/// <summary>
/// 更新订单温湿度上报进度
/// </summary>
/// <param name="relation">包含运单信息以及运单温湿度数据上报的进度</param>
/// <returns></returns>
public static bool UpdataUploadDataNode(RelationModel relation)//, ref List<long> _ignoreTempRelationList)
{
bool isArrived = false;
//试图获取当前运单的下一个节点
NodeInfo nodeInfo = NodeUploadServer.GetNextUploadNodeInfo(relation.CurrentUploadDataNodeId, relation.Number);
//如果存在下一个节点并且当前上报进度等于下一个节点的创建时间，则更新上报进度的节点
if (nodeInfo != null && DateTime.Parse(relation.CurrentUploadDataTime) >= DateTime.Parse(nodeInfo.OperateAt))
{
relation.CurrentUploadDataNodeId = nodeInfo.Id;
}
//查询当前节点是否已经运抵
if (relation.CurrentUploadDataNodeId != -1)
{
string sql = "select arrived from waybill_node where id = " + relation.CurrentUploadDataNodeId;
object arrived = DbHelperMySQL.GetSingle(sql);
if (arrived == null)
{
throw new Exception("获取节点信息失败");
}
isArrived = (arrived.ToString() == "2" && (relation.CurrentUploadNodeId == 0));
}
//if (isArrived)
// _ignoreTempRelationList.Remove(relation.Id);
return(UpdateCurrentRelationUploadDataNode(relation, isArrived));
//}
//else {
//return UpdateCurrentRelationUploadDataNode(relation, false);
//}
//查询当前节点冷藏载体的下一条温湿度数据，如果大于下一个节点的时间，则进入下一个节点
//string sql = "select StorageId from waybill_Node where id = " + relation.CurrentUploadDataNodeId;
//object storageId = DbHelperMySQL.GetSingle(sql);
//if (storageId == null)
// throw new Exception(string.Format("获取下一节点失败:R【{0}】 O【{1}】 N【{2}】", relation.RelationId, relation.Number, relation.CurrentUploadDataNodeId));
//sql = string.Format("select dataTime from history_data_{0} where dataTime > '{1}' limit 1", storageId, relation.CurrentUploadDataTime);
//object dataTime = DbHelperMySQL.GetSingle(sql);
//if (dataTime != null && Convert.ToDateTime(dataTime) > DateTime.Parse(relation.CurrentUploadDataTime))
//{
// if (nodeInfo != null)
// relation.CurrentUploadDataNodeId = nodeInfo.Id;
// else
// {
// //查询当前节点是否已经运抵
// sql = "select arrived from waybill_node where id = " + relation.CurrentUploadDataNodeId;
// object arrived = DbHelperMySQL.GetSingle(sql);
// if (arrived == null)
// throw new Exception("获取节点信息失败");
// isArrived = arrived.ToString() == "2";
// if (isArrived)
// _ignoreTempRelationList.Remove(relation.Id);
// }
//}
//else
// _ignoreTempRelationList.Add(relation.Id);
//return UpdateCurrentRelationUploadDataNode(relation, isArrived);
}
public static Model.NodeDataUpload.XML GetNextWaitUploadDatas(List <string> senderCodeList, ref List <M_TMSData> loginkData, out RelationModel relation)
{
Model.NodeDataUpload.XML result = null;
relation = new RelationModel();
try
{
relation = GetNextWaitUploadDataOrderRelation(senderCodeList);//, ref _ignoreTempRelationList);
if (relation != null)
{
NodeInfo nodeInfo = NodeUploadServer.GetNextUploadNodeInfo(relation.CurrentUploadDataNodeId, relation.Number);
if (nodeInfo != null)
{
//从未上报过节点数据
if (string.IsNullOrEmpty(relation.CurrentUploadDataTime) || relation.CurrentUploadDataNodeId == null || relation.CurrentUploadDataNodeId == -1)
{
relation.CurrentUploadDataTime = nodeInfo.OperateAt;
relation.CurrentUploadDataNodeId = nodeInfo.Id;
//更新冷链数据上报进度
bool isUpdataRelation = UpdateCurrentRelationUploadDataNode(relation, false);
string info = string.Format("R【{0}】 O【{1}】 N【{2}】 T【{3}】", relation.RelationId, relation.Number, relation.CurrentUploadDataNodeId, relation.CurrentUploadDataTime);
throw new Exception(info + (isUpdataRelation ? "更新为首节点成功." : "更新为首节点失败."));
//throw new Exception("首个节点暂不上报数据 " );
}
else
{
//获取待上报数据
DataTable dt = GetStorageData((int)relation.CurrentUploadDataNodeId, DateTime.Parse(relation.CurrentUploadDataTime), DateTime.Parse(nodeInfo.OperateAt).AddDays(1));//结束时间+30分钟改为24小时
if (dt == null)
{
string info = string.Format("R【{0}】 O【{1}】 N【{2}】 T【{3}】", relation.RelationId, relation.Number, relation.CurrentUploadDataNodeId, relation.CurrentUploadDataTime);
if ((DateTime.Now - DateTime.Parse(relation.CurrentUploadDataTime)).TotalDays > int.Parse(Utility._StorageDataTimeOut))
{
relation.CurrentUploadDataTime = nodeInfo.OperateAt;
relation.CurrentUploadDataNodeId = nodeInfo.Id;
bool isUpdataRelation = UpdateCurrentRelationUploadDataNode(relation, false);
throw new Exception(info + "放弃等待当前载体温湿度,已过" + int.Parse(Utility._StorageDataTimeOut) + "*24小时 更新为下一节点" + (isUpdataRelation ? "成功." : "失败."));
}
else
{
UpdateHandleTHTime(relation.Id, false);
//_ignoreTempRelationList.Add(relation.Id);
throw new Exception(info + "没有新的载体温湿度.");
}
}
result = new Model.NodeDataUpload.XML();
result.CONTENTLIST = new List <CONTENT>();
result.CONTENTLIST.Add(new CONTENT());
result.CONTENTLIST[0].DETAILLIST = new List <DETAIL>();
DETAIL dModel = new DETAIL();
dModel.ECNO = NodeUploadServer.GetShipmentCodeByTMSOrder(relation.RelationId);
dModel.LEGNO = relation.RelationId;
Utility.AddLogText(string.Format("dModel:ECNO:{0},LEGNO:{1},RelationId:{2}", dModel.ECNO, dModel.LEGNO, relation.RelationId));
GetStorageByNodeId((int)relation.CurrentUploadDataNodeId, ref dModel);
loginkData = new List <M_TMSData>();
foreach (DataRow row in dt.Rows)
{
string temp = row["t"] is DBNull ? string.Empty : row["t"].ToString();
string hump = string.Empty;
try
{
hump = row["h"] is DBNull ? string.Empty : row["h"].ToString();
}
catch
{
}
if (temp == "System.Byte[]")
{
temp = System.Text.Encoding.Default.GetString(row["t"] as byte[]);
}
if (hump == "System.Byte[]")
{
hump = System.Text.Encoding.Default.GetString(row["h"] as byte[]);
}
DETAIL detail = new DETAIL();
detail.ECNO = dModel.ECNO;
detail.LEGNO = dModel.LEGNO;
detail.LICENSENO = dModel.LICENSENO;
detail.WAREHOUSECODE = dModel.WAREHOUSECODE;
detail.TRACKTIME = Convert.ToDateTime(row["datatime"]).ToString("yyyy-MM-dd HH:mm:ss");
detail.TEMPREATURE = temp.Replace("-300.0", "").Replace("-300", "");
detail.HUMIDITY = hump.Replace("-300.0", "").Replace("-300", "");
try
{
detail.LONGITUDE = row["lo"] is DBNull ? string.Empty : row["lo"].ToString();
}
catch
{
}
try
{
detail.LATITUDE = row["la"] is DBNull ? string.Empty : row["la"].ToString();
}
catch
{
}
Utility.AddLogText(string.Format("detail:ECNO:{0},LEGNO:{1}", detail.ECNO, detail.LEGNO));
result.CONTENTLIST[0].DETAILLIST.Add(detail);
M_TMSData data = new M_TMSData();
data.Latitude = detail.LATITUDE == string.Empty ? null : detail.LATITUDE.ToString();
data.Longitude = detail.LONGITUDE == string.Empty ? null : detail.LONGITUDE.ToString();
data.RecordTime = Convert.ToDateTime(row["datatime"]);
data.OrderNo = relation.RelationId;
data.JcOrderNo = relation.Number;
data.JcNodeId = (int)relation.CurrentUploadDataNodeId;
Type t = data.GetType();
for (int i = 0; i < temp.Split('|').Count(); i++)
{
t.GetProperty("T" + (i + 1)).SetValue(data, temp.Split('|')[i].ToString(), null);
}
for (int i = 0; i < hump.Split('|').Count(); i++)
{
t.GetProperty("RH" + (i + 1)).SetValue(data, hump.Split('|')[i].ToString(), null);
}
loginkData.Add(data);
relation.CurrentUploadDataTime = detail.TRACKTIME;
if (DateTime.Parse(detail.TRACKTIME) >= DateTime.Parse(nodeInfo.OperateAt))
{
break;
}
}
}
}
else
{
UpdataUploadDataNode(relation);//, ref _ignoreTempRelationList);
}
}
}
catch (Exception ex)
{
//if (relation != null)
// _ignoreTempRelationList.Add(relation.Id);
throw new Exception(ex.Message);
}
return(result);
}