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; }