public ActionResult EditUser(int id = 0)
{
var supplierID = CurrentUser.SupplierID;
try
{
SupplierUserInfo userInfo;
if (id > 0)
{
userInfo = SupplierUserBll.GetSupplierUserBySupplierIDAndUserID(supplierID, id);
}
else
{
userInfo = new SupplierUserInfo();
}
var page = new PageDTO()
{
PageIndex = 1, PageSize = int.MaxValue
};
var RoleList = SupplierUserBll.GetSupplierRoleBySupplierID(supplierID, page);
ViewBag.RoleList = RoleList.Items;
return(View(userInfo));
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(Content(""));
}
private static void GetSupplierLogo(SupplierUserInfo userInfo)
{
if (userInfo.IsAdmin != 1)
{
userInfo.ImageUrl = supplierUserDAL.GetSupplierLogo(userInfo.SupplierID);
}
if (!string.IsNullOrEmpty(userInfo.ImageUrl))
{
userInfo.ImageUrl = ConfigHelper.ImageServer + userInfo.ImageUrl.Replace('\\', '/');
}
}
public static bool SaveSupplierUserInfo(int supplierID, SupplierUserInfo user)
{
try
{
user.Password = MD5Hash.GetMd5String(user.Password);
return(supplierUserDAL.SaveSupplierUserInfo(supplierID, user));
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(false);
}
public JsonResult SaveUser(SupplierUserInfo userinfo)
{
if (userinfo.ID == 0)
{
userinfo.UserName = userinfo.UserName.SafeTrim();
if (string.IsNullOrEmpty(userinfo.UserName))
{
return(Json(new { Error = 1, Message = "請輸入賬號" }));
}
if (userinfo.UserName.Length > 50)
{
return(Json(new { Error = 1, Message = "賬號長度不能超過50個字符" }));
}
if (string.IsNullOrEmpty(userinfo.Password))
{
return(Json(new { Error = 1, Message = "請輸入密碼" }));
}
if (userinfo.Password.Length < 6 || userinfo.Password.Length > 32)
{
return(Json(new { Error = 1, Message = "密碼長度只允許為6到32个字符" }));
}
if (!string.IsNullOrEmpty(userinfo.NickName) && (userinfo.NickName.Length < 4 || userinfo.NickName.Length > 20))
{
return(Json(new { Error = 1, Message = "使用者姓名長度只允許為6到32个字符" }));
}
}
var supplierID = CurrentUser.SupplierID;
try
{
if (userinfo.ID == 0 && SupplierUserBll.ExistsSupplierUserName(userinfo.UserName))
{
return(Json(new { Error = 1, Message = "此賬號已被佔用" }));
}
var falg = SupplierUserBll.SaveSupplierUserInfo(supplierID, userinfo);
if (falg)
{
return(Json(new { Error = 0 }));
}
else
{
return(Json(new { Error = 1 }));
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
return(Json(new { Error = 1, Message = ex.Message }));
}
}
public bool SaveSupplierUserInfo(int supplierID, SupplierUserInfo user)
{
string UPDATE_SQL = "";
var db = DbSFO2OMain;
var parameters = db.CreateParameterCollection();
parameters.Append("SupplierID", supplierID);
parameters.Append("Password", user.Password);
parameters.Append("NickName", user.NickName);
string Part_Sql = "";
if (user.RoleIDList != null && user.RoleIDList.Count > 0)
{
Part_Sql = "INSERT INTO SupplierUserRole(UserID,RoleID)VALUES" + String.Join(",", user.RoleIDList.Select(p => "(@UserID," + p.ToString() + ")"));
}
if (user.ID != 0) //编辑
{
UPDATE_SQL = string.Format(@"begin transaction
declare @error int
set @error = 0
DELETE ur
FROM SupplierUserRole ur
INNER JOIN SupplierUser u ON u.ID=ur.UserID
WHERE u.ID=@UserID AND u.SupplierID=@SupplierID
set @error = @error + @@error
UPDATE SupplierUser SET Password=@Password,NickName=@NickName,UpdateTime=GetDate() WHERE SupplierID=@SupplierID AND ID=@UserID
set @error = @error + @@error
{0}
set @error = @error + @@error
if @error <> 0
rollback transaction
else
commit transaction", Part_Sql);
parameters.Append("UserID", user.ID);
}
else
{
UPDATE_SQL = string.Format(@"begin transaction
declare @error int;
declare @UserID int;
set @error = 0;
--添加用户
INSERT INTO SupplierUser(SupplierID,UserName,Password,Status,IsAdmin,NickName,CreateTime)
VALUES(@SupplierID,@UserName,@Password,1,0,@NickName,GetDate())
set @error = @error + @@error
set @UserID = ( select Scope_Identity() as UserID)
--添加关系
{0}
set @error = @error + @@error
if @error <> 0
rollback transaction
else
commit transaction", Part_Sql);
parameters.Append("UserName", user.UserName);
}
try
{
return(db.ExecuteSqlNonQuery(UPDATE_SQL, parameters) > 0);
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(false);
}
