public ActionResult RegisterUser() { var flag = false; try { var model = new UserInfoModel() { Account = Normal.ListStr(Request["Account"]), Password = Normal.CheckPoint(PwdUtil.MD5Encrypt(Request["Password"])), Email = Normal.ListStr(Request["Email"]), Name = Normal.ListStr(Request["Name"]), Sex = Normal.ListStr(Request["Sex"]), BirthDay = Normal.ListStr(Request["BirthDay"]), HomeTown = Normal.ListStr(Request["HomeTown"]), Marriage = Normal.ListStr(Request["Marriage"]), TheLatter = Normal.ListStr(Request["TheLatter"]), Position = Normal.ListStr(Request["Position"]), Company = Normal.ListStr(Request["Company"]), WorkingConditions = Normal.ParseInt(Request["WorkingConditions"]), InterestIn = Normal.ListStr(Request["InterestIn"]), QQ = Normal.ListStr(Request["QQ"]), IntroduceMyself = Normal.ListStr(Request["IntroduceMyself"]) }; var personService = new PersonService(); flag = personService.AddUserInfo(model); return flag ? Content("修改成功!") : Content("修改失败!"); } catch (Exception) { return Content("修改失败!"); } }
public ActionResult DoUpdateUserInfo() { var flag = false; try { var model = new UserInfoModel() { Email = Normal.ListStr(Request["Email"]), Name = Normal.ListStr(Request["Name"]), Sex = Normal.ListStr(Request["Sex"]), BirthDay = Normal.ListStr(Request["BirthDay"]), HomeTown = Normal.ListStr(Request["HomeTown"]), Marriage = Normal.ListStr(Request["Marriage"]), TheLatter = Normal.ListStr(Request["TheLatter"]), Position = Normal.ListStr(Request["Position"]), Company = Normal.ListStr(Request["Company"]), WorkingConditions = Normal.ParseInt(Request["WorkingConditions"]), InterestIn = Normal.ListStr(Request["InterestIn"]), QQ = Normal.ListStr(Request["QQ"]), IntroduceMyself = Normal.ListStr(Request["IntroduceMyself"]) }; var personService = new PersonService(); flag = personService.UpdateUserInfo(model); return flag ? Content("注册成功!") : Content("注册失败!"); } catch (Exception) { return Content("注册失败!"); } }
protected void btnSave_Click(object sender, EventArgs e) { string type = Request.QueryString["type"]; UserInfoModel user = new UserInfoModel { UserID = txtUserID.Value, UserName = txtName.Value, DeptID = Convert.ToInt32(ddlDept.SelectedValue), Cellphone = txtCellphone.Value, UserType = Convert.ToByte(ddlType.Value) }; UserInfoBLL bll = new UserInfoBLL(); try { if (type == "add") { bll.AppendUser(user); } else { if (txtPwd.Value != "") { user.Password = txtPwd.Value; } bll.EditUser(user); } ClientScript.RegisterStartupScript(this.GetType(), "optuser", "alert('保存成功!');parent.dialog.close();window.parent.location.reload();", true); } catch { ClientScript.RegisterStartupScript(this.GetType(), "optuser", "alert('保存失败!');", true); } }
public int AppendUser(UserInfoModel user) { string sql = "insert into UserInfo values(@UserID,@UserName,@DeptID,@Password,@Cellphone,@UserType)"; SqlParameter[] pars = { new SqlParameter("@UserID",user.UserID), new SqlParameter("@UserName",user.UserName), new SqlParameter("@DeptID",user.DeptID), new SqlParameter("@Password",MD5Maker.GetMD5("1")), new SqlParameter("@Cellphone",user.Cellphone), new SqlParameter("@UserType",user.UserType) }; return SqlHelper.ExecuteNonQuery(sql, pars); }
//添加用户 public bool AddUserInfo(UserInfoModel model) { string sql = string.Format(@"insert into UserInfo(Account,[Password],[Email],Name,Sex, TheLatter,HomeTown,Marriage,Position,Company,InterestIn,IntroduceMyself,QQ,WorkingConditions,BirthDay) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}', '{9}','{10}','{11}','{12}',{13},'{14}')", model.Account, model.Password, model.Email, model.Name, model.Sex, model.TheLatter, model.HomeTown, model.Marriage, model.Position, model.Company, model.InterestIn, model.IntroduceMyself, model.QQ, model.WorkingConditions, model.BirthDay); return SqlAccess.Execute(sql) > 0; }
public int EditPrivate(UserInfoModel user) { string sql = "update UserInfo set {0}Cellphone=@Cellphone where UserID=@UserID"; List<SqlParameter> list = new List<SqlParameter>(); list.Add(new SqlParameter("@UserID", user.UserID)); list.Add(new SqlParameter("@Cellphone", user.Cellphone)); if (user.Password != null) { sql = string.Format(sql, "Password=@Password,"); list.Add(new SqlParameter("@Password", user.Password)); } else sql = string.Format(sql, ""); return SqlHelper.ExecuteNonQuery(sql, list.ToArray()); }
protected void Button1_Click(object sender, EventArgs e) { UserStore<IdentityUser> userStore = new UserStore<IdentityUser>(); userStore.Context.Database.Connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["CANDZOILPDBConnectionString"].ConnectionString; UserManager<IdentityUser> manager = new UserManager<IdentityUser>(userStore); IdentityUser user = new IdentityUser(); user.UserName = txtUserName.Text; if (txtPassword.Text.Equals(txtConfirmPassword.Text)) { try { IdentityResult result = manager.Create(user, txtPassword.Text); if (result.Succeeded) { UserInformation info = new UserInformation { Address = txtAddress.Text, FirstName = txtFirstName.Text, LastName = txtLastName.Text, PostalCode = Convert.ToInt32(txtPostalCode.Text), GUID = user.Id }; UserInfoModel model = new UserInfoModel(); model.InsertUserInformation(info); var authenticationManager = HttpContext.Current.GetOwinContext().Authentication; var userIdentity = manager.CreateIdentity(user, DefaultAuthenticationTypes.ApplicationCookie); authenticationManager.SignIn(new AuthenticationProperties(), userIdentity); Response.Redirect("~/Index.aspx"); }else{ litStatusMessage.Text = result.Errors.FirstOrDefault(); } } catch (Exception er) { litStatusMessage.Text = er.ToString(); } } else { litStatusMessage.Text = "Passwords must match!"; } }
public int EditUser(UserInfoModel user) { string sql = "update UserInfo set UserName=@UserName,DeptID=@DeptID,{0}Cellphone=@Cellphone,UserType=@UserType where UserID=@UserID"; List<SqlParameter> list = new List<SqlParameter>(); list.Add(new SqlParameter("@UserID", user.UserID)); list.Add(new SqlParameter("@UserName", user.UserName)); list.Add(new SqlParameter("@DeptID", user.DeptID)); list.Add(new SqlParameter("@Cellphone", user.Cellphone)); list.Add(new SqlParameter("@UserType", user.UserType)); if (user.Password != null) { sql = string.Format(sql, "Password=@Password,"); list.Add(new SqlParameter("@Password", MD5Maker.GetMD5(user.Password))); } else sql = string.Format(sql, ""); return SqlHelper.ExecuteNonQuery(sql, list.ToArray()); }
public UserInfoModel GetUserById(string userID) { string sql = "select * from UserInfo where UserID=@UserID"; SqlParameter par = new SqlParameter("@UserID", userID); UserInfoModel user = new UserInfoModel(); using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, par)) { while (reader.Read()) { user.UserID = reader["UserID"] as string; user.UserName = reader["UserName"] as string; user.DeptID = (int)reader["DeptID"]; user.Password = reader["Password"] as string; user.Cellphone = reader["Cellphone"] as string; user.UserType = (byte)reader["UserType"]; } } return user; }
public static ObjectData saveCloud(MetaObject metaObj, UserInfoModel info) { ObjectData data = new ObjectData(metaObj); data.CreatedBy = userId; data.CreatedTime = DateTime.Now; data.ModifiedBy = userId; data.ModifiedTime = DateTime.Now; data["StdIsDeleted"] = false; data["SuiteKey"] = SystemInfo.SuiteKey; //配置文件 data["ISVTenantId"] = info.TenantId; data["UserId"] = info.UserId; data["UserType"] = info.Type; data["MappingUserId"] = info.OpenId; data["CorpId"] = info.AppId; data["Status"] = info.State;// 值需要对应一下,,值代表的含义不一致 data["StaffId"] = info.UserId; data["MappingType"] = "21"; data["AppId"] = SystemInfo.AppId; //配置文件 return(data); }
public void UserInfoLogon(string Name, string Key) { url += "/Login/Login"; UserInfoModel m = new UserInfoModel() { Uname = Name, Upwd = Key }; string s = JsonConvert.SerializeObject(m); string data = HttpClientHeper.Post(url, s); List <UserInfoModel> list = JsonConvert.DeserializeObject <List <UserInfoModel> >(data); if (list.Count > 0) { //Cooke事件 HttpCookie cookie = new HttpCookie("User"); //给Cooke赋值 cookie.Value = list.First().Uname; //给Cooke设置过期时间 cookie.Expires = DateTime.Now.AddMinutes(20); //添加到服务器 Response.AppendCookie(cookie); HttpCookie http = new HttpCookie("Cooke"); //Cooke传入并编码 http.Value = HttpUtility.UrlEncode(data, Encoding.GetEncoding("UTF-8")); http.Expires = DateTime.Now.AddMinutes(20); Response.AppendCookie(http); Session["ID"] = list.First().UIDa; int ids = Convert.ToInt32(Session["ID"]); Response.Write("<script>alert('登录成功!');location.href='/News/NewIndex'</script>"); } else { Response.Write("<script>alert('用户名错误,或密码错误!');location.href='/UserInfo/UserInfoLogon'</script>"); } }
private void _Init(int deck_id, int enemy_deck_id, BattleManager bManager, BattleResultFmt fmt, List <ShipModel_BattleAll> ships_f, List <ShipModel_BattleAll> ships_e, Dictionary <int, int> exp_rates_before) { UserInfoModel userInfo = bManager.UserInfo; DeckModel deck = userInfo.GetDeck(deck_id); _deck_name = deck.Name; _user_name = userInfo.Name; _fmt = fmt; _ships_f = ships_f.ConvertAll((ShipModel_BattleAll ship) => (ShipModel_BattleResult)ship); _ships_e = ships_e.ConvertAll((ShipModel_BattleAll ship) => (ShipModel_BattleResult)ship); _mvp_ship = _ships_f.Find((ShipModel_BattleResult ship) => ship != null && ship.TmpId == _fmt.MvpShip); for (int i = 0; i < Ships_f.Length; i++) { ShipModel_BattleResult shipModel_BattleResult = Ships_f[i]; if (shipModel_BattleResult != null) { _SetShipExp(deck, shipModel_BattleResult, exp_rates_before); _hp_start_f += shipModel_BattleResult.HpStart; _hp_end_f += shipModel_BattleResult.HpEnd; } } DeckModel deck2 = userInfo.GetDeck(enemy_deck_id); for (int j = 0; j < Ships_e.Length; j++) { ShipModel_BattleResult shipModel_BattleResult2 = Ships_e[j]; if (shipModel_BattleResult2 != null) { _SetShipExp(deck2, shipModel_BattleResult2, exp_rates_before); _hp_start_e += shipModel_BattleResult2.HpStart; _hp_end_e += shipModel_BattleResult2.HpEnd; } } _new_opened_map_ids = fmt.NewOpenMapId.GetRange(0, fmt.NewOpenMapId.Count); _new_opened_map_ids.AddRange(fmt.ReOpenMapId); _new_opened_area_ids = _new_opened_map_ids.FindAll((int map_id) => map_id % 10 == 1); _new_opened_area_ids = _new_opened_area_ids.ConvertAll((int map_id) => (int)Math.Floor((double)map_id / 10.0)); _first_area_clear = fmt.FirstAreaComplete; }
private async Task <IList <UserInfoModel> > MapUsersResultToModelAsync(IEnumerable <UserFullResult> userResults, IList <UserPhotoResult> userPhotos = null) { var users = new List <UserInfoModel>(); foreach (var userResult in userResults) { var user = new UserInfoModel() { Address = userResult.Address, BirthDate = userResult.BirthDate, CountryCode = userResult.CountryCode, CountryId = userResult.CountryId, CountryName = userResult.CountryName, Email = userResult.Email, CreatedDate = userResult.CreatedDate, Description = userResult.Description, DisplayName = userResult.DisplayName, Firstname = userResult.Firstname, GenderId = userResult.GenderId, GenderLabel = userResult.GenderLabel, Lastname = userResult.Lastname, PhoneNumber = userResult.PhoneNumber, StatusId = userResult.StatusId, StatusLabel = userResult.StatusLabel, UpdatedDate = userResult.UpdatedDate, UserIdentityId = await _userManager.EncryptUserIdAsync(userResult.Id) }; if (userPhotos != null && userPhotos.Any()) { var userAvatar = userPhotos.FirstOrDefault(x => x.UserId == userResult.Id); user.AvatarCode = userAvatar.Code; } users.Add(user); } return(users); }
public bool SaveNewUser(UserInfoModel user) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_SaveNewUser, conn); cmd.Parameters.AddWithValue("@firstName", user.FirstName); cmd.Parameters.AddWithValue("@lastName", user.LastName); cmd.Parameters.AddWithValue("@email", user.Email); cmd.Parameters.AddWithValue("@password", user.Password); int rowsAffectedOne = cmd.ExecuteNonQuery(); return(rowsAffectedOne > 0); } } catch (SqlException ex) { throw; } }
private void SetSessions() { try { UserInfoModel objUserInfoModel = new UserInfoModel(); Session["UserName"] = UserName.Text; Session["Role"] = objUserInfoModel.GetRole(UserName.Text); Session["UserManagement"] = objUserInfoModel.SetModuleUser(UserName.Text, "UserManagement"); Session["RoleManagement"] = objUserInfoModel.SetModuleUser(UserName.Text, "RoleManagement"); Session["GroupManagement"] = objUserInfoModel.SetModuleUser(UserName.Text, "GroupManagement"); Session["AddEditDeleteIncidents"] = objUserInfoModel.SetModuleUser(UserName.Text, "AddEditDeleteIncidents"); Session["AssignmentOfIncident"] = objUserInfoModel.SetModuleUser(UserName.Text, "AssignmentOfIncident"); Session["InputProposedDateAndTime"] = objUserInfoModel.SetModuleUser(UserName.Text, "InputProposedDateAndTime"); Session["UpdateIncidents"] = objUserInfoModel.SetModuleUser(UserName.Text, "UpdateIncidents"); Session["CancelIncidents"] = objUserInfoModel.SetModuleUser(UserName.Text, "CancelIncidents"); Session["ViewCharts"] = objUserInfoModel.SetModuleUser(UserName.Text, "ViewCharts"); } catch (Exception Ex) { } }
public IActionResult AddUser(UserInfoModel model) { if (!ModelState.IsValid) { return(View(model)); } var user = _mapper.Map <UserInfo>(model); var repoUser = _unitOfWork.GetRepository <UserInfo>(); //内存数据库无自增长 user.Id = repoUser.GetEntities().OrderByDescending(i => i.Id).FirstOrDefault().Id + 1; repoUser.Insert(user); var r = _unitOfWork.SaveChanges(); //_userInfoService.AddUserInfo(); return(Json(new MgResult() { Code = r > 0 ? 0 : 1, Msg = r > 0 ? "ok" : "SaveChanges失败!" })); }
protected void Page_Load(object sender, EventArgs e) { int ProductID = int.Parse(Request["ProductID"].ToString()); string ProductName = Request["ProductName"].ToString(); string ProductPic = Request["ProductPic"].ToString(); decimal ProductPrice = decimal.Parse(Request["ProductPrice"].ToString()); string ProductDesc = Request["ProductDesc"].ToString(); DateTime AddTime = DateTime.Parse(Request["AddTime"].ToString()); UserInfoModel m = new UserInfoModel(); m.ProductID = ProductID; m.ProductName = ProductName; m.ProductPic = ProductPic; m.ProductPrice = ProductPrice; m.ProductDesc = ProductDesc; m.AddTime = AddTime; string[] strArr = ProductListBLL.Update(m); Response.Write("{"); Response.Write("\"strChk\":" + strArr[0] + ","); Response.Write("\"strInfo\":\"" + strArr[1] + "\""); Response.Write("}"); }
public async Task UpdateInfoAsync(string userId, UserInfoModel model) { if (userId == null) { throw new ArgumentNullException(nameof(userId)); } if (model == null) { throw new ArgumentNullException(nameof(model)); } _log.LogInformation($"Update UserInfo: {userId}"); var user = await _db.Set <User>().FindAsync(userId); if (user == null) { return; } user.Email = model.Email; user.Mobile = model.Mobile; user.Name = model.Name; await _db.SaveChangesAsync(); }
/// <summary> /// 新增 /// </summary> /// <param name="user"></param> /// <returns></returns> public int Add(UserInfoModel user) { string sql = string.Format(@" insert into UserInfo( DevSN,PIN,UserName,Passwd,IDCard,Grp,TZ,Pri ) values ( @DevSN,@PIN,@UserName,@Passwd,@IDCard,@Grp,@TZ,@Pri );"); SQLiteParameter[] parameters = { new SQLiteParameter("@DevSN", user.DevSN), new SQLiteParameter("@PIN", user.PIN), new SQLiteParameter("@UserName", user.UserName), new SQLiteParameter("@Pri", user.Pri), new SQLiteParameter("@Passwd", user.Passwd), new SQLiteParameter("@IDCard", user.IDCard), new SQLiteParameter("@Grp", user.Grp), new SQLiteParameter("@TZ", user.TZ) }; return(SqliteHelper.ExecuteNonQuery(sql, parameters)); }
string GenerateJWTToken(UserInfoModel userInfo) { string s = this.configuration["Jwt:SecretKey"]; var securityKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(s)); var credentials = new SigningCredentials(securityKey, SecurityAlgorithms.HmacSha256); var claims = new[] { new Claim(JwtRegisteredClaimNames.Sub, userInfo.UserName), new Claim("username", userInfo.UserName.ToString()), new Claim("role", userInfo.UserRole), new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()), }; var token = new JwtSecurityToken( issuer: this.configuration["Jwt:Issuer"], audience: this.configuration["Jwt:Audience"], claims: claims, expires: DateTime.Now.AddMinutes(30), signingCredentials: credentials ); return(new JwtSecurityTokenHandler().WriteToken(token)); }
public ActionResult LogIn(string emailid, string password) { string userRole = ""; UserInfoModelLogic userLogic = new UserInfoModelLogic(); UserInfoModel userInfo = userLogic.getUser(emailid, password); if (userInfo != null) { Session["userInfo"] = userInfo; ConfigurationManager.AppSettings.Set("userRole", userInfo.UserRole); TempData["alert"] = new AlertBoxModel() { Type = "Success", Message = "User Login Successfully!" }; return(Redirect(userInfo.defaultUrl)); } TempData["alert"] = new AlertBoxModel() { Type = "Error", Message = "Email Id or Password is Wrong!" }; //if (Response.Cookies["User"] != null) //{ // HttpCookie userInfo = new HttpCookie("User"); // userRole = userInfo["userRole"].ToString(); // //userInfo["UserName"] = "******"; // //userInfo["UserColor"] = "Black"; // //userInfo.Expires.Add(new TimeSpan(0, 1, 0)); // //Response.Cookies.Add(userInfo); //} //else //{ // //@Html.Action("LogOut", "Authentication", new { @area = "User" }) //} return(View()); }
private string getAlertMessage(DeckModel deck) { UserInfoModel userInfo = StrategyTopTaskManager.GetLogicManager().UserInfo; MemberMaxInfo memberMaxInfo = userInfo.ShipCountData(); MemberMaxInfo memberMaxInfo2 = userInfo.SlotitemCountData(); if (deck.GetShips().Any((ShipModel x) => x.IsTaiha())) { AlertMessage.color = AlertColor; return("※大破している艦娘がいます。(被弾により喪失の危険があります)"); } if (memberMaxInfo.MaxCount <= memberMaxInfo.NowCount) { AlertMessage.color = AlertColor; return("※艦娘保有数が上限に達しているため、新しい艦娘との邂逅はできません。"); } if (memberMaxInfo.MaxCount - 6 <= memberMaxInfo.NowCount) { AlertMessage.color = WarningColor; return("※艦娘保有数が上限に近いため、新しい艦娘と邂逅できない可能性があります。"); } if (memberMaxInfo2.MaxCount <= memberMaxInfo2.NowCount) { AlertMessage.color = AlertColor; return("※装備保有数が上限に達しているため、新しい艦娘との邂逅はできません。"); } if (memberMaxInfo2.MaxCount - 24 <= memberMaxInfo2.NowCount) { AlertMessage.color = WarningColor; return("※装備保有数が上限に近いため、新しい艦娘と邂逅できない可能性があります。"); } if (deck.GetShips().Any((ShipModel x) => x.FuelRate < 100.0 || x.AmmoRate < 100.0)) { AlertMessage.color = WarningColor; return("※十分な補給を受けていない艦娘がいます。(本来の戦闘力を発揮できません)"); } return(string.Empty); }
public async Task <UserInfoModel> DetailsAsync(Guid userId) { var user = await userManager.FindByIdAsync(userId.ToString()); if (user == null) { throw new Exception("Нет такого пользователя"); } var matches = from u in userManager.Users join match in unitOfWork.Match.All() on u.Id equals match.UserId join word in unitOfWork.Word.All() on match.WordId equals word.Id where u.Id == userId group match by match.Result into grp select grp; var userInfoModel = new UserInfoModel { FullName = user.FullName }; foreach (var match in matches) { if (match.Key) { userInfoModel.CountOfWin = match.Count(); } else { userInfoModel.CountOfLose = match.Count(); } } await unitOfWork.SaveChangesAsync(); userInfoModel.GameCount = userInfoModel.CountOfWin + userInfoModel.CountOfLose; return(userInfoModel); }
public async Task <UserInfoModel> UserInfo(string?userId = null) { var signedIn = signInManager.IsSignedIn(User); var userInfoRet = new UserInfoModel { SignedIn = string.IsNullOrEmpty(userId) && signedIn }; if (string.IsNullOrEmpty(userId)) { userId = userManager.GetUserId(User); } var user = await userManager.FindByIdAsync(userId); var currentUser = string.IsNullOrEmpty(userId) ? user : await userManager.GetUserAsync(User); if (userId == null || user == null) { return(new UserInfoModel()); } userInfoRet.UserId = user.Id; userInfoRet.UserName = user.UserName; userInfoRet.Privilege = user.Privilege; userInfoRet.Coins = user.Coins; userInfoRet.Experience = user.Experience; userInfoRet.OtherInfo = IdentityHelper.GetOtherUserInfo(string.IsNullOrEmpty(user.OtherInfo) ? "{}" : user.OtherInfo); if (userInfoRet.SignedIn || PrivilegeHelper.IsTeacher(currentUser?.Privilege)) { userInfoRet.Name = user.Name; userInfoRet.EmailConfirmed = user.EmailConfirmed; userInfoRet.PhoneNumberConfirmed = user.PhoneNumberConfirmed; userInfoRet.Email = user.Email; userInfoRet.PhoneNumber = user.PhoneNumber; } return(userInfoRet); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="uid">ID</param> /// <returns>用户模型实例 获取不到返回null</returns> public static UserInfoModel getUserInfo(String uid) { if (!exist(uid)) { return(null); } Object[] parameter = getParameterList(new SqlParameter[] { new SqlParameter("@uid", uid) }); ArrayList arr = SQLUtil.rawQuery("Select * From UserInfo Where Uid = @uid", parameter); if (arr.Count > 0) { Hashtable table = (Hashtable)arr[0]; //密码 String pwd = table["Pwd"].ToString().Trim(); //注册时间 String regtime = table["RegTime"].ToString().Trim(); //别名 String alias = table["Alias"].ToString().Trim(); //Token String token = table["Token"].ToString().Trim(); //Token注册时间 String generatestr = table["TokenGenerateTime"].ToString().Trim(); //生日 String birthday = table["BirthDay"].ToString().Trim(); //头像ID String faceid = table["FaceID"].ToString().Trim(); //性别 String sexstr = table["Sex"].ToString().Trim(); bool sex = Convert.ToBoolean(sexstr == "" ? "True" : sexstr); //UserInfo对象 UserInfoModel user = new UserInfoModel(uid.Trim(), pwd.Trim(), regtime.Trim(), alias.Trim(), faceid.Trim(), token.Trim(), generatestr.Trim(), birthday.Trim(), sex); return(user); } else { return(null); } }
public JsonResult DoUpdateUserInfoStatus() { string message = "操作失败,请与管理员联系"; string userId = GetFormData("userId"); string roleType = GetFormData("roleId"); string workType = GetFormData("workType"); string statusType = GetFormData("statusType"); List <string> userIdList = userId.Split(',').ToList(); if (userIdList == null && userIdList.Count == 0) { return(FailedJson(message)); } else { UserInfoModel model = new UserInfoModel(); if (roleType == "roseId") { model.RoleId = GetFormData("rolseid"); } if (workType == "work") { model.WorkStatus = GetFormData("work_status"); } if (statusType == "status") { model.Status = Convert.ToInt32(GetFormData("status")); } foreach (string userInfoId in userIdList) { model.UserId = userInfoId; UserInfoService.Instance.UpdateUserInfoStatus(model, out message); } } return(SuccessedJson(message, "UserMgr_UserList", "UserMgr_UserList", "closeCurrent", "/UserMgr/UserList")); }
public HttpResponseMessage Login(string username, string password) { if (User.Identity.IsAuthenticated) { return(new HttpResponseMessage() { Content = new StringContent("authenticated") }); } else { IUserRepository repository = new UserRepository(new eyeDropsDbDataContext()); LoginModel model = new LoginModel(); model.Username = username; model.Password = password; HttpResponseMessage res = new HttpResponseMessage(); UserInfoModel lin = repository.login(model); if (lin.userData.UserId > 0) { FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, model.Username, DateTime.Now, DateTime.Now.AddDays(30), true, null, FormsAuthentication.FormsCookiePath); // Encrypt the ticket. FormsAuthentication.SetAuthCookie(model.Username, model.RememberMe); return(Request.CreateResponse(HttpStatusCode.OK, "loggedin")); } else { return(Request.CreateResponse(HttpStatusCode.OK, "failedlogin")); } } }
//PROCEDURE FOR PICKING HOME PAGE OF DIFFERENT USERS: USED FOR PROFILE BUTTON IN NAVBAR public ActionResult PickProfile() { UserInfoModel u = new UserInfoModel(); if (TempData["currentSession"] != null) { u = TempData["currentSession"] as UserInfoModel; } string email = u.Email; //OBTAINING USER'S STATUS var user = new DataTable(); using (var sqlCon = new SqlConnection(connectString)) { sqlCon.Open(); var query = "Select * from UserDetails where Email='" + email + "';"; var sqlDa = new SqlDataAdapter(query, sqlCon); sqlDa.Fill(user); } byte bloggerStat = (byte)user.Rows[0][4]; //FOR NORMAL USER if (bloggerStat == 0) { return(RedirectToAction("Index", "User", new { email = email })); } //USER APPLIED TO BE BLOGGER else if (bloggerStat == 1) { return(RedirectToAction("Index1", "User", new { email = email })); } //BLOGGER else { return(RedirectToAction("Index", "Blogger", new { email = email })); } }
public ActionResult Register(UserInfoModel model) { if (model.UserName.Trim().Contains(" ")) { ModelState.AddModelError("UserName", "帐号中间不可以有空格."); } if (ModelState.IsValid) { // Attempt to register the user MembershipCreateStatus createStatus; Membership.CreateUser(model.UserName.Trim(), model.Password.Trim(), model.Email.Trim(), null, null, true, null, out createStatus); if (createStatus == MembershipCreateStatus.Success) { ProfileBase objProfile = ProfileBase.Create(model.UserName.Trim()); objProfile.SetPropertyValue("RoleLevelID", 0); objProfile.SetPropertyValue("IsActivated", false); //FormsAuthentication.SetAuthCookie(model.UserName, false /* createPersistentCookie */); var emprole = new EmployeeRole() { AccountName = model.UserName, Email = model.Email }; CH.Create <EmployeeRole>(emprole); return(RedirectToAction("Index", "Account")); } else { ModelState.AddModelError("", ErrorCodeToString(createStatus)); } } // If we got this far, something failed, redisplay form return(View(model)); }
public JsonResult Manage(MGroupUserMenuModel item) { UserInfoModel userInfo = (UserInfoModel)GeneralFunctions.GetSession(Configs.session); ResultStatusModel result = new ResultStatusModel(); item.UserCreated = userInfo.UserName; item.UserModified = userInfo.UserName; if (ModelState.IsValid) { try { string id_out = ""; if (item.GroupUserMenuID == 0) { result = uow.GroupUserMenuRepository.CUD_GroupUserMenu(item, "c", out id_out); } else { result = uow.GroupUserMenuRepository.CUD_GroupUserMenu(item, "u", out id_out); } if (!result.issuccess) { ModelState.AddModelError("Failed", result.err_msg); } } catch (Exception e) { ModelState.AddModelError("Failed", e.Message); } } List <string> Error = (from m in ModelState where m.Value.Errors.Any() select m.Value.Errors[0].ErrorMessage).ToList(); return(Json(new { Error = Error, data = item }, JsonRequestBehavior.DenyGet)); }
/// <summary> /// 修改多用户状态 /// </summary> /// <param name="type"></param> private void UpdateUsersState(int type) { string actMsg = type == 1 ? "启用" : "停用"; if (dgvUsers.SelectedRows.Count == 0) { MsgBoxHelper.MsgErrorShow($"请选择要{actMsg}的用户!"); return; } if (MsgBoxHelper.MsgBoxConfirm($"用户{actMsg}", $"您确定要{actMsg}这些选择的用户吗?") == DialogResult.Yes) { List <int> userIds = new List <int>(); foreach (DataGridViewRow row in dgvUsers.SelectedRows) { UserInfoModel userInfo = row.DataBoundItem as UserInfoModel; userIds.Add(userInfo.UserId); } bool bl = false; if (type == 1) { bl = RequestStar.EnableUsers(userIds); } else { bl = RequestStar.StopUsers(userIds); } if (bl) { MsgBoxHelper.MsgBoxShow($"用户{actMsg}", $"该用户{actMsg}成功!"); LoadUserList(); } else { MsgBoxHelper.MsgErrorShow($"该用户{actMsg}失败!"); return; } } }
/// <summary> /// This method will remove (delete) the user, if exists. /// </summary> /// <param name="s">User information</param> /// <param name="login">Login information to Active Directory.</param> /// <returns>Deleted user's email address.</returns> public BaseResponse <string> RemoveUser(UserInfoModel s) { ADResponseType rt; string rResult = string.Empty; string rMessage = string.Empty; Exception rException = null; ADLoginModel login = GetAdminActiveDirectoryLogin(); try { PrincipalContext pc = new PrincipalContext(ContextType.Domain, login.Domain, login.Username, login.Password); UserPrincipal user = UserPrincipal.FindByIdentity(pc, s.DomainEmailAddress); if (user != null) { user.Delete(); rt = ADResponseType.OK; rResult = s.DomainEmailAddress; } else { rMessage = "User does not exist."; rt = ADResponseType.Undefined; } } catch (System.DirectoryServices.ActiveDirectory.ActiveDirectoryOperationException E) { rMessage = "Unable to perform operation."; rt = ADResponseType.Exception; rException = E; } catch (System.DirectoryServices.ActiveDirectory.ActiveDirectoryObjectNotFoundException E) { rMessage = "User was not found."; rt = ADResponseType.Exception; rException = E; } return(new BaseResponse <string>(rResult, rt, rMessage, rException)); }
protected void Page_Load(object sender, EventArgs e) { if (Session["uid"] == null) { Response.Redirect("/login.aspx"); } int userid = 0; try { userid = (int)Session["uid"]; UserOnThisPage = UserInfoBLL.GetUserInfoByID(userid); txtUserName.Text = UserOnThisPage.username + "的个人中心"; txtRegDate.Text = UserOnThisPage.reg_date.ToShortDateString(); txtMail.Text = UserOnThisPage.mail; txtLatestDate.Text = "昨天"; if (!IsPostBack) { ReloadInfo(); } List <AddressModel> addresses = AddressBLL.GetAddressesByUserID(userid); foreach (AddressModel address in addresses) { AddressRow row = (AddressRow)LoadControl("~/Controls/AddressRow.ascx"); row.SetAddress(address); row.Click += Row_Click; addresscontent.Controls.Add(row); } txtAddressNum.Text = AddressBLL.GetAddressNumByUserID(UserOnThisPage.id).ToString(); } catch (Exception err) { string x = err.Message; Response.Redirect("/index.aspx"); } }
public BothWayBindViewModel() { UserInfo = new UserInfoModel(); CombboxList = new List <ComplexInfoModel>() { new ComplexInfoModel() { Key = "0", Text = "西瓜" }, new ComplexInfoModel() { Key = "1", Text = "草莓" }, new ComplexInfoModel() { Key = "2", Text = "香梨" }, }; RadioButtons = new List <RadioChoose>() { new RadioChoose() { Content = "天空", IsCheck = false }, new RadioChoose() { Content = "海洋", IsCheck = false }, new RadioChoose() { Content = "大地", IsCheck = false }, new RadioChoose() { Content = "宇宙", IsCheck = true }, }; }
private void SetAllShipsLevel(int LV) { if (LV == 0) { return; } UserInfo = StrategyTopTaskManager.GetLogicManager().UserInfo; Dictionary <int, int> dictionary = Mst_DataManager.Instance.Get_MstLevel(shipTable: true); int num = 1; while (true) { int num2 = num; MemberMaxInfo memberMaxInfo = UserInfo.ShipCountData(); if (num2 < memberMaxInfo.NowCount + 1) { UserInfo.GetShip(num).AddExp(dictionary[LV] - UserInfo.GetShip(num).Exp); num++; continue; } break; } }
//查询 public List <UserInfoModel> Search(UserInfoModel m) { string sql = "select * from UserInfo where 1=1 "; if (!string.IsNullOrEmpty(m.UserName)) { sql += $" and UserName = @UserName "; } if (m.Department != 0) { sql += $" and Department = @Department "; } if (m.role != 0) { sql += $" and role = @role "; } if (!string.IsNullOrEmpty(m.UserNumber)) { sql += $" and UserNumber = @UserNumber "; } return(dal.Search <UserInfoModel, UserInfoModel>(sql, m)); }
public ApiResult <List <UserInfoModel> > QueryAllUser(string groupId) { var list = new List <UserInfoModel>(); var data = _userGroupService.QueryAllUser(groupId.ToGuid()); if (data != null) { foreach (var item in data) { var entity = new UserInfoModel(); entity.ImUserId = item.ImUserId; entity.ImUserName = item.ImUserName; entity.UserHeadimg = item.UserHeadimg; entity.UserId = item.UserId; entity.UserType = item.UserType; entity.Remark = item.Remark; entity.Online = (CacheManager.RedisChat.Get(item.ImUserId.ToString().ToLower().AddCachePrefix("Online")).IsNullOrEmpty() ? 0 : 1); list.Add(entity); } } return(Success(list)); }
protected string CreateDirPath(string parentDir, string subDir = null, bool hasUserDir = true) { UserInfoModel m = (UserInfoModel)Session[SessionVar.SHARED_USER_INFO]; var userid = ""; if (hasUserDir) { userid = m.ユーザーID; } var dir = HttpContext.Server.MapPath(ConfigurationManager.AppSettings[parentDir]); if (hasUserDir) { dir += "\\" + userid; } if (subDir != null) { dir += "\\" + subDir; } return(dir); }
/// <summary> /// 获取登录信息 /// </summary> /// <returns></returns> public static UserInfoModel GetSession() { UserInfoModel userInfo = null; string user = string.Empty; if (HttpContext.Current != null) { if (HttpContext.Current.Request.Cookies[SessionName] != null) { user = HttpContext.Current.Request.Cookies[SessionName].Value.DBColToString(); } else { user = HttpContext.Current.Session[SessionName].DBColToString(); } if (!string.IsNullOrEmpty(user)) { user = user.Contains("[Encrypt]") ? DesCodeHelper.DecryptDes(user.Substring(9, user.Length - 9)) : user; userInfo = JsonConvert.DeserializeObject <UserInfoModel>(user); } } return(userInfo); }
protected void btnRegister_Click(object sender, EventArgs e) { // Default UserStore constructor uses the default connection string named: DefaultConnection var userStore = new UserStore<IdentityUser>(); //Set ConnectionString to GarageConnectionString userStore.Context.Database.Connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["GarageDBConnectionString"].ConnectionString; var manager = new UserManager<IdentityUser>(userStore); //Create new user and try to store in DB. var user = new IdentityUser { UserName = txtUserName.Text }; if (txtPassword.Text == txtConfirmPassword.Text) { try { //Create user object //Database will be created / expanded automatically IdentityResult result = manager.Create(user, txtPassword.Text); if (result.Succeeded) { UserInformation info = new UserInformation() { Address = txtAddress.Text, FirstName = txtFirstName.Text, LastName = txtLastName.Text, PostalCode = Convert.ToInt32(txtPostalCode.Text), //retreive the dynamically generateed key from the current logged in user GUID = user.Id }; //send the user information object to the database UserInfoModel model = new UserInfoModel(); model.InsertUserDetail(info); //Store user in DB var authenticationManager = HttpContext.Current.GetOwinContext().Authentication; //set to login new user by Cookie var userIdentity = manager.CreateIdentity(user, DefaultAuthenticationTypes.ApplicationCookie); //If succeedeed, log in the new user and set a cookie and redirect to homepage authenticationManager.SignIn(new AuthenticationProperties(), userIdentity); Response.Redirect("~/Index.aspx"); } else { litStatusMessage.Text = result.Errors.FirstOrDefault(); } } catch (Exception ex) { litStatusMessage.Text = ex.ToString(); } } else { litStatusMessage.Text = "Passwords must match!"; } }
//通过主键ID得到用户信息 public UserInfoModel GetUserInfo(int id) { string sql = string.Format("select * from UserInfo where id={0}", id); DataTable dt = new DataTable(); SqlAccess.QueryDt(dt, sql); var model = new UserInfoModel() { ID = id, Name = Normal.ListStr(dt.Rows[0]["Name"]), Account = Normal.ListStr(dt.Rows[0]["Account"]), BirthDay = Normal.ParseDateTime(dt.Rows[0]["BirthDay"]).ToString("yyyy年MM月dd日"), Sex = Normal.ListStr(dt.Rows[0]["Sex"]), Company = Normal.ListStr(dt.Rows[0]["Company"]), HomeTown = Normal.ListStr(dt.Rows[0]["HomeTown"]), TheLatter = Normal.ListStr(dt.Rows[0]["TheLatter"]), InterestIn = Normal.ListStr(dt.Rows[0]["InterestIn"]), IntroduceMyself = Normal.ListStr(dt.Rows[0]["IntroduceMyself"]), Marriage = Normal.ListStr(dt.Rows[0]["Marriage"]), Position = Normal.ListStr(dt.Rows[0]["Position"]), Email = Normal.ListStr(dt.Rows[0]["Email"]), QQ = Normal.ListStr(dt.Rows[0]["QQ"]), WorkingConditions = Normal.ParseInt(dt.Rows[0]["WorkingConditions"]), EntryDate = Normal.ListStr(dt.Rows[0]["EntryDate"]) }; return model; }
public void ProcessRequest(HttpContext context) { if (context.Request.QueryString["type"] != null) { if (context.Request.QueryString["type"] == "bind") { #region 绑定用户列表 if (context.Request.QueryString["opera"] == "users") { Dictionary<string, string> userDic = new Dictionary<string, string>(); if (context.Request.QueryString["userID"] != null) { userDic["userID"] = context.Request.QueryString["userID"]; } if (context.Request.QueryString["userName"] != null) { userDic["userName"] = context.Request.QueryString["userName"]; } if (context.Request.QueryString["deptID"] != null) { userDic["deptID"] = context.Request.QueryString["deptID"]; } int pageCurrent = Convert.ToInt32(context.Request.QueryString["pageCurrent"]); string order = string.IsNullOrEmpty(context.Request.QueryString["orderField"]) ? "UserID" : context.Request.QueryString["orderField"]; int rowCount; UserInfoBLL bll = new UserInfoBLL(); DataTable dt = bll.GetUserList(userDic, pageCurrent, order, out rowCount); StringBuilder sb = new StringBuilder(); List<string> list = new List<string>(); list.Add("<tr><th scope='col'>序号</th><th scope='col'><input id='chkAll' type='checkbox' onclick='selectAll();' /></th><th scope='col'><a href='javascript:void(0);' onclick='order(\"UserID\");'>用户ID</a></th><th scope='col'><a href='javascript:void(0);' onclick='order(\"UserName\");'>用户姓名</a></th><th scope='col'><a href='javascript:void(0);' onclick='order(\"DeptID\");'>所属部门</a></th><th scope='col'> </th></tr>"); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append("<tr>"); sb.AppendFormat("<td style='width: 10%;'><span>{0}</span></td>", dt.Rows[i][0]); sb.AppendFormat("<td style='width: 10%;'><input type='checkbox' value='{0}' /></td>", dt.Rows[i]["UserID"]); sb.AppendFormat("<td style='width: 15%;'>{0}</td>", dt.Rows[i]["UserID"]); sb.AppendFormat("<td style='width: 20%;'>{0}</td>", dt.Rows[i]["UserName"]); sb.AppendFormat("<td style='width: 15%;'>{0}</td>", dt.Rows[i]["DeptName"]); sb.AppendFormat("<td style='width: 10%;'><img alt='编辑' title='编辑' src='/Image/common/edit.png' class='imgBtn' onclick='editUser(\"{0}\");' /></td>", dt.Rows[i]["UserID"]); sb.Append("</tr>"); } if (string.IsNullOrEmpty(sb.ToString())) { list.Clear(); list.Add("<td colspan='6' style='text-align:center;line-height:26px;'>没有数据</td>"); } else { list.Add(sb.ToString()); } list.Add("☭" + rowCount); context.Response.Write(string.Concat(list)); } #endregion #region 绑定部门列表 else if (context.Request.QueryString["opera"] == "depart") { DepartmentModel dept = new DepartmentModel(); if (context.Request.QueryString["deptName"] != null) { dept.DeptName = context.Request.QueryString["deptName"]; } if (context.Request.QueryString["manager"] != null) { dept.ManagerID = context.Request.QueryString["manager"]; } int pageCurrent = Convert.ToInt32(context.Request.QueryString["pageCurrent"]); int rowCount; DepartmentBLL bll = new DepartmentBLL(); DataTable dt = bll.GetDepartList(dept, pageCurrent, out rowCount); StringBuilder sb = new StringBuilder(); List<string> list = new List<string>(); list.Add("<tr><th scope='col'>序号</th><th scope='col'>部门名称</th><th scope='col'>主管</th><th scope='col'> </th></tr>"); for (int i = 0; i < dt.Rows.Count; i++) { string DeptID = dt.Rows[i]["DeptID"].ToString(); sb.Append("<tr>"); sb.AppendFormat("<td style='width: 10%;'><span>{0}</span></td>", dt.Rows[i][0]); sb.AppendFormat("<td style='width: 30%;'>{0}</td>", dt.Rows[i]["DeptName"]); sb.AppendFormat("<td style='width: 20%;'>{0}</td>", dt.Rows[i]["UserName"]); // 如果部门下没有员工即可删除 if (bll.IsEmptyDepart(DeptID)) sb.AppendFormat("<td style='width: 20%;'><img alt='编辑' title='编辑' src='/Image/common/edit.png' class='imgBtn' onclick='editDept(\"{0}\");' /> <input type='image' id='btnDelete' title='删除' class='imgBtn' src='/Image/common/delete.png' onclick='return deleteDept(\"{1}\");' style='border-width:0px;'></td>", DeptID, DeptID); else sb.AppendFormat("<td style='width: 20%;'><img alt='编辑' title='编辑' src='/Image/common/edit.png' class='imgBtn' onclick='editDept(\"{0}\");' /></td>", DeptID); sb.Append("</tr>"); } if (string.IsNullOrEmpty(sb.ToString())) { list.Clear(); list.Add("<td colspan='4' style='text-align:center;line-height:26px;'>没有数据</td>"); } else { list.Add(sb.ToString()); } list.Add("☭" + rowCount); context.Response.Write(string.Concat(list)); } #endregion #region 显示考勤列表 else if (context.Request.QueryString["opera"] == "setting") { int year = Convert.ToInt32(context.Request.QueryString["year"]); int month = Convert.ToInt32(context.Request.QueryString["month"]); int days = DateTime.DaysInMonth(year, month);// 获取当前月份的天数 StringBuilder sb = new StringBuilder(); sb.Append("<tr><th scope='col'>日期</th><th scope='col'>星期</th><th scope='col'>状态</th></tr>"); //string[] chsWeek = { "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" }; AttendanceSettingBLL bll = new AttendanceSettingBLL(); DataTable dt = bll.GetAttendanceSetting(); for (int i = 1; i <= days; i++) { sb.Append("<tr>"); DateTime time = Convert.ToDateTime(year + "-" + month + "-" + i); string date = time.ToString("yyyy-MM-dd"); sb.AppendFormat("<td style='width:30%;'>{0}</td>", date); // 判断当前日期是星期几 //string week = chsWeek[Convert.ToInt32(time.DayOfWeek)]; string week = time.ToString("dddd"); sb.AppendFormat("<td style='width:30%;'>{0}</td>", week); // 获取当前的考勤设置 DataRow[] rows = dt.Select("Date = '" + date + "'"); if (rows.Length > 0) { if (rows[0]["Status"].ToString().Equals("1")) { sb.AppendFormat("<td style='width:20%;'><select id='ddlStatus' date='{0}'><option value='0' style='color:Black;'>默认</option><option selected='selected' value='1' style='color:Green;'>上班</option><option value='2' style='color:Red;'>休假</option></select></td>", date); } else { sb.AppendFormat("<td style='width:20%;'><select id='ddlStatus' date='{0}'><option value='0' style='color:Black;'>默认</option><option value='1' style='color:Green;'>上班</option><option selected='selected' value='2' style='color:Red;'>休假</option></select></td>", date); } } else { sb.AppendFormat("<td style='width:20%;'><select id='ddlStatus' date='{0}'><option selected='selected' value='0' style='color:Black;'>默认</option><option value='1' style='color:Green;'>上班</option><option value='2' style='color:Red;'>休假</option></select></td>", date); } sb.Append("</tr>"); } context.Response.Write(sb.ToString()); } #endregion #region 显示部门员工 else if (context.Request.QueryString["opera"] == "deptuser") { if (context.Session["user"] == null) { context.Response.Write("<script>top.location='/View/Default.aspx'</script>"); context.Response.End(); } string userID = ((UserInfoModel)context.Session["user"]).UserID; int pageCurrent = Convert.ToInt32(context.Request.QueryString["pageCurrent"]); string order = string.IsNullOrEmpty(context.Request.QueryString["orderField"]) ? "UserID" : context.Request.QueryString["orderField"]; int rowCount; AttendanceInfoBLL bll = new AttendanceInfoBLL(); DataTable dt = bll.GetDeptUser(userID, pageCurrent, order, out rowCount); StringBuilder sb = new StringBuilder(); List<string> list = new List<string>(); list.Add("<tr><th scope='col'>序号</th><th scope='col'><a href='javascript:void(0);' onclick='order(\"UserID\");'>用户ID</a></th><th scope='col'><a href='javascript:void(0);' onclick='order(\"UserName\");'>用户名</a></th><th scope='col'><a href='javascript:void(0);' onclick='order(\"DeptName\");'>部门</a></th><th scope='col'>考勤信息</th></tr>"); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append("<tr>"); sb.AppendFormat("<td style='width: 10%;'><span>{0}</span></td>", dt.Rows[i][0]); sb.AppendFormat("<td style='width: 20%;'>{0}</td>", dt.Rows[i]["UserID"]); sb.AppendFormat("<td style='width: 20%;'>{0}</td>", dt.Rows[i]["UserName"]); sb.AppendFormat("<td style='width: 20%;'>{0}</td>", dt.Rows[i]["DeptName"]); sb.AppendFormat("<td style='width: 10%;'><a href='javascript:showAttendance(\"{0}\");'>查看</a></td>", dt.Rows[i]["UserID"]); sb.Append("</tr>"); } if (string.IsNullOrEmpty(sb.ToString())) { list.Clear(); list.Add("<td colspan='5' style='text-align:center;line-height:26px;'>没有数据</td>"); } else { list.Add(sb.ToString()); } list.Add("☭" + rowCount); context.Response.Write(string.Concat(list)); } #endregion #region 显示请假列表 else if (context.Request.QueryString["opera"] == "leave") { if (context.Session["user"] == null) { context.Response.Write("<script>top.location='/View/Default.aspx'</script>"); context.Response.End(); } string userID = ((UserInfoModel)context.Session["user"]).UserID; string title = null, beginDate = null, endDate = null, statu = null, name = null; if (context.Request.QueryString["title"] != null) { title = context.Request.QueryString["title"]; } if (context.Request.QueryString["begin"] != null) { beginDate = context.Request.QueryString["begin"]; } if (context.Request.QueryString["end"] != null) { endDate = context.Request.QueryString["end"]; } if (context.Request.QueryString["statu"] != null) { statu = context.Request.QueryString["statu"]; } if (context.Request.QueryString["name"] != null) { name = context.Request.QueryString["name"]; } int pageCurrent = Convert.ToInt32(context.Request.QueryString["pageCurrent"]); string order = string.IsNullOrEmpty(context.Request.QueryString["orderField"]) ? "UserName" : context.Request.QueryString["orderField"]; int rowCount; ApproveBLL bll = new ApproveBLL(); DataTable dt = bll.GetLeave(userID, title, beginDate, endDate, statu, name, pageCurrent, order, out rowCount); StringBuilder sb = new StringBuilder(); List<string> list = new List<string>(); list.Add("<tr><th scope='col'>请假单ID</th><th scope='col'><a href='javascript:void(0);' onclick='order(\"UserName\");'>申请人</a></th><th scope='col'>标题</th><th scope='col'><a href='javascript:void(0);' onclick='order(\"BeginDate\");'>起始时间</a></th><th scope='col'><a href='javascript:void(0);' onclick='order(\"EndDate\");'>结束时间</a></th><th scope='col'><a href='javascript:void(0);' onclick='order(\"ApplyDate\");'>申请时间</a></th><th scope='col'>请假单状态</th><th scope='col'> </th></tr>"); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append("<tr>"); sb.AppendFormat("<td style='width:8%;'>{0}</td>", dt.Rows[i]["ApproveID"]); sb.AppendFormat("<td style='width:10%;'>{0}</td>", dt.Rows[i]["UserName"]); sb.AppendFormat("<td style='width:15%;'>{0}</td>", dt.Rows[i]["Title"]); sb.AppendFormat("<td style='width:10%;'>{0}</td>", dt.Rows[i]["BeginDate"]); sb.AppendFormat("<td style='width:10%;'>{0}</td>", dt.Rows[i]["EndDate"]); sb.AppendFormat("<td style='width:10%;'>{0}</td>", dt.Rows[i]["ApplyDate"]); string status = dt.Rows[i]["Status"].ToString(); sb.AppendFormat("<td style='width:7%;'><span id='lblStatus'>{0}</span></td>", status == "0" ? "待审批" : "归档"); string opt = HttpUtility.UrlDecode(context.Request.QueryString["opt"], Encoding.UTF8); if (opt == "请假审批") { string type = status == "0" ? "apprv(\"{0}\")" : "show(\"{0}\")"; sb.AppendFormat("<td style='width:10%;'><a href='javascript:{0};'>查看</a></td>", string.Format(type, dt.Rows[i]["ApproveID"])); } else { if (status == "0") { sb.AppendFormat("<td style='width:10%;'><img alt='编辑' title='编辑' src='/Image/common/edit.png' class='imgBtn' onclick='editLeave(\"{0}\");'><input type='image' id='btnDelete' title='删除' class='imgBtn' src='/Image/common/delete.png' onclick='return deleteApp(\"{1}\");' style='border-width:0px;'></td>'", dt.Rows[i]["ApproveID"], dt.Rows[i]["ApproveID"]); } else { sb.AppendFormat("<td style='width:10%;'><a href='javascript:show(\"{0}\");'>查看</a></td>", dt.Rows[i]["ApproveID"]); } } sb.Append("</tr>"); } if (string.IsNullOrEmpty(sb.ToString())) { list.Clear(); list.Add("<td colspan='4' style='text-align:center;line-height:26px;'>没有数据</td>"); } else { list.Add(sb.ToString()); } list.Add("☭" + rowCount); context.Response.Write(string.Concat(list)); } #endregion #region 列表显示员工考勤 else if (context.Request.QueryString["opera"] == "userattc") { string userID = string.Empty; if (!string.IsNullOrEmpty(context.Request.QueryString["userID"])) { userID = context.Request.QueryString["userID"]; } else if (context.Session["user"] != null) { userID = ((UserInfoModel)context.Session["user"]).UserID; } else { context.Response.Write("<script>top.location='/View/Default.aspx'</script>"); context.Response.End(); } int year = Convert.ToInt32(context.Request.QueryString["year"]); int month = Convert.ToInt32(context.Request.QueryString["month"]); int days = DateTime.DaysInMonth(year, month); // 获取当前月份的天数 StringBuilder sb = new StringBuilder(); sb.Append("<table class='grid' cellspacing='0' rules='all' border='1' style='border-collapse: collapse;'>"); sb.Append("<tr><th scope='col'>日期</th><th scope='col'>星期</th><th scope='col'>首次打卡时间</th><th scope='col'>最后打卡时间</th><th scope='col'>考勤状态</th></tr>"); string[] chsWeek = { "周日", "周一", "周二", "周三", "周四", "周五", "周六" }; AttendanceInfoBLL bll = new AttendanceInfoBLL(); DataTable dt = bll.GetAskForLeaveTime(userID); for (int i = 1; i <= days; i++) { sb.Append("<tr>"); DateTime time = Convert.ToDateTime(year + "-" + month + "-" + i); string date = time.ToString("yyyy-MM-dd"); sb.AppendFormat("<td style='width:12%;'>{0}</td>", date); // 判断当前日期是周几 string week = chsWeek[Convert.ToInt32(time.DayOfWeek)]; sb.AppendFormat("<td style='width:8%;'>{0}</td>", week); // 获取当天的打卡时间 string min = bll.GetMinFaceTime(userID, date).ToString(); sb.AppendFormat("<td style='width:20%;'>{0}</td>", min); string max = bll.GetMaxFaceTime(userID, date).ToString(); sb.AppendFormat("<td style='width:20%;'>{0}</td>", max); DateTime? minTime = null; if (!string.IsNullOrEmpty(min)) { minTime = Convert.ToDateTime(min); } DateTime? maxTime = null; if (!string.IsNullOrEmpty(max)) { maxTime = Convert.ToDateTime(max); } // 正常的上下班时间 DateTime morInTime = Convert.ToDateTime(date + " 08:30:00"); DateTime morOutTime = Convert.ToDateTime(date + " 11:50:00"); DateTime aftInTime = Convert.ToDateTime(date + " 13:50:00"); DateTime aftOutTime = Convert.ToDateTime(date + " 17:00:00"); byte statu; try { statu = Convert.ToByte(bll.GetStatus(date)); } catch { statu = 0; } if (statu.Equals(0) || statu.Equals(2)) { sb.Append("<td style='width:20%;'><span style='color:gray'>休假</span></td>"); } else if (statu.Equals(1)) { // 如果当天存在请假信息,进行考勤状态的逻辑判断 if (bll.IsAskForLeaveTime(userID, date)) { DataRow[] row1 = dt.Select("BeginDate<='" + morInTime + "' and EndDate>='" + morOutTime + "'"); DataRow[] row2 = dt.Select("BeginDate<='" + aftInTime + "' and EndDate>='" + aftOutTime + "'"); if (minTime == null && maxTime == null) { if (row1.Length > 0 && row2.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#436EEE'>请假</span></td>"); } else if (row2.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:red;margin-right:10px;'>缺勤</span><span style='color:#436EEE;margin-left:10px;'>请假</span></td>"); } else if (row1.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#436EEE;margin-right:10px;'>请假</span><span style='color:red;margin-left:10px;'>缺勤</span></td>"); } else { sb.Append("<td style='width:20%;'><span style='color:red'>缺勤</span></td>"); } } else { // 对比上下班时间判定考勤状态 int r1 = DateTime.Compare((DateTime)minTime, morInTime); int r2 = DateTime.Compare((DateTime)maxTime, aftOutTime); int r3 = DateTime.Compare((DateTime)maxTime, morOutTime); int r4 = DateTime.Compare((DateTime)minTime, aftInTime); if (row1.Length > 0 && row2.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#436EEE'>请假</span></td>"); } else if (DateTime.Compare((DateTime)minTime, (DateTime)maxTime) == 0 && row1.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#436EEE;margin-right:10px;'>请假</span><span style='color:pink;margin-left:10px;'>未打卡</span></td>"); } else if (DateTime.Compare((DateTime)minTime, (DateTime)maxTime) == 0 && row2.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:pink;margin-right:10px;'>未打卡</span><span style='color:#436EEE;margin-left:10px;'>请假</span></td>"); } else if ((r4 > 0 && r2 < 0) && row1.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#436EEE;margin-right:10px;'>请假</span><span style='color:Aqua;margin-left:10px;'>迟到且早退</span></td>"); } else if ((r1 > 0 && r3 < 0) && row2.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:Aqua;margin-right:10px;'>迟到且早退</span><span style='color:#436EEE;margin-left:10px;'>请假</span></td>"); } else if ((r4 <= 0 && r2 >= 0) && row1.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#436EEE;margin-right:10px;'>请假</span><span style='color:#3CB371;margin-left:10px;'>正常</span></td>"); } else if ((r1 <= 0 && r3 >= 0) && row2.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#3CB371;margin-right:10px;'>正常</span><span style='color:#436EEE;margin-left:10px;'>请假</span></td>"); } else if (r2 < 0 && row1.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#436EEE;margin-right:10px;'>请假</span><span style='color:Orange;margin-left:10px;'>早退</span></td>"); } else if (r4 > 0 && row1.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#436EEE;margin-right:10px;'>请假</span><span style='color:#CAFF70;margin-left:10px;'>迟到</span></td>"); } else if (r1 > 0 && row2.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:#CAFF70;margin-right:10px;'>迟到</span><span style='color:#436EEE;margin-left:10px;'>请假</span></td>"); } else if (r3 < 0 && row2.Length > 0) { sb.Append("<td style='width:20%;'><span style='color:Orange;margin-right:10px;'>早退</span><span style='color:#436EEE;margin-left:10px;'>请假</span></td>"); } else if (r1 > 0) { sb.Append("<td style='width:20%;'><span style='color:#CAFF70;margin-right:10px;'>迟到</span><span style='color:red;margin-left:10px;'>缺勤</span></td>"); } else if (r2 < 0) { sb.Append("<td style='width:20%;'><span style='color:red;margin-right:10px;'>缺勤</span><span style='color:Orange;margin-left:10px;'>早退</span></td>"); } else { sb.Append("<td style='width:20%;'><span style='color:red'>缺勤</span></td>"); } } } else { if (minTime == null && maxTime == null) { sb.Append("<td style='width:20%;'><span style='color:red'>缺勤</span></td>"); } else { // 对比上下班时间判定考勤状态 int r1 = DateTime.Compare((DateTime)minTime, morInTime); int r2 = DateTime.Compare((DateTime)maxTime, aftOutTime); if (DateTime.Compare((DateTime)minTime, (DateTime)maxTime) == 0) { sb.Append("<td style='width:20%;'><span style='color:pink'>未打卡</span></td>"); } else if (r1 <= 0 && r2 >= 0) { sb.Append("<td style='width:20%;'><span style='color:#3CB371'>正常</span></td>"); } else if (r1 > 0 && r2 < 0) { sb.Append("<td style='width:20%;'><span style='color:Aqua'>迟到且早退</span></td>"); } else if (r1 > 0) { sb.Append("<td style='width:20%;'><span style='color:#CAFF70'>迟到</span></td>"); } else if (r2 < 0) { sb.Append("<td style='width:20%;'><span style='color:Orange'>早退</span></td>"); } else { sb.Append("<td style='width:20%;'><span style='color:#8B008B'>异常</span></td>"); } } } } sb.Append("</tr>"); } sb.Append("</table>"); context.Response.Write(sb.ToString()); } #endregion #region 日历显示员工考勤 else if (context.Request.QueryString["opera"] == "calendar") { if (context.Session["user"] == null) { context.Response.Write("<script>top.location='/View/Default.aspx'</script>"); context.Response.End(); } string userID = ((UserInfoModel)context.Session["user"]).UserID; int year = Convert.ToInt32(context.Request.QueryString["year"]); int month = Convert.ToInt32(context.Request.QueryString["month"]); int days = DateTime.DaysInMonth(year, month); // 获取当前月份的天数 StringBuilder sb = new StringBuilder(); sb.Append("<table class='calendar' cellspacing='0' rules='all' border='1' id='calendar' style='border-collapse:collapse;'>"); sb.Append("<tr><th scope='col'>一</th><th scope='col'>二</th><th scope='col'>三</th><th scope='col'>四</th><th scope='col'>五</th><th scope='col'>六</th><th scope='col'>日</th></tr>"); int day = 1; DateTime time = Convert.ToDateTime(year + "-" + month + "-" + day); AttendanceInfoBLL bll = new AttendanceInfoBLL(); DataTable dt = bll.GetAskForLeaveTime(userID); for (int i = 0; i < 6; i++) { sb.Append("<tr>"); // 遍历每个星期的考勤状态 for (int j = 0; j < 7; j++) { int week = (Convert.ToInt32(time.DayOfWeek) + 6) % 7; if (j == week && day <= days) { string date = time.ToString("yyyy-MM-dd"); // 获取当天的打卡时间 string min = bll.GetMinFaceTime(userID, date).ToString(); string max = bll.GetMaxFaceTime(userID, date).ToString(); sb.AppendFormat("<td Day='{0}' FirstTime='{1}' LastTime='{2}'>", time.ToString("yyyy年MM月dd日") + "\t" + time.ToString("dddd"), min, max); sb.AppendFormat("<div class='left'>{0}</div>", day); DateTime? minTime = null; if (!string.IsNullOrEmpty(min)) { minTime = Convert.ToDateTime(min); } DateTime? maxTime = null; if (!string.IsNullOrEmpty(max)) { maxTime = Convert.ToDateTime(max); } // 正常的上下班时间 DateTime morInTime = Convert.ToDateTime(date + " 08:30:00"); DateTime morOutTime = Convert.ToDateTime(date + " 11:50:00"); DateTime aftInTime = Convert.ToDateTime(date + " 13:50:00"); DateTime aftOutTime = Convert.ToDateTime(date + " 17:00:00"); byte statu; try { statu = Convert.ToByte(bll.GetStatus(date)); } catch { statu = 0; } if (statu.Equals(0) || statu.Equals(2)) { sb.Append("<div class='right'><div class='div1' style='background-color:gray;'>休假</div></div>"); } else if (statu.Equals(1)) { // 如果当天存在请假信息,进行考勤状态的逻辑判断 if (bll.IsAskForLeaveTime(userID, date)) { DataRow[] row1 = dt.Select("BeginDate<='" + morInTime + "' and EndDate>='" + morOutTime + "'"); DataRow[] row2 = dt.Select("BeginDate<='" + aftInTime + "' and EndDate>='" + aftOutTime + "'"); if (minTime == null && maxTime == null) { if (row1.Length > 0 && row2.Length > 0) { sb.Append("<div class='right'><div class='div1' style='background-color:#436EEE;'>请假</div></div>"); } else if (row2.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:red;'>缺勤</div><div class='div2' style='background-color:#436EEE;'>请假</div></div>"); } else if (row1.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#436EEE;'>请假</div><div class='div2' style='background-color:red;'>缺勤</div></div>"); } else { sb.Append("<div class='right'><div class='div1' style='background-color:red;'>缺勤</div></div>"); } } else { // 对比上下班时间判定考勤状态 int r1 = DateTime.Compare((DateTime)minTime, morInTime); int r2 = DateTime.Compare((DateTime)maxTime, aftOutTime); int r3 = DateTime.Compare((DateTime)maxTime, morOutTime); int r4 = DateTime.Compare((DateTime)minTime, aftInTime); if (row1.Length > 0 && row2.Length > 0) { sb.Append("<div class='right'><div class='div1' style='background-color:#436EEE;'>请假</div></div>"); } else if (DateTime.Compare((DateTime)minTime, (DateTime)maxTime) == 0 && row1.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#436EEE;'>请假</div><div class='div2' style='background-color:pink;'>未打卡</div></div>"); } else if (DateTime.Compare((DateTime)minTime, (DateTime)maxTime) == 0 && row2.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:pink;'>未打卡</div><div class='div2' style='background-color:#436EEE;'>请假</div></div>"); } else if ((r4 > 0 && r2 < 0) && row1.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#436EEE;'>请假</div><div class='div2' style='background-color:Aqua;'>迟到且早退</div></div>"); } else if ((r1 > 0 && r3 < 0) && row2.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:Aqua;'>迟到且早退</div><div class='div2' style='background-color:#436EEE;'>请假</div></div>"); } else if ((r4 <= 0 && r2 >= 0) && row1.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#436EEE;'>请假</div><div class='div2' style='background-color:#3CB371;'>正常</div></div>"); } else if ((r1 <= 0 && r3 >= 0) && row2.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#3CB371;'>正常</div><div class='div2' style='background-color:#436EEE;'>请假</div></div>"); } else if (r2 < 0 && row1.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#436EEE;'>请假</div><div class='div2' style='background-color:Orange;'>早退</div></div>"); } else if (r4 > 0 && row1.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#436EEE;'>请假</div><div class='div2' style='background-color:#CAFF70;'>迟到</div></div>"); } else if (r1 > 0 && row2.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#CAFF70;'>迟到</div><div class='div2' style='background-color:#436EEE;'>请假</div></div>"); } else if (r3 < 0 && row2.Length > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:Orange;'>早退</div><div class='div2' style='background-color:#436EEE;'>请假</div></div>"); } else if (r1 > 0) { sb.Append("<div class='right'><div class='div2' style='background-color:#CAFF70;'>迟到</div><div class='div2' style='background-color:red;'>缺勤</div></div>"); } else if (r2 < 0) { sb.Append("<div class='right'><div class='div2' style='background-color:red;'>缺勤</div><div class='div2' style='background-color:Orange;'>早退</div></div>"); } else { sb.Append("<div class='right'><div class='div1' style='background-color:red;'>缺勤</div></div>"); } } } else { if (minTime == null && maxTime == null) { sb.Append("<div class='right'><div class='div1' style='background-color:red;'>缺勤</div></div>"); } else { // 对比上下班时间判定考勤状态 int r1 = DateTime.Compare((DateTime)minTime, morInTime); int r2 = DateTime.Compare((DateTime)maxTime, aftOutTime); if (DateTime.Compare((DateTime)minTime, (DateTime)maxTime) == 0) { sb.Append("<div class='right'><div class='div1' style='background-color:pink;'>未打卡</div></div>"); } else if (r1 <= 0 && r2 >= 0) { sb.Append("<div class='right'><div class='div1' style='background-color:#3CB371;'>正常</div></div>"); } else if (r1 > 0 && r2 < 0) { sb.Append("<div class='right'><div class='div1' style='background-color:Aqua;'>迟到且早退</div></div>"); } else if (r1 > 0) { sb.Append("<div class='right'><div class='div1' style='background-color:#CAFF70;'>迟到</div></div>"); } else if (r2 < 0) { sb.Append("<div class='right'><div class='div1' style='background-color:Orange;'>早退</div></div>"); } else { sb.Append("<div class='right'><div class='div1' style='background-color:#8B008B;'>异常</div></div>"); } } } } sb.Append("</td>"); time = time.AddDays(1); day++; } else { sb.Append("<td><div class='left'></div><div class='right'></div></td>"); } } sb.Append("</tr>"); if (day > days) break; } sb.Append("</table>"); context.Response.Write(sb.ToString()); } #endregion } else if (context.Request.QueryString["type"] == "delete") { #region 删除指定用户 if (context.Request.QueryString["opera"] == "users") { if (context.Request.QueryString["userID"] != null) { UserInfoBLL bll = new UserInfoBLL(); int res = bll.DeleteUsers(context.Request.QueryString["userID"]); int total = Convert.ToInt32(context.Request.QueryString["total"]); string msg = res > 0 ? "删除成功:" + res + "条,删除失败:" + (res - total) + "条。" : "删除失败!"; context.Response.Write(msg); } } #endregion #region 删除指定部门 else if (context.Request.QueryString["opera"] == "depart") { if (context.Request.QueryString["deptID"] != null) { DepartmentBLL bll = new DepartmentBLL(); try { bll.DeleteDepart(context.Request.QueryString["deptID"]); context.Response.Write("{'Result':'OK','Message':'删除成功!'}"); } catch { context.Response.Write("{'Result':'NO','Message':'删除失败!'}"); } } } #endregion #region 删除请假单 else if (context.Request.QueryString["opera"] == "leave") { if (context.Request.QueryString["appID"] != null) { ApproveBLL bll = new ApproveBLL(); try { bll.DeleteLeave(context.Request.QueryString["appID"]); context.Response.Write("{'Result':'OK','Message':'删除成功!'}"); } catch { context.Response.Write("{'Result':'NO','Message':'删除失败!'}"); } } } #endregion } else if (context.Request.QueryString["type"] == "append") { #region 添加请假单 if (context.Request.QueryString["opera"] == "leave") { if (context.Session["user"] == null) { context.Response.Write("<script>top.location='/View/Default.aspx'</script>"); context.Response.End(); } ApproveModel apprv = new ApproveModel { ApplyUser = ((UserInfoModel)context.Session["user"]).UserID, Title = context.Request.QueryString["title"], BeginDate = Convert.ToDateTime(context.Request.QueryString["beginDate"]), EndDate = Convert.ToDateTime(context.Request.QueryString["endDate"]), Reason = context.Request.QueryString["reason"] }; ApproveBLL bll = new ApproveBLL(); try { bll.AppendLeave(apprv); context.Response.Write("{'Result':'OK','Message':'保存成功!'}"); } catch { context.Response.Write("{'Result':'NO','Message':'保存失败!'}"); } } #endregion } else if (context.Request.QueryString["type"] == "edit") { #region 编辑个人资料 if (context.Request.QueryString["opera"] == "private") { if (context.Session["user"] == null) { context.Response.Write("<script>top.location='/View/Default.aspx'</script>"); context.Response.End(); } UserInfoModel user = new UserInfoModel { UserID = ((UserInfoModel)context.Session["user"]).UserID, Cellphone = context.Request.QueryString["phone"] }; // 检验用户是否修改密码 if (context.Request.QueryString["pwd"] != null) { user.Password = MD5Maker.GetMD5(context.Request.QueryString["pwd"]); } UserInfoBLL bll = new UserInfoBLL(); try { bll.EditPrivate(user); context.Response.Write("{'Result':'OK','Message':'保存成功!'}"); } catch { context.Response.Write("{'Result':'NO','Message':'保存失败!'}"); } } #endregion #region 设置日常考勤 else if (context.Request.QueryString["opera"] == "setting") { string date = context.Request.QueryString["date"]; string statu = context.Request.QueryString["statu"]; AttendanceSettingBLL bll = new AttendanceSettingBLL(); try { bll.SetAttendanceSetting(date, statu); context.Response.Write("{'Result':'OK','Message':'保存成功!'}"); } catch { context.Response.Write("{'Result':'NO','Message':'保存失败!'}"); } } #endregion #region 编辑请假单 else if (context.Request.QueryString["opera"] == "leave") { ApproveModel apprv = new ApproveModel { ApproveID = Convert.ToInt32(context.Request.QueryString["appID"]), Title = context.Request.QueryString["title"], BeginDate = Convert.ToDateTime(context.Request.QueryString["beginDate"]), EndDate = Convert.ToDateTime(context.Request.QueryString["endDate"]), Reason = context.Request.QueryString["reason"] }; ApproveBLL bll = new ApproveBLL(); try { bll.EditLeave(apprv); context.Response.Write("{'Result':'OK','Message':'保存成功!'}"); } catch { context.Response.Write("{'Result':'NO','Message':'保存失败!'}"); } } #endregion #region 审批请假单 else if (context.Request.QueryString["opera"] == "apprv") { if (context.Session["user"] == null) { context.Response.Write("<script>top.location='/View/Default.aspx'</script>"); context.Response.End(); } ApproveModel apprv = new ApproveModel { ApproveID = Convert.ToInt32(context.Request.QueryString["appID"]), ApproveUser = ((UserInfoModel)context.Session["user"]).UserID, Result = Convert.ToByte(context.Request.QueryString["result"]), Remark = context.Request.QueryString["remark"] }; ApproveBLL bll = new ApproveBLL(); try { bll.ApprvLeave(apprv); context.Response.Write("{'Result':'OK','Message':'保存成功!'}"); } catch { context.Response.Write("{'Result':'NO','Message':'保存失败!'}"); } } #endregion } else if (context.Request.QueryString["type"] == "validate") { #region 验证用户ID if (context.Request.QueryString["opera"] == "users") { string userID = context.Request.QueryString["userID"]; UserInfoBLL bll = new UserInfoBLL(); if (bll.IsExistsID(userID)) context.Response.Write("{'Result':'NO'}"); else context.Response.Write("{'Result':'OK'}"); } #endregion #region 验证部门名称 else if (context.Request.QueryString["opera"] == "depart") { string dept = context.Request.QueryString["dept"]; DepartmentBLL bll = new DepartmentBLL(); if (bll.IsExistsDept(dept)) context.Response.Write("{'Result':'NO'}"); else context.Response.Write("{'Result':'OK'}"); } #endregion } else if (context.Request.QueryString["type"] == "logout") { #region 清除Session context.Session["user"] = null; context.Response.Write("<script>location='/View/Default.aspx'</script>"); #endregion } } }
/// <summary> /// 添加用户 /// </summary> public int AppendUser(UserInfoModel user) { return dal.AppendUser(user); }
/// <summary> /// 编辑用户资料 /// </summary> public int EditUser(UserInfoModel user) { return dal.EditUser(user); }
public List<UserInfoModel> GetManager() { string sql = "select UserID,UserName,Department.DeptID,Password,Cellphone,UserType from UserInfo join Department on UserInfo.DeptID=Department.DeptID where UserType=1"; List<UserInfoModel> userList = new List<UserInfoModel>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(sql)) { while (reader.Read()) { UserInfoModel user = new UserInfoModel(); user.UserID = reader["UserID"] as string; user.UserName = reader["UserName"] as string; user.DeptID = (int)reader["DeptID"]; user.Password = reader["Password"] as string; user.Cellphone = reader["Cellphone"] as string; user.UserType = (byte)reader["UserType"]; userList.Add(user); } } return userList; }
/// <summary> /// 编辑个人资料 /// </summary> public int EditPrivate(UserInfoModel user) { return dal.EditPrivate(user); }
//修改个人资料 public bool UpdateUserInfo(UserInfoModel model) { string sql = string.Format(@"upadte UserInfo set [Email]='{0}',Name='{1}',Sex='{2}', TheLatter='{3}',HomeTown='{4}',Marriage='{5}',Position='{6}', Company='{7}',InterestIn='{8}',IntroduceMyself='{9}',QQ='{10}',WorkingConditions={11},BirthDay='{12}')", model.Email, model.Name, model.Sex, model.TheLatter, model.HomeTown, model.Marriage, model.Position, model.Company, model.InterestIn, model.IntroduceMyself, model.QQ, model.WorkingConditions, model.BirthDay); return SqlAccess.Execute(sql) > 0; }