private BaseSubscribe GetBaseSubscribe() { BaseSubscribe result = null; try { result = new BaseSubscribe(); result.status = "ALL"; result.dxpMode = "DXP"; result.dxpAddress = "DXPENT0000001110"; ; result.note = null; } catch (Exception) { throw; } return result; }
public bool CreateMessage601(string logisticsNo) { bool success = true; InventoryHead inventoryHead = null; List<InventoryList> inventoryLists = null; BaseSubscribe baseSubscribe = null; XElement xele = null; XNamespace ns = null; MessageSql mssql = null; MessageService msService = null; try { inventoryHead = new InventoryHead(); inventoryLists = new List<InventoryList>(); baseSubscribe = new BaseSubscribe(); mssql = new MessageSql(); mssql.QueryDate601(logisticsNo, ref inventoryHead, ref inventoryLists, ref baseSubscribe); if (inventoryHead.guid != new Guid()) { ns = "http://www.chinaport.gov.cn/ceb"; xele = new XElement(ns + "CEB601Message"); xele.SetAttributeValue(XNamespace.Xmlns + "ceb", ns); xele = inventoryHead.ToXElememt(xele, ns); foreach (var a in inventoryLists) { xele = a.ToXElememt(xele, ns); } xele = baseSubscribe.ToXElememt(xele, ns); FileUtilities.CreateFolder(ConfigurationInfo.PathSend); xele.Save(ConfigurationInfo.PathSend + "\\" + FileUtilities.GetNewFileName(inventoryHead.orderNo) + "_601.xml"); string destPath = FileUtilities.GetNewFolderName(true, ConfigurationInfo.PathBackUp, "601") + "\\" + FileUtilities.GetNewFileName(inventoryHead.orderNo, "Create") + ".xml"; msService = new MessageService(); msService.DealMessage601(false, true, inventoryHead.guid.ToString(), inventoryHead.copNo, destPath); xele.Save(destPath); } else { Logs.Info("Does not exist in database:" + logisticsNo); success = false; } } catch (Exception ex) { Logs.Error("Create301Message Exception:" + ex.ToString()); success = false; } return success; }
public void QueryDate601(string logisticsNo, ref InventoryHead inventoryHead, ref List<InventoryList> inventoryLists, ref BaseSubscribe baseSubscribe) { InventoryList inventoryList = null; SqlDataReader dr = null; try { dr = a_sqlServer.ExePROC("MessageCenterQuery", ConvertToSqlParameters(601, "", logisticsNo)); if (dr.HasRows) { int i = 1; while (dr.Read()) { if (i == 1) { inventoryHead = GetInventoryHead(dr); } inventoryList = GetInventoryList(dr, i++); InventoryList exist = inventoryLists.Find(o => o.gno.Equals(inventoryList.gno)); if (exist == null) { inventoryLists.Add(inventoryList); } else { exist.qty += inventoryList.qty; exist.total += inventoryList.total; exist.qty1 += inventoryList.qty1; exist.qty2 += inventoryList.qty2; } baseSubscribe = GetBaseSubscribe(dr); } foreach (var list in inventoryLists) { var f = inventoryHead.netWeight / inventoryLists.Count; list.qty2 = ((float?)((int)(f * 100))) / 100; } //a_sqlServer.ExePROCNonQuery("MessageReceipt", ConvertToSqlParameters("601", inventoryHead.orderNo, logisticsNo, "0", "", inventoryHead.copNo, "", "")); } } catch (Exception ex) { Logs.Error("Query601DataByOrderNo Exception:" + ex.ToString()); } finally { dr.Close(); } }