/// <summary> /// 获取所有部门列表 /// </summary> /// <returns>部门集合</returns> public IList<Organization> GetAllOrganization() { IList<Organization> list = new List<Organization>(); string sql = "select * from TB_Organization order by ParentId asc"; DataSet ds = AccessHelper.ExecuteDataSet(_connectionString, sql); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { Organization org = new Organization(); org.OId = (int)row["OId"]; org.ParentId = (int)row["ParentId"]; org.OName = (string)row["OName"]; if (!Convert.IsDBNull(row["Comment"])) { org.Comment = (string)row["Comment"]; } list.Add(org); } } return list; }
private void btnOk_Click(object sender, EventArgs e) { string name = txtName.Text.Trim(); string comment = txtComment.Text.Trim(); if (name.Length == 0) { MessageBox.Show("名称不能为空"); return; } Organization org = new Organization(); org.ParentId = _parentId; org.OName = name; org.Comment = comment; oBll.Insert(org); MessageBox.Show("添加成功!"); this.DialogResult = DialogResult.OK; this.Close(); }
/// <summary> /// 修改部门 /// </summary> /// <param name="org">部门对象</param> /// <returns>影响行数</returns> public int Update(Organization org) { string sql = "update TB_Organization set ParentId=@ParentId,OName=@OName,Comment=@Comment where OId=@OId"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@ParentId",org.ParentId), new OleDbParameter("@OName",org.OName), new OleDbParameter("@Comment",org.Comment), new OleDbParameter("@OId",org.OId) }; int count = AccessHelper.ExecuteNonQuery(_connectionString, sql, param); return count; }
/// <summary> /// 添加部门 /// </summary> /// <param name="org">部门对象</param> /// <returns>ID</returns> public int Insert(Organization org) { string sql = "insert into TB_Organization(ParentId,OName,Comment) "; sql += "values(@ParentId,@OName,@Comment)"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@ParentId",org.ParentId), new OleDbParameter("@OName",org.OName), new OleDbParameter("@Comment",org.Comment) }; AccessHelper.ExecuteNonQuery(_connectionString, sql, param); object id = AccessHelper.ExecuteScalar(_connectionString, "select @@identity"); return Convert.ToInt32(id); }
/// <summary> /// 根据员工ID获取部门对象 /// </summary> /// <param name="eId">员工ID</param> /// <returns>部门对象</returns> public Organization GetOrganizationByEId(int eId) { Organization org = null; string sql = "select O.* from TB_Organization O,TB_EmployeeOrg EO where O.OId=EO.OId and EO.EId=" + eId; DataSet ds = AccessHelper.ExecuteDataSet(_connectionString, sql); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; org = new Organization(); org.OId = (int)row["OId"]; org.ParentId = (int)row["ParentId"]; org.OName = (string)row["OName"]; if (!Convert.IsDBNull(row["Comment"])) { org.Comment = (string)row["Comment"]; } } return org; }
/// <summary> /// 修改部门 /// </summary> /// <param name="org">部门对象</param> /// <returns>影响行数</returns> public int Update(Organization org) { return _dal.Update(org); }
/// <summary> /// 添加部门 /// </summary> /// <param name="org">部门对象</param> /// <returns>ID</returns> public int Insert(Organization org) { return _dal.Insert(org); }