private DataTable SelPage(int pageSize, int pageIndex)
{
ZoomLa.BLL.B_CartPro.Filter_Order filter = new ZoomLa.BLL.B_CartPro.Filter_Order();
filter.cpage = pageIndex;
filter.psize = pageSize;
filter.storeType = StoreType_DP.SelectedValue;
filter.orderType = OrderType;
filter.addon = Filter;
filter.proname = ProName_T.Text;
filter.orderno = OrderNo_T.Text;
filter.reuser = ReUser_T.Text;
filter.mobile = Mobile_T.Text;
filter.uids = UserID_T.Text;
filter.stype = SkeyType_DP.SelectedValue;
filter.skey = Skey_T.Text;
filter.stime = STime_T.Text;
filter.etime = ETime_T.Text;
filter.expstime = ExpSTime_T.Text;
filter.expetime = ExpETime_T.Text;
//StoreType_DP.SelectedValue, OrderType, Filter, ProName_T.Text, OrderNo_T.Text, ReUser_T.Text, Mobile_T.Text, UserID_T.Text, SkeyType_DP.SelectedValue, Skey_T.Text, STime_T.Text, ETime_T.Text, ExpSTime_T.Text, ExpETime_T.Text
PageSetting setting = cpBll.SelForOrderList(filter);
OrderDT = setting.dt;
StoreDT = orderCom.SelStoreDT(OrderDT);
DataTable dt = new DataTableHelper().DistinctByField(OrderDT, "ID");
Skey_T.Text = Skey;
empty_div.Visible = dt.Rows.Count < 1;
TotalSum_Hid.Value = DataConvert.CDouble(OrderDT.Compute("SUM(ordersamount)", "")).ToString("f2");
//function.Script(this, "CheckOrderType('" + Filter + "')");
Order_RPT.ItemCount = setting.itemCount;
return(dt);
}
private DataTable SelPage(int pageSize, int pageIndex)
{
M_UserInfo mu = buser.GetLogin();
Filter_Order filter = new Filter_Order();
filter.cpage = pageIndex;
filter.psize = pageSize;
filter.orderType = OrderType;
//filter.uids = ClientUid.ToString();
filter.storeType = mu.SiteID.ToString();
PageSetting setting = ExOrder.Order_Sel(filter);
OrderDT = setting.dt;
StoreDT = orderCom.SelStoreDT(OrderDT);
//Skey_T.Text = Skey;
DataTable dt = new DataTableHelper().DistinctByField(OrderDT, "ID");
if (dt != null && dt.Rows.Count > 0)
{
TotalSum_Hid.Value = DataConvert.CDouble(OrderDT.Compute("SUM(ordersamount)", "")).ToString("f2");
//function.Script(this, "CheckOrderType('" + Filter + "')");
Order_RPT.ItemCount = setting.itemCount;
empty_div.Visible = false;
}
else
{
empty_div.Visible = true; TotalSum_Hid.Value = "0";
}
return(dt);
}
protected void Pro_RPT_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//如果变复杂,将其分离为局部页
if (e.Item.ItemIndex == 0)//首行判断
{
DataRowView dr = e.Item.DataItem as DataRowView;
int count = OrderDT.Select("id=" + dr["ID"]).Length;
//收货人
string html = "<span><i class='fa fa-user'></i> " + dr["AddUser"] + "</span>";
//金额栏
html += "<span style='color:#c00;'> <i class='fa fa-rmb'></i> " + GetTureMoney(dr["OrderNo"].ToString()) + "</span><br/>";
string _paytypeHtml = OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.PayType);
if (!string.IsNullOrEmpty(_paytypeHtml))
{
_paytypeHtml = _paytypeHtml + "";
}
html += _paytypeHtml;
html += "(" + OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.Pay) + ")";
//订单状态
html += "<span class='gray9'>" + OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.Order) + "</span>";
html += OrderHelper.GetExpStatus(Convert.ToInt32(dr["StateLogistics"])) + " <br/>";
html += "<span><a href='/User/Order/OrderProList1.aspx?OrderNo=" + dr["OrderNo"] + "'><i class='fa fa-file-text'></i> 订单详情</a></span>";
//操作栏
html += "<span>" + Getoperator(dr) + "</span>";
(e.Item.FindControl("Order_Lit") as Literal).Text = html;
}
}
}
protected void Pro_RPT_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//如果变复杂,将其分离为局部页
if (e.Item.ItemIndex == 0)//首行判断
{
DataRowView dr = e.Item.DataItem as DataRowView;
M_Payment payMod = OrderHelper.GetPaymentByOrderNo(dr.Row);
int count = OrderDT.Select("id=" + dr["ID"]).Length;
string html = "";
//收货人
html += "<td class='td_l rowtd' rowspan='" + count + "'>";
html += "<i class='fa fa-user'></i> <a href='OrderList.aspx?UserID=" + dr["UserID"] + "' title='按用户筛选'>" + B_User.GetUserName(dr["HoneyName"], dr["AddUser"]) + "</a>";
html += "(<a href='javascript:;' onclick='user.showuinfo(" + dr["UserID"] + ");' title='查看用户信息'><span style='color:green;'>" + dr["UserID"] + "</span></a>)";
html += "</td>";
//金额栏
html += "<td class='td_l rowtd' rowspan='" + count + "' style='font-size:12px;'>总计:<i class='fa fa-rmb'></i> " + Convert.ToDouble(dr["OrdersAmount"]).ToString("f2") + "<br />";
string _paytypeHtml = OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.PayType);
if (!string.IsNullOrEmpty(_paytypeHtml))
{
_paytypeHtml = _paytypeHtml + "<br />";
}
html += _paytypeHtml;
html += "<div>商品:" + (DataConvert.CDouble(dr["OrdersAmount"]) - DataConvert.CDouble(dr["Freight"])).ToString("F2") + "</div>";
html += "<div>运费:" + DataConvert.CDouble(dr["Freight"]).ToString("F2") + "</div>";
html += "<div title='优惠卷'>优惠:" + payMod.ArriveMoney.ToString("F2") + "</div>";
html += "<div>积分:" + payMod.UsePointArrive.ToString("f2") + "(" + payMod.UsePoint.ToString("F0") + ")</div>";
html += "<div style='color:#d9534f;'>需付:" + payMod.MoneyReal.ToString("F2") + "</div>";
if (!string.IsNullOrEmpty(DataConvert.CStr(dr["PaymentNo"])))
{
string plat = platBll.GetPayPlatName(DataConvert.CStr(dr["PaymentNo"]));
html += "<a href='" + StrHelper.Url_AddParam(Request.RawUrl, "filter=paid") + "' title='筛选已付款订单'>" + "<span style='color:#337ab7;'>" + plat + "</span>"
+ "(" + OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.Pay) + ")</a>";
}
else
{
html += "(" + OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.Pay) + ")";
}
html += "</td>";
//订单状态
html += "<td class='td_md rowtd' rowspan='" + count + "'><span class='gray9'>" + OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.Order) + "</span> <br />";
int ordertype = DataConvert.CLng(dr["OrderType"]);
//非旅游与酒店订单,则显示快递信息
int expid = DataConvert.CLng(dr["ExpressNum"]);
if (ordertype != 7 && ordertype != 9)
{
html += "<a href='javascript:;' class='expview_a' data-expid='" + expid + "' id='expview_" + dr["ID"] + "_a' onclick=\"exp.apilink(this,'" + expid + "');\">" + OrderHelper.GetExpStatus(Convert.ToInt32(dr["StateLogistics"])) + "</span> <br/>";
}
html += "</td>";
//操作栏
html += "<td class='td_md rowtd' rowspan='" + count + "'><a href='OrderListInfo.aspx?ID=" + dr["ID"] + "' class='order_bspan'>订单详情</a><br/>" + Getoperator(dr) + "</td>";
(e.Item.FindControl("Order_Lit") as Literal).Text = html;
}
}
}
private void MyBind()
{
string fields = "ID,OrderNo,AddUser,AddTime,StoreID,PaymentStatus,OrderType,OrderStatus,OrderMessage,ExpressNum,ParentUserID,UserID,HoneyName,ExpSTime";
DataTable dt = OrderDT.DefaultView.ToTable(true, fields.Split(','));
Order_RPT.DataSource = dt;
Order_RPT.DataBind();
Skey_T.Text = Skey;
empty_div.Visible = dt.Rows.Count < 1;
TotalSum_Hid.Value = DataConvert.CDouble(OrderDT.Compute("SUM(ordersamount)", "")).ToString("f2");
//function.Script(this, "CheckOrderType('" + Filter + "')");
}
protected void Pro_RPT_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//如果变复杂,将其分离为局部页
if (e.Item.ItemIndex == 0)//首行判断
{
DataRowView dr = e.Item.DataItem as DataRowView;
M_Payment payMod = OrderHelper.GetPaymentByOrderNo(dr.Row);
int count = OrderDT.Select("id=" + dr["ID"]).Length;
string html = "";
//收货人
html += "<td class='td_l rowtd' rowspan='" + count + "'>";
html += "<div>会员:<a href='javascript:;'>" + dr["rename"] + "</a></div>";
html += "<div>收银:<a href='javascript:;'>" + dr["AddUser"] + "</a></div>";
//html += "<i class='fa fa-user'></i> <a href='OrderList.aspx?UserID=" + dr["UserID"] + "' title='按用户筛选'>" + B_User.GetUserName(dr["HoneyName"], dr["AddUser"]) + "</a>";
//html += "(<a href='javascript:;' onclick='user.showuinfo(" + dr["UserID"] + ");' title='查看用户信息'><span style='color:green;'>" + dr["UserID"] + "</span></a>)";
html += "</td>";
//金额栏
html += "<td class='td_l rowtd' rowspan='" + count + "' style='font-size:12px;'>总计:<i class='fa fa-rmb'></i> " + Convert.ToDouble(dr["OrdersAmount"]).ToString("f2") + "<br />";
string _paytypeHtml = OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.PayType);
if (!string.IsNullOrEmpty(_paytypeHtml))
{
_paytypeHtml = _paytypeHtml + "<br />";
}
html += _paytypeHtml;
html += "<div>商品:" + (DataConvert.CDouble(dr["OrdersAmount"]) - DataConvert.CDouble(dr["Freight"])).ToString("F2") + "</div>";
//html += "<div>运费:" + DataConvert.CDouble(dr["Freight"]).ToString("F2") + "</div>";
html += "<div title='优惠券'>优惠:" + payMod.ArriveMoney.ToString("F2") + "</div>";
//html += "<div>积分:" + payMod.UsePointArrive.ToString("f2") + "(" + payMod.UsePoint.ToString("F0") + ")</div>";
html += "<div style='color:#d9534f;'>需付:" + payMod.MoneyReal.ToString("F2") + "</div>";
if (!string.IsNullOrEmpty(DataConvert.CStr(dr["PaymentNo"])))
{
string plat = ExOrder.ShowPayPlatName(DataConvert.CLng(dr["PayPlatID"]));
html += "<span style='color:#337ab7;'>" + plat + "</span>"
+ "(" + OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.Pay) + ")</a>";
}
else
{
html += "(" + OrderHelper.GetStatus(dr.Row, OrderHelper.TypeEnum.Pay) + ")";
}
html += "</td>";
//订单状态
//html += "<td class='td_md rowtd' rowspan='" + count + "'>";
//int ordertype = DataConvert.CLng(dr["OrderType"]);
//html += "</td>";
//操作栏
html += "<td class='td_md rowtd' rowspan='" + count + "'>" + Getoperator(dr) + "</td>";
(e.Item.FindControl("Order_Lit") as Literal).Text = html;
}
}
}
private DataTable SelPage(int pageSize, int pageIndex)
{
M_UserInfo mu = buser.GetLogin();
Filter_Order filter = new Filter_Order();
filter.cpage = pageIndex;
filter.psize = pageSize;
//filter.storeType = StoreType_DP.SelectedValue;
filter.orderType = "-100";
//filter.addon = Filter;
filter.uids = mu.UserID.ToString();
//filter.proname = ProName_T.Text;
//filter.orderno = OrderNo_T.Text;
//filter.reuser = ReUser_T.Text;
//filter.mobile = Mobile_T.Text;
//filter.uids = UserID_T.Text;
//filter.stype = SkeyType_DP.SelectedValue;
//filter.skey = Skey_T.Text;
//filter.stime = STime_T.Text;
//filter.etime = ETime_T.Text;
//filter.expstime = ExpSTime_T.Text;
//filter.expetime = ExpETime_T.Text;
PageSetting setting = ExHelper.Order_Sel(filter);
OrderDT = setting.dt;
StoreDT = orderCom.SelStoreDT(OrderDT);
//Skey_T.Text = Skey;
DataTable dt = new DataTableHelper().DistinctByField(OrderDT, "ID");
if (dt != null && dt.Rows.Count > 0)
{
TotalSum_Hid.Value = DataConvert.CDouble(OrderDT.Compute("SUM(ordersamount)", "")).ToString("f2");
//function.Script(this, "CheckOrderType('" + Filter + "')");
Order_RPT.ItemCount = setting.itemCount;
empty_div.Visible = false;
}
else { empty_div.Visible = true; TotalSum_Hid.Value = "0"; }
return dt;
}
