public string GetExternalParkingData()
{
Dictionary <string, string> parkings = new Dictionary <string, string>();
List <BWYGateMapping> gates = BWYGateMappingServices.QueryAll();
foreach (var item in gates)
{
if (!parkings.ContainsKey(item.ParkingID))
{
parkings.Add(item.ParkingID, item.ParkingName);
}
}
StringBuilder strTree = new StringBuilder();
strTree.Append("[");
strTree.Append("{\"id\":\"-1\",");
strTree.Append("\"text\":\"所有\",\"selected\":true");
strTree.Append("}");
foreach (var item in parkings)
{
strTree.Append(",{\"id\":\"" + item.Key + "\",");
strTree.Append("\"text\":\"" + item.Value + "\"");
strTree.Append("}");
}
strTree.Append("]");
return(strTree.ToString());
}
/// <summary>
/// 导出
/// </summary>
/// <returns></returns>
public ActionResult Export()
{
List <BWYGateMapping> gates = BWYGateMappingServices.QueryAll();
List <OnlineOrder> onlineOrder = OnlineOrderServices.ExportQueryPage(GetOnlineOrderCondition());
var result = from p in onlineOrder
select new
{
订单编号 = p.OrderID.ToString(),
车场名称 = p.PKName,
车牌号 = p.PlateNo,
支付金额 = p.Amount,
续期月数 = p.OrderType == OnlineOrderType.MonthCardRecharge ? p.MonthNum.ToString() : string.Empty,
支付人 = p.PayerNickName,
步支付次数 = p.SyncResultTimes,
最后同步时间 = p.LastSyncResultTime != DateTime.MinValue ? p.LastSyncResultTime.ToString("yyyy-MM-dd HH:mm:ss") : string.Empty,
退款订单号 = p.RefundOrderId,
订单类型 = p.OrderType.GetDescription(),
订单状态 = p.Status.GetDescription(),
订单时间 = p.OrderTime.ToString("yyyy-MM-dd HH:mm:ss"),
支付时间 = p.RealPayTime != DateTime.MinValue ? p.RealPayTime.ToString("yyyy-MM-dd HH:mm:ss") : string.Empty,
外部车场名称 = GetBWYParkingName(p.ExternalPKID, gates),
备注 = p.Remark
};
StringBuilder sb = new StringBuilder();
sb.Append(JsonHelper.GetJsonString(result));
var dt = JsonToDataTable(sb.ToString());
var dl = DownLoadExcel(dt);
return(dl);
}
public string GetBWYParkGateData()
{
JsonResult json = new JsonResult();
string parkName = Request.Params["ParkName"];
string gateName = Request.Params["GateName"];
int page = string.IsNullOrEmpty(Request.Params["page"]) ? 0 : int.Parse(Request.Params["page"]);
int rows = string.IsNullOrEmpty(Request.Params["rows"]) ? 0 : int.Parse(Request.Params["rows"]);
int?dataSource = null;
int source = 0;
if (!string.IsNullOrWhiteSpace(Request.Params["DataSource"]) && int.TryParse(Request.Params["DataSource"], out source))
{
dataSource = source;
}
StringBuilder strData = new StringBuilder();
try
{
int total = 0;
List <BWYGateMapping> models = BWYGateMappingServices.QueryPage(parkName, gateName, dataSource, page, rows, out total);
strData.Append("{");
strData.Append("\"total\":" + total + ",");
strData.Append("\"rows\":" + JsonHelper.GetJsonString(models) + ",");
strData.Append("\"index\":" + page);
strData.Append("}");
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "查询错误日志失败");
}
return(strData.ToString());
}
public JsonResult SaveEdit(BWYGateMapping model)
{
try
{
bool result = false;
if (string.IsNullOrWhiteSpace(model.RecordID))
{
model.DataSource = 0;
result = BWYGateMappingServices.Add(model);
if (!result)
{
throw new MyException("添加失败");
}
return(Json(MyResult.Success()));
}
else
{
result = BWYGateMappingServices.Update(model);
if (!result)
{
throw new MyException("修改失败");
}
return(Json(MyResult.Success()));
}
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "保存岗亭信息失败");
return(Json(MyResult.Error("保存岗亭信息失败")));
}
}
public static TempParkingFeeResult SFMTempParkingFeeResult(string ParkNo, string GateID)
{
TempParkingFeeResult result = new TempParkingFeeResult();
result.Result = APPResult.OtherException;
result.ErrorDesc = "车场或通道编号未配置";
if (!string.IsNullOrWhiteSpace(SystemDefaultConfig.SFMPKID) && !string.IsNullOrWhiteSpace(ParkNo) && !string.IsNullOrWhiteSpace(GateID))
{
try
{
BWYGateMapping gate = BWYGateMappingServices.QueryByGateID(1, ParkNo, GateID);
if (gate == null)
{
result.Result = APPResult.OtherException;
result.ErrorDesc = "获取车场信息失败";
TxtLogServices.WriteTxtLogEx("SFMError", string.Format("SFMTempParkingFeeResult方法，获取车场信息失败，通道编号：{0}", GateID));
return(result);
}
TxtLogServices.WriteTxtLogEx("SFMError", string.Format("SFMTempParkingFeeResult方法,SFMInterfaceUrl:{0},SFMSecretKey:{1},SFMPKID:{2}", SFMInterfaceUrl, SFMSecretKey, SFMPKID));
if (!string.IsNullOrWhiteSpace(SFMInterfaceUrl) && !string.IsNullOrWhiteSpace(SFMSecretKey) && !string.IsNullOrWhiteSpace(SFMPKID))
{
OutCarInfoResult sfmResult = SFMInterfaceProcess.QueryOutCarOrder(gate.ParkNo, GateID);
if (!sfmResult.Success)
{
result.Result = APPResult.OtherException;
result.ErrorDesc = string.Format("{0}[{1}]", sfmResult.Message, sfmResult.Code);
return(result);
}
if (sfmResult.Data == null)
{
result.Result = APPResult.NoCarInBox;
result.ErrorDesc = string.Empty;
return(result);
}
return(SFMTransforTempParkingFeeResult(result, sfmResult));
}
}
catch (Exception ex)
{
TxtLogServices.WriteTxtLogEx("SFMError", string.Format("SFMTempParkingFeeResult方法，异常：{0}", ex.Message));
}
}
else
{
TxtLogServices.WriteTxtLogEx("SFMError", string.Format("SFMTempParkingFeeResult方法，参数无效：{0},GateID:{1}", SystemDefaultConfig.SFMPKID, GateID));
}
return(result);
}
public string GetOnlineOrderData()
{
StringBuilder strData = new StringBuilder();
try
{
if (string.IsNullOrWhiteSpace(Request.Params["Query"]))
{
return(strData.ToString());
}
int page = string.IsNullOrEmpty(Request.Params["page"]) ? 0 : int.Parse(Request.Params["page"]);
int rows = string.IsNullOrEmpty(Request.Params["rows"]) ? 0 : int.Parse(Request.Params["rows"]);
List <BWYGateMapping> gates = BWYGateMappingServices.QueryAll();
int total = 0;
List <OnlineOrder> result = OnlineOrderServices.QueryPage(GetOnlineOrderCondition(), page, rows, out total);
var obj = from p in result
select new
{
OrderID = p.OrderID.ToString(),
PKName = p.PKName,
PlateNo = p.PlateNo,
Amount = p.Amount,
MonthNum = p.OrderType == OnlineOrderType.MonthCardRecharge ? p.MonthNum.ToString() : string.Empty,
PayerNickName = p.PayerNickName,
SyncResultTimes = p.SyncResultTimes,
LastSyncResultTime = p.LastSyncResultTime != DateTime.MinValue ? p.LastSyncResultTime.ToString("yyyy-MM-dd HH:mm:ss") : string.Empty,
RefundOrderId = p.RefundOrderId,
Remark = p.Remark,
OrderType = (int)p.OrderType,
OrderTypeDes = p.OrderType.GetDescription(),
Status = (int)p.Status,
StatusDes = p.Status.GetDescription(),
OrderTime = p.OrderTime.ToString("yyyy-MM-dd HH:mm:ss"),
RealPayTime = p.RealPayTime != DateTime.MinValue ? p.RealPayTime.ToString("yyyy-MM-dd HH:mm:ss") : string.Empty,
BWYParkingName = GetBWYParkingName(p.ExternalPKID, gates)
};
strData.Append("{");
strData.Append("\"total\":" + total + ",");
strData.Append("\"rows\":" + JsonHelper.GetJsonString(obj) + ",");
strData.Append("\"index\":" + page);
strData.Append("}");
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "查询微信订单信息失败");
}
return(strData.ToString());
}
public JsonResult Delete(string recordId)
{
try
{
bool result = BWYGateMappingServices.Delete(recordId);
if (!result)
{
throw new MyException("删除失败");
}
return(Json(MyResult.Success()));
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "删除信息失败");
return(Json(MyResult.Error("删除信息失败")));
}
}
public JsonResult SaveQRCodeParkNo(BWYGateMapping model)
{
try
{
bool result = BWYGateMappingServices.UpdateParkNo(model.RecordID, model.ParkNo);
if (!result)
{
throw new MyException("保存失败");
}
return(Json(MyResult.Success()));
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "保存二维码车场编号失败");
return(Json(MyResult.Error("保存二维码车场编号失败")));
}
}
public JsonResult DownloadQRCode(string gateId, int size)
{
try
{
List <int> dics = new List <int>();
dics.Add(258);
dics.Add(344);
dics.Add(430);
dics.Add(860);
dics.Add(1280);
List <string> imgs = new List <string>();
BWYGateMapping gate = BWYGateMappingServices.QueryByRecordId(gateId);
if (gate == null)
{
throw new MyException("获取车场信息失败");
}
if (string.IsNullOrWhiteSpace(SystemDefaultConfig.SystemDomain))
{
throw new MyException("获取域名失败");
}
BaseCompany company = null;
if (gate.DataSource == 0)
{
if (string.IsNullOrWhiteSpace(SystemDefaultConfig.BWPKID))
{
throw new MyException("获取车场编号失败");
}
company = CompanyServices.QueryByParkingId(SystemDefaultConfig.BWPKID);
}
else
{
if (string.IsNullOrWhiteSpace(SystemDefaultConfig.SFMPKID))
{
throw new MyException("获取车场编号失败");
}
if (string.IsNullOrWhiteSpace(gate.ParkNo))
{
throw new MyException("二维码车场编号不能为空");
}
company = CompanyServices.QueryByParkingId(SystemDefaultConfig.SFMPKID);
}
if (company == null)
{
throw new MyException("获取单位编号失败");
}
string content = string.Format("{0}/qrl/scio_ix_pid={1}^io={2}^source=0", SystemDefaultConfig.SystemDomain, SystemDefaultConfig.BWPKID, gate.GateID);
if (gate.DataSource == 1)
{
content = string.Format("{0}/qrl/scio_ix_pid={1}^io={2}^source=0", SystemDefaultConfig.SystemDomain, SystemDefaultConfig.SFMPKID, gate.ParkNo + "$" + gate.GateID);
}
foreach (var item in dics)
{
string parkingName = string.Format("{0}_{1}_{2}", gate.ParkingName, gate.GateName, item);
string result = QRCodeServices.GenerateQRCode(company.CPID, content, item, parkingName);
imgs.Add(item.ToString() + "|" + result);
}
return(Json(MyResult.Success("", imgs)));
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "下载外部车场二维码失败");
return(Json(MyResult.Error("下载外部车场二维码失败")));
}
}
public JsonResult ImportSFMParking()
{
try
{
SFMParkInfoResult result = SFMInterfaceProcess.GetParkInfo();
if (result == null || !result.Success)
{
throw new MyException("获取车场信息失败");
}
if (result.Data == null || result.Data.TotalRecord == 0 ||
result.Data.ResultList == null || result.Data.ResultList.Count == 0)
{
throw new MyException("无车场信息");
}
List <BWYGateMapping> models = new List <BWYGateMapping>();
foreach (var item in result.Data.ResultList)
{
BWYGateMapping model = new BWYGateMapping();
model.ParkingID = item.parkKey;
model.ParkingName = item.parkName;
model.DataSource = 1;
List <ParkSentry> parkSentry = item.parkSentry;
if (parkSentry != null && parkSentry.Count > 0)
{
foreach (var sentry in parkSentry)
{
model.ParkBoxID = sentry.sentryNo;
model.ParkBoxName = sentry.sentryName;
List <ParkLane> parkLanes = sentry.parkLane;
if (parkLanes != null)
{
foreach (var lane in parkLanes)
{
if (lane.vehicleType != "1")
{
continue;
}
BWYGateMapping gateMap = new BWYGateMapping();
gateMap.ParkingID = model.ParkingID;
gateMap.ParkingName = model.ParkingName;
gateMap.DataSource = model.DataSource;
gateMap.ParkBoxID = model.ParkBoxID;
gateMap.ParkBoxName = model.ParkBoxName;
gateMap.GateID = lane.vehicleNo;
gateMap.GateName = lane.vehicleName;
models.Add(gateMap);
}
}
}
}
}
if (models.Count == 0)
{
throw new MyException("请核实塞菲姆车场数据的完整性");
}
bool addResult = BWYGateMappingServices.UpdateSFMParking(models);
if (!addResult)
{
throw new MyException("导入塞菲姆车场信息失败");
}
return(Json(MyResult.Success()));
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "导入塞菲姆车场信息失败");
return(Json(MyResult.Error("导入塞菲姆车场信息失败")));
}
}
