public ZuZhiFenPei GetZuZhiByUserID(DateTime dateTime, string strUserId)
{
string sql = "select a.id,a.人员编号,a.开始日期,a.结束日期,a.人事范围,a.人事子范围,a.员工组,a.员工子组,a.工资范围,a.职位编码,a.备注,a.更改者,a.更改日期,b.姓名,c.EG,c.员工子组的名称,d.职位名称,f.机构名称 as 二级内设机构,e.机构名称 as 三级内设机构,e.内设机构层级 from emp_org a ";
sql += " left join emp_bas b on b.人员编号 = a.人员编号";
sql += " left join bas_subgroup c on c.EG = a.员工子组";
sql += " left join org_posi d on d.职位编码 = a.职位编码";
sql += " left join org_dept e on e.机构编号 = d.ParentID";
sql += " left join org_dept f on f.机构编号 = e.ParentID";
sql += " where '{0}' between a.开始日期 and a.结束日期 and a.人员编号 = '{1}' ";
sql = string.Format(sql, dateTime, strUserId);
SqlDataReader objReader = SQLHelper.GetReader(sql);
ZuZhiFenPei objZuZhiFenPei = null;
if (objReader.Read())
{
objZuZhiFenPei = new ZuZhiFenPei()
{
id = Convert.ToInt32(objReader["id"].ToString()),
人员编号 = objReader["人员编号"].ToString(),
开始日期 = Convert.ToDateTime(objReader["开始日期"].ToString()),
结束日期 = Convert.ToDateTime(objReader["结束日期"].ToString()),
人事范围 = objReader["人事范围"].ToString(),
人事子范围 = objReader["人事子范围"].ToString(),
员工组 = objReader["员工组"].ToString(),
员工子组 = objReader["员工子组"].ToString(),
工资范围 = objReader["工资范围"].ToString(),
职位编码 = Convert.ToInt32(objReader["职位编码"].ToString()),
备注 = objReader["备注"].ToString(),
更改者 = objReader["更改者"].ToString(),
更改日期 = Convert.ToDateTime(objReader["更改日期"].ToString()),
姓名 = objReader["姓名"].ToString(),
员工子组的名称 = objReader["员工子组的名称"].ToString(),
职位名称 = objReader["职位名称"].ToString(),
二级内设机构 = objReader["二级内设机构"].ToString(),
级内设机构 = objReader["三级内设机构"].ToString(),
内设机构层级 = objReader["内设机构层级"].ToString(),
};
}
objReader.Close();
//如果是二级内设机构时，将三机内设机构的值赋给二级，并清空三级的值。
if (objZuZhiFenPei.内设机构层级 == "02")
{
objZuZhiFenPei.二级内设机构 = objZuZhiFenPei.级内设机构;
objZuZhiFenPei.级内设机构 = null;
}
return(objZuZhiFenPei);
}
/// <summary>
/// 修改人员对象
/// </summary>
/// <param name="objZuZhiFenPei"></param>
/// <returns></returns>
public int Modify(ZuZhiFenPei objZuZhiFenPei)
{
//1、编写SQL语句
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("update emp_org set 人员编号 = '{0}',开始日期 = '{1}',结束日期 = '{2}',人事范围 = '{3}',人事子范围 = '{4}',员工组 = '{5}',员工子组 = '{6}',工资范围 = '{7}',职位编码 = {8},备注 = '{9}',更改者 = '{10}',更改日期 = '{11}'");
sqlBuilder.Append(" where id = {12}");
//2、解析对象
string sql = string.Format(sqlBuilder.ToString(), objZuZhiFenPei.人员编号, objZuZhiFenPei.开始日期, objZuZhiFenPei.结束日期, objZuZhiFenPei.人事范围, objZuZhiFenPei.人事子范围, objZuZhiFenPei.员工组, objZuZhiFenPei.员工子组, objZuZhiFenPei.工资范围, objZuZhiFenPei.职位编码, objZuZhiFenPei.备注, objZuZhiFenPei.更改者, objZuZhiFenPei.更改日期, objZuZhiFenPei.id);
//3、执行SQL语句，返回结果
return(SQLHelper.Update(sql));
}
/// <summary>
/// 根据dataGridView双击行数据查询人员组织信息
/// </summary>
/// <param name="strUserId"></param>
private void GetUserInfoGroupBox(string strUserId)
{
ZuZhiFenPei objZuZhiFenPei = objZuZhiFenPeiService.GetZuZhiByUserID(DateTime.Now, strUserId);
this.txtUserID.Text = objZuZhiFenPei.人员编号;
this.txtViewName.Text = objZuZhiFenPei.姓名;
this.txtZuZhiDanWei.Text = objZuZhiFenPei.二级内设机构 + objZuZhiFenPei.级内设机构;
this.txtRenShiFanWei.Text = objZuZhiFenPei.人事范围;
this.txtYuanGongZu.Text = objZuZhiFenPei.员工组;
this.txtZhiWei.Text = objZuZhiFenPei.职位名称;
this.txtRenShiZiFanWei.Text = objZuZhiFenPei.人事子范围;
this.txtYuanGongZiZu.Text = objZuZhiFenPei.员工子组的名称;
}
/// <summary>
/// 增加人员对象
/// </summary>
/// <param name="objZuZhiFenPei"></param>
/// <returns></returns>
public int Add(ZuZhiFenPei objZuZhiFenPei)
{
//1、编写SQL语句
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("insert into emp_org (人员编号,开始日期,结束日期,人事范围,人事子范围,员工组,员工子组,工资范围,职位编码,备注,更改者,更改日期)");
sqlBuilder.Append(" values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},'{9}','{10}','{11}')");
//2、解析对象
string sql = string.Format(sqlBuilder.ToString(), objZuZhiFenPei.人员编号, objZuZhiFenPei.开始日期, objZuZhiFenPei.结束日期, objZuZhiFenPei.人事范围, objZuZhiFenPei.人事子范围, objZuZhiFenPei.员工组, objZuZhiFenPei.员工子组, objZuZhiFenPei.工资范围, objZuZhiFenPei.职位编码, objZuZhiFenPei.备注, objZuZhiFenPei.更改者, objZuZhiFenPei.更改日期);
//3、执行SQL语句，返回结果
return(SQLHelper.Update(sql));
}
/// <summary>
/// 根据dataGridView双击行数据查询组织分配
/// </summary>
/// <param name="strUserId"></param>
private void GetZuZhiFenPeitabPage(string strUserId)
{
ZuZhiFenPei objZuZhiFenPei = objZuZhiFenPeiService.GetZuZhiByUserID(DateTime.Now, strUserId);
this.txtZuZhiStartDate.Text = string.Format("{0:yyyy.MM.dd}", Convert.ToDateTime(objZuZhiFenPei.开始日期.ToString()));
this.txtZuZhiEndDate.Text = string.Format("{0:yyyy.MM.dd}", Convert.ToDateTime(objZuZhiFenPei.结束日期.ToString()));
this.txtTabRenShiFanWei.Text = objZuZhiFenPei.人事范围;
this.txtTabRenShiZiFanWei.Text = objZuZhiFenPei.人事子范围;
this.txtTabYuanGongZu.Text = objZuZhiFenPei.员工组;
this.txtTabGongZiFanWei.Text = objZuZhiFenPei.工资范围;
this.cmbYuanGongZiZu.Text = objZuZhiFenPei.员工子组的名称;
this.txtTabZhiWeiBianMa.Text = objZuZhiFenPei.职位编码.ToString();
this.txtTabZhiWei.Text = objZuZhiFenPei.职位名称;
this.txtTabSuoShuErJiJiGou.Text = objZuZhiFenPei.二级内设机构;
this.txtTabSuoShuSanJiJiGou.Text = objZuZhiFenPei.级内设机构;
}
private ZuZhiFenPei FengZhuangDuiXiang_ZuZhi()
{
ZuZhiFenPei objZuZhiFenPei = new ZuZhiFenPei()
{
id = Convert.ToInt32(this.dgvProject.CurrentRow.Cells["id"].Value.ToString()),
人员编号 = this.txtUserID.Text.Trim(),
开始日期 = Convert.ToDateTime(this.txtZuZhiStartDate.Text.Trim()),
结束日期 = Convert.ToDateTime(this.txtZuZhiEndDate.Text.Trim()),
人事范围 = this.txtTabRenShiFanWei.Text.Trim(),
人事子范围 = this.txtTabRenShiZiFanWei.Text.Trim(),
员工组 = this.txtTabYuanGongZu.Text.Trim(),
员工子组 = this.cmbYuanGongZiZu.SelectedIndex == -1 ? null : this.cmbYuanGongZiZu.SelectedValue.ToString(),
工资范围 = this.txtTabGongZiFanWei.Text.Trim(),
职位编码 = Convert.ToInt32(this.txtTabZhiWeiBianMa.Text.Trim()),
备注 = this.txtTabZuZhiRemark.Text.Trim(),
更改者 = Program.currentAdmin.username,
更改日期 = DateTime.Now
};
return(objZuZhiFenPei);
}
private void tsbSave_Click(object sender, EventArgs e)
{
if (bAdd == true)//新增数据
{
#region 数据验证
#endregion
#region 封装对象
//UserInfo objUserInfo = FengZhuangDuiXiang_UserInfo();
//ZuZhiFenPei objZuZhiFenPei = FengZhuangDuiXiang_ZuZhi();
#endregion
#region 调用后台数据访问对象添加数据
try
{
int intResult = 0;
if (tabControl1.SelectedTab == tabPage1)
{
UserInfo objUserInfo = FengZhuangDuiXiang_UserInfo();
intResult = objUserInfoService.Add(objUserInfo);
}
else if (tabControl1.SelectedTab == tabPage2)
{
ZuZhiFenPei objZuZhiFenPei = FengZhuangDuiXiang_ZuZhi();
intResult = objZuZhiFenPeiService.Add(objZuZhiFenPei);
}
if (intResult == 1)
{
DialogResult result = MessageBox.Show("添加成功，是否继续添加？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
tsbADD_Click(null, null);
}
else
{
bAdd = false;
if (tabControl1.SelectedTab == tabPage1)
{
objControlService.init_tabPage(tabPage1);
objControlService.DisabledTabPageItem(tabPage1);
init_dgvUserInfo();
init_dgvProject(this.txtUserID.Text.Trim());
}
else if (tabControl1.SelectedTab == tabPage2)
{
objControlService.init_tabPage(tabPage2);
objControlService.DisabledTabPageItem(tabPage2);
init_dgvProject(this.txtUserID.Text.Trim());
}
//init_dgvUserInfo();
}
}
else
{
MessageBox.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
#endregion
}
if (bModify == true)//修改数据
{
#region 数据验证
#endregion
#region 封装对象
//UserInfo objUserInfo = FengZhuangDuiXiang_UserInfo();
//ZuZhiFenPei objZuZhiFenPei = FengZhuangDuiXiang_ZuZhi();
#endregion
#region 调用后台数据访问对象修改数据
try
{
int intResult = 0;
if (tabControl1.SelectedTab == tabPage1)
{
UserInfo objUserInfo = FengZhuangDuiXiang_UserInfo();
intResult = objUserInfoService.Modify(objUserInfo);
}
else if (tabControl1.SelectedTab == tabPage2)
{
ZuZhiFenPei objZuZhiFenPei = FengZhuangDuiXiang_ZuZhi();
intResult = objZuZhiFenPeiService.Modify(objZuZhiFenPei);
}
if (intResult == 1)
{
bModify = false;
if (tabControl1.SelectedTab == tabPage1)
{
objControlService.init_tabPage(tabPage1);
objControlService.DisabledTabPageItem(tabPage1);
init_dgvUserInfo();
init_dgvProject(this.txtUserID.Text.Trim());
}
else if (tabControl1.SelectedTab == tabPage2)
{
objControlService.init_tabPage(tabPage2);
objControlService.DisabledTabPageItem(tabPage2);
init_dgvProject(this.txtUserID.Text.Trim());
}
MessageBox.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;//返回修改成功的信息
}
else
{
MessageBox.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
#endregion
}
}
