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 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);
}