예제 #1
0
        private void BindDrawMoney()
        {
            MemDrawMoney bllDrawMoney = new MemDrawMoney();
            string       strSql       = this.QueryCondition();

            strSql += " and MemDrawMoney.DrawMoneyMemID=Mem.MemID ";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql);
            DataTable dtDrawMoney = bllDrawMoney.GetDrawMoneyCount(strSql).Tables[0];

            this.lblDrawTotalMoney.Text  = decimal.Parse(dtDrawMoney.Rows[0]["DrawMoney"].ToString()).ToString("0.00");
            this.lblDrawActualMoney.Text = decimal.Parse(dtDrawMoney.Rows[0]["DrawActualMoney"].ToString()).ToString("0.00");
        }
예제 #2
0
        protected void btnMemDrawMoneyExcel_Click(object sender, EventArgs e)
        {
            MemDrawMoney bllDrawMoney = new MemDrawMoney();
            int          Counts       = this.NetPagerParameter.RecordCount;
            string       strSql       = this.QueryCondition();

            strSql += "and MemDrawMoney.DrawMoneyShopID = SysShop.ShopID and MemDrawMoney.DrawMoneyMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and MemDrawMoney.DrawMoneyUserID = SysUser.UserID";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql);
            DataTable db = bllDrawMoney.GetListSP(1000000, 1, out Counts, new string[]
            {
                strSql
            }).Tables[0];

            DataExcelInfo.MemDrawMoney(db, this._UserName);
        }
예제 #3
0
        private void Get_ParameterList(string strSql)
        {
            MemDrawMoney bllDrawMoney = new MemDrawMoney();
            int          Counts       = this.NetPagerParameter.RecordCount;

            strSql += "and MemDrawMoney.DrawMoneyShopID = SysShop.ShopID and MemDrawMoney.DrawMoneyMemID = Mem.MemID and Mem.MemLevelID=MemLevel.LevelID and MemDrawMoney.DrawMoneyUserID = SysUser.UserID";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "DrawMoneyShopID", strSql);
            DataTable db = bllDrawMoney.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.gvRptMemDrawMoney.DataSource = db;
            this.gvRptMemDrawMoney.DataBind();
            PageBase.BindSerialRepeater(this.gvRptMemDrawMoney, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
        }