List <Hyt.Model.Icp.GZBaiYunJiChang.Order.OrderGoodsList> SetOrderGoodsListList(int OrderSysNo)
{
//获取电子订单编号
FnOnlinePayment OnPayment = Hyt.BLL.Finance.FinanceBo.Instance.GetOnlinePaymentBySourceSysNo(OrderSysNo);
List <Hyt.Model.Icp.GZBaiYunJiChang.Order.OrderGoodsList> OrderGoodsListList = new List <Hyt.Model.Icp.GZBaiYunJiChang.Order.OrderGoodsList>();
IList <SoOrderItem> OrderItem = SoOrderBo.Instance.GetOrderItemsByOrderId(OrderSysNo);
int i = 0;
foreach (SoOrderItem item in OrderItem)
{
i++;
IcpBYJiChangGoodsInfo Entity = IcpBo.Instance.GetIcpBYJiChangGoodsInfoEntityByPid(item.ProductSysNo);
if (Entity != null)
{
OrderGoodsListList.Add(new Hyt.Model.Icp.GZBaiYunJiChang.Order.OrderGoodsList()
{
Seq = i.ToString(),
LogisticsOrderNo = OnPayment.BusinessOrderSysNo,
EntGoodsNo = Entity.EntGoodsNo,
EPortGoodsNo = Entity.EPortGoodsNo,
CIQGoodsNo = Entity.CIQGoodsNo,
CusGoodsNo = Entity.CusGoodsNo,
HSCode = Entity.HSCode,
GoodsName = Entity.GoodsName,
GoodsStyle = Entity.GoodsStyle,
BarCode = Entity.BarCode,
Brand = Entity.Brand,
Qty = item.Quantity.ToString(),
Unit = Entity.GUnit,
Price = item.SalesUnitPrice.ToString(),
Total = item.SalesAmount.ToString(),
CurrCode = Entity.CurrCode,
Notes = Entity.Notes
});
}
}
//OrderGoodsListList.Add(new Hyt.Model.Icp.GZBaiYunJiChang.Order.OrderGoodsList()
//{
// Seq = "1",
// LogisticsOrderNo = "A20150915007",
// EntGoodsNo = "123",
// EPortGoodsNo = "",
// CIQGoodsNo = "1500096155",
// CusGoodsNo = "GDO5141507080000560",
// HSCode = "1901900000",
// GoodsName = "日本尤妮佳拉拉裤男用XXL26片",
// GoodsStyle = "XXL码|26片/包",
// BarCode = "",
// Brand = "尤妮佳",
// Qty = "1",
// Unit = "125",
// Price = "100.00",
// Total = "100.00",
// CurrCode = "142",
// Notes = ""
//});
return(OrderGoodsListList);
}
/// <summary>
///
/// </summary>
/// <param name="SysNo"></param>
/// <returns></returns>
/// <remarkss>2016-04-05 王耀发 更新</remarks>
public override int UpdateIcpBYJiChangGoodsInfoEntity(IcpBYJiChangGoodsInfo entity)
{
return(Context.Update("IcpBYJiChangGoodsInfo", entity)
.AutoMap(o => o.SysNo)
.Where("SysNo", entity.SysNo)
.Execute());
}
/// <summary>
///
/// </summary>
/// <param name="SysNo"></param>
/// <returns></returns>
/// <remarkss>2016-04-05 王耀发 创建</remarks>
public override int InsertIcpBYJiChangGoodsInfo(IcpBYJiChangGoodsInfo entity)
{
entity.SysNo = Context.Insert("IcpBYJiChangGoodsInfo", entity)
.AutoMap(o => o.SysNo)
.ExecuteReturnLastId <int>("SysNo");
return(entity.SysNo);
}
/// <summary>
/// 保存白云机场的商品配置信息
/// </summary>
/// <param name="productModel"></param>
/// <returns></returns>
/// <remarks>2016-04-05 王耀发 创建</remarks>
public Result SaveIcpBYJiChangGoodsInfo(IcpBYJiChangGoodsInfo model, SyUser user)
{
Result r = new Result()
{
Status = false
};
IcpBYJiChangGoodsInfo entity = IcpDao.Instance.GetIcpBYJiChangGoodsInfoEntityByPid(model.ProductSysNo);
if (entity != null)
{
model.SysNo = entity.SysNo;
model.CreatedDate = entity.CreatedDate;
model.CreatedBy = entity.CreatedBy;
model.LastUpdateBy = user.SysNo;
model.LastUpdateDate = DateTime.Now;
IcpDao.Instance.UpdateIcpBYJiChangGoodsInfoEntity(model);
r.Status = true;
}
else
{
model.CreatedDate = DateTime.Now;
model.CreatedBy = user.SysNo;
model.LastUpdateBy = user.SysNo;
model.LastUpdateDate = DateTime.Now;
IcpDao.Instance.InsertIcpBYJiChangGoodsInfo(model);
r.Status = true;
}
return(r);
}
/// <summary>
/// 设置商品备案内部信息
/// </summary>
/// <returns></returns>
/// <remarks>2016-1-15 王耀发 创建</remarks>
List <Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.GoodsContent> SetIcpGoodsBodyData(List <CIcpGoodsItem> CIcpGoodsItemList)
{
List <Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.GoodsContent> GoodsContentList = new List <Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.GoodsContent>();
int i = 0;
foreach (CIcpGoodsItem item in CIcpGoodsItemList)
{
i++;
IcpBYJiChangGoodsInfo Entity = IcpBo.Instance.GetIcpBYJiChangGoodsInfoEntityByPid(item.ProductSysNo);
if (Entity != null)
{
GoodsContentList.Add(new Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.GoodsContent()
{
Seq = i.ToString(),
EntGoodsNo = Entity.EntGoodsNo,
EPortGoodsNo = "",
CIQGoodsNo = "",
CusGoodsNo = "",
EmsNo = "",
ItemNo = "",
ShelfGName = Entity.ShelfGName,
NcadCode = Entity.NcadCode,
PostTariffName = Entity.PostTariffName,
BarCode = (Entity.BarCode == null ? "" : Entity.BarCode),
HSCode = (Entity.HSCode == null ? "" : Entity.HSCode),
GoodsName = Entity.GoodsName,
GoodsStyle = Entity.GoodsStyle,
Brand = Entity.Brand,
GUnit = Entity.GUnit,
StdUnit = Entity.StdUnit,
//SecUnit = (Entity.SecUnit == null ? "" : Entity.SecUnit),
RegPrice = Entity.RegPrice.ToString(),
CurrCode = Entity.CurrCode,
GiftFlag = Entity.GiftFlag.ToString(),
OriginCountry = Entity.OriginCountry,
Quality = Entity.Quality,
QualityCertify = (Entity.QualityCertify == null ? "" : Entity.QualityCertify),
Manufactory = (Entity.Manufactory == null ? "" : Entity.Manufactory),
NetWt = Entity.NetWt.ToString(),
GrossWt = Entity.GrossWt.ToString(),
GNote = Entity.GNote,
ValidDate = DateTime.Now.ToString("yyyyMMddHHmmss"),
EndDate = "20651207164852",
Notes = ""
});
}
}
return(GoodsContentList);
}
/// <summary>
///
/// </summary>
/// <param name="IcpType"></param>
/// <param name="ProductSysNoList"></param>
/// <returns></returns>
/// <remarks>2016-4-1 王耀发 创建</remarks>
public override Result PushGoods(string ProductSysNoList)
{
Result result = new Result();
CIcp model = new CIcp();
model.IcpType = (int)Model.CommonEnum.商检.广州白云机场;
List <CIcpGoodsItem> CIcpGoodsItemList = new List <CIcpGoodsItem>();
string[] sArray = ProductSysNoList.Split(',');
foreach (string i in sArray)
{
int ProductSysNo = int.Parse(i);
IcpBYJiChangGoodsInfo Entity = IcpBo.Instance.GetIcpBYJiChangGoodsInfoEntityByPid(ProductSysNo);
CIcpGoodsItemList.Add(new CIcpGoodsItem()
{
IcpType = model.IcpType,
ProductSysNo = ProductSysNo,
EntGoodsNo = Entity.EntGoodsNo
});
}
Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.InternationalTrade internationaltrade = new Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.InternationalTrade();
internationaltrade.Head = new Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.Head();
internationaltrade.Declaration = new Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.Declaration();
internationaltrade.Declaration.GoodsRegHead = new Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.GoodsRegHead();
internationaltrade.Declaration.GoodsRegList = new Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.GoodsRegList();
internationaltrade.Declaration.GoodsRegList.GoodsContentList = new List <Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.GoodsContent>();
//生成最大流水号
string MaxSerialNumber = GetMaxSerialNumberByMType(model.IcpType.ToString(), config.GZJCIcpInfoTrade.GoodsMessageType);
string fileName = config.GZJCIcpInfoTrade.GoodsMessageType + "_" + config.GZJCIcpInfoTrade.Sender + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + MaxSerialNumber;
internationaltrade.Head = SetIcpGoodsHead(fileName, config.GZJCIcpInfoTrade.GoodsMessageType);
internationaltrade.Declaration.GoodsRegHead = SetIcpGoodsHeadData();
List <Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.GoodsContent> GoodsContentList = SetIcpGoodsBodyData(CIcpGoodsItemList);
if (GoodsContentList.Count != 0)
{
internationaltrade.Declaration.GoodsRegList.GoodsContentList = SetIcpGoodsBodyData(CIcpGoodsItemList);
string str = Hyt.Util.Serialization.SerializationUtil.XmlSerialize <Hyt.Model.Icp.GZBaiYunJiChang.Goods.Goods.InternationalTrade>(internationaltrade);
str = str.Replace("encoding=\"utf-16\"", "encoding=\"UTF-8\"");
FtpUtil ftp = new FtpUtil(config.GZJCIcpInfoTrade.FtpUrl, config.GZJCIcpInfoTrade.FtpName, config.GZJCIcpInfoTrade.FtpPassword);
string msg = "";
string MessageID = fileName;
fileName = fileName + ".xml";
try
{
ftp.UploadFile(config.GZJCIcpInfoTrade.FtpUrl + "in", fileName, Encoding.UTF8.GetBytes(str), out msg);
//新增商检表信息
int UserSysNo = AdminAuthenticationBo.Instance.Current.Base.SysNo;
model.SourceSysNo = 0;
model.MessageID = MessageID;
model.MessageType = config.GZJCIcpInfoTrade.GoodsMessageType;
model.SerialNumber = MaxSerialNumber;
model.XmlContent = str;
model.CreatedBy = UserSysNo;
model.CreatedDate = DateTime.Now;
model.Status = (int)IcpStatus.商品商检推送状态.已推送;
model.LastUpdateBy = UserSysNo;
model.LastUpdateDate = DateTime.Now;
model.SysNo = IcpDao.Instance.Insert(model);
if (model.SysNo > 0) //
{
if (CIcpGoodsItemList != null)
{
foreach (var item in CIcpGoodsItemList)
{
var m = new CIcpGoodsItem
{
SourceSysNo = 0,
IcpType = model.IcpType,
MessageID = MessageID,
IcpGoodsSysNo = model.SysNo,
ProductSysNo = item.ProductSysNo,
EntGoodsNo = item.EntGoodsNo,
CreatedBy = UserSysNo,
CreatedDate = DateTime.Now,
LastUpdateBy = UserSysNo,
LastUpdateDate = DateTime.Now
};
IcpDao.Instance.InsertIcpGoodsItem(m);
}
}
}
result.Status = true;
result.Message = internationaltrade.Head.MessageID;
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
}
else
{
result.Status = false;
result.Message = "商品备案信息无效";
}
return(result);
}
/// <summary> /// 更新数据 /// </summary> /// <param name="entity">数据实体</param> /// <returns></returns> /// <remarkss>2016-04-05 王耀发 更新</remarks> public abstract int UpdateIcpBYJiChangGoodsInfoEntity(IcpBYJiChangGoodsInfo entity);
/// <summary> /// 插入数据 /// </summary> /// <param name="entity">数据实体</param> /// <returns>新增记录编号</returns> /// <remarkss>2016-04-05 王耀发 创建</remarks> public abstract int InsertIcpBYJiChangGoodsInfo(IcpBYJiChangGoodsInfo entity);
