/// <summary> /// 获取订单总金额 /// </summary> /// <param name="total_amount"></param> protected void getTotalAmount() { refund_amount = 0M; if (this.keyDate == "") { BLL.user_point_log bll = new BLL.user_point_log(); DataTable dt = bll.GetList(0, " pointtype=3", " add_time desc,id desc").Tables[0]; foreach (DataRow row in dt.Rows) { if (int.Parse(row["order_status"].ToString()) == 2) //统计退款 { refund_amount += decimal.Parse(row["amount"].ToString()); } } } else { BLL.user_point_log bll = new BLL.user_point_log(); DataTable dt = bll.GetList(0, " pointtype=3 and datediff(dd,add_time,'" + this.keyDate + "')=0", " add_time desc,id desc").Tables[0]; foreach (DataRow row in dt.Rows) { if (int.Parse(row["order_status"].ToString()) == 2) { refund_amount += decimal.Parse(row["amount"].ToString()); } } } }
private void RptBind(string _strWhere, string _orderby) { this.page = MXRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.user_point_log bll = new BLL.user_point_log(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("point_log.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.user_point_log bll = new BLL.user_point_log(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("point_log.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = Vincent._DTcms.DTRequest.GetQueryInt("page", 1); ipt_Time.Value = this.keyDate; BLL.user_point_log bll = new BLL.user_point_log(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Vincent._DTcms.Utils.CombUrlTxt("refund.aspx", "keywords={0}&keyDate={1}&page={2}", this.keywords, this.keyDate, "__id__"); PageContent.InnerHtml = Vincent._DTcms.Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 15); }