public JArray Create_ModelSO()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from MM_ORDERS_HEADER where STATUS='' and Warehouse_Number='90071' ");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
DataTable dtOrderkey = this.Get_Orderkey_South(count, "90071", "CS");
if (count > 0 && dtOrderkey.Rows.Count == count)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model_South so = new SOInfor_Model_South();
IList <Orderdetail_South> orderDetail = new List <Orderdetail_South>();
string type = dt.Rows[i]["Order_Type"].ToString().Trim();
string orderkey_infor = dtOrderkey.Rows[i][0].ToString();
string orderkey_mm = dt.Rows[i]["Order_Number"].ToString().Trim();
string storer = dt.Rows[i]["Store_Number"].ToString().Trim().TrimStart('0');
string externorderkey = "S" + storer.Substring(3, 2);
code = orderkey_mm;
so.type = "9602";
so.orderkey = orderkey_infor;
so.storerkey = "OW9600";
so.consigneekey = storer;
so.externalorderkey2 = orderkey_mm;
so.externorderkey = externorderkey;
so.notes2 = dt.Rows[i]["Memo_Field"].ToString().Trim();
so.pokey = "";
so.requestedshipdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.deliverydate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_To_Warehouse"].ToString());
so.orderdate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse10";
orderDetail = this.Create_OrderDetail(orderkey_mm, orderkey_infor);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "CS_SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}
public JArray Create_ModelSO_Return()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from [V_MM_SO_RETURN_HEADER_SOUTH] ");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
DataTable dtOrderkey = this.Get_Orderkey_South(count, "90071", "RT");
if (count > 0 && dtOrderkey.Rows.Count == count)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model_South so = new SOInfor_Model_South();
IList <Orderdetail_South> orderDetail = new List <Orderdetail_South>();
string orderkey_infor = dtOrderkey.Rows[i][0].ToString();
string po_MM = dt.Rows[i]["Order_Number"].ToString().Trim();
string supplier = dt.Rows[i]["Supplier_Number"].ToString().TrimStart('0');
string externorderkey = supplier;
code = po_MM;
so.type = "9603";
so.orderkey = orderkey_infor;
so.storerkey = "OW9600";
so.consigneekey = "STD";
so.externalorderkey2 = po_MM;
so.externorderkey = externorderkey;
so.susr2 = "";
so.notes2 = "";
so.pokey = "";
so.requestedshipdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.deliverydate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.orderdate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse10";
orderDetail = this.Create_OrderDetail_Return(po_MM, orderkey_infor);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "RETURN_SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}
public JArray Create_ModelSO_Xdock()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from V_MM_SO_XDOCK_HEADER_SOUTH ");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
DataTable dtOrderkey = this.Get_Orderkey_South(count, "90071", "XD");
if (count > 0 && dtOrderkey.Rows.Count == count)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model_South so = new SOInfor_Model_South();
IList <Orderdetail_South> orderDetail = new List <Orderdetail_South>();
string orderkey_infor = dtOrderkey.Rows[i][0].ToString();
string orderkey_mm = dt.Rows[i]["SO"].ToString();
code = orderkey_mm;
string storer = dt.Rows[i]["Store"].ToString();
string externorderkey = "S" + storer.Substring(3, 2);
so.type = "0";
so.orderkey = orderkey_infor;
so.storerkey = "OW9600";
so.consigneekey = dt.Rows[i]["Store"].ToString();
so.externalorderkey2 = orderkey_mm;
so.externorderkey = externorderkey;
so.susr1 = orderkey_mm;
so.requestedshipdate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); //DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString().Trim());
so.deliverydate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
so.orderdate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString().Trim());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse10";
orderDetail = this.Create_OrderDetail_Xdock(orderkey_infor, orderkey_mm);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "XDOCK_SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}