public int UpdateSingleUser(string obj)
{
UserTableModel m = JsonConvert.DeserializeObject <UserTableModel>(obj);
var s = m.User_Photo;
if (Request.Form.Files.Count > 0)
{
//获取物理路径 webtootpath
string path = _hostEnvironment.ContentRootPath + "\\wwwroot\\img";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
var file = Request.Form.Files[0];
string fileExt = file.FileName.Split('.')[file.FileName.Split('.').Length - 1];
string filename = Guid.NewGuid().ToString() + "." + fileExt;
string fileFullName = path + "\\" + filename;
using (FileStream fs = System.IO.File.Create(fileFullName))
{
file.CopyTo(fs);
fs.Flush();
}
m.User_Photo = "/img/" + filename;
}
return(_bll.UpdateSingleUser(m));
}
public int PutPwd(string phone, string oldpwd, string newPwd)
{
string sql = "select * from UserTable where User_Phone='" + phone + "' and User_Pwd='" + oldpwd + "'";
UserTableModel m = dapper.Query(sql).FirstOrDefault();
if (m != null)
{
sql = "update UserTable set User_Pwd='" + newPwd + "' where User_Phone='" + phone + "'";
return(dapper.Execute(sql));
}
return(0);
}
public ActionResult GetUserTable([FromBody] UserTableFilters filter)//проблема з виводом
{
int count_users = 10;
UserTableModels userTableModels = new UserTableModels();
userTableModels.Users = new List <UserTableModel>();
var query = _context.UserProfile
.AsQueryable();
query = query
.Where(a => a.DateOfRegister.Year == filter.Year && a.DateOfRegister.Month == filter.Month && 0 == _context.UserAccessLocks.Where(b => b.Id == a.Id).Count());
if (filter.NickName != "")
{
query = query.Select(a => a).Where(a => a.NickName.Contains(filter.NickName));
}
userTableModels.TotalCount = query.Count();
query = query.Skip((filter.CurrentPage - 1) * count_users)
.Take(count_users);
foreach (var item in query)
{
var temp = _context.UserAccessLocks.Select(a => a).Where(a => item.Id == a.Id).AsQueryable();
if (temp.Count() != 0)//проверка чи є бан
{
userTableModels.TotalCount = userTableModels.TotalCount--;
continue;
}
UserTableModel userTableModel = new UserTableModel();
userTableModel.Id = item.Id;
userTableModel.Nickname = item.NickName;
userTableModel.Mail = _context.Users.Select(a => a).Where(a => a.Id == item.Id).FirstOrDefault().UserName;
userTableModel.Registrdate = item.DateOfRegister.ToString("dd.MM.yyyy");
string city = _context.City.FirstOrDefault(a => a.Id == item.CityId).Name;
userTableModel.City = city;
userTableModel.Status = "Не забанений";
userTableModels.Users.Add(userTableModel);
}
return(Ok(userTableModels));
}
public IEnumerable <UserTableModel> GetUserTableModel()
{
List <UserTableModel> result = new List <UserTableModel>();
IEnumerable <UserResult> userListResult = _userDataAccess.GetUserList();
TicketTableModel.TotalRows = TicketResult.TotalCount;
foreach (UserResult item in userListResult)
{
UserTableModel model = new UserTableModel();
model.Id = item.Id;
model.Name = item.Name;
model.Email = item.Email;
model.Mobile = item.Mobile;
model.Org = item.Org;
model.Dept = item.Dept;
model.ImageUrl = item.ImageUrl;
result.Add(model);
}
return(result);
}
public async Task <IActionResult> UpdateUser([FromBody] UserTableModel model)
{
try
{
var user = await _userManager.FindByIdAsync(model.Id);
user.Email = model.Email;
user.UserName = model.UserName;
user.FirstName = model.FirstName;
user.LastName = model.LastName;
var updateUserProfileResult = await _userManager.UpdateAsync(user);
var userRoles = await _userManager.GetRolesAsync(user);
_userManager.RemoveFromRolesAsync(user, userRoles).GetAwaiter().GetResult();
var updateUserRoleResult = await _userManager.AddToRoleAsync(user, model.Role);
return(Ok(new { updateUserProfileResult, updateUserRoleResult }));
}
catch (Exception ex)
{
throw ex;
}
}
public int Forget(UserTableModel m)
{
return(_bll.Forget(m));
}
public int UpdateSingleUser(UserTableModel m)
{
string sql = "update UserTable set User_Id='" + m.User_Id + "',User_Name='" + m.User_Name + "',User_Pwd='" + m.User_Pwd + "',User_Sex=" + m.User_Sex + ",User_Phone='" + m.User_Phone + "',User_Email='" + m.User_Email + "',User_Wechat='" + m.User_Wechat + "',User_QQ='" + m.User_QQ + "',User_Department=" + m.User_Department + ",User_Job=" + m.User_Job + ",User_Province=" + m.User_Province + ",User_City=" + m.User_City + ",User_District=" + m.User_District + ",User_Area='" + m.User_Area + "',User_Address='" + m.User_Address + "',User_ProductId=" + m.User_ProductId + ",User_Photo='" + m.User_Photo + "' where Id=" + m.Id;
return(dapper.Execute(sql));
}
/// <summary>
/// 忘记密码
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int Forget(UserTableModel m)
{
string sql = $"update UserTable set User_Pwd='{m.User_Pwd}' where User_Phone='{m.User_Phone}'";
return(dapper.Execute(sql));
}
/// <summary>
/// 添加单个用户
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int AddSingleUser(UserTableModel m)
{
string sql = $"insert into UserTable values('" + m.User_Id + "','" + m.User_Name + "','" + m.User_Pwd + "'," + m.User_Sex + ",'" + m.User_Phone + "','" + m.User_Email + "','" + m.User_Wechat + "','" + m.User_QQ + "'," + m.User_Department + "," + m.User_Job + "," + m.User_Province + "," + m.User_City + "," + m.User_District + ",'" + m.User_Area + "','" + m.User_Address + "'," + m.User_ProductId + ",'" + m.User_Photo + "','" + DateTime.Now + "',0,'" + m.User_Desc + "',0)";
return(dapper.Execute(sql));
}
public int UpdateSingleUser(UserTableModel m)
{
return(_dal.UpdateSingleUser(m));
}
public int AddSingleUser(UserTableModel m)
{
return(_dal.AddSingleUser(m));
}
