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