public List<OrderStatus> GetOrderStatusByParterid(string parterid) { List<OrderStatus> result = new List<OrderStatus>(); try { string sSql = string.Format("Select * From D_CallCenterOrderInfo (nolock) where Parterid='{0}'", parterid); //插入订单 var dt = helper.GetDataTable(sSql); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { OrderStatus entity = new OrderStatus(); entity.Status = dt.Rows[i]["State"].ToString(); entity.OrderId = dt.Rows[i]["OrderId"].ToString(); result.Add(entity); } } } catch (Exception ex) { LogControl.WriteError("GetOrderStatusByParterid查询订单失败|Error:" + ex.Message); } return result; }
public List<OrderStatus> GetOrderStatusByOrderIds(string orderIds, out List<string> lastIds) { List<OrderStatus> result = new List<OrderStatus>(); lastIds = new List<string>(); try { string[] sIds = orderIds.Split(','); string newIds = ""; for (int i = 0; i < sIds.Length; i++) { newIds += "'" + sIds[i] + "',"; lastIds.Add(sIds[i].ToUpper()); } newIds = newIds.Substring(0, newIds.Length - 1); string sSql = string.Format(@"Select OrderId,States From D_CallCenterOrderInfo (nolock) where States>41 and OrderId in({0}) union Select Orderid,State From D_OrderInfo(nolock) where OrderId in({0})", newIds); var dt = helper.GetDataTable(sSql); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { OrderStatus entity = new OrderStatus(); entity.Status = dt.Rows[i]["States"].ToString(); entity.OrderId = dt.Rows[i]["OrderId"].ToString(); result.Add(entity); lastIds.Remove(entity.OrderId.ToUpper()); } } } catch (Exception ex) { LogControl.WriteError("GetOrderStatusByOrderIds查询订单失败|Error:" + ex.Message); } return result; }