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