public JArray Create_ModelSku_South() { JArray items = new JArray(); string sql = string.Format("exec PP_Article"); DataTable dt = DAL.SELECT_SQL(sql); if (dt.Rows.Count > 0) { int count = dt.Rows.Count; for (int i = 0; i < count; i++) { SkuInfor_Model item = new SkuInfor_Model(); item.storerkey = "OW9600"; string sku = dt.Rows[i]["Article_Number"].ToString().Trim(); item.sku = sku; item.descr = dt.Rows[i]["Desc_Article"].ToString().Trim(); item.addwho = "addmin"; item.editwho = "admin"; item.putawaystrategykey = "STD"; item.sourceversion = "0"; item.susr1 = dt.Rows[i]["susr1"].ToString().Trim(); item.susr2 = dt.Rows[i]["susr2"].ToString().Trim(); item.susr3 = dt.Rows[i]["Supplier_Article_Number"].ToString().Trim(); item.susr4 = ""; item.susr5 = dt.Rows[i]["susr5"].ToString().Trim(); item.susr6 = ""; item.susr7 = ""; item.susr8 = dt.Rows[i]["susr8"].ToString().Trim(); item.susr9 = dt.Rows[i]["susr9"].ToString().Trim(); item.susr10 = dt.Rows[i]["susr10"].ToString().Trim(); item.packkey = dt.Rows[i]["Article_Number"].ToString().Trim() + "_MMMN"; item.skugroup = dt.Rows[i]["Article_Group_Number"].ToString().Trim(); item.skugroup2 = dt.Rows[i]["Artice_Subgroup_Number"].ToString().Trim(); item.stdgrosswgt = "0"; item.stdnetwgt = "0"; item.stdcube = "0"; item.tare = "0"; item.onreceiptcopypackkey = "1"; item.rotateby = "Lottable04"; string shelifeIndicator = dt.Rows[i]["Expiry_Days_Checking_Indicator"].ToString().Trim(); if (shelifeIndicator == "1") { item.shelflifeindicator = "Y"; item.toexpiredays = dt.Rows[i]["Expiry_Days"].ToString().Trim(); item.shelflife = dt.Rows[i]["Minimum_Expiry_Days"].ToString().Trim(); } else { item.shelflifeindicator = "N"; item.toexpiredays = "0"; #region /*nếu shelflifeindicator là N thì phải để shelflife= 0 , nếu không * sẽ báo lỗi localizedMessage internal server*/ #endregion item.shelflife = "0"; } item.odeweight = "1"; item.rfdefaultpack = sku; item.rfdefaultuom = "MU"; item.lottablevalidationkey = "MM"; item.putawaystrategykey = "STD"; item.flowthruitem = "Y"; item.barcodeconfigkey = ""; item.collection = "Local"; item.shelflifecodetype = "M"; // M -manufacturing E- expriation item.lottable01label = "Khong can nhap"; item.lottable02label = "Khong can nhap"; item.lottable03label = "So Batch"; item.lottable04label = "Ngay San Xuat"; item.lottable05label = "Ngay Het Han"; item.lottable06label = "Khong can nhap"; item.lottable07label = "Khong can nhap"; item.lottable08label = "Khong can nhap"; item.lottable09label = "Khong can nhap"; item.lottable10label = "Khong can nhap"; item.snumlength = "0"; item.snumincrlength = "0"; item.allowmultilotlpn = "1"; item.newallocationstrategy = "N01"; string output = JsonConvert.SerializeObject(item); JObject objectitem = JObject.Parse(output); items.Add(objectitem); } } return(items); }
public JArray Create_ModelSku() { JArray items = new JArray(); string sql = string.Format("exec PR_MM_ARTICLES_INFORMATION {0}", "NORTH"); DataTable dt = DAL.SELECT_SQL(sql); if (dt.Rows.Count > 0) { int count = dt.Rows.Count; for (int i = 0; i < count; i++) { try { SkuInfor_Model item = new SkuInfor_Model(); string sku = dt.Rows[i]["Article_Number"].ToString().Trim(); code = dt.Rows[i]["Article_Number"].ToString().Trim(); sku = sku.TrimStart('0'); item.storerkey = "N0528"; item.sku = sku; item.descr = dt.Rows[i]["Desc_Article"].ToString().Trim().Replace("'", "\""); item.addwho = "addmin"; item.editwho = "admin"; item.sourceversion = "0"; item.susr1 = dt.Rows[i]["susr1"].ToString().Trim().TrimStart('0'); item.susr2 = dt.Rows[i]["susr2"].ToString().Trim(); item.susr3 = dt.Rows[i]["Supplier_Article_Number"].ToString().Trim(); item.susr4 = dt.Rows[i]["ARTICLE_GROUP1"].ToString().Trim(); item.susr5 = dt.Rows[i]["ARTICLE_GROUP2"].ToString().Trim(); item.susr6 = ""; item.susr7 = ""; item.susr8 = ""; item.susr9 = ""; item.susr10 = ""; item.packkey = sku; item.rfdefaultpack = sku; item.stdgrosswgt = "0"; item.stdnetwgt = "0"; item.stdcube = "0"; item.tare = "0"; item.onreceiptcopypackkey = "1"; item.rotateby = "Lottable04"; item.odeweight = "1"; item.rfdefaultuom = "MU"; item.lottablevalidationkey = "MM"; item.putawaystrategykey = "STD"; item.newallocationstrategy = "MM"; item.flowthruitem = "Y"; item.barcodeconfigkey = "GLCMB"; item.collection = "Local"; item.shelflifecodetype = "M"; // M -manufacturing E- expriation item.lottable01label = "Khong can nhap"; item.lottable02label = "Khong can nhap"; item.lottable03label = "So Batch"; item.lottable04label = "Ngay San Xuat"; item.lottable05label = "Ngay Het Han"; item.lottable06label = "Khong can nhap"; item.lottable07label = "Khong can nhap"; item.lottable08label = "Khong can nhap"; item.lottable09label = "Khong can nhap"; item.lottable10label = "Khong can nhap"; item.snumlength = "0"; item.snumincrlength = "0"; item.allowmultilotlpn = "1"; string logisticFlow = dt.Rows[i]["Logistic_Flow_Indicator"].ToString().Trim(); if (logisticFlow == "19") { item.shelflifeindicator = "Y"; item.toexpiredays = dt.Rows[i]["Expiry_Days"].ToString().Trim(); item.shelflife = "0"; } else { item.shelflifeindicator = "N"; item.toexpiredays = "0"; #region /*nếu shelflifeindicator là N thì phải để shelflife= 0 , nếu không * sẽ báo lỗi localizedMessage internal server*/ #endregion item.shelflife = "0"; } string output = JsonConvert.SerializeObject(item); JObject objectitem = JObject.Parse(output); items.Add(objectitem); } catch (Exception e) { string step = string.Format(Constant.MODEL_SKU, "NORTH"); resultMapping.Handle_Error_Mapping(code, e.ToString(), step); continue; } } } return(items); }