FrmOrderM.cs 108 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using CoreFS.CA06;using Pur.Entity;
  10. using Core.Mes.Client.Comm.Control;
  11. using Core.Mes.Client.Comm;
  12. using Pur.Entity.configureEntity;
  13. using Infragistics.Win.UltraWinGrid;
  14. using System.Collections;
  15. using Pur.Entity.pur_orderEntiy;
  16. using Pur.configure;
  17. using Pur.Pop_upWindow;
  18. using Pur.require_plan;
  19. using Core.Mes.Client.Comm.Tool;
  20. using com.hnshituo.pur.vo;
  21. using Infragistics.Win.UltraWinEditors;
  22. using Pur.balance;
  23. using Core.Mes.Client.Comm.Server;
  24. using Infragistics.Win;
  25. using CoreFS.SA06;
  26. using Bpm;
  27. namespace Pur.order
  28. {
  29. public partial class FrmOrderM : FrmPmsBase
  30. {
  31. // 合同头区域使用变量
  32. string init_OrderTitleCode = "";//合同头编码
  33. string init_Supp_Code = "";//供应商编码
  34. string init_Mode_Id = "";//合同模板
  35. // 交货行区域使用变量
  36. string init_MaxOrderCDQty = "0";//合同行最大可编制量
  37. string init_OrderCDUom = "";//单位
  38. // 合同行区域使用变量
  39. string init_itemUomId = "";//物料单位换算ID
  40. string init_itemStandardsId = "";//采购标准ID
  41. string init_itemAttrId = "";//物料属性编码
  42. string init_itemUnique = "";//物料唯一码
  43. string init_deliveryLocationCode = "";//地点编码
  44. //构造函数
  45. public FrmOrderM()
  46. {
  47. InitializeComponent();
  48. }
  49. //load
  50. private void FrmOrderM_Load(object sender, EventArgs e)//load
  51. {
  52. //初始化
  53. Init();
  54. }
  55. #region toolbar工具栏
  56. /// <summary>
  57. /// toolbar菜单
  58. /// </summary>
  59. /// <param name="sender"></param>
  60. /// <param name="ToolbarKey"></param>
  61. public override void ToolBar_Click(object sender, string ToolbarKey)// toolbar菜单
  62. {
  63. switch (ToolbarKey)
  64. {
  65. case "Query":
  66. GetPUR_ORDER_M();
  67. break;
  68. case "Add":
  69. AddPUR_ORDER_M();
  70. break;
  71. case "Update":
  72. UpdPUR_ORDER_M();
  73. break;
  74. case "Delete":
  75. DelPUR_ORDER_M();
  76. break;
  77. case "Submittal":
  78. SubPUR_ORDER_M();
  79. break;
  80. case "Revocation":
  81. RevPUR_ORDER_M();
  82. break;
  83. case "getBalance":
  84. getBalance();
  85. break;
  86. case "getReport":
  87. getReportHT("0");
  88. break;
  89. case "getReportNoSign":
  90. getReportHT("1");
  91. break;
  92. case "getReportJY":
  93. getReportJY();
  94. break;
  95. case "Process":
  96. Process();
  97. break;
  98. case "FinishedAuditOutline":
  99. FinishedAuditOutline();
  100. break;
  101. }
  102. }
  103. private void FinishedAuditOutline()
  104. {
  105. UltraGridRow uge = ultraGrid1.ActiveRow;
  106. if (uge == null)
  107. {
  108. MessageUtil.ShowTips("请选择合同头!");
  109. return;
  110. }
  111. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  112. OrderM Odm = new OrderM();
  113. Odm.OrderId = strOrderId;
  114. Odm.OperatorUserId = UserInfo.GetUserID();
  115. if (MessageBox.Show("确认该合同[" + strOrderId + "]线下已经完成审批?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  116. {
  117. return;
  118. }
  119. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "finishedAuditOutline", new object[] { Odm });
  120. if (rt.Resultcode != 0)
  121. {
  122. MessageUtil.ShowTips("操作失败:" + rt.Resultmsg);
  123. return;
  124. }
  125. MessageUtil.ShowTips("操作成功!");
  126. GetPUR_ORDER_M();
  127. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  128. }
  129. #endregion
  130. #region toolbar事件
  131. /// <summary>
  132. /// 生成结算单
  133. /// </summary>
  134. private void getBalance()// 生成结算单
  135. {
  136. ultraGrid1.UpdateData();
  137. string strSuppCode = "";
  138. string strSuppName="";
  139. int sumSuppCode = 0;
  140. ArrayList al = new ArrayList();
  141. for (int i = 0; i < ultraGrid1.Rows.Count; i++)
  142. {
  143. if ((Boolean)ultraGrid1.Rows[i].Cells["Check"].Value)
  144. {
  145. sumSuppCode++;
  146. if (sumSuppCode > 1)
  147. {
  148. if (strSuppCode != ultraGrid1.Rows[i].Cells["SUPPCODE"].Value.ToString())
  149. {
  150. MessageUtil.ShowTips("选择的合同不为同一个供应商,请重新选择");
  151. return;
  152. }
  153. }
  154. al.Add(ultraGrid1.Rows[i].Cells["OrderId"].Value.ToString());
  155. strSuppCode = ultraGrid1.Rows[i].Cells["SUPPCODE"].Value.ToString();
  156. strSuppName=ultraGrid1.Rows[i].Cells["SUPPNAME"].Value.ToString();
  157. }
  158. }
  159. if (sumSuppCode == 0)
  160. {
  161. MessageUtil.ShowTips("请选择合同");
  162. return;
  163. }
  164. frmConfirmBalance frm = new frmConfirmBalance(this.ob, al, strSuppName, strSuppCode);
  165. frm.ShowDialog();
  166. }
  167. /// <summary>
  168. /// 撤销提报
  169. /// </summary>
  170. private void RevPUR_ORDER_M()// 撤销提报
  171. {
  172. UltraGridRow uge = ultraGrid1.ActiveRow;
  173. if (uge == null)
  174. {
  175. MessageUtil.ShowTips("请选择合同头!");
  176. return;
  177. }
  178. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  179. if (String.IsNullOrEmpty(strOrderId))
  180. {
  181. MessageUtil.ShowTips("该合同头编号为空!");
  182. return;
  183. }
  184. //验证合同头是否可以撤销提报
  185. if (testOrderMStatus(strOrderId, 4) == false)
  186. {
  187. return;
  188. }
  189. OrderM Odm = new OrderM();
  190. Odm.OrderId = strOrderId;
  191. Odm.Status = "1";
  192. Odm.OperatorUserId = UserInfo.GetUserID();
  193. if (MessageBox.Show("确定撤销提报合同【" + uge.Cells["OrderId"].Value.ToString() + "】?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  194. {
  195. return;
  196. }
  197. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "Submittal_OrderM", new object[] { Odm });
  198. if (rt.Resultcode != 0)
  199. {
  200. MessageUtil.ShowTips("撤销提报失败:" + rt.Resultmsg);
  201. return;
  202. }
  203. MessageUtil.ShowTips("操作成功!");
  204. GetPUR_ORDER_M();
  205. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  206. }
  207. /// <summary>
  208. /// 提报
  209. /// </summary>
  210. private void SubPUR_ORDER_M()// 提报
  211. {
  212. UltraGridRow uge = ultraGrid1.ActiveRow;
  213. if (uge == null)
  214. {
  215. MessageUtil.ShowTips("请选择合同头!");
  216. return;
  217. }
  218. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  219. if (String.IsNullOrEmpty(strOrderId))
  220. {
  221. MessageUtil.ShowTips("该合同头编号为空!");
  222. return;
  223. }
  224. //验证合同头是否可以提报
  225. if (testOrderMStatus(strOrderId,3) == false)
  226. {
  227. return;
  228. }
  229. OrderM Odm = new OrderM();
  230. Odm.OrderId = strOrderId;
  231. Odm.Status = "2";
  232. Odm.OperatorUserId = UserInfo.GetUserID();
  233. if (MessageBox.Show("确定提报合同【" + strOrderId + "】?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  234. {
  235. return;
  236. }
  237. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "Submittal_OrderM", new object[] { Odm });
  238. if (rt.Resultcode != 0)
  239. {
  240. MessageUtil.ShowTips("提交失败:" + rt.Resultmsg);
  241. return;
  242. }
  243. MessageUtil.ShowTips("提交成功!");
  244. GetPUR_ORDER_M();
  245. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  246. }
  247. /// <summary>
  248. /// 删除
  249. /// </summary>
  250. private void DelPUR_ORDER_M()// 删除
  251. {
  252. try
  253. {
  254. UltraGridRow uge = ultraGrid1.ActiveRow;
  255. if (uge == null)
  256. {
  257. MessageUtil.ShowTips("请选择合同头!");
  258. return;
  259. }
  260. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  261. if (String.IsNullOrEmpty(strOrderId))
  262. {
  263. MessageUtil.ShowTips("该合同头编号为空!");
  264. return;
  265. }
  266. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[0].Text || ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[3].Text)
  267. {
  268. //验证合同头是否可以增删改
  269. if (testOrderMStatus(strOrderId, 2) == false)
  270. {
  271. return;
  272. }
  273. OrderM Odm = new OrderM();
  274. Odm.Validflag = "0";
  275. Odm.DeleteName = CoreUserInfo.UserInfo.GetUserName();
  276. Odm.DeleteUserid = CoreUserInfo.UserInfo.GetUserID();
  277. Odm.DeleteTime = DateTime.Now;
  278. Odm.OrderId = strOrderId;
  279. if (MessageBox.Show("确定删除合同[" + uge.Cells["OrderId"].Value.ToString() + "]?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  280. {
  281. return;
  282. }
  283. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "cancelOrderM", new object[] { Odm });
  284. if (rt.Resultcode != 0)
  285. {
  286. Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("操作失败!" + rt.Resultmsg);
  287. return;
  288. }
  289. MessageUtil.ShowTips("删除成功!");
  290. GetPUR_ORDER_M();
  291. }
  292. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[1].Text)
  293. {
  294. UltraGridRow uRe = ultraGrid2.ActiveRow;
  295. if (uRe == null)
  296. {
  297. MessageUtil.ShowTips("请选择需要操作的合同行!");
  298. return;
  299. }
  300. String strOrderLineSqe = uRe.Cells["OrderLineSqe"].Value.ToString().Trim();
  301. if (String.IsNullOrEmpty(strOrderLineSqe))
  302. {
  303. MessageUtil.ShowTips("数据异常,该合同行无合同行号!");
  304. return;
  305. }
  306. if (testOrderCStatus(strOrderLineSqe, 1) == false)
  307. {
  308. return;
  309. }
  310. OrderC odC = new OrderC();
  311. odC.DeleteName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  312. odC.DeleteUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  313. odC.DeleteTime = DateTime.Now;
  314. odC.Validflag = "0";
  315. odC.OrderLineSqe = strOrderLineSqe;
  316. //this.execute("com.hnshituo.pur.order.service.OrderCService", "update", new object[] { odC });
  317. // OrderM Omg = new OrderM();
  318. // Omg.OrderId = uge.Cells["OrderId"].Value.ToString();
  319. // Omg.WithAmtTax = (uge.Cells["WithAmtTax"].Value == null || String.IsNullOrEmpty(uge.Cells["WithAmtTax"].Value.ToString().Trim()) ? 0 : Convert.ToDouble(uge.Cells["WithAmtTax"].Value.ToString())) - (uRe.Cells["WithAmtTax"].Value == null || String.IsNullOrEmpty(uRe.Cells["WithAmtTax"].Value.ToString().Trim()) ? 0 : Convert.ToDouble(uRe.Cells["WithAmtTax"].Value.ToString()));
  320. // Omg.WithoutTaxAmt = (uge.Cells["WithoutTaxAmt"].Value == null || String.IsNullOrEmpty(uge.Cells["WithoutTaxAmt"].Value.ToString().Trim()) ? 0 : Convert.ToDouble(uge.Cells["WithoutTaxAmt"].Value.ToString())) - (uRe.Cells["WithoutTaxAmt"].Value == null || String.IsNullOrEmpty(uRe.Cells["WithoutTaxAmt"].Value.ToString().Trim()) ? 0 : Convert.ToDouble(uRe.Cells["WithoutTaxAmt"].Value.ToString()));
  321. // this.execute("com.hnshituo.pur.order.service.OrderMService", "update", new object[] { Omg });
  322. //if (ultraGrid4.Rows.Count() > 0)
  323. //{
  324. // MessageUtil.ShowTips("该合同行[" + odC.OrderLineSqe + "]已关联交货行,不允许删除");
  325. // return;
  326. //}
  327. if (MessageBox.Show("确定作废合同行[" + odC.OrderLineSqe + "]?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  328. {
  329. return;
  330. }
  331. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCService", "update_MC", new object[] { odC, uge.Cells["OrderId"].Value.ToString() });
  332. if (rt.Resultcode != 0)
  333. {
  334. Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除失败!" + rt.Resultmsg);
  335. return;
  336. }
  337. MessageUtil.ShowTips("删除成功!");
  338. GetPUR_ORDER_M();
  339. ConfigureClassCommon.doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  340. getOrderC(strOrderId, odC.OrderLineSqe);
  341. }
  342. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
  343. {
  344. UltraGridRow ugc = ultraGrid4.ActiveRow;
  345. if(ugc==null)
  346. {
  347. return;
  348. }
  349. String strOrderLineDSqe = ugc.GetCellValue("orderLineDSqe").ToString().Trim();
  350. String strOrderLineSqe = ugc.Cells["orderLineSqe"].Value.ToString().Trim();
  351. if (String.IsNullOrEmpty(strOrderLineDSqe))
  352. {
  353. MessageUtil.ShowTips("数据异常,该合同发货行的发货行号为空!");
  354. return;
  355. }
  356. if (testOrderCDStatus(strOrderLineDSqe,1) == false)
  357. {
  358. return;
  359. }
  360. OrderCD orderCD = new OrderCD();
  361. orderCD.OrderLineDSqe = strOrderLineDSqe;
  362. orderCD.DeleteName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  363. orderCD.DeleteUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  364. orderCD.DeleteTime = DateTime.Now;
  365. orderCD.Validflag = "0";
  366. if (MessageUtil.ShowYesNoAndQuestion("确定删除发货行【" + strOrderLineDSqe + "】?") == DialogResult.No)
  367. {
  368. return;
  369. }
  370. CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCDService", "doUpdate", new object[] { orderCD });
  371. if (re.Resultcode == 0)
  372. {
  373. MessageUtil.ShowTips("删除成功");
  374. getOrderC(uge.GetCellValue("orderId").ToString().Trim(), strOrderLineSqe);
  375. }
  376. else
  377. {
  378. MessageUtil.ShowTips("删除失败:" + re.Resultmsg);
  379. return;
  380. }
  381. }
  382. }
  383. catch (Exception e)
  384. {
  385. MessageUtil.ShowWarning("操作失败! " + e);
  386. return;
  387. }
  388. }
  389. /// <summary>
  390. /// 修改
  391. /// </summary>
  392. private void UpdPUR_ORDER_M()// 修改
  393. {
  394. try
  395. {
  396. UltraGridRow uge = ultraGrid1.ActiveRow;
  397. if (uge == null)
  398. {
  399. MessageUtil.ShowTips("请选择合同头!");
  400. return;
  401. }
  402. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  403. if(String.IsNullOrEmpty(strOrderId))
  404. {
  405. MessageUtil.ShowTips("该合同头编号为空!");
  406. return;
  407. }
  408. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[0].Text || ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[3].Text)
  409. {
  410. //验证合同头是否可以增删改
  411. if (testOrderMStatus(strOrderId, 1) == false)
  412. {
  413. return;
  414. }
  415. //验证合同头输入数据的有效信息
  416. if (testOrderM() == false)
  417. {
  418. return;
  419. }
  420. OrderM Odm = new OrderM();
  421. Odm.BuyerName = txt_BuyerName.Text;
  422. //Odm.BuyerDeptDesc = txt_BuyerDeptDesc.Text;
  423. //Odm.BuyerUnitDesc = txt_BuyerUnitDesc.Text;
  424. Odm.Currency = txt_Currency.Value == null ? "" : txt_Currency.Value.ToString().Trim();
  425. Odm.OrderType = txt_OrderType.Value.ToString().Trim();//合同类别
  426. Odm.OrderClass = txt_OrderClass.Value.ToString().Trim();//合同分类
  427. Odm.ExchangeRateCur = (txt_ExchangeRateCur.Value == null ? 0 : Convert.ToDouble(txt_ExchangeRateCur.Text));
  428. Odm.OrderId = strOrderId;
  429. Odm.ModeName = txt_ModeName.Text;
  430. Odm.ModeId = init_Mode_Id;
  431. Odm.SuppCode = init_Supp_Code;
  432. Odm.SuppName = txt_SuppName.Text;
  433. Odm.OrderMoneyType = txt_OrderMoneyType.Value == null ? null : txt_OrderMoneyType.Value.ToString().Trim();
  434. Odm.SignDate = Convert.ToDateTime(txt_SignDate.Value);//签订日期
  435. Odm.OrderTitleCode = init_OrderTitleCode;
  436. Odm.SignAddress = txt_SignAddress.Text;
  437. Odm.UpdateName = CoreUserInfo.UserInfo.GetUserName();
  438. Odm.UpdateUserid = CoreUserInfo.UserInfo.GetUserID();
  439. Odm.UpdateTime = DateTime.Now;
  440. Odm.TaxRateName = txt_TaxRateName.Value.ToString().Trim();
  441. Odm.DeliveryCondition = txt_deliveryCondition.Value.ToString().Trim();//运输条件
  442. Odm.DeliveryType = txt_deliveryType.Value.ToString().ToString().Trim();//运输方式
  443. if (MessageBox.Show("确定修改合同[" + strOrderId + "]?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  444. {
  445. return;
  446. }
  447. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "doUpdate", new object[] { Odm });
  448. if (rt.Resultcode != 0)
  449. {
  450. Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("操作失败!" + rt.Resultmsg);
  451. return;
  452. }
  453. MessageUtil.ShowTips("操作成功!");
  454. GetPUR_ORDER_M();
  455. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  456. }
  457. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[1].Text)
  458. {
  459. //验证合同头是否可以删改
  460. if (testOrderMStatus(strOrderId, 1) == false)
  461. {
  462. return;
  463. }
  464. if (testOrderC() == false)
  465. {
  466. return;
  467. }
  468. UltraGridRow uRe = ultraGrid2.ActiveRow;
  469. OrderC odC = new OrderC();
  470. odC.OrderId = strOrderId;
  471. odC.OrderLineSqe = txt_OrderLineSqe.Text.ToString().Trim();
  472. odC.ItemCode = txt_ItemCode.Text.ToString().Trim();
  473. odC.ItemAttr = txt_itemAttrName.Text.ToString().Trim();
  474. odC.ItemAttrId = init_itemAttrId.ToString().Trim();
  475. odC.PriceWithoutTax = (txt_PriceWithoutTax.Value == null ? 0 : Convert.ToDouble(txt_PriceWithoutTax.Value));
  476. odC.PriceWithTax = (txt_PriceWithTax.Value == null ? 0 : Convert.ToDouble(txt_PriceWithTax.Value));
  477. odC.PriceWithoutTax = (txt_PriceWithoutTax.Value == null ? 0 : Convert.ToDouble(txt_PriceWithoutTax.Value));
  478. odC.WithoutTaxAmt = (txt_WithoutTaxAmt2.Value == null ? 0 : Convert.ToDouble(txt_WithoutTaxAmt2.Value));
  479. odC.WithAmtTax = (txt_WithAmtTax2.Value == null ? 0 : Convert.ToDouble(txt_WithAmtTax2.Value));
  480. odC.TaxAmt = (txt_TaxAmt2.Value == null ? 0 : Convert.ToDouble(txt_TaxAmt2.Value));
  481. odC.Qty = (txt_Qty.Value == null ? 0 : Convert.ToDouble(txt_Qty.Value));
  482. //odC.BuyerDeptDesc = txt_BuyerDeptDesc.Text;
  483. odC.ItemName = txt_ItemName.Text;
  484. //odC.BuyerUnitDesc = txt_BuyerUnitDesc.Text;
  485. odC.BuyerName = txt_BuyerName2.Text;
  486. odC.ChemPriceNo = txt_ChemPriceNo.Text;
  487. //OtherPriceNum = txt_OtherPriceNum.Text;
  488. odC.ReceiveType = txt_ReceiveType.Value.ToString();
  489. odC.StartDate = Convert.ToDateTime(txt_StartDate2.Value);//交货开始时间
  490. odC.EndDate = Convert.ToDateTime(txt_EndDate2.Value);//交货结束时间
  491. odC.GradePriceNo = txt_GradePriceNo.Text;
  492. //odC.BasePriceNo = txt_BasePriceNo.Text;
  493. odC.DeliveryLocationCode = init_deliveryLocationCode;
  494. odC.QuantityPriceNum = txt_QuantityPriceNum.Text;
  495. odC.UpdateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  496. odC.UpdateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  497. odC.UpdateTime = DateTime.Now;
  498. odC.Remark = txt_Remark.Text.ToString().Trim();
  499. odC.PackageType = txt_packType.Value==null?null:txt_packType.Value.ToString().Trim();//包装方式
  500. odC.PaymentCode = txt_paymentType.Value == null ? null : txt_paymentType.Value.ToString().Trim();//付款方式
  501. if (txt_Pur_Clause.Value != null)
  502. {
  503. odC.BcmId = txt_Pur_Clause.Value.ToString().Trim();
  504. }
  505. else
  506. {
  507. odC.BcmId = "";
  508. }
  509. odC.PurStandardsCode = txt_purstandardscode.Text;
  510. odC.ItemUomConefficient = Convert.ToDouble(txt_ItemUomConefficient.Text);
  511. odC.ItemUom = txt_UNIT.Text;
  512. odC.WeightUnit = txt_WEIGHTUNIT.Text;
  513. odC.ItemUseUom = "1";
  514. odC.CkQty = ultraTextEditor6.Value == null ? 0 : Convert.ToDouble(ultraTextEditor6.Value);
  515. odC.ItemUnique = init_itemUnique;
  516. odC.ItemStandardsId = init_itemStandardsId;
  517. odC.ItemUomId = init_itemUomId;
  518. odC.ItemAttrId = init_itemAttrId;
  519. if (MessageBox.Show("确定修改合同行[" + odC.OrderLineSqe + "]?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  520. {
  521. return;
  522. }
  523. CoreResult rt2 = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCService", "update_MC", new object[] { odC, uge.Cells["OrderId"].Value.ToString() });
  524. if (rt2.Resultcode != 0)
  525. {
  526. MessageUtil.ShowTips("操作失败!" + rt2.Resultmsg);
  527. return;
  528. }
  529. ////主表合同额跟随从表变化
  530. //OrderM Omg = new OrderM();
  531. //Omg.OrderId = uge.Cells["OrderId"].Value.ToString();
  532. //Omg.WithAmtTax = (uge.Cells["WithAmtTax"].Value == null ? 0 : Convert.ToDouble(uge.Cells["WithAmtTax"].Value.ToString())) - (uRe.Cells["WithAmtTax"].Value == ""? 0 : Convert.ToDouble(uRe.Cells["WithAmtTax"].Value.ToString()))+odC.WithAmtTax;
  533. //Omg.WithoutTaxAmt = (uge.Cells["WithoutTaxAmt"].Value == null ? 0 : Convert.ToDouble(uge.Cells["WithoutTaxAmt"].Value.ToString())) - (uRe.Cells["WithoutTaxAmt"].Value == "" ? 0 : Convert.ToDouble(uRe.Cells["WithoutTaxAmt"].Value.ToString()))+odC.WithoutTaxAmt;
  534. //this.execute("com.hnshituo.pur.order.service.OrderMService", "update", new object[] { Omg });
  535. MessageUtil.ShowTips("修改成功!");
  536. GetPUR_ORDER_M();
  537. doActiveSelRow(ultraGrid1, "OrderId", strOrderId);
  538. getOrderC(strOrderId, odC.OrderLineSqe);
  539. }
  540. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
  541. {
  542. UltraGridRow ugc = ultraGrid4.ActiveRow;
  543. if (ugc == null)
  544. {
  545. MessageUtil.ShowTips("请选择合同发货行!");
  546. return;
  547. }
  548. String strOrderLineDSqe=ugc.GetCellValue("orderLineDSqe").ToString().Trim();
  549. if(string.IsNullOrEmpty(strOrderLineDSqe))
  550. {
  551. MessageUtil.ShowTips("选择的合同发货行编号为空!");
  552. return;
  553. }
  554. //验证是否可以删改
  555. if (testOrderCDStatus(strOrderLineDSqe, 1) == false)
  556. {
  557. return;
  558. }
  559. if (testOrderCD() == false)
  560. {
  561. return;
  562. }
  563. OrderCD orderCD = new OrderCD();
  564. orderCD.DeliveryDateEnd = Convert.ToDateTime(txt_askDeliveryDateEnd.Value);
  565. orderCD.DeliveryDateStart = Convert.ToDateTime(txt_askDeliveryDateStart.Value);
  566. String strOrderLineSqe = ultraGrid2.ActiveRow.Cells["orderLineSqe"].Value.ToString().Trim();
  567. orderCD.OrderLineDSqe = strOrderLineDSqe;
  568. orderCD.OrderLineSqe = strOrderLineSqe;
  569. orderCD.Qty = double.Parse(txt_CD_Qty.Value.ToString().Trim());
  570. orderCD.Remark = txt_orderCD_Remark.Text.ToString().Trim();
  571. orderCD.UpdateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  572. orderCD.UpdateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  573. orderCD.UpdateTime = DateTime.Now;
  574. if (MessageUtil.ShowYesNoAndQuestion("确定修改发货行【" + strOrderLineDSqe + "】?") == DialogResult.No)
  575. {
  576. return;
  577. }
  578. CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCDService", "doUpdateOrderCD", new object[] { orderCD });
  579. if (re.Resultcode == 0)
  580. {
  581. MessageUtil.ShowTips("修改成功");
  582. getOrderC(strOrderId, strOrderLineSqe);
  583. doActiveSelRow(ultraGrid4, "orderLineDSqe", strOrderLineDSqe);
  584. }
  585. else
  586. {
  587. MessageUtil.ShowTips("修改失败:" + re.Resultmsg);
  588. return;
  589. }
  590. }
  591. }
  592. catch (Exception e)
  593. {
  594. MessageUtil.ShowWarning("修改失败! " + e);
  595. return;
  596. }
  597. finally
  598. {
  599. }
  600. }
  601. /// <summary>
  602. /// 查询
  603. /// </summary>
  604. private void GetPUR_ORDER_M()// 查询
  605. {
  606. try
  607. {
  608. this.Cursor = Cursors.WaitCursor;
  609. ClearTab1();
  610. ClearTab2();
  611. ClearTab3();
  612. ClearTab4();
  613. dataSet1.Clear();
  614. dataSet2.Clear();
  615. dataSet3.Clear();
  616. OrderM Odm = new OrderM();
  617. Odm.Status = COPStatus.Value == null ? null : COPStatus.Value.ToString().Trim();
  618. Odm.OrderType = COP_OrderType.Value == null ? null : COP_OrderType.Value.ToString().Trim();
  619. if(CK_Ctime.Checked==true)
  620. {
  621. if (txt_createTimeStart.Text != "")
  622. {
  623. Odm.CreateTime = Convert.ToDateTime(txt_createTimeStart.Value);
  624. }
  625. if (txt_createTimeEnd.Text != "")
  626. {
  627. Odm.UpdateTime = Convert.ToDateTime(txt_createTimeEnd.Value);
  628. }
  629. }
  630. Odm.OrderId = COP_OrderId.Text;
  631. Odm.SuppName = COP_SuppName.Text;
  632. Odm.Validflag = "1";
  633. Odm.ValidDataPurviewIds = this.ValidDataPurviewIds;
  634. Odm.BpmUserId = UserInfo.GetUserID();
  635. string strDataFlag = this.execute<string>("com.hnshituo.pur.utils.service.UtilsService", "getRoleDataFlag", new object[] { UserInfo.GetUserID(), "Pur.order.FrmOrderMNew" });
  636. //if(!Odm.OrderId.Equals("")){
  637. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderMService", "find_OrderM", new object[] { Odm, 0, 0 });
  638. GridHelper.CopyDataToDatatable(dt, dataTable1, true);
  639. // }
  640. }
  641. catch (Exception ex)
  642. {
  643. MessageUtil.ShowTips("查询合同头数据失败:" + ex);
  644. }
  645. finally
  646. {
  647. this.Cursor = Cursors.Default;
  648. }
  649. }
  650. /// <summary>
  651. /// 新增
  652. /// </summary>
  653. private void AddPUR_ORDER_M()// 新增
  654. {
  655. try
  656. {
  657. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[0].Text || ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[3].Text)
  658. {
  659. if (testOrderM() == false)
  660. {
  661. return;
  662. }
  663. OrderM Odm = new OrderM();
  664. Odm.AftPaymentAmt1 = (txt_AftPaymentAmt1.Value == null ? 0 : Convert.ToDouble(txt_AftPaymentAmt1.Text));
  665. Odm.BuyerName = txt_BuyerName.Text;
  666. Odm.ExchangeRateCur = (txt_ExchangeRateCur.Value == null ? 0 : Convert.ToDouble(txt_ExchangeRateCur.Text));
  667. Odm.Currency = txt_Currency.Value.ToString().Trim();
  668. Odm.OrderType = txt_OrderType.Value.ToString().Trim();//合同类别
  669. Odm.OrderClass = txt_OrderClass.Value.ToString().Trim();//合同分类
  670. Odm.ModeName = txt_ModeName.Text;
  671. Odm.ModeId = init_Mode_Id;
  672. Odm.SuppName = txt_SuppName.Text;
  673. Odm.SuppCode = init_Supp_Code;
  674. Odm.OrderMoneyType = txt_OrderMoneyType.Value == null ? null : txt_OrderMoneyType.Value.ToString().Trim();//合同金额分类
  675. Odm.SignDate = Convert.ToDateTime(txt_SignDate.Value);//签订日期
  676. Odm.OrderTitleCode = init_OrderTitleCode;
  677. Odm.BuyerName = UserInfo.GetUserName();
  678. Odm.CreateName = UserInfo.GetUserName();
  679. Odm.CreateUserid = UserInfo.GetUserID();
  680. Odm.CreateTime = DateTime.Now;
  681. Odm.SignAddress = txt_SignAddress.Text;
  682. Odm.TaxRateName = txt_TaxRateName.Value.ToString().Trim();
  683. Odm.DeliveryCondition = txt_deliveryCondition.Value.ToString().Trim();//运输条件
  684. Odm.DeliveryType = txt_deliveryType.Value.ToString().ToString().Trim();//运输方式
  685. Odm.Validflag = "1";
  686. Odm.Status = "1";
  687. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "insert_OrderM", new object[] { Odm });
  688. if (rt.Resultcode != 0)
  689. {
  690. MessageUtil.ShowTips("新增失败!" + rt.Resultmsg);
  691. return;
  692. }
  693. MessageUtil.ShowTips("新增成功!");
  694. GetPUR_ORDER_M();
  695. doActiveSelRow(ultraGrid1, "orderId", rt.Resultmsg);
  696. }
  697. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[1].Text)
  698. {
  699. UltraGridRow uge = ultraGrid1.ActiveRow;
  700. if (uge == null)
  701. {
  702. MessageUtil.ShowTips("请选择合同头!");
  703. return;
  704. }
  705. String strOrderId=uge.Cells["OrderId"].Value.ToString();
  706. if (strOrderId == "")
  707. {
  708. MessageUtil.ShowTips("合同头编号不能为空!");
  709. return;
  710. }
  711. //验证合同头是否可以增删改
  712. if (testOrderMStatus(strOrderId,1) == false)
  713. {
  714. return;
  715. }
  716. //验证填写数据的有效性
  717. if (testOrderC() == false)
  718. {
  719. return;
  720. }
  721. string str = strOrderId;
  722. OrderC odC = new OrderC();
  723. odC.OrderId = str;
  724. odC.ItemCode = txt_ItemCode.Text;
  725. odC.ItemAttr = txt_itemAttrName.Text;
  726. odC.ItemAttrId = init_itemAttrId;
  727. odC.PriceWithoutTax = (txt_PriceWithoutTax.Value == null ? 0 : Convert.ToDouble(txt_PriceWithoutTax.Value));
  728. odC.PriceWithTax = (txt_PriceWithTax.Value == null ? 0 : Convert.ToDouble(txt_PriceWithTax.Value));
  729. //odC.BuyerDeptDesc = txt_BuyerDeptDesc.Text;
  730. odC.PriceWithoutTax = (txt_PriceWithoutTax.Value == null ? 0 : Convert.ToDouble(txt_PriceWithoutTax.Value));
  731. //odC.BuyerUnitDesc = txt_BuyerUnitDesc.Text;
  732. odC.TaxAmt = (txt_TaxAmt2.Value == null ? 0 : Convert.ToDouble(txt_TaxAmt2.Value));
  733. odC.WithoutTaxAmt = (txt_WithoutTaxAmt2.Value == null ? 0 : Convert.ToDouble(txt_WithoutTaxAmt2.Value));
  734. odC.WithAmtTax = (txt_WithAmtTax2.Value == null ? 0 : Convert.ToDouble(txt_WithAmtTax2.Value));
  735. odC.ItemName = txt_ItemName.Text;
  736. odC.BuyerName = txt_BuyerName2.Text;
  737. odC.ChemPriceNo = txt_ChemPriceNo.Text;
  738. //odC.OtherPriceNum = txt_OtherPriceNum.Text;
  739. odC.ReceiveType = txt_ReceiveType.Value.ToString();
  740. odC.StartDate = Convert.ToDateTime(txt_StartDate2.Value);//交货开始时间
  741. odC.EndDate = Convert.ToDateTime(txt_EndDate2.Value);//交货结束时间
  742. odC.GradePriceNo = txt_GradePriceNo.Text;
  743. //odC.BasePriceNo = txt_BasePriceNo.Text;
  744. odC.DeliveryLocationCode = init_deliveryLocationCode;
  745. odC.QuantityPriceNum = txt_QuantityPriceNum.Text;
  746. odC.Remark = txt_Remark.Text.ToString().Trim();
  747. odC.PackageType = txt_packType.Value == null ? null : txt_packType.Value.ToString().Trim();//包装方式
  748. odC.PaymentCode = txt_paymentType.Value == null ? null : txt_paymentType.Value.ToString().Trim();//付款方式
  749. odC.Validflag = "1";
  750. if (txt_Pur_Clause.Value != null)
  751. {
  752. odC.BcmId = txt_Pur_Clause.Value.ToString().Trim();
  753. }
  754. else
  755. {
  756. odC.BcmId = "";
  757. }
  758. odC.CreateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  759. odC.CreateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  760. odC.CreateTime = DateTime.Now;
  761. odC.PurStandardsCode = txt_purstandardscode.Text;
  762. odC.Qty = (txt_Qty.Value == null ? 0 : Convert.ToDouble(txt_Qty.Text));
  763. odC.ItemUomConefficient = Convert.ToDouble(txt_ItemUomConefficient.Text);
  764. odC.ItemUom = txt_UNIT.Text;
  765. odC.WeightUnit = txt_WEIGHTUNIT.Text;
  766. odC.ItemUseUom = "1";
  767. odC.CkQty = ultraTextEditor6.Value == null ? 0 : Convert.ToDouble(ultraTextEditor6.Value);
  768. odC.ItemUnique = init_itemUnique;
  769. odC.ItemStandardsId = init_itemStandardsId;
  770. odC.ItemUomId = init_itemUomId;
  771. odC.ItemAttrId = init_itemAttrId;
  772. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCService", "insert_MC", new object[] { odC, uge.Cells["OrderId"].Value.ToString() });
  773. if (crt.Resultcode != 0)
  774. {
  775. MessageUtil.ShowTips("新增失败!" + crt.Resultmsg);
  776. return;
  777. }
  778. //OrderM Omg = new OrderM();
  779. //Omg.OrderId = uge.Cells["OrderId"].Value.ToString();
  780. //Omg.WithAmtTax = (uge.Cells["WithAmtTax"].Value == null ? 0 : Convert.ToDouble(uge.Cells["WithAmtTax"].Value.ToString())) + odC.WithAmtTax;
  781. //Omg.WithoutTaxAmt = (uge.Cells["WithoutTaxAmt"].Value == null ? 0 : Convert.ToDouble(uge.Cells["WithoutTaxAmt"].Value.ToString())) + odC.WithoutTaxAmt;
  782. //this.execute("com.hnshituo.pur.order.service.OrderMService", "update", new object[] { Omg });
  783. MessageUtil.ShowTips("新增成功!");
  784. GetPUR_ORDER_M();
  785. doActiveSelRow(ultraGrid1, "orderId", odC.OrderId);
  786. getOrderC(odC.OrderId, odC.OrderLineSqe);
  787. }
  788. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
  789. {
  790. try
  791. {
  792. UltraGridRow ugc = ultraGrid2.ActiveRow;
  793. if (ugc == null)
  794. {
  795. MessageUtil.ShowTips("请选择合同头!");
  796. return;
  797. }
  798. String strOrderId = ugc.GetCellValue("orderId").ToString().Trim();
  799. String strOrderLineSqe = ugc.GetCellValue("orderLineSqe").ToString().Trim();
  800. if (strOrderId == "" || strOrderLineSqe == "")
  801. {
  802. MessageUtil.ShowTips("合同行、合同头和合同行编号不能为空!");
  803. return;
  804. }
  805. if (testOrderCD() == false)
  806. {
  807. return;
  808. }
  809. OrderCD orderCD = new OrderCD();
  810. orderCD.DeliveryDateEnd = Convert.ToDateTime(txt_askDeliveryDateEnd.Value);
  811. orderCD.DeliveryDateStart = Convert.ToDateTime(txt_askDeliveryDateStart.Value);
  812. orderCD.Qty = double.Parse(txt_CD_Qty.Value.ToString().Trim());
  813. orderCD.OrderId = strOrderId;
  814. orderCD.OrderLineSqe = strOrderLineSqe;
  815. orderCD.Remark = txt_orderCD_Remark.Text.ToString().Trim();
  816. orderCD.CreateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  817. orderCD.CreateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  818. orderCD.CreateTime = DateTime.Now;
  819. orderCD.Validflag = "1";
  820. orderCD.Status = "0";
  821. CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCDService", "doInsertOrderCD", new object[] { orderCD });
  822. if (re.Resultcode == 0)
  823. {
  824. MessageUtil.ShowTips("新增成功");
  825. getOrderC(strOrderId, strOrderLineSqe);
  826. doActiveSelRow(ultraGrid4, "orderLineDSqe", re.Resultmsg);
  827. }
  828. else
  829. {
  830. MessageUtil.ShowTips("新增失败:"+re.Resultmsg);
  831. return;
  832. }
  833. }
  834. catch (Exception ex)
  835. {
  836. MessageUtil.ShowTips("新增失败:"+ex);
  837. }
  838. }
  839. }
  840. catch (Exception e)
  841. {
  842. MessageUtil.ShowWarning("新增失败" + e);
  843. return;
  844. }
  845. }
  846. /// <summary>
  847. /// 打印预览
  848. /// </summary>
  849. private void getReportHT(String isSign)//打印 签名0显示,1不显示
  850. {
  851. try
  852. {
  853. this.Cursor = Cursors.WaitCursor;
  854. UltraGridRow ugr = ultraGrid1.ActiveRow;
  855. if (ugr == null)
  856. {
  857. MessageUtil.ShowWarning("请选择您要查看的合同!");
  858. return;
  859. }
  860. //string ordLnPk = ugr.Cells["ORD_LN_PK"].Value.ToString();
  861. //string saleOrg = ugr.Cells["SALE_ORG"].Value.ToString();
  862. //string ordPk = ugr.Cells["ORD_PK"].Value.ToString();
  863. string orderNo = ugr.Cells["OrderId"].Value.ToString();
  864. string strurl = "";
  865. DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1223" }, this.ob);
  866. DataRow[] drArr = dt.Select("validflag='1'");
  867. if (drArr.Length != 1)
  868. {
  869. MessageUtil.ShowTips("基础数据维护错误:报表系统需维护有效的Ip且只能维护一个有效ip!");
  870. return;
  871. }
  872. String TipsEnv = drArr[0]["baseName"].ToString();
  873. String strUrlPort = "http://172.54.10.42:8080";//报表系统IP
  874. String[] str = strUrlPort.Split(':');
  875. String strUrl = str[0] + ":" + str[1];
  876. if (ob.MainUrl.StartsWith(strUrl))
  877. {
  878. //测试环境
  879. if (TipsEnv == "2")
  880. {
  881. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo + "&USER=" + isSign;
  882. }
  883. else
  884. {
  885. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo + "&USER=" + isSign;
  886. }
  887. }
  888. else
  889. {
  890. //测试环境
  891. if (TipsEnv == "2")
  892. {
  893. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo + "&USER=" + isSign;
  894. }
  895. else
  896. {
  897. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo + "&USER=" + isSign;
  898. }
  899. }
  900. //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
  901. //{
  902. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo;
  903. //}
  904. //else
  905. //{
  906. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrder.cpt&__bypagesize__=false" + "&cmbOrder=" + orderNo;
  907. //}
  908. FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
  909. fBug.AutoSize = true;
  910. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  911. fBug.WindowState = FormWindowState.Maximized;
  912. fBug.Text = "TPCO合同查询";
  913. fBug.Show();
  914. }
  915. finally
  916. {
  917. this.Cursor = Cursors.Default;
  918. }
  919. }
  920. /// <summary>
  921. /// 打印预览
  922. /// </summary>
  923. private void getReportJY()//打印
  924. {
  925. try
  926. {
  927. this.Cursor = Cursors.WaitCursor;
  928. UltraGridRow ugr = ultraGrid1.ActiveRow;
  929. if (ugr == null)
  930. {
  931. MessageUtil.ShowWarning("请选择您要查看采购纪要的合同头!");
  932. return;
  933. }
  934. //string ordLnPk = ugr.Cells["ORD_LN_PK"].Value.ToString();
  935. //string saleOrg = ugr.Cells["SALE_ORG"].Value.ToString();
  936. //string ordPk = ugr.Cells["ORD_PK"].Value.ToString();
  937. string strTaskRecordId = ugr.Cells["TaskRecordId"].Value.ToString().Trim();
  938. string strurl = "";
  939. DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1223" }, this.ob);
  940. DataRow[] drArr = dt.Select("validflag='1'");
  941. if (drArr.Length != 1)
  942. {
  943. MessageUtil.ShowTips("基础数据维护错误:报表系统需维护有效的Ip且只能维护一个有效ip!");
  944. return;
  945. }
  946. String TipsEnv = drArr[0]["baseName"].ToString();
  947. String strUrlPort = "http://172.54.10.42:8080";//报表系统IP
  948. String[] str = strUrlPort.Split(':');
  949. String strUrl = str[0] + ":" + str[1];
  950. if (ob.MainUrl.StartsWith(strUrl))
  951. {
  952. //测试环境
  953. if (TipsEnv == "2")
  954. {
  955. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
  956. }
  957. //其它为生成环境
  958. else
  959. {
  960. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecord.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
  961. }
  962. }
  963. else
  964. {
  965. //测试环境
  966. if (TipsEnv == "2")
  967. {
  968. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
  969. }
  970. //其它为生成环境
  971. else
  972. {
  973. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecord.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
  974. }
  975. }
  976. //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
  977. //{
  978. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
  979. //}
  980. //else
  981. //{
  982. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
  983. //}
  984. FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
  985. fBug.AutoSize = true;
  986. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  987. fBug.WindowState = FormWindowState.Maximized;
  988. fBug.Text = "TPCO采购纪要查询";
  989. fBug.Show();
  990. }
  991. finally
  992. {
  993. this.Cursor = Cursors.Default;
  994. }
  995. }
  996. #endregion
  997. #region 界面事件
  998. /// <summary>
  999. /// 点击表格 tab1页跳转事件
  1000. /// </summary>
  1001. /// <param name="sender"></param>
  1002. /// <param name="e"></param>
  1003. private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
  1004. {
  1005. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];
  1006. try
  1007. {
  1008. ClearTab1();
  1009. ClearTab2();
  1010. ClearTab4();
  1011. ClearTab3();
  1012. UltraGridRow uge = ultraGrid1.ActiveRow;
  1013. currencylabel1.Text = uge.GetCellValue("Currency").ToString().ToString();
  1014. currencylabel2.Text = uge.GetCellValue("Currency").ToString().ToString();
  1015. currencylabel3.Text = uge.GetCellValue("Currency").ToString().ToString();
  1016. currencylabel4.Text = uge.GetCellValue("Currency").ToString().ToString();
  1017. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  1018. //加载编辑区数据
  1019. OrderM Omg = this.execute<OrderM>("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { strOrderId });
  1020. txt_OrderType.Value = Omg.OrderType == null ? null : Omg.OrderType.ToString();//合同类别
  1021. txt_OrderClass.Value = Omg.OrderClass == null ? null : Omg.OrderClass.ToString().Trim();//合同分类
  1022. txt_Currency.Value = Omg.Currency == null ? null : Omg.Currency.ToString();//合同货币代码
  1023. txt_deliveryCondition.Value = Omg.DeliveryCondition == null ? "" : Omg.DeliveryCondition.ToString().Trim();//运输条件
  1024. txt_deliveryType.Value = Omg.DeliveryType == null ? "" : Omg.DeliveryType.ToString().Trim();//运输条件
  1025. txt_OrderMoneyType.Value = Omg.OrderMoneyType == null ? null : Omg.OrderMoneyType.ToString().Trim();//合同金额类别
  1026. txt_TaxRateName.Value = Omg.TaxRateName == null ? null : Omg.TaxRateName.ToString().Trim();//合同税率
  1027. txt_SignAddress.Text = Omg.SignAddress == null ? null : Omg.SignAddress.ToString();//签订地点
  1028. init_OrderTitleCode = Omg.OrderTitleCode == null ? null : Omg.OrderTitleCode.ToString();//合同抬头编号
  1029. Title title = this.execute<Title>("com.hnshituo.pur.configure.service.TitleService", "findById", new object[] { init_OrderTitleCode });
  1030. if (title != null)
  1031. {
  1032. txt_TitleName.Text = title.TitleName;//合同抬头名称
  1033. }
  1034. txt_BuyerName.Text = Omg.BuyerName == null ? null : Omg.BuyerName.ToString();//采购员
  1035. txt_CreateTime.Value = Omg.CreateTime;//创建时间
  1036. txt_SignDate.Value = Omg.SignDate == null ? null : Omg.SignDate;//签订日期
  1037. txt_SuppName.Text = Omg.SuppName == null ? null : Omg.SuppName.ToString();//供应商名称
  1038. txt_ModeName.Text = Omg.ModeName == null ? null : Omg.ModeName.ToString();//模板名称
  1039. init_Mode_Id = Omg.ModeId;//模板id
  1040. txt_OrderId.Text = Omg.OrderId == null ? null : Omg.OrderId.ToString();//合同号
  1041. init_Supp_Code = Omg.SuppCode;
  1042. txt_TaskRecordId.Text = Omg.TaskRecordId;
  1043. txt_WithAmtTax.Value = Omg.WithAmtTax;//含税金额
  1044. txt_AftPaymentAmt1.Value = Omg.AftPaymentAmt1;//尾款1
  1045. txt_WithoutTaxAmt.Value = Omg.WithoutTaxAmt;//不含税金额
  1046. txt_TaxAmt.Value = Omg.TaxAmt;//合同税额
  1047. //加载从表数据
  1048. OrderC odC = new OrderC();
  1049. odC.OrderId = strOrderId;
  1050. odC.Validflag = "1";
  1051. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCService", "doQueryOrderC", new object[] { odC, 0, 0 });
  1052. GridHelper.CopyDataToDatatable(dt, dataTable2, true);
  1053. //加载任务单数据
  1054. OrderModeC Omc = new OrderModeC();
  1055. Omc.ModeId = Omg.ModeId;
  1056. if (!string.IsNullOrEmpty(Omc.ModeId))
  1057. {
  1058. DataTable dt1 = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderModeCService", "find_ModeC", new object[] { Omc, 0, 0 });
  1059. GridHelper.CopyDataToDatatable(dt1, dataTable3, true);
  1060. }
  1061. //加载采购纪要数据
  1062. string strTaskRecordId = Omg.TaskRecordId;
  1063. PurTaskRecordEntity taskRecord = this.execute<PurTaskRecordEntity>("com.hnshituo.pur.purplan.service.TaskRecordService", "findById", new object[] { strTaskRecordId });
  1064. jy_buyerUsername.Text = taskRecord.BuyerUsername;
  1065. jy_mngOrgName.Text = taskRecord.MngOrgName;
  1066. jy_negDate.Value = taskRecord.NegDate;
  1067. jy_procRecord.Text = taskRecord.ProcRecord;
  1068. jy_taskId.Text = taskRecord.TaskId;
  1069. jy_taskName.Text = taskRecord.TaskName;
  1070. //加载采购纪要评单记录表
  1071. DataTable dt6 = this.execute<DataTable>("com.hnshituo.pur.purplan.service.TaskEvaService", "doQueryEva", new object[] { taskRecord.TaskId });
  1072. GridHelper.CopyDataToDatatable(dt6, dataTable5, true);
  1073. }
  1074. catch (Exception ex)
  1075. {
  1076. MessageUtil.ShowTips("加载合同行和条款数据失败:" + ex);
  1077. }
  1078. }
  1079. private void ultraGrid1_Click(object sender, EventArgs e)
  1080. {
  1081. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];
  1082. }
  1083. /// <summary>
  1084. /// 点击表格 tab2页跳转事件
  1085. /// </summary>
  1086. /// <param name="sender"></param>
  1087. /// <param name="e"></param>
  1088. private void ultraGrid2_ClickCell(object sender, ClickCellEventArgs e)
  1089. {
  1090. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[1];
  1091. ClearTab2();
  1092. ClearTab3();
  1093. UltraGridRow uge1 = ultraGrid1.ActiveRow;
  1094. currencyLabel62.Text = uge1.GetCellValue("Currency").ToString().ToString();
  1095. currencyLabel63.Text = uge1.GetCellValue("Currency").ToString().ToString();
  1096. currencyLabel64.Text = uge1.GetCellValue("Currency").ToString().ToString();
  1097. currencyLabel65.Text = uge1.GetCellValue("Currency").ToString().ToString();
  1098. currencyLabel66.Text = uge1.GetCellValue("Currency").ToString().ToString();
  1099. UltraGridRow uge = ultraGrid2.ActiveRow;
  1100. String strOrderLineSqe = uge.Cells["OrderLineSqe"].Value.ToString();
  1101. if (String.IsNullOrEmpty(strOrderLineSqe))
  1102. {
  1103. MessageUtil.ShowTips("合同行号为空");
  1104. return;
  1105. }
  1106. OrderC Odc = this.execute<OrderC>("com.hnshituo.pur.order.service.OrderCService", "findById", new object[] { strOrderLineSqe });
  1107. txt_ReceiveType.Value = Odc.ReceiveType == null ? null : Odc.ReceiveType.ToString().Trim();//入库类型
  1108. txt_packType.Value = Odc.PackageType == null ? "" : Odc.PackageType.ToString().Trim();//包装方式
  1109. txt_paymentType.Value = Odc.PaymentCode == null ? null : Odc.PaymentCode.ToString().Trim();//付款方式
  1110. txt_Pur_Clause.Value = Odc.BcmId == null ? "" : Odc.BcmId.ToString().Trim();//结算条款
  1111. txt_PriceWithoutTax.Value = Odc.PriceWithoutTax;//不含税单价
  1112. txt_PriceWithTax.Value = Odc.PriceWithTax;//含税单价
  1113. txt_Qty.Value = Odc.Qty = Odc.Qty;//合同数量
  1114. txt_QuantityPriceNum.Text = Odc.QuantityPriceNum == null ? null : Odc.QuantityPriceNum.ToString();//保量加价标准编号
  1115. init_deliveryLocationCode = Odc.DeliveryLocationCode;//交付地点编码
  1116. //txt_BasePriceNo.Value = Odc.BasePriceNo == null ? null : Odc.BasePriceNo.ToString();//基础价格编号
  1117. txt_GradePriceNo.Text = Odc.GradePriceNo == null ? null : Odc.GradePriceNo.ToString();//品级计价标准编号
  1118. //txt_OtherPriceNum.Text = Odc.OtherPriceNum == null ? null : Odc.OtherPriceNum.ToString();//其它计价标准编号
  1119. txt_ChemPriceNo.Text = Odc.ChemPriceNo == null ? null : Odc.ChemPriceNo.ToString();//成分计价标准编号
  1120. //txt_BuyerUnitDesc.Text = Odc.BuyerUnitDesc == null ? null : Odc.BuyerUnitDesc.ToString();//采购管理科室描叙
  1121. txt_ItemName.Text = Odc.ItemName == null ? null : Odc.ItemName.ToString();//物料简称
  1122. //txt_BuyerDeptDesc.Text = Odc.BuyerDeptDesc == null ? null : Odc.BuyerDeptDesc.ToString();//采购管理部门描叙
  1123. txt_itemAttrName.Text = Odc.ItemAttr == null ? null : Odc.ItemAttr.ToString();//物料属性名称
  1124. txt_OrderLineSqe.Text = Odc.OrderLineSqe == null ? null : Odc.OrderLineSqe.ToString();//合同行号
  1125. txt_UNIT.Text = Odc.ItemUom == null ? null : Odc.ItemUom.ToString();
  1126. txt_WEIGHTUNIT.Text = Odc.WeightUnit == null ? null : Odc.WeightUnit.ToString();
  1127. txt_purstandardscode.Text = Odc.ItemStandardsCode;
  1128. txt_Remark.Text = Odc.Remark;
  1129. txt_ItemUomConefficient.Text = Odc.ItemUomConefficient == null ? null : Odc.ItemUomConefficient.ToString();
  1130. ultraTextEditor6.Text = Odc.CkQty.ToString().Trim();
  1131. txt_ItemCode.Text = Odc.ItemCode == null ? null : Odc.ItemCode.ToString();//物料编码
  1132. init_itemAttrId = Odc.ItemAttrId == null ? null : Odc.ItemAttrId.ToString();//物料属性
  1133. init_itemUomId = Odc.ItemUomId;//物料单位换算ID
  1134. init_itemStandardsId = Odc.ItemStandardsId;//采购标准ID
  1135. init_itemUnique = Odc.ItemUnique;//物料唯一码
  1136. txt_StartDate2.Value = Odc.StartDate;//开始交期
  1137. txt_EndDate2.Value = Odc.EndDate;//结束交期
  1138. //加载交货行数据
  1139. Get_OrderCD(txt_OrderLineSqe.Text);
  1140. //计算剩余可编制量
  1141. getRemainQty(txt_OrderLineSqe.Text);
  1142. //初始化交货行交期
  1143. txt_askDeliveryDateEnd.Value = Odc.EndDate;
  1144. }
  1145. private void ultraGrid2_Click(object sender, EventArgs e)
  1146. {
  1147. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[1];
  1148. }
  1149. /// <summary>
  1150. /// 点击表格 tab3页跳转事件
  1151. /// </summary>
  1152. /// <param name="sender"></param>
  1153. /// <param name="e"></param>
  1154. private void ultraGrid4_ClickCell(object sender, ClickCellEventArgs e)
  1155. {
  1156. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[2];
  1157. UltraGridRow ucd = ultraGrid4.ActiveRow;
  1158. txt_CD_Qty.Value = ucd.GetCellValue("qty");
  1159. txt_askDeliveryDateEnd.Value = ucd.GetCellValue("deliveryDateend");
  1160. txt_askDeliveryDateStart.Value = ucd.GetCellValue("deliveryDatestart");
  1161. txt_orderCD_Remark.Text = ucd.GetCellValue("remark").ToString().Trim();
  1162. }
  1163. private void ultraGrid4_Click(object sender, EventArgs e)
  1164. {
  1165. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[2];
  1166. }
  1167. /// <summary>
  1168. /// 控制输入数字
  1169. /// </summary>
  1170. /// <param name="sender"></param>
  1171. /// <param name="e"></param>
  1172. private void txt_QtyOrder_KeyPress(object sender, KeyPressEventArgs e)
  1173. {
  1174. if (!char.IsNumber(e.KeyChar) && e.KeyChar != (char)8)
  1175. {
  1176. e.Handled = true;
  1177. }
  1178. }
  1179. /// <summary>
  1180. /// 金额自动计算
  1181. /// </summary>
  1182. /// <param name="sender"></param>
  1183. /// <param name="e"></param>
  1184. private void txt_QtyOrder_ValueChanged(object sender, EventArgs e)
  1185. {
  1186. String StrTaxRate;
  1187. if (ultraGrid1.ActiveRow != null)
  1188. {
  1189. StrTaxRate = ultraGrid1.ActiveRow.Cells["taxRateName"].Value.ToString().Trim();
  1190. }
  1191. else
  1192. {
  1193. MessageUtil.ShowTips("请在合同信息区域选择有效合同行");
  1194. return;
  1195. }
  1196. if (String.IsNullOrEmpty(StrTaxRate))
  1197. {
  1198. //MessageUtil.ShowTips("获取合同税率失败,请先完善合同信息");
  1199. return;
  1200. }
  1201. if (StrTaxRate == "NULL")
  1202. {
  1203. return;
  1204. }
  1205. Double demiTaxRate = Convert.ToDouble(StrTaxRate.Substring(0, StrTaxRate.Length-1))/100;
  1206. if (!string.IsNullOrEmpty(txt_ItemUomConefficient.Text))
  1207. {
  1208. ultraTextEditor6.Value = Convert.ToDouble(txt_ItemUomConefficient.Value) * Convert.ToDouble(txt_Qty.Value);
  1209. }
  1210. if (txt_PriceWithoutTax.Value !=null && txt_Qty.Value != null)
  1211. {
  1212. txt_WithAmtTax2.Value = Math.Round(Convert.ToDouble(txt_Qty.Value) * Convert.ToDouble(txt_PriceWithoutTax.Value) * (1 + demiTaxRate), 2);
  1213. txt_WithoutTaxAmt2.Value = Convert.ToDouble(txt_Qty.Value) * Convert.ToDouble(txt_PriceWithoutTax.Value);
  1214. txt_TaxAmt2.Value = Math.Round(Convert.ToDouble(txt_WithAmtTax2.Value) - Convert.ToDouble(txt_WithoutTaxAmt2.Value), 2);
  1215. txt_PriceWithTax.Value = Math.Round(Convert.ToDouble(txt_PriceWithoutTax.Value) * (1 + demiTaxRate), 2);
  1216. }
  1217. else
  1218. {
  1219. txt_WithAmtTax2.Value = 0;
  1220. txt_WithoutTaxAmt2.Value = 0;
  1221. txt_TaxAmt2.Value = 0;
  1222. txt_PriceWithTax.Value = 0;
  1223. }
  1224. }
  1225. private void txt_PriceWithoutTax_ValueChanged(object sender, EventArgs e)
  1226. {
  1227. String StrTaxRate;
  1228. if (ultraGrid1.ActiveRow != null)
  1229. {
  1230. StrTaxRate = ultraGrid1.ActiveRow.Cells["taxRateName"].Value.ToString().Trim();
  1231. }
  1232. else
  1233. {
  1234. MessageUtil.ShowTips("请在合同信息区域选择有效合同行");
  1235. return;
  1236. }
  1237. if (String.IsNullOrEmpty(StrTaxRate))
  1238. {
  1239. //MessageUtil.ShowTips("获取合同税率失败,请先完善合同信息");
  1240. return;
  1241. }
  1242. if (StrTaxRate == "NULL")
  1243. {
  1244. return;
  1245. }
  1246. Double demiTaxRate = Convert.ToDouble(StrTaxRate.Substring(0, StrTaxRate.Length - 1))/100;
  1247. if (txt_Qty.Value != null && txt_PriceWithoutTax.Value != null)
  1248. {
  1249. txt_PriceWithTax.Value = Math.Round( Convert.ToDouble(txt_PriceWithoutTax.Value) * (1 + demiTaxRate), 2);
  1250. txt_WithAmtTax2.Value = Math.Round(Convert.ToDouble(txt_Qty.Value) * Convert.ToDouble(txt_PriceWithoutTax.Value) * (1 + demiTaxRate), 2);
  1251. txt_WithoutTaxAmt2.Value = Convert.ToDouble(txt_Qty.Value) * Convert.ToDouble(txt_PriceWithoutTax.Value);
  1252. txt_TaxAmt2.Value = Math.Round(Convert.ToDouble(txt_WithAmtTax2.Value) - Convert.ToDouble(txt_WithoutTaxAmt2.Value), 2);
  1253. }
  1254. else
  1255. {
  1256. txt_WithAmtTax2.Value = 0;
  1257. txt_WithoutTaxAmt2.Value = 0;
  1258. txt_TaxAmt2.Value = 0;
  1259. txt_PriceWithTax.Value = 0;
  1260. }
  1261. }
  1262. /// <summary>
  1263. /// 合同模板弹窗
  1264. /// </summary>
  1265. /// <param name="sender"></param>
  1266. /// <param name="e"></param>
  1267. private void txt_ModeName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1268. {
  1269. FrmPop_upOrderMode Pop = new FrmPop_upOrderMode(this.ob);
  1270. Pop.ShowDialog();
  1271. if (Pop.ModeId == null)
  1272. return;
  1273. txt_ModeName.Text = Pop.ModeName.ToString();
  1274. init_Mode_Id = Pop.ModeId.ToString();
  1275. }
  1276. /// <summary>
  1277. /// 供应商弹窗
  1278. /// </summary>
  1279. /// <param name="sender"></param>
  1280. /// <param name="e"></param>
  1281. private void txt_SuppName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1282. {
  1283. //Supp Sp = new Supp();
  1284. //Sp.Validflag = "1";
  1285. //DataTable dt = this.execute<DataTable>("com.hnshituo.pur.configure.service.SuppService", "find", new object[] { Sp, 0, 0 });
  1286. frmSuppSel Sky = new frmSuppSel(this.ob);
  1287. Sky.ShowDialog();
  1288. if (Sky.strSUPP_CODE == null)
  1289. return;
  1290. txt_SuppName.Text = Sky.strSUPP_NAME.ToString();
  1291. init_Supp_Code = Sky.strSUPP_CODE.ToString();
  1292. txt_TaxRateName.Value = Sky.strSUPP_TAX_RATE.ToString().Trim();
  1293. }
  1294. /// <summary>
  1295. /// 物料弹窗
  1296. /// </summary>
  1297. /// <param name="sender"></param>
  1298. /// <param name="e"></param>
  1299. private void txt_ItemCode_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1300. {
  1301. FrmPurPlanMat mat = new FrmPurPlanMat(this.ob);
  1302. mat.ShowDialog();
  1303. if (mat.getItemCode() == null)
  1304. return;
  1305. if (mat.ItemAttrId == null) //属性编码
  1306. {
  1307. MessageUtil.ShowTips("物料属性为空");
  1308. return;
  1309. }
  1310. if (mat.ItemStandardsId == null)
  1311. {
  1312. MessageUtil.ShowTips("标准编号值为空");
  1313. return;
  1314. }
  1315. if (mat.ItemUomId==null)
  1316. {
  1317. MessageUtil.ShowTips("单位换算为空");
  1318. return;
  1319. }
  1320. txt_ItemCode.Value = mat.getItemCode().ToString();
  1321. txt_ItemName.Value = mat.getItemName().ToString();
  1322. txt_UNIT.Text = mat.UomName.ToString();
  1323. txt_WEIGHTUNIT.Text = mat.getWeightUnit().ToString();
  1324. txt_ReceiveType.Value = mat.getReceiveType().ToString();//默认接收方式
  1325. init_itemAttrId = mat.ItemAttrId == null ? "" : mat.ItemAttrId.ToString();
  1326. txt_itemAttrName.Value = mat.ItemAttr == null ? "" : mat.ItemAttr.ToString();
  1327. txt_ItemUomConefficient.Text = mat.getItemUomConefficient().ToString();
  1328. init_itemAttrId = mat.ItemAttrId;//属性编码
  1329. init_itemStandardsId = mat.ItemStandardsId;//采购标准编码
  1330. init_itemUomId = mat.ItemUomId;//单位换算编码
  1331. init_itemUnique = mat.ItemUnique;
  1332. txt_purstandardscode.Text = mat.StandardsCode;
  1333. //选择新物料后清空数据
  1334. txt_Qty.Value = 0;//合同数量
  1335. txt_PriceWithoutTax.Value = 0;//不含税单价
  1336. }
  1337. /// <summary>
  1338. /// 抬头弹窗
  1339. /// </summary>
  1340. /// <param name="sender"></param>
  1341. /// <param name="e"></param>
  1342. private void txt_TitleName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1343. {
  1344. FrmPop_upTitle Pot = new FrmPop_upTitle(this.ob);
  1345. Pot.ShowDialog();
  1346. if (Pot.Id == null)
  1347. return;
  1348. init_OrderTitleCode = Pot.Id;
  1349. txt_TitleName.Text = Pot.TitleName;
  1350. }
  1351. /// <summary>
  1352. /// 交货行编制数量输入校验
  1353. /// </summary>
  1354. /// <param name="sender"></param>
  1355. /// <param name="e"></param>
  1356. private void txt_CD_Qty_ValueChanged(object sender, EventArgs e)
  1357. {
  1358. if (txt_CD_Qty.Value != null)
  1359. {
  1360. if (ultraGrid4.ActiveRow == null)
  1361. {
  1362. if ((double)txt_CD_Qty.Value > double.Parse(init_MaxOrderCDQty))
  1363. {
  1364. label3.Text = "新增可编制量" + init_MaxOrderCDQty + "[" + init_OrderCDUom + "]";
  1365. //txt_CD_Qty.Value = double.Parse(MaxOrderCDQty);
  1366. //System.Windows.Forms.Application.DoEvents();
  1367. label3.ForeColor = Color.Red;
  1368. label3.Visible = true;
  1369. }
  1370. else
  1371. {
  1372. label3.ForeColor = Color.Black;
  1373. label3.Visible = true;
  1374. }
  1375. }
  1376. else
  1377. {
  1378. double canUse = double.Parse(init_MaxOrderCDQty) + double.Parse(ultraGrid4.ActiveRow.Cells["qty"].Value.ToString().Trim());
  1379. if ((double)txt_CD_Qty.Value > canUse)
  1380. {
  1381. //txt_CD_Qty.Value = canUse;
  1382. label3.Text = "新增可编制量" + init_MaxOrderCDQty + "[" + init_OrderCDUom + "] | 修改可编辑量" + canUse + "[" + init_OrderCDUom + "]";
  1383. //System.Windows.Forms.Application.DoEvents();
  1384. label3.ForeColor = Color.Red;
  1385. label3.Visible = true;
  1386. }
  1387. else
  1388. {
  1389. label3.ForeColor = Color.Black;
  1390. label3.Visible = true;
  1391. }
  1392. }
  1393. }
  1394. }
  1395. /// <summary>
  1396. /// 交货行交货开始时间校验
  1397. /// </summary>
  1398. /// <param name="sender"></param>
  1399. /// <param name="e"></param>
  1400. private void txt_askDeliveryDateStart_ValueChanged(object sender, EventArgs e)// 交货行交货开始时间校验
  1401. {
  1402. if (String.IsNullOrEmpty(txt_askDeliveryDateStart.Text))
  1403. {
  1404. label4.Text = "*无效交期";
  1405. label4.ForeColor = Color.Red;
  1406. label4.Visible = true;
  1407. }
  1408. else
  1409. {
  1410. label4.Visible = false;
  1411. }
  1412. }
  1413. /// <summary>
  1414. /// 交货行交货结束时间校验
  1415. /// </summary>
  1416. /// <param name="sender"></param>
  1417. /// <param name="e"></param>
  1418. private void txt_askDeliveryDateEnd_ValueChanged(object sender, EventArgs e)// 交货行交货结束时间校验
  1419. {
  1420. if (String.IsNullOrEmpty(txt_askDeliveryDateEnd.Text))
  1421. {
  1422. label2.Text = "*无效交期";
  1423. label2.ForeColor = Color.Red;
  1424. label2.Visible = true;
  1425. }
  1426. else
  1427. {
  1428. DateTime timeNow = DateTime.Now;
  1429. label2.Text = "*该交期小于等于当前时间,可能导致供方无法交货";
  1430. if (!String.IsNullOrEmpty(txt_askDeliveryDateStart.Text))
  1431. {
  1432. DateTime timeNow1 = Convert.ToDateTime(txt_askDeliveryDateStart.Value);
  1433. //取当前时间和发货开始时间最大的数
  1434. if (timeNow1 > timeNow)//取发货时间比较
  1435. {
  1436. timeNow = timeNow1;
  1437. label2.Text = "*该交期小于等于发货开始时间,可能导致供方无法交货";
  1438. }
  1439. }
  1440. DateTime inputDate = Convert.ToDateTime(txt_askDeliveryDateEnd.Value);
  1441. if (inputDate <= timeNow)
  1442. {
  1443. label2.ForeColor = Color.Red;
  1444. label2.Visible = true;
  1445. }
  1446. else
  1447. {
  1448. label2.Visible = false;
  1449. }
  1450. }
  1451. }
  1452. /// <summary>
  1453. /// 合同货币类型选择-界面上货币名称变化
  1454. /// </summary>
  1455. /// <param name="sender"></param>
  1456. /// <param name="e"></param>
  1457. private void txt_Currency_ValueChanged(object sender, EventArgs e)
  1458. {
  1459. currencylabel1.Text = txt_Currency.Text;
  1460. currencylabel2.Text = txt_Currency.Text;
  1461. currencylabel3.Text = txt_Currency.Text;
  1462. currencylabel4.Text = txt_Currency.Text;
  1463. currencyLabel62.Text = txt_Currency.Text;
  1464. currencyLabel63.Text = txt_Currency.Text;
  1465. currencyLabel64.Text = txt_Currency.Text;
  1466. currencyLabel65.Text = txt_Currency.Text;
  1467. currencyLabel66.Text = txt_Currency.Text;
  1468. }
  1469. /// <summary>
  1470. /// 创建时间查询控制
  1471. /// </summary>
  1472. /// <param name="sender"></param>
  1473. /// <param name="e"></param>
  1474. private void CK_Ctime_CheckedChanged(object sender, EventArgs e)// 创建时间查询控制
  1475. {
  1476. if (CK_Ctime.Checked == false)
  1477. {
  1478. txt_createTimeEnd.Enabled = false;
  1479. txt_createTimeStart.Enabled = false;
  1480. }
  1481. else
  1482. {
  1483. txt_createTimeEnd.Enabled = true;
  1484. txt_createTimeStart.Enabled = true;
  1485. }
  1486. }
  1487. #endregion
  1488. #region 初始化函数
  1489. /// <summary>
  1490. /// 选择和合同结算
  1491. /// </summary>
  1492. private void Init()
  1493. {
  1494. switch (this.CustomInfo.ToString().Trim())
  1495. {
  1496. case "@Confirma":
  1497. #region
  1498. ultraGrid1.DisplayLayout.Bands[0].Columns["Check"].Hidden = false;
  1499. ultraExpandableGroupBox2.Visible = false;
  1500. COPStatus.SelectedIndex = 3;
  1501. #endregion
  1502. break;
  1503. }
  1504. initDropDownList();
  1505. //合同状态默认全部
  1506. COPStatus.SelectedIndex = 0;
  1507. txt_BuyerName.Text = CoreUserInfo.UserInfo.GetUserName();
  1508. txt_BuyerName2.Text = CoreUserInfo.UserInfo.GetUserName();
  1509. //头初始化
  1510. txt_SignDate.Value = DateTime.Now;//签订日期
  1511. txt_CreateTime.Value = DateTime.Now;//录入日期
  1512. txt_SignAddress.Text = "公司本部";
  1513. //行初始化
  1514. txt_StartDate2.Value = DateTime.Now;//送货开始日期
  1515. txt_EndDate2.Value = DateTime.Now ;//送货结束日期
  1516. CK_Ctime.Checked = true;
  1517. txt_createTimeStart.Value = DateTime.Now.AddDays(-2);
  1518. txt_createTimeEnd.Value = DateTime.Now.AddDays(2);
  1519. //交货行
  1520. txt_askDeliveryDateStart.Value = DateTime.Now;
  1521. txt_askDeliveryDateEnd.Value = DateTime.Now;
  1522. //加载数据 加载太耗费时间
  1523. //GetPUR_ORDER_M();
  1524. //默认收起编辑区
  1525. ultraExpandableGroupBox2.Expanded = false;
  1526. //设置Grid不可编辑
  1527. //SetColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] { });
  1528. SetColumnsActive(ultraGrid2.DisplayLayout.Bands[0], new string[] { });
  1529. SetColumnsActive(ultraGrid3.DisplayLayout.Bands[0], new string[] { });
  1530. SetColumnsActive(ultraGrid4.DisplayLayout.Bands[0], new string[] { });
  1531. SetColumnsActive(ultraGrid6.DisplayLayout.Bands[0], new string[] { });
  1532. }
  1533. /// <summary>
  1534. /// 初始化DropDownList控件
  1535. /// </summary>
  1536. private void initDropDownList()// 初始化DropDownList控件
  1537. {
  1538. //加载结算条款
  1539. BalanceClauseM bm = new BalanceClauseM();
  1540. bm.Validflag = "1";
  1541. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.balance.service.BalanceClauseMService", "doQueryClauseM", new object[] { bm });
  1542. comm.FilComboboxAdd(txt_Pur_Clause, dt, "bcmId", "bcmName", null, true, "/", "");
  1543. //合同类别
  1544. DataTable dt1 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1200" }, this.ob);
  1545. comm.FilComboboxAdd(COP_OrderType, dt1, "baseCode", "baseName", "validflag NOT in ('0')", true, "全部", "");
  1546. COP_OrderType.SelectedIndex = 0;
  1547. comm.FilComboboxAdd(txt_OrderType, dt1, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1548. //合同税率
  1549. DataTable dt2 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1109" }, this.ob);
  1550. comm.FilComboboxAdd(txt_TaxRateName, dt2, "memo", "baseName", "validflag NOT in ('0')", false, "/", "");
  1551. //合同分类
  1552. DataTable dt3 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1220" }, this.ob);
  1553. comm.FilComboboxAdd(txt_OrderClass, dt3, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1554. //货币代码
  1555. //throw new NotImplementedException();
  1556. DataTable dt4 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1001" }, this.ob);
  1557. comm.FilComboboxAdd(txt_Currency, dt4, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1558. txt_Currency.SelectedIndex = 1;
  1559. //接收方式
  1560. DataTable dt5 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1101" }, this.ob);
  1561. comm.FilComboboxAdd(txt_ReceiveType, dt5, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1562. //加载运输条件
  1563. DataTable dt6 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1105" }, this.ob);
  1564. comm.FilComboboxAdd(txt_deliveryCondition, dt6, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
  1565. //加载运输方式
  1566. DataTable dt7 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1102" }, this.ob);
  1567. comm.FilComboboxAdd(txt_deliveryType, dt7, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
  1568. //加载包装方式
  1569. DataTable dt8 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1107" }, this.ob);
  1570. comm.FilComboboxAdd(txt_packType, dt8, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
  1571. //加载付款方式
  1572. DataTable dt9 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1104" }, this.ob);
  1573. comm.FilComboboxAdd(txt_paymentType, dt9, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1574. //加载合同金额分类
  1575. DataTable dt10 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1222" }, this.ob);
  1576. comm.FilComboboxAdd(txt_OrderMoneyType, dt10, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1577. }
  1578. /// <summary>
  1579. /// 清除合同头编辑区
  1580. /// </summary>
  1581. private void ClearTab1()//清除合同头编辑区
  1582. {
  1583. txt_WithAmtTax.Value = 0;//含税金额
  1584. txt_AftPaymentAmt1.Value = 0;//尾款1
  1585. txt_TaxAmt.Value = 0;//合同税额
  1586. txt_WithoutTaxAmt.Value = 0;//不含税金额
  1587. txt_OrderId.Text = "";//合同号
  1588. init_Supp_Code = "";//供应商编码
  1589. init_Mode_Id = "";//合同模板编码
  1590. txt_OrderId.Text = "";//合同编号
  1591. txt_TaskRecordId.Text = "";//采购纪要
  1592. txt_ModeName.Text = "";//合同模板名称
  1593. txt_TitleName.Text = "";//合同头名称
  1594. init_OrderTitleCode = "";//合同头编码
  1595. init_OrderTitleCode = "";//合同头编码
  1596. currencylabel1.Text = "-";
  1597. currencylabel2.Text = "-";
  1598. currencylabel3.Text = "-";
  1599. currencylabel4.Text = "-";
  1600. txt_SignAddress.Value= "公司本部";//签订地点
  1601. txt_BuyerName.Text = "";//采购员
  1602. txt_CreateTime.Value = DateTime.Now;//创建时间
  1603. txt_SignDate.Value = DateTime.Now;//签订日期
  1604. txt_SuppName.Text = "";//供应商名称
  1605. init_Supp_Code = "";//供应商编号
  1606. txt_ModeName.Text = "";//模板名称
  1607. init_Mode_Id = "";//模板id
  1608. txt_TaskRecordId.Text = "";//采购纪要号
  1609. txt_OrderType.SelectedIndex = -1;//合同类别
  1610. txt_Currency.SelectedIndex = -1;//合同货币代码
  1611. txt_OrderClass.SelectedIndex = -1;//合同分类置空
  1612. txt_TaxRateName.SelectedIndex=-1;//税率
  1613. txt_OrderMoneyType.SelectedIndex = -1;//合同金额类别
  1614. txt_deliveryType.SelectedIndex = -1;//运输方式
  1615. txt_deliveryCondition.SelectedIndex = -1;//运输条件
  1616. }
  1617. /// <summary>
  1618. /// 清空合同行编辑区
  1619. /// </summary>
  1620. private void ClearTab2()// 清空合同行编辑区
  1621. {
  1622. //合同行部分
  1623. txt_Qty.Value = 0;//合同数量
  1624. txt_PriceWithTax.Value = 0;//含税单价
  1625. txt_PriceWithoutTax.Value = 0;//不含税单价
  1626. txt_CD_Qty.Value = 0;
  1627. txt_QuantityPriceNum.Text = "";//保量加价标准编号
  1628. init_deliveryLocationCode = "";//交付地点编码
  1629. //txt_BasePriceNo.Text = "";//基础价格编号
  1630. txt_GradePriceNo.Text = "";//品级计价标准编号
  1631. //txt_OtherPriceNum.Text = "";//其它计价标准编号
  1632. txt_ChemPriceNo.Text = "";//成分计价标准编号
  1633. txt_DelvryRangeMin.Text = "";//交货量差下限
  1634. //txt_BuyerUnitDesc.Text = "";//采购管理科室描叙
  1635. txt_ItemName.Text = "";//物料简称
  1636. //txt_BuyerDeptDesc.Text = "";//采购管理部门描叙
  1637. txt_ItemCode.Text = "";//物料编码
  1638. txt_OrderLineSqe.Text = "";//合同行号
  1639. txt_UNIT.Text = "-";
  1640. txt_WEIGHTUNIT.Text = "-";
  1641. txt_purstandardscode.Text = "";
  1642. txt_itemAttrName.Text = "";
  1643. txt_orderCD_Remark.Text = "";
  1644. init_itemUomId = "";//物料单位换算ID
  1645. init_itemStandardsId = "";//采购标准ID
  1646. init_itemAttrId = "";//物料属性编码
  1647. init_itemUnique = "";//物料唯一码
  1648. txt_StartDate2.Value = DateTime.Now;//交期开始
  1649. txt_EndDate2.Value = DateTime.Now;//交期结束
  1650. txt_ReceiveType.SelectedIndex = -1;//接收方式
  1651. txt_Pur_Clause.SelectedIndex = -1;//结算条款
  1652. txt_paymentType.SelectedIndex = -1;//付款方式
  1653. txt_packType.SelectedIndex = -1;//包装方式
  1654. currencyLabel62.Text = "-";
  1655. currencyLabel63.Text = "-";
  1656. currencyLabel64.Text = "-";
  1657. currencyLabel65.Text = "-";
  1658. currencyLabel66.Text = "-";
  1659. }
  1660. /// <summary>
  1661. /// 清空发货行编辑区
  1662. /// </summary>
  1663. private void ClearTab3()// 清空发货行编辑区
  1664. {
  1665. txt_CD_Qty.Value = null;
  1666. txt_orderCD_Remark.Text = "";
  1667. label3.Text = "";
  1668. label3.Visible = false;
  1669. label2.Text = "";
  1670. label2.Visible = false;
  1671. label4.Visible = false;
  1672. txt_askDeliveryDateEnd.Value = DateTime.Now;
  1673. txt_askDeliveryDateStart.Value = DateTime.Now;
  1674. }
  1675. private void ClearTab4()
  1676. {
  1677. ConfigureClassCommon.clearOldData(panel1);
  1678. jy_procRecord.Clear();
  1679. }
  1680. #endregion
  1681. #region 公共函数
  1682. /// <summary>
  1683. ///从表 查询
  1684. /// </summary>
  1685. private void getOrderC(string ab, String lineId)
  1686. {
  1687. dataTable2.Clear();
  1688. dataTable3.Clear();
  1689. OrderC odC = new OrderC();
  1690. odC.OrderId = ab;
  1691. odC.Validflag = "1";
  1692. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCService", "doQueryOrderC", new object[] { odC, 0, 0 });
  1693. GridHelper.CopyDataToDatatable(dt, dataTable2, true);
  1694. ConfigureClassCommon.doActiveSelRow(ultraGrid2, "orderLineSqe", lineId);
  1695. }
  1696. /// <summary>
  1697. /// 查询合同行可生成的交货行数量
  1698. /// </summary>
  1699. /// <param name="strOrderLineSqe"></param>
  1700. /// <returns></returns>
  1701. private void getRemainQty(String strOrderLineSqe)
  1702. {
  1703. CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCDService", "doRemainQty", new object[] { strOrderLineSqe });
  1704. if (re.Resultcode!=0)
  1705. {
  1706. MessageUtil.ShowTips("查询剩余可编制量失败:"+re.Resultmsg);
  1707. return;
  1708. }
  1709. label3.Text = "剩余可编制量" + re.Resultmsg + "[" + re.Resultdata + "]";
  1710. init_MaxOrderCDQty = re.Resultmsg;
  1711. init_OrderCDUom = re.Resultdata == null ? "" : re.Resultdata.ToString();
  1712. //txt_CD_Qty.MaxValue = double.Parse(re.Resultmsg);
  1713. label3.ForeColor = Color.Black;
  1714. label3.Visible = true;
  1715. }
  1716. /// <summary>
  1717. /// 根据合同行号查交货行信息
  1718. /// </summary>
  1719. private void Get_OrderCD(String strOrderLineSqe)
  1720. {
  1721. if (String.IsNullOrEmpty(strOrderLineSqe))
  1722. {
  1723. return;
  1724. }
  1725. else
  1726. {
  1727. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCDService", "doQueryOrderCD", new object[] { strOrderLineSqe });
  1728. GridHelper.CopyDataToDatatable(dt, dataTable4, true);
  1729. }
  1730. }
  1731. /// <summary>
  1732. /// 设置包含在指定列中的列可编辑
  1733. /// </summary>
  1734. /// <param name="band"></param>
  1735. /// <param name="columnKeys"></param>
  1736. public static void SetColumnsActive(UltraGridBand band, params string[] columnKeys)
  1737. {
  1738. foreach (UltraGridColumn gridColumn in band.Columns)
  1739. {
  1740. if (columnKeys.Contains(gridColumn.Key) != true)
  1741. {
  1742. gridColumn.CellActivation = Activation.ActivateOnly;
  1743. }
  1744. }
  1745. }
  1746. /// <summary>
  1747. /// 字符串转是否能转换成非负数
  1748. /// </summary>
  1749. /// <param name="str"></param>
  1750. /// <returns></returns>
  1751. public static bool Is_Below_zero(string str)
  1752. {
  1753. try
  1754. {
  1755. if (str.Equals(""))
  1756. {
  1757. return false;
  1758. }
  1759. else
  1760. {
  1761. if (StringUtil.IsDouble(str) && double.Parse(str) > 0)
  1762. return true;
  1763. else
  1764. return false;
  1765. }
  1766. }
  1767. catch
  1768. {
  1769. return false;
  1770. }
  1771. }
  1772. /// <summary>
  1773. /// 激活输入当前值行数据
  1774. /// </summary>
  1775. /// <param name="ug">ultragrid</param>
  1776. /// <param name="strColumn">列名</param>
  1777. /// <param name="strKey">列值</param>
  1778. public static string doActiveSelRow(UltraGrid ug, string strColumn, string strKey)// 激活输入当前值行数据
  1779. {
  1780. try
  1781. {
  1782. if (strKey != "")
  1783. {
  1784. foreach (UltraGridRow row in ug.Rows)
  1785. {
  1786. if (row.Cells[strColumn].Text.ToString() == strKey)
  1787. {
  1788. row.Activated = true;
  1789. if (row.ChildBands != null)
  1790. row.Expanded = true;
  1791. }
  1792. }
  1793. }
  1794. return "";
  1795. }
  1796. catch (Exception ex)
  1797. {
  1798. return ex.ToString();
  1799. }
  1800. }
  1801. /// <summary>
  1802. /// 验证合同头输入数据有效性
  1803. /// </summary>
  1804. /// <returns></returns>
  1805. private bool testOrderM()// 验证合同头输入数据有效性
  1806. {
  1807. if (string.IsNullOrEmpty(txt_Currency.Text) || txt_Currency.Text.ToString().Trim() == "/")
  1808. {
  1809. MessageUtil.ShowTips("合同货币类型不能为空");
  1810. txt_Currency.Focus();
  1811. return false;
  1812. }
  1813. if (string.IsNullOrEmpty(txt_OrderType.Text) || txt_OrderType.Text.ToString().Trim() == "/")
  1814. {
  1815. MessageUtil.ShowTips("合同类别不能为空!");
  1816. txt_OrderType.Focus();
  1817. return false;
  1818. }
  1819. if (String.IsNullOrEmpty(init_Supp_Code))
  1820. {
  1821. MessageUtil.ShowTips("供应商不能为空,请选择供方信息");
  1822. txt_SuppName.Focus();
  1823. return false;
  1824. }
  1825. if (String.IsNullOrEmpty(txt_TaxRateName.Text))
  1826. {
  1827. MessageUtil.ShowTips("合同税率不允许为空");
  1828. txt_TaxRateName.Focus();
  1829. return false;
  1830. }
  1831. if (String.IsNullOrEmpty(txt_OrderType.Value.ToString().Trim()) || txt_OrderType.Value.ToString().Trim() == "/")
  1832. {
  1833. MessageUtil.ShowTips("未选择合同类别为空,请选择合同类别");
  1834. txt_OrderType.Focus();
  1835. return false;
  1836. }
  1837. if (String.IsNullOrEmpty(init_Mode_Id) || init_Mode_Id == "/")
  1838. {
  1839. MessageUtil.ShowTips("未选择合同模板,请选择合同模板");
  1840. txt_ModeName.Focus();
  1841. return false;
  1842. }
  1843. if (String.IsNullOrEmpty(txt_SignDate.Text))
  1844. {
  1845. MessageUtil.ShowTips("请输入合同签订日期");
  1846. txt_SignDate.Focus();
  1847. return false;
  1848. }
  1849. return true;
  1850. }
  1851. /// <summary>
  1852. /// 验证合同行输入数据的有效性
  1853. /// </summary>
  1854. /// <returns></returns>
  1855. private bool testOrderC()// 验证合同行输入数据的有效性
  1856. {
  1857. if (txt_Qty.Value==null || txt_PriceWithoutTax.Value==null || string.IsNullOrEmpty(txt_ItemCode.Text))
  1858. {
  1859. MessageUtil.ShowTips("合同数,单价,物料不能为空");
  1860. return false;
  1861. }
  1862. if (txt_PriceWithoutTax.Value==null|| txt_PriceWithTax.Value==null)
  1863. {
  1864. MessageUtil.ShowTips("请输入物料有效的含税单价和不含税单价");
  1865. txt_PriceWithoutTax.Focus();
  1866. return false;
  1867. }
  1868. if (String.IsNullOrEmpty(txt_ReceiveType.Text))
  1869. {
  1870. MessageUtil.ShowTips("请选择接收方式");
  1871. txt_ReceiveType.Focus();
  1872. return false;
  1873. }
  1874. if (txt_paymentType.SelectedIndex==-1)
  1875. {
  1876. MessageUtil.ShowTips("请选择付款方式");
  1877. txt_paymentType.Focus();
  1878. return false;
  1879. }
  1880. if (string.IsNullOrEmpty(txt_ItemUomConefficient.Text))
  1881. {
  1882. MessageUtil.ShowTips("转化系数为空");
  1883. txt_ItemUomConefficient.Focus();
  1884. return false;
  1885. }
  1886. if (txt_UNIT.Text == "" || txt_UNIT.Text == "-" || txt_WEIGHTUNIT.Text == "" || txt_WEIGHTUNIT.Text == "-")
  1887. {
  1888. MessageUtil.ShowTips("采购单位或者库存单位无效");
  1889. return false;
  1890. }
  1891. //if (String.IsNullOrEmpty(txt_StartDate2.Text))
  1892. //{
  1893. // MessageUtil.ShowTips("请输入有效的合同行交货开始时间");
  1894. // txt_StartDate2.Focus();
  1895. // return false;
  1896. //}
  1897. if (String.IsNullOrEmpty(txt_EndDate2.Text))
  1898. {
  1899. MessageUtil.ShowTips("请输入有效的合同行交货开始时间");
  1900. txt_EndDate2.Focus();
  1901. return false;
  1902. }
  1903. //if (Convert.ToDateTime(txt_StartDate2.Value) > Convert.ToDateTime(txt_EndDate2.Value))
  1904. //{
  1905. // MessageUtil.ShowTips("交货开始时间不能需早于接收时间,请输入有效的合同行交货开始时间");
  1906. // txt_EndDate2.Focus();
  1907. // return false;
  1908. //}
  1909. return true;
  1910. }
  1911. /// <summary>
  1912. /// 验证交货行输入数据的有效性
  1913. /// </summary>
  1914. /// <returns></returns>
  1915. private bool testOrderCD()// 验证交货行输入数据的有效性
  1916. {
  1917. if (txt_CD_Qty.Value == null)
  1918. {
  1919. MessageUtil.ShowTips("请编制交货行的数量");
  1920. txt_CD_Qty.Focus();
  1921. return false;
  1922. }
  1923. else
  1924. {
  1925. if (!Is_Below_zero(txt_CD_Qty.Value.ToString().Trim()))
  1926. {
  1927. MessageUtil.ShowTips("请编制有效的交货行的数量");
  1928. txt_CD_Qty.Focus();
  1929. return false;
  1930. }
  1931. }
  1932. if (ultraGrid2.ActiveRow == null)
  1933. {
  1934. MessageUtil.ShowTips("请选择合同行");
  1935. return false;
  1936. }
  1937. if (String.IsNullOrEmpty(txt_askDeliveryDateEnd.Text))
  1938. {
  1939. MessageUtil.ShowTips("请输入交货结束时间");
  1940. txt_askDeliveryDateEnd.Focus();
  1941. return false;
  1942. }
  1943. if (String.IsNullOrEmpty(txt_askDeliveryDateStart.Text))
  1944. {
  1945. MessageUtil.ShowTips("请输入交货开始时间");
  1946. txt_askDeliveryDateStart.Focus();
  1947. return false;
  1948. }
  1949. if (Convert.ToDateTime(txt_askDeliveryDateStart.Value) >= Convert.ToDateTime(txt_askDeliveryDateEnd.Value))
  1950. {
  1951. MessageUtil.ShowTips("合同交货行的交货结束时间需大于开始时间");
  1952. txt_askDeliveryDateStart.Focus();
  1953. return false;
  1954. }
  1955. return true;
  1956. }
  1957. /// <summary>
  1958. /// 验证合同行的状态有效性
  1959. /// </summary>
  1960. /// <param name="strOrderLineSqe"></param>
  1961. /// <param name="p"></param>
  1962. /// <returns></returns>
  1963. private bool testOrderCStatus(string strOrderLineSqe, int p)// 验证合同行的状态有效性
  1964. {
  1965. OrderC oc = this.execute<OrderC>("com.hnshituo.pur.order.service.OrderCService", "findById", new object[] { strOrderLineSqe });
  1966. if (oc == null)
  1967. {
  1968. MessageUtil.ShowTips("无合同行【" + strOrderLineSqe + "】的信息记录,可能已被作废,或请刷新界面重新操作!");
  1969. return false;
  1970. }
  1971. if (oc.Validflag=="0")
  1972. {
  1973. MessageUtil.ShowTips("合同行【" + strOrderLineSqe + "】的信息记录可能已被作废,或请刷新界面重新操作!");
  1974. return false;
  1975. }
  1976. String strOrderId = oc.OrderId;
  1977. //是否允许删除
  1978. if (p == 1)
  1979. {
  1980. if (testOrderMStatus(strOrderId, 1) == false)
  1981. {
  1982. return false;
  1983. }
  1984. OrderCD ordercd = new OrderCD();
  1985. ordercd.OrderLineSqe = strOrderLineSqe;
  1986. ordercd.Validflag = "1";
  1987. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCDService", "find", new object[] { ordercd,0,0});
  1988. if (dt != null)
  1989. {
  1990. if (dt.Rows.Count > 0)
  1991. {
  1992. MessageUtil.ShowTips("合同行【" + strOrderLineSqe + "】存在" + dt.Rows.Count + "条有效的合同发货行,请先作废这些合同发货行记录!");
  1993. return false;
  1994. }
  1995. }
  1996. }
  1997. else
  1998. {
  1999. MessageUtil.ShowTips("未知参数,无法验证合同行数据的有效性!");
  2000. return false;
  2001. }
  2002. return true;
  2003. }
  2004. /// <summary>
  2005. /// 验证合同发货行数据的有效性
  2006. /// </summary>
  2007. /// <param name="strOrderLineDSqe"></param>
  2008. /// <param name="p"></param>
  2009. /// <returns></returns>
  2010. private bool testOrderCDStatus(string strOrderLineDSqe, int p)// 验证合同发货行数据的有效性
  2011. {
  2012. OrderCD Ocd = this.execute<OrderCD>("com.hnshituo.pur.order.service.OrderCDService", "findById", new object[] { strOrderLineDSqe });
  2013. if (Ocd == null)
  2014. {
  2015. MessageUtil.ShowTips("无合同发货行【" + strOrderLineDSqe + "】的信息记录,可能已作废,或请刷新界面重新操作!");
  2016. return false;
  2017. }
  2018. if (Ocd.Validflag=="0")
  2019. {
  2020. MessageUtil.ShowTips("合同发货行【" + strOrderLineDSqe + "】的信息记录可能已作废,或请刷新界面重新操作!");
  2021. return false;
  2022. }
  2023. string strStatus = Ocd.Status;
  2024. //是否可以删改
  2025. if (p == 1)
  2026. {
  2027. if (!(strStatus == "0"))
  2028. {
  2029. MessageUtil.ShowTips("已生成发货通知,无法进行删改!");
  2030. return false;
  2031. }
  2032. }
  2033. else
  2034. {
  2035. MessageUtil.ShowTips("未知参数,无法验证合同发货行数据的有效性!");
  2036. return false;
  2037. }
  2038. return true;
  2039. }
  2040. /// <summary>
  2041. /// 验证合同头的状态有效性
  2042. /// </summary>
  2043. /// <param name="strOrderId"></param>
  2044. /// <param name="p"></param>
  2045. /// <returns></returns>
  2046. private bool testOrderMStatus(string strOrderId, int p)// 验证合同头的状态有效性
  2047. {
  2048. OrderM Omg = this.execute<OrderM>("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { strOrderId });
  2049. if (Omg == null)
  2050. {
  2051. MessageUtil.ShowTips("未发现合同【" + strOrderId + "】的信息记录,可能已作废,或请刷新界面重新操作!");
  2052. return false;
  2053. }
  2054. if (Omg.CreateUserid != UserInfo.GetUserID())
  2055. {
  2056. MessageUtil.ShowWarning("非提报该合同本人,无权限进行增删改操作,或请刷新后再操作!");
  2057. return false;
  2058. }
  2059. String tempStatus = Omg.Status.ToString().Trim();
  2060. //验证合同头是否可以增改
  2061. if (p == 1)
  2062. {
  2063. if (tempStatus != "1" )
  2064. {
  2065. MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“待提报”状态,无法进行增删改操作,请刷新后再操作!");
  2066. return false;
  2067. }
  2068. }
  2069. //验证合同是否可以删除
  2070. else if (p == 2)
  2071. {
  2072. if (tempStatus != "1" || tempStatus != "0")
  2073. {
  2074. MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“待提报”或“草稿”状态,无权限进行增删改操作,请刷新后再操作!");
  2075. return false;
  2076. }
  2077. if (Omg.Status != "0")
  2078. {
  2079. OrderC orderc = new OrderC();
  2080. orderc.OrderId = strOrderId;
  2081. orderc.Validflag = "1";
  2082. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCService", "find", new object[] { orderc, 0, 0 });
  2083. if (dt != null)
  2084. {
  2085. if (dt.Rows.Count > 0)
  2086. {
  2087. MessageUtil.ShowTips("合同【" + strOrderId + "】存在" + dt.Rows.Count + "条有效的合同行,请先删除这些合同行!");
  2088. return false;
  2089. }
  2090. }
  2091. }
  2092. }
  2093. //验证是否可以提报
  2094. else if(p==3)
  2095. {
  2096. if ( tempStatus != "1")
  2097. {
  2098. MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“待提报”状态,请刷新后再操作!");
  2099. return false;
  2100. }
  2101. OrderC orderc = new OrderC();
  2102. orderc.OrderId = strOrderId;
  2103. orderc.Validflag = "1";
  2104. List<OrderC> dt = this.execute<List<OrderC>>("com.hnshituo.pur.order.service.OrderCService", "find", new object[] { orderc ,0,0});
  2105. if (dt == null || dt.Count < 1)
  2106. {
  2107. MessageUtil.ShowTips("合同【" + strOrderId + "】无有效的行信息,或请刷新界面重新操作!");
  2108. return false;
  2109. }
  2110. //验证数据的有效性--头有效性
  2111. if (string.IsNullOrEmpty(Omg.Currency))
  2112. {
  2113. MessageUtil.ShowTips("需要完善合同货币类型,该项不能为空!");
  2114. return false;
  2115. }
  2116. if (string.IsNullOrEmpty(Omg.OrderType))
  2117. {
  2118. MessageUtil.ShowTips("需要完善合同类别,该项不能为空!");
  2119. return false;
  2120. }
  2121. if (String.IsNullOrEmpty(Omg.SuppCode))
  2122. {
  2123. MessageUtil.ShowTips("需要完善供方信息,供应商编号不能为空!");
  2124. return false;
  2125. }
  2126. if (String.IsNullOrEmpty(Omg.TaxRateName))
  2127. {
  2128. MessageUtil.ShowTips("需要完善合同税率信息,合同税率不允许为空!");
  2129. return false;
  2130. }
  2131. if (String.IsNullOrEmpty(Omg.ModeId))
  2132. {
  2133. MessageUtil.ShowTips("需要选择合同模板,合同模板不允许为空!");
  2134. return false;
  2135. }
  2136. if (Omg.SignDate==null)
  2137. {
  2138. MessageUtil.ShowTips("需完善合同签订日期,合同签订日期不允许为空");
  2139. txt_SignDate.Focus();
  2140. return false;
  2141. }
  2142. for(int i=0;i<dt.Count;i++)
  2143. {
  2144. OrderC oc=dt[i];
  2145. if (!isRightDoubleWithoutZero(oc.Qty) || string.IsNullOrEmpty(oc.ItemCode))
  2146. {
  2147. MessageUtil.ShowTips("合同行【"+oc.OrderLineSqe+"】的合同数量数,物料未维护,上述项不允许为空!");
  2148. return false;
  2149. }
  2150. if (!isRightDoubleWithZero(oc.PriceWithoutTax) || !isRightDoubleWithZero(oc.PriceWithTax))
  2151. {
  2152. MessageUtil.ShowTips("合同行【"+oc.OrderLineSqe+"】的含税单价和不含税单价未维护,上述项不允许为空!");
  2153. txt_PriceWithoutTax.Focus();
  2154. return false;
  2155. }
  2156. if (String.IsNullOrEmpty(oc.ReceiveType))
  2157. {
  2158. MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的接收方式未维护,上述项不允许为空!");
  2159. return false;
  2160. }
  2161. //if (String.IsNullOrEmpty(oc.DeliveryLocation) || String.IsNullOrEmpty(oc.DeliveryLocationCode))
  2162. //{
  2163. // MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交付地点和地点编码未维护,上述项不能为空!");
  2164. // return false;
  2165. //}
  2166. if (!isRightDoubleWithoutZero(oc.ItemUomConefficient))
  2167. {
  2168. MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的单位转化系数为空,数据异常!");
  2169. return false;
  2170. }
  2171. if (string.IsNullOrEmpty(oc.ItemUom)||string.IsNullOrEmpty(oc.WeightUnit))
  2172. {
  2173. MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的库存单位和采购单位为空,数据异常!");
  2174. return false;
  2175. }
  2176. //if (oc.StartDate==null)
  2177. //{
  2178. // MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货开始时间未维护,上述项不能为空!");
  2179. // return false;
  2180. //}
  2181. if (oc.EndDate==null)
  2182. {
  2183. MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货结束时间未维护,上述项不能为空!");
  2184. return false;
  2185. }
  2186. //if (Convert.ToDateTime(oc.StartDate) > Convert.ToDateTime(oc.EndDate))
  2187. //{
  2188. // MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货开始时间不能需早于接收时间,请维护有效的交货时间!");
  2189. // return false;
  2190. //}
  2191. }
  2192. }
  2193. else if (p == 4)
  2194. {
  2195. if (tempStatus!="2")
  2196. {
  2197. MessageUtil.ShowWarning("合同【" + strOrderId + "】未在“审批中”状态,无权限撤回,请刷新后再操作!");
  2198. return false;
  2199. }
  2200. }
  2201. else
  2202. {
  2203. MessageUtil.ShowTips("未知参数,无法验证合同头数据的有效性!");
  2204. return false;
  2205. }
  2206. return true;
  2207. }
  2208. /// <summary>
  2209. /// 验证是否为非负小数
  2210. /// </summary>
  2211. /// <param name="db"></param>
  2212. /// <returns></returns>
  2213. private bool isRightDoubleWithZero(double? db)// 验证是否为非负小数
  2214. {
  2215. if (db == null)
  2216. {
  2217. return false;
  2218. }
  2219. if (db < 0)
  2220. {
  2221. return false;
  2222. }
  2223. return true;
  2224. }
  2225. /// <summary>
  2226. /// 验证是否为大于0的正数
  2227. /// </summary>
  2228. /// <param name="db"></param>
  2229. /// <returns></returns>
  2230. private bool isRightDoubleWithoutZero(double? db)// 验证是否为大于0的正数
  2231. {
  2232. if (db == null)
  2233. {
  2234. return false;
  2235. }
  2236. if (db <= 0)
  2237. {
  2238. return false;
  2239. }
  2240. return true;
  2241. }
  2242. /// <summary>
  2243. /// 查看流程详情
  2244. /// </summary>
  2245. private void Process()//查看流程详情
  2246. {
  2247. UltraGridRow uge = ultraGrid1.ActiveRow;
  2248. if (uge == null)
  2249. {
  2250. MessageUtil.ShowTips("请选择合同头!");
  2251. return;
  2252. }
  2253. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  2254. ProcInstDetail detail = new ProcInstDetail(BpmFlowConstants.PROCDEF_PUR_ORDER_AUDIT, strOrderId);
  2255. detail.ShowDialog();
  2256. }
  2257. #endregion
  2258. }
  2259. }