public IList <Orderdetail> Create_OrderDetail(string orderkey_MM, string orderkey_Infor)
{
IList <Orderdetail> orderDetails = new List <Orderdetail>();
string sql = string.Format("select * from MM_ORDERS_DETAIL where Order_Number = '{0}' and STATUS=''", orderkey_MM);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
Orderdetail orderDetail = new Orderdetail();
orderDetail.orderkey = orderkey_Infor;
orderDetail.storerkey = "OW0094";
orderDetail.sku = dt.Rows[i]["Article_Number"].ToString();
orderDetail.openqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.originalqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.newallocationstrategy = "N01";
orderDetail.susr2 = dt.Rows[i]["Article_Selling_Price"].ToString();
orderDetail.whseid = "wmwhse3";
orderDetail.addwho = "wmsadmin";
orderDetail.editwho = "wmsadmin";
orderDetails.Add(orderDetail);
}
return(orderDetails);
}
public IList <Orderdetail> Create_OrderDetail_Xdock(string orderkey_mm, string pokey_MM)
{
IList <Orderdetail> orderDetails = new List <Orderdetail>();
string sql = string.Format("select * from [V_MM_SO_XDOCK_DETAIL] where Order_Number = '{0}' and Sale_Order='{1}'", pokey_MM, orderkey_mm);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
try
{
Orderdetail orderDetail = new Orderdetail();
string sku = dt.Rows[i]["Article_Number"].ToString().Trim().TrimStart('0');
orderDetail.orderkey = orderkey_mm.TrimStart('0');
orderDetail.storerkey = "N0528";
orderDetail.sku = sku;
orderDetail.openqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.originalqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.newallocationstrategy = "MM";
orderDetail.susr2 = "";
orderDetail.lottable02 = "BBXD";
orderDetail.lottable03 = pokey_MM.TrimStart('0');
orderDetail.lottable10 = orderkey_mm.TrimStart('0');
orderDetail.whseid = "wmwhse3";
orderDetail.addwho = "wmsadmin";
orderDetail.editwho = "wmsadmin";
orderDetails.Add(orderDetail);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SODETAIL, "XDOCK_NORTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
return(orderDetails);
}
public IList <Orderdetail> Create_OrderDetail(string orderkey_mm, string orderkey_infor)
{
IList <Orderdetail> orderDetails = new List <Orderdetail>();
string sql = string.Format("select * from MM_ORDERS_DETAIL where Order_Number = '{0}' and STATUS='' and Warehouse_Number='90072' ", orderkey_mm);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
try
{
Orderdetail orderDetail = new Orderdetail();
string sku = dt.Rows[i]["Article_Number"].ToString().Trim().TrimStart('0');
orderDetail.orderkey = orderkey_infor;
orderDetail.storerkey = "N0528";
orderDetail.sku = sku;
orderDetail.openqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.originalqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.newallocationstrategy = "N01";
orderDetail.susr2 = dt.Rows[i]["Article_Selling_Price"].ToString().Trim();
orderDetail.whseid = "wmwhse3";
orderDetail.addwho = "wmsadmin";
orderDetail.editwho = "wmsadmin";
orderDetails.Add(orderDetail);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SODETAIL, "CS_NORTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
return(orderDetails);
}
