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