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