CGDD_SyncServiceModel.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using System.Xml.Linq;
  7. namespace HH.YiDaSyncNC.Models
  8. {
  9. class CGDD_SyncServiceModel
  10. {
  11. public class DataModel
  12. {
  13. public string 集团 { get; set; }
  14. public string 组织 { get; set; }
  15. public string 部门 { get; set; } = "06";
  16. public string 订单编号 { get; set; }
  17. public string 订单日期 { get; set; }
  18. public string 供应商 { get; set; }
  19. public string 订单类型 { get; set; } = "21-Cxx-02";
  20. public string 单据状态 { get; set; } = "0";
  21. public string 审批人 { get; set; }
  22. public string 审批时间 { get; set; }
  23. public string 制单人 { get; set; }
  24. public string 制单时间 { get; set; }
  25. public string 创建人 { get; set; }
  26. public string 创建时间 { get; set; }
  27. public string 换算率 { get; set; } = "1.00/1.00";
  28. public string 折扣 { get; set; } = "100";
  29. public string 数量 { get; set; }
  30. public string 价税合计 { get; set; }
  31. public string 业务流程 { get; set; } = "Cxx-CG-02";
  32. public string 币种 { get; set; } = "CNY";
  33. public List<OrderB> pk_order_b { get; set; }
  34. public class OrderB
  35. {
  36. public string 物料编码 { get; set; }
  37. public string 物料名称 { get; set; }
  38. public string 计量单位 { get; set; }
  39. public string 项目 { get; set; }
  40. public string 数量 { get; set; }
  41. public string 无税单价 { get; set; }
  42. public string 含税单价 { get; set; }
  43. public string 无税金额 { get; set; }
  44. public string 税额 { get; set; }
  45. public string 税率 { get; set; } = "13";
  46. public string 税码 { get; set; } = "CN15";
  47. public string 价税合计 { get; set; }
  48. public string 联系人 { get; set; }
  49. public string 收货地址 { get; set; }
  50. }
  51. }
  52. public class ImportXml
  53. {
  54. /// <summary>
  55. /// 模板头部份
  56. /// </summary>
  57. /// <returns></returns>
  58. public static XElement TemplateHeade()
  59. {
  60. return new XElement(new XElement("ufinterface", new object[]
  61. {
  62. new XAttribute("sender","dingding"),
  63. new XAttribute("roottag",""),
  64. new XAttribute("replace","Y"),
  65. new XAttribute("isexchange","Y"),
  66. new XAttribute("groupcode","0"),
  67. new XAttribute("filename",""),
  68. new XAttribute("billtype","21"),
  69. new XAttribute("account","develop")
  70. }));
  71. }
  72. /// <summary>
  73. /// 组建表头xml
  74. /// </summary>
  75. /// <param name="item">表头参数</param>
  76. /// <returns></returns>
  77. public static XElement Header(DataModel item, string id)
  78. {
  79. var pk_order_b = new List<XElement>();
  80. if (item.pk_order_b != null && item.pk_order_b.Count > 0)
  81. {
  82. var crowno = 10; // 行号
  83. foreach (var itemData in item.pk_order_b)
  84. {
  85. pk_order_b.Add(new XElement("item", new object[] {
  86. new XElement("pk_group",item.集团),
  87. new XElement("pk_org",item.组织),
  88. new XElement("pk_org_v",item.组织),
  89. new XElement("pk_reqcorp",item.组织),
  90. new XElement("pk_reqstoorg",item.组织),
  91. new XElement("pk_reqstoorg_v",item.组织),
  92. new XElement("pk_arrvstoorg",item.组织),
  93. new XElement("pk_arrvstoorg_v",item.组织),
  94. new XElement("pk_psfinanceorg",item.组织),
  95. new XElement("pk_psfinanceorg_v",item.组织),
  96. new XElement("pk_apfinanceorg",item.组织),
  97. new XElement("pk_apfinanceorg_v",item.组织),
  98. new XElement("crowno",crowno.ToString()),
  99. new XElement("pk_material",itemData.物料编码),
  100. new XElement("pk_srcmaterial",itemData.物料编码),
  101. new XElement("vvendinventorycode",itemData.物料编码),
  102. new XElement("vvendinventoryname",itemData.物料名称),
  103. new XElement("cunitid",itemData.计量单位),
  104. new XElement("castunitid",itemData.计量单位),
  105. new XElement("cqtunitid",itemData.计量单位),
  106. new XElement("cprojectid",itemData.项目),
  107. new XElement("dbilldate",item.订单日期),
  108. new XElement("pk_supplier",item.供应商),
  109. new XElement("dsenddate",Convert.ToDateTime(item.订单日期).AddDays(1).ToString("yyyy-MM-dd HH:mm:ss")),
  110. new XElement("nnum",itemData.数量),
  111. new XElement("nastnum",itemData.数量),
  112. new XElement("vchangerate",item.换算率),
  113. new XElement("nqtunitnum",itemData.数量),
  114. new XElement("vqtunitrate",item.换算率),
  115. new XElement("nqtorigprice",itemData.无税单价),
  116. new XElement("nqtorignetprice",itemData.无税单价),
  117. new XElement("nqtnetprice",itemData.无税单价),
  118. new XElement("norigprice",itemData.无税单价),
  119. new XElement("norignetprice",itemData.无税单价),
  120. new XElement("nnetprice",itemData.无税单价),
  121. new XElement("nqtprice",itemData.无税单价),
  122. new XElement("nprice",itemData.无税单价),
  123. new XElement("nqtorigtaxprice",itemData.含税单价),
  124. new XElement("nqtorigtaxnetprc",itemData.含税单价),
  125. new XElement("nqttaxnetprice",itemData.含税单价),
  126. new XElement("norigtaxprice",itemData.含税单价),
  127. new XElement("norigtaxnetprice",itemData.含税单价),
  128. new XElement("ntaxnetprice",itemData.含税单价),
  129. new XElement("nqttaxprice",itemData.含税单价),
  130. new XElement("ntaxprice",itemData.含税单价),
  131. new XElement("norigmny",itemData.无税金额),
  132. new XElement("nmny",itemData.无税金额),
  133. new XElement("ncaltaxmny",itemData.无税金额),
  134. new XElement("ncalcostmny",itemData.无税金额),
  135. new XElement("ntax",itemData.税额),
  136. new XElement("ntaxrate",itemData.税率),
  137. new XElement("ctaxcodeid",itemData.税码),
  138. new XElement("norigtaxmny",itemData.价税合计),
  139. new XElement("ntaxmny",itemData.价税合计),
  140. new XElement("nitemdiscountrate","100"),
  141. new XElement("breceiveplan","N"),
  142. new XElement("blargess","N"),
  143. new XElement("btransclosed","N"),
  144. new XElement("bborrowpur","N"),
  145. new XElement("bstockclose","N"),
  146. new XElement("binvoiceclose","N"),
  147. new XElement("barriveclose","N"),
  148. new XElement("bpayclose","N"),
  149. new XElement("ftaxtypeflag","1"),
  150. new XElement("vbdef3",itemData.联系人),
  151. new XElement("vbdef4",itemData.收货地址),
  152. new XElement("ccurrencyid",item.币种),
  153. new XElement("nexchangerate","1"),
  154. new XElement("corigcurrencyid",item.币种),
  155. new XElement("csendcountryid","CN"),
  156. new XElement("crececountryid","CN"),
  157. new XElement("ctaxcountryid","CN"),
  158. new XElement("fbuysellflag","2"),
  159. new XElement("btriatradeflag","N"),
  160. }));
  161. crowno = crowno + 10;
  162. }
  163. }
  164. return new XElement("bill", new object[]
  165. {
  166. "",
  167. new XAttribute("id",id),
  168. new XElement("billhead", new object[]
  169. {
  170. new XElement("pk_group",item.集团),
  171. new XElement("pk_org",item.组织),
  172. new XElement("pk_org_v",item.组织),
  173. new XElement("vbillcode",item.订单编号),
  174. new XElement("dbilldate",item.订单日期),
  175. new XElement("pk_supplier",item.供应商),
  176. new XElement("pk_invcsupllier",item.供应商),
  177. new XElement("vtrantypecode",item.订单类型),
  178. new XElement("ctrantypeid",item.订单类型),
  179. new XElement("pk_dept",item.部门),
  180. new XElement("pk_dept_v",item.部门),
  181. new XElement("approver",item.审批人),
  182. new XElement("taudittime",item.审批时间),
  183. new XElement("billmaker",item.制单人),
  184. new XElement("dmakedate",item.制单时间),
  185. new XElement("creator",item.创建人),
  186. new XElement("creationtime",item.创建时间),
  187. new XElement("forderstatus",item.单据状态),
  188. new XElement("nversion","1"),
  189. new XElement("bislatest","Y"),
  190. new XElement("vdef10",item.订单编号),
  191. new XElement("ntotalastnum",item.数量),
  192. new XElement("ntotalorigmny",item.价税合计),
  193. new XElement("pk_busitype",item.业务流程),
  194. new XElement("fhtaxtypeflag","1"),
  195. new XElement("corigcurrencyid",item.币种),
  196. new XElement("pk_order_b",pk_order_b),
  197. }),
  198. });
  199. }
  200. }
  201. }
  202. }