Esempio n. 1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!base.IsPostBack)
     {
         this.hdUserID.Value        = this._UserID.ToString();
         this.hdShopID.Value        = this._UserShopID.ToString();
         this.lblUserName.InnerText = this._UserName;
         SysUserWork bllsysuserwork = new SysUserWork();
         DataTable   dtuserwork     = bllsysuserwork.GetList(1, string.Format("UserID = {0}", this._UserID), "EedTime DESC").Tables[0];
         DataTable   dtyfmoney      = bllsysuserwork.GetList(string.Format("ispay = 0 and HandoverUserID = {0}", this._UserID)).Tables[0];
         if (dtuserwork.Rows.Count > 0)
         {
             this.hdStartTime.Value = dtuserwork.Rows[0]["EedTime"].ToString();
         }
         else
         {
             this.hdStartTime.Value = "1949-10-01";
         }
         double summoney = 0.0;
         foreach (DataRow dr in dtyfmoney.Rows)
         {
             summoney += Convert.ToDouble(dr["Arrearage"]);
         }
         this.hdEndTime.Value  = DateTime.Now.ToString();
         this.hdallmoney.Value = summoney.ToString();
     }
 }
Esempio n. 2
0
        protected void btnPointRankExcel_Click(object sender, EventArgs e)
        {
            SysUserWork bllsysuserwork = new SysUserWork();
            int         Counts         = this.NetPagerParameter.RecordCount;
            string      strSql         = this.QueryCondition();

            strSql += "and SysUserWork.userID = SysUser.userid and SysUser.UserShopID = SysShop.ShopID ";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "UserShopID", strSql);
            DataTable dtPoint = bllsysuserwork.GetListSP(100000, 1, out Counts, new string[]
            {
                strSql
            }).Tables[0];

            DataExcelInfo.PointUserWorkExcel(dtPoint, this._UserName);
        }
Esempio n. 3
0
        private void Get_ParameterList(string strSql)
        {
            SysUserWork bllsysuserwork = new SysUserWork();
            int         Counts         = this.NetPagerParameter.RecordCount;

            strSql += "and SysUserWork.userID = SysUser.userid and SysUser.UserShopID = SysShop.ShopID ";
            strSql  = PubFunction.GetShopAuthority(this._UserShopID, "UserShopID", strSql);
            DataTable db = bllsysuserwork.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.gvPointRankList.DataSource = db;
            this.gvPointRankList.DataBind();
            PageBase.BindSerialRepeater(this.gvPointRankList, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1));
        }