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