/// <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);
}
}
} // function AddConMenRecord
/// <summary>
/// 添加内部与会人员
/// </summary>
/// <returns> 添加内部与会人员</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-20
/// 修改时间:
public void AddConMenRecord(InConMemberModel inConMen)
{
try
{
InConMemberDAL ICMDAL = new InConMemberDAL();
ICMDAL.AddARecord(inConMen);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
} // function AddConMenRecord
} // function DelARecord
/// <summary>
/// 向数据库内部与会人员表中修改信息
/// </summary>
/// <param name="obj">要修改的内部与会人员信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool UpdateARecord(object obj)
{
try
{
InConMemberModel InConMember = (InConMemberModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("update InConMember set ConRegister='{2}' where ConId ='{0}'and ConEmId='{1}'",
InConMember.ConId, InConMember.ConEmId, InConMember.ConRegister);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function UpdateARecord
} // function AddARecord
/// <summary>
/// 从数据库内部与会人员表中删除一条信息
/// </summary>
/// <param name="obj">要删除的内部与会人员信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool DelARecord(object obj)
{
try
{
InConMemberModel InConMember = (InConMemberModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("Delete from InconMember where ConId ='{0}'and ConEmId='{1}'",
InConMember.ConId, InConMember.ConEmId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function DelARecord
/// <summary>
/// 向数据库内部与会人员表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的内部与会人员信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool AddARecord(object obj)
{
try
{
InConMemberModel InConMember = (InConMemberModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("insert into InconMember values('{0}','{1}','{2}')",
InConMember.ConId, InConMember.ConEmId, InConMember.ConRegister);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function AddARecord
} // function UpdateARecord
/// <summary>
/// 获取内部参会者的状态
/// </summary>
/// <param name="conId">会议ID</param>
/// <returns>返回内部参会者</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-22
/// 修改时间:
public List <InConMemberModel> GetInConRecord(int conId)
{
try
{
List <InConMemberModel> InConMemberList = new List <InConMemberModel>();
InConMemberModel InConMember = new InConMemberModel();
DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, "select * from InConMember where Conid='" + conId + "'", "InConMember");
foreach (DataRow row in data.Tables["InConMember"].Rows)
{
InConMember.ConId = Convert.ToInt32(row["ConId"]);
InConMember.ConEmId = Convert.ToInt32(row["EmId"]);
InConMember.ConRegister = char.Parse(row["ConRegister"].ToString());
InConMemberList.Add(InConMember);
}
return(InConMemberList);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}// function GetInConRecord
/// <summary>
/// 申请，将数据添加到数据库中
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnEnsure_Click(object sender, EventArgs e)
{
DialogResult result;
result = MessageBox.Show("确定申请?", "系统消息", MessageBoxButtons.OKCancel);
if (cmbHost.Text != "" && cmbTopic.Text != "")
{
if (result == DialogResult.OK)
{
con.ConHost = cmbHost.Text;
con.ConSubMen = emp.EmId;
con.ConOthers = rtxRemarks.Text;
con.ConPlace = bdrPlace;
con.ConStartTime = constart;
con.ConEndTime = conend;
con.ConStatus = '0';
con.ConIsDone = '0';
con.ConName = cmbTopic.Text;
con.ConRecordMen = Convert.ToInt32(cmbRecMan.SelectedValue);
// 随机选择会务执行人
List<EmployeeModel> emlist = new List<EmployeeModel>();
List<EmployeeModel> onelist = new List<EmployeeModel>();
emlist = userbll.GetAllEmployee();
foreach (EmployeeModel em2 in emlist)
{
if (em2.EmPermission == "CE")
{
onelist.Add(em2);
}
}
Random r = new Random();
int ecId = r.Next(0, onelist.Count - 1);
con.ConStaffMen = onelist[ecId].EmId;
// 会议使用资源表中添加条目
List<string> rscList = new List<string>();
IEnumerator myEnumerator = cklStaff.CheckedIndices.GetEnumerator();
int index;
string[] rsc;
while (myEnumerator.MoveNext())
{
index = (int)myEnumerator.Current;
cklStaff.SelectedItem = cklStaff.Items[index];
rsc = cklStaff.Text.Split(' ');
rscList.Add(rsc[0]);
//MessageBox.Show(rsc[0]);
}
int ConId = userbll.ConApply(con, rscList);
for (int i = 0; i < addconmem.dataset.Tables["table"].Rows.Count; i++)
{
InConMemberModel ICMM = new InConMemberModel();
ICMM.ConId = ConId;
DataRow dr;
dr = addconmem.dataset.Tables["table"].Rows[i];
ICMM.ConEmId = Convert.ToInt32(dr["员工ID"]);
ICMM.ConRegister = '0';
userbll.AddConMenRecord(ICMM);
}
// 申请会议
MessageBox.Show("申请成功，请耐心等待管理员审核通知");
this.Close();
}
} // end if
else
{
MessageBox.Show("请填写完整信息");
}
}
}// function GetTask
/// <summary>
/// 内部与会人员签到
/// </summary>
/// <param name="RegisterMan"></param>
/// 作者:王宇昊
/// 创建时间:2014-09-19
/// 修改时间:
public void InConMemberRegister(InConMemberModel RegisterMan)
{
InConMemberDAL ICMDAL = new InConMemberDAL();
ICMDAL.UpdateARecord(RegisterMan);
}// function InConMemberRegister
