public string GetOrdersDeliverys()
{
string listtype = tools.CheckStr(Request.QueryString["listtype"]);
string keyword, date_start, date_end;
int orders_ID;
orders_ID = 0;
//关键词
keyword = tools.CheckStr(Request["keyword"]);
//开始时间
date_start = tools.CheckStr(Request["date_start"]);
//结束时间
date_end = tools.CheckStr(Request["date_end"]);
OrdersInfo ordersinfo = null;
QueryInfo Query = new QueryInfo();
Query.PageSize = tools.CheckInt(Request["rows"]);
Query.CurrentPage = tools.CheckInt(Request["page"]);
Query.ParamInfos.Add(new ParamInfo("AND", "str", "OrdersDeliveryInfo.Orders_Delivery_Site", "=", Public.GetCurrentSite()));
if (keyword != "")
{
ordersinfo = Myorder.GetOrdersBySN(keyword);
if (ordersinfo != null)
{
orders_ID = ordersinfo.Orders_ID;
}
if (orders_ID > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND", "int", "OrdersDeliveryInfo.Orders_Delivery_OrdersID", "=", orders_ID.ToString()));
}
}
if (date_start != "")
{
Query.ParamInfos.Add(new ParamInfo("AND", "funint", "DATEDIFF(d, '" + date_start + "',{OrdersDeliveryInfo.Orders_Delivery_Addtime})", ">=", "0"));
}
if (date_end != "")
{
Query.ParamInfos.Add(new ParamInfo("AND", "funint", "DATEDIFF(d, '" + date_end + "',{OrdersDeliveryInfo.Orders_Delivery_Addtime})", "<=", "0"));
}
Query.OrderInfos.Add(new OrderInfo(tools.CheckStr(Request["sidx"]), tools.CheckStr(Request["sord"])));
if (listtype == "shipping")
{
Query.ParamInfos.Add(new ParamInfo("AND", "int", "OrdersDeliveryInfo.Orders_Delivery_DeliveryStatus", "=", "1"));
}
else if (listtype == "returned")
{
Query.ParamInfos.Add(new ParamInfo("AND", "int", "OrdersDeliveryInfo.Orders_Delivery_DeliveryStatus", "=", "5"));
}
PageInfo pageinfo = MyBLL.GetPageInfo(Query, Public.GetUserPrivilege());
IList <OrdersDeliveryInfo> entitys = MyBLL.GetOrdersDeliverys(Query, Public.GetUserPrivilege());
if (entitys != null)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"page\":" + pageinfo.CurrentPage + ",\"total\":" + pageinfo.PageCount + ",\"records\":" + pageinfo.RecordCount + ",\"rows\"");
jsonBuilder.Append(":[");
foreach (OrdersDeliveryInfo entity in entitys)
{
jsonBuilder.Append("{\"id\":" + entity.Orders_Delivery_ID + ",\"cell\":[");
//各字段
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Orders_Delivery_ID);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
ordersinfo = Myorder.GetOrdersByID(entity.Orders_Delivery_OrdersID);
if (ordersinfo != null)
{
jsonBuilder.Append("<a href=\\\"/orders/orders_view.aspx?orders_id=" + entity.Orders_Delivery_OrdersID + "\\\">" + ordersinfo.Orders_SN + "</a>");
}
else
{
jsonBuilder.Append("未知");
}
ordersinfo = null;
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Orders_Delivery_DocNo);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"<span class=\\\"t12_red\\\">");
jsonBuilder.Append(Public.DisplayCurrency(entity.Orders_Delivery_Amount));
jsonBuilder.Append("</span>\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Orders_Delivery_Addtime);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (Public.CheckPrivilege("95515ef3-e035-4400-b4fc-da4d8f5a530f"))
{
if (entity.Orders_Delivery_Status == 0 && entity.Orders_Delivery_DeliveryStatus == 5)
{
jsonBuilder.Append("<a href=\\\"orders_deliverypaycancel.aspx?orders_delivery_id=" + entity.Orders_Delivery_ID + "&orders_id=" + entity.Orders_Delivery_OrdersID + "\\\">申请退款</a> ");
}
}
jsonBuilder.Append("<a href=\\\"orders_delivery_view.aspx?orders_delivery_id=" + entity.Orders_Delivery_ID + "\\\"><img src=\\\"/images/btn_view.gif\\\" alt=\\\"查看\\\" border=\\\"0\\\" align=\\\"absmiddle\\\"></a>");
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
else
{
return(null);
}
}
