public void Insert(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; T_C_BU_EX Table = null; string NAME = string.Empty; string VALUE = string.Empty; int result; try { sfcdb = this.DBPools["SFCDB"].Borrow(); Table = new T_C_BU_EX(sfcdb, DBTYPE); NAME = Data["NAME"].ToString().Trim(); VALUE = Data["VALUE"].ToString().Trim(); result = Table.Insert(BU, NAME, VALUE, sfcdb, SystemName, DBTYPE); if (result == 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Insert Fail"; StationReturn.Data = new object(); } else if (result > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Insert success"; StationReturn.Data = new object(); } else if (result == -1) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Error name and value existed"; StationReturn.Data = new object(); } if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } catch (Exception e) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Exception"; StationReturn.MessagePara.Add(e.Message); StationReturn.Data = e.Message; if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } }
public void CheckIdSeqNoNameValueIsExist(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; T_C_BU_EX Table = null; string ID = string.Empty; decimal SEQ_NO; string NAME = string.Empty; string VALUE = string.Empty; bool result; try { sfcdb = this.DBPools["SFCDB"].Borrow(); Table = new T_C_BU_EX(sfcdb, DBTYPE); ID = Data["ID"].ToString().Trim(); SEQ_NO = decimal.Parse(Data["SEQ_NO"].ToString().Trim()); NAME = Data["NAME"].ToString().Trim(); VALUE = Data["VALUE"].ToString().Trim(); result = Table.ID_SEQ_NO_NAME_VALUE_IsExist(ID, SEQ_NO, NAME, VALUE, sfcdb); if (!result) //not exist { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "QueryNoData"; StationReturn.Data = new object(); } else // exist { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "QueryOK"; StationReturn.Data = new object(); } if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } catch (Exception e) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Exception"; StationReturn.MessagePara.Add(e.Message); StationReturn.Data = e.Message; if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } }
public void DeleteBuExByIDSEQNO(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; T_C_BU_EX Table = null; string ID = string.Empty; decimal SEQ_NO; int result; try { sfcdb = this.DBPools["SFCDB"].Borrow(); Table = new T_C_BU_EX(sfcdb, DBTYPE); ID = Data["ID"].ToString().Trim(); SEQ_NO = decimal.Parse(Data["SEQ_NO"].ToString().Trim()); result = Table.DeleteBuExByID_SEQ_NO(ID, SEQ_NO, sfcdb); if (result == 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Delete Fail"; StationReturn.Data = new object(); } else { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Delete success"; StationReturn.Data = new object(); } if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } catch (Exception e) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Exception"; StationReturn.MessagePara.Add(e.Message); StationReturn.Data = e.Message; if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } }
public void GetBuExByName(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; List <C_BU_EX> BUExList = new List <C_BU_EX>(); T_C_BU_EX Table = null; string BUNAME = string.Empty; try { sfcdb = this.DBPools["SFCDB"].Borrow(); Table = new T_C_BU_EX(sfcdb, DBTYPE); BUNAME = Data["BUNAME"].ToString().Trim(); BUExList = Table.GetBuExByName(BUNAME, sfcdb); if (BUExList.Count() == 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "QueryNoData"; StationReturn.Data = new object(); } else { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "QueryOK"; StationReturn.MessagePara.Add(BUExList.Count().ToString()); StationReturn.Data = BUExList; } if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } catch (Exception e) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Exception"; StationReturn.MessagePara.Add(e.Message); StationReturn.Data = e.Message; if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } }
public void GetAllBuEx(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec oleDB = null; T_C_BU_EX buex = null; List <C_BU_EX> buexList = new List <C_BU_EX>(); try { oleDB = this.DBPools["SFCDB"].Borrow(); buex = new T_C_BU_EX(oleDB, DBTYPE); buexList = buex.GetAllBUEx(oleDB); if (buexList.Count > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "QueryOK"; StationReturn.MessagePara.Add(buexList.Count); StationReturn.Data = buexList; } else { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "QueryNoData"; StationReturn.Data = ""; } 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); } } }
public void Update(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { C_BU_EX old_data = JsonConvert.DeserializeObject <C_BU_EX>(Data["old_data_obj"].ToString()); C_BU_EX new_data = JsonConvert.DeserializeObject <C_BU_EX>(Data["new_data_obj"].ToString()); OleExec sfcdb = null; T_C_BU_EX Table = null; int result; bool flag; try { sfcdb = this.DBPools["SFCDB"].Borrow(); Table = new T_C_BU_EX(sfcdb, DBTYPE); flag = Table.ID_SEQ_NO_IsExist(old_data.ID, decimal.Parse(old_data.SEQ_NO.ToString()), sfcdb); //check id seq_no exist if (flag) { if ((old_data.NAME + old_data.VALUE) != (new_data.NAME + new_data.VALUE)) { ///check new name and value flag = Table.NAME_VALUE_IsExist(new_data.NAME, new_data.VALUE, sfcdb); if (!flag) { //update result = Table.UpDate(new_data.ID, decimal.Parse(new_data.SEQ_NO.ToString()), new_data.NAME, new_data.VALUE, sfcdb); if (result > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Update success"; StationReturn.Data = new object(); } else { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Update Fail"; StationReturn.Data = new object(); } } else { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Update fail new name and value existed"; StationReturn.Data = new object(); } } else { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Update Fail"; StationReturn.Data = new object(); } } else { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Update Fail"; StationReturn.Data = new object(); } if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } catch (Exception e) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Exception"; StationReturn.MessagePara.Add(e.Message); StationReturn.Data = e.Message; if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } }