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); }