public DataTable GetDataSFTTRANSORDER(DataTable ERPPQC, DataTable TRANSORDERLINE)
{
DataTable dt = new DataTable();
try
{
Database.SFT.SFT_TRANSORDER sFT_TRANSORDER = new Database.SFT.SFT_TRANSORDER();
dt = sFT_TRANSORDER.GetTop1DataTable();
Database.GetListWarehouse getListWarehouse = new Database.GetListWarehouse();
List <Database.WarehouseItems> listWarehouse = getListWarehouse.GetWarehouseOnly();
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["CREATER"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["CREATE_DATE"] = DateTime.Now;
dt.Rows[i]["MODI_DATE"] = DBNull.Value;
dt.Rows[i]["FLAG"] = 0;
dt.Rows[i]["TRANSTYPE"] = TRANSORDERLINE.Rows[0]["TRANSORDERTYPE"];
dt.Rows[i]["TRANSNO"] = TRANSORDERLINE.Rows[0]["TRANSNO"];
dt.Rows[i]["TRANSDATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["OUTTYPE"] = "1";
dt.Rows[i]["OUTDEPID"] = TRANSORDERLINE.Rows[0]["OUTDEP"];
dt.Rows[i]["OUTDEPNAME"] = "胶管OEM生产线ONGOEM";
dt.Rows[i]["INTYPE"] = "3";
dt.Rows[i]["INDEPID"] = TRANSORDERLINE.Rows[0]["INDEP"];
dt.Rows[i]["INDEPNAME"] = listWarehouse.Where(d => d.MC001_Wh.Contains(TRANSORDERLINE.Rows[0]["INDEP"].ToString())).Select(d => d.MC002_WhName).ToList()[0];
dt.Rows[i]["FACTORYID"] = TRANSORDERLINE.Rows[0]["FACTORYID"];
dt.Rows[i]["CONFIRMCODE"] = "Y";
dt.Rows[i]["DOCUMENTDATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["VENDORNO"] = "";
dt.Rows[i]["INVOICECOUNT"] = 1;
dt.Rows[i]["TAXATIONTYPE"] = 1;
dt.Rows[i]["DISCOUNTDEVIDE"] = 1;
dt.Rows[i]["DECLARATIONDATE"] = DateTime.Now.ToString("yyyyMM");
dt.Rows[i]["SALESTAXRATE"] = 0.2;
dt.Rows[i]["COMPANYID"] = "TLVN2";// qua serverchinh co the phai doi
dt.Rows[i]["KEYID"] = TRANSORDERLINE.Rows[0]["KEYID"];
dt.Rows[i]["STOCKINTYPE"] = 1;
dt.Rows[i]["TO001"] = 1;
dt.Rows[i]["TO007"] = TRANSORDERLINE.Rows[0]["TL011"];
dt.Rows[i]["TO008"] = TRANSORDERLINE.Rows[0]["TL012"];
dt.Rows[i]["TO011"] = 0;
dt.Rows[i]["TO012"] = 0;
dt.Rows[i]["COINSTYPE"] = "VND";
dt.Rows[i]["CONFIRMER"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["TO013"] = 1;
dt.Rows[i]["TO014"] = DBNull.Value;
dt.Rows[i]["TO015"] = DBNull.Value;
}
}
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);
}
