public ActionResult Create(InstallModel m) { if (m.InstallType == "SCHEMA" || ModelState.IsValid) { // Read embedded create script Stream str = Assembly.GetExecutingAssembly().GetManifestResourceStream("Piranha.Data.Scripts.Create.sql") ; String sql = new StreamReader(str).ReadToEnd() ; str.Close() ; // Read embedded data script str = Assembly.GetExecutingAssembly().GetManifestResourceStream("Piranha.Data.Scripts.Data.sql") ; String data = new StreamReader(str).ReadToEnd() ; str.Close() ; // Split statements and execute string[] stmts = sql.Split(new char[] { ';' }) ; using (IDbTransaction tx = Database.OpenTransaction()) { // Create database from script foreach (string stmt in stmts) { if (!String.IsNullOrEmpty(stmt.Trim())) SysUser.Execute(stmt, tx) ; } tx.Commit() ; } if (m.InstallType.ToUpper() == "FULL") { // Split statements and execute stmts = data.Split(new char[] { ';' }) ; using (IDbTransaction tx = Database.OpenTransaction()) { // Create user SysUser usr = new SysUser() { Login = m.UserLogin, Email = m.UserEmail, GroupId = new Guid("7c536b66-d292-4369-8f37-948b32229b83"), CreatedBy = new Guid("ca19d4e7-92f0-42f6-926a-68413bbdafbc"), UpdatedBy = new Guid("ca19d4e7-92f0-42f6-926a-68413bbdafbc"), Created = DateTime.Now, Updated = DateTime.Now } ; usr.Save(tx) ; // Create user password SysUserPassword pwd = new SysUserPassword() { Id = usr.Id, Password = m.Password, IsNew = false } ; pwd.Save(tx) ; // Create default data foreach (string stmt in stmts) { if (!String.IsNullOrEmpty(stmt.Trim())) SysUser.Execute(stmt, tx) ; } tx.Commit() ; } } return RedirectToAction("index", "account") ; } return Index() ; }
public void GetData() { string _userid = Parameters["puserid"]; SysUserBiz biz = new SysUserBiz(); SysUser item = new SysUser(); item = biz.Select(_userid); Response.Write(item.ToJson()); }
/// <summary> /// 冻结/解冻用户 /// </summary> /// <param name="user">系统用户</param> /// <returns>业务操作结果</returns> public async Task<OperationResult> LockUserOrNot(SysUser user) { user.CheckNotNull("user"); user.IsLocked = !user.IsLocked; await UserRepository.UpdateAsync(user); return new OperationResult(OperationResultType.Success, "操作成功"); }
protected void Page_Load(object sender, EventArgs e) { SysUser useritem = new SysUser(); useritem = GetUserInfo(); lbluserdesc.Text = useritem.FUserDesc; lblusername.Text = useritem.FUserName; this.menu.InnerHtml = SetMenu(useritem.FUserId); }
public ActionResult Create(SysUser sysUser) { db.SysUsers.Add(sysUser); db.SaveChanges(); return RedirectToAction("Index"); }
/// <summary> /// Default constructor. Creates a model. /// </summary> public UserEditModel() { List<SysGroup> gr = SysGroup.GetFields("sysgroup_id, sysgroup_name", new Params() { OrderBy = "sysgroup_id" }) ; groups = new List<SysGroup>() ; groups.Insert(0, new SysGroup()) ; gr.Each<SysGroup>((i,g) => { if (HttpContext.Current.User.IsMember(g.Id)) groups.Add(g) ; }); User = new SysUser() ; Password = new SysUserPassword() ; Groups = new SelectList(groups, "Id", "Name") ; }
//保存 private void btnSave_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (validationProvider.Validate()) { if (Type == DBOperateType.Insert) { User = new SysUser(); User.Valid = true; } User.UserName = txtUserName.Text.Trim(); User.Password = txtPassword.Text; User.RoleCode = lookUpRole.EditValue.ToString(); if (lookUpEmployee.EditValue == null) User.EmployeeID = null; else User.EmployeeID = (int)lookUpEmployee.EditValue; User.CheckComputer = cheCheckComputer.Checked; User.IsLock = cheIsLock.Checked; User.IsAdmin = cheIsAdmin.Checked; User.ComputerCode = txtComputerCode.Text.Trim(); User.Remark = txtRemark.Text.Trim(); User.ModifyUser = Identity.CurrentUser.UserName; User.ModifyDate = DateTime.Now; if (Type == DBOperateType.Insert) WcfServiceHelper.Client.InsertUser(User); else WcfServiceHelper.Client.UpdateUser(User); this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); } } catch (Exception ex) { ControlsHelper.ShowErrorMessage("保存失败", ex.Message); } finally { this.Cursor = Cursors.Default; } }
public void SavePsw() { string _orgpsw = Parameters["orgpsw"]; string _newpsw = Parameters["newpsw"]; string _confirmpsw = Parameters["confirmpsw"]; SysUserBiz biz = new SysUserBiz(); ErrorEntity ErrInfo = new ErrorEntity(); SysUser useritem = new SysUser(); useritem = GetUserInfo(); if (_newpsw.Length < 6) { ErrInfo = new ErrorEntity(RespCode.SysUser0010); } else { int result = biz.UserChangePsw(useritem.FUserId, _orgpsw, _newpsw, _confirmpsw, out ErrInfo); } Response.Write(ErrInfo.ToJson()); }
protected void loginbtn_Click(object sender, EventArgs e) { string username = txtUserName.Text; string psw = txtUserPsw.Text; ErrorEntity ErrInfo = new ErrorEntity(); SysUserBiz userbiz = new SysUserBiz(); SysUser useritem = new SysUser(); useritem = userbiz.UserLogin(username, psw, "PMMG", out ErrInfo); if (ErrInfo.ErrorCode == RespCode.Success) { SetUserInfo(useritem); Response.Redirect("~/partymember/default.aspx"); } else { Server_Alert(ErrInfo.ErrorMessage); return; } }
/// <summary> /// 保存用户信息信息 /// </summary> /// <param name="dtos">要保存的用户DTO信息</param> /// <returns>业务操作结果</returns> public async Task<OperationResult> SaveUsers(params SysUserDto[] dtos) { dtos.CheckNotNull("dtos"); UserRepository.UnitOfWork.TransactionEnabled = true; foreach (SysUserDto dto in dtos) { IdentityResult result; SysUser user = new SysUser(); if (dto.Id > 0)//处理编辑 { user = UserManager.FindById(dto.Id); if (user == null) { return new OperationResult(OperationResultType.QueryNull); } } user = dto.MapTo(user); //密码单独处理 if (!dto.Password.IsNullOrEmpty()) { result = await UserManager.PasswordValidator.ValidateAsync(dto.Password); if (!result.Succeeded) { return result.ToOperationResult(); } user.PasswordHash = UserManager.PasswordHasher.HashPassword(dto.Password); } result = dto.Id > 0 ? await UserManager.UpdateAsync(user) : await UserManager.CreateAsync(user); if (!result.Succeeded) { return new OperationResult(OperationResultType.Error, result.Errors.ExpandAndToString()); } } return UserRepository.UnitOfWork.SaveChanges() > 0 ? new OperationResult(OperationResultType.Success,"保存成功") : OperationResult.NoChanged; }
public void SaveQuestion() { string _contentclassid = Parameters["pcontentclassid"]; string _questionbank = Parameters["pquestionbank"]; string _questionid = Parameters["pquestionid"]; string _questiontitile = Parameters["pquestiontitle"]; string _questiontype = Parameters["pquestiontype"]; string _questiondiffculty = Parameters["pquestiondifficulty"]; string _keyword = Parameters["pkeyword"]; string _desc = Parameters["pdesc"]; string _analysis = Parameters["panalysis"]; ErrorEntity ErrInfo = new ErrorEntity(); OEQuestionBiz biz = new OEQuestionBiz(); HQOnlineExam.ML.OEQuestion item = new HQOnlineExam.ML.OEQuestion(); SysUser useritem = new SysUser(); useritem = GetUserInfo(); item.AUserId = useritem.FUserId; item.AUserName = useritem.FUserName; item.FQuestionId = Convert.ToInt64(_questionid); item.FQBankId = Convert.ToInt64(_questionbank); item.FQuestionTitle = _questiontitile; item.FQuestionType = _questiontype; item.FQuestionDifficulty = _questiondiffculty; item.FKeyWord = _keyword; item.FQuestionDesc = _desc; item.FQuestionAnalysis = _analysis; item.FQuestionStatus = "1"; if (string.IsNullOrEmpty(_questionid) || _questionid == "0") { biz.Insert(item, out ErrInfo); } else { biz.Update(item, out ErrInfo); } Response.Write(ErrInfo.ToJson()); }
//constructor adds two users to the sysUser list public myUserViewModel() { SysUser usr1 = new SysUser { EmailAddress = "*****@*****.**", Password = "******", FirstName = "User1", LastName = "Test" }; SysUser usr2 = new SysUser { EmailAddress = "*****@*****.**", Password = "******", FirstName = "User2", LastName = "Test2" }; List<SysUser> userList = new List<SysUser>(); userList.Add(usr1); userList.Add(usr2); //Attach class property value this.sysUsers = userList; }
public void Update(SysUser user) { context.Entry(user).State = System.Data.Entity.EntityState.Modified; }
private void InitUser() { try { Response.Write(".........初始化用户<br/>"); #region 废弃 //SysUser sysUser = new SysUser(); //sysUser.Name = "系统管理员"; //sysUser.LoginAccount = "admin"; //sysUser.Password = "******"; //sysUser.Status = 0; //Container.Instance.Resolve<SysUserService>().Create(sysUser); //SysUser sysUser = new SysUser() //{ // Name = "系统管理员", // LoginAccount = "admin", // Password = "******", // Status = 0 //}; //Container.Instance.Resolve<SysUserService>().Create(sysUser); #endregion var allRole = Container.Instance.Resolve <SysRoleService>().GetAll(); Container.Instance.Resolve <SysUserService>().Create(new SysUser() { Name = "系统管理员", LoginAccount = "admin", Password = StringHelper.EncodeMD5("123456"), Status = 0, SysRoleList = (from m in allRole where m.ID == 2 select m).ToList(), }); Container.Instance.Resolve <SysUserService>().Create(new SysUser() { Name = "莫宇", LoginAccount = "my", Password = StringHelper.EncodeMD5("123456"), Status = 0, SysRoleList = (from m in allRole where m.ID == 1 select m).ToList(), }); for (int i = 0; i < 100; i++) { Container.Instance.Resolve <SysUserService>().Create(new SysUser() { Name = "用户" + i, LoginAccount = "user" + i, Password = StringHelper.EncodeMD5("123456"), Status = 0 }); } // ID=20 接单员 SysUser user = Container.Instance.Resolve <SysUserService>().GetEntity(20); user.SysRoleList = (from m in allRole where m.ID == 3 select m).ToList(); Container.Instance.Resolve <SysUserService>().Edit(user); // ID=[30, 35] 调度员 IList <int> idRange = new List <int>() { 30, 31, 32, 33, 34, 35 }; var findUser = Container.Instance.Resolve <SysUserService>().Query(new List <ICriterion>() { Expression.In("ID", idRange.ToArray()) }); foreach (var item in findUser) { item.SysRoleList = (from m in allRole where m.ID == 4 select m).ToList(); Container.Instance.Resolve <SysUserService>().Edit(item); } // ID=[40, 45] 驾驶员 idRange = new List <int>() { 40, 41, 42, 43, 44, 45 }; findUser = Container.Instance.Resolve <SysUserService>().Query(new List <ICriterion>() { Expression.In("ID", idRange.ToArray()) }); foreach (var item in findUser) { item.SysRoleList = (from m in allRole where m.ID == 6 select m).ToList(); Container.Instance.Resolve <SysUserService>().Edit(item); } // ID=[50, 55] 财务员 idRange = new List <int>() { 50, 51, 52, 53, 54, 55 }; findUser = Container.Instance.Resolve <SysUserService>().Query(new List <ICriterion>() { Expression.In("ID", idRange.ToArray()) }); foreach (var item in findUser) { item.SysRoleList = (from m in allRole where m.ID == 6 select m).ToList(); Container.Instance.Resolve <SysUserService>().Edit(item); } // ID=[60, 65] 决策员 idRange = new List <int>() { 60, 61, 62, 63, 64, 65 }; findUser = Container.Instance.Resolve <SysUserService>().Query(new List <ICriterion>() { Expression.In("ID", idRange.ToArray()) }); foreach (var item in findUser) { item.SysRoleList = (from m in allRole where m.ID == 7 select m).ToList(); Container.Instance.Resolve <SysUserService>().Edit(item); } Response.Write(".........初始化用户ok<br/>"); } catch (Exception ex) { Response.Write(".........初始化用户Error<br/>"); } }
public void Add(SysUser user) { context.SysUsers.Add(user); }
public ViewResult UserForm(SysUser sysUser) { // INSERT SYSUSER... // VALIDATED by ModelState: // * Values exist for each required field. // * EmailAddress is correct format. // VALIDATED in code, following: // * EmailAddress is unique in the data. if (ModelState.IsValid) { string emailAddress = sysUser.EmailAddress; string password = sysUser.Password; string firstName = sysUser.FirstName; string lastName = sysUser.LastName; if (viewModelProp.sysUsers == null) { //Not a test... viewModelProp = getUserList(); } IList<Models.SysUser> userList = viewModelProp.sysUsers; //Validate uniqueness of new user's email address... var match = from u in userList where u.EmailAddress == emailAddress select u; if (match.Count() > 0) { // EmailAddress not unique in data. Return to sender. ViewBag.Message = "You already have a login. No need to register again."; return View("Index", viewModelProp); } else { //Add user to the list... userList.Add(sysUser); //Sort records by email address, into a new collection... IEnumerable<SysUser> orderedList = from u in userList orderby u.EmailAddress select u; IList<SysUser> newIList = new List<SysUser>(); // Serialize list to XML... XmlDocument xmlUsers = new XmlDocument(); XmlDeclaration dec = xmlUsers.CreateXmlDeclaration("1.0", null, null); xmlUsers.AppendChild(dec); XmlElement root = xmlUsers.CreateElement("Users"); xmlUsers.AppendChild(root); foreach (Models.SysUser u in orderedList) { XmlElement nextUser = xmlUsers.CreateElement("User"); nextUser.SetAttribute("EmailAddress", u.EmailAddress); nextUser.SetAttribute("Password", u.Password); nextUser.SetAttribute("FirstName", u.FirstName); nextUser.SetAttribute("LastName", u.LastName); root.AppendChild(nextUser); //add sorted member to new collection... newIList.Add((Models.SysUser)u); } // replace unsorted List<> with new sorted one... viewModelProp.sysUsers = newIList; //Persist the updated Model: PersistUsers(xmlUsers); } return View("Index", viewModelProp); } else { //Invalid, based on model field validation //performed in MockUserAdmin.Models.sysUsers. return View(viewModelProp.sysUsers); } }
/// <summary> /// 导入数据 /// </summary> private void DoImpData() { string prefix = FileModule.FindFirstByProperties("Name", "Portal").RootPath + "\\Default\\"; string FilePath = RequestData.Get("FileId") + ""; FilePath = prefix + FilePath; DataTable Dt = ExcelToDataTable(FilePath, 4); for (int i = 0; i < Dt.Rows.Count; i++) { try { string workno = Dt.Rows[i]["工号"] + ""; SysUser UserEnt = SysUser.FindFirstByProperties(SysUser.Prop_WorkNo, Dt.Rows[i]["工号"]); SysGroup Group = SysGroup.TryFind(UserEnt.Pk_corp); SysGroup DeptGroup = SysGroup.TryFind(UserEnt.Pk_deptdoc); //Dept TravelMoneyConfig TM = new TravelMoneyConfig(); ComUtility Utility = new ComUtility(); string Money = string.Empty; if (string.IsNullOrEmpty(Dt.Rows[i]["服务年限奖励金"] + "")) { Money = Utility.GetTravelMoney(workno); decimal M = 0.0m; if (decimal.TryParse(Money, out M)) { TM.Money = M; } } else { decimal M = 0.0m; if (decimal.TryParse(Dt.Rows[i]["服务年限奖励金"] + "", out M)) { TM.Money = M; } } //基本津贴 decimal MK = 0.0m; string BaseMoney = Utility.GetTravelBaseMoney(workno); if (decimal.TryParse(BaseMoney, out MK)) { TM.BaseMoney = MK; } TM.UserId = UserEnt.UserID; TM.UserName = UserEnt.Name; TM.WorkNo = UserEnt.WorkNo; DateTime DTime = new DateTime(); if (DateTime.TryParse(UserEnt.Indutydate, out DTime)) { TM.Indutydate = DTime; } if (!string.IsNullOrEmpty(Dt.Rows[i]["是否已用"] + "")) { string val = string.Empty; val = ((Dt.Rows[i]["是否已用"] + "") == "是" || (Dt.Rows[i]["是否已用"] + "") == "Y") ? "Y" : "N"; TM.HaveUsed = val; } if (Group != null) { TM.Corp = Group.GroupID; TM.CorpName = Group.Name; } if (DeptGroup != null) { TM.DeptId = DeptGroup.GroupID; TM.DeptName = DeptGroup.Name; } TM.CreateTime = DateTime.Now; TM.UserId = UserEnt.UserID; TM.Create(); } catch { } } this.PageState.Add("State", "1"); }
public async Task <bool> UpdateLoginUser(SysUser model) => await freeSql.Update <SysUser>().SetSource(model).Where(x => x.Id == model.Id).ExecuteAffrowsAsync() > 0;
public virtual bool Edit(ref ValidationErrors errors, SysUserModel model) { try { SysUser entity = m_Rep.GetById(model.Id); if (entity == null) { errors.Add(Suggestion.Disable); return(false); } entity.Id = model.Id; entity.UserName = model.UserName; entity.Password = model.Password; entity.TrueName = model.TrueName; entity.Card = model.Card; entity.MobileNumber = model.MobileNumber; entity.PhoneNumber = model.PhoneNumber; entity.QQ = model.QQ; entity.EmailAddress = model.EmailAddress; entity.OtherContact = model.OtherContact; entity.Province = model.Province; entity.City = model.City; entity.Village = model.Village; entity.Address = model.Address; entity.State = model.State; entity.CreateTime = model.CreateTime; entity.CreatePerson = model.CreatePerson; entity.Sex = model.Sex; entity.Birthday = model.Birthday; entity.JoinDate = model.JoinDate; entity.Marital = model.Marital; entity.Political = model.Political; entity.Nationality = model.Nationality; entity.Native = model.Native; entity.School = model.School; entity.Professional = model.Professional; entity.Degree = model.Degree; entity.DepId = model.DepId; entity.PosId = model.PosId; entity.Expertise = model.Expertise; entity.JobState = model.JobState; entity.Photo = model.Photo; entity.Attach = model.Attach; if (m_Rep.Edit(entity)) { return(true); } else { errors.Add(Suggestion.EditFail); return(false); } } catch (Exception ex) { errors.Add(ex.Message); ExceptionHandler.WriteException(ex); return(false); } }
public void ReverseReceiptNodeTraceByQty(DocumentBalance docBalance, int quantity, SysUser user) { try { SetService(); SerClient.ReverseReceiptNodeTraceByQty(docBalance, quantity, user); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
internal DocumentPackage CreateNewPackage(Document document, SysUser sysUser, bool isOpen, DocumentPackage parent, string packType) { try { SetService(); return SerClient.CreateNewPackage(document, sysUser, isOpen, parent, packType); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public void ReverseReceiptNodeTraceByLabels(List<NodeTrace> nodeTraceList, SysUser user, DocumentType docType) { try { SetService(); SerClient.ReverseReceiptNodeTraceByLabels(nodeTraceList, user, docType); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public void ReversePickingNodeTraceByLabels(List<NodeTrace> nodeTraceList, SysUser user, Bin restockBin) { try { SetService(); SerClient.ReversePickingNodeTraceByLabels(nodeTraceList, user, restockBin); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public void PickCrossDockProduct(Document purchase, IList<DocumentBalance> crossDockBalance, SysUser picker) { try { SetService(); SerClient.PickCrossDockProduct(purchase, crossDockBalance.ToList(), picker); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public void DeleteSysUser(SysUser data) { try { SetService(); SerClient.DeleteSysUser(data); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public SysUser SaveSysUser(SysUser data) { try { SetService(); return SerClient.SaveSysUser(data); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
protected void Page_Load(object sender, EventArgs e) { try { Aim.Portal.Web.WebPortalService.CheckLogon(); } catch { Response.Write("<script> window.parent.location.href = '/Login.aspx';</script>"); Response.End(); } string action = Request["action"]; SysGroup sgEnt = null; SysUser suEnt = null; IList <SysUser> suEnts = null; string sql = ""; DataTable dt = null; string where = ""; MD5Encrypt encrypt = new MD5Encrypt(); switch (action) { case "sync": string connstr = ConfigurationManager.ConnectionStrings["NimsConn"].ToString(); OracleConnection conn = new OracleConnection(connstr); sql = "select * from apps.cux_hr_org_structrue_v where ORG_ID_CHILD='228' or org_id_parent='228'"; OracleCommand com = new OracleCommand(sql, conn); OracleDataAdapter da = new OracleDataAdapter(com); DataSet ds = new DataSet(); da.Fill(ds); //首先同步部门信息 foreach (DataRow dr in ds.Tables[0].Rows) { sgEnt = SysGroup.TryFind(dr["ORG_ID_CHILD"] + ""); if (sgEnt == null) //如果不存在该部门 { //此处将PATH字段用来存储父部门的名称 sql = "insert into SysGroup (GroupID,Name,Code,ParentID,Path,Status) values('{0}','{1}','{2}','{3}','{4}',1)"; sql = string.Format(sql, dr["ORG_ID_CHILD"], dr["ORG_NAME_CHILD"], dr["ORG_CODE_CHILD"], dr["ORG_ID_PARENT"], dr["ORG_NAME_PARENT"]); DataHelper.ExecSql(sql); } else { sql = "update SysGroup set Name='{0}',Code='{1}',ParentID='{2}',Path='{3}' where GroupID='{4}'"; sql = string.Format(sql, dr["ORG_NAME_CHILD"], dr["ORG_CODE_CHILD"], dr["ORG_ID_PARENT"], dr["ORG_NAME_PARENT"], dr["ORG_ID_CHILD"]); DataHelper.ExecSql(sql); } } //同步人员信息 sql = @"select * from apps.cux_hr_employee_v where ORG_ID in (select ORG_ID_CHILD from apps.cux_hr_org_structrue_v where ORG_ID_CHILD='228' or org_id_parent='228') and primary_flag='Y'"; com = new OracleCommand(sql, conn); da = new OracleDataAdapter(com); ds = new DataSet(); da.Fill(ds); SqlConnection conn_sql = new SqlConnection(); conn_sql.ConnectionString = ConfigurationManager.AppSettings["Con_Portal"]; conn_sql.Open(); foreach (DataRow dr in ds.Tables[0].Rows) { suEnts = SysUser.FindAllByProperty(SysUser.Prop_IDNumber, dr["NATIONAL_IDENTIFIER"]); //通过身份证就行匹配 if (suEnts.Count == 0) { sql = @"insert into SysUser (UserID,LoginName,Name,Password,Email,Phone,HomePhone,Sex,IDNumber,Server_IAGUID,Server_Seed,Status,CreateDate) values(@UserID,@LoginName,@Name,@Password,@Email,@Phone,@HomePhone,@Sex,@IDNumber,@Server_IAGUID,@Server_Seed,@Status,@CreateDate)"; SqlParameter[] sparray = new SqlParameter[13]; sparray[0] = new SqlParameter("@UserID", dr["PERSON_ID"]); sparray[1] = new SqlParameter("@LoginName", dr["EMP_NUM"]);//NIMS数据库工号是不能为空的 即进入的NIMS系统的员工工号是肯定有的 sparray[2] = new SqlParameter("@Name", dr["LAST_NAME"]); sparray[3] = new SqlParameter("@Password", encrypt.GetMD5FromString(dr["SYS_ACCOUNT"].ToString())); sparray[4] = new SqlParameter("@Email", dr["EMAIL_ADDRESS"]); sparray[5] = new SqlParameter("@Phone", dr["MOBILE_PHONE_NUMBER"]); sparray[6] = new SqlParameter("@HomePhone", dr["OFFICE_PHONE_NUMBER"]); sparray[7] = new SqlParameter("@Sex", dr["SEX"]); sparray[8] = new SqlParameter("@IDNumber", dr["NATIONAL_IDENTIFIER"]); sparray[9] = new SqlParameter("@Server_IAGUID", dr["ORG_ID"]); sparray[10] = new SqlParameter("@Server_Seed", dr["ORG_NAME"]); sparray[11] = new SqlParameter("@Status", SqlDbType.TinyInt); sparray[11].Value = 1; sparray[12] = new SqlParameter("@CreateDate", dr["HIRE_DATE"]); SqlCommand com_sql = new SqlCommand(sql, conn_sql); com_sql.Parameters.AddRange(sparray); com_sql.ExecuteNonQuery(); } else { sql = @"update SysUser set LoginName=@LoginName,Name=@Name,Email=@Email,Phone=@Phone,HomePhone=@HomePhone, Sex=@Sex,Server_IAGUID=@Server_IAGUID,Server_Seed=@Server_Seed,CreateDate=@CreateDate where IDNumber=@IDNumber"; SqlParameter[] sparray = new SqlParameter[10]; sparray[0] = new SqlParameter("@LoginName", dr["EMP_NUM"]); sparray[1] = new SqlParameter("@Name", dr["LAST_NAME"]); sparray[2] = new SqlParameter("@Email", dr["EMAIL_ADDRESS"]); sparray[3] = new SqlParameter("@Phone", dr["MOBILE_PHONE_NUMBER"]); sparray[4] = new SqlParameter("@HomePhone", dr["OFFICE_PHONE_NUMBER"]); sparray[5] = new SqlParameter("@Sex", dr["SEX"]); sparray[6] = new SqlParameter("@Server_IAGUID", dr["ORG_ID"]); sparray[7] = new SqlParameter("@Server_Seed", dr["ORG_NAME"]); sparray[8] = new SqlParameter("@CreateDate", dr["HIRE_DATE"]); sparray[9] = new SqlParameter("@IDNumber", dr["NATIONAL_IDENTIFIER"]); SqlCommand com_sql = new SqlCommand(sql, conn_sql); com_sql.Parameters.AddRange(sparray); com_sql.ExecuteNonQuery(); } } conn_sql.Close(); Response.Write("{success:true}"); Response.End(); break; case "inipsd": suEnt = SysUser.Find(Request["UserId"]); suEnt.Password = encrypt.GetMD5FromString(suEnt.LoginName); suEnt.DoUpdate(); Response.Write("{success:true}"); Response.End(); break; case "loadtreedata": string id = Request["id"]; sql = "select GroupID as id,replace(Name,'江西瑞林建设监理有限公司','') as name,1 as leaf from SysGroup where ParentId='" + id + "' order by Code asc"; dt = DataHelper.QueryDataTable(sql); Response.Write(JsonHelper.GetJsonStringFromDataTable(dt)); Response.End(); break; case "loaduser": string groupid = Request["groupid"]; if (!string.IsNullOrEmpty(Request["name_workno"])) { where += " and (LoginName like '%" + Request["name_workno"] + "%' or Name like '%" + Request["name_workno"] + "%')"; } if (!string.IsNullOrEmpty(Request["UserType"])) { where += " and UserType='" + Request["UserType"] + "'"; } if (!string.IsNullOrEmpty(Request["Status"])) { where += " and Status='" + Request["Status"] + "'"; } if (string.IsNullOrEmpty(groupid) || groupid == "228") { sql = @"select UserID as UserId,Name,LoginName,Sex,Phone,Replace(Server_Seed,'江西瑞林建设监理有限公司','') as Server_Seed, HomePhone,IDNumber,CreateDate from SysUser where (Server_Seed like '%江西瑞林建设监理有限公司%' ) " + where; } else { sql = @"select UserID as UserId,Name,LoginName,Sex,Phone,Replace(Server_Seed,'江西瑞林建设监理有限公司','') as Server_Seed, HomePhone,IDNumber,CreateDate,Status from SysUser where Server_Seed like '%江西瑞林建设监理有限公司%' and Server_IAGUID='" + groupid + "'" + where; } dt = DataHelper.QueryDataTable(sql); Response.Write("{'rows':" + JsonHelper.GetJsonStringFromDataTable(dt) + ",total:'" + totalProperty + "'}"); Response.End(); break; } }
public Label PickProductWithTrack(Document document, Label label, double qtyToPick, Node node, SysUser picker, Label packLabel) { try { SetService(); return SerClient.PickProductWithTrack(document, label, qtyToPick, node, picker, packLabel); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public override int SaveChanges() { if (this._DoNotModifyTableBaseInfo) { return(base.SaveChanges()); } List <DbEntityEntry> entities = ChangeTracker.Entries().Where(x => x.State == EntityState.Added || x.State == EntityState.Modified || x.State == EntityState.Deleted).ToList(); foreach (DbEntityEntry entity in entities) { if (entity.Entity is SysTableBase) { SysTableBase entityBase = entity.Entity as SysTableBase; DateTime now = DateTime.Now; SysUser user = null; if (HttpContext.Current.Session[MySessionNames.login] != null) { user = HttpContext.Current.Session[MySessionNames.login] as SysUser; } switch (entity.State) { case EntityState.Added: entityBase.CreatedOn = now; entityBase.CreatedUser = user?.Username ?? MyMagicStrings.noname; break; case EntityState.Deleted: //// TODO : Eğer hiçbir kayıt silinmesin istenirse, ilgili entity'e IIneffaceable interface implement edilmeli ve IsDeleted = true yapılarak entity.state = EntityState.Modified olarak değiştirilmeli. //entityBase.ModifiedOn = now; //entityBase.ModifiedUser = App.CurrentUser?.KullaniciAdi ?? MagicStrings.noname; //// *************************************************************************** //// Silinen kayıtlar günlük olarak yyyyMMdd.xml isimli bir dosyada saklanır. //// Sadece DbTableBase 'den türemiş olan nesneler için bu kayıt yapılır. //// *************************************************************************** //string fileName = DateTime.Now.ToString("yyyyMMdd") + ".xml"; //string filePath = HttpContext.Current.Server.MapPath(@"~\Removed\" + fileName); //XDocument xdoc = null; //if (File.Exists(filePath)) //{ // xdoc = XDocument.Load(filePath); //} //else //{ // xdoc = new XDocument( // new XDeclaration("1.0", "utf-8", "no"), // new XElement("items")); //} //string entityXml = EntitySerializer.Serialize(entity.Entity.GetType(), entity.Entity); //XElement xe = XElement.Parse(entityXml); //xdoc.Root.Add(xe); //xdoc.Save(filePath); //// *************************************************************************** //// *************************************************************************** break; case EntityState.Detached: break; case EntityState.Modified: entityBase.ModifiedOn = now; entityBase.ModifiedUser = user?.Username ?? MyMagicStrings.noname; break; case EntityState.Unchanged: break; default: break; } } } return(base.SaveChanges()); }
internal void ReceiveReturn(Document document, IList<ProductStock> retProduct, SysUser sysUser, double retTotalQty, Node recNode) { try { SetService(); SerClient.ReceiveReturn(document, retProduct.ToList(), sysUser, retTotalQty, recNode); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
//添加用户 public void Add(SysUser sysUser) { db.SysUsers.Add(sysUser); db.SaveChanges(); }
internal void ReceiptAcknowledge(Document document, double numLabels, SysUser sysUser) { try { SetService(); SerClient.ReceiptAcknowledge(document, numLabels, sysUser, null); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
/// <summary> /// Maps a Piranha CMS user to a membership user. /// </summary> /// <param name="user">The user</param> /// <returns>The membership user</returns> private MembershipUser MapUser(SysUser user) { return new MembershipUser("Piranha.Security.InternalUserProvider", user.Login, user.Id, user.Email, "", "", true, user.IsLocked, user.Created, user.LastLogin, user.LastLogin, user.Created, user.Created) ; }
internal Label PickUniqueLabel(Document document, Node node, Product product, string serialLabel, SysUser picker, Label packLabel) { try { SetService(); return SerClient.PickUniqueLabel(document, node, product, serialLabel, picker, packLabel); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public virtual async Task AddUser(SysUser user, CancellationToken cancellationToken = default) { await _userRepository.InsertAsync(user, cancellationToken); await _financeRepository.InsertAsync(new SysUserFinance { Id = user.Id, Amount = 0.00M }, cancellationToken); }
internal void UnPickUniqueLabel(Document document, Label label, SysUser picker) { try { SetService(); SerClient.UnPickUniqueLabel(document, label, picker); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
private void InitUsers(ExtendedIdentityDbContext context) { IdentityManager manager = new IdentityManager(context); var userManager = manager.UserManager; var roleManager = manager.RoleManager; //InitRoles(roleManager); #if DEBUG //var user = new SysUser() //{ // UserName = "******", // Email = "*****@*****.**", // Name = "梁达文", // PhoneNumber = "13826403668", //}; //FindCreateAssignRole(userManager, roleManager, user, "Admin@12345", "系统管理员"); var user = new SysUser() { //Id = Guid.NewGuid().ToString(), UserName = "******", Email = "*****@*****.**", Name = "Iris Xiao", PhoneNumber = "18666031989", }; FindCreateAssignRole(userManager, roleManager, user, "Iris2013", "Manager"); user = new SysUser() { //Id = Guid.NewGuid().ToString(), UserName = "******", Email = "*****@*****.**", Name = "Common User", PhoneNumber = "18666031989", }; FindCreateAssignRole(userManager, roleManager, user, "CommonUser", "一般用户"); #else //var user = new SysUser() //{ // //Id = Guid.NewGuid().ToString(), // UserName = "******", // Email = "*****@*****.**", // Name = "Administrator", // PhoneNumber = "13826403668", //}; //FindCreateAssignRole(userManager, roleManager, user, "Admin@12345", "系统管理员"); var user = new SysUser() { //Id = Guid.NewGuid().ToString(), UserName = "******", Email = "*****@*****.**", Name = "Iris Xiao", PhoneNumber = "18666031989", }; FindCreateAssignRole(userManager, roleManager, user, "Iris2013", "Manager"); user = new SysUser() { //Id = Guid.NewGuid().ToString(), UserName = "******", Email = "*****@*****.**", Name = "Common User", PhoneNumber = "18666031989", }; FindCreateAssignRole(userManager, roleManager, user, "CommonUser", "一般用户"); #endif }
private void InputDatas(DataTable dt) { foreach (DataRow row in dt.Rows) { if (row[2] != null && row[2].ToString().Trim() != "") { string workNo = ""; try { if (SysUser.FindAllByProperties("WorkNo", row[1].ToString().Trim()).Length == 0) { SysUser sysUser = new SysUser(); sysUser.WorkNo = row[1].ToString().Trim(); sysUser.Name = row[2].ToString().Trim(); if (row[3].ToString().Trim() == "") { sysUser.LoginName = GetPingyin(row[2].ToString().Trim()); } else { sysUser.LoginName = row[3].ToString(); } sysUser.Email = row[5].ToString(); sysUser.Remark = row[6].ToString(); sysUser.Status = 1; sysUser.CreateDate = DateTime.Now; sysUser.Save(); if (SysGroup.FindAllByProperties("Name", row[4].ToString().Trim()).Length > 0) { using (new SessionScope()) { SysGroup grp = SysGroup.FindAllByProperties("Name", row[4].ToString().Trim())[0]; IList <string> userIDs = new List <string>(); userIDs.Add(sysUser.UserID); grp.AddUsers(userIDs); } } } else { if (SysGroup.FindAllByProperties("Name", row[4].ToString().Trim()).Length > 0) { SysUser sysUser = SysUser.FindAllByProperties("WorkNo", row[1].ToString().Trim())[0]; using (new SessionScope()) { if (sysUser.RetrieveAllGroup().Where(en => en.Type == 2 && en.Name != row[4].ToString()).Count() == 0) { if (sysUser.RetrieveAllGroup().Where(en => en.Type == 2).Count() > 0) { foreach (SysGroup gp in sysUser.RetrieveAllGroup().Where(en => en.Type == 2)) { gp.User.Remove(sysUser); } } SysGroup grp = SysGroup.FindAllByProperties("Name", row[4].ToString().Trim())[0]; IList <string> userIDs = new List <string>(); userIDs.Add(sysUser.UserID); grp.AddUsers(userIDs); } } } } } catch (Exception e) { continue; } } } }
public ActionResult Details(int ID) { SysUser sysUser = iSysUserR.SelectByID(ID);// db.SysUsers.Find(ID); return(View(sysUser)); }
protected void Page_Load(object sender, EventArgs e) { if (this.Request.Files.Count > 0) { string guid = Guid.NewGuid().ToString(); string filePath = "//WorkTime//InputExcelFiles//" + Guid.NewGuid().ToString() + System.IO.Path.GetExtension(Request.Files[0].FileName); this.Request.Files[0].SaveAs(Server.MapPath(filePath)); ExcelProcessor ep = ExcelService.GetProcessor(Server.MapPath(filePath)); DataSet ds = ep.GetDataSet(); InputDatas(ds.Tables[0]); Response.Write("{success:true}"); Response.End(); } id = RequestData.Get <string>("id", String.Empty); type = RequestData.Get <string>("type", String.Empty); SearchCriterion.AutoOrder = false; SearchCriterion.SetOrder(SysUser.Prop_WorkNo); string dName = SearchCriterion.GetSearchValue <string>("Name"); string workNo = SearchCriterion.GetSearchValue <string>("WorkNo"); SearchCriterion.SetOrder(SysUser.Prop_WorkNo); if (dName != null && dName.Trim() != "") { string where = "select * from SysUser where " + GetPinyinWhereString("Name", dName); where += " and WorkNo like '%" + workNo + "%'"; this.PageState.Add("UsrList", DataHelper.QueryDictList(where)); } else { users = SysUserRule.FindAll(SearchCriterion); this.PageState.Add("UsrList", users); } SysUser usr = null; switch (this.RequestAction) { case RequestActionEnum.Create: usr = this.GetPostedData <SysUser>(); usr.DoCreate(); this.SetMessage("新建成功!"); break; case RequestActionEnum.Update: usr = this.GetMergedData <SysUser>(); usr.DoUpdate(); this.SetMessage("保存成功!"); break; case RequestActionEnum.Delete: usr = this.GetTargetData <SysUser>(); usr.DoDelete(); this.SetMessage("删除成功!"); break; default: if (RequestActionString == "clearpass") { usr = SysUser.Find(this.RequestData.Get <string>("UserId")); usr.Password = ""; usr.Remark = ""; usr.Save(); } else if (RequestActionString == "setpass") { MD5Encrypt encrypt = new MD5Encrypt(); SysUser[] users = SysUser.FindAll(); foreach (SysUser user in users) { Random rnd = new Random(); int rndNum = rnd.Next(10000000, 99999999); string encryPassword = encrypt.GetMD5FromString(rndNum.ToString()); user.Password = encryPassword; user.Remark = rndNum.ToString(); user.Save(); } } else if (RequestActionString == "checkkey") { if (SysUser.FindAllByProperties("Server_IAGUID", this.RequestData.Get <string>("usbguid")).Length > 0) { this.PageState.Add("UserName", SysUser.FindAllByProperties("Server_IAGUID", this.RequestData.Get <string>("usbguid"))[0].Name); } else { this.PageState.Add("UserName", ""); } } else if (RequestActionString == "setkey") { SysUser user = SysUser.Find(this.RequestData.Get <string>("userid")); user.Server_IAGUID = this.RequestData.Get <string>("usbguid"); user.Server_Seed = "FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"; user.ThreeDESKEY = "ABCDEFGhijklmn0123456789"; user.Save(); } else if (RequestActionString == "sendmail") { IList <object> idList = RequestData.GetList <object>("IdList"); SysUser[] tents = SysUser.FindAll(Expression.In("UserID", idList.ToArray())); foreach (SysUser user in tents) { string body = SysParameter.FindAllByProperties("Code", "MailText")[0].Description + "<br>"; body += "您的登录用户名:" + user.LoginName + ";密码:" + user.Remark; string mailAccount = SysParameter.FindAllByProperties("Code", "MailAccount")[0].Value; string mailPass = SysParameter.FindAllByProperties("Code", "MailPassword")[0].Value; string mailServer = SysParameter.FindAllByProperties("Code", "MailSmtpServer")[0].Value; string mailSenderAddress = SysParameter.FindAllByProperties("Code", "MailSenderAddress")[0].Value; MailHelper.SendMail(mailSenderAddress, user.Email, "工时分配系统邮件", body, mailAccount, mailPass, mailServer); } } break; } }
public void Delete(int UseID) { SysUser user = context.SysUsers.Find(UseID); context.SysUsers.Remove(user); }
public ActionResult ConfigServiceRight(int roleId = -1, int userId = 0) { //具有国内/国际开发主管角色的登入用户进入该页后,角色下拉列表只列出国内/国际开发主管, //否则,列出国内开发主管和国际开发主管两角色: SysRoleLogic roleLogic = new SysRoleLogic(); List <SysRole> roleList = roleLogic.GetRoleList().ToList <SysRole>(); LoginUserInfo currentLogin = this.WorkContext.CurrentUser; //7表示国内开发主管角色,8表示国际开发主管角色 if (currentLogin.RoleId == 7 || currentLogin.RoleId == 8) { roleList = roleList.Where(x => x.RoleId == currentLogin.RoleId).ToList <SysRole>(); } else { roleList = roleList.Where(x => (x.RoleId == 7 || x.RoleId == 8)).ToList <SysRole>(); } ViewBag.RoleId = new SelectList(roleList, "RoleId", "RoleName"); if (roleId < 1) { if (currentLogin.RoleId == 7 || currentLogin.RoleId == 8) { ViewBag.CurrentRoleId = currentLogin.RoleId; } else { ViewBag.CurrentRoleId = 7; } } else { ViewBag.CurrentRoleId = roleId; } List <SysUser> userList = GetUserList(roleId); ViewBag.UserId = new SelectList(userList, "UserId", "RealName"); ViewBag.CurrentUserId = userId; List <SysRoleRight> roleRightList = new List <SysRoleRight>(); if (roleId > 0) { SysApplicationLogic appIdMenuLogic = new SysApplicationLogic(); //求配置中心权限管理模块的各菜单项: List <SysApplicationEntity> appIdMenuList = null; SysUserLogic sysUserLogic = new SysUserLogic(); SysUser sysUser = null; int? selectedUserId = -1; string selectedUserName = string.Empty; switch (roleId) { case 7: //国内开发主管角色,目前只求针对国内机票产品线的配置中心权限管理模块的各菜单项: sysUser = sysUserLogic.GetUserInfo(userId); if (sysUser != null) { selectedUserName = sysUser.RealName; ViewBag.CurrentUserName = selectedUserName; } appIdMenuList = appIdMenuLogic.GetSysApplicationList(-1, -1, "", -1, -1, null, new List <int> { 1 }, selectedUserName).ToList <SysApplicationEntity>(); break; case 8: //国际开发主管角色,目前只求针对国际机票产品线的配置中心权限管理模块的各菜单项: sysUser = sysUserLogic.GetUserInfo(userId); if (sysUser != null) { selectedUserName = sysUser.RealName; ViewBag.CurrentUserName = selectedUserName; } appIdMenuList = appIdMenuLogic.GetSysApplicationList(-1, -1, "", -1, -1, null, new List <int> { 2 }, selectedUserName).ToList <SysApplicationEntity>(); break; default: break; } ViewBag.AppIdMenuList = appIdMenuList; selectedUserId = ViewBag.CurrentUserId as int?; roleRightList = logic.GetRoleRightList(roleId, true, (selectedUserId.HasValue ? Convert.ToInt32(selectedUserId) : -1)).ToList <SysRoleRight>(); } return(View(roleRightList)); }
public VMregisterInfomation Register(ViewModelRegister viewmodelRegister) { VMregisterInfomation vMregisterInfomation = null; try { vMregisterInfomation = new VMregisterInfomation(); if (viewmodelRegister.Account != "") //判断用户账号是否为空 { var u = unitOfWork.SysUserRepository.Get().Where(s => s.UserAccount.Equals(viewmodelRegister.Account)).FirstOrDefault(); //查找是否存在账号,存在返回账号所在对象,否则返回null if (u == null) //判断账号是否存在 { // 账号规范放在 UI 进行 #region 账号规范 foreach (char c in viewmodelRegister.Account) //规范账号必须由字母和数字构成 { if (!(('0' <= c && c <= '9') || ('A' <= c && c <= 'Z') || ('a' <= c && c <= 'z'))) { throw new Exception("账号必须只由字母和数字构成!"); } } #endregion if (viewmodelRegister.Password != "") //判断密码是否为空 { // 密码规范放在 UI 进行 #region 密码规范 int number = 0, character = 0; foreach (char c in viewmodelRegister.Password) //规范密码必须由ASCII码33~126之间的字符构成 { if (!(33 <= c && c <= 126)) { throw new Exception("符号错误,请重新输入!"); } if ('0' <= c && c <= '9') //number记录数字个数 { number++; } else //character记录字符个数 { character++; } } if (number < 5 || character < 2) //密码的安全系数 { throw new Exception("密码安全系数太低!"); } #endregion if (viewmodelRegister.Password.Equals(viewmodelRegister.SurePassword)) //判断密码与确认密码是否相等 放在 UI 进行 { if (viewmodelRegister.Answer != "1" + "2" + "3" + "4" + "5") //判断拾回密码是否为空 { // 下面需要调试 看看 ,逻辑过程是否合理,另外角色根据具体场景,一般是默认缺省的角色,其他的角色在用户管理界面进行重新 赋予高级角色 var sysRole = unitOfWork.SysRoleRepository.Get().Where(s => s.RoleName.Equals(viewmodelRegister.RoleName)).FirstOrDefault(); //寻找用户所选择角色在UserRole里的实例,返回对象 if (sysRole != null) { var CurrentUser = new SysUser(); CurrentUser.UserAccount = viewmodelRegister.Account; CurrentUser.UserPassword = CreateMD5.EncryptWithMD5(viewmodelRegister.Password); CurrentUser.UserAnswer = CreateMD5.EncryptWithMD5(viewmodelRegister.Answer); CurrentUser.RememberPassword = "******"; unitOfWork.SysUserRepository.Insert(CurrentUser); //增加新SysUser unitOfWork.Save(); var CurrentUserRole = new SysUserRole(); CurrentUserRole.SysUserID = CurrentUser.ID; CurrentUserRole.SysRoleID = sysRole.ID; unitOfWork.SysUserRoleRepository.Insert(CurrentUserRole); //增加新SysUserRole unitOfWork.Save(); //对更改进行保存 vMregisterInfomation.message = "注册成功"; return(vMregisterInfomation); } } else { throw new Exception("密码拾回问题答案不能为空!"); } } else { throw new Exception("两次输入的密码不一致!");//2次密码不一致放在 UI 进行判断 } } else { throw new Exception("密码不能为空!"); } } else { throw new Exception("用户名已存在!"); } } else { throw new Exception("账号不能为空!"); } } catch (Exception ex) { vMregisterInfomation.message = ex.Message; return(vMregisterInfomation); } return(vMregisterInfomation); }
public ActionResult Edit(SysUser sysUser) { db.Entry(sysUser).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); }
protected override void Seed(SomeProject.Core.Model.DefaultDbContext context) { base.Seed(context); return; List <SysRole> roles = new List <SysRole> { new SysRole { Name = "系统管理", Description = "系统管理角色,拥有整个系统的管理权限。", RoleType = RoleType.Admin }, new SysRole { Name = "蓝钻", Description = "蓝钻会员角色", RoleType = RoleType.Guest }, new SysRole { Name = "红钻", Description = "红钻会员角色", RoleType = RoleType.Guest }, new SysRole { Name = "黄钻", Description = "黄钻会员角色", RoleType = RoleType.Guest }, new SysRole { Name = "绿钻", Description = "绿钻会员角色", RoleType = RoleType.Guest } }; DbSet <SysRole> roleSet = context.Set <SysRole>(); roleSet.AddOrUpdate(m => new { m.Name }, roles.ToArray()); context.SaveChanges(); List <SysUser> users = new List <SysUser> { new SysUser { UserName = "******", Password = "******", Email = "*****@*****.**", NickName = "管理员" }, new SysUser { UserName = "******", Password = "******", Email = "*****@*****.**", NickName = "张三" } }; for (int i = 0; i < 100; i++) { Random rnd = new Random((int)DateTime.Now.Ticks + i); SysUser user = new SysUser { UserName = "******" + i, Password = "******", Email = "userName" + i + "@cn.net", NickName = "用户" + i }; var roleArray = roleSet.ToArray(); if (user.Roles == null) { user.Roles = new List <SysRole>(); } user.Roles.Add(roleArray[rnd.Next(0, roleArray.Length)]); if (rnd.NextDouble() > 0.5) { user.Roles.Add(roleArray[rnd.Next(1, roleArray.Length)]); } users.Add(user); } DbSet <SysUser> userSet = context.Set <SysUser>(); userSet.AddOrUpdate(m => new { m.UserName }, users.ToArray()); }
/// <summary> /// 编辑用户信息 /// </summary> /// <param name="user">修改用户名,性别,密码,地址,qq,手机</param> /// <param name="token"></param> /// <returns></returns> public JsonResult EditeUserInfo(string username, int sex, int age) { var Res = new JsonResult(); RespResult result = new RespResult(); try { if (!CacheManagerFactory.GetMemoryManager().Contains(token)) { result.Error = AppError.ERROR_PERSON_NOT_LOGIN; } else { int userid = Convert.ToInt32(CacheManagerFactory.GetMemoryManager().Get(token)); if (userid > 0) { SysUser olduser = SysUserAccessor.Instance.Get(userid); olduser.UserName = username; olduser.Sex = sex; olduser.Birthday = DateTime.Now.AddYears(-age); //olduser.Pwd = user.Pwd; //olduser.Province = user.Province; //olduser.City = user.City; //olduser.County = user.County; //olduser.Street = user.Street; //olduser.Mobile = user.Mobile; //olduser.Qq = user.Qq; //SysUser olduser = SysUserAccessor.Instance.Get(userid, string.Empty, string.Empty, StateType.Ignore); //if (olduser.UserAccount != user.UserAccount) //{ // AdvancedResult<bool> dr = CheckAccout(user.UserAccount); // if (dr.Data) // { // result.Error = AppError.ERROR_PERSON_FOUND; // return result; // } //} //olduser.UserAccount = user.UserAccount; //olduser.Pwd = user.Pwd; //olduser.Province = user.Province; //olduser.City = user.City; //olduser.County = user.County; //olduser.Street = user.Street; //olduser.Mobile = user.Mobile; //olduser.Qq = user.Qq; SysUserAccessor.Instance.Update(olduser); result.Error = AppError.ERROR_SUCCESS; } else { result.Error = AppError.ERROR_FAILED; } } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); }
private void simpleButtonOk_Click(object sender, EventArgs e) { _sysUser = new SysUser(); _sysPackage = new SysPackage(); _sysConfig = new SysConfig(); if (dxErrorProviderMain.HasErrors) { XtraMessageBox.Show("Vui lòng cung cấp đủ thông tin yêu cầu"); return; } if (textEditPassword.Text != _sysUser.maskPwd) { pwd = Security.EnCode(textEditPassword.Text); } if (!_sysUser.CheckLogin(textEditUser.Text, pwd)) { XtraMessageBox.Show("Thông tin đăng nhập chưa chính xác, vui lòng kiểm tra lại!"); return; } drUser = _sysUser.DrUser; DataTable dt1 = _sysPackage.GetPackageForUser(_sysUser); if (dt1 == null) { return; } if (dt1.Rows.Count == 0) { XtraMessageBox.Show("Người dùng này chưa được phân quyền sử dụng gói phần mềm nào!"); return; } //dang nhap thanh cong Config.NewKeyValue("StructServer", _sysPackage.StructServer); lookUpEditPackage.Properties.DataSource = dt1; lookUpEditPackage.Properties.DisplayMember = radioGroupLanguage.SelectedIndex == 0 ? "PackageName" : "PackageName2"; lookUpEditPackage.Properties.ValueMember = "sysDBID"; if (dt1.Rows.Count == 1) { drPackage = dt1.Rows[0]; lookUpEditPackage.EditValue = dt1.Rows[0]["sysDBID"]; Config.NewKeyValue("Admin", bool.Parse(dt1.Rows[0]["isAdmin"].ToString())); Config.NewKeyValue("sysUserPackageID", dt1.Rows[0]["sysUserPackageID"]); if (_sysConfig.DsStartConfig == null || _sysConfig.DsStartConfig.Tables[0].Rows.Count == 0) { DangNhap(); } else { simpleButtonLogin_Click(simpleButtonLogin, new EventArgs()); //this.Height = 300; //layoutControl2.Visible = true; ////layoutControlItemLogin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; //layoutControlItemStartConfig.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; //layoutControlItemPackage.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; } } else { // this.Height = 340; //layoutControl2.Size = new System.Drawing.Size(583, 40); simpleButtonLogin.Visible = true; lookUpEditPackage.Visible = true; // layoutControl2.Visible = true; lc1.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lc2.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lookUpEditPackage.Focus(); //layoutControlItemStartConfig.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; //layoutControlItemPackage.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; } }
public ActionResult Index(T_XSDModels evalModel) { SysUser UserModel = Session["UserModel"] as SysUser; try { ViewData["shUserId"] = UserModel.UserId; evalModel.currentPage = int.Parse(Request["pageNum"].ToString()); } catch { } string order = ""; try { order = Request["orderField"].ToString(); } catch { } if (order.Trim() == "${param.orderField}") { order = ""; } int pagesize = Convert.ToInt32(evalModel.pageSize); int pagecount = Convert.ToInt32(evalModel.pagecount); int currentPage = Convert.ToInt32(evalModel.currentPage); evalModel.DataModel = evalModel.DataModel ?? new T_XSD(); string strCUSQY = "请选择"; if (Request["strXSDH"] != null) { string str = Request["strXSDH"].ToString(); if (!String.IsNullOrEmpty(str)) { evalModel.DataModel.XSDH = str; } } if (Request["strXSDMC"] != null) { string str = Request["strXSDMC"].ToString(); if (!String.IsNullOrEmpty(str)) { evalModel.DataModel.XSMC = str; } } if (Request["strCUSQY"] != null) { strCUSQY = Request["strCUSQY"].ToString(); if (!String.IsNullOrEmpty(strCUSQY)) { evalModel.DataModel.KHID = Convert.ToInt16(strCUSQY); } } var strXSPerson = ""; if (Request["strXSPerson"] != null) { strXSPerson = Request["strXSPerson"].ToString(); if (!String.IsNullOrEmpty(strXSPerson)) { evalModel.DataModel.XSRY = strXSPerson; } } ViewData["strXSPerson"] = strXSPerson; var cpId = 0; if (Request["strXSCPMC"] != null) { string str = Request["strXSCPMC"].ToString(); if (!String.IsNullOrEmpty(str)) { cpId = Convert.ToInt32(str); } ViewData["strXSCPMC"] = str; } var cusId = 0; if (Request["strXSCusQY"] != null) { string str = Request["strXSCusQY"].ToString(); if (!String.IsNullOrEmpty(str)) { cusId = Convert.ToInt32(str); } ViewData["strXSCusQY"] = str; } //购货企业列表 T_CusQY cusqy = new T_CusQY(); ViewBag.CUSQY = new SelectList(T_CusQYDomain.GetInstance().GetAllT_CusQY(cusqy).Where(p => p.CusStatus == 1).ToList(), "CusID", "CusMC"); ViewData["strCUSQY"] = strCUSQY; //获取本企业下的人员列表 T_Person person = new T_Person(); person.PsQYID = (int)UserModel.UserCompanyID; ViewBag.Persons = new SelectList(T_PersonDomain.GetInstance().GetAllT_Person(person), "PsMZ", "PsMZ"); T_SupQYModels supmode = new T_SupQYModels(); supmode.DataModel = supmode.DataModel ?? new T_SupQY(); supmode.DataList = T_SupQYDomain.GetInstance().GetAllT_SupQY(supmode.DataModel).Where(p => p.SupStatus == 1).ToList(); ViewData["SupQYList"] = new SelectList(supmode.DataList, "SupID", "SupMC"); T_YLCPModels ylcpQymode = new T_YLCPModels(); ylcpQymode.DataModel = ylcpQymode.DataModel ?? new T_YLCP(); ylcpQymode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpQymode.DataModel).Where(p => p.CPStatus == 1).ToList(); ViewData["YLCP"] = new SelectList(ylcpQymode.DataList, "CPID", "CPMC"); evalModel.DataList = T_XSDDomain.GetInstance().PageT_XSD(evalModel.DataModel, evalModel.StartTime, evalModel.EndTime, currentPage, pagesize, cpId, cusId, out pagecount, out resultCount); evalModel.resultCount = resultCount; return(View("~/Views/T_XSD/Index.cshtml", evalModel)); }
protected void btnADD_Click(object sender, EventArgs e) { string sqlchkMajor = "Select * From MAJOR Where MAJORCODE='" + ddlMajor.SelectedValue + "'"; List <TQF.Major> chkMajor = new TQF.Major().getMajorManual(sqlchkMajor); if (chkMajor.Count > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('แขนงวิชาซ้ำ!');", true); //เรียกข้อมูลอาจารย์ขึ้นมาใหม่เมื่อเวลาเก็บข้อมูลลงไปแล้วไม่สามารถนำกลับมาใช้ได้อีก List <SysUser> sysUser = new SysUser().getSysUser(); ddlLecturer.Items.Clear(); foreach (SysUser rowUser in sysUser) { string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + rowUser.IdCode + "'"; List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql); //เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง if (aboutLecturer.Count > 0) { continue; } else { ddlLecturer.Items.Insert(ddlLecturer.Items.Count, new ListItem(rowUser.ThName + " " + rowUser.ThSurName + " (" + rowUser.ShortName + ")", rowUser.IdCode)); } } } else { TableRow row = new TableRow(); //Cell [0] TableCell cellSpecialField_Thai = new TableCell(); cellSpecialField_Thai.Text = new SpecialField().getSpecialField(ddlMajor.SelectedValue).SpecialField_Thai; row.Cells.Add(cellSpecialField_Thai); //Cell [1] TableCell cellSpecialField_Eng = new TableCell(); cellSpecialField_Eng.Text = new SpecialField().getSpecialField(ddlMajor.SelectedValue).SpecialField_Eng; row.Cells.Add(cellSpecialField_Eng); //Cell [2] TableCell cellAboutLecturer = new TableCell(); foreach (ListItem li in ddlLecturer.Items) { if (li.Selected) { int sequence = int.Parse(new TQF.TQFUtility().getMaxID("SEQUENCE", "ABOUTLECTURER")); cellAboutLecturer.Text += li.Text + "<br>"; AboutLecturer aboutlecturer = new AboutLecturer(); aboutlecturer.CurrCode = CurrCode; aboutlecturer.YearVersion = YearVersion; aboutlecturer.LectIdentity = li.Value; aboutlecturer.LoadTypeCode = "4"; //4 = อาจารย์ประจำแขนง (ข้อมูลจากตาราง LoadType) aboutlecturer.Sequence = sequence.ToString(); aboutlecturer.MajorCode = ddlMajor.SelectedValue; //add อาจารย์ลงตาราง AboutLecturer string insertAboutlecturer = new AboutLecturer().insertAboutLecturer(aboutlecturer); } } row.Cells.Add(cellAboutLecturer); //เก็บข้อมูลแขนงวิชาลงตาราง Major TQF.Major major = new TQF.Major(); major.MajorCode = ddlMajor.SelectedValue; major.MajorThName = new SpecialField().getSpecialField(ddlMajor.SelectedValue).SpecialField_Thai; major.MajorEnName = new SpecialField().getSpecialField(ddlMajor.SelectedValue).SpecialField_Eng; major.CurrCode = CurrCode; major.YearVersion = YearVersion; string insertMajor = new TQF.Major().insertMajor(major); //Cell [3] TableCell cellDel = new TableCell(); string urlDel = "deleteMAJOR.aspx?CurrCode=" + major.CurrCode + "&YearVersion=" + major.YearVersion + "&MajorCode=" + major.MajorCode; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteMAJOR"); hypDel.Attributes.Add("data-toggle", "modal"); hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>"; hypDel.NavigateUrl = urlDel; hypDel.ToolTip = "Delete"; cellDel.Controls.Add(hypDel); cellDel.CssClass = "text-center"; cellDel.Width = 50; row.Cells.Add(cellDel); tblMajor.Rows.Add(row); //เคลียร์ค่า selection คอนโทรล ddlMajor ddlMajor.ClearSelection(); //เรียกข้อมูลอาจารย์ขึ้นมาใหม่เมื่อเวลาเก็บข้อมูลลงไปแล้วไม่สามารถนำกลับมาใช้ได้อีก List <SysUser> sysUser = new SysUser().getSysUser(); ddlLecturer.Items.Clear(); foreach (SysUser rowUser in sysUser) { string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + rowUser.IdCode + "'"; List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql); //เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง if (aboutLecturer.Count > 0) { continue; } else { ddlLecturer.Items.Insert(ddlLecturer.Items.Count, new ListItem(rowUser.ThName + " " + rowUser.ThSurName + " (" + rowUser.ShortName + ")", rowUser.IdCode)); } } }//end else }
/// <summary> /// 验证用户注册 /// </summary> /// <param name="dto">用户注册信息</param> /// <param name="validateCode">验证码</param> /// <returns>业务操作结果</returns> public async Task<OperationResult> ValidateRegister(UserInfoRegistDto dto, string validateCode) { dto.CheckNotNull("dto"); validateCode.CheckNotNullOrEmpty("validateCode"); //验证码 var severCode = GetValidateCode(dto.UserName, CodeType.用户注册); if (severCode == null || severCode.Code != validateCode) { return new OperationResult(OperationResultType.ValidError, "验证码错误", 0); } if (SysUserRepo.CheckExists(p => p.UserName == dto.UserName)) { return new OperationResult(OperationResultType.ValidError, "账号已被使用", 0); } try { UserInfoRepo.UnitOfWork.TransactionEnabled = true; //验证密码格式 IdentityResult result = await UserManager.PasswordValidator.ValidateAsync(dto.Password); if (!result.Succeeded) return result.ToOperationResult(); SysUser sUser = new SysUser() { UserName = dto.UserName, NickName = dto.NickName, PasswordHash = UserManager.PasswordHasher.HashPassword(dto.Password),//密码加密 UserType = UserType.App用户 }; if (severCode.ValidateType == ValidateType.手机) { sUser.PhoneNumber = dto.UserName; sUser.PhoneNumberConfirmed = true; } else { sUser.Email = dto.UserName; sUser.EmailConfirmed = true; } await UserManager.CreateAsync(sUser); var userInfo = Mapper.Map<UserInfo>(dto); userInfo.SysUser = sUser; await UserInfoRepo.InsertAsync(userInfo); await UserInfoRepo.UnitOfWork.SaveChangesAsync(); return new OperationResult(OperationResultType.Success, "注册成功", userInfo.Id); } catch { return new OperationResult(OperationResultType.NoChanged, "注册失败", 0); } }
/// <summary> /// 员工注册 /// </summary> /// <param name="account">员工账号是邮箱格式</param> /// <param name="pwd"></param> /// <returns></returns> public JsonResult UserRegister(string username, string account, string pwd, string entCode) { var Res = new JsonResult(); AdvancedResult <string> result = new AdvancedResult <string>(); try { AdvancedResult <bool> dr = CheckUserAccout(account); if (dr.Data) { result.Error = AppError.ERROR_PERSON_FOUND; Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); } SysUser entUser = new SysUser(); SysUser user = new SysUser(); if (!string.IsNullOrEmpty(entCode)) { entUser = SysUserAccessor.Instance.GetEntUserByEntCode(entCode.ToUpper().Trim()); if (entUser != null) { user.EntId = entUser.EntId; user.EntCode = entCode.ToUpper(); } else { result.Error = AppError.ERROR_FAILED; Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); } } user.UserAccount = account; user.UserName = username; user.Pwd = SecurityHelper.MD5(pwd); user.Email = account; user.CreateTime = DateTime.Now; user.EndTime = DateTime.Now.AddDays(90); user.IsEnable = 1; user.Type = 1; int i = SysUserAccessor.Instance.Insert(user); if (i > 0) { string token = SecurityHelper.GetToken(i.ToString()); CacheManagerFactory.GetMemoryManager().Set(token, i.ToString()); result.Error = AppError.ERROR_SUCCESS; result.Data = token; WriteAuthCookie(user.UserName, token); AddUserTimeMachine(i, 1, 0); } } catch (Exception e) { result.Error = AppError.ERROR_FAILED; result.ExMessage = e.ToString(); } Res.Data = result; Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(Res); }
public Boolean Delete(SysUser data) { return(base.Delete(data)); }
private void createCreditTable2() { available_data = (AvailableCourseData)Session["save_data"]; CourseData course_data = new Course().getCourse(available_data.Course_Code); tblSubCredit.Rows.Clear(); // แบ่งโหลด string[] ar5 = { "ชื่ออาจารย์", "ภาระงานสอน ชั่วโมง/หน่วยกิต", "ชั่วโมงสอนอ้างอิง", "หน่วยกิตรวม", "แบ่งหน่วยกิต" }; Table tb5 = new Table(); tb5.Attributes.Add("class", "table table-bordered table-striped"); tb5.Attributes.Add("id", "dt_basic5"); TableHeaderRow tRowHead5 = new TableHeaderRow(); tRowHead5.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar5.Length; cellCtr++) { // Create a new cell and add it to the row. TableHeaderCell cellHead5 = new TableHeaderCell(); cellHead5.Text = ar5[cellCtr - 1]; cellHead5.Attributes.Add("class", "text-align-center"); tRowHead5.Cells.Add(cellHead5); } tb5.Rows.Add(tRowHead5); int i = 0; List <LecturerTableData> new_lecturertable = new List <LecturerTableData>(); //List<LecturerTableData> tmp = new List<LecturerTableData>(); new_lecturertable = lecturertable.OrderBy(o => o.Lecturer).ToList(); //string lec_code = ""; //foreach (LecturerTableData lect_data in tmp) // { // if (lect_data.Lecturer != lec_code) // { // new_lecturertable.Add(lect_data); // } // lec_code = lect_data.Lecturer; // } foreach (LecturerTableData lect_data in new_lecturertable) { subcreditData = (List <SubCreditData>)Session["subCredit"]; SysUser user1 = new SysUser(); user1 = new SysUser().getSysUser(lect_data.Lecturer); Sysuser2 user2 = new Sysuser2(); user2 = new Sysuser2().getSysuser2(lect_data.Lecturer); TableRow tRowBody5 = new TableRow(); tRowBody5.TableSection = TableRowSection.TableBody; TableCell cellLecName = new TableCell(); cellLecName.Text = lecturerObj.getLecturer(lect_data.Lecturer).First_ThaiName + " " + lecturerObj.getLecturer(lect_data.Lecturer).Family_ThaiName; tRowBody5.Cells.Add(cellLecName); WorkLoadConfigData workload = new WorkLoadConfigData(); workload = new WorkLoadConfig().getWorkLoadConfig(user2.Lecturer_Type, user1.Position); TableCell cellLoad = new TableCell(); cellLoad.Text = workload.HourReference.ToString() + " / " + workload.TotalCredit.ToString(); cellLoad.Attributes.Add("class", "text-align-center"); tRowBody5.Cells.Add(cellLoad); TableCell cellHourRef = new TableCell(); cellHourRef.Text = new WorkLoadCalculate().getHourRef(lect_data.AcademicYear, lect_data.Semester, lect_data.Lecturer).ToString(); cellHourRef.Attributes.Add("class", "text-align-center"); tRowBody5.Cells.Add(cellHourRef); TableCell cellTotalCredit = new TableCell(); cellTotalCredit.Text = new WorkLoadCalculate().getTotalCredit(lect_data.AcademicYear, lect_data.Semester, lect_data.Lecturer).ToString(); cellTotalCredit.Attributes.Add("class", "text-align-center"); tRowBody5.Cells.Add(cellTotalCredit); int credit = course_data.Credit; if (lect_data.Course_Type == "1") { if (course_data.Practice != 0) { credit = course_data.Theory; } else { credit = course_data.Credit; } } else if (lect_data.Course_Type == "2") { if (course_data.Theory != 0) { credit = course_data.Practice / 2; } else { credit = course_data.Credit; } } TableCell cellSubCredit = new TableCell(); txtSubCredit = new TextBox[new_lecturertable.Count]; txtSubCredit[i] = new TextBox(); txtSubCredit[i].ID = lect_data.Lecturer + lect_data.Teaching_Day + lect_data.Teaching_Start_Time.Replace(":", "").Replace(".", "") + lect_data.Teaching_End_Time.Replace(":", "").Replace(".", ""); txtSubCredit[i].MaxLength = 5; txtSubCredit[i].Width = 50; txtSubCredit[i].AutoPostBack = true; txtSubCredit[i].Text = subcreditData[i].ToString(); txtSubCredit[i].Attributes.Add("class", "text-align-center"); txtSubCredit[i].TextChanged += new EventHandler(txtChanged); cellSubCredit.Attributes.Add("class", "text-align-center"); cellSubCredit.Controls.Add(txtSubCredit[i]); tRowBody5.Cells.Add(cellSubCredit); tb5.Rows.Add(tRowBody5); i++; } TableRow row5 = new TableRow(); TableCell cell5 = new TableCell(); cell5.Controls.Add(tb5); row5.Cells.Add(cell5); tblSubCredit.Rows.Add(row5); }
public SysUser SelectById(SysUser data) { return((SysUser)base.SelectById(data)); }
public override IQuery GetHsql(Object data) { StringBuilder sql = new StringBuilder("select a from SysUser a where "); SysUser user = (SysUser)data; if (user != null) { Parms = new List <Object[]>(); if (user.UserID != 0) { sql.Append(" a.UserID = :usr and "); Parms.Add(new Object[] { "usr", user.UserID }); } if (!String.IsNullOrEmpty(user.UserName)) { sql.Append(" Lower(a.UserName) = :nom and "); Parms.Add(new Object[] { "nom", user.UserName.ToLower() }); } if (!String.IsNullOrEmpty(user.Password)) { sql.Append(" a.Password = :nom1 and "); Parms.Add(new Object[] { "nom1", user.Password }); } if (!String.IsNullOrEmpty(user.FirstName)) { sql.Append(" a.FirstName = :nom2 and "); Parms.Add(new Object[] { "nom2", user.FirstName }); } if (!String.IsNullOrEmpty(user.LastName)) { sql.Append(" a.LastName = :nom3 and "); Parms.Add(new Object[] { "nom3", user.LastName }); } if (!String.IsNullOrEmpty(user.Phone)) { sql.Append(" a.Phone = :nom4 and "); Parms.Add(new Object[] { "nom4", user.Phone }); } if (!String.IsNullOrEmpty(user.Email)) { sql.Append(" a.Email = :nom5 and "); Parms.Add(new Object[] { "nom5", user.Email }); } if (user.IsSuperUser == true) { sql.Append(" a.IsSuperUser = :nom7 and "); Parms.Add(new Object[] { "nom7", true }); } else if (user.IsSuperUser == false) { sql.Append(" a.IsSuperUser = :nom8 and "); Parms.Add(new Object[] { "nom8", false }); } if (!String.IsNullOrEmpty(user.LastSession)) { sql.Append(" a.LastSession = :n4 and "); Parms.Add(new Object[] { "n4", user.LastSession }); } } sql = new StringBuilder(sql.ToString()); sql.Append("1=1 order by a.UserID asc "); IQuery query = Factory.Session.CreateQuery(sql.ToString()); SetParameters(query); return(query); }
public async Task <AccountValidationVM> LoginValidation(SysUser mo, string captcha, int remember) { var result = new AccountValidationVM(); var outMo = new SysUser(); //跳过验证码 if (captcha == "_pass_") { outMo = mo; } else { var capt = HttpContext.Session.GetString("captcha"); if (string.IsNullOrWhiteSpace(captcha) || (capt ?? "") != Core.CalcTo.MD5(captcha.ToLower())) { result.code = 104; result.message = "验证码错误或已过期"; return(result); } if (string.IsNullOrWhiteSpace(mo.SuName) || string.IsNullOrWhiteSpace(mo.SuPwd)) { result.code = 101; result.message = "用户名或密码不能为空"; return(result); } outMo = db.SysUser.Where(x => x.SuName == mo.SuName && x.SuPwd == Core.CalcTo.MD5(mo.SuPwd, 32)).FirstOrDefault(); } if (outMo == null || string.IsNullOrWhiteSpace(outMo.SuId)) { result.code = 102; result.message = "用户名或密码错误"; return(result); } if (outMo.SuStatus != 1) { result.code = 103; result.message = "用户已被禁止登录"; return(result); } try { #region 授权访问信息 //登录信息 var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme); identity.AddClaim(new Claim(ClaimTypes.PrimarySid, outMo.SuId)); identity.AddClaim(new Claim(ClaimTypes.Name, outMo.SuName)); identity.AddClaim(new Claim(ClaimTypes.GivenName, outMo.SuNickname ?? "")); identity.AddClaim(new Claim(ClaimTypes.Role, outMo.SrId)); //配置 var authParam = new AuthenticationProperties(); if (remember == 1) { authParam.IsPersistent = true; authParam.ExpiresUtc = DateTime.Now.AddDays(10); } //写入 await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(identity), authParam); result.code = 100; result.message = "登录成功"; result.url = "/"; return(result); #endregion } catch (Exception ex) { result.code = 105; result.message = "处理登录请求出错(" + ex.Message + ")"; return(result); } }
public SysUser Save(SysUser data) { return((SysUser)base.Save(data)); }
public FrmUserEdit(DBOperateType type, SysUser user) { InitializeComponent(); Type = type; User = user; }
public void Update(string PkSuid,string FpSBranchID,string SPwd,string SFullName,string SDepart,DateTime? TDateCreated,short? ISecurityLevel,string SDesc,string DelegateUser) { SysUser item = new SysUser(); item.MarkOld(); item.IsLoaded = true; item.PkSuid = PkSuid; item.FpSBranchID = FpSBranchID; item.SPwd = SPwd; item.SFullName = SFullName; item.SDepart = SDepart; item.TDateCreated = TDateCreated; item.ISecurityLevel = ISecurityLevel; item.SDesc = SDesc; item.DelegateUser = DelegateUser; item.Save(UserName); }
public Boolean Update(SysUser data) { return(base.Update(data)); }