public ActionResult UserUpdate(string NickName, string Email, string Phone, string Qq, int RoleId, int User_Id)
{
Model.Sys.User muser = this.userService.Find(User_Id);
if (string.IsNullOrEmpty(NickName))
{
return(Json(new ResultModel {
msg = "昵称为空", pass = false
}));
}
muser.NickName = NickName.Trim();
muser.Email = Email.Trim();
muser.Phone = Phone.Trim();
muser.Qq = Qq.Trim();
muser.RoleId = RoleId;
try
{
this.userService.Update(muser);
return(Json(new ResultModel {
msg = "修改成功", pass = true
}));
}
catch
{
return(Json(new ResultModel {
msg = "修改失败", pass = false
}));
}
}
public List <Model.Sys.SysLog> ToPagedList(int pageIndex, int pageSize, string keySelector, out int count)
{
/*
* pageIndex:起始索引
* pageSize:每页显示的数量
* keySelector:排序的字段名
* sql:可以是简单的单表查询语句，也可以是复杂的多表联合查询语句
*/
using (IDbConnection conn = SqlString.GetSqlConnection(SqlString.MSSQLString))
{
string sql = "select a.*,b.* from sys_log as a left join sys_user as b on a.UserId=b.User_Id";
string sql01 = "select count(*) from sys_log";
count = conn.Query <int>(sql01).SingleOrDefault();
Model.Sys.User userTemp = new Model.Sys.User();
string query = "select top " + pageSize + " o.* from (select row_number() over(order by " + keySelector + ") as rownumber,* from(" + sql + ") as oo) as o where rownumber>" + (pageIndex - 1) * pageSize;
return(conn.Query <Model.Sys.SysLog, Model.Sys.User, Model.Sys.SysLog>(query, (log, user) =>
{
if (user != null)
{
log.User = user;
}
return log;
}, null, null, "User_Id", null, null).ToList());
}
}
public void Update(Model.Sys.User entity)
{
using (IDbConnection conn = SqlString.GetSQLiteConnection())
{
conn.Execute("UPDATE sys_user SET RoleId=@RoleId,Name=@Name,Password=@Password,NickName=@NickName,Avatar=@Avatar,Email=@Email," +
"Phone=@Phone,Qq=@Qq,AddTime=@AddTime,LastLoginTime=@LastLoginTime,LastLoginIp=@LastLoginIp,IsSuperUser=@IsSuperUser WHERE User_Id =@User_Id", entity);
}
}
public bool Insert(Model.Sys.User entity)
{
using (IDbConnection conn = SqlString.GetSQLiteConnection())
{
int i = conn.Execute("INSERT INTO sys_user(RoleId,Name,Password,NickName,Avatar,Email,Phone,Qq,AddTime,LastLoginTime,LastLoginIp,IsSuperUser)" +
"VALUES(@RoleId,@Name,@Password,@NickName,@Avatar,@Email,@Phone,@Qq,@AddTime,@LastLoginTime,@LastLoginIp,@IsSuperUser)", entity);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public List <Model.Sys.User> ToPagedList(int pageIndex, int pageSize, string keySelector, out int count)
{
using (IDbConnection conn = SqlString.GetSqlConnection(SqlString.MSSQLString))
{
string sql = "select a.*,b.* from sys_user as a left join sys_role as b on a.RoleId=b.Role_Id";
string sql01 = "select count(*) from sys_user";
count = conn.Query <int>(sql01).SingleOrDefault();
Model.Sys.User userTemp = new Model.Sys.User();
string query = "select top " + pageSize + " o.* from (select row_number() over(order by " + keySelector + ") as rownumber,* from(" + sql + ") as oo) as o where rownumber>" + (pageIndex - 1) * pageSize;
return(conn.Query <Model.Sys.User, Model.Sys.Role, Model.Sys.User>(query, (user, role) => {
if (role != null)
{
user.Role = role;
}
return user;
}, null, null, "Role_Id", null, null).ToList());
}
}
public List <Model.Sys.User> GetAll()
{
using (IDbConnection conn = SqlString.GetSQLiteConnection())
{
Model.Sys.User userTemp = new Model.Sys.User();
return(conn.Query <Model.Sys.User, Model.Sys.Role, Model.Sys.User>("select a.*,b.* from sys_user as a left join sys_role as b on a.RoleId=b.Role_Id", (user, role) =>
{
if (userTemp == null || userTemp.User_Id != user.User_Id)
{
userTemp = user;
}
if (role != null)
{
userTemp.Role = role;
}
return user;
}, null, null, "Role_Id", null, null).ToList());
}
}
public ActionResult UserUpdate(string NickName, string Email, string Phone, string Qq, int RoleId, int User_Id)
{
Model.Sys.User muser = this.userServer.Find(User_Id);
muser.NickName = NickName;
muser.Email = Email;
muser.Phone = Phone;
muser.Qq = Qq;
muser.RoleId = RoleId;
try
{
this.userServer.Update(muser);
return(Json(new ResultModel {
msg = "修改成功", pass = true
}));
}
catch
{
return(Json(new ResultModel {
msg = "修改失败", pass = false
}));
}
}
public ActionResult CenterAlterFace()
{
if (Request.HttpMethod == "GET")
{
return(View());
}
else
{
var avatarFile = Request.Files["AvatarFile"];
if (avatarFile != null)
{
if (!System.IO.Directory.Exists(MyPath.TempPath))
{
System.IO.Directory.CreateDirectory(MyPath.TempPath);
}
var avatarName = avatarFile.FileName;
var avatarExt = Path.GetExtension(avatarName);
//保存原图
var savePath = Path.Combine(MyPath.TempPath, avatarName);
if (WebHelper.saveUploadFile(avatarFile, savePath, Config.ImgExtensions.Split('*'), this.pathConfig.dic["avatar"].FileSize))
{
if (!System.IO.Directory.Exists(this.pathConfig.dic["avatar"].DirPath))
{
System.IO.Directory.CreateDirectory(this.pathConfig.dic["avatar"].DirPath);
}
//缩略图路径
var thumbPath = Path.Combine(this.pathConfig.dic["avatar"].DirPath, "Avatar_" + LoginUser.User_Id + avatarExt);
//生成头像缩略图
ImageHelper.MakeThumbnailImage(savePath, thumbPath, 48, 48, "HW");
LoginUser.Avatar = this.pathConfig.dic["avatar"].WebPath + "/" + "Avatar_" + LoginUser.User_Id + avatarExt;
System.IO.File.Delete(savePath);
Model.Sys.User u = this.userService.Find(LoginUser.User_Id);
if (base.Config.DefaultAvatar != u.Avatar)
{
string _syspath = HIO.SysPathParse(MyPath.AppPath, u.Avatar, true);
try
{
System.IO.File.Delete(_syspath);
}
catch (Exception e)
{
HIO.WriteLog(e);
}
}
u.Avatar = LoginUser.Avatar;
this.userService.Update(u);
return(Json(new ResultModel {
pass = true, msg = "上传成功", append = new { url = LoginUser.Avatar }
}));
}
else
{
return(Json(new ResultModel {
msg = "上传文件错误,注意文件大小" + this.pathConfig.dic["avatar"].FileSize + "kb以内或文件类型为" + Config.ImgExtensions, pass = false
}));
}
}
else
{
return(Json(new ResultModel {
msg = "上传文件错误", pass = false
}));
}
}
}
static void mssql_UserTest()
{
try
{
Console.WriteLine("mssql_UserTest Test");
mssql_user.Insert(new Model.Sys.User()
{
AddTime = DateTime.Now,
Avatar = "/image.png",
Email = "*****@*****.**",
IsSuperUser = true,
LastLoginIp = "127.0.0.1",
LastLoginTime = DateTime.Now,
Name = "*****@*****.**",
NickName = "漫漫洒洒",
Password = "******",
Phone = "138888888888",
Qq = "702295399",
RoleId = 1
});
mssql_user.Insert(new Model.Sys.User()
{
AddTime = DateTime.Now,
Avatar = "/image.png",
Email = "*****@*****.**",
IsSuperUser = true,
LastLoginIp = "127.0.0.1",
LastLoginTime = DateTime.Now,
Name = "*****@*****.**",
NickName = "漫漫洒洒2",
Password = "******",
Phone = "138888888888",
Qq = "702295399",
RoleId = 1
});
mssql_user.Delete("2");
mssql_user.Update(new Model.Sys.User()
{
AddTime = DateTime.Now,
Avatar = "/image.png",
Email = "*****@*****.**",
IsSuperUser = false,
LastLoginIp = "127.0.0.1",
LastLoginTime = DateTime.Now,
Name = "*****@*****.**",
NickName = "漫漫洒洒1111",
Password = "******",
Phone = "138888888888",
Qq = "702295399",
RoleId = 1,
User_Id = 1
});
Model.Sys.User ur = mssql_user.Find(1);
Console.WriteLine("User_Id:" + ur.User_Id);
Console.WriteLine("Avatar:" + ur.Avatar);
Console.WriteLine("Email:" + ur.Email);
Console.WriteLine("IsSuperUser:"******"LastLoginIp:" + ur.LastLoginIp);
Console.WriteLine("LastLoginTime:" + ur.LastLoginTime);
Console.WriteLine("Name:" + ur.Name);
Console.WriteLine("NickName:" + ur.NickName);
Console.WriteLine("Password:"******"Phone:" + ur.Phone);
Console.WriteLine("Qq:" + ur.Qq);
Console.WriteLine("Role_Id:" + ur.Role.Role_Id);
Console.WriteLine("RoleName:" + ur.Role.RoleName);
Console.WriteLine("mssql_UserTest Ok");
}
catch (Exception ex)
{
Console.WriteLine("mssql_UserTest Error");
ConsoleError(ex);
}
}
public ActionResult UserAlterFacePost(int Id)
{
var avatarFile = Request.Files["AvatarFile"];
string Avatar = "";
if (avatarFile != null && avatarFile.ContentLength > 0)
{
if (avatarFile.ContentLength <= 200 * 1024)
{
var avatarName = avatarFile.FileName;
var avatarExt = Path.GetExtension(avatarName);
string FileType = avatarName.Substring(avatarName.LastIndexOf(".") + 1);//取得类型
FileType = FileType.ToLower();
if (!String.IsNullOrEmpty(avatarExt) &&
Config.ImgExtensions.Contains(avatarExt))
{
avatarName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "." + FileType;
//保存原图
if (!System.IO.Directory.Exists(MyPath.TempPath))
{
System.IO.Directory.CreateDirectory(MyPath.AvatarPath);
}
var savePath = Path.Combine(MyPath.TempPath, avatarName);
avatarFile.SaveAs(savePath);
if (!System.IO.Directory.Exists(MyPath.AvatarPath))
{
System.IO.Directory.CreateDirectory(MyPath.AvatarPath);
}
//缩略图路径
var thumbPath = Path.Combine(MyPath.AvatarPath, "Avatar_" + Id + avatarExt);
//生成头像缩略图
ImageHelper.MakeThumbnailImage(savePath, thumbPath, 48, 48, "HW");
//记得删除原图
//DirFileHelper.DeleteFile(savePath);
//System.IO.Directory.Delete(savePath,true);
System.IO.File.Delete(savePath);
Avatar = MyPath.Web_AvatarPath + "/" + "Avatar_" + Id + avatarExt;
Model.Sys.User u = this.userServer.Find(Id);
u.Avatar = Avatar;
this.userServer.Update(u);
return(Json(new ResultModel {
pass = true, msg = "上传成功", append = new { url = Avatar }
}));
}
else
{
return(Json(new ResultModel {
msg = "上传文件类型错误", pass = false
}));
}
}
else
{
return(Json(new ResultModel {
msg = "上传文件大小超出限制", pass = false
}));
}
}
else
{
return(Json(new ResultModel {
msg = "上传文件错误", pass = false
}));
}
}
