public ActionResult GetCreateTreeData()
{
SqlModel model = SqlModel.Select(@"select a.area_code,a.area_text,b.area_text parenttext from T_SYS_AREA a left join T_SYS_AREA b on a.parent_code = b.area_code WHERE a.RELATION_TYPE < 4 AND a.Remark = 1 and a.parent_code='410100'").Native();
DataTable dt = model.ExecToDataTable();
return(Json(dt.ToDynamicList()));
}
public ActionResult GetIndustryData(RequestData data)
{
StringBuilder sql = new StringBuilder();
sql.Append(@" (SELECT distinct '410010' AS id,'0' AS parentId , '行业' AS text, '行业' AS SortNo, '行业' AS prefix, '行业' AS relationtype from basdic ) UNION(select to_char(basdic.code) AS id, '410010' AS parentId,to_char(basdic.title) AS text , '行业' AS SortNo, '行业' AS prefix, '行业' AS relationtype from basdic where typecode='IndustryType' ) ");
SqlModel sqlModel = SqlModel.Select(sql.ToString()).Native();
var json = sqlModel.ExecToDataTable().ToDynamicComboTree("0", "prefix,relationtype");
return(Json(json));
}
public ActionResult GetAreaData()
{
if (CurrentUser.UserTypeID == ((int)PowerType.ProvincialUser).ToString())
{
SqlModel model = SqlModel.Select("T".Field("id"), "T".Field("parentId"), "T".Field("text"), "T".Field("SortNo"), "T".Field("prefix"), "T".Field("relationtype"))
.From(
(
SqlModel.Select(T_SYS_AREA.AREA_CODE.ToChar().As("id"),
"0".As("parentId"),
T_SYS_AREA.AREA_TEXT.ToChar().As("text"),
T_SYS_AREA.ORDER_ID.ToChar().As("SortNo"),
T_SYS_AREA.LICENSE_PLATE_PREFIX.ToChar().As("prefix"),
T_SYS_AREA.RELATION_TYPE.ToChar().As("relationtype")
)
.From(DB.T_SYS_AREA)
.Where(T_SYS_AREA.AREA_CODE.In(SqlModel.Select(BASDIC.CODE).From(DB.BASDIC).Where(BASDIC.TITLE == "SysAreaCode")))
)
.Union
(
SqlModel.Select(T_SYS_AREA.AREA_CODE.ToChar().As("id"),
T_SYS_AREA.PARENT_CODE.ToChar().As("parentId"),
T_SYS_AREA.AREA_TEXT.ToChar().As("text"),
T_SYS_AREA.ORDER_ID.ToChar().As("SortNo"),
T_SYS_AREA.LICENSE_PLATE_PREFIX.ToChar().As("prefix"),
T_SYS_AREA.RELATION_TYPE.ToChar().As("relationtype")
)
.From(DB.T_SYS_AREA)
.Where(T_SYS_AREA.PARENT_CODE.In(SqlModel.Select(BASDIC.CODE).From(DB.BASDIC).Where(BASDIC.TITLE == "SysAreaCode")))
).As("T")
)
.OrderByAsc("T".Field("SortNo"));
//SqlModel model = SqlModel.Select(T_SYS_AREA.AREA_CODE.ToChar().As("id"),
// T_SYS_AREA.PARENT_CODE.ToChar().As("parentId"),
// T_SYS_AREA.AREA_TEXT.ToChar().As("text"),
// T_SYS_AREA.ORDER_ID.ToChar().As("SortNo"),
// T_SYS_AREA.LICENSE_PLATE_PREFIX.ToChar().As("prefix"),
// T_SYS_AREA.RELATION_TYPE.ToChar().As("relationtype")
// )
// .From(DB.T_SYS_AREA)
// .Where(T_SYS_AREA.AREA_CODE.In(SqlModel.Select(BASDIC.CODE).From(DB.BASDIC).Where(BASDIC.TITLE == "SysAreaCode")) |
// T_SYS_AREA.PARENT_CODE.In(SqlModel.Select(BASDIC.CODE).From(DB.BASDIC).Where(BASDIC.TITLE == "SysAreaCode"))
// ).OrderByAsc(T_SYS_AREA.ORDER_ID);
var json = model.ExecToDataTable().ToDynamicComboTree("0", "prefix,relationtype");
return(Json(json));
}
else if (CurrentUser.UserTypeID == ((int)PowerType.AreaUser).ToString())
{
DataTable dt =
SqlModel.Select("T".Field("id"), "T".Field("parentId"), "T".Field("text"), "T".Field("SortNo"), "T".Field("prefix"), "T".Field("relationtype"))
.From(
//(
// SqlModel.Select((-1).As("id"), 0.As("parentId"), "请选择区域信息".As("text"), 0.As("SortNo"), 0.As("prefix"), 0.As("relationtype"))
// .From(DB.T_SYS_AREA)
//)
//.Union
(
SqlModel.Select(T_SYS_AREA.AREA_CODE.ToChar().As("id"),
(0).As("parentId"),
T_SYS_AREA.AREA_TEXT.ToChar().As("text"),
T_SYS_AREA.ID.ToChar().As("SortNo"),
T_SYS_AREA.LICENSE_PLATE_PREFIX.ToChar().As("prefix"),
T_SYS_AREA.RELATION_TYPE.ToChar().As("relationtype")
)
.From(DB.T_SYS_AREA)
.Where(T_SYS_AREA.PARENT_CODE.In(SqlModel.Select(BASDIC.CODE).From(DB.BASDIC).Where(BASDIC.TITLE == "SysAreaCode")) & T_SYS_AREA.AREA_CODE == CurrentUser.AreaCode
)
).As("T")
)
.OrderByAsc("T".Field("SortNo"))
.ExecToDataTable();
var json = dt.ToDynamicComboTree("0", "prefix,relationtype");
return(Json(json));
}
return(Json(""));
}
