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