protected void btnExport_Click(object sender, EventArgs e)
{
TB_EmployeeCheckOut mTB_EmployeeCheckOut = new TB_EmployeeCheckOut();
mTB_EmployeeCheckOut.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_EmployeeCheckOut.EmployeeNo = this.txtWorkDayNo.Text.Trim();
mTB_EmployeeCheckOut.Name = this.txtName.Text.Trim();
mTB_EmployeeCheckOut.CardNo = this.txtScanCardNO.Text.Trim();
mTB_EmployeeCheckOut.BUID = Convert.ToInt32(Request.Form[this.ddlBuildingName.UniqueID.ToString()]);
mTB_EmployeeCheckOut.RoomID = Convert.ToInt32(this.ddlRoomType.SelectedValue);
mTB_EmployeeCheckOut.BU = GetSelectedBu(); // this.txtBu.Text.Trim();
DateTime dtVal = DateTime.Now;
if (DateTime.TryParse(this.txtStartDay.Text.Trim(), out dtVal))
{
mTB_EmployeeCheckOut.CheckOutDateBegin = dtVal;
}
if (DateTime.TryParse(this.txtEndDay.Text.Trim(), out dtVal))
{
mTB_EmployeeCheckOut.CheckOutDateEnd = dtVal;
}
int iDormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue);
string strFileName = new EmployeeCheckOutBLL().Export(mTB_EmployeeCheckOut, iDormAreaID);
this.DownLoadFile(this.Request, this.Response, "退房记录.xls", File.ReadAllBytes(strFileName), 10240000);
//File.Delete(strFileName);
}
private string GetCheckOutDate(string EmployeeID)
{
TB_EmployeeCheckOut mTB_EmployeeCheckOut = new TB_EmployeeCheckOut();
EmployeeCheckOutBLL mEmployeeCheckOutBLL = new EmployeeCheckOutBLL();
Pager pager = new Pager();
DataTable dtSource = null;
pager.CurrentPageIndex = 1;
pager.srcOrder = " ID desc";
mTB_EmployeeCheckOut.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_EmployeeCheckOut.EmployeeNo = EmployeeID;
mTB_EmployeeCheckOut.Name = "";
mTB_EmployeeCheckOut.CardNo = "";
dtSource = mEmployeeCheckOutBLL.GetPagerData(mTB_EmployeeCheckOut, ref pager);
return(dtSource.Rows.Count > 0 ? dtSource.Rows[0]["CheckOutDate"].ToString() : "未住宿舍");
}
private void Bind(int intCurrentIndex)
{
TB_EmployeeCheckOut mTB_EmployeeCheckOut = new TB_EmployeeCheckOut();
EmployeeCheckOutBLL mEmployeeCheckOutBLL = new EmployeeCheckOutBLL();
Pager pager = new Pager();
DataTable dtSource = null;
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
mTB_EmployeeCheckOut.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_EmployeeCheckOut.EmployeeNo = this.txtWorkDayNo.Text.Trim();
mTB_EmployeeCheckOut.Name = this.txtName.Text.Trim();
mTB_EmployeeCheckOut.CardNo = this.txtScanCardNO.Text.Trim();
mTB_EmployeeCheckOut.BUID = Convert.ToInt32(Request.Form[this.ddlBuildingName.UniqueID.ToString()]);
mTB_EmployeeCheckOut.BU = GetSelectedBu(); //this.txtBu.Text.Trim();
DateTime dtVal = DateTime.Now;
if (DateTime.TryParse(this.txtStartDay.Text.Trim(), out dtVal))
{
mTB_EmployeeCheckOut.CheckOutDateBegin = dtVal;
}
if (DateTime.TryParse(this.txtEndDay.Text.Trim(), out dtVal))
{
mTB_EmployeeCheckOut.CheckOutDateEnd = dtVal;
}
int iDormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue);
int iRoomTypeID = Convert.ToInt32(this.ddlRoomType.SelectedValue);
string sRoomName = this.txtRoom.Text.Trim();
dtSource = mEmployeeCheckOutBLL.GetPagerData(mTB_EmployeeCheckOut, iDormAreaID, iRoomTypeID, sRoomName, ref pager);
GridView1.DataSource = dtSource;
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}