public void SelectByColumnName(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_SECTION cSection = new T_C_SECTION(sfcdb, DB_TYPE_ENUM.Oracle); List <C_SECTION_DETAIL> list = new List <C_SECTION_DETAIL>(); string data = Data["ColumnValue"].ToString(); string column = Data["ColumnName"].ToString(); list = cSection.GetDataByColumn(column, data, sfcdb); if (list.Count > 0) { StationReturn.Data = list; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000033"; StationReturn.MessagePara.Add(list.Count); } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000034"; StationReturn.Data = ""; } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }
public void DeleteSectionByID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_SECTION cSection = new T_C_SECTION(sfcdb, DB_TYPE_ENUM.Oracle); Row_C_SECTION r = (Row_C_SECTION)cSection.GetObjByID(Data["ID"].ToString(), sfcdb, DB_TYPE_ENUM.Oracle); string strRet = sfcdb.ExecSQL(r.GetDeleteString(DB_TYPE_ENUM.Oracle)); if (Convert.ToInt32(strRet) > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000004"; StationReturn.Data = ""; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "NotLatestData"; } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }
public void ShowAllData(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = this.DBPools["SFCDB"].Borrow(); try { T_C_SECTION cSection = new T_C_SECTION(sfcdb, DB_TYPE_ENUM.Oracle); List <C_SECTION_DETAIL> list = new List <C_SECTION_DETAIL>(); list = cSection.ShowAllData(sfcdb); if (list.Count > 0) { StationReturn.Data = list; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000001"; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000034"; StationReturn.Data = ""; } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }
public void SectionInsert(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_SECTION cSection = new T_C_SECTION(sfcdb, DB_TYPE_ENUM.Oracle); Row_C_SECTION r = (Row_C_SECTION)cSection.NewRow(); r.ID = cSection.GetNewID(BU, sfcdb, DBTYPE); r.SECTION_NAME = (Data["SectionName"].ToString()).Trim(); r.DESCRIPTION = (Data["DESCRIPTION"].ToString()).Trim(); string strRet = sfcdb.ExecSQL(r.GetInsertString(DB_TYPE_ENUM.Oracle)); if (Convert.ToInt32(strRet) > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000002"; StationReturn.Data = strRet; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000036"; StationReturn.Data = ""; } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }
public void DeleteSectionByID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = this.DBPools["SFCDB"].Borrow(); try { T_C_SECTION cSection = new T_C_SECTION(sfcdb, DB_TYPE_ENUM.Oracle); Row_C_SECTION r = (Row_C_SECTION)cSection.GetObjByID(Data["ID"].ToString(), sfcdb, DB_TYPE_ENUM.Oracle); string strRet = sfcdb.ExecSQL(r.GetDeleteString(DB_TYPE_ENUM.Oracle)); if (Convert.ToInt32(strRet) > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "OK"; StationReturn.Data = strRet; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "Delete Fail or Data Not Exist"; } } catch (Exception e) { StationReturn.Message = e.Message; StationReturn.Status = StationReturnStatusValue.Fail; } finally { this.DBPools["SFCDB"].Return(sfcdb); } }
public void SelectByColumnName(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_SECTION cSection = new T_C_SECTION(sfcdb, DB_TYPE_ENUM.Oracle); List <C_SECTION_DETAIL> list = new List <C_SECTION_DETAIL>(); try { string data = Data["ColumnValue"].ToString(); string column = Data["ColumnName"].ToString(); list = cSection.GetDataByColumn(column, data, sfcdb); if (list.Count > 0) { StationReturn.Data = list; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "OK"; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "No data found"; } } catch (Exception) { //StationReturn.Message = e.Message; StationReturn.Message = "ERROE"; StationReturn.Status = StationReturnStatusValue.Fail; } finally { this.DBPools["SFCDB"].Return(sfcdb); } }
public void GetSection(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec oleDB = null; T_C_SECTION sec = null; string SECTION_NAME = string.Empty; List <C_SECTION_DETAIL> List = new List <C_SECTION_DETAIL>(); try { oleDB = this.DBPools["SFCDB"].Borrow(); sec = new T_C_SECTION(oleDB, DBTYPE); SECTION_NAME = Data["SECTION_NAME"].ToString().Trim(); List = sec.GetSectionT(SECTION_NAME, oleDB); if (List.Count > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000033"; StationReturn.MessagePara.Add(List.Count); StationReturn.Data = List; } else { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000034"; StationReturn.Data = new object(); } if (oleDB != null) { this.DBPools["SFCDB"].Return(oleDB); } } catch (Exception exception) { this.DBPools["SFCDB"].Return(oleDB); StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = exception.Message; StationReturn.Data = ""; if (oleDB != null) { this.DBPools["SFCDB"].Return(oleDB); } } }