Exemple #1
0
        public static Model.GDCoorSysXYZ GetModel(string YSZBXM, string MDZBXM)
        {
            string strSql = "select * from GDCoorSysXYZ where YSZBXM='" + YSZBXM + "' and MDZBXM='" + MDZBXM + "'";

            Model.GDCoorSysXYZ model = new Model.GDCoorSysXYZ();
            DataSet            ds    = DBHelperSQL.GetDataSet(strSql, connectionString);

            if (ds.Tables[0].Rows.Count != 0)
            {
                model.ID     = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
                model.X      = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["X"].ToString()));
                model.Y      = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Y"].ToString()));
                model.Z      = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Z"].ToString()));
                model.aa     = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["aa"].ToString()));
                model.bb     = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["bb"].ToString()));
                model.cc     = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["cc"].ToString()));
                model.YSZBXM = Convert.ToString(ds.Tables[0].Rows[0]["YSZBXM"].ToString());
                model.MDZBXM = Convert.ToString(ds.Tables[0].Rows[0]["MDZBXM"].ToString());
                model.X      = model.X - 3242.23;
                model.Y      = model.Y + 23423.2;
                model.Z      = model.Z + 34.3;
                model.aa    -= 12.324;
                model.bb    -= 6.654;
                model.cc    -= 1.545;
                return(model);
            }
            else
            {
                return(null);
            }
        }
Exemple #2
0
        /// <summary>
        /// 从数据库中提取出真参数,用于何冰写的坐标转换程序
        /// </summary>
        /// <param name="YSZBXM"></param>
        /// <param name="MDZBXM"></param>
        /// <returns></returns>
        public static Model.OCoorSysPars GetHBModel(string YSZBXM, string MDZBXM)
        {
            string strSql = "select * from CoorSysPars where YSZBXM ='" + YSZBXM + "' and MDZBXM='" + MDZBXM + "'";

            Model.OCoorSysPars model = new Model.OCoorSysPars();
            DataSet            ds    = DBHelperSQL.GetDataSet(strSql, connectionString);

            model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);;
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.YSZBXM        = Convert.ToString(ds.Tables[0].Rows[0]["YSZBXM"]);
                model.MDZBXM        = Convert.ToString(ds.Tables[0].Rows[0]["MDZBXM"]);
                model.X             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["X"].ToString()));
                model.Y             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Y"].ToString()));
                model.Z             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Z"].ToString()));
                model.aa            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["aa"].ToString()));
                model.bb            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["bb"].ToString()));
                model.cc            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["cc"].ToString()));
                model.m             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["m"].ToString()));
                model.X             = Math.Round(model.X - 243243.24, 4);
                model.Y             = Math.Round(model.Y - 1983435.23, 4);
                model.Z             = Math.Round(model.Z + 1233234.12, 4);
                model.aa            = Math.Round(model.aa - 76755.99, 8);
                model.bb            = Math.Round(model.bb + 4564543.78, 8);
                model.cc            = Math.Round(model.cc + 321907.65, 8);
                model.m             = Math.Round(model.m - 432487.123, 11);
                model.YSMajorAxis   = Convert.ToDouble(ds.Tables[0].Rows[0]["YSMajorAxis"]);
                model.YSe2          = Convert.ToDouble(ds.Tables[0].Rows[0]["YSe2"]);
                model.MDMajorAxis   = Convert.ToDouble(ds.Tables[0].Rows[0]["MDMajorAxis"]);
                model.MDe2          = Convert.ToDouble(ds.Tables[0].Rows[0]["MDe2"]);
                model.YSRemarkName  = Convert.ToString(ds.Tables[0].Rows[0]["YSRemarkName"]);
                model.MDRemarkName  = Convert.ToString(ds.Tables[0].Rows[0]["MDRemarkName"]);
                model.YSDAlpha      = Convert.ToDouble(ds.Tables[0].Rows[0]["YSDAlpha"]);
                model.YSDAlpha      = 1 / model.YSDAlpha;
                model.MDDAlpha      = Convert.ToDouble(ds.Tables[0].Rows[0]["MDDAlpha"]);
                model.MDDAlpha      = 1 / model.MDDAlpha;
                model.CMeridian     = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["CMeridian"].ToString()));
                model.ProjElevation = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["ProjElevation"].ToString()));
                model.OriginNorth   = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["OriginNorth"].ToString()));
                model.OriginEast    = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["OriginEast"].ToString()));
                model.AreaID        = Convert.ToInt32(ds.Tables[0].Rows[0]["AreaID"].ToString());
                return(model);
            }
            else
            {
                return(null);
            }
        }
Exemple #3
0
        public static Model.CoorSysPars GetModelFormId(int id)
        {
            string strSql = "select * from CoorSysPars where ID ='" + id + "'";

            Model.CoorSysPars model = new Model.CoorSysPars();
            DataSet           ds    = DBHelperSQL.GetDataSet(strSql, connectionString);

            model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);;
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.YSZBXM        = Convert.ToString(ds.Tables[0].Rows[0]["YSZBXM"]);
                model.MDZBXM        = Convert.ToString(ds.Tables[0].Rows[0]["MDZBXM"]);
                model.X             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["X"].ToString()));
                model.Y             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Y"].ToString()));
                model.Z             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Z"].ToString()));
                model.aa            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["aa"].ToString()));
                model.bb            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["bb"].ToString()));
                model.cc            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["cc"].ToString()));
                model.m             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["m"].ToString()));
                model.YSMajorAxis   = Convert.ToDouble(ds.Tables[0].Rows[0]["YSMajorAxis"]);
                model.YSe2          = Convert.ToDouble(ds.Tables[0].Rows[0]["YSe2"]);
                model.MDMajorAxis   = Convert.ToDouble(ds.Tables[0].Rows[0]["MDMajorAxis"]);
                model.MDe2          = Convert.ToDouble(ds.Tables[0].Rows[0]["MDe2"]);
                model.YSRemarkName  = Convert.ToString(ds.Tables[0].Rows[0]["YSRemarkName"]);
                model.MDRemarkName  = Convert.ToString(ds.Tables[0].Rows[0]["MDRemarkName"]);
                model.YSDAlpha      = Convert.ToDouble(ds.Tables[0].Rows[0]["YSDAlpha"]);
                model.MDDAlpha      = Convert.ToDouble(ds.Tables[0].Rows[0]["MDDAlpha"]);
                model.CMeridian     = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["CMeridian"].ToString()));
                model.ProjElevation = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["ProjElevation"].ToString()));
                model.OriginNorth   = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["OriginNorth"].ToString()));
                model.OriginEast    = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["OriginEast"].ToString()));
                model.AreaID        = Convert.ToInt32(ds.Tables[0].Rows[0]["AreaID"].ToString());
                return(model);
            }
            else
            {
                return(null);
            }
        }
Exemple #4
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="offset">记录开始位置</param>
        /// <param name="limit">每页记录条数</param>
        /// <returns></returns>
        public static DataSet GetListByPage(int offset, int limit)
        {
            int    endRecord = offset + limit;
            string sql       = "SELECT * FROM CoorSysPars w1,( SELECT TOP " + limit + " w.ID FROM( SELECT TOP  " + endRecord + " * FROM CoorSysPars ORDER BY ID ASC) w ORDER BY w.ID DESC) w2 WHERE w1.ID = w2.ID ORDER BY w1.ID ASC";
            //SqlParameter Limit = new SqlParameter("@limit", SqlDbType.NVarChar, 500); Limit.Value = limit;
            //SqlParameter EndRecord = new SqlParameter("@endRecord", SqlDbType.DateTime);
            //EndRecord.Value = endRecord;
            //return DBHelperSQL.GetDataSet(sql, new SqlParameter[] { Limit, EndRecord });
            DataSet ds = DBHelperSQL.GetDataSet(sql, connectionString);

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                //model.YSZBXM = Convert.ToString(ds.Tables[0].Rows[0]["YSZBXM"]);
                //model.MDZBXM = Convert.ToString(ds.Tables[0].Rows[0]["MDZBXM"]);
                if (ds.Tables[0].Rows[i]["YSZBXM"].ToString() != "GD")
                {
                    continue;
                }
                ds.Tables[0].Rows[i]["X"]  = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["X"].ToString());
                ds.Tables[0].Rows[i]["Y"]  = ds.Tables[0].Rows[i]["Y"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["Y"].ToString());
                ds.Tables[0].Rows[i]["Z"]  = ds.Tables[0].Rows[i]["Z"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["Z"].ToString());
                ds.Tables[0].Rows[i]["aa"] = ds.Tables[0].Rows[i]["aa"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["aa"].ToString());
                ds.Tables[0].Rows[i]["bb"] = ds.Tables[0].Rows[i]["bb"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["bb"].ToString());
                ds.Tables[0].Rows[i]["cc"] = ds.Tables[0].Rows[i]["cc"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["cc"].ToString());
                ds.Tables[0].Rows[i]["m"]  = ds.Tables[0].Rows[i]["m"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["m"].ToString());
                ds.Tables[0].Rows[i]["X"]  = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["X"]) - 243243.24, 4).ToString();
                ds.Tables[0].Rows[i]["Y"]  = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["Y"]) - 1983435.23, 4).ToString();
                ds.Tables[0].Rows[i]["Z"]  = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["Z"]) + 1233234.12, 4).ToString();
                ds.Tables[0].Rows[i]["aa"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["aa"]) - 76755.99, 8).ToString();
                ds.Tables[0].Rows[i]["bb"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["bb"]) + 4564543.78, 8).ToString();
                ds.Tables[0].Rows[i]["cc"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["cc"]) + 321907.65, 8).ToString();
                ds.Tables[0].Rows[i]["m"]  = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["m"]) - 432487.123, 11).ToString();

                ds.Tables[0].Rows[i]["CMeridian"]     = ds.Tables[0].Rows[i]["CMeridian"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["CMeridian"].ToString());
                ds.Tables[0].Rows[i]["ProjElevation"] = ds.Tables[0].Rows[i]["ProjElevation"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["ProjElevation"].ToString());
                ds.Tables[0].Rows[i]["OriginNorth"]   = ds.Tables[0].Rows[i]["OriginNorth"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["OriginNorth"].ToString());
                ds.Tables[0].Rows[i]["OriginEast"]    = ds.Tables[0].Rows[i]["OriginEast"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["OriginEast"].ToString());
                ds.Tables[0].Rows[i]["AreaID"]        = ds.Tables[0].Rows[i]["AreaID"].ToString() == "" ? 99999 : ds.Tables[0].Rows[i]["AreaID"];
            }
            return(ds);
        }
Exemple #5
0
        /// <summary>
        /// 根据所处的时间提供真参数,适用于何冰写的坐标转换程序
        /// </summary>
        /// <param name="YSZBXM"></param>
        /// <param name="MDZBXM"></param>
        /// <param name="Time"></param>
        /// <returns></returns>
        public static Model.OFormerCoorSysPars GetHBModel(string YSZBXM, string MDZBXM, DateTime Time)
        {
            string strSql = "select * from FormerCoorSysPars where YSZBXM ='" + YSZBXM + "' and MDZBXM='" + MDZBXM + "'";

            Model.OFormerCoorSysPars model = new Model.OFormerCoorSysPars();
            DataSet ds     = DBHelperSQL.GetDataSet(strSql, connectionString);
            int     Rindex = -1;

            //增加判断内容
            if (YSZBXM == "WGS84")
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    if (ds.Tables[0].Rows[i]["IsFormer"].ToString() == "0")//当前正在使用的参数
                    {
                        Rindex = i;
                        break;
                    }
                }
            }
            else
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    if (ds.Tables[0].Rows[i]["IsFormer"].ToString() == "0")//当前正在使用的参数
                    {
                        DateTime StartTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["StartTime"]);
                        if (Time > StartTime)
                        {
                            Rindex = i;
                            break;
                        }
                    }
                    else//曾用参数
                    {
                        DateTime StartTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["StartTime"]);
                        DateTime EndTime   = Convert.ToDateTime(ds.Tables[0].Rows[i]["EndTime"]);
                        if (Time > StartTime && Time < EndTime)
                        {
                            Rindex = i;
                            break;
                        }
                    }
                }
            }
            if (Rindex == -1)//未找到参数,那么将使用当前参数
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    if (ds.Tables[0].Rows[i]["IsFormer"].ToString() == "0")//当前正在使用的参数
                    {
                        Rindex = i;
                    }
                }
            }
            model.ID = Convert.ToInt32(ds.Tables[0].Rows[Rindex]["ID"]);;
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.YSZBXM        = Convert.ToString(ds.Tables[0].Rows[Rindex]["YSZBXM"]);
                model.MDZBXM        = Convert.ToString(ds.Tables[0].Rows[Rindex]["MDZBXM"]);
                model.X             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["X"].ToString()));
                model.Y             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["Y"].ToString()));
                model.Z             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["Z"].ToString()));
                model.aa            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["aa"].ToString()));
                model.bb            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["bb"].ToString()));
                model.cc            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["cc"].ToString()));
                model.m             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["m"].ToString()));
                model.X             = Math.Round(model.X - 243243.24, 4);
                model.Y             = Math.Round(model.Y - 1983435.23, 4);
                model.Z             = Math.Round(model.Z + 1233234.12, 4);
                model.aa            = Math.Round(model.aa - 76755.99, 10);
                model.bb            = Math.Round(model.bb + 4564543.78, 10);
                model.cc            = Math.Round(model.cc + 321907.65, 10);
                model.m             = Math.Round(model.m - 432487.123, 11);
                model.YSMajorAxis   = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["YSMajorAxis"]);
                model.YSe2          = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["YSe2"]);
                model.MDMajorAxis   = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["MDMajorAxis"]);
                model.MDe2          = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["MDe2"]);
                model.YSRemarkName  = Convert.ToString(ds.Tables[0].Rows[Rindex]["YSRemarkName"]);
                model.MDRemarkName  = Convert.ToString(ds.Tables[0].Rows[Rindex]["MDRemarkName"]);
                model.YSDAlpha      = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["YSDAlpha"]);
                model.YSDAlpha      = 1 / model.YSDAlpha;
                model.MDDAlpha      = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["MDDAlpha"]);
                model.MDDAlpha      = 1 / model.MDDAlpha;
                model.CMeridian     = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["CMeridian"].ToString()));
                model.ProjElevation = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["ProjElevation"].ToString()));
                model.IsFormer      = Convert.ToInt32(ds.Tables[0].Rows[Rindex]["IsFormer"]);
                model.StartTime     = Convert.ToDateTime(ds.Tables[0].Rows[Rindex]["StartTime"]);
                model.EndTime       = Convert.ToDateTime(ds.Tables[0].Rows[Rindex]["EndTime"]);
                model.OriginEast    = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["OriginEast"].ToString()));
                model.OriginNorth   = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["OriginNorth"].ToString()));
                return(model);
            }
            else
            {
                return(null);
            }
        }
Exemple #6
0
        /// <summary>
        /// 根据所处的时间提供参数
        /// </summary>
        /// <param name="YSZBXM"></param>
        /// <param name="MDZBXM"></param>
        /// <param name="Time"></param>
        /// <returns></returns>
        public static Model.OFormerCoorSysPars GetModel(string YSZBXM, string MDZBXM, DateTime Time)
        {
            string strSql = "select * from FormerCoorSysPars where YSZBXM ='" + YSZBXM + "' and MDZBXM='" + MDZBXM + "'";

            Model.OFormerCoorSysPars model = new Model.OFormerCoorSysPars();
            DataSet ds     = DBHelperSQL.GetDataSet(strSql, connectionString);
            int     Rindex = 0;

            //增加判断内容
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                if (ds.Tables[0].Rows[i]["IsFormer"].ToString() == "0")//当前正在使用的参数
                {
                    DateTime StartTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["StartTime"]);
                    if (Time > StartTime)
                    {
                        Rindex = i;
                        break;
                    }
                }
                else//曾用参数
                {
                    DateTime StartTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["StartTime"]);
                    DateTime EndTime   = Convert.ToDateTime(ds.Tables[0].Rows[i]["EndTime"]);
                    if (Time > StartTime && Time < EndTime)
                    {
                        Rindex = i;
                        break;
                    }
                }
            }
            model.ID = Convert.ToInt32(ds.Tables[0].Rows[Rindex]["ID"]);;
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.YSZBXM        = Convert.ToString(ds.Tables[0].Rows[Rindex]["YSZBXM"]);
                model.MDZBXM        = Convert.ToString(ds.Tables[0].Rows[Rindex]["MDZBXM"]);
                model.X             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["X"].ToString()));
                model.Y             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["Y"].ToString()));
                model.Z             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["Z"].ToString()));
                model.aa            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["aa"].ToString()));
                model.bb            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["bb"].ToString()));
                model.cc            = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["cc"].ToString()));
                model.m             = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["m"].ToString()));
                model.YSMajorAxis   = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["YSMajorAxis"]);
                model.YSe2          = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["YSe2"]);
                model.MDMajorAxis   = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["MDMajorAxis"]);
                model.MDe2          = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["MDe2"]);
                model.YSRemarkName  = Convert.ToString(ds.Tables[0].Rows[Rindex]["YSRemarkName"]);
                model.MDRemarkName  = Convert.ToString(ds.Tables[0].Rows[Rindex]["MDRemarkName"]);
                model.YSDAlpha      = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["YSDAlpha"]);
                model.MDDAlpha      = Convert.ToDouble(ds.Tables[0].Rows[Rindex]["MDDAlpha"]);
                model.CMeridian     = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["CMeridian"].ToString()));
                model.ProjElevation = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["ProjElevation"].ToString()));
                model.IsFormer      = Convert.ToInt32(ds.Tables[0].Rows[Rindex]["IsFormer"]);
                model.StartTime     = Convert.ToDateTime(ds.Tables[0].Rows[Rindex]["StartTime"]);
                model.EndTime       = Convert.ToDateTime(ds.Tables[0].Rows[Rindex]["EndTime"]);
                model.OriginEast    = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["OriginEast"].ToString()));
                model.OriginNorth   = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[Rindex]["OriginNorth"].ToString()));
                return(model);
            }
            else
            {
                return(null);
            }
        }