Esempio n. 1
0
        /// <summary>
        /// 获取列表分页
        /// </summary>
        /// <param name="sw"></param>
        /// <param name="total"></param>
        /// <returns></returns>
        public static IEnumerable <SDE_GONGYILIN_Model> getModelPager(SDE_GONGYILIN_Model sw, out int total)
        {
            var       result = new List <SDE_GONGYILIN_Model>();
            DataTable dt     = BaseDT.SDE.GONGYILIN.getDT(sw, out total);//列表

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                var m = GetModel(dt, i);
                result.Add(m);
            }
            dt.Clear();
            dt.Dispose();
            return(result);
        }
Esempio n. 2
0
        /// <summary>
        /// 获取公益林数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static DataTable getDT(SDE_GONGYILIN_Model model)
        {
            StringBuilder sb = new StringBuilder();

            sb.AppendFormat("SELECT *,shape.STCentroid().STX AS STX ,shape.STCentroid().STY AS STY FROM GONGYILIN Where 1=1 ");
            if (!string.IsNullOrEmpty(model.OBJECTID))
            {
                sb.AppendFormat(" AND OBJECTID = {0}", ClsSql.EncodeSql(model.OBJECTID));
            }
            if (!string.IsNullOrEmpty(model.SqlStr))
            {
                sb.AppendFormat(" AND {0} ", model.SqlStr);
            }

            DataSet ds = SDEDataBaseClass.FullDataSet(sb.ToString());

            return(ds.Tables[0]);
        }
Esempio n. 3
0
        /// <summary>
        /// 获取分页数据
        /// </summary>
        /// <param name="sw"></param>
        /// <param name="total"></param>
        /// <returns></returns>
        public static DataTable getDT(SDE_GONGYILIN_Model sw, out int total)
        {
            StringBuilder sb = new StringBuilder();

            sb.AppendFormat("  from   GONGYILIN  ");
            sb.AppendFormat("where 1=1");
            if (!string.IsNullOrEmpty(sw.COUNTY))
            {
                sb.AppendFormat(" AND 县 LIKE '%{0}%'", ClsSql.EncodeSql(sw.COUNTY));
            }
            if (!string.IsNullOrEmpty(sw.COUNTRY))
            {
                sb.AppendFormat(" AND 乡 LIKE '%{0}%'", ClsSql.EncodeSql(sw.COUNTRY));
            }
            if (!string.IsNullOrEmpty(sw.VILLAGE))
            {
                sb.AppendFormat(" AND 村 LIKE '%{0}%'", ClsSql.EncodeSql(sw.VILLAGE));
            }
            if (!string.IsNullOrEmpty(sw.LINBAN))
            {
                sb.AppendFormat(" AND 林班 = '{0}'", ClsSql.EncodeSql(sw.LINBAN));
            }
            if (!string.IsNullOrEmpty(sw.XIAOBAN))
            {
                sb.AppendFormat(" AND 小班 = '{0}'", ClsSql.EncodeSql(sw.XIAOBAN));
            }
            string sql  = ("select *, shape.STCentroid().STX AS STX ,shape.STCentroid().STY AS STY ") + sb.ToString() + (" order by OBJECTID desc ");
            string sqlC = "select count(1) " + sb.ToString();

            total      = int.Parse(SDEDataBaseClass.ReturnSqlField(sqlC));
            sw.curPage = PagerCls.getCurPage(new PagerSW {
                curPage = sw.curPage, pageSize = sw.pageSize, rowCount = total
            });
            DataSet ds = SDEDataBaseClass.FullDataSet(sql, (sw.curPage - 1) * sw.pageSize, sw.pageSize, "a");

            return(ds.Tables[0]);
        }
Esempio n. 4
0
        /// <summary>
        /// 获取公益林模型
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="i"></param>
        /// <returns></returns>
        private static SDE_GONGYILIN_Model GetModel(DataTable dt, int i)
        {
            SDE_GONGYILIN_Model m = new SDE_GONGYILIN_Model();

            m.AGE              = dt.Rows[i]["年龄"].ToString();
            m.AGEGROUP         = dt.Rows[i]["龄组"].ToString();
            m.AGELEVEL         = dt.Rows[i]["龄级"].ToString();
            m.AREA             = dt.Rows[i]["所属区"].ToString();
            m.ASIAFOREST       = dt.Rows[i]["亚林种"].ToString();
            m.AVGHEIGHT        = dt.Rows[i]["平均高"].ToString();
            m.AVGSEA           = dt.Rows[i]["平均海"].ToString();
            m.AVGXIONG         = dt.Rows[i]["平均胸"].ToString();
            m.BAREROCK         = dt.Rows[i]["基岩裸"].ToString();
            m.CANOPY           = dt.Rows[i]["郁闭度"].ToString();
            m.CHECKPERSON      = dt.Rows[i]["核查人"].ToString();
            m.CHECKTIME        = dt.Rows[i]["核查时"].ToString();
            m.COMMUNITYNODE    = dt.Rows[i]["群落结"].ToString();
            m.COMPENSATIONFACE = dt.Rows[i]["补偿面"].ToString();
            m.COUNTRY          = dt.Rows[i]["乡"].ToString();
            m.COUNTY           = dt.Rows[i]["县"].ToString();
            m.DEDUCTFACE       = dt.Rows[i]["扣除面"].ToString();
            m.DESERTIFICATION  = dt.Rows[i]["荒漠化"].ToString();
            m.DESERTIFICATION_ = dt.Rows[i]["荒漠化_"].ToString();
            m.DOMINANTTREE     = dt.Rows[i]["优势树"].ToString();
            m.EARTH            = dt.Rows[i]["地貌"].ToString();
            m.EARTHCLASS       = dt.Rows[i]["地类"].ToString();
            m.ECOLOGICAL       = dt.Rows[i]["生态功"].ToString();
            m.ECOLOGICAL_      = dt.Rows[i]["生态功_"].ToString();
            m.ECOLOGICALAREA   = dt.Rows[i]["生态区"].ToString();
            m.FORESTHEALTH     = dt.Rows[i]["森林健"].ToString();
            m.FORESTLANDSHI    = dt.Rows[i]["林地使"].ToString();
            m.FORESTLANDSUO    = dt.Rows[i]["林地所"].ToString();
            m.FORESTSHI        = dt.Rows[i]["林木所"].ToString();
            m.FORESTSUO        = dt.Rows[i]["林木所"].ToString();
            m.LINBAN           = dt.Rows[i]["林班"].ToString();
            m.LOCATIONNAME     = dt.Rows[i]["区位名"].ToString();
            m.MANAGEMENTLEVEL  = dt.Rows[i]["管理级"].ToString();
            m.MANAGEMENTPERSON = dt.Rows[i]["管护人"].ToString();
            m.MANAGEMENTXING   = dt.Rows[i]["管护形"].ToString();
            m.MANAGEMENTZE     = dt.Rows[i]["管护责"].ToString();
            m.NATURALNESS      = dt.Rows[i]["自然度"].ToString();
            m.OBJECTID         = dt.Rows[i]["OBJECTID"].ToString();
            m.OBJECTID_1       = dt.Rows[i]["OBJECTID_1"].ToString();
            m.PERHECTARE       = dt.Rows[i]["每公顷"].ToString();
            m.POWER            = dt.Rows[i]["事权等"].ToString();
            m.PROJECT          = dt.Rows[i]["保护等"].ToString();
            m.PROJECTAREA      = dt.Rows[i]["工程区"].ToString();
            m.RESPONSIBILITY   = dt.Rows[i]["责任单"].ToString();
            m.RIGHT            = dt.Rows[i]["权属者"].ToString();
            m.RIVER            = dt.Rows[i]["流域"].ToString();
            m.ROCKY            = dt.Rows[i]["石漠化"].ToString();
            m.SANDCLASS        = dt.Rows[i]["沙化类"].ToString();
            m.SANDDEGREE       = dt.Rows[i]["沙化程"].ToString();
            m.SHAPE_LENG       = dt.Rows[i]["Shape_Leng"].ToString();
            m.SLOPEDU          = dt.Rows[i]["坡度"].ToString();
            m.SLOPEPOSITION    = dt.Rows[i]["坡位"].ToString();
            m.SLOPEXIANG       = dt.Rows[i]["坡向"].ToString();
            m.SMALLFACE        = dt.Rows[i]["小班面"].ToString();
            m.SMALLVILLAGERS   = dt.Rows[i]["村民小"].ToString();
            m.SOILNAME         = dt.Rows[i]["土壤名"].ToString();
            m.SOURCE           = dt.Rows[i]["起源"].ToString();
            m.STATECITY        = dt.Rows[i]["州市代"].ToString();
            m.TOTALVEGETATION  = dt.Rows[i]["植被总"].ToString();
            m.TREENODE         = dt.Rows[i]["树种结"].ToString();
            m.TREESPECIESGROUP = dt.Rows[i]["树种组"].ToString();
            m.UNIT             = dt.Rows[i]["单位性"].ToString();
            m.VILLAGE          = dt.Rows[i]["村"].ToString();
            m.WHOLECLASS       = dt.Rows[i]["全小班"].ToString();
            m.X       = dt.Rows[i]["纵坐标"].ToString();
            m.XIAOBAN = dt.Rows[i]["小班"].ToString();
            m.Y       = dt.Rows[i]["横坐标"].ToString();
            m.STX     = dt.Rows[i]["STX"].ToString();
            m.STY     = dt.Rows[i]["STY"].ToString();
            return(m);
        }