/// <summary>
/// 编辑功能
/// </summary>
/// <param name="input"></param>
/// <param name="profile"></param>
/// <returns></returns>
public ActionResult EditFunc(Dictionary <string, string> input, sys_member profile)
{
sys_func f = JsonConvert.DeserializeObject <sys_func>(input["inputData"]);
if (input["type"] == "save")
{
_db.Updateable(f).ExecuteCommand();
}
else if (input["type"] == "del")
{
if (!_db.Queryable <sys_func>().Where(_f => _f.pid == f.ID).Any())
{
_db.Deleteable <sys_func>().Where(d => d.ID == f.ID).ExecuteCommand();
}
else
{
return(new ActionResult(false, null, null, "请先删除子节点"));
}
}
else
{
if (f.pid != null && f.pid == 0)
{
f.pid = null;
}
if (input.ContainsKey("child") && input["child"] == "child")
{
f.pid = f.ID;
}
_db.Insertable(f).ExecuteCommand();
}
return(new ActionResult(true));
}
public bool SaveChange(SysMember entity)
{
var snapshot = GetById(entity.ID);
var rlt = _baseQueryRepository.Context.Ado.UseTran(() =>
{
var userTemp = new sys_member();
userTemp.Mapp(entity);
var success = _baseQueryRepository.Context.Updateable(userTemp)
.Where(it => it.ID == entity.ID)
.ExecuteCommand();//主表
snapshot.Roles.Where(r => !entity.Roles.Exists(rr => rr.ID == r.ID)).ToList().ForEach(r =>
{
_baseQueryRepository.Context.Ado.ExecuteCommand("delete from sys_member_roles_link where mid=@mid and rid=@rid;"
, new { mid = entity.ID, rid = r.ID });
});
entity.Roles.Where(r => !snapshot.Roles.Exists(rr => rr.ID == r.ID)).ToList().ForEach(r =>
{
var smrlink = new sys_member_roles_link()
{
ID = IdWorker.NextId(),
mid = entity.ID,
rid = r.ID
};
_baseQueryRepository.Context.Insertable(smrlink).ExecuteCommand();
});
});
return(true);
}
/// <summary>
/// 保存用户角色
/// </summary>
/// <returns></returns>
public ActionResult SaveSurRoles(Dictionary <string, string> input, sys_member profile)
{
sys_member usr = profile;
if (usr != null)
{
List <sys_roles> frl = JsonConvert.DeserializeObject <List <sys_roles> >(input["inputData"]);
sys_member_roles_link mrl = new sys_member_roles_link();
_db.Deleteable <sys_member_roles_link>().Where(l => l.mid == Convert.ToInt32(input["uid"])).ExecuteCommand();
foreach (sys_roles r in frl)
{
mrl = new sys_member_roles_link();
mrl.mid = Convert.ToInt32(input["uid"]);
mrl.rid = Convert.ToInt32(r.ID);
_db.Insertable(mrl).ExecuteCommand();
}
}
return(new ActionResult(true));
}
public ActionResult PCenter()
{
if (Profile != null)
{
sys_member member = null;
if (RequestContainsKey("type") && RequestContainsKey("id"))
{
member = DbInstance.Db.Queryable <sys_member>().Where(m => (m.ID == RequestInt64("id"))).First();
}
else
{
member = DbInstance.Db.Queryable <sys_member>().Where(m => (m.ID == Profile.ID)).First();
}
return(new ActionResult(true, member));
}
else
{
return(new ActionResult(false, null, null, "未授权的访问"));
}
}
public (bool success, string msg) AddMember(SysMember sysMember)
{
var rlt = _baseQueryRepository.Context.Ado.UseTran(() =>
{
var userTemp = new sys_member();
userTemp.Mapp(sysMember);
_baseQueryRepository.Context.Insertable(userTemp).ExecuteCommand();
sysMember.Roles.ForEach(role =>
{
var mrlink = new Model.sys_member_roles_link
{
ID = IdWorker.NextId(),
mid = userTemp.ID,
rid = role.ID
};
_baseQueryRepository.Context.Insertable(mrlink).ExecuteCommand();
});
});
return(rlt.IsSuccess, rlt.IsSuccess ? null : rlt.ErrorMessage);
}
/// <summary>
/// 密码修改，启用停用、重置
/// </summary>
/// <returns></returns>
public ActionResult ReSetpwd(Dictionary <string, string> input, sys_member profile)
{
sys_member usr = new sys_member();
if (input.ContainsKey("pwd")) //修改密码
{
if (input["pwd"].Length < 6)
{
return(new ActionResult(false, null, null, "新密码至少6位"));
}
usr = profile;
string pwd = CryptoHelper.TripleDesEncrypting(input["opwd"]);
string Npwd = CryptoHelper.TripleDesEncrypting(input["pwd"]);
if (usr.pwd == pwd)
{
usr.pwd = Npwd;
_db.Updateable(usr).ExecuteCommand();
return(new ActionResult(true));
}
else
{
return(new ActionResult(false, null, null, "旧密码验证失败：管理员【微信：Anno6295】"));
}
}
else if (input.ContainsKey("state")) //启用停用
{
usr.ID = Convert.ToInt32(input["uid"]);
usr.state = Convert.ToInt16(input["state"]);
_db.Updateable(usr).UpdateColumns(m => new { m.state }).ExecuteCommand();
}
else
{ //重置密码
usr.ID = Convert.ToInt32(input["uid"]);
usr.pwd = CryptoHelper.TripleDesEncrypting(Const.AppSettings.DefaultPwd);
_db.Updateable(usr).UpdateColumns(m => new { m.pwd }).ExecuteCommand();
}
return(new ActionResult(true));
}