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