public List <string> GetListBySkuno(OleExec db, string skuno)
{
//List<C_KEYPART> kps = new List<C_KEYPART>();
List <string> kps = new List <string>();
DataTable dt = null;
Row_C_KEYPART row_kp = null;
if (DBType == DB_TYPE_ENUM.Oracle)
{
string sql = $@"select * from {TableName} where skuno='{skuno}' ";
dt = db.ExecSelect(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
//row_kp = (Row_C_KEYPART) NewRow();
//row_kp.loadData(dr);
//kps.Add(row_kp.GetDataObject());
kps.Add(dr["keypart_id"].ToString());
}
return(kps);
}
else
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { this.DBType.ToString() }));
}
}
public List <C_KEYPART> GetKeyPartList(OleExec db, string kpListID)
{
string sql = null;
List <C_KEYPART> lists = null;
Row_C_KEYPART rckp = null;
DataTable dt = null;
if (!string.IsNullOrEmpty(kpListID))
{
sql = $@" select * from {this.TableName} where keypart_id = '{kpListID}' order by seq_no asc ";
dt = db.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
lists = new List <C_KEYPART>();
foreach (DataRow dr in dt.Rows)
{
rckp = (Row_C_KEYPART)this.NewRow();
rckp.loadData(dr);
lists.Add(rckp.GetDataObject());
}
}
}
return(lists);
}
public List <C_KEYPART> GetKeypartListBySkuVersion(OleExec db, string skuno, string version)
{
DataTable dt = null;
Row_C_KEYPART rowKeypart = null;
List <C_KEYPART> keypartList = new List <C_KEYPART>();
//modify by LLF 2018-04-01
//string sql = $@"select * from c_keypart where skuno='{skuno}' and skuno_ver='{version}'";
string sql = $@"select * from c_keypart where skuno='{skuno}'";
try
{
dt = db.ExecSelect(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
rowKeypart = (Row_C_KEYPART)this.NewRow();
rowKeypart.loadData(dr);
keypartList.Add(rowKeypart.GetDataObject());
}
}
catch (Exception ex)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000037", new string[] { ex.Message }));
}
return(keypartList);
}
public Row_C_KEYPART getC_MenubyKPID(string id, OleExec DB)
{
string strSql = $@" SELECT * FROM C_KEYPART where KEYPART_ID='{id}' ";
DataSet res = DB.ExecSelect(strSql);
if (res.Tables[0].Rows.Count > 0)
{
Row_C_KEYPART ret = (Row_C_KEYPART)NewRow();
ret.loadData(res.Tables[0].Rows[0]);
return(ret);
}
else
{
return(null);
}
}
public List <C_KEYPART> GetKeypartListBySNAndStation(OleExec sfcdb, string sn, string station)
{
if (string.IsNullOrEmpty(sn))
{
return(null);
}
DataTable dt = null;
Row_C_KEYPART row_main = null;
List <C_KEYPART> mains = new List <C_KEYPART>();
string sql = $@" SELECT B.*
FROM R_WO_BASE A, C_KEYPART B, R_SN C
WHERE A.KP_LIST_ID = B.KEYPART_ID
AND A.WORKORDERNO = C.WORKORDERNO
AND C.SN = '{sn}' --and STATION_NAME='{station}'
ORDER BY B.SEQ_NO ";
if (DBType == DB_TYPE_ENUM.Oracle)
{
try
{
dt = sfcdb.ExecSelect(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
row_main = (Row_C_KEYPART)this.NewRow();
row_main.loadData(dr);
mains.Add(row_main.GetDataObject());
}
}
catch (Exception ex)
{
//MES00000037
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000037", new string[] { ex.Message }));
}
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }));
}
return(mains);
}
public List <C_KEYPART> GetKeypartList(OleExec sfcdb, string skuno, string station)
{
DataTable dt = null;
Row_C_KEYPART row_main = null;
List <C_KEYPART> mains = new List <C_KEYPART>();
string sql = $@" select * from C_KEYPART where 1=1 ";
if (!string.IsNullOrEmpty(skuno))
{
sql += $@" and SKUNO='{skuno}' ";
}
if (!string.IsNullOrEmpty(station))
{
sql += $@" and station_name='{station}' ";
}
if (DBType == DB_TYPE_ENUM.Oracle)
{
try
{
dt = sfcdb.ExecSelect(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
row_main = (Row_C_KEYPART)this.NewRow();
row_main.loadData(dr);
mains.Add(row_main.GetDataObject());
}
}
catch (Exception ex)
{
//MES00000037
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000037", new string[] { ex.Message }));
}
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }));
}
return(mains);
}
