Ejemplo n.º 1
0
        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;
        }
Ejemplo n.º 2
0
        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);
        }