private void Bind(int intCurrentIndex) { TB_ChangeRoomRecord mTB_ChangeRoomRecord = new TB_ChangeRoomRecord(); ChangeRoomRecordBLL mChangeRoomRecordBLL = new ChangeRoomRecordBLL(); Pager pager = new Pager(); DataTable dtSource = null; pager.CurrentPageIndex = intCurrentIndex; pager.srcOrder = " ID desc"; mTB_ChangeRoomRecord.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); mTB_ChangeRoomRecord.CardNo = this.txtScanCardNO.Text.Trim(); mTB_ChangeRoomRecord.EmployeeNo = this.txtWorkDayNo.Text.Trim(); mTB_ChangeRoomRecord.BU = GetSelectedBu(); DateTime dtVal = DateTime.Now; if (DateTime.TryParse(this.txtStartDay.Text.Trim(), out dtVal)) { mTB_ChangeRoomRecord.ChangeRoomDateBegin = dtVal; } if (DateTime.TryParse(this.txtEndDay.Text.Trim(), out dtVal)) { mTB_ChangeRoomRecord.ChangeRoomDateEnd = dtVal; } dtSource = mChangeRoomRecordBLL.GetPagerData(mTB_ChangeRoomRecord, 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; }
protected void btnExport_Click(object sender, EventArgs e) { TB_ChangeRoomRecord mTB_ChangeRoomRecord = new TB_ChangeRoomRecord(); ChangeRoomRecordBLL mChangeRoomRecordBLL = new ChangeRoomRecordBLL(); mTB_ChangeRoomRecord.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); mTB_ChangeRoomRecord.CardNo = this.txtScanCardNO.Text.Trim(); mTB_ChangeRoomRecord.EmployeeNo = this.txtWorkDayNo.Text.Trim(); mTB_ChangeRoomRecord.BU = GetSelectedBu(); DateTime dtVal = DateTime.Now; if (DateTime.TryParse(this.txtStartDay.Text.Trim(), out dtVal)) { mTB_ChangeRoomRecord.ChangeRoomDateBegin = dtVal; } if (DateTime.TryParse(this.txtEndDay.Text.Trim(), out dtVal)) { mTB_ChangeRoomRecord.ChangeRoomDateEnd = dtVal; } string strFileName = mChangeRoomRecordBLL.Export(mTB_ChangeRoomRecord); this.DownLoadFile(this.Request, this.Response, "换房记录.xls", File.ReadAllBytes(strFileName), 10240000); //File.Delete(strFileName); }