public bool UpdateWarehouse(DataTable dtERPPQC, string TB002)
{
try
{
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
for (int i = 0; i < dtERPPQC.Rows.Count; i++)
{
Database.Model.INVItems iNVItems = new Database.Model.INVItems();
iNVItems.Product = dtERPPQC.Rows[i]["Product"].ToString().Trim();
iNVItems.ProductCode = dtERPPQC.Rows[i]["ProductOrder"].ToString().Trim();
iNVItems.Lot = dtERPPQC.Rows[i]["LotNo"].ToString().Trim();
iNVItems.Create_Date = DateTime.Now;
iNVItems.TypeDoccument = Class.valiballecommon.GetStorage().DocNo;
iNVItems.DoccumentNo = TB002; // DEM LEN TU BANG SFCTB TB002
iNVItems.STTDoc = dtERPPQC.Rows[i]["STT"].ToString().Trim(); /// NO 0001->
iNVItems.Warehouse = dtERPPQC.Rows[i]["Warehouse"].ToString().Trim();
iNVItems.TypeInportExport = "1";
iNVItems.TypeChange = "1";
iNVItems.Quantity = double.Parse(dtERPPQC.Rows[i]["Quantity"].ToString());
double SLDongGoi = Database.INV.INVMD.ConvertToWeightKg(dtERPPQC.Rows[i]["Product"].ToString().Trim(), double.Parse(dtERPPQC.Rows[i]["Quantity"].ToString()));
iNVItems.PackageQty = SLDongGoi;
iNVItems.Note = dtERPPQC.Rows[i]["ProductOrder"].ToString().Trim();
iNVItems.Location = dtERPPQC.Rows[i]["Location"].ToString().Trim();
iNVItems.ImportDate = DateTime.Now;
iNVItems.MainLocation = dtERPPQC.Rows[i]["Location"].ToString().Trim();
iNVItems.ImportQR = null;// dtERPPQC.Rows[i]["KeyID"].ToString().Trim() +"-"+ dtERPPQC.Rows[i]["KeyNo"].ToString().Trim();
Database.INVMFUpdate iNVMFUpdate = new Database.INVMFUpdate();
var UpdateINVMF = iNVMFUpdate.InsertINVMF(iNVItems, dtADMMF);
Database.INVMEUpdate iNVMEUpdate = new Database.INVMEUpdate();
var UpdateINVME = iNVMEUpdate.InsertOrUpdate(iNVItems, dtADMMF);
Database.INVLAUpdate iNVLAUpdate = new Database.INVLAUpdate();
var UpdateINVLA = iNVLAUpdate.InsertINVLA(iNVItems, dtADMMF);
Database.INVLFUpdate iNVLFUpdate = new Database.INVLFUpdate();
var UpdateINVLF = iNVLFUpdate.InsertINVLF(iNVItems, dtADMMF);
Database.INVMCUpdate iNVMCUpdate = new Database.INVMCUpdate();
var UpdateINVMC = iNVMCUpdate.UpdateOrInsertINVMC(iNVItems, dtADMMF);
Database.INV.INVMB iNVMB = new Database.INV.INVMB();
var UpdateINVMB = iNVMB.UpdateINVMBbyProduct(iNVItems);
Database.INVMMUpdate iNVMMUpdate = new Database.INVMMUpdate();
var UpdateINVMM = iNVMMUpdate.UpdateOrInsertINVMM(iNVItems, dtADMMF);
if ((UpdateINVMF && UpdateINVLA && UpdateINVLF && UpdateINVMC && UpdateINVMM) == false)
{
return(false);
}
}
return(true);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateWarehouse", ex.Message);
return(false);
}
}
public bool UpdateWarehouse(DataTable COPTH, DataTable dtExport)
{
try
{
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
for (int i = 0; i < COPTH.Rows.Count; i++)
{
Database.Model.INVItems iNVItems = new Database.Model.INVItems();
iNVItems.Product = COPTH.Rows[i]["TH004"].ToString().Trim();
iNVItems.ProductCode = "";
iNVItems.Lot = dtExport.Rows[i]["LotNo"].ToString().Trim();
iNVItems.Create_Date = DateTime.Now;
iNVItems.TypeDoccument = COPTH.Rows[i]["TH001"].ToString().Trim();
iNVItems.DoccumentNo = COPTH.Rows[i]["TH002"].ToString().Trim();
iNVItems.STTDoc = COPTH.Rows[i]["TH003"].ToString().Trim();
iNVItems.Warehouse = dtExport.Rows[i]["Warehouse"].ToString().Trim();
iNVItems.TypeInportExport = "-1";
iNVItems.TypeChange = "2";
iNVItems.Quantity = double.Parse(COPTH.Rows[i]["TH008"].ToString().Trim());
double SLDongGoi = Database.INV.INVMD.ConvertToWeightKg(COPTH.Rows[i]["TH004"].ToString().Trim(), double.Parse(COPTH.Rows[i]["TH008"].ToString().Trim()));
iNVItems.PackageQty = SLDongGoi;
iNVItems.Note = "";
iNVItems.Location = dtExport.Rows[i]["Location"].ToString().Trim();
iNVItems.ImportDate = DateTime.Now;
iNVItems.MainLocation = dtExport.Rows[i]["Location"].ToString().Trim();
Database.INVMFUpdate iNVMFUpdate = new Database.INVMFUpdate();
var UpdateINVMF = iNVMFUpdate.InsertINVMF(iNVItems, dtADMMF);
Database.INVMEUpdate iNVMEUpdate = new Database.INVMEUpdate();
var UpdateINVME = iNVMEUpdate.InsertOrUpdate(iNVItems, dtADMMF);
Database.INVLAUpdate iNVLAUpdate = new Database.INVLAUpdate();
var UpdateINVLA = iNVLAUpdate.InsertINVLA(iNVItems, dtADMMF);
Database.INVLFUpdate iNVLFUpdate = new Database.INVLFUpdate();
var UpdateINVLF = iNVLFUpdate.InsertINVLF(iNVItems, dtADMMF);
Database.INVMCUpdate iNVMCUpdate = new Database.INVMCUpdate();
var UpdateINVMC = iNVMCUpdate.UpdateOrInsertINVMC(iNVItems, dtADMMF);
Database.INV.INVMB iNVMB = new Database.INV.INVMB();
var UpdateINVMB = iNVMB.UpdateINVMBbyProduct(iNVItems);
Database.INVMMUpdate iNVMMUpdate = new Database.INVMMUpdate();
var UpdateINVMM = iNVMMUpdate.UpdateOrInsertINVMM(iNVItems, dtADMMF);
if ((UpdateINVMF && UpdateINVLA && UpdateINVLF && UpdateINVMC && UpdateINVMM) == false)
{
return(false);
}
}
return(true);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateWarehouse", ex.Message);
return(false);
}
}
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);
}
