public bool UpdateSFTStatusIntoWH(DataTable dtERPPQC) { try { if (dtERPPQC.Rows.Count == 0) { return(false); } ConvertDataTable convertDataTable = new ConvertDataTable(); int[] OutSequence = new int[dtERPPQC.Rows.Count]; DataTable dtWSRUN = convertDataTable.GetDataTableSFT_WS_RUNPendingWH(dtERPPQC); if (dtWSRUN.Rows.Count == 0) { MessageBox.Show("data convert WS_RUN_PENDING WareHouse is fail", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } Database.SFT.SFT_WS_RUN sFT_WS_RUN = new Database.SFT.SFT_WS_RUN(); var InsertWsRun = sFT_WS_RUN.InsertData(dtWSRUN, out OutSequence); Database.SFT.SFT_LOT sFT_LOT = new Database.SFT.SFT_LOT(); var InsertorUpdateLot = sFT_LOT.InsertOrUpdateIntoWH(dtERPPQC); Database.SFT.SFT_OP_REALRUN sFT_OP_REALRUN = new Database.SFT.SFT_OP_REALRUN(); var insertorUpdateREALRUN = sFT_OP_REALRUN.UpdateOrInsert(dtERPPQC, OutSequence); if (InsertWsRun && InsertorUpdateLot && insertorUpdateREALRUN) { return(true); } else { MessageBox.Show("Insert data for pending warehouse fail", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } } catch (Exception EX) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateSFTStatusIntoWH(DataTable dtERPPQC)", EX.Message); } return(false); }
public DataTable GetDataTableSFT_WS_RUNPendingWH(DataTable ERPPQC) { DataTable dt = new DataTable(); int[] OutSequence = new int[ERPPQC.Rows.Count]; try { Database.SFT.SFT_WS_RUN sFT_WS_RUN = new Database.SFT.SFT_WS_RUN(); dt = sFT_WS_RUN.GetTop1DataTable(); if (ERPPQC.Rows.Count > 1) { for (int i = 1; i < ERPPQC.Rows.Count; i++) { var newRow = dt.NewRow(); dt.Rows.Add(newRow); } } for (int i = 0; i < dt.Rows.Count; i++) { string PO = ERPPQC.Rows[i]["ProductOrder"].ToString(); DataTable dtLot = Database.SFT.SFT_LOT.GetDataTableLot(PO); dt.Rows[i]["WSID"] = "B01"; dt.Rows[i]["OPID"] = "B02---B01"; dt.Rows[i]["ID"] = ERPPQC.Rows[i]["ProductOrder"].ToString(); var Sequence = GgetSequenceCountupSFT_WS_RUN(ERPPQC.Rows[i]["ProductOrder"].ToString()); OutSequence[i] = Sequence; dt.Rows[i]["SEQUENCE"] = Sequence; dt.Rows[i]["EXECUTENAME"] = ""; dt.Rows[i]["EXECUTETIME"] = DateTime.Now; dt.Rows[i]["EXECUTETYPE"] = "IntoStockIn"; dt.Rows[i]["ROUTESEQUENCE"] = DBNull.Value; dt.Rows[i]["STEPSEQUENCE"] = DBNull.Value; dt.Rows[i]["ALTSTEPSEQUENCE"] = DBNull.Value; dt.Rows[i]["OPSEQUENCE"] = DBNull.Value; dt.Rows[i]["EXECUTEQTY"] = ERPPQC.Rows[i]["Quantity"]; dt.Rows[i]["USERID"] = Class.valiballecommon.GetStorage().UserName; dt.Rows[i]["QTYPERUNIT"] = 0; dt.Rows[i]["UNIT"] = dtLot.Rows[0]["UNIT"].ToString(); dt.Rows[i]["QTYPER"] = 1; dt.Rows[i]["PLUSINDEX"] = "0"; dt.Rows[i]["ERP_OPSEQ"] = "0020"; dt.Rows[i]["ERP_OPID"] = "B02"; dt.Rows[i]["ERP_WSID"] = "B01"; dt.Rows[i]["PKQTY"] = double.Parse(ERPPQC.Rows[i]["Quantity"].ToString()) * double.Parse(dtLot.Rows[0]["PKQTYPER"].ToString()); dt.Rows[i]["PKQTYPER"] = dtLot.Rows[0]["PKQTYPER"]; dt.Rows[i]["PKUNIT"] = dtLot.Rows[0]["PKUNIT"]; dt.Rows[i]["WR001"] = -1; dt.Rows[i]["WR002"] = ""; dt.Rows[i]["WR003"] = DBNull.Value; dt.Rows[i]["WR004"] = ERPPQC.Rows[i]["Quantity"]; dt.Rows[i]["WR005"] = ERPPQC.Rows[i]["Quantity"]; dt.Rows[i]["WR006"] = 0; dt.Rows[i]["WR007"] = "0020"; dt.Rows[i]["WR008"] = "B02"; dt.Rows[i]["WR009"] = "B01"; dt.Rows[i]["WR010"] = 0; dt.Rows[i]["WR011"] = 0; //dt.Rows[i]["WR013"] = -1; dt.Rows[i]["WR014"] = 1; dt.Rows[i]["WR015"] = 1; dt.Rows[i]["WR016"] = 0; dt.Rows[i]["WR017"] = DBNull.Value; dt.Rows[i]["WR018"] = DBNull.Value; dt.Rows[i]["WR019"] = DBNull.Value; dt.Rows[i]["WR021"] = Class.valiballecommon.GetStorage().UserName; dt.Rows[i]["WR023"] = DBNull.Value; dt.Rows[i]["CREATE_DATE"] = DateTime.Now; dt.Rows[i]["WR029"] = "1"; dt.Rows[i]["WR030"] = 1; dt.Rows[i]["WR031"] = 0; dt.Rows[i]["WR032"] = 0; dt.Rows[i]["WR036"] = 0; } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, " public DataTable GetDataSFTTRANSORDER(DataTable ERPPQC, DataTable TRANSORDERLINE)", ex.Message); dt = new DataTable(); } return(dt); }
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); }