public List <t_user> GetUsersByCondition(string first, string end, string nid, string phone, int pageIndex)
{
int firstIndex = (pageIndex - 1) * pageCount + 1;
int endIndex = pageIndex * pageCount;
string name = string.Empty;
if (nid != "0")
{
t_user model = _dal.GetUserById(nid);
if (model != null)
{
name = model.RealName;
}
else
{
name = "";
}
}
else
{
name = "";
}
if (phone == "0")
{
phone = "";
}
return(_dal.GetUsersByCondition(first, end, name, phone, firstIndex, endIndex));
}
public static ResponResultViewModel Deactive(UserViewModel entity, long userid)
{
//untuk deactive
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
t_user user = db.t_user.Where(x => x.id == entity.id).FirstOrDefault();
if (user != null)
{
user.active = false;
user.modified_by = userid;
user.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "user not found!";
}
}
}
catch (Exception e)
{
result.Success = false;
result.Message = e.Message;
}
return(result);
}
public void ConfirmEmail(string id, bool confirm)
{
t_user user = _unitOfWork.UserRepository.Get(int.Parse(id));
user.emailconfirm = confirm;
_unitOfWork.Save();
}
public static ResponseResult ResetPassword(UserViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
t_user user = db.t_user.Where(o => o.id == entity.id).FirstOrDefault();
if (user != null)
{
var Serial = new JavaScriptSerializer();
object data = new
{
user.password
};
var json = Serial.Serialize(data);
user.password = entity.password;
user.modified_by = entity.UserId;
user.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
db.SaveChanges();
object data2 = new
{
user.password
};
t_audit_log log = new t_audit_log();
log.type = "MODIFY";
log.json_before = json;
json = Serial.Serialize(data2);
log.json_after = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Category not found";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public Tuple <bool, string> SaveModel(t_user sourceModel)
{
bool result = false;
if (sourceModel == null)
{
return(Tuple.Create(false, "错误的请求对象！"));
}
if (sourceModel.p_id > 0)//修改
{
sourceModel.p_updatetime = DateTime.Now;
sourceModel.p_updateuserid = LZY.Code.OperatorProvider.Provider.GetCurrent().UserId;
result = _service.Update(sourceModel) > 0;
}
else//新增
{
sourceModel.p_createtime = DateTime.Now;
sourceModel.p_deleted = false;
sourceModel.p_createuserid = LZY.Code.OperatorProvider.Provider.GetCurrent().UserId;
result = _service.Insert(sourceModel) > 0;
}
if (result)
{
return(Tuple.Create(true, "操作成功！"));
}
else
{
return(Tuple.Create(false, "操作失败！"));
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public JsonResult Save(t_user obj)
{
if (obj.list_id == -1)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("code", obj.code);
var list = new Dal.Basedata.t_userDal(dic, "code").ToList();
if (list.Count > 0)
{
return(Json(new { success = "error", message = "，该编号已经存在" }));
}
}
try
{
obj.cdefine5 = "否";//默认系统接收通知 是
//obj.bmbh = obj.bmbh.Substring(1, obj.bmbh.IndexOf("]") - 1);
new Dal.Basedata.t_userDal().Save(obj);
return(Json(new { success = "ok" }));
}
catch (Exception e)
{
return(Json(new { success = "error", message = e.Message }));
}
}
//修改昵称
public Res modNikeName(User data)
{
Res res = new Res();
//判断请求的数据是否合法
if (string.IsNullOrEmpty(data.name))
{
res.code = -1;
res.msg = "账号不能为空";
}
else
{
//检查账号是否在用户表里面，在的话就是被注册了
t_user user = userDal.getUser(data.name);
if (user == null)
{
res.code = -1;
res.msg = "无此账号";
}
else
{
//修改到数据库
user.nikename = data.nikename;
res = userDal.modUser(user);
}
}
return(res);
}
//注册
public Res register(User data)
{
Res res = new Res();
//判断请求的数据是否合法
if (string.IsNullOrEmpty(data.name) || string.IsNullOrEmpty(data.pwd))
{
res.code = -1;
res.msg = "账号密码不能为空";
}
else
{
//检查账号是否在用户表里面，在的话就是被注册了
t_user check = userDal.getUser(data.name);
if (check != null)
{
res.code = -1;
res.msg = "账号已经被注册了，请使用其他账号";
}
else
{
//从接口请求过来的数据赋值给数据库的表对象
t_user user = new t_user();
user.name = data.name;
user.nikename = data.nikename;
//用md5加密密码
user.pwd = Md5Help.UserMd5(data.pwd);
res = userDal.register(user);
}
}
return(res);
}
public int GetPageCountByCondition(string first, string end, string nid, string phone)
{
string name = string.Empty;
if (nid != "0")
{
t_user model = _dal.GetUserById(nid);
if (model != null)
{
name = model.RealName;
}
else
{
name = "";
}
}
if (phone == "0")
{
phone = "";
}
int num = _dal.GetPageCountByCondition(first, end, name, phone);
if (num % pageCount == 0)
{
return(num / pageCount);
}
else
{
return((num / pageCount) + 1);
}
}
public ActionResult User_Edit(t_user model)
{
string sql = string.Format("update t_user t set abilityid={0},position='{1}' where t.id={2}", model.abilityid, model.position, model.id);
int count = DbHelperMySQL.ExecuteSql(sql);
return(Json(Result.AutoResult(count), JsonRequestBehavior.AllowGet));
}
public ActionResult Login(IFormCollection form)
{
//获取参数
string userName = form["userName"];
string passWord = form["password"];
string validateCode = form["validateCode"];
if (string.IsNullOrEmpty(userName))
{
return(Content("用户名不能为空！"));
}
if (string.IsNullOrEmpty(passWord))
{
return(Content("密码不能为空！"));
}
t_user userModel = new t_user();
//先判断验证码是否正确,如果不正确则直接返回
if (!validateCode.Equals(HttpContext.Session.GetString("validate")))
{
return(Content("验证码不正确！"));
}
//调用业务逻辑层
LoginService loginService = new LoginService();
string msg = "";
msg = loginService.Login(userName, passWord, validateCode, ref userModel);
return(Content(msg));
}
public ResultHandler Login(string name, string pwd)
{
ResultHandler res = new ResultHandler();
t_user model = _dal.GetUserByName(name);
if (CommonFun.IsEmpty(model))
{
res.state = false;
res.message = "该用户不存在";
}
else
{
if (!model.Pwd.Equals(pwd))
{
res.state = false;
res.message = "用户名或密码错误";
}
else
{
res.state = true;
res.message = "登录成功";
res.data = model;
}
}
return(res);
}
public async Task <List <ApplyProcess> > GetApplyLogByOrderSnAsync(string order_sn)
{
string sql = g_sqlMaker.Select <t_apply_log>().Where("order_sn", "=", "@order_sn").ToSQL();
List <t_apply_log> apply_log_list = await g_dbHelper.QueryListAsync <t_apply_log>(sql, new { order_sn });
IPositionServer positionServer = new PositionServerImpl(g_dbHelper, g_logServer);
IUserServer userServer = new UserServerImpl(g_dbHelper, g_logServer);
List <ApplyProcess> apply_list = new List <ApplyProcess>();
foreach (var item in apply_log_list)
{
t_position position_model = await positionServer.GetPosition(s => new { s.position_name }, item.position_id);
t_user user_model = await userServer.GetUserById(s => new { s.real_name }, item.user_id);
apply_list.Add(new ApplyProcess
{
audit_status = item.apply_status,
audit_time = item.add_time.Value.ToString("yyyy-MM-dd hh:mm"),
remark = item.remark,
position_name = position_model.position_name,
auditer = user_model.real_name
});
}
return(apply_list);
}
public static bool Update2(UserViewModel model)
{
bool result = false;
using (MinProContext db = new MinProContext())
{
t_user user = db.t_user.Find(model.id);
user.username = model.username;
user.password = model.password;
user.role_id = model.role_id;
user.mobile_flag = model.mobile_flag;
user.mobile_token = model.mobile_token;
user.created_by = model.id;
user.created_on = DateTime.Now;
user.modified_by = model.id;
user.modified_on = DateTime.Now;
user.active = model.active;
try
{
db.SaveChanges();
result = true;
}
catch (Exception e)
{
result = false;
}
}
return(result);
}
//根据用户名查询用户信息
public t_user getUser(string name)
{
//数据库查询姓名=输入值的用户信息
t_user user = dbcontext.t_user.FirstOrDefault(t => t.name.Equals(name));
return(user);
}
public JsonResult Register([FromBody] t_user clientModel)
{
//参数过滤
if (string.IsNullOrEmpty(clientModel.userAccount))
{
return(Json(Rsp.Fail("账号不能为空", -1)));
}
if (string.IsNullOrEmpty(clientModel.userPwd))
{
return(Json(Rsp.Fail("密码不能为空", -2)));
}
var userModel = _userService.GetUserInfo(clientModel.userAccount);
if (userModel != null)
{
return(Json(Rsp.Fail("账号已存在", -3)));
}
else
{
//密码加密
clientModel.userPwd = EncryptHelper.AESEncrypt(clientModel.userPwd, "DNLiCore");
int resultInt = _userService.AddUser(clientModel);
return(Json(Rsp.Success(resultInt.ToString())));
}
}
//编辑，新增
public ActionResult Details(string code, string deptid, string deptname)
{
t_user model = new t_user();
if (code == null)
{
string sql = @"select top 1 bh from t_user where bmbh = '" + deptid + "' order by bh desc";
DataTable dt = DataHelper.GetDataTable(sql);
string usercode = deptid + "0001";
if (dt.Rows.Count > 0)
{
int bh = int.Parse(dt.Rows[0][0].ToString()) + 1;
usercode = "0" + bh.ToString();
}
return(View(new t_user()
{
list_id = -1, deptcode = deptid, code = usercode
}));
}
else
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("code", code);
model = new Dal.Basedata.t_userDal(dic, "code").ToList().First();
//查找部门
Dictionary <string, string> dicdetp = new Dictionary <string, string>();
dicdetp.Add("deptcode", model.deptcode);
var deptmodel = new Dal.Basedata.t_bmDal(dicdetp, "deptcode").ToList().First();
if (deptmodel != null)
{
//model.bmbh = '[' + deptmodel.bmbm + ']' + deptmodel.bmmc;
}
return(View(model));
}
}
public JsonResult Save(t_user model)
{
//Dictionary<string, string> dic = new Dictionary<string, string>();
//dic.Add("code", model.code);
////如果是新增
//if (model.list_id == -1)
//{
// model.createDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// model.lastloginDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// if (new Dal.Basedata.s_userDal().getDataCount(dic, "code") > 0)
// {
// return Json(new { success = "error", message = "编码不能重复" });
// }
//}
//model.ts = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//new Dal.Basedata.s_userDal().Delete(dic, null, "code");
//new Dal.Basedata.s_userDal().Add(model);
return(Json(new { success = "ok", message = "保存成功" }));
}
public Request(t_user entity) : this(entity, false)
{
ObjectType = RequestObjectType.User;
ObjectId = entity.user_id;
Name = entity.full_name;
Status = SetStatus(entity.active);
}
public static ResponseResult Delete(UserViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
t_user user = db.t_user.Where(o => o.id == entity.id).FirstOrDefault();
if (user != null)
{
var Serial = new JavaScriptSerializer();
object data = new
{
user.username,
user.email,
user.role_id,
user.mobile_flag,
user.mobile_token
};
var json = Serial.Serialize(data);
user.is_delete = true;
user.deleted_by = entity.UserId;
user.deleted_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
db.SaveChanges();
t_audit_log log = new t_audit_log();
log.type = "MODIFY";
log.json_delete = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Category not found";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public override SetUserPasswordResponseBody ExecuteCore()
{
SetUserPasswordResponseBody res = new SetUserPasswordResponseBody();
using (HWLEntities db = new HWLEntities())
{
IQueryable <t_user> query = db.t_user;
IQueryable <t_user_code> codeQuery = db.t_user_code.OrderByDescending(c => c.id).Where(c => c.code_type == CodeType.Register);
if (!string.IsNullOrEmpty(this.request.Mobile))
{
query = query.Where(u => u.mobile == this.request.Mobile);
codeQuery = codeQuery.Where(u => u.user_account == this.request.Mobile);
}
else
{
query = query.Where(u => u.email == this.request.Email);
codeQuery = codeQuery.Where(u => u.user_account == this.request.Email);
}
t_user user = query.FirstOrDefault();
if (user == null)
{
throw new Exception("未注册的帐号不能找回密码!");
}
t_user_code userCode = codeQuery.FirstOrDefault();
if (userCode == null)
{
throw new Exception("注册码不存在");
}
if (userCode.expire_time <= DateTime.Now)
{
throw new Exception("注册码已过期");
}
if (userCode.code != this.request.CheckCode)
{
throw new Exception("注册码验证错误");
}
//添加用户成功后,设置注册码失效
userCode.expire_time = userCode.expire_time.AddDays(-1);
//更新用户密码信息
user.password = this.request.PasswordOK;
db.SaveChanges();
try
{
//清除用户之前登录用过的TOKEN
new Redis.UserAction().RemoveUserToken(user.id);
}
catch (Exception)
{
}
res.Status = ResultStatus.Success;
}
return(res);
}
public bool RemoveModel(int id)
{
t_user temp = new t_user();
temp.ID = id.ToString();
bool res = Delete <t_user>(temp);
return(res);
}
/// <summary>
/// 登陆服务
/// </summary>
/// <returns></returns>
public IActionResult Login(string userName, string passWord, string validateCode)
{
t_user tuser = new t_user();
//调用LoginService
string result = "";
LoginService loginService = new LoginService();
result = loginService.Login(userName, passWord, validateCode, ref tuser);
return(SuccessRes(result));
}
public ActionResult Info(int?id)
{
t_user model = new t_user();
if (id.GetValueOrDefault() > 0)
{
model = _bus.FindModel(id);
}
return(View(model));
}
private void SetCoreFields(ref t_user user, User model)
{
user.email = model.Email;
user.first_name = model.FirstName;
user.last_name = model.LastName;
user.title = model.Title;
user.phone = model.Phone;
user.site_id = model.SiteId;
user.active = model.Active;
user.user_status_id = 2; //default to 2 this column is not used at moment
}
public User(int userId)
{
using (Entity db = new Entity())
{
byte languageId = IidCulture.CurrentLanguageId;
t_user user = db.t_user.Find(userId);
if (user == null)
{
throw new ArgumentException("Invalid userId: " + UserId);
}
v_user[] roles = db.v_user.Where(e => e.user_id == user.user_id).ToArray();
v_site site = null;
if (user.site_id.HasValue)
{
site = db.v_site.Find(user.site_id.Value);
}
UserId = user.user_id;
OrganizationId = user.organization_id;
Email = user.email;
UserStatusId = user.user_status_id;
SiteId = user.site_id;
SiteName = site?.get_name_translated(languageId);
FirstName = user.first_name;
LastName = user.last_name;
FullName = user.first_name + " " + user.last_name + " (" + user.email + ")";
Phone = user.phone;
Title = user.title;
LastLogin = user.last_login_activity;
CreatedByUserId = user.createdby_userid;
CreatedDate = user.created_date;
UpdatedDate = user.updated_date;
UpdatedByUserId = user.updatedby_userid;
UserRoleFieldIds = roles.Select(e => e.user_role_fieldid).ToArray();
UserRoleValues = roles.Select(e => e.user_role_fieldid_value).ToArray();
Active = user.active;
var userAccess = db.v_user_access.Where(e => e.user_id == userId);
AssignedActivities = userAccess.Where(e => e.access_level_type == "Activity").OrderBy(e => e.activity_name).ToArray();
AssignedCountries = userAccess.Where(e => e.access_level_type == "Country").OrderBy(e => e.country).ToArray();
AssignedRegions = userAccess.Where(e => e.access_level_type == "Regional").OrderBy(e => e.access_level_name).ToArray();
AssignedSites = userAccess.Where(e => e.access_level_type == "Site").OrderBy(e => e.site_name).ToArray();
// Get all active sites. If the user is assigned to an inactive site, include it, too!
int inactiveSiteId = (site != null && site.active == false) ? site.site_id : 0;
Expression <Func <v_site, bool> > predicate = e => e.active == true || e.site_id == inactiveSiteId;
AllSites = SelectLists.GetSites(predicate, true);
}
}
/// <summary>
/// 根据用户名获取用户信息
/// </summary>
/// <param name="cust_name"></param>
public t_user GetUserById(string Id)
{
t_user res = null;
string sql = "select * from t_user where id=@id";
List <t_user> users = Query <t_user>(sql, new { id = Id });
if (users.Count > 0)
{
res = users.First();
}
return(res);
}
/// <summary>
/// 根据用户名获取用户信息
/// </summary>
/// <param name="cust_name"></param>
public t_user GetUserByRealName(string realName)
{
t_user res = null;
string sql = "select * from t_user where RealName=@Cust_Name";
List <t_user> users = Query <t_user>(sql, new { Cust_Name = realName });
if (users.Count > 0)
{
res = users.First();
}
return(res);
}
public ActionResult UserDetails(Users users)
{
t_user user = obj.t_user.Where(x => x.id.Equals(users.id)).SingleOrDefault();
user.username = users.username;
user.mobile_no = users.mobile_no;
user.city = users.city;
user.is_type = Convert.ToInt32(Request["UserType"]);
user.is_active = users.is_active;
obj.SaveChanges();
return(RedirectToAction("Users"));
}
public string Login(string userName, string pwd, string validateCode, ref t_user userModel)
{
userModel = new t_user();
try
{
//判断用户信息
userModel = APIServer.DataAccess.DBPlatform.Data.UserData.Get(userName);
string loginResult = "0"; //初始状态
if (userModel == null)
{
loginResult = "1";
return("用户不存在，请注册后再登陆！");
}
if (!userModel.status.ToString().Equals("1"))
{
loginResult = "3";
return("用户状态异常，请联系管理员！");
}
if (userModel.wrongCounts >= 5 && userModel.lastLoginTime.Value.Equals(DateTime.Now.Date))
{
//当天错误次数已经超过了5次
loginResult = "5";
return("当天密码错误次数已经超过5次，请明天再登陆！");
}
if (!MD5Encrypt.Encrypt(pwd).Equals(userModel.passWord))
{
//登陆密码错误
loginResult = "2";
userModel.wrongCounts += 1;
LoginingWrite(userModel);
return("密码输入错误，请重新输入！");
}
userModel.lastLoginTime = DateTime.Now;
string result = LoginingWrite(userModel);
if (result.Length < 1)
{
loginResult = "10";
}
else
{
result = "FAIL";
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
static void Main(string[] args)
{
using (var db = new Database("UltraDbEntity")) {
var user = new t_user() {
CreateDate=DateTime.Now,
Guid=Guid.NewGuid(),
Creator="admin",
IsUsing=true,
Pwd="123",
UserName="******"
};
var result=user.Insert();
}
}
