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