/// <summary>
/// 跟用户id获取用户信息返回DataTable
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public DataTable GetUserInfoByUid(string uid)
{
StringBuilder str = new StringBuilder();
str.Append(@"select UserID, UserAccount,'" + SiteHelper.GetFileServer() + "'+ HeadPortrait as HeadPortrait,UserName,IDCardNum,UserSex,Tel,Email,LastloginTime,UserState from YR_OPUser where DeleteMark=1 and UserID='" + uid + "'");
return(DataFactory.SqlDataBase().GetDataTableBySQL(str));
}
public string Execute(Hashtable params_ht)
{
Hashtable res = params_ht;
if (res["UID"] == null || res["UID"].ToString().Trim().Length <= 0 ||
res["CurrentPage"] == null || res["CurrentPage"].ToString().Trim().Length <= 0 ||
res["PageNum"] == null || res["PageNum"].ToString().Trim().Length <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
}
else
{
try
{
uid = res["UID"].ToString().Trim();
if (res["MessageType"] != null && res["MessageType"].ToString().Trim().Length > 0)
{
//消息类型,1:系统消息，2:公告、通知
messagetype = res["MessageType"].ToString().Trim();
}
pagenum = int.Parse(res["PageNum"].ToString().Trim());
currentpage = int.Parse(res["CurrentPage"].ToString().Trim());
}
catch
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "数据格式不正确"));
}
MessageManager mm = new MessageManager();
DataTable messages = mm.GetMessageInfoPageByUser(uid, messagetype, currentpage, pagenum);
if (messages == null || messages.Rows.Count <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "没有数据了"));
}
else
{
messages.Columns.Add("IsRead");
foreach (DataRow message in messages.Rows)
{
string messageid = message["ID"].ToString();
if (message["ImageUrl"].ToString().Trim().Length > 0)
{
message["ImageUrl"] = SiteHelper.GetFileServer() + message["ImageUrl"].ToString().Trim();
}
message["MessageUrl"] = string.Format("{0}/Manage/InformationManage/Notification.aspx?id={1}", SiteHelper.GetFileServer(), message["ID"].ToString());
message["IsRead"] = "0";
MessageReadLogManager mrlm = new MessageReadLogManager();
if (!mrlm.IsUserReadMessages(uid, messageid))
{
//系统消息设置为已读
if (message["MessageType"].ToString() == "1")
{
Hashtable userreadmessage = new Hashtable();
userreadmessage["ID"] = CommonHelper.GetGuid;
userreadmessage["UserID"] = uid;
userreadmessage["MessageID"] = messageid;
userreadmessage["IsRead"] = 1;
userreadmessage["ReadTime"] = SiteHelper.GetWebServerCurrentTime().ToString();
mrlm.AddMessageReadLog(userreadmessage);
message["IsRead"] = "1";
}
}
else
{
message["IsRead"] = "1";
}
if (message["MessageType"].ToString() == "2")
{
message["MessageContent"] = "";
}
message["Summary"] = message["Summary"].ToString().Replace("\r\n", "");
}
return(JsonHelper.DataTableToJson("success", "获取数据成功", messages, "Messages"));
}
}
}
public string Execute(Hashtable params_ht)
{
Hashtable res = params_ht;
if (res["UID"] == null || res["UseState"] == null || res["VehicleState"] == null ||
res["PageNum"] == null || res["PageNum"].ToString().Trim().Length <= 0 ||
res["CurrentPage"] == null || res["CurrentPage"].ToString().Trim().Length <= 0 ||
res["UID"].ToString().Trim().Length <= 0 || res["UseState"].ToString().Trim().Length <= 0 || res["VehicleState"].ToString().Trim().Length <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
}
else
{
try
{
uid = res["UID"].ToString().Trim();
useState = int.Parse(res["UseState"].ToString().Trim());
vehicleState = int.Parse(res["VehicleState"].ToString().Trim());
currentPage = int.Parse(res["CurrentPage"].ToString().Trim());
pageNum = int.Parse(res["PageNum"].ToString().Trim());
if (res["LowBattery"] != null)
{
lowBattery = int.Parse(res["LowBattery"].ToString().Trim());
}
if (res["ChargeState"] != null)
{
chargeState = int.Parse(res["ChargeState"].ToString().Trim());
}
if (res["ParkingID"] != null)
{
parkingID = res["ParkingID"].ToString().Trim();
}
if (res["AbnormalState"] != null)
{
abnormalState = int.Parse(res["AbnormalState"].ToString().Trim());
}
}
catch
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "数据格式不正确"));
}
VehicleManager vm = new VehicleManager();
OrdersManager om = new OrdersManager();
ServiceAreaManager areaManager = new ServiceAreaManager();
DataTable vehicles = areaManager.GetVehiclesByParkingID(uid, parkingID, useState, vehicleState, lowBattery, chargeState, abnormalState, currentPage, pageNum, out sumCount);
if (vehicles == null || vehicles.Rows.Count <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "亲，没有数据了"));
}
else
{
vehicles.Columns.Add("OrderUserName");
vehicles.Columns.Add("OrderUserTel");
vehicles.Columns.Add("HeadPortrait");
vehicles.Columns.Add("OrderState");
vehicles.Columns.Add("OrderTime");
vehicles.Columns.Add("UserType");
vehicles.Columns.Add("AbnormalState");
vehicles.Columns.Add("AlarmType");
vehicles.Columns.Add("AlarmTime");
foreach (DataRow dr in vehicles.Rows)
{
LatLng latlng = new LatLng(double.Parse(dr["Latitude"].ToString()), double.Parse(dr["Longitude"].ToString()));
latlng = SiteHelper.TransformFromWGSToGCJ(latlng);
dr["Longitude"] = latlng.longitude;
dr["Latitude"] = latlng.latitude;
dr["ThumbImageUrl"] = SiteHelper.GetFileServer() + dr["ThumbImageUrl"].ToString();
decimal electricity = 0;
decimal.TryParse(dr["Electricity"].ToString(), out electricity);
int dianliang = Decimal.ToInt32(electricity);
dr["Electricity"] = dianliang + "%";
dr["AbnormalState"] = 0;
Hashtable abht = null;// vm.GetAbnormalVehicle(dr["ID"].ToString());
if (abht != null && abht.Keys.Count > 0)
{
dr["AbnormalState"] = 1;
dr["AlarmType"] = SiteHelper.GetHashTableValueByKey(abht, "AlarmType");
dr["AlarmTime"] = SiteHelper.GetHashTableValueByKey(abht, "AlarmTime");
}
Hashtable order_ht = om.GetLatestUserByVehicleID(dr["ID"].ToString());
if (order_ht != null && order_ht.Keys.Count > 0)
{
dr["OrderUserName"] = order_ht["REALNAME"];
dr["OrderUserTel"] = order_ht["BINDPHONE"];
//dr["HeadPortrait"] = SiteHelper.GetFileServer() + order_ht["HEADPORTRAIT"];
dr["HeadPortrait"] = "";
dr["OrderState"] = order_ht["ORDERSTATE"];
dr["UserType"] = order_ht["USERTYPE"];
dr["OrderTime"] = order_ht["CREATETIME"];
}
else
{
dr["OrderUserName"] = "";
dr["OrderUserTel"] = "";
dr["HeadPortrait"] = "";
dr["OrderState"] = "";
dr["UserType"] = "";
dr["OrderTime"] = "";
}
}
return(SiteHelper.GetJsonFromDataTable2(vehicles, "success", "获取数据成功", "GetVehicleList", sumCount));
}
}
}
public string Execute(Hashtable params_ht)
{
Hashtable res = params_ht;
if (res["UID"] == null || res["UID"].ToString().Trim().Length <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
}
else
{
uid = res["UID"].ToString().Trim();
VehicleManager vm = new VehicleManager();
SystemImagesManager sim = new SystemImagesManager();
OPUserManager opUserManager = new OPUserManager();
Hashtable vehicle = opUserManager.GetVehicleInfoByOperator(uid);
OrdersManager om = new OrdersManager();
string thumbImg = string.Empty;
string detailsImg = string.Empty;
if (vehicle == null || vehicle.Keys.Count <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "车辆数据为空"));
}
else
{
DataTable dt = sim.GetImagesByVehicleID(vehicle["ID"].ToString());
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["Type"].ToString().Trim() == ((int)ImagesType.Thumbnail).ToString().Trim())
{
thumbImg += SiteHelper.GetFileServer() + dr["ImageUrl"].ToString().Trim() + ";";
}
if (dr["Type"].ToString().Trim() == ((int)ImagesType.Details).ToString().Trim())
{
detailsImg += SiteHelper.GetFileServer() + dr["ImageUrl"].ToString().Trim() + ";";
}
}
}
vehicle["THUMBIMG"] = thumbImg;
vehicle["DETAILSIMG"] = detailsImg;
string lng = vehicle["LONGITUDE"].ToString();
string lat = vehicle["LATITUDE"].ToString();
if (!string.IsNullOrEmpty(lng) && !string.IsNullOrEmpty(lat))
{
LatLng latlng = new LatLng(double.Parse(lat), double.Parse(lng));
latlng = SiteHelper.TransformFromWGSToGCJ(latlng);
if (latlng != null)
{
vehicle["LATITUDE"] = latlng.latitude;
vehicle["LONGITUDE"] = latlng.longitude;
if (vehicle["ADDRESS"].ToString().Length <= 0)
{
vehicle["ADDRESS"] = SiteHelper.GetLocationByGPS(vehicle["LONGITUDE"].ToString(), vehicle["LATITUDE"].ToString(), "gcj02ll");
}
}
}
decimal electricity = 0;
decimal.TryParse(vehicle["ELECTRICITY"].ToString(), out electricity);
int dianliang = Decimal.ToInt32(electricity);
vehicle["ELECTRICITY"] = dianliang + "%";
Hashtable order_ht = om.GetLatestUserByVehicleID(vehicle["ID"].ToString());
if (order_ht != null && order_ht.Keys.Count > 0)
{
vehicle["OrderUserName"] = order_ht["REALNAME"];
vehicle["OrderUserTel"] = order_ht["BINDPHONE"];
vehicle["HeadPortrait"] = SiteHelper.GetFileServer() + order_ht["HEADPORTRAIT"];
vehicle["OrderState"] = order_ht["ORDERSTATE"];
vehicle["UserType"] = order_ht["USERTYPE"];
}
else
{
vehicle["OrderUserName"] = "";
vehicle["OrderUserTel"] = "";
vehicle["HeadPortrait"] = "";
vehicle["OrderState"] = "";
vehicle["UserType"] = "";
}
return(SiteHelper.GetJsonFromHashTable(vehicle, "success", "获取数据成功", "GetCurrentVehicle"));
}
}
}
/// <summary>
/// 获取附近车辆信息
/// </summary>
/// <param name="context"></param>
private void GetNearVehicles(HttpContext context)
{
double km = 100;
int pageNum = 100;
int currentPage = 1;
string weidu = string.Empty;
string jingdu = string.Empty;
if (!string.IsNullOrEmpty(SiteHelper.GetAppsetString("NearVehicleKM")))
{
km = double.Parse(SiteHelper.GetAppsetString("NearVehicleKM"));
}
if (!string.IsNullOrEmpty(SiteHelper.GetAppsetString("PageNum")))
{
pageNum = int.Parse(SiteHelper.GetAppsetString("PageNum"));
}
if (context.Request["Latitude"] == null ||
context.Request["Longitude"] == null ||
context.Request["PageNum"] == null ||
context.Request["CurrentPage"] == null ||
context.Request["Latitude"].ToString().Trim().Length <= 0 ||
context.Request["Longitude"].ToString().Trim().Length <= 0 ||
context.Request["PageNum"].ToString().Trim().Length <= 0 ||
context.Request["CurrentPage"].ToString().Trim().Length <= 0)
{
context.Response.Write(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
}
else
{
try
{
//pageNum = int.Parse(res["PageNum"].ToString().Trim());
currentPage = int.Parse(context.Request["CurrentPage"].ToString().Trim());
weidu = context.Request["Latitude"].ToString().Trim();
jingdu = context.Request["Longitude"].ToString().Trim();
}
catch
{
context.Response.Write(SiteHelper.GetJsonFromHashTable(null, "faild", "数据格式不正确"));
context.Response.End();
}
VehicleManager vm = new VehicleManager();
DataTable vehicles = vm.GetNearVehicles(km, weidu, jingdu, currentPage, pageNum);
if (vehicles == null || vehicles.Rows.Count <= 0)
{
context.Response.Write(SiteHelper.GetJsonFromHashTable(null, "faild", "亲，没有数据了"));
context.Response.End();
}
else
{
foreach (DataRow dr in vehicles.Rows)
{
dr["ThumbImageUrl"] = SiteHelper.GetFileServer() + dr["ThumbImageUrl"].ToString();
decimal electricity = 0;
decimal.TryParse(dr["Electricity"].ToString(), out electricity);
int dianliang = Decimal.ToInt32(electricity);
dr["Electricity"] = dianliang + "%";
string lng = dr["Longitude"].ToString();
string lat = dr["Latitude"].ToString();
if (!string.IsNullOrEmpty(lng) && !string.IsNullOrEmpty(lat))
{
LatLng latlng = SiteHelper.GetBaiduByGPS(lat, lng);
if (latlng != null)
{
dr["Longitude"] = latlng.longitude;
dr["Latitude"] = latlng.latitude;
if (dr["Address"].ToString().Trim().Length <= 0)
{
dr["Address"] = SiteHelper.GetLocationByGPS(dr["Latitude"].ToString(), dr["Longitude"].ToString());
}
}
}
}
context.Response.Write(JsonHelper.DataTableToJson("success", "获取数据成功", vehicles, "VehicleInfo"));
}
}
}
/// <summary>
/// 获取附近车辆详细信息
/// </summary>
/// <param name="context"></param>
private void GetVehicleByID(HttpContext context)
{
string vehicleID = string.Empty;
string weidu = string.Empty;
string jingdu = string.Empty;
if (context.Request["VehicleID"] == null ||
context.Request["Latitude"] == null ||
context.Request["Longitude"] == null ||
context.Request["VehicleID"].ToString().Trim().Length <= 0 ||
context.Request["Latitude"].ToString().Trim().Length <= 0 ||
context.Request["Longitude"].ToString().Trim().Length <= 0)
{
context.Response.Write(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
context.Response.End();
}
else
{
vehicleID = context.Request["VehicleID"].ToString().Trim();
weidu = context.Request["Latitude"].ToString().Trim();
jingdu = context.Request["Longitude"].ToString().Trim();
VehicleManager vm = new VehicleManager();
SystemImagesManager sim = new SystemImagesManager();
Hashtable vehicle = vm.GetVehicleInfoByID(vehicleID, weidu, jingdu);
string thumbImg = string.Empty;
string detailsImg = string.Empty;
if (vehicle == null || vehicle.Keys.Count <= 0)
{
context.Response.Write(SiteHelper.GetJsonFromHashTable(null, "faild", "车辆数据为空"));
}
else
{
DataTable dt = sim.GetImagesByVehicleID(vehicleID);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["Type"].ToString().Trim() == ((int)ImagesType.Thumbnail).ToString().Trim())
{
thumbImg += SiteHelper.GetFileServer() + dr["ImageUrl"].ToString().Trim() + ";";
}
if (dr["Type"].ToString().Trim() == ((int)ImagesType.Details).ToString().Trim())
{
detailsImg += SiteHelper.GetFileServer() + dr["ImageUrl"].ToString().Trim() + ";";
}
}
}
vehicle["THUMBIMG"] = thumbImg;
vehicle["DETAILSIMG"] = detailsImg;
string lng = vehicle["LONGITUDE"].ToString();
string lat = vehicle["LATITUDE"].ToString();
if (!string.IsNullOrEmpty(lng) && !string.IsNullOrEmpty(lat))
{
/*LatLng latlng = SiteHelper.GetBaiduByGPS(lat, lng);
* vehicle["LATITUDE"] = latlng.latitude;
* vehicle["LONGITUDE"] = latlng.longitude;
* if (vehicle["ADDRESS"].ToString().Length <= 0)
* {
* vehicle["ADDRESS"] = SiteHelper.GetLocationByGPS(vehicle["LONGITUDE"].ToString(), vehicle["LATITUDE"].ToString());
* }*/
LatLng latlng = new LatLng(double.Parse(lat), double.Parse(lng));
latlng = SiteHelper.TransformFromWGSToGCJ(latlng);
vehicle["LATITUDE"] = latlng.latitude;
vehicle["LONGITUDE"] = latlng.longitude;
}
decimal electricity = 0;
decimal.TryParse(vehicle["ELECTRICITY"].ToString(), out electricity);
int dianliang = Decimal.ToInt32(electricity);
vehicle["ELECTRICITY"] = dianliang + "%";
vehicle["PRICESYSTEM"] = SiteHelper.GetFileServer() + "/AppPage/BusinessInfo.aspx?id=" + SiteHelper.GetHashTableValueByKey(vehicle, "ID") + "&type=" + BusinessType.Vehicle.GetHashCode() + "&field=" + BusinessFieldType.PRICESYSTEM.GetHashCode();
vehicle["VEHICLEREMARK"] = SiteHelper.GetFileServer() + "/AppPage/BusinessInfo.aspx?id=" + SiteHelper.GetHashTableValueByKey(vehicle, "ID") + "&type=" + BusinessType.Vehicle.GetHashCode() + "&field=" + BusinessFieldType.VEHICLEREMARK.GetHashCode();
vehicle["TRANSPORTINFORMATION"] = SiteHelper.GetFileServer() + "/AppPage/BusinessInfo.aspx?id=" + SiteHelper.GetHashTableValueByKey(vehicle, "ID") + "&type=" + BusinessType.Vehicle.GetHashCode() + "&field=" + BusinessFieldType.TRANSPORTINFORMATION.GetHashCode();
context.Response.Write(SiteHelper.GetJsonFromHashTable(vehicle, "success", "获取数据成功", "VehicleInfo"));
}
}
}
/// <summary>
/// 获取所有车辆信息
/// </summary>
/// <param name="context"></param>
private void GetVehicles(HttpContext context)
{
string name = context.Request["name"];
int? vstate = null;
if (!string.IsNullOrEmpty(context.Request["vstate"]))
{
int val = 0;
int.TryParse(context.Request["vstate"], out val);
vstate = val;
}
int page_index = 0;
int.TryParse(context.Request["page_index"], out page_index);
int page_size = 0;
int.TryParse(context.Request["page_size"], out page_size);
if (page_size == 0)
{
page_size = 10000;
}
ObjectApiResp resp = new ObjectApiResp();
resp.Code = "0";
resp.Message = "";
resp.Data = "";
VehicleManager vm = new VehicleManager();
DataTable vehicles = vm.GetVehicles(name, vstate, page_index + 1, page_size);
if (vehicles != null && vehicles.Rows.Count > 0)
{
foreach (DataRow dr in vehicles.Rows)
{
dr["ThumbImageUrl"] = SiteHelper.GetFileServer() + dr["ThumbImageUrl"].ToString();
decimal electricity = 0;
decimal.TryParse(dr["Electricity"].ToString(), out electricity);
int dianliang = Decimal.ToInt32(electricity);
dr["Electricity"] = dianliang + "%";
if (dr["LastUpdateTime"] != null && dr["LastUpdateTime"] != DBNull.Value)
{
dr["LastUpdateTime"] = DateTime.Parse(dr["LastUpdateTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
string lng = dr["Longitude"].ToString();
string lat = dr["Latitude"].ToString();
if (!string.IsNullOrEmpty(lng) && !string.IsNullOrEmpty(lat))
{
LatLng latlng = new LatLng(double.Parse(lat), double.Parse(lng));
latlng = SiteHelper.TransformFromWGSToGCJ(latlng);
dr["Longitude"] = latlng.longitude;
dr["Latitude"] = latlng.latitude;
}
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeFormat = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
resp.Data = Newtonsoft.Json.JsonConvert.SerializeObject(vehicles, Formatting.Indented, timeFormat);
}
else
{
resp.Code = "-1";
resp.Message = "未找到相关车辆";
}
context.Response.Write(JsonConvert.SerializeObject(resp));
}
public string Execute(Hashtable params_ht)
{
Hashtable res = params_ht;
if (res["VehicleID"] == null ||
res["Latitude"] == null ||
res["Longitude"] == null ||
res["VehicleID"].ToString().Trim().Length <= 0 ||
res["Latitude"].ToString().Trim().Length <= 0 ||
res["Longitude"].ToString().Trim().Length <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
}
else
{
vehicleID = res["VehicleID"].ToString().Trim();
weidu = res["Latitude"].ToString().Trim();
jingdu = res["Longitude"].ToString().Trim();
VehicleManager vm = new VehicleManager();
SystemImagesManager sim = new SystemImagesManager();
//如何扫码内容为url地址则从地址中取出车辆id
if (vehicleID != null && (vehicleID.StartsWith("http://") || vehicleID.StartsWith("https://")))
{
//http://api.qingniaokeji.cn/download/app.aspx?no=xxxxxxxxxxxxx
Uri uri = new Uri(vehicleID);
System.Collections.Specialized.NameValueCollection coll = System.Web.HttpUtility.ParseQueryString(uri.Query);
vehicleID = coll.Get("no");
}
Hashtable vehicle = vm.GetVehicleInfoByID(vehicleID, weidu, jingdu);
if (vehicle == null || vehicle.Keys.Count <= 0)
{
vehicle = vm.GetVehicleInfoByName(vehicleID, weidu, jingdu);
}
string thumbImg = string.Empty;
string detailsImg = string.Empty;
if (vehicle == null || vehicle.Keys.Count <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "车辆数据为空"));
}
else
{
DataTable dt = sim.GetImagesByVehicleID(vehicleID);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["Type"].ToString().Trim() == ((int)ImagesType.Thumbnail).ToString().Trim())
{
thumbImg += SiteHelper.GetFileServer() + dr["ImageUrl"].ToString().Trim() + ";";
}
if (dr["Type"].ToString().Trim() == ((int)ImagesType.Details).ToString().Trim())
{
detailsImg += SiteHelper.GetFileServer() + dr["ImageUrl"].ToString().Trim() + ";";
}
}
}
vehicle["THUMBIMG"] = thumbImg;
vehicle["DETAILSIMG"] = detailsImg;
string lng = vehicle["LONGITUDE"].ToString();
string lat = vehicle["LATITUDE"].ToString();
if (!string.IsNullOrEmpty(lng) && !string.IsNullOrEmpty(lat))
{
LatLng latlng = new LatLng(double.Parse(lat), double.Parse(lng));
if (res["Client"] != null && "iOS" == res["Client"].ToString())
{
latlng = new LatLng(double.Parse(lat), double.Parse(lng));
latlng = SiteHelper.TransformFromWGSToGCJ(latlng);
vehicle["LONGITUDE"] = latlng.longitude;
vehicle["LATITUDE"] = latlng.latitude;
}
else
{
/*latlng = SiteHelper.GetBaiduByGPS(lat, lng);
* if (latlng != null)
* {
* vehicle["LATITUDE"] = latlng.latitude;
* vehicle["LONGITUDE"] = latlng.longitude;
* if (vehicle["ADDRESS"].ToString().Length <= 0)
* {
* vehicle["ADDRESS"] = SiteHelper.GetLocationByGPS(vehicle["LATITUDE"].ToString(), vehicle["LONGITUDE"].ToString());
* }
* }*/
latlng = new LatLng(double.Parse(lat), double.Parse(lng));
latlng = SiteHelper.TransformFromWGSToGCJ(latlng);
vehicle["LONGITUDE"] = latlng.longitude;
vehicle["LATITUDE"] = latlng.latitude;
string citycode = "", cityname = "";
vehicle["ADDRESS"] = SiteHelper.GetAddressInfoByGPS(latlng.longitude.ToString(), latlng.latitude.ToString(), out citycode, out cityname);
}
}
decimal electricity = 0;
decimal.TryParse(vehicle["ELECTRICITY"].ToString(), out electricity);
int dianliang = Decimal.ToInt32(electricity);
vehicle["ELECTRICITY"] = dianliang + "%";
vehicle["PRICESYSTEM"] = SiteHelper.GetFileServer() + "/AppPage/BusinessInfo.aspx?id=" + SiteHelper.GetHashTableValueByKey(vehicle, "ID") + "&type=" + BusinessType.Vehicle.GetHashCode() + "&field=" + BusinessFieldType.PRICESYSTEM.GetHashCode();
vehicle["VEHICLEREMARK"] = SiteHelper.GetFileServer() + "/AppPage/BusinessInfo.aspx?id=" + SiteHelper.GetHashTableValueByKey(vehicle, "ID") + "&type=" + BusinessType.Vehicle.GetHashCode() + "&field=" + BusinessFieldType.VEHICLEREMARK.GetHashCode();
vehicle["TRANSPORTINFORMATION"] = SiteHelper.GetFileServer() + "/AppPage/BusinessInfo.aspx?id=" + SiteHelper.GetHashTableValueByKey(vehicle, "ID") + "&type=" + BusinessType.Vehicle.GetHashCode() + "&field=" + BusinessFieldType.TRANSPORTINFORMATION.GetHashCode();
return(SiteHelper.GetJsonFromHashTable(vehicle, "success", "获取数据成功", "VehicleInfo"));
}
}
}
public string Execute(Hashtable params_ht)
{
Hashtable res = params_ht;
if (res["VehicleID"] == null || res["VehicleID"].ToString().Trim().Length <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
}
else
{
vehicleID = res["VehicleID"].ToString().Trim();
VehicleManager vm = new VehicleManager();
SystemImagesManager sim = new SystemImagesManager();
//如何扫码内容为url地址则从地址中取出车辆id
if (vehicleID != null && (vehicleID.StartsWith("http://") || vehicleID.StartsWith("https://")))
{
//http://api.qingniaokeji.cn/download/app.aspx?no=xxxxxxxxxxxxx
Uri uri = new Uri(vehicleID);
System.Collections.Specialized.NameValueCollection coll = System.Web.HttpUtility.ParseQueryString(uri.Query);
vehicleID = coll.Get("no");
}
Hashtable vehicle = vm.GetVehicleInfoByIDORNumber(vehicleID);
OrdersManager om = new OrdersManager();
string thumbImg = string.Empty;
string detailsImg = string.Empty;
if (vehicle == null || vehicle.Keys.Count <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "车辆数据为空"));
}
else
{
DataTable dt = sim.GetImagesByVehicleID(vehicleID);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["Type"].ToString().Trim() == ((int)ImagesType.Thumbnail).ToString().Trim())
{
thumbImg += SiteHelper.GetFileServer() + dr["ImageUrl"].ToString().Trim() + ";";
}
if (dr["Type"].ToString().Trim() == ((int)ImagesType.Details).ToString().Trim())
{
detailsImg += SiteHelper.GetFileServer() + dr["ImageUrl"].ToString().Trim() + ";";
}
}
}
vehicle["THUMBIMG"] = thumbImg;
vehicle["DETAILSIMG"] = detailsImg;
string lng = vehicle["LONGITUDE"].ToString();
string lat = vehicle["LATITUDE"].ToString();
if (!string.IsNullOrEmpty(lng) && !string.IsNullOrEmpty(lat))
{
LatLng latlng = new LatLng(double.Parse(lat), double.Parse(lng));
latlng = SiteHelper.TransformFromWGSToGCJ(latlng);
if (latlng != null)
{
vehicle["LATITUDE"] = latlng.latitude;
vehicle["LONGITUDE"] = latlng.longitude;
if (vehicle["ADDRESS"].ToString().Length <= 0)
{
vehicle["ADDRESS"] = SiteHelper.GetLocationByGPS(vehicle["LONGITUDE"].ToString(), vehicle["LATITUDE"].ToString(), "gcj02ll");
}
}
}
decimal electricity = 0;
decimal.TryParse(vehicle["ELECTRICITY"].ToString(), out electricity);
int dianliang = Decimal.ToInt32(electricity);
vehicle["ELECTRICITY"] = dianliang + "%";
vehicle["AbnormalState"] = 0;
Hashtable abht = null;// vm.GetAbnormalVehicle(vehicle["ID"].ToString());
if (abht != null && abht.Keys.Count > 0)
{
vehicle["AbnormalState"] = 1;
vehicle["AlarmType"] = SiteHelper.GetHashTableValueByKey(abht, "AlarmType");
vehicle["AlarmTime"] = SiteHelper.GetHashTableValueByKey(abht, "AlarmTime");
}
vehicle["ChargeBeginTime"] = "";
Hashtable chargeht = vm.GetVehicleChargingInfo(vehicle["ID"].ToString());
if (chargeht != null && chargeht.Keys.Count > 0)
{
vehicle["ChargeBeginTime"] = chargeht["BEGINTIME"].ToString();
}
Hashtable order_ht = om.GetLatestUserByVehicleID(vehicle["ID"].ToString());
if (order_ht != null && order_ht.Keys.Count > 0)
{
vehicle["OrderUserName"] = order_ht["REALNAME"];
vehicle["OrderUserTel"] = order_ht["BINDPHONE"];
//vehicle["HeadPortrait"] = SiteHelper.GetFileServer() + order_ht["HEADPORTRAIT"];
vehicle["HeadPortrait"] = "";
vehicle["OrderState"] = order_ht["ORDERSTATE"];
vehicle["UserType"] = order_ht["USERTYPE"];
vehicle["OrderTime"] = order_ht["CREATETIME"];
}
else
{
vehicle["OrderUserName"] = "";
vehicle["OrderUserTel"] = "";
vehicle["HeadPortrait"] = "";
vehicle["OrderState"] = "";
vehicle["UserType"] = "";
vehicle["OrderTime"] = "";
}
return(SiteHelper.GetJsonFromHashTable(vehicle, "success", "获取数据成功", "VehicleInfo"));
}
}
}
public string Execute(Hashtable params_ht)
{
Hashtable res = params_ht;
string mark = "0";
string logo_path = HttpContext.Current.Server.MapPath("/api/operations/logo.png");
if (System.IO.File.Exists(logo_path))
{
System.IO.FileInfo file_info = new System.IO.FileInfo(logo_path);
mark = file_info.CreationTime.ToString("yyyyMMddHHmmss");
}
Hashtable startingimage = new Hashtable();
startingimage["MARK"] = mark;
startingimage["URL"] = string.Format("{0}/api/operations/logo.png?mark={1}", SiteHelper.GetFileServer(), mark);
return(SiteHelper.GetJsonFromHashTable(startingimage, "success", "获取数据成功", "StartImage"));
}
