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