public ActionResult SaveGroup(SupplierRoleInfo roleinfo)
{
var supplierID = CurrentUser.SupplierID;
try
{
if (SupplierUserBll.ExistsSupplierRoleName(supplierID, roleinfo.RoleID, roleinfo.RoleName))
{
return(Json(new { Error = 1, Message = "此分組名已存在" }));
}
var falg = SupplierUserBll.SaveSupplierRoleInfo(supplierID, roleinfo);
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 SaveSupplierRoleInfo(int supplierID, SupplierRoleInfo role)
{
string UPDATE_SQL = "";
var db = DbSFO2OMain;
var parameters = db.CreateParameterCollection();
parameters.Append("SupplierID", supplierID);
parameters.Append("RoleName", role.RoleName);
string Part_Sql = "";
if (role.MenuIdList != null && role.MenuIdList.Count > 0)
{
Part_Sql = "INSERT INTO SupplierMenuRole(MenuId,RoleID)VALUES" + String.Join(",", role.MenuIdList.Select(p => "(" + p.ToString() + ",@RoleID)"));
}
if (role.RoleID != 0) //编辑
{
UPDATE_SQL = string.Format(@"begin transaction
declare @error int
set @error = 0
DELETE mr
FROM SupplierMenuRole mr
INNER JOIN SupplierRole r ON r.RoleID=mr.RoleID
WHERE r.RoleID=@RoleID AND r.SupplierID=@SupplierID
set @error = @error + @@error
update SupplierRole set RoleName=@RoleName WHERE SupplierID=@SupplierID AND RoleID=@RoleID
set @error = @error + @@error
{0}
set @error = @error + @@error
if @error <> 0
rollback transaction
else
commit transaction", Part_Sql);
parameters.Append("RoleID", role.RoleID);
}
else
{
UPDATE_SQL = string.Format(@"begin transaction
declare @error int;
declare @RoleID int;
set @error = 0;
set @RoleID= 0
--添加角色
insert into SupplierRole(RoleName,Status,SupplierID)values(@RoleName,1,@SupplierID)
set @error = @error + @@error
set @RoleID = ( select Scope_Identity() as RoleID)
--添加关系
{0}
set @error = @error + @@error
if @error <> 0
rollback transaction
else
commit transaction", Part_Sql);
}
try
{
return(db.ExecuteSqlNonQuery(UPDATE_SQL, parameters) > 0);
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(false);
}
public static bool SaveSupplierRoleInfo(int supplierID, SupplierRoleInfo role)
{
return(supplierUserDAL.SaveSupplierRoleInfo(supplierID, role));
}
