예제 #1
0
        /// <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();
        }
예제 #2
0
        /// <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 { }
        }