protected void Ibtn_OK_Click(object sender, ImageClickEventArgs e) { SHMetroTestSysModel.jc_User user = new SHMetroTestSysModel.jc_User(); user.UserIdCard = txt_UserIdCard.Text; user.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile(this.txt_UserPwd.Text, "MD5"); user.TrueName = this.txt_TrueName.Text.Trim(); user.UserGroupId = this.ddl_UserGroup.SelectedValue; user.UserSex = this.ddl_Sex.SelectedItem.Value.ToString(); if (user.UserSex == "0") { user.UserSex = ""; } user.UserQQ = this.txt_QQ.Text.Trim(); user.ProhibitSubject = this.hd_ProhibitSubject.Value; user.Corporation = this.txt_Corporation.Text.Trim(); user.Education = this.ddl_Education.SelectedItem.Value; user.Phone = this.txt_Phone.Text.Trim(); try { if (!string.IsNullOrEmpty(this.txt_UserBirthday.Text.Trim())) { user.UserBirthday = DateTime.Parse(this.txt_UserBirthday.Text.Trim()); } if (!string.IsNullOrEmpty(this.txt_ValidityDate_Start.Text.Trim()) & !string.IsNullOrEmpty(this.txt_ValidityDate_End.Text.Trim())) { DateTime time = Convert.ToDateTime(txt_ValidityDate_Start.Text.Trim()); DateTime time2 = Convert.ToDateTime(txt_ValidityDate_End.Text.Trim()); if (time >= time2) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert(\"有效期限的开始日期必须小于结束日期!\");</script>"); return; } } user.ValidityDate = this.txt_ValidityDate_Start.Text.Trim() + "|" + this.txt_ValidityDate_End.Text.Trim(); } catch (Exception ex) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert(\"日期格式不对!\");</script>"); } if (jcUserBF.CheckUserExists(user.UserIdCard)) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert(\"用户名已存在,请使用其他用户名!\");</script>"); } else { if (jcUserBF.RegUser(user)) { this.Pan_Add.Visible = false; this.Pan_Add_OK.Visible = true; this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert(\"添加新考生成功!\");</script>"); } else { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert(\"添加新考生出现异常错误!\");</script>"); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_User GetModelByUsername(string userIdCard, string userPwd) { var strSql = new StringBuilder(); strSql.Append( "select top 1 Id,UserGroupId,UserIdCard,UserPwd,TrueName,UserSex,Corporation,Education,Phone,UserQQ,UserBirthday,ProhibitSubject,ProhibitLibrary,ValidityDate,UserStatus,LastLoginTime from jc_User "); strSql.Append(" where UserIdCard=@UserIdCard"); strSql.Append(" and UserPwd=@UserPwd"); SqlParameter[] parameters = { new SqlParameter("@UserIdCard", SqlDbType.VarChar, 18), new SqlParameter("@UserPwd", SqlDbType.Char, 32) }; parameters[0].Value = userIdCard; parameters[1].Value = userPwd; var model = new SHMetroTestSysModel.jc_User(); var ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } return null; }
/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_User DataRowToModel(DataRow row) { var model = new SHMetroTestSysModel.jc_User(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["UserGroupId"] != null) { model.UserGroupId = row["UserGroupId"].ToString(); } if (row["UserIdCard"] != null) { model.UserIdCard = row["UserIdCard"].ToString(); } if (row["UserPwd"] != null) { model.UserPwd = row["UserPwd"].ToString(); } if (row["TrueName"] != null) { model.TrueName = row["TrueName"].ToString(); } if (row["UserSex"] != null) { model.UserSex = row["UserSex"].ToString(); } if (row["Corporation"] != null) { model.Corporation = row["Corporation"].ToString(); } if (row["Education"] != null) { model.Education = row["Education"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["UserQQ"] != null) { model.UserQQ = row["UserQQ"].ToString(); } if (row["UserBirthday"] != null && row["UserBirthday"].ToString() != "") { model.UserBirthday = DateTime.Parse(row["UserBirthday"].ToString()); } if (row["ProhibitSubject"] != null) { model.ProhibitSubject = row["ProhibitSubject"].ToString(); } if (row["ProhibitLibrary"] != null) { model.ProhibitLibrary = row["ProhibitLibrary"].ToString(); } if (row["ValidityDate"] != null) { model.ValidityDate = row["ValidityDate"].ToString(); } if (row["UserStatus"] != null) { model.UserStatus = row["UserStatus"].ToString(); } if (row["LastLoginTime"] != null && row["LastLoginTime"].ToString() != "") { model.LastLoginTime = DateTime.Parse(row["LastLoginTime"].ToString()); } } return model; }
protected void Ibtn_Reg_Click(object sender, ImageClickEventArgs e) { SHMetroTestSysModel.jc_User user = new SHMetroTestSysModel.jc_User(); user.UserIdCard = txt_UserIdCard.Text.Trim(); user.TrueName = txt_TrueName.Text.Trim(); user.UserGroupId = ddl_UserGroup.SelectedItem.Value; user.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile(txt_UserPwd.Text, "MD5"); if ((((user.UserIdCard == "") || (user.TrueName == "")) || (user.UserGroupId == "")) || (user.UserPwd == "")) { Page.ClientScript.RegisterStartupScript(GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert('请输入必须项!');</script>"); } else if (jcUserBF.CheckUserExists(user.UserIdCard)) { Page.ClientScript.RegisterStartupScript(GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert('输入的用户名已存在!');</script>"); } else { user.UserSex = ddl_UserSex.SelectedItem.Value; if (user.UserSex == "0") { user.UserSex = ""; } if (txt_UserBirthday.Text.Trim() != "点击选择日期" && !string.IsNullOrEmpty(txt_UserBirthday.Text.Trim())) { user.UserBirthday = DateTime.Parse(txt_UserBirthday.Text.Trim()); } user.UserQQ = txt_UserQQ.Text.Trim(); user.Corporation = txt_Corporation.Text.Trim(); user.Education = ddl_Education.SelectedItem.Value; user.Phone = txt_Phone.Text.Trim(); user.LastLoginTime = DateTime.Now; user.UserSex = "Leave"; user.ProhibitSubject = jcSubjectBF.GetAllSubjectIds(); try { string installedValTemp = jcSystemBF.GetJcSystemByInstalledName("DefaultOpenSubject"); if (!string.IsNullOrEmpty(installedValTemp)) { var strArray = installedValTemp.Split(','); for (var i = 0; i < (strArray.Length - 1); i++) { user.ProhibitSubject = user.ProhibitSubject.Replace(strArray[i] + ",", ""); } } } catch { Page.ClientScript.RegisterStartupScript(GetType(), "startscript", "<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('注册考生时出现异常错误!');</script>"); return; } try { if (jcUserBF.RegUser(user)) { Session["UserIdCard"] = user.UserIdCard; Session["RegUserIdCard"] = user.UserIdCard; Response.Redirect("Login.aspx"); } else { Page.ClientScript.RegisterStartupScript(GetType(), "startscript", "<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('注册考生时出现异常错误!');</script>"); return; } } catch { Page.ClientScript.RegisterStartupScript(GetType(), "startscript", "<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('注册考生时出现异常错误!');</script>"); } } }
protected void Ibtn_OK_Click(object sender, ImageClickEventArgs e) { SHMetroTestSysModel.jc_User user = new SHMetroTestSysModel.jc_User(); user = jcUserBF.GetUserByUserIdCard(Request.QueryString["UserIdCard"].ToString()); user.TrueName = this.txt_TrueName.Text.Trim(); user.UserGroupId = this.ddl_UserGroup.SelectedValue; user.UserSex = this.ddl_Sex.SelectedItem.Value.ToString(); if (user.UserSex == "0") { user.UserSex = ""; } user.UserQQ = this.txt_QQ.Text.Trim(); user.Corporation = this.txt_Corporation.Text.Trim(); user.Education = this.ddl_Education.SelectedItem.Value; user.Phone = this.txt_Phone.Text.Trim(); user.ProhibitSubject = this.hd_ProhibitSubject.Value.ToString(); user.ProhibitLibrary = this.hd_ProhibitLibrary.Value.ToString(); try { if (!string.IsNullOrEmpty(this.txt_UserBirthday.Text.Trim())) { user.UserBirthday = DateTime.Parse(this.txt_UserBirthday.Text.Trim()); } if (!string.IsNullOrEmpty(this.txt_ValidityDate_Start.Text.Trim()) & !string.IsNullOrEmpty(this.txt_ValidityDate_End.Text.Trim())) { DateTime time = Convert.ToDateTime(txt_ValidityDate_Start.Text.Trim()); DateTime time2 = Convert.ToDateTime(txt_ValidityDate_End.Text.Trim()); if (time >= time2) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert(\"有效期限的开始日期必须小于结束日期!\");</script>"); return; } } if (string.IsNullOrEmpty(txt_ValidityDate_Start.Text.Trim()) && string.IsNullOrEmpty(txt_ValidityDate_End.Text.Trim())) { user.ValidityDate = ""; } } catch (Exception ex) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert(\"日期格式不对!\");</script>"); } if (jcUserBF.UpdateModel(user)) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script>document.getElementById(\"showStinfo\").style.display = \"none\";</script>"); this.Pan_Modify_OK.Visible = true; this.ModifyOk.Value = "true"; } else { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert('修改考生信息出现异常错误!');</script>"); } }