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