protected void btn_CreatTable_Click(object sender, EventArgs e) { SHUniversity.KPI.Model.Users u = (SHUniversity.KPI.Model.Users)Session["SHUUser"]; //lb_msg bool r = kpiBll.Exists(u.WorkID, DateTime.Now.Year); if (r) { Jscript.Alert("本年度已经创建了考核表,不能重复创建"); } else { SHUniversity.KPI.Model.UserKPI kpi = new SHUniversity.KPI.Model.UserKPI(); kpi.CreatDate = DateTime.Now; kpi.Creator = u.Name; kpi.KPINumber = SHUniversity.KPI.Common.CreatRandom(); kpi.KPIYear = DateTime.Now.Year; kpi.Status = 0;//0未审核1正在审核2审核通过3退回 kpi.WorkID = u.WorkID; int result = kpiBll.Add(kpi); if (result > 0) { Jscript.AlertAndRedirect("建表成功", "/Home.aspx"); } else { } } }
/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void butSava_Click(object sender, EventArgs e) { SHUniversity.KPI.Model.Users u = new SHUniversity.KPI.Model.Users(); u.ID = int.Parse(hidid.Value); u.BrithDay = SHUniversity.KPI.Common.ConvertDatetime(txt_birthday.Text.Trim()); u.CreatDate = DateTime.Now; u.Email = txt_email.Text.Trim(); u.InDate = Common.ConvertDatetime(txt_indate.Text.Trim()); u.Moblie = txt_moblie.Text.Trim(); u.Name = txt_name.Text.Trim(); u.Password = txt_pwd.Text.Trim(); u.Ramerk = txt_common.Text.Trim(); u.Satat = 1; u.Sex = int.Parse(rb_sex.SelectedValue); u.Tel = txt_tell.Text.Trim(); u.UserType = int.Parse(rb_usertype.SelectedValue); u.WorkID = txt_workID.Text.Trim(); u.Xueli = txt_xueli.Text.Trim(); u.Xuexiao = txt_xuexiao.Text.Trim(); u.Zhiwu = txt_zhiwu.Text.Trim(); bool result = uBll.Update(u); if (result) { Jscript.RedirectToFrames("UserManage.aspx"); } else { Jscript.Alert("修改异常,请重试"); Jscript.RedirectToFrames("UserManage.aspx"); } }
protected void rp_main_ItemCommand(object source, RepeaterCommandEventArgs e) { SHUniversity.KPI.Model.Users currUser = Session["SHUUser"] as SHUniversity.KPI.Model.Users; string parma = e.CommandArgument.ToString(); //0未提交1正在审核2审核通过3退回 if (e.CommandName == "pass") { bool r = kpiBll.ChangeStatus(parma, 2, currUser.Name, currUser.WorkID); if (r) { Jscript.Alert("审核成功"); } else { Jscript.Alert("审核失败,稍后再试"); } } if (e.CommandName == "back") { bool r = kpiBll.ChangeStatus(parma, 3, currUser.Name, currUser.WorkID); if (r) { Jscript.Alert("审核成功"); } else { Jscript.Alert("审核失败,稍后再试"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["SHUUser"] == null) { Jscript.AlertAndRedirect("未登录或登录超时,请重新登录", "/Login.aspx"); Response.End(); } u = (SHUniversity.KPI.Model.Users)Session["SHUUser"]; if (!IsPostBack) { //lb_msg bool r = kpiBll.Exists(u.WorkID, DateTime.Now.Year); if (r) { lb_msg.Text = "已建表"; lb_msg.ForeColor = System.Drawing.Color.Green; btn_CreatTable.Enabled = false; } else { lb_msg.Text = "未建表"; lb_msg.ForeColor = System.Drawing.Color.Red; btn_CreatTable.Enabled = true; } rp_table.DataSource = kpiBll.GetList(" WorkID='" + u.WorkID + "'").Tables[0]; rp_table.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { SHUniversity.KPI.Model.Users currUser = new SHUniversity.KPI.Model.Users(); if (Session["SHUAdmin"] == null && Session["SHUManage"] == null) { Jscript.AlertAndRedirect("未登录或登录超时,请重新登录", "/Login.aspx"); Response.End(); } else { currUser = Session["SHUUser"] as SHUniversity.KPI.Model.Users; } Tid = Common.StrToInt(Request.QueryString["id"], -1); if (Tid < 0) { Jscript.AlertAndRedirect("无法找到考核表信息", "../Home.aspx"); return; } List <SHUniversity.KPI.Model.KPIItems> list = bll.GetModelList(" KPINO= " + Tid); if (list.Count > 0) { rp_cxsy.DataSource = list.Where(m => m.ItemType == "大学生创新实验项目").ToList(); rp_cxsy.DataBind(); rp_xkjs.DataSource = list.Where(m => m.ItemType == "学科竞赛").ToList(); rp_xkjs.DataBind(); rp_dsz.DataSource = list.Where(m => m.ItemType == "导师制").ToList(); rp_dsz.DataBind(); rp_jxgg.DataSource = list.Where(m => m.ItemType == "教学改革").ToList(); rp_jxgg.DataBind(); rp_jxhj.DataSource = list.Where(m => m.ItemType == "教学获奖").ToList(); rp_jxhj.DataBind(); rp_jxlw.DataSource = list.Where(m => m.ItemType == "教学论文").ToList(); rp_jxlw.DataBind(); rp_KYXM.DataSource = list.Where(m => m.ItemType == "科研项目").ToList(); rp_KYXM.DataBind(); rp_KYLW.DataSource = list.Where(m => m.ItemType == "科研论文").ToList(); rp_KYLW.DataBind(); rp_KYCB.DataSource = list.Where(m => m.ItemType == "著作出版").ToList(); rp_KYCB.DataBind(); rp_KJJL.DataSource = list.Where(m => m.ItemType == "科技奖励").ToList();// rp_KJJL.DataBind(); rp_KL.DataSource = list.Where(m => m.ItemType == "专利").ToList(); rp_KL.DataBind(); } }
protected void Image1_ServerClick(object sender, ImageClickEventArgs e) { //userBll string loginName = this.TextBox1.Text.Trim(); string password = this.TextBox2.Text.Trim(); if (string.IsNullOrEmpty(loginName) || string.IsNullOrEmpty(password)) { lb_msg.Text = "用户名/密码不能为空"; } else { SHUniversity.KPI.Model.Users user = userBll.Login(loginName, password); if (user == null) { lb_msg.Text = "用户名/密码错误"; } else { //用户类型 99:管理员 0员工1管理 if (user.UserType == 99) { Session["SHUAdmin"] = user; Session["SHUUser"] = user; Response.Redirect("~/admin/main.aspx"); } if (user.UserType == 0) { Session["SHUUser"] = user; Response.Redirect("~/Home.aspx"); } if (user.UserType == 1) { Session["SHUManage"] = user; Session["SHUUser"] = user; Response.Redirect("~/Manager.aspx"); } else { Jscript.AlertAndRedirect("用户信息错误", "/Login.aspx"); } } } }
protected void butSava_Click(object sender, EventArgs e) { try { if (ubll.Exists(txt_workID.Text.Trim())) { Jscript.Alert("已经存在的工号"); return; } //添加用户 SHUniversity.KPI.Model.Users u = new SHUniversity.KPI.Model.Users(); u.BrithDay = SHUniversity.KPI.Common.ConvertDatetime(txt_birthday.Text.Trim()); u.CreatDate = DateTime.Now; u.Email = txt_email.Text.Trim(); u.InDate = Common.ConvertDatetime(txt_indate.Text.Trim()); u.Moblie = txt_moblie.Text.Trim(); u.Name = txt_name.Text.Trim(); u.Password = txt_pwd.Text.Trim(); u.Ramerk = txt_common.Text.Trim(); u.Satat = 1; u.Sex = int.Parse(rb_sex.SelectedValue); u.Tel = txt_tell.Text.Trim(); u.UserType = int.Parse(rb_usertype.SelectedValue); u.WorkID = txt_workID.Text.Trim(); u.Xueli = txt_xueli.Text.Trim(); u.Xuexiao = txt_xuexiao.Text.Trim(); u.Zhiwu = txt_zhiwu.Text.Trim(); if (ubll.Add(u) > 0) { Jscript.AlertAndRedirect("添加成功!", "AddUser.aspx"); } else { Jscript.Alert("添加失败请重试"); } } catch (Exception ex) { Jscript.Alert("异常信息:" + ex.Message); } }
string op; //操作 protected void Page_Load(object sender, EventArgs e) { if (Session["SHUUser"] == null) { Jscript.AlertAndRedirect("未登录或登录超时,请重新登录", "/Login.aspx"); Response.End(); } else { currUser = Session["SHUUser"] as SHUniversity.KPI.Model.Users; string id = Request.QueryString["id"]; //TODO:验证该考核表是否属于这个用户 TableID = Common.StrToInt(id, -1); if (TableID < 0) { Jscript.AlertAndRedirect("无法找到考核表信息", "../Home.aspx"); return; } if (!kpibll.Exists(TableID, currUser.WorkID)) { Jscript.AlertAndRedirect("考核表与用户信息不匹配", "../Home.aspx"); return; } if (!kpibll.isEdit(TableID)) { Jscript.AlertAndRedirect("考核表只有在未提交和驳回的时候才可以修改", "../Home.aspx"); return; } if (!IsPostBack) { op = Request.QueryString["op"]; string cid = Request.QueryString["cxsyid"]; //根据操作参数判断是新增、删除、编辑 int cxsyid; //itemID int.TryParse(cid, out cxsyid); if (op == "edit") //编辑----初始赋值 { SHUniversity.KPI.Model.KPIItems m = bll.GetModel(cxsyid, currUser.WorkID); if (m != null) { hid_cid.Value = cxsyid.ToString(); //何年月至何年月 ddl_pstartyear.SelectedValue = m.Int1.ToString(); //开始年 ddl_pstartmonth.SelectedValue = m.Int2.ToString(); //开始月 txtProjectName.Text = m.ProjectName; //论文题目 ddl_ptype.SelectedValue = m.ProjectType; //期刊类别 txtChubanshe.Text = m.ProjectNO; //杂志出版社 txtJuanqi.Text = m.ItemNO; //卷期 txtShijian.Text = m.Str1; //时间 //int3 自己是第几作者(从0开始) Int4 是否是学生 Int5是否通讯作者 txtJS1.Text = m.Str2.Split('|')[0]; txtJS2.Text = m.Str3.Split('|')[0]; txtJS3.Text = m.Str4.Split('|')[0]; txtJS4.Text = m.Str5.Split('|')[0]; txtJS5.Text = m.Str6.Split('|')[0]; if (m.Str2.Split('|')[1] == "1") { cb_iss_1.Checked = true; } else { cb_iss_1.Checked = false; } if (m.Str3.Split('|')[1] == "1") { cb_iss_2.Checked = true; } else { cb_iss_2.Checked = false; } if (m.Str4.Split('|')[1] == "1") { cb_iss_3.Checked = true; } else { cb_iss_3.Checked = false; } if (m.Str5.Split('|')[1] == "1") { cb_iss_4.Checked = true; } else { cb_iss_4.Checked = false; } if (m.Str6.Split('|')[1] == "1") { cb_iss_5.Checked = true; } else { cb_iss_5.Checked = false; } if (m.Str2.Split('|')[2] == "1") { cb_istx_1.Checked = true; } else { cb_istx_1.Checked = false; } if (m.Str3.Split('|')[2] == "1") { cb_istx_2.Checked = true; } else { cb_istx_2.Checked = false; } if (m.Str4.Split('|')[2] == "1") { cb_istx_3.Checked = true; } else { cb_istx_3.Checked = false; } if (m.Str5.Split('|')[2] == "1") { cb_istx_4.Checked = true; } else { cb_istx_4.Checked = false; } if (m.Str6.Split('|')[2] == "1") { cb_istx_5.Checked = true; } else { cb_istx_5.Checked = false; } if (m.float3 == 1.2M) { ddl_gjhz.SelectedValue = "是"; } else { ddl_gjhz.SelectedValue = "否"; } //是否国际合作 if (m.float4 == 1) { ddl_mkh.SelectedValue = "是"; } else { ddl_mkh.SelectedValue = "否"; } //是否顶级发表论文 } } if (op == "del")//删除 { bool r = bll.Delete(cxsyid, currUser.WorkID); if (r) { Jscript.AlertAndRedirect("删除成功!", "/KPIManage.aspx?id=" + id); } else { Jscript.AlertAndRedirect("删除失败,请稍后再试", "/KPIManage.aspx?id=" + id); } } } } }
string op; //操作 protected void Page_Load(object sender, EventArgs e) { if (Session["SHUUser"] == null) { Jscript.AlertAndRedirect("未登录或登录超时,请重新登录", "/Login.aspx"); Response.End(); } else { currUser = Session["SHUUser"] as SHUniversity.KPI.Model.Users; string id = Request.QueryString["id"]; //TODO:验证该考核表是否属于这个用户 TableID = Common.StrToInt(id, -1); if (TableID < 0) { Jscript.AlertAndRedirect("无法找到考核表信息", "../Home.aspx"); return; } if (!kpibll.Exists(TableID, currUser.WorkID)) { Jscript.AlertAndRedirect("考核表与用户信息不匹配", "../Home.aspx"); return; } if (!kpibll.isEdit(TableID)) { Jscript.AlertAndRedirect("考核表只有在未提交和驳回的时候才可以修改", "../Home.aspx"); return; } if (!IsPostBack) { op = Request.QueryString["op"]; string cid = Request.QueryString["cxsyid"]; //根据操作参数判断是新增、删除、编辑 int cxsyid; //itemID int.TryParse(cid, out cxsyid); if (op == "edit") //编辑----初始赋值 { SHUniversity.KPI.Model.KPIItems m = bll.GetModel(cxsyid, currUser.WorkID); if (m != null) { hid_cid.Value = cxsyid.ToString(); //何年月至何年月 ddl_pstartyear.SelectedValue = m.Int1.ToString(); //开始年 ddl_pstartmonth.SelectedValue = m.Int2.ToString(); //开始月 ddl_pendyear.SelectedValue = m.Int3.ToString(); //End年 ddl_pendmonth.SelectedValue = m.Int4.ToString(); //End月 txtProjectNO.Text = m.ProjectNO; //项目编号 txtProjectName.Text = m.ProjectName; //项目名称 ddl_ptype.SelectedValue = m.ProjectType; //项目类型 //个人质量得分 txtTGetScore.Text = Math.Round(m.float2.Value, 2).ToString(); //是否全国挑战杯 rb_istzb.SelectedValue = m.Str4; //挑战杯获奖 rb_tzb_jl.SelectedValue = m.Str5; txtZQ.Text = m.Str1; //项目周期 txtStuNum.Text = m.Int5.ToString(); //学生数量 rb_status.SelectedValue = m.Str2.ToString(); //项目质量 txtStuYuanXi.Text = m.Str3; //学生院系 txtStuNames.Text = m.text1; //学生姓名 } } if (op == "del")//删除 { bool r = bll.Delete(cxsyid, currUser.WorkID); if (r) { Jscript.AlertAndRedirect("删除成功!", "/KPIManage.aspx?id=" + id); } else { Jscript.AlertAndRedirect("删除失败,请稍后再试", "/KPIManage.aspx?id=" + id); } } } } }
protected void Page_Load(object sender, EventArgs e) { SHUniversity.KPI.Model.Users model = new SHUniversity.KPI.Model.Users(); if (!IsPostBack) { string con = Request.QueryString["con"]; string id = Request.QueryString["id"]; //发布 if (con == "pub") { model = uBll.GetModel(Convert.ToInt32(id)); if (model.Satat == 1) { model.Satat = 0; } else if (model.Satat == 0) { model.Satat = 1; } uBll.Update(model); Jscript.RedirectToFrames("UserManage.aspx"); } //删除 if (con == "del") { bool result = uBll.Delete(Convert.ToInt32(id)); if (result) { Jscript.RedirectToFrames("UserManage.aspx"); } else { Jscript.Alert("删除异常,请重试"); Jscript.RedirectToFrames("UserManage.aspx"); } } //修改 if (con == "edit") { SHUniversity.KPI.Model.Users u = uBll.GetModel(Convert.ToInt32(id)); if (model == null) { Jscript.Alert("账户不存在,请重试"); Jscript.RedirectToFrames("UserManage.aspx"); } else { hidid.Value = id; txt_birthday.Text = string.Format("{0:yyyy-MM-dd}", u.BrithDay); txt_email.Text = u.Email; txt_indate.Text = string.Format("{0:yyyy-MM-dd}", u.InDate); txt_moblie.Text = u.Moblie; txt_name.Text = u.Name; txt_pwd.Text = u.Password; txt_common.Text = u.Ramerk; rb_sex.SelectedValue = u.Sex.ToString(); txt_tell.Text = u.Tel; rb_usertype.SelectedValue = u.UserType.ToString(); txt_workID.Text = u.WorkID; txt_xueli.Text = u.Xueli; txt_xuexiao.Text = u.Xuexiao; txt_zhiwu.Text = u.Zhiwu; } } } }
string op; //操作 protected void Page_Load(object sender, EventArgs e) { if (Session["SHUUser"] == null) { Jscript.AlertAndRedirect("未登录或登录超时,请重新登录", "/Login.aspx"); Response.End(); } else { currUser = Session["SHUUser"] as SHUniversity.KPI.Model.Users; string id = Request.QueryString["id"]; TableID = Common.StrToInt(id, -1); if (TableID < 0) { Jscript.AlertAndRedirect("无法找到考核表信息", "../Home.aspx"); return; } if (!kpibll.Exists(TableID, currUser.WorkID)) { Jscript.AlertAndRedirect("考核表与用户信息不匹配", "../Home.aspx"); return; } if (!kpibll.isEdit(TableID)) { Jscript.AlertAndRedirect("考核表只有在未提交和驳回的时候才可以修改", "../Home.aspx"); return; } if (!IsPostBack) { op = Request.QueryString["op"]; string cid = Request.QueryString["cxsyid"]; //根据操作参数判断是新增、删除、编辑 int cxsyid; //itemID int.TryParse(cid, out cxsyid); if (op == "edit") //编辑----初始赋值 { SHUniversity.KPI.Model.KPIItems m = bll.GetModel(cxsyid, currUser.WorkID); if (m != null) { hid_cid.Value = cxsyid.ToString(); //何年月至何年月 ddl_pstartyear.SelectedValue = m.Int1.ToString(); //开始年 ddl_pstartmonth.SelectedValue = m.Int2.ToString(); //开始月 txtProjectName.Text = m.ProjectName; //项目名称 ddl_ptype.SelectedValue = m.ProjectType; //项目类型 ddl_xj_level.SelectedValue = m.Str5; //校级奖励 奖项 } } if (op == "del")//删除 { bool r = bll.Delete(cxsyid, currUser.WorkID); if (r) { Jscript.AlertAndRedirect("删除成功!", "/KPIManage.aspx?id=" + id); } else { Jscript.AlertAndRedirect("删除失败,请稍后再试", "/KPIManage.aspx?id=" + id); } } } } }
string op; //操作 protected void Page_Load(object sender, EventArgs e) { if (Session["SHUUser"] == null) { Jscript.AlertAndRedirect("未登录或登录超时,请重新登录", "/Login.aspx"); Response.End(); } else { currUser = Session["SHUUser"] as SHUniversity.KPI.Model.Users; string id = Request.QueryString["id"]; //TODO:验证该考核表是否属于这个用户 TableID = Common.StrToInt(id, -1); if (TableID < 0) { Jscript.AlertAndRedirect("无法找到考核表信息", "../Home.aspx"); return; } if (!kpibll.Exists(TableID, currUser.WorkID)) { Jscript.AlertAndRedirect("考核表与用户信息不匹配", "../Home.aspx"); return; } if (!kpibll.isEdit(TableID)) { Jscript.AlertAndRedirect("考核表只有在未提交和驳回的时候才可以修改", "../Home.aspx"); return; } if (!IsPostBack) { op = Request.QueryString["op"]; string cid = Request.QueryString["cxsyid"]; //根据操作参数判断是新增、删除、编辑 int cxsyid; //itemID int.TryParse(cid, out cxsyid); if (op == "edit") //编辑----初始赋值 { SHUniversity.KPI.Model.KPIItems m = bll.GetModel(cxsyid, currUser.WorkID); if (m != null) { hid_cid.Value = cxsyid.ToString(); //何年月至何年月 ddl_pstartyear.SelectedValue = m.Int1.ToString(); //开始年 ddl_pstartmonth.SelectedValue = m.Int2.ToString(); //开始月 ddl_pendyear.SelectedValue = m.Int3.ToString(); //End年 ddl_pendmonth.SelectedValue = m.Int4.ToString(); //End月 txtProjectNO.Text = m.ProjectNO; //项目编号 txtProjectName.Text = m.ProjectName; //项目名称 ddl_ptype.SelectedValue = m.ProjectType; //项目类型 txtGJJF.Text = Math.Round(m.float1.Value, 2).ToString(); //实到经费 txt_self_lv.Text = Math.Round(m.float3.Value, 2).ToString(); //本人贡献比例 txtJS1.Text = m.Str1; txtJS2.Text = m.Str2; txtJS3.Text = m.Str3; txtJS4.Text = m.Str4; txt_js1_lv.Text = m.float4 == null?"": Math.Round(m.float4.Value, 2).ToString(); txt_js2_lv.Text = m.float5 == null ? "" : Math.Round(m.float5.Value, 2).ToString(); txt_js3_lv.Text = m.float6 == null ? "" : Math.Round(m.float6.Value, 2).ToString(); txt_js4_lv.Text = m.float7 == null ? "" : Math.Round(m.float7.Value, 2).ToString(); } } if (op == "del")//删除 { bool r = bll.Delete(cxsyid, currUser.WorkID); if (r) { Jscript.AlertAndRedirect("删除成功!", "/KPIManage.aspx?id=" + id); } else { Jscript.AlertAndRedirect("删除失败,请稍后再试", "/KPIManage.aspx?id=" + id); } } } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SHUniversity.KPI.Model.Users model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SHUniversity.KPI.Model.Users model) { return(dal.Add(model)); }