ctrlOrderLine.cs 80 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Drawing;
  5. using System.Data;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using CoreFS.CA06;
  10. using Core.Mes.Client.Comm.Server;
  11. using System.Diagnostics;
  12. using Core.Mes.Client.Comm.Tool;
  13. using Infragistics.Win.UltraWinGrid;
  14. using System.Collections;
  15. namespace Core.StlMes.Client.SaleOrder
  16. {
  17. public partial class ctrlOrderLine : UserControl
  18. {
  19. public delegate void HUpdateOrderDeliveryDesc(DataSet orderLine);
  20. public event HUpdateOrderDeliveryDesc UpdateOrderDeliveryDesc;
  21. /// <summary>
  22. /// 合同行三个附加要求
  23. /// </summary>
  24. /// <param name="type">true,false,Clear</param>
  25. public delegate void SetOrderLineYesNo(string type);
  26. public event SetOrderLineYesNo SetOrderLineYesNoType;
  27. public delegate bool HCommitOrderLineRow(DataSet orderLine, string CommandType);
  28. public event HCommitOrderLineRow CommitOrderLineRow;
  29. OpeBase ob = new OpeBase();
  30. DataSet orderDerlivery = new DataSet();
  31. DataRow orderHead = null;
  32. DataTable orderline = new DataTable("SLM_ORDER_LINE");
  33. DataSet ctrlLineValue = new DataSet();
  34. DataRow pscSelectRow = null;//订货产品
  35. private string dlyTime = "";
  36. public string DlyTime
  37. {
  38. get { return dlyTime; }
  39. set { dlyTime = value; }
  40. }
  41. private string dlyAddress = "";
  42. public string DlyAddress
  43. {
  44. get { return dlyAddress; }
  45. set { dlyAddress = value; }
  46. }
  47. /// <summary>
  48. /// 产品规范
  49. /// </summary>
  50. public DataRow PscSelectRow
  51. {
  52. get { return pscSelectRow; }
  53. set { pscSelectRow = value; }
  54. }
  55. DataRow lenOrderRow = null;//长度产品
  56. DataTable technologyRow = new DataTable("SLM_TECHOLG_LINE");//技术特殊标准
  57. DataTable technologyRowAsk = new DataTable("SLM_TECHOLG_LINE_ASK");//附加要求项
  58. string saveUpdateVal = "";//保存是否修改信息
  59. string yesNotype = "";//合同行YesNo
  60. UltraGridRow reRow = null;
  61. /// <summary>
  62. /// 最终用户
  63. /// </summary>
  64. public UltraGridRow ReRow
  65. {
  66. get { return reRow; }
  67. set { reRow = value; }
  68. }
  69. public ctrlOrderLine()
  70. {
  71. InitializeComponent();
  72. }
  73. /// <summary>
  74. /// 清空交货发运要求、技术特殊要求、附加要求描述。
  75. /// </summary>
  76. public void setDelVry()
  77. {
  78. ultraTextGetDelVry.Text = "";
  79. ultraTextEdiAsk.Text = "";
  80. labDly.Text = "";
  81. }
  82. public void editLabDly()
  83. {
  84. labDly.ReadOnly = false;
  85. }
  86. public void updateDlyAddVisible(bool b)
  87. {
  88. ultraTextGetDelVry.ButtonsLeft["UpdateDlyAdd"].Visible = b;
  89. }
  90. private string labDlyTxt = "";
  91. public string LabDlyTxt
  92. {
  93. get { return labDly.Text; }
  94. set { labDly.Text = value; }
  95. }
  96. string customerno = ""; //销售组织
  97. string saleorg = "100204"; //用途类型
  98. string managno = ""; //管理卡号
  99. string order = ""; //合同号
  100. string orderSeq = ""; //合同行号
  101. string psc = "";
  102. string pesc_code = "";
  103. private int iTrueFlases = 0;
  104. private int iTrueFlase = 0;
  105. private string shRow = "";
  106. public string ShRow
  107. {
  108. get { return shRow; }
  109. set { shRow = value; }
  110. }
  111. double weight = 0;
  112. double jg_weight = 0;
  113. public DataSet CtrlLineValue
  114. {
  115. get
  116. {
  117. try
  118. {
  119. if (!IsDesignMode())
  120. {
  121. if (pscSelectRow == null)
  122. {
  123. if (string.IsNullOrEmpty(orderHead["PSC"].ToString()))
  124. {
  125. MessageUtil.ShowTips("请选择一条订货产品信息!");
  126. return null;
  127. }
  128. }
  129. if (ultraComboSpec.SelectedItem == null)
  130. {
  131. MessageUtil.ShowTips("请选择产品规格!");
  132. return null;
  133. }
  134. //规格
  135. if (comboSpecOrderIght.Value == null)
  136. {
  137. MessageUtil.ShowTips("请选择订货规格!");
  138. return null;
  139. }
  140. if (string.IsNullOrEmpty(comBoModel.Text))
  141. {
  142. MessageUtil.ShowTips("扣型不允许为空,请维护:" + comBoModel.Text + "。");
  143. return null;
  144. }
  145. if (lenOrderRow == null)
  146. {
  147. //if (string.IsNullOrEmpty(orderHead["LEN_NO"].ToString()))
  148. //{
  149. // MessageUtil.ShowTips("请选择一条长度信息!");
  150. // return null;
  151. //}
  152. //这里为了导入的合同在界面不报错才注释掉 进而采用下面不是100%严谨的方法判断长度是否维护
  153. }
  154. if (ultraTextEditorLen.Text.Trim() == "")
  155. {
  156. MessageUtil.ShowWarning("请选择一条长度信息!");
  157. return null;
  158. }
  159. if (comboUNIT.Text.Trim() == "")
  160. {
  161. MessageUtil.ShowWarning("请选择订货计量单位!");
  162. return null;
  163. }
  164. if (cmbOutPutStd.SelectedItem == null)
  165. {
  166. MessageUtil.ShowTips("请选择输出标准号!");
  167. return null;
  168. }
  169. //新增保总长逻辑
  170. //if (comboUNIT.Text.Trim() == "米" || comboUNIT.Text.Trim() == "英尺"||comboUNIT.Text.Trim()=="支")
  171. //{
  172. // if (numTag.Text.Trim() == "" || Convert.ToDouble(numTag.Text.Trim() == "" ? "0" : numTag.Text.Trim()) <= 0)
  173. // {
  174. // MessageUtil.ShowWarning("请输入保总长!");
  175. // return null;
  176. // }
  177. //}
  178. if (pscSelectRow != null && pscSelectRow.Table.Rows.Count > 0)
  179. {
  180. //判断SLM_ORDER_LINE表是否有记录,没有新增/有修改
  181. orderHead["PSC"] = pscSelectRow["PSC"];
  182. orderHead["PSC_DESC"] = pscSelectRow["PSC_DESC"];
  183. orderHead["PRD_CLS"] = pscSelectRow["PRODUC_STYLE"];
  184. orderHead["PRODUCCODE"] = pscSelectRow["PRODUCCODE"];
  185. orderHead["PRODUCNAME"] = pscSelectRow["PRODUCNAME"];
  186. orderHead["STD_CODE"] = pscSelectRow["STD_CODE"];
  187. orderHead["STD_NAME"] = pscSelectRow["STD_NAME"];
  188. orderHead["STEELCODE"] = pscSelectRow["STEELCODE"];
  189. orderHead["STEELNAME"] = pscSelectRow["STEELNAME"];
  190. orderHead["MSC"] = pscSelectRow["MSC"];
  191. orderHead["MSC_DESC"] = pscSelectRow["MSC_DESC"];
  192. orderHead["MSC_STYLE"] = pscSelectRow["MSC_STYLE"];
  193. orderHead["USE_CODE"] = pscSelectRow["USE_CODE"];
  194. orderHead["USE_DESC"] = pscSelectRow["USE_DESC"];
  195. orderHead["STD_STYLE"] = pscSelectRow["STD_STYLE"];
  196. orderHead["STD_STYLE_DESC"] = pscSelectRow["STD_STYLE_DESC"];
  197. }
  198. if (lenOrderRow != null && lenOrderRow.Table.Rows.Count > 0)
  199. {
  200. orderHead["LEN_NO"] = lenOrderRow["LEN_NO"].ToString();
  201. orderHead["LEN_DESC"] = lenOrderRow["LEN_DESC"].ToString();
  202. orderHead["LEN_UNIT"] = lenOrderRow["LEN_UNIT"].ToString();
  203. orderHead["LEN_MIN"] = lenOrderRow["LEN_MIN"].ToString();
  204. orderHead["LEN_MAX"] = lenOrderRow["LEN_MAX"].ToString();
  205. orderHead["SHRT_LEN_RATO"] = lenOrderRow["SHRT_LEN_RATO"].ToString();
  206. orderHead["SHORTEST"] = lenOrderRow["SHORTEST"].ToString();
  207. orderHead["LONG_LEN_RATO"] = lenOrderRow["LONG_LEN_RATO"].ToString();
  208. orderHead["LONGEST"] = lenOrderRow["LONGEST"].ToString();
  209. orderHead["SHRT_STOVE"] = lenOrderRow["SHRT_STOVE"].ToString();
  210. orderHead["AVG_LEN_MIN"] = lenOrderRow["AVG_LEN_MIN"].ToString();
  211. orderHead["AVG_LEN_MAX"] = lenOrderRow["AVG_LEN_MAX"].ToString();
  212. orderHead["DIFRNC_LEN_MAX"] = lenOrderRow["DIFRNC_LEN_MAX"].ToString();
  213. orderHead["SIGL_LEN"] = lenOrderRow["SIGL_LEN"].ToString();
  214. orderHead["ENDLEN_SPECSTD"] = lenOrderRow["ENDLEN_SPECSTD"].ToString();
  215. }
  216. if (reRow != null)
  217. {
  218. orderHead["FINAL_USER"] = reRow.Cells["CUSTOMER_NO"].Value.ToString();
  219. orderHead["FINAL_USER_DESC"] = reRow.Cells["CUSTOMER_NM"].Value.ToString();
  220. orderHead["CUSTOMER_NO"] = reRow.Cells["CUSTOMER_NO"].Value.ToString();
  221. }
  222. else
  223. {
  224. if (textFinalUser.Text.Trim() == "N/A" || textFinalUser.Text.Trim() == "" || textFinalUser.Text.Trim() == "/")
  225. {
  226. orderHead["FINAL_USER"] = "/";
  227. orderHead["FINAL_USER_DESC"] = "/";
  228. orderHead["CUSTOMER_NO"] = "/";
  229. }
  230. else
  231. {
  232. orderHead["FINAL_USER"] = textFinalUser.Tag.ToString2();
  233. orderHead["FINAL_USER_DESC"] = textFinalUser.Text.Trim();
  234. orderHead["CUSTOMER_NO"] = textFinalUser.Tag.ToString2();
  235. }
  236. }
  237. string code = ultraComboSpec.Value.ToString();
  238. DataTable db = (DataTable)ultraComboSpec.DataSource;
  239. DataRow[] dr = db.Select("SPEC_CODE = '" + code + "'", "");
  240. if (dr.Length > 0)
  241. {
  242. orderHead["ORDER_SPEC_CODE"] = comboSpecOrderIght.Value.ToString();
  243. orderHead["ORDER_SPEC_DESC"] = comboSpecOrderIght.Text.Trim();
  244. orderHead["SPEC_CODE"] = dr[0]["SPEC_CODE"].ToString();
  245. orderHead["SPEC_NAME"] = dr[0]["SPEC_NAME"].ToString();
  246. orderHead["DIMATER"] = dr[0]["DIMATER"].ToString() == "" ? "0" : dr[0]["DIMATER"].ToString();
  247. orderHead["HEIGHT"] = dr[0]["HEIGHT"].ToString() == "" ? "0" : dr[0]["HEIGHT"].ToString();
  248. pesc_code = dr[0]["SPEC_CODE"].ToString();
  249. code = "Yes";
  250. }
  251. if (!code.Equals("Yes"))
  252. {
  253. MessageUtil.ShowTips("订货规格不存在,请维护:" + comboSpecOrderIght.Value.ToString() + "。");
  254. return null;
  255. }
  256. //发货交运要求
  257. orderHead["DELVRY_DESC"] = ultraTextGetDelVry.Text;
  258. if (ctrlLineValue.Tables["Main"] != null)
  259. {
  260. for (int i = 0; i < ctrlLineValue.Tables["Main"].Rows.Count; i++)
  261. {
  262. orderHead["DELVRY_EDATE"] = ctrlLineValue.Tables["Main"].Rows[i]["DELVRY_EDATE"].ToString();
  263. orderHead["TRANS_DESC"] = ctrlLineValue.Tables["Main"].Rows[i]["TRANSIT_PLAN"].ToString();
  264. }
  265. }
  266. if (ctrlLineValue.Tables["Test"] != null)
  267. {
  268. for (int i = 0; i < ctrlLineValue.Tables["Test"].Rows.Count; i++)
  269. {
  270. orderHead["TRANS_PRICE"] = ctrlLineValue.Tables["Test"].Rows[i]["TRANSIT_LN_MNY"].ToString();
  271. }
  272. }
  273. //技术要求
  274. if (technologyRow.Rows.Count > 0)
  275. {
  276. if (labDly.Tag != null)
  277. {
  278. string[] arr = (string[])labDly.Tag;
  279. string alphaNo = arr[0];
  280. string msc = arr[1];
  281. DataTable mscDt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderLine.getMscInfo", new object[] { msc }, this.ob);
  282. if (mscDt != null && mscDt.Rows.Count > 0)
  283. {
  284. orderHead["MSC"] = msc;
  285. orderHead["MSC_DESC"] = mscDt.Rows[0]["MSC_DESC"].ToString();
  286. orderHead["USE_CODE"] = mscDt.Rows[0]["USE_CODE"].ToString();
  287. orderHead["USE_DESC"] = mscDt.Rows[0]["USE_DESC"].ToString();
  288. orderHead["MSC_STYLE"] = mscDt.Rows[0]["MSC_STYLE"].ToString();
  289. }
  290. orderHead["CUST_ALPHA_NO"] = alphaNo;
  291. orderHead["ORDER_SPECIAL_DESC"] = technologyRow.Rows[0]["ORDER_SPECIAL_DESC"];
  292. }
  293. }
  294. //附加要求
  295. if (technologyRowAsk.Rows.Count > 0)
  296. {
  297. orderHead["ADD_ASK_NO"] = ultraTextEdiAsk.Tag == null ? "" : ultraTextEdiAsk.Tag.ToString();
  298. orderHead["ORDER_ADD_DESC"] = ultraTextEdiAsk.Text;
  299. }
  300. //扣型
  301. /*DataTable comBoMd = (DataTable)comBoModel.DataSource;
  302. bool combool = false;
  303. for (int i = 0; i < comBoMd.Rows.Count; i++)
  304. {
  305. if (comBoMd.Rows[i]["MODEL_DESC"].Equals(comBoModel.Text))
  306. {
  307. combool = true;
  308. }
  309. }*/
  310. if (comBoModel.SelectedItem == null)
  311. {
  312. MessageUtil.ShowTips("扣型不存在,请维护:" + comBoModel.Text + "。");
  313. return null;
  314. }
  315. if (comBoModel.Text.Equals("/"))
  316. {
  317. orderHead["MODEL_CODE"] = "C001";
  318. orderHead["MODEL_DESC"] = comBoModel.Text;
  319. comBoModel.Value = "C001";
  320. }
  321. else
  322. {
  323. orderHead["MODEL_CODE"] = comBoModel.Value.ToString();
  324. orderHead["MODEL_DESC"] = comBoModel.Text;
  325. }
  326. //交货量差
  327. orderHead["DELVRY_RANGE_TPE"] = comboPercentage.Text.ToString();
  328. orderHead["DELVRY_RANGE_MIN"] = Convert.ToDecimal(numericWTMax.Value == System.DBNull.Value ? "0" : numericWTMax.Value).ToString();
  329. orderHead["DELVRY_RANGE_MAX"] = Convert.ToDecimal(numericWTMin.Value == System.DBNull.Value ? "0" : numericWTMin.Value).ToString();
  330. //订货量
  331. orderHead["ORDER_QTY"] = Convert.ToDecimal(NumWt.Value == System.DBNull.Value ? "0" : NumWt.Value).ToString();
  332. //保总长
  333. orderHead["ORD_ENSU_TOTL_LEN"] = Convert.ToDecimal(numTag.Value.ToString() == "" ? 0 : numTag.Value).ToString();
  334. //生产吨数(根据估算重量计算)
  335. OrderFunction.GetPrdctWgt(ref weight, Convert.ToDouble(Convert.ToDecimal(NumWt.Value == System.DBNull.Value ? "0" : NumWt.Value).ToString()), comboUNIT.Text.Trim(), pesc_code, this.ob);
  336. if (orderHead["PRODUCCODE"].Equals("S000012"))
  337. {
  338. OrderFunction.GetWgt_JG(ref jg_weight, "S000012", orderHead["STD_CODE"].ToString(),
  339. orderHead["STD_STYLE"].ToString(), orderHead["STEELCODE"].ToString(), pesc_code, comBoModel.Value.ToString(), this.ob);
  340. orderHead["PRDCT_WGT"] = jg_weight * Convert.ToDouble(Convert.ToDecimal(NumWt.Value == System.DBNull.Value ? "0" : NumWt.Value).ToString());
  341. }
  342. else
  343. {
  344. orderHead["PRDCT_WGT"] = weight;
  345. }
  346. orderHead["ORDER_UNIT"] = comboUNIT.Text;
  347. //订货单价
  348. orderHead["ORDER_PRICE"] = textPrice.Text;
  349. //外购坯(1:允许;0:不允许)
  350. orderHead["OUTS_BILLET_FL"] = ultraCheckWGP.Value == null ? " " : ultraCheckWGP.Value.ToString();
  351. orderHead["OUTS_BILLET_DESC"] = ultraCheckWGP.Text == null ? " " : ultraCheckWGP.Text;
  352. //外购管(1:允许;0:不允许)
  353. orderHead["OUTS_STL_PIPE_FL"] = ultraCheckWGG.Value == null ? " " : ultraCheckWGG.Value.ToString();
  354. orderHead["OUTS_STL_PIPE_DESC"] = ultraCheckWGG.Text == null ? " " : ultraCheckWGG.Text;
  355. //ASSEL(1:允许;0:不允许)
  356. orderHead["ASSEL_FL"] = ultraCheckASL.Checked == true ? "1" : "0";
  357. //监制要求(1:允许;0:不允许)
  358. orderHead["PRODUCER_FL"] = ultraCheckProducer.Checked == true ? "1" : "0";
  359. //MPS_FL(1:允许;0:不允许)
  360. orderHead["MPS_FL"] = ultraCheckMps_Fl.Checked == true ? "1" : "0";
  361. string aw = "";
  362. if (ultraCheckASL.Checked)
  363. aw = "A";
  364. if (ultraCheckWGP.SelectedItem != null && ultraCheckWGP.Value.ToString() == "121801")
  365. aw = "OW";
  366. if (ultraCheckASL.Checked)
  367. {
  368. if (ultraCheckWGP.SelectedItem != null && ultraCheckWGP.Value.ToString() == "121801")
  369. aw = "AW";
  370. }
  371. if (ultraCheckWGG.SelectedItem != null && ultraCheckWGG.Value.ToString2() == "121902")
  372. {
  373. aw = "CW";
  374. }
  375. if (ultraCheckWGG.SelectedItem != null && ultraCheckWGG.Value.ToString2() == "121903")
  376. {
  377. aw = "BW";
  378. }
  379. orderHead["AW"] = aw;
  380. orderHead["QUALITY_USER"] = cmbQualityUser.Value.ToString2();
  381. orderHead["QUALITY_USER_DESC"] = cmbQualityUser.Text.Trim();
  382. orderHead["MAN_INSPECTION"] = cmbInspection.SelectedItem == null ? "1" : cmbInspection.Value.ToString();
  383. orderHead["OUTPUT_STD_NO"] = cmbOutPutStd.SelectedItem == null ? "" : cmbOutPutStd.Value.ToString();
  384. orderHead["PROJECT_NO"] = txtProjectNo.Text.Trim();
  385. orderHead["OUTBOUND_CALCULATE"] = cmbOutboundCalculate.SelectedItem == null ? "0" : cmbOutboundCalculate.Value.ToString2();
  386. orderHead["ORDER_TEAM"] = cmborderteam.SelectedItem == null ? "0" : cmborderteam.Value.ToString2();
  387. orderHead["MODE_OF_TRANSPORT"] = cmbmodeoftransport.Value.ToString2();
  388. for (int i = 0; i < ctrlLineValue.Tables.Count; i++)
  389. {
  390. if (ctrlLineValue.Tables[i].TableName.Equals(orderline.TableName))
  391. {
  392. ctrlLineValue.Tables.Remove(orderline.TableName);
  393. }
  394. }
  395. orderline.Rows.Clear();
  396. orderline.Rows.Add(orderHead.ItemArray);
  397. if (ctrlLineValue.Tables["SLM_ORDER_LINE"] != null)
  398. {
  399. ctrlLineValue.Tables.Remove(orderline.TableName);
  400. }
  401. ctrlLineValue.Tables.Add(orderline.Copy());
  402. }
  403. return ctrlLineValue;
  404. }
  405. catch
  406. {
  407. throw;
  408. }
  409. }
  410. set
  411. {
  412. if (!IsDesignMode())
  413. {
  414. //orderDerlivery 发运要求的集合。
  415. orderDerlivery.Tables.Clear();
  416. lenOrderRow = null;
  417. ctrlLineValue = value;
  418. //赋值交货信息和交货运输方式表
  419. orderDerlivery.Tables.Add(ctrlLineValue.Tables["SLM_ORDER_LINE_DELIVERY"].Copy());
  420. orderDerlivery.Tables.Add(ctrlLineValue.Tables["SLM_ORDER_DELIVERY_TRANSIT"].Copy());
  421. //合同行
  422. DataTable slmorderline = new DataTable();
  423. slmorderline = ctrlLineValue.Tables["orderLineDt"];
  424. //订货产品
  425. ultraTextPSCSelect.Text = slmorderline.Rows[0]["PSC_DESC"].ToString();
  426. orderHead["PSC"] = slmorderline.Rows[0]["PSC"];
  427. psc = slmorderline.Rows[0]["PSC"].ToString();
  428. orderHead["PSC_DESC"] = slmorderline.Rows[0]["PSC_DESC"];
  429. orderHead["PRD_CLS"] = slmorderline.Rows[0]["PRD_CLS"];
  430. orderHead["PRODUCCODE"] = slmorderline.Rows[0]["PRODUCCODE"];
  431. orderHead["PRODUCNAME"] = slmorderline.Rows[0]["PRODUCNAME"];
  432. orderHead["STD_CODE"] = slmorderline.Rows[0]["STD_CODE"];
  433. orderHead["STD_NAME"] = slmorderline.Rows[0]["STD_NAME"];
  434. orderHead["STEELCODE"] = slmorderline.Rows[0]["STEELCODE"];
  435. orderHead["STEELNAME"] = slmorderline.Rows[0]["STEELNAME"];
  436. orderHead["MSC"] = slmorderline.Rows[0]["MSC"];
  437. orderHead["MSC_DESC"] = slmorderline.Rows[0]["MSC_DESC"];
  438. orderHead["MSC_STYLE"] = slmorderline.Rows[0]["MSC_STYLE"];
  439. orderHead["USE_CODE"] = slmorderline.Rows[0]["USE_CODE"];
  440. orderHead["USE_DESC"] = slmorderline.Rows[0]["USE_DESC"];
  441. orderHead["PRDCT_WGT"] = slmorderline.Rows[0]["PRDCT_WGT"];
  442. orderHead["STD_STYLE"] = slmorderline.Rows[0]["STD_STYLE"];
  443. orderHead["STD_STYLE_DESC"] = slmorderline.Rows[0]["STD_STYLE_DESC"];
  444. pesc_code = slmorderline.Rows[0]["SPEC_CODE"].ToString();
  445. //规格
  446. ultraComboSpec.Value = slmorderline.Rows[0]["SPEC_CODE"];
  447. ultraComboSpec.Text = slmorderline.Rows[0]["SPEC_NAME"].ToString();
  448. comboSpecOrderIght.Text = slmorderline.Rows[0]["ORDER_SPEC_DESC"].ToString();
  449. comboSpecOrderIght.Value = slmorderline.Rows[0]["ORDER_SPEC_CODE"];
  450. orderHead["ORDER_SPEC_CODE"] = slmorderline.Rows[0]["ORDER_SPEC_CODE"];
  451. orderHead["ORDER_SPEC_DESC"] = slmorderline.Rows[0]["ORDER_SPEC_DESC"];
  452. orderHead["SPEC_CODE"] = slmorderline.Rows[0]["SPEC_CODE"];
  453. orderHead["SPEC_NAME"] = slmorderline.Rows[0]["SPEC_NAME"];
  454. orderHead["DIMATER"] = slmorderline.Rows[0]["DIMATER"];
  455. orderHead["HEIGHT"] = slmorderline.Rows[0]["HEIGHT"];
  456. //扣型
  457. comBoModel.Text = slmorderline.Rows[0]["MODEL_DESC"].ToString();
  458. comBoModel.Value = slmorderline.Rows[0]["MODEL_CODE"].ToString();
  459. //长度
  460. ultraTextEditorLen.Text = slmorderline.Rows[0]["LEN_DESC"].ToString();
  461. orderHead["LEN_NO"] = slmorderline.Rows[0]["LEN_NO"];
  462. orderHead["LEN_DESC"] = slmorderline.Rows[0]["LEN_DESC"];
  463. orderHead["LEN_UNIT"] = slmorderline.Rows[0]["LEN_UNIT"];
  464. ultraLabel18.Text = slmorderline.Rows[0]["LEN_UNIT"].ToString();
  465. orderHead["LEN_MIN"] = slmorderline.Rows[0]["LEN_MIN"];
  466. orderHead["LEN_MAX"] = slmorderline.Rows[0]["LEN_MAX"];
  467. orderHead["SHRT_LEN_RATO"] = slmorderline.Rows[0]["SHRT_LEN_RATO"];
  468. orderHead["SHORTEST"] = slmorderline.Rows[0]["SHORTEST"];
  469. orderHead["LONG_LEN_RATO"] = slmorderline.Rows[0]["LONG_LEN_RATO"];
  470. orderHead["LONGEST"] = slmorderline.Rows[0]["LONGEST"];
  471. orderHead["SHRT_STOVE"] = slmorderline.Rows[0]["SHRT_STOVE"];
  472. orderHead["AVG_LEN_MIN"] = slmorderline.Rows[0]["AVG_LEN_MIN"];
  473. orderHead["AVG_LEN_MAX"] = slmorderline.Rows[0]["AVG_LEN_MAX"];
  474. orderHead["DIFRNC_LEN_MAX"] = slmorderline.Rows[0]["DIFRNC_LEN_MAX"];
  475. orderHead["SIGL_LEN"] = slmorderline.Rows[0]["SIGL_LEN"];
  476. orderHead["ENDLEN_SPECSTD"] = slmorderline.Rows[0]["ENDLEN_SPECSTD"];//19-10-11 修改成品率消失问题
  477. //订货量
  478. NumWt.Value = slmorderline.Rows[0]["ORDER_QTY"].ToString();
  479. numTag.Value = slmorderline.Rows[0]["ORD_ENSU_TOTL_LEN"].ToString() == "" ? "0" : slmorderline.Rows[0]["ORD_ENSU_TOTL_LEN"].ToString();
  480. comboUNIT.Text = slmorderline.Rows[0]["ORDER_UNIT"].ToString();
  481. orderHead["ORDER_QTY"] = slmorderline.Rows[0]["ORDER_QTY"];
  482. orderHead["ORDER_UNIT"] = slmorderline.Rows[0]["ORDER_UNIT"];
  483. //交货量差
  484. comboPercentage.Text = slmorderline.Rows[0]["DELVRY_RANGE_TPE"].ToString();
  485. numericWTMin.Text = slmorderline.Rows[0]["DELVRY_RANGE_MAX"].ToString();
  486. numericWTMax.Text = slmorderline.Rows[0]["DELVRY_RANGE_MIN"].ToString();
  487. orderHead["DELVRY_RANGE_TPE"] = slmorderline.Rows[0]["DELVRY_RANGE_TPE"];
  488. orderHead["DELVRY_RANGE_MIN"] = slmorderline.Rows[0]["DELVRY_RANGE_MIN"];
  489. orderHead["DELVRY_RANGE_MAX"] = slmorderline.Rows[0]["DELVRY_RANGE_MAX"];
  490. //订货单价
  491. textPrice.Text = slmorderline.Rows[0]["ORDER_PRICE"].ToString();
  492. orderHead["ORDER_PRICE"] = slmorderline.Rows[0]["ORDER_PRICE"];
  493. //外购坯(1:允许;0:不允许)
  494. orderHead["OUTS_BILLET_FL"] = slmorderline.Rows[0]["OUTS_BILLET_FL"];
  495. ultraCheckWGP.Text = slmorderline.Rows[0]["OUTS_BILLET_FL"].ToString();
  496. //外购管(1:允许;0:不允许)
  497. orderHead["OUTS_STL_PIPE_FL"] = slmorderline.Rows[0]["OUTS_STL_PIPE_FL"];
  498. ultraCheckWGG.Text = slmorderline.Rows[0]["OUTS_STL_PIPE_FL"].ToString();
  499. //ASSEL(1:允许;0:不允许)
  500. orderHead["ASSEL_FL"] = slmorderline.Rows[0]["ASSEL_FL"];
  501. orderHead["PRODUCER_FL"] = slmorderline.Rows[0]["PRODUCER_FL"];
  502. orderHead["OUTBOUND_CALCULATE"] = slmorderline.Rows[0]["OUTBOUND_CALCULATE"];
  503. orderHead["ORDER_TEAM"] = slmorderline.Rows[0]["ORDER_TEAM"];
  504. orderHead["MODE_OF_TRANSPORT"] = slmorderline.Rows[0]["MODE_OF_TRANSPORT"];
  505. ultraCheckASL.Checked = Convert.ToBoolean(slmorderline.Rows[0]["ASSEL_FL"]);
  506. ultraCheckProducer.Checked = Convert.ToBoolean(slmorderline.Rows[0]["PRODUCER_FL"]);
  507. ultraCheckMps_Fl.Checked = Convert.ToBoolean(slmorderline.Rows[0]["MPS_FL"]);
  508. //最终用户
  509. this.textFinalUser.Text = slmorderline.Rows[0]["FINAL_USER_DESC"].ToString();
  510. this.textFinalUser.Tag = slmorderline.Rows[0]["FINAL_USER"];
  511. //orderBuyerName = slmorderline.Rows[0]["FINAL_USER"].ToString();
  512. string id = slmorderline.Rows[0]["FINAL_USER"].ToString();
  513. string name = slmorderline.Rows[0]["FINAL_USER"].ToString();
  514. orderHead["FINAL_USER"] = id;
  515. orderHead["FINAL_USER_DESC"] = name;
  516. //发货交运要求
  517. orderHead["DELVRY_DESC"] = slmorderline.Rows[0]["DELVRY_DESC"].ToString();
  518. orderHead["DELVRY_EDATE"] = slmorderline.Rows[0]["DELVRY_EDATE"].ToString();
  519. orderHead["TRANS_DESC"] = slmorderline.Rows[0]["TRANS_DESC"].ToString();
  520. orderHead["TRANS_PRICE"] = slmorderline.Rows[0]["TRANS_PRICE"].ToString();
  521. ultraTextGetDelVry.Text = slmorderline.Rows[0]["DELVRY_DESC"].ToString() + "\r\n";
  522. orderHead["CUST_ALPHA_NO"] = slmorderline.Rows[0]["CUST_ALPHA_NO"];
  523. orderHead["ADD_ASK_NO"] = slmorderline.Rows[0]["ADD_ASK_NO"];
  524. orderHead["ORDER_SPECIAL_DESC"] = slmorderline.Rows[0]["ORDER_SPECIAL_DESC"];
  525. orderHead["ORDER_ADD_DESC"] = slmorderline.Rows[0]["ORDER_ADD_DESC"];
  526. technologyRow.Rows.Clear();
  527. technologyRowAsk.Rows.Clear();
  528. technologyRow.Rows.Add(slmorderline.Rows[0]["CUST_ALPHA_NO"], slmorderline.Rows[0]["ORDER_SPECIAL_DESC"]);
  529. technologyRowAsk.Rows.Add(slmorderline.Rows[0]["ADD_ASK_NO"], slmorderline.Rows[0]["ORDER_ADD_DESC"]);
  530. labDly.Text = slmorderline.Rows[0]["ORDER_SPECIAL_DESC"].ToString();
  531. ultraTextEdiAsk.Text = slmorderline.Rows[0]["ORDER_ADD_DESC"].ToString();
  532. ultraTextEdiAsk.Tag = orderHead["ADD_ASK_NO"] = slmorderline.Rows[0]["ADD_ASK_NO"];
  533. string[] arr = new string[] { "", "" };
  534. arr[0] = slmorderline.Rows[0]["CUST_ALPHA_NO"].ToString();
  535. arr[1] = slmorderline.Rows[0]["MSC"].ToString();
  536. labDly.Tag = arr;
  537. cmbQualityUser.Value = slmorderline.Rows[0]["QUALITY_USER"].ToString();
  538. cmbQualityUser.Text = slmorderline.Rows[0]["QUALITY_USER_DESC"].ToString();
  539. cmbInspection.Text = slmorderline.Rows[0]["MAN_INSPECTION"].ToString();
  540. cmbOutPutStd.Text = slmorderline.Rows[0]["OUTPUT_STD_NO"].ToString();
  541. txtProjectNo.Text = slmorderline.Rows[0]["PROJECT_NO"].ToString();
  542. cmbOutboundCalculate.Text = slmorderline.Rows[0]["OUTBOUND_CALCULATE"].ToString();
  543. cmborderteam.Value = slmorderline.Rows[0]["ORDER_TEAM"].ToString();
  544. cmbmodeoftransport.Value = slmorderline.Rows[0]["MODE_OF_TRANSPORT"].ToString();
  545. }
  546. }
  547. }
  548. /// <summary>
  549. /// 请重新填写订货量,不允许小于发运要求中交货量!
  550. /// </summary>
  551. /// <returns></returns>
  552. public bool deliveryWTQty()
  553. {
  554. if (NumWt.Value != null && NumWt.Value != System.DBNull.Value && order != "")
  555. {
  556. double numwts = Convert.ToDouble(NumWt.Value.ToString());
  557. DataTable wtls = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderDelivery.GetDeliveryWTQty", new Object[] { order }, ob);
  558. if (wtls.Rows.Count != 0)
  559. {
  560. double wtlines = Convert.ToDouble(wtls.Rows[0][0].ToString());
  561. if (numwts < wtlines)
  562. {
  563. NumWt.Value = wtlines;
  564. MessageUtil.ShowWarning("请重新填写订货量,不允许小于发运要求中交货量!");
  565. return false;
  566. }
  567. }
  568. }
  569. return true;
  570. }
  571. private void ultraTextPSCSelect_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  572. {
  573. ultraTextPSCSelect.Clear();
  574. dlgPSCSelect pscSelect = new dlgPSCSelect(ob);
  575. pscSelect.GetPscSelect += new dlgPSCSelect.GetPscSelectHander(pscSelect_GetPscSelect);
  576. pscSelect.ShowDialog();
  577. }
  578. //订货产品
  579. void pscSelect_GetPscSelect(DataRow row)
  580. {
  581. ultraTextPSCSelect.Text = row["PSC_DESC"].ToString();
  582. psc = row["PSC"].ToString();
  583. pscSelectRow = row;
  584. //过滤订货单位 放在这里是因为 valueChange事件在这个之前。
  585. string productCode = "";
  586. if (pscSelectRow != null)
  587. {
  588. productCode = pscSelectRow["PRODUCCODE"].ToString();
  589. }
  590. else
  591. {
  592. productCode = ctrlLineValue.Tables["orderLineDt"].Rows[0]["PRODUCCODE"].ToString();
  593. }
  594. DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.getProductType", new object[] { productCode }, this.ob);
  595. if (dt != null && dt.Rows.Count > 0)
  596. {
  597. string proType = dt.Rows[0][0].ToString();
  598. if (proType == "C" || proType == "D" || proType == "E") //短节+附件 接箍 双工短节 订货单位只有“支”
  599. {
  600. ((DataTable)comboUNIT.DataSource).DefaultView.RowFilter = "";
  601. comboUNIT.Enabled = false;
  602. comboUNIT.Text = "支";
  603. }
  604. else //钢管(管坯) 钢管+接箍
  605. {
  606. comboUNIT.Enabled = true;
  607. ((DataTable)comboUNIT.DataSource).DefaultView.RowFilter = "BASENAME <>'支'";
  608. }
  609. }
  610. }
  611. private void ultraTextEditor3_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  612. {
  613. string lenid = "";
  614. if (lenOrderRow != null)
  615. lenid = lenOrderRow["LEN_NO"].ToString();
  616. else if (ctrlLineValue.Tables["SLM_ORDER_LINE"] != null)
  617. lenid = ctrlLineValue.Tables["SLM_ORDER_LINE"].Rows[0]["LEN_NO"].ToString();
  618. else
  619. lenid = "";
  620. frmOrderLen len = new frmOrderLen(ob);
  621. len.LenNo = lenid;
  622. len.GetOrderLen += new frmOrderLen.GetOrderLenHander(len_GetOrderLen);
  623. len.ShowDialog();
  624. }
  625. //长度
  626. void len_GetOrderLen(DataRow ROrdLen)
  627. {
  628. lenOrderRow = ROrdLen;
  629. ultraTextEditorLen.Text = ROrdLen["LEN_DESC"].ToString();
  630. ultraLabel18.Text = lenOrderRow["len_unit"].ToString();
  631. }
  632. private void textFinalUser_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  633. {
  634. if ("100105".Equals(customerno))
  635. {
  636. saleorg = customerno;
  637. }
  638. FrmOrderBuyer buyer = new FrmOrderBuyer(ob, customerno, saleorg);
  639. buyer.GetOrderBuyer += new FrmOrderBuyer.GetOrderBuyerHander(buyer_GetOrderBuyer);
  640. buyer.ShowDialog();
  641. }
  642. //客户编码和名称
  643. void buyer_GetOrderBuyer(UltraGridRow ugr)
  644. {
  645. if (ugr != null)
  646. {
  647. reRow = ugr;
  648. textFinalUser.Tag = ugr.Cells["CUSTOMER_NO"].Value.ToString();
  649. textFinalUser.Text = ugr.Cells["CUSTOMER_NM"].Value.ToString();
  650. if (cmbQualityUser.Text != "")
  651. {
  652. cmbQualityUser.Value = "122603";
  653. }
  654. }
  655. else
  656. {
  657. textFinalUser.Tag = "";
  658. this.textFinalUser.Text = "";
  659. }
  660. }
  661. private void ctrlOrderLine_Load(object sender, EventArgs e)
  662. {
  663. technologyRow.Columns.Add("CUST_ALPHA_NO", typeof(System.String));
  664. technologyRow.Columns.Add("ORDER_SPECIAL_DESC", typeof(System.String));
  665. technologyRowAsk.Columns.Add("ADD_ASK_NO", typeof(System.String));
  666. technologyRowAsk.Columns.Add("ORDER_ADD_DESC", typeof(System.String));
  667. orderline.Columns.Add("MANAG_NO", typeof(System.String));
  668. orderline.Columns.Add("ORDER_NO", typeof(System.String));
  669. orderline.Columns.Add("ORDER_SEQ", typeof(System.String));
  670. orderline.Columns.Add("CUSTOMER_NO", typeof(System.String));
  671. orderline.Columns.Add("CUST_ALPHA_NO", typeof(System.String));
  672. orderline.Columns.Add("PSC", typeof(System.String));
  673. orderline.Columns.Add("PSC_DESC", typeof(System.String));
  674. orderline.Columns.Add("MSC", typeof(System.String));
  675. orderline.Columns.Add("MSC_DESC", typeof(System.String));
  676. orderline.Columns.Add("MSC_STYLE", typeof(System.String));
  677. orderline.Columns.Add("PRD_CLS", typeof(System.String));
  678. orderline.Columns.Add("PRODUCCODE", typeof(System.String));
  679. orderline.Columns.Add("PRODUCNAME", typeof(System.String));
  680. orderline.Columns.Add("STD_CODE", typeof(System.String));
  681. orderline.Columns.Add("STD_NAME", typeof(System.String));
  682. orderline.Columns.Add("STD_STYLE", typeof(System.String));
  683. orderline.Columns.Add("STD_STYLE_DESC", typeof(System.String));
  684. orderline.Columns.Add("STEELCODE", typeof(System.String));
  685. orderline.Columns.Add("STEELNAME", typeof(System.String));
  686. orderline.Columns.Add("ORDER_SPEC_CODE", typeof(System.String));
  687. orderline.Columns.Add("ORDER_SPEC_DESC", typeof(System.String));
  688. orderline.Columns.Add("SPEC_CODE", typeof(System.String));
  689. orderline.Columns.Add("SPEC_NAME", typeof(System.String));
  690. orderline.Columns.Add("DIMATER", typeof(System.String));
  691. orderline.Columns.Add("HEIGHT", typeof(System.String));
  692. orderline.Columns.Add("MODEL_CODE", typeof(System.String));
  693. orderline.Columns.Add("MODEL_DESC", typeof(System.String));
  694. orderline.Columns.Add("LEN_NO", typeof(System.String));
  695. orderline.Columns.Add("LEN_DESC", typeof(System.String));
  696. orderline.Columns.Add("LEN_UNIT", typeof(System.String));
  697. orderline.Columns.Add("LEN_MIN", typeof(System.String));
  698. orderline.Columns.Add("LEN_MAX", typeof(System.String));
  699. orderline.Columns.Add("SHRT_LEN_RATO", typeof(System.String));
  700. orderline.Columns.Add("SHORTEST", typeof(System.String));
  701. orderline.Columns.Add("LONG_LEN_RATO", typeof(System.String));
  702. orderline.Columns.Add("LONGEST", typeof(System.String));
  703. orderline.Columns.Add("SHRT_STOVE", typeof(System.String));
  704. orderline.Columns.Add("AVG_LEN_MIN", typeof(System.String));
  705. orderline.Columns.Add("AVG_LEN_MAX", typeof(System.String));
  706. orderline.Columns.Add("DIFRNC_LEN_MAX", typeof(System.String));
  707. orderline.Columns.Add("SIGL_LEN", typeof(System.String));
  708. orderline.Columns.Add("ENDLEN_SPECSTD", typeof(System.String));
  709. orderline.Columns.Add("FINAL_USER", typeof(System.String));
  710. orderline.Columns.Add("FINAL_USER_DESC", typeof(System.String));
  711. orderline.Columns.Add("OUTS_BILLET_FL", typeof(System.String));
  712. orderline.Columns.Add("OUTS_STL_PIPE_FL", typeof(System.String));
  713. orderline.Columns.Add("OUTS_BILLET_DESC", typeof(System.String));
  714. orderline.Columns.Add("OUTS_STL_PIPE_DESC", typeof(System.String));
  715. orderline.Columns.Add("ASSEL_FL", typeof(System.String));
  716. orderline.Columns.Add("MPS_FL", typeof(System.String));
  717. orderline.Columns.Add("ORDER_UNIT", typeof(System.String));
  718. orderline.Columns.Add("ORDER_QTY", typeof(System.String));
  719. orderline.Columns.Add("ORD_ENSU_TOTL_LEN", typeof(System.String));
  720. orderline.Columns.Add("PRDCT_WGT", typeof(System.String));
  721. orderline.Columns.Add("DELVRY_RANGE_TPE", typeof(System.String));
  722. orderline.Columns.Add("DELVRY_RANGE_MIN", typeof(System.String));
  723. orderline.Columns.Add("DELVRY_RANGE_MAX", typeof(System.String));
  724. orderline.Columns.Add("DELVRY_BDATE", typeof(System.String));
  725. orderline.Columns.Add("DELVRY_EDATE", typeof(System.String));
  726. orderline.Columns.Add("DELVRY_DESC", typeof(System.String));
  727. orderline.Columns.Add("TRANS_DESC", typeof(System.String));
  728. orderline.Columns.Add("ADD_ASK_NO", typeof(System.String));
  729. orderline.Columns.Add("ORDER_SPECIAL_DESC", typeof(System.String));
  730. orderline.Columns.Add("ORDER_ADD_DESC", typeof(System.String));
  731. orderline.Columns.Add("ORDER_PRICE", typeof(System.String));
  732. orderline.Columns.Add("TRANS_PRICE", typeof(System.String));
  733. orderline.Columns.Add("TEST_ID", typeof(System.String));
  734. orderline.Columns.Add("TEST_PRICE", typeof(System.String));
  735. orderline.Columns.Add("OUT_PRICE", typeof(System.String));
  736. orderline.Columns.Add("BALNCE_PRICE", typeof(System.String));
  737. orderline.Columns.Add("ORDER_LN_STATUS", typeof(System.String));
  738. orderline.Columns.Add("MEMO", typeof(System.String));
  739. orderline.Columns.Add("PRODUCER_FL", typeof(System.String));
  740. orderline.Columns.Add("USE_CODE", typeof(System.String));
  741. orderline.Columns.Add("USE_DESC", typeof(System.String));
  742. orderline.Columns.Add("AW", typeof(System.String));
  743. orderline.Columns.Add("MAN_INSPECTION", typeof(System.String));
  744. orderline.Columns.Add("QUALITY_USER", typeof(System.String));
  745. orderline.Columns.Add("QUALITY_USER_DESC", typeof(System.String));
  746. orderline.Columns.Add("OUTPUT_STD_NO", typeof(System.String));
  747. orderline.Columns.Add("PROJECT_NO", typeof(System.String));
  748. orderline.Columns.Add("OUTBOUND_CALCULATE", typeof(System.String));
  749. orderline.Columns.Add("ORDER_TEAM", typeof(System.String));
  750. orderline.Columns.Add("MODE_OF_TRANSPORT", typeof(System.String));
  751. orderHead = orderline.NewRow();
  752. ultraTextGetDelVry.ButtonsLeft["UpdateDlyAdd"].Visible = false;
  753. }
  754. /// <summary>
  755. /// 初始化
  756. /// </summary>
  757. /// <param name="db">OpeBase</param>
  758. /// <param name="Managno">管理卡号</param>
  759. /// <param name="Order">合同号</param>
  760. /// <param name="OrderSeq">合同行号</param>
  761. /// <param name="Customerno">销售组织</param>
  762. public void loadFun(OpeBase db, string Managno, string Order, string OrderSeq, string Customerno, string sh)
  763. {
  764. customerno = Customerno; //销售组织
  765. saleorg = "100204"; //用途类型
  766. managno = Managno; //管理卡号
  767. order = Order; //合同号 一直是ORDLNPK
  768. orderSeq = OrderSeq; //合同行号
  769. shRow = sh;//合同头收货单位
  770. iTrueFlase = 0;//初始化订货规格下拉列表
  771. iTrueFlases = 0;//初始化扣型下拉列表
  772. }
  773. /// <summary>
  774. /// 初始化
  775. /// </summary>
  776. /// <param name="db">OpeBase</param>
  777. /// <param name="Customerno">销售组织</param>
  778. public void loadFun(OpeBase db, string Customerno)
  779. {
  780. customerno = Customerno; //销售组织
  781. saleorg = "100204"; //用途类型
  782. managno = ""; //管理卡号
  783. order = ""; //合同号
  784. orderSeq = ""; //合同行号
  785. shRow = "";//合同头收货单位
  786. ob = db;
  787. DataTable isx = new DataTable();
  788. //产品规格
  789. DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderLine.getSpecInfo", null, ob);
  790. ultraComboSpec.DataSource = dt;
  791. ultraComboSpec.DisplayMember = "SPEC_NAME";
  792. ultraComboSpec.ValueMember = "SPEC_CODE";
  793. //订货规格
  794. comboSpecOrderIght.DataSource = null;
  795. //订货扣型
  796. comBoModel.DataSource = null;
  797. isx = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderLine.GetQueryBaseModel", new Object[] { }, ob);
  798. comBoModel.DataSource = isx;
  799. comBoModel.DisplayMember = "MODEL_DESC";
  800. comBoModel.ValueMember = "MODEL_CODE";
  801. comBoModel.Value = "C001";
  802. //订货量
  803. comboUNIT.DataSource = null;
  804. isx = ServerHelper.GetData("com.steering.pss.sale.base.CoreBuyerOrder.GetQueryBaseInfo", new Object[] { "1215" }, ob);
  805. comboUNIT.DataSource = isx;
  806. comboUNIT.DisplayMember = "BASENAME";
  807. comboUNIT.ValueMember = "BASECODE";
  808. comboUNIT.Text = "吨";
  809. //交货量差
  810. comboPercentage.DataSource = null;
  811. isx = ServerHelper.GetData("com.steering.pss.sale.base.CoreBuyerOrder.GetQueryBaseInfo", new Object[] { "1216" }, ob);
  812. comboPercentage.DataSource = isx;
  813. comboPercentage.DisplayMember = "BASENAME";
  814. comboPercentage.ValueMember = "BASECODE";
  815. comboPercentage.Text = "%";
  816. comboPercentage.Enabled = false;
  817. //外购坯
  818. ultraCheckWGP.DataSource = null;
  819. isx = ServerHelper.GetData("com.steering.pss.sale.base.CoreBuyerOrder.GetQueryBaseInfo", new Object[] { "1218" }, ob);
  820. ultraCheckWGP.DataSource = isx;
  821. ultraCheckWGP.DisplayMember = "BASENAME";
  822. ultraCheckWGP.ValueMember = "BASECODE";
  823. ultraCheckWGP.Text = "自炼";
  824. //外购管
  825. ultraCheckWGG.DataSource = null;
  826. isx = ServerHelper.GetData("com.steering.pss.sale.base.CoreBuyerOrder.GetQueryBaseInfo", new Object[] { "1219" }, ob);
  827. ultraCheckWGG.DataSource = isx;
  828. ultraCheckWGG.DisplayMember = "BASENAME";
  829. ultraCheckWGG.ValueMember = "BASECODE";
  830. ultraCheckWGG.Text = "/";
  831. //在线机探盲区
  832. cmbInspection.Value = "1";
  833. //质保书单位
  834. OrderFunction.InitComboEditorWithParm(cmbQualityUser, "com.steering.pss.sale.order.CoreOrderInfoUpdate.getComBaseInfo",
  835. "BASECODE", "BASENAME", this.ob, false, new object[] { "1226" });
  836. cmbQualityUser.Value = "122603";
  837. //输出标准号 cmbOutPutStd
  838. OrderFunction.InitComboEditorWithParm(cmbOutPutStd, "com.steering.pss.sale.order.CoreOrderInfoUpdate.getComBaseInfo",
  839. "BASECODE", "BASENAME", this.ob, false, new object[] { "1227" });
  840. cmbOutPutStd.Value = "122701";
  841. cmbOutboundCalculate.Value = "0";
  842. ClsBaseInfo.SetComboItemHeight(cmbOutPutStd);
  843. ClsBaseInfo.SetComboItemHeight(cmbQualityUser);
  844. ClsBaseInfo.SetComboItemHeight(comboPercentage);
  845. ClsBaseInfo.SetComboItemHeight(ultraCheckWGP);
  846. ClsBaseInfo.SetComboItemHeight(ultraCheckWGG);
  847. }
  848. public void loadPsc()
  849. {
  850. this.ultraTextPSCSelect.Text = "";
  851. this.ultraComboSpec.Text = "";
  852. this.comboSpecOrderIght.Text = "";
  853. //this.comBoModel.Text = "";
  854. this.ultraTextEditorLen.Text = "";
  855. this.textFinalUser.Text = "";
  856. NumWt.Text = "";
  857. textPrice.Text = "";
  858. txtProjectNo.Text = "";
  859. }
  860. private void ultraTextEditor2_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  861. {
  862. if (e.Button.Key.Equals("JHQK"))
  863. {
  864. if (MessageUtil.ShowYesNoAndQuestion("是否清除数据?").ToString().Equals("Yes"))
  865. {
  866. SetOrderLineYesNoType("FYTrue");
  867. }
  868. return;
  869. }
  870. //新增临时修改交货地点口子
  871. if (e.Button.Key.Equals("UpdateDlyAdd"))
  872. {
  873. DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreCtrlOrderLine.queryYdmZcBillM", new object[] { order }, this.ob);
  874. if (dt != null && dt.Rows.Count > 0)
  875. {
  876. MessageUtil.ShowWarning("所选合同行存在在途提单,不能进行修改,请先关闭在途提单!");
  877. return;
  878. }
  879. DataTable dt1 = ServerHelper.GetData("com.steering.pss.sale.order.CoreCtrlOrderLine.queryYdmSendPlan", new object[] { order }, this.ob);
  880. if (dt1 != null && dt1.Rows.Count > 0)
  881. {
  882. MessageUtil.ShowWarning("所选合同行存在未执行完的出厂计划,不能进行修改,请先关闭出厂计划!");
  883. return;
  884. }
  885. if (order == "")
  886. {
  887. MessageUtil.ShowWarning("请选择一行合同行或者新增一行合同行!");
  888. return;
  889. }
  890. frmOrderDelivery delivery = new frmOrderDelivery(ob);
  891. delivery.ManageNo = managno;
  892. delivery.OrderNo = order;
  893. delivery.OrderSeq = orderSeq;
  894. delivery.SaleOrg = customerno;
  895. delivery.ShRow = shRow;
  896. delivery.NumWt = NumWt.Value.ToString();
  897. delivery.DlyTime = this.DlyTime;
  898. delivery.DlyAddress = this.DlyAddress;
  899. delivery.LenUnit = ultraLabel18.Text.Trim();
  900. //根据估算重量公式计算
  901. OrderFunction.GetPrdctWgt(ref weight, Convert.ToDouble(NumWt.Value), comboUNIT.Text.Trim(), pesc_code, this.ob);
  902. DataTable slmorderline = new DataTable();
  903. slmorderline = ctrlLineValue.Tables["orderLineDt"];
  904. if (slmorderline.Rows[0]["PRODUCCODE"].Equals("S000012"))
  905. {
  906. OrderFunction.GetWgt_JG(ref jg_weight, "S000012", slmorderline.Rows[0]["STD_CODE"].ToString(),
  907. slmorderline.Rows[0]["STD_STYLE"].ToString(), slmorderline.Rows[0]["STEELCODE"].ToString(), pesc_code, comBoModel.Value.ToString(), this.ob);
  908. delivery.NumTag = Convert.ToString(jg_weight * Convert.ToDouble(NumWt.Value));
  909. }
  910. else
  911. {
  912. delivery.NumTag = weight.ToString();
  913. }
  914. delivery.Jg_weight = jg_weight;
  915. delivery.Produc_code = slmorderline.Rows[0]["PRODUCCODE"].ToString();
  916. //单位
  917. delivery.FromForm = "4";
  918. delivery.OrderUnit = comboUNIT.Text.Trim();
  919. //DataSet,也许有记录,也许为空。
  920. delivery.OrderSet = orderDerlivery;
  921. //产品规格代码 numTag
  922. delivery.Spec_code = pesc_code;
  923. //保总长
  924. delivery.Order_line_lne = Convert.ToDouble(numTag.Value == null ? 0 : numTag.Value);
  925. delivery.GetOrderDelivery += new frmOrderDelivery.GetOrderDeliveryHander(delivery_GetOrderDelivery);
  926. delivery.ShowDialog();
  927. }
  928. else
  929. {
  930. if (CommitOrderLineRow == null)
  931. return;
  932. if (!CommitOrderLineRow(null, "insert"))
  933. {
  934. return;
  935. }
  936. if (CommitOrderLineRow(CtrlLineValue, "insert"))
  937. {
  938. //增加后续代码(按业务逻辑要求)
  939. frmOrderDelivery delivery = new frmOrderDelivery(ob);
  940. delivery.ManageNo = managno;
  941. delivery.OrderNo = order;
  942. delivery.OrderSeq = orderSeq;
  943. delivery.SaleOrg = customerno;
  944. delivery.ShRow = shRow;
  945. delivery.NumWt = NumWt.Value == null ? "0" : NumWt.Value.ToString();
  946. delivery.DlyTime = this.DlyTime;
  947. delivery.DlyAddress = this.DlyAddress;
  948. delivery.LenUnit = ultraLabel18.Text.Trim();
  949. //根据估算重量公式计算
  950. OrderFunction.GetPrdctWgt(ref weight, Convert.ToDouble(NumWt.Value), comboUNIT.Text.Trim(), pesc_code, this.ob);
  951. if (orderHead["PRODUCCODE"].Equals("S000012"))
  952. {
  953. OrderFunction.GetWgt_JG(ref jg_weight, "S000012", orderHead["STD_CODE"].ToString(),
  954. orderHead["STD_STYLE"].ToString(), orderHead["STEELCODE"].ToString(), pesc_code, comBoModel.Value.ToString(), this.ob);
  955. delivery.NumTag = Convert.ToString(jg_weight * Convert.ToDouble(NumWt.Value));
  956. }
  957. else
  958. {
  959. delivery.NumTag = weight.ToString();
  960. }
  961. delivery.Jg_weight = jg_weight;
  962. delivery.Produc_code = orderHead["PRODUCCODE"].ToString();
  963. //单位
  964. delivery.OrderUnit = comboUNIT.Text.Trim();
  965. //DataSet,也许有记录,也许为空。
  966. delivery.OrderSet = orderDerlivery;
  967. //产品规格代码 numTag
  968. delivery.Spec_code = pesc_code;
  969. //保总长
  970. delivery.Order_line_lne = Convert.ToDouble(numTag.Value == null ? 0 : numTag.Value);
  971. delivery.GetOrderDelivery += new frmOrderDelivery.GetOrderDeliveryHander(delivery_GetOrderDelivery);
  972. delivery.ShowDialog();
  973. }
  974. }
  975. }
  976. void yesNo_UpdateOrderDeliveryDesc(string type)
  977. {
  978. yesNotype = type;
  979. }
  980. void delivery_GetOrderDelivery(DataSet ds)
  981. {
  982. orderDerlivery = ds;
  983. ultraTextGetDelVry.Text = null;
  984. for (int i = 0; i < orderDerlivery.Tables.Count; i++)
  985. {
  986. if (ctrlLineValue.Tables.Count > 0)
  987. {
  988. for (int j = 0; j < ctrlLineValue.Tables.Count; j++)
  989. {
  990. if (ctrlLineValue.Tables[j].TableName.Equals(orderDerlivery.Tables[i].TableName))
  991. {
  992. ctrlLineValue.Tables.Remove(orderDerlivery.Tables[i].TableName);
  993. }
  994. }
  995. }
  996. if (orderDerlivery.Tables[i].TableName.Equals("Main"))
  997. {
  998. for (int k = 0; k < orderDerlivery.Tables[i].Rows.Count; k++)
  999. {
  1000. string ordLnDlyPk = orderDerlivery.Tables[i].Rows[k]["ORD_LN_DLY_PK"].ToString();
  1001. DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderLine.getOrderDlyTransit", new object[] { ordLnDlyPk }, this.ob);
  1002. string trasLine = "";
  1003. for (int n = 0; n < dt.Rows.Count; n++)
  1004. {
  1005. string agency = dt.Rows[n]["AGENCY_FL"].ToString();
  1006. if (agency == "0" || agency == "2") //买方线路
  1007. {
  1008. if (agency == "0")
  1009. trasLine += " 买方线路:";
  1010. else
  1011. {
  1012. trasLine += " 买方线路(买方代办):";
  1013. }
  1014. if (dt.Rows[n]["TRANSIT_TYP"].ToString() != "")
  1015. trasLine = trasLine + "运输方式:" + dt.Rows[n]["TRANSIT_TYP"].ToString();
  1016. if (dt.Rows[n]["DESTINATION"].ToString() != "")
  1017. trasLine = trasLine + " 目的地:" + dt.Rows[n]["DESTINATION"].ToString();
  1018. if (dt.Rows[n]["STATION_NO"].ToString() != "")
  1019. trasLine = trasLine + " 到站名称:" + dt.Rows[n]["STATION_NM"].ToString();
  1020. if (dt.Rows[n]["SPCL_LN_NO"].ToString() != "")
  1021. trasLine = trasLine + " 专用线名称:" + dt.Rows[n]["SPCL_LN_NM"].ToString();
  1022. if (dt.Rows[n]["PORT_NO"].ToString() != "")
  1023. trasLine = trasLine + " 港口/码头:" + dt.Rows[n]["PORT_DESC"].ToString();
  1024. if (dt.Rows[n]["CARRIER_UNIT"].ToString() != "")
  1025. trasLine = trasLine + " 承运单位:" + dt.Rows[n]["CARRIER_UNIT"].ToString();
  1026. if (dt.Rows[n]["RECEIVOR"].ToString() != "")
  1027. trasLine = trasLine + " 接货人:" + dt.Rows[n]["RECEIVOR"].ToString();
  1028. }
  1029. else
  1030. {
  1031. trasLine += " TPCO代办线路:";
  1032. if (dt.Rows[n]["TRANSIT_TYP"].ToString() != "")
  1033. trasLine = trasLine + " 运输方式:" + dt.Rows[n]["TRANSIT_TYP"].ToString();
  1034. if (dt.Rows[n]["DESTINATION"].ToString() != "")
  1035. trasLine = trasLine + " 目的地:" + dt.Rows[n]["DESTINATION"].ToString();
  1036. if (dt.Rows[n]["STATION_NO"].ToString() != "")
  1037. trasLine = trasLine + " 到站名称:" + dt.Rows[n]["STATION_NM"].ToString();
  1038. if (dt.Rows[n]["SPCL_LN_NO"].ToString() != "")
  1039. trasLine = trasLine + " 专用线名称:" + dt.Rows[n]["SPCL_LN_NM"].ToString();
  1040. if (dt.Rows[n]["PORT_NO"].ToString() != "")
  1041. trasLine = trasLine + " 港口/码头:" + dt.Rows[n]["PORT_DESC"].ToString();
  1042. if (dt.Rows[n]["CARRIER_UNIT"].ToString() != "")
  1043. trasLine = trasLine + " 承运单位:" + dt.Rows[n]["CARRIER_UNIT"].ToString();
  1044. if (dt.Rows[n]["RECEIVOR"].ToString() != "")
  1045. trasLine = trasLine + " 接货人:" + dt.Rows[n]["RECEIVOR"].ToString();
  1046. }
  1047. trasLine = trasLine + ";";
  1048. }
  1049. ultraTextGetDelVry.Text += "交货量:" + orderDerlivery.Tables[i].Rows[k]["DELVRY_QTY"].ToString() + ";交货日期:" + orderDerlivery.Tables[i].Rows[k]["DELVRY_EDATE"].ToString() + ";收货单位:" + orderDerlivery.Tables[i].Rows[k]["RECEIV_NM"].ToString() + ";交货地点:" + orderDerlivery.Tables[i].Rows[k]["DELVRY_ADDR"].ToString() + trasLine + "\r\n";//;运输方案:" + orderDerlivery.Tables[i].Rows[k]["TRANSIT_PLAN"].ToString() + "\r\n";
  1050. }
  1051. }
  1052. ctrlLineValue.Tables.Add(orderDerlivery.Tables[i].Copy());
  1053. }
  1054. UpdateOrderDeliveryDesc(ctrlLineValue);
  1055. }
  1056. public static bool IsDesignMode()
  1057. {
  1058. bool returnFlag = false;
  1059. if (LicenseManager.UsageMode == LicenseUsageMode.Designtime)
  1060. { returnFlag = true; }
  1061. else if (Process.GetCurrentProcess().ProcessName == "devenv")
  1062. { returnFlag = true; }
  1063. return returnFlag;
  1064. }
  1065. void spec_GetOrderSpecs(string specName, UltraGridRow retunSpecRow)
  1066. {
  1067. comboSpecOrderIght.Text = specName;
  1068. }
  1069. private void comBoModel_MouseDown(object sender, MouseEventArgs e)
  1070. {
  1071. saveUpdateVal = "true";
  1072. }
  1073. private void ultraTextPSCSelect_MouseDown(object sender, MouseEventArgs e)
  1074. {
  1075. saveUpdateVal = "true";
  1076. }
  1077. private void comboSpecOrderIght_MouseDown(object sender, MouseEventArgs e)
  1078. {
  1079. saveUpdateVal = "true";
  1080. }
  1081. private void ultraTextEditorLen_MouseDown(object sender, MouseEventArgs e)
  1082. {
  1083. saveUpdateVal = "true";
  1084. }
  1085. private void NumWt_MouseDown(object sender, MouseEventArgs e)
  1086. {
  1087. saveUpdateVal = "true";
  1088. }
  1089. private void comboUNIT_MouseDown(object sender, MouseEventArgs e)
  1090. {
  1091. saveUpdateVal = "true";
  1092. }
  1093. private void numTag_MouseDown(object sender, MouseEventArgs e)
  1094. {
  1095. saveUpdateVal = "true";
  1096. }
  1097. private void numericWTMax_MouseDown(object sender, MouseEventArgs e)
  1098. {
  1099. saveUpdateVal = "true";
  1100. }
  1101. private void numericWTMin_MouseDown(object sender, MouseEventArgs e)
  1102. {
  1103. saveUpdateVal = "true";
  1104. }
  1105. private void comboPercentage_MouseDown(object sender, MouseEventArgs e)
  1106. {
  1107. saveUpdateVal = "true";
  1108. }
  1109. private void textPrice_MouseDown(object sender, MouseEventArgs e)
  1110. {
  1111. saveUpdateVal = "true";
  1112. }
  1113. private void textFinalUser_MouseDown(object sender, MouseEventArgs e)
  1114. {
  1115. saveUpdateVal = "true";
  1116. }
  1117. private void ultraCheckASL_MouseDown(object sender, MouseEventArgs e)
  1118. {
  1119. saveUpdateVal = "true";
  1120. }
  1121. private void ultraTextEditor6_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1122. {
  1123. if (e.Button.Key.Equals("JSQK"))
  1124. {
  1125. if (MessageUtil.ShowYesNoAndQuestion("是否清除数据?").ToString().Equals("Yes"))
  1126. {
  1127. loadAlphaSpecl();
  1128. }
  1129. return;
  1130. }
  1131. FrmOrderSpecialInfo specInfo = new FrmOrderSpecialInfo();
  1132. specInfo.Ob = this.ob;
  1133. System.Data.DataTable tmptab = new DataTable();
  1134. tmptab.Columns.Add("MSC", typeof(string));
  1135. tmptab.Columns.Add("FINAL_USER", typeof(string));
  1136. tmptab.Columns.Add("FINAL_USER_DESC", typeof(string));
  1137. tmptab.Columns.Add("PSC", typeof(string));
  1138. tmptab.Columns.Add("PSC_DESC", typeof(string));
  1139. tmptab.Columns.Add("SPEC_NAME", typeof(string));
  1140. tmptab.Columns.Add("MODEL_CODE", typeof(string));
  1141. tmptab.Columns.Add("MODEL_DESC", typeof(string));
  1142. tmptab.Columns.Add("ORD_LN_PK", typeof(string));
  1143. tmptab.Columns.Add("SPEC_CODE", typeof(string));
  1144. System.Data.DataRow nrow = tmptab.NewRow();
  1145. if (pscSelectRow != null && pscSelectRow.Table.Rows.Count > 0)
  1146. {
  1147. nrow["MSC"] = pscSelectRow["MSC"];
  1148. nrow["PSC"] = pscSelectRow["PSC"];
  1149. nrow["PSC_DESC"] = pscSelectRow["PSC_DESC"];
  1150. }
  1151. else if (ctrlLineValue.Tables["orderLineDt"] != null)
  1152. {
  1153. nrow["MSC"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["MSC"].ToString();
  1154. nrow["PSC"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["PSC"].ToString();
  1155. nrow["PSC_DESC"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["PSC_DESC"].ToString();
  1156. nrow["SPEC_NAME"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["SPEC_NAME"].ToString();
  1157. nrow["ORD_LN_PK"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["ORD_LN_PK"].ToString();
  1158. nrow["SPEC_CODE"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["SPEC_CODE"].ToString();
  1159. }
  1160. else
  1161. {
  1162. MessageUtil.ShowTips("请选择订货产品");
  1163. return;
  1164. }
  1165. if (labDly.Tag != null && labDly.Tag.ToString() != "")
  1166. {
  1167. string[] arr = (string[])labDly.Tag;
  1168. if (arr[0] == "")
  1169. specInfo.CustAlphaNo = arr[1];
  1170. else
  1171. specInfo.CustAlphaNo = arr[0];
  1172. }
  1173. else if (ctrlLineValue.Tables["orderLineDt"] != null)
  1174. {
  1175. if (ctrlLineValue.Tables["orderLineDt"].Rows[0]["CUST_ALPHA_NO"].ToString() == "")
  1176. specInfo.CustAlphaNo = ctrlLineValue.Tables["orderLineDt"].Rows[0]["MSC"].ToString();
  1177. else
  1178. specInfo.CustAlphaNo = ctrlLineValue.Tables["orderLineDt"].Rows[0]["CUST_ALPHA_NO"].ToString();
  1179. }
  1180. DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.getBaseMsc", new object[] { nrow["PSC"].ToString() }, this.ob);
  1181. if (dt != null && dt.Rows.Count > 0)
  1182. {
  1183. }
  1184. else
  1185. {
  1186. MessageUtil.ShowTips("该产品规格下不存在基础冶金规范码,请联系制造部-标准科维护!");
  1187. return;
  1188. }
  1189. if (ultraComboSpec.Text != null && ultraComboSpec.Text != "")
  1190. {
  1191. nrow["SPEC_NAME"] = ultraComboSpec.Text;
  1192. nrow["SPEC_CODE"] = ultraComboSpec.Value.ToString();
  1193. }
  1194. else
  1195. {
  1196. MessageUtil.ShowTips("请选择产品规格!");
  1197. return;
  1198. }
  1199. if (textFinalUser.Tag != null && this.textFinalUser.Tag.ToString() != "" && textFinalUser.Tag.ToString() != "/")
  1200. {
  1201. nrow["FINAL_USER"] = textFinalUser.Tag.ToString();
  1202. nrow["FINAL_USER_DESC"] = textFinalUser.Text;
  1203. }
  1204. else if (ctrlLineValue.Tables["orderLineDt"] != null && ctrlLineValue.Tables["orderLineDt"].Rows[0]["FINAL_USER"].ToString() != "/")
  1205. {
  1206. nrow["FINAL_USER"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["FINAL_USER"].ToString();
  1207. nrow["FINAL_USER_DESC"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["FINAL_USER_DESC"].ToString();
  1208. }
  1209. else if (nrow["FINAL_USER"].ToString().Equals("/"))
  1210. {
  1211. MessageUtil.ShowTips("最终用户为空,请确认最终用户以后维护合同附加要求!");
  1212. return;
  1213. }
  1214. else
  1215. {
  1216. MessageUtil.ShowTips("请确认最终用户!");
  1217. return;
  1218. }
  1219. if (this.comBoModel.Value != null && this.comBoModel.Value.ToString() != "")
  1220. {
  1221. nrow["MODEL_CODE"] = comBoModel.Value;
  1222. nrow["MODEL_DESC"] = comBoModel.Text;
  1223. }
  1224. else
  1225. {
  1226. MessageUtil.ShowTips("请确认扣型!");
  1227. return;
  1228. }
  1229. specInfo.Dr = nrow;
  1230. specInfo.FrmOrderSpecialInfoComfirm += new FrmOrderSpecialInfoHand(specInfo_FrmOrderSpecialInfoComfirm);
  1231. specInfo.ShowDialog();
  1232. }
  1233. void specInfo_FrmOrderSpecialInfoComfirm(object sender, FrmOrderSpecialInfoEventArgs e)
  1234. {
  1235. technologyRow.Rows.Clear();
  1236. ArrayList strList = new ArrayList();
  1237. technologyRow.Rows.Add(e.CustAlphaNo, e.Description);
  1238. this.labDly.Text = e.Description;
  1239. string[] str = new string[] { "", "" };
  1240. str[0] = e.CustAlphaNo;
  1241. str[1] = e.Msc;
  1242. labDly.Tag = str;
  1243. }
  1244. private void ultraTextEdiAsk_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1245. {
  1246. if (e.Button.Key.Equals("FJQK"))
  1247. {
  1248. if (MessageUtil.ShowYesNoAndQuestion("是否清除数据?").ToString().Equals("Yes"))
  1249. {
  1250. loadAddAskNo();
  1251. }
  1252. return;
  1253. }
  1254. dlgOrderAddAsk addask = new dlgOrderAddAsk();
  1255. addask.Ob = this.ob;
  1256. System.Data.DataTable tmptab = new DataTable();
  1257. tmptab.Columns.Add("FINAL_USER", typeof(string));
  1258. tmptab.Columns.Add("FINAL_USER_DESC", typeof(string));
  1259. tmptab.Columns.Add("STD_CODE", typeof(string));
  1260. tmptab.Columns.Add("ORD_LN_PK", typeof(string));
  1261. System.Data.DataRow nrow = tmptab.NewRow();
  1262. if (pscSelectRow != null && pscSelectRow.Table.Rows.Count > 0)
  1263. {
  1264. nrow["STD_CODE"] = pscSelectRow["STD_CODE"];
  1265. }
  1266. else if (ctrlLineValue.Tables["orderLineDt"] != null)
  1267. {
  1268. nrow["STD_CODE"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["STD_CODE"].ToString();
  1269. nrow["ORD_LN_PK"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["ORD_LN_PK"].ToString();
  1270. }
  1271. else
  1272. {
  1273. MessageUtil.ShowTips("请选择订货产品");
  1274. return;
  1275. }
  1276. if (textFinalUser.Tag != null && this.textFinalUser.Tag.ToString() != "" && textFinalUser.Tag.ToString() != "/")
  1277. {
  1278. nrow["FINAL_USER"] = textFinalUser.Tag.ToString();
  1279. nrow["FINAL_USER_DESC"] = textFinalUser.Text;
  1280. }
  1281. else if (ctrlLineValue.Tables["orderLineDt"] != null && ctrlLineValue.Tables["orderLineDt"].Rows[0]["FINAL_USER"].ToString() != "/")
  1282. {
  1283. nrow["FINAL_USER"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["FINAL_USER"].ToString();
  1284. nrow["FINAL_USER_DESC"] = ctrlLineValue.Tables["orderLineDt"].Rows[0]["FINAL_USER_DESC"].ToString();
  1285. }
  1286. else if (nrow["FINAL_USER"].ToString().Equals("/"))
  1287. {
  1288. MessageUtil.ShowTips("最终用户为空,请确认最终用户以后维护合同附加要求!");
  1289. return;
  1290. }
  1291. else
  1292. {
  1293. MessageUtil.ShowTips("请确认最终用户");
  1294. return;
  1295. }
  1296. if (ultraTextEdiAsk.Tag != null && ultraTextEdiAsk.Tag.ToString() != "")
  1297. {
  1298. addask.AddAskNos = ultraTextEdiAsk.Tag.ToString();
  1299. }
  1300. else if (ctrlLineValue.Tables["orderLineDt"] != null)
  1301. {
  1302. addask.AddAskNos = ctrlLineValue.Tables["orderLineDt"].Rows[0]["ADD_ASK_NO"].ToString();
  1303. }
  1304. addask.Dr = nrow;
  1305. addask.dlgOrderAddAskHandEvent += new dlgOrderAddAskHand(addask_dlgOrderAddAskHandEvent);
  1306. addask.ShowDialog();
  1307. }
  1308. void addask_dlgOrderAddAskHandEvent(object sender, ReturnMessage e)
  1309. {
  1310. technologyRowAsk.Rows.Clear();
  1311. ArrayList strList = new ArrayList();
  1312. technologyRowAsk.Rows.Add(e.AddAskNo, e.Message.ToString());
  1313. ultraTextEdiAsk.Text = e.Message;
  1314. ultraTextEdiAsk.Tag = e.AddAskNo;
  1315. //UpdateOrderDeliveryDesc(ctrlLineValue);
  1316. }
  1317. private void comboSpecOrderIght_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1318. {
  1319. if (ultraComboSpec.SelectedItem == null)
  1320. {
  1321. MessageUtil.ShowWarning("请选择产品规格!");
  1322. return;
  1323. }
  1324. FrmOrderSpec spec = new FrmOrderSpec(ob);
  1325. spec.TitleName = comboSpecOrderIght.Text;
  1326. spec.SpecCode = ultraComboSpec.Value.ToString();
  1327. spec.GetOrderSpecs += new FrmOrderSpec.GetOrderSpec(spec_GetOrderSpecs);
  1328. spec.ShowDialog();
  1329. }
  1330. private void comboSpecOrderIght_ValueChanged(object sender, EventArgs e)
  1331. {
  1332. if (iTrueFlase == 1)
  1333. {
  1334. // comboSpecOrderIght.DroppedDown = true;
  1335. }
  1336. pesc_code = comboSpecOrderIght.Value == null ? " " : comboSpecOrderIght.Value.ToString();
  1337. iTrueFlase = 1;
  1338. }
  1339. private void comBoModel_ValueChanged(object sender, EventArgs e)
  1340. {
  1341. if (iTrueFlases == 1)
  1342. {
  1343. //comBoModel.DroppedDown = true;
  1344. }
  1345. iTrueFlases = 1;
  1346. }
  1347. private bool orderLineYes(string nameType, string nameUp)
  1348. {
  1349. orderLineYesNo yesNo = new orderLineYesNo(nameType, nameUp);
  1350. yesNo.UpdateOrderDeliveryDesc += new orderLineYesNo.UporderLineYesNoDesc(yesNo_UpdateOrderDeliveryDesc);
  1351. yesNo.StartPosition = FormStartPosition.Manual;
  1352. //更改位置
  1353. yesNo.Left = Convert.ToInt32(1080);
  1354. yesNo.Top = Convert.ToInt32(550);
  1355. yesNo.ShowDialog();
  1356. if (!yesNotype.Equals("") && !yesNotype.Equals("False") && !yesNotype.Equals("True"))
  1357. {
  1358. if (MessageUtil.ShowYesNoAndQuestion("是否清除数据?").ToString().Equals("Yes"))
  1359. {
  1360. SetOrderLineYesNoType(yesNotype);
  1361. }
  1362. return false;
  1363. }
  1364. if (yesNotype.Equals("False"))
  1365. {
  1366. return false;
  1367. }
  1368. return true;
  1369. }
  1370. private void textFinalUser_ValueChanged(object sender, EventArgs e)
  1371. {
  1372. loadAddAskNo();
  1373. loadAlphaSpecl();
  1374. ClearDly();
  1375. }
  1376. private void comBoModel_TextChanged(object sender, EventArgs e)
  1377. {
  1378. loadAlphaSpecl();
  1379. }
  1380. private void ultraTextPSCSelect_TextChanged(object sender, EventArgs e)
  1381. {
  1382. loadAlphaSpecl();
  1383. loadAddAskNo();
  1384. //ClearDly();
  1385. }
  1386. private void ultraTextEditorLen_TextChanged(object sender, EventArgs e)
  1387. {
  1388. loadAlphaSpecl();
  1389. }
  1390. /// <summary>
  1391. /// 附加要求清空
  1392. /// </summary>
  1393. private void loadAddAskNo()
  1394. {
  1395. ultraTextEdiAsk.Tag = "";
  1396. ultraTextEdiAsk.Text = "";
  1397. ultraTextEdiAsk.Value = "";
  1398. orderHead["ADD_ASK_NO"] = "";
  1399. orderHead["ORDER_ADD_DESC"] = "";
  1400. technologyRowAsk.Clear();
  1401. }
  1402. /// <summary>
  1403. /// 技术特殊要求清空
  1404. /// </summary>
  1405. private void loadAlphaSpecl()
  1406. {
  1407. labDly.Text = "";
  1408. labDly.Tag = null;
  1409. labDly.Value = "";
  1410. orderHead["CUST_ALPHA_NO"] = "";
  1411. orderHead["ORDER_SPECIAL_DESC"] = "";
  1412. orderHead["USE_CODE"] = "";
  1413. orderHead["USE_DESC"] = "";
  1414. if (orderHead["MSC"].ToString().Length>10)
  1415. orderHead["MSC"] = orderHead["MSC"].ToString().Substring(0,10)+"000";
  1416. technologyRow.Clear();
  1417. }
  1418. private void ClearDly()
  1419. {
  1420. ultraTextGetDelVry.Text = "";
  1421. ultraTextGetDelVry.Tag = "";
  1422. ultraTextGetDelVry.Value = "";
  1423. }
  1424. private void ultraComboSpec_ValueChanged(object sender, EventArgs e)
  1425. {
  1426. if (ultraComboSpec.Value != null)
  1427. {
  1428. string specCode = ultraComboSpec.Value.ToString();
  1429. DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderLine.getOrderSpecInfo", new object[] { specCode }, ob);
  1430. comboSpecOrderIght.DataSource = dt;
  1431. comboSpecOrderIght.DisplayMember = "ORDER_SPEC_DESC";
  1432. comboSpecOrderIght.ValueMember = "ORDER_SPEC_CODE";
  1433. }
  1434. if (ultraComboSpec.Text == "")
  1435. {
  1436. comboSpecOrderIght.DataSource = null;
  1437. }
  1438. loadAlphaSpecl();
  1439. }
  1440. private void ultraTextPSCSelect_ValueChanged(object sender, EventArgs e)
  1441. {
  1442. string productCode = "";
  1443. if (pscSelectRow != null)
  1444. {
  1445. productCode = pscSelectRow["PRODUCCODE"].ToString();
  1446. }
  1447. else if (ctrlLineValue.Tables["orderLineDt"] != null)
  1448. {
  1449. productCode = ctrlLineValue.Tables["orderLineDt"].Rows[0]["PRODUCCODE"].ToString();
  1450. }
  1451. DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.getProductType", new object[] { productCode }, this.ob);
  1452. if (dt != null && dt.Rows.Count > 0)
  1453. {
  1454. string proType = dt.Rows[0][0].ToString();
  1455. if (proType == "C" || proType == "D" || proType == "E") //短节+附件 接箍 双工短节 订货单位只有“支”
  1456. {
  1457. ((DataTable)comboUNIT.DataSource).DefaultView.RowFilter = "";
  1458. comboUNIT.Enabled = false;
  1459. comboUNIT.Text = "支";
  1460. }
  1461. else //钢管(管坯) 钢管+接箍
  1462. {
  1463. comboUNIT.Enabled = true;
  1464. ((DataTable)comboUNIT.DataSource).DefaultView.RowFilter = "BASENAME <>'支'";
  1465. }
  1466. }
  1467. }
  1468. private void NumWt_ValueChanged(object sender, EventArgs e)
  1469. {
  1470. string orderUnit = comboUNIT.Text.Trim();
  1471. string num = NumWt.Text.Trim();
  1472. if (num == "")
  1473. return;
  1474. if (orderUnit == "米" || orderUnit == "英尺")
  1475. numTag.Value = 0;
  1476. }
  1477. private void comboUNIT_ValueChanged(object sender, EventArgs e)
  1478. {
  1479. string orderUnit = comboUNIT.Text.Trim();
  1480. //string num = NumWt.Text.Trim();
  1481. //if (num == "")
  1482. // return;
  1483. //if (orderUnit == "米" || orderUnit == "英尺")
  1484. // numTag.Value = num;
  1485. if (orderUnit == "米" || orderUnit == "英尺" || orderUnit == "支")
  1486. {
  1487. numTag.Enabled = false;
  1488. numTag.Value = 0;
  1489. }
  1490. else
  1491. {
  1492. numTag.Enabled = true;
  1493. }
  1494. }
  1495. /// <summary>
  1496. /// 锁定控件
  1497. /// </summary>
  1498. public void LockControl()
  1499. {
  1500. foreach (System.Windows.Forms.Control item in this.Controls)
  1501. {
  1502. if (item.Name.ToString() != "ultraTextEdiAsk")
  1503. {
  1504. item.Enabled = false;
  1505. }
  1506. }
  1507. }
  1508. /// <summary>
  1509. /// 解锁控件
  1510. /// </summary>
  1511. public void UnLockControl()
  1512. {
  1513. foreach (System.Windows.Forms.Control item in this.Controls)
  1514. {
  1515. if (item.Name.ToString() != "textPrice" && item.Name.ToString() != "comboPercentage")
  1516. {
  1517. item.Enabled = true;
  1518. }
  1519. }
  1520. }
  1521. private void ultraCheckWGP_ValueChanged(object sender, EventArgs e)
  1522. {
  1523. if (ultraCheckWGP.Value.ToString2() == "121801")
  1524. {
  1525. ultraCheckWGG.Enabled = false;
  1526. ultraCheckWGG.Value = "121901";
  1527. }
  1528. else
  1529. {
  1530. ultraCheckWGG.Enabled = true;
  1531. ultraCheckWGG.Value = "121901";
  1532. }
  1533. }
  1534. private void ultraCheckWGG_ValueChanged(object sender, EventArgs e)
  1535. {
  1536. if (ultraCheckWGG.Value.ToString2() == "121901")
  1537. {
  1538. ultraCheckWGP.Enabled = true;
  1539. ultraCheckASL.Enabled = true;
  1540. }
  1541. else
  1542. {
  1543. ultraCheckWGP.Value = "121802";
  1544. ultraCheckWGP.Enabled = false;
  1545. ultraCheckASL.Checked = false;
  1546. ultraCheckASL.Enabled = false;
  1547. }
  1548. }
  1549. private void labDly_ValueChanged(object sender, EventArgs e)
  1550. {
  1551. }
  1552. }
  1553. }