private void tvDeptList_AfterSelect(object sender, TreeViewEventArgs e)
{
if (e.Node.Level == 1)
{
objControlService.init_GroupBox(groupBox);
int deptid = Convert.ToInt32(e.Node.Tag.ToString()); //查询、删除时使用
JiGou objJiGou = objJiGouService.GetJiGouByJiGouID(DateTime.Now, deptid); //查询创建对象
this.txtDeptId.Text = objJiGou.机构编号.ToString();
this.txtDept.Text = objJiGou.机构简称.ToString();
objControlService.DisabledGroupBoxItem(groupBox);
}
else if (e.Node.Level == 2)
{
#region 点选表格中的一行时，把内容送到编辑区
id = Convert.ToInt32(e.Node.Tag.ToString()); //查询、删除时使用
Admin objAdmin = objAdminService.GetAdminByID(DateTime.Now, id); //查询创建对象
this.txtDeptId.Text = objAdmin.deptid.ToString();
this.txtDept.Text = objAdmin.dept.ToString();
this.txtUserId.Text = objAdmin.userid.ToString();
this.txtUserName.Text = objAdmin.username.ToString();
this.ckbAttendance.Checked = objAdmin.Attendance;
this.ckbOvertime.Checked = objAdmin.Overtime;
this.ckbEvaluation.Checked = objAdmin.Evaluation;
this.ckbAssessment.Checked = objAdmin.Assessment;
this.txtBeiZhu.Text = objAdmin.备注.ToString();
this.txtStartDate.Text = string.Format("{0:yyyy.MM.dd}", Convert.ToDateTime(objAdmin.开始日期.ToString()));
this.txtEndDate.Text = string.Format("{0:yyyy.MM.dd}", Convert.ToDateTime(objAdmin.结束日期.ToString()));
objControlService.EnabledGroupBoxItem(groupBox);
this.txtDeptId.Enabled = false;
this.txtDept.Enabled = false;
////给当前机构编号最大值赋值
//maxDeptID = objJiGouService.GetMaxDeptID();
////给新设同级机构编号赋值
//currentParentID = Convert.ToInt32(objJiGou.ParentID.ToString());
//maxParentSortID = Convert.ToInt32(objJiGouService.GetMaxSortID(objJiGou.ParentID));
////给新设下级机构编号赋值
//currentDeptID = Convert.ToInt32(objJiGou.机构编号.ToString());
//maxChildSortID = Convert.ToInt32(objJiGouService.GetMaxSortID(objJiGou.机构编号));
////点保存时使用
//bAdd = false;
#endregion
}
else
{
objControlService.init_GroupBox(groupBox);
objControlService.DisabledGroupBoxItem(groupBox);
}
}
/// <summary>
/// 修改机构对象
/// </summary>
/// <param name="objJiGou"></param>
/// <returns></returns>
public int ModifyJiGouByJiGouID(JiGou objJiGou)
{
//1、编写SQL语句
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("update org_dept set 机构名称 = '{0}',机构简称 = '{1}',开始日期 = '{2}',结束日期 = '{3}',成立日期 = '{4}',成立文号 = '{5}',内设机构层级 = '{6}',是否虚拟组织 = '{7}',是否挂靠组织 = '{8}',备注 = '{9}',ParentID = {10},排序 = {11},更改者 = '{12}',更改日期 = '{13}'");
sqlBuilder.Append(" where 机构编号 = {14}");
//2、解析对象
string sql = string.Format(sqlBuilder.ToString(), objJiGou.机构名称, objJiGou.机构简称, objJiGou.开始日期, objJiGou.结束日期, objJiGou.成立日期, objJiGou.成立文号, objJiGou.内设机构层级, objJiGou.是否虚拟组织, objJiGou.是否挂靠组织, objJiGou.备注, objJiGou.ParentID, objJiGou.排序, objJiGou.更改者, objJiGou.更改日期, objJiGou.机构编号);
//3、执行SQL语句，返回结果
return(SQLHelper.Update(sql));
}
/// <summary>
/// 增加机构对象
/// </summary>
/// <param name="objJiGou"></param>
/// <returns></returns>
public int AddJiGou(JiGou objJiGou)
{
//1、编写SQL语句
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("insert into org_dept (机构名称,机构简称,开始日期,结束日期,成立日期,成立文号,内设机构层级,是否虚拟组织,是否挂靠组织,备注,ParentID,排序,更改者,更改日期)");
sqlBuilder.Append(" values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}',{10},{11},'{12}','{13}')");
//2、解析对象
string sql = string.Format(sqlBuilder.ToString(), objJiGou.机构名称, objJiGou.机构简称, objJiGou.开始日期, objJiGou.结束日期, objJiGou.成立日期, objJiGou.成立文号, objJiGou.内设机构层级, objJiGou.是否虚拟组织, objJiGou.是否挂靠组织, objJiGou.备注, objJiGou.ParentID, objJiGou.排序, objJiGou.更改者, objJiGou.更改日期);
//3、执行SQL语句，返回结果
return(SQLHelper.Update(sql));
}
/// <summary>
/// 根据节点的tag查询详细信息，并输出给GroupBox
/// </summary>
/// <param name="intDeptId"></param>
private void GetDeptGroupBox(int intDeptId)
{
JiGou objJiGou = objJiGouService.GetJiGouByJiGouID(DateTime.Now, intDeptId); //查询创建对象
this.cmbJiGouLevel.Text = objJiGou.机构类型长文本.ToString();
this.txtJiGouFullName.Text = objJiGou.机构名称.ToString();
this.txtJiGouShortName.Text = objJiGou.机构简称.ToString();
this.txtChengLiRiQi.Text = objJiGou.成立日期.ToString();
this.txtChengLiWenHao.Text = objJiGou.成立文号.ToString();
this.ckbIsXuNiZuZhi.Checked = objJiGou.是否虚拟组织;
this.ckbIsGuaKaoZuZhi.Checked = objJiGou.是否挂靠组织;
this.txtBeiZhu.Text = objJiGou.备注.ToString();
this.txtStartDate.Text = string.Format("{0:yyyy.MM.dd}", Convert.ToDateTime(objJiGou.开始日期.ToString()));
this.txtEndDate.Text = string.Format("{0:yyyy.MM.dd}", Convert.ToDateTime(objJiGou.结束日期.ToString()));
}
/// <summary>
/// 查询单一组织（部门、班组）对象
/// </summary>
/// <param name="current_date_gz"></param>
/// <param name="JiGouID"></param>
/// <returns></returns>
public JiGou GetJiGouByJiGouID(DateTime dateTime, int id)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("select 机构编号,机构名称,机构简称,机构类型长文本,开始日期,结束日期,成立日期,成立文号,内设机构层级, 是否虚拟组织, 是否挂靠组织, 备注, ParentID, 排序, 更改者, 更改日期 from org_dept");
sqlBuilder.Append(" inner join bas_Dept on bas_Dept.DT = org_dept.内设机构层级");
sqlBuilder.Append(" where '{0}' between 开始日期 and 结束日期 and 机构编号 = {1}");
string sql = string.Format(sqlBuilder.ToString(), dateTime, id);
SqlDataReader objReader = SQLHelper.GetReader(sql);
JiGou objJiGou = null;
if (objReader.Read())
{
objJiGou = new JiGou()
{
机构编号 = Convert.ToInt32(objReader["机构编号"].ToString()),
机构名称 = objReader["机构名称"].ToString(),
机构简称 = objReader["机构简称"].ToString(),
开始日期 = Convert.ToDateTime(objReader["开始日期"].ToString()),
结束日期 = Convert.ToDateTime(objReader["结束日期"].ToString()),
成立日期 = objReader["成立日期"].ToString(),
成立文号 = objReader["成立文号"].ToString(),
内设机构层级 = objReader["内设机构层级"].ToString(),
是否虚拟组织 = objReader["是否虚拟组织"] is DBNull ? false : (bool)objReader["是否虚拟组织"],
是否挂靠组织 = objReader["是否挂靠组织"] is DBNull ? false : (bool)objReader["是否挂靠组织"],
备注 = objReader["备注"].ToString(),
ParentID = Convert.ToInt32(objReader["ParentID"].ToString()),
排序 = Convert.ToInt32(objReader["排序"].ToString()),
更改者 = objReader["更改者"].ToString(),
更改日期 = Convert.ToDateTime(objReader["更改日期"].ToString()),
机构类型长文本 = objReader["机构类型长文本"].ToString()
};
}
objReader.Close();
return(objJiGou);
}
private void tsbSave_Click(object sender, EventArgs e)
{
if (bAdd == true)//新增数据
{
#region 数据验证
if (this.txtJiGouFullName.Text.Trim().Length == 0)
{
MessageBox.Show("请输入机构名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.txtJiGouShortName.Text.Trim().Length == 0)
{
MessageBox.Show("请输入机构简称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.cmbJiGouLevel.Text.Trim().Length == 0)
{
MessageBox.Show("请选择机构层级！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.txtBeiZhu.Text.Trim().Length > 30)
{
MessageBox.Show("备注内容不能超过30个字符！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
#endregion
#region 封装对象
JiGou objJiGou = new JiGou()
{
机构名称 = this.txtJiGouFullName.Text.Trim(),
机构简称 = this.txtJiGouShortName.Text.Trim(),
开始日期 = Convert.ToDateTime(this.txtStartDate.Text.Trim()),
结束日期 = Convert.ToDateTime(this.txtEndDate.Text.Trim()),
成立日期 = this.txtChengLiRiQi.Text.Trim(),
成立文号 = this.txtChengLiWenHao.Text.Trim(),
内设机构层级 = this.cmbJiGouLevel.SelectedValue.ToString(),
是否虚拟组织 = this.ckbIsXuNiZuZhi.Checked,
是否挂靠组织 = this.ckbIsGuaKaoZuZhi.Checked,
备注 = this.txtBeiZhu.Text.Trim(),
ParentID = intParentId,
排序 = -1,
更改者 = Program.currentAdmin.username,
更改日期 = DateTime.Now
};
#endregion
#region 调用后台数据访问对象添加数据
try
{
if (objJiGouService.AddJiGou(objJiGou) == 1)
{
LoadDeptList();
objControlService.init_GroupBox(gbDept);
MessageBox.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;//返回修改成功的信息
objControlService.DisabledGroupBoxItem(gbDept);
bAdd = false;
tsbModify.Enabled = true;
tsbADDParent.Enabled = true;
tsbADDChild.Enabled = true;
}
else
{
MessageBox.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
#endregion
}
if (bModify == true)//修改数据
{
#region 数据验证
if (this.txtJiGouFullName.Text.Trim().Length == 0)
{
MessageBox.Show("请输入机构名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.txtJiGouShortName.Text.Trim().Length == 0)
{
MessageBox.Show("请输入机构简称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.cmbJiGouLevel.Text.Trim().Length == 0)
{
MessageBox.Show("请选择机构层级！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.txtBeiZhu.Text.Trim().Length > 30)
{
MessageBox.Show("备注内容不能超过30个字符！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
#endregion
#region 封装对象
JiGou objJiGou = new JiGou()
{
机构编号 = nTreeViewId,
机构名称 = this.txtJiGouFullName.Text.Trim(),
机构简称 = this.txtJiGouShortName.Text.Trim(),
开始日期 = Convert.ToDateTime(this.txtStartDate.Text.Trim()),
结束日期 = Convert.ToDateTime(this.txtEndDate.Text.Trim()),
成立日期 = this.txtChengLiRiQi.Text.Trim(),
成立文号 = this.txtChengLiWenHao.Text.Trim(),
内设机构层级 = this.cmbJiGouLevel.SelectedValue.ToString(),
是否虚拟组织 = this.ckbIsXuNiZuZhi.Checked,
是否挂靠组织 = this.ckbIsGuaKaoZuZhi.Checked,
备注 = this.txtBeiZhu.Text.Trim(),
ParentID = objJiGouService.GetParentId(true, nTreeViewId),
排序 = objJiGouService.GetDeptSortID(nTreeViewId),
更改者 = Program.currentAdmin.username,
更改日期 = DateTime.Now
};
#endregion
#region 调用后台数据访问对象修改数据
try
{
if (objJiGouService.ModifyJiGouByJiGouID(objJiGou) == 1)
{
LoadDeptList();
objControlService.init_GroupBox(gbDept);
MessageBox.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;//返回修改成功的信息
objControlService.DisabledGroupBoxItem(gbDept);
bModify = false;
tsbModify.Enabled = true;
tsbADDParent.Enabled = true;
tsbADDChild.Enabled = true;
}
else
{
MessageBox.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
#endregion
}
}
