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);
}
