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();
}
}
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);
}
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));
}