private void showInfo() { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(id); if (user_model == null) { InnerRedirect(MyEnums.RediirectErrorEnum.ParameterError); } //this.txt_identity_number.Text = user_model.User_ID_number; this.txt_realname.Text = user_model.User_realname; if (user_model.User_birthday != null) { this.txtBirthday.Value = Convert.ToDateTime(user_model.User_birthday).ToString("yyyy-MM-dd"); } this.lbl_phone_number.Text = user_model.User_number; //this.ddl_identity_type.SelectedValue = user_model.User_ID_number_type.ToString(); if ((Boolean)user_model.User_gender) { this.ddl_Sex.SelectedIndex = 1; } //this.ddl_user_type.SelectedValue = user_model.User_type.ToString(); this.lbl_register_time.Text = Convert.ToDateTime(user_model.User_addtime).ToString("yyyy-MM-dd"); }
protected int ShowInfo() { Model.CCOM.User_information model = GetAdminInfo_CCOM(); long _id = model.User_id; int score_t = -1, score_c = -1, score_s = -1; BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(_id); if (user_model == null) { InnerRedirect(MyEnums.RediirectErrorEnum.ParameterError); } var relation_model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + _id); if (relation_model == null) { return(-1); } var comment_model = new BLL.CCOM.Comment().GetModel(" Topic_relation_id=" + relation_model.Topic_relation_id); try { score_t = (int)comment_model.Teacher_score; } catch { score_t = -1; } try { score_c = (int)comment_model.Reply_score; } catch { score_c = -1; } try { var soft_model = new BLL.CCOM.Software_accept().GetModel(" Topic_relation_id=" + relation_model.Topic_relation_id); score_s = (int)soft_model.Conclusion; } catch { score_s = -1; } if (score_c >= 0 && score_s >= 0 && score_t >= 0) { return(1); } else { return(0); } }
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); }
public void ShowOtherInfo() { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(UserID); if (user_model == null) { InnerRedirect(MyEnums.RediirectErrorEnum.ParameterError); } //真实姓名 if (user_model.User_realname == null) { txt_User_realname.Text = "请填写真实姓名"; } else { this.txt_User_realname.Text = user_model.User_realname; } int agency_id = 0; agency_id = user_model.Agency_id; BLL.CCOM.Agency user_agency_bll = new BLL.CCOM.Agency(); Model.CCOM.Agency user_agency_model = user_agency_bll.GetModel(agency_id); if (user_agency_model.Agency_id != 0) { txt_Agency.Text = user_agency_model.Agency_name; } else { div_user_agency.Visible = false; } //移动电话 this.txt_User_number.Text = user_model.User_number; //性别 if ((Boolean)user_model.User_gender) { this.rbl_User_gender.SelectedIndex = 1; } //出生日期 if (user_model.User_birthday == null) { txt_User_birthday.Text = "请填写出生日期"; } else { this.txt_User_birthday.Text = Convert.ToDateTime(user_model.User_birthday).ToString("yyyy-MM-dd"); } //添加日期 this.txt_User_addtime.Text = Convert.ToDateTime(user_model.User_addtime).ToString("yyyy-MM-dd"); }
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()); }
public string GetTeacherName(long id) { try { BLL.CCOM.User_information bll = new BLL.CCOM.User_information(); Model.CCOM.User_information model = bll.GetModel(id); return(model.User_realname); } catch { return("该教师用户不存在"); } }
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); }
public string GetTeacherName(string UserID) { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); string str = string.Empty; try { Model.CCOM.User_information user_model = user_bll.GetModel(" User_id='" + UserID + "'"); str = user_model.User_realname; } catch { str = "未设置"; } return(str); }
//public void BindRole() //{ // string sql = "Role_status = 1"; // BLL.CCOM.Role bll = new BLL.CCOM.Role(); // DataSet ds = bll.GetList(sql); // this.ddlRole.DataSource = ds.Tables[0].DefaultView; // this.ddlRole.DataTextField = "Role_name"; // this.ddlRole.DataValueField = "Role_id"; // this.ddlRole.DataBind(); // ListItem item = new ListItem("--请选择角色--", "#"); // this.ddlRole.Items.Insert(0, item); //} #region 赋值操作================================= private void ShowInfo(long UserId) { var bll = new BLL.CCOM.User_information(); var model = bll.GetModel("User_id=" + UserId); this.rblSex.SelectedIndex = (model.User_gender == true) ? 1 : 0; this.txtMobile.Text = model.User_number; this.txtRealname.Text = model.User_realname; //if (model.User_ID_number_type != null) // this.ddlIdType.SelectedIndex = model.User_ID_number_type.Value; //this.txtIdNumber.Text = model.User_ID_number; if (model.User_birthday != null) { this.txtBirthday.Value = ((DateTime)model.User_birthday).ToString("yyyy-MM-dd"); } this.ddlAgency.SelectedValue = model.Agency_id.ToString(); this.ddlRole.SelectedValue = model.Role_id.ToString(); }
protected void showStudentInfo() { BLL.CCOM.User_information ubll = new BLL.CCOM.User_information(); BLL.CCOM.User_property pbll = new BLL.CCOM.User_property(); List <Model.CCOM.Examination_arrangement_detail> EadList = new BLL.CCOM.Examination_arrangement_detail().GetModelList(" Ea_id=" + examId); int num = 0; TableRow studentRow = new TableRow(); foreach (Model.CCOM.Examination_arrangement_detail EadModel in EadList) { num++; var umodel = ubll.GetModel(EadModel.User_id); var pmodel = pbll.GetModel("User_id=" + EadModel.User_id); TableCell studentCell = new TableCell(); studentCell.HorizontalAlign = HorizontalAlign.Center; studentRow.Cells.Add(studentCell); Image upPicture = new Image(); upPicture.ImageUrl = "../../.." + pmodel.UP_picture; upPicture.Width = 60; studentCell.Controls.Add(upPicture); Panel panel1 = new Panel(); studentCell.Controls.Add(panel1); Label upCcomNum = new Label(); upCcomNum.Text = pmodel.UP_CCOM_number; panel1.Controls.Add(upCcomNum); Panel panel2 = new Panel(); studentCell.Controls.Add(panel2); Label name = new Label(); name.Text = umodel.User_realname; panel2.Controls.Add(name); if (num % 6 == 0) { studentTable.Rows.Add(studentRow); studentRow = new TableRow(); } } if (num % 6 != 0) { studentTable.Rows.Add(studentRow); } }
/// <summary> /// 判断管理员是否已经登录(解决Session超时问题) /// </summary> public bool IsAdminLogin() { //如果Session为Null if (Session[MyKeys.SESSION_ADMIN_INFO] != null) { return(true); } else { //检查Cookies //Cookie存储 时间,ID 加密后的内容 手动计算过期时间 string CookieID = Utils.GetCookie("UniversityLoginInfo"); if (CookieID != "") { CookieID = DESEncrypt.Decrypt(CookieID); try { DateTime dt = Convert.ToDateTime(CookieID.Split(',')[0]); if (dt.Date.Date == DateTime.Now.Date) { CookieID = CookieID.Split(',')[1]; BLL.CCOM.User_information bll = new BLL.CCOM.User_information(); Model.CCOM.User_information model = bll.GetModel(Convert.ToInt64(CookieID)); /* * Model.admin.View_AdminUser model = new BLL.admin.View_AdminUser().GetModel(Convert.ToInt64(CookieID)); */ if (model != null) { Session[MyKeys.SESSION_ADMIN_INFO] = model; Session[MyKeys.SESSION_USER_STATUSID] = model.User_id.ToString(); return(true); } return(true); } } catch { } } } return(false); }
protected void InitView() { Model.CCOM.Reply_group model = new BLL.CCOM.Reply_group().GetModel(Group_id); if (model != null) { try { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = new Model.CCOM.User_information(); this.txtGroupName.Text = model.Group_name; this.txtReplyTime.Value = model.Reply_time.ToString("yyyy-MM-dd HH:mm:ss"); this.txtReplyRoom.Text = model.Reply_room; user_model = user_bll.GetModel(model.User_id); this.txtTeaNumber.Text = user_model.User_number; this.ddltype.SelectedValue = model.Group_type.ToString(); } catch { } } }
protected void showStudentInfo() { BLL.CCOM.User_information ubll = new BLL.CCOM.User_information(); BLL.CCOM.User_property pbll = new BLL.CCOM.User_property(); List <Model.CCOM.Examination_arrangement_detail> EadList = new BLL.CCOM.Examination_arrangement_detail().GetModelList(" Ea_id=" + examId); int num = 0; foreach (Model.CCOM.Examination_arrangement_detail EadModel in EadList) { TableRow studentRow = new TableRow(); studentTable.Rows.Add(studentRow); var umodel = ubll.GetModel(EadModel.User_id); var pmodel = pbll.GetModel("User_id=" + EadModel.User_id); TableCell numCell = new TableCell(); numCell.HorizontalAlign = HorizontalAlign.Center; studentRow.Cells.Add(numCell); TableCell idCell = new TableCell(); idCell.HorizontalAlign = HorizontalAlign.Center; studentRow.Cells.Add(idCell); TableCell nameCell = new TableCell(); nameCell.HorizontalAlign = HorizontalAlign.Center; studentRow.Cells.Add(nameCell); TableCell scoreCell = new TableCell(); scoreCell.HorizontalAlign = HorizontalAlign.Center; studentRow.Cells.Add(scoreCell); TableCell chapterCell = new TableCell(); studentRow.Cells.Add(chapterCell); Label numLabel = new Label(); numLabel.Text = (++num).ToString(); numCell.Controls.Add(numLabel); Label upCcomNum = new Label(); upCcomNum.Text = pmodel.UP_CCOM_number; idCell.Controls.Add(upCcomNum); Label name = new Label(); name.Text = umodel.User_realname; nameCell.Controls.Add(name); Label chapter = newChapterLabel(umodel.User_id); chapterCell.Controls.Add(chapter); } }
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 "); } }
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); }
protected void ShowInfo() { int score_t = -1, score_c = -1, score_s = -1; BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel(_id); if (user_model == null) { InnerRedirect(MyEnums.RediirectErrorEnum.ParameterError); } //真实姓名 if (user_model.User_realname == null) { txt_User_realname.Text = "请填写真实姓名"; } else { this.txt_User_realname.Text = user_model.User_realname; } this.txt_User_number.Text = user_model.User_number; var relation_model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + _id); if (relation_model == null) { return; } var comment_model = new BLL.CCOM.Comment().GetModel(" Topic_relation_id=" + relation_model.Topic_relation_id); try { score_t = (int)comment_model.Teacher_score; this.txtTeacherScore.Text = comment_model.Teacher_score.ToString(); } catch { this.txtTeacherScore.Text = "未评分"; } try { score_c = (int)comment_model.Reply_score; float sc = GetUser_CommentScore(_id); if (sc != -1) { this.txtCommentScore.Text = sc.ToString(); } else { this.txtCommentScore.Text = "未评分"; } this.lblComment.HRef = "CommentPage.aspx?userId=" + DESEncrypt.Encrypt(_id.ToString()); } catch { this.txtCommentScore.Text = "未评分"; } try { var soft_model = new BLL.CCOM.Software_accept().GetModel(" Topic_relation_id=" + relation_model.Topic_relation_id); score_s = (int)soft_model.Conclusion; this.txtScoftwareScore.Text = soft_model.Conclusion.ToString(); this.lblSoft.HRef = "SoftwarePage.aspx?userId=" + DESEncrypt.Encrypt(_id.ToString()); } catch { this.txtScoftwareScore.Text = "未评分"; } if (score_c >= 0 && score_s >= 0 && score_t >= 0) { var model = new BLL.CCOM.Comput_score().GetModel(1); decimal score = 0; if (model.Ratio_software == 0) { score = score_t * model.Ratio_teacher + (int)((score_s < score_c ? score_s : score_c) * model.Ratio_review); } else { score = score_t * model.Ratio_teacher + (int)((score_s > score_c ? score_s : score_c) * model.Ratio_review); } this.txtScore.Text = score.ToString(); } }
/// <summary> /// 根据与用户相关的推送通知 /// </summary> /// <param name="context"></param> public void GetUserNotice(HttpContext context) { try { if (!IsAdminLogin()) { FlushResponse(context, JsonConvert.SerializeObject(new ReturnObject() { Result = ERROR, Msg = "error" })); return; } var userId = GetAdminInfo().User_id; //var topN = 10; //var pushNewsItemList = new List<NoticeItem>(); string notice_type = context.Request.Params["notice_type"]; int page = int.Parse(context.Request.Params["page"]); var model = new BLL.CCOM.User_notice().GetModel("User_id=" + userId); if(notice_type!=null&¬ice_type!="") { StringBuilder ulSb = new StringBuilder(); string[] notice_ids=null; if (notice_type == "no_read") { string ids = model.Notice_id; if(ids!=null&&ids.Length>0&&ids!="") { notice_ids = ids.Split(','); } } else { string ids =model.Notice_read_id; if (ids != null && ids.Length > 0 && ids != "") { notice_ids = ids.Split(','); } } var sb = new StringBuilder(); if (notice_ids!=null&¬ice_ids.Length > 0) { for (int i = 0; i < notice_ids.Length; i++) { if (i == 0) { sb.Append("Notice_id=" + notice_ids[i]); } else { sb.Append(" or Notice_id=" + notice_ids[i]); } } int start_index = pageSize * (page - 1) + 1; int end_index = pageSize * page; DataTable dt = new BLL.CCOM.Notice().GetListByPage(sb.ToString(), "Notice_date DESC ", start_index, end_index).Tables[0]; if (dt.Rows.Count > 0) { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); string realname = string.Empty; foreach (DataRow dr in dt.Rows) { var content = ""; content = "<a href=\"ViewNotice.aspx?id=" + DESEncrypt.Encrypt(dr["Notice_id"].ToString()) + "\" target=\"_blank\">"; content += dr["Notice_title"] + "</a>"; content += "<br />"; content += dr["Notice_content"]; try { realname = user_bll.GetModel(Convert.ToInt32(dr["Notice_sender_id"])).User_realname; } catch { realname = "---"; } ulSb.Append("<li>"); ulSb.Append("<div class=\"media\">"); ulSb.Append("<span class=\"label pull-left label-success\"><i class=\"icon-bell\"></i></span>"); ulSb.Append("<div class=\"media-body\">"); ulSb.Append("<div class=\"notice-collapse\" style=\"padding: 5px;\">"); ulSb.Append("<div class=\"text\" style=\"padding: 2px 4px; text-decoration: none;\">"); ulSb.Append(" <p style=\"font-weight:bold;\">" + content + "</p>"); ulSb.Append(" <p class=\"attribution\">" + realname + " " + ((DateTime)dr["Notice_date"]).ToString("yyyy-MM-dd HH:mm") + "</p>"); ulSb.Append("</div>"); ulSb.Append("</div>"); ulSb.Append("</div>"); ulSb.Append("</div>"); ulSb.Append("</li>"); } } else { ulSb.Append("<li style=\"height:40px;font-size:18px;text-align:center;padding-top:21px;\">暂无通知消息!</li>"); } } else { ulSb.Append("<li style=\"height:40px;font-size:18px;text-align:center;padding-top:21px;\">暂无通知消息!</li>"); } context.Response.Write(ulSb.ToString()); //string json = ToJson(dt); } else//传参不正确 { } } catch (Exception ex) { String logContent = "GetUserNotice-"; logContent += "Ex:" + ex.ToString() + "\r\n"; Common.FileOperate.WriteFile(context.Server.MapPath("error-" + DateTime.Now.ToString("yyyyMMdd") + ".txt"), logContent); FlushResponse(context, JsonConvert.SerializeObject(new ReturnObject() { Result = ERROR, Msg = "error" })); } }
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); }
private string DoAction() { string result = ""; BLL.CCOM.Reply_group bll = new BLL.CCOM.Reply_group(); Model.CCOM.Reply_group model; if (action != MyEnums.ActionEnum.Edit.ToString()) { model = new Model.CCOM.Reply_group(); } else { model = bll.GetModel(Group_id); } string GroupName = this.txtGroupName.Text.Trim(); string TeaNumber = this.txtTeaNumber.Text.Trim(); // string Time = this.txtReplyTime.Text.Trim(); string Room = this.txtReplyRoom.Text.Trim(); string Goup_type = this.ddltype.SelectedValue; //必填部分 if (Tools.CheckParams(GroupName + TeaNumber + Room)) { return("请勿输入非法字符"); } if (GroupName == "") { return("请填答辩组名称"); } if (TeaNumber == "") { return("请填组长工号"); } if (this.txtReplyTime.Value == "") { return("请填写答辩时间"); } if (Room == "") { return("请填写答辩地点"); } if (Goup_type == "#") { return("请选择答辩类型"); } else if (Goup_type == "0") { model.Group_type = 0; } else if (Goup_type == "1") { model.Group_type = 1; } else if (Goup_type == "2") { model.Group_type = 2; } model.Group_name = GroupName; model.Reply_time = Convert.ToDateTime(this.txtReplyTime.Value);; model.Reply_room = Room; BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information uset_model; uset_model = user_bll.GetModel("User_number='" + TeaNumber + "'and Role_id!=3"); if (uset_model == null) { return("该教师用户不存在"); } else { model.User_id = uset_model.User_id; } 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); }
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 void RptBind() { int pageSize = 10; //每页数量 int page = MyRequest.GetQueryInt("page", 1); string keywords = this.keywords; //MyRequest.GetQueryString("keywords"); int start_index = pageSize * (page - 1) + 1; int end_index = pageSize * page; this.txtKeywords.Value = keywords; StringBuilder ulSb = new StringBuilder(); //获取该用户的所有未读通知Id BLL.CCOM.User_notice bll = new BLL.CCOM.User_notice(); Model.CCOM.User_notice model = bll.GetModel(" User_id=" + GetAdminInfo_CCOM().User_id); if (model != null) { string all_news_id = string.Empty; if (type == 0) { all_news_id = model.Notice_id; this.no_read.Style.Value = "background-color:#a5d16c"; this.read.Style.Value = "background-color:lightgrey"; } else { all_news_id = model.Notice_read_id; this.read.Style.Value = "background-color:#a5d16c"; this.no_read.Style.Value = "background-color:lightgrey"; } if (all_news_id.Length > 0) { string[] ids = all_news_id.Split(','); string strWhere = string.Empty; if (keywords != null && keywords.Length > 0) { strWhere += " Notice_content like '%" + keywords + "%' "; } else { strWhere += " 1=1"; } if (ids.Length > 0) { for (int i = 0; i < ids.Length; i++) { if (i == 0) { strWhere += " and ( Notice_id=" + ids[i]; } else { strWhere += " or Notice_id=" + ids[i]; } } strWhere += " )"; //获取通知信息 BLL.CCOM.Notice bll_notice = new BLL.CCOM.Notice(); int totalCount = bll_notice.GetRecordCount(strWhere); //计算数量 DataTable dt = bll_notice.GetListByPage(strWhere, "Notice_date DESC", start_index, end_index).Tables[0]; //绑定当页 long userId = GetAdminInfo_CCOM().User_id; if (dt.Rows.Count > 0) { BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); string realname = string.Empty; foreach (DataRow dr in dt.Rows) { var content = ""; content = "<a href=\"ViewNotice.aspx?id=" + DESEncrypt.Encrypt(dr["Notice_id"].ToString()) + "\" target=\"_blank\">"; content += dr["Notice_title"] + "</a>"; content += "<br />"; content += dr["Notice_content"]; try { realname = user_bll.GetModel(Convert.ToInt32(dr["Notice_sender_id"])).User_realname; } catch { realname = "---"; } ulSb.Append("<li>"); ulSb.Append("<div class=\"media\">"); ulSb.Append("<span class=\"label pull-left label-success\"><i class=\"icon-bell\"></i></span>"); ulSb.Append("<div class=\"media-body\">"); ulSb.Append("<div class=\"notice-collapse\" style=\"padding: 5px;\">"); ulSb.Append("<div class=\"text\" style=\"padding: 2px 4px; text-decoration: none;\">"); ulSb.Append(" <p style=\"font-weight:bold;\">" + content + "</p>"); ulSb.Append(" <p class=\"attribution\">" + realname + " " + ((DateTime)dr["Notice_date"]).ToString("yyyy-MM-dd HH:mm") + "</p>"); ulSb.Append("</div>"); ulSb.Append("</div>"); ulSb.Append("</div>"); ulSb.Append("</div>"); ulSb.Append("</li>"); } //this.page_size.Style.Add("display", ""); } else { //this.page_size.Style.Add("display", "none"); ulSb.Append("<li style=\"height:40px;font-size:18px;text-align:center;padding-top:21px;\">暂无通知消息!</li>"); } //绑定页码 string pageUrl = Utils.CombUrlTxt("Notice_list.aspx", "keywords={0}&page={1}&fun_id={2}&type={3}", this.keywords, "__id__", DESEncrypt.Encrypt(this.fun_id), DESEncrypt.Encrypt(this.type.ToString())); this.PageContent.InnerHtml = Utils.OutPageList(pageSize, page, totalCount, pageUrl, 8, true); } } else { ulSb.Append("<li style=\"height:40px;font-size:18px;text-align:center;padding-top:21px;\">暂无通知消息!</li>"); //this.page_size.Style.Add("display", "none"); } } else//为空则创建该用户 { Model.CCOM.User_notice user_notice_model = new Model.CCOM.User_notice(); user_notice_model.User_id = GetAdminInfo_CCOM().User_id; bll.Add(user_notice_model); } this.noticeList.InnerHtml = ulSb.ToString(); }
protected void btnSubmit_Click(object sender, EventArgs e) { string cookie = Utils.GetCookie("try_time"); //if (!string.IsNullOrEmpty(Utils.GetCookie("try_time")) && int.Parse(Utils.GetCookie("try_time")) > TryNumber) //{ // this.lblTip.Text = "您尝试次数超过限制,请3分钟后再试"; // Session[MyKeys.NEED_VCODE] = 0; // this.txtCode.Text = ""; // return; //} //else { string userName = txtUserName.Text.Trim(); //string userStuNo = this.txtStuNo.Text.Trim(); string userPwd = txtUserPwd.Text.Trim(); //string code = txtCode.Text.Trim(); if (Tools.CheckParams(userName)) { lblTip.Visible = true; lblTip.Text = "请勿输入非法字符"; this.txtCode.Text = ""; return; } //用户名登录 if (userName.Equals("") || userPwd.Equals("")) { lblTip.Visible = true; lblTip.Text = "请输入用户名或密码"; this.txtCode.Text = ""; return; } if (userName.Length > 200) { lblTip.Visible = true; lblTip.Text = "用户名不合法"; this.txtCode.Text = ""; return; } if (userPwd.Length > 200) { lblTip.Visible = true; lblTip.Text = "密码不合法"; return; } //需要验证码 if (this.showVCode.Value == "1") { string code = this.txtCode.Text.Trim(); if (code.Equals("")) { lblTip.Visible = true; lblTip.Text = "请输入验证码"; this.txtCode.Text = ""; return; } if (Session[MyKeys.SESSION_CODE] == null) { lblTip.Visible = true; lblTip.Text = "系统找不到验证码"; this.txtCode.Text = ""; return; } if (code.ToLower() != Session[MyKeys.SESSION_CODE].ToString().ToLower()) { lblTip.Visible = true; lblTip.Text = "验证码输入不正确"; this.txtCode.Text = ""; return; } } BLL.CCOM.User_information bll = new BLL.CCOM.User_information(); Model.CCOM.User_information model = null; string sql = "User_number='" + userName + "' and User_password='******'"; //string sql = "User_number='" + userName + "'"; model = bll.GetModel(sql); //model = bll.GetModel(userName, DESEncrypt.MD5Encrypt(userPwd));//敏感字段 if (model == null) { lblTip.Text = "用户名或密码有误"; this.txtCode.Text = ""; lblTip.Visible = true; ////记录错误次数 if (Session[MyKeys.NEED_VCODE] == null) { Session[MyKeys.NEED_VCODE] = 1; } else { int num = (int)Session[MyKeys.NEED_VCODE]; Session[MyKeys.NEED_VCODE] = (int)Session[MyKeys.NEED_VCODE] + 1; if ((int)Session[MyKeys.NEED_VCODE] == TryNumber) { this.showVCode.Value = "1"; this.show_code.Style["display"] = "block"; //Utils.WriteCookie("try_time",((int)Session[MyKeys.NEED_VCODE]).ToString(),3); } } return; } if (model != null) { if (model.User_status == false) { lblTip.Text = "用户已禁用"; model = null; return; } else { //写入Cookies if (cbRememberId.Checked) { Utils.WriteCookie(MyKeys.COOKIE_USER_NAME_REMEMBER, userName, 144000); } else { Utils.WriteCookie(MyKeys.COOKIE_USER_NAME_REMEMBER, userName, -144000); } } } //写入登录方式的cookie Utils.WriteCookie(MyKeys.COOKIE_USER_LOGINTYPE_REMEMBER, this.showLoginTab.Value, 144000); Session[MyKeys.NEED_VCODE] = null; Session[MyKeys.SESSION_ADMIN_INFO] = model; Session.Timeout = 600; Utils.WriteCookie("UniversityLoginInfo", DESEncrypt.Encrypt(DateTime.Now.Date.ToString() + "," + model.User_id), 1200); Response.Redirect("index.aspx"); return; } }
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 string ImportDataItem(DataSet ds, ref int success, ref int error)//基础数据 { string result = ""; BLL.CCOM.User_information bll = new BLL.CCOM.User_information(); Model.CCOM.User_information model = new Model.CCOM.User_information(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string checkmsg = null; //姓名 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 != "") { model.User_realname = name; } //学号/工号 string mobile = ds.Tables[0].Rows[i]["学号/工号"].ToString().Trim(); if (!Validator.IsMobile(mobile)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,学号/工号要为整数<br/>"; error++; continue; } if (!ValidDFValue(mobile, true, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,学号/工号" + checkmsg + "<br/>"; error++; continue; } else if (bll.GetRecordCount(" User_number='" + mobile + "'") > 0) { result += "×第" + (i + 1).ToString() + "行数据更新失败,该学号/工号已被添加<br/>"; error++; continue; } else if (mobile != "") { model.User_number = mobile; } //性别 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 == "男") { model.User_gender = false; } else if (gender == "女") { model.User_gender = true; } //机构 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; } model.Agency_id = agency_model.Agency_id; //角色 string role = ds.Tables[0].Rows[i]["角色"].ToString().Trim(); if (!ValidDFValue(role, true, "", ref checkmsg)) { result += "×第" + (i + 1).ToString() + "行数据更新失败,角色<br/>"; error++; continue; } BLL.CCOM.Role role_bll = new BLL.CCOM.Role(); Model.CCOM.Role role_model = new Model.CCOM.Role(); role_model = role_bll.GetModel(" Role_name='" + role + "'"); if (role_model == null) { result += "×第" + (i + 1).ToString() + "行数据更新失败,用户角色不存在<br/>"; error++; continue; } model.Role_id = role_model.Role_id; //生日 //string birthday = ds.Tables[0].Rows[i]["生日"].ToString().Trim(); //if (!ValidDFValue(birthday, false, "", ref checkmsg)) //{ // result += "×第" + (i + 1).ToString() + "行数据更新失败,生日" + checkmsg + "<br/>"; // error++; // continue; //} //else if (birthday != "") //{ // if (!Validator.IsBirthday(birthday)) // { // result += "×第" + (i + 1).ToString() + "行数据更新失败,生日格式不对<br/>"; // error++; // continue; // } // model.User_birthday = Convert.ToDateTime(birthday); //} //model.User_password = mobile; ////教师职称 //string title = ds.Tables[0].Rows[i]["教师职称"].ToString().Trim(); //BLL.CCOM.Title title_bll = new BLL.CCOM.Title(); //Model.CCOM.Title title_model = new Model.CCOM.Title(); //title_model = title_bll.GetModel(" Title_name='" + title + "'"); //if (title_model == null) //{ // result += "×第" + (i + 1).ToString() + "行数据更新失败,该教师职称不存在<br/>"; // error++; // continue; //} //else if (!ValidDFValue(title, true, "", ref checkmsg)) //{ // result += "×第" + (i + 1).ToString() + "行数据更新失败,教师职称<br/>"; // error++; // continue; //} model.User_password = DESEncrypt.MD5Encrypt(mobile); if (bll.Add(model) == 0) { result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>"; error++; continue; } else { success++; BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information(); Model.CCOM.User_information user_model = user_bll.GetModel("User_number='" + mobile + "'"); if (model.Role_id == 2) //如果为指导教师,插入Tutor表 { BLL.CCOM.Tutor tutor_bll = new BLL.CCOM.Tutor(); Model.CCOM.Tutor tutor_model = new Model.CCOM.Tutor(); tutor_model.User_id = user_model.User_id; tutor_model.Title_id = 1; tutor_bll.Add(tutor_model); } if (model.Role_id == 3)//如果为学生,插入Student表 { 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); } } } 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 void btnPhoneCode_Click(object sender, EventArgs e) { 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; } } if (Session[MyKeys.SESSION_PHONE_CODE_TIME] != null) { DateTime dt = (DateTime)Session[MyKeys.SESSION_PHONE_CODE_TIME]; if (dt.Add(new TimeSpan(0, 0, 60)) > DateTime.Now) { this.lblReInfo.Text = "请您60秒后再获取手机验证码!"; return; } } //发送验证码 String code = Utils.Number(6); Session[MyKeys.SESSION_PHONE_CODE] = code; Session[MyKeys.SESSION_PHONE_CODE_TIME] = DateTime.Now; ManDaoSMS.SendSMS(phone, GetVCodeSms(model.User_realname, code)); this.lblReInfo.Text = "手机验证码已发送到您的手机!"; this.hidIsTick.Value = "1"; }