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;
}
