private static string _root = "E:\\TCPJW_Developer\\Code\\TCPJW.OA\\ImageServer";// SysStatic.GetNoStaticNode("imageServer").Text;
/// <summary>
/// 省
/// </summary>
/// <returns></returns>
public static List <StaticEntity> GetProDataSource()
{
tcpjw3.oa.Models.tcpjwEntities db = new tcpjw3.oa.Models.tcpjwEntities();
List <StaticEntity> list = new List <StaticEntity>();
var query = (from sysParent in db.SysStatic
join sysChild in db.SysStatic on sysParent.ID equals sysChild.PID
where sysParent.Value.Equals("administrative_regions")
select sysChild).Distinct();
foreach (var item in query)
{
StaticEntity entity = new StaticEntity();
entity.Text = item.Text;
entity.Value = item.Value;
list.Add(entity);
}
return(list);
}
/// <summary>
/// 城市
/// </summary>
/// <returns></returns>
public static List <StaticEntity> GetCityDataSource(string parentValue)
{
tcpjw3.oa.Models.tcpjwEntities db = new tcpjw3.oa.Models.tcpjwEntities();
List <StaticEntity> list = new List <StaticEntity>();
if (string.IsNullOrEmpty(parentValue))
{
return(list);
}
var query = (from sysParent in db.SysStatic
join sysChild in db.SysStatic on sysParent.ID equals sysChild.PID
where sysParent.Value.Equals(parentValue)
select sysChild).Distinct();
foreach (var item in query)
{
StaticEntity entity = new StaticEntity();
entity.Text = item.Text;
entity.Value = item.Value;
list.Add(entity);
}
return(list);
}
