public ResponseBase <EmptyResponse> UpdateUser(UpdateUserRequest req)
{
DateTime dt = DateTime.Now;
tb_user user = userrepository.FindSingle(x => x.id == req.UserId);
if (user == null)
{
return(ResponseToClient <EmptyResponse>(ResponesStatus.Failed, "当前用户不存在"));
}
if (!string.IsNullOrEmpty(req.UserEmail))
{
user.useremail = req.UserEmail;
}
if (!string.IsNullOrEmpty(req.UserMobile))
{
user.usermobile = req.UserMobile; user.username = req.UserMobile;
}
if (!string.IsNullOrEmpty(req.UserPassword))
{
user.userpassword = req.UserPassword;
}
if (!string.IsNullOrEmpty(req.UserRealName))
{
user.realname = req.UserRealName;
}
userrepository.Update(user);
return(ResponseToClient <EmptyResponse>(ResponesStatus.Success, ""));
}
public ActionResult RegisterUser(string username, string email, string phone, string password)
{
tb_user user = new tb_user();
user.UserName = username;
user.email = email;
user.phone = phone;
user.password = password;
user.createDate = System.DateTime.Now;
musicDB.tb_user.Add(user);
musicDB.SaveChanges();
//user details
int userid = (from u in musicDB.tb_user
where u.UserName == username
select u.UserId).Single();
tb_userDetails userdetails = new tb_userDetails();
userdetails.nickname = "";
userdetails.gender = "male";
userdetails.location = "china";
userdetails.birthday = System.DateTime.Now;
userdetails.userId = userid;
SetInfo(username);
return(View(user));
}
public bool Login(tb_user user)
{
using (var context = new db_cmaEntities())
{
return(context.tb_user.Where(n => n.Username == user.Username && n.Password == user.Password).FirstOrDefault() != null);
}
}
public JsonResult AddUser(AddUser userInfo)
{
ResultModel resultModel = new ResultModel();
tb_user _User = new tb_user();
_User.Id = GetNewGuid();
_User.InsertTime = DateTime.Now;
_User.UpdateTime = DateTime.Now;
_User.Mobile = userInfo.UserPhone != null? userInfo.UserPhone : "";
_User.Email = userInfo.UserEmail != null ? userInfo.UserEmail : "";
_User.UserName = userInfo.UserName != null ? userInfo.UserName : "";
_User.Utype = userInfo.UserRole;
var newPassword = GetUserIntilPassWord();
_User.Password = newPassword.MD5_Password;
_User.Account = String.IsNullOrEmpty(userInfo.UserAccount)? GetNewAccount():userInfo.UserAccount;
_User.Status = 0;
if (_userBusiness.AddNewUser(_User))
{
resultModel.ResultCode = 1;
resultModel.ResultMsg = string.Format("创建成功，账号为{0}，密码为{1}", _User.Account, newPassword.Password);
}
else
{
resultModel.ResultMsg = "创建失败！";
}
return(Json(resultModel));
}
public ActionResult AddOrEdit(tb_user emp)
{
try
{
if (emp.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(emp.ImageUpload.FileName);
string extension = Path.GetExtension(emp.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
emp.ImagePath = "~/AppFiles/Images/" + fileName;
emp.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
using (db_auctionEntities db = new db_auctionEntities())
{
if (emp.ID == 0)
{
db.Employees.Add(emp);
db.SaveChanges();
}
else
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
}
return(View(emp));
}
// return Json(new { success =true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public bool Add(UserInfoModel model)
{
bool result = false;
try
{
using (var context = new db_cmaEntities())
{
tb_user dbmodel = new tb_user()
{
Email = model.Email,
Password = model.Password,
RealName = model.RealName,
Telphone = model.Telphone,
Username = model.Username,
State = model.State,
};
context.tb_user.Add(dbmodel);
context.SaveChanges();
//dbmodel = context.tb_user.Where(n => n.Id == dbmodel.Id).FirstOrDefault();
if (model.RoleList.Count > 0)
{
dbmodel.tb_role.Clear();
dbmodel.tb_role = context.tb_role.Where(n => model.RoleList.Contains(n.Id)).ToList();
}
result = context.SaveChanges() > 0;
}
}
catch (Exception ex)
{
throw;
}
return(result);
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="userIcon"></param>
/// <returns></returns>
public JsonResult UserChangeInfo(tb_user userInfo)
{
ResultModel result = new ResultModel();
try
{
if (userInfo.Id == loginUser.Id)
{
var nowUser = _userBusiness.GetUserInfoById(loginUser.Id).FirstOrDefault();
nowUser = userInfo.ConvertToT <tb_user>(nowUser);
ef.SaveChanges();
//删除cookie信息，删除缓存
DelCookieInfo(loginUser.Account);
nowUser.AccountIcon = nowUser.AccountIcon.Replace("~", BaseUrl);
result.ResultCode = 1;
result.ResultData = nowUser;
}
else
{
result.ResultMsg = "您无此权限！";
}
}
catch (Exception)
{
}
return(Json(result));
}
/// <summary>
/// 客户表 列表
/// </summary>
public ActionResult userList(tb_user model)
{
int count = 0;
ViewBag.userList = duser.GetList(model, ref count);
ViewBag.page = Utils.ShowPage(count, model.PageSize, model.PageIndex, 5);
return(View());
}
private void Btn_Login_Click(object sender, EventArgs e)
{
progressBar.Value = 20;
lbLoginMsg.Text = "账号密码校验中...";
lbLoginMsg.Update();
user.level = "";
if ("" == cbUserName.Text)
{
// MessageBox.Show("用户名不能为空！","温馨提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
lbLoginMsg.Text = "用户名不能为空！";
lbLoginMsg.Update();
progressBar.Value = 0;
this.DialogResult = DialogResult.None;
return;
}
if ("" == tbPw.Text)
{
// MessageBox.Show("密码不能为空！", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
lbLoginMsg.Text = "密码不能为空！";
lbLoginMsg.Update();
progressBar.Value = 0;
this.DialogResult = DialogResult.None;
return;
}
user.user = cbUserName.Text;
user.password = tbPw.Text;
tb_user userRlt = LaserCode.BLL.BllUser.SelectData().Where(us => us.user == user.user).Where(us => us.password == user.password).FirstOrDefault();
if (userRlt == null)
{
lbLoginMsg.Text = "密码或用户名错误，请重新输入";
lbLoginMsg.Update();
cbUserName.Text = "";
tbPw.Text = "";
this.DialogResult = DialogResult.None;
}
else
{
user = userRlt;
cbUserName.Text = "";
tbPw.Text = "";
//isSetUp = true;
lbLoginMsg.Text = "加载主窗体...";
lbLoginMsg.Update();
this.Hide();
this.DialogResult = DialogResult.OK;
}
}
/// <summary>
/// 数据转换
/// </summary>
/// <param name="dbModel">dbModel装换为UserInfoModel</param>
/// <returns></returns>
private UserInfoModel GetModel(tb_user dbModel)
{
return(new UserInfoModel()
{
Email = dbModel.Email,
Id = dbModel.Id,
Password = dbModel.Password,
RealName = dbModel.RealName,
Telphone = dbModel.Telphone,
Username = dbModel.Username,
State = dbModel.State
});
}
public ResponseBase <CheckUNameAndPwdResponse> CheckUNameAndPwd(CheckUNameAndPwdRequest req)
{
tb_user user = userrepository.FindSingle(x => x.username == req.UserName && x.userpassword == req.Password);
if (user == null)
{
return(ResponseToClient <CheckUNameAndPwdResponse>(ResponesStatus.Failed, "用户名或密码不正确"));
}
return(ResponseToClient <CheckUNameAndPwdResponse>(ResponesStatus.Success, "", new CheckUNameAndPwdResponse()
{
UserInfo = user
}));
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="_User"></param>
/// <returns></returns>
public bool AddNewUser(tb_user _User)
{
try
{
ef.tb_user.Add(_User);
ef.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (filterContext.HttpContext.Session["LoginUserInfo"] == null)
{
filterContext.Result = LoginResult("");
return;
}
else
{
UserInfo = filterContext.HttpContext.Session["LoginUserInfo"] as tb_user;
}
//base.OnActionExecuting(filterContext);
}
/// <summary>
/// 根据登入信息获取用户信息
/// </summary>
/// <param name="account">账号</param>
/// <param name="password">密码</param>
/// <returns></returns>
protected tb_user GetUserInfoByLogin(string account, string password)
{
tb_user result = null;
try
{
result = _userBusiness.GetUserByLogin(account, GetMD5Password(password));
}
catch (Exception)
{
throw;
}
return(result);
}
public ResponseBase <LoadUserDetailResponse> LoadUserDetail(LoadUserDetailRequest req)
{
DateTime dt = DateTime.Now;
tb_user user = userrepository.FindSingle(x => x.id == req.UserId);
if (user == null)
{
return(ResponseToClient <LoadUserDetailResponse>(ResponesStatus.Failed, "当前用户不存在"));
}
return(ResponseToClient <LoadUserDetailResponse>(ResponesStatus.Success, "", new LoadUserDetailResponse()
{
UserDetail = user
}));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="theData">保存的数据</param>
public ActionResult SaveData(tb_user theData)
{
if (theData.Id.IsNullOrEmpty())
{
//theData.Id = Guid.NewGuid().ToSequentialGuid();
_tb_userBusiness.AddData(theData);
}
else
{
_tb_userBusiness.UpdateData(theData);
}
return(Success());
}
/// <summary>
/// 用户名密码获取登入账户
/// </summary>
/// <param name="userAccount"></param>
/// <param name="passWord"></param>
/// <returns></returns>
public tb_user GetUserByLogin(string userAccount, string passWord)
{
tb_user result = new tb_user();
try
{
string sql = string.Format("select * from tb_user u where u.Account={0} and u.Password={1}", userAccount, passWord);
result = ef.tb_user.Where(u => u.Account == userAccount && u.Password == passWord).FirstOrDefault();
}
catch (Exception)
{
throw;
}
return(result);
}
public bool LoginPost([FromBody] tb_user model)
{
try
{
return(_business.Login(model));
}
catch (Exception ex)
{
throw new HttpResponseException(new HttpResponseMessage()
{
StatusCode = HttpStatusCode.InternalServerError,
Content = new StringContent(ex.Message)
});
}
}
/// <summary>
/// 用户信息页
/// </summary>
/// <returns></returns>
public ActionResult UserInfoView()
{
string userId = Request["userId"];
var selUserInfo = new tb_user();
if (!String.IsNullOrEmpty(userId))
{
selUserInfo = loginUser;
}
else
{
selUserInfo = GetUserInfoById(userId);
}
ViewBag.SelUserInfo = selUserInfo;
return(View());
}
public static bool Add(User user)
{
using (var ec = new TestProjectEntities1())
{
var tbUser = new tb_user
{
name = user.Name,
language_id = user.LanguageId,
creation_date = DateTime.Now,
};
ec.tb_user.Add(tbUser);
EntityConnector.SaveChanges(ec);
return(true);
}
}
public ActionResult Delete(int id)
{
try
{
using (db_auctionEntities db = new db_auctionEntities())
{
tb_user emp = db.Employees.Where(x => x.ID == id).FirstOrDefault <tb_user>();
db.Employees.Remove(emp);
db.SaveChanges();
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="uId"></param>
/// <returns></returns>
private tb_user GetUserInfoById(string uId)
{
tb_user result = new tb_user();
try
{
result = _userBusiness.GetUserInfoById(loginUser.Id).FirstOrDefault();
if (result != null)
{
result.AccountIcon = result.AccountIcon.Replace("~", BaseUrl);
}
}
catch (Exception)
{
}
return(result);
}
public JsonResult Login(tb_user user)
{
Thread.Sleep(2000);
string sts = "GAGAL";
if (!string.IsNullOrEmpty(user.USERNAME) || !string.IsNullOrEmpty(user.PASSWORD))
{
if (Fungsi.IsValid(user.USERNAME, user.PASSWORD))
{
sts = "OK";
}
else
{
sts = "GAGAL";
}
}
return(Json(new { status = sts }));
}
/// <summary>
/// 客户表 保存
/// </summary>
public JsonResult userSave(tb_user model)
{
if (model == null)
{
return(ResultTool.jsonResult(false, "参数错误！"));
}
if (!String.IsNullOrEmpty(model.id))
{
bool boolResult = duser.Update(model);
return(ResultTool.jsonResult(boolResult, boolResult ? "成功！" : "更新失败！"));
}
else
{
model.id = Guid.NewGuid().ToString("N");
bool boolResult = duser.Add(model);
return(ResultTool.jsonResult(boolResult, boolResult ? "成功！" : "添加失败！"));
}
}
public JsonResult UserDEL(string USR)
{
Thread.Sleep(1000);
string result = "GAGAL";
try
{
//_DB.bengkel_user.Remove(_DB.bengkel_user.Single(r => r.USERNAME == User));
//_DB.SaveChanges();
tb_user tb_user = _DB.tb_user.Find(USR);
_DB.tb_user.Remove(tb_user);
_DB.SaveChanges();
result = "OK";
}
catch (Exception ex)
{
result = ex.ToString();
}
return(Json(new { status = result }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 保存用户成功登入的信息
/// </summary>
/// <param name="name"></param>
/// <param name="value"></param>
/// <param name="outTimeMin"></param>
/// <returns></returns>
public bool SaveUserLoginInfo(tb_user user)
{
bool result = false;
try
{
if (user != null)
{
SetCookieInfo(user.Account, JsonConvert.SerializeObject(user), 7200);
user.Status = 2;
ef.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw;
}
return(result);
}
private UserInfoModel GetModel(tb_user dbModel, ICollection <tb_role> tb_role)
{
var roleList = new List <long>();
foreach (var item in tb_role)
{
roleList.Add(item.Id);
}
return(new UserInfoModel()
{
Email = dbModel.Email,
Id = dbModel.Id,
Password = dbModel.Password,
RealName = dbModel.RealName,
Telphone = dbModel.Telphone,
Username = dbModel.Username,
State = dbModel.State,
RoleList = roleList
});
}
public JsonResult UserEDIT(tb_user USR)
{
Thread.Sleep(1000);
string result = "GAGAL";
try
{
USR.UPD = DateTime.Now;
USR.RECID = "";
if (ModelState.IsValid)
{
_DB.Entry(USR).State = EntityState.Modified;
_DB.SaveChanges();
result = "OK";
}
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(Json(new { status = result }));
}
public ActionResult AddOrEdit(int id = 0)
{
tb_user emp = new tb_user();
if (Session["Email"] != null)
{
if (id != 0)
{
using (db_auctionEntities db = new db_auctionEntities())
{
emp = db.Employees.Where(x => x.ID == id).FirstOrDefault <tb_user>();
//return RedirectToAction("Viewuser", this);
}
}
}
else
{
//return RedirectToAction("Loginone");
}
return(View(emp));
}
public JsonResult UserADD(tb_user USR)
{
Thread.Sleep(1000);
string result = "GAGAL";
try
{
USR.UPD = DateTime.Now;
USR.RECID = "";
USR.PASSWORD = Fungsi.GenerateMD5(USR.PASSWORD);
if (ModelState.IsValid)
{
_DB.tb_user.Add(USR);
_DB.SaveChanges();
//_DB.Database.ExecuteSqlCommand("INSERT INTO TB_SATUAN VALUES ('" + Nama + "','" + Ket + "');");
result = "OK";
}
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(Json(new { status = result }));
}
