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); } }
/// <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); } }
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); } }
/// <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); }
/// <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); } }
/// <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); } }