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