public void DeleteStationByID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_STATION cStation = new T_C_STATION(sfcdb, DB_TYPE_ENUM.Oracle); Row_C_STATION r = (Row_C_STATION)cStation.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 StationInsert(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_STATION cStation = new T_C_STATION(sfcdb, DB_TYPE_ENUM.Oracle); Row_C_STATION rStation = (Row_C_STATION)cStation.NewRow(); rStation.ID = cStation.GetNewID(BU, sfcdb); rStation.STATION_NAME = (Data["StationName"].ToString()).Trim(); rStation.TYPE = (Data["TYPE"].ToString()).Trim(); string strRet = sfcdb.ExecSQL(rStation.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 SelectByColumnName(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); string data = (Data["ColumnValue"].ToString()).Trim(); string column = (Data["ColumnName"].ToString()).Trim(); T_C_STATION cStation = new T_C_STATION(sfcdb, DB_TYPE_ENUM.Oracle); List <C_STATION_DETAIL> list = new List <C_STATION_DETAIL>(); list = cStation.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 ShowAllData(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_STATION cStation = new T_C_STATION(sfcdb, DB_TYPE_ENUM.Oracle); List <C_STATION_DETAIL> list = new List <C_STATION_DETAIL>(); list = cStation.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 ShowAllData(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = this.DBPools["SFCDB"].Borrow(); try { T_C_STATION cStation = new T_C_STATION(sfcdb, DB_TYPE_ENUM.Oracle); List <C_STATION_DETAIL> list = new List <C_STATION_DETAIL>(); list = cStation.ShowAllData(sfcdb); if (list.Count > 0) { StationReturn.Data = list; StationReturn.Status = "1"; StationReturn.Message = "OK"; } else { StationReturn.Status = "0"; StationReturn.Message = "No data found"; } } catch (Exception e) { StationReturn.Message = e.Message; StationReturn.Status = "0"; } finally { this.DBPools["SFCDB"].Return(sfcdb); } }
public void DeleteStationByID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = this.DBPools["SFCDB"].Borrow(); try { T_C_STATION cStation = new T_C_STATION(sfcdb, DB_TYPE_ENUM.Oracle); Row_C_STATION r = (Row_C_STATION)cStation.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 = "1"; StationReturn.Message = "OK"; StationReturn.Data = strRet; } else { StationReturn.Status = "0"; StationReturn.Message = "Delete Fail or Data Not Exist"; } } catch (Exception e) { StationReturn.Message = e.Message; StationReturn.Status = "0"; } 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(); try { string data = (Data["ColumnValue"].ToString()).Trim(); string column = (Data["ColumnName"].ToString()).Trim(); T_C_STATION cStation = new T_C_STATION(sfcdb, DB_TYPE_ENUM.Oracle); List <C_STATION_DETAIL> list = new List <C_STATION_DETAIL>(); list = cStation.GetDataByColumn(column, data, sfcdb); if (list.Count > 0) { StationReturn.Data = list; StationReturn.Status = "1"; StationReturn.Message = "OK"; } else { StationReturn.Status = "0"; StationReturn.Message = "No data found"; } } catch (Exception e) { StationReturn.Message = e.Message; StationReturn.Status = "0"; } finally { this.DBPools["SFCDB"].Return(sfcdb); } }
public void StationInsert(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = this.DBPools["SFCDB"].Borrow(); try { T_C_STATION cStation = new T_C_STATION(sfcdb, DB_TYPE_ENUM.Oracle); Row_C_STATION rStation = (Row_C_STATION)cStation.NewRow(); rStation.ID = cStation.GetNewID(Data["BU"].ToString(), sfcdb); rStation.STATION_NAME = Data["StationName"].ToString(); rStation.TYPE = Data["TYPE"].ToString(); string strRet = sfcdb.ExecSQL(rStation.GetInsertString(DB_TYPE_ENUM.Oracle)); if (Convert.ToInt32(strRet) > 0) { StationReturn.Status = "1"; StationReturn.Message = "OK"; StationReturn.Data = strRet; } } catch (Exception e) { StationReturn.Status = "0"; StationReturn.Message = e.Message; } finally { this.DBPools["SFCDB"].Return(sfcdb); } }