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