protected void Sure_Add(object sender, EventArgs e) { if (m.Get_FieId_Data("Power_NO", "PartyData", " where StudentNum='" + Session["StudentNum"].ToString() + "'") != "003") { string file = ""; string filename = ""; for (int i = 0; i < Add_Files.Items.Count; i++) { if (Add_Files.Items[i].Selected) { file += Add_Files.Items[i].Value + ","; filename += m.Get_FieId_Data("TypeName", "Category", " where TypeNO='" + Add_Files.Items[i].Value + "'") + ","; } } PartyData pd = pidc.PartyData.FirstOrDefault(p => p.StudentNum == studentnum.Text); if (pd != null) { pd.Files = file; pd.File_Clerk = Session["StudentNum"].ToString(); pidc.SubmitChanges(); m.MessageBox(this, "操作完成"); // Response.Write("<script></script>"); } Record_Details rd = new Record_Details(); rd.StudentNum = studentnum.Text; rd.Detail_Type = 1; rd.Details_Contents = "添加新的档案:" + filename; rd.Operate = DateTime.Now; rd.Operator = m.Get_FieId_Data("Name", "PartyData", " where StudentNum='" + Session["StudentNum"].ToString() + "'"); pidc.Record_Details.InsertOnSubmit(rd); pidc.SubmitChanges(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["StudentNum"] != null) { if (Request.QueryString["ID"] != null) { int id = Convert.ToInt32(Request.QueryString["ID"]); Message message = pidc.Message.FirstOrDefault(p => p.ID == id); if (message != null) { studentnum.Text = message.StudentNum; Create_Time.Text = message.Create_Time.ToString(); Contents.Text = message.Contents; if (message.TypeClass == 1) { message.Message_Status = "已读"; pidc.SubmitChanges(); } else if (message.TypeClass == 3 || message.TypeClass == 4 || message.TypeClass == 5) { message.Message_Status = "已读"; pidc.SubmitChanges(); } } } } }
protected void Data_Show_ItemCommand(object sender, RepeaterCommandEventArgs e) { if (m.Get_FieId_Data("Power_NO", "PartyData", " where StudentNum='" + Session["StudentNum"].ToString() + "'") == "001") { PartyData pd = pidc.PartyData.FirstOrDefault(p => p.StudentNum == e.CommandArgument); switch (e.CommandName) { case "empower": if (pd != null) { if (pd.Power_NO == "003") { pd.Power_NO = "002"; pidc.SubmitChanges(); m.MessageBox(this, "授权成功"); } else { m.MessageBox(this, "此人已经拥有权限,不用重复授权"); return; } } break; case "lostpower": //PartyData pd = pidc.PartyData.FirstOrDefault(p => p.StudentNum == e.CommandArgument); if (pd != null) { if (pd.Power_NO == "002") { pd.Power_NO = "003"; pidc.SubmitChanges(); m.MessageBox(this, "收回权限成功"); } else { m.MessageBox(this, "此人已经没有权限,不用重复收回"); return; } } break; } } else { m.MessageBox(this, "您没有权限进行此操作"); return; } }
protected void add_click(object sender, EventArgs e) { if (Session["StudentNum"] != null) { string powerno = m.Get_FieId_Data("Power_NO", "Personal_Data", " where StudentNum='" + Session["StudentNum"].ToString() + "'"); string promulgator = ""; if (Promulgator.SelectedValue == "1") { promulgator = "系统"; } else { promulgator = m.Get_FieId_Data("Name", "PartyData", " where StudentNum='" + Session["StudentNum"].ToString() + "'"); } Work_Info wi = new Work_Info(); wi.Metting_Theme = Metting_Theme.Text; wi.Work_Message_Time = Convert.ToDateTime(Work_Message_Time.Text); wi.Promulgator = promulgator; wi.Created_on_time = DateTime.Now; wi.Work_Content = Work_Content.Text; wi.Metting_Status = 1; pidc.Work_Info.InsertOnSubmit(wi); pidc.SubmitChanges(); m.MessageBox(this, "会议安排成功"); } }
protected void Sure_Update_Click(object sender, EventArgs e) { if (Session["StudentNum"] != null) { Party_InformationDataContext pidc = new Party_InformationDataContext(); if (pidc.Update_Data.FirstOrDefault(p => p.Update1 == Session["StudentNum"].ToString() && p.Update_Type == 1 && p.Update_Status == 0) == null) { Update_Data ud = new Update_Data(); ud.Update_Type = 1; ud.Update_Theme = "修改个人信息"; ud.Update1 = StudentNum.Text; ud.Update2 = placeOfOrigin1.Value; ud.Update3 = telephone1.Value; ud.Update4 = Address1.Value; ud.Update_Time = DateTime.Now; pidc.Update_Data.InsertOnSubmit(ud); pidc.SubmitChanges(); m.MessageBox(this, "修改已提交"); } else { m.MessageBox(this, "已经提交过修改个人信息申请"); } } }
[WebMethod] //密码申诉的方法 public static string Password_appeal(string studentnum, string reason, string password) { Method m = new Method(); Party_InformationDataContext pidc = new Party_InformationDataContext(); string result = "true"; if (studentnum != "" && password != "") { Update_Data ud = new Update_Data(); ud.Update1 = studentnum; ud.Update_Reason = reason; ud.Update3 = m.MD5(password); ud.Update_Status = 0; ud.Update_Type = 3; ud.Update_Time = DateTime.Now; ud.Update_Theme = studentnum + "密码申诉"; pidc.Update_Data.InsertOnSubmit(ud); pidc.SubmitChanges(); result = "true"; } else { result = "false"; } return(result); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["StudentNum"] != null) { GetData(); for (int i = 0; i < Data_Show.Items.Count; i++) { DateTime dt = Convert.ToDateTime((Data_Show.Items[i].FindControl("Work_Message_Time") as Label).Text); if (dt < DateTime.Now) { int id = Convert.ToInt32((Data_Show.Items[i].FindControl("Work_Message_Id") as HiddenField).Value); Work_Info wi = pidc.Work_Info.FirstOrDefault(p => p.Work_Message_Id == id); if (wi != null) { wi.Metting_Status = 2; pidc.SubmitChanges(); } } } string data = m.Get_FieId_Data("Power_NO", "Personal_Data", " where StudentNum='" + Session["StudentNum"].ToString() + "'"); if (data == "003") { #region 会议记录权限 for (int i = 0; i < Data_Show.Items.Count; i++) { (Data_Show.Items[i].FindControl("update_metting") as LinkButton).Visible = false; (Data_Show.Items[i].FindControl("delete_metting") as LinkButton).Visible = false; } #endregion } } else { Response.Redirect("../Login.aspx"); } } }
protected void sure_add_click(object sender, EventArgs e) { if (m.Get_FieId_Data("Power_NO", "PartyData", " where studentnum='" + Session["studentnum"].ToString() + "'") != "003") { PartyData pd = new PartyData(); PartyStatus ps = new PartyStatus(); pd.StudentNum = studentnum.Text; pd.Name = studentName.Text; pd.Password = m.MD5("123456"); pd.Birth = birth.Text; pd.Sex = sex.SelectedValue; pd.PlaceOfOrigin = place.Text; pd.StartTime = Convert.ToDateTime(starTime.Text); pd.Telephone = telephone.Text; pd.ClassNO = Convert.ToInt32(classno.Text); pd.FromPlace = fromplace.Text; string path = Server.MapPath("../../Image/Personal_Photos/" + studentnum.Text); string filename = personal_photo.PostedFile.FileName; if (!File.Exists(path + "/" + filename)) { Directory.CreateDirectory(path); personal_photo.PostedFile.SaveAs(path + "/" + filename); pd.Photo = "../../Image/Personal_Photos/" + studentnum.Text + "/" + filename; } pd.CollegeNO = Convert.ToInt32(m.Get_FieId_Data("CollegeID", "Class", " where ClassID=" + Convert.ToInt32(classno.Text) + "")); pd.Power_NO = "003"; pd.Address = address.Text; pidc.PartyData.InsertOnSubmit(pd); pidc.SubmitChanges(); ps.StudentNum = studentnum.Text; ps.MemberStatus_NO = memberstatus.SelectedValue; pidc.PartyStatus.InsertOnSubmit(ps); pidc.SubmitChanges(); m.MessageBox(this, "添加成员成功"); } else { m.MessageBox(this, "你没有权限添加成员"); } }
protected void Sure_Add(object sender, EventArgs e) { if (Request.QueryString["studentnum"] == null) { return; } string studentnum = Request.QueryString["studentnum"].ToString(); PartyData pd = pidc.PartyData.FirstOrDefault(p => p.StudentNum == studentnum); if (pd != null) { if (RemovePlace.Text != "") { if (pd.RemovePlace == "") { pd.RemovePlace = RemovePlace.Text; pidc.SubmitChanges(); m.MessageBox(this, "档案转出成功"); } else { m.MessageBox(this, "档案已转出"); } } else { m.MessageBox(this, "档案转出地不能为空"); } } Record_Details rd = new Record_Details(); rd.StudentNum = studentnum; rd.Detail_Type = 3; rd.Details_Contents = "档案转出到:" + RemovePlace.Text; rd.Operate = DateTime.Now; rd.Operator = m.Get_FieId_Data("Name", "PartyData", " where StudentNum='" + Session["StudentNum"].ToString() + "'"); pidc.Record_Details.InsertOnSubmit(rd); pidc.SubmitChanges(); }
protected void Upload_Datum(object sender, EventArgs e) { if (Upload_Files.HasFile) { string studentnum = Session["StudentNum"].ToString(); string browse_Authority = ""; //定义权限变量 for (int i = 0; i < Browse_Authority.Items.Count; i++) { if (Browse_Authority.Items[i].Selected) { browse_Authority += Browse_Authority.Items[i].Value + ","; } } if (browse_Authority == "") { m.MessageBox(this, "请选择阅览权限"); return; } string filepath = Server.MapPath("../../Files/" + studentnum); string filename = Upload_Files.FileName; string Datum_URL = "../../Files/" + studentnum + "/" + Upload_Files.FileName; if (Directory.Exists(filepath)) { Upload_Files.SaveAs(filepath + "/" + filename); m.MessageBox(this, "文件上传成功"); } else { Directory.CreateDirectory(filepath); Upload_Files.SaveAs(filepath + "/" + filename); m.MessageBox(this, "文件上传成功"); } Datum d = new Datum(); d.StudentNum = studentnum; d.Datum_Name = filename; d.Datum_URL = Datum_URL; d.Browse_Authority = browse_Authority; d.Upload_Time = DateTime.Now; d.Download_Num = 0; ptdc.Datum.InsertOnSubmit(d); ptdc.SubmitChanges(); } else { m.MessageBox(this, "请选择上传的文件"); } }
protected void Data_Show_ItemCommand(object sender, RepeaterCommandEventArgs e) { if (e.CommandName == "download") { string fileName = ""; string filePath = Server.MapPath(e.CommandArgument.ToString()); for (int i = 0; i < e.CommandArgument.ToString().Split('/').Length; i++) { fileName = e.CommandArgument.ToString().Split('/')[i]; } if (new FileInfo(filePath).Exists) { FileInfo fileInfo = new FileInfo(filePath); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName); Response.AddHeader("Content-Length", fileInfo.Length.ToString()); Response.AddHeader("Content-Transfer-Encoding", "binary"); Response.ContentType = "application/octet-stream"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); Response.WriteFile(fileInfo.FullName); int Datum_ID = Convert.ToInt32((e.Item.FindControl("Datum_ID") as HiddenField).Value); Party_InformationDataContext ptdc = new Party_InformationDataContext(); Datum d = ptdc.Datum.FirstOrDefault(p => p.Datum_ID == Datum_ID); if (d != null) { d.Download_Num = d.Download_Num + 1; ptdc.SubmitChanges(); } Response.Flush(); Response.End(); } else { Response.Write("<script>alert('不存在该文件')</script>"); } } }
protected void sure_review_click(object sender, EventArgs e) { if (m.Get_FieId_Data("Power_NO", "PartyData", " where studentnum='" + Session["studentnum"].ToString() + "'") != "003") { string studentnum = save_studentnum.Value; bool result = true; //判断是否已经添加考核 for (int i = 0; i < studentnum.Split(',').Length; i++) { string n = studentnum.Split(',')[i]; if (pidc.Update_Data.FirstOrDefault(p => p.Update1 == n && p.Update_Type == 4 && p.Update_Status == 0) != null) { m.MessageBox(this, "学号为:" + studentnum + "的同学已经添加考核,请重新选择"); result = false; return; } } if (result) { for (int i = 0; i < studentnum.Split(',').Length; i++) { string n = studentnum.Split(',')[i]; Update_Data ud = new Update_Data(); ud.Update1 = n; ud.Update2 = MemberStatus.SelectedValue; //党员身份 ud.Update_Status = 0; ud.Update_Type = 4; ud.Update_Time = DateTime.Now; //创建考核时间 ud.Update_Theme = theme.Text; //考核时间 ud.Review_Time = Convert.ToDateTime(review_time.Text); ud.Audit_Person = person.Text; pidc.Update_Data.InsertOnSubmit(ud); pidc.SubmitChanges(); } m.MessageBox(this, "添加考核完成"); } } }
protected void update_click(object sender, EventArgs e) { if (Session["StudentNum"] != null) { int id = Convert.ToInt32(Request.QueryString["Work_Message_Id"]); string powerno = m.Get_FieId_Data("Power_NO", "Personal_Data", " where StudentNum='" + Session["StudentNum"].ToString() + "'"); if (powerno == "003") { m.MessageBox(this, "你没有权限修改"); } else { string promulgator = ""; if (Promulgator.SelectedValue == "1") { promulgator = "系统"; } else { promulgator = m.Get_FieId_Data("Name", "PartyData", " where StudentNum='" + Session["StudentNum"].ToString() + "'"); } Work_Info wi = pidc.Work_Info.FirstOrDefault(p => p.Work_Message_Id == id); if (wi != null) { wi.Metting_Theme = Metting_Theme.Text; wi.Promulgator = promulgator; wi.Work_Message_Time = Convert.ToDateTime(Work_Message_Time.Text); wi.Work_Content = Work_Content.Text; wi.Update_time = DateTime.Now; pidc.SubmitChanges(); m.MessageBox(this, "修改成功"); } } } }
protected void application_pass_click(object sender, EventArgs e) { if (m.Get_FieId_Data("Power_NO", "Personal_Data", " where StudentNum='" + Session["StudentNum"].ToString() + "'") != "003") { int id = Convert.ToInt32(Request.QueryString["id"]); Update_Data ud = pidc.Update_Data.FirstOrDefault(p => p.ID == id); if (ud != null) { if (ud.Update_Status == 0) { if (ud.Update_Type == 1) { PartyData pd = pidc.PartyData.FirstOrDefault(p => p.StudentNum == ud.Update1); #region 个人信息新盖审核 if (pd != null) { pd.PlaceOfOrigin = ud.Update2; pd.Telephone = ud.Update3; pd.Address = ud.Update4; ud.Update_Time = DateTime.Now; ud.Update_Remark = Remark.Text; ud.Audit_Person = m.Get_FieId_Data("name", "PartyData", " where studentnum='" + ud.Update1 + "'"); ud.Update_Status = 1; pidc.SubmitChanges(); m.MessageBox(this, "审核通过"); } #endregion } #region 密码申诉审核 else if (ud.Update_Type == 3) { PartyData pd = pidc.PartyData.FirstOrDefault(p => p.StudentNum == ud.Update1); if (pd != null) { ud.Update_Time = DateTime.Now; pd.Password = ud.Update3; ud.Update_Remark = Remark.Text; ud.Audit_Person = m.Get_FieId_Data("name", "PartyData", " where studentnum='" + ud.Update1 + "'"); ud.Update_Status = 1; pidc.SubmitChanges(); m.MessageBox(this, "审核通过"); } } #endregion #region 党员考核 else if (ud.Update_Type == 4) { PartyStatus ps = pidc.PartyStatus.FirstOrDefault(p => p.StudentNum == ud.Update1); if (ps != null) { if (ps.AuditTime1 != null) { ps.AuditTime1 = ud.Review_Time; ps.Auditor1 = ud.Audit_Person; ps.AuditOpinion1 = Remark.Text; if (ud.Update2 != "正式党员") { ps.MemberStatus_NO = (Convert.ToInt32(m.Get_FieId_Data("TypeNO", "Category", " where TypeName='" + ud.Update2 + "'")) - 1).ToString(); } ud.Update_Time = DateTime.Now; ud.Update_Remark = Remark.Text; //ud.Audit_Person = m.Get_FieId_Data("name", "PartyData", " where studentnum='" + ud.Update1 + "'"); ud.Update_Status = 1; pidc.SubmitChanges(); m.MessageBox(this, "审核通过"); } else { if (ps.AuditTime2 != null) { ps.AuditTime2 = ud.Review_Time; ps.Auditor2 = ud.Audit_Person; ps.AuditOpinion2 = Remark.Text; if (ud.Update2 != "正式党员") { ps.MemberStatus_NO = (Convert.ToInt32(m.Get_FieId_Data("TypeNO", "Category", " where TypeName='" + ud.Update2 + "'")) - 1).ToString(); } ud.Update_Time = DateTime.Now; ud.Update_Remark = Remark.Text; //ud.Audit_Person = m.Get_FieId_Data("name", "PartyData", " where studentnum='" + ud.Update1 + "'"); ud.Update_Status = 1; pidc.SubmitChanges(); m.MessageBox(this, "审核通过"); } else { if (ps.AuditTime3 != null) { ps.AuditTime3 = ud.Review_Time; ps.Auditor3 = ud.Audit_Person; ps.AuditOpinion3 = Remark.Text; if (ud.Update2 != "正式党员") { ps.MemberStatus_NO = (Convert.ToInt32(m.Get_FieId_Data("TypeNO", "Category", " where TypeName='" + ud.Update2 + "'")) - 1).ToString(); } ud.Update_Time = DateTime.Now; ud.Update_Remark = Remark.Text; //ud.Audit_Person = m.Get_FieId_Data("name", "PartyData", " where studentnum='" + ud.Update1 + "'"); ud.Update_Status = 1; pidc.SubmitChanges(); m.MessageBox(this, "审核通过"); } } } } } #endregion #region 资料审核 if (ud.Update_Type == 5) { ud.Update_Status = 1; ud.Audit_Person = m.Get_FieId_Data("name", "PartyData", " where studentnum='" + Session["studentnum"].ToString() + "'"); ud.Update_Remark = Remark.Text; Datum d = pidc.Datum.FirstOrDefault(p => p.Datum_ID == Convert.ToInt32(ud.Update3)); if (d != null) { d.Audit_State = 1; } pidc.SubmitChanges(); m.MessageBox(this, "审核通过"); } #endregion } else { m.MessageBox(this, "只能审核未审核的"); } } } }