?? summary.aspx.cs
字號:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using DBUtils;
namespace BlueHill.CheckLeave
{
/// <summary>
/// Summary 的摘要說明。
/// </summary>
public class Summary : System.Web.UI.Page
{
public Employee emp;
protected System.Web.UI.WebControls.Panel pnlPageFix;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox txtStartTime;
protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.TextBox txtEndTime;
protected System.Web.UI.WebControls.CompareValidator CompareValidator2;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.WebControls.Label lblDept;
protected System.Web.UI.WebControls.DropDownList cmbDeptList;
protected System.Web.UI.WebControls.Panel pnlChooseDept;
protected System.Web.UI.WebControls.Button btnSearch;
protected System.Web.UI.WebControls.Panel pnlHeader;
protected System.Web.UI.WebControls.Label lblMessage;
protected System.Web.UI.WebControls.DataGrid grdResult;
protected System.Web.UI.WebControls.DataGrid grdResult1;
protected System.Web.UI.WebControls.Label lblDenyReason;
protected System.Web.UI.WebControls.Label lblDeny;
protected System.Web.UI.WebControls.Label lblReason;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label lblApproverName;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Panel pnlDetail;
protected System.Web.UI.WebControls.Label lblDeptID;
protected System.Web.UI.WebControls.Panel pnlBody;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此處放置用戶代碼以初始化頁面
if(!Page.IsPostBack)
{
//獲取雇員ID;
int iEmpID;
iEmpID = Convert.ToInt32(Session["EmployeeID"].ToString());
int iRetValue;
emp = new Employee();
//執(zhí)行數(shù)據(jù)庫操作
iRetValue=Employee.GetEmployeeInfo(iEmpID,emp);
// if(iRetValue== 0)
// {
// this.RegisterStartupScript("out","<script>alert('操作失敗');</script>");
// Response.Redirect("CheckLvReq.aspx");
// }
// else
// {
// // `Session
// }
if(iRetValue == 1)
{
bool IsManager = emp.IsManager;
if(IsManager)
{
btnSearch.Visible = true;
int iCEOID = 0;
int iRetValue1 = Employee.GetCEOInfo(ref iCEOID);
if(iRetValue1== 0)
{
this.RegisterStartupScript("out","<script>alert('操作失敗');</script>");
}
else
{
if(iCEOID==emp.EmployeeID)
{
DataSet dsResult = new DataSet();
int iRetValue2 = DBUtils.CheckLvReq.GetDeptList(ref dsResult);
if(iRetValue2== 0)
{
this.RegisterStartupScript("out","<script>alert('操作失敗');</script>");
Response.Redirect("CheckLvReq.aspx");
}
else
{
lblDept.Visible = true;
DataTable Dept = dsResult.Tables[0];
this.cmbDeptList.DataSource =Dept;
this.cmbDeptList.DataTextField = "DeptName";
this.cmbDeptList.DataValueField = "DeptID";
this.cmbDeptList.DataBind();
cmbDeptList.Visible = true;
}
}
else
{
int DeptID = Convert.ToInt32(emp.DeptID);
lblDeptID.Text = DeptID.ToString();
lblDept.Visible = false;
cmbDeptList.Visible = false;
}
}
}
else
{
grdResult.Visible = false;
lblMessage.Text = "該功能是經(jīng)理專用";
lblMessage.Visible = true;
btnSearch.Visible = false;
lblDept.Visible = false;
cmbDeptList.Visible = false;
}
}
}
}
#region Web 窗體設(shè)計(jì)器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調(diào)用是 ASP.NET Web 窗體設(shè)計(jì)器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
this.cmbDeptList.SelectedIndexChanged += new System.EventHandler(this.cmbDeptList_SelectedIndexChanged);
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
this.grdResult.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.grdResult_ItemCommand);
this.grdResult1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.grdResult1_ItemCommand);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void btnSearch_Click(object sender, System.EventArgs e)
{
// if(!Page.IsPostBack)
// {
string strStartTime = txtStartTime.Text.ToString().Trim();
string strEndTime = txtEndTime.Text.ToString().Trim();
int DeptID = Convert.ToInt32(lblDeptID.Text);
DataSet dsResult = new DataSet();
int iRerValue = DBUtils.CheckLvReq.DeptSummary(DeptID,strStartTime,strEndTime,ref dsResult);
if(iRerValue == 1)
{
Session["dsResult"] = dsResult;
grdResult.DataSource = dsResult.Tables[0];
grdResult.DataBind();
grdResult.Visible = true;
grdResult1.Visible = false;
}
else
{
lblMessage.Text = "頁面請求失敗,請稍后再試";
lblMessage.Visible = true;
}
// }
}
private void grdResult_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string strStartTime = txtStartTime.Text.ToString().Trim();
string strEndTime = txtEndTime.Text.ToString().Trim();
int n = Convert.ToInt32(e.Item.ItemIndex);
DataSet dsResult = (DataSet)Session["dsResult"];
int iEmpID = Convert.ToInt32(dsResult.Tables[0].Rows[n]["EmployeeID"].ToString());
DataSet dsResult1 = new DataSet();
if(e.CommandName == "Detail")
{
int iRetValue = DBUtils.CheckLvReq.QueryIndividHistory(iEmpID,strStartTime,strEndTime,dsResult1);
if( iRetValue == (int) DBResult.Success )
{
Session["dsResult1"] = dsResult1;
grdResult1.DataSource = dsResult1.Tables[0];
grdResult1.DataBind();
grdResult1.Visible = true;
grdResult.Visible = false;
}
}
}
private void grdResult1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName == "Detail")
{
int n = Convert.ToInt32(e.Item.ItemIndex);
DataSet dsResult1 = (DataSet)Session["dsResult1"];
Label3.Visible = true;
Label5.Visible = true;
lblDeny.Visible = true;
lblApproverName.Visible = true;
lblReason.Visible = true;
lblDenyReason.Visible = true;
lblMessage.Visible = false;
lblApproverName.Text = Convert.ToString(dsResult1.Tables[0].Rows[n]["ApproverName"].ToString());
lblReason.Text = Convert.ToString(dsResult1.Tables[0].Rows[n]["Reason"].ToString());
lblDenyReason.Text = Convert.ToString(dsResult1.Tables[0].Rows[n]["DenyReason"].ToString());
}
}
private void cmbDeptList_SelectedIndexChanged(object sender, System.EventArgs e)
{
lblDeptID.Text = cmbDeptList.SelectedValue;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -