public void DeleteFactory(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec oleDB = null; T_C_FACTORY Table = null; string ID = string.Empty; int result; try { oleDB = this.DBPools["SFCDB"].Borrow(); Table = new T_C_FACTORY(oleDB, DBTYPE); ID = Data["ID"].ToString().Trim(); result = Table.Delete(ID, oleDB); if (result == 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Delete success"; StationReturn.Data = new object(); } else if (result == 1) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Delete fail"; StationReturn.Data = new object(); } else if (result == 2) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Delete fail ID is empty"; StationReturn.Data = new object(); } else if (result == 3) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.Data = new object(); } if (oleDB != null) { this.DBPools["SFCDB"].Return(oleDB); } } catch (Exception e) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.MessagePara.Add(e.Message); StationReturn.Data = e.Message; if (oleDB != null) { this.DBPools["SFCDB"].Return(oleDB); } } }
public void GetAllFactory(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec oleDB = null; T_C_FACTORY factory = null; string FACTORY_CODE = string.Empty; List <C_FACTORY> factoryList = new List <C_FACTORY>(); try { oleDB = this.DBPools["SFCDB"].Borrow(); factory = new T_C_FACTORY(oleDB, DBTYPE); FACTORY_CODE = Data["FACTORY_CODE"].ToString().Trim().ToUpper(); factoryList = factory.GetAllFactory(FACTORY_CODE, oleDB); if (factoryList.Count > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000033"; StationReturn.MessagePara.Add(factoryList.Count); StationReturn.Data = factoryList; } else { StationReturn.Status = StationReturnStatusValue.Fail; 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); } } }
public void UpdateFactory(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec oleDB = null; T_C_FACTORY Table = null; string ID = string.Empty; string FACTORY_CODE = string.Empty; string FACTORY_NAME = string.Empty; string FACTORY_ADDRESS = string.Empty; string DESCRIPTION = string.Empty; string EDIT_EMP = string.Empty; int result; try { oleDB = this.DBPools["SFCDB"].Borrow(); Table = new T_C_FACTORY(oleDB, DBTYPE); ID = Data["ID"].ToString().Trim(); FACTORY_CODE = Data["FACTORY_CODE"].ToString().Trim().ToUpper(); FACTORY_NAME = Data["FACTORY_NAME"].ToString().Trim().ToUpper(); FACTORY_ADDRESS = Data["FACTORY_ADDRESS"].ToString().Trim().ToUpper(); DESCRIPTION = Data["DESCRIPTION"].ToString().Trim(); EDIT_EMP = LoginUser.EMP_NO.Trim(); result = Table.Update(ID, FACTORY_CODE, FACTORY_NAME, FACTORY_ADDRESS, DESCRIPTION, EDIT_EMP, oleDB); if (result == 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Update fail ID not exist"; StationReturn.Data = new object(); } else if (result == 1) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Update fail Factorycode, Factoryname, Factoryaddress existed "; StationReturn.Data = new object(); } else if (result == 2) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "Update success"; StationReturn.Data = new object(); } else if (result == 3) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "Update fail"; StationReturn.Data = new object(); } else if (result == 4) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.Data = new object(); } if (oleDB != null) { this.DBPools["SFCDB"].Return(oleDB); } } catch (Exception e) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.MessagePara.Add(e.Message); StationReturn.Data = e.Message; if (oleDB != null) { this.DBPools["SFCDB"].Return(oleDB); } } }