Ejemplo n.º 1
0
        protected void btnRptPointChangeExcel_Click(object sender, EventArgs e)
        {
            StringBuilder strWhere = new StringBuilder();

            if (this.txtStartTime.Value != "")
            {
                strWhere.AppendFormat(" and ShopCreateTime>='{0}' ", this.txtStartTime.Value);
            }
            if (this.txtEndTime.Value != "")
            {
                strWhere.AppendFormat(" and ShopCreateTime<='{0}'", PubFunction.TimeEndDay(this.txtEndTime.Value));
            }
            SysShop   bllPointLog = new SysShop();
            int       Counts      = this.NetPagerParameter.RecordCount;
            string    strSql      = this.QueryCondition();
            DataTable dt          = bllPointLog.GetListShop(100000, 1, out Counts, strWhere.ToString(), new string[]
            {
                strSql
            }).Tables[0];

            DataExcelInfo.ShopListShopReportExcel(dt, this._UserName);
        }