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("")); }