public static KPListBase GetKPListByListName(string ListName, MESDBHelper.OleExec SFCDB)
{
List <KPListBase> ret = new List <KPListBase>();
T_C_KP_LIST T = new T_C_KP_LIST(SFCDB, MESDataObject.DB_TYPE_ENUM.Oracle);
//List<string> IDS = T.GetListIDBySkuno(Skuno, SFCDB);
string strSql = $@"select ID from c_kp_list where listname='{ListName}'";
DataSet res = SFCDB.RunSelect(strSql);
if (res.Tables[0].Rows.Count > 0)
{
return(new KPListBase(res.Tables[0].Rows[0]["ID"].ToString(), SFCDB));
}
else
{
return(null);
}
}