public GPSXY getCenter(String cCameraID, float P, float T, float X) { StringBuilder sql = new StringBuilder(); sql.Append("SELECT * FROM XT_CAMERA_CONFIG WHERE DEVICE_ID='" + cCameraID + "'"); DataTable dtRows = WebSQL.QueryData(sql.ToString()); if (dtRows != null && dtRows.Rows.Count > 0) { GPSXY vGPS = new GPSXY(); //113.807187 34.170334 vGPS.X = StringEx.GetDouble(dtRows, 0, "X"); vGPS.Y = StringEx.GetDouble(dtRows, 0, "Y"); Double dOffsetX = StringEx.GetDouble(dtRows, 0, "OFFSET_X"); Double dOffsetY = StringEx.GetDouble(dtRows, 0, "OFFSET_Y"); Double dStartP = StringEx.GetDouble(dtRows, 0, "START_P"); Double dStartT = StringEx.GetDouble(dtRows, 0, "START_T"); Double dStartX = StringEx.GetDouble(dtRows, 0, "START_X"); Double dStartH = StringEx.GetDouble(dtRows, 0, "START_H"); return(vGPS); } else { return(null); } }
public GPSXY getCenter(String cCameraID, float fP, float fT, float fX) { StringBuilder sql = new StringBuilder(); sql.Append("SELECT * FROM XT_CAMERA_CONFIG WHERE DEVICE_ID='" + cCameraID + "'"); DataTable dtRows = DbManager.QueryData(sql.ToString()); if (dtRows != null && dtRows.Rows.Count > 0) { GPSXY vGPS = new GPSXY(); //113.807187 34.170334 vGPS.X = StringEx.GetDouble(dtRows, 0, "X"); vGPS.Y = StringEx.GetDouble(dtRows, 0, "Y"); Double dOFFSET_P = StringEx.GetDouble(dtRows, 0, "OFFSET_P"); Double dOFFSET_T = StringEx.GetDouble(dtRows, 0, "OFFSET_T"); Double dOFFSET_X = StringEx.GetDouble(dtRows, 0, "OFFSET_X"); Double dOFFSET_H = StringEx.GetDouble(dtRows, 0, "OFFSET_H"); Double fGPS_Y = getY(vGPS.Y, dOFFSET_H, fT); return(vGPS); } else { return(null); } }
public LoginUserInfo getLoginUserInfo() { String cUSER_ID = getUserID(); if (!String.IsNullOrEmpty(cUSER_ID)) { try { DataTable dtRows = DbManager.QueryData("SELECT * FROM S_USER_INF WHERE USER_ID='" + cUSER_ID + "'"); LoginUserInfo vUser = new LoginUserInfo(); vUser.USER_CODE = StringEx.getString(dtRows, 0, "USER_CODE"); vUser.ORG_ID = StringEx.getString(dtRows, 0, "ORG_ID"); vUser.USER_NAME = StringEx.getString(dtRows, 0, "USER_NAME"); vUser.ROLE_ID = StringEx.getString(dtRows, 0, "ROLE_ID"); dtRows = DbManager.QueryData("SELECT ORG_NAME,ORG_FULL_NAME,X,Y FROM S_ORG_INF WHERE ORG_ID='" + vUser.ORG_ID + "'"); vUser.ORG_NAME = StringEx.getString(dtRows, 0, "ORG_NAME"); vUser.ORG_FULL_NAME = StringEx.getString(dtRows, 0, "ORG_FULL_NAME"); vUser.X = StringEx.GetDouble(dtRows, 0, "X"); vUser.Y = StringEx.GetDouble(dtRows, 0, "Y"); DBConfig vConf = new DBConfig(); vUser.APPID = vConf.getOrgKey(vUser.ORG_ID, "WX_APPID"); vUser.WX_ID = vConf.getOrgKey(vUser.ORG_ID, "WX_ID"); return(vUser); } catch (Exception ex) { return(null); } } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { CheckLogin(); UserInfo = getLoginUserInfo(); ORG_ID = UserInfo.ORG_ID; String ID = StringEx.getString(Request.QueryString["ID"]); String P = StringEx.getString(Request.QueryString["P"]); String T = StringEx.getString(Request.QueryString["T"]); String X = StringEx.getString(Request.QueryString["X"]); String DEVICE_ID = StringEx.getString(Request.QueryString["DEVICE_ID"]); if (!String.IsNullOrEmpty(DEVICE_ID)) { } if (ID.Length > 0) { UrlMessage vMSG = null; try { vMSG = Newtonsoft.Json.JsonConvert.DeserializeObject <UrlMessage>(ID); } catch { } if (vMSG != null) { XT_CAMERA_Dao dao = new XT_CAMERA_Dao(); String cCameraID = vMSG.Code; XT_CAMERA vo = dao.FindOne(cCameraID); double cX = vo.x; double cY = vo.y; if ((cX > 0) && (cY > 0)) { X = cX.ToString(); Y = cY; } } } //LoginUserInfo vUserInf = this.getLoginUserInfo(); //X = vUserInf.X; //Y = vUserInf.Y; TYPE_ID = StringEx.getString(Request.QueryString["TYPE_ID"]); if (TYPE_ID.Length > 0) { String cX = StringEx.getString(Request.QueryString["X"]); String cY = StringEx.getString(Request.QueryString["Y"]); if ((cX.Length > 0) && (cY.Length > 0)) { X = StringEx.GetDouble(cX).ToString(); Y = StringEx.GetDouble(cY); } } }
private void onIdle_Event(object sender, EventArgs e) { if (!LOAD_FLAG) { LOAD_FLAG = true; InitCameraLogin(); dtInfo = WebSQL.QueryData("SELECT * FROM XT_CAMERA WHERE DEVICE_ID='" + ActiveCameraCode + "'"); this.Text = StringEx.getString(dtInfo, 0, "CAMERA_NAME"); X = StringEx.GetDouble(dtInfo, 0, "X"); Y = StringEx.GetDouble(dtInfo, 0, "Y"); if (X > 0 && Y > 0) { String cWebUrl = INIConfig.ReadString("Config", AppConfig.WEB_URL, ""); String cUrl = "http://" + cWebUrl + "/pages/webgis.aspx?TOKEN=" + ApplicationEvent.Token + "&TYPE_ID=2&X=" + X.ToString() + "&Y=" + Y.ToString(); //geckoWeb.Navigate(cUrl); } btnStartReal_Click(null, null); } }