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