SaveMattressExcutor.cs 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data.SqlClient;
  4. using System.Diagnostics;
  5. using System.Linq;
  6. using System.Text;
  7. using DirectService.Tools;
  8. using JLHHJSvr.BLL;
  9. using JLHHJSvr.Com;
  10. using JLHHJSvr.Com.Model;
  11. using JLHHJSvr.Helper;
  12. using JLHHJSvr.LJException;
  13. using JLHHJSvr.Tools;
  14. using LJLib.DAL.SQL;
  15. using LJLib.Net.SPI.Server;
  16. using LJLib.SQLEX;
  17. namespace JLHHJSvr.Excutor
  18. {
  19. internal sealed class SaveMattressExcutor : ExcutorBase<SaveMattressRequest, SaveMattressResponse>
  20. {
  21. /*protected override void ExcuteInternal(SaveMattressRequest request, object state, SaveMattressResponse rslt)
  22. {
  23. var tokendata = BllHelper.GetToken(request.token);
  24. if (tokendata == null)
  25. {
  26. rslt.ErrMsg = "会话已经中断,请重新登录";
  27. return;
  28. }
  29. if (request.mattress == null)
  30. {
  31. rslt.ErrMsg = "缺少主表信息";
  32. return;
  33. }
  34. using (var con = GlobalVar.ConnectionString.NewSqlConnection())
  35. using (var cmd = con.CreateCommand())
  36. {
  37. con.Open();
  38. // 初始化属性
  39. AutoInit.AutoInitS(cmd, request.mattress);
  40. if(request.mattress.copy_id != null && request.mattress.copy_id > 0)
  41. {
  42. request.mattress.mattressid = 0;
  43. request.mattress.mattresscode = string.Empty;
  44. request.mattress.yw_flag = 0;
  45. request.mattress.yw_auditingrep = "";
  46. request.mattress.yw_auditingdate = null;
  47. request.mattress.js1_flag = 0;
  48. request.mattress.js1_auditingrep = "";
  49. request.mattress.js1_auditingdate = null;
  50. request.mattress.js2_flag = 0;
  51. request.mattress.js2_auditingrep = "";
  52. request.mattress.js2_auditingdate = null;
  53. request.mattress.xd_flag = 0;
  54. request.mattress.xd_auditingrep = "";
  55. request.mattress.xd_auditingdate = null;
  56. request.mattress.flag = 0;
  57. request.mattress.auditingrep = "";
  58. request.mattress.auditingdate = null;
  59. request.mattress.qr_auditingrep = "";
  60. request.mattress.qr_auditingdate = null;
  61. request.mattress.erp_mtrlid = 0;
  62. request.mattress.erp_mtrlcode = "";
  63. request.mattress.erp_piccode = "";
  64. request.mattress.erp_mtrlname = "";
  65. foreach (var mx in request.mattressMx)
  66. {
  67. mx.mattressid = 0;
  68. mx.mattressmxid = 0;
  69. }
  70. }
  71. else
  72. {
  73. #region 状态判断
  74. if (request.mattress.mattressid > 0) {
  75. var mattressInfo = new u_mattress() { mattressid = request.mattress.mattressid };
  76. if (DbSqlHelper.SelectOne(cmd, mattressInfo, "flag, xd_flag, yw_flag, mattresscode, parentid") == 1)
  77. {
  78. if (mattressInfo.xd_flag == 1)
  79. {
  80. rslt.ErrMsg = "床垫报价单【" + mattressInfo.mattresscode + "】已业务下单,不能修改";
  81. return;
  82. }
  83. }
  84. }
  85. if (request.subspecs != null && request.subspecs.Count > 0)
  86. {
  87. foreach (var submx in request.subspecs)
  88. {
  89. var itemid = Convert.ToInt32(submx["mattressid"]);
  90. if (itemid == 0) continue;
  91. var mattressInfo = new u_mattress() { mattressid = itemid };
  92. if (DbSqlHelper.SelectOne(cmd, mattressInfo, "flag, xd_flag, yw_flag, mattresscode, parentid") == 1)
  93. {
  94. if (mattressInfo.xd_flag == 1)
  95. {
  96. rslt.ErrMsg = "副规格-床垫报价单【" + mattressInfo.mattresscode + "】已业务下单,不能修改";
  97. return;
  98. }
  99. }
  100. }
  101. }
  102. #endregion
  103. }
  104. foreach (var mx in request.mattressMx)
  105. {
  106. AutoInit.AutoInitS(cmd, mx);
  107. }
  108. using (cmd.Transaction = con.BeginTransaction())
  109. {
  110. var helper = HelperBase.GetHelper<MattressHelper>(cmd, new HelperBase.Context() { tokendata = tokendata });
  111. var bednetHelper = HelperBase.GetHelper<BedNetHelper>(cmd, new HelperBase.Context() { tokendata = tokendata });
  112. try
  113. {
  114. rslt.mxmessage = new List<string>();
  115. rslt.mxmessage = toSaveMattress(cmd, request.mattress, request.mattressMx, request.extraProcesses, request.extraCosts, tokendata,true);
  116. rslt.mattressid = request.mattress.mattressid;
  117. rslt.mattresscode = request.mattress.mattresscode;
  118. var subspecsList = helper.GetMattressSubspecs(request.mattress.mattressid);
  119. //if (subspecsList.Count > 0)
  120. //{
  121. // foreach (var submx in subspecsList)
  122. // {
  123. // // 删除副规格特殊工艺表
  124. // cmd.CommandText = @"DELETE u_mattress_mx_extra WHERE mattressid = @mattressid";
  125. // cmd.Parameters.Clear();
  126. // cmd.Parameters.AddWithValue("@mattressid", submx.mattressid);
  127. // cmd.ExecuteNonQuery();
  128. // // 删除副规格明细
  129. // cmd.CommandText = @"DELETE u_mattress_mx_mtrl WHERE mattressid = @mattressid";
  130. // cmd.Parameters.Clear();
  131. // cmd.Parameters.AddWithValue("@mattressid", submx.mattressid);
  132. // cmd.ExecuteNonQuery();
  133. // // 删除副规格
  134. // cmd.CommandText = @"DELETE u_mattress WHERE mattressid = @mattressid";
  135. // cmd.Parameters.Clear();
  136. // cmd.Parameters.AddWithValue("@mattressid", submx.mattressid);
  137. // cmd.ExecuteNonQuery();
  138. // }
  139. //}
  140. if (request.subspecs != null && request.subspecs.Count > 0)
  141. {
  142. // 排序:宽、长,从小到大
  143. var _subspecs = request.subspecs.OrderBy(o => o["mattress_width"]).ThenBy(o => o["mattress_length"]).ToList();
  144. // 副规格
  145. foreach (var submx in _subspecs)
  146. {
  147. var _mattressid = 0;
  148. var _mattresscode = "";
  149. if (submx.Value<int>("mattressid") > 0)
  150. {
  151. _mattressid = Convert.ToInt32(submx["mattressid"]);
  152. }
  153. if (!string.IsNullOrEmpty(submx.Value<string>("mattresscode")))
  154. {
  155. _mattresscode = Convert.ToString(submx["mattresscode"]);
  156. }
  157. var _mattress = ObjectHelper.DeepCopy(request.mattress);
  158. _mattress.parentid = request.mattress.mattressid;
  159. _mattress.createby = request.mattress.createby;
  160. _mattress.mattressid = _mattressid;
  161. _mattress.mattresscode = _mattresscode;
  162. _mattress.mattress_width = Convert.ToInt32(submx["mattress_width"]);
  163. _mattress.mattress_length = Convert.ToInt32(submx["mattress_length"]);
  164. _mattress.mattress_height = Convert.ToInt32(submx["mattress_height"]);
  165. _mattress.mattressrelcode = Convert.ToString(submx["mattressrelcode"]);
  166. _mattress.mattressname = Convert.ToString(submx["mattressname"]);
  167. if (submx.Value<int>("erp_mtrlid") > 0)
  168. {
  169. _mattress.erp_mtrlid = Convert.ToInt32(submx["erp_mtrlid"]);
  170. }
  171. if (!string.IsNullOrEmpty(submx.Value<string>("erp_mtrlcode")))
  172. {
  173. _mattress.erp_mtrlcode = Convert.ToString(submx["erp_mtrlcode"]);
  174. }
  175. if (submx.Value<int>("erp_configcodetype") > 0)
  176. {
  177. _mattress.erp_configcodetype = Convert.ToInt32(submx["erp_configcodetype"]);
  178. }
  179. if (!string.IsNullOrEmpty(submx.Value<string>("erp_mtrlengname")))
  180. {
  181. _mattress.erp_mtrlengname = Convert.ToString(submx["erp_mtrlengname"]);
  182. }
  183. if (!string.IsNullOrEmpty(submx.Value<string>("erp_mtrlmode")))
  184. {
  185. _mattress.erp_mtrlmode = Convert.ToString(submx["erp_mtrlmode"]);
  186. }
  187. if (!string.IsNullOrEmpty(submx.Value<string>("erp_mtrlname")))
  188. {
  189. _mattress.erp_mtrlname = Convert.ToString(submx["erp_mtrlname"]);
  190. }
  191. if (!string.IsNullOrEmpty(submx.Value<string>("erp_mtrltype")))
  192. {
  193. _mattress.erp_mtrltype = Convert.ToString(submx["erp_mtrltype"]);
  194. }
  195. if (submx.Value<int>("erp_mtrltypeid") > 0)
  196. {
  197. _mattress.erp_mtrltypeid = Convert.ToInt32(submx["erp_mtrltypeid"]);
  198. }
  199. if (!string.IsNullOrEmpty(submx.Value<string>("erp_mtrlunit")))
  200. {
  201. _mattress.erp_mtrlunit = Convert.ToString(submx["erp_mtrlunit"]);
  202. }
  203. if (!string.IsNullOrEmpty(submx.Value<string>("erp_piccode")))
  204. {
  205. _mattress.erp_piccode = Convert.ToString(submx["erp_piccode"]);
  206. }
  207. var _mattressMx = new List<u_mattress_mx_mtrl>();
  208. if (request.mattressMx != null && request.mattressMx.Any())
  209. {
  210. var bednetIndex = 0; // 床网索引
  211. var ifSubspecsIndex = 0; // 垫层主副规格物料索引
  212. foreach (var itemMx in request.mattressMx)
  213. {
  214. var item = ObjectHelper.DeepCopy(itemMx);
  215. item.mattressid = _mattress.mattressid;
  216. item.mattressmxid = 0;
  217. item.message = "";
  218. #region 副规格床网自动匹配/新增逻辑
  219. if (item.formulatype == 99 && item.mtrlid > 0)
  220. {
  221. bednetIndex++;
  222. var oBednet = new u_bednet();
  223. var _bednet = bednetHelper.GetBedNet(item.mtrlid.Value);
  224. var _bednetMx = bednetHelper.GetBedNetMxList(item.mtrlid.Value);
  225. var _bednetSpring = bednetHelper.GetBedNetSpringList(item.mtrlid.Value);
  226. //_bednet.mattress_width = Convert.ToInt32(submx["mattress_width"]) - (request.mattress.mattress_width - _bednet.mattress_width);
  227. //_bednet.mattress_length = Convert.ToInt32(submx["mattress_length"]) - (request.mattress.mattress_length - _bednet.mattress_length);
  228. _bednet.mattress_width = Convert.ToInt32(submx["mattress_width"]);
  229. _bednet.mattress_length = Convert.ToInt32(submx["mattress_length"]);
  230. var _spring_qty_width = Convert.ToInt32(submx["spring_qty_width_" + bednetIndex]);
  231. var _spring_qty_length = Convert.ToInt32(submx["spring_qty_length_" + bednetIndex]);
  232. var _bednet_fork_qty = _bednet.fork_qty;
  233. if (!string.IsNullOrEmpty(submx.Value<string>("bednet_fork_qty_" + bednetIndex)))
  234. {
  235. _bednet_fork_qty = Convert.ToInt32(submx["bednet_fork_qty_" + bednetIndex]);
  236. }
  237. //if (_bednetMx.Count > 0)
  238. //{
  239. // cmd.CommandText = @"SELECT TOP 1 u_bednet.bednetid
  240. // ,u_bednet_type.typename
  241. // ,bednetcode
  242. // ,mattress_width
  243. // ,mattress_length
  244. // ,mattress_height
  245. // ,nottax_factory_cost
  246. // FROM u_bednetmx
  247. // INNER JOIN u_bednet on u_bednet.bednetid = u_bednetmx.bednetid
  248. // INNER JOIN u_bednet_type on u_bednet_type.bednettypeid = u_bednet.bednettypeid
  249. // WHERE u_bednet.bednettypeid = @bednettypeid
  250. // AND u_bednet.mattress_width = @mattress_width
  251. // AND u_bednet.mattress_length = @mattress_length
  252. // AND u_bednet.if_doublenet = @if_doublenet
  253. // AND u_bednet.if_doublespring = @if_doublespring
  254. // AND u_bednet.snake_wire_diameter = @snake_wire_diameter
  255. // AND u_bednet.if_rsorwa = @if_rsorwa
  256. // AND u_bednet.if_sponge_drilling = @if_sponge_drilling
  257. // AND u_bednet.ifsaleout = 0
  258. // AND u_bednet.sponge_mtrlid = @sponge_mtrlid
  259. // AND u_bednet.sponge_thickness = @sponge_thickness
  260. // AND u_bednet.sponge_height = @sponge_height
  261. // AND u_bednet.sponge_tc_mtrlid = @sponge_tc_mtrlid
  262. // AND u_bednet.sponge_tc_thickness = @sponge_tc_thickness
  263. // AND u_bednet.sponge_tc_height = @sponge_tc_height
  264. // AND u_bednet.edge_mtrlid = @edge_mtrlid
  265. // AND u_bednet.edge_height = @edge_height
  266. // AND u_bednet.felt_mtrlid = @felt_mtrlid
  267. // AND u_bednet.felt_qty = @felt_qty
  268. // AND u_bednet.felt_x_mtrlid = @felt_x_mtrlid
  269. // AND u_bednet.felt_x_qty = @felt_x_qty
  270. // AND u_bednet.fork_qty = @fork_qty
  271. // AND u_bednet.felt_dscrp = @felt_dscrp
  272. // AND u_bednet.duo_qv_str = @duo_qv_str
  273. // AND u_bednetmx.bednet_height = @bednet_height
  274. // AND u_bednetmx.springid = @springid
  275. // AND u_bednetmx.spring_qty_width = @spring_qty_width
  276. // AND u_bednetmx.spring_qty_length = @spring_qty_length
  277. // AND u_bednetmx.if_side_iron = @if_side_iron
  278. // AND u_bednetmx.side_iron_qty = @side_iron_qty
  279. // AND u_bednetmx.fabrics2_mtrlid = @fabrics2_mtrlid
  280. // AND u_bednetmx.fabrics1_mtrlid = @fabrics1_mtrlid
  281. // AND u_bednetmx.if_hard_around = @if_hard_around
  282. // AND u_bednetmx.hard_around_springid = @hard_around_springid
  283. // AND u_bednetmx.hard_around_row = @hard_around_row
  284. // AND u_bednetmx.if_15strip = @if_15strip
  285. // ";
  286. // cmd.Parameters.Clear();
  287. // cmd.Parameters.AddWithValue("@bednettypeid", _bednet.bednettypeid);
  288. // cmd.Parameters.AddWithValue("@mattress_width", _bednet.mattress_width);
  289. // cmd.Parameters.AddWithValue("@mattress_length", _bednet.mattress_length);
  290. // cmd.Parameters.AddWithValue("@if_doublenet", _bednet.if_doublenet);
  291. // cmd.Parameters.AddWithValue("@if_doublespring", _bednet.if_doublespring);
  292. // cmd.Parameters.AddWithValue("@snake_wire_diameter", _bednet.snake_wire_diameter);
  293. // cmd.Parameters.AddWithValue("@if_rsorwa", _bednet.if_rsorwa);
  294. // cmd.Parameters.AddWithValue("@if_sponge_drilling", _bednet.if_sponge_drilling);
  295. // cmd.Parameters.AddWithValue("@sponge_mtrlid", _bednet.sponge_mtrlid);
  296. // cmd.Parameters.AddWithValue("@sponge_thickness", _bednet.sponge_thickness);
  297. // cmd.Parameters.AddWithValue("@sponge_height", _bednet.sponge_height);
  298. // cmd.Parameters.AddWithValue("@sponge_tc_mtrlid", _bednet.sponge_tc_mtrlid);
  299. // cmd.Parameters.AddWithValue("@sponge_tc_thickness", _bednet.sponge_tc_thickness);
  300. // cmd.Parameters.AddWithValue("@sponge_tc_height", _bednet.sponge_tc_height);
  301. // cmd.Parameters.AddWithValue("@edge_mtrlid", _bednet.edge_mtrlid);
  302. // cmd.Parameters.AddWithValue("@edge_height", _bednet.edge_height);
  303. // cmd.Parameters.AddWithValue("@felt_mtrlid", _bednet.felt_mtrlid);
  304. // cmd.Parameters.AddWithValue("@felt_qty", _bednet.felt_qty);
  305. // cmd.Parameters.AddWithValue("@felt_x_mtrlid", _bednet.felt_x_mtrlid);
  306. // cmd.Parameters.AddWithValue("@felt_x_qty", _bednet.felt_x_qty);
  307. // cmd.Parameters.AddWithValue("@felt_dscrp", _bednet.felt_dscrp);
  308. // cmd.Parameters.AddWithValue("@duo_qv_str", _bednet.duo_qv_str);
  309. // cmd.Parameters.AddWithValue("@fork_qty", _bednet.iffork == 1 ? _bednet_fork_qty : 0);
  310. // cmd.Parameters.AddWithValue("@bednet_height", _bednetMx[0].bednet_height);
  311. // cmd.Parameters.AddWithValue("@springid", _bednetMx[0].springid);
  312. // cmd.Parameters.AddWithValue("@spring_qty_width", _spring_qty_width);
  313. // cmd.Parameters.AddWithValue("@spring_qty_length", _spring_qty_length);
  314. // cmd.Parameters.AddWithValue("@if_side_iron", _bednetMx[0].if_side_iron);
  315. // cmd.Parameters.AddWithValue("@side_iron_qty", _bednetMx[0].side_iron_qty);
  316. // cmd.Parameters.AddWithValue("@fabrics2_mtrlid", _bednetMx[0].fabrics2_mtrlid);
  317. // cmd.Parameters.AddWithValue("@fabrics1_mtrlid", _bednetMx[0].fabrics1_mtrlid);
  318. // cmd.Parameters.AddWithValue("@if_hard_around", _bednetMx[0].if_hard_around);
  319. // cmd.Parameters.AddWithValue("@hard_around_springid", _bednetMx[0].hard_around_springid);
  320. // cmd.Parameters.AddWithValue("@hard_around_row", _bednetMx[0].hard_around_row);
  321. // cmd.Parameters.AddWithValue("@if_15strip", _bednetMx[0].if_15strip);
  322. // using (var reader = cmd.ExecuteReader())
  323. // {
  324. // if (reader.Read())
  325. // {
  326. // oBednet = new u_bednet() {
  327. // bednetid = Convert.ToInt32(reader["bednetid"]),
  328. // typename = Convert.ToString(reader["typename"]),
  329. // bednetcode = Convert.ToString(reader["bednetcode"]),
  330. // mattress_width = Convert.ToInt32(reader["mattress_width"]),
  331. // mattress_length = Convert.ToInt32(reader["mattress_length"]),
  332. // mattress_height = Convert.ToInt32(reader["mattress_height"]),
  333. // nottax_factory_cost = Convert.ToDecimal(reader["nottax_factory_cost"])
  334. // };
  335. // }
  336. // }
  337. // if (_bednetSpring.Count>0)
  338. // {
  339. // }
  340. //}
  341. // 匹配失败,自动新建
  342. //if (oBednet.bednetid == null)
  343. //{
  344. /// 20250714 副规格的床网,不匹配查找,直接新建
  345. oBednet = _bednet;
  346. _bednetMx[0].spring_qty_width = _spring_qty_width;
  347. _bednetMx[0].spring_qty_length = _spring_qty_length;
  348. oBednet.fork_qty = _bednet_fork_qty;
  349. oBednet.bednetid = 0;
  350. // 袋装网,多个分区时,重新分配弹簧
  351. bednetHelper.GetSpringListQty(oBednet, _bednetMx[0], ref _bednetSpring);
  352. bednetHelper.SaveBedNet(oBednet, _bednetMx, _bednetSpring);
  353. //}
  354. var _mtrlname = oBednet.typename +
  355. " " +
  356. oBednet.bednetcode +
  357. " " +
  358. oBednet.mattress_width +
  359. "*" +
  360. oBednet.mattress_length +
  361. "*" +
  362. oBednet.mattress_height;
  363. item.mtrlid = oBednet.bednetid;
  364. item.mtrlname = _mtrlname;
  365. item.price = oBednet.nottax_factory_cost;
  366. item.qty = 1;
  367. }
  368. #endregion
  369. #region 垫层改动逻辑
  370. if (item.formulatype == 1 && item.mtrlid > 0 )
  371. {
  372. // 规格长/宽,按比例缩放
  373. if (item.mattress_width > 0)
  374. {
  375. item.mattress_width = (int)Math.Floor((decimal)item.mattress_width * (Convert.ToDecimal(submx["mattress_width"]) / (decimal)request.mattress.mattress_width));
  376. }
  377. if (item.mattress_length > 0)
  378. {
  379. item.mattress_length = (int)Math.Floor((decimal)item.mattress_length * (Convert.ToDecimal(submx["mattress_length"]) / (decimal)request.mattress.mattress_length));
  380. }
  381. // 副规格-垫层物料替换
  382. if (item.if_subspecs == 1)
  383. {
  384. ifSubspecsIndex++;
  385. item.mtrlid = Convert.ToInt32(submx["cushions_subspecs_" + ifSubspecsIndex]);
  386. }
  387. }
  388. #endregion
  389. _mattressMx.Add(item);
  390. }
  391. #region FEAT:内布套/顶部裥棉逻辑
  392. var butaoList = _mattressMx.Where(t => (t.formulatype == 101 || t.formulatype == 102 || t.formulatype == 103) && t.mtrlid > 0 && (t.mattress_width > 0 || t.mattress_length > 0));
  393. foreach(var itemMx in butaoList)
  394. {
  395. itemMx.mattress_width += _mattress.mattress_width - request.mattress.mattress_width;
  396. itemMx.mattress_length += _mattress.mattress_length - request.mattress.mattress_length;
  397. }
  398. #endregion
  399. }
  400. toSaveMattress(cmd, _mattress, _mattressMx, request.extraProcesses, request.extraCosts, tokendata,false);
  401. }
  402. }
  403. cmd.Transaction.Commit();
  404. }
  405. catch (Exception e)
  406. {
  407. cmd.Transaction.Rollback();
  408. rslt.ErrMsg = e.ToString();
  409. Trace.Write(e);
  410. }
  411. }
  412. }
  413. }*/
  414. /*public List<string> toSaveMattress(SqlCommand cmd, u_mattress mattress, List<u_mattress_mx_mtrl> mattressMx, List<u_mattress_mx_extra> extraProcesses, List<u_mattress_mx_extra> extraCosts, TokenData tokendata,bool iferpmtrl)
  415. {
  416. var helper = HelperBase.GetHelper<MattressHelper>(cmd, new HelperBase.Context() { tokendata = tokendata });
  417. List<string> message = new List<string>();
  418. helper.MattressCalculateCost(mattress, mattressMx, extraProcesses, extraCosts);
  419. var mxmessageList = mattressMx.Where(item => !string.IsNullOrEmpty(item.message)).ToList();
  420. if (mxmessageList.Any())
  421. {
  422. foreach (var mx in mxmessageList)
  423. {
  424. message.Add(mx.message);
  425. }
  426. }
  427. try
  428. {
  429. helper.SaveMattress(mattress, mattressMx, extraProcesses, extraCosts, iferpmtrl);
  430. if (mattress.copy_id != null && mattress.copy_id > 0)
  431. {
  432. helper.CopyMattressInterface(mattress.copy_id.Value,mattress.mattressid);
  433. }
  434. }
  435. catch (Exception e)
  436. {
  437. throw new LJCommonException(e.Message);
  438. }
  439. return message;
  440. }*/
  441. protected override void ExcuteInternal(SaveMattressRequest request, object state, SaveMattressResponse rslt)
  442. {
  443. var tokendata = BllHelper.GetToken(request.token);
  444. if (tokendata == null)
  445. {
  446. rslt.ErrMsg = "会话已经中断,请重新登录";
  447. return;
  448. }
  449. if (request.mattress == null)
  450. {
  451. rslt.ErrMsg = "缺少主表信息";
  452. return;
  453. }
  454. using (var con = GlobalVar.ConnectionString.NewSqlConnection())
  455. using (var cmd = con.CreateCommand())
  456. {
  457. con.Open();
  458. var mattressHelper = HelperBase.GetHelper<MattressHelper>(cmd, new HelperBase.Context() { tokendata = tokendata });
  459. var bednetHelper = HelperBase.GetHelper<BedNetHelper>(cmd, new HelperBase.Context() { tokendata = tokendata });
  460. var subspecsList = new List<u_mattress>();
  461. // 状态判断
  462. if (request.mattress.copy_id != null && request.mattress.copy_id > 0)
  463. {
  464. }
  465. else
  466. {
  467. var mattressInfo = new u_mattress() { mattressid = request.mattress.mattressid };
  468. if (DbSqlHelper.SelectOne(cmd, mattressInfo, "flag, xd_flag, yw_flag, mattresscode, parentid") == 1)
  469. {
  470. if (mattressInfo.xd_flag == 1)
  471. {
  472. rslt.ErrMsg = "床垫报价单【" + mattressInfo.mattresscode + "】已业务下单,不能修改";
  473. return;
  474. }
  475. }
  476. // 副规格
  477. if (mattressInfo.parentid != null && mattressInfo.parentid > 0)
  478. {
  479. subspecsList = mattressHelper.GetMattressSubspecs(mattressInfo.parentid.Value, "flag, xd_flag, yw_flag, mattresscode, parentid,mattressid,mattress_width,mattress_length,mattress_height,mattressname,mattressrelcode");
  480. foreach(var submx in subspecsList)
  481. {
  482. if (submx.xd_flag == 1)
  483. {
  484. rslt.ErrMsg = "副规格-床垫报价单【" + submx.mattresscode + "】已业务下单,不能修改";
  485. return;
  486. }
  487. }
  488. }
  489. }
  490. var _mattress = ObjectHelper.DeepCopy(request.mattress);
  491. _mattress.mxList = request.mattressMx;
  492. _mattress.extraList = request.extraProcesses;
  493. _mattress.extraCostList = request.extraCosts;
  494. _mattress.subspecsList = request.subspecsList;
  495. // 初始化属性
  496. AutoInit.AutoInitS(cmd, _mattress);
  497. foreach (var mx in _mattress.mxList)
  498. {
  499. AutoInit.AutoInitS(cmd, mx);
  500. }
  501. #region TODO:需要优化
  502. List<string> message = new List<string>();
  503. mattressHelper.MattressCalculateCost(_mattress, _mattress.mxList, _mattress.extraList, _mattress.extraCostList);
  504. var mxmessageList = _mattress.mxList.Where(item => !string.IsNullOrEmpty(item.message)).ToList();
  505. if (mxmessageList.Any())
  506. {
  507. foreach (var mx in mxmessageList)
  508. {
  509. message.Add(mx.message);
  510. }
  511. }
  512. rslt.mxmessage = message;
  513. #endregion
  514. #region 复制报价初始化
  515. if(_mattress.copy_id != null && _mattress.copy_id > 0)
  516. {
  517. _mattress.mattressid = 0;
  518. _mattress.mattresscode = string.Empty;
  519. _mattress.yw_flag = 0;
  520. _mattress.yw_auditingrep = "";
  521. _mattress.yw_auditingdate = null;
  522. _mattress.js1_flag = 0;
  523. _mattress.js1_auditingrep = "";
  524. _mattress.js1_auditingdate = null;
  525. _mattress.js2_flag = 0;
  526. _mattress.js2_auditingrep = "";
  527. _mattress.js2_auditingdate = null;
  528. _mattress.xd_flag = 0;
  529. _mattress.xd_auditingrep = "";
  530. _mattress.xd_auditingdate = null;
  531. _mattress.flag = 0;
  532. _mattress.auditingrep = "";
  533. _mattress.auditingdate = null;
  534. _mattress.qr_auditingrep = "";
  535. _mattress.qr_auditingdate = null;
  536. _mattress.erp_mtrlid = 0;
  537. _mattress.erp_mtrlcode = "";
  538. _mattress.erp_piccode = "";
  539. _mattress.erp_mtrlname = "";
  540. foreach (var mx in _mattress.mxList)
  541. {
  542. mx.mattressid = 0;
  543. mx.mattressmxid = 0;
  544. }
  545. foreach(var mx in _mattress.extraList)
  546. {
  547. mx.mattressid = 0;
  548. mx.mattressmxid = 0;
  549. }
  550. foreach (var mx in _mattress.extraCostList)
  551. {
  552. mx.mattressid = 0;
  553. mx.mattressmxid = 0;
  554. }
  555. foreach(var mx in _mattress.subspecsList)
  556. {
  557. mx.mattressid = 0;
  558. mx.mattresscode = string.Empty;
  559. }
  560. }
  561. #endregion
  562. using (cmd.Transaction = con.BeginTransaction())
  563. {
  564. try
  565. {
  566. mattressHelper.SaveMattressPro(_mattress, true);
  567. rslt.mattressid = _mattress.mattressid;
  568. rslt.mattresscode = _mattress.mattresscode;
  569. if (_mattress.copy_id != null && _mattress.copy_id > 0)
  570. {
  571. mattressHelper.CopyMattressInterface(_mattress.copy_id.Value, _mattress.mattressid);
  572. }
  573. cmd.Transaction.Commit();
  574. }
  575. catch (Exception e)
  576. {
  577. rslt.ErrMsg = e.ToString();
  578. Trace.Write(e);
  579. cmd.Transaction?.Rollback();
  580. }
  581. }
  582. }
  583. }
  584. }
  585. }