public List <string> GetRepairItemsSonList(string ItemsID, OleExec DB)
{
string strSql = string.Empty;
//if (string.IsNullOrEmpty(ItemsID))
//{
// strSql = $@" select *from c_repair_items_son where items_id in (select min(id) from c_repair_items where 1=1 )";
//}
//else
//{
strSql = $@" select *from c_repair_items_son where items_id ='{ItemsID}'";
// }
List <string> result = new List <string>();
DataTable res = DB.ExecSelect(strSql).Tables[0];
result.Add(""); ///BY SDL 加載頁面默認賦予空值,操作員必須點選其他有內容選項
if (res.Rows.Count > 0)
{
for (int i = 0; i < res.Rows.Count; i++)
{
Row_C_REPAIR_ITEMS_SON ret = (Row_C_REPAIR_ITEMS_SON)NewRow();
ret.loadData(res.Rows[i]);
result.Add(ret.GetDataObject().ITEMS_SON);
}
}
return(result);
}
public Row_C_REPAIR_ITEMS_SON GetIDByItemsSon(string _ItemSon, OleExec DB)
{
string strsql = "";
if (DBType == DB_TYPE_ENUM.Oracle)
{
strsql = $@"select ID from c_repair_items_son where items_son='{_ItemSon.Replace("'", "''")}'";
string ID = DB.ExecSelectOneValue(strsql)?.ToString();
if (ID == null)
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000007", new string[] { "ItemSon:" + _ItemSon });
throw new MESReturnMessage(errMsg);
}
Row_C_REPAIR_ITEMS_SON R = (Row_C_REPAIR_ITEMS_SON)this.GetObjByID(ID, DB);
return(R);
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
}
