/// <summary>
/// 订单分配
/// </summary>
public void InstallerAssign()
{
var json = Request["data"];
var rows = (ArrayList)PluSoft.Utils.JSON.Decode(json);
foreach (Hashtable row in rows)
{
var orderId = Convert.ToInt32(row["OrderId"]);
var detailCount = new Sys.BLL.OrderStatusFlow().GetRecordCount("OrderId=" + orderId);
if (detailCount > 0)
{
Response.Write("-1");
return;
}
else
{
var model = new Sys.BLL.Orders().GetModel(orderId);
if (model != null)
{
model.WorkerId = row["newWorkerId"].ToString();
var result = new Sys.BLL.Orders().Update(model);
if (result)
{
Response.Write("1");
}
}
}
}
}
public void GetView()
{
int id = PageRequest.GetInt("id", 0);
var dt = new Sys.BLL.Orders().GetOrderByOrderId(id);
var data = MyDBUtils.DataTable2ArrayList(dt);
var htData = data.Count > 0 ? (Hashtable)data[0] : null;
var json = PluSoft.Utils.JSON.Encode(htData);
Response.Write(json);
}
public void DelOrder()
{
int id = PageRequest.GetInt("id", 0);
var bll = new Sys.BLL.Orders();
if (bll.DeleteOrders(id))
{
Response.Write("1");
}
else
{
Response.Write("0");
}
}
/// <summary>
/// 更新订单
/// </summary>
/// <returns></returns>
public Dictionary <string, object> UpdateOrdersStatus()
{
Dictionary <string, object> dicResult = new Dictionary <string, object>();
if (!Request.Params.AllKeys.Contains("ordersId") ||
!Request.Params.AllKeys.Contains("orderStatus") || !Request.Params.AllKeys.Contains("staFlag") ||
!Request.Params.AllKeys.Contains("staMessage"))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "接口缺少参数！");
return(dicResult);
}
var token = Request["token"];
var ordersId = Convert.ToInt32(Request["ordersId"]);
var orderStatus = Convert.ToInt32(Request["orderStatus"]);
var staFlag = Convert.ToInt32(Request["staFlag"]);
var staMessage = Request["staMessage"];
//var picList = Request["PicList"];
if (!new Sys.BLL.Account().CheckToken(token))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "Token验证失败！");
return(dicResult);
}
string message;
var bllOrder = new Sys.BLL.Orders();
if (!bllOrder.OrdersStatusCheck(ordersId, orderStatus, staFlag, out message))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", message);
}
else
{
var picList = UploadPhotos();
var result = bllOrder.UpdateOrdersStatus(ordersId, orderStatus, staFlag, picList, staMessage);
if (result)
{
dicResult.Add("response_id", 1);
dicResult.Add("response_msg", "订单状态更新成功！");
}
}
return(dicResult);
}
/// <summary>
/// 创建订单
/// </summary>
/// <param name="dicParams"></param>
/// <returns></returns>
private Dictionary <string, object> CreateOrders(Dictionary <string, object> dicParams)
{
Dictionary <string, object> dicResult = new Dictionary <string, object>();
if (!dicParams.ContainsKey("orders") || !dicParams.ContainsKey("orders_type") || !dicParams.ContainsKey("token"))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "登陆接口缺少参数！");
return(dicResult);
}
if (!new Sys.BLL.Account().CheckToken(dicParams["token"].ToString()))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "Token验证失败！");
return(dicResult);
}
var ds = new DataSet();
ds.Tables.Add(JsonHelper.JsonToDataTable(dicParams["orders"].ToString()));
ds.Tables.Add(JsonHelper.JsonToDataTable(dicParams["orders_type"].ToString()));
var ordersList = JsonHelper.DataSetToIList <Sys.Model.Orders>(ds, 0);
var orderTypeList = JsonHelper.DataSetToIList <Sys.Model.OrderType>(ds, 1);
if (ordersList == null || orderTypeList == null)
{
// 失败，返回信息
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "创建失败！");
}
else
{
bool result = new Sys.BLL.Orders().CreateOrders(ordersList, orderTypeList);
if (result)
{
dicResult.Add("response_id", 1);
dicResult.Add("response_msg", "订单创建成功！");
}
else
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "订单创建失败！");
}
}
return(dicResult);
}
/// <summary>
/// 更新订单
/// </summary>
/// <param name="dicParams"></param>
/// <returns></returns>
public Dictionary <string, object> UpdateOrdersStatus(Dictionary <string, object> dicParams)
{
Dictionary <string, object> dicResult = new Dictionary <string, object>();
//int ordersId, string orderStatus, int staFlag
if (!dicParams.ContainsKey("token") || !dicParams.ContainsKey("ordersId") ||
!dicParams.ContainsKey("orderStatus") || !dicParams.ContainsKey("staFlag") ||
!dicParams.ContainsKey("PicList") || !dicParams.ContainsKey("staMessage"))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "接口缺少参数！");
return(dicResult);
}
if (!new Sys.BLL.Account().CheckToken(dicParams["token"].ToString()))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "Token验证失败！");
return(dicResult);
}
int ordersId = Convert.ToInt32(dicParams["ordersId"]);
int orderStatus = Convert.ToInt32(dicParams["orderStatus"]);
int staFlag = Convert.ToInt32(dicParams["staFlag"]);
string picList = dicParams["PicList"].ToString();
string staMessage = dicParams["staMessage"].ToString();
string message;
var bllOrder = new Sys.BLL.Orders();
if (!bllOrder.OrdersStatusCheck(ordersId, orderStatus, staFlag, out message))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", message);
}
else
{
var result = bllOrder.UpdateOrdersStatus(ordersId, orderStatus, staFlag, picList, staMessage);
if (result)
{
dicResult.Add("response_id", 1);
dicResult.Add("response_msg", "订单状态更新成功！");
}
}
return(dicResult);
}
/// <summary>
/// 订单列表
/// </summary>
/// <param name="dicParams"></param>
/// <returns></returns>
private Dictionary <string, object> GetOrdersList(Dictionary <string, object> dicParams)
{
Dictionary <string, object> dicResult = new Dictionary <string, object>();
if (!dicParams.ContainsKey("token") || !dicParams.ContainsKey("orderStatus") ||
!dicParams.ContainsKey("pageIndex") || !dicParams.ContainsKey("pageSize"))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "接口缺少参数！");
return(dicResult);
}
if (!new Sys.BLL.Account().CheckToken(dicParams["token"].ToString()))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "Token验证失败！");
return(dicResult);
}
var orderStatus = dicParams["orderStatus"].ToString();
var userType = dicParams["userType"].ToString();
var userLoginId = dicParams["userLoginId"].ToString();
var pageIndex = Convert.ToInt32(dicParams["pageIndex"]);
var pageSize = Convert.ToInt32(dicParams["pageSize"]);
var dt = new Sys.BLL.Orders().GetOrdersList(orderStatus, userType, userLoginId, pageIndex, pageSize);
if (dt == null || dt.Rows.Count == 0)
{
// 失败，返回信息
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "暂无数据！");
}
else
{
dicResult.Add("response_id", 1);
dicResult.Add("response_msg", "订单信息获取成功！");
dicResult.Add("orders_info", dt);
}
return(dicResult);
}
/// <summary>
/// 根据UserLoginId获取用户信息和订单信息
/// </summary>
/// <param name="dicParams"></param>
/// <returns></returns>
private Dictionary <string, object> GetOrdersInfo(Dictionary <string, object> dicParams)
{
Dictionary <string, object> dicResult = new Dictionary <string, object>();
if (!dicParams.ContainsKey("token") || !dicParams.ContainsKey("orderId"))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "接口缺少参数！");
return(dicResult);
}
if (!new Sys.BLL.Account().CheckToken(dicParams["token"].ToString()))
{
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "Token验证失败！");
return(dicResult);
}
int orderId = Utils.StrToInt(dicParams["orderId"], 0);
var orderModel = new Sys.BLL.Orders().GetModel(orderId);
var orderTypeList = new Sys.BLL.OrderType().GetModelList("OrderId=" + orderId);
var orderFlow = new Sys.BLL.Orders().GetOrderFlowInfo(orderId);
if (orderModel == null || orderTypeList == null)
{
// 失败，返回信息
dicResult.Add("response_id", 0);
dicResult.Add("response_msg", "订单明细获取异常！");
}
else
{
dicResult.Add("response_id", 1);
dicResult.Add("response_msg", "订单信息获取成功！");
dicResult.Add("order_main", orderModel);
dicResult.Add("order_detail", orderTypeList);
dicResult.Add("order_flow", orderFlow);
}
return(dicResult);
}
/// <summary>
/// 查询
/// </summary>
public void SearchData()
{
//查询条件
var orderStatus = PageRequest.GetString("orderStatus");
var projectName = PageRequest.GetString("projectName");
var cmbDate = PageRequest.GetString("cmbDate");
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1) + 1;
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " u." + sortField + " " + sortOrder;
}
else
{
order += " CreateDate desc";
}
var strWhere = "1=1";
if (!string.IsNullOrEmpty(orderStatus))
{
if (orderStatus.Equals("0"))
{
strWhere += " and OrderStatus is null";
}
else
{
strWhere += " and OrderStatus=" + orderStatus;
}
}
if (!string.IsNullOrEmpty(projectName))
{
strWhere += string.Format(" and ProjectName like '%{0}%' ", DataSecurity.FilterBadChar(projectName));
}
if (!string.IsNullOrEmpty(cmbDate))
{
//1day,3day,1week,1month,halfyear,oneyear
if (cmbDate.Equals("1day"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-1,GETDATE())";
}
else if (cmbDate.Equals("3day"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-3,GETDATE())";
}
else if (cmbDate.Equals("1week"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-7,GETDATE())";
}
else if (cmbDate.Equals("1month"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-30,GETDATE())";
}
else if (cmbDate.Equals("halfyear"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-180,GETDATE())";
}
else if (cmbDate.Equals("oneyear"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-365,GETDATE())";
}
}
if (pageSize == 1)
{
pageSize = 100;
}
var dt = new Sys.BLL.Orders().GetListForMoreTable(pageSize, pageIndex, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
var total = new Sys.BLL.Common().GetCount("Orders o", strWhere);
result["total"] = total;
//JSON
var json = PluSoft.Utils.JSON.Encode(result);
Response.Write(json);
}