/// <summary>
/// 删除会议室信息
/// </summary>
private void Del()
{
if (MessageBox.Show("确定删除该条会议信息?,该操作不可恢复!", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
try
{
ConferenceAuditorBLL Del = new ConferenceAuditorBLL();
BoardroomModel boardroom = new BoardroomModel();
string bdrid = this.dgvBoardroom.CurrentRow.Cells["ColumnBdrId"].Value.ToString();//获取当前行要修改的会议ID
boardroom.BdrId = int.Parse(bdrid);
if (Del.DelBoardroom(boardroom))
{
MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("该会议室存在会议,不可删除", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
this.btnSearch_Click(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 确认提交
/// </summary>
private void Ensure()
{
try
{
ConferenceAuditorBLL Add = new ConferenceAuditorBLL();
BoardroomModel boardroom = new BoardroomModel();
boardroom.BdrStatus = '1';
boardroom.BdrName = this.txtBdrName.Text;
boardroom.BdrContactNum = int.Parse(this.txtBdrContact.Text);
boardroom.BdrLinkMan = this.txtConMan.Text;
boardroom.BdrContactPhone = this.txtConPhone.Text;
boardroom.BdrIntro = this.txtConIntro.Text;
boardroom.BdrRemarks = this.txtConRemarks.Text;
Add.AddBoardroom(boardroom);
this.DialogResult = DialogResult.OK;
MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 确认任务单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// 作者:王宇昊
/// 创建时间:2014-09-24
/// 修改时间:2014-09-24
private void btnEnsure_Click(object sender, EventArgs e)
{
try
{
if (dgvTask.RowCount != 0)
{
ConferenceAuditorBLL Save = new ConferenceAuditorBLL();
ExecutorBLL Get = new ExecutorBLL();
List <ConferenceModel> Conference = new List <ConferenceModel>();
Conference = Get.GetConferenceInfo("");
foreach (ConferenceModel con in Conference)
{
if (con.ConId.ToString() == this.dgvTask.CurrentRow.Cells["ColumnConferenceId"].Value.ToString())
{
con.ConIsDone = '1';
Save.UpdateConference(con);
MessageBox.Show("确认成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
GetTask();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 增加资源
/// </summary>
private void Add()
{
try
{
if (cmbAddResClass.Text == "")
{
if (MessageBox.Show("值不能为空", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
}
else
{
if (MessageBox.Show("确定添加?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
ConferenceAuditorBLL Add = new ConferenceAuditorBLL();
ResourceModel resource = new ResourceModel();
resource.ResourceClass = cmbAddResClass.Text;
resource.ResourceStatus = '0';
Add.AddResouce(resource);
MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.ResourceManageForm_Load(null, null);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 查询所有会议室信息
/// </summary>
private void search()
{
try
{
dgvBoardroom.Rows.Clear();
ConferenceAuditorBLL Boardroom = new ConferenceAuditorBLL();
List <BoardroomModel> BoardroomList = new List <BoardroomModel>();
BoardroomList = Boardroom.GetBoardroomInfo(txtQuery.Text);
int n = 0;
foreach (BoardroomModel boardroom in BoardroomList)
{
dgvBoardroom.Rows.Add();
dgvBoardroom.Rows[n].Cells["ColumnBdrId"].Value = boardroom.BdrId;
if (boardroom.BdrStatus == '1')
{
dgvBoardroom.Rows[n].Cells["ColumnBdrStatus"].Value = "正常";
}
else
{
dgvBoardroom.Rows[n].Cells["ColumnBdrStatus"].Value = "损坏";
}
dgvBoardroom.Rows[n].Cells["ColumnBdrName"].Value = boardroom.BdrName;
dgvBoardroom.Rows[n].Cells["ColumnBdrContactNum"].Value = boardroom.BdrContactNum;
dgvBoardroom.Rows[n].Cells["ColumnBdrLinkMan"].Value = boardroom.BdrLinkMan;
dgvBoardroom.Rows[n].Cells["ColumnBdrContactPhone"].Value = boardroom.BdrContactPhone;
dgvBoardroom.Rows[n].Cells["ColumnBdrIntro"].Value = boardroom.BdrIntro;
dgvBoardroom.Rows[n].Cells["ColumnBdrRemarks"].Value = boardroom.BdrRemarks;
n++;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 获取选中的信息显示在控件中
/// </summary>
private void load()
{
ConferenceAuditorBLL Boardroom = new ConferenceAuditorBLL();
List <BoardroomModel> BoardroomList = new List <BoardroomModel>();
BoardroomList = Boardroom.GetBoardroomInfo("");
foreach (BoardroomModel boardroom in BoardroomList)
{
if (boardroom.BdrId == bdrid.BdrId)
{
if (boardroom.BdrStatus == '1')
{
ComtxtBdrs.Text = "正常";
}
else
{
ComtxtBdrs.Text = "损坏";
}
txtBdrName.Text = boardroom.BdrName;
txtBdrContact.Text = boardroom.BdrContactNum.ToString();
txtConMan.Text = boardroom.BdrLinkMan;
txtConPhone.Text = boardroom.BdrContactPhone;
txtConIntro.Text = boardroom.BdrIntro;
txtConRemarks.Text = boardroom.BdrRemarks;
}
}
}
private void btnEnsure_Click(object sender, EventArgs e)
{
if (DialogResult.OK == MessageBox.Show("确定修改吗", "系统消息", MessageBoxButtons.OKCancel))
{
ConferenceAuditorBLL auditbll = new ConferenceAuditorBLL();
List <ConferenceModel> conlist = new List <ConferenceModel>();
conlist = auditbll.GetConferenceInfo(selecetedConId.ToString());
foreach (ConferenceModel con in conlist)
{
if (con.ConId == this.selecetedConId)
{
con.ConHost = cmbHost.Text;
List <BoardroomModel> bdrlist = new List <BoardroomModel>();
bdrlist = auditbll.GetBoardroomInfo(cmbPlace.Text);
foreach (BoardroomModel bdr in bdrlist)
{
con.ConPlace = bdr.BdrId;
}
con.ConStartTime = dtpStart.Value;
con.ConEndTime = dtpEnd.Value;
auditbll.UpdateCon(con);
MessageBox.Show("修改成功！");
}
}
}
}
private void ChooseBoardroomForm_Load(object sender, EventArgs e)
{
ConferenceAuditorBLL conabll = new ConferenceAuditorBLL();
List <BoardroomModel> bdrlist = new List <BoardroomModel> ();
bdrlist = conabll.GetBoardroomInfo("");
foreach (BoardroomModel bdr in bdrlist)
{
cmbSelect.Items.Add(bdr.BdrName);
}
}
/// <summary>
/// 绑定会议室
/// </summary>
private void bindPlace()
{
ConferenceAuditorBLL conabll = new ConferenceAuditorBLL();
List <BoardroomModel> bdrlist = new List <BoardroomModel>();
bdrlist = conabll.GetBoardroomInfo("");
foreach (BoardroomModel bdr in bdrlist)
{
cmbPlace.Items.Add(bdr.BdrName);
}
}
/// <summary>
/// 读取界面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ConferenceApplyForm_Load(object sender, EventArgs e)
{
GetStaff();
dgvConMember.DataSource = dataset;
List<TopicModel > toplist = new List<TopicModel> ();
toplist = userbll.GetUserTopic(emp);
foreach (TopicModel top in toplist)
{
cmbTopic.Items.Add(top.TopicHead);
}
ConferenceAuditorBLL conabll = new ConferenceAuditorBLL();
cmbHost.Text = conabll.GetAEmployee(emp.EmId).EmDepart;
rdoInCon.Checked = true;
rdoInCon_Click(null,null);
rdoReg.Checked = true;
rdoReg_Click(null,null);
}
/// <summary>
/// 读取议题信息
/// </summary>
private void load()
{
try
{
dgvTopic.Rows.Clear();
TopicAuditorBLL Topic = new TopicAuditorBLL();
List <TopicModel> TopicList = new List <TopicModel>();
ConferenceAuditorBLL GetAEmployee = new ConferenceAuditorBLL();
TopicList = Topic.GetTopicInfo("");
int n = 0;
foreach (TopicModel topic in TopicList)
{
if (topic.TopicApplicantId == TopicApplicantId)
{
dgvTopic.Rows.Add();
dgvTopic.Rows[n].Cells["dgvTopicSubTime"].Value = topic.TopicSubTime;
if (topic.TopicStatus == '0')
{
dgvTopic.Rows[n].Cells["dgvTopicVerifyTime"].Value = "";
dgvTopic.Rows[n].Cells["dgvTopicStatus"].Value = "未审核";
}
else
{
dgvTopic.Rows[n].Cells["dgvTopicVerifyTime"].Value = topic.TopicVerifyTime;
if (topic.TopicStatus == '1')
{
dgvTopic.Rows[n].Cells["dgvTopicStatus"].Value = "已审核";
}
else
{
dgvTopic.Rows[n].Cells["dgvTopicStatus"].Value = "未通过";
}
}
dgvTopic.Rows[n].Cells["dgvTopicHead"].Value = topic.TopicHead;
dgvTopic.Rows[n].Cells["dgvTopicContent"].Value = topic.TopicContent;
n++;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 获取任务单
/// </summary>
/// 作者:王宇昊
/// 创建时间:2014-09-24
/// 修改时间:2014-09-24
private void GetTask()
{
try
{
dgvTask.Rows.Clear();
ExecutorBLL Task = new ExecutorBLL();
List <TaskModel> TaskList = new List <TaskModel>();
ConferenceAuditorBLL ResourceName = new ConferenceAuditorBLL();
List <ResourceModel> Resource = new List <ResourceModel>();
TaskList = Task.GetTask(employee);
int n = 0;
foreach (TaskModel task in TaskList)
{
if (task.TaskConference.ConIsDone == '0')
{
dgvTask.Rows.Add();
dgvTask.Rows[n].Cells["ColumnConferenceId"].Value = task.TaskConference.ConId;
dgvTask.Rows[n].Cells["ColumnConference"].Value = task.TaskBdrName;
dgvTask.Rows[n].Cells["ColumnBoardroom"].Value = task.TaskConference.ConName;
dgvTask.Rows[n].Cells["ColumnStartTime"].Value = task.TaskConference.ConStartTime;
dgvTask.Rows[n].Cells["ColumnResource"].Value = "";
for (int i = 0; i < task.TaskResource.Count; i++)
{
Resource = ResourceName.GetAllResource();
foreach (ResourceModel Res in Resource)
{
if (Res.ResourceId == Convert.ToInt32(task.TaskResource[i]))
{
dgvTask.Rows[n].Cells["ColumnResource"].Value += task.TaskResource[i].ToString() + Res.ResourceClass + "\r\n";
}
}
}
n++;
}
}
//txtResId.Text = this.dgvTask.CurrentRow.Cells["ColumnResourceId"].Value.ToString();
dgvTask_CellContentClick(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 绑定LIST到datagridview
/// </summary>
/// 作者：吴欣哲
/// 创建时间：20140919
public void BindDataToDgv()
{
dgvReturn.Rows.Clear();
ConferenceAuditorBLL con = new ConferenceAuditorBLL();
List <ConferenceModel> conList = new List <ConferenceModel>();
conList = con.GetConferenceInfo(txtQuery.Text);
int n = 0;
foreach (ConferenceModel conference in conList)
{
dgvReturn.Rows.Add();
dgvReturn.Rows[n].Cells["Column1"].Value = conference.ConId;
if (conference.ConStatus == '0')
{
dgvReturn.Rows[n].Cells["Column2"].Value = "未审核";
}
else if (conference.ConStatus == '1')
{
dgvReturn.Rows[n].Cells["Column2"].Value = "审核通过";
}
else if (conference.ConStatus == '2')
{
dgvReturn.Rows[n].Cells["Column2"].Value = "不通过";
}
dgvReturn.Rows[n].Cells["Column3"].Value = conference.ConName;
dgvReturn.Rows[n].Cells["Column4"].Value = conference.ConStartTime;
dgvReturn.Rows[n].Cells["Column5"].Value = conference.ConEndTime;
UserBLL userbll = new UserBLL();
List <BoardroomModel> bdrlist = new List <BoardroomModel>();
bdrlist = userbll.GetBoardroomInfo(conference.ConPlace.ToString());
foreach (BoardroomModel bdr in bdrlist)
{
if (bdr.BdrId == conference.ConId)
{
dgvReturn.Rows[n].Cells["Column6"].Value = bdr.BdrName;
}
}
n++;
}
}
/// <summary>
/// 保存资源信息
/// </summary>
private void Save()
{
try
{
ConferenceAuditorBLL Save = new ConferenceAuditorBLL();
ResourceModel resource = new ResourceModel();
resource.ResourceId = int.Parse(txtResId.Text);
resource.ResourceClass = cmbResClass.Text;
if (cmbStatus.Text == "空闲")
{
resource.ResourceStatus = '0';
}
else if (cmbStatus.Text == "被预订")
{
resource.ResourceStatus = '1';
}
else if (cmbStatus.Text == "使用中")
{
resource.ResourceStatus = '2';
}
else if (cmbStatus.Text == "损坏")
{
resource.ResourceStatus = '3';
}
else
{
MessageBox.Show("输入错误");
return;
}
Save.UpdateResouce(resource);
MessageBox.Show("保存成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.ResourceManageForm_Load(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 读取资源信息
/// </summary>
private void load()
{
try
{
dgvResource.Rows.Clear();
ConferenceAuditorBLL Resource = new ConferenceAuditorBLL();
List <ResourceModel> ResourceList = new List <ResourceModel>();
ResourceList = Resource.GetAllResource();
int n = 0;
foreach (ResourceModel resource in ResourceList)
{
dgvResource.Rows.Add();
dgvResource.Rows[n].Cells["ColumnResourceId"].Value = resource.ResourceId;
dgvResource.Rows[n].Cells["ColumnResourceClass"].Value = resource.ResourceClass;
if (resource.ResourceStatus == '0')
{
dgvResource.Rows[n].Cells["ColumnResourceStatus"].Value = "空闲";
}
if (resource.ResourceStatus == '1')
{
dgvResource.Rows[n].Cells["ColumnResourceStatus"].Value = "被预订";
}
if (resource.ResourceStatus == '2')
{
dgvResource.Rows[n].Cells["ColumnResourceStatus"].Value = "使用中";
}
if (resource.ResourceStatus == '3')
{
dgvResource.Rows[n].Cells["ColumnResourceStatus"].Value = "损坏";
}
n++;
}
txtResId.Text = this.dgvResource.CurrentRow.Cells["ColumnResourceId"].Value.ToString();
cmbResClass.Text = this.dgvResource.CurrentRow.Cells["ColumnResourceClass"].Value.ToString();
cmbStatus.Text = this.dgvResource.CurrentRow.Cells["ColumnResourceStatus"].Value.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void cmbSelect_SelectionChangeCommitted(object sender, EventArgs e)
{
List <BoardroomModel> bdrlist = new List <BoardroomModel>();
ConferenceAuditorBLL conabll = new ConferenceAuditorBLL();
bdrlist = conabll.GetBoardroomInfo("");
foreach (BoardroomModel bdr in bdrlist)
{
if (bdr.BdrName.ToString() == cmbSelect.SelectedItem.ToString())
{
lblId.Text = bdr.BdrId.ToString();
lblName.Text = bdr.BdrName;
lblContactNum.Text = bdr.BdrContactNum.ToString();
lblIntro.Text = bdr.BdrIntro;
lblRemarks.Text = bdr.BdrRemarks;
lblStatus.Text = bdr.BdrStatus.ToString();
lblConMan.Text = bdr.BdrLinkMan;
lblConPhone.Text = bdr.BdrContactPhone;
}
}
}
/// <summary>
/// 读取议题信息
/// </summary>
/// <param name="statut">状态</param>
/// <param name="statusDisplay">状态名称</param>
/// <param name="dgvTopic">填充的表格</param>
/// <param name="Name">列名前缀</param>
/// <param name="query">查询的内容</param>
private void load(char statut, string statusDisplay, DataGridView dgvTopic, string Name, string query)
{
try
{
dgvTopic.Rows.Clear();
TopicAuditorBLL Topic = new TopicAuditorBLL();
List <TopicModel> TopicList = new List <TopicModel>();
ConferenceAuditorBLL GetAEmployee = new ConferenceAuditorBLL();
TopicList = Topic.GetTopicInfo(query);
int n = 0;
foreach (TopicModel topic in TopicList)
{
if (topic.TopicStatus == statut)
{
dgvTopic.Rows.Add();
dgvTopic.Rows[n].Cells[Name + "Id"].Value = topic.TopicId;
dgvTopic.Rows[n].Cells[Name + "ApplicantId"].Value = topic.TopicApplicantId;
dgvTopic.Rows[n].Cells[Name + "Applicant"].Value = GetAEmployee.GetAEmployee(topic.TopicApplicantId).EmName;
dgvTopic.Rows[n].Cells[Name + "SubTime"].Value = topic.TopicSubTime;
if (topic.TopicStatus == '0')
{
dgvTopic.Rows[n].Cells[Name + "VerifyTime"].Value = "";
}
else
{
dgvTopic.Rows[n].Cells[Name + "VerifyTime"].Value = topic.TopicVerifyTime;
}
dgvTopic.Rows[n].Cells[Name + "Head"].Value = topic.TopicHead;
dgvTopic.Rows[n].Cells[Name + "Content"].Value = topic.TopicContent;
dgvTopic.Rows[n].Cells[Name + "Status"].Value = statusDisplay;
n++;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 确认提交
/// </summary>
private void Ensure()
{
try
{
ConferenceAuditorBLL Upd = new ConferenceAuditorBLL();
BoardroomModel boardroom = new BoardroomModel();
boardroom.BdrId = bdrid.BdrId;
if (this.ComtxtBdrs.Text == "正常")
{
boardroom.BdrStatus = '1';
}
else
{
boardroom.BdrStatus = '0';
}
boardroom.BdrName = this.txtBdrName.Text;
boardroom.BdrContactNum = int.Parse(this.txtBdrContact.Text);
boardroom.BdrLinkMan = this.txtConMan.Text;
boardroom.BdrContactPhone = this.txtConPhone.Text;
boardroom.BdrIntro = this.txtConIntro.Text;
boardroom.BdrRemarks = this.txtConRemarks.Text;
if (Upd.UpdateBoardroom(boardroom))
{
MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("该会议室存在会议,不可修改", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 删除资源信息
/// </summary>
private void Del()
{
if (MessageBox.Show("确定删除该条资源信息?该操作不可恢复!", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
try
{
ConferenceAuditorBLL Del = new ConferenceAuditorBLL();
ResourceModel resource = new ResourceModel();
string resourceid = this.dgvResource.CurrentRow.Cells["ColumnResourceId"].Value.ToString();; //获取当前行要修改的资源ID
resource.ResourceId = int.Parse(resourceid);
Del.DelAResource(resource);
MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.ResourceManageForm_Load(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
