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 DataTable GetDataTableMOCTG(DataTable ERPPQC, string TB002)
{
DataTable dt = new DataTable();
try
{
dt = Database.MOC.MOCTG.GetTop1DataTable();
if (ERPPQC.Rows.Count > 1)
{
for (int i = 1; i < ERPPQC.Rows.Count; i++)
{
var newRow = dt.NewRow();
dt.Rows.Add(newRow);
}
}
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable dtINVMB = Database.INV.INVMB.GetDatabyProduct(ERPPQC.Rows[i]["Product"].ToString().Trim());
int ExpireDay = Database.INV.INVMB.ExpireDaybyProduct(ERPPQC.Rows[i]["Product"].ToString().Trim());
int ExpireDay2 = Database.INV.INVMB.ExpireDayInspectbyProduct(ERPPQC.Rows[i]["Product"].ToString().Trim());
double ConvertToKg = Database.INV.INVMD.ConvertToWeightKg(ERPPQC.Rows[i]["Product"].ToString().Trim(), double.Parse(ERPPQC.Rows[i]["Quantity"].ToString()));
dt.Rows[i]["COMPANY"] = dtADMMF.Rows[0]["COMPANY"];
dt.Rows[i]["CREATOR"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["USR_GROUP"] = dtADMMF.Rows[0]["MF004"].ToString();
dt.Rows[i]["CREATE_DATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["MODIFIER"] = DBNull.Value;
dt.Rows[i]["MODI_DATE"] = DBNull.Value;
dt.Rows[i]["FLAG"] = 1;
dt.Rows[i]["CREATE_TIME"] = DateTime.Now.ToString("HH:mm:ss");
dt.Rows[i]["CREATE_AP"] = "SFT";
dt.Rows[i]["CREATE_PRID"] = "SFT";
dt.Rows[i]["MODI_TIME"] = DBNull.Value;
dt.Rows[i]["MODI_AP"] = DBNull.Value;
dt.Rows[i]["MODI_PRID"] = DBNull.Value;
dt.Rows[i]["TG001"] = Class.valiballecommon.GetStorage().DocNo;
dt.Rows[i]["TG002"] = TB002;
dt.Rows[i]["TG003"] = (i + 1).ToString("0000");
dt.Rows[i]["TG004"] = ERPPQC.Rows[i]["Product"].ToString().Trim();
dt.Rows[i]["TG005"] = dtINVMB.Rows[0]["MB002"];
dt.Rows[i]["TG006"] = dtINVMB.Rows[0]["MB003"];
dt.Rows[i]["TG007"] = dtINVMB.Rows[0]["MB004"];
dt.Rows[i]["TG008"] = "";
dt.Rows[i]["TG009"] = 1;
dt.Rows[i]["TG010"] = ERPPQC.Rows[i]["Warehouse"].ToString().Trim();
dt.Rows[i]["TG011"] = ERPPQC.Rows[i]["Quantity"];
dt.Rows[i]["TG012"] = 0;
dt.Rows[i]["TG013"] = ERPPQC.Rows[i]["Quantity"];
dt.Rows[i]["TG014"] = ERPPQC.Rows[i]["ProductOrder"].ToString().Split('-')[0];
dt.Rows[i]["TG015"] = ERPPQC.Rows[i]["ProductOrder"].ToString().Split('-')[1];
dt.Rows[i]["TG016"] = "0";
dt.Rows[i]["TG017"] = ERPPQC.Rows[i]["LotNo"].ToString().Trim();
dt.Rows[i]["TG018"] = DateTime.Now.AddDays(ExpireDay).ToString("yyyyMMdd");;
dt.Rows[i]["TG019"] = DateTime.Now.AddDays(ExpireDay2).ToString("yyyyMMdd");;
dt.Rows[i]["TG020"] = "[" + ERPPQC.Rows[i]["Warehouse"].ToString().Trim() + "]";
dt.Rows[i]["TG021"] = "";
dt.Rows[i]["TG022"] = "Y";
dt.Rows[i]["TG023"] = 0;
dt.Rows[i]["TG024"] = "N";
dt.Rows[i]["TG025"] = ConvertToKg;
dt.Rows[i]["TG026"] = 0;
dt.Rows[i]["TG027"] = ConvertToKg;
dt.Rows[i]["TG028"] = 0;
dt.Rows[i]["TG029"] = dtINVMB.Rows[0]["MB090"];
dt.Rows[i]["TG030"] = "N";
dt.Rows[i]["TG031"] = "N";
dt.Rows[i]["TG032"] = 0;
dt.Rows[i]["TG033"] = "2";
dt.Rows[i]["TG034"] = ERPPQC.Rows[i]["Location"].ToString();//add tuanngoc
dt.Rows[i]["TG035"] = 0;
dt.Rows[i]["TG036"] = 0;
dt.Rows[i]["TG037"] = "0";
dt.Rows[i]["TG038"] = "";
dt.Rows[i]["TG039"] = 0;
dt.Rows[i]["TG040"] = "";
dt.Rows[i]["TG041"] = "";
dt.Rows[i]["TG503"] = 0;
dt.Rows[i]["TG504"] = 0;
dt.Rows[i]["TG505"] = 0;
dt.Rows[i]["TG506"] = 0;
dt.Rows[i]["TG553"] = 0;
dt.Rows[i]["TG554"] = 0;
dt.Rows[i]["TG555"] = 0;
dt.Rows[i]["TG556"] = 0;
dt.Rows[i]["UDF06"] = 0;
dt.Rows[i]["UDF07"] = 0;
dt.Rows[i]["UDF08"] = 0;
dt.Rows[i]["UDF09"] = 0;
dt.Rows[i]["UDF10"] = 0;
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetDataTableSFCTC", ex.Message);
}
return(dt);
}
public DataTable GetDataTableMOCTF(DataTable MOCTG, string TB002)
{
DataTable dt = new DataTable();
try
{
dt = Database.MOC.MOCTF.GetTop1DataTable();
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
Database.GetListWarehouse getListWarehouse = new Database.GetListWarehouse();
List <Database.WarehouseItems> listWarehouse = getListWarehouse.GetWarehouseOnly();
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["COMPANY"] = dtADMMF.Rows[0]["COMPANY"];
dt.Rows[i]["CREATOR"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["USR_GROUP"] = dtADMMF.Rows[0]["MF004"].ToString();
dt.Rows[i]["CREATE_DATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["MODIFIER"] = DBNull.Value;
dt.Rows[i]["MODI_DATE"] = DBNull.Value;
dt.Rows[i]["FLAG"] = 1;
dt.Rows[i]["CREATE_TIME"] = DateTime.Now.ToString("HH:mm:ss");
dt.Rows[i]["CREATE_AP"] = "SFT";
dt.Rows[i]["CREATE_PRID"] = "SFT";
dt.Rows[i]["MODI_TIME"] = DBNull.Value;
dt.Rows[i]["MODI_AP"] = DBNull.Value;
dt.Rows[i]["MODI_PRID"] = DBNull.Value;
dt.Rows[i]["TF001"] = MOCTG.Rows[0]["TG001"];
dt.Rows[i]["TF002"] = MOCTG.Rows[0]["TG002"];
dt.Rows[i]["TF003"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["TF004"] = "TL";
dt.Rows[i]["TF005"] = "";
dt.Rows[i]["TF006"] = "Y";
dt.Rows[i]["TF007"] = "N";
dt.Rows[i]["TF008"] = 0;
dt.Rows[i]["TF009"] = "N";
dt.Rows[i]["TF010"] = "N";
dt.Rows[i]["TF011"] = "B01";
dt.Rows[i]["TF012"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["TF013"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["TF014"] = "N";
dt.Rows[i]["TF015"] = "0";
dt.Rows[i]["TF016"] = 0;
dt.Rows[i]["TF017"] = 0;
dt.Rows[i]["TF018"] = 0;
dt.Rows[i]["TF019"] = "";
dt.Rows[i]["TF020"] = "";
dt.Rows[i]["TF021"] = "";
dt.Rows[i]["UDF06"] = 0;
dt.Rows[i]["UDF07"] = 0;
dt.Rows[i]["UDF08"] = 0;
dt.Rows[i]["UDF09"] = 0;
dt.Rows[i]["UDF10"] = 0;
var SumQty = MOCTG.AsEnumerable().Sum(x => x.Field <decimal>("TG011"));
// dt.Rows[i]["TB200"] = SumQty;
dt.Rows[i]["TF200"] = SumQty;
dt.Rows[i]["TF201"] = 0;
dt.Rows[i]["TF202"] = 0;
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetDataTableSFCTB", ex.Message);
}
return(dt);
}
public DataTable GetDataTableSFCTB(DataTable dtSFCTC, DataTable ERPPQC, string TransNo, string Confirm)
{
DataTable dt = new DataTable();
try
{
dt = Database.SFC.SFCTB.GetTop1DataTable();
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
Database.GetListWarehouse getListWarehouse = new Database.GetListWarehouse();
List <Database.WarehouseItems> listWarehouse = getListWarehouse.GetWarehouseOnly();
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["COMPANY"] = dtADMMF.Rows[0]["COMPANY"];
dt.Rows[i]["CREATOR"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["USR_GROUP"] = dtADMMF.Rows[0]["MF004"].ToString();
dt.Rows[i]["CREATE_DATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["MODIFIER"] = DBNull.Value;
dt.Rows[i]["MODI_DATE"] = DBNull.Value;
dt.Rows[i]["FLAG"] = 1;
dt.Rows[i]["CREATE_TIME"] = DateTime.Now.ToString("HH:mm:ss");
dt.Rows[i]["CREATE_AP"] = "SFT";
dt.Rows[i]["CREATE_PRID"] = "SFT";
dt.Rows[i]["MODI_TIME"] = DBNull.Value;
dt.Rows[i]["MODI_AP"] = DBNull.Value;
dt.Rows[i]["MODI_PRID"] = DBNull.Value;
dt.Rows[i]["TB001"] = dtSFCTC.Rows[0]["TC001"];
dt.Rows[i]["TB002"] = dtSFCTC.Rows[0]["TC002"];
dt.Rows[i]["TB003"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["TB004"] = "1";
dt.Rows[i]["TB005"] = "B01";
dt.Rows[i]["TB006"] = "?管OEM生??ONGOEM";
dt.Rows[i]["TB007"] = "3";
dt.Rows[i]["TB008"] = ERPPQC.Rows[0]["Warehouse"].ToString().Trim();
dt.Rows[i]["TB009"] = listWarehouse.Where(d => d.MC001_Wh.Contains(ERPPQC.Rows[0]["Warehouse"].ToString())).Select(d => d.MC002_WhName).ToList()[0];
dt.Rows[i]["TB010"] = "TL";
dt.Rows[i]["TB011"] = 0;
dt.Rows[i]["TB012"] = "N";
dt.Rows[i]["TB013"] = Confirm;
dt.Rows[i]["TB015"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["TB016"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["TB017"] = "N";
dt.Rows[i]["TB018"] = "";
dt.Rows[i]["TB019"] = "1";
dt.Rows[i]["TB022"] = "1";
dt.Rows[i]["TB023"] = "1";
dt.Rows[i]["TB024"] = "";
dt.Rows[i]["TB025"] = DateTime.Now.ToString("yyyyMM");
dt.Rows[i]["TB026"] = 0.2;
dt.Rows[i]["TB027"] = 0;
dt.Rows[i]["TB029"] = 0;
dt.Rows[i]["TB030"] = 0;
dt.Rows[i]["TB031"] = 0;
//DataTable dtSFCTA = Database.SFC.SFCTA.GetDataTableSFCTA(ERPPQC.Rows[i]["ProductOrder"].ToString());
//dt.Rows[i]["TB036"] = dtSFCTA.Rows[0]["TA018"].ToString();
dt.Rows[i]["TB037"] = 0;
dt.Rows[i]["TB038"] = Class.valiballecommon.GetStorage().DocNo;
dt.Rows[i]["TB039"] = TransNo;
dt.Rows[i]["UDF06"] = 0;
dt.Rows[i]["UDF07"] = 0;
dt.Rows[i]["UDF08"] = 0;
dt.Rows[i]["UDF09"] = 0;
dt.Rows[i]["UDF10"] = 0;
var SumQty = ERPPQC.Rows[i]["Quantity"].ToString().Trim();/*ERPPQC.AsEnumerable().Sum(x =>x.Field<decimal>("Quantity"));*/
dt.Rows[i]["TB200"] = SumQty;
dt.Rows[i]["TB201"] = SumQty;
dt.Rows[i]["TB202"] = 0;
dt.Rows[i]["TB042"] = "";
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetDataTableSFCTB", ex.Message);
}
return(dt);
}
public DataTable GetDataTableSFCTC(DataTable ERPPQC, string TB002, string confirm)
{
DataTable dt = new DataTable();
try
{
dt = Database.SFC.SFCTC.GetTop1DataTable();
if (ERPPQC.Rows.Count > 1)
{
for (int i = 1; i < ERPPQC.Rows.Count; i++)
{
var newRow = dt.NewRow();
dt.Rows.Add(newRow);
}
}
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["COMPANY"] = dtADMMF.Rows[0]["COMPANY"];
dt.Rows[i]["CREATOR"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["USR_GROUP"] = dtADMMF.Rows[0]["MF004"].ToString();
dt.Rows[i]["CREATE_DATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["MODIFIER"] = DBNull.Value;
dt.Rows[i]["MODI_DATE"] = DBNull.Value;
dt.Rows[i]["FLAG"] = 1;
dt.Rows[i]["CREATE_TIME"] = DateTime.Now.ToString("HH:mm:ss");
dt.Rows[i]["CREATE_AP"] = "SFT";
dt.Rows[i]["CREATE_PRID"] = "SFT";
dt.Rows[i]["MODI_TIME"] = DBNull.Value;
dt.Rows[i]["MODI_AP"] = DBNull.Value;
dt.Rows[i]["MODI_PRID"] = DBNull.Value;
dt.Rows[i]["TC001"] = Class.valiballecommon.GetStorage().DocNo;
dt.Rows[i]["TC002"] = TB002;
dt.Rows[i]["TC003"] = (i + 1).ToString("0000");
dt.Rows[i]["TC004"] = ERPPQC.Rows[i]["ProductOrder"].ToString().Trim().Split('-')[0];
dt.Rows[i]["TC005"] = ERPPQC.Rows[i]["ProductOrder"].ToString().Trim().Split('-')[1];
dt.Rows[i]["TC006"] = "0020";
DataTable dtSFCTA = Database.SFC.SFCTA.GetDataTableSFCTA(ERPPQC.Rows[i]["ProductOrder"].ToString());///
if (dtSFCTA.Rows.Count == 0)
{
MessageBox.Show("dtSFCTA =" + dtSFCTA.Rows.Count.ToString());
}
else
{
dt.Rows[i]["TC007"] = dtSFCTA.Rows[0]["TA004"].ToString();
dt.Rows[i]["TC010"] = dtSFCTA.Rows[0]["TA020"].ToString();
dt.Rows[i]["TC023"] = dtSFCTA.Rows[0]["TA006"].ToString();
}
dt.Rows[i]["TC008"] = "";
dt.Rows[i]["TC009"] = "";
//dt.Rows[i]["TC010"] = dtSFCTA.Rows[0]["TA020"].ToString();
dt.Rows[i]["TC011"] = DBNull.Value;
dt.Rows[i]["TC012"] = DBNull.Value;
dt.Rows[i]["TC013"] = "1";
dt.Rows[i]["TC014"] = ERPPQC.Rows[i]["Quantity"];
dt.Rows[i]["TC015"] = 0;
dt.Rows[i]["TC016"] = 0;
dt.Rows[i]["TC017"] = 0;
dt.Rows[i]["TC018"] = 0;
dt.Rows[i]["TC019"] = 0;
dt.Rows[i]["TC020"] = 0;
dt.Rows[i]["TC021"] = 0;
dt.Rows[i]["TC022"] = confirm;
//dt.Rows[i]["TC023"] = dtSFCTA.Rows[0]["TA006"].ToString();
dt.Rows[i]["TC024"] = DBNull.Value;
dt.Rows[i]["TC025"] = 0;
dt.Rows[i]["TC026"] = "N";
dt.Rows[i]["TC027"] = "N";
dt.Rows[i]["TC028"] = DBNull.Value;
dt.Rows[i]["TC029"] = DBNull.Value;
dt.Rows[i]["TC030"] = DBNull.Value;
dt.Rows[i]["TC031"] = DBNull.Value;
dt.Rows[i]["TC032"] = ERPPQC.Rows[i]["LotNo"].ToString().Trim();
int ExpireDay = Database.INV.INVMB.ExpireDaybyProduct(ERPPQC.Rows[i]["Product"].ToString().Trim());
int ExpireDay2 = Database.INV.INVMB.ExpireDayInspectbyProduct(ERPPQC.Rows[i]["Product"].ToString().Trim());
dt.Rows[i]["TC033"] = DateTime.Now.AddDays(ExpireDay).ToString("yyyyMMdd");
dt.Rows[i]["TC034"] = DateTime.Now.AddDays(ExpireDay2).ToString("yyyyMMdd");
dt.Rows[i]["TC035"] = "N";
dt.Rows[i]["TC036"] = ERPPQC.Rows[i]["Quantity"];
dt.Rows[i]["TC037"] = "0";
dt.Rows[i]["TC038"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["TC039"] = 0;
dt.Rows[i]["TC041"] = ERPPQC.Rows[i]["Warehouse"].ToString().Trim();
//DataTable dtLot = Database.SFT.SFT_LOT.GetDataTableLot(ERPPQC.Rows[i]["ProductOrder"].ToString());
// dt.Rows[i]["TC042"] = (double.Parse(ERPPQC.Rows[i]["Quantity"].ToString()))*(double.Parse(dtLot.Rows[0]["PKQTYPER"].ToString()));
//dt.Rows[i]["TC043"] = (double.Parse(ERPPQC.Rows[i]["Quantity"].ToString())) * (double.Parse(dtLot.Rows[0]["PKQTYPER"].ToString()));
dt.Rows[i]["TC044"] = 0;
dt.Rows[i]["TC045"] = 0;
dt.Rows[i]["TC046"] = 0;
dt.Rows[i]["TC047"] = ERPPQC.Rows[i]["Product"].ToString().Trim();
/* DataTable dtINVMB = Database.INV.INVMB.GetDatabyProduct(ERPPQC.Rows[i]["Product"].ToString().Trim());
* dt.Rows[i]["TC048"] = dtINVMB.Rows[0]["MB002"].ToString();
* dt.Rows[i]["TC049"] = dtINVMB.Rows[0]["MB003"].ToString();*///Temporate ignore wait confirm.
// dt.Rows[i]["TC050"] = dtLot.Rows[0]["PKUNIT"].ToString();
dt.Rows[i]["TC051"] = 0;
dt.Rows[i]["TC052"] = ERPPQC.Rows[i]["Location"].ToString();//add tuanngoc;
dt.Rows[i]["TC053"] = 0;
dt.Rows[i]["TC054"] = 0;
dt.Rows[i]["TC055"] = "N";
dt.Rows[i]["TC056"] = DBNull.Value;
dt.Rows[i]["TC057"] = DBNull.Value;
dt.Rows[i]["TC058"] = DBNull.Value;
dt.Rows[i]["TC059"] = DBNull.Value;
dt.Rows[i]["TC060"] = 0;
dt.Rows[i]["UDF06"] = 0;
dt.Rows[i]["UDF07"] = 0;
dt.Rows[i]["UDF08"] = 0;
dt.Rows[i]["UDF09"] = 0;
dt.Rows[i]["UDF10"] = 0;
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetDataTableSFCTC", ex.Message);
}
return(dt);
}
public DataTable ConvertDataTable(DataTable dtProduct)
{
DataTable dt = new DataTable();
try
{
dt = GetTop1Table();
dt.Rows.Clear();
if (dtProduct.Rows.Count > 0)
{
for (int i = 0; i < dtProduct.Rows.Count; i++)
{
var newRow = dt.NewRow();
dt.Rows.Add(newRow);
}
}
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["COMPANY"] = dtADMMF.Rows[0]["COMPANY"];
dt.Rows[i]["CREATOR"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["USR_GROUP"] = dtADMMF.Rows[0]["MF004"].ToString();
dt.Rows[i]["CREATE_DATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["MODIFIER"] = DBNull.Value;
dt.Rows[i]["MODI_DATE"] = DBNull.Value;
dt.Rows[i]["FLAG"] = 1;
dt.Rows[i]["CREATE_TIME"] = DateTime.Now.ToString("HH:mm:ss");
dt.Rows[i]["CREATE_AP"] = "SFT";
dt.Rows[i]["CREATE_PRID"] = "SFT";
dt.Rows[i]["MODI_TIME"] = DBNull.Value;
dt.Rows[i]["MODI_AP"] = DBNull.Value;
dt.Rows[i]["MODI_PRID"] = DBNull.Value;
dt.Rows[i]["MB001"] = dtProduct.Rows[i]["MB001"];
dt.Rows[i]["MB002"] = dtProduct.Rows[i]["MB002"];
dt.Rows[i]["MB003"] = dtProduct.Rows[i]["MB003"];
dt.Rows[i]["MB004"] = DBNull.Value;
dt.Rows[i]["MB005"] = DBNull.Value;
dt.Rows[i]["MB006"] = DBNull.Value;
dt.Rows[i]["MB007"] = DBNull.Value;
dt.Rows[i]["MB008"] = DBNull.Value;
dt.Rows[i]["MB009"] = DBNull.Value;
dt.Rows[i]["MB010"] = DBNull.Value;
dt.Rows[i]["MB011"] = DBNull.Value;
dt.Rows[i]["MB012"] = DBNull.Value;
dt.Rows[i]["MB013"] = DBNull.Value;
dt.Rows[i]["MB014"] = DBNull.Value;
dt.Rows[i]["MB015"] = DBNull.Value;
dt.Rows[i]["MB016"] = DBNull.Value;
dt.Rows[i]["MB017"] = DBNull.Value;
dt.Rows[i]["MB018"] = DBNull.Value;
dt.Rows[i]["MB019"] = DBNull.Value;
dt.Rows[i]["MB020"] = DBNull.Value;
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "ConvertDataTable(DataTable dtProduct)", ex.Message);
}
return(dt);
}
public DataTable ConvertdtCOPTG(DataTable COPTH, DataTable dtExport)
{
DataTable dt = Database.COPTG.GetdtTop1COPTG();
dt.Rows.Clear();
DataRow dataRow = dt.NewRow();
dt.Rows.Add(dataRow);
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["COMPANY"] = dtADMMF.Rows[0]["COMPANY"];
dt.Rows[i]["CREATOR"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["USR_GROUP"] = dtADMMF.Rows[0]["MF004"].ToString();
dt.Rows[i]["CREATE_DATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["MODIFIER"] = DBNull.Value;
dt.Rows[i]["MODI_DATE"] = DBNull.Value;
dt.Rows[i]["FLAG"] = 1;
dt.Rows[i]["CREATE_TIME"] = DateTime.Now.ToString("HH:mm:ss");
dt.Rows[i]["CREATE_TIME"] = DateTime.Now.ToString("HH:mm:ss");
dt.Rows[i]["CREATE_AP"] = "SFT";
dt.Rows[i]["CREATE_PRID"] = "SFT";
dt.Rows[i]["MODI_TIME"] = DBNull.Value;
dt.Rows[i]["MODI_AP"] = "";//Class.valiballecommon.GetStorage().PCName;
dt.Rows[i]["CREATE_PRID"] = "COPI08";
dt.Rows[i]["TG001"] = COPTH.Rows[0]["TH001"];
dt.Rows[i]["TG002"] = COPTH.Rows[0]["TH002"];
dt.Rows[i]["TG003"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["TG004"] = dtExport.Rows[0]["Client"];
dt.Rows[i]["TG005"] = dtExport.Rows[0]["DeptCode"];
dt.Rows[i]["TG006"] = "";
DataTable dtCOPMA = Database.COPMA.GetDataTableKhachhangbyClientCode(dtExport.Rows[0]["Client"].ToString().Trim());
dt.Rows[i]["TG007"] = dtCOPMA.Rows[0]["MA003"];//ten day du khach hang
dt.Rows[i]["TG008"] = "";
dt.Rows[i]["TG009"] = "";
dt.Rows[i]["TG010"] = "TL";
dt.Rows[i]["TG011"] = dtExport.Rows[0]["Currency"];
DataTable dtCMSMG = Database.CMS.CMSMG.GetdtConvetTienTe(dtExport.Rows[i]["Currency"].ToString().Trim(), DateTime.Now);
dt.Rows[i]["TG012"] = dtCMSMG.Rows[0]["MG012"];
var MonneySaled = COPTH.AsEnumerable().Sum(x => x.Field <decimal>("TH013"));
dt.Rows[i]["TG013"] = MonneySaled; //so tien ban
dt.Rows[i]["TG014"] = "";
dt.Rows[i]["TG015"] = "";
dt.Rows[i]["TG016"] = "3";
dt.Rows[i]["TG017"] = "3";
dt.Rows[i]["TG018"] = "";
dt.Rows[i]["TG019"] = "";
dt.Rows[i]["TG020"] = "";
dt.Rows[i]["TG021"] = "";//ngay hoa don
dt.Rows[i]["TG022"] = 0;
dt.Rows[i]["TG023"] = "Y";
dt.Rows[i]["TG024"] = "N";
dt.Rows[i]["TG025"] = 0;
dt.Rows[i]["TG026"] = "";
dt.Rows[i]["TG027"] = "";
dt.Rows[i]["TG028"] = "";
dt.Rows[i]["TG029"] = "";
dt.Rows[i]["TG030"] = "N";
dt.Rows[i]["TG031"] = "2";
dt.Rows[i]["TG032"] = 0;
dt.Rows[i]["TG033"] = 0;
dt.Rows[i]["TG032"] = 0;
var SumQty = COPTH.AsEnumerable().Sum(x => x.Field <decimal>("TH008"));
dt.Rows[i]["TG033"] = SumQty;
dt.Rows[i]["TG034"] = "N";
dt.Rows[i]["TG035"] = "";
dt.Rows[i]["TG036"] = "N";
dt.Rows[i]["TG037"] = "N";
dt.Rows[i]["TG038"] = DateTime.Now.ToString("yyyyMM");
dt.Rows[i]["TG039"] = "";
dt.Rows[i]["TG040"] = dtExport.Rows[0]["Invoice"].ToString().Trim();
dt.Rows[i]["TG041"] = 0;
dt.Rows[i]["TG042"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["TG043"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["TG044"] = 0;
var TongTienViet = COPTH.AsEnumerable().Sum(x => x.Field <decimal>("TH037"));
dt.Rows[i]["TG045"] = TongTienViet;//So tien ban tinh sao
dt.Rows[i]["TG046"] = 0;
dt.Rows[i]["TG047"] = "";
dt.Rows[i]["TG048"] = "";
dt.Rows[i]["TG049"] = "";
dt.Rows[i]["TG050"] = "";
dt.Rows[i]["TG051"] = "";
dt.Rows[i]["TG052"] = 0;
dt.Rows[i]["TG053"] = 0;
var SumPackingKg = COPTH.AsEnumerable().Sum(x => x.Field <decimal>("TH039"));
dt.Rows[i]["TG054"] = SumPackingKg;
dt.Rows[i]["TG055"] = "N";
dt.Rows[i]["TG056"] = "N";
dt.Rows[i]["TG057"] = "";
dt.Rows[i]["TG058"] = "";
dt.Rows[i]["TG059"] = "N";
dt.Rows[i]["TG060"] = "";
dt.Rows[i]["TG061"] = "N";
dt.Rows[i]["TG062"] = "0";
dt.Rows[i]["TG063"] = 0;
dt.Rows[i]["TG064"] = "";
dt.Rows[i]["TG065"] = "";
dt.Rows[i]["TG066"] = "";
dt.Rows[i]["TG067"] = "";
dt.Rows[i]["TG068"] = "1";
dt.Rows[i]["TG069"] = 0;
dt.Rows[i]["TG070"] = "N";
dt.Rows[i]["TG071"] = 0;
dt.Rows[i]["TG072"] = "";
dt.Rows[i]["TG073"] = "";
dt.Rows[i]["TG074"] = "";
dt.Rows[i]["TG075"] = "";
dt.Rows[i]["TG076"] = dtCOPMA.Rows[0]["MA003"];
dt.Rows[i]["TG077"] = "";
dt.Rows[i]["TG078"] = "";
dt.Rows[i]["TG079"] = "";
dt.Rows[i]["TG080"] = "";
dt.Rows[i]["TG081"] = "";
dt.Rows[i]["TG082"] = "1";
dt.Rows[i]["TG083"] = "";
dt.Rows[i]["TG084"] = 0;
dt.Rows[i]["TG085"] = 0;
dt.Rows[i]["TG086"] = "2";
dt.Rows[i]["TG087"] = "";
dt.Rows[i]["TG088"] = "";
dt.Rows[i]["TG089"] = "N";
dt.Rows[i]["TG090"] = "";
dt.Rows[i]["TG091"] = 0;
dt.Rows[i]["TG092"] = "";
dt.Rows[i]["TG093"] = "";
dt.Rows[i]["TG094"] = "003";// cai nay lay o dau
dt.Rows[i]["TG095"] = "";
dt.Rows[i]["TG096"] = "";
dt.Rows[i]["TG097"] = "N";
dt.Rows[i]["TG098"] = "";
dt.Rows[i]["TG099"] = 0;
dt.Rows[i]["TG100"] = "N";
dt.Rows[i]["TG101"] = 1;
dt.Rows[i]["TG102"] = "";
dt.Rows[i]["TG103"] = "";
dt.Rows[i]["TG104"] = "";
dt.Rows[i]["TG105"] = "";
dt.Rows[i]["TG106"] = "";
dt.Rows[i]["TG107"] = "";
dt.Rows[i]["TG108"] = "";
dt.Rows[i]["TG109"] = "";
dt.Rows[i]["TG110"] = "";
dt.Rows[i]["TG111"] = "0";
dt.Rows[i]["UDF06"] = 0;
dt.Rows[i]["UDF07"] = 0;
dt.Rows[i]["UDF08"] = 0;
dt.Rows[i]["UDF09"] = 0;
dt.Rows[i]["UDF10"] = 0;
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Convert to COPTG", ex.Message);
dt = new DataTable();
}
return(dt);
}
public DataTable ConverttoDtCOPTH(DataTable dtExport)
{
DataTable dt = Database.COPTH.GetdtTop1COPTH();
Database.ADMMFUpdate aDMMF = new Database.ADMMFUpdate();
DataTable dtADMMF = aDMMF.GetDtADMFFByUser(Class.valiballecommon.GetStorage().UserName);
dt.Rows.Clear();
for (int i = 0; i < dtExport.Rows.Count; i++)
{
DataRow dtRow = dt.NewRow();
dt.Rows.Add(dtRow);
}
try
{
string KeyCOPTGTH = Database.COPTG.KeyCOPTGTH(DateTime.Now, dtExport.Rows[0]["DocNo"].ToString().Trim());
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["COMPANY"] = dtADMMF.Rows[0]["COMPANY"];
dt.Rows[i]["CREATOR"] = Class.valiballecommon.GetStorage().UserName;
dt.Rows[i]["USR_GROUP"] = dtADMMF.Rows[0]["MF004"].ToString();
dt.Rows[i]["CREATE_DATE"] = DateTime.Now.ToString("yyyyMMdd");
dt.Rows[i]["MODIFIER"] = DBNull.Value;
dt.Rows[i]["MODI_DATE"] = DBNull.Value;
dt.Rows[i]["FLAG"] = 1;
dt.Rows[i]["CREATE_TIME"] = DateTime.Now.ToString("HH:mm:ss");
dt.Rows[i]["CREATE_AP"] = "SFT";
dt.Rows[i]["CREATE_PRID"] = "SFT";
dt.Rows[i]["MODI_TIME"] = DBNull.Value;
dt.Rows[i]["MODI_AP"] = "";//Class.valiballecommon.GetStorage().PCName;
dt.Rows[i]["CREATE_PRID"] = "COPI08";
dt.Rows[i]["TH001"] = dtExport.Rows[0]["DocNo"].ToString().Trim();
dt.Rows[i]["TH002"] = KeyCOPTGTH;
dt.Rows[i]["TH003"] = dtExport.Rows[i]["STT"].ToString().Trim();
dt.Rows[i]["TH004"] = dtExport.Rows[i]["Product"].ToString().Trim();
DataTable dtINVMB = Database.INV.INVMB.GetDatabyProduct(dtExport.Rows[i]["Product"].ToString().Trim());
StringBuilder stringBuilder = new StringBuilder();
dt.Rows[i]["TH005"] = dtINVMB.Rows[0]["MB002"];
dt.Rows[i]["TH006"] = dtINVMB.Rows[0]["MB003"];
dt.Rows[i]["TH007"] = dtExport.Rows[i]["Warehouse"].ToString().Trim();
dt.Rows[i]["TH008"] = dtExport.Rows[i]["Quantity"];
dt.Rows[i]["TH009"] = dtINVMB.Rows[0]["MB004"];
dt.Rows[i]["TH010"] = 0;
dt.Rows[i]["TH011"] = "";
dt.Rows[i]["TH012"] = dtExport.Rows[i]["PriceUnit"]; //Don gia lay o dau
dt.Rows[i]["TH013"] = double.Parse(dtExport.Rows[i]["Quantity"].ToString()) * double.Parse(dt.Rows[i]["TH012"].ToString()); //Don gia lay o dau
dt.Rows[i]["TH014"] = dtExport.Rows[i]["ClientCode"];
dt.Rows[i]["TH015"] = dtExport.Rows[i]["ClientOrder"];
dt.Rows[i]["TH016"] = dtExport.Rows[i]["OrderSTT"];
dt.Rows[i]["TH017"] = dtExport.Rows[i]["LotNo"];; //So lo
dt.Rows[i]["TH018"] = ""; //So lo
dt.Rows[i]["TH019"] = ""; //ma san pham khach hang
dt.Rows[i]["TH020"] = "Y";
dt.Rows[i]["TH021"] = "N";
dt.Rows[i]["TH022"] = "";
dt.Rows[i]["TH023"] = "";
dt.Rows[i]["TH024"] = 0;
dt.Rows[i]["TH025"] = 1;
dt.Rows[i]["TH026"] = "N";
dt.Rows[i]["TH027"] = "";
dt.Rows[i]["TH028"] = "";
dt.Rows[i]["TH029"] = "";
dt.Rows[i]["TH030"] = "";
dt.Rows[i]["TH031"] = "1";
dt.Rows[i]["TH032"] = "";
dt.Rows[i]["TH033"] = "";
dt.Rows[i]["TH034"] = "";
dt.Rows[i]["TH035"] = dt.Rows[i]["TH013"];
DataTable dtCMSMG = Database.CMS.CMSMG.GetdtConvetTienTe(dtExport.Rows[i]["Currency"].ToString().Trim(), DateTime.Now);
dt.Rows[i]["TH036"] = 0; // THUE XUAT = 0
dt.Rows[i]["TH037"] = double.Parse(dt.Rows[i]["TH013"].ToString()) * double.Parse(dtCMSMG.Rows[0]["MG012"].ToString()); // TIEN HOAN DOI RA TIEN VIET
dt.Rows[i]["TH038"] = 0;
double SLDongGoi = Database.INV.INVMD.ConvertToWeightKg(dt.Rows[i]["TH004"].ToString(), double.Parse(dt.Rows[i]["TH008"].ToString()));
DataTable dtCOPTD = Database.COP.COPTD.GetdtCOPTDby(dt.Rows[i]["TH014"].ToString(), dt.Rows[i]["TH015"].ToString(), dt.Rows[i]["TH016"].ToString());
dt.Rows[i]["TH039"] = SLDongGoi;
dt.Rows[i]["TH040"] = 0;
dt.Rows[i]["TH041"] = dtCOPTD.Rows[0]["TD036"];//DON VI DONG GOI
dt.Rows[i]["TH042"] = "N";
dt.Rows[i]["TH043"] = 0;
dt.Rows[i]["TH044"] = 0;
dt.Rows[i]["TH045"] = 0;
dt.Rows[i]["TH046"] = 0;
dt.Rows[i]["TH047"] = 0;
dt.Rows[i]["TH048"] = 0;
dt.Rows[i]["TH049"] = 0;
dt.Rows[i]["TH050"] = 0;
dt.Rows[i]["TH051"] = "";
dt.Rows[i]["TH052"] = 0;
dt.Rows[i]["TH053"] = 0;
dt.Rows[i]["TH054"] = "N";
dt.Rows[i]["TH055"] = "";
dt.Rows[i]["TH056"] = "";
dt.Rows[i]["TH057"] = 0;
dt.Rows[i]["TH058"] = "";
dt.Rows[i]["TH059"] = "";
dt.Rows[i]["TH060"] = dtExport.Rows[i]["Location"];
dt.Rows[i]["TH061"] = dtExport.Rows[i]["Quantity"];
dt.Rows[i]["TH062"] = dtINVMB.Rows[0]["MB004"];//PCS
dt.Rows[i]["TH063"] = 0;
dt.Rows[i]["TH064"] = 0;
dt.Rows[i]["TH065"] = "";
dt.Rows[i]["TH066"] = "";
dt.Rows[i]["TH067"] = "";
dt.Rows[i]["TH068"] = "N";
dt.Rows[i]["TH069"] = 0;
dt.Rows[i]["TH070"] = "";
dt.Rows[i]["TH071"] = 0;
dt.Rows[i]["TH072"] = 0;
dt.Rows[i]["TH073"] = 0;
dt.Rows[i]["TH074"] = 0;
dt.Rows[i]["TH075"] = "";
dt.Rows[i]["TH076"] = "";
dt.Rows[i]["TH077"] = "";
dt.Rows[i]["TH078"] = "";
dt.Rows[i]["TH079"] = "";
dt.Rows[i]["TH080"] = 0;
dt.Rows[i]["UDF06"] = 0;
dt.Rows[i]["UDF07"] = 0;
dt.Rows[i]["UDF08"] = 0;
dt.Rows[i]["UDF09"] = 0;
dt.Rows[i]["UDF10"] = 0;
dt.Rows[i]["TH091"] = 0;
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Convert to COPTH", ex.Message);
dt = new DataTable();
}
return(dt);
}