/// <summary>
/// 更新用户
/// </summary>
/// <param name="dicUser">用户信息</param>
/// <returns></returns>
public string UpdateUser(Dictionary <string, string> dicUser)
{
foreach (string key in dicUser.Keys)
{
switch (key)
{
case ColumnName.UserCode:
m_UserCode = dicUser[key];
break;
case ColumnName.UserName:
m_UserName = dicUser[key];
break;
case ColumnName.UserPassword:
m_UserPassword = Encryption.Encrypt(dicUser[key]);
break;
case ColumnName.RoleID:
m_UserRole = new Role(dicUser[key], m_dbOperate);
break;
}
}
if (string.IsNullOrEmpty(m_UserCode))
{
return(string.Format("无法修改用户:用户ID不能为空"));
}
DataTable pTable = m_dbOperate.GetTable(TableName.TUser, string.Format("{0}='{1}'", ColumnName.UserCode, m_UserCode));
if (pTable.Rows.Count <= 0)
{
return(string.Format("无法修改用户:当前用户ID不存在"));
}
if (!m_dbOperate.UpdateTable(TableName.TUser,
string.Format("{0}='{1}'", ColumnName.UserCode, m_UserCode),
string.Format("{0}='{1}'", ColumnName.UserName, m_UserName),
string.Format("{0}='{1}'", ColumnName.UserPassword, m_UserPassword)
))
{
return(string.Format("修改用户失败:请查询相应日志信息"));
}
else
{
if (!m_dbOperate.UpdateTable(TableName.TUserRole,
string.Format("{0}='{1}'", ColumnName.UserCode, m_UserCode),
string.Format("{0}='{1}'", ColumnName.RoleID, m_UserRole.RoleID)))
{
return(string.Format("修改用户授权失败:请查询相应日志信息"));
}
}
return(string.Empty);
}
public string UpdateSysConfig(string ConfigCode, string ConfigValue, string ConfigName = "")
{
if (m_Dboperate == null)
{
return(string.Format("无数据库操作信息"));
}
if (string.IsNullOrEmpty(ConfigCode) || string.IsNullOrEmpty(ConfigValue))
{
return(string.Format("未设置系统配置更新项"));
}
DataTable pConfigDt = m_Dboperate.GetTable(TableName.TSysConfig, string.Empty);
if (pConfigDt == null || pConfigDt.Rows.Count == 0)
{
return(string.Format("无法获取系统配置信息"));
}
DataRow[] pSelectRows = pConfigDt.Select(string.Format("{0}='{1}'", ColumnName.ConfigCode, ConfigCode));
if (pSelectRows.Length <= 0)
{
if (!m_Dboperate.AddRow(TableName.TSysConfig, new List <string> {
ColumnName.ConfigCode, ColumnName.ConfigName, ColumnName.ConfigValue
},
ConfigCode, ConfigName, ConfigValue))
{
return(string.Format("更新表失败，请查看日志信息"));
}
}
else
{
bool flag = false;
if (string.IsNullOrEmpty(ConfigName))
{
flag = m_Dboperate.UpdateTable(TableName.TSysConfig, string.Format("{0}='{1}'", ColumnName.ConfigCode, ConfigCode),
ColumnName.ConfigValue, ConfigValue);
}
else
{
flag = m_Dboperate.UpdateTable(TableName.TSysConfig, string.Format("{0}='{1}'", ColumnName.ConfigCode, ConfigCode),
ColumnName.ConfigValue, ConfigValue,
ColumnName.ConfigName, ConfigName);
}
if (!flag)
{
return(string.Format("更新表失败，请查看日志信息"));
}
}
return(string.Empty);
}
/// <summary>
/// 更新角色信息
/// </summary>
/// <param name="UpdateRole">角色信息</param>
/// <returns></returns>
public string UpdateRole(Dictionary <string, string> UpdateRole)
{
if (UpdateRole == null || UpdateRole.Count <= 0)
{
return(string.Format("更新角色信息失败"));
}
foreach (string key in UpdateRole.Keys)
{
switch (key)
{
case ColumnName.RoleName:
m_RoleName = UpdateRole[key];
break;
case ColumnName.RoleID:
m_RoleID = UpdateRole[key];
break;
}
}
if (!m_DbOperate.UpdateTable(TableName.TRole, string.Format("{0}='{1}'", ColumnName.RoleID, m_RoleID),
string.Format("{0}='{1}'", ColumnName.RoleName, m_RoleName)))
{
return(string.Format("更新角色信息失败：更新数据库失败"));
}
return(string.Empty);
}