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