Ejemplo n.º 1
0
        protected void btnMemCountExcel_Click(object sender, EventArgs e)
        {
            int    Counts = this.NetPagerParameter.RecordCount;
            string strSql = this.QueryCondition();

            strSql += " AND MemStorageTiming.StorageTimingMemID = Mem.MemID \r\n                         AND MemStorageTiming.StorageTimingShopID = SysShop.ShopID \r\n                         AND MemStorageTiming.StorageTimingUserID = SysUser.UserID \r\n                         AND MemStorageTiming.StorageTimingProjectID = TimingProject.ProjectID \r\n                         AND Mem.MemLevelID = MemLevel.LevelID ";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "StorageTimingShopID", strSql);
            DataTable dtMemCount = this.bllMemStorageTiming.GetListSP(10000000, 1, out Counts, new string[]
            {
                strSql
            }).Tables[0];

            DataExcelInfo.MemStorageTimingExcel(dtMemCount, this._UserName);
        }