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