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 } }