public bool InsertOrUpdateSFCTA(FinishedGoodsItems fgItems)
{
try
{
CheckExtinctRowInTable checkExtinctRowInTable = new CheckExtinctRowInTable();
if (checkExtinctRowInTable.CheckExstinctRowSFCTA(fgItems.productCode, "0020"))
{
//Update
UpdateSFCTAForFinishedGoods(fgItems, "0020");
}
else
{
//Insert
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "InsertOrUpdateSFCTA(FinishedGoodsItems fgItems)", ex.Message);
return(false);
}
return(true);
}
public bool UpdateSFCTAForFinishedGoods(FinishedGoodsItems fgItems, string TA003)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" update SFCTA ");
stringBuilder.Append(" set MODIFIER = '" + Class.valiballecommon.GetStorage().UserName + "', ");
stringBuilder.Append(" MODI_DATE = '" + DateTime.Now.ToString("yyyyMMdd") + "', ");
stringBuilder.Append(" FLAG = FLAG+1 , ");
stringBuilder.Append(" MODI_TIME = '" + DateTime.Now.ToString("HH:mm:ss") + "' ,");
stringBuilder.Append(" MODI_AP = '" + "SFT" + "' ,");
stringBuilder.Append(" MODI_PRID = '" + "Sftb03" + "' ,");
stringBuilder.Append(" TA017 = TA017 + " + fgItems.TotalQty + " ,");
stringBuilder.Append(" TA045 = TA045 +" + (fgItems.TotalQty * 0).ToString() + " ");
stringBuilder.Append(" where TA001 ='" + fgItems.productCode.Split('-')[0] + "' ");
stringBuilder.Append(" and TA002 ='" + fgItems.productCode.Split('-')[1] + "' ");
stringBuilder.Append(" and TA003 ='" + TA003 + "' ");
SqlTLVN2 sqlTLVN2 = new SqlTLVN2();
var result = sqlTLVN2.sqlExecuteNonQuery(stringBuilder.ToString(), false);
if (result == false)
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "UpdateSFCTAForFinishedGoods(FinishedGoodsItems fgItems)", "");
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateSFCTAForFinishedGoods(FinishedGoodsItems fgItems, string TA003)", ex.Message);
}
return(false);
}
public bool UploadtoERPDBForFinishedGoods(FinishedGoodsItems fgItems, DataTable dtADMMF, DataTable dtLotMODETAIL, string TB002, string TransNo)
{
try
{
if (fgItems != null)
{
GetDataERPTable getDataERPTable = new GetDataERPTable();
DataTable dtSFCTA = getDataERPTable.GetDataTableSFCTA(fgItems.productCode);
var InsertSFCTC = InsertSFCTCForFinishedGoods(fgItems, dtADMMF, dtSFCTA, dtLotMODETAIL, TB002);
if (InsertSFCTC == false)
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "InsertSFCTCForFinishedGoods(fgItems, TB002))", "False");
}
var InsertSFCTB = InsertSFCTBForFinishedGoods(fgItems, dtADMMF, dtSFCTA, dtLotMODETAIL, TransNo, TB002);
if (InsertSFCTB == false)
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "InsertSFCTBForFinishedGoods(fgItems, TransNo, TB002)", "False");
}
var InsertOrUpdate = InsertOrUpdateSFCTA(fgItems);
if (InsertOrUpdate == false)
{
SystemLog.Output(SystemLog.MSG_TYPE.War, "InsertOrUpdateSFCTA(fgItems)", "false");
}
if (InsertSFCTC && InsertSFCTB && InsertOrUpdate)
{
return(true);
}
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UploadtoERPDBForFinishedGoods(FinishedGoodsItems fgItems)", ex.Message);
return(false);
}
return(false);
}
public bool InsertSFCTCForFinishedGoods(FinishedGoodsItems fgItems, DataTable dtADMMF, DataTable dtSFCTA, DataTable dtMODELLOT, string TB002)
{
try
{
GetDataERPTable getDataERPTable = new GetDataERPTable();
DataTable dtHeader = getDataERPTable.GetDataTableSFCTC();
StringBuilder stringBuilder = new StringBuilder();
StringBuilder stringFun = new StringBuilder();
stringBuilder.Append(" insert into SFCTC ( ");
for (int i = 0; i < dtHeader.Columns.Count; i++)
{
if (i < dtHeader.Columns.Count - 1)
{
stringBuilder.Append(dtHeader.Columns[i].ColumnName + ",");
}
else
{
stringBuilder.Append(dtHeader.Columns[i].ColumnName + ") values ( ");
}
}
if (dtHeader != null && dtHeader.Rows.Count == 1)
{
for (int j = 0; j < dtHeader.Columns.Count; j++)
{
string valueCell = "";
if (dtHeader.Columns[j].ColumnName == "COMPANY")
{
valueCell = dtSFCTA.Rows[0]["COMPANY"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "CREATOR")
{
valueCell = Class.valiballecommon.GetStorage().UserName;
}
else if (dtHeader.Columns[j].ColumnName == "USR_GROUP")
{
valueCell = dtADMMF.Rows[0]["MF004"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "CREATE_DATE")
{
valueCell = DateTime.Now.ToString("yyyyMMdd");
}
else if (dtHeader.Columns[j].ColumnName == "FLAG")
{
valueCell = "1";
}
else if (dtHeader.Columns[j].ColumnName == "CREATE_TIME")
{
valueCell = DateTime.Now.ToString("HH:mm:ss");
}
else if (dtHeader.Columns[j].ColumnName == "MODIFIER")
{
valueCell = "NULL";
}
else if (dtHeader.Columns[j].ColumnName == "MODI_DATE")
{
valueCell = "NULL";
}
else if (dtHeader.Columns[j].ColumnName == "CREATE_AP")
{
valueCell = "SFT";
}
else if (dtHeader.Columns[j].ColumnName == "CREATE_PRID")
{
valueCell = "Sftb03";
}
else if (dtHeader.Columns[j].ColumnName == "TC001")
{
valueCell = Class.valiballecommon.GetStorage().DocNo;
}
else if (dtHeader.Columns[j].ColumnName == "TC002")
{
valueCell = TB002;
}
else if (dtHeader.Columns[j].ColumnName == "TC003")
{
valueCell = "0001";
}
else if (dtHeader.Columns[j].ColumnName == "TC004")
{
valueCell = fgItems.productCode.Split('-')[0];
}
else if (dtHeader.Columns[j].ColumnName == "TC005")
{
valueCell = fgItems.productCode.Split('-')[1];
}
else if (dtHeader.Columns[j].ColumnName == "TC006")
{
valueCell = "0020";
}
else if (dtHeader.Columns[j].ColumnName == "TC007")
{
valueCell = dtSFCTA.Rows[0]["TA004"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TC010")
{
valueCell = dtSFCTA.Rows[0]["TA020"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TC013")
{
valueCell = "1";
}
else if (dtHeader.Columns[j].ColumnName == "TC014")
{
valueCell = fgItems.TotalQty.ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TC015")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC016")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC017")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC018")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC019")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC020")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC021")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC022")
{
valueCell = "Y";
}
else if (dtHeader.Columns[j].ColumnName == "TC023")
{
valueCell = dtSFCTA.Rows[0]["TA006"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TC025")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC026")
{
valueCell = "N";
}
else if (dtHeader.Columns[j].ColumnName == "TC027")
{
valueCell = "N";
}
else if (dtHeader.Columns[j].ColumnName == "TC035")
{
valueCell = "N";
}
else if (dtHeader.Columns[j].ColumnName == "TC036")
{
valueCell = fgItems.TotalQty.ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TC037")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC038")
{
valueCell = DateTime.Now.ToString("yyyyMMdd");
}
else if (dtHeader.Columns[j].ColumnName == "TC039")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC041")
{
valueCell = fgItems.INDEPID;
}
else if (dtHeader.Columns[j].ColumnName == "TC042")
{
valueCell = (double.Parse(dtMODELLOT.Rows[0]["PKQTYPER"].ToString()) * fgItems.TotalQty).ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TC043")
{
valueCell = (double.Parse(dtMODELLOT.Rows[0]["PKQTYPER"].ToString()) * fgItems.TotalQty).ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TC044")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC045")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC046")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC047")
{
valueCell = fgItems.product;
}
else if (dtHeader.Columns[j].ColumnName == "TC048")
{
valueCell = dtMODELLOT.Rows[0]["MO021"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TC050")
{
valueCell = dtMODELLOT.Rows[0]["PKUNIT"].ToString(); //cai nay lay o dau
}
else if (dtHeader.Columns[j].ColumnName == "TC051")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC052")
{
valueCell = fgItems.location;
}
else if (dtHeader.Columns[j].ColumnName == "TC053")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC054")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TC055")
{
valueCell = "N";
}
else if (dtHeader.Columns[j].ColumnName == "TC060")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF06")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF07")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF08")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF09")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF10")
{
valueCell = "0";
}
if (j < dtHeader.Columns.Count - 1)
{
if (valueCell == "NULL")
{
stringFun.Append(" " + valueCell + " ,");
}
else
{
stringFun.Append(" '" + valueCell + "',");
}
}
else
{
if (valueCell == "NULL")
{
stringFun.Append(" " + valueCell + ")");
}
else
{
stringFun.Append(" '" + valueCell + "')");
}
}
}
string sqlInsert = stringBuilder.ToString() + stringFun.ToString();
SqlTLVN2 sqlTLVN2 = new SqlTLVN2();
if (sqlTLVN2.sqlExecuteNonQuery(sqlInsert, false) == false)
{
//MessageBox.Show("Insert SFT_TRANSORDER fail", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
return(true);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, " InsertSFCTCForFinishedGoods(FinishedGoodsItems fgItems)", ex.Message);
}
return(false);
}
public bool InsertSFCTBForFinishedGoods(FinishedGoodsItems fgItems, DataTable dtADMMF, DataTable dtSFCTA, DataTable dtMODELLOT, string TransNo, string TB002)
{
try
{
GetDataERPTable getDataERPTable = new GetDataERPTable();
DataTable dtHeader = getDataERPTable.GetDataTableSFCTB();
StringBuilder stringBuilder = new StringBuilder();
StringBuilder stringFun = new StringBuilder();
stringBuilder.Append(" insert into SFCTB ( ");
for (int i = 0; i < dtHeader.Columns.Count - 1; i++)
{
if (i < dtHeader.Columns.Count - 2)
{
if (dtHeader.Columns[i].ColumnName != "CFIELD01")
{
stringBuilder.Append(dtHeader.Columns[i].ColumnName + ",");
}
}
else
{
stringBuilder.Append(dtHeader.Columns[i].ColumnName + ") values ( ");
}
}
if (dtHeader != null && dtHeader.Rows.Count == 1)
{
for (int j = 0; j < dtHeader.Columns.Count - 1; j++)
{
string valueCell = "";
if (dtHeader.Columns[j].ColumnName == "COMPANY")
{
valueCell = dtSFCTA.Rows[0]["COMPANY"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "CREATOR")
{
valueCell = Class.valiballecommon.GetStorage().UserName;
}
else if (dtHeader.Columns[j].ColumnName == "USR_GROUP")
{
valueCell = dtADMMF.Rows[0]["MF004"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "CREATE_DATE")
{
valueCell = DateTime.Now.ToString("yyyyMMdd");
}
else if (dtHeader.Columns[j].ColumnName == "FLAG")
{
valueCell = "1";
}
else if (dtHeader.Columns[j].ColumnName == "CREATE_TIME")
{
valueCell = DateTime.Now.ToString("HH:mm:ss");
}
else if (dtHeader.Columns[j].ColumnName == "CREATE_AP")
{
valueCell = "SFT";
}
else if (dtHeader.Columns[j].ColumnName == "CREATE_PRID")
{
valueCell = "Sftb03";
}
else if (dtHeader.Columns[j].ColumnName == "TB001")
{
valueCell = Class.valiballecommon.GetStorage().DocNo;
}
else if (dtHeader.Columns[j].ColumnName == "TB002")
{
valueCell = TB002;
}
else if (dtHeader.Columns[j].ColumnName == "TB003")
{
valueCell = DateTime.Now.ToString("yyyyMMdd");
}
else if (dtHeader.Columns[j].ColumnName == "TB004")
{
valueCell = "1";
}
else if (dtHeader.Columns[j].ColumnName == "TB005")
{
valueCell = dtSFCTA.Rows[0]["TA006"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TB006")
{
valueCell = dtSFCTA.Rows[0]["TA007"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TB007")
{
valueCell = "3";
}
else if (dtHeader.Columns[j].ColumnName == "TB008")
{
valueCell = fgItems.INDEPID;
}
else if (dtHeader.Columns[j].ColumnName == "TB009")
{
valueCell = fgItems.INDEPNAME; // Ten kho den
}
else if (dtHeader.Columns[j].ColumnName == "TB010")
{
valueCell = dtMODELLOT.Rows[0]["FACTORYID"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TB011")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB012")
{
valueCell = "N";
}
else if (dtHeader.Columns[j].ColumnName == "TB013")
{
valueCell = "Y";
}
else if (dtHeader.Columns[j].ColumnName == "TB014")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "TB015")
{
valueCell = DateTime.Now.ToString("yyyyMMdd");
}
else if (dtHeader.Columns[j].ColumnName == "TB016")
{
valueCell = Class.valiballecommon.GetStorage().UserName;
}
else if (dtHeader.Columns[j].ColumnName == "TB017")
{
valueCell = "N";
}
else if (dtHeader.Columns[j].ColumnName == "TB018")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "TB019")
{
valueCell = "1";
}
else if (dtHeader.Columns[j].ColumnName == "TB022")
{
valueCell = "1";
}
else if (dtHeader.Columns[j].ColumnName == "TB023")
{
valueCell = "1";
}
else if (dtHeader.Columns[j].ColumnName == "TB025")
{
valueCell = DateTime.Now.ToString("yyyyMM");
}
else if (dtHeader.Columns[j].ColumnName == "TB026")
{
valueCell = "0.2";
}
else if (dtHeader.Columns[j].ColumnName == "TB027")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB029")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB030")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB031")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB036")
{
valueCell = dtSFCTA.Rows[0]["TA018"].ToString();
}
else if (dtHeader.Columns[j].ColumnName == "TB037")
{
valueCell = "1";
}
else if (dtHeader.Columns[j].ColumnName == "TB038")
{
valueCell = Class.valiballecommon.GetStorage().DocNo;
}
else if (dtHeader.Columns[j].ColumnName == "TB039")
{
valueCell = TransNo;
}
else if (dtHeader.Columns[j].ColumnName == "UDF06")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF07")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF08")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF09")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "UDF10")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB200")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB201")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB202")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "TB042")
{
valueCell = "";
}
//if (j < dtHeader.Columns.Count - 1)
//{
// if (dtHeader.Columns[j].ColumnName != "CFIELD01")
// stringFun.Append(" '" + valueCell + "',");
//}
//else stringFun.Append("'" + valueCell + "')");
if (j < dtHeader.Columns.Count - 2)
{
if (valueCell == "NULL")
{
stringFun.Append(" " + valueCell + " ,");
}
else
{
stringFun.Append(" '" + valueCell + "',");
}
}
else
{
if (valueCell == "NULL")
{
stringFun.Append(" " + valueCell + " )");
}
else
{
stringFun.Append(" '" + valueCell + "')");
}
}
}
string sqlInsert = stringBuilder.ToString() + stringFun.ToString();
SqlTLVN2 sqlTLVN2 = new SqlTLVN2();
if (sqlTLVN2.sqlExecuteNonQuery(sqlInsert, false) == false)
{
//MessageBox.Show("Insert SFT_TRANSORDER fail", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
return(true);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, " InsertSFCTCForFinishedGoods(FinishedGoodsItems fgItems)", 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);
}
