Esempio n. 1
0
        private void Get_ParameterList(string strSql)
        {
            Chain.BLL.GoodsLog bllGoodsLog = new Chain.BLL.GoodsLog();
            int Counts = this.NetPagerParameter.RecordCount;

            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(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
            {
                strSql
            }).Tables[0];

            this.NetPagerParameter.RecordCount    = Counts;
            this.NetPagerParameter.CustomInfoHTML = string.Format("<div class=\"results\"><span>当前第{0}/{1}页 共{2}条记录 每页{3}条</span></div>", new object[]
            {
                this.NetPagerParameter.CurrentPageIndex,
                this.NetPagerParameter.PageCount,
                this.NetPagerParameter.RecordCount,
                this.NetPagerParameter.PageSize
            });
            this.rptGoodsLog.DataSource = db;
            this.rptGoodsLog.DataBind();
            PageBase.BindSerialRepeater(this.rptGoodsLog, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
        }
Esempio n. 2
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);
        }