/// <summary>
/// 保存内部与会人员签到信息
/// </summary>
private void InSave()
{
try
{
ExecutorBLL Execu = new ExecutorBLL();
InConMemberModel InCon = new InConMemberModel();
for (int n = 0; n < dgvInRegister.Rows.Count; n++)
{
string selectValue = dgvInRegister.Rows[n].Cells["ColumnInConRegister"].EditedFormattedValue.ToString();
if (selectValue == "True")
{
InCon.ConId = Convert.ToInt32(conid);
InCon.ConRegister = '1';
InCon.ConEmId = int.Parse(dgvInRegister.Rows[n].Cells["ColumnEmId"].Value.ToString());
Execu.InConMemberRegister(InCon);
}
else
{
InCon.ConId = Convert.ToInt32(conid);
InCon.ConRegister = '0';
InCon.ConEmId = int.Parse(dgvInRegister.Rows[n].Cells["ColumnEmId"].Value.ToString());
Execu.InConMemberRegister(InCon);
}
}
MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
InQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 保存外部与会人员签到信息
/// </summary>
private void OutSave()
{
try
{
ExecutorBLL Execu = new ExecutorBLL();
OutConMemberModel OutCon = new OutConMemberModel();
for (int n = 0; n < dgvOutRegister.Rows.Count; n++)
{
string selectValue = dgvOutRegister.Rows[n].Cells["ColumnConRegister"].EditedFormattedValue.ToString();
if (selectValue == "True")
{
OutCon.ConId = Convert.ToInt32(conid);
OutCon.ConRegister = '1';
OutCon.ConPhone = dgvOutRegister.Rows[n].Cells["ColumnConPhone"].Value.ToString();
Execu.OutConMemberRegister(OutCon);
}
else
{
OutCon.ConId = Convert.ToInt32(conid);
OutCon.ConRegister = '0';
OutCon.ConPhone = dgvOutRegister.Rows[n].Cells["ColumnConPhone"].Value.ToString();
Execu.OutConMemberRegister(OutCon);
}
}
MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
OutQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ConferenceModForm_Load(object sender, EventArgs e)
{
bindtopic();
bindhost();
bindPlace();
UserBLL userbll = new UserBLL();
ExecutorBLL exebll = new ExecutorBLL();
List <ConferenceModel> conlist = new List <ConferenceModel>();
conlist = userbll.GetConferenceInfo(selecetedConId.ToString());
foreach (ConferenceModel con in conlist)
{
if (con.ConId == selecetedConId)
{
cmbTopic.Text = con.ConName;
cmbHost.Text = con.ConHost;
List <BoardroomModel> bdrlist = new List <BoardroomModel>();
bdrlist = userbll.GetBoardroomInfo(con.ConPlace.ToString());
foreach (BoardroomModel bdr in bdrlist)
{
cmbPlace.Text = bdr.BdrName;
}
dtpEnd.Value = con.ConEndTime;
dtpStart.Value = con.ConStartTime;
List <ResourceModel> reslist = new List <ResourceModel>();
reslist = userbll.GetConUseResourceInfo(con.ConId);
foreach (ResourceModel res in reslist)
{
cklStaff.Items.Add(res.ResourceId + " " + res.ResourceClass);
}
con.ConOthers = rtxRemarks.Text;
cklStaff.Enabled = false;
}
}
}
/// <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 Ensure()
{
try
{
ExecutorBLL Add = new ExecutorBLL();
OutConMemberModel OutConMember = new OutConMemberModel();
OutConMember.ConId = conid.Conid;
OutConMember.ConName = this.txtConName.Text;
OutConMember.ConSex = this.cmbConSex.Text;
OutConMember.ConDuties = this.txtConDuties.Text;
OutConMember.ConPhone = this.txtConPhone.Text;
OutConMember.ConEmail = this.txtConEmail.Text;
OutConMember.ConCompany = this.txtConCompany.Text;
OutConMember.ConRegister = '0';
Add.AddConMenRecord(OutConMember);
this.DialogResult = DialogResult.OK;
MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 查询内部与会人员信息
/// </summary>
private void InQuery()
{
try
{
dgvInConMember.Rows.Clear();
ExecutorBLL InConMember = new ExecutorBLL();
List <EmployeeModel> EmployeeList = new List <EmployeeModel>();
ConferenceModel Conid = new ConferenceModel();
Conid.ConId = Convert.ToInt32(conid);
EmployeeList = InConMember.GetInConMemberInfo(Conid);
int n = 0;
foreach (EmployeeModel employee in EmployeeList)
{
dgvInConMember.Rows.Add();
dgvInConMember.Rows[n].Cells["ColumnEmId"].Value = employee.EmId;
dgvInConMember.Rows[n].Cells["ColumnEmName"].Value = employee.EmName;
dgvInConMember.Rows[n].Cells["ColumnEmPermission"].Value = employee.EmPermission;
dgvInConMember.Rows[n].Cells["ColumnEmSex"].Value = employee.EmSex;
dgvInConMember.Rows[n].Cells["ColumnEmDepart"].Value = employee.EmDepart;
dgvInConMember.Rows[n].Cells["ColumnEmPhone"].Value = employee.EmPhone;
dgvInConMember.Rows[n].Cells["ColumnEmEmail"].Value = employee.EmEmail;
dgvInConMember.Rows[n].Cells["ColumnEmCompany"].Value = employee.EmCompany;
dgvInConMember.Rows[n].Cells["ColumnEmDuties"].Value = employee.EmDuties;
n++;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 查询内部与会人员签到信息
/// </summary>
private void InQuery()
{
try
{
dgvInRegister.Rows.Clear();
ExecutorBLL InConMember = new ExecutorBLL();
List <EmployeeModel> EmployeeList = new List <EmployeeModel>();
List <InConMemberModel> inconList = new List <InConMemberModel>();
ConferenceModel Conid = new ConferenceModel();
ConferenceModel Con = new ConferenceModel();
Conid.ConId = Convert.ToInt32(conid);
EmployeeList = InConMember.GetInConMemberInfo(Conid);
int n = 0;
foreach (EmployeeModel employee in EmployeeList)
{
dgvInRegister.Rows.Add();
dgvInRegister.Rows[n].Cells["ColumnEmId"].Value = employee.EmId;
dgvInRegister.Rows[n].Cells["ColumnEmName"].Value = employee.EmName;
dgvInRegister.Rows[n].Cells["ColumnEmPhone"].Value = employee.EmPhone;
dgvInRegister.Rows[n].Cells["ColumnEmDuties"].Value = employee.EmDuties;
Con.ConId = Conid.ConId;
inconList = InConMember.GetInConMemberRegisterInfo(Con);
foreach (InConMemberModel incon in inconList)
{
if (incon.ConEmId == employee.EmId)
{
if (incon.ConRegister == '1')
{
((DataGridViewCheckBoxCell)dgvInRegister.Rows[n].Cells["ColumnInConRegister"]).Value = true;
}
if (incon.ConRegister == '0')
{
((DataGridViewCheckBoxCell)dgvInRegister.Rows[n].Cells["ColumnInConRegister"]).Value = false;
}
}
dgvInRegister.Rows[n].Cells["ColumnConId2"].Value = incon.ConId;
}
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>
/// 查询外部与会人员信息
/// </summary>
private void OutQuery()
{
try
{
dgvOutConMember.Rows.Clear();
ExecutorBLL OutConMember = new ExecutorBLL();
List <OutConMemberModel> OutConMemberList = new List <OutConMemberModel>();
ConferenceModel Conid = new ConferenceModel();
Conid.ConId = Convert.ToInt32(conid);
OutConMemberList = OutConMember.GetOutConMemberRegisterInfo(Conid);
int n = 0;
foreach (OutConMemberModel outConMember in OutConMemberList)
{
dgvOutConMember.Rows.Add();
dgvOutConMember.Rows[n].Cells["ColumnConId"].Value = outConMember.ConId;
dgvOutConMember.Rows[n].Cells["ColumnConName"].Value = outConMember.ConName;
dgvOutConMember.Rows[n].Cells["ColumnConSex"].Value = outConMember.ConSex;
dgvOutConMember.Rows[n].Cells["ColumnConDuties"].Value = outConMember.ConDuties;
dgvOutConMember.Rows[n].Cells["ColumnConPhone"].Value = outConMember.ConPhone;
dgvOutConMember.Rows[n].Cells["ColumnConEmail"].Value = outConMember.ConEmail;
dgvOutConMember.Rows[n].Cells["ColumnConCompany"].Value = outConMember.ConCompany;
if (outConMember.ConRegister == '1')
{
dgvOutConMember.Rows[n].Cells["ColumnConRegister"].Value = "已签到";
}
else
{
dgvOutConMember.Rows[n].Cells["ColumnConRegister"].Value = "未签到";
}
n++;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
