/// <summary> /// /// </summary> private void LoadData() { List <SearchParam> listParam = new List <SearchParam>(); listParam.Add(new SearchParam("userid", this.UserId)); DateTime tempdt = DateTime.MinValue; if (!string.IsNullOrEmpty(sdate.Value.Trim())) { if (DateTime.TryParse(sdate.Value.Trim(), out tempdt)) { if (tempdt > DateTime.MinValue) { listParam.Add(new SearchParam("starttime", tempdt)); } } } if (!string.IsNullOrEmpty(edate.Value.Trim())) { if (DateTime.TryParse(edate.Value.Trim(), out tempdt)) { if (tempdt > DateTime.MinValue) { listParam.Add(new SearchParam("endtime", tempdt.AddDays(1))); } } } //if (!string.IsNullOrEmpty(this.ddlstatus.SelectedValue)) //{ // listParam.Add(new SearchParam("status", int.Parse(this.ddlstatus.SelectedValue))); //} DataSet pageData = rechargeBLL.PageSearch(listParam, this.Pager1.PageSize, this.Pager1.CurrentPageIndex, string.Empty, true); this.Pager1.RecordCount = Convert.ToInt32(pageData.Tables[0].Rows[0][0]); this.rptrecharges.DataSource = pageData.Tables[1]; this.rptrecharges.DataBind(); }
/// <summary> /// /// </summary> private void LoadData() { string orderby = "id desc"; if (ViewState["__Sort"] != null) { orderby = ViewState["__Sort"].ToString(); } List <SearchParam> listParam = new List <SearchParam>(); string userId = txtuserId.Text.Trim(); int tempId = 0; if (int.TryParse(userId, out tempId)) { listParam.Add(new SearchParam("userid", tempId)); } DateTime tempdt = DateTime.MinValue; if (!string.IsNullOrEmpty(StimeBox.Text.Trim())) { if (DateTime.TryParse(StimeBox.Text.Trim(), out tempdt)) { if (tempdt > DateTime.MinValue) { listParam.Add(new SearchParam("starttime", StimeBox.Text.Trim())); } } } if (!string.IsNullOrEmpty(EtimeBox.Text.Trim())) { if (DateTime.TryParse(EtimeBox.Text.Trim(), out tempdt)) { if (tempdt > DateTime.MinValue) { listParam.Add(new SearchParam("endtime", tempdt.AddDays(1))); } } } if (!string.IsNullOrEmpty(this.ddlstatus.SelectedValue)) { listParam.Add(new SearchParam("status", int.Parse(this.ddlstatus.SelectedValue))); } DataSet pageData = rechargeBLL.PageSearch(listParam, this.Pager1.PageSize, this.Pager1.CurrentPageIndex, orderby, true); this.Pager1.RecordCount = Convert.ToInt32(pageData.Tables[0].Rows[0][0]); this.recharges.DataSource = pageData.Tables[1]; this.recharges.DataBind(); try { DataRow row = pageData.Tables[2].Rows[0]; wzfmoney = string.Format("{0:f2}", row["realPayAmt"]); } catch { } }