/// <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);
}
