public bool SetSystemParameter(SystemParameter systemParameter, string userName, out string error) { error = string.Empty; bool result = false; var query = SystemParameterRepository.GetQueryable().FirstOrDefault(a => a.Id == systemParameter.Id); if (query != null) { try { query.ParameterName = systemParameter.ParameterName; query.ParameterValue = systemParameter.ParameterValue; query.Remark = systemParameter.Remark; query.UserName = userName; query.SystemID = systemParameter.SystemID; SystemParameterRepository.SaveChanges(); result = true; } catch (Exception ex) { error = "原因:" + ex.Message; } } else { error = "原因:未找到当前需要修改的数据!"; } return(result); }
public bool SetSystemParameter(AUTH_SYSTEM_PARAMETER systemParameter, string userName, out string error) { error = string.Empty; bool result = false; var query = SystemParameterRepository.GetQueryable().FirstOrDefault(a => a.ID == systemParameter.ID); if (query != null) { try { query.PARAMETER_NAME = systemParameter.PARAMETER_NAME; query.PARAMETER_VALUE = systemParameter.PARAMETER_VALUE; query.REMARK = systemParameter.REMARK; query.USER_NAME = userName; query.SYSTEM_ID = systemParameter.SYSTEM_ID; SystemParameterRepository.SaveChanges(); result = true; } catch (Exception ex) { error = "原因:" + ex.Message; } } else { error = "原因:未找到当前需要修改的数据!"; } return(result); }
public bool DelSystemParameter(int id, out string error) { error = string.Empty; bool result = false; var query = SystemParameterRepository.GetQueryable().FirstOrDefault(a => a.Id == id); if (query != null) { try { SystemParameterRepository.Delete(query); SystemParameterRepository.SaveChanges(); result = true; } catch (Exception ex) { error = "原因:" + ex.Message; } } else { error = "原因:未找到当前需要删除的数据!"; } return(result); }
public bool AddSystemParameter(SystemParameter systemParameter, string userName, out string error) { error = string.Empty; bool result = false; var query = SystemParameterRepository.GetQueryable().FirstOrDefault(a => a.Id == systemParameter.Id); if (query == null) { SystemParameter sp = new SystemParameter(); if (sp != null) { try { sp.ParameterName = systemParameter.ParameterName; sp.ParameterValue = systemParameter.ParameterValue; sp.Remark = systemParameter.Remark; sp.UserName = userName; sp.SystemID = systemParameter.SystemID; SystemParameterRepository.Add(sp); SystemParameterRepository.SaveChanges(); result = true; } catch (Exception ex) { error = "原因:" + ex.Message; } } else { error = "原因:找不到当前登陆用户!请重新登陆!"; } } else { error = "原因:该编号已存在!"; } return(result); }
public bool AddSystemParameter(AUTH_SYSTEM_PARAMETER systemParameter, string userName, out string error) { error = string.Empty; bool result = false; var query = SystemParameterRepository.GetQueryable().FirstOrDefault(a => a.ID == systemParameter.ID); if (query == null) { AUTH_SYSTEM_PARAMETER sp = new AUTH_SYSTEM_PARAMETER(); if (sp != null) { try { sp.PARAMETER_NAME = systemParameter.PARAMETER_NAME; sp.PARAMETER_VALUE = systemParameter.PARAMETER_VALUE; sp.REMARK = systemParameter.REMARK; sp.USER_NAME = userName; sp.SYSTEM_ID = systemParameter.SYSTEM_ID; SystemParameterRepository.Add(sp); SystemParameterRepository.SaveChanges(); result = true; } catch (Exception ex) { error = "原因:" + ex.Message; } } else { error = "原因:找不到当前登陆用户!请重新登陆!"; } } else { error = "原因:该编号已存在!"; } return(result); }