/// <summary>
/// 加载订单数据
/// </summary>
private void LoadOrderList()
{
if (Session["login"] == null)
{
Response.Redirect("~/Login.aspx", true);
}
else
{
LoginInfo login = Session["login"] as LoginInfo;
if (Session["cutPay"].ToString() != "")
{
string sql = " collectStatus='完成收款' ";
sql += Session["cutPay"].ToString();
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 033);
if (sps != null)
{
this.j_pagesize.Value = sps.Pageitem.ToString();
this.j_pagecount.Value = sps.Pagecount.ToString();
}
this.payRepeater.DataSource = To_OrderInfoManager.GetViewOrderAndCollect("*", sql);
this.payRepeater.DataBind();
}
}
}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadOrderCollect()
{
if (Session["MyOrderQuery"].ToString() != "")
{
string sqlstr = " and iscancel='N'";//0510 修改作废的订单不显示
sqlstr += Session["MyOrderQuery"].ToString();
if (Session["login"] == null)
{
Response.Redirect("~/Login.aspx", true);
}
else
{
LoginInfo login = (LoginInfo)Session["login"];
//string ids = LoginDataLimitManager.GetLimit(login.Id);
//if (string.IsNullOrEmpty(ids))
// sqlstr += " and salemanid = " + login.Id;
//else
// sqlstr += " and salemanid in (" + ids + ")";
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 034);
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("View_OrderAndClollect", sqlstr);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("View_OrderAndClollect", "outTime", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
orderRepeater.DataSource = dt;
orderRepeater.DataBind();
//计算合计
DataTable dtsum = To_OrderInfoManager.GetViewOrderAndCollect(" sum(adultNum) as adult_sum,sum(childNum) as child_sum,sum(withNum) as with_sum,sum(pNum) as pnum_sum,sum(lirun) as lirun_sum,sum(money) as money_sum ", " 1=1 " + sqlstr);
if (dtsum.Rows.Count > 0)
{
this.adult_sum.InnerHtml = dtsum.Rows[0]["adult_sum"].ToString();
this.child_sum.InnerHtml = dtsum.Rows[0]["child_sum"].ToString();
this.with_sum.InnerHtml = dtsum.Rows[0]["with_sum"].ToString();
this.pnum_sum.InnerHtml = dtsum.Rows[0]["pnum_sum"].ToString();
this.lirun_sum.InnerHtml = dtsum.Rows[0]["lirun_sum"].ToString();
this.money_sum.InnerHtml = dtsum.Rows[0]["money_sum"].ToString();
}
}
}
else
{
orderRepeater.DataSource = null;
orderRepeater.DataBind();
this.adult_sum.InnerHtml = this.child_sum.InnerHtml = this.with_sum.InnerHtml = this.pnum_sum.InnerHtml = this.lirun_sum.InnerHtml = this.money_sum.InnerHtml = "";
}
}
/// <summary>
/// 加载所要选择的认领订单
/// </summary>
private void LoadOrderList()
{
string payerId = Request.QueryString["payer"];
string sql = " iscancel='N'";
sql += this.cbxshowfile.Checked ? "" : " and fileStatus=0 ";
if (payerId != "")
{
sql += " and cusId = " + payerId;
}
sql += " order by outTime desc ";
DataTable dt = new DataTable();
dt = To_OrderInfoManager.GetViewOrderAndCollect("*", sql);
RpPolicyList.DataSource = dt;
RpPolicyList.DataBind();
}
/// <summary>
/// 加载订单收款信息
/// </summary>
private void LoadOrderInfo()
{
//CutPayList cList = (CutPayList)Context.Handler;
string id = Request.QueryString["id"];
id = "(" + id + ")";
string sort = Request.QueryString["sort"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
switch (sort)
{
case "0":
this.czy.Visible = false;
string sql = " and collectId in " + id;
DataSet ds = data.DataPage("View_OrderAndClollect", "collectId", "*", sql, "orderNum", false, 5, 5, pages);
payRepeater.DataSource = ds;
payRepeater.DataBind();
sql = " 1=1 " + sql;
DataTable dt0 = To_OrderInfoManager.GetViewOrderAndCollect("sum(adultNum)+sum(childNum) as num,sum(lirun) as lirun", sql);
if (dt0.Rows.Count > 0)
{
this.sumNum.InnerText = dt0.Rows[0]["num"].ToString();
this.sumlirun.InnerText = dt0.Rows[0]["lirun"].ToString();
}
break;
case "1":
this.ywy.Visible = false;
string str = " and id in " + id;
DataSet dt = data.DataPage("To_orderInfo", "id", "*", str, "orderNum", false, 5, 5, pages);
czyRepeater.DataSource = dt;
czyRepeater.DataBind();
str = " 1=1 " + str;
DataTable dt1 = To_OrderInfoManager.getList("sum(inputerTc) as inputerTc", str);
if (dt1.Rows.Count > 0)
{
this.suminputerTc.InnerText = dt1.Rows[0]["inputerTc"].ToString();
}
break;
}
}
