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