private bool UpdateOtherInfo() { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(UserID); bool result = false; //更新姓名 if (txt_User_realname.Text == "") { JscriptMsg("请填写真实姓名!", "", "Error"); return(false); } else { user_model.User_realname = this.txt_User_realname.Text; } //更新手机号,内容不变 user_model.User_number = this.txt_User_number.Text; //更新性别 if (this.rbl_User_gender.SelectedIndex == 0) { user_model.User_gender = false; } else { user_model.User_gender = true; } //更新出生日期 try { user_model.User_birthday = Convert.ToDateTime(this.txt_User_birthday.Text); } catch { user_model.User_birthday = null; } //更新的状态 try { bool res = user_bll.Update(user_model); if (res == true) { return(res); } } catch { result = false; } return(result); }
protected string Pass(HttpContext context) { JsonData data = new JsonData(); string _schooluserid = MyRequest.GetString("schooluserid"); string Pass = MyRequest.GetString("pass"); string PassConfirm = MyRequest.GetString("passconfirm"); string msg = ""; if (Tools.CheckParams(Pass + PassConfirm)) { msg = "传输异常,存在非法字符!"; } else { if (Pass.Length < 6 || Pass.Length > 16) { msg = "密码长度请控制在6-16位!"; } else if (Pass != PassConfirm) { msg = "两次密码输入不一致!"; } else { try { BLL.CCOM.User_information bll = new BLL.CCOM.User_information(); long schooluserid = long.Parse(DESEncrypt.Decrypt(_schooluserid)); Model.CCOM.User_information model = bll.GetModel(schooluserid); model.User_password = DESEncrypt.MD5Encrypt(Pass); bool res = bll.Update(model); if (res == false) { msg = "修改失败,参数发生异常!"; } } catch (Exception) { msg = "修改发生异常!"; } } } if (msg == "") { data["msg"] = "修改成功"; data["code"] = 1; } else { data["msg"] = msg; data["code"] = 0; } return(data.ToJson()); }
private bool UpdateStudentInfo() { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(UserID); bool result = false; if (this.ddlOtherGender.SelectedValue == "0") { user_model.User_gender = false; } else { user_model.User_gender = true; } if (this.txtOtherPhone.Value != "") { user_model.User_phone = this.txtOtherPhone.Value; } if (this.txtBirthday.Text != "") { user_model.User_birthday = Convert.ToDateTime(this.txtBirthday.Text); } if (this.ddlNationality.SelectedValue != "0") { user_model.Nationality_id = int.Parse(this.ddlNationality.SelectedValue); } if (this.ddlPolitic.SelectedValue != "0") { user_model.Politic_id = int.Parse(this.ddlPolitic.SelectedValue); } try { bool res = user_bll.Update(user_model); if (res == true) { return(res); } } catch { result = false; } return(result); }
protected void lbtAble_Click(object sender, EventArgs e) { var bll = new BLL.CCOM.User_information(); var lbtn = sender as LinkButton; if (lbtn != null) { var id = Int64.Parse(DESEncrypt.Decrypt(lbtn.ToolTip.ToString())); bool isOn = false; bool result = true; try { var m = bll.GetModel("User_id=" + id); isOn = m.User_status == true; m.User_status = isOn ^ true; if (bll.Update(m) == false) { result = false; } } catch { result = false; } string keywords = MyRequest.GetQueryString("keywords"); int page = MyRequest.GetQueryInt("page", 1); if (result == true) { JscriptMsg(isOn ? "禁用成功!" : "启用成功!", Utils.CombUrlTxt("ManagerList.aspx", "fun_id={0}&keywords={1}&page={2}", DESEncrypt.Encrypt(this.fun_id), keywords, page.ToString()), "Success"); } else { JscriptMsg(isOn ? "禁用失败!" : "启用失败!", Utils.CombUrlTxt("ManagerList.aspx", "fun_id={0}&keywords={1}&page={2}", DESEncrypt.Encrypt(this.fun_id), keywords, page.ToString()), "Error"); } RptBind(CombSqlTxt(this.keywords), " User_id desc "); } }
protected string Pass(string Pass, string PassConfirm) { string msg = ""; if (Tools.CheckParams(Pass + PassConfirm)) { msg = "传输异常,存在非法字符!"; } else { if (Pass.Length < 6 || Pass.Length > 16) { msg = "密码长度请控制在6-16位!"; } else if (Pass != PassConfirm) { msg = "两次密码输入不一致!"; } else { try { BLL.CCOM.User_information bll = new BLL.CCOM.User_information(); Model.CCOM.User_information model = GetAdminInfo_CCOM(); model.User_password = DESEncrypt.MD5Encrypt(Pass); bool res = bll.Update(model); if (res == false) { msg = "修改失败,参数发生异常!"; } } catch (Exception) { msg = "修改发生异常!"; } } } return(msg); }
private string DoAction() { string result = ""; BLL.CCOM.User_information bll = new BLL.CCOM.User_information(); Model.CCOM.User_information model; if (action != MyEnums.ActionEnum.Edit.ToString()) { model = new Model.CCOM.User_information(); } else { model = bll.GetModel("User_id=" + userId); } string Sex = this.rblSex.SelectedValue; string Mobile = this.txtMobile.Text.Trim(); string Pass1 = this.txtPass1.Text.Trim(); string Pass2 = this.txtPass2.Text.Trim(); // string IdNumberType = this.ddlIdType.SelectedItem.Value; //string IdNumber = this.txtIdNumber.Text.Trim(); string Realname = this.txtRealname.Text.Trim(); string Agency = this.ddlAgency.SelectedItem.Value; // string Role = this.ddlRole.SelectedItem.Value; //必填部分 if (Tools.CheckParams(Mobile + Realname + Pass1 + Pass2)) { return("请勿输入非法字符"); } if (Realname == "") { return("请填写真实姓名"); } model.User_realname = Realname; if (Mobile == "") { return("请填写学号/工号"); } if (!Validator.IsMobile(Mobile)) { return("学号/工号不合法"); } if (action != MyEnums.ActionEnum.Edit.ToString() && bll.GetRecordCount(" User_number='" + Mobile + "'") > 0) { return("该学号/工号已被添加"); } model.User_number = Mobile; if (action != MyEnums.ActionEnum.Edit.ToString()) { if (Pass1 == "") { return("请填写密码"); } if (Pass2 == "") { return("请填写确认密码"); } } if (Pass1.Length > 0 || Pass2.Length > 0) { if (Pass1.Length < 6 || Pass1.Length > 16) { return("密码长度请控制在6-16位"); } if (Pass1 != Pass2) { return("两次输入密码不符"); } } model.User_password = DESEncrypt.MD5Encrypt(Pass1); model.User_addtime = DateTime.Now; model.User_status = true; model.Role_id = 1; if (Agency == "#") { return("请选择机构"); } model.Agency_id = Convert.ToInt32(Agency); //if (Role == "#") //{ // return "请选择角色"; //} //model.Role_id = Convert.ToInt32(Role); //选填部分 model.User_gender = Convert.ToInt32(Sex) == 0; //if (IdNumber != "") //{ // if (IdNumberType == "#") // { // return "请选择证件类型"; // } // //验证身份证信息,只能验证身份证 // else if (Convert.ToInt32(IdNumberType) == 1) // { // bool check = false; // if (IdNumber.Length == 18) // { // check = CheckIDCard18(IdNumber); // } // else if (IdNumber.Length == 15) // { // check = CheckIDCard15(IdNumber); // } // if (check) // { // if (action != MyEnums.ActionEnum.Edit.ToString() && bll.GetRecordCount(" User_ID_number='" + IdNumber + "'") > 0) // { // return "该证件号已被添加"; // } // model.User_ID_number_type = Convert.ToInt32(IdNumberType); // model.User_ID_number = IdNumber; // } // else // { // return "请检查身份证号码是否正确"; // } // } //} if (this.txtBirthday.Value != "") { DateTime Birthday = Convert.ToDateTime(this.txtBirthday.Value); model.User_birthday = Birthday; } try { if (action == MyEnums.ActionEnum.Edit.ToString()) //修改 { bll.Update(model); } else { bll.Add(model); } } catch (Exception ex) { result = action == MyEnums.ActionEnum.Edit.ToString() ? "修改失败" : "添加失败" + ex.Message.ToString(); } return(result); }
private bool DoUpdateUserInfo(long _id) { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(_id); bool result = false; //更新姓名 if (txt_User_realname.Text == "") { JscriptMsg("请填写真实姓名!", "", "Error"); return(false); } else { user_model.User_realname = this.txt_User_realname.Text; } //更改选择的结果 // //更新手机号,内容不变 user_model.User_number = this.txt_User_number.Text; //更新性别 if (this.rbl_User_gender.SelectedIndex == 0) { user_model.User_gender = false; } else { user_model.User_gender = true; } //= Convert.ToBoolean(this.rbl_User_gender.SelectedValue); ////更新证件类型 //user_model.User_ID_number_type = Convert.ToInt32(this.ddl_User_ID_number_type.SelectedValue); ////更新证件号码 //if (txt_User_ID_number.Text == "") //{ // JscriptMsg("请填写证件号码!", "", "Error"); // return false; //} //else //{ // //验证身份证信息,只能验证身份证 // string _txt_User_Id_number = txt_User_ID_number.Text.ToString(); // if (Convert.ToInt32(this.ddl_User_ID_number_type.SelectedValue) == 1) // { // bool check = false; // if (_txt_User_Id_number.Length == 18) // { // check = CheckIDCard18(_txt_User_Id_number); // } // else if (_txt_User_Id_number.Length == 15) // { // check = CheckIDCard15(_txt_User_Id_number); // } // if (check) // { // user_model.User_ID_number = this.txt_User_ID_number.Text; // } // else // { // JscriptMsg("请检查身份证号码是否正确!", "", "Error"); // return false; // } // } // //非身份证的时候 // else // { // user_model.User_ID_number = this.txt_User_ID_number.Text; // } //} //更新出生日期 try { user_model.User_birthday = Convert.ToDateTime(this.txt_User_birthday.Text); } catch { user_model.User_birthday = null; } //更新的状态 try { bool res = user_bll.Update(user_model); if (res == true) { return(res); } } catch { result = false; } return(result); }
protected void GetPwdByPhone() { if (Session[MyKeys.SESSION_PHONE_CODE] == null) { this.lblReInfo.Text = "请输入手机验证码!"; return; } if (Session[MyKeys.SESSION_PHONE_CODE].ToString() != this.txtPhoneCode.Text) { this.lblReInfo.Text = "验证码输入不正确!"; return; } String userName = this.txtUserName1.Text.Trim(); String phone = this.txtPhone.Text.Trim(); if (userName == "") { this.lblReInfo.Text = "用户名为空!"; return; } if (userName.Length > 50 || !Common.Utils.IsSafeSqlString(userName)) { this.lblReInfo.Text = "用户名不合法!"; return; } if (!Validator.IsMobile(phone)) { this.lblReInfo.Text = "手机号不合法!"; return; } //判断用户是否存在 BLL.CCOM.User_information bll = new BLL.CCOM.User_information(); Model.CCOM.User_information model = bll.GetModel(" User_number='" + phone + "'"); if (model == null) { this.lblReInfo.Text = "用户信息不匹配!"; return; } BLL.CCOM.User_property userEx_bll = new BLL.CCOM.User_property(); Model.CCOM.User_property userEx_model = userEx_bll.GetModel(" User_id=" + model.User_id); if (userEx_model == null) { if (!model.User_realname.Equals(userName)) { this.lblReInfo.Text = "用户信息不匹配!"; return; } } else { if (!model.User_realname.Equals(userName) && !userEx_model.UP_CEE_number.Equals(userName)) { this.lblReInfo.Text = "用户信息不匹配!"; return; } } //更改密码 String newPwd = Utils.Number(6); model.User_password = DESEncrypt.MD5Encrypt(newPwd);//敏感字段 bll.Update(model); ManDaoSMS.SendSMS(phone, GetChangePwdSms(model.User_realname, newPwd)); this.lblReInfo.Text = "新密码已发送您的手机,请查看!"; }
protected string ImportDataItem(DataSet ds, ref int success, ref int error)//基础数据 { string result = ""; BLL.CCOM.User_information stu_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information stu_model = new Model.CCOM.User_information(); BLL.CCOM.Topic topic_bll = new BLL.CCOM.Topic(); Model.CCOM.Topic topic_model = new Model.CCOM.Topic(); BLL.CCOM.Topic_relation rela_bll = new BLL.CCOM.Topic_relation(); Model.CCOM.Topic_relation rela_model = new Model.CCOM.Topic_relation(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string checkmsg = null; #region 添加学生信息========================== //学号 string number = ds.Tables[0].Rows[i]["学号"].ToString().Trim(); if (!ValidDFValue(number, true, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,学号" + checkmsg + "<br/>"; error++; continue; } else if (stu_bll.GetModel(" User_number='" + number + "'") != null) { stu_model = stu_bll.GetModel(" User_number='" + number + "'"); } else if (number != "") { stu_model.User_number = number; } //姓名 string name = ds.Tables[0].Rows[i]["姓名"].ToString().Trim(); if (!ValidDFValue(name, true, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,姓名" + checkmsg + "<br/>"; error++; continue; } else if (name != "") { stu_model.User_realname = name; } //性别 //string gender = ds.Tables[0].Rows[i]["性别"].ToString().Trim(); //if (!ValidDFValue(gender, true, "男|女", ref checkmsg)) //{ // result += "×第" + (i + 1).ToString() + "行数据更新失败,性别" + checkmsg + "<br/>"; // error++; // continue; //} //else if (gender == "男") //{ // stu_model.User_gender = false; //} //else if (gender == "女") //{ // stu_model.User_gender = true; //} //机构 stu_model.User_gender = false; string angency = ds.Tables[0].Rows[i]["行政班"].ToString().Trim(); if (!ValidDFValue(angency, true, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,所在班号" + checkmsg + "<br/>"; error++; continue; } BLL.CCOM.Agency agency_bll = new BLL.CCOM.Agency(); Model.CCOM.Agency agency_model = new Model.CCOM.Agency(); agency_model = agency_bll.GetModel(" Agency_name='" + angency + "'"); if (agency_model == null) { result += "×第" + (i + 1).ToString() + "行数据更新失败,所在班号不存在<br/>"; error++; continue; } stu_model.Agency_id = agency_model.Agency_id; stu_model.Role_id = 3; stu_model.User_password = DESEncrypt.MD5Encrypt(number); if (stu_bll.GetModel(" User_number='" + number + "'") == null) { stu_model.User_id = stu_bll.Add(stu_model); if (stu_model.User_id == 0) { result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>"; error++; continue; } else { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel("User_number='" + number + "'"); BLL.CCOM.Student student_bll = new BLL.CCOM.Student(); Model.CCOM.Student student_model = new Model.CCOM.Student(); student_model.User_id = user_model.User_id; student_model.Period_id = 4; student_bll.Add(student_model); } } else { if (!stu_bll.Update(stu_model)) { result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>"; error++; continue; } } #endregion #region 更新导师信息========================== var tea_model = new Model.CCOM.Tutor(); //姓名 string tea_name = ds.Tables[0].Rows[i]["指导教师"].ToString().Trim(); if (!ValidDFValue(tea_name, true, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,指导教师" + checkmsg + "<br/>"; error++; continue; } else if (tea_name != "") { var tea_user_model = new BLL.CCOM.User_information().GetModel(" User_realname='" + tea_name + "'"); if (tea_user_model == null) { result += "×第" + (i + 1).ToString() + "行数据更新失败,指导教师" + tea_name + "不存在<br/>"; error++; continue; } tea_model = new BLL.CCOM.Tutor().GetModel(" User_id=" + tea_user_model.User_id); string title_name = ds.Tables[0].Rows[i]["职称"].ToString().Trim(); if (!ValidDFValue(title_name, true, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,职称" + checkmsg + "<br/>"; error++; continue; } else if (title_name != "") { var title_model = new BLL.CCOM.Title().GetModel(" Title_name='" + title_name + "'"); if (title_model == null) { result += "×第" + (i + 1).ToString() + "行数据更新失败,职称" + title_name + "不存在<br/>"; error++; continue; } tea_model.Title_id = title_model.Title_id; if (!new BLL.CCOM.Tutor().Update(tea_model)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,更新导师信息失败<br/>"; error++; continue; } } } #endregion #region 导入选题信息========================== string topic_name = ds.Tables[0].Rows[i]["毕业设计题目"].ToString().Trim(); if (!ValidDFValue(topic_name, true, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,题目名称" + checkmsg + "<br/>"; error++; continue; } else if (topic_name != "") { topic_model.Topic_name = topic_name; } string Topic_nature = ds.Tables[0].Rows[i]["题目性质"].ToString().Trim(); if (!ValidDFValue(Topic_nature, false, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,题目性质" + checkmsg + "<br/>"; error++; continue; } else if (Topic_nature != "") { topic_model.Topic_nature = Topic_nature; } string Topic_source = ds.Tables[0].Rows[i]["题目来源"].ToString().Trim(); if (!ValidDFValue(Topic_source, false, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,题目来源" + checkmsg + "<br/>"; error++; continue; } else if (Topic_source != "") { topic_model.Topic_source = Topic_source; } string Topic_content = ds.Tables[0].Rows[i]["题目详情"].ToString().Trim(); if (!ValidDFValue(Topic_content, false, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,题目详情" + checkmsg + "<br/>"; error++; continue; } else if (Topic_content != "") { topic_model.Topic_content = Topic_content; } string Topic_task = ds.Tables[0].Rows[i]["任务书"].ToString().Trim(); if (!ValidDFValue(Topic_task, false, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,任务书" + checkmsg + "<br/>"; error++; continue; } else if (Topic_task != "") { topic_model.Topic_task = Topic_task; } topic_model.Selected_state = true; topic_model.Check_state = 1; topic_model.Teacher_id = tea_model.User_id; topic_model.Company = "软件学院"; topic_model.Topic_id = topic_bll.Add(topic_model); if (topic_model.Topic_id == 0) { result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>"; error++; continue; } #endregion #region 题对应关系信息========================== if (rela_bll.GetModel(" Student_id=" + stu_model.User_id) != null && rela_bll.GetModel(" Student_id=" + stu_model.User_id).Accept_state != 2) { result += "×第" + (i + 1).ToString() + "行学生选题对应关系更新异常,该学生已经在系统有选题记录!<br/>"; error++; continue; } rela_model.Student_id = stu_model.User_id; rela_model.Teacher_id = tea_model.User_id; rela_model.Topic_id = topic_model.Topic_id; rela_model.Accept_state = 1; rela_model.Apply_time = DateTime.Now; rela_model.Topic_relation_id = rela_bll.Add(rela_model); if (rela_model.Topic_relation_id == 0) { result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>"; error++; continue; } else { success++; } #endregion } return(result); }
private bool UpdateTeacherInfo() { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(UserID); bool result = false; if (this.ddlGender.SelectedValue == "0") { user_model.User_gender = false; } else { user_model.User_gender = true; } if (this.txtPhone.Value != "") { user_model.User_phone = this.txtPhone.Value; } try { bool res = user_bll.Update(user_model); if (res == true) { result = true; } } catch { result = false; } BLL.CCOM.Tutor teacher_bll = new BLL.CCOM.Tutor(); Model.CCOM.Tutor teacher_model = teacher_bll.GetModel(" User_id=" + UserID); if (teacher_model != null) { if (this.ddlTitle.SelectedValue != "0") { teacher_model.Title_id = int.Parse(this.ddlTitle.SelectedValue); } if (this.txtSubject.Value != "") { teacher_model.Subject = this.txtSubject.Value; } if (this.txtEmail.Value != "") { teacher_model.Tutor_email = this.txtEmail.Value; } if (this.txtFixedPhone.Value != "") { teacher_model.Tutor_fixedphone = this.txtFixedPhone.Value; } if (this.txtPlace.Value != "") { teacher_model.Tutor_location = this.txtPlace.Value; } if (this.txtIntroduce.Value != "") { teacher_model.Tutor_introduce = this.txtIntroduce.Value; } if (teacher_bll.Update(teacher_model)) { result = true; } } else { teacher_model = new Model.CCOM.Tutor(); teacher_model.User_id = UserID; if (this.ddlTitle.SelectedValue != "0") { teacher_model.Title_id = int.Parse(this.ddlTitle.SelectedValue); } if (this.txtSubject.Value != "") { teacher_model.Subject = this.txtSubject.Value; } if (this.txtEmail.Value != "") { teacher_model.Tutor_email = this.txtEmail.Value; } if (this.txtFixedPhone.Value != "") { teacher_model.Tutor_fixedphone = this.txtFixedPhone.Value; } if (this.txtPlace.Value != "") { teacher_model.Tutor_location = this.txtPlace.Value; } if (this.txtIntroduce.Value != "") { teacher_model.Tutor_introduce = this.txtIntroduce.Value; } if (teacher_bll.Add(teacher_model) != 0) { result = true; } } return(result); }