public Row_C_SKU_SAMPLE GetBySkuNo(string _SkuNo, string _Station, OleExec DB)
{
string strsql = "";
if (DBType == DB_TYPE_ENUM.Oracle)
{
strsql = $@" select ID from c_sku_sample where skuno='{_SkuNo.Replace("'", "''")}' and station_name='{_Station.Replace("'", "''")}'";
string ID = DB.ExecSelectOneValue(strsql)?.ToString();
if (ID == null)
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000189", new string[] { _SkuNo, _Station });
throw new MESReturnMessage(errMsg);
}
Row_C_SKU_SAMPLE R = (Row_C_SKU_SAMPLE)this.GetObjByID(ID, DB);
return(R);
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
}
public List <C_SKU_SAMPLE> GetSample(string skuno, string station, OleExec DB)
{
List <C_SKU_SAMPLE> aqls = new List <C_SKU_SAMPLE>();
string sql = string.Empty;
DataTable dt = new DataTable("C_SKU_SAMPLE");
Row_C_SKU_SAMPLE aqlsRow = (Row_C_SKU_SAMPLE)NewRow();
if (this.DBType.Equals(DB_TYPE_ENUM.Oracle))
{
sql = $@" select * from c_Sku_Sample where 1=1 ";
if (skuno != "")
{
sql += $@" and skuno='{skuno}' ";
}
if (station != "")
{
sql += $@" and STATION_NAME='{station}' ";
}
if (skuno == "" && station == "")
{
sql += $@" and rownum<21 order by EDIT_TIME ";
}
dt = DB.ExecSelect(sql, null).Tables[0];
foreach (DataRow dr in dt.Rows)
{
aqlsRow.loadData(dr);
aqls.Add(aqlsRow.GetDataObject());
}
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
return(aqls);
}