public List <DeptCodeName> deptCodeNames(ref ComboBox comboBox)
{
comboBox.Items.Clear();
List <DeptCodeName> deptCodes = new List <DeptCodeName>();
StringBuilder sql = new StringBuilder();
sql.Append("select MD001,MD002 ");
sql.Append("from dbo.ERP_CMSMD ");
sql.Append("where 1=1 ");
sqlSFT sqlSFT = new sqlSFT();
DataTable dt = new DataTable();
sqlSFT.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
deptCodes = (from DataRow dr in dt.Rows
select new DeptCodeName()
{
DeptCode = dr["MD001"].ToString(),
DeptName = "[" + dr["MD001"].ToString() + "] - " + dr["MD002"].ToString()
}).ToList();
foreach (var item in deptCodes)
{
comboBox.Items.Add(item.DeptName);
}
return(deptCodes);
}
public bool CheckExstinctRow(string producCode, string Status, string ERP_OPSEQ)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select * from LOT ");
stringBuilder.Append(" where 1=1 ");
stringBuilder.Append(" and ID = '" + producCode + "' ");
stringBuilder.Append(" and STATUS = '" + Status + "' ");
stringBuilder.Append(" and ERP_OPSEQ ='" + ERP_OPSEQ + "' ");
sqlSFT sqlSFT = new sqlSFT();
DataTable dt = new DataTable();
sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "CheckExtinctRow(string Table, string ID, string ID2)", ex.Message);
return(false);
}
}
public bool CheckExstinctRow(string ID, string ERP_OPSEQ, string ERP_OPID, string ERP_WSID)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select * from SFT_OP_REALRUN ");
stringBuilder.Append(" where 1=1 ");
stringBuilder.Append(" and ID ='" + ID + "' ");
stringBuilder.Append(" and ERP_OPSEQ ='" + ERP_OPSEQ + "' ");
stringBuilder.Append(" and ERP_OPID ='" + ERP_OPID + "' ");
stringBuilder.Append(" and ERP_WSID ='" + ERP_WSID + "' ");
stringBuilder.Append(" and REPORTSTOCKIN ='" + 1 + "' ");
sqlSFT sqlSFT = new sqlSFT();
DataTable dt = new DataTable();
sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "CheckExtinctRow(string Table, string ID, string ID2)", ex.Message);
return(false);
}
}
public DataTable GetTop1DataTable()
{
DataTable dt = new DataTable();
string querry = "select top(1) * from SFT_TRANSORDER ";
sqlSFT sqlSFT = new sqlSFT();
sqlSFT.sqlDataAdapterFillDatatable(querry, ref dt);
return(dt);
}
public static DataTable GetDataTableLot(string ProductOrder)
{
DataTable dt = new DataTable();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top(1) * from LOT where ID ='" + ProductOrder + "' ");
sqlSFT sqlSFT = new sqlSFT();
sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
return(dt);
}
public DataTable GetDataTableFromLot()
{
DataTable dt = new DataTable();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select top(1) * from LOT ");
sqlSFT sqlSFT = new sqlSFT();
sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
return(dt);
}
public static DataTable GetDataTableSFT_OP_REALRUN()
{
DataTable dt = new DataTable();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top(1) * from SFT_OP_REALRUN ");
sqlSFT sqlSFT = new sqlSFT();
sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
return(dt);
}
public DataTable GetDataTableLOTMODETAIL(string productCode)
{
DataTable dt = new DataTable();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"select * from LOT a
left join MODETAIL b on CMOID = ID
where 1 = 1
and ERP_OPSEQ = '0020'
and a.STATUS = '130'
and b.STATUS != '99' and b.STATUS != '100'
");
stringBuilder.Append(" and a.ID= '" + productCode + "'");
sqlSFT sqlSFT = new sqlSFT();
sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
return(dt);
}
public static string getProductionOrder(string Product)
{
DataTable dt = new DataTable();
string productionOrder = "";
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select ID from LOT where LOTSIZE > 0 and STATUS = 50
and ERP_OPSEQ ='0020' ");
stringBuilder.Append(" and ITEMID like '%" + Product + "%' ");
sqlSFT sqlSFT = new sqlSFT();
sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
if (dt.Rows.Count > 0)
{
productionOrder = dt.Rows[0]["ID"].ToString();
}
return(productionOrder);
}
public List <PendingWarehouseItems> GetFinishedGoodsItems(string product)
{
List <PendingWarehouseItems> pendingWarehouseItems = new List <PendingWarehouseItems>();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select a.ID, a.ITEMID,LOTSIZE, a.UNIT,a.PKQTYPER, a.ERP_WSID,a.ERP_OPID from LOT a
left join MODETAIL b on CMOID = ID
where 1 = 1
and ERP_OPSEQ = '0020'
and a.STATUS = '130'
and b.STATUS != '99' and b.STATUS != '100' ");
stringBuilder.Append(" and a.ITEMID LIKE '%" + product + "%' ");
DataTable dt = new DataTable();
sqlSFT sqlTLVN2 = new sqlSFT();
sqlTLVN2.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
pendingWarehouseItems.Add(new PendingWarehouseItems
{
ProductCode = dt.Rows[i]["ID"].ToString(),
product = dt.Rows[i]["ITEMID"].ToString(),
TotalQty = dt.Rows[i]["LOTSIZE"].ToString() != "" ? double.Parse(dt.Rows[i]["LOTSIZE"].ToString()) : 0,
DefectQty = 0,
Unit = dt.Rows[i]["UNIT"].ToString(),
DateExport = DateTime.Now,
PKQTYPER = double.Parse(dt.Rows[i]["PKQTYPER"].ToString()),
OUTDEPID = dt.Rows[i]["ERP_WSID"].ToString(),
OUTTYPE = dt.Rows[i]["ERP_OPID"].ToString()
});
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetFinishedGoodsItems(string product)", ex.Message);
}
return(pendingWarehouseItems);
}
public List <DeptCodeName> deptCodeNames()
{
List <DeptCodeName> deptCodes = new List <DeptCodeName>();
StringBuilder sql = new StringBuilder();
sql.Append("select MD001,MD002 ");
sql.Append("from dbo.ERP_CMSMD ");
sql.Append("where 1=1 ");
sqlSFT sqlSFT = new sqlSFT();
DataTable dt = new DataTable();
sqlSFT.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
deptCodes = (from DataRow dr in dt.Rows
select new DeptCodeName()
{
DeptCode = dr["MD001"].ToString(),
DeptName = "[" + dr["MD001"].ToString() + "] - " + dr["MD002"].ToString()
}).ToList();
return(deptCodes);
}