public int UpdateManager(RLib.DB.DbConn dbconn, Model.Manager model)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE manager set ");
sb.Append("name = @name,");
sb.Append("subName = @subname,");
sb.Append("loginName = @loginname,");
// sb.Append("loginPwd = @loginpwd,");
sb.Append("allowLogin = @allowlogin,");
sb.Append("state = @state,");
sb.Append("updateTime = getdate(),");
sb.Append("remark = @remark ");
sb.Append(" WHERE managerId = @managerid;");
int rows = dbconn.ExecuteSql(sb.ToString(), new
{
managerid = model.ManagerId,
name = model.Name,
subname = model.SubName ?? "",
loginname = model.LoginName ?? "",
loginpwd = model.LoginPwd ?? "",
allowlogin = model.AllowLogin,
state = model.State,
remark = model.Remark ?? ""
});
return(rows);
}
public int UpdateManagerPwd(RLib.DB.DbConn dbconn, int managerid, string newpwd)
{
string sql = "update manager set loginpwd=@loginpwd where managerid=@managerid;";
int rows = dbconn.ExecuteSql(sql, new { managerid = managerid, loginpwd = newpwd ?? "" });
return(rows);
}
public int DeleteManager(RLib.DB.DbConn dbconn, int managerid)
{
string sql = "update manager set state=-1 where managerid=@managerid;";
int rows = dbconn.ExecuteSql(sql, new { managerid = managerid });
return(rows);
}
public void SetTagPermission(RLib.DB.DbConn dbconn, int usertagid, List <string> keys)
{
DeleteTagPermission(dbconn, usertagid);
string sqlinsert = "insert into tagpermission(usertagid,permissionKey) values(@usertagid,@key);";
foreach (var k in keys)
{
if (string.IsNullOrEmpty(k))
{
continue;
}
dbconn.ExecuteSql(sqlinsert, new { usertagid = usertagid, key = k });
}
}
public Model.Manager AddManager(RLib.DB.DbConn dbconn, Model.Manager model)
{
string sql = "insert into manager(name,subname,loginname,loginpwd,allowlogin,state,createtime,remark)" +
"values(@name,@subname,@loginname,@loginpwd,@allowlogin,@state,getdate(),@remark);";
dbconn.ExecuteSql(sql, new
{
name = model.Name,
subname = model.SubName ?? "",
loginname = model.LoginName ?? "",
loginpwd = model.LoginPwd ?? "",
allowlogin = model.AllowLogin,
state = model.State,
remark = model.Remark ?? ""
});
model.ManagerId = dbconn.GetIdentity();
return(model);
}
public int DeleteTagPermission(RLib.DB.DbConn dbconn, int usertagid)
{
string sql = "delete from tagpermission where usertagid=@usertagid;";
return(dbconn.ExecuteSql(sql, new { usertagid = usertagid }));
}
