protected void btnRptExpenseExcel_Click(object sender, EventArgs e) { Chain.BLL.GoodsLog bllGoodsLog = new Chain.BLL.GoodsLog(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); string strAgent = ""; strSql += " and GoodsLog.ShopID>0"; strSql += " and GoodsLog.ShopID = SysShop.ShopID and GoodsLog.UserID = SysUser.UserID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "GoodsLog.ShopID", strSql); DataTable db = bllGoodsLog.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.GoodsLogExcel(db, this._UserName, strAgent); }