/// <summary>
/// 根据当前的Org信息,获取子节点
/// </summary>
/// <param name="orgs">如果参数为null,则返回顶级列表</param>
/// <returns></returns>
public PartlyCollection <WdOrg> GetChildOrg(WdOrg orgs = null)
{
PartlyCollection <WdOrg> result = new PartlyCollection <WdOrg>();
string sqlCommand = string.Empty;
if (orgs == null)
{
sqlCommand = "SELECT parentUnitID ParentID,OrgID, OrgName,ShortName,[order] OrderID, FullPath FROM dbo.wd_org WHERE isRoot = 1 AND parentStatus = 1 ORDER BY [order]";
}
else
{
sqlCommand = string.Format("SELECT parentUnitID ParentID,OrgID, OrgName,ShortName,[order] OrderID FROM dbo.wd_org WHERE parentUnitID = {0} AND parentStatus = 1 ORDER BY [order]", orgs.OrgID);;
}
DataSet ds = DbHelper.RunSqlReturnDS(sqlCommand, ConnectionName);
if (ds != null)
{
DataTable table = ds.Tables[0];
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
WdOrg view = new WdOrg();
ORMapping.DataRowToObject <WdOrg>(row, view);
result.Add(view);
}
}
}
return(result);
}
public WdOrg GetOrgByName(string orgName)
{
WdOrg result = null;
string sqlCommand = string.Empty;
sqlCommand = string.Format(@"SELECT parentUnitID ParentID,OrgID, OrgName,ShortName,[order] OrderID , FullPath
FROM dbo.wd_org WHERE [orgName] ='{0}' ORDER BY [order]",
SqlTextHelper.SafeQuote(orgName));
DataSet ds = DbHelper.RunSqlReturnDS(sqlCommand, ConnectionName);
if (ds != null)
{
DataTable table = ds.Tables[0];
if (table != null && table.Rows.Count > 0)
{
WdOrg view = new WdOrg();
ORMapping.DataRowToObject <WdOrg>(table.Rows[0], view);
result = view;
}
}
return(result);
}
public List <WdOrg> GetOrgList()
{
List <WdOrg> result = new List <WdOrg>();
string sqlCommand = string.Empty;
sqlCommand = "SELECT parentUnitID ParentID,OrgID, OrgName,ShortName,[order] OrderID FROM dbo.wd_org WHERE parentStatus = 1 ORDER BY [order]";
DataSet ds = DbHelper.RunSqlReturnDS(sqlCommand, ConnectionName);
if (ds != null)
{
DataTable table = ds.Tables[0];
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
WdOrg view = new WdOrg();
ORMapping.DataRowToObject <WdOrg>(row, view);
result.Add(view);
}
}
}
return(result);
}
public PartlyCollection <WdOrg> GetChildOrg(WdOrg orgs = null)
{
PartlyCollection <WdOrg> result = WdOrgAdapter.Instance.GetChildOrg(orgs);
return(result);
}
