/// <summary> /// 获取单条记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static T_SYS_LAYER_Model getModel(T_SYS_LAYER_SW sw) { DataTable dt = BaseDT.T_SYS_LAYER.getDT2(sw); T_SYS_LAYER_Model m = new T_SYS_LAYER_Model(); if (dt.Rows.Count > 0) { int i = 0; //数据库表字段 m.LAYERCODE = dt.Rows[i]["LAYERCODE"].ToString(); m.LAYERNAME = dt.Rows[i]["LAYERNAME"].ToString(); m.LAYERID = dt.Rows[i]["LAYERID"].ToString(); m.ISACTION = dt.Rows[i]["ISACTION"].ToString(); m.LAYERRIGHTID = dt.Rows[i]["LAYERRIGHTID"].ToString(); m.ISDEFAULTCH = dt.Rows[i]["ISDEFAULTCH"].ToString(); m.ISFIREROUNDDEFAULT = dt.Rows[i]["ISFIREROUNDDEFAULT"].ToString(); m.ISFUROUNDDEFAULT = dt.Rows[i]["ISFUROUNDDEFAULT"].ToString(); m.LAYERPICNAME = dt.Rows[i]["LAYERPICNAME"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); //扩充字段 } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取树形三维图层控制菜单(所有节点默认为false) /// </summary> /// <param name="sw"></param> /// <returns></returns> public static string getTckzTreeChecked(T_SYS_LAYER_SW sw) { JArray jObjects = new JArray(); DataTable dtLayer = BaseDT.T_SYS_LAYER.getDT(sw); DataRow[] drLayer = dtLayer.Select("", "LAYERCODE"); if (drLayer.Length > 0) { if (drLayer[0]["LAYERCODE"].ToString().Length == 2) { JObject root = new JObject { { "id", drLayer[0]["LAYERCODE"].ToString() }, { "text", drLayer[0]["LAYERNAME"].ToString() } }; root.Add("children", getTckzTreeChildChecked(dtLayer, drLayer[0]["LAYERCODE"].ToString())); jObjects.Add(root); } else { JObject root = new JObject { { "id", drLayer[0]["LAYERCODE"].ToString() }, { "text", drLayer[0]["LAYERNAME"].ToString() } }; jObjects.Add(root); } } dtLayer.Clear(); dtLayer.Dispose(); return(JsonConvert.SerializeObject(jObjects)); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在</returns> public static bool isExists(T_SYS_LAYER_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from T_SYS_LAYER where 1=1"); if (string.IsNullOrEmpty(sw.LAYERCODE) == false) { sb.AppendFormat(" and LAYERCODE= '{0}'", ClsSql.EncodeSql(sw.LAYERCODE)); } if (string.IsNullOrEmpty(sw.LAYERID) == false) { sb.AppendFormat(" and LAYERID= '{0}'", ClsSql.EncodeSql(sw.LAYERID)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 获取权限图层数据列表 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(T_SYS_LAYER_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT LAYERCODE, LAYERNAME, LAYERID, ISACTION, LAYERRIGHTID, ISDEFAULTCH,ISFIREROUNDDEFAULT,ISFUROUNDDEFAULT, ORDERBY FROM T_SYS_LAYER"); sb.AppendFormat(" Where 1=1 "); sb.AppendFormat(" and ISACTION=0"); sb.AppendFormat(" or("); sb.AppendFormat(" LAYERRIGHTID in( "); sb.AppendFormat(" select rightid from T_SYSSEC_ROLE_RIGHT where roleid in(select roleid from T_SYSSEC_USER_ROLE where USERID='{0}') ", ClsSql.EncodeSql(sw.USERID)); sb.AppendFormat(" ))"); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 获取三维图层控制LAYERCODE /// </summary> public static string getLayerLAYERCODEStr(T_SYS_LAYER_SW sw) { DataTable dt = BaseDT.T_SYS_LAYER.getDT(sw); string LAYERCODE = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (i != dt.Rows.Count - 1) { LAYERCODE += dt.Rows[i]["LAYERCODE"].ToString() + ","; } else { LAYERCODE += dt.Rows[i]["LAYERCODE"].ToString(); } } return(LAYERCODE); }
/// <summary> /// 获取三维图层控制ISDEFAULTCH /// </summary> public static string getLayerDEFAULTCHStr(T_SYS_LAYER_SW sw) { DataTable dt = BaseDT.T_SYS_LAYER.getDT(sw); string ISDEFAULTCH = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (i != dt.Rows.Count - 1) { ISDEFAULTCH += dt.Rows[i]["ISDEFAULTCH"].ToString() + ","; } else { ISDEFAULTCH += dt.Rows[i]["ISDEFAULTCH"].ToString(); } } return(ISDEFAULTCH); }
/// <summary> /// 获取图层数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns></returns> public static DataTable getDT2(T_SYS_LAYER_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT LAYERCODE, LAYERNAME, LAYERID, ISACTION, LAYERRIGHTID, ISDEFAULTCH,ISFIREROUNDDEFAULT,ISFUROUNDDEFAULT,LAYERPICNAME, ORDERBY FROM T_SYS_LAYER WHERE 1=1"); if (!string.IsNullOrEmpty(sw.LAYERCODE)) { sb.AppendFormat(" AND LAYERCODE = '{0}'", ClsSql.EncodeSql(sw.LAYERCODE)); } if (!string.IsNullOrEmpty(sw.LAYERNAME)) { sb.AppendFormat(" AND LAYERNAME like '%{0}%'", ClsSql.EncodeSql(sw.LAYERNAME)); } string sql = sb.ToString() + " ORDER BY LAYERCODE "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取三维图层LAYERID用于护林员周边查询 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static string getLayerHuLinYuanLAYERID(T_SYS_LAYER_SW sw) { DataTable dt = BaseDT.T_SYS_LAYER.getDT(sw); string LAYERID = ""; DataRow[] drOrg = dt.Select("ISFUROUNDDEFAULT = '1'"); for (int i = 0; i < drOrg.Length; i++) { if (i != drOrg.Length - 1) { LAYERID += drOrg[i]["LAYERID"].ToString() + ","; } else { LAYERID += drOrg[i]["LAYERID"].ToString(); } } return(LAYERID); }
/// <summary> /// 获取树形图层用于火点周边查询 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static string getTreeFireQuery(T_SYS_LAYER_SW sw) { JArray jObjects = new JArray(); DataTable dtLayer = BaseDT.T_SYS_LAYER.getDT(sw); if (dtLayer != null && dtLayer.Rows.Count > 0) { DataRow[] drOrg = dtLayer.Select("Len(LAYERCODE) = '2'"); if (drOrg.Length > 0) { JObject root = new JObject { { "id", drOrg[0]["LAYERID"].ToString() }, { "text", drOrg[0]["LAYERNAME"].ToString() } }; JArray childArray = new JArray(); DataRow[] drOrg1 = dtLayer.Select("Len(LAYERCODE) = '4' AND SUBSTRING(LAYERCODE,1,3)='010'");//点,线,面 for (int i = 0; i < drOrg1.Length; i++) { JObject root1 = new JObject { { "id", drOrg1[i]["LAYERID"].ToString() }, { "text", drOrg1[i]["LAYERNAME"].ToString() } }; JArray childArray1 = new JArray(); DataRow[] drOrg2 = dtLayer.Select("(ISFIREROUNDDEFAULT='1' AND SUBSTRING(LAYERCODE,1,5)='" + drOrg1[i]["LAYERCODE"].ToString() + "0" + "') OR (ISFIREROUNDDEFAULT='1' AND SUBSTRING(LAYERCODE,1,5)='" + drOrg1[i]["LAYERCODE"].ToString() + "1" + "')"); for (int j = 0; j < drOrg2.Length; j++) { JObject root2 = new JObject { { "id", drOrg2[j]["LAYERID"].ToString() }, { "text", drOrg2[j]["LAYERNAME"].ToString() } }; childArray1.Add(root2); } root1.Add("children", childArray1); childArray.Add(root1); } root.Add("children", childArray); jObjects.Add(root); } } dtLayer.Clear(); dtLayer.Dispose(); return(JsonConvert.SerializeObject(jObjects)); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型PEST_REPORT_HAPPEN_SW</param> /// <returns>参见模型PEST_REPORT_HAPPEN_Model</returns> public static IEnumerable <T_SYS_LAYER_Model> getListModel(T_SYS_LAYER_SW sw) { var result = new List <T_SYS_LAYER_Model>(); DataTable dt = BaseDT.T_SYS_LAYER.getDT2(sw); for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_LAYER_Model m = new T_SYS_LAYER_Model(); m.LAYERCODE = dt.Rows[i]["LAYERCODE"].ToString(); m.LAYERNAME = dt.Rows[i]["LAYERNAME"].ToString(); m.LAYERID = dt.Rows[i]["LAYERID"].ToString(); m.ISACTION = dt.Rows[i]["ISACTION"].ToString(); m.LAYERRIGHTID = dt.Rows[i]["LAYERRIGHTID"].ToString(); m.ISDEFAULTCH = dt.Rows[i]["ISDEFAULTCH"].ToString(); m.ISFIREROUNDDEFAULT = dt.Rows[i]["ISFIREROUNDDEFAULT"].ToString(); m.ISFUROUNDDEFAULT = dt.Rows[i]["ISFUROUNDDEFAULT"].ToString(); m.LAYERPICNAME = dt.Rows[i]["LAYERPICNAME"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取树形三维图层控制菜单 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static string getTree(T_SYS_LAYER_SW sw) { JArray jObjects = new JArray(); DataTable dtLayer = BaseDT.T_SYS_LAYER.getDT(sw); if (dtLayer != null && dtLayer.Rows.Count > 0) { DataRow[] drOrg = dtLayer.Select("Len(LAYERCODE) = '2'"); if (drOrg.Length > 0) { JObject root = new JObject { { "id", drOrg[0]["LAYERCODE"].ToString() }, { "text", drOrg[0]["LAYERNAME"].ToString() } }; JArray childArray = new JArray(); DataRow[] drOrg1 = dtLayer.Select("Len(LAYERCODE) = '4' AND SUBSTRING(LAYERCODE,1,3)='010'");//点,线,面 for (int i = 0; i < drOrg1.Length; i++) { JObject root1 = new JObject { { "id", drOrg1[i]["LAYERCODE"].ToString() }, { "text", drOrg1[i]["LAYERNAME"].ToString() } }; JArray childArray1 = new JArray(); DataRow[] drOrg2 = dtLayer.Select("(Len(LAYERCODE) = '6' AND SUBSTRING(LAYERCODE,1,5)='" + drOrg1[i]["LAYERCODE"].ToString() + "0" + "') OR (Len(LAYERCODE) = '6' AND SUBSTRING(LAYERCODE,1,5)='" + drOrg1[i]["LAYERCODE"].ToString() + "1" + "')"); for (int j = 0; j < drOrg2.Length; j++) { JObject root2 = new JObject { { "id", drOrg2[j]["LAYERCODE"].ToString() }, { "text", drOrg2[j]["LAYERNAME"].ToString() }, { "state", "closed" } }; JArray childArray2 = new JArray(); DataRow[] drOrg3 = dtLayer.Select("Len(LAYERCODE) = '8' AND SUBSTRING(LAYERCODE,1,7)='" + drOrg2[j]["LAYERCODE"].ToString() + "0" + "'"); for (int k = 0; k < drOrg3.Length; k++) { JObject root3 = new JObject { { "id", drOrg3[k]["LAYERCODE"].ToString() }, { "text", drOrg3[k]["LAYERNAME"].ToString() } }; if (drOrg3[k]["ISDEFAULTCH"].ToString() == "1") { root3 = new JObject { { "id", drOrg3[k]["LAYERCODE"].ToString() }, { "text", drOrg3[k]["LAYERNAME"].ToString() }, { "checked", true } }; } JArray childArray3 = new JArray(); DataRow[] drOrg4 = dtLayer.Select("Len(LAYERCODE) = '10' AND SUBSTRING(LAYERCODE,1,9)='" + drOrg3[k]["LAYERCODE"].ToString() + "0" + "'"); for (int m = 0; m < drOrg4.Length; m++) { JObject root4 = new JObject { { "id", drOrg4[m]["LAYERCODE"].ToString() }, { "text", drOrg4[m]["LAYERNAME"].ToString() } }; if (drOrg4[m]["ISDEFAULTCH"].ToString() == "1") { root4 = new JObject { { "id", drOrg4[m]["LAYERCODE"].ToString() }, { "text", drOrg4[m]["LAYERNAME"].ToString() }, { "checked", true } }; } childArray3.Add(root4); } root3.Add("children", childArray3); childArray2.Add(root3); } if (drOrg3.Count() > 0) { root2.Add("children", childArray2); } else { root2 = new JObject { { "id", drOrg2[j]["LAYERCODE"].ToString() }, { "text", drOrg2[j]["LAYERNAME"].ToString() } } }; if (drOrg2[j]["ISDEFAULTCH"].ToString() == "1") { root2 = new JObject { { "id", drOrg2[j]["LAYERCODE"].ToString() }, { "text", drOrg2[j]["LAYERNAME"].ToString() }, { "checked", true } }; } childArray1.Add(root2); } root1.Add("children", childArray1); childArray.Add(root1); } root.Add("children", childArray); jObjects.Add(root); } } dtLayer.Clear(); dtLayer.Dispose(); return(JsonConvert.SerializeObject(jObjects)); }