public void DeleteBU(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
string id = Data["BU_ID"].ToString().Trim();
OleExec oleDB = null;
T_C_BU bu = null;
Row_C_BU rowBU = null;
if (string.IsNullOrEmpty(id))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("BU ID");
StationReturn.Data = "";
return;
}
try
{
oleDB = this.DBPools["SFCDB"].Borrow();
bu = new T_C_BU(oleDB, DBTYPE);
oleDB.ThrowSqlExeception = true;
rowBU = (Row_C_BU)bu.GetObjByID(id, oleDB, DBTYPE);
oleDB.ExecSQL(rowBU.GetDeleteString(DBTYPE));
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000004";
this.DBPools["SFCDB"].Return(oleDB);
}
catch (Exception exception)
{
this.DBPools["SFCDB"].Return(oleDB);
throw exception;
}
}
public void QueryBU(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
string strBU = Data["BU"].ToString().Trim();
OleExec oleDB = null;
T_C_BU bu = null;
List <C_BU> buList = new List <C_BU>();
try
{
oleDB = this.DBPools["SFCDB"].Borrow();
bu = new T_C_BU(oleDB, DBTYPE);
buList = bu.GetBUList(oleDB, strBU);
if (buList.Count > 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000033";
StationReturn.MessagePara.Add(buList.Count);
StationReturn.Data = buList;
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000034";
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(oleDB);
}
catch (Exception exception)
{
this.DBPools["SFCDB"].Return(oleDB);
throw exception;
}
}
public void InitBu(OleExec db)
{
DataTable dt = new DataTable();
List <string> allbu = new List <string>();
T_C_BU bu = new T_C_BU(db, DB_TYPE_ENUM.Oracle);
dt = bu.GetAllBu(db);
foreach (DataRow dr in dt.Rows)
{
allbu.Add(dr["BU"].ToString());
}
Bu.ValueForUse = allbu;
}
public void AddNewBU(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
string strbu = Data["BU"].ToString().Trim();
OleExec oleDB = null;
T_C_BU bu = null;
Row_C_BU buRow = null;
try
{
oleDB = this.DBPools["SFCDB"].Borrow();
bu = new T_C_BU(oleDB, DBTYPE);
if (bu.BUIsExist(oleDB, strbu))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000005";
StationReturn.Data = "";
}
else
{
buRow = (Row_C_BU)bu.NewRow();
buRow.ID = bu.GetNewID(SystemName, oleDB, DBTYPE);
buRow.BU = strbu;
oleDB.ThrowSqlExeception = true;
oleDB.ExecSQL(buRow.GetInsertString(DBTYPE));
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000002";
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(oleDB);
}
catch (Exception exception)
{
this.DBPools["SFCDB"].Return(oleDB);
throw exception;
}
}