public void UpdateSellerRole(Model.RoleInfo model)
{
var updatemodel = Context.RoleInfo.FindBy(a => a.ShopId == model.ShopId && a.Id == model.Id).FirstOrDefault();
if (updatemodel == null)
{
throw new HimallException("找不到该权限组");
}
var ex = Context.RoleInfo.Any(a => a.RoleName == model.RoleName && a.ShopId == model.ShopId && a.RoleName != updatemodel.RoleName);
if (ex)
{
throw new HimallException("已存在相同名称的权限组");
}
updatemodel.RoleName = model.RoleName;
updatemodel.Description = model.Description;
if (string.IsNullOrEmpty(model.Description))
{
updatemodel.Description = model.RoleName;
}
Context.RolePrivilegeInfo.RemoveRange(updatemodel.RolePrivilegeInfo);
updatemodel.RolePrivilegeInfo = model.RolePrivilegeInfo;
Context.SaveChanges();
}
public JsonResult Edit(string roleJson, long id)
{
if (ModelState.IsValid)
{
var shopId = CurrentSellerManager.ShopId;
var s = new Newtonsoft.Json.JsonSerializerSettings();
s.MissingMemberHandling = Newtonsoft.Json.MissingMemberHandling.Ignore;
s.NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore;
Model.RoleInfo role = Newtonsoft.Json.JsonConvert.DeserializeObject <Model.RoleInfo>(roleJson, s);
role.Id = id;
role.ShopId = CurrentSellerManager.ShopId;
_iPrivilegesService.UpdateSellerRole(role);
var users = _iManagerService.GetSellerManagerByRoleId(id, shopId).ToList();
foreach (var user in users)
{
string CACHE_MANAGER_KEY = CacheKeyCollection.Seller(user.Id);
Core.Cache.Remove(CACHE_MANAGER_KEY);
}
}
else
{
return(Json(new { success = true, msg = "验证失败" }));
}
return(Json(new { success = true }));
}
public Model.Result UpdateRole(Model.UserInfo user, Model.RoleInfo role, List <int> menus)
{
using (TransactionScope ts = new TransactionScope())
{
try
{
string sql = "select count(1) from RoleInfo where RoleName='" + role.RoleName + "' and RoleID !=" + role.RoleID;
int count = (int)DbHelper.SqlHelper.ExecuteScalarByString(sql, new Dictionary <string, object>());
if (count > 0)
{
return(new Model.Result()
{
ReturnValue = false, Message = "已存在相同名称的角色，修改失败！"
});
}
sql = @" update RoleInfo set roleName ='" + role.RoleName + @"',Note = '" + role.Note + @"'
delete from RoleMenuInfo where RoleID=" + role.RoleID;
sql += " insert into RoleMenuInfo(RoleID,MenuID)";
int index = 1;
foreach (var item in menus)
{
sql += "select " + role.RoleID + "," + item;
if (index < menus.Count)
{
sql += " union ";
}
index++;
}
sql += " if(@@error=0) begin select 1 end else begin select -1 end ";
count = (int)DbHelper.SqlHelper.ExecuteScalarByString(sql, new Dictionary <string, object>());
if (count == 1)
{
ts.Complete();
return(new Model.Result()
{
ReturnValue = true, Message = "修改成功！"
});
}
return(new Model.Result()
{
ReturnValue = false, Message = "修改失败！"
});
}
catch (Exception ex)
{
return(new Model.Result()
{
ReturnValue = false, Message = ex.Message
});
}
}
}
/// <summary>
/// 添加一个角色
/// </summary>
/// <param name="RoleInfo"></param>
/// <returns></returns>
public bool InsertRole(Model.RoleInfo RoleInfo)
{
const string sql =
@"INSERT INTO RoleInfo(RoleCode,RoleName,MenuIdList) VALUES(@RoleCode,@RoleName,0)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
RoleInfo.RoleCode,
RoleInfo.RoleName
})));
}
public ActionResult Add(Model.RoleInfo RoleInfo)
{
ViewData["deptSelectItems"] = GetdeptSelectItems();
Business.Sys_Role Sys_Role = new Business.Sys_Role();
if (Sys_Role.InsertRole(RoleInfo))
{
Response.Write("<script>parent.layer.closeAll();</script>");
}
else
{
Response.Write("<script>parent.layer.closeAll();</script>");
}
return(View());
}
protected void bind()
{
if (roleid > 0)
{
Model.RoleInfo info = BLL.RolesBLL.GetModel(roleid);
if (info != null && info.RoleID == roleid)
{
hfRoleID.Value = info.RoleID.ToString();
txbRoleName.Text = info.RoleName;
txbDescription.Text = info.Description;
txbIconFile.Text = hfIconFile.Value = info.IconFile;
}
}
}
public JsonResult Add(string roleJson)
{
if (ModelState.IsValid)
{
var s = new Newtonsoft.Json.JsonSerializerSettings();
s.MissingMemberHandling = Newtonsoft.Json.MissingMemberHandling.Ignore;
s.NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore;
Model.RoleInfo role = Newtonsoft.Json.JsonConvert.DeserializeObject <Model.RoleInfo>(roleJson, s);
_iPrivilegesService.AddPlatformRole(role);
}
else
{
return(Json(new { success = true, msg = "验证失败" }));
}
return(Json(new { success = true }));
}
public void AddPlatformRole(Model.RoleInfo model)
{
model.ShopId = 0L;
if (string.IsNullOrEmpty(model.Description))
{
model.Description = model.RoleName;
}
var ex = Context.RoleInfo.Any(a => a.RoleName == model.RoleName && a.ShopId == model.ShopId);
if (ex)
{
throw new HimallException("已存在相同名称的权限组");
}
Context.RoleInfo.Add(model);
Context.SaveChanges();
}
public ActionResult SetRoleInfo(string deptSelectItems)
{
ViewData["SetRoleInfoId"] = Request["SetRoleInfoId"];
ViewData["deptSelectItems"] = GetdeptSelectItems();
string RoleCode = Request["deptSelectItems"];
Business.Sys_Role Sys_Role = new Business.Sys_Role();
Model.RoleInfo RoleInfo = Sys_Role.GetRoleInfoByRoleCode(RoleCode);
string SetRoleInfoId = Request["SetRoleInfoId"];
Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin();
if (Sys_UserAdmin.SetUserAdminRole(SetRoleInfoId, RoleInfo.RoleCode, RoleInfo.RoleName))
{
}
Response.Write("<script>parent.layer.closeAll();</script>");
return(View());
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
Model.RoleInfo info = new Model.RoleInfo();
info.RoleID = Convert.ToInt32(hfRoleID.Value);
info.RoleName = txbRoleName.Text.Trim();
info.Description = txbDescription.Text.Trim();
info.IconFile = hfIconFile.Value;
info.LastModifiedOnDate = DateTime.Now;
info.LastModifiedByUserID = base.UserID;
if (info.RoleID > 0)
{
int returnval = BLL.RolesBLL.Update(info);
if (returnval > 0)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "editrole", "alert('修改成功！');location.href='ViewRoles.aspx';", true);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "editrole", "alert('修改失败！');", true);
}
}
else
{
info.RoleID = BLL.RolesBLL.GetMaxId() + 1;
int returnval = BLL.RolesBLL.Add(info);
if (returnval > 0)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "addrole", "alert('添加成功！');closediv();", true);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "addrole", "alert('添加失败！');", true);
}
}
}
catch (Exception exc)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "addrele", "alert('提交失败," + exc.Message + "！');", true);
}
}
public ActionResult AddRole(string name, string remark, int sort)
{
string jsondata;
Model.RoleInfo roleInfo = new Model.RoleInfo();
roleInfo.Remark = remark;
roleInfo.Sort = sort;
roleInfo.Name = name;
roleInfo.SubTime = DateTime.Now;
roleInfo.DelFlag = true;
var role = roleInfoService.AddEntity(roleInfo);
if (role.ID != 0 && role != null)
{
jsondata = Common.JsonHelper.ResposeJson(200, null, "ok");
return(Content(jsondata));
}
jsondata = Common.JsonHelper.ResposeJson(404, null, "添加失败");
return(Content(jsondata));
}
public ActionResult SetMenuInfo()
{
Business.Sys_Role Sys_Role = new Business.Sys_Role();
Model.RoleInfo RoleInfo = Sys_Role.GetRoleInfoByRoleID(Request["RoleId"]);
string UsersId = Request["UsersId"];
string[] MenuList = new string[1000000];
if (!string.IsNullOrEmpty(RoleInfo.MenuIdList))
{
MenuList = RoleInfo.MenuIdList.Split(',');
}
Business.Sys_Menu Sys_Menu = new Business.Sys_Menu();
List <Model.Menu> MenuParentList = Sys_Menu.GetMenuListByHierarchy("1");
List <Model.Menu> MenuChildrenList = Sys_Menu.GetMenuListByHierarchy("2");
StringBuilder sb = new StringBuilder();
sb.Append("<div class=\"panel-body\" style=\"padding-bottom:0px;\">");
foreach (var item in MenuParentList)
{
bool CheckParent = false;
sb.Append("<div class=\"panel panel-default\">");
for (int i = 0; i < MenuList.Length; i++)
{
if (int.Parse(MenuList[i]) == item.id)
{
CheckParent = true;
sb.Append("<div class=\"panel-heading\"><input type=\"checkbox\" checked=\"checked\" class=\"" + item.MenuCode + "\" id=\"" + item.MenuCode + "\" name=\"MenuListInfo\" onclick=\"FillCheckBox(this)\" value=\"" + item.id + "\"/>" + item.MenuName + "(" + item.Terminal + ")");
break;
}
}
if (!CheckParent)
{
sb.Append("<div class=\"panel-heading\"><input type=\"checkbox\" class=\"" + item.MenuCode + "\" id=\"" + item.MenuCode + "\" name=\"MenuListInfo\" onclick=\"FillCheckBox(this)\" value=\"" + item.id + "\"/>" + item.MenuName + "(" + item.Terminal + ")");
}
sb.Append("<div class=\"panel-body\"><div id=\"formSearch\" div=\"form-horizontal\">");
List <Model.Menu> MenuChildrenListByItem = MenuChildrenList.Where(x => x.SuperiorMenuID == item.id).ToList();
foreach (var items in MenuChildrenListByItem)
{
bool CheckChildren = false;
sb.Append("<label class=\"control-label col-sm-2\" for=\"txt_search_departmentname\">");
for (int i = 0; i < MenuList.Length; i++)
{
if (int.Parse(MenuList[i]) == items.id)
{
CheckChildren = true;
sb.Append("<input name=\"MenuListInfo\" type=\"checkbox\" checked=\"checked\" class=\"" + item.MenuCode + "\" onclick=\"CheckBoxChilrden(this)\" value=\"" + items.id + "\" />" + items.MenuName + "");
break;
}
}
if (!CheckChildren)
{
sb.Append("<input name=\"MenuListInfo\" type=\"checkbox\" class=\"" + item.MenuCode + "\" onclick=\"CheckBoxChilrden(this)\" value=\"" + items.id + "\" />" + items.MenuName + "");
}
sb.Append("</label>");
}
sb.Append("</div></div></div></div>");
}
sb.Append("</div>");
ViewData["MenuInfoList"] = sb.ToString();
ViewData["RoleId"] = Request["RoleId"];
return(View());
}
public Model.Result AddRole(Model.UserInfo user, Model.RoleInfo role, List <int> menus)
{
using (TransactionScope ts = new TransactionScope())
{
try
{
string sql = "select count(1) from RoleInfo where RoleName='" + role.RoleName + "'";
int count = (int)DbHelper.SqlHelper.ExecuteScalarByString(sql, new Dictionary <string, object>());
if (count > 0)
{
return(new Model.Result()
{
ReturnValue = false, Message = "已存在相同名称的角色，保存失败！"
});
}
sql = @"insert into RoleInfo(RoleName,Note)values(@name,@note)
if (@@ROWCOUNT=1) begin select RoleID from RoleInfo where RoleName=@name end else begin select -1 end";
Dictionary <string, object> indic = new Dictionary <string, object>();
indic.Add("@name", role.RoleName);
indic.Add("@note", role.Note);
int roleID = (int)DbHelper.SqlHelper.ExecuteScalarByString(sql, indic);
if (roleID == -1)
{
return(new Model.Result()
{
ReturnValue = false, Message = "保存失败！"
});
}
sql = "insert into RoleMenuInfo(RoleID,MenuID)";
int index = 1;
foreach (var item in menus)
{
sql += "select " + roleID + "," + item;
if (index < menus.Count)
{
sql += " union ";
}
index++;
}
count = DbHelper.SqlHelper.ExecuteNonQuery(sql, new Dictionary <string, object>());
if (count == menus.Count)
{
ts.Complete();
return(new Model.Result()
{
ReturnValue = true, Message = "保存成功！"
});
}
return(new Model.Result()
{
ReturnValue = false, Message = "保存失败！"
});
}
catch (Exception ex)
{
return(new Model.Result()
{
ReturnValue = false, Message = ex.Message
});
}
}
}
public ActionResult GetCode()
{
try
{
string code = Request["code"];
Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin();
string OpenId = WxHelper.WxMain.Getopenid(code);
Model.UserAdmin UserAdmin = Sys_UserAdmin.GetUserAdminByOpendId(OpenId);
Session["OpenId"] = OpenId;
if (UserAdmin != null && UserAdmin.RoleCode != "Tourist")
{
Session["UsersId"] = UserAdmin.ID;
Session["UserName"] = UserAdmin.UserName;
Session["RealName"] = UserAdmin.RealName;
Session["RoleCode"] = UserAdmin.RoleCode;
if (Request["way"] == "Arrangement")
{
string gzhurl = "https://mp.weixin.qq.com/mp/profile_ext?action=home&__biz=" + System.Configuration.ConfigurationManager.AppSettings["WxAppId"] + "&scene=110#wechat_redirect";
Utility.PostData.GetData(gzhurl);
return(RedirectToAction("GetArrangementInfo", "MMain", new { ArrangementId = Request["id"] }));
}
else
{
return(RedirectToAction("Index", "MMIndex"));
}
}
else if (Request["way"] == "Arrangement")
{
string gzhurl = "https://mp.weixin.qq.com/mp/profile_ext?action=home&__biz=" + System.Configuration.ConfigurationManager.AppSettings["WxAppId"] + "&scene=110#wechat_redirect";
Utility.PostData.GetData(gzhurl);//自动关注公众号
if (UserAdmin == null)
{
System.Random Random = new System.Random();
int Result = Random.Next(0, 9999);
Business.Sys_Role Sys_Role = new Business.Sys_Role();
Model.RoleInfo RoleInfo = Sys_Role.GetRoleInfoByRoleCode("Tourist");
//写入一条记录 标识为游客
Model.UserAdmin UserAdminTourist = new Model.UserAdmin();
UserAdminTourist.UserName = "******" + Result.ToString() + DateTime.Now.ToString("yyyy-MM-dd");
UserAdminTourist.PassWord = Utility.ChangeText.md5("123456");
UserAdminTourist.IsEnable = 0;
UserAdminTourist.OpenId = OpenId;
UserAdminTourist.RoleCode = RoleInfo.RoleCode;
UserAdminTourist.RoleName = RoleInfo.RoleName;
UserAdminTourist.RealName = "游客未知";
Session["UsersId"] = Sys_UserAdmin.InsertUserAdminGetId(UserAdminTourist);
Session["UserName"] = UserAdminTourist.UserName;
Session["RealName"] = UserAdminTourist.RealName;
Session["RoleCode"] = UserAdminTourist.RoleCode;
return(RedirectToAction("GetArrangementInfo", "MMain", new { ArrangementId = Request["id"] }));
}
if (UserAdmin.RoleCode == "Tourist")
{
Session["UsersId"] = UserAdmin.ID;
Session["UserName"] = UserAdmin.UserName;
Session["RealName"] = UserAdmin.RealName;
Session["RoleCode"] = UserAdmin.RoleCode;
return(RedirectToAction("GetArrangementInfo", "MMain", new { ArrangementId = Request["id"] }));
}
}
return(RedirectToAction("Index", "MLogin"));
}
catch (Exception ex)
{
Utility.Log.WriteTextLog("微信自动登陆异常", "", "", "", ex.ToString());
return(null);
}
}
