/// <summary> /// //添加会议纪要信息 /// </summary> /// <param name="meetingSummary"></param> public void AddMeetingSummary(MeetingSummary meetingSummary) { string sql = "usp_AddMeetingSummary"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@MeetingTitle", meetingSummary.MeetingTitle), new SqlParameter("@MeetingContent", meetingSummary.MeetingContent), new SqlParameter("@BeginTime", meetingSummary.BeginTime.ToString()), new SqlParameter("@EndTime", meetingSummary.EndTime.ToString()), new SqlParameter("@MissingPeople", meetingSummary.MissingPeople), new SqlParameter("@ChargeMan", meetingSummary.ChargeMan), new SqlParameter("@Visitor", meetingSummary.Visitor), new SqlParameter("@Compere", meetingSummary.Compere) }; DBHelper.ExecuteNonQueryProc(sql, para); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (IsValid) { //判断缺席人中是否含有出席人 //参与者 string otherman = txtOtherMan.Text; // 缺席者 string absentman = txtMissingPeople.Value; //判断缺席者是否存在参与者中 if (otherman.Contains(absentman)) { Response.Write("<script>alert('此缺席人在参与者中已存在!');</script>"); return; } //获得用户登录的ID UserInfo user = Session["user"] as UserInfo; MeetingSummary meeting = new MeetingSummary(); meeting.MeetingTitle = txtTitle.Text; //会议主题 meeting.MeetingContent = txtMeetingContent.Value; //会议内容 meeting.BeginTime = Convert.ToDateTime(txtStartTime.Value); //开始时间 meeting.EndTime = Convert.ToDateTime(txtEndTime.Value); //结束时间 meeting.MissingPeople = txtMissingPeople.Value; //缺席人员 meeting.Compere = txtOtherMan.Text; //参与 者 meeting.ChargeMan = user.Name; //负责人,就是会议纪要人,也就是登录用户 //进行添加操作 try { MeetingSummaryManager.AddMeetingSummary(meeting); Response.Write("<script>alert('添加成功!');location.href='SelMeeting.aspx';</script>"); } catch (Exception) { Response.Write("<script>alert('添加失败!');</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["MSID"] == null) { Response.Redirect("SelMeeting.aspx"); } //获得要查看的会议纪要的id int id = Convert.ToInt32(Request.QueryString["MSID"]); MeetingSummary meetingSummary = MeetingSummaryManager.GetMeetingSummaryById(id); lblRoomName.Text = meetingSummary.MeetingTitle; txtBeginTime.Value = meetingSummary.BeginTime.ToString(); txtEndTime.Value = meetingSummary.EndTime.ToString(); txtMeetingContent.Value = meetingSummary.MeetingContent; txtMissingPeople.Value = meetingSummary.MissingPeople; txtCompere.Value = meetingSummary.Compere; txtVisitor.Value = meetingSummary.Visitor; } }
public List <MeetingSummary> GetAllMeetingSummaries() { List <MeetingSummary> mss = new List <MeetingSummary>(); string query = "SELECT * FROM MeetingSummaries"; //using stored procedure instead of specific query //string query = "SelectAll"; DataSet data = executor.Execute(query); DataTableReader reader = data.CreateDataReader(); while (reader.Read()) { int id = Convert.ToInt32(reader["Id"]); int cid = Convert.ToInt32(reader["Case"]); int sid = Convert.ToInt32(reader["Lawyer"]); DateTime date = Convert.ToDateTime(reader["Date"]); string sum = Convert.ToString(reader["Summary"]); MeetingSummary ms = new MeetingSummary(id, cid, sid, date); mss.Add(ms); } return(mss); }
/// <summary> /// 更新会议纪要信息 /// </summary> /// <param name="meetingSummary"></param> public static void UpdateMeetingSummary(MeetingSummary meetingSummary) { meetingService.UpdateMeetingSummary(meetingSummary); }
/// <summary> /// //添加会议纪要信息 /// </summary> /// <param name="meetingSummary"></param> public static void AddMeetingSummary(MeetingSummary meetingSummary) { meetingService.AddMeetingSummary(meetingSummary); }