protected override void ExecuteChild(BomReturnStatusErpReq dataReq, ResponseAPI dataRes)
{
ResponseErp _result = new ResponseErp();
var amw_refId = "RBOM" + DateTimeUtil.ToRefId(DateTime.Now) + "-" + "0001";
if (dataReq != null)
{
try
{
if ((dataReq.amw_refId != null) && (dataReq.amw_refId.Trim() != ""))
{
_result.amw_refId = amw_refId;
_result.code = "S0001";
_result.message = "SUCCESS";
_result.status = "S";
_result.data = dataReq;
}
else
{
_result.amw_refId = amw_refId;
_result.code = "F0001";
_result.message = "Failed : " + "กรุณาระบุ amw_refId ";
_result.status = "F";
_result.data = dataReq;
}
}
catch (Exception ex)
{
_result = ExceptionConvert(ex);
_result.amw_refId = amw_refId;
_result.data = dataReq;
}
}
else
{
_result.amw_refId = amw_refId;
_result.code = "F0000";
_result.message = "ไม่รองรับข้อมูล == null";
_result.status = "F";
_result.data = dataReq;
}
dataRes.data = _result;
}
private ResponseErp ExceptionConvert(Exception ex)
{
ResponseErp _result = new ResponseErp();
string StackTraceMsg = string.Empty;
StackTraceMsg = ex.StackTrace;
//map error code, message
ErrorCode error = EnumUtil.GetEnum <ErrorCode>(ex.Message);
_result.code = error.ToString();
if (_result.code == ErrorCode.U000.ToString())
{
_result.message = ex.Message;
}
else
{
_result.message = error.GetDescription();
}
_result.status = "F";
return(_result);
}
protected override void ExecuteChild(ItemMasterReturnStatusErpReq dataReq, ResponseAPI dataRes)
{
ResponseErp _result = new ResponseErp();
var amw_refId = "RITM" + DateTimeUtil.ToRefId(DateTime.Now) + "-" + "0001";
List <ItemMasterReturnStatusErpRes> _resDatas = new List <ItemMasterReturnStatusErpRes>();
ItemMasterReturnStatusErpRes _data = new ItemMasterReturnStatusErpRes();
if (dataReq != null)
{
if ((dataReq.amw_refId != null) && (dataReq.amw_refId.Trim() != ""))
{
_result.amw_refId = amw_refId;
_result.code = "S0001";
_result.message = "SUCCESS";
_result.status = "S";
_result.data = dataReq;
foreach (var afor in dataReq.item_master)
{
_data = new ItemMasterReturnStatusErpRes();
_data.seq_item = NumberUtil.Strtoint(afor.seq_item);
_data.item = afor.item;
if (afor.seq_item != null)
{
_data.code = "S0001";
_data.message = "SUCCESS";
_data.status = "S";
}
else
{
_data.code = "F0001";
_data.message = "Failed : " + "กรุณาระบุ amw_refId ";
_data.status = "F";
}
_resDatas.Add(_data);
}
_result.data = _resDatas;
}
else
{
_result.amw_refId = amw_refId;
_result.code = "F0001";
_result.message = "Failed : " + "กรุณาระบุ amw_refId ";
_result.status = "F";
_result.data = dataReq;
}
}
else
{
_result.amw_refId = amw_refId;
_result.code = "F0000";
_result.message = "ไม่รองรับข้อมูล == null";
_result.status = "F";
_result.data = dataReq;
}
dataRes.data = _result;
}
protected override void ExecuteChild(IDCodeDesModel dataReq, ResponseAPI dataRes)
{
var amw_refId = "SITM" + DateTimeUtil.ToRefId(DateTime.Now) + "-" + "0002";
var _sendUrl = "";
var _json = "";
var reJson = "";
ResponseErp resErp = new ResponseErp();
var res = new ItemMasterSend();
res.amw_refId = amw_refId;
res.item_master = new List <ItemMaster>();
ItemMaster eg = new ItemMaster();
eg.seq_item = 1;
//eg.item = "B640715-0-00-0-0-00";
eg.item = "T999999-0-00-0-0-05";
eg.description = "SRM UNIT LOAD DDH15 M.นน700 KG.(PALLETSIZE1.10X1.35X1.45 M.)";
eg.search_key_i = "SRM UNIT LOAD DD";
eg.search_key_ii = "SRM UNIT LOAD DD";
eg.item_type = "30"; //PRODUCT
eg.item_group = "MFG";
eg.order_system = "2"; //PLANNED
eg.inventory_unit = "set";
eg.serialized = "2";
eg.derived_from_item = "T999999-0-00-0-0-05";
eg.customizable = "1";
eg.with_pcs = "1";
eg.cost_component = "1";
eg.size = "1";
eg.standard = "1";
eg.weight = (Decimal)0.0;
eg.weight_unit = "1";
eg.product_type = "";
eg.product_class = "102"; //101 insert 102 edit
eg.product_line = "";
eg.default_supply_source = "20"; //JOB SHOP
eg.material = "JOB SHOP";
eg.order_quantity_increment = 1;
eg.minimum_order_quantity = (Decimal)0.0;
eg.maximum_order_quantity = (Decimal)9999999.0;
eg.fixed_order_quantity = (Decimal)1.0;
eg.reorder_point = (Decimal)0.0;
eg.order_interval = (Decimal)1.0;
eg.safety_stock = (Decimal)0.0;
eg.safety_time = (Decimal)0.0;
eg.bom_quantity = (Decimal)1.0;
eg.routing_quantity = (Decimal)1.0;
eg.purchase_unit = "set";
eg.purchase_price_unit = "set";
eg.purchase_price_group = "101";
eg.purchase_statistics_group = "101";
eg.purchase_currency = "THB";
eg.purchase_price = (Decimal)0.0;
eg.vendorRating = 1;
eg.inspection = 2;
eg.supply_time = (Decimal)0.0;
eg.sales_unit = "set";
eg.sales_price_unit = "set";
eg.sales_price_group = "101";
eg.sales_statistics_group = "101";
eg.sales_currency = "THB";
eg.sales_price = (Decimal)0.0;
eg.warehouse_item_sales = "FG";
eg.warehouse_item_purch = "FG";
eg.warehouse_item_ordering = "FG";
eg.plan_level = "1";
eg.ordering_warehouse = "FG";
eg.operations_horizon = "365";
eg.order_horizon = "365";
eg.planning_horizon = "365";
eg.costing_source = "20";//JOB SHOP
eg.standard_cost_component_scheme = "101";
eg.sales_office = "DBI01";
eg.quality_group = "";
res.item_master.Add(eg);
/*
* eg = new ItemMaster();
*
* eg.seq_item = 2;
* eg.item = "TEST20-1-24-0-0-02";
* eg.description = "TEST SEND ITEM MASTER 2";
* eg.search_key_i = "TEST SEND ITEM MASTER 2";
* eg.search_key_ii = "TEST SEND ITEM MASTER 2";
* eg.item_type = "30";//PRODUCT
* eg.item_group = "MFG";
* eg.order_system = "2";//PLANNED
* eg.inventory_unit = "set";
* eg.serialized = "2";
* eg.derived_from_item = "TEST20-1-24-0-0-02";
* eg.customizable = "1";
* eg.with_pcs = "1";
* eg.cost_component = "1";
* eg.size = "1";
* eg.standard = "1";
* eg.weight = (Decimal)0.0;
* eg.weight_unit = "1";
* eg.product_type = "";
* eg.product_class = "";
* eg.product_line = "";
* eg.default_supply_source = "20";//JOB SHOP
* eg.material = "JOB SHOP";
* eg.order_quantity_increment = 1;
* eg.minimum_order_quantity = (Decimal)0.0;
* eg.maximum_order_quantity = (Decimal)9999999.0;
* eg.fixed_order_quantity = (Decimal)1.0;
* eg.reorder_point = (Decimal)0.0;
* eg.order_interval = (Decimal)1.0;
* eg.safety_stock = (Decimal)0.0;
* eg.safety_time = (Decimal)0.0;
* eg.bom_quantity = (Decimal)1.0;
* eg.routing_quantity = (Decimal)1.0;
* eg.purchase_unit = "set";
* eg.purchase_price_unit = "set";
* eg.purchase_price_group = "101";
* eg.purchase_statistics_group = "101";
* eg.purchase_currency = "THB";
* eg.purchase_price = (Decimal)0.0;
*
* eg.vendorRating = 1;
* eg.inspection = 2;
*
* eg.supply_time = (Decimal)0.0;
* eg.sales_unit = "set";
* eg.sales_price_unit = "set";
* eg.sales_price_group = "101";
* eg.sales_statistics_group = "101";
* eg.sales_currency = "THB";
* eg.sales_price = (Decimal)0.0;
* eg.warehouse_item_sales = "FG";
* eg.warehouse_item_purch = "FG";
* eg.warehouse_item_ordering = "FG";
* eg.plan_level = "1";
* eg.ordering_warehouse = "FG";
* eg.operations_horizon = "365";
* eg.order_horizon = "365";
* eg.planning_horizon = "365";
* eg.costing_source = "20";//JOB SHOP
* eg.standard_cost_component_scheme = "101";
* eg.sales_office = "DBI01";
* eg.quality_group = "";
*
* res.item_master.Add(eg);
*/
dataRes.data = res;
if (res != null)
{
if (res.item_master.Count > 0)
{
/*_sendUrl = "https://localhost:44347/weatherforecast/ExErpItemMaster";*/
_sendUrl = "https://erplnaddonapi.kigintergroup.com:4433/api/ItemMaster";
_json = "";
reJson = "";
_json = Newtonsoft.Json.JsonConvert.SerializeObject(res);
reJson = SendErpRequest.SendRequest("POST", _sendUrl, _json);
resErp = JsonConvert.DeserializeObject <ResponseErp>(reJson);
}
}
}
protected override void ExecuteChild(ItemGroupsReq dataReq, ResponseAPI dataRes)
{
ResponseErp _result = new ResponseErp();
var amw_refId = "RITG" + DateTimeUtil.ToRefId(DateTime.Now) + "-" + "0001";
var conn = ASSETKKF_ADO.Mssql.Mcis.Base.OpenConnection();//ตรงนี้สามารถกำหนด สำรอง/จริงได้
conn.Open();
List <ItemGroupRes> Item_Group = new List <ItemGroupRes>();
if (dataReq != null)
{
amw_refId = dataReq.amw_refId;
foreach (var afor in dataReq.item_group)
{
ItemGroupRes _itemGroup = new ItemGroupRes();
lnItemGroup _lnItemGroup = new lnItemGroup();
if (NumberUtil.GetID(afor.seq_itemgroup) != null)
{
_itemGroup.seq_itemgroup = afor.seq_itemgroup;
_itemGroup.itemgroup = afor.itemgroup;
_itemGroup.description = afor.description;
_lnItemGroup.seq_itemgroup = afor.seq_itemgroup;
_lnItemGroup.itemgroup = afor.itemgroup;
_lnItemGroup.description = afor.description;
var iSuccess = true;
SqlTransaction tran = conn.BeginTransaction();
try
{
lnItemGroupAdo.GetInstant().Save(_lnItemGroup, "", tran);
_itemGroup.code = "S0001";
_itemGroup.message = "SUCCESS";
_itemGroup.status = "S";
}
catch (Exception ex)
{
iSuccess = false;
_itemGroup.code = "F0002";
_itemGroup.message = "Failed : " + "บันทึกข้อมูลไม่สำเร็จ " + ex.Message;
_itemGroup.status = "F";
}
finally
{
}
if (!iSuccess)
{
tran.Rollback();
}
else
{
tran.Commit();
}
}
else
{
_itemGroup.seq_itemgroup = afor.seq_itemgroup;
_itemGroup.itemgroup = afor.itemgroup;
_itemGroup.description = afor.description;
_itemGroup.code = "F0001";
_itemGroup.message = "Failed : " + "กรุณาระบุ Seq_Itemgroup ";
_itemGroup.status = "F";
}
Item_Group.Add(_itemGroup);
}
_result.amw_refId = amw_refId;
_result.code = "S0001";
_result.message = "SUCCESS";
_result.status = "S";
_result.data = Item_Group;
}
else
{
_result.amw_refId = amw_refId;
_result.code = "F0000";
_result.message = "ไม่รองรับข้อมูล == null";
_result.status = "F";
_result.data = dataReq;
}
dataRes.data = _result;
}
