/// <summary>
/// 获得部门的集合
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public IList<Department> GetDepartMent(Department dept)
{
IList<Department> datalist = new List<Department>();
string strWhere = string.Empty;
if (!string.IsNullOrEmpty(dept.CompanyCode)) strWhere = "a.CCODE = '" + dept.CompanyCode + "' And ";
if (!string.IsNullOrEmpty(dept.DeptCode)) strWhere = "a.DeptCode in (" + dept.DeptCode + ") And ";
string strSql = "select * from Department a left join Company b on a.ccode = b.ccode where {0} 1 = 1 order by a.OrderNo";
strSql = string.Format(strSql, strWhere);
IDataReader dr = OracleHelper.ExecuteReader(strSql);
while (dr.Read())
{
Department deptEntity = new Department();
deptEntity.DeptCode = dr["DeptCode"].ToString();
deptEntity.DeptName = dr["DeptName"].ToString();
deptEntity.FullName = string.Format("{0}--{1}", dr["cName"].ToString(), dr["DeptName"].ToString());
deptEntity.Description = dr["Description"].ToString();
datalist.Add(deptEntity);
}
dr.Close();
return datalist;
}
public Users()
{
company = new Company();
role = new Role();
depart = new Department();
}
public bool ManageDeartMent(Department dept)
{
string strSql = string.Empty;
switch (dept.Action)
{
case ActionEnum.Insert:
strSql = "select nvl(Max(OrderNo),0) + 1 OrderNo from department where cCode = '" + dept.CompanyCode + "'";
string orderNo = OracleHelper.ExecuteDataTable(strSql).Rows[0][0].ToString();
strSql = "Insert into DepartMent(DeptCode,CCODE,DeptName,Description,OrderNo) Values ('{1}'||{0},'{1}','{2}','{3}','{4}')";
strSql = string.Format(strSql, "seq_department.Nextval", dept.CompanyCode, dept.DeptName, dept.Description, orderNo);
break;
case ActionEnum.Update:
strSql = "Update DepartMent Set DeptName = '{1}',Description = '{2}' Where DeptCode = {0}";
strSql = string.Format(strSql, dept.DeptCode, dept.DeptName, dept.Description);
break;
case ActionEnum.Delete:
strSql = "delete from DepartMent Where DeptCode = {0}";
strSql = string.Format(strSql, dept.DeptCode);
break;
}
return OracleHelper.ExecuteCommand(strSql);
}
/// <summary>
/// 查询部门
/// </summary>
/// <param name="dept"></param>
/// <returns></returns>
public IList<Department> QueryDepartMent(Department dept)
{
IList<Department> datalist = new List<Department>();
string strWhere = string.Empty;
if (!string.IsNullOrEmpty(dept.CompanyCode)) strWhere += "a.CCODE like '" + CommonHelper.GetShortCode(dept.CompanyCode) + "%' And ";
if (!string.IsNullOrEmpty(dept.QueryDeptLevel))
{
if (dept.QueryDeptLevel.IndexOf(",") == -1)
{
if (dept.QueryDeptLevel.Equals(((int)CompanyTypeEnum.SHI).ToString()))
{
strWhere += "length(b.ShortCCode) = 4 And ";
}
if (dept.QueryDeptLevel.Equals(((int)CompanyTypeEnum.XIAN).ToString()))
{
strWhere += "length(b.ShortCCode) = 6 And ";
}
}
}
string strSql = "select * from Department a left join Company b on a.ccode = b.ccode where {0} 1 = 1 order by a.ccode, a.orderno";
strSql = string.Format(strSql, strWhere);
IDataReader dr = OracleHelper.ExecuteReader(strSql);
while (dr.Read())
{
Department deptEntity = new Department();
deptEntity.DeptCode = dr["DeptCode"].ToString();
deptEntity.DeptName = dr["DeptName"].ToString();
deptEntity.FullName = string.Format("{0}--{1}", dr["cName"].ToString(), dr["DeptName"].ToString());
deptEntity.Description = dr["Description"].ToString();
datalist.Add(deptEntity);
}
dr.Close();
return datalist;
}
