MattressHelper.cs 142 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220
  1. using CSUST.Data.Expr;
  2. using DirectService.Tools;
  3. using JLHHJSvr.BLL;
  4. using JLHHJSvr.Com.Model;
  5. using JLHHJSvr.LJException;
  6. using JLHHJSvr.LJFramework.Tools;
  7. using JLHHJSvr.Tools;
  8. using LJLib.DAL.SQL;
  9. using System;
  10. using System.Collections.Generic;
  11. using System.Data.SqlClient;
  12. using System.Linq;
  13. using System.Text;
  14. using System.Text.RegularExpressions;
  15. using System.Threading.Tasks;
  16. namespace JLHHJSvr.Helper
  17. {
  18. class MattressHelper : HelperBase
  19. {
  20. private Dictionary<string, object> replacements = new Dictionary<string, object>();
  21. /// <summary>
  22. /// 默认展示公式
  23. /// </summary>
  24. private Dictionary<string, string> formula_replacements = new Dictionary<string, string>();
  25. /// <summary>
  26. /// 隐藏公式
  27. /// </summary>
  28. private Dictionary<string, string> formula_replacements_hide = new Dictionary<string, string>();
  29. /// <summary>
  30. /// 床网参数替换
  31. /// </summary>
  32. public List<replacement_bednet> BendetReplace = new List<replacement_bednet>();
  33. public List<replacement> BendetFormulasReplace = new List<replacement>();
  34. public List<replacement> Replacements
  35. {
  36. get
  37. {
  38. var res = new List<replacement>();
  39. foreach (var item in replacements)
  40. {
  41. res.Add(new replacement { label = item.Key, value = item.Value, type = 0 });
  42. }
  43. return res;
  44. }
  45. }
  46. public List<replacement> FormulaReplacements
  47. {
  48. get
  49. {
  50. var res = new List<replacement>();
  51. foreach (var item in formula_replacements)
  52. {
  53. res.Add(new replacement { label = item.Key, value = item.Value, type = 0 });
  54. }
  55. string[] keys = { "车间成本", "总床垫车间成本", "不含税出厂价", "部门不含税价", "税金", "部门含税价", "外币价", "底价", "佣金" };
  56. res = res.OrderBy(r => Array.IndexOf(keys, r.label.Replace("【", "").Replace("】", ""))).ToList();
  57. foreach (var item in formula_replacements_hide)
  58. {
  59. res.Add(new replacement { label = item.Key, value = item.Value, type = 1 });
  60. }
  61. return res;
  62. }
  63. }
  64. /// <summary>
  65. /// 公式计算
  66. /// </summary>
  67. /// <param name="mattress"></param>
  68. /// <param name="mxlist"></param>
  69. /// <param name="isCalBed">是否实时计算</param>
  70. /// <param name="isNewFormula">是否获取新的公式计算</param>
  71. /// <param name="extraProcesses">特殊工艺</param>
  72. /// <param name="extraCosts">额外费用</param>
  73. public void CalCulateFormula(u_mattress mattress, List<u_mattress_mx_mtrl> mxlist, Boolean isCalBed = true, Boolean isNewFormula = true, List<u_mattress_mx_extra> extraProcesses = null, List<u_mattress_mx_extra> extraCosts = null)
  74. {
  75. BendetReplace = new List<replacement_bednet>();
  76. BendetFormulasReplace = new List<replacement>();
  77. InitMattress(mattress);
  78. InitReplaceMents(mattress, isNewFormula, extraProcesses, extraCosts);
  79. if (isCalBed || isNewFormula) CalCulateBedNet(mxlist, isCalBed, isNewFormula, mattress.deptid.Value);
  80. // 实时计算价格
  81. if (isCalBed)
  82. {
  83. InitMattressMx(mattress, mxlist);
  84. //CalCulateBedNet(mxlist);
  85. var diancengList = mxlist.Where(t => t.formulatype == 1).ToList();
  86. var mattersstype = new u_mattress_type() { mattresstypeid = mattress.mattresstypeid };
  87. DbSqlHelper.SelectOne(cmd, mattersstype, "formula_big_side,formula_small_side,formula_v_side");
  88. var thicknessDict = InitMxThicknessReplaceMents(mxlist);
  89. foreach (var mx in mxlist)
  90. {
  91. if (mx.mtrlid == 0 && mx.formulakind != 31) continue;
  92. if (string.IsNullOrEmpty(mx.formula) && string.IsNullOrEmpty(mx.useformula)) continue;
  93. InitMxReplaceMents(mx);
  94. // 顶替分组关键值:內布套、顶布裥棉
  95. if (thicknessDict.ContainsKey(mx.chastr))
  96. {
  97. foreach(var rp in thicknessDict[mx.chastr])
  98. {
  99. AddKeyValue(rp.Key, rp.Value);
  100. }
  101. }
  102. string expression = ConvertToEnglishSymbols(mx.formula), use_expression = ConvertToEnglishSymbols(mx.useformula);
  103. expression = InitMxSideReplaceMents(mattress, mx, diancengList, mattersstype, expression);
  104. use_expression = InitMxSideReplaceMents(mattress, mx, diancengList, mattersstype,use_expression);
  105. #region 替换布料幅宽
  106. //大侧
  107. if (new List<int>() { 2,42,52,62,72,82 }.Contains(mx.formulakind.Value))
  108. {
  109. InitMxClothWidthReplaceMents(mx, mxlist,2);
  110. }
  111. //小侧
  112. if (new List<int>() { 3, 43, 53, 63, 73, 83 }.Contains(mx.formulakind.Value))
  113. {
  114. InitMxClothWidthReplaceMents(mx, mxlist,3);
  115. }
  116. //大侧
  117. if (new List<int>() { 4, 44, 54, 64, 74, 84 }.Contains(mx.formulakind.Value))
  118. {
  119. InitMxClothWidthReplaceMents(mx, mxlist,4);
  120. }
  121. //面裥绵
  122. if (new List<int>() { 0, 40, 50, 60, 70, 80, 203 }.Contains(mx.formulakind.Value))
  123. {
  124. InitMxClothWidthReplaceMents(mx, mxlist,0);
  125. }
  126. //底裥绵
  127. if (new List<int>() { 1, 41, 51, 61, 71, 81 }.Contains(mx.formulakind.Value))
  128. {
  129. InitMxClothWidthReplaceMents(mx, mxlist,1);
  130. }
  131. #endregion
  132. #region 替换布套高
  133. //if(new List<int>() { 101 }.Contains(mx.formulakind.Value))
  134. //{
  135. // if (mx.mattress_width != null && mx.mattress_width > 0) expression = expression.Replace("【规格宽】", $"{mx.mattress_width}");
  136. // if (mx.mattress_length != null && mx.mattress_length > 0) expression = expression.Replace("【规格长】", $"{mx.mattress_length}");
  137. //}
  138. //内布套
  139. if (new List<int>() { 101,102,103,104,105,106 }.Contains(mx.formulakind.Value))
  140. {
  141. expression = InitMxClothHeightReplaceMents(mattress, mx, expression, mxlist, 101);
  142. use_expression = InitMxClothHeightReplaceMents(mattress, mx, use_expression, mxlist, 101);
  143. }
  144. //外布套
  145. if (new List<int>() { 111, 112, 113, 114, 115, 116 }.Contains(mx.formulakind.Value))
  146. {
  147. expression = InitMxClothHeightReplaceMents(mattress, mx, expression, mxlist, 111);
  148. use_expression = InitMxClothHeightReplaceMents(mattress, mx, use_expression, mxlist, 111);
  149. }
  150. #endregion
  151. #region 裥绵收缩率
  152. InitMxShrinkageReplaceMents(mx,mxlist);
  153. #endregion
  154. foreach (var replacement in replacements)
  155. {
  156. expression = expression.Replace(replacement.Key, Convert.ToString(replacement.Value));
  157. use_expression = use_expression.Replace(replacement.Key, Convert.ToString(replacement.Value));
  158. }
  159. #region 计算成本金额
  160. // 判断expression前两个字符是否为@@
  161. bool sqlCal = !string.IsNullOrEmpty(expression) && expression.Length > 2 && expression.Substring(0, 2) == "@@";
  162. expression = expression.Replace("@@", "");
  163. mx.replace_formula = expression;
  164. try
  165. {
  166. if (sqlCal)
  167. {
  168. mx.costamt = Convert.ToDecimal(SqlCalculate(expression, "成本金额"));
  169. }
  170. else
  171. {
  172. mx.costamt = Calculate(expression, "成本金额").DecimalValue;
  173. }
  174. }
  175. catch (Exception e)
  176. {
  177. mx.if_success = 1;
  178. mx.message = e.Message;
  179. }
  180. #endregion
  181. #region 计算清单用量
  182. sqlCal = !string.IsNullOrEmpty(use_expression) && use_expression.Length > 2 &&use_expression.Substring(0, 2) == "@@";
  183. use_expression = use_expression.Replace("@@", "");
  184. mx.replace_useformula = use_expression;
  185. try
  186. {
  187. if (sqlCal)
  188. {
  189. mx.useqty = Convert.ToDecimal(SqlCalculate(use_expression, "清单用量"));
  190. }
  191. else
  192. {
  193. mx.useqty = Calculate(use_expression, "清单用量").DecimalValue;
  194. }
  195. }
  196. catch (Exception e)
  197. {
  198. mx.if_success = 1;
  199. mx.message = e.Message;
  200. }
  201. #endregion
  202. }
  203. }
  204. InitMattressMxListReplaceMents(mattress, mxlist, isNewFormula);
  205. string[] keys = { "车间成本", "不含税出厂价", "部门不含税价", "税金", "部门含税价", "外币价", "底价", "佣金" };
  206. if (formula_replacements_hide.Count > 0)
  207. {
  208. foreach (var replacement in formula_replacements_hide)
  209. {
  210. var _key = replacement.Key.Replace("【", "").Replace("】", "");
  211. var value = CalculateVarFormula(_key).DecimalValue;
  212. AddKeyValue(_key, value);
  213. }
  214. foreach (var replacement in formula_replacements)
  215. {
  216. var _key = replacement.Key.Replace("【", "").Replace("】", "");
  217. if (!keys.Contains(_key) )
  218. {
  219. var value = CalculateVarFormula(_key).DecimalValue;
  220. AddKeyValue(_key, value);
  221. }
  222. }
  223. }
  224. }
  225. /// <summary>
  226. /// 记录明细按分组读取厚度变量
  227. /// </summary>
  228. /// <param name="mxlist"></param>
  229. private Dictionary<string, Dictionary<string, object>> InitMxThicknessReplaceMents(List<u_mattress_mx_mtrl> mxlist)
  230. {
  231. // 明细按分组读取厚度变量
  232. var thicknessDict = new Dictionary<string, Dictionary<string, object>> () { };
  233. foreach (var mx in mxlist)
  234. {
  235. // 只处理 内布套(101,102)、顶布裥棉(103)
  236. if (!new List<int>() { 101, 102, 103 }.Contains(mx.formulatype.Value)) continue;
  237. if (mx.chastr.Contains("顶布裥棉") || mx.chastr.Contains("内布套"))
  238. {
  239. if(!thicknessDict.ContainsKey(mx.chastr))
  240. {
  241. thicknessDict.Add(mx.chastr, new Dictionary<string, object>() {});
  242. }
  243. var mxDict = thicknessDict[mx.chastr];
  244. setMxThicknessValue(mx, ref mxDict);
  245. thicknessDict[mx.chastr] = mxDict;
  246. }
  247. }
  248. return thicknessDict;
  249. }
  250. private void setMxThicknessValue(u_mattress_mx_mtrl mx, ref Dictionary<string, object> mxDict)
  251. {
  252. var keyStr = "";
  253. if (new List<int>() { 101, 102 }.Contains(mx.formulatype.Value))
  254. {
  255. switch (mx.formulakind.Value)
  256. {
  257. case 0: // 面裥绵-布料
  258. keyStr = "内布套上覆";
  259. break;
  260. case 1: // 底裥绵-布料
  261. keyStr = "内布套下覆";
  262. break;
  263. case 2: // 大侧裥绵-布料
  264. keyStr = "内布套侧覆";
  265. break;
  266. }
  267. if (!string.IsNullOrEmpty(keyStr))
  268. {
  269. mxDict.Add(keyStr, mx.thickness);
  270. }
  271. }
  272. else if (new List<int>() { 103 }.Contains(mx.formulatype.Value))
  273. {
  274. switch (mx.formulakind.Value)
  275. {
  276. case 50: // 面裥绵-裥绵海绵
  277. keyStr = "物料厚度";
  278. break;
  279. }
  280. if (!string.IsNullOrEmpty(keyStr))
  281. {
  282. mxDict.Add(keyStr, mx.thickness.Value);
  283. }
  284. }
  285. }
  286. private void CalCulateBedNet(List<u_mattress_mx_mtrl> mxlist, Boolean isCalBed = true, Boolean isNewFormula = true, int deptid = 0)
  287. {
  288. var bedNetHelper = HelperBase.GetHelper<BedNetHelper>(cmd, new HelperBase.Context() { tokendata = context.tokendata });
  289. var bednetList = mxlist.Where(t => t.formulatype == 99);
  290. decimal dannumRate = 0;
  291. int dannumType = 0;
  292. //if (replacements.TryGetValue("【大小单系数】", out object value2))
  293. //{
  294. // dannumRate = Convert.ToDecimal(value2);
  295. //}
  296. if (replacements.TryGetValue("【大小单类型】", out object value1))
  297. {
  298. dannumType = Convert.ToInt32(value1);
  299. }
  300. List<replacement_bednet> rpBednet = new List<replacement_bednet>();
  301. var bednetSumList = new List<decimal?>();
  302. var index = 0;
  303. foreach (var mx in bednetList)
  304. {
  305. if (mx.mtrlid <= 0) continue;
  306. var bednet = bedNetHelper.GetBedNet(mx.mtrlid.Value);
  307. if (bednet.flag == 1) continue;
  308. if (deptid > 0)
  309. {
  310. bednet.deptid = deptid;
  311. }
  312. var bednetMxlist = bedNetHelper.GetBedNetMxList(bednet.bednetid.Value);
  313. var bednetSpringList = bedNetHelper.GetBedNetSpringList(bednet.bednetid.Value);
  314. //bednet.dannum_rate = dannumRate;
  315. bednet.dannum_type = dannumType;
  316. bedNetHelper.CalCulateFormula(bednet, bednetMxlist, bednetSpringList, true, true);
  317. var rpBednetItem = new replacement_bednet()
  318. {
  319. label = mx.mtrlname,
  320. replace = bedNetHelper.Replacements
  321. };
  322. BendetFormulasReplace = bedNetHelper.FormulaReplacements.Where(itm => new List<int>{ 0, 1 }.Contains(itm.type.Value)).ToList();
  323. rpBednet.Add(rpBednetItem);
  324. //if (isCalBed)
  325. //{
  326. // bedNetHelper.SaveBedNet(bednet, bednetMxlist, bednetSpringList);
  327. //}
  328. if (isNewFormula)
  329. {
  330. mx.price = bednet.total_cost;
  331. AddKeyValue("床网车间成本" + (index + 1), bednet.total_cost);
  332. bednetSumList.Add(bednet.total_cost);
  333. }
  334. else
  335. {
  336. mx.price = bednet.nottax_factory_cost;
  337. }
  338. }
  339. BendetReplace = rpBednet;
  340. #region 总床网车间成本
  341. AddKeyValue("总床网车间成本", bednetSumList.Sum());
  342. #endregion
  343. }
  344. private void InitMattress(u_mattress mattress)
  345. {
  346. var dept = new u_dept() { deptid = mattress.deptid.Value };
  347. DbSqlHelper.SelectOne(cmd, dept, "pricelistid,profitrate,moneyrate,discount");
  348. //var profirate = new u_factory_profitrate() { deptid = mattress.deptid, bednettypeid_mattresstypeid = mattress.mattresstypeid, bednet_or_mattress = 1 };
  349. //DbSqlHelper.SelectOne(cmd, profirate, "profitrate");
  350. decimal profitrate = 0;
  351. cmd.CommandText = @"SELECT profitrate FROM u_factory_profitrate
  352. WHERE deptid = @deptid
  353. AND bednettypeid_mattresstypeid = @bednettypeid_mattresstypeid
  354. AND bednet_or_mattress = 1";
  355. cmd.Parameters.Clear();
  356. cmd.Parameters.AddWithValue("@deptid", mattress.deptid);
  357. cmd.Parameters.AddWithValue("@bednettypeid_mattresstypeid", mattress.mattresstypeid);
  358. using (var reader = cmd.ExecuteReader())
  359. {
  360. if (reader.Read())
  361. {
  362. profitrate = Convert.ToDecimal(reader["profitrate"]);
  363. }
  364. }
  365. mattress.pricelistid = dept.pricelistid;
  366. mattress.dept_profitrate = dept.profitrate;
  367. mattress.profitrate = profitrate;
  368. mattress.moneyrate = mattress.if_moneyrate == 1 ? dept.moneyrate ?? 1 : 1;
  369. mattress.discount = dept.discount ?? 1 ;
  370. mattress.commission = mattress.commission ?? 1;
  371. mattress.taxrate = mattress.taxrate ?? 1;
  372. mattress.other_rate = mattress.other_rate ?? 1;
  373. mattress.dept_profitrate = mattress.dept_profitrate ?? 0;
  374. // 检查佣金是否小于1
  375. if (mattress.commission < 1)
  376. {
  377. throw new LJCommonException("佣金点数不能小于1!");
  378. }
  379. // 检查税率是否小于1
  380. if (mattress.taxrate < 1)
  381. {
  382. throw new LJCommonException("税率不能小于1!");
  383. }
  384. // 检查额外点数是否小于1
  385. if (mattress.other_rate < 1)
  386. {
  387. throw new LJCommonException("税率不能小于1!");
  388. }
  389. // 检查部门利润率是否为0
  390. if (mattress.dept_profitrate == 0)
  391. {
  392. throw new LJCommonException("部门利润率不能为0!");
  393. }
  394. }
  395. private void InitMattressMx(u_mattress mattress,List<u_mattress_mx_mtrl> mxlist)
  396. {
  397. foreach (var mx in mxlist)
  398. {
  399. if (!new List<int>() { 0, 1, 2, 3, 104 }.Contains(mx.formulatype.Value)) continue;
  400. // 垫层 wf_check_dianceng_ifright
  401. if (mx.formulatype.Value == 1)
  402. {
  403. cmd.CommandText = @"SELECT TOP 1 formulaid From u_mattress_formula where formulakind = @ll_formulakind";
  404. cmd.Parameters.Clear();
  405. cmd.Parameters.AddWithValue("@ll_formulakind", mx.formulakind);
  406. using (var reader = cmd.ExecuteReader())
  407. {
  408. if (reader.Read())
  409. {
  410. mx.formulaid = Convert.ToInt32(reader["formulaid"]);
  411. }
  412. else
  413. {
  414. mx.formulaid = 0;
  415. }
  416. }
  417. }
  418. var formula = new u_mattress_formula() { formulaid = mx.formulaid, };
  419. DbSqlHelper.SelectOne(cmd, formula, "formulakind,formulatype,sortcode");
  420. var mtrldef = new u_mtrl_price() { mtrlid = mx.mtrlid };
  421. DbSqlHelper.SelectOne(cmd, mtrldef, "name,gram_weight,cloth_width,if_inputqty,priceunit,shrinkage,if_areaprice");
  422. mx.costamt = 0;
  423. mx.useqty = 0;
  424. mx.if_success = 0;
  425. mx.replace_formula = "";
  426. mx.replace_useformula = "";
  427. mx.formulakind = formula.formulakind;
  428. mx.formulatype = formula.formulatype;
  429. //mx.sortcode = formula.sortcode.Trim();
  430. mx.mtrlname = mtrldef.name ?? "";
  431. var formula2 = new u_mattress_formula();
  432. DbSqlHelper.SelectOne(cmd, "u_mattress_formula","formulakind = @formulakind",
  433. new Dictionary<string, object>() { { "@formulakind",mx.formulakind } },formula2, "formula,useformula,gydscrp");
  434. mx.formula = formula2.formula;
  435. mx.useformula = formula2.useformula;
  436. mx.gydscrp = formula2.gydscrp;
  437. cmd.CommandText = @"SELECT isnull(u_mtrl_price_pricelist.price, 0) AS pricelistprice
  438. ,u_mtrl_price.gram_weight
  439. ,u_mtrl_price.cloth_width
  440. ,u_mtrl_price.if_inputqty
  441. ,u_mtrl_price.priceunit
  442. ,u_mtrl_price.shrinkage
  443. ,isnull(u_mtrl_price_pricelist.price_formula, 0) AS price_formula
  444. ,isnull(u_mtrl_price_pricelist.qty_formula, 0) AS qty_formula
  445. ,u_mtrl_price.if_areaprice
  446. ,u_mtrl_price.thickness
  447. FROM u_mtrl_price
  448. INNER JOIN u_mtrl_price_pricelist ON u_mtrl_price.mtrlid = u_mtrl_price_pricelist.mtrlid
  449. WHERE (u_mtrl_price.mtrlid = @mtrlid)
  450. AND (u_mtrl_price_pricelist.pricelistid = @pricelistid)";
  451. cmd.Parameters.Clear();
  452. cmd.Parameters.AddWithValue("@mtrlid", mx.mtrlid);
  453. cmd.Parameters.AddWithValue("@pricelistid", mattress.pricelistid);
  454. using(var reader = cmd.ExecuteReader())
  455. {
  456. if (reader.Read())
  457. {
  458. mx.price = Convert.ToDecimal(reader["pricelistprice"]);
  459. mx.gram_weight = Convert.ToDecimal(reader["gram_weight"]);
  460. mx.cloth_width = Convert.ToDecimal(reader["cloth_width"]);
  461. mx.if_inputqty = Convert.ToInt32(reader["if_inputqty"]);
  462. mx.priceunit = reader["priceunit"].ToString();
  463. mx.shrinkage = Convert.ToDecimal(reader["shrinkage"]);
  464. mx.if_areaprice = Convert.ToByte(reader["if_areaprice"]);
  465. if(mx.if_inputqty == 1) mx.thickness = Convert.ToDecimal(reader["thickness"]);
  466. string price_formula = Convert.ToString(reader["price_formula"]);
  467. string qty_formula = Convert.ToString(reader["qty_formula"]);
  468. mx.formula = string.IsNullOrEmpty(price_formula) ? mx.formula : price_formula;
  469. mx.useformula = string.IsNullOrEmpty(qty_formula) ? mx.useformula : qty_formula;
  470. }
  471. }
  472. }
  473. }
  474. /// <summary>
  475. /// 其他额外费用tab / 特殊工艺计算
  476. /// </summary>
  477. /// <param name="mattress"></param>
  478. /// <param name="typeid"></param> 1: 特殊工艺。2:其他额外费用
  479. /// <returns></returns>
  480. private decimal GetExtraAmt(u_mattress mattress, int typeid)
  481. {
  482. decimal amt = 0;
  483. cmd.CommandText = @"
  484. SELECT ISNULL(SUM(u_mattress_mx_extra.price * u_mattress_mx_extra.qty), 0) AS amt
  485. From u_mattress_mx_extra
  486. INNER JOIN u_mattress_extra_type On u_mattress_extra_type.extraid = u_mattress_mx_extra.extraid
  487. WHERE u_mattress_extra_type.typeid = @typeid
  488. AND u_mattress_mx_extra.mattressid = @mattressid";
  489. cmd.Parameters.Clear();
  490. cmd.Parameters.AddWithValue("@typeid", typeid);
  491. cmd.Parameters.AddWithValue("@mattressid", mattress.mattressid);
  492. using (var reader = cmd.ExecuteReader())
  493. {
  494. if (reader.Read())
  495. {
  496. amt = Convert.ToDecimal(reader["amt"]);
  497. }
  498. }
  499. return amt;
  500. }
  501. private void InitReplaceMents(u_mattress mattress, Boolean isNewFormula = true, List<u_mattress_mx_extra> extraProcesses = null, List<u_mattress_mx_extra> extraCosts = null)
  502. {
  503. replacements.Clear();
  504. decimal cost = 0;
  505. if (extraCosts != null && extraCosts.Count > 0)
  506. {
  507. foreach(var itemCost in extraCosts)
  508. {
  509. cost += itemCost.price.Value * itemCost.qty.Value;
  510. }
  511. }
  512. else
  513. {
  514. cost = GetExtraAmt(mattress, 2);
  515. }
  516. AddKeyValue("材料额外费用", cost);
  517. decimal cost1 = 0;
  518. if (extraProcesses != null && extraProcesses.Count > 0)
  519. {
  520. foreach (var itemPro in extraProcesses)
  521. {
  522. cost1 += itemPro.price.Value * itemPro.qty.Value;
  523. }
  524. }
  525. else
  526. {
  527. cost1 = GetExtraAmt(mattress, 1);
  528. }
  529. AddKeyValue("特殊工艺费用", cost1);
  530. AddKeyValue("规格宽", mattress.mattress_width);
  531. AddKeyValue("规格长", mattress.mattress_length);
  532. AddKeyValue("规格高", mattress.mattress_height);
  533. AddKeyValue("压包数量", mattress.packqty);
  534. AddKeyValue("卷包直径", mattress.diameter);
  535. AddKeyValue("顶布裥棉外布套做法", mattress.if_db_wbutao_way);
  536. AddKeyValue("面料外布套做法", mattress.if_m_wbutao_way);
  537. AddKeyValue("内布套上覆", mattress.s_cover_qty);
  538. AddKeyValue("内布套侧覆", mattress.z_cover_qty);
  539. AddKeyValue("内布套下覆", mattress.x_cover_qty);
  540. AddKeyValue("面料上覆", mattress.s_m_cover_qty);
  541. AddKeyValue("面料侧覆", mattress.z_m_cover_qty);
  542. AddKeyValue("面料下覆", mattress.x_m_cover_qty);
  543. AddKeyValue("面拆", mattress.if_m_chai);
  544. AddKeyValue("中拆", mattress.if_z_chai);
  545. AddKeyValue("底拆", mattress.if_d_chai);
  546. AddKeyValue("工厂利润率", mattress.profitrate);
  547. AddKeyValue("部门利润率", mattress.dept_profitrate);
  548. AddKeyValue("部门让利点数", mattress.dept_profitrate_rangli);
  549. AddKeyValue("佣金点数", mattress.commission);
  550. AddKeyValue("额外点数", mattress.other_rate);
  551. AddKeyValue("额外费用", mattress.extras_cost);
  552. AddKeyValue("汇率", mattress.moneyrate);
  553. AddKeyValue("税率", mattress.taxrate);
  554. AddKeyValue("折扣率", mattress.discount);
  555. // 地区FOB费用,如果存在变量表,会替代
  556. AddKeyValue("大柜-普通地区-地区FOB费用", 6500);
  557. AddKeyValue("大柜-特定地区-地区FOB费用", 8500);
  558. AddKeyValue("小柜-普通地区-地区FOB费用", 6000);
  559. AddKeyValue("小柜-特定地区-地区FOB费用", 7000);
  560. // 柜型立方数
  561. AddKeyValue("大柜-柜型立方数", 64);
  562. AddKeyValue("小柜-柜型立方数", 28);
  563. // 柜型米数
  564. AddKeyValue("大柜-柜型米数", 12);
  565. AddKeyValue("小柜-柜型米数", 5.9);
  566. AddKeyValue("柜型", mattress.cabinet_type);
  567. //AddFormulaHideKeyValue("【总材料成本】", "【弹簧材料总成本】+【蛇线材料成本】+【四周口袋弹簧成本】+【四周口袋无纺布成本】+【四周加硬材料成本】+【胶水材料成本】+【入袋无纺布材料成本】+【底面无纺布材料成本】+【边铁材料成本】+【C钉/夹码材料成本】+【海绵包边材料成本】+【填充海绵成本】+【封边材料成本】+【弹叉材料成本】+【胶条/包角材料成本】+【上垫层物料成本】+【下垫层物料成本】+【包装总成本】");
  568. if (mattress.woodpallettype == 0)
  569. {
  570. AddKeyValue("木托方式", "'普通木托'");
  571. }else if (mattress.woodpallettype == 1)
  572. {
  573. AddKeyValue("木托方式", " '夹板木托'");
  574. }else if (mattress.woodpallettype == 2)
  575. {
  576. AddKeyValue("木托方式", "'铁管木托' ");
  577. }
  578. // 公式
  579. AddFormulaKeyValue("车间成本", "【材料成本】*【大小单】+【人工费用】+【边带费用】+【额外费用】+【制造费用】");
  580. AddFormulaKeyValue("不含税出厂价", "【车间成本】*(【工厂利润率】+【工艺点数】+【内布套点数】+【拆装点数】+【海绵扣点】)*【管理费点】");
  581. AddFormulaKeyValue("部门不含税价", "【不含税出厂价】/(【部门利润率】+【部门让利点数】/100)/(1-(【佣金点数】-1))*【额外点数】+【FOB】");
  582. AddFormulaKeyValue("税金", "【部门不含税价】*(【税率】-1)+【佣金】 * 0.05");
  583. AddFormulaKeyValue("部门含税价", "(【部门不含税价】+【佣金】 * 0.06)*【税率】*【折扣率】");
  584. AddFormulaKeyValue("外币价", "【部门含税价】/【汇率】");
  585. AddFormulaKeyValue("底价", "if((【部门利润率】+【部门让利点数】/100)<> 0,【不含税出厂价】/(【部门利润率】+【部门让利点数】/ 100),0)");
  586. AddFormulaKeyValue("佣金", "【底价】/(1-(【佣金点数】-1))-【底价】");
  587. var dept = new u_dept() { deptid = mattress.deptid.Value };
  588. DbSqlHelper.SelectOne(cmd, dept, "pricelistid,taxes_rate");
  589. AddKeyValue("税金补偿", dept.taxes_rate);
  590. var bednetVarList = new List<u_bednet_var>();
  591. var selectStr = @"SELECT u_bednet_varmx.varid AS varid
  592. ,varkind
  593. ,varcode
  594. ,varname
  595. ,varclass
  596. ,vartype
  597. ,varunit
  598. ,u_bednet_varmx.varvalue AS varvalue
  599. ,formula
  600. FROM u_bednet_var
  601. INNER JOIN u_bednet_varmx ON u_bednet_varmx.varid = u_bednet_var.varid
  602. INNER JOIN u_dept ON u_dept.pricelistid = u_bednet_varmx.pricelistid";
  603. var whereList = new List<string>();
  604. whereList.Add("u_bednet_var.varclass < 2");
  605. whereList.Add("u_bednet_var.varkind = @varkind");
  606. whereList.Add("u_dept.deptid = @deptid");
  607. var param = new Dictionary<string, object>();
  608. param.Add("@varkind", 1);
  609. param.Add("@deptid", mattress.deptid);
  610. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), param, "varid", "varid,varkind,varcode,varname,varclass,vartype,varunit,varvalue", 0, 0, bednetVarList);
  611. foreach (var netvar in bednetVarList)
  612. {
  613. AddKeyValue(netvar.varname, netvar.varvalue);
  614. }
  615. if (isNewFormula)
  616. {
  617. selectStr = @"SELECT varid
  618. ,varkind
  619. ,varcode
  620. ,varname
  621. ,varclass
  622. ,vartype
  623. ,varunit
  624. ,formula
  625. FROM u_bednet_var";
  626. bednetVarList = new List<u_bednet_var>();
  627. whereList = new List<string>();
  628. whereList.Add("u_bednet_var.varkind = @varkind");
  629. whereList.Add("u_bednet_var.varclass = @varclass");
  630. param = new Dictionary<string, object>();
  631. param.Add("@varkind", 1);
  632. param.Add("@varclass", 2);
  633. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), param, "varid", "varid,varkind,varcode,varname,varclass,vartype,varunit,formula", 0, 0, bednetVarList);
  634. string[] keys = { "车间成本", "不含税出厂价", "部门不含税价", "税金", "部门含税价", "外币价", "底价", "佣金", "总床垫车间成本" };
  635. // 添加替换公式变量
  636. foreach (var netvar in bednetVarList)
  637. {
  638. if (keys.Contains(netvar.varname))
  639. {
  640. AddFormulaKeyValue(netvar.varname, netvar.formula);
  641. }
  642. else
  643. {
  644. AddFormulaHideKeyValue(netvar.varname, netvar.formula);
  645. }
  646. }
  647. }
  648. if (isNewFormula) GetDannumRate(mattress);
  649. }
  650. private void InitMxReplaceMents(u_mattress_mx_mtrl mx)
  651. {
  652. mx.mtrlname = !string.IsNullOrEmpty(mx.mtrlname) ? mx.mtrlname.Trim() : "null";
  653. decimal _shrinkage = mx.shrinkage.Value == 0 ? (decimal)1 : mx.shrinkage.Value;
  654. //取mtrldef.name的前两位
  655. AddKeyValue("名称前2位", mx.mtrlname.Length > 2 ? mx.mtrlname.Substring(0, 2) : mx.mtrlname);
  656. AddKeyValue("物料单价", mx.price);
  657. AddKeyValue("物料克重", mx.gram_weight);
  658. AddKeyValue("幅宽", mx.cloth_width);
  659. AddKeyValue("数量", mx.qty);
  660. AddKeyValue("物料厚度", mx.if_inputqty);
  661. AddKeyValue("固定厚度", mx.if_inputqty);
  662. AddKeyValue("厚度", mx.thickness);
  663. AddKeyValue("按面积单价", mx.if_areaprice);
  664. AddKeyValue("物料名称", mx.mtrlname);
  665. if (_shrinkage > 0) AddKeyValue("物料收缩率", _shrinkage);
  666. }
  667. /// <summary>
  668. /// 添加大侧,小侧,V侧高度公式替换
  669. /// </summary>
  670. /// <param name="mx"></param>
  671. /// <param name="diancengList"></param>
  672. /// <param name="mattersstype"></param>
  673. /// <param name="expression"></param>
  674. /// <returns></returns>
  675. private string InitMxSideReplaceMents(u_mattress mattress, u_mattress_mx_mtrl mx,List<u_mattress_mx_mtrl> diancengList, u_mattress_type mattersstype, string expression)
  676. {
  677. // 获取垫层的数据
  678. decimal bigSum = 0, smallSum = 0, vSum = 0;
  679. string bigChaStr = "大侧";
  680. string smallChaStr = mx.chastr ?? "小侧1";
  681. string vChaStr = mx.chastr ?? "V侧1";
  682. foreach (var dianceng in diancengList)
  683. {
  684. if (dianceng.chastr.IndexOf(bigChaStr) > -1) bigSum += dianceng.qty.Value * dianceng.thickness.Value;
  685. if (dianceng.chastr.IndexOf(smallChaStr) > -1) smallSum += dianceng.qty.Value * dianceng.thickness.Value;
  686. if (dianceng.chastr.IndexOf(vChaStr) > -1) vSum += dianceng.qty.Value * dianceng.thickness.Value;
  687. }
  688. if (bigSum > 0)
  689. {
  690. AddKeyValue("垫层", bigSum);
  691. }
  692. if (smallSum > 0)
  693. {
  694. AddKeyValue("垫层", smallSum);
  695. }
  696. if (vSum > 0)
  697. {
  698. AddKeyValue("垫层", vSum);
  699. }
  700. #region 替换大侧高度
  701. if (expression.IndexOf("【大侧高度】") > -1)
  702. {
  703. if (!string.IsNullOrEmpty(mattersstype.formula_big_side)) expression = expression.Replace("【大侧高度】", $"({mattersstype.formula_big_side})");
  704. expression = expression.Replace("【位置】", $"'{bigChaStr}'");
  705. if (bigSum > 0) expression = expression.Replace("【大侧高度】", $"{bigSum}");
  706. }
  707. #endregion
  708. #region 替换小侧高度
  709. if (expression.IndexOf("【小侧高度】") > -1)
  710. {
  711. if (!string.IsNullOrEmpty(mattersstype.formula_small_side)) expression = expression.Replace("【小侧高度】", $"({mattersstype.formula_small_side})");
  712. expression = expression.Replace("【位置】", $"'{smallChaStr}'");
  713. expression = expression.Replace("【小侧高度】", $"{smallSum}");
  714. }
  715. #endregion
  716. #region 替换V侧高度
  717. if (expression.IndexOf("【V侧高度】") > -1)
  718. {
  719. if(!string.IsNullOrEmpty(mattersstype.formula_v_side)) expression = expression.Replace("【V侧高度】", $"({mattersstype.formula_v_side})");
  720. expression = expression.Replace("【位置】", $"'{vChaStr}'");
  721. expression = expression.Replace("【V侧高度】", $"18");
  722. }
  723. #endregion
  724. #region 若填写则顶替床垫尺寸
  725. if (mx.mattress_width != null && mx.mattress_width > 0) expression = expression.Replace("【规格宽】", $"{mx.mattress_width}");
  726. if (mx.mattress_length != null && mx.mattress_length > 0) expression = expression.Replace("【规格长】", $"{mx.mattress_length}");
  727. #endregion
  728. return expression;
  729. }
  730. /// <summary>
  731. /// 添加布料幅宽公式替换
  732. /// </summary>
  733. /// <param name="mx"></param>
  734. /// <param name="mxlist"></param>
  735. /// <param name="formulakind"></param>
  736. private void InitMxClothWidthReplaceMents(u_mattress_mx_mtrl mx, List<u_mattress_mx_mtrl> mxlist,int formulakind)
  737. {
  738. decimal cloth_width = 0;
  739. if (string.IsNullOrEmpty(mx.chastr))
  740. {
  741. cloth_width = mxlist.First(t => t.formulakind.Value == formulakind).cloth_width.Value;
  742. }
  743. else
  744. {
  745. cloth_width = mxlist.First(t => t.formulakind.Value == formulakind && t.chastr.Equals(mx.chastr)).cloth_width.Value;
  746. }
  747. AddKeyValue("布料幅宽", cloth_width);
  748. }
  749. /// <summary>
  750. /// 添加布套高公式替换
  751. /// </summary>
  752. /// <param name="mxlist"></param>
  753. /// <param name="formulakind"></param>
  754. private string InitMxClothHeightReplaceMents(u_mattress mattress, u_mattress_mx_mtrl mx, string expression, List<u_mattress_mx_mtrl> mxlist, int formulakind)
  755. {
  756. decimal cloth_height = 0;
  757. cloth_height = mxlist.First(t => t.formulakind.Value == formulakind).thickness.Value;
  758. AddKeyValue("布套高", cloth_height);
  759. //if (mx.mattress_width != null && mx.mattress_width > 0) expression = expression.Replace("【规格宽】", $"{mx.mattress_width}");
  760. //if (mx.mattress_length != null && mx.mattress_length > 0) expression = expression.Replace("【规格长】", $"{mx.mattress_length}");
  761. return expression;
  762. }
  763. /// <summary>
  764. /// 添加裥绵收缩率公式替换
  765. /// </summary>
  766. /// <param name="mx"></param>
  767. /// <param name="mxlist"></param>
  768. private void InitMxShrinkageReplaceMents(u_mattress_mx_mtrl mx, List<u_mattress_mx_mtrl> mxlist)
  769. {
  770. decimal thickness = 0, shrinkage = 0;
  771. int[][] formulaKinds = new int[][]
  772. {
  773. new int [] {50, 0, 40, 60, 70, 80},
  774. new int [] {51, 1, 41, 61, 71, 81},
  775. new int [] {52, 2, 42, 62, 72, 82},
  776. new int [] {53, 3, 43, 63, 73, 83},
  777. new int [] {54, 4, 44, 64, 74, 84},
  778. };
  779. foreach (int[] kindGroup in formulaKinds)
  780. {
  781. if (kindGroup.Contains(mx.formulakind.Value))
  782. {
  783. var _mxList = mxlist.Where(o => o.formulatype == mx.formulatype).ToList(); //在同一个tab中计算
  784. foreach (var row in _mxList) // mxList.Rows等价于arg_dw.RowCount()
  785. {
  786. if (row.formulakind.Value == kindGroup[0])
  787. {
  788. thickness += row.thickness.Value * row.qty.Value; // 简化计算
  789. }
  790. }
  791. }
  792. }
  793. if(thickness >= 0)
  794. {
  795. cmd.CommandText = @"SELECT TOP 1 shrinkage
  796. FROM u_shrinkage
  797. WHERE u_shrinkage.minvalue <= @thickness
  798. AND u_shrinkage.maxvalue >= @thickness";
  799. cmd.Parameters.Clear();
  800. cmd.Parameters.AddWithValue("@thickness", thickness);
  801. using(var reader = cmd.ExecuteReader())
  802. {
  803. if (reader.Read())
  804. {
  805. shrinkage = Convert.ToDecimal(reader["shrinkage"]);
  806. }
  807. }
  808. }
  809. if(shrinkage > 0)
  810. {
  811. AddKeyValue("收缩率", shrinkage);
  812. }
  813. }
  814. /// <summary>
  815. /// 添加主表与明细表相关公式替换
  816. /// </summary>
  817. /// <param name="mattress"></param>
  818. /// <param name="mxlist"></param>
  819. /// <param name="isNewFormula">是否获取新的公式计算</param>
  820. private void InitMattressMxListReplaceMents(u_mattress mattress,List<u_mattress_mx_mtrl> mxlist, Boolean isNewFormula = true)
  821. {
  822. string fob_expression = string.Empty,cubage_expression = string.Empty;
  823. cubage_expression = "(【规格长】*【规格宽】* 【规格高】)/100000";
  824. #region 判断装柜方式 是否进箱
  825. if (mattress.packtype == 0)
  826. {
  827. mattress.loading_type = "平压";
  828. fob_expression = "【地区FOB费用】/(【柜型米数】 /(【规格宽】/ 100 +0.1)*(【压包数量】*2))";
  829. //if (mattress.packqty == 0) throw new LJCommonException("请填写压包数量!");
  830. }
  831. else if (mattress.packtype == 1)
  832. {
  833. mattress.loading_type = "卷包(非进箱)";
  834. fob_expression = "【地区FOB费用】 /(【柜型立方数】 /( 3.14*( 【卷包直径】 /100/2+0.03)*( 【卷包直径】 /100/2+0.03)*(【规格宽】/ 100 +0.05)))";
  835. cubage_expression = "( 3.14*( 【卷包直径】 /100/2+0.03)*( 【卷包直径】 /100/2+0.03)*(【规格宽】/ 100 +0.05))";
  836. //if (mattress.diameter == 0) throw new LJCommonException("请填写卷包直径!");
  837. var _bzList = mxlist.Where(t => t.formulatype == 3 && t.formulakind == 19).ToList();
  838. foreach(var bz in _bzList)
  839. {
  840. if (bz.mtrlname.IndexOf("箱") > -1) {
  841. mattress.loading_type = "卷包(进箱)";
  842. fob_expression = "【地区FOB费用】/(【柜型立方数】 / (( 【纸箱宽】 /100+0.03)*(【纸箱宽】/100+0.03)*(【规格宽】/ 100 +0.1)))";
  843. cubage_expression = "( 【纸箱宽】 /100+0.03)*(【纸箱宽】/100+0.03)*(【规格宽】/ 100 +0.1)";
  844. AddKeyValue("纸箱宽", bz.mtrlname.Length > 2 ? bz.mtrlname.Substring(0, 2) : bz.mtrlname);
  845. break;
  846. }
  847. }
  848. }
  849. else if (mattress.packtype == 2)
  850. {
  851. mattress.loading_type = "国内";
  852. fob_expression = "【地区FOB费用】/(【柜型立方数】/((【规格宽】/100+0.03)*(【规格长】/100+0.03)*(【规格高】/100+0.03)))";
  853. }
  854. #endregion
  855. #region 计算FOB
  856. if (!string.IsNullOrEmpty(mattress.area) && !string.IsNullOrEmpty(mattress.cabinet_type) && !string.IsNullOrEmpty(mattress.loading_type))
  857. {
  858. //地区FOB费用
  859. if (new List<string>() { "大柜", "小柜" }.Contains(mattress.cabinet_type) && new List<string>() { "普通地区", "特定地区" }.Contains(mattress.area))
  860. {
  861. fob_expression = fob_expression.Replace("【地区FOB费用】", $"【{mattress.cabinet_type.Trim()}-{mattress.area.Trim()}-地区FOB费用】");
  862. }
  863. //柜型立方数
  864. if (new List<string>() { "大柜", "小柜" }.Contains(mattress.cabinet_type))
  865. {
  866. fob_expression = fob_expression.Replace("【柜型立方数】", $"【{mattress.cabinet_type.Trim()}-柜型立方数】");
  867. }
  868. //纸箱宽 见上面
  869. //柜型米数
  870. if (new List<string>() { "大柜", "小柜" }.Contains(mattress.cabinet_type))
  871. {
  872. fob_expression = fob_expression.Replace("【柜型米数】", $"【{mattress.cabinet_type.Trim()}-柜型米数】");
  873. }
  874. mattress.fob_replace_formula = fob_expression;
  875. mattress.fob = Calculate(fob_expression, "FOB").DecimalValue;
  876. //半成品:如果PE袋物料是含 半成品专用 的编码,FOB需要除以数量
  877. var bzList2 = mxlist.Where(t => t.formulatype == 3).ToList();
  878. foreach (var bz in bzList2)
  879. {
  880. if (bz.qty.Value > 0 && bz.mtrlname.IndexOf("半成品专用") > -1)
  881. {
  882. mattress.fob /= bz.qty.Value;
  883. mattress.fob_replace_formula = $"{mattress.fob_replace_formula} / {bz.qty.Value}";
  884. }
  885. }
  886. }
  887. else {
  888. mattress.fob = 0;
  889. }
  890. AddKeyValue("FOB", mattress.fob);
  891. #endregion
  892. #region 计算体积
  893. if (mattress.fob > 0)
  894. {
  895. mattress.cubage = Calculate(cubage_expression, "体积").DecimalValue;
  896. }
  897. #endregion
  898. #region 计算人工费用
  899. var mattersstype = new u_mattress_type() { mattresstypeid = mattress.mattresstypeid };
  900. DbSqlHelper.SelectOne(cmd, mattersstype, "hrcost_formula,biandaiqty,zhizao_amt,guanli_rate,typerate,dannum1_rate,dannum2_rate,dannum3_rate,dannum4_rate");
  901. if(mattress.biandai_qty == 0 && mattress.if_m_chai == 0 && mattress.if_z_chai == 0 && mattress.if_d_chai == 0)
  902. {
  903. mattress.biandai_qty = mattersstype.biandaiqty;
  904. }
  905. mattress.hrcost_replace_formula = mattersstype.hrcost_formula;
  906. mattress.zhizao_amt = mattersstype.zhizao_amt;
  907. mattress.guanli_rate = mattersstype.guanli_rate;
  908. var diancengList = mxlist.Where(t => t.formulatype == 1).ToList();
  909. int diancengCount = 0;
  910. foreach(var dianceng in diancengList)
  911. {
  912. if (dianceng.formulakind == 32) diancengCount++;
  913. }
  914. AddKeyValue("垫层数量", diancengCount);
  915. AddKeyValue("制造费用", mattress.zhizao_amt);
  916. AddKeyValue("管理费点", mattress.guanli_rate);
  917. mattress.hrcost = Calculate(mattress.hrcost_replace_formula, "人工费用").DecimalValue;
  918. AddKeyValue("人工费用", mattress.hrcost);
  919. #endregion
  920. #region 计算边带费用
  921. if (!isNewFormula || !formula_replacements.ContainsKey("【边带费用】"))
  922. {
  923. mattress.biandaicost_replace_formula = "【边带条数】*【边带单价】*((【规格宽】+【规格长】)*2+30)/100";
  924. }
  925. else
  926. {
  927. mattress.biandaicost_replace_formula = formula_replacements["【边带费用】"];
  928. }
  929. AddKeyValue("边带条数", mattress.biandai_qty);
  930. mattress.biandaicost = Calculate(mattress.biandaicost_replace_formula, "边带费用").DecimalValue;
  931. AddKeyValue("边带费用", mattress.biandaicost);
  932. #endregion
  933. #region 辅料 有打钮纽扣 加0.13 工厂利润率
  934. var fuliaoList = mxlist.Where(t => t.formulatype == 2 && t.mtrlname.IndexOf("打钮") > -1).ToList();
  935. if (fuliaoList.Any()) mattress.profitrate += 0.13M;
  936. #endregion
  937. #region 拼侧 最大金额的侧 和 工厂利润率加点
  938. CalCulatePince(mattress, mxlist, isNewFormula);
  939. #endregion
  940. #region 内布套特殊加点
  941. CalCulateNetBuTao(mattress, mxlist);
  942. #endregion
  943. #region 拆装特殊加点
  944. CalCulateChaiZhuang(mattress);
  945. #endregion
  946. #region 海绵款特殊扣点
  947. CalCulateHaiMian(mattress);
  948. #endregion
  949. #region 计算主表 材料成本
  950. var aa = new List<decimal>();
  951. mxlist.ForEach(t => {
  952. var _costamt = t.costamt.Value;
  953. if (isNewFormula)
  954. {
  955. decimal _dannum_rate = 0;
  956. #region 计算损耗率
  957. switch (mattress.dannum_type.Value)
  958. {
  959. case 1:
  960. if (t.dannum1_rate != null) _dannum_rate = t.dannum1_rate.Value;
  961. break;
  962. case 2:
  963. if (t.dannum2_rate != null) _dannum_rate = t.dannum2_rate.Value;
  964. break;
  965. case 3:
  966. if (t.dannum3_rate != null) _dannum_rate = t.dannum3_rate.Value;
  967. break;
  968. case 4:
  969. if (t.dannum4_rate != null) _dannum_rate = t.dannum4_rate.Value;
  970. break;
  971. }
  972. _costamt = _costamt * (1 + _dannum_rate);
  973. #endregion
  974. // 新公式排除床网计算
  975. if (t.formulatype != 99) aa.Add(_costamt);
  976. }
  977. else
  978. {
  979. aa.Add(_costamt);
  980. }
  981. });
  982. mattress.total_material_cost = aa.Sum();
  983. AddKeyValue("材料成本", mattress.total_material_cost);
  984. #endregion
  985. //#region 标准金额
  986. //if (!isNewFormula)
  987. //{
  988. // // 旧公式
  989. // CalCulateCostNew(mattress, "标准");
  990. // // 查找点数
  991. // decimal _rate = GetWorkmanshipRate(mattress, "num_10", "标准");
  992. // _rate = _rate == 0 ? 1 : _rate;
  993. // mattress.foreign_cost_bz = mattress.dept_cost / _rate;
  994. //}
  995. //else
  996. //{
  997. // CalCulateCostNew(mattress, "标准", mattersstype);
  998. // mattress.foreign_cost_bz = mattress.dept_cost;
  999. //}
  1000. //AddKeyValue("标准金额", mattress.foreign_cost_bz);
  1001. //#endregion
  1002. //#region 大单金额
  1003. //if (!isNewFormula)
  1004. //{
  1005. // // 旧公式
  1006. // CalCulateCostNew(mattress, "大单");
  1007. // // 查找点数
  1008. // decimal _rate2 = GetWorkmanshipRate(mattress, "num_11", "大单");
  1009. // _rate2 = _rate2 == 0 ? 1 : _rate2;
  1010. // mattress.foreign_cost_dd = mattress.dept_cost / _rate2;
  1011. //}
  1012. //else
  1013. //{
  1014. // CalCulateCostNew(mattress, "大单", mattersstype);
  1015. // mattress.foreign_cost_dd = mattress.dept_cost;
  1016. //}
  1017. //AddKeyValue("大单金额", mattress.foreign_cost_dd);
  1018. //#endregion
  1019. if (!isNewFormula)
  1020. {
  1021. // 旧公式
  1022. CalCulateCostNew(mattress, "散单");
  1023. }
  1024. else
  1025. {
  1026. CalCulateCostNew(mattress, "散单", isNewFormula);
  1027. }
  1028. AddKeyValue("散单金额", mattress.foreign_cost);
  1029. }
  1030. /// <summary>
  1031. /// 计算拼侧最大金额的侧和工厂利润率加点
  1032. /// </summary>
  1033. /// <param name="mattress"></param>
  1034. /// <param name="mxlist"></param>
  1035. private void CalCulatePince(u_mattress mattress, List<u_mattress_mx_mtrl> mxlist, Boolean isNewFormula = true)
  1036. {
  1037. var mianliaoList = mxlist.Where(t => t.formulatype == 0).ToList();
  1038. var costAmounts = new Dictionary<string, decimal>
  1039. {
  1040. { "普通大侧", 0m },
  1041. { "上下拼侧1", 0m },
  1042. { "上下拼侧2", 0m },
  1043. { "上下拼侧3", 0m },
  1044. { "左右拼侧1", 0m },
  1045. { "左右拼侧2", 0m },
  1046. { "左右拼侧3", 0m },
  1047. { "左右拼侧4", 0m }
  1048. };
  1049. var costAmounts2 = new Dictionary<string, decimal>
  1050. {
  1051. { "小侧1-上下拼侧1", 0m },
  1052. { "小侧1-上下拼侧2", 0m },
  1053. { "小侧1-上下拼侧3", 0m }
  1054. };
  1055. foreach (var mianliao in mianliaoList)
  1056. {
  1057. if (costAmounts.ContainsKey(mianliao.sortcode))
  1058. {
  1059. costAmounts[mianliao.sortcode] += mianliao.costamt.Value;
  1060. }else if (costAmounts2.ContainsKey(mianliao.sortcode))
  1061. {
  1062. costAmounts2[mianliao.sortcode] += mianliao.costamt.Value;
  1063. }
  1064. }
  1065. // 找出最大拼侧金额及对应的拼侧名称
  1066. string lsTempMaxStr = null;
  1067. decimal ldeTempMax = decimal.MinValue;
  1068. foreach (var item in costAmounts)
  1069. {
  1070. if (item.Value >= ldeTempMax)
  1071. {
  1072. ldeTempMax = item.Value;
  1073. lsTempMaxStr = item.Key;
  1074. }
  1075. }
  1076. // 清空不是最大金额的拼侧
  1077. foreach (var mianliao in mianliaoList)
  1078. {
  1079. if (mianliao.sortcode != lsTempMaxStr && new List<int>() { 2, 82, 42, 52, 62, 72 }.Contains(mianliao.formulakind.Value))
  1080. {
  1081. mianliao.costamt = 0;
  1082. }
  1083. }
  1084. // 找出最大小侧拼侧金额及对应的拼侧名称
  1085. string lsTempMaxStr2 = null;
  1086. decimal ldeTempMax2 = decimal.MinValue;
  1087. foreach (var item in costAmounts)
  1088. {
  1089. if (item.Value >= ldeTempMax)
  1090. {
  1091. ldeTempMax = item.Value;
  1092. lsTempMaxStr = item.Key;
  1093. }
  1094. }
  1095. if (ldeTempMax2 > 0)
  1096. {
  1097. // 清空不是最大金额的拼侧
  1098. foreach (var mianliao in mianliaoList)
  1099. {
  1100. if (mianliao.sortcode != lsTempMaxStr2 && new List<int>() { 3, 83, 43, 53, 63, 73 }.Contains(mianliao.formulakind.Value))
  1101. {
  1102. mianliao.costamt = 0;
  1103. }
  1104. }
  1105. }
  1106. // 计算拼侧数量
  1107. int pinceCnt = costAmounts.Values.Count(value => value > 0);
  1108. AddKeyValue("拼侧数量", pinceCnt);
  1109. // 判断是否有大侧
  1110. bool hasBigSide = mianliaoList.Any(row => new[] { 7, 8, 9, 10 }.Contains(row.formulakind.Value) && row.mtrlid.Value > 0);
  1111. AddKeyValue("大侧数量", Convert.ToInt32(hasBigSide));
  1112. string field = pinceCnt > 3 || (hasBigSide && (pinceCnt == 2 || pinceCnt == 3)) ? "num_3" : hasBigSide ? "num_1" : pinceCnt == 2 || pinceCnt == 3 ? "num_2" : string.Empty;
  1113. // 查找点数
  1114. mattress.profitrate_point = GetWorkmanshipRate(mattress, field, "工艺点数", isNewFormula);
  1115. AddKeyValue("工艺点数", mattress.profitrate_point);
  1116. decimal extraProcesses = GetExtraAmt(mattress, 1);
  1117. AddKeyValue("特殊工艺费用", extraProcesses);
  1118. }
  1119. /// <summary>
  1120. /// 计算内布套特殊加点
  1121. /// </summary>
  1122. /// <param name="mattress"></param>
  1123. /// <param name="mxlist"></param>
  1124. private void CalCulateNetBuTao(u_mattress mattress, List<u_mattress_mx_mtrl> mxlist)
  1125. {
  1126. if(mattress.if_n_butao == 1)
  1127. {
  1128. var butaoList = mxlist.Where(t => t.formulatype == 101 || t.formulatype == 102);
  1129. bool butaoFz = false, butaoJd = false;
  1130. // 检查内布套是否为复杂款
  1131. foreach (var butao in butaoList) {
  1132. if (butao.formulakind == 70 && butao.mtrlid > 0) { butaoFz = true; break; }
  1133. }
  1134. if (butaoFz)
  1135. {
  1136. foreach (var butao in butaoList)
  1137. {
  1138. if (butao.formulakind == 203 && butao.mtrlid > 0) { butaoFz = true; break; }
  1139. }
  1140. }
  1141. else
  1142. {
  1143. butaoJd = true; // 没有找到复杂款即为简单款
  1144. }
  1145. // 根据款式类型判断查询的字段
  1146. string field = butaoJd ? "num_4" : (butaoFz ? "num_5" : "");
  1147. AddKeyValue("内布套简单款", Convert.ToInt32(butaoJd));
  1148. AddKeyValue("内布套复杂款", Convert.ToInt32(butaoFz));
  1149. // 查找点数
  1150. //var workmanship = new u_workmanship_add() { deptid = mattress.deptid, mattresstypeid = mattress.mattresstypeid, workmanshipname = field };
  1151. mattress.butao_point = GetWorkmanshipRate(mattress, field, "内布套点数");
  1152. }
  1153. AddKeyValue("内布套点数", mattress.butao_point);
  1154. }
  1155. /// <summary>
  1156. /// 拆装特殊加点
  1157. /// </summary>
  1158. /// <param name="mattress"></param>
  1159. private void CalCulateChaiZhuang(u_mattress mattress)
  1160. {
  1161. int cnt = 0;
  1162. // 判断 if_m_chai, if_z_chai, if_d_chai 是否为 1
  1163. if (Convert.ToInt32(mattress.if_m_chai) == 1) cnt++;
  1164. if (Convert.ToInt32(mattress.if_z_chai) == 1) cnt++;
  1165. if (Convert.ToInt32(mattress.if_d_chai) == 1) cnt++;
  1166. // 根据款式类型判断查询的字段
  1167. string field = cnt == 1 ? "num_6" : (cnt > 1 ? "num_7" : "");
  1168. AddKeyValue("拆装数量", cnt);
  1169. // 查找点数
  1170. mattress.chaizhuang_point = GetWorkmanshipRate(mattress, field, "拆装点数");
  1171. AddKeyValue("拆装点数", mattress.chaizhuang_point);
  1172. }
  1173. /// <summary>
  1174. /// 计算海绵款特殊扣点
  1175. /// </summary>
  1176. /// <param name="mattress"></param>
  1177. private void CalCulateHaiMian(u_mattress mattress)
  1178. {
  1179. if (mattress.if_haimian_type == 1)
  1180. {
  1181. // 根据款式类型判断查询的字段
  1182. string field = "num_8";
  1183. // 查找点数
  1184. mattress.haimian_point = GetWorkmanshipRate(mattress, field, "海绵扣点");
  1185. }
  1186. AddKeyValue("海绵扣点", mattress.haimian_point);
  1187. }
  1188. /// <summary>
  1189. /// 查询工艺加点设置
  1190. /// </summary>
  1191. /// <param name="label"></param>
  1192. /// <returns></returns>
  1193. public List<u_workmanship_add> GetWorkmanshipAdd(string label)
  1194. {
  1195. var list = new List<u_workmanship_add>();
  1196. var outputFields = @"deptid, mattresstypeid, formula, rate";
  1197. var selectStr = @"SELECT deptid, mattresstypeid, formula, rate FROM u_workmanship_add ";
  1198. var whereList = new List<string>();
  1199. whereList.Add("u_workmanship_add.inuse = 1");
  1200. whereList.Add("workmanshipname = @workmanshipname");
  1201. var param = new Dictionary<string, object>();
  1202. param.Add("@workmanshipname", label);
  1203. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), param, "mattressid", outputFields, 0, 0, list);
  1204. return list;
  1205. }
  1206. /// <summary>
  1207. /// 获取工厂利润率
  1208. /// </summary>
  1209. /// <param name="mattress"></param>
  1210. /// <param name="field">旧表字段名</paramD>
  1211. /// <param name="label">新表变量名</paramD>
  1212. /// <returns></returns>
  1213. public decimal GetWorkmanshipRate(u_mattress mattress, string field, string label, Boolean isNewFormula = true)
  1214. {
  1215. decimal rate = 0;
  1216. if (field == "") return 0;
  1217. if (isNewFormula)
  1218. {
  1219. var addList = GetWorkmanshipAdd(label);
  1220. var tgList = addList.Where(o => o.deptid == mattress.deptid && o.mattresstypeid == mattress.mattresstypeid).ToList();
  1221. if (tgList.Count <= 0) tgList = addList.Where(o => o.deptid == mattress.deptid).ToList();
  1222. if (tgList.Count <= 0) tgList = addList.Where(o => o.mattresstypeid == mattress.mattresstypeid).ToList();
  1223. if (tgList.Count <= 0) tgList = addList;
  1224. if (tgList.Count > 0)
  1225. {
  1226. var item = tgList[0];
  1227. rate = item.rate == null ? 0 : Convert.ToDecimal(item.rate);
  1228. var _formula = Convert.ToString(item.formula);
  1229. if (!string.IsNullOrEmpty(_formula))
  1230. {
  1231. AddKeyValue(label, rate);
  1232. rate = Calculate(_formula, label).DecimalValue;
  1233. }
  1234. }
  1235. }
  1236. else
  1237. {
  1238. cmd.CommandText = @"SELECT " + field + " FROM u_workmanship_dianshu WHERE deptid = @deptid AND mattresstypeid = @mattresstypeid";
  1239. cmd.Parameters.Clear();
  1240. cmd.Parameters.AddWithValue("@deptid", mattress.deptid);
  1241. cmd.Parameters.AddWithValue("@mattresstypeid", mattress.mattresstypeid);
  1242. using (var reader = cmd.ExecuteReader())
  1243. {
  1244. if (reader.Read())
  1245. {
  1246. rate = reader[field] == null ? 0 : Convert.ToDecimal(reader[field]);
  1247. }
  1248. }
  1249. }
  1250. return rate;
  1251. }
  1252. /// <summary>
  1253. /// 计算大小单加点
  1254. /// </summary>
  1255. /// <param name="mattress"></param>
  1256. /// <param name="typename"></param>
  1257. private void CalCulateDanNum(u_mattress mattress,string typename)
  1258. {
  1259. var _typename = typename;
  1260. if (mattress.dannum_type.Value != 1)
  1261. {
  1262. switch(mattress.dannum_type.Value)
  1263. {
  1264. case 1:
  1265. _typename = "散单";
  1266. break;
  1267. case 2:
  1268. _typename = "标准";
  1269. break;
  1270. case 3:
  1271. _typename = "大单";
  1272. break;
  1273. case 4: // "小单":
  1274. _typename = "";
  1275. break;
  1276. }
  1277. }
  1278. // 根据款式类型判断查询的字段
  1279. string field = "散单".Equals(_typename) ? "num_9" : "标准".Equals(_typename) ? "num_10" : "大单".Equals(_typename) ? "num_11" : "";
  1280. // 查找点数
  1281. decimal _rate = GetWorkmanshipRate(mattress, field, typename);
  1282. mattress.dannum_rate = _rate == 0 ? 1 : _rate;
  1283. AddKeyValue("大小单", mattress.dannum_rate);
  1284. }
  1285. private decimal CalCulateDanNumRate(u_mattress mattress, string typename)
  1286. {
  1287. // 根据款式类型判断查询的字段
  1288. string field = "散单".Equals(typename) ? "num_9" : "标准".Equals(typename) ? "num_10" : "大单".Equals(typename) ? "num_11" : "";
  1289. // 查找点数
  1290. decimal _rate = GetWorkmanshipRate(mattress, field, typename);
  1291. return _rate;
  1292. }
  1293. /// <summary>
  1294. ///
  1295. /// </summary>
  1296. private void GetDannumRate(u_mattress mattress)
  1297. {
  1298. var mattressType = new u_mattress_type() { mattresstypeid = mattress.mattresstypeid };
  1299. DbSqlHelper.SelectOne(cmd, mattressType, "hrcost_formula,biandaiqty,zhizao_amt,guanli_rate,typerate,dannum1_rate,dannum2_rate,dannum3_rate,dannum4_rate");
  1300. var dept = new u_dept() { deptid = mattress.deptid.Value };
  1301. DbSqlHelper.SelectOne(cmd, dept, "pricelistid,managerate,com_profitrate,dannum1_rate,dannum2_rate,dannum3_rate,dannum4_rate");
  1302. decimal? com_profitrate_dannum = 0;
  1303. decimal _rate = 1;
  1304. if (mattress.dannum_type == null)
  1305. {
  1306. mattress.dannum_type = 2;
  1307. }
  1308. switch (mattress.dannum_type.Value)
  1309. {
  1310. case 1: // "散单":
  1311. _rate = mattressType.dannum1_rate.Value;
  1312. com_profitrate_dannum = dept.dannum1_rate;
  1313. break;
  1314. case 2: // "标准":
  1315. _rate = mattressType.dannum2_rate.Value;
  1316. com_profitrate_dannum = dept.dannum2_rate;
  1317. break;
  1318. case 3: // "大单":
  1319. _rate = mattressType.dannum3_rate.Value;
  1320. com_profitrate_dannum = dept.dannum3_rate;
  1321. break;
  1322. case 4: // "小单":
  1323. _rate = mattressType.dannum4_rate.Value;
  1324. com_profitrate_dannum = dept.dannum4_rate;
  1325. break;
  1326. }
  1327. AddKeyValue("大小单类型", mattress.dannum_type.Value);
  1328. mattress.dannum_rate = _rate;
  1329. AddKeyValue("大小单系数", _rate);
  1330. AddKeyValue("款式系数", mattressType.typerate.Value);
  1331. #region 公式利润点
  1332. AddKeyValue("管理费用点", dept.managerate);
  1333. AddKeyValue("公司利润点(部门)", dept.com_profitrate);
  1334. AddKeyValue("公司利润点", dept.com_profitrate + com_profitrate_dannum);
  1335. #endregion
  1336. }
  1337. /// <summary>
  1338. /// 计算成本
  1339. /// </summary>
  1340. /// <param name="mattress"></param>
  1341. /// <param name="typename"></param>
  1342. private void CalCulateCostNew(u_mattress mattress, string typename, Boolean isNewFormula = false)
  1343. {
  1344. #region 判断大小单
  1345. if (isNewFormula)
  1346. {
  1347. GetDannumRate(mattress);
  1348. }
  1349. #endregion
  1350. #region 总成本-车间成本
  1351. CalCulateDanNum(mattress, typename);
  1352. if (mattress.if_zhedie_type == 1)
  1353. {
  1354. var _formula = formula_replacements["【车间成本】"];
  1355. AddFormulaKeyValue("车间成本", "( " + _formula + " ) * 2");
  1356. mattress.total_cost = CalculateVarFormula("车间成本").DecimalValue;
  1357. }
  1358. else
  1359. {
  1360. mattress.total_cost = CalculateVarFormula("车间成本").DecimalValue;
  1361. }
  1362. AddKeyValue("车间成本", mattress.total_cost);
  1363. #endregion
  1364. #region 不含税出厂价
  1365. mattress.nottax_factory_cost = CalculateVarFormula("不含税出厂价").DecimalValue;
  1366. AddKeyValue("不含税出厂价", mattress.nottax_factory_cost);
  1367. #endregion
  1368. #region 部门不含税价
  1369. mattress.nottax_dept_cost = CalculateVarFormula("部门不含税价").DecimalValue;
  1370. AddKeyValue("部门不含税价", mattress.nottax_dept_cost);
  1371. #endregion
  1372. #region 底价
  1373. decimal _dijia = CalculateVarFormula("底价").DecimalValue;
  1374. AddKeyValue("底价", _dijia);
  1375. #endregion
  1376. #region 佣金
  1377. decimal _yongjin = CalculateVarFormula("佣金").DecimalValue;
  1378. AddKeyValue("佣金", _yongjin);
  1379. #endregion
  1380. #region 税金
  1381. mattress.taxes = CalculateVarFormula("税金").DecimalValue;
  1382. AddKeyValue("税金", mattress.taxes);
  1383. #endregion
  1384. #region 部门含税价=(部门不含税价+佣金*0.06)*税率*折扣率(fob>0)
  1385. if (mattress.fob == 0) {
  1386. mattress.discount = 1;
  1387. AddKeyValue("折扣率", mattress.discount);
  1388. }
  1389. mattress.dept_cost = CalculateVarFormula("部门含税价").DecimalValue;
  1390. AddKeyValue("部门含税价", mattress.dept_cost);
  1391. #endregion
  1392. #region 外币价= 部门含税价/汇率
  1393. //if (mattress.moneyrate > 0)
  1394. //{
  1395. // if ("标准".Equals(typename)) mattress.foreign_cost_bz = mattress.dept_cost / mattress.moneyrate;
  1396. // else if ("大单".Equals(typename)) mattress.foreign_cost_dd = mattress.dept_cost / mattress.moneyrate;
  1397. // else if ("散单".Equals(typename)) mattress.foreign_cost = mattress.dept_cost / mattress.moneyrate;
  1398. //}
  1399. decimal _waibi = 0;
  1400. if (mattress.moneyrate > 0)
  1401. {
  1402. _waibi = CalculateVarFormula("外币价").DecimalValue;
  1403. } else
  1404. {
  1405. _waibi = mattress.dept_cost.Value;
  1406. }
  1407. mattress.foreign_cost = _waibi;
  1408. AddKeyValue("外币价", _waibi);
  1409. #endregion
  1410. }
  1411. /// <summary>
  1412. /// 保存床垫报价
  1413. /// </summary>
  1414. /// <param name="mattress"></param>
  1415. /// <param name="mxlist"></param>
  1416. /// <param name="subspecs">副规格列表</param>
  1417. public void SaveMattress(u_mattress mattress,List<u_mattress_mx_mtrl> mxlist, List<u_mattress_mx_extra> extraProcesses = null, List<u_mattress_mx_extra> extraCosts = null, bool iferpmtrl = false)
  1418. {
  1419. var fields = "mattressname, deptid, mattresscode, mattresstypeid, mattress_width, mattress_length, mattress_height, packtype, packqty, woodpallettype, total_hr_cost, total_material_cost, fees_dscrp, total_fees_cost, total_cost, taxrate, taxes, commissionrate, commission, fob," +
  1420. " profitrate, dept_profitrate, moneyrate, nottax_factory_cost, nottax_dept_cost, foreign_cost, diameter, area, cabinet_type, hrcost, biandaicost, createtime, createby, mattressrelcode, other_rate, flag, dept_profitrate_rangli, profitrate_point, if_moneyrate, discount, if_m_chai," +
  1421. " if_z_chai, if_d_chai, if_n_butao, if_w_butao, if_m_wbutao_way, s_cover_qty, z_cover_qty, x_cover_qty, biandai_qty, s_m_cover_qty, z_m_cover_qty, x_m_cover_qty, chaizhuang_point, haimian_point, if_zhedie_type, qr_auditingrep, qr_auditingdate, if_bcp_type, zhizao_amt, foreign_cost_bz, " +
  1422. "cubage, extras_cost, extras_cost_dscrp, parentid, flag, xd_flag, dannum_type,dannum_cost1,dannum_cost2, dannum_cost3, dannum_cost4, dijia_cost1,dijia_cost2,dijia_cost3,dijia_cost4";
  1423. var fieldsMx = "mattressmxid,mattressid,formulaid,formula,replace_formula,if_success,priceunit,shrinkage,mtrlid,price,gram_weight,cloth_width,if_inputqty,qty ,costamt,if_areaprice,thickness,chastr,xu,useqty,useformula,replace_useformula,gydscrp,mattress_width,mattress_length";
  1424. var fieldsExtra = "mattressmxid,mattressid, extraid, extramxid, extraname, price, qty, dscrp";
  1425. mattress.qr_auditingdate = context.opdate;
  1426. mattress.qr_auditingrep = context.tokendata.username;
  1427. if (iferpmtrl)
  1428. {
  1429. fields += ",erp_mtrlcode,erp_mtrlid";
  1430. }
  1431. if (mattress.mattressid <= 0)
  1432. {
  1433. //新建
  1434. mattress.createtime = context.opdate;
  1435. if (mattress.parentid == null || mattress.parentid == 0) mattress.createby = context.tokendata.username;
  1436. mattress.mattressid = BllHelper.GetID(cmd, "u_mattress");
  1437. fields = "mattressid," + fields;
  1438. if (string.IsNullOrEmpty(mattress.mattresscode))
  1439. {
  1440. var mattresstype = new u_mattress_type() { mattresstypeid = mattress.mattresstypeid };
  1441. DbSqlHelper.SelectOne(cmd, mattresstype, "typecode");
  1442. mattress.mattresscode = $"{mattresstype.typecode}-{context.opdate.ToString("yyyyMMdd")}{(mattress.mattressid % 10000).ToString("D4")}";
  1443. }
  1444. DbSqlHelper.Insert(cmd, "u_mattress", null, mattress, fields);
  1445. }
  1446. else
  1447. {
  1448. // 删除所有明细
  1449. cmd.CommandText = @"DELETE u_mattress_mx_mtrl WHERE mattressid = @mattressid";
  1450. cmd.Parameters.Clear();
  1451. cmd.Parameters.AddWithValue("@mattressid", mattress.mattressid);
  1452. cmd.ExecuteNonQuery();
  1453. // 删除所有额外费用明细
  1454. cmd.CommandText = @"DELETE u_mattress_mx_extra WHERE mattressid = @mattressid";
  1455. cmd.Parameters.Clear();
  1456. cmd.Parameters.AddWithValue("@mattressid", mattress.mattressid);
  1457. cmd.ExecuteNonQuery();
  1458. DbSqlHelper.Update(cmd, "u_mattress", null, mattress, "mattressid", fields);
  1459. }
  1460. if (mxlist != null && mxlist.Any())
  1461. {
  1462. foreach (var item in mxlist)
  1463. {
  1464. item.mattressid = mattress.mattressid;
  1465. if (item.mattressmxid == null || item.mattressmxid <= 0)
  1466. {
  1467. item.mattressmxid = BllHelper.GetID(cmd, "u_mattress_mx_mtrl");
  1468. }
  1469. DbSqlHelper.Insert(cmd, "u_mattress_mx_mtrl", null, item, fieldsMx);
  1470. }
  1471. }
  1472. if (extraProcesses != null && extraProcesses.Any())
  1473. {
  1474. foreach (var item in extraProcesses)
  1475. {
  1476. item.mattressid = mattress.mattressid;
  1477. item.mattressmxid = BllHelper.GetID(cmd, "u_mattress_mx_extra");
  1478. DbSqlHelper.Insert(cmd, "u_mattress_mx_extra", null, item, fieldsExtra);
  1479. }
  1480. }
  1481. if (extraCosts != null && extraCosts.Any())
  1482. {
  1483. foreach (var item in extraCosts)
  1484. {
  1485. item.mattressid = mattress.mattressid;
  1486. item.mattressmxid = BllHelper.GetID(cmd, "u_mattress_mx_extra");
  1487. DbSqlHelper.Insert(cmd, "u_mattress_mx_extra", null, item, fieldsExtra);
  1488. }
  1489. }
  1490. // 更新计价历史
  1491. var hisprice = new u_his_price
  1492. {
  1493. bednetid_mattressid = mattress.mattressid,
  1494. typeid = 1,
  1495. cmpdate = context.opdate,
  1496. cmpemp = context.tokendata.username,
  1497. nottax_dept_cost = mattress.nottax_dept_cost,
  1498. dept_cost = mattress.dept_cost,
  1499. foreign_cost = mattress.foreign_cost,
  1500. dannum_cost1 = mattress.dannum_cost1,
  1501. dannum_cost2 = mattress.dannum_cost2,
  1502. dannum_cost3 = mattress.dannum_cost3,
  1503. dannum_cost4 = mattress.dannum_cost4
  1504. };
  1505. var fieldsHs = "bednetid_mattressid, typeid, cmpdate, cmpemp, nottax_dept_cost, dept_cost, foreign_cost, dannum_cost1, dannum_cost2, dannum_cost3, dannum_cost4";
  1506. DbSqlHelper.Insert(cmd, "u_his_price", null, hisprice, fieldsHs);
  1507. }
  1508. public u_mattress GetMattress(int mattressid)
  1509. {
  1510. if(mattressid <= 0)
  1511. {
  1512. throw new LJCommonException("查找床垫报价失败,ID错误!");
  1513. }
  1514. var mattress = new u_mattress() { mattressid = mattressid };
  1515. var fields = @"mattressid,mattressname,deptid,mattresstypeid,mattresscode,mattress_width,mattress_length,mattress_height,packtype,packqty,woodpallettype,old_mtrlname,
  1516. total_hr_cost,total_material_cost,fees_dscrp,total_fees_cost,taxrate,commissionrate,commission,fob,profitrate,profitrate_point,butao_point,chaizhuang_point,
  1517. haimian_point,dannum_rate,hrcost,biandaicost,zhizao_amt,guanli_rate,discount,extras_cost,dept_profitrate,dept_profitrate_rangli,moneyrate,mattressrelcode,
  1518. flag,auditingrep,auditingdate,createtime,createby,total_cost,nottax_factory_cost,nottax_dept_cost,taxes,dept_cost,foreign_cost,foreign_cost_bz,
  1519. nottax_factory_cost/(dept_profitratedept_profitrate_rangli/100)asdijia_cost,xd_flag,xd_auditingrep,xd_auditingdate,qr_flag,qr_auditingrep,
  1520. qr_auditingdate,js1_flag,erp_mtrlcode,erp_cb_updatetime,if_bcp_type,if_zhedie_type,if_w_butao,biandai_qty,other_rate,if_moneyrate,parentid,
  1521. if_m_chai,if_z_chai,if_d_chai,if_n_butao,if_m_wbutao_way,s_cover_qty,z_cover_qty,x_cover_qty,s_m_cover_qty,z_m_cover_qty,x_m_cover_qty,cabinet_type,area,diameter,cubage,erp_mtrlcode,erp_mtrlid,dannum_type";
  1522. DbSqlHelper.SelectOne(cmd, mattress, fields);
  1523. return mattress;
  1524. }
  1525. public List<u_mattress_mx_mtrl> GetMattressMxMtrl(int mattressid,List<string> extraWhere = null)
  1526. {
  1527. var mxList = new List<u_mattress_mx_mtrl>();
  1528. var outputFields = @"mattressmxid, mattressid, formulakind, formula, formulaid, mtrlid, mtrlname, price, gram_weight, cloth_width, if_inputqty, qty , costamt, if_areaprice, formulatype, sortcode, if_mtrl, if_success, replace_formula, priceunit, shrinkage, name, dannum1_rate, dannum2_rate, dannum3_rate, dannum4_rate, thickness, chastr, xu, useqty, useformula, replace_useformula , gydscrp, mattress_width, mattress_length";
  1529. var selectStr = @"
  1530. SELECT
  1531. u_mattress_mx_mtrl.mattressmxid,
  1532. u_mattress_mx_mtrl.mattressid,
  1533. u_mattress_formula.formulakind as formulakind ,
  1534. u_mattress_mx_mtrl.formula as formula,
  1535. u_mattress_mx_mtrl.formulaid,
  1536. u_mattress_mx_mtrl.mtrlid,
  1537. CASE WHEN u_mattress_formula.formulatype = 99 THEN vv_bednet.bednetname ELSE vv_mtrl_price.mtrlname END AS mtrlname,
  1538. u_mattress_mx_mtrl.price,
  1539. u_mattress_mx_mtrl.gram_weight,
  1540. u_mattress_mx_mtrl.cloth_width,
  1541. u_mattress_mx_mtrl.if_inputqty,
  1542. u_mattress_mx_mtrl.qty ,
  1543. u_mattress_mx_mtrl.costamt,
  1544. u_mattress_mx_mtrl.if_areaprice,
  1545. u_mattress_formula.formulatype,
  1546. case when u_mattress_mx_mtrl.chastr <> '' then u_mattress_mx_mtrl.chastr else u_mattress_formula.sortcode end as sortcode,
  1547. u_mattress_formula.if_mtrl,
  1548. u_mattress_mx_mtrl.if_success,
  1549. u_mattress_mx_mtrl.replace_formula,
  1550. u_mattress_mx_mtrl.priceunit,
  1551. u_mattress_mx_mtrl.shrinkage,
  1552. CASE when u_mattress_formula.if_mtrl > 1 THEN '+' ELSE '' END as addmx,
  1553. CASE when u_mattress_formula.if_mtrl > 1 THEN '-' ELSE '' END as delmx,
  1554. u_mtrl_price.name,
  1555. ISNULL(u_mtrltype.dannum1_rate, 0) AS dannum1_rate,
  1556. ISNULL(u_mtrltype.dannum2_rate, 0) AS dannum2_rate,
  1557. ISNULL(u_mtrltype.dannum3_rate, 0) AS dannum3_rate,
  1558. ISNULL(u_mtrltype.dannum4_rate, 0) AS dannum4_rate,
  1559. u_mattress_mx_mtrl.thickness,
  1560. u_mattress_mx_mtrl.chastr,
  1561. u_mattress_mx_mtrl.xu,
  1562. u_mattress_mx_mtrl.useqty as useqty,
  1563. u_mattress_mx_mtrl.useformula,
  1564. u_mattress_mx_mtrl.replace_useformula ,
  1565. u_mattress_mx_mtrl.gydscrp,
  1566. u_mattress_mx_mtrl.mattress_width,
  1567. u_mattress_mx_mtrl.mattress_length
  1568. From u_mattress_mx_mtrl
  1569. Left join u_mattress_formula On u_mattress_formula.formulaid = u_mattress_mx_mtrl.formulaid
  1570. left outer join u_mtrl_price on u_mattress_mx_mtrl.mtrlid = u_mtrl_price.mtrlid
  1571. left outer join u_mtrltype on u_mtrltype.mtrltypeid = u_mtrl_price.mtrltype
  1572. Left OUTER JOIN (
  1573. select
  1574. mtrlid,
  1575. name as mtrlname
  1576. from u_mtrl_price
  1577. union all
  1578. select top 1
  1579. 0 as mtrlid,
  1580. ' ' as mtrlname
  1581. from u_user_jlhprice
  1582. ) AS vv_mtrl_price on vv_mtrl_price.mtrlid = u_mattress_mx_mtrl.mtrlid
  1583. Left OUTER JOIN (
  1584. SELECT u_bednet.bednetid,
  1585. rtrim(u_bednet_type.typename)+ ' ' + rtrim(u_bednet.bednetcode)+ ' '+cast(u_bednet.mattress_width as char(3))+ '*'
  1586. +cast(u_bednet.mattress_length as char(3))+ '*'+cast(u_bednet.mattress_height as char(3)) as bednetname
  1587. FROM u_bednet
  1588. inner join u_bednet_type ON u_bednet_type.bednettypeid = u_bednet.bednettypeid
  1589. ) as vv_bednet ON vv_bednet.bednetid = u_mattress_mx_mtrl.mtrlid";
  1590. var whereList = new List<string>();
  1591. whereList.Add("u_mattress_mx_mtrl.mattressid = @mattressid");
  1592. if(extraWhere != null && extraWhere.Any())
  1593. {
  1594. whereList = whereList.Concat(extraWhere).ToList();
  1595. }
  1596. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), new Dictionary<string, object>() { { "@mattressid", mattressid } }, "mattressmxid", outputFields, 0, 0, mxList);
  1597. return mxList;
  1598. }
  1599. /// <summary>
  1600. /// 其他额外费用tab / 特殊工艺列表
  1601. /// </summary>
  1602. /// <param name="mattress"></param>
  1603. /// <param name="typeid"></param> 1: 特殊工艺。2:其他额外费用
  1604. /// <returns></returns>
  1605. public List<u_mattress_mx_extra> GetMattressMxExtra(int mattressid, int typeid)
  1606. {
  1607. var mxList = new List<u_mattress_mx_extra>();
  1608. var outputFields = @"mattressmxid,mattressid,extraid,extramxid,extratypename,extraname,price,dscrp,qty";
  1609. var selectStr = @"
  1610. SELECT
  1611. u_mattress_mx_extra.mattressid,
  1612. u_mattress_mx_extra.mattressmxid,
  1613. u_mattress_mx_extra.extraid,
  1614. u_mattress_mx_extra.extramxid,
  1615. u_mattress_mx_extra.extraname,
  1616. u_mattress_mx_extra.price,
  1617. u_mattress_mx_extra.qty,
  1618. u_mattress_mx_extra.dscrp
  1619. From u_mattress_mx_extra
  1620. Left OUTER JOIN u_mattress_extra_type On u_mattress_extra_type.extraid = u_mattress_mx_extra.extraid
  1621. Left OUTER JOIN u_mattress_extra On u_mattress_extra.extramxid = u_mattress_mx_extra.extramxid
  1622. ";
  1623. var whereList = new List<string>();
  1624. whereList.Add("u_mattress_mx_extra.mattressid = @mattressid");
  1625. whereList.Add("u_mattress_extra_type.typeid = @typeid");
  1626. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), new Dictionary<string, object>() { { "@mattressid", mattressid }, { "@typeid", typeid } }, "mattressmxid", outputFields, 0, 0, mxList);
  1627. return mxList;
  1628. }
  1629. /// <summary>
  1630. /// 获取副规格列表
  1631. /// </summary>
  1632. /// <param name="mattressid"></param>
  1633. /// <returns></returns>
  1634. public List<u_mattress> GetMattressSubspecs(int mattressid)
  1635. {
  1636. var list = new List<u_mattress>();
  1637. var outputFields = @"mattressid,mattresscode,mattress_width,mattress_length,mattress_height,mattressname,mattressrelcode,parentid,erp_mtrlid,erp_mtrlcode";
  1638. var selectStr = @"SELECT
  1639. mattressid,
  1640. mattresscode,
  1641. mattress_width,
  1642. mattress_length,
  1643. mattress_height,
  1644. mattressname,
  1645. mattressrelcode,
  1646. parentid,
  1647. erp_mtrlid,
  1648. erp_mtrlcode
  1649. FROM u_mattress
  1650. ";
  1651. var whereList = new List<string>();
  1652. whereList.Add(@"u_mattress.parentid = @mattressid OR parentid = (
  1653. SELECT parentid FROM u_mattress WHERE mattressid = @mattressid and parentid > 0
  1654. )");
  1655. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), new Dictionary<string, object>() { { "@mattressid", mattressid } }, "mattressid", outputFields, 0, 0, list);
  1656. return list;
  1657. }
  1658. /// <summary>
  1659. /// 获取副规格的床网弹簧排列数
  1660. /// </summary>
  1661. /// <param name="mattressid"></param>
  1662. /// <returns></returns>
  1663. public List<u_mattress_mx_mtrl> GetMattressSubspecsBednet(int mattressid)
  1664. {
  1665. var list = new List<u_mattress_mx_mtrl>();
  1666. var outputFields = @"mattressid,mtrlid,spring_qty_width,spring_qty_length,bednet_iffork,bednet_fork_qty";
  1667. var selectStr = @"SELECT
  1668. u_mattress_mx_mtrl.mattressid,
  1669. u_mattress_mx_mtrl.mattressmxid,
  1670. u_mattress_mx_mtrl.mtrlid,
  1671. ISNULL(u_bednetmx.spring_qty_width, 0) AS spring_qty_width,
  1672. ISNULL(u_bednetmx.spring_qty_length, 0) AS spring_qty_length,
  1673. ISNULL(u_bednet.iffork, 0) AS bednet_iffork,
  1674. ISNULL(u_bednet.fork_qty, 0) AS bednet_fork_qty
  1675. FROM u_mattress_mx_mtrl
  1676. LEFT JOIN u_mattress_formula On u_mattress_formula.formulaid = u_mattress_mx_mtrl.formulaid
  1677. LEFT OUTER JOIN u_bednetmx on u_bednetmx.bednetid = u_mattress_mx_mtrl.mtrlid
  1678. LEFT OUTER JOIN u_bednet on u_bednetmx.bednetid = u_bednet.bednetid
  1679. ";
  1680. var whereList = new List<string>();
  1681. whereList.Add("u_mattress_formula.formulatype = 99");
  1682. whereList.Add("u_mattress_mx_mtrl.mattressid = @mattressid");
  1683. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), new Dictionary<string, object>() { { "@mattressid", mattressid } }, "mattressmxid", outputFields, 0, 0, list);
  1684. return list;
  1685. }
  1686. /// <summary>
  1687. /// 获取床垫明细中,垫层出现的主副规格调整物料
  1688. /// </summary>
  1689. /// <param name="mattressid"></param>
  1690. /// <returns></returns>
  1691. public List<u_mattress_mx_mtrl> GetMattressMxSubspecsMtrl(int mattressid)
  1692. {
  1693. var list = new List<u_mattress_mx_mtrl>();
  1694. var outputFields = @"mattressid,mtrlid,chastr,formulakind,mtrlname";
  1695. var selectStr = @"SELECT
  1696. u_mattress_mx_mtrl.mattressid,
  1697. u_mattress_mx_mtrl.mattressmxid,
  1698. u_mattress_mx_mtrl.mtrlid,
  1699. u_mattress_mx_mtrl.chastr,
  1700. u_mattress_formula.formulakind,
  1701. vv_mtrl_price.mtrlname
  1702. FROM u_mattress_mx_mtrl
  1703. LEFT JOIN u_mattress_formula On u_mattress_formula.formulaid = u_mattress_mx_mtrl.formulaid
  1704. LEFT OUTER JOIN u_mtrl_price on u_mtrl_price.mtrlid = u_mattress_mx_mtrl.mtrlid
  1705. Left OUTER JOIN (
  1706. select
  1707. mtrlid,
  1708. name as mtrlname
  1709. from u_mtrl_price
  1710. union all
  1711. select top 1
  1712. 0 as mtrlid,
  1713. ' ' as mtrlname
  1714. from u_user_jlhprice
  1715. ) AS vv_mtrl_price on vv_mtrl_price.mtrlid = u_mattress_mx_mtrl.mtrlid
  1716. ";
  1717. var whereList = new List<string>();
  1718. whereList.Add("u_mattress_formula.formulatype = 1");
  1719. whereList.Add("u_mtrl_price.if_subspecs = 1");
  1720. whereList.Add("u_mattress_mx_mtrl.mattressid = @mattressid");
  1721. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), new Dictionary<string, object>() { { "@mattressid", mattressid } }, "mattressmxid", outputFields, 0, 0, list);
  1722. return list;
  1723. }
  1724. /// <summary>
  1725. /// 保存床垫复制清单
  1726. /// </summary>
  1727. /// <param name="mattressid"></param>
  1728. public void CopyMattressInterface(int cpoyid,int mattressid)
  1729. {
  1730. cmd.CommandText = @"DELETE u_mattress_interface WHERE mattressid = @mattressid";
  1731. cmd.Parameters.Clear();
  1732. cmd.Parameters.AddWithValue("@mattressid", mattressid);
  1733. cmd.ExecuteNonQuery();
  1734. cmd.CommandText = @"DELETE u_mattress_interface_qd WHERE mattressid = @mattressid";
  1735. cmd.Parameters.Clear();
  1736. cmd.Parameters.AddWithValue("@mattressid", mattressid);
  1737. cmd.ExecuteNonQuery();
  1738. cmd.CommandText = @"INSERT INTO u_mattress_interface (
  1739. mattressid
  1740. ,printid
  1741. ,itemname
  1742. ,bj_pzname
  1743. ,bj_namemx
  1744. ,bj_inputtype
  1745. ,actual_size
  1746. ,sb_craft
  1747. ,actual_size_sb
  1748. ,erp_pzid
  1749. ,ss_rate
  1750. ,ls_rate
  1751. )
  1752. SELECT @mattressid
  1753. ,printid
  1754. ,itemname
  1755. ,bj_pzname
  1756. ,bj_namemx
  1757. ,bj_inputtype
  1758. ,actual_size
  1759. ,sb_craft
  1760. ,actual_size_sb
  1761. ,erp_pzid
  1762. ,ss_rate
  1763. ,ls_rate
  1764. FROM u_mattress_interface
  1765. WHERE mattressid = @copy_id";
  1766. cmd.Parameters.Clear();
  1767. cmd.Parameters.AddWithValue("@mattressid", mattressid);
  1768. cmd.Parameters.AddWithValue("@copy_id", cpoyid);
  1769. cmd.ExecuteNonQuery();
  1770. cmd.CommandText = @"INSERT INTO u_mattress_interface_qd (
  1771. mattressid
  1772. ,printid
  1773. ,itemname
  1774. ,bj_pzname
  1775. ,bj_pzname_mx
  1776. ,mtrlid
  1777. ,erp_mtrlid
  1778. ,wrkgrpid
  1779. ,useqty
  1780. ,dscrp
  1781. ,actual_useqty
  1782. ,qd_actual_size
  1783. ,qd_pfgroupqty
  1784. ,formulaid
  1785. )
  1786. SELECT @mattressid
  1787. ,printid
  1788. ,itemname
  1789. ,bj_pzname
  1790. ,bj_pzname_mx
  1791. ,mtrlid
  1792. ,erp_mtrlid
  1793. ,wrkgrpid
  1794. ,useqty
  1795. ,dscrp
  1796. ,actual_useqty
  1797. ,qd_actual_size
  1798. ,qd_pfgroupqty
  1799. ,formulaid
  1800. FROM u_mattress_interface_qd
  1801. WHERE mattressid = @copy_id";
  1802. cmd.Parameters.Clear();
  1803. cmd.Parameters.AddWithValue("@mattressid", mattressid);
  1804. cmd.Parameters.AddWithValue("@copy_id", cpoyid);
  1805. cmd.ExecuteNonQuery();
  1806. }
  1807. public void CopyMattress(List<u_mattress> mattressList,int gwidth,int glength)
  1808. {
  1809. var bedNetHelpe = HelperBase.GetHelper<BedNetHelper>(cmd);
  1810. foreach(var mattress in mattressList)
  1811. {
  1812. var mattress_copy = GetMattress(mattress.mattressid);
  1813. var mxlist = new List<u_mattress_mx_mtrl>();
  1814. mattress_copy.deptid = mattress.deptid;
  1815. if (mattress.mattress_length > 0 && mattress.mattress_width > 0)
  1816. {
  1817. cmd.CommandText = @"SELECT u_mattress_mx_mtrl.mtrlid
  1818. FROM u_mattress_mx_mtrl
  1819. INNER JOIN u_mattress_formula ON u_mattress_formula.formulaid = u_mattress_mx_mtrl.formulaid
  1820. WHERE u_mattress_formula.formulakind = 99
  1821. AND u_mattress_mx_mtrl.mattressid = @mattressid
  1822. AND u_mattress_mx_mtrl.mtrlid > 0";
  1823. cmd.Parameters.Clear();
  1824. cmd.Parameters.AddWithValue("@mattressid", mattress.mattressid);
  1825. using(var reader = cmd.ExecuteReader())
  1826. {
  1827. while (reader.Read())
  1828. {
  1829. mxlist.Add(new u_mattress_mx_mtrl() { copty_mtrlid = Convert.ToInt32(reader["mtrlid"]) });
  1830. }
  1831. }
  1832. foreach(var mx in mxlist)
  1833. {
  1834. var bednet = new u_bednet() { bednetid = mx.copty_mtrlid, mattress_width = mattress.mattress_width ,mattress_length = mattress.mattress_length };
  1835. var bednetMx = new u_bednetmx() { spring_qty_width = gwidth, spring_qty_length = glength };
  1836. bedNetHelpe.CopyBedNet(bednet, bednetMx, out int newMtrlid);
  1837. mx.mtrlid = newMtrlid;
  1838. }
  1839. }
  1840. // 判断copy_bedNet.bednetcode是否存在@@字符串,如果存在,则删除@@后面的字符串,包括@@
  1841. if (mattress_copy.mattresscode.IndexOf("@@") > -1)
  1842. {
  1843. mattress_copy.mattresscode = mattress_copy.mattresscode.Substring(mattress_copy.mattresscode.IndexOf("@@"));
  1844. }
  1845. mattress_copy.mattresscode += " @@";
  1846. mattress_copy.mattresscode += DateTime.Now.ToString("yyyMMdd_mmhhss");
  1847. if (mattress_copy.mattressrelcode.IndexOf("@@") > -1)
  1848. {
  1849. mattress_copy.mattressrelcode = mattress_copy.mattressrelcode.Substring(mattress_copy.mattressrelcode.IndexOf("@@"));
  1850. }
  1851. mattress_copy.mattressrelcode += " @@";
  1852. mattress_copy.mattressrelcode += DateTime.Now.ToString("yyyMMdd_mmhhss");
  1853. mattress_copy.mattressid = 0;
  1854. mattress_copy.mattress_width = mattress.mattress_width > 0 ? mattress.mattress_width : mattress_copy.mattress_width;
  1855. mattress_copy.mattress_length = mattress.mattress_length > 0 ? mattress.mattress_length : mattress_copy.mattress_length;
  1856. if (!"维持原状".Equals(mattress.area)) mattress_copy.area = mattress.area;
  1857. if (!"维持原状".Equals(mattress.cabinet_type)) mattress_copy.cabinet_type = mattress.cabinet_type;
  1858. if (mattress.packtype == 0) mattress_copy.packqty = mattress.packqty;
  1859. mattress_copy.js1_flag = 0;
  1860. mattress_copy.js1_auditingrep = string.Empty;
  1861. mattress_copy.js1_auditingdate = null;
  1862. mattress_copy.xd_flag = 0;
  1863. var mattressMxMtrlList = GetMattressMxMtrl(mattress.mattressid);
  1864. foreach(var mx in mattressMxMtrlList)
  1865. {
  1866. mx.mattressid = 0;
  1867. mx.mattressmxid = 0;
  1868. }
  1869. var mattressMxExtra1List = GetMattressMxExtra(mattress.mattressid, 1);
  1870. foreach (var mx in mattressMxExtra1List)
  1871. {
  1872. mx.mattressid = 0;
  1873. mx.mattressmxid = 0;
  1874. }
  1875. var mattressMxExtra2List = GetMattressMxExtra(mattress.mattressid, 2);
  1876. foreach (var mx in mattressMxExtra2List)
  1877. {
  1878. mx.mattressid = 0;
  1879. mx.mattressmxid = 0;
  1880. }
  1881. try
  1882. {
  1883. CalCulateFormula(mattress_copy, mattressMxMtrlList, true, true, mattressMxExtra1List, mattressMxExtra2List);
  1884. }
  1885. catch (Exception e)
  1886. {
  1887. throw new LJCommonException(e.Message);
  1888. }
  1889. SaveMattress(mattress_copy, mattressMxMtrlList, mattressMxExtra1List, mattressMxExtra2List, true);
  1890. var mattressSubspecs = GetMattressSubspecs(mattress.mattressid);
  1891. foreach (var sub in mattressSubspecs)
  1892. {
  1893. sub.parentid = mattress_copy.mattressid;
  1894. sub.mattressid = 0;
  1895. sub.mattresscode = "";
  1896. var mattressMxList = GetMattressMxMtrl(sub.mattressid);
  1897. foreach (var submx in mattressMxList)
  1898. {
  1899. submx.mattressid = 0;
  1900. submx.mattressmxid = 0;
  1901. }
  1902. var mattressMxExtra1 = GetMattressMxExtra(sub.mattressid, 1);
  1903. foreach (var mx in mattressMxExtra1)
  1904. {
  1905. mx.mattressid = 0;
  1906. mx.mattressmxid = 0;
  1907. }
  1908. var mattressMxExtra2 = GetMattressMxExtra(sub.mattressid, 2);
  1909. foreach (var mx in mattressMxExtra2)
  1910. {
  1911. mx.mattressid = 0;
  1912. mx.mattressmxid = 0;
  1913. }
  1914. SaveMattress(sub, mattressMxList, mattressMxExtra1, mattressMxExtra2);
  1915. }
  1916. CopyMattressInterface(mattress_copy.mattressid, mattress.mattressid);
  1917. foreach (var mx in mxlist)
  1918. {
  1919. cmd.CommandText = @"UPDATE u_mattress_mx_mtrl
  1920. SET mtrlid = @new_mtrlid
  1921. FROM u_mattress_mx_mtrl
  1922. INNER JOIN u_mattress_formula ON u_mattress_formula.formulaid = u_mattress_mx_mtrl.formulaid
  1923. WHERE u_mattress_formula.formulakind = 99
  1924. AND u_mattress_mx_mtrl.mattressid = @new_mattressid
  1925. AND u_mattress_mx_mtrl.mtrlid = @old_mtrld";
  1926. cmd.Parameters.Clear();
  1927. cmd.Parameters.AddWithValue("@new_mtrlid", mx.mtrlid);
  1928. cmd.Parameters.AddWithValue("@new_mattressid", mattress_copy.mattressid);
  1929. cmd.Parameters.AddWithValue("@old_mtrld", mx.copty_mtrlid);
  1930. cmd.ExecuteNonQuery();
  1931. }
  1932. }
  1933. }
  1934. public void SaveMattressInterface(int mattressid, List<u_mattress_interface> mxlist,List<u_mattress_interface_qd> qdlist)
  1935. {
  1936. cmd.CommandText = @"DELETE u_mattress_interface WHERE mattressid = @mattressid";
  1937. cmd.Parameters.Clear();
  1938. cmd.Parameters.AddWithValue("@mattressid", mattressid);
  1939. cmd.ExecuteNonQuery();
  1940. cmd.CommandText = @"DELETE u_mattress_interface_qd WHERE mattressid = @mattressid";
  1941. cmd.Parameters.Clear();
  1942. cmd.Parameters.AddWithValue("@mattressid", mattressid);
  1943. cmd.ExecuteNonQuery();
  1944. foreach (var mx in mxlist) {
  1945. mx.mattressid = mattressid;
  1946. DbSqlHelper.Insert(cmd, mx, "mattressid,printid,itemname,bj_pzname,bj_namemx,actual_size,sb_craft,actual_size_sb,erp_pzid,bj_inputtype,ss_rate,ls_rate");
  1947. }
  1948. foreach (var mx in qdlist)
  1949. {
  1950. mx.mattressid = mattressid;
  1951. DbSqlHelper.Insert(cmd, mx, "mattressid,printid,itemname,bj_pzname,bj_pzname_mx,bj_pzname_mx_mx,wip_type,mtrlid,erp_mtrlid,wrkgrpid,wrkgrpid2,useqty,dscrp,actual_useqty,qd_actual_size,qd_pfgroupqty,ss_rate,ls_rate,sh_rate,formulaid,wrkgrpcode1,wrkgrpcode2");
  1952. }
  1953. AutoUpdateBcp(mattressid);
  1954. }
  1955. public void MattressCalculateCost(u_mattress mattress, List<u_mattress_mx_mtrl> mattressMx, List<u_mattress_mx_extra> extraProcesses, List<u_mattress_mx_extra> extraCosts)
  1956. {
  1957. // 没有输入默认按标准计算
  1958. //if (mattress.dannum_type == null || mattress.dannum_type == 0)
  1959. // 20250703:默认只保存标准的单据
  1960. mattress.dannum_type = 2;
  1961. // 作为记录不含税出厂价、部门含税价的各个大小单价格的载体
  1962. var _mattressMain = ObjectHelper.DeepCopy(mattress);
  1963. try
  1964. {
  1965. List<u_mattress> sumMattress = new List<u_mattress>();
  1966. for (var i = 1; i < 5; i++)
  1967. {
  1968. var _mattress = ObjectHelper.DeepCopy(mattress);
  1969. if (mattress.dannum_type.Value != i)
  1970. {
  1971. _mattress.dannum_type = i;
  1972. CalCulateFormula(_mattress, mattressMx, true, true, extraProcesses, extraCosts);
  1973. var nottax_factory_cost = Replacements.Where(o => o.label == "【不含税出厂价】").ToList();
  1974. var dept_cost = Replacements.Where(o => o.label == "【部门含税价】").ToList();
  1975. if (nottax_factory_cost.Count > 0)
  1976. {
  1977. decimal nottax_value = Convert.ToDecimal(nottax_factory_cost[0].value);
  1978. decimal dept_costValue = Convert.ToDecimal(dept_cost[0].value);
  1979. if (i == 1)
  1980. {
  1981. _mattress.dijia_cost1 = nottax_value;
  1982. }
  1983. else if (i == 2)
  1984. {
  1985. _mattress.dijia_cost2 = nottax_value;
  1986. }
  1987. else if (i == 3)
  1988. {
  1989. _mattress.dijia_cost3 = nottax_value;
  1990. }
  1991. else if (i == 4)
  1992. {
  1993. _mattress.dijia_cost4 = nottax_value;
  1994. }
  1995. }
  1996. if (dept_cost.Count > 0)
  1997. {
  1998. decimal dept_costValue = Convert.ToDecimal(dept_cost[0].value);
  1999. if (i == 1)
  2000. {
  2001. _mattress.dannum_cost1 = dept_costValue;
  2002. }
  2003. else if (i == 2)
  2004. {
  2005. _mattress.dannum_cost2 = dept_costValue;
  2006. }
  2007. else if (i == 3)
  2008. {
  2009. _mattress.dannum_cost3 = dept_costValue;
  2010. }
  2011. else if (i == 4)
  2012. {
  2013. _mattress.dannum_cost4 = dept_costValue;
  2014. }
  2015. }
  2016. sumMattress.Add(_mattress);
  2017. }
  2018. }
  2019. CalCulateFormula(mattress, mattressMx, true, true, extraProcesses, extraCosts);
  2020. for (var i = 1; i < 5; i++)
  2021. {
  2022. if (mattress.dannum_type.Value == i)
  2023. {
  2024. var nottax_factory_cost = Replacements.Where(o => o.label == "【不含税出厂价】").ToList();
  2025. var dept_cost = Replacements.Where(o => o.label == "【部门含税价】").ToList();
  2026. if (nottax_factory_cost.Count > 0)
  2027. {
  2028. decimal nottax_value = Convert.ToDecimal(nottax_factory_cost[0].value);
  2029. decimal dept_costValue = Convert.ToDecimal(dept_cost[0].value);
  2030. if (i == 1)
  2031. {
  2032. mattress.dijia_cost1 = nottax_value;
  2033. }
  2034. else if (i == 2)
  2035. {
  2036. mattress.dijia_cost2 = nottax_value;
  2037. }
  2038. else if (i == 3)
  2039. {
  2040. mattress.dijia_cost3 = nottax_value;
  2041. }
  2042. else if (i == 4)
  2043. {
  2044. mattress.dijia_cost4 = nottax_value;
  2045. }
  2046. }
  2047. if (dept_cost.Count > 0)
  2048. {
  2049. decimal dept_costValue = Convert.ToDecimal(dept_cost[0].value);
  2050. if (i == 1)
  2051. {
  2052. mattress.dannum_cost1 = dept_costValue;
  2053. }
  2054. else if (i == 2)
  2055. {
  2056. mattress.dannum_cost2 = dept_costValue;
  2057. }
  2058. else if (i == 3)
  2059. {
  2060. mattress.dannum_cost3 = dept_costValue;
  2061. }
  2062. else if (i == 4)
  2063. {
  2064. mattress.dannum_cost4 = dept_costValue;
  2065. }
  2066. }
  2067. }
  2068. else
  2069. {
  2070. var matchMattress = sumMattress.Where(o => o.dannum_type == i).ToList();
  2071. if (matchMattress.Count > 0)
  2072. {
  2073. if (i == 1)
  2074. {
  2075. mattress.dannum_cost1 = matchMattress[0].dannum_cost1;
  2076. mattress.dijia_cost1 = matchMattress[0].dijia_cost1;
  2077. }
  2078. else if (i == 2)
  2079. {
  2080. mattress.dannum_cost2 = matchMattress[0].dannum_cost2;
  2081. mattress.dijia_cost2 = matchMattress[0].dijia_cost2;
  2082. }
  2083. else if (i == 3)
  2084. {
  2085. mattress.dannum_cost3 = matchMattress[0].dannum_cost3;
  2086. mattress.dijia_cost3 = matchMattress[0].dijia_cost3;
  2087. }
  2088. else if (i == 4)
  2089. {
  2090. mattress.dannum_cost4 = matchMattress[0].dannum_cost4;
  2091. mattress.dijia_cost4 = matchMattress[0].dijia_cost4;
  2092. }
  2093. }
  2094. }
  2095. }
  2096. }
  2097. catch (Exception e)
  2098. {
  2099. throw new LJCommonException(e.Message);
  2100. }
  2101. }
  2102. #region 床垫接口相关方法
  2103. /// <summary>
  2104. /// 业务审核
  2105. /// </summary>
  2106. /// <param name="mattressid"></param>
  2107. /// <exception cref="LJCommonException"></exception>
  2108. public void MattressYWAudit(int mattressid)
  2109. {
  2110. var mattress = new u_mattress() { mattressid = mattressid };
  2111. DbSqlHelper.SelectOne(cmd, mattress, "yw_flag");
  2112. if(mattress.yw_flag == 1)
  2113. {
  2114. throw new LJCommonException("床垫已业务审核,不能业务审核!");
  2115. }
  2116. mattress.yw_flag = 1;
  2117. mattress.yw_auditingdate = context.opdate;
  2118. mattress.yw_auditingrep = context.tokendata.username;
  2119. DbSqlHelper.Update(cmd, mattress, "yw_flag,yw_auditingdate,yw_auditingrep");
  2120. }
  2121. /// <summary>
  2122. /// 自动更新半成品部件
  2123. /// </summary>
  2124. /// <param name="mattressid"></param>
  2125. public void AutoUpdateBcp(int mattressid)
  2126. {
  2127. var qdList = new List<u_mattress_interface_qd>();
  2128. var selectStr = @"
  2129. SELECT u_mattress_interface_qd.mattressid
  2130. ,u_mattress_interface_qd.printid
  2131. ,u_mattress_interface_qd.itemname
  2132. ,u_mattress_interface_qd.bj_pzname
  2133. ,u_mattress_interface_qd.bj_pzname_mx
  2134. ,u_mattress_interface_qd.bj_pzname_mx_mx
  2135. ,u_mattress_interface_qd.mtrlid
  2136. ,u_mattress_interface_qd.erp_mtrlid
  2137. ,u_mattress_interface_qd.useqty
  2138. ,u_mattress_interface_qd.dscrp
  2139. ,u_mattress_interface_qd.actual_useqty
  2140. ,u_mattress_interface_qd.qd_actual_size
  2141. ,u_mattress_interface_qd.qd_pfgroupqty
  2142. ,u_mattress_interface_qd.wrkgrpid
  2143. ,u_mattress_interface_qd.ss_rate
  2144. ,u_mattress_interface_qd.ls_rate
  2145. ,u_mattress_interface_qd.sh_rate
  2146. ,u_mattress_interface_qd.formulaid
  2147. FROM u_mattress_interface_qd
  2148. ";
  2149. var whereList = new List<string>();
  2150. whereList.Add("mattressid = @mattressid");
  2151. var param = new Dictionary<string, object>();
  2152. param.Add("@mattressid", mattressid);
  2153. var outFields = "mattressid, printid, itemname, bj_pzname, bj_pzname_mx, bj_pzname_mx_mx, mtrlid, erp_mtrlid, useqty, dscrp, actual_useqty, qd_actual_size, qd_pfgroupqty, wrkgrpid, ss_rate, ls_rate, sh_rate, formulaid";
  2154. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), param, "printid", outFields, 0, 0, qdList);
  2155. var chastrArr = new List<string>() { "裥面", "裥底", "顶布裥棉", "大侧", "小侧", "V侧" };
  2156. var chastrType = new Dictionary<string, int>();
  2157. Dictionary<string, List<u_mattress_interface_qd>> bcpQdlist = new Dictionary<string, List<u_mattress_interface_qd>>();
  2158. foreach (var mx in qdList)
  2159. {
  2160. if (chastrArr.Contains(mx.itemname) && !string.IsNullOrEmpty(mx.bj_pzname_mx_mx))
  2161. {
  2162. if (!chastrType.ContainsKey(mx.bj_pzname_mx_mx))
  2163. {
  2164. switch (mx.itemname)
  2165. {
  2166. case "裥面":
  2167. chastrType.Add(mx.bj_pzname_mx_mx, 901);
  2168. mx.billtype = 901;
  2169. break;
  2170. case "裥底":
  2171. chastrType.Add(mx.bj_pzname_mx_mx, 902);
  2172. mx.billtype = 902;
  2173. break;
  2174. case "大侧":
  2175. chastrType.Add(mx.bj_pzname_mx_mx, 903);
  2176. mx.billtype = 903;
  2177. break;
  2178. case "小侧":
  2179. chastrType.Add(mx.bj_pzname_mx_mx, 904);
  2180. mx.billtype = 904;
  2181. break;
  2182. case "V侧":
  2183. chastrType.Add(mx.bj_pzname_mx_mx, 905);
  2184. mx.billtype = 905;
  2185. break;
  2186. }
  2187. }
  2188. if (!bcpQdlist.ContainsKey(mx.bj_pzname_mx_mx))
  2189. {
  2190. List<u_mattress_interface_qd> list = new List<u_mattress_interface_qd>();
  2191. list.Add(mx);
  2192. bcpQdlist.Add(mx.bj_pzname_mx_mx, list);
  2193. }
  2194. else
  2195. {
  2196. bcpQdlist[mx.bj_pzname_mx_mx].Add(mx);
  2197. }
  2198. }
  2199. }
  2200. foreach (var mx in bcpQdlist)
  2201. {
  2202. var billid = 0;
  2203. cmd.CommandText = @"SELECT TOP 1 billid
  2204. FROM u_semi_finished_product
  2205. WHERE semi_finished_name = @semi_finished_name";
  2206. cmd.Parameters.Clear();
  2207. cmd.Parameters.AddWithValue("@semi_finished_name", mx.Key);
  2208. using (var reader = cmd.ExecuteReader())
  2209. {
  2210. if (reader.Read())
  2211. {
  2212. billid = Convert.ToInt32(reader["billid"]);
  2213. }
  2214. }
  2215. if (billid == 0)
  2216. {
  2217. //创建
  2218. var bcpMattress = new u_semi_finished_product() { billid = 0 };
  2219. AutoInit.AutoInitS(cmd, bcpMattress);
  2220. bcpMattress.billid = 0;
  2221. bcpMattress.billdate = DateTime.Now;
  2222. bcpMattress.dscrp = "自动生成,来自mattressid:" + mattressid;
  2223. //bcpMattress.production_size = DateTime.Now;
  2224. //bcpMattress.hemming_process = DateTime.Now;
  2225. //bcpMattress.hemmed_size = DateTime.Now;
  2226. //bcpMattress.shrinkage_rate = DateTime.Now;
  2227. //bcpMattress.elongation_rate = DateTime.Now;
  2228. bcpMattress.opemp = context.tokendata.username;
  2229. bcpMattress.opdate = DateTime.Now;
  2230. bcpMattress.semi_finished_type = chastrType[mx.Key];
  2231. bcpMattress.semi_finished_code = mx.Key;
  2232. bcpMattress.semi_finished_name = mx.Key;
  2233. var bcpMxList = new List<u_semi_finished_product_mx>();
  2234. foreach (var qdmx in mx.Value)
  2235. {
  2236. var bcpmx = new u_semi_finished_product_mx()
  2237. {
  2238. mtrlid = qdmx.mtrlid.Value,
  2239. erp_mtrlid = qdmx.erp_mtrlid,
  2240. formulaid = qdmx.formulaid
  2241. };
  2242. bcpMxList.Add(bcpmx);
  2243. }
  2244. bcpMattress.mxlist = bcpMxList;
  2245. SaveMattressBcp(bcpMattress);
  2246. }
  2247. else
  2248. {
  2249. // 判断不一样,就覆盖
  2250. selectStr = @"
  2251. SELECT u_semi_finished_product_mx.billid
  2252. ,u_semi_finished_product_mx.printid
  2253. ,u_semi_finished_product_mx.mtrlid
  2254. ,u_semi_finished_product_mx.formulaid
  2255. ,u_semi_finished_product_mx.chastr
  2256. ,u_semi_finished_product_mx.thickness
  2257. ,u_semi_finished_product_mx.qty
  2258. ,u_semi_finished_product_mx.erp_mtrlid
  2259. ,u_semi_finished_product_mx.usenum
  2260. ,u_semi_finished_product_mx.usedenom
  2261. FROM u_semi_finished_product_mx
  2262. ";
  2263. var bcpMxList = new List<u_semi_finished_product_mx>();
  2264. whereList = new List<string>();
  2265. whereList.Add("u_semi_finished_product_mx.billid = @billid");
  2266. param.Clear();
  2267. param.Add("@billid", billid);
  2268. outFields = "billid, printid, mtrlid, formulaid, chastr, thickness, qty, erp_mtrlid, usenum, usedenom, mtrlname, if_mtrl, formula, formulatype, formulakind";
  2269. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), param, "formulatype, sortcode", outFields, 0, 0, bcpMxList);
  2270. var ErpMtrlids = "";
  2271. var BcpErpMtrlids = "";
  2272. foreach (var qdmx in mx.Value)
  2273. {
  2274. ErpMtrlids += qdmx.erp_mtrlid + "+";
  2275. }
  2276. foreach (var qdmx in bcpMxList)
  2277. {
  2278. BcpErpMtrlids += qdmx.erp_mtrlid + "+";
  2279. }
  2280. if (ErpMtrlids != BcpErpMtrlids)
  2281. {
  2282. var bcpMattress = new u_semi_finished_product() { billid = billid };
  2283. DbSqlHelper.SelectOne(cmd, bcpMattress, "billid, billdate, flag, semi_finished_type, semi_finished_code, semi_finished_name, dscrp, production_size, hemming_process, hemmed_size, shrinkage_rate, elongation_rate, opemp, opdate, auditemp, auditdate");
  2284. bcpMattress.billid = billid;
  2285. bcpMattress.auditemp = context.tokendata.username;
  2286. bcpMattress.auditdate = DateTime.Now;
  2287. foreach (var qdmx in bcpMxList)
  2288. {
  2289. var mtrlid = 0;
  2290. var formulaid = 0;
  2291. var arr = mx.Value.Where((itm) => itm.mtrlid == qdmx.mtrlid).ToList();
  2292. if (arr.Count > 0)
  2293. {
  2294. mtrlid = arr[0].erp_mtrlid.Value;
  2295. if (arr[0].formulaid != null) formulaid = arr[0].formulaid.Value;
  2296. }
  2297. qdmx.erp_mtrlid = mtrlid;
  2298. qdmx.formulaid = formulaid;
  2299. }
  2300. bcpMattress.mxlist = bcpMxList;
  2301. SaveMattressBcp(bcpMattress);
  2302. }
  2303. }
  2304. }
  2305. }
  2306. /// <summary>
  2307. /// 业务撤审
  2308. /// </summary>
  2309. /// <param name="mattressid"></param>
  2310. /// <exception cref="LJCommonException"></exception>
  2311. public void MattressYWCancelAudit(int mattressid)
  2312. {
  2313. var mattress = new u_mattress() { mattressid = mattressid };
  2314. DbSqlHelper.SelectOne(cmd, mattress, "yw_flag,js1_flag");
  2315. if (mattress.js1_flag == 1)
  2316. {
  2317. throw new LJCommonException("床垫已技术1审核,不能业务撤审!");
  2318. }
  2319. if (mattress.yw_flag == 0)
  2320. {
  2321. throw new LJCommonException("床垫未业务审核,不能业务撤审!");
  2322. }
  2323. mattress.yw_flag = 0;
  2324. mattress.yw_auditingdate = null;
  2325. mattress.yw_auditingrep = string.Empty;
  2326. DbSqlHelper.Update(cmd, mattress, "yw_flag,yw_auditingdate,yw_auditingrep");
  2327. }
  2328. /// <summary>
  2329. /// 产品补充审核
  2330. /// </summary>
  2331. /// <param name="mattressid"></param>
  2332. /// <exception cref="LJCommonException"></exception>
  2333. public void MattressJSAudit(int mattressid)
  2334. {
  2335. var mattress = new u_mattress() { mattressid = mattressid };
  2336. DbSqlHelper.SelectOne(cmd, mattress, "yw_flag,js1_flag");
  2337. if (mattress.js1_flag == 1)
  2338. {
  2339. throw new LJCommonException("床垫已技术1审核,不能技术1审核!");
  2340. }
  2341. if (mattress.yw_flag == 0)
  2342. {
  2343. throw new LJCommonException("床垫未业务审核,不能技术1审核!");
  2344. }
  2345. mattress.js1_flag = 1;
  2346. mattress.js1_auditingdate = context.opdate;
  2347. mattress.js1_auditingrep = context.tokendata.username;
  2348. DbSqlHelper.Update(cmd, mattress, "js1_flag,js1_auditingdate,js1_auditingrep");
  2349. }
  2350. /// <summary>
  2351. /// 产品补充撤审
  2352. /// </summary>
  2353. /// <param name="mattressid"></param>
  2354. /// <exception cref="LJCommonException"></exception>
  2355. public void MattressJSCancelAudit(int mattressid)
  2356. {
  2357. var mattress = new u_mattress() { mattressid = mattressid };
  2358. DbSqlHelper.SelectOne(cmd, mattress, "yw_flag,js1_flag,creatmtrl_flag");
  2359. //if (mattress.creatmtrl_flag == 1)
  2360. //{
  2361. // throw new LJCommonException("床垫已生成产品,不能技术1撤审!");
  2362. //}
  2363. if (mattress.js1_flag == 0)
  2364. {
  2365. throw new LJCommonException("床垫未技术1撤审,不能技术1撤审!");
  2366. }
  2367. mattress.js1_flag = 0;
  2368. mattress.js1_auditingdate = null;
  2369. mattress.js1_auditingrep = string.Empty;
  2370. DbSqlHelper.Update(cmd, mattress, "js1_flag,js1_auditingdate,js1_auditingrep");
  2371. }
  2372. /// <summary>
  2373. /// 清单补充审核
  2374. /// </summary>
  2375. /// <param name="mattressid"></param>
  2376. /// <exception cref="LJCommonException"></exception>
  2377. public void MattressJS2Audit(int mattressid)
  2378. {
  2379. var mattress = new u_mattress() { mattressid = mattressid };
  2380. DbSqlHelper.SelectOne(cmd, mattress, "js2_flag");
  2381. if (mattress.js2_flag == 1)
  2382. {
  2383. throw new LJCommonException("床垫已技术2审核,不能技术2审核!");
  2384. }
  2385. mattress.js2_flag = 1;
  2386. mattress.js2_auditingdate = context.opdate;
  2387. mattress.js2_auditingrep = context.tokendata.username;
  2388. DbSqlHelper.Update(cmd, mattress, "js2_flag,js2_auditingdate,js2_auditingrep");
  2389. }
  2390. /// <summary>
  2391. /// 清单补充撤审
  2392. /// </summary>
  2393. /// <param name="mattressid"></param>
  2394. /// <exception cref="LJCommonException"></exception>
  2395. public void MattressJS2CancelAudit(int mattressid)
  2396. {
  2397. var mattress = new u_mattress() { mattressid = mattressid };
  2398. DbSqlHelper.SelectOne(cmd, mattress, "js2_flag");
  2399. if (mattress.js2_flag == 0)
  2400. {
  2401. throw new LJCommonException("床垫未技术2审核,不能技术2撤审!");
  2402. }
  2403. mattress.js2_flag = 0;
  2404. mattress.js2_auditingdate = null;
  2405. mattress.js2_auditingrep = string.Empty;
  2406. DbSqlHelper.Update(cmd, mattress, "js2_flag,js2_auditingdate,js2_auditingrep");
  2407. }
  2408. /// <summary>
  2409. /// 配对ERP成品
  2410. /// </summary>
  2411. /// <param name="mattress"></param>
  2412. /// <param name="mxlist"></param>
  2413. /// <exception cref="LJCommonException"></exception>
  2414. public void MatchERPMtrldef(u_mattress mattress,List<u_mattress_mx_mtrl> mxlist)
  2415. {
  2416. if(mattress.mattressid <= 0)
  2417. {
  2418. throw new LJCommonException("床垫id有误,请检查!");
  2419. }
  2420. DbSqlHelper.Update(cmd, mattress, "erp_mtrlid,erp_mtrlcode");
  2421. foreach(var mx in mxlist)
  2422. {
  2423. DbSqlHelper.Update(cmd, mx, "erp_mtrlid");
  2424. }
  2425. }
  2426. #endregion
  2427. #region 公式计算通用方法
  2428. private void AddKeyValue(string key, object value, bool isReplace = true)
  2429. {
  2430. key = $"【{key}】";
  2431. if (!replacements.ContainsKey(key))
  2432. {
  2433. replacements.Add(key, value);
  2434. }
  2435. else if (isReplace)
  2436. {
  2437. replacements[key] = value;
  2438. }
  2439. }
  2440. private void AddFormulaKeyValue(string key, string value, bool isReplace = true)
  2441. {
  2442. key = $"【{key}】";
  2443. if (!formula_replacements.ContainsKey(key))
  2444. {
  2445. formula_replacements.Add(key, value);
  2446. }
  2447. else if (isReplace)
  2448. {
  2449. formula_replacements[key] = value;
  2450. }
  2451. }
  2452. /// <summary>
  2453. /// 记录隐藏公式
  2454. /// </summary>
  2455. /// <param name="key"></param>
  2456. /// <param name="value"></param>
  2457. /// <param name="isReplace"></param>
  2458. private void AddFormulaHideKeyValue(string key, string value, bool isReplace = true)
  2459. {
  2460. key = $"【{key}】";
  2461. if (!formula_replacements_hide.ContainsKey(key))
  2462. {
  2463. formula_replacements_hide.Add(key, value);
  2464. }
  2465. else if (isReplace)
  2466. {
  2467. formula_replacements_hide[key] = value;
  2468. }
  2469. }
  2470. private string ConvertToEnglishSymbols(string input)
  2471. {
  2472. input = input.Replace("(", "(")
  2473. .Replace(")", ")")
  2474. .Replace(",", ",")
  2475. .Replace("。", ".")
  2476. .Replace(":", ":")
  2477. .Replace(";", ";")
  2478. .Replace("“", "\"")
  2479. .Replace("”", "\"")
  2480. .Replace("‘", "'")
  2481. .Replace("’", "'");
  2482. return input;
  2483. }
  2484. /// <summary>
  2485. /// 变量公式计算
  2486. /// </summary>
  2487. /// <param name="varname"></param>
  2488. /// <returns></returns>
  2489. private TData CalculateVarFormula(string varname)
  2490. {
  2491. varname = $"【{varname}】";
  2492. if (formula_replacements.ContainsKey(varname)) return Calculate(formula_replacements[varname], varname);
  2493. if (formula_replacements_hide.ContainsKey(varname)) return Calculate(formula_replacements_hide[varname], varname);
  2494. return null;
  2495. }
  2496. private void replaceFormulas(ref string expression)
  2497. {
  2498. bool hasReplace = false;
  2499. foreach (var replacement in formula_replacements)
  2500. {
  2501. if (expression.IndexOf(replacement.Key) > -1)
  2502. {
  2503. expression = expression.Replace(replacement.Key, "(" + replacement.Value + ")");
  2504. hasReplace = true;
  2505. }
  2506. }
  2507. foreach (var replacement in formula_replacements_hide)
  2508. {
  2509. if (expression.IndexOf(replacement.Key) > -1)
  2510. {
  2511. expression = expression.Replace(replacement.Key, "(" + replacement.Value + ")");
  2512. hasReplace = true;
  2513. }
  2514. }
  2515. if (hasReplace)
  2516. {
  2517. replaceFormulas(ref expression);
  2518. }
  2519. }
  2520. private void FormatExpression(ref string expression)
  2521. {
  2522. // 替换相互嵌套的公式
  2523. replaceFormulas(ref expression);
  2524. expression = ConvertToEnglishSymbols(expression);
  2525. // 定义正则表达式模式,匹配包含【】的内容
  2526. string pattern = @"【(.*?)】";
  2527. // 创建正则表达式对象
  2528. Regex regex = new Regex(pattern);
  2529. // 使用正则表达式匹配输入字符串
  2530. MatchCollection matches = regex.Matches(expression);
  2531. var new_replacements = new Dictionary<string, object>();
  2532. foreach (Match match in matches)
  2533. {
  2534. if (replacements.TryGetValue(match.Value, out object value2))
  2535. {
  2536. new_replacements[match.Value] = value2;
  2537. }
  2538. }
  2539. foreach (var replacement in new_replacements)
  2540. {
  2541. expression = expression.Replace(replacement.Key, Convert.ToString(replacement.Value));
  2542. }
  2543. }
  2544. /// <summary>
  2545. /// 公式计算
  2546. /// </summary>
  2547. /// <param name="expression"></param>
  2548. /// <param name="name"></param>
  2549. /// <returns></returns>
  2550. private TData Calculate(string expression, string name = "")
  2551. {
  2552. FormatExpression(ref expression);
  2553. try
  2554. {
  2555. return LJExprParser.Parse(expression).Result;
  2556. }
  2557. catch (Exception ex)
  2558. {
  2559. throw new LJCommonException($"计算{name}公式错误: {ex.Message}");
  2560. }
  2561. }
  2562. /// <summary>
  2563. /// Sql公式计算
  2564. /// </summary>
  2565. /// <param name="expression"></param>
  2566. /// <param name="name"></param>
  2567. /// <returns></returns>
  2568. private object SqlCalculate(string expression, string name = "")
  2569. {
  2570. FormatExpression(ref expression);
  2571. try
  2572. {
  2573. cmd.CommandText = $@"{expression}";
  2574. cmd.Parameters.Clear();
  2575. return cmd.ExecuteScalar();
  2576. }
  2577. catch (Exception ex)
  2578. {
  2579. throw new LJCommonException($"计算{name}公式错误: {ex.Message}");
  2580. }
  2581. }
  2582. #endregion
  2583. #region 导入包装明细
  2584. /// <summary>
  2585. /// 导入 2-按包装方式 的公式
  2586. /// </summary>
  2587. /// <param name="packtype">包装方式</param>
  2588. /// <param name="dw_2">结果导出</param>
  2589. public void wf_import_bz(int packtype, ref List<u_mattress_mx_mtrl> dw_2)
  2590. {
  2591. var selectStr = @"
  2592. SELECT formulaid
  2593. ,formulakind
  2594. ,formulatype
  2595. ,sortcode
  2596. ,if_mtrl
  2597. ,formula
  2598. ,usetype
  2599. ,if_packtype0
  2600. ,if_packtype1
  2601. ,if_packtype2
  2602. ,default_mtrlid
  2603. ,createtime
  2604. ,createby
  2605. ,useformula
  2606. ,gydscrp
  2607. ,mtrltype
  2608. FROM u_mattress_formula";
  2609. var outFields = "formulaid, formulakind, formulatype, sortcode, if_mtrl, formula, usetype, if_packtype0, if_packtype1, if_packtype2, default_mtrlid, createtime, createby, useformula, gydscrp, mtrltype";
  2610. var whereList = new List<string>();
  2611. whereList.Add("u_mattress_formula.formulatype IN (0, 1, 2, 3, 99, 104)");
  2612. whereList.Add("u_mattress_formula.usetype = @usetype");
  2613. var param = new Dictionary<string, object>();
  2614. // 导入 2-按包装方式 的公式
  2615. var mattressFormulaList = new List<u_mattress_formula>();
  2616. param.Clear();
  2617. param.Add("@usetype", 2);
  2618. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), param, "formulatype, sortcode", outFields, 0, 0, mattressFormulaList);
  2619. foreach (var mx in mattressFormulaList)
  2620. {
  2621. if (packtype == 0 && mx.if_packtype0 != 1) continue;
  2622. if (packtype == 1 && mx.if_packtype1 != 1) continue;
  2623. if (packtype == 2 && mx.if_packtype2 != 1) continue;
  2624. var newDw2 = new u_mattress_mx_mtrl();
  2625. AutoInit.AutoInitS(newDw2);
  2626. if (mx.if_mtrl > 1)
  2627. {
  2628. newDw2.addmx = "+";
  2629. newDw2.delmx = "-";
  2630. }
  2631. newDw2.formulatype = mx.formulatype;
  2632. newDw2.if_mtrl = mx.if_mtrl;
  2633. newDw2.formulaid = mx.formulaid;
  2634. newDw2.sortcode = mx.sortcode;
  2635. newDw2.formulakind = mx.formulakind;
  2636. newDw2.formula = mx.formula;
  2637. newDw2.useformula = mx.useformula;
  2638. newDw2.gydscrp = mx.gydscrp;
  2639. dw_2.Add(newDw2);
  2640. }
  2641. }
  2642. #endregion
  2643. #region 明细排序
  2644. /// <summary>
  2645. /// 明细排序
  2646. /// </summary>
  2647. /// <param name="dw_2"></param>
  2648. public void wf_sort_mx(ref List<u_mattress_mx_mtrl> dw_2)
  2649. {
  2650. // u_mattress_formula_formulatype A xu A u_mattress_formula_sortcode A u_mattress_mx_mtrl_formulaid A
  2651. dw_2.Sort((a, b) =>
  2652. {
  2653. if (a.formulatype != b.formulatype)
  2654. {
  2655. return a.formulatype.Value.CompareTo(b.formulatype.Value);
  2656. }
  2657. if (a.xu != b.xu)
  2658. {
  2659. return a.xu.Value.CompareTo(b.xu.Value);
  2660. }
  2661. if (a.sortcode != b.sortcode)
  2662. {
  2663. return a.sortcode.CompareTo(b.sortcode);
  2664. }
  2665. int result = GetFormulakindOrder(a.formulakind).CompareTo(GetFormulakindOrder(b.formulakind));
  2666. if (result != 0)
  2667. {
  2668. return result;
  2669. }
  2670. return a.formulaid.Value.CompareTo(b.formulaid.Value);
  2671. });
  2672. }
  2673. #endregion
  2674. // 普通大侧特殊排序
  2675. private int GetFormulakindOrder(int? formulakind)
  2676. {
  2677. switch (formulakind)
  2678. {
  2679. case 2: return 1;
  2680. case 82: return 2;
  2681. case 42: return 3;
  2682. case 52: return 4;
  2683. case 62: return 5;
  2684. case 72: return 6;
  2685. default: return int.MaxValue;
  2686. }
  2687. }
  2688. #region 获取物料信息
  2689. public void wf_mtrl_fine(List<int> arg_mtrlid, int arg_pricelistid, ref List<u_mtrl_price> mtrlList)
  2690. {
  2691. var selectStr = @"
  2692. SELECT
  2693. u_mtrl_price.mtrlid,
  2694. u_mtrl_price.name,
  2695. isnull(u_mtrl_price_pricelist.price,0) as price,
  2696. u_mtrl_price.gram_weight,
  2697. u_mtrl_price.cloth_width,
  2698. u_mtrl_price.if_inputqty,
  2699. u_mtrl_price.priceunit,
  2700. u_mtrl_price.shrinkage,
  2701. isnull(u_mtrl_price_pricelist.price_formula,0) as price_formula,
  2702. isnull(u_mtrl_price_pricelist.qty_formula,0) as qty_formula,
  2703. u_mtrl_price.if_areaprice,
  2704. u_mtrl_price.thickness
  2705. FROM u_mtrl_price inner join u_mtrl_price_pricelist on
  2706. u_mtrl_price.mtrlid = u_mtrl_price_pricelist.mtrlid";
  2707. var outFields = "mtrlid, name, price, gram_weight, cloth_width, if_inputqty, priceunit, shrinkage, price_formula, qty_formula, if_areaprice, thickness";
  2708. var whereList = new List<string>();
  2709. whereList.Add("u_mtrl_price.mtrlid IN (" + string.Join(",", arg_mtrlid) + ")");
  2710. whereList.Add("u_mtrl_price_pricelist.pricelistid = @arg_pricelistid");
  2711. var param = new Dictionary<string, object>();
  2712. param.Clear();
  2713. param.Add("@arg_pricelistid", arg_pricelistid);
  2714. DbSqlHelper.SelectJoin(cmd, selectStr, ListEx.GetWhereStr(whereList), param, "", outFields, 0, 0, mtrlList);
  2715. }
  2716. #endregion
  2717. #region 获取包装默认物料
  2718. /// <summary>
  2719. /// 获取包装默认物料
  2720. /// </summary>
  2721. /// <param name="dw_2"></param>
  2722. public void wf_default_mtrlid(int pricelistid, ref List<u_mattress_mx_mtrl> dw_2)
  2723. {
  2724. // 导入 2-按包装方式 的公式
  2725. var mtrlPriceList = new List<u_mtrl_price>();
  2726. wf_mtrl_fine(new List<int> { 46804, 46809, 46811, 46817, 46872 }, pricelistid, ref mtrlPriceList);
  2727. foreach (var mx in dw_2)
  2728. {
  2729. var _mtrlid = 0;
  2730. if (mx.formulakind == 16)
  2731. {
  2732. //默认 pe kind = 16 默认 10C PE袋 mtrlid 46804
  2733. _mtrlid = 46804;
  2734. }
  2735. else if (mx.formulakind == 17)
  2736. {
  2737. //默认 外层pe kind = 17 默认 20C mtrlid 46809
  2738. _mtrlid = 46809;
  2739. }
  2740. else if (mx.formulakind == 18)
  2741. {
  2742. //默认 pvc kind = 18 默认 15C mtrlid 46811
  2743. _mtrlid = 46811;
  2744. }
  2745. else if (mx.formulakind == 19)
  2746. {
  2747. //默认 卷包外包装 kind = 19 默认 彩箱 32*32 46817
  2748. _mtrlid = 46817;
  2749. }
  2750. else if (mx.formulakind == 27)
  2751. {
  2752. //默认 拉手脚轮 kind = 27 默认 46872
  2753. _mtrlid = 46872;
  2754. }
  2755. var mtrlItm = mtrlPriceList.Where((itm) => itm.mtrlid == _mtrlid).ToList();
  2756. if (mtrlItm.Count > 0)
  2757. {
  2758. mx.mtrlid = mtrlItm[0].mtrlid;
  2759. mx.mtrlname = mtrlItm[0].name;
  2760. mx.price = mtrlItm[0].price;
  2761. mx.gram_weight = mtrlItm[0].gram_weight;
  2762. mx.cloth_width = mtrlItm[0].cloth_width;
  2763. mx.if_inputqty = mtrlItm[0].if_inputqty;
  2764. mx.priceunit = mtrlItm[0].priceunit;
  2765. mx.shrinkage = mtrlItm[0].shrinkage;
  2766. mx.qty = 1;
  2767. if (!string.IsNullOrEmpty(mtrlItm[0].price_formula)) mx.formula = mtrlItm[0].price_formula;
  2768. }
  2769. }
  2770. }
  2771. #endregion
  2772. #region 获取非包装默认物料
  2773. /// <summary>
  2774. /// 获取非包装默认物料
  2775. /// </summary>
  2776. /// <param name="dw_2"></param>
  2777. public void wf_default_mtrlid_notbz(int pricelistid, ref List<u_mattress_mx_mtrl> dw_2)
  2778. {
  2779. foreach (var mx in dw_2)
  2780. {
  2781. var matterssformula = new u_mattress_formula() { formulaid = mx.formulaid };
  2782. if (DbSqlHelper.SelectOne(cmd, matterssformula, "default_mtrlid") != 1 || matterssformula.default_mtrlid.Value == 0) continue;
  2783. // 导入 2-按包装方式 的公式
  2784. var mtrlItm = new List<u_mtrl_price>();
  2785. wf_mtrl_fine(new List<int> { matterssformula.default_mtrlid.Value }, pricelistid, ref mtrlItm);
  2786. if (mtrlItm.Count > 0)
  2787. {
  2788. mx.mtrlid = mtrlItm[0].mtrlid;
  2789. mx.mtrlname = mtrlItm[0].name;
  2790. mx.price = mtrlItm[0].price;
  2791. mx.gram_weight = mtrlItm[0].gram_weight;
  2792. mx.cloth_width = mtrlItm[0].cloth_width;
  2793. mx.if_inputqty = mtrlItm[0].if_inputqty;
  2794. mx.priceunit = mtrlItm[0].priceunit;
  2795. mx.shrinkage = mtrlItm[0].shrinkage;
  2796. mx.qty = 1;
  2797. if (!string.IsNullOrEmpty(mtrlItm[0].price_formula)) mx.formula = mtrlItm[0].price_formula;
  2798. }
  2799. }
  2800. }
  2801. #endregion
  2802. #region 保存半成品部件
  2803. public void SaveMattressBcp(u_semi_finished_product mattress)
  2804. {
  2805. var dtNow = DateTime.Now;
  2806. var fields = @"billdate,semi_finished_type,semi_finished_code,semi_finished_name,dscrp,production_size,hemming_process,
  2807. hemmed_size,shrinkage_rate,elongation_rate,opemp,opdate,auditemp,auditdate";
  2808. var fieldsMx = "billid,printid,mtrlid,formulaid,chastr,thickness,qty,erp_mtrlid,usenum,usedenom";
  2809. if (mattress.billid <= 0)
  2810. {
  2811. //新建
  2812. fields += ",billid,billcode";
  2813. mattress.opdate = dtNow;
  2814. mattress.opemp = context.tokendata.username;
  2815. mattress.billid = BllHelper.GetID(cmd, "u_semi_finished_product");
  2816. switch (mattress.semi_finished_type)
  2817. {
  2818. case 901:
  2819. mattress.billcode = "JM";
  2820. break;
  2821. case 902:
  2822. mattress.billcode = "JD";
  2823. break;
  2824. case 903:
  2825. mattress.billcode = "BC";
  2826. break;
  2827. case 904:
  2828. mattress.billcode = "XC";
  2829. break;
  2830. case 905:
  2831. mattress.billcode = "VC";
  2832. break;
  2833. }
  2834. // 编号-年月日+流水
  2835. mattress.billcode = $"{mattress.billcode}-{dtNow.ToString("yyyyMMdd")}{(mattress.billid.Value % 10000).ToString("D4")}";
  2836. DbSqlHelper.Insert(cmd, "u_semi_finished_product", null, mattress, fields);
  2837. }
  2838. else
  2839. {
  2840. //修改
  2841. cmd.CommandText = @"DELETE FROM u_semi_finished_product_mx WHERE billid = @billid";
  2842. cmd.Parameters.Clear();
  2843. cmd.Parameters.AddWithValue("@billid", mattress.billid);
  2844. cmd.ExecuteNonQuery();
  2845. DbSqlHelper.Update(cmd, "u_semi_finished_product", null, mattress, "billid", fields);
  2846. }
  2847. var cnt = 0;
  2848. foreach (var mx in mattress.mxlist)
  2849. {
  2850. AutoInit.AutoInitS(cmd, mx);
  2851. mx.billid = mattress.billid;
  2852. mx.printid = ++cnt;
  2853. DbSqlHelper.Insert(cmd, "u_semi_finished_product_mx", null, mx, fieldsMx);
  2854. }
  2855. var hisprice = new u_his_price
  2856. {
  2857. bednetid_mattressid = mattress.billid,
  2858. typeid = 2,
  2859. cmpdate = dtNow,
  2860. cmpemp = context.tokendata.username,
  2861. nottax_dept_cost = 0,
  2862. dept_cost = 0,
  2863. foreign_cost = 0
  2864. };
  2865. var fieldsHs = "bednetid_mattressid, typeid, cmpdate, cmpemp, nottax_dept_cost, dept_cost, foreign_cost";
  2866. DbSqlHelper.Insert(cmd, "u_his_price", null, hisprice, fieldsHs);
  2867. }
  2868. #endregion
  2869. }
  2870. }