public bool UpdateDataDBForFinishedGoods(DataTable dtERPPQC, out string ERPDoc)
{
try
{
ERPDoc = "";
//Class.valiballecommon.GetStorage().DocNo
ERPDataUpdate eRPDataUpdate = new ERPDataUpdate();
string TB002 = eRPDataUpdate.getTB002(Class.valiballecommon.GetStorage().DocNo); //fix
//string TB002 = eRPDataUpdate.getTF002(Class.valiballecommon.GetStorage().DocNo);//fix disable 22/12/2020
ConvertDataTable convertDataTable = new ConvertDataTable();
ConvertDataERP convertDataERP = new ConvertDataERP();
DataTable dtSFCTC = convertDataERP.GetDataTableSFCTC(dtERPPQC, TB002, "Y");
DataTable dtSFCTB = convertDataERP.GetDataTableSFCTB(dtSFCTC, dtERPPQC, "", "Y");// NO SFT
DataTable dtMOCTG = convertDataERP.GetDataTableMOCTG(dtERPPQC, TB002);
DataTable dtMOCTF = convertDataERP.GetDataTableMOCTF(dtMOCTG, TB002);
if (dtSFCTC.Rows.Count > 0 && dtMOCTG.Rows.Count > 0 && dtMOCTF.Rows.Count > 0)
{
Database.SFC.SFCTC sFCTC = new Database.SFC.SFCTC();
var InsertSFCTC = sFCTC.InsertData(dtSFCTC);
if (InsertSFCTC == false)
{
MessageBox.Show("Insert SFCTC fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.SFC.SFCTB sFCTB = new Database.SFC.SFCTB();
var InsertSFCTB = sFCTB.InsertData(dtSFCTB);
if (InsertSFCTB == false)
{
MessageBox.Show("Insert SFCTB fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.SFC.SFCTA sFCTA = new Database.SFC.SFCTA();
var UpdateSFCTA = sFCTA.UpdateSFCTAForFinishedGoods(dtERPPQC); // UPDATE SO LUONG
if (UpdateSFCTA == false)
{
MessageBox.Show("Insert SFCTA fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.MOC.MOCTG mOCTG = new Database.MOC.MOCTG();
var insertMoctg = mOCTG.InsertData(dtMOCTG);
if (insertMoctg == false)
{
ClassMessageBoxUI.Show("Insert MOCTG fail ", false);
return(false);
}
Database.MOC.MOCTF mOCTF = new Database.MOC.MOCTF();
var insertMOCTF = mOCTF.InsertData(dtMOCTF);
if (insertMOCTF == false)
{
ClassMessageBoxUI.Show("Insert MOCTF fail ", false);
return(false);
}
Database.MOC.MOCTA mOCTA = new Database.MOC.MOCTA();
var updateMOCTA = mOCTA.UpdateMOCTAForFinishedGoods(dtERPPQC);
if (updateMOCTA == false)
{
ClassMessageBoxUI.Show("update MOCTA fail ", false);
return(false);
}
UpdateWarehouseForFinishedGoods updateWarehouseForFinishedGoods = new UpdateWarehouseForFinishedGoods();
var UpdateWarehouse = updateWarehouseForFinishedGoods.UpdateWarehouse(dtERPPQC, TB002);
if (UpdateWarehouse == false)
{
ClassMessageBoxUI.Show("update stock warehouse fail ", false);
}
}
ERPDoc = TB002;
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateData2DBForFinishedGoods(FinishedGoodsItems fgItems)", ex.Message);
ERPDoc = "";
return(false);
}
return(true);
}
/// <summary>
/// [Tuanngoc Dev] For update all data to all department.
/// </summary>
/// <param name="dtERPPQC"></param>
/// <param name="ERPDoc"></param>
/// <returns></returns>
public sql_CheckCondition.QueryResult UpdateDataDBForAllDeparment(DataTable dtERPPQC, out string ERPDoc)
{
ERPDoc = null;
sql_CheckCondition.QueryResult ttReturn = sql_CheckCondition.QueryResult.Exception;
var ischeckSFCTA = false;
try
{
ERPDoc = "";
ERPDataUpdate eRPDataUpdate = new ERPDataUpdate();
string TB002 = eRPDataUpdate.getTB002(Class.valiballecommon.GetStorage().DocNo); // Done update query from Mr.An guidelines.
sql_CheckCondition.QueryResult CheckNoConfirmTotal = sql_CheckCondition.CheckConditionAllItemQRCodeInsert(dtERPPQC);
for (int i = 0; i < dtERPPQC.Rows.Count; i++)
{
string productOrder = dtERPPQC.Rows[i]["ProductOrder"].ToString();
if (!Database.SFC.SFCTA.IsExistSFCTA(productOrder))
{
MessageBox.Show("Please check not exist this product in SFCTA: " + productOrder, "Warning", MessageBoxButtons.OK); /// Consider
break;
}
string product = dtERPPQC.Rows[i]["Product"].ToString().Trim();
double Quantity = double.Parse(dtERPPQC.Rows[i]["Quantity"].ToString());
double SLDongGoi = Database.INV.INVMD.ConvertToWeightKg(product, Quantity); // convert quality to Kg
string WareHouse = dtERPPQC.Rows[i]["Warehouse"].ToString();
///
sql_CheckCondition.QueryResult statusStage = sql_CheckCondition.Is_stageManagement(product);
sql_CheckCondition.QueryResult statusLocationManagement = sql_CheckCondition.Is_LocationManagement(WareHouse);
///
if (statusStage == sql_CheckCondition.QueryResult.OK) // phai quan ly cong doan moi kiem tra
{
ischeckSFCTA = Database.SFC.SFCTA.IscheckQantityAndWeight(productOrder, Quantity, SLDongGoi); // chi cho quan ly cong doan
}
var ischeckMOCTA = Database.MOC.MOCTA.IscheckQantityAndWeight(productOrder, Quantity, SLDongGoi); //
sql_CheckCondition.QueryResult statusLot = sql_CheckCondition.Is_lotManagement(product);
/// stage OK
if (statusStage == sql_CheckCondition.QueryResult.OK && statusLot == sql_CheckCondition.QueryResult.OK && statusLocationManagement == sql_CheckCondition.QueryResult.OK) //_07_111
{
if (ischeckMOCTA == true && ischeckSFCTA == true && CheckNoConfirmTotal == sql_CheckCondition.QueryResult.OK)
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_07(dtERPPQC.Rows[i], i, TB002, true);
}
else
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_07(dtERPPQC.Rows[i], i, TB002, false);
}
}
else if (statusStage == sql_CheckCondition.QueryResult.OK && statusLot == sql_CheckCondition.QueryResult.OK && statusLocationManagement == sql_CheckCondition.QueryResult.NG) ///_06_110
{
if (ischeckMOCTA == true && ischeckSFCTA == true && CheckNoConfirmTotal == sql_CheckCondition.QueryResult.OK)
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_06(dtERPPQC.Rows[i], i, TB002, true);
}
else
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_06(dtERPPQC.Rows[i], i, TB002, false);
}
}
else if (statusStage == sql_CheckCondition.QueryResult.OK && statusLot == sql_CheckCondition.QueryResult.NG && statusLocationManagement == sql_CheckCondition.QueryResult.OK) /// _05_101
{
if (ischeckMOCTA == true && ischeckSFCTA == true && CheckNoConfirmTotal == sql_CheckCondition.QueryResult.OK)
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_05(dtERPPQC.Rows[i], i, TB002, true);
}
else
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_05(dtERPPQC.Rows[i], i, TB002, false);
}
}
else if (statusStage == sql_CheckCondition.QueryResult.OK && statusLot == sql_CheckCondition.QueryResult.NG && statusLocationManagement == sql_CheckCondition.QueryResult.NG) //_04_100
{
if (ischeckMOCTA == true && ischeckSFCTA == true && CheckNoConfirmTotal == sql_CheckCondition.QueryResult.OK)
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_04(dtERPPQC.Rows[i], i, TB002, true);
}
else
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_04(dtERPPQC.Rows[i], i, TB002, false);
}
}
/////////stage NG
else if (statusStage == sql_CheckCondition.QueryResult.NG && statusLot == sql_CheckCondition.QueryResult.OK && statusLocationManagement == sql_CheckCondition.QueryResult.OK) //_03_011
{
if (ischeckMOCTA == true && CheckNoConfirmTotal == sql_CheckCondition.QueryResult.OK)
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_03(dtERPPQC.Rows[i], i, TB002, true);
}
else
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_03(dtERPPQC.Rows[i], i, TB002, false);
}
}
else if (statusStage == sql_CheckCondition.QueryResult.NG && statusLot == sql_CheckCondition.QueryResult.OK && statusLocationManagement == sql_CheckCondition.QueryResult.NG) //_02_010
{
if (ischeckMOCTA == true && CheckNoConfirmTotal == sql_CheckCondition.QueryResult.OK)
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_02(dtERPPQC.Rows[i], i, TB002, true);
}
else
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_02(dtERPPQC.Rows[i], i, TB002, false);
}
}
else if (statusStage == sql_CheckCondition.QueryResult.NG && statusLot == sql_CheckCondition.QueryResult.NG && statusLocationManagement == sql_CheckCondition.QueryResult.OK) //_01_001
{
if (ischeckMOCTA == true && CheckNoConfirmTotal == sql_CheckCondition.QueryResult.OK)
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_01(dtERPPQC.Rows[i], i, TB002, true);
}
else
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_01(dtERPPQC.Rows[i], i, TB002, false);
}
}
else if (statusStage == sql_CheckCondition.QueryResult.NG && statusLot == sql_CheckCondition.QueryResult.NG && statusLocationManagement == sql_CheckCondition.QueryResult.NG) //_00_000
{
if (ischeckMOCTA == true && CheckNoConfirmTotal == sql_CheckCondition.QueryResult.OK)
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_00(dtERPPQC.Rows[i], i, TB002, true);
}
else
{
ttReturn = NewQRcode.sql_QueryFromFileSQL.managestage_managelot_managelocation_00(dtERPPQC.Rows[i], i, TB002, false);
}
}
else
{
ttReturn = sql_CheckCondition.QueryResult.Exception;
}
}
ERPDoc = TB002;
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Exception message", "UpdateDataDBForAllDeparment :" + ex.Message);
return(sql_CheckCondition.QueryResult.Exception);
}
return(ttReturn);
}
public bool UpdateDataDBForFinishedGoodsNotConfirm(DataTable dtERPPQC, string Location, out string ERPDoc, out string SFTDoc)
{
try
{
ERPDoc = "";
SFTDoc = "";
ERPDataUpdate eRPDataUpdate = new ERPDataUpdate();
string TB002 = eRPDataUpdate.getTB002(Class.valiballecommon.GetStorage().DocNo);
SFTDataUpdate sFTDataUpdate = new SFTDataUpdate();
string TransNo = sFTDataUpdate.getTransnoOfSFT(Class.valiballecommon.GetStorage().DocNo);
Database.SFT.SFT_TRANSORDER_LINE sFT_TRANSORDER_LINE = new Database.SFT.SFT_TRANSORDER_LINE();
ConvertDataTable convertDataTable = new ConvertDataTable();
DataTable dtTRANSORDER_LINE = convertDataTable.ERPPQCtoSFTTRANSORDERLINE(dtERPPQC, TransNo, TB002, Location);
DataTable dtTRANSORDER = convertDataTable.GetDataSFTTRANSORDER(dtERPPQC, dtTRANSORDER_LINE);
DataTable dtWSRUN = convertDataTable.GetDataTableSFT_WS_RUN(dtERPPQC, dtTRANSORDER_LINE);
ConvertDataERP convertDataERP = new ConvertDataERP();
DataTable dtSFCTC = convertDataERP.GetDataTableSFCTC(dtERPPQC, TB002, "N"); ////
DataTable dtSFCTB = convertDataERP.GetDataTableSFCTB(dtSFCTC, dtERPPQC, TransNo, "N"); ///
if (dtTRANSORDER_LINE.Rows.Count > 0 && dtTRANSORDER.Rows.Count > 0 && dtWSRUN.Rows.Count > 0 &&
dtSFCTC.Rows.Count > 0 && dtSFCTB.Rows.Count > 0)
{
var Result = sFT_TRANSORDER_LINE.InsertData(dtTRANSORDER_LINE);
if (Result == false)
{
MessageBox.Show("Insert TransOrder_Line fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.SFT.SFT_TRANSORDER sFT_TRANSORDER = new Database.SFT.SFT_TRANSORDER();
var resultTransOrder = sFT_TRANSORDER.InsertData(dtTRANSORDER);
if (resultTransOrder == false)
{
MessageBox.Show("Insert TransOrder fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
int[] sequence = new int[dtERPPQC.Rows.Count];
Database.SFT.SFT_WS_RUN sFT_WS_RUN = new Database.SFT.SFT_WS_RUN();
var resultWs_run = sFT_WS_RUN.InsertData(dtWSRUN, out sequence);
if (resultWs_run == false)
{
MessageBox.Show("Insert SFT_WS_RUN fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.SFT.MODETAIL mODETAIL = new Database.SFT.MODETAIL();
var resultUpdate = mODETAIL.UpdateMODETAIL(dtTRANSORDER_LINE); //MOC027 ko biet la gi ?
if (resultUpdate == false)
{
MessageBox.Show("update Modetail fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.SFT.SFT_LOT sFT_LOT = new Database.SFT.SFT_LOT();
var InsertOrUpdate = sFT_LOT.InsertUpdateLot(dtTRANSORDER_LINE);
if (InsertOrUpdate == false)
{
MessageBox.Show("Insert Lot fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.SFC.SFCTC sFCTC = new Database.SFC.SFCTC(); ///
var InsertSFCTC = sFCTC.InsertData(dtSFCTC); /////
if (InsertSFCTC == false)
{
MessageBox.Show("Insert SFCTC fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.SFC.SFCTB sFCTB = new Database.SFC.SFCTB(); /////
var InsertSFCTB = sFCTB.InsertData(dtSFCTB);
if (InsertSFCTB == false)
{
MessageBox.Show("Insert SFCTB fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.SFC.SFCTA sFCTA = new Database.SFC.SFCTA(); /////
var UpdateSFCTA = sFCTA.UpdateSFCTAForFinishedGoodsNotConfirm(dtERPPQC);
if (UpdateSFCTA == false)
{
MessageBox.Show("Insert SFCTA fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.ERPSOFT.ERPOutPQCQR eRPOutPQCQR = new Database.ERPSOFT.ERPOutPQCQR(); ////function kho
var updateOutPQC = eRPOutPQCQR.UpdateImportWarehouse(dtERPPQC, Class.valiballecommon.GetStorage().DocNo + "-" + TB002);
if (updateOutPQC == false)
{
MessageBox.Show("Insert import status fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
ERPDoc = TB002;
SFTDoc = TransNo;
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateData2DBForFinishedGoods(FinishedGoodsItems fgItems)", ex.Message);
ERPDoc = "";
SFTDoc = "";
return(false);
}
return(true);
}
public bool UpdateDataDBForFinishedGoods(FinishedGoodsItems fgItems, out string ERPDoc, out string SFTDoc)
{
try
{
GetdataSFTToDataTable getdataSFTToDataTable = new GetdataSFTToDataTable();
DataTable dtLotMODETAL = getdataSFTToDataTable.GetDataTableLOTMODETAIL(fgItems.productCode);
ERPDataUpdate eRPDataUpdate = new ERPDataUpdate();
string TB002 = eRPDataUpdate.getTB002(Class.valiballecommon.GetStorage().DocNo);
SFTDataUpdate sFTDataUpdate = new SFTDataUpdate();
string TransNo = sFTDataUpdate.getTransnoOfSFT(Class.valiballecommon.GetStorage().DocNo);
Database.ADMMFUpdate aDMMF = new ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
var Update2SFT = sFTDataUpdate.SFTdataUpdate(fgItems, dtLotMODETAL, TB002, TransNo);
if (Update2SFT == false)
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "sFTDataUpdate.SFTdataUpdate(fgItems, TB002, TransNo)", "false");
}
else
{
SystemLog.Output(SystemLog.MSG_TYPE.War, Class.valiballecommon.GetStorage().DocNo + "-" + TransNo + " is created !", "");
}
var Update2ERP = eRPDataUpdate.UploadtoERPDBForFinishedGoods(fgItems, dtADMMF, dtLotMODETAL, TB002, TransNo);
if (Update2ERP == false)
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "eRPDataUpdate.UploadtoERPDBForFinishedGoods(fgItems, TB002, TransNo)", "false");
}
else
{
SystemLog.Output(SystemLog.MSG_TYPE.War, Class.valiballecommon.GetStorage().DocNo + "-" + TB002 + " is created !", "");
}
Database.Model.INVItems iNVItems = new Database.Model.INVItems();
iNVItems.Product = fgItems.product;
iNVItems.ProductCode = fgItems.productCode;
iNVItems.Lot = fgItems.lot;
iNVItems.Create_Date = fgItems.ImportDate;
iNVItems.TypeDoccument = Class.valiballecommon.GetStorage().DocNo;
iNVItems.DoccumentNo = TB002;
iNVItems.STTDoc = "0001";
iNVItems.Warehouse = fgItems.Warehouse;
iNVItems.TypeInportExport = "1";
iNVItems.TypeChange = "1";
iNVItems.Quantity = fgItems.TotalQty;
iNVItems.PackageQty = 0;
iNVItems.Note = iNVItems.ProductCode;
iNVItems.Location = fgItems.location;
iNVItems.ImportDate = fgItems.ImportDate;
iNVItems.MainLocation = fgItems.location;
Database.INVMFUpdate iNVMFUpdate = new INVMFUpdate();
var UpdateINVMF = iNVMFUpdate.InsertINVMF(iNVItems, dtADMMF);
Database.INVMEUpdate iNVMEUpdate = new INVMEUpdate();
var UpdateINVME = iNVMEUpdate.InsertINVME(iNVItems, dtADMMF);
INVLAUpdate iNVLAUpdate = new INVLAUpdate();
var UpdateINVLA = iNVLAUpdate.InsertINVLA(iNVItems, dtADMMF);
INVLFUpdate iNVLFUpdate = new INVLFUpdate();
var UpdateINVLF = iNVLFUpdate.InsertINVLF(iNVItems, dtADMMF);
INVMCUpdate iNVMCUpdate = new INVMCUpdate();
var UpdateINVMC = iNVMCUpdate.UpdateOrInsertINVMC(iNVItems, dtADMMF);
INVMMUpdate iNVMMUpdate = new INVMMUpdate();
var UpdateINVMM = iNVMMUpdate.UpdateOrInsertINVMM(iNVItems, dtADMMF);
ERPDoc = TB002;
SFTDoc = TransNo;
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateData2DBForFinishedGoods(FinishedGoodsItems fgItems)", ex.Message);
ERPDoc = "";
SFTDoc = "";
return(false);
}
return(true);
}
