public string SaveFunInfo(PSS.Model.Sys_Function model)
{
if (model.FunID == 0)
{
//add
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.FunName != null)
{
strSql1.Append("FunName,");
strSql2.Append("'" + model.FunName + "',");
}
if (model.EnFunName != null)
{
strSql1.Append("EnFunName,");
strSql2.Append("'" + model.EnFunName + "',");
}
if (model.FunUrl != null)
{
strSql1.Append("FunUrl,");
strSql2.Append("'" + model.FunUrl + "',");
}
if (model.FunParentID != null)
{
strSql1.Append("FunParentID,");
strSql2.Append("" + model.FunParentID + ",");
}
if (model.IsEnable != null)
{
strSql1.Append("IsEnable,");
strSql2.Append("" + (model.IsEnable ? 1 : 0) + ",");
}
if (model.OrderIndex != null)
{
strSql1.Append("OrderIndex,");
strSql2.Append("" + model.OrderIndex + ",");
}
strSql.Append("insert into Sys_Function(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DataSource.GetSingle(strSql.ToString());
if (obj == null)
{
return JsonMessage.FailString("保存失败，请重新提交！");
}
else
{
return JsonMessage.SuccessString(obj.ToString());
}
}
else
{
//modify
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Function set ");
if (model.FunName != null)
{
strSql.Append("FunName='" + model.FunName + "',");
}
if (model.EnFunName != null)
{
strSql.Append("EnFunName='" + model.EnFunName + "',");
}
else
{
strSql.Append("EnFunName= null ,");
}
if (model.FunUrl != null)
{
strSql.Append("FunUrl='" + model.FunUrl + "',");
}
if (model.FunParentID != null)
{
strSql.Append("FunParentID=" + model.FunParentID + ",");
}
if (model.IsEnable != null)
{
strSql.Append("IsEnable=" + (model.IsEnable ? 1 : 0) + ",");
}
if (model.OrderIndex != null)
{
strSql.Append("OrderIndex=" + model.OrderIndex + ",");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where FunID=" + model.FunID + "");
int rowsAffected = DataSource.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return JsonMessage.SuccessString(model.FunID.ToString());
}
else
{
return JsonMessage.FailString("保存失败，请重新提交！");
}
}
}
public string ModifyPwd(PSS.Model.Sys_User_ModifyPwd table)
{
if (table.UserID == 0)
{
return JsonMessage.FailString("请从【用户管理】功能进入修改，请勿直接进入当前页操作！");
}
if (!table.newPwd.Equals(table.newPwd_Confirm))
{
return JsonMessage.FailString("请核对新密码和确认密码是否一致！");
}
string UserLoginName = GetLoginNameByUserID(table.UserID);
string result = string.Empty;
if (!CheckPwdIsRight(UserLoginName, table.oldPwd, ref result))
{
return JsonMessage.FailString(result);
}
string strSql = "update Sys_User set UserLoginPwd = '" + GetSHA1Password(UserLoginName + table.newPwd) + "' where UserID = '" + table.UserID + "'";
int rows = DataSource.ExecuteSql(strSql);
if (rows > 0)
{
return JsonMessage.SuccessString();
}
else
{
return JsonMessage.FailString("登录名为：" + UserLoginName + "的账号不存在，无法进行密码修改操作！");
}
}
public string Save(PSS.Model.Sys_User model)
{
if (CheckLoginNameIsExists(model.UserID, model.UserLoginName))
{
return JsonMessage.FailString("当前登录名已存在，请重新输入！");
}
if (model.UserID == 0)
{
//add
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.UserName != null)
{
strSql1.Append("UserName,");
strSql2.Append("'" + model.UserName + "',");
}
if (model.UserLoginName != null)
{
strSql1.Append("UserLoginName,");
strSql2.Append("'" + model.UserLoginName + "',");
}
strSql1.Append("UserLoginPwd,");
strSql2.Append("'" + GetSHA1Password(model.UserLoginName + "666666") + "',");
strSql1.Append("IsEnable,");
strSql2.Append("" + (model.IsEnable ? 1 : 0) + ",");
if (model.InDate != null)
{
strSql1.Append("InDate,");
strSql2.Append("'" + model.InDate + "',");
}
if (model.Treatment != null)
{
strSql1.Append("Treatment,");
strSql2.Append("'" + model.Treatment + "',");
}
strSql.Append("insert into Sys_User(");
strSql.Append(strSql1.ToString().TrimEnd(','));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().TrimEnd(','));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DataSource.GetSingle(strSql.ToString());
if (obj == null)
{
return JsonMessage.FailString("保存失败，请重新提交！");
}
else
{
if (!string.IsNullOrEmpty(model.DepID.ToString()))
{
string sql = "insert into Sys_UserDep(UserID,DepID) values('" + obj + "','" + model.DepID + "')";
DataSource.ExecuteSql(sql);
}
return JsonMessage.SuccessString(obj.ToString());
}
}
else
{
//modify
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_User set ");
if (model.UserName != null)
{
strSql.Append("UserName='******',");
}
else
{
strSql.Append("UserName= null ,");
}
if (model.UserLoginName != null)
{
strSql.Append("UserLoginName='" + model.UserLoginName + "',");
}
else
{
strSql.Append("UserLoginName= null ,");
}
strSql.Append("IsEnable=" + (model.IsEnable ? 1 : 0) + ",");
if (model.InDate != null)
{
strSql.Append("InDate='" + model.InDate + "',");
}
else
{
strSql.Append("InDate= null ,");
}
if (model.Treatment != null)
{
strSql.Append("Treatment='" + model.Treatment + "',");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where UserID=" + model.UserID + "");
int rowsAffected = DataSource.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
if (!string.IsNullOrEmpty(model.DepID.ToString()))
{
string sql = "if not exists(select UserID from Sys_UserDep where UserID = '" + model.UserID + "') begin insert into Sys_UserDep(UserID,DepID) values('" + model.UserID + "','" + model.DepID + "'); end else begin update Sys_UserDep set DepID = '" + model.DepID + "' where UserID = '" + model.UserID + "' end";
DataSource.ExecuteSql(sql);
}
return JsonMessage.SuccessString(model.UserID.ToString());
}
else
{
return JsonMessage.FailString("保存失败，请重新提交！");
}
}
}
/// <summary>
/// 保存方法
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Save(PSS.Model.Sys_Role model)
{
if (CheckRoleNameIsExists(model.RoleID, model.RoleName))
{
return JsonMessage.FailString("当前登录名已存在，请重新输入！");
}
if (model.RoleID == 0)
{
//add
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.RoleName != null)
{
strSql1.Append("RoleName,");
strSql2.Append("'" + model.RoleName + "',");
}
if (model.IsEnable != null)
{
strSql1.Append("IsEnable,");
strSql2.Append("" + (model.IsEnable ? 1 : 0) + ",");
}
strSql.Append("insert into Sys_Role(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DataSource.GetSingle(strSql.ToString());
if (obj == null)
{
return JsonMessage.FailString("保存失败，请重新提交！");
}
else
{
return JsonMessage.SuccessString(obj.ToString());
}
}
else
{
//modify
if (model.RoleName == "超级管理员" && !model.IsEnable)
{
return JsonMessage.FailString("超级管理员角色禁止禁用操作！");
}
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Role set ");
if (model.RoleName != null)
{
strSql.Append("RoleName='" + model.RoleName + "',");
}
if (model.IsEnable != null)
{
strSql.Append("IsEnable=" + (model.IsEnable ? 1 : 0) + ",");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where RoleID=" + model.RoleID + "");
int rowsAffected = DataSource.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return JsonMessage.SuccessString(model.RoleID.ToString());
}
else
{
return JsonMessage.FailString("保存失败，请重新提交！");
}
}
}
