public bool CheckExistINVMM(Model.INVItems iNVItems)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select * from INVMM ");
stringBuilder.Append(" where 1=1 ");
stringBuilder.Append(" and MM001 = '" + iNVItems.Product + "' ");
stringBuilder.Append(" and MM002 = '" + iNVItems.Warehouse + "' ");
stringBuilder.Append(" and MM003 = '" + iNVItems.Location + "' ");
stringBuilder.Append(" and MM004 = '" + iNVItems.Lot + "' ");
SqlTLVN2 sqlTLVN2 = new SqlTLVN2();
DataTable dt = new DataTable();
sqlTLVN2.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "CheckExistINVMM(Model.INVItems iNVItems)", ex.Message);
return(false);
}
}
public bool UpdateINVME(Model.INVItems iNVItems, DataTable dtCommonERP)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" update INVME ");
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 = '" + "MOCI05" + "' ");
stringBuilder.Append(" where ME001 ='" + iNVItems.Product + "' ");
stringBuilder.Append(" and ME002 ='" + iNVItems.Lot + "' ");
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 InsertOrUpdate(Model.INVItems iNVItems, DataTable dtCommonERP)
{
if (CheckExistINVME(iNVItems))
{
var update = UpdateINVME(iNVItems, dtCommonERP);
return(update);
}
else
{
var insert = InsertINVME(iNVItems, dtCommonERP);
return(insert);
}
}
public bool UpdateINVMC(Model.INVItems iNVItems, DataTable dtCommonERP)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" update INVMC ");
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 = '" + "MOCI05" + "' ,");
if (iNVItems.TypeInportExport == "1") //nhap kho
{
stringBuilder.Append(" MC007 = MC007 + " + iNVItems.Quantity + " ,");
stringBuilder.Append(" MC014 = MC014 + " + iNVItems.PackageQty + " ,");
stringBuilder.Append(" MC012 = '" + iNVItems.Create_Date.ToString("yyyyMMdd") + "' ");
}
else if (iNVItems.TypeInportExport == "-1") //xuat kho
{
stringBuilder.Append(" MC007 = MC007 - " + iNVItems.Quantity + " ,");
stringBuilder.Append(" MC014 = MC014 - " + iNVItems.PackageQty + " ,");
stringBuilder.Append(" MC013 = '" + iNVItems.Create_Date.ToString("yyyyMMdd") + "' ");
}
stringBuilder.Append(" where MC001 ='" + iNVItems.Product + "' ");
stringBuilder.Append(" and MC002 ='" + iNVItems.Warehouse + "' ");
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 UpdateINVMM(Model.INVItems iNVItems, DataTable dtCommonERP)
{
try
{
double SLDongGoi = Database.INV.INVMD.ConvertToWeightKg(iNVItems.Product, iNVItems.Quantity);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" update INVMM ");
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 = '" + "MOCI05" + "' ,");
if (iNVItems.TypeInportExport == "1")
{
stringBuilder.Append(" MM005 = MM005 + " + iNVItems.Quantity + " ,");
stringBuilder.Append(" MM006 = MM006 + " + SLDongGoi + " ,");
}
else if (iNVItems.TypeInportExport == "-1")
{
stringBuilder.Append(" MM005 = MM005 - " + iNVItems.Quantity + " ,");
stringBuilder.Append(" MM006 = MM006 - " + SLDongGoi + " ,");
}
stringBuilder.Append(" MM008= '" + iNVItems.Create_Date.ToString("yyyyMMdd") + "' ");
stringBuilder.Append(" where MM001 ='" + iNVItems.Product + "' ");
stringBuilder.Append(" and MM002 ='" + iNVItems.Warehouse + "' ");
stringBuilder.Append(" and MM003 ='" + iNVItems.Location + "' ");
stringBuilder.Append(" and MM004 ='" + iNVItems.Lot + "' ");
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 UpdateINVMBbyProduct(Model.INVItems iNVItems)
{
try
{
double ConvertToKg = Database.INV.INVMD.ConvertToWeightKg(iNVItems.Product, iNVItems.Quantity);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" update INVMB ");
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 = '" + "MOCI05" + "' ,");
if (iNVItems.TypeInportExport == "1")
{
stringBuilder.Append(" MB064 = MB064 + " + iNVItems.Quantity + " ,");
stringBuilder.Append(" MB089= MB089 + " + ConvertToKg + " ");
}
else if (iNVItems.TypeInportExport == "-1")
{
stringBuilder.Append(" MB064 = MB064 - " + iNVItems.Quantity + " ,");
stringBuilder.Append(" MB089= MB089 - " + ConvertToKg + " ");
}
stringBuilder.Append(" where MB001 ='" + iNVItems.Product + "' ");
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 UpdateOrInsertINVMM(Model.INVItems iNVItems, DataTable dtCommonERP)
{
try
{
if (CheckExistINVMM(iNVItems))
{
var Update = UpdateINVMM(iNVItems, dtCommonERP);
return(Update);
}
else
{
var Insert = InsertINVMM(iNVItems, dtCommonERP);
return(Insert);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateOrInsertINVMM(Model.INVItems iNVItems, DataTable dtCommonERP)", ex.Message);
}
return(false);
}
public bool InsertINVMF(Model.INVItems iNVItems, DataTable dtCommonERP)
{
try
{
double SLDongGoi = Database.INV.INVMD.ConvertToWeightKg(iNVItems.Product, iNVItems.Quantity);
DataTable dtHeader = GetDtTop1INVMF();
StringBuilder stringBuilder = new StringBuilder();
StringBuilder stringFun = new StringBuilder();
stringBuilder.Append(" insert into INVMF ( ");
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 = "NULL";
if (dtHeader.Columns[j].ColumnName == "COMPANY")
{
valueCell = dtCommonERP.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 = dtCommonERP.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 = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF001")
{
valueCell = iNVItems.Product;
}
else if (dtHeader.Columns[j].ColumnName == "MF002")
{
valueCell = iNVItems.Lot;
}
else if (dtHeader.Columns[j].ColumnName == "MF003")
{
valueCell = iNVItems.Create_Date.ToString("yyyyMMdd");
}
else if (dtHeader.Columns[j].ColumnName == "MF004")
{
valueCell = iNVItems.TypeDoccument;
}
else if (dtHeader.Columns[j].ColumnName == "MF005")
{
valueCell = iNVItems.DoccumentNo;
}
else if (dtHeader.Columns[j].ColumnName == "MF006")
{
valueCell = iNVItems.STTDoc;
}
else if (dtHeader.Columns[j].ColumnName == "MF007")
{
valueCell = iNVItems.Warehouse;
}
else if (dtHeader.Columns[j].ColumnName == "MF008")
{
valueCell = iNVItems.TypeInportExport;
}
else if (dtHeader.Columns[j].ColumnName == "MF009")
{
valueCell = iNVItems.TypeChange;
}
else if (dtHeader.Columns[j].ColumnName == "MF010")
{
valueCell = iNVItems.Quantity.ToString();
}
else if (dtHeader.Columns[j].ColumnName == "MF011")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF012")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF013")
{
valueCell = iNVItems.ProductCode.Replace("-", "");
}
else if (dtHeader.Columns[j].ColumnName == "MF014")
{
valueCell = SLDongGoi.ToString();
}
else if (dtHeader.Columns[j].ColumnName == "MF015")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF016")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "MF017")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "MF018")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF019")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF020")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF021")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF500")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF501")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF502")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "MF503")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "MF504")
{
valueCell = "0";
}
else if (dtHeader.Columns[j].ColumnName == "MF505")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "MF506")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "UDF01")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "UDF02")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "UDF03")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "UDF04")
{
valueCell = "";
}
else if (dtHeader.Columns[j].ColumnName == "UDF05")
{
valueCell = "";
}
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, "InsertINVMF(Model.INVItems iNVItems)", ex.Message);
}
return(false);
}
