private void QueryData()
{
int page_index = this.GridPagerControl1.PageIndex;
int page_count = this.GridPagerControl1.PageCount;
SysUserInfo curr_user = this.GetCurrentUserInfo();
if (curr_user == null)
{
this.Response.Write("user is null");
return;
}
List <FormApproveInfo> list = FormApproveBiz.QueryApprovePage(
this.GridPagerControl1.PageSize,
ref page_index,
curr_user.UserId,
this.textbox_form_no.Text,
out page_count);
this.GridView1.DataSource = list;
this.GridView1.DataBind();
this.GridPagerControl1.PageCount = page_count;
this.GridPagerControl1.PageIndex = page_index;
}
public async Task <MessageModel <string> > AddUserInfo(SysUserInfo sysUserInfo)
{
var data = new MessageModel <string>();
data.success = false;
data.msg = "添加失败";
try
{
unitOfWork.BeginTran();
sysUserInfo.uPassWord = MD5Helper.MD5Encrypt32(sysUserInfo.uPassWord);
//默认有5次机会登录
sysUserInfo.uErrorCount = 5;
var id = await sysUserService.Add(sysUserInfo);
data.success = id > 0;
if (data.success)
{
data.msg = "添加成功";
}
unitOfWork.CommitTran();
}
catch (Exception)
{
unitOfWork.RollbackTran();
}
return(data);
}
public User(string userId)
{
this.UserId = userId;
SysUserInfo user = UserDataAccess.GetUser(userId);
if (user != null)
{
this.Account = user.Account;
this.Active = user.Active;
this.CreateTime = user.CreateTime;
this.CreateUser = user.CreateUser;
this.DefaultUrl = user.DefaultUrl;
this.DeptCode = user.DeptCode;
this.Description = user.Description;
this.DomainName = user.DomainName;
this.Email = user.Email;
this.EntryDate = user.EntryDate;
this.ExtNo = user.ExtNo;
this.LanguageId = user.LanguageId;
this.LastLogonTime = user.LastLogonTime;
this.LoginName = user.LoginName;
this.LogonTimes = user.LogonTimes;
this.Password = user.Password;
this.SiteSerial = user.SiteSerial;
this.UserName = user.UserName;
}
}
public ActionResult UserInfo()
{
SysUserInfo model = null;
try
{
//var userBll = new Pharos.Sys.BLL.SysUserInfoBLL();
//model = userBll.GetModelByUID(Sys.SysUserService.UID);
//ViewBag.BumenTitle = new Pharos.Sys.BLL.SysDepartmentBLL().GetModelByDepId(model.BumenId.GetValueOrDefault()).Title;
//ViewBag.PositionTitle = new Pharos.Sys.BLL.SysDataDictionaryBLL().GetExtModelByDicSN(model.PositionId.GetValueOrDefault()).Title;
//var roleBLL = new Pharos.Sys.BLL.SysRoleBLL();
//var roleIdArray = model.RoleIds.Split(',');SysUserService.RoleIds
//var roleTitle = string.Empty;
//var roleStr = string.Empty;
//foreach (var item in roleIdArray)
//{
// roleTitle = roleBLL.GetModelByRoleId(int.Parse(item)).Title;
// if (string.IsNullOrEmpty(roleStr)) roleStr = roleTitle;
// else roleStr += "、" + roleTitle;
//}
//ViewBag.RoleStr = roleStr;
}
catch (Exception ex)
{
//new LogEngine().WriteError(ex);
}
return(View());
}
public IActionResult Login([FromBody] SysUserInfo model)
{
RespondResult result = new RespondResult();
SysUserInfo userInfo = systemUserService.GetLoginUserInfo(model.UserName);
//用户不存在
if (userInfo == null)
{
result.is_success = false;
result.msg = "用户不存在";
result.result = null;
}
//判断密码
string md5Password = Md5Helper.Md5(model.Password);
//密码错误
if (!userInfo.Password.Equals(md5Password))
{
result.is_success = false;
result.msg = "密码错误";
result.result = null;
}
var tokenStr = AuthConfiguer.GetJWT(model, _jwtSettings);
result.is_success = true;
result.msg = "";
result.result = tokenStr;
return(Ok(result));
}
protected void ButtonLogin_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TextBoxUserName.Text))
{
ScriptHelper.AjaxAlertFocus(this.ButtonLogin,
"Please input user name.", this.TextBoxUserName);
return;
}
if (string.IsNullOrEmpty(TextBoxPassword.Text))
{
ScriptHelper.AjaxAlertFocus(this.ButtonLogin,
"Please input password.", this.TextBoxPassword);
return;
}
// UserBiz biz = new UserBiz();
SysUserInfo user = UserBiz.Login(TextBoxUserName.Text, TextBoxPassword.Text);
if (user != null)
{
this.Session["user"] = user;
Response.Redirect("~/HomePage.aspx");
// ScriptHelper.AjaxAlert(this.ButtonLogin, "Login Ok.");
return;
}
else
{
ScriptHelper.AjaxAlertSelect(this.ButtonLogin,
"User name or password error.",
this.TextBoxUserName);
return;
}
}
protected void apply_form_link_Click(object sender, EventArgs e)
{
Control button = sender as Control;
SysUserInfo curr_user = this.GetCurrentUserInfo();
string form_Id = (button.NamingContainer.FindControl("hidden_form_id") as HiddenField).Value;
#region add to form_header
//FormHeader header = new FormHeader(form_Id, form_no);
//header.FormDate = DateTime.Now;
//header.FormDueDate = DateTime.Now;
//header.FormFiller = curr_user.UserId;
//header.SiteSerial = curr_user.SiteSerial;
//header.Status = FormStatus.NC;
//FormHeaderBiz.InsertFormHeader(header);
#endregion
FormInfo form = FormBiz.GetForm(int.Parse(form_Id));
string apply_url = form.ApplyUrl;
if (string.IsNullOrEmpty(apply_url))
{
throw new ApplicationException(string.Format("form kind ({0})'s apply_url not set.", form_Id));
}
StringBuilder sb = new StringBuilder(150);
sb.Append(apply_url);
//sb.Append(apply_url.Contains("?") ? "&" : "?");
//sb.AppendFormat("form_no={0}", form_no);
Response.Redirect("transferframe.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string userId = string.Empty;
if (!string.IsNullOrEmpty(Request.QueryString["UserId"]))
{
userId = Request.QueryString["UserId"];
}
else
{
userId = this.GetCurrentUserInfo().UserId;
}
List <SysSiteList> site_list = SiteBiz.GetAllSites();
this.ddl_site.DataSource = site_list;
this.ddl_site.DataBind();
SysUserInfo curr_user = UserBiz.GetUser(this.GetCurrentUserInfo().UserId);
this.text_name.Text = curr_user.LoginName;
this.text_dept.Text = curr_user.DeptCode;
this.text_email.Text = curr_user.Email;
this.text_ext_no.Text = curr_user.ExtNo;
// this.text_site.Text = curr_user.SiteSerial;
this.DateControl1.Date = curr_user.EntryDate;
this.ddl_site.SelectedValue = curr_user.SiteSerial.ToString();
this.DateControl1.Date = curr_user.EntryDate;
}
}
protected void button_modify_password_Click(object sender, EventArgs e)
{
if (this.text_new_password.Text.Trim().Length == 0)
{
this.AjaxAlert(this.UpdatePanel1, "please input new password");
return;
}
SysUserInfo curr_user = UserBiz.GetUser(this.GetCurrentUserInfo().UserId);
if (this.text_old_password.Text != curr_user.Password)
{
this.AjaxAlert(this.UpdatePanel1, "password error.");
return;
}
if (this.text_new_password.Text != this.text_confirm_password.Text)
{
this.AjaxAlert(this.UpdatePanel1, "New password and confirm password don't match, please reinput.");
return;
}
curr_user.Password = this.text_new_password.Text;
UserBiz.UpdateUser(curr_user);
this.ResetSession(curr_user);
this.AjaxAlert(this.UpdatePanel2, "modify password successfully!");
}
private async Task <List <SysUserInfo> > AddTestAccount(SysUserInfoModel model)
{
List <SysUserInfo> list = new List <SysUserInfo>();
await Task.Run(() =>
{
for (var i = 0; i < 100; i++)
{
SysUserInfo entity = new SysUserInfo
{
UserAccount = Guid.NewGuid().ToString("N").Substring(0, 6),
UserName = Guid.NewGuid().ToString("N").Substring(0, 6),
UserPassword = model.UserPassword,
UserOrgId = model.UserOrgId,
UserGroupNames = model.UserGroupNames,
UserEmail = Guid.NewGuid().ToString("N").Substring(0, 6) + "@gmail.com",
UserMobile = model.UserMobileNo,
CreationDate = DateTime.Now,
CreatedBy = "admin"
};
list.Add(entity);
}
});
return(list);
}
/// <summary>
/// 生成JWT字符串
/// </summary>
/// <param name="tokenModel"></param>
/// <param name="jwtModel"></param>
/// <returns></returns>
public static string GetJWT(SysUserInfo tokenModel, JwtSettings jwtModel)
{
//DateTime utc = DateTime.UtcNow;
var claims = new List <Claim>
{
new Claim(ClaimTypes.NameIdentifier, tokenModel.Id.ToString()),
new Claim(ClaimTypes.Name, tokenModel.ReallyName),
};
// 密钥
var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(jwtModel.SecretKey));
var creds = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
var tokenHandler = new JwtSecurityTokenHandler();
var jwt = new JwtSecurityToken(
audience: jwtModel.Audience,
issuer: jwtModel.Issuer,
claims: claims, // 声明的集合
expires: DateTime.Now.AddHours(1), // token的有效时间
signingCredentials: creds
);
var handler = new JwtSecurityTokenHandler();
// 生成 jwt字符串
var strJWT = handler.WriteToken(jwt);
return(strJWT);
}
private async Task <List <SysUserInfo> > AddTestAccount(SysUserInfoModel model)
{
List <SysUserInfo> list = new List <SysUserInfo>();
await Task.Run(() =>
{
for (var i = 0; i < 100; i++)
{
SysUserInfo entity = new SysUserInfo
{
User_Account = Guid.NewGuid().ToString("N").Substring(0, 6),
User_Name = Guid.NewGuid().ToString("N").Substring(0, 6),
User_Password = model.UserPassword,
User_Org_Id = model.UserOrgId,
User_Group_Names = model.UserGroupNames,
User_Email = Guid.NewGuid().ToString("N").Substring(0, 6) + "@gmail.com",
User_Is_Ldap = model.UserIsLdap,
User_Mobile_No = model.UserMobileNo,
User_Ower = model.UserOwer,
Language_Code = model.LanguageCode,
User_Is_Lock = model.UserIsLock,
Eff_Start_Date = model.EffStartDate,
Eff_End_Date = model.EffEndDate,
Creation_Date = DateTime.Now,
Created_By = 1
};
list.Add(entity);
}
});
return(list);
}
public ActionResult Login(FormCollection fc)
{
string userName = fc["UserName"];
string password = fc["Password"];
string returnUrl = Convert.ToString(TempData["ReturnUrl"]);
bool remberMe = fc["chkRemberMe"] == null ? false : true;
SysUserInfo user = unitOfWork.SysUserInfoRepository.Get(filter: u => u.Name == userName && u.Password == password).FirstOrDefault();
unitOfWork.Dispose();
if (user != null)
{
FormsAuthentication.SetAuthCookie(userName, remberMe);
if (!string.IsNullOrEmpty(returnUrl))
{
return(Redirect(returnUrl));
}
else
{
return(Redirect("~/"));
}
}
else
{
ViewBag.LoginState = "User name or password incorrect";
}
return(View());
}
private Guid FindSysAdminUnitId(Guid contactId)
{
SysUserInfo currentUser = _userConnection.CurrentUser;
if (currentUser.ContactId == contactId)
{
return(currentUser.Id);
}
EntitySchemaManager entitySchemaManager = _userConnection.EntitySchemaManager;
var esq = new EntitySchemaQuery(entitySchemaManager, "SysAdminUnit")
{
UseAdminRights = false,
IgnoreDisplayValues = true,
CanReadUncommitedData = true
};
EntitySchemaQueryColumn queryColumn = esq.AddColumn("Id");
IEntitySchemaQueryFilterItem queryFilterItem =
esq.CreateFilterWithParameters(FilterComparisonType.Equal, "Contact", contactId);
esq.Filters.Add(queryFilterItem);
EntityCollection entities = esq.GetEntityCollection(_userConnection);
if (entities.Count != 0)
{
Entity entity = entities.First.Value;
return(entity.GetTypedColumnValue <Guid>(queryColumn.Name));
}
return(Guid.Empty);
}
/// <summary>
/// 统一登录写入cookie
/// </summary>
/// <param name="user">Entity.SysUserInfo 用户信息类</param>
/// <param name="remember">记住用户和密码，默认false</param>
public static void Login(SysUserInfo user, bool remember = false)
{
Dictionary <string, string> kv = new Dictionary <string, string>();
kv.Add(key_cid, user.CompanyId.ToString());
kv.Add(key_uid, user.UID);
kv.Add(key_uname, user.LoginName);
kv.Add(key_fname, HttpUtility.UrlEncode(user.FullName));
kv.Add(key_branchId, user.BranchId.ToString());
kv.Add(key_bumenId, user.BumenId.ToString());
kv.Add(key_photo, user.PhotoUrl);
kv.Add(key_roleId, user.RoleIds);
CookieHelper.Remove("remuc");
if (remember)
{
//kv.Add("_pwd", user.LoginPwd);
CookieHelper.Set("remuc", kv, 100, true);//防止退出删除
}
CookieHelper.Set(Url.CurDomain, "", uc, kv, 1, false);
var browser = HttpContext.Current.Request.Browser;
//SysLogService.WriteInfo(string.Format("用户（{0}，{1}）成功登录系统！浏览器:{2},版本:{3}", user.LoginName, user.FullName,browser.Browser,browser.Version),LogType.登录,LogModule.其他);
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (!CheckFormInfo())
{
lblMsg.Text = "登陆信息不完整";
}
else
{
SysUserInfo bUser = new SysUserInfo();
mUserInfo = bUser.GetUserInfo(mUserInfo);
if (mUserInfo != null)
{
BaseForm.UserInfo = mUserInfo;
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
throw new Exception("密码验证失败");
}
}
}
catch (Exception err)
{
lblMsg.Text = err.Message;
}
}
public ActionResult ModifyPassword(string oldPwd, string newPwd, string confirmPwd)
{
SysUserInfo ui = Startup.GetUserInfo();
string code = "";
string msg = "";
EncryptCommon EncryptCommon = new EncryptCommon();
if (EncryptCommon.EncryptMD5(oldPwd) == ui.Password)
{
if (newPwd == confirmPwd)
{
SysUserInfoMan uiMan = new SysUserInfoMan();
SysUserInfo user = uiMan.GetEntity(ui.ID);
user.Password = EncryptCommon.EncryptMD5(newPwd);
user.UpdateTime = DateTime.Now;
ui.Password = user.Password;
uiMan.Update(user);
code = "1";
msg = "修改成功";
}
else
{
code = "2";
msg = "重设密码与确认密码输入不一致！";
}
}
else
{
code = "2";
msg = "原始密码输入错误！";
}
ViewBag.code = code;
ViewBag.msg = msg;
return(View());
}
public ActionResult UserSave(int id = 0)
{
SysUserInfo model = null;
if (id > 0)
{
model = _sysUserRespository.Get(id);
}
if (model == null)
{
model = new SysUserInfo();
}
ViewBag.sysUserState = this.ToSelectTitle(new List <SelectListItem>()
{
new SelectListItem()
{
Text = "正常", Value = "1"
},
new SelectListItem()
{
Text = "锁定", Value = "2"
}, new SelectListItem()
{
Text = "注销", Value = "3"
}
}, emptyTitle: "请选择");
var roleService = AutofacDependencyResolver.Current.GetService <ISysRolesRepository>();
ViewBag.roles = this.ToSelectTitle(roleService.GetRoleList().Select(o => new SelectListItem()
{
Value = o.RoleId.ToString(), Text = o.Title
}));
return(View(model));
}
public ActionResult UserSave(SysUserInfo model)
{
model.Limits = Request["Limits"];
var result = UserService.SaveOrUpdate(model);
return(new OpActionResult(result));
}
public ActionResult ChangeRole(string userAD, string[] selRole)
{
var res = new TRes
{
bok = false
};
if (string.IsNullOrEmpty(userAD) || null == selRole || 0 == selRole.Length)
{
res.msg = "参数有误";
return(Json(res));
}
if (!CommonInfo.HasRight(TRightID.ADMIN))
{
res.msg = "只有管理员才可以修改权限";
return(Json(res));
}
string errmsg = string.Empty;
var sRoleID = SysUserInfo.ChangeRole(userAD, selRole, out errmsg);
res.bok = true;
res.data = sRoleID;
return(Json(res));
}
public void Delete(int id)
{
SysUserInfo entity = this.GetEntity(id);
db.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
public SysUserInfo Add(SysUserInfo entity)
{
var model = db.SysUserInfos.Add(entity);
db.SaveChanges();
return(model);
}
/// <summary>
/// 统一登录写入cookie
/// </summary>
/// <param name="user">Entity.SysUserInfo 用户信息类</param>
/// <param name="remember">记住用户和密码，默认false</param>
public void Login(SysUserInfo user, bool remember = false)
{
Dictionary <string, string> kv = new Dictionary <string, string>();
kv.Add(key_cid, user.CompanyId.ToString());
kv.Add(key_uid, user.UID);
kv.Add(key_uname, user.LoginName);
kv.Add(key_fname, HttpUtility.UrlEncode(user.FullName));
kv.Add(key_branchId, user.BranchId.ToString());
kv.Add(key_bumenId, user.BumenId.ToString());
kv.Add(key_photo, user.PhotoUrl);
kv.Add(key_storeId, HttpUtility.UrlEncode(user.StoreId));
kv.Add(key_roleId, user.RoleIds);
Cookies.Remove("remuc");
if (remember)
{
//kv.Add("_pwd", user.LoginPwd);
Cookies.Set("remuc", kv, 100, true);//防止退出删除
}
//StoreId { get { return "d4ab4325c87c4863b1419b6862d8454c"; } }
SettingLimits(user.UID);
Cookies.Set(Url.CurDomain, "", uc, kv, 1, false);
var browser = HttpContext.Current.Request.Browser;
log.WriteLogin(string.Format("用户（{0}，{1}）成功登录系统！浏览器:{2},版本:{3}", user.LoginName, user.FullName, browser.Browser, browser.Version), LogModule.其他);
}
private void ScheduleEmailMiningJob()
{
SchedulerUtils.DeleteOldJobs(TargetJobGroupName);
SysUserInfo currentUser = UserConnection.CurrentUser;
_schedulerWraper.ScheduleImmediateJob <EmailMiningJob>(TargetJobGroupName, UserConnection.Workspace.Name,
currentUser.Name, null, true);
}
private void btnSelect_Click(object sender, EventArgs e)
{
UserInfo.SkinId = int.Parse(cboSkin.SelectedItem.ToString().Split(':')[1]);
SysUserInfo bUser = new SysUserInfo();
bUser.UpdateUserInfo(UserInfo, new ObjectControls(MCtrl.SetSkinId));
this.Close();
}
public bool ValidateCredentials(SysUserInfo userInfo)
{
if (userInfo.UserName == "admin" && userInfo.UserPwd == "admin")
{
return(true);
}
return(false);
}
public PageEntityRepository(UserConnection uc)
{
UserConnection = uc;
EntitySchemaManager = uc.EntitySchemaManager;
ApplicationCache = uc.ApplicationCache;
CurrentUser = uc.CurrentUser;
Workspace = uc.Workspace;
}
public ActionResult UserSave(SysUserInfo model)
{
model.RoleIds = Request["RoleIds"];
model.CreateUID = Services.SysUserService.CurrentUser.UserID;
var result = _sysUserRespository.AddOrUpdate(model);
return(this.ToJsonOperateResult(result));
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="moduleInfo"></param>
/// <returns></returns>
public bool DeleteSysUser(Guid sysno)
{
SysUserInfo permissionInfo = new SysUserInfo()
{
SysNo = sysno
};
return(_sysUserBizService.DeleteSysUser(permissionInfo));
}
private void insert_one_file(FileUpload file_upload, SysUserInfo curr_user, string batch_id)
{
if ((file_upload.PostedFile != null) &&
(!string.IsNullOrEmpty(file_upload.PostedFile.FileName)))
{
SysAttachment attachment = AttachmentBiz.InsertAttachment(curr_user,
file_upload.PostedFile, batch_id);
}
}
