| | |
| | | /// </summary> |
| | | public static int SelectLayerPid(SysPublish sys, SysMeta meta) |
| | | { |
| | | string sql = GetSelectLayerPidSql(meta); |
| | | string sql = GetSelectLayerPidSql(meta, meta.ismeta); |
| | | int pid = Tools.DBHelper.GetIntScalar(sql); |
| | | string dirid = sys.dirid.Substring(0, 2); |
| | | |
| | |
| | | /// <summary> |
| | | /// 获取查询图层父节点ID的SQL |
| | | /// </summary> |
| | | public static string GetSelectLayerPidSql(SysMeta meta) |
| | | public static string GetSelectLayerPidSql(SysMeta meta, int isModel) |
| | | { |
| | | string noneSql = "select id from lf.sys_layer where cn_name = '其他' and pid = (select id from lf.sys_layer where cn_name = '工程数据' order by pid limit 1)"; |
| | | |
| | |
| | | if ("DOM".Equals(meta.type)) |
| | | return "select id from lf.sys_layer where cn_name = '数字正射影像图' and pid = (select id from lf.sys_layer where cn_name = '测绘' order by pid limit 1)"; |
| | | else |
| | | return "select id from lf.sys_layer where cn_name = '单体模型' and pid = (select id from lf.sys_layer where cn_name = '测绘' order by pid limit 1)"; |
| | | { |
| | | //return "select id from lf.sys_layer where cn_name = '单体模型' and pid = (select id from lf.sys_layer where cn_name = '测绘' order by pid limit 1)"; |
| | | return string.Format("select id from lf.sys_layer where cn_name = '{0}' and pid = (select id from lf.sys_layer where cn_name = '测绘' order by pid limit 1)", isModel > 0 ? "单体模型" : "倾斜摄影数据"); |
| | | } |
| | | } |
| | | |
| | | if (meta.dirname.IndexOf("\\地灾") > -1) |