FrmOrderMNew.cs 133 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052
  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. using Pur.Balance;
  28. using com.hnshituo.ck;
  29. using Pur.Entity.ck;
  30. using System.Web;
  31. namespace Pur.order
  32. {
  33. public partial class FrmOrderMNew : FrmPmsBase
  34. {
  35. //合同条款区使用变量
  36. string init_bcm_Id = "";
  37. //价格政策
  38. string init_balance_Id = "";
  39. //合同上传
  40. String fileName = "";
  41. int intNum = 2;
  42. public static string suppName = "";
  43. //构造函数
  44. public FrmOrderMNew()
  45. {
  46. InitializeComponent();
  47. this.IsLoadUserView = true;
  48. }
  49. private DataTable dt_addItem = new DataTable();
  50. //load
  51. private void FrmOrderMNew_Load(object sender, EventArgs e)//load
  52. {
  53. DateTime now = DateTime.Now;
  54. txt_StartDate2.Value = now.ToString("yyyy-MM-dd");
  55. //打印参数
  56. txt_printMs.Value = intNum;
  57. ultraExpandableGroupBox1.Expanded = false;
  58. ultraTabControl2.Tabs["change"].Visible = false;
  59. //初始化
  60. Init();
  61. }
  62. #region toolbar工具栏
  63. /// <summary>
  64. /// toolbar菜单
  65. /// </summary>
  66. /// <param name="sender"></param>
  67. /// <param name="ToolbarKey"></param>
  68. public override void ToolBar_Click(object sender, string ToolbarKey)// toolbar菜单
  69. {
  70. switch (ToolbarKey)
  71. {
  72. case "Query":
  73. GetPUR_ORDER_M();
  74. break;
  75. case "Add":
  76. AddPUR_ORDER_M();
  77. break;
  78. case "Update":
  79. UpdPUR_ORDER_M();
  80. break;
  81. case "Delete":
  82. DelPUR_ORDER_M();
  83. break;
  84. case "Submittal":
  85. SubPUR_ORDER_M();
  86. break;
  87. case "Revocation":
  88. RevPUR_ORDER_M("0");
  89. break;
  90. case "RevocationMaster"://已经审批合同撤回
  91. RevPUR_ORDER_M("1");
  92. break;
  93. case "getReport":
  94. getReportHT();
  95. break;
  96. case "getReportJY":
  97. getReportJY();
  98. break;
  99. case "Process":
  100. Process();
  101. break;
  102. case "OrderChange":
  103. OrderChange();
  104. break;
  105. case "UltraGridToExcel":
  106. UltraGridToExcel();
  107. break;
  108. case "FinishedAuditOutline"://一键审批(废除)
  109. FinishedAuditOutline();
  110. break;
  111. case "maintainJhyItem"://批量维护检验项目(废除)
  112. maintainJhyItem();
  113. break;
  114. case "FinishFile"://完成归档
  115. finishFile();
  116. break;
  117. case "ChangeOrder"://合同拆分
  118. ChangeOrder();
  119. break;
  120. case "CancelChangeOrder"://撤销合同拆分
  121. CancelChangeOrder();
  122. break;
  123. case "doClose"://完成归档
  124. this.Close();
  125. break;
  126. }
  127. }
  128. //合同拆分
  129. private void ChangeOrder()
  130. {
  131. UltraGridRow uge = ultraGrid1.ActiveRow;
  132. if (uge == null)
  133. {
  134. MessageUtil.ShowTips("请选择合同头!");
  135. return;
  136. }
  137. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  138. if (String.IsNullOrEmpty(strOrderId))
  139. {
  140. MessageUtil.ShowTips("合同头编号为空!");
  141. return;
  142. }
  143. FrmChangeOrder frm = new FrmChangeOrder(this.ob, strOrderId);
  144. frm.ShowDialog();
  145. if (frm.strTips == "1")
  146. {
  147. GetPUR_ORDER_M();
  148. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  149. getOrderC(strOrderId, "");
  150. }
  151. }
  152. /// <summary>
  153. /// 合同变更申请
  154. /// </summary>
  155. private void OrderChange()
  156. {
  157. UltraGridRow uge = ultraGrid1.ActiveRow;
  158. if (uge == null)
  159. {
  160. MessageUtil.ShowTips("请选择合同头!");
  161. return;
  162. }
  163. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  164. if (String.IsNullOrEmpty(strOrderId))
  165. {
  166. MessageUtil.ShowTips("合同头编号为空!");
  167. return;
  168. }
  169. FrmOrderChange frm = new FrmOrderChange(this.ob, strOrderId);
  170. frm.ShowDialog();
  171. if (frm.strTips == "1")
  172. {
  173. GetPUR_ORDER_M();
  174. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  175. getOrderC(strOrderId, "");
  176. }
  177. }
  178. /// <summary>
  179. /// 导出Excel
  180. /// </summary>
  181. private void UltraGridToExcel()
  182. {
  183. try
  184. {
  185. ArrayList alUltraGrid = new ArrayList();
  186. alUltraGrid.Add(ultraGrid1);
  187. alUltraGrid.Add(ultraGrid2);
  188. alUltraGrid.Add(ultraGrid3);
  189. ArrayList alSheeft = new ArrayList();
  190. alSheeft.Add("合同主表");
  191. alSheeft.Add("合同行表");
  192. alSheeft.Add("合同条款");
  193. if (ultraGrid1.Rows.Count > 0)
  194. {
  195. GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "合同");//导出excel
  196. }
  197. //MessageUtil.ShowTips("导出成功");
  198. }
  199. catch (Exception e)
  200. {
  201. MessageUtil.ShowTips("导出失败" + e.Message);
  202. }
  203. finally
  204. {
  205. }
  206. }
  207. //完成归档
  208. private void finishFile()
  209. {
  210. UltraGridRow uge = ultraGrid1.ActiveRow;
  211. if (uge == null)
  212. {
  213. MessageUtil.ShowTips("请选择合同头!");
  214. return;
  215. }
  216. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  217. if (testOrderMStatus(strOrderId, 8) == false)
  218. {
  219. return;
  220. }
  221. if (MessageBox.Show("确认归档合同[" + strOrderId + "]?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  222. {
  223. return;
  224. }
  225. OrderM Omg = new OrderM();
  226. Omg.OrderId = strOrderId;
  227. Omg.Status = "4";
  228. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "doUpdate", new object[] { Omg });
  229. if (rt.Resultcode != 0)
  230. {
  231. MessageUtil.ShowTips("操作失败:" + rt.Resultmsg);
  232. return;
  233. }
  234. MessageUtil.ShowTips("操作成功!");
  235. GetPUR_ORDER_M();
  236. }
  237. //维护检验项目
  238. private void maintainJhyItem()
  239. {
  240. UltraGridRow uge = ultraGrid1.ActiveRow;
  241. if (uge == null)
  242. {
  243. MessageUtil.ShowTips("请选择合同头!");
  244. return;
  245. }
  246. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  247. frmMaintainJhy frm = new frmMaintainJhy(strOrderId, this.ob);
  248. frm.ShowDialog();
  249. }
  250. private void FinishedAuditOutline()
  251. {
  252. UltraGridRow uge = ultraGrid1.ActiveRow;
  253. if (uge == null)
  254. {
  255. MessageUtil.ShowTips("请选择合同头!");
  256. return;
  257. }
  258. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  259. OrderM Odm = new OrderM();
  260. Odm.OrderId = strOrderId;
  261. Odm.OperatorUserId = UserInfo.GetUserID();
  262. if (testOrderMStatus(strOrderId, 7) == false)
  263. {
  264. return;
  265. }
  266. if (MessageBox.Show("确认该合同[" + strOrderId + "]线下已经完成审批?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  267. {
  268. return;
  269. }
  270. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "finishedAuditOutline", new object[] { Odm });
  271. if (rt.Resultcode != 0)
  272. {
  273. MessageUtil.ShowTips("操作失败:" + rt.Resultmsg);
  274. return;
  275. }
  276. MessageUtil.ShowTips("操作成功!");
  277. GetPUR_ORDER_M();
  278. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  279. getOrderC(strOrderId, "");
  280. }
  281. /// <summary>
  282. /// 撤销提报
  283. /// </summary>
  284. private void RevPUR_ORDER_M(String tips)// 撤销提报
  285. {
  286. UltraGridRow uge = ultraGrid1.ActiveRow;
  287. if (uge == null)
  288. {
  289. MessageUtil.ShowTips("请选择合同头!");
  290. return;
  291. }
  292. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  293. if (String.IsNullOrEmpty(strOrderId))
  294. {
  295. MessageUtil.ShowTips("该合同头编号为空!");
  296. return;
  297. }
  298. //验证合同头是否可以撤销提报
  299. if (tips == "0")
  300. {
  301. if (testOrderMStatus(strOrderId, 4) == false)
  302. {
  303. return;
  304. }
  305. }
  306. else
  307. {
  308. if (testOrderMStatus(strOrderId, 41) == false)
  309. {
  310. return;
  311. }
  312. }
  313. OrderM Odm = new OrderM();
  314. Odm.OrderId = strOrderId;
  315. Odm.Status = "1";
  316. Odm.OperatorUserId = UserInfo.GetUserID();
  317. Odm.DeleteName = tips;
  318. if (MessageBox.Show("确定撤销提报合同【" + uge.Cells["OrderId"].Value.ToString() + "】?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  319. {
  320. return;
  321. }
  322. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "Submittal_OrderM", new object[] { Odm});
  323. if (rt.Resultcode != 0)
  324. {
  325. MessageUtil.ShowTips("撤销提报失败:" + rt.Resultmsg);
  326. return;
  327. }
  328. MessageUtil.ShowTips("操作成功!");
  329. GetPUR_ORDER_M();
  330. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  331. getOrderC(strOrderId, "");
  332. }
  333. /// <summary>
  334. /// 提报
  335. /// </summary>
  336. private void SubPUR_ORDER_M()// 提报
  337. {
  338. UltraGridRow uge = ultraGrid1.ActiveRow;
  339. if (uge == null)
  340. {
  341. MessageUtil.ShowTips("请选择合同头!");
  342. return;
  343. }
  344. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  345. if (String.IsNullOrEmpty(strOrderId))
  346. {
  347. MessageUtil.ShowTips("该合同头编号为空!");
  348. return;
  349. }
  350. //验证合同头是否可以提报
  351. if (testOrderMStatus(strOrderId,3) == false)
  352. {
  353. return;
  354. }
  355. OrderM Odm = new OrderM();
  356. Odm.OrderId = strOrderId;
  357. Odm.Status = "2";
  358. Odm.OperatorUserId = UserInfo.GetUserID();
  359. if (MessageBox.Show("确定提报合同【" + strOrderId + "】?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  360. {
  361. return;
  362. }
  363. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "Submittal_OrderM", new object[] { Odm });
  364. if (rt.Resultcode != 0)
  365. {
  366. MessageUtil.ShowTips("提交失败:" + rt.Resultmsg);
  367. return;
  368. }
  369. MessageUtil.ShowTips("提交成功!");
  370. GetPUR_ORDER_M();
  371. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  372. getOrderC(strOrderId, "");
  373. }
  374. /// <summary>
  375. /// 撤销合同拆分
  376. /// </summary>
  377. private void CancelChangeOrder()// 撤销
  378. {
  379. try
  380. {
  381. ArrayList changeD = new ArrayList();
  382. UltraGridRow uge = ultraGrid1.ActiveRow;
  383. if (uge == null)
  384. {
  385. MessageUtil.ShowTips("请选择合同头!");
  386. return;
  387. }
  388. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  389. if (!strOrderId.Contains("BG"))
  390. {
  391. MessageUtil.ShowTips("不是变更过的合同,不允许撤销!");
  392. return;
  393. }
  394. if (String.IsNullOrEmpty(strOrderId))
  395. {
  396. MessageUtil.ShowTips("该合同头编号为空!");
  397. return;
  398. }
  399. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[0].Text)
  400. {
  401. //验证合同头是否可以删
  402. if (testOrderMStatus(strOrderId, 2) == false)
  403. {
  404. return;
  405. }
  406. OrderM Odm = new OrderM();
  407. Odm.Validflag = "0";
  408. Odm.DeleteName = CoreUserInfo.UserInfo.GetUserName();
  409. Odm.DeleteUserid = CoreUserInfo.UserInfo.GetUserID();
  410. Odm.DeleteTime = DateTime.Now;
  411. Odm.OrderId = strOrderId;
  412. foreach (UltraGridRow urg in ultraGrid9.Rows)
  413. {
  414. OrderChangeD change = new OrderChangeD();
  415. change.Validflag = "1";
  416. change.OrderLineSqe = urg.Cells["ORDERLINESQE"].Text.ToString().Trim();
  417. changeD.Add(change);
  418. }
  419. OrderC orderc = new OrderC();
  420. orderc.OrderId = strOrderId;
  421. orderc.Validflag = "1";
  422. int count = this.execute<int>("com.hnshituo.pur.order.service.OrderCService", "count", new object[] { orderc });
  423. if (count > 0)
  424. {
  425. if (MessageUtil.ShowYesNoAndQuestion("合同:" + strOrderId + "存在" + count + "条有效的合同行,确定一起删除?") != DialogResult.Yes)
  426. {
  427. return;
  428. }
  429. }
  430. else
  431. {
  432. if (strOrderId.EndsWith("BG"))
  433. {
  434. if (MessageBox.Show("确定取消(删除)合同:" + strOrderId + "的变更申请?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  435. {
  436. return;
  437. }
  438. }
  439. else
  440. {
  441. if (MessageBox.Show("确定删除合同:" + strOrderId + "?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  442. {
  443. return;
  444. }
  445. }
  446. }
  447. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "cancelOrderM1", new object[] { Odm,changeD });
  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. }
  456. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[1])
  457. {
  458. UltraGridRow uRe = ultraGrid2.ActiveRow;
  459. if (uRe == null)
  460. {
  461. MessageUtil.ShowTips("请选择需要操作的合同行!");
  462. return;
  463. }
  464. String strOrderLineSqe = uRe.Cells["OrderLineSqe"].Value.ToString().Trim();
  465. if (String.IsNullOrEmpty(strOrderLineSqe))
  466. {
  467. MessageUtil.ShowTips("数据异常,该合同行无合同行号!");
  468. return;
  469. }
  470. if (testOrderCStatus(strOrderLineSqe, 1) == false)
  471. {
  472. return;
  473. }
  474. OrderC odC = new OrderC();
  475. odC.DeleteName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  476. odC.DeleteUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  477. odC.DeleteTime = DateTime.Now;
  478. odC.Validflag = "0";
  479. odC.OrderLineSqe = strOrderLineSqe;
  480. if (MessageBox.Show("确定删除合同行:" + strOrderLineSqe + "?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  481. {
  482. return;
  483. }
  484. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCService", "update_MC", new object[] { odC, strOrderId });
  485. if (rt.Resultcode != 0)
  486. {
  487. Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除失败!" + rt.Resultmsg);
  488. return;
  489. }
  490. MessageUtil.ShowTips("删除成功!");
  491. GetPUR_ORDER_M();
  492. ConfigureClassCommon.doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  493. getOrderC(strOrderId, odC.OrderLineSqe);
  494. }
  495. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
  496. {
  497. UltraGridRow rowclause = ultraGrid3.ActiveRow;
  498. if (rowclause == null)
  499. {
  500. MessageUtil.ShowTips("请选择合同条款行!");
  501. return;
  502. }
  503. String strClauseID = rowclause.Cells["ID"].Value.ToString().Trim();
  504. if (String.IsNullOrEmpty(strClauseID))
  505. {
  506. MessageUtil.ShowTips("该合同条款编号为空!");
  507. return;
  508. }
  509. //验证合同头是否可以增删改
  510. if (testOrderMStatus(strOrderId, 1) == false)
  511. {
  512. return;
  513. }
  514. OrderCClause clause = new OrderCClause();
  515. clause.Id = strClauseID;
  516. clause.OrderId = strOrderId;
  517. clause.Validflag = "0";
  518. clause.DeleteName = UserInfo.GetUserName();
  519. clause.DeleteTime = DateTime.Now;
  520. clause.DeleteUserid = UserInfo.GetUserID();
  521. if (MessageUtil.ShowYesNoAndQuestion("确定删除合同条款:" + strClauseID + "?") != DialogResult.Yes)
  522. {
  523. return;
  524. }
  525. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCClauseService", "doDelete_clause", new object[] { clause });
  526. if (crt.Resultcode != 0)
  527. {
  528. MessageUtil.ShowTips("删除失败!" + crt.Resultmsg);
  529. return;
  530. }
  531. MessageUtil.ShowTips("删除成功!");
  532. getOrderClause(strOrderId, "");
  533. }
  534. if (ultraTabControl2.SelectedTab == ultraTabControl2.Tabs[4])
  535. {
  536. UltraGridRow rowAppend = ultraGrid4.ActiveRow;
  537. if (rowAppend == null)
  538. {
  539. MessageUtil.ShowTips("请选择需删除的附件!");
  540. return;
  541. }
  542. String strAppendID = rowAppend.Cells["ID"].Value.ToString().Trim();
  543. String strcertPath = rowAppend.Cells["CERTPATH"].Value.ToString().Trim();
  544. String strCertPathOld = rowAppend.Cells["CERTPATHOLD"].Value.ToString().Trim();
  545. if (String.IsNullOrEmpty(strAppendID))
  546. {
  547. MessageUtil.ShowTips("该合同附件编号为空!");
  548. return;
  549. }
  550. if (String.IsNullOrEmpty(strCertPathOld))
  551. {
  552. MessageUtil.ShowTips("未获取到合同附件地址信息!");
  553. return;
  554. }
  555. //验证合同头是否可以增删改
  556. if (testOrderAppendStatus(strAppendID, 1) == false)
  557. {
  558. return;
  559. }
  560. OrderAppend append = new OrderAppend();
  561. append.Id = strAppendID;
  562. append.Validflag = "0";
  563. append.DeleteName = UserInfo.GetUserName();
  564. append.DeleteTime = DateTime.Now;
  565. append.DeleteUserid = UserInfo.GetUserID();
  566. if (MessageUtil.ShowYesNoAndQuestion("确定删除合同附件:" + strcertPath + "?") != DialogResult.Yes)
  567. {
  568. return;
  569. }
  570. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderAppendService", "delete_append", new object[] { append });
  571. if (crt.Resultcode != 0)
  572. {
  573. MessageUtil.ShowTips("删除失败!" + crt.Resultmsg);
  574. return;
  575. }
  576. else
  577. {
  578. bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Delete(strCertPathOld);
  579. if (isSuccess)
  580. {
  581. MessageUtil.ShowTips("删除成功");
  582. }
  583. else
  584. {
  585. MessageBox.Show("删除成功");
  586. }
  587. }
  588. getOrderAppend(strOrderId, "");
  589. }
  590. }
  591. catch (Exception e)
  592. {
  593. MessageUtil.ShowTips("操作失败! " + e);
  594. return;
  595. }
  596. }
  597. /// <summary>
  598. /// 删除
  599. /// </summary>
  600. private void DelPUR_ORDER_M()// 删除
  601. {
  602. try
  603. {
  604. UltraGridRow uge = ultraGrid1.ActiveRow;
  605. if (uge == null)
  606. {
  607. MessageUtil.ShowTips("请选择合同头!");
  608. return;
  609. }
  610. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  611. if (String.IsNullOrEmpty(strOrderId))
  612. {
  613. MessageUtil.ShowTips("该合同头编号为空!");
  614. return;
  615. }
  616. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[0].Text)
  617. {
  618. //验证合同头是否可以删
  619. if (testOrderMStatus(strOrderId, 2) == false)
  620. {
  621. return;
  622. }
  623. OrderM Odm = new OrderM();
  624. Odm.Validflag = "0";
  625. Odm.DeleteName = CoreUserInfo.UserInfo.GetUserName();
  626. Odm.DeleteUserid = CoreUserInfo.UserInfo.GetUserID();
  627. Odm.DeleteTime = DateTime.Now;
  628. Odm.OrderId = strOrderId;
  629. OrderC orderc = new OrderC();
  630. orderc.OrderId = strOrderId;
  631. orderc.Validflag = "1";
  632. int count = this.execute<int>("com.hnshituo.pur.order.service.OrderCService", "count", new object[] { orderc });
  633. if (count > 0)
  634. {
  635. if (MessageUtil.ShowYesNoAndQuestion("合同:" + strOrderId + "存在" + count + "条有效的合同行,确定一起删除?") != DialogResult.Yes)
  636. {
  637. return;
  638. }
  639. }
  640. else
  641. {
  642. if (strOrderId.EndsWith("BG"))
  643. {
  644. if (MessageBox.Show("确定取消(删除)合同:" + strOrderId + "的变更申请?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  645. {
  646. return;
  647. }
  648. }
  649. else
  650. {
  651. if (MessageBox.Show("确定删除合同:" + strOrderId + "?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  652. {
  653. return;
  654. }
  655. }
  656. }
  657. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "cancelOrderM", new object[] { Odm });
  658. if (rt.Resultcode != 0)
  659. {
  660. Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("操作失败!" + rt.Resultmsg);
  661. return;
  662. }
  663. MessageUtil.ShowTips("删除成功!");
  664. GetPUR_ORDER_M();
  665. }
  666. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[1])
  667. {
  668. UltraGridRow uRe = ultraGrid2.ActiveRow;
  669. if (uRe == null)
  670. {
  671. MessageUtil.ShowTips("请选择需要操作的合同行!");
  672. return;
  673. }
  674. String strOrderLineSqe = uRe.Cells["OrderLineSqe"].Value.ToString().Trim();
  675. if (String.IsNullOrEmpty(strOrderLineSqe))
  676. {
  677. MessageUtil.ShowTips("数据异常,该合同行无合同行号!");
  678. return;
  679. }
  680. if (testOrderCStatus(strOrderLineSqe, 1) == false)
  681. {
  682. return;
  683. }
  684. OrderC odC = new OrderC();
  685. odC.DeleteName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  686. odC.DeleteUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  687. odC.DeleteTime = DateTime.Now;
  688. odC.Validflag = "0";
  689. odC.OrderLineSqe = strOrderLineSqe;
  690. if (MessageBox.Show("确定删除合同行:" + strOrderLineSqe + "?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  691. {
  692. return;
  693. }
  694. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCService", "update_MC", new object[] { odC, strOrderId });
  695. if (rt.Resultcode != 0)
  696. {
  697. Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除失败!" + rt.Resultmsg);
  698. return;
  699. }
  700. MessageUtil.ShowTips("删除成功!");
  701. GetPUR_ORDER_M();
  702. ConfigureClassCommon.doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  703. getOrderC(strOrderId, odC.OrderLineSqe);
  704. }
  705. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
  706. {
  707. UltraGridRow rowclause = ultraGrid3.ActiveRow;
  708. if (rowclause == null)
  709. {
  710. MessageUtil.ShowTips("请选择合同条款行!");
  711. return;
  712. }
  713. String strClauseID = rowclause.Cells["ID"].Value.ToString().Trim();
  714. if (String.IsNullOrEmpty(strClauseID))
  715. {
  716. MessageUtil.ShowTips("该合同条款编号为空!");
  717. return;
  718. }
  719. //验证合同头是否可以增删改
  720. if (testOrderMStatus(strOrderId, 1) == false)
  721. {
  722. return;
  723. }
  724. OrderCClause clause = new OrderCClause();
  725. clause.Id = strClauseID;
  726. clause.OrderId = strOrderId;
  727. clause.Validflag = "0";
  728. clause.DeleteName = UserInfo.GetUserName();
  729. clause.DeleteTime = DateTime.Now;
  730. clause.DeleteUserid = UserInfo.GetUserID();
  731. if (MessageUtil.ShowYesNoAndQuestion("确定删除合同条款:" + strClauseID + "?")!=DialogResult.Yes)
  732. {
  733. return;
  734. }
  735. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCClauseService", "doDelete_clause", new object[] { clause });
  736. if (crt.Resultcode != 0)
  737. {
  738. MessageUtil.ShowTips("删除失败!" + crt.Resultmsg);
  739. return;
  740. }
  741. MessageUtil.ShowTips("删除成功!");
  742. getOrderClause(strOrderId, "");
  743. }
  744. if (ultraTabControl2.SelectedTab== ultraTabControl2.Tabs[4])
  745. {
  746. UltraGridRow rowAppend = ultraGrid4.ActiveRow;
  747. if (rowAppend == null)
  748. {
  749. MessageUtil.ShowTips("请选择需删除的附件!");
  750. return;
  751. }
  752. String strAppendID = rowAppend.Cells["ID"].Value.ToString().Trim();
  753. String strcertPath = rowAppend.Cells["CERTPATH"].Value.ToString().Trim();
  754. String strCertPathOld = rowAppend.Cells["CERTPATHOLD"].Value.ToString().Trim();
  755. if (String.IsNullOrEmpty(strAppendID))
  756. {
  757. MessageUtil.ShowTips("该合同附件编号为空!");
  758. return;
  759. }
  760. if (String.IsNullOrEmpty(strCertPathOld))
  761. {
  762. MessageUtil.ShowTips("未获取到合同附件地址信息!");
  763. return;
  764. }
  765. //验证合同头是否可以增删改
  766. if (testOrderAppendStatus(strAppendID, 1) == false)
  767. {
  768. return;
  769. }
  770. OrderAppend append = new OrderAppend();
  771. append.Id = strAppendID;
  772. append.Validflag = "0";
  773. append.DeleteName = UserInfo.GetUserName();
  774. append.DeleteTime = DateTime.Now;
  775. append.DeleteUserid = UserInfo.GetUserID();
  776. if (MessageUtil.ShowYesNoAndQuestion("确定删除合同附件:" + strcertPath + "?") != DialogResult.Yes)
  777. {
  778. return;
  779. }
  780. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderAppendService", "delete_append", new object[] { append });
  781. if (crt.Resultcode != 0)
  782. {
  783. MessageUtil.ShowTips("删除失败!" + crt.Resultmsg);
  784. return;
  785. }
  786. else
  787. {
  788. bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Delete(strCertPathOld);
  789. if (isSuccess)
  790. {
  791. MessageUtil.ShowTips("删除成功");
  792. }
  793. else
  794. {
  795. MessageBox.Show("删除成功");
  796. }
  797. }
  798. getOrderAppend(strOrderId,"");
  799. }
  800. }
  801. catch (Exception e)
  802. {
  803. MessageUtil.ShowTips("操作失败! " + e);
  804. return;
  805. }
  806. }
  807. /// <summary>
  808. /// 修改
  809. /// </summary>
  810. private void UpdPUR_ORDER_M()// 修改
  811. {
  812. try
  813. {
  814. UltraGridRow uge = ultraGrid1.ActiveRow;
  815. if (uge == null)
  816. {
  817. MessageUtil.ShowTips("请选择合同头!");
  818. return;
  819. }
  820. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  821. if (strOrderId.EndsWith("BG"))
  822. {
  823. MessageUtil.ShowTips("变更的临时审批合同不允许修改");
  824. return;
  825. }
  826. if(String.IsNullOrEmpty(strOrderId))
  827. {
  828. MessageUtil.ShowTips("该合同头编号为空!");
  829. return;
  830. }
  831. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
  832. {
  833. //验证合同头是否可以改
  834. if (testOrderMStatus(strOrderId, 1) == false)
  835. {
  836. return;
  837. }
  838. //验证合同头输入数据的有效信息
  839. if (testOrderM() == false)
  840. {
  841. return;
  842. }
  843. OrderM Odm = new OrderM();
  844. Odm.Currency = txt_Currency.Value == null ? "" : txt_Currency.Value.ToString().Trim();
  845. Odm.OrderType = txt_OrderType.Value.ToString().Trim();//合同类别
  846. Odm.OrderClass = txt_OrderClass.Value.ToString().Trim();//合同分类
  847. Odm.ExchangeRateCur = (txt_ExchangeRateCur.Value == null ? 0 : Convert.ToDouble(txt_ExchangeRateCur.Text));
  848. Odm.OrderId = strOrderId;
  849. Odm.OrderMoneyType = txt_OrderMoneyType.Value == null ? null : txt_OrderMoneyType.Value.ToString().Trim();
  850. Odm.SignDate = Convert.ToDateTime(txt_SignDate.Value);//签订日期
  851. Odm.SignAddress = txt_SignAddress.Text;
  852. Odm.UpdateName = CoreUserInfo.UserInfo.GetUserName();
  853. Odm.UpdateUserid = CoreUserInfo.UserInfo.GetUserID();
  854. Odm.UpdateTime = DateTime.Now;
  855. Odm.DeliveryCondition = txt_deliveryCondition.Value.ToString().Trim();//运输条件
  856. Odm.DeliveryType = txt_deliveryType.Value.ToString().ToString().Trim();//运输方式
  857. Odm.BuyerName = txt_buy_name.Text.Trim();
  858. Odm.OrderForm = combo_order_type.Text.Trim();
  859. if (MessageBox.Show("确定修改合同头[" + strOrderId + "]?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  860. {
  861. return;
  862. }
  863. CoreResult rt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "doUpdate", new object[] { Odm });
  864. if (rt.Resultcode != 0)
  865. {
  866. Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("操作失败!" + rt.Resultmsg);
  867. return;
  868. }
  869. MessageUtil.ShowTips("操作成功!");
  870. GetPUR_ORDER_M();
  871. doActiveSelRow(ultraGrid1, "orderId", strOrderId);
  872. getOrderC(strOrderId, "");
  873. }
  874. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[1])
  875. {
  876. //验证合同头是否可以删改
  877. if (testOrderMStatus(strOrderId, 1) == false)
  878. {
  879. return;
  880. }
  881. if (testOrderC() == false)
  882. {
  883. return;
  884. }
  885. UltraGridRow uRe = ultraGrid2.ActiveRow;
  886. if (uRe == null)
  887. {
  888. MessageUtil.ShowTips("请选择合同行!");
  889. return;
  890. }
  891. String strOrderLineSqe = uRe.Cells["OrderLineSqe"].Value.ToString().Trim();
  892. if (String.IsNullOrEmpty(strOrderLineSqe))
  893. {
  894. MessageUtil.ShowTips("该合同行编号为空!");
  895. return;
  896. }
  897. OrderC odC = new OrderC();
  898. //odC.OrderId = strOrderId;
  899. odC.OrderLineSqe = strOrderLineSqe;
  900. odC.ReceiveType = txt_ReceiveType.Value.ToString();
  901. if (txt_StartDate2.Text != "")
  902. {
  903. odC.StartDate = Convert.ToDateTime(txt_StartDate2.Value);
  904. }
  905. odC.EndDate = Convert.ToDateTime(txt_EndDate2.Value);//交货结束时间
  906. odC.UpdateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
  907. odC.UpdateUserid = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
  908. odC.UpdateTime = DateTime.Now;
  909. odC.Remark = txt_Remark.Text.ToString().Trim();
  910. odC.PackageType = txt_packType.SelectedIndex==-1?null:txt_packType.Value.ToString().Trim();//包装方式
  911. odC.PaymentCode = txt_paymentType.SelectedIndex == -1? null : txt_paymentType.Value.ToString().Trim();//付款方式
  912. odC.ItemStandardsId = txt_matStand.SelectedIndex == -1 ? "" : txt_matStand.Value.ToString().Trim();
  913. odC.ItemStandardsCode = txt_matStand.SelectedIndex == -1 ? "" : txt_matStand.Text.ToString().Trim();
  914. odC.ConvertCount = uRe.Cells["ConvertCount"].Text.ToString().Replace("_", "").Trim(); // 折算数量
  915. odC.ConvertPrice = uRe.Cells["ConvertPrice"].Value.ToString().Trim(); // 含税折算单价
  916. odC.ConvertPriceTax = uRe.Cells["ConvertPriceTax"].Value.ToString().Trim(); // 不含税折算单价
  917. if (txt_BalanceClauseType.SelectedIndex == 0 || txt_BalanceClauseType.SelectedIndex == 1)
  918. {
  919. odC.BasePriceType = txt_BalanceClauseType.Value.ToString().Trim();
  920. odC.BasePriceName = "";
  921. odC.BasePriceNo = "";
  922. }
  923. else if (txt_BalanceClauseType.SelectedIndex == 2)
  924. {
  925. odC.BasePriceType = txt_BalanceClauseType.Value.ToString().Trim();
  926. if (String.IsNullOrEmpty(txt_balanceClause.Text.Trim()) || String.IsNullOrEmpty(init_balance_Id))
  927. {
  928. MessageUtil.ShowTips("请选择价格政策");
  929. return;
  930. }
  931. odC.BasePriceName = txt_balanceClause.Text;
  932. odC.BasePriceNo = init_balance_Id;
  933. }
  934. else
  935. {
  936. MessageUtil.ShowTips("请选择价格政策类型");
  937. return;
  938. }
  939. if (MessageBox.Show("确定修改合同行[" + odC.OrderLineSqe + "]?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
  940. {
  941. return;
  942. }
  943. CoreResult rt2 = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCService", "update_MC", new object[] { odC, uge.Cells["OrderId"].Value.ToString() });
  944. if (rt2.Resultcode != 0)
  945. {
  946. MessageUtil.ShowTips("操作失败!" + rt2.Resultmsg);
  947. return;
  948. }
  949. MessageUtil.ShowTips("修改成功!");
  950. GetPUR_ORDER_M();
  951. doActiveSelRow(ultraGrid1, "OrderId", strOrderId);
  952. getOrderC(strOrderId, odC.OrderLineSqe);
  953. }
  954. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
  955. {
  956. UltraGridRow rowclause = ultraGrid3.ActiveRow;
  957. if (rowclause == null)
  958. {
  959. MessageUtil.ShowTips("请选择合同条款行!");
  960. return;
  961. }
  962. String strClauseID = rowclause.Cells["ID"].Value.ToString().Trim();
  963. if (String.IsNullOrEmpty(strClauseID))
  964. {
  965. MessageUtil.ShowTips("该合同条款编号为空!");
  966. return;
  967. }
  968. //验证合同头是否可以增删改
  969. if (testOrderMStatus(strOrderId, 1) == false)
  970. {
  971. return;
  972. }
  973. //验证填写数据的有效性
  974. if (testOrderClause() == false)
  975. {
  976. return;
  977. }
  978. OrderCClause clause = new OrderCClause();
  979. clause.ClauseDesc = txt_ClauseDesc.Text.Trim();
  980. clause.ClauseName = txt_ClauseName.Text.Trim();
  981. clause.ClauseIndx = txt_ClauseIndx1.Text.Trim();
  982. clause.ClauseIndxIn = txt_ClauseIndx2.Value.ToString().Trim();
  983. clause.ClauseType = txt_ClauseType.Value.ToString().Trim();
  984. clause.BcmId = init_bcm_Id;
  985. clause.BcmName = txt_Bcm_Name.Text.Trim();
  986. clause.OrderId = strOrderId;
  987. clause.UpdateTime = DateTime.Now;
  988. clause.UpdateUserid = UserInfo.GetUserID();
  989. clause.UpdateName = UserInfo.GetUserName();
  990. clause.Id = strClauseID;
  991. if (MessageUtil.ShowYesNoAndQuestion("确定修改合同条款:" + strClauseID + "?") != DialogResult.Yes)
  992. {
  993. return;
  994. }
  995. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCClauseService", "doUpdate_Clause", new object[] { clause });
  996. if (crt.Resultcode != 0)
  997. {
  998. MessageUtil.ShowTips("修改失败!" + crt.Resultmsg);
  999. return;
  1000. }
  1001. MessageUtil.ShowTips("修改成功!");
  1002. getOrderClause(strOrderId, strClauseID);
  1003. }
  1004. }
  1005. catch (Exception e)
  1006. {
  1007. MessageUtil.ShowTips("修改失败! " + e);
  1008. return;
  1009. }
  1010. finally
  1011. {
  1012. }
  1013. }
  1014. /// <summary>
  1015. /// 查询
  1016. /// </summary>
  1017. private void GetPUR_ORDER_M()// 查询
  1018. {
  1019. try
  1020. {
  1021. this.Cursor = Cursors.WaitCursor;
  1022. ClearTab1();//清空合同头编辑区
  1023. ClearTab2();//清楚合同行编辑区
  1024. ClearTab4();//清除纪要
  1025. change.Clear();
  1026. dataSet1.Clear();
  1027. dataSet2.Clear();
  1028. dataSet3.Clear();
  1029. dataSet4.Clear();
  1030. dataSet5.Clear();
  1031. message.Clear();
  1032. OrderM Odm = new OrderM();
  1033. Odm.Status = COPStatus.Value == null ? null : COPStatus.Value.ToString().Trim();
  1034. Odm.OrderType = COP_OrderType.Value == null ? null : COP_OrderType.Value.ToString().Trim();
  1035. if(CK_Ctime.Checked==true)
  1036. {
  1037. if (txt_createTimeStart.Text != "")
  1038. {
  1039. Odm.CreateTime = Convert.ToDateTime(txt_createTimeStart.Value);
  1040. }
  1041. if (txt_createTimeEnd.Text != "")
  1042. {
  1043. Odm.UpdateTime = Convert.ToDateTime(txt_createTimeEnd.Value);
  1044. }
  1045. }
  1046. Odm.OrderId = COP_OrderId.Text;
  1047. Odm.SuppName = COP_SuppName.Text;
  1048. Odm.Validflag = "1";
  1049. Odm.ValidDataPurviewIds = this.ValidDataPurviewIds;
  1050. Odm.BpmUserId = UserInfo.GetUserID();
  1051. string strDataFlag = this.execute<string>("com.hnshituo.pur.utils.service.UtilsService", "getRoleDataFlag", new object[] { UserInfo.GetUserID(), "Pur.order.FrmOrderMNew" });
  1052. //if (strDataFlag == "0")
  1053. //{
  1054. // Odm.CreateUserid = this.UserInfo.GetUserID();
  1055. //}
  1056. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderMService", "find_OrderM", new object[] { Odm, 0, 0 });
  1057. GridHelper.CopyDataToDatatable(dt, dataTable1, true);
  1058. GridHelper.RefreshAndAutoSize(ultraGrid1);
  1059. }
  1060. catch (Exception ex)
  1061. {
  1062. MessageUtil.ShowTips("查询合同头数据失败:" + ex);
  1063. }
  1064. finally
  1065. {
  1066. this.Cursor = Cursors.Default;
  1067. }
  1068. }
  1069. /// <summary>
  1070. /// 新增
  1071. /// </summary>
  1072. private void AddPUR_ORDER_M()// 新增
  1073. {
  1074. try
  1075. {
  1076. if (ultraTabControl1.SelectedTab.Text == ultraTabControl1.Tabs[2].Text)
  1077. {
  1078. UltraGridRow uge = ultraGrid1.ActiveRow;
  1079. if (uge == null)
  1080. {
  1081. MessageUtil.ShowTips("请选择合同头!");
  1082. return;
  1083. }
  1084. String strOrderId = uge.Cells["OrderId"].Value.ToString();
  1085. if (strOrderId == "")
  1086. {
  1087. MessageUtil.ShowTips("合同头编号不能为空!");
  1088. return;
  1089. }
  1090. //验证合同头是否可以增删改
  1091. if (testOrderMStatus(strOrderId, 1) == false)
  1092. {
  1093. return;
  1094. }
  1095. //验证填写数据的有效性
  1096. if (testOrderClause() == false)
  1097. {
  1098. return;
  1099. }
  1100. OrderCClause clause = new OrderCClause();
  1101. clause.ClauseDesc = txt_ClauseDesc.Text.Trim();
  1102. clause.ClauseName = txt_ClauseName.Text.Trim();
  1103. clause.ClauseIndx = txt_ClauseIndx1.Text.Trim();
  1104. clause.ClauseIndxIn = txt_ClauseIndx2.Value.ToString().Trim();
  1105. clause.ClauseType = txt_ClauseType.Value.ToString().Trim();
  1106. clause.BcmId = init_bcm_Id;
  1107. clause.BcmName = txt_Bcm_Name.Text.Trim();
  1108. clause.OrderId = strOrderId;
  1109. clause.CreateTime = DateTime.Now;
  1110. clause.CreateUserid = UserInfo.GetUserID();
  1111. clause.CreateName = UserInfo.GetUserName();
  1112. clause.Validflag = "1";
  1113. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCClauseService", "insert_Clause", new object[] { clause });
  1114. if (crt.Resultcode != 0)
  1115. {
  1116. MessageUtil.ShowTips("新增失败!" + crt.Resultmsg);
  1117. return;
  1118. }
  1119. MessageUtil.ShowTips("新增成功!");
  1120. getOrderClause(strOrderId, crt.Resultmsg);
  1121. }
  1122. else
  1123. {
  1124. MessageUtil.ShowTips("暂无权限");
  1125. return;
  1126. }
  1127. }
  1128. catch (Exception e)
  1129. {
  1130. MessageUtil.ShowWarning("新增失败" + e);
  1131. return;
  1132. }
  1133. }
  1134. /// <summary>
  1135. /// 打印预览
  1136. /// </summary>
  1137. private void getReportHT()//打印合同
  1138. {
  1139. try
  1140. {
  1141. this.Cursor = Cursors.WaitCursor;
  1142. UltraGridRow ugr = ultraGrid1.ActiveRow;
  1143. if (ugr == null)
  1144. {
  1145. MessageUtil.ShowWarning("请选择您要查看的合同!");
  1146. return;
  1147. }
  1148. //string ordLnPk = ugr.Cells["ORD_LN_PK"].Value.ToString();
  1149. //string saleOrg = ugr.Cells["SALE_ORG"].Value.ToString();
  1150. //string ordPk = ugr.Cells["ORD_PK"].Value.ToString();
  1151. string orderNo = ugr.Cells["OrderId"].Value.ToString();
  1152. if (String.IsNullOrEmpty(orderNo))
  1153. {
  1154. MessageUtil.ShowWarning("请选择合同的合同编号为空!");
  1155. return;
  1156. }
  1157. OrderM Omg = this.execute<OrderM>("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { orderNo });
  1158. if (Omg==null)
  1159. {
  1160. MessageUtil.ShowWarning("未发现合同:" + orderNo+"信息记录");
  1161. return;
  1162. }
  1163. if (String.IsNullOrEmpty(Omg.ModeId))
  1164. {
  1165. MessageUtil.ShowWarning("合同:" + orderNo + "未绑定合同模板导致无法按照模板输出");
  1166. return;
  1167. }
  1168. OrderModeM omm = this.execute<OrderModeM>("com.hnshituo.pur.order.service.OrderModeMService", "findById", new object[] { Omg.ModeId });
  1169. OrderM om=new OrderM();
  1170. om.OrderId=orderNo;
  1171. om.Validflag="1";
  1172. int count = this.execute<int>("com.hnshituo.pur.order.service.OrderCService", "count", new object[] { om });
  1173. string strurl = "";
  1174. DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1223" }, this.ob);
  1175. DataRow[] drArr = dt.Select("validflag='1'");
  1176. if (drArr.Length != 1)
  1177. {
  1178. MessageUtil.ShowTips("基础数据维护错误:报表系统需维护有效的Ip且只能维护一个有效ip!");
  1179. return;
  1180. }
  1181. String TipsEnv = drArr[0]["baseName"].ToString();
  1182. //String TipsNum=drArr[0]["memo1"].ToString();
  1183. //double.TryParse(txt_printMs.Value,out );
  1184. //if(!StringUtil.IsInt(TipsNum))
  1185. //{
  1186. // MessageUtil.ShowTips("基础数据维护错误:报表系统需维护有效物料显示数量!");
  1187. // return;
  1188. //}
  1189. int.TryParse(txt_printMs.Value.ToString(),out intNum);
  1190. String strUrlPort = "http://172.54.10.42:8080";//报表系统IP
  1191. //String strUrlPort = "http://localhost:8075";//报表系统IP
  1192. String[] str = strUrlPort.Split(':');
  1193. String strUrl = str[0] + ":" + str[1];
  1194. String orgName = "1";
  1195. if (ugr.Cells["BuyerDeptCode"].Text.Trim().Contains("002001029"))
  1196. orgName = "1";
  1197. else
  1198. orgName = "2";
  1199. if (ob.MainUrl.StartsWith(strUrl))//
  1200. {
  1201. //测试环境
  1202. if (TipsEnv == "2")
  1203. {
  1204. if (Omg.OrderType == "120024")
  1205. {
  1206. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev_GT.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName;
  1207. }
  1208. else
  1209. {
  1210. if (omm.OrderClass == "122002")
  1211. {
  1212. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMMDev.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName;
  1213. }
  1214. else
  1215. {
  1216. if (count <= intNum)
  1217. {
  1218. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName;
  1219. }
  1220. else
  1221. {
  1222. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMultiDev.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName;
  1223. }
  1224. }
  1225. }
  1226. }
  1227. else
  1228. {
  1229. if (ultraGrid8.Rows.Count == 0)
  1230. {
  1231. if (count <= intNum)
  1232. {
  1233. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName + "&ACOUNT=" + utAccount.Text.Trim();
  1234. }
  1235. else
  1236. {
  1237. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMulti.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName +"&ACOUNT=" + utAccount.Text.Trim();
  1238. }
  1239. }
  1240. else
  1241. {
  1242. if (count <= intNum)
  1243. {
  1244. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderChange.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName + "&ACOUNT=" + utAccount.Text.Trim();
  1245. }
  1246. else
  1247. {
  1248. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMultiChange.cpt&op=view" + "&cmbOrder=" + orderNo + "&ORG_NAME=" + orgName + "&ACOUNT=" + utAccount.Text.Trim();
  1249. }
  1250. }
  1251. }
  1252. }
  1253. else
  1254. {
  1255. if (Omg.OrderType == "120024")
  1256. {
  1257. //strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev_GT.cpt&op=view" + "&cmbOrder=" + orderNo;
  1258. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder_GT.cpt&op=view" + "&cmbOrder=" + orderNo + "&ADDRESS=" + "&ACOUNT= encodeURIComponent(" +utAccount.Text.Trim()+")";
  1259. }
  1260. else
  1261. {
  1262. if (omm.OrderClass == "122002")
  1263. {
  1264. //strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMMDev.cpt&op=view" + "&cmbOrder=" + orderNo;
  1265. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMM.cpt&op=view" + "&cmbOrder=" + orderNo + "&ADDRESS=" + "&ACOUNT= encodeURIComponent(" + utAccount.Text.Trim() + ")";
  1266. }
  1267. else
  1268. {
  1269. if (count <= intNum)
  1270. {
  1271. //strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&op=view" + "&cmbOrder=" + orderNo;
  1272. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder.cpt&op=view" + "&cmbOrder=" + orderNo + "&ADDRESS=" + "&ACOUNT= encodeURIComponent(" + utAccount.Text.Trim() + ")";
  1273. }
  1274. else
  1275. {
  1276. //strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMultiDev.cpt&op=view" + "&cmbOrder=" + orderNo;
  1277. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMulti.cpt&op=view" + "&cmbOrder=" + orderNo + "&ADDRESS=" + "&ACOUNT= encodeURIComponent(" +utAccount.Text.Trim()+")";
  1278. }
  1279. }
  1280. }
  1281. }
  1282. //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
  1283. //{
  1284. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&op=view" + "&cmbOrder=" + orderNo;
  1285. //}
  1286. //else
  1287. //{
  1288. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrder.cpt&op=view" + "&cmbOrder=" + orderNo;
  1289. //}
  1290. FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
  1291. fBug.AutoSize = true;
  1292. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  1293. fBug.WindowState = FormWindowState.Maximized;
  1294. fBug.Text = "TPCO合同查询";
  1295. fBug.Show();
  1296. }
  1297. finally
  1298. {
  1299. this.Cursor = Cursors.Default;
  1300. }
  1301. }
  1302. /// <summary>
  1303. /// 打印预览
  1304. /// </summary>
  1305. private void getReportJY()//打印纪要
  1306. {
  1307. try
  1308. {
  1309. this.Cursor = Cursors.WaitCursor;
  1310. UltraGridRow ugr = ultraGrid1.ActiveRow;
  1311. if (ugr == null)
  1312. {
  1313. MessageUtil.ShowWarning("请选择您要查看采购纪要的合同头!");
  1314. return;
  1315. }
  1316. string strRecordId = ugr.Cells["TaskRecordId"].Value.ToString().Trim();
  1317. if (String.IsNullOrEmpty(strRecordId))
  1318. {
  1319. MessageUtil.ShowTips("采购纪要号为空,可能未生成采购纪要!");
  1320. txt_TaskRecordId.Focus();
  1321. return;
  1322. }
  1323. PurTaskRecordEntity taskRecord = this.execute<PurTaskRecordEntity>("com.hnshituo.pur.purplan.service.TaskRecordService", "findById", new object[] { strRecordId });
  1324. if (taskRecord == null)
  1325. {
  1326. MessageUtil.ShowTips("未发现纪要:" + strRecordId + "信息记录,可能已被作废!或请刷新界面重新操作!");
  1327. return;
  1328. }
  1329. if (taskRecord.Validflag == "0")
  1330. {
  1331. MessageUtil.ShowTips("纪要:" + strRecordId + "信息记录可能已被作废!或请刷新界面重新操作!");
  1332. return;
  1333. }
  1334. String RecordType = taskRecord.Type;
  1335. string strurl = "";
  1336. DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1223" }, this.ob);
  1337. DataRow[] drArr = dt.Select("validflag='1'");
  1338. if (drArr.Length != 1)
  1339. {
  1340. MessageUtil.ShowTips("基础数据维护错误:报表系统需维护有效的Ip且只能维护一个有效ip!");
  1341. return;
  1342. }
  1343. String TipsEnv = drArr[0]["baseName"].ToString();
  1344. String strUrlPort = "http://172.54.10.42:8080";//报表系统IP
  1345. String[] str = strUrlPort.Split(':');
  1346. String strUrl = str[0] + ":" + str[1];
  1347. if (ob.MainUrl.StartsWith(strUrl))
  1348. {
  1349. if (RecordType == "1")//价格
  1350. {
  1351. //测试环境
  1352. if (TipsEnv == "2")
  1353. {
  1354. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepJGRecordDev.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
  1355. }
  1356. else
  1357. {
  1358. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepJGRecord.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
  1359. }
  1360. }
  1361. else
  1362. {
  1363. //测试环境
  1364. if (TipsEnv == "2")
  1365. {
  1366. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
  1367. }
  1368. else
  1369. {
  1370. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecord.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
  1371. }
  1372. }
  1373. }
  1374. else
  1375. {
  1376. if (RecordType == "1")//价格
  1377. {
  1378. //测试环境
  1379. if (TipsEnv == "2")
  1380. {
  1381. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepJGRecordDev.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
  1382. }
  1383. else
  1384. {
  1385. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepJGRecord.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
  1386. }
  1387. }
  1388. else
  1389. {
  1390. //测试环境
  1391. if (TipsEnv == "2")
  1392. {
  1393. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
  1394. }
  1395. else
  1396. {
  1397. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepTaskRecord.cpt&op=view" + "&cmbTaskRecordId=" + strRecordId;
  1398. }
  1399. }
  1400. }
  1401. //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
  1402. //{
  1403. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
  1404. //}
  1405. //else
  1406. //{
  1407. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepTaskRecordDev.cpt&__bypagesize__=false" + "&cmbTaskRecordId=" + strTaskRecordId;
  1408. //}
  1409. FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
  1410. fBug.AutoSize = true;
  1411. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  1412. fBug.WindowState = FormWindowState.Maximized;
  1413. fBug.Text = "TPCO采购纪要查询";
  1414. fBug.Show();
  1415. }
  1416. finally
  1417. {
  1418. this.Cursor = Cursors.Default;
  1419. }
  1420. }
  1421. #endregion
  1422. #region 界面事件
  1423. /// <summary>
  1424. /// 点击表格 tab1页跳转事件
  1425. /// </summary>
  1426. /// <param name="sender"></param>
  1427. /// <param name="e"></param>
  1428. private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
  1429. {
  1430. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];
  1431. try
  1432. {
  1433. ClearTab1();
  1434. ClearTab2();
  1435. ClearTab3();
  1436. ClearTab4();
  1437. dataTable2.Clear();
  1438. dataTable3.Clear();
  1439. dataTable5.Clear();
  1440. dataTable4.Clear();
  1441. dataSet5.Clear();
  1442. message.Clear();
  1443. UltraGridRow uge = ultraGrid1.ActiveRow;
  1444. currencylabel1.Text = uge.GetCellValue("Currency").ToString().ToString();
  1445. currencylabel4.Text = uge.GetCellValue("Currency").ToString().ToString();
  1446. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  1447. //加载编辑区数据
  1448. OrderM Omg = this.execute<OrderM>("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { strOrderId });
  1449. txt_OrderType.Value = Omg.OrderType == null ? null : Omg.OrderType.ToString();//合同类别
  1450. txt_OrderClass.Value = Omg.OrderClass == null ? null : Omg.OrderClass.ToString().Trim();//合同分类
  1451. txt_Currency.Value = Omg.Currency == null ? null : Omg.Currency.ToString();//合同货币代码
  1452. txt_deliveryCondition.Value = Omg.DeliveryCondition == null ? "" : Omg.DeliveryCondition.ToString().Trim();//运输条件
  1453. txt_deliveryType.Value = Omg.DeliveryType == null ? "" : Omg.DeliveryType.ToString().Trim();//运输条件
  1454. txt_OrderMoneyType.Value = Omg.OrderMoneyType == null ? null : Omg.OrderMoneyType.ToString().Trim();//合同金额类别
  1455. txt_SignAddress.Text = Omg.SignAddress == null ? null : Omg.SignAddress.ToString();//签订地点
  1456. if (!String.IsNullOrEmpty(Omg.OrderTitleCode))
  1457. {
  1458. Title title = this.execute<Title>("com.hnshituo.pur.configure.service.TitleService", "findById", new object[] { Omg.OrderTitleCode });
  1459. if (title != null)
  1460. {
  1461. txt_TitleName.Text = title.TitleName;//合同抬头名称
  1462. }
  1463. }
  1464. txt_CreateTime.Value = Omg.CreateTime;//创建时间
  1465. txt_SignDate.Value = Omg.SignDate == null ? null : Omg.SignDate;//签订日期
  1466. txt_ModeName.Text = Omg.ModeName == null ? null : Omg.ModeName.ToString();//模板名称
  1467. txt_OrderId.Text = Omg.OrderId == null ? null : Omg.OrderId.ToString();//合同号
  1468. txt_TaskRecordId.Text = Omg.TaskRecordId;
  1469. txt_AftPaymentAmt1.Value = Omg.AftPaymentAmt1;//尾款1
  1470. txt_buy_name.Text = Omg.BuyerName;
  1471. //加载从表数据
  1472. getOrderC(strOrderId, "");
  1473. //加载条款数据
  1474. getOrderClause(strOrderId,"");
  1475. //加载采购纪要数据
  1476. string strTaskRecordId = Omg.TaskRecordId;
  1477. if (!String.IsNullOrEmpty(strTaskRecordId))
  1478. {
  1479. getTaskRecord(strTaskRecordId);
  1480. }
  1481. getOrderAppend(strOrderId, "");
  1482. //加载评审意见
  1483. getOrderReview(strOrderId);
  1484. //加载变更记录
  1485. getOrderChangeRecord(strOrderId);
  1486. UltraGridRow urg = ultraGrid1.ActiveRow;
  1487. if(urg!=null)
  1488. {
  1489. suppName = urg.Cells["SuppName"].Text.ToString();
  1490. }
  1491. }
  1492. catch (Exception ex)
  1493. {
  1494. MessageUtil.ShowTips("加载合同行和条款数据失败:" + ex);
  1495. }
  1496. }
  1497. private void ultraGrid1_Click(object sender, EventArgs e)
  1498. {
  1499. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];
  1500. }
  1501. /// <summary>
  1502. /// 点击表格 tab2页跳转事件
  1503. /// </summary>
  1504. /// <param name="sender"></param>
  1505. /// <param name="e"></param>
  1506. private void ultraGrid2_ClickCell(object sender, ClickCellEventArgs e)
  1507. {
  1508. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[1];
  1509. dataSet5.Clear();
  1510. ClearTab2();
  1511. UltraGridRow uge1 = ultraGrid1.ActiveRow;
  1512. currencyLabel66.Text = uge1.GetCellValue("Currency").ToString().ToString();
  1513. UltraGridRow uge = ultraGrid2.ActiveRow;
  1514. String strOrderLineSqe = uge.Cells["OrderLineSqe"].Value.ToString();
  1515. if (String.IsNullOrEmpty(strOrderLineSqe))
  1516. {
  1517. MessageUtil.ShowTips("合同行号为空");
  1518. return;
  1519. }
  1520. //加载物料信息
  1521. OrderC Odc = this.execute<OrderC>("com.hnshituo.pur.order.service.OrderCService", "findById", new object[] { strOrderLineSqe });
  1522. PurMatStandardsEntity stand = new PurMatStandardsEntity();
  1523. stand.ItemCode = Odc.ItemCode;
  1524. stand.Validflag = "1";
  1525. DataTable dt3 = this.execute<DataTable>("com.hnshituo.pur.configure.service.MatStandardsService", "find", new object[] { stand,0,0});
  1526. PublicTools.publicPms.FilComboboxAdd(txt_matStand, dt3, "itemStandardsId", "standardsCode", "", true, "/", "");
  1527. txt_matStand.Value = Odc.ItemStandardsId;
  1528. txt_ReceiveType.Value = Odc.ReceiveType == null ? null : Odc.ReceiveType.ToString().Trim();//入库类型
  1529. txt_packType.Value = Odc.PackageType == null ? "" : Odc.PackageType.ToString().Trim();//包装方式
  1530. txt_paymentType.Value = Odc.PaymentCode == null ? null : Odc.PaymentCode.ToString().Trim();//付款方式
  1531. txt_ChemPriceNo.Text = Odc.ChemPriceNo == null ? null : Odc.ChemPriceNo.ToString();//成分计价标准编号
  1532. txt_EndDate2.Value = Odc.EndDate;//结束交期
  1533. txt_StartDate2.Value = Odc.StartDate;//开始交期
  1534. txt_Remark.Text = Odc.Remark;
  1535. txt_BalanceClauseType.Value = Odc.BasePriceType;
  1536. txt_balanceClause.Value = Odc.BasePriceName;
  1537. init_balance_Id = Odc.BasePriceNo;
  1538. //加载检验项目从表
  1539. if (!String.IsNullOrEmpty(Odc.ItemCode) && !String.IsNullOrEmpty(Odc.ItemStandardsId))
  1540. {
  1541. //加载可选的标准信息
  1542. MatStdBaseinfo basei = new MatStdBaseinfo();
  1543. basei.ItemCode = Odc.ItemCode;
  1544. basei.Validflag = "1";
  1545. DataTable dtStad = this.execute<DataTable>("com.hnshituo.pur.jhy.service.MatStdBaseinfo_jhyService", "find", new object[] { basei, 0, 0 });
  1546. comm.FilComboboxAdd(cb_standardsCode, dtStad, "mic", "standardsCode", "validflag NOT in ('0')", true, "全部", "");
  1547. //加载合同默认检验标准信息
  1548. getStdDetail(strOrderLineSqe);
  1549. }
  1550. GridHelper.RefreshAndAutoSize(ultraGrid5);
  1551. }
  1552. /// <summary>
  1553. /// 加载检验项目
  1554. /// </summary>
  1555. /// <param name="strOrderLineSqe"></param>
  1556. private void getStdDetail(String strOrderLineSqe)
  1557. {
  1558. OrderCStdDetail detailstd = new OrderCStdDetail();
  1559. detailstd.OrderLineSqe = strOrderLineSqe;
  1560. detailstd.Validflag = "1";
  1561. DataTable list_detail = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCStdDetailService", "find", new object[] { detailstd, 0, 0 });
  1562. GridHelper.CopyDataToDatatable(list_detail, dataTable11, true);
  1563. OrderCStdBaseinfo baseInfo = new OrderCStdBaseinfo();
  1564. baseInfo.OrderLineSqe = strOrderLineSqe;
  1565. baseInfo.Validflag = "1";
  1566. List<OrderCStdBaseinfo> list_baseInfo = this.execute<List<OrderCStdBaseinfo>>("com.hnshituo.pur.order.service.OrderCStdBaseinfoService", "find", new object[] { baseInfo, 0, 0 });
  1567. if (list_baseInfo != null && list_baseInfo.Count > 0)
  1568. {
  1569. cb_standardsCode.Text = list_baseInfo[0].StandardsCode;
  1570. }
  1571. }
  1572. private void ultraGrid2_Click(object sender, EventArgs e)
  1573. {
  1574. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[1];
  1575. }
  1576. private void ultraGrid3_ClickCell(object sender, ClickCellEventArgs e)
  1577. {
  1578. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[2];
  1579. ClearTab3();
  1580. UltraGridRow row =e.Cell.Row;
  1581. String strId = row.GetCellValue("ID").ToString().Trim();
  1582. OrderCClause clauseC = this.execute<OrderCClause>("com.hnshituo.pur.order.service.OrderCClauseService", "findById", new object[] { strId });
  1583. txt_Clauseid.Text = strId;
  1584. txt_ClauseIndx1.Text = clauseC.ClauseIndx;//打印顺序1
  1585. txt_ClauseIndx2.Value =clauseC.ClauseIndxIn;//打印顺序2
  1586. txt_ClauseName.Text = clauseC.ClauseName;
  1587. txt_ClauseOldId.Text =clauseC.ClauseIdOld;
  1588. txt_ClauseType.Value =clauseC.ClauseType;
  1589. txt_ClauseDesc.Text =clauseC.ClauseDesc;
  1590. txt_Bcm_Name.Text = clauseC.BcmName==null?"":clauseC.BcmName;
  1591. init_bcm_Id = clauseC.BcmId==null?"": clauseC.BcmId;
  1592. }
  1593. private void ultraGrid3_Click(object sender, EventArgs e)
  1594. {
  1595. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[2];
  1596. }
  1597. private void ultraGrid4_Click(object sender, EventArgs e)
  1598. {
  1599. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[3];
  1600. }
  1601. private void ultraGrid4_ClickCell(object sender, ClickCellEventArgs e)
  1602. {
  1603. this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[3];
  1604. }
  1605. /// <summary>
  1606. /// 合同模板弹窗
  1607. /// </summary>
  1608. /// <param name="sender"></param>
  1609. /// <param name="e"></param>
  1610. private void txt_ModeName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1611. {
  1612. String strOrderType = txt_OrderType.SelectedIndex == -1 ? "" : txt_OrderType.Value.ToString().Trim();
  1613. FrmPop_upOrderMode Pop = new FrmPop_upOrderMode(this.ob, strOrderType);
  1614. Pop.ShowDialog();
  1615. if (Pop.ModeId == null)
  1616. return;
  1617. txt_ModeName.Text = Pop.ModeName.ToString();
  1618. }
  1619. /// <summary>
  1620. /// 抬头弹窗
  1621. /// </summary>
  1622. /// <param name="sender"></param>
  1623. /// <param name="e"></param>
  1624. private void txt_TitleName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1625. {
  1626. FrmPop_upTitle Pot = new FrmPop_upTitle(this.ob);
  1627. Pot.ShowDialog();
  1628. if (Pot.Id == null)
  1629. return;
  1630. txt_TitleName.Text = Pot.TitleName;
  1631. }
  1632. /// <summary>
  1633. /// 合同货币类型选择-界面上货币名称变化
  1634. /// </summary>
  1635. /// <param name="sender"></param>
  1636. /// <param name="e"></param>
  1637. private void txt_Currency_ValueChanged(object sender, EventArgs e)
  1638. {
  1639. currencylabel1.Text = txt_Currency.Text;
  1640. currencylabel4.Text = txt_Currency.Text;
  1641. currencyLabel66.Text = txt_Currency.Text;
  1642. }
  1643. /// <summary>
  1644. /// 创建时间查询控制
  1645. /// </summary>
  1646. /// <param name="sender"></param>
  1647. /// <param name="e"></param>
  1648. private void CK_Ctime_CheckedChanged(object sender, EventArgs e)// 创建时间查询控制
  1649. {
  1650. if (CK_Ctime.Checked == false)
  1651. {
  1652. txt_createTimeEnd.Enabled = false;
  1653. txt_createTimeStart.Enabled = false;
  1654. }
  1655. else
  1656. {
  1657. txt_createTimeEnd.Enabled = true;
  1658. txt_createTimeStart.Enabled = true;
  1659. }
  1660. }
  1661. /// <summary>
  1662. /// 条款选择
  1663. /// </summary>
  1664. /// <param name="sender"></param>
  1665. /// <param name="e"></param>
  1666. private void txt_ClauseOldId_EditorButtonClick(object sender, EditorButtonEventArgs e)
  1667. {
  1668. String strtype = txt_OrderType.SelectedIndex == -1 ? "" : txt_OrderType.Value.ToString().Trim();
  1669. FrmClauseInMode Fcinm = new FrmClauseInMode(this.ob, strtype);
  1670. Fcinm.ShowDialog();
  1671. if (Fcinm.getClauseId() == null)
  1672. return;
  1673. ClearTab3();
  1674. txt_ClauseDesc.Text = Fcinm.getClauseDesc().ToString();
  1675. txt_ClauseOldId.Text = Fcinm.getClauseId().ToString();
  1676. txt_ClauseName.Text = Fcinm.getClauseName().ToString();
  1677. txt_ClauseIndx1.Text = Fcinm.getClauseOrderBy().ToString();
  1678. txt_ClauseType.Value = Fcinm.getClauseType().ToString();
  1679. }
  1680. /// <summary>
  1681. /// 价格政策选择
  1682. /// </summary>
  1683. /// <param name="sender"></param>
  1684. /// <param name="e"></param>
  1685. private void txt_balanceClause_EditorButtonClick(object sender, EditorButtonEventArgs e)
  1686. {
  1687. FrmFGPriceMainTain frm = new FrmFGPriceMainTain(this.ob);
  1688. frm.ShowDialog();
  1689. if (frm.tips == "1")
  1690. {
  1691. txt_balanceClause.Text = frm.strPriceName;
  1692. this.init_balance_Id = frm.strPriceId;
  1693. }
  1694. }
  1695. /// <summary>
  1696. /// 新增按钮控制
  1697. /// </summary>
  1698. /// <param name="sender"></param>
  1699. /// <param name="e"></param>
  1700. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)// 新增按钮控制
  1701. {
  1702. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[2])
  1703. {
  1704. this.ToolBarItemEnable(this, "Add", true);
  1705. }
  1706. else
  1707. {
  1708. this.ToolBarItemEnable(this, "Add", false);
  1709. }
  1710. }
  1711. private void FrmOrderMNew_Shown(object sender, EventArgs e)
  1712. {
  1713. this.ToolBarItemEnable(this, "Add", false);
  1714. }
  1715. private void ultraGrid8_AfterRowActivate(object sender, EventArgs e)
  1716. {
  1717. dataTable9.Clear();
  1718. txt_change_record.Clear();
  1719. String strChangeId = ultraGrid8.ActiveRow.GetCellValue("changeId").ToString();
  1720. txt_change_record.Text = ultraGrid8.ActiveRow.GetCellValue("CHANGERECORD").ToString().Replace("\n", "\r\n");
  1721. if (String.IsNullOrEmpty(strChangeId))
  1722. {
  1723. return;
  1724. }
  1725. OrderChangeD change = new OrderChangeD();
  1726. change.ChangeId = strChangeId;
  1727. change.Validflag = "1";
  1728. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderChangeDService", "find", new object[] { change, 0, 0 });
  1729. GridHelper.CopyDataToDatatable(dt, dataTable9, true);
  1730. GridHelper.RefreshAndAutoSize(ultraGrid9);
  1731. }
  1732. /// <summary>
  1733. /// 条款类型变化---打印顺序1
  1734. /// </summary>
  1735. /// <param name="sender"></param>
  1736. /// <param name="e"></param>
  1737. private void txt_ClauseType_ValueChanged(object sender, EventArgs e)
  1738. {
  1739. try
  1740. {
  1741. if (txt_ClauseType.SelectedIndex != -1)
  1742. {
  1743. string strBaseCode = txt_ClauseType.Value.ToString().Trim();
  1744. BaseInfo baseInfo = this.execute<BaseInfo>("com.hnshituo.pur.configure.service.BaseInfoService", "findById", new object[] { strBaseCode });
  1745. if (baseInfo != null)
  1746. {
  1747. if (String.IsNullOrEmpty(baseInfo.Memo.Trim()))
  1748. {
  1749. MessageUtil.ShowTips("未维护条款分类默认打印排序!请在基础数据表里维护!");
  1750. return;
  1751. }
  1752. txt_ClauseIndx1.Text = baseInfo.Memo;
  1753. }
  1754. }
  1755. }
  1756. catch (Exception ex)
  1757. {
  1758. MessageUtil.ShowTips(ex.Message);
  1759. txt_ClauseIndx1.Text = "";
  1760. }
  1761. }
  1762. /// <summary>
  1763. /// 选择结算条款
  1764. /// </summary>
  1765. /// <param name="sender"></param>
  1766. /// <param name="e"></param>
  1767. private void txt_Bcm_Name_EditorButtonClick(object sender, EditorButtonEventArgs e)
  1768. {
  1769. FrmFGPriceMainTain frm = new FrmFGPriceMainTain(this.ob);
  1770. frm.ShowDialog();
  1771. if (frm.tips == "1")
  1772. {
  1773. txt_Bcm_Name.Text = frm.strPriceName;
  1774. this.init_bcm_Id = frm.strPriceId;
  1775. }
  1776. }
  1777. /// <summary>
  1778. /// 价格政策
  1779. /// </summary>
  1780. /// <param name="sender"></param>
  1781. /// <param name="e"></param>
  1782. private void txt_BalanceClauseType_SelectionChanged(object sender, EventArgs e)
  1783. {
  1784. if (txt_BalanceClauseType.SelectedIndex == 2)
  1785. {
  1786. txt_balanceClause.Enabled = true;
  1787. }
  1788. else
  1789. {
  1790. txt_balanceClause.Enabled = false;
  1791. }
  1792. }
  1793. #endregion
  1794. #region 初始化函数
  1795. /// <summary>
  1796. /// 选择和合同结算
  1797. /// </summary>
  1798. private void Init()
  1799. {
  1800. switch (this.CustomInfo.ToString().Trim())
  1801. {
  1802. case "@Confirma":
  1803. #region
  1804. ultraGrid1.DisplayLayout.Bands[0].Columns["Check"].Hidden = false;
  1805. ultraExpandableGroupBox2.Visible = false;
  1806. COPStatus.SelectedIndex = 3;
  1807. #endregion
  1808. break;
  1809. }
  1810. initDropDownList();
  1811. //合同状态默认全部
  1812. COPStatus.SelectedIndex = 0;
  1813. //头初始化
  1814. txt_SignDate.Value = DateTime.Now;//签订日期
  1815. txt_CreateTime.Value = DateTime.Now;//录入日期
  1816. txt_SignAddress.Text = "天津市";
  1817. //行初始化
  1818. txt_EndDate2.Value = DateTime.Now ;//送货结束日期
  1819. CK_Ctime.Checked = true;
  1820. txt_createTimeStart.Value = DateTime.Now.AddMonths(-2);
  1821. txt_createTimeEnd.Value = DateTime.Now.AddDays(7);
  1822. //加载数据
  1823. //GetPUR_ORDER_M();
  1824. //默认收起编辑区
  1825. ultraExpandableGroupBox2.Expanded = false;
  1826. //设置Grid不可编辑
  1827. SetColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] { });
  1828. SetColumnsActive(ultraGrid2.DisplayLayout.Bands[0], new string[] { "convertCount" });
  1829. SetColumnsActive(ultraGrid3.DisplayLayout.Bands[0], new string[] { });
  1830. SetColumnsActive(ultraGrid6.DisplayLayout.Bands[0], new string[] { });
  1831. SetColumnsActive(ultraGrid4.DisplayLayout.Bands[0], new string[] { "CERTPATH"});
  1832. GridHelper.SetExcludeColumnsActive(ultraGrid5.DisplayLayout.Bands[0], new string[] { "MATNAME","CHK", "STDMIN", "STDMINSIGN", "STDMAX", "STDMAXSIGN", "REMARK","JUDGETYPE" });
  1833. SetColumnsActive(ultraGrid8.DisplayLayout.Bands[0], new string[] { });
  1834. SetColumnsActive(ultraGrid9.DisplayLayout.Bands[0], new string[] { });
  1835. //加载附件查询控件
  1836. ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];
  1837. ultraGrid5.DisplayLayout.Bands[0].Columns["STDMINSIGN"].EditorComponent = ultraComSignMin;//下限符号
  1838. ultraGrid5.DisplayLayout.Bands[0].Columns["STDMAXSIGN"].EditorComponent = ultraComSignMax;//上限符号
  1839. ultraGrid5.DisplayLayout.Bands[0].Columns["JUDGETYPE"].EditorComponent = ultraJUDGE_TYPE;//上限符号
  1840. ultraGrid5.DisplayLayout.Bands[0].Columns["MATNAME"].EditorComponent = ultraMAT_NAME;//上限符号
  1841. }
  1842. /// <summary>
  1843. /// 初始化DropDownList控件
  1844. /// </summary>
  1845. private void initDropDownList()// 初始化DropDownList控件
  1846. {
  1847. //价格政策
  1848. txt_BalanceClauseType.SelectedIndex = 0;
  1849. txt_balanceClause.Enabled = false;
  1850. //加载结算条款
  1851. //BalanceClauseM bm = new BalanceClauseM();
  1852. //bm.Validflag = "1";
  1853. //DataTable dt = this.execute<DataTable>("com.hnshituo.pur.balance.service.BalanceClauseMService", "doQueryClauseM", new object[] { bm });
  1854. //comm.FilComboboxAdd(txt_Pur_Clause, dt, "bcmId", "bcmName", null, true, "/", "");
  1855. //合同类别
  1856. DataTable dt1 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1200" }, this.ob);
  1857. comm.FilComboboxAdd(COP_OrderType, dt1, "baseCode", "baseName", "validflag NOT in ('0')", true, "全部", "");
  1858. COP_OrderType.SelectedIndex = 0;
  1859. comm.FilComboboxAdd(txt_OrderType, dt1, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1860. //合同分类
  1861. DataTable dt3 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1220" }, this.ob);
  1862. comm.FilComboboxAdd(txt_OrderClass, dt3, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1863. //货币代码
  1864. //throw new NotImplementedException();
  1865. DataTable dt4 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1001" }, this.ob);
  1866. comm.FilComboboxAdd(txt_Currency, dt4, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1867. txt_Currency.SelectedIndex = 1;
  1868. //接收方式
  1869. DataTable dt5 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1101" }, this.ob);
  1870. comm.FilComboboxAdd(txt_ReceiveType, dt5, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1871. //加载运输条件
  1872. DataTable dt6 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1105" }, this.ob);
  1873. comm.FilComboboxAdd(txt_deliveryCondition, dt6, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
  1874. //加载运输方式
  1875. DataTable dt7 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1102" }, this.ob);
  1876. comm.FilComboboxAdd(txt_deliveryType, dt7, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
  1877. //加载包装方式
  1878. DataTable dt8 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1107" }, this.ob);
  1879. comm.FilComboboxAdd(txt_packType, dt8, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
  1880. //加载付款方式
  1881. DataTable dt9 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1104" }, this.ob);
  1882. comm.FilComboboxAdd(txt_paymentType, dt9, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1883. //加载合同金额分类
  1884. DataTable dt10 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1222" }, this.ob);
  1885. comm.FilComboboxAdd(txt_OrderMoneyType, dt10, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  1886. //加载条款类型下拉框
  1887. DataTable dt20 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1218" }, this.ob);
  1888. foreach (DataRow row in dt20.Rows)
  1889. {
  1890. row["baseName"] = "[" + row["memo"] + "]" + row["baseName"];
  1891. }
  1892. comm.FilComboboxAdd(txt_ClauseType, dt20, "baseCode", "baseName", "validflag NOT in ('0')", false, "全部", "");
  1893. MatCheckitem item = new MatCheckitem();
  1894. item.Validflag = "1";
  1895. DataTable dt1212 = this.execute<DataTable>("com.hnshituo.pur.jhy.service.MatCheckitem_jhyService", "find", new object[] { item, 0, 0 });
  1896. if (dt1212 == null || dt1212.Rows.Count == 0)
  1897. {
  1898. return;
  1899. }
  1900. //检验项目
  1901. ultraMAT_NAME.DataSource = dt1212;
  1902. ultraMAT_NAME.ValueMember = "matCode";
  1903. ultraMAT_NAME.DisplayMember = "matName";
  1904. DataRow dr = dt1212.NewRow();
  1905. dr[0] = "";
  1906. dr[1] = "";
  1907. dt1212.Rows.Add(dr);
  1908. string basecode = "1235";// 合同类型
  1909. DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { basecode }, this.ob);
  1910. dt = dt.AsEnumerable().Where(p => p["VALIDFLAG"].ToString().Equals("1")).CopyToDataTable();
  1911. combo_order_type.DataSource = dt;
  1912. combo_order_type.DisplayMember = "BASENAME";
  1913. combo_order_type.ValueMember = "BASECODE";
  1914. }
  1915. /// <summary>
  1916. /// 清除合同头编辑区
  1917. /// </summary>
  1918. private void ClearTab1()//清除合同头编辑区
  1919. {
  1920. txt_AftPaymentAmt1.Value = 0;//尾款1
  1921. txt_OrderId.Text = "";//合同号
  1922. txt_OrderId.Text = "";//合同编号
  1923. txt_TaskRecordId.Text = "";//采购纪要
  1924. txt_ModeName.Text = "";//合同模板名称
  1925. txt_TitleName.Text = "";//合同头名称
  1926. currencylabel1.Text = "-";
  1927. currencylabel4.Text = "-";
  1928. txt_SignAddress.Value= "天津市";//签订地点
  1929. txt_CreateTime.Value = DateTime.Now;//创建时间
  1930. txt_SignDate.Value = DateTime.Now;//签订日期
  1931. txt_ModeName.Text = "";//模板名称
  1932. txt_TaskRecordId.Text = "";//采购纪要号
  1933. txt_OrderType.SelectedIndex = -1;//合同类别
  1934. txt_Currency.SelectedIndex = -1;//合同货币代码
  1935. txt_OrderClass.SelectedIndex = -1;//合同分类置空
  1936. txt_OrderMoneyType.SelectedIndex = -1;//合同金额类别
  1937. txt_deliveryType.SelectedIndex = -1;//运输方式
  1938. txt_deliveryCondition.SelectedIndex = -1;//运输条件
  1939. txt_buy_name.Clear();
  1940. }
  1941. /// <summary>
  1942. /// 清空合同行编辑区
  1943. /// </summary>
  1944. private void ClearTab2()// 清空合同行编辑区
  1945. {
  1946. //合同行部分
  1947. txt_EndDate2.Value = null;//要求到货时间
  1948. txt_ReceiveType.SelectedIndex = -1;//接收方式
  1949. //txt_Pur_Clause.SelectedIndex = -1;//结算条款
  1950. txt_paymentType.SelectedIndex = -1;//付款方式
  1951. txt_packType.SelectedIndex = -1;//包装方式
  1952. currencyLabel66.Text = "-";
  1953. txt_Remark.Clear();
  1954. txt_balanceClause.Clear();
  1955. txt_BalanceClauseType.SelectedIndex = -1;
  1956. txt_balanceClause.Clear();
  1957. init_balance_Id = "";
  1958. }
  1959. /// <summary>
  1960. /// 清空合同条款编辑区
  1961. /// </summary>
  1962. private void ClearTab3()// 清空合同条款编辑区
  1963. {
  1964. txt_Clauseid.Clear();
  1965. txt_ClauseIndx1.Clear();
  1966. txt_ClauseIndx2.Value = "1";
  1967. txt_ClauseName.Clear();
  1968. txt_ClauseOldId.Clear();
  1969. txt_ClauseType.SelectedIndex = -1;
  1970. txt_ClauseDesc.Clear();
  1971. init_bcm_Id = "";
  1972. txt_Bcm_Name.Text = "";
  1973. }
  1974. private void ClearTab4()
  1975. {
  1976. ConfigureClassCommon.clearOldData(panel1);
  1977. jy_procRecord.Clear();
  1978. }
  1979. /// <summary>
  1980. /// 清空文件上传编辑区
  1981. /// </summary>
  1982. private void ClearTab5()
  1983. {
  1984. txt_certPath.Clear();
  1985. txt_certpath_local.Clear();
  1986. txt_CERTDESC.Clear();
  1987. fileName = "";
  1988. }
  1989. #endregion
  1990. #region 公共函数
  1991. /// <summary>
  1992. ///从表 查询
  1993. /// </summary>
  1994. private void getOrderC(string ab, String lineId)
  1995. {
  1996. dataTable2.Clear();
  1997. OrderC odC = new OrderC();
  1998. odC.OrderId = ab;
  1999. odC.Validflag = "1";
  2000. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCService", "doQueryOrderC", new object[] { odC, 0, 0 });
  2001. GridHelper.CopyDataToDatatable(dt, dataTable2, true);
  2002. GridHelper.RefreshAndAutoSize(ultraGrid2);
  2003. if (!String.IsNullOrEmpty(lineId))
  2004. {
  2005. ConfigureClassCommon.doActiveSelRow(ultraGrid2, "orderLineSqe", lineId);
  2006. }
  2007. }
  2008. /// <summary>
  2009. ///条款从表 查询
  2010. /// </summary>
  2011. private void getOrderClause(string strOrderId, string clauseId)//条款从表 查询
  2012. {
  2013. dataTable3.Clear();
  2014. OrderCClause clause = new OrderCClause();
  2015. clause.OrderId = strOrderId;
  2016. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderCClauseService", "find_Clause", new object[] { clause });
  2017. GridHelper.CopyDataToDatatable(dt, dataTable3, true);
  2018. GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid3, new UltraGridColumn[] { ultraGrid3.DisplayLayout.Bands[0].Columns["ClauseDesc"] });
  2019. //GridHelper.RefreshAndAutoSize(ultraGrid3);
  2020. if (!String.IsNullOrEmpty(clauseId))
  2021. {
  2022. ConfigureClassCommon.doActiveSelRow(ultraGrid3, "ID", clauseId);
  2023. }
  2024. }
  2025. /// <summary>
  2026. /// 采购纪要查询
  2027. /// </summary>
  2028. /// <param name="strTaskRecordId"></param>
  2029. private void getTaskRecord(string strTaskRecordId)
  2030. {
  2031. dataTable5.Clear();
  2032. ClearTab4();
  2033. PurTaskRecordEntity taskRecord = this.execute<PurTaskRecordEntity>("com.hnshituo.pur.purplan.service.TaskRecordService", "findById", new object[] { strTaskRecordId });
  2034. if (taskRecord != null)
  2035. {
  2036. jy_buyerUsername.Text = taskRecord.BuyerUsername;
  2037. jy_mngOrgName.Text = taskRecord.MngOrgName;
  2038. jy_negDate.Value = taskRecord.NegDate;
  2039. jy_procRecord.Text = taskRecord.ProcRecord.Replace("\n", "\r\n");
  2040. jy_taskId.Text = taskRecord.TaskId;
  2041. jy_taskName.Text = taskRecord.TaskName;
  2042. jy_type.Value = taskRecord.Type;
  2043. //加载采购纪要评单记录表
  2044. DataTable dt6 = this.execute<DataTable>("com.hnshituo.pur.purplan.service.TaskEvaService", "doQueryEva", new object[] { taskRecord.TaskId });
  2045. GridHelper.CopyDataToDatatable(dt6, dataTable5, true);
  2046. GridHelper.RefreshAndAutoSize(ultraGrid6);
  2047. }
  2048. }
  2049. /// <summary>
  2050. /// 加载合同附件
  2051. /// </summary>
  2052. /// <param name="strOrderId"></param>
  2053. /// <param name="p"></param>
  2054. private void getOrderAppend(string strOrderId, string p)
  2055. {
  2056. dataTable4.Clear();
  2057. OrderAppend append = new OrderAppend();
  2058. append.OrderId = strOrderId;
  2059. append.Validflag = "1";
  2060. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderAppendService", "find", new object[] { append,0,0});
  2061. GridHelper.CopyDataToDatatable(dt, dataTable4, true);
  2062. GridHelper.RefreshAndAutoSize(ultraGrid4);
  2063. if (!String.IsNullOrEmpty(p))
  2064. {
  2065. ConfigureClassCommon.doActiveSelRow(ultraGrid4, "CERTPATH", p);
  2066. }
  2067. }
  2068. /// <summary>
  2069. /// 获取合同评审意见
  2070. /// </summary>
  2071. /// <param name="strOrderId"></param>
  2072. private void getOrderReview(string strOrderId)
  2073. {
  2074. DataTable dt11 = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderMService", "getReviewMsg", new object[] { strOrderId });
  2075. GridHelper.CopyDataToDatatable(dt11, dataTable7, true);
  2076. GridHelper.RefreshAndAutoSize(ultraGrid7);
  2077. }
  2078. /// <summary>
  2079. /// 加载合同变更记录
  2080. /// </summary>
  2081. /// <param name="strOrderId"></param>
  2082. private void getOrderChangeRecord(string strOrderId)
  2083. {
  2084. change.Clear();
  2085. OrderChangeM change1 = new OrderChangeM();
  2086. if (strOrderId.EndsWith("BG"))
  2087. {
  2088. change1.OrderIdB = strOrderId;
  2089. }
  2090. else
  2091. {
  2092. change1.OrderId = strOrderId;
  2093. }
  2094. change1.Validflag = "1";
  2095. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderChangeMService", "find", new object[] { change1, 0, 0 });
  2096. if (dt != null && dt.Rows.Count > 0)
  2097. {
  2098. ultraTabControl2.Tabs["change"].Visible = true;
  2099. GridHelper.CopyDataToDatatable(dt, dataTable8, true);
  2100. GridHelper.RefreshAndAutoSize(ultraGrid8);
  2101. }
  2102. else
  2103. {
  2104. ultraTabControl2.Tabs["change"].Visible = false;
  2105. }
  2106. }
  2107. /// <summary>
  2108. /// 设置包含在指定列中的列可编辑
  2109. /// </summary>
  2110. /// <param name="band"></param>
  2111. /// <param name="columnKeys"></param>
  2112. public static void SetColumnsActive(UltraGridBand band, params string[] columnKeys)
  2113. {
  2114. foreach (UltraGridColumn gridColumn in band.Columns)
  2115. {
  2116. if (columnKeys.Contains(gridColumn.Key) != true)
  2117. {
  2118. gridColumn.CellActivation = Activation.ActivateOnly;
  2119. }
  2120. }
  2121. }
  2122. /// <summary>
  2123. /// 字符串转是否能转换成非负数
  2124. /// </summary>
  2125. /// <param name="str"></param>
  2126. /// <returns></returns>
  2127. public static bool Is_Below_zero(string str)
  2128. {
  2129. try
  2130. {
  2131. if (str.Equals(""))
  2132. {
  2133. return false;
  2134. }
  2135. else
  2136. {
  2137. if (StringUtil.IsDouble(str) && double.Parse(str) > 0)
  2138. return true;
  2139. else
  2140. return false;
  2141. }
  2142. }
  2143. catch
  2144. {
  2145. return false;
  2146. }
  2147. }
  2148. /// <summary>
  2149. /// 激活输入当前值行数据
  2150. /// </summary>
  2151. /// <param name="ug">ultragrid</param>
  2152. /// <param name="strColumn">列名</param>
  2153. /// <param name="strKey">列值</param>
  2154. public static string doActiveSelRow(UltraGrid ug, string strColumn, string strKey)// 激活输入当前值行数据
  2155. {
  2156. try
  2157. {
  2158. if (strKey != "")
  2159. {
  2160. foreach (UltraGridRow row in ug.Rows)
  2161. {
  2162. if (row.Cells[strColumn].Text.ToString() == strKey)
  2163. {
  2164. row.Activated = true;
  2165. if (row.ChildBands != null)
  2166. row.Expanded = true;
  2167. }
  2168. }
  2169. }
  2170. return "";
  2171. }
  2172. catch (Exception ex)
  2173. {
  2174. return ex.ToString();
  2175. }
  2176. }
  2177. /// <summary>
  2178. /// 验证合同头输入数据有效性
  2179. /// </summary>
  2180. /// <returns></returns>
  2181. private bool testOrderM()// 验证合同头输入数据有效性
  2182. {
  2183. if (string.IsNullOrEmpty(txt_Currency.Text) || txt_Currency.Text.ToString().Trim() == "/")
  2184. {
  2185. MessageUtil.ShowTips("合同货币类型不能为空");
  2186. txt_Currency.Focus();
  2187. return false;
  2188. }
  2189. if (string.IsNullOrEmpty(txt_OrderType.Text) || txt_OrderType.Text.ToString().Trim() == "/")
  2190. {
  2191. MessageUtil.ShowTips("合同类别不能为空!");
  2192. txt_OrderType.Focus();
  2193. return false;
  2194. }
  2195. if (String.IsNullOrEmpty(txt_OrderType.Value.ToString().Trim()) || txt_OrderType.Value.ToString().Trim() == "/")
  2196. {
  2197. MessageUtil.ShowTips("未选择合同类别为空,请选择合同类别");
  2198. txt_OrderType.Focus();
  2199. return false;
  2200. }
  2201. if (String.IsNullOrEmpty(txt_SignDate.Text))
  2202. {
  2203. MessageUtil.ShowTips("请输入合同签订日期");
  2204. txt_SignDate.Focus();
  2205. return false;
  2206. }
  2207. return true;
  2208. }
  2209. /// <summary>
  2210. /// 验证合同行输入数据的有效性
  2211. /// </summary>
  2212. /// <returns></returns>
  2213. private bool testOrderC()// 验证合同行输入数据的有效性
  2214. {
  2215. if (String.IsNullOrEmpty(txt_ReceiveType.Text))
  2216. {
  2217. MessageUtil.ShowTips("请选择接收方式");
  2218. txt_ReceiveType.Focus();
  2219. return false;
  2220. }
  2221. //if (txt_paymentType.SelectedIndex==-1)
  2222. //{
  2223. // MessageUtil.ShowTips("请选择付款方式");
  2224. // txt_paymentType.Focus();
  2225. // return false;
  2226. //}
  2227. if (String.IsNullOrEmpty(txt_EndDate2.Text))
  2228. {
  2229. MessageUtil.ShowTips("请输入有效的合同行交货开始时间");
  2230. txt_EndDate2.Focus();
  2231. return false;
  2232. }
  2233. return true;
  2234. }
  2235. /// <summary>
  2236. /// 验证合同条款输入数据的有效性
  2237. /// </summary>
  2238. /// <returns></returns>
  2239. private bool testOrderClause()// 验证合同条款输入数据的有效性
  2240. {
  2241. if (String.IsNullOrEmpty(txt_ClauseDesc.Text.Trim()))
  2242. {
  2243. txt_ClauseDesc.Focus();
  2244. MessageUtil.ShowTips("合同条款内容不能为空!");
  2245. return false;
  2246. }
  2247. if (String.IsNullOrEmpty(txt_ClauseName.Text.Trim()))
  2248. {
  2249. txt_ClauseName.Focus();
  2250. MessageUtil.ShowTips("合同条款名称不能为空!");
  2251. return false;
  2252. }
  2253. if (txt_ClauseType.SelectedIndex == -1)
  2254. {
  2255. txt_ClauseType.Focus();
  2256. MessageUtil.ShowTips("合同条款分类不能为空!");
  2257. return false;
  2258. }
  2259. if (String.IsNullOrEmpty(txt_ClauseIndx1.Text))
  2260. {
  2261. txt_ClauseIndx1.Focus();
  2262. MessageUtil.ShowTips("合同条款分排序(打印顺序1)不能为空!");
  2263. return false;
  2264. }
  2265. if (txt_ClauseIndx2.Value==null)
  2266. {
  2267. txt_ClauseIndx2.Focus();
  2268. MessageUtil.ShowTips("合同条款排序(打印顺序2)不能为空!");
  2269. return false;
  2270. }
  2271. return true;
  2272. }
  2273. /// <summary>
  2274. /// 验证合同条款输入数据的有效性
  2275. /// </summary>
  2276. /// <returns></returns>
  2277. private bool testOrderAppendStatus(String strId,int p)// 验证合同附件
  2278. {
  2279. OrderAppend append = this.execute<OrderAppend>("com.hnshituo.pur.order.service.OrderAppendService", "findById", new object[] { strId });
  2280. if (append == null)
  2281. {
  2282. MessageUtil.ShowTips("未发现合同附件:" + strId+"信息记录,可能已作废");
  2283. return false;
  2284. }
  2285. if (append.Validflag != "1")
  2286. {
  2287. MessageUtil.ShowTips("合同附件:" + strId + "信息记录可能已作废");
  2288. return false;
  2289. }
  2290. if (append.CreateUserid != UserInfo.GetUserID())
  2291. {
  2292. MessageUtil.ShowTips("非本人上传合同附件无权限进行增删改");
  2293. return false;
  2294. }
  2295. if (p == 1)
  2296. {
  2297. }
  2298. else
  2299. {
  2300. MessageUtil.ShowTips("未知参数:" + p + "");
  2301. return false;
  2302. }
  2303. return true;
  2304. }
  2305. /// <summary>
  2306. /// 验证合同行的状态有效性
  2307. /// </summary>
  2308. /// <param name="strOrderLineSqe"></param>
  2309. /// <param name="p"></param>
  2310. /// <returns></returns>
  2311. private bool testOrderCStatus(string strOrderLineSqe, int p)// 验证合同行的状态有效性
  2312. {
  2313. OrderC oc = this.execute<OrderC>("com.hnshituo.pur.order.service.OrderCService", "findById", new object[] { strOrderLineSqe });
  2314. if (oc == null)
  2315. {
  2316. MessageUtil.ShowTips("无合同行【" + strOrderLineSqe + "】的信息记录,可能已被作废,或请刷新界面重新操作!");
  2317. return false;
  2318. }
  2319. if (oc.Validflag=="0")
  2320. {
  2321. MessageUtil.ShowTips("合同行【" + strOrderLineSqe + "】的信息记录可能已被作废,或请刷新界面重新操作!");
  2322. return false;
  2323. }
  2324. String strOrderId = oc.OrderId;
  2325. //是否允许删除
  2326. if (p == 1)
  2327. {
  2328. if (testOrderMStatus(strOrderId, 1) == false)
  2329. {
  2330. return false;
  2331. }
  2332. //验证是否生成通知单
  2333. if (oc.CreatedNoticeQty != null)
  2334. {
  2335. if (oc.CreatedNoticeQty > 0)
  2336. {
  2337. MessageUtil.ShowTips("合同行【" + strOrderLineSqe + "】已编制发货通知单!");
  2338. return false;
  2339. }
  2340. }
  2341. }
  2342. else
  2343. {
  2344. MessageUtil.ShowTips("未知参数,无法验证合同行数据的有效性!");
  2345. return false;
  2346. }
  2347. return true;
  2348. }
  2349. /// <summary>
  2350. /// 验证合同头的状态有效性
  2351. /// </summary>
  2352. /// <param name="strOrderId"></param>
  2353. /// <param name="p"></param>
  2354. /// <returns></returns>
  2355. private bool testOrderMStatus(string strOrderId, int p)// 验证合同头的状态有效性
  2356. {
  2357. OrderM Omg = this.execute<OrderM>("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { strOrderId });
  2358. if (Omg == null)
  2359. {
  2360. MessageUtil.ShowTips("未发现合同【" + strOrderId + "】的信息记录,可能已作废,或请刷新界面重新操作!");
  2361. return false;
  2362. }
  2363. if (p != 8&&p!=41)
  2364. {
  2365. if (Omg.CreateUserid != UserInfo.GetUserID())
  2366. {
  2367. MessageUtil.ShowWarning("非提报该合同本人,无权限进行增删改操作,或请刷新后再操作!");
  2368. return false;
  2369. }
  2370. }
  2371. if (Omg.Validflag != "1")
  2372. {
  2373. MessageUtil.ShowWarning("合同【" + strOrderId + "】可能已作废,或请刷新界面重新操作!");
  2374. return false;
  2375. }
  2376. String tempStatus = Omg.Status.ToString().Trim();
  2377. //验证合同头是否可以增改
  2378. if (p == 1)
  2379. {
  2380. if (strOrderId.EndsWith("BG"))
  2381. {
  2382. MessageUtil.ShowWarning("合同【" + strOrderId + "】为临是变更合同,无法进行增改,请刷新后再操作!");
  2383. return false;
  2384. }
  2385. if (tempStatus == "0" && tempStatus== "3" && tempStatus == "4")
  2386. {
  2387. MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“草稿”或“待提报”或“审批不通过”状态,无法进行增改操作,请刷新后再操作!");
  2388. return false;
  2389. }
  2390. //if (tempStatus == "2")
  2391. //{
  2392. // CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "canSubmitOrderM", new object[] { strOrderId });
  2393. // if (crt.Resultcode != 1)
  2394. // {
  2395. // MessageUtil.ShowWarning("合同【" + strOrderId + "】上一节点已审批,无法进行增改,请刷新后再操作!");
  2396. // return false;
  2397. // }
  2398. //}
  2399. }
  2400. //验证合同是否可以删除
  2401. else if (p == 2)
  2402. {
  2403. if (tempStatus != "1" && tempStatus != "0" && tempStatus != "5")
  2404. {
  2405. MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“草稿”、“待提报”、“审批不通过”状态,无权限进行删除操作,请刷新后再操作!");
  2406. return false;
  2407. }
  2408. }
  2409. //验证是否可以提报
  2410. else if(p==3)
  2411. {
  2412. if (tempStatus != "1"&& tempStatus != "5")
  2413. {
  2414. MessageUtil.ShowWarning("合同【" + strOrderId + "】不在“待提报”或者“审批不通过”状态,请刷新后再操作!");
  2415. return false;
  2416. }
  2417. OrderC orderc = new OrderC();
  2418. orderc.OrderId = strOrderId;
  2419. orderc.Validflag = "1";
  2420. List<OrderC> dt = this.execute<List<OrderC>>("com.hnshituo.pur.order.service.OrderCService", "find", new object[] { orderc ,0,0});
  2421. if (dt == null || dt.Count < 1)
  2422. {
  2423. MessageUtil.ShowTips("合同【" + strOrderId + "】无有效的行信息,或请刷新界面重新操作!");
  2424. return false;
  2425. }
  2426. //验证数据的有效性--头有效性
  2427. if (string.IsNullOrEmpty(Omg.Currency))
  2428. {
  2429. MessageUtil.ShowTips("需要完善合同货币类型,该项不能为空!");
  2430. return false;
  2431. }
  2432. if (string.IsNullOrEmpty(Omg.OrderType))
  2433. {
  2434. MessageUtil.ShowTips("需要完善合同类别,该项不能为空!");
  2435. return false;
  2436. }
  2437. if (String.IsNullOrEmpty(Omg.SuppCode))
  2438. {
  2439. MessageUtil.ShowTips("需要完善供方信息,供应商编号不能为空!");
  2440. return false;
  2441. }
  2442. //if (String.IsNullOrEmpty(Omg.TaxRateName))
  2443. //{
  2444. // MessageUtil.ShowTips("需要完善合同税率信息,合同税率不允许为空!");
  2445. // return false;
  2446. //}
  2447. if (String.IsNullOrEmpty(Omg.ModeId))
  2448. {
  2449. MessageUtil.ShowTips("需要选择合同模板,合同模板不允许为空!");
  2450. return false;
  2451. }
  2452. if (Omg.SignDate==null)
  2453. {
  2454. MessageUtil.ShowTips("需完善合同签订日期,合同签订日期不允许为空");
  2455. txt_SignDate.Focus();
  2456. return false;
  2457. }
  2458. for(int i=0;i<dt.Count;i++)
  2459. {
  2460. OrderC oc=dt[i];
  2461. //if (!isRightDoubleWithoutZero(oc.Qty) || string.IsNullOrEmpty(oc.ItemCode))
  2462. if (string.IsNullOrEmpty(oc.ItemCode))
  2463. {
  2464. MessageUtil.ShowTips("合同行【"+oc.OrderLineSqe+"】的合同数量数,物料未维护,上述项不允许为空!");
  2465. return false;
  2466. }
  2467. if (!isRightDoubleWithZero(oc.PriceWithoutTax) || !isRightDoubleWithZero(oc.PriceWithTax))
  2468. {
  2469. MessageUtil.ShowTips("合同行【"+oc.OrderLineSqe+"】的含税单价和不含税单价未维护,上述项不允许为空!");
  2470. return false;
  2471. }
  2472. if (String.IsNullOrEmpty(oc.ReceiveType))
  2473. {
  2474. MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的接收方式未维护,上述项不允许为空!");
  2475. return false;
  2476. }
  2477. //if (String.IsNullOrEmpty(oc.DeliveryLocation) || String.IsNullOrEmpty(oc.DeliveryLocationCode))
  2478. //{
  2479. // MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交付地点和地点编码未维护,上述项不能为空!");
  2480. // return false;
  2481. //}
  2482. if (!isRightDoubleWithoutZero(oc.ItemUomConefficient))
  2483. {
  2484. MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的单位转化系数为空,数据异常!");
  2485. return false;
  2486. }
  2487. if (string.IsNullOrEmpty(oc.ItemUom)||string.IsNullOrEmpty(oc.WeightUnit))
  2488. {
  2489. MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的库存单位和采购单位为空,数据异常!");
  2490. return false;
  2491. }
  2492. //if (oc.StartDate==null)
  2493. //{
  2494. // MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货开始时间未维护,上述项不能为空!");
  2495. // return false;
  2496. //}
  2497. if (oc.EndDate==null)
  2498. {
  2499. MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货结束时间未维护,上述项不能为空!");
  2500. return false;
  2501. }
  2502. //if (Convert.ToDateTime(oc.StartDate) > Convert.ToDateTime(oc.EndDate))
  2503. //{
  2504. // MessageUtil.ShowTips("合同行【" + oc.OrderLineSqe + "】的交货开始时间不能需早于接收时间,请维护有效的交货时间!");
  2505. // return false;
  2506. //}
  2507. }
  2508. }
  2509. //合同是否可以撤回
  2510. else if (p == 4)
  2511. {
  2512. if (tempStatus != "2" && tempStatus != "5")
  2513. {
  2514. MessageUtil.ShowWarning("合同【" + strOrderId + "】未在“审批中”或者“审批不通过”状态,无权限撤回,请刷新后再操作!");
  2515. return false;
  2516. }
  2517. if (tempStatus != "5")
  2518. {
  2519. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "iscanRevOrderM", new object[] { strOrderId });
  2520. if (crt.Resultcode != 1)
  2521. {
  2522. MessageUtil.ShowWarning("合同【" + strOrderId + "】已被下游节点审批,无权限撤回,请刷新后再操作!");
  2523. return false;
  2524. }
  2525. }
  2526. }
  2527. //合同是否可以撤回(审批或者审批中)
  2528. else if (p == 41)
  2529. {
  2530. if (tempStatus != "2" && tempStatus != "3" && tempStatus != "4" && tempStatus != "5")
  2531. {
  2532. MessageUtil.ShowWarning("合同【" + strOrderId + "】未提报或者已经变更,请刷新后再操作!");
  2533. return false;
  2534. }
  2535. ExcDeliveryNoticeC nc = new ExcDeliveryNoticeC();
  2536. nc.OrderId = strOrderId;
  2537. nc.Validflag = "1";
  2538. int count = this.execute<int>("com.hnshituo.pur.ck.service.ExcDeliveryNoticeCService", "count", new object[] { nc });
  2539. if (count > 0)
  2540. {
  2541. MessageUtil.ShowWarning("合同【" + strOrderId + "】已经编制发货通知,请刷新后再操作!");
  2542. return false;
  2543. }
  2544. }
  2545. else if (p == 6)
  2546. {
  2547. if (tempStatus == "0" || tempStatus == "1")
  2548. {
  2549. MessageUtil.ShowWarning("合同未申请流程,请先提报!");
  2550. return false;
  2551. }
  2552. }
  2553. //归档
  2554. else if (p == 8)
  2555. {
  2556. if (tempStatus != "3")
  2557. {
  2558. MessageUtil.ShowWarning("合同未审批通过,无法归档!");
  2559. return false;
  2560. }
  2561. if (tempStatus == "4")
  2562. {
  2563. MessageUtil.ShowWarning("重复操作,合同已归档!");
  2564. return false;
  2565. }
  2566. OrderAppend sat = new OrderAppend();
  2567. sat.OrderId = strOrderId;
  2568. sat.Validflag = "1";
  2569. int count = this.execute<int>("com.hnshituo.pur.order.service.OrderAppendService", "count", new object[] { sat });
  2570. if (count <= 0)
  2571. {
  2572. MessageUtil.ShowTips("无法归档,合同:" + strOrderId + "未上传任何附件,请以附件形式上传已生效的合同电子文档!");
  2573. return false;
  2574. }
  2575. }
  2576. else
  2577. {
  2578. MessageUtil.ShowTips("未知参数,无法验证合同头数据的有效性!");
  2579. return false;
  2580. }
  2581. return true;
  2582. }
  2583. /// <summary>
  2584. /// 验证是否为非负小数
  2585. /// </summary>
  2586. /// <param name="db"></param>
  2587. /// <returns></returns>
  2588. private bool isRightDoubleWithZero(double? db)// 验证是否为非负小数
  2589. {
  2590. if (db == null)
  2591. {
  2592. return false;
  2593. }
  2594. if (db < 0)
  2595. {
  2596. return false;
  2597. }
  2598. return true;
  2599. }
  2600. /// <summary>
  2601. /// 验证是否为大于0的正数
  2602. /// </summary>
  2603. /// <param name="db"></param>
  2604. /// <returns></returns>
  2605. private bool isRightDoubleWithoutZero(double? db)// 验证是否为大于0的正数
  2606. {
  2607. if (db == null)
  2608. {
  2609. return false;
  2610. }
  2611. if (db <= 0)
  2612. {
  2613. return false;
  2614. }
  2615. return true;
  2616. }
  2617. /// <summary>
  2618. /// 查看流程详情
  2619. /// </summary>
  2620. private void Process()//查看流程详情
  2621. {
  2622. UltraGridRow uge = ultraGrid1.ActiveRow;
  2623. if (uge == null)
  2624. {
  2625. MessageUtil.ShowTips("请选择合同头!");
  2626. return;
  2627. }
  2628. String strOrderId = uge.Cells["OrderId"].Value.ToString().Trim();
  2629. ProcInstDetail detail = new ProcInstDetail(BpmFlowConstants.PROCDEF_PUR_ORDER_AUDIT, strOrderId);
  2630. detail.ShowDialog();
  2631. }
  2632. #endregion
  2633. #region 附件上传
  2634. private void craftImg_EditorButtonClick(object sender, EditorButtonEventArgs e)
  2635. {
  2636. try
  2637. {
  2638. UltraGridRow row = ultraGrid4.ActiveRow;
  2639. string filePathOld = row.GetValue("certPathOld");
  2640. if (e.Button.Key.ToLower().Equals("select"))
  2641. {
  2642. FrmPopFileShow down = new FrmPopFileShow(this.ob, filePathOld);
  2643. down.DeleteButton.Visible = false;
  2644. down.ShowDialog();
  2645. }
  2646. }
  2647. catch (Exception ex)
  2648. {
  2649. MessageUtil.ShowTips("操作失败:" + ex);
  2650. }
  2651. }
  2652. private void txt_certPath_EditorButtonClick(object sender, EditorButtonEventArgs e)
  2653. {
  2654. try
  2655. {
  2656. if (e.Button.Key.ToLower().Equals("insert"))
  2657. {
  2658. OpenFileDialog file = new OpenFileDialog();
  2659. file.Multiselect = false;
  2660. DialogResult drStat;
  2661. drStat = file.ShowDialog();
  2662. if (drStat == DialogResult.OK)
  2663. {
  2664. fileName = file.FileName;
  2665. String filePathlocal = System.IO.Path.GetFullPath(fileName);
  2666. string filena = System.IO.Path.GetFileName(fileName);
  2667. txt_certPath.Text = filena;
  2668. txt_certpath_local.Text = filePathlocal;
  2669. }
  2670. }
  2671. }
  2672. catch (Exception ex)
  2673. {
  2674. MessageUtil.ShowTips("操作失败:" + ex);
  2675. }
  2676. }
  2677. //上传按钮
  2678. private void btn_submitAppend_Click(object sender, EventArgs e)
  2679. {
  2680. if (ultraGrid1.ActiveRow == null)
  2681. {
  2682. MessageUtil.ShowTips("未选择合同头");
  2683. return;
  2684. }
  2685. String filena = txt_certPath.Text.ToString().Trim();
  2686. if (String.IsNullOrEmpty(filena) || String.IsNullOrEmpty(fileName))
  2687. {
  2688. MessageUtil.ShowTips("请选择待上传文件");
  2689. return;
  2690. }
  2691. string strOrderId = ultraGrid1.ActiveRow.GetValue("orderId");
  2692. OrderAppend sat = new OrderAppend();
  2693. sat.OrderId = strOrderId;
  2694. String filePathNew = "Pms/CERT/" + strOrderId + "/";
  2695. sat.CertPath = filena;
  2696. sat.CertPathOld = filePathNew + filena;
  2697. sat.CreateUserid = UserInfo.GetUserID();
  2698. sat.CreateName = UserInfo.GetUserName();
  2699. sat.CreateTime=DateTime.Now;
  2700. sat.Validflag = "1";
  2701. sat.CertDesc = txt_CERTDESC.Text.Trim();
  2702. if (GetCraftFileCraftNoCnt(filena, strOrderId) > 0)
  2703. {
  2704. MessageUtil.ShowTips("合同已存在该附件文件:" + filena);
  2705. return;
  2706. }
  2707. List<FileBean> list = new List<FileBean>();
  2708. FileBean bean = new FileBean();
  2709. bean = new FileBean();
  2710. bean.setFileName(filena);
  2711. bean.setPathName(filePathNew);
  2712. bean.setFile(FileHelper.FileToArray(fileName));
  2713. list.Add(bean);
  2714. bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list);
  2715. if (isSuccess)
  2716. {
  2717. //开始写数据库
  2718. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderAppendService", "insert_append", new object[] { sat });
  2719. if (crt.Resultcode != 0)
  2720. {
  2721. MessageUtil.ShowTips("上传失败:" + crt.Resultmsg);
  2722. }
  2723. else
  2724. {
  2725. MessageUtil.ShowTips("上传成功");
  2726. ClearTab5();
  2727. }
  2728. }
  2729. else
  2730. {
  2731. MessageBox.Show("上传失败");
  2732. }
  2733. //刷新界面并激活当前行
  2734. Relocate(sat);
  2735. }
  2736. private void Relocate(OrderAppend sat)
  2737. {
  2738. getOrderAppend(sat.OrderId,sat.CertPath);
  2739. }
  2740. /// <summary>
  2741. /// 判断是否之前已提交相同的文件
  2742. /// </summary>
  2743. /// <param name="craftNo"></param>
  2744. /// <returns></returns>
  2745. private int GetCraftFileCraftNoCnt(string CERT_PATH, string orderId)
  2746. {
  2747. OrderAppend sat = new OrderAppend();
  2748. sat.CertPath = CERT_PATH;
  2749. sat.OrderId = orderId;
  2750. sat.Validflag = "1";
  2751. int dt = this.execute<int>("com.hnshituo.pur.order.service.OrderAppendService", "count", new object[] { sat });
  2752. return dt;
  2753. }
  2754. #endregion
  2755. #region @检验项
  2756. private void btn_saveItem_Click(object sender, EventArgs e)
  2757. {
  2758. if (ultraGrid2.ActiveRow == null)
  2759. {
  2760. MessageUtil.ShowTips("请选择合同行");
  2761. return;
  2762. }
  2763. String strOrderLineSqe = ultraGrid2.ActiveRow.Cells["OrderLineSqe"].Value.ToString();
  2764. if (String.IsNullOrEmpty(strOrderLineSqe))
  2765. {
  2766. MessageUtil.ShowTips("请选择合同行行号为空");
  2767. return;
  2768. }
  2769. if (cb_standardsCode.SelectedIndex == -1)
  2770. {
  2771. MessageUtil.ShowTips("请选择合同行检验标准");
  2772. cb_standardsCode.Focus();
  2773. return;
  2774. }
  2775. String strMic = cb_standardsCode.Value.ToString().Trim();
  2776. if (String.IsNullOrEmpty(strMic))
  2777. {
  2778. MessageUtil.ShowTips("请选择合同行检验标准,检验标准编号为空");
  2779. cb_standardsCode.Focus();
  2780. return;
  2781. }
  2782. ArrayList alDetail = new ArrayList();
  2783. foreach (UltraGridRow ur in ultraGrid5.Rows)
  2784. {
  2785. if (ur.Cells["CHK"].Text.Trim() == "True" && ur.Cells["MATNAME"].Text.Trim() != "")
  2786. {
  2787. OrderCStdDetail DET = new OrderCStdDetail();
  2788. DET.MatCode=ur.Cells["MATNAME"].Value.ToString();
  2789. DET.MatName = ur.Cells["MATNAME"].Text.Trim();
  2790. if (DET.MatCode == DET.MatName)
  2791. {
  2792. DET.MatCode = ur.Cells["MATCODE"].Text.Trim();
  2793. }
  2794. DET.AddCondition = "";
  2795. DET.StdminSign = ur.Cells["STDMINSIGN"].Value.ToString();
  2796. DET.Stdmin = ur.Cells["STDMIN"].Text.Trim();
  2797. DET.Stdmax = ur.Cells["STDMAX"].Text.Trim();
  2798. DET.StdmaxSign = ur.Cells["STDMAXSIGN"].Text.Trim();
  2799. DET.StdminSign = ur.Cells["STDMINSIGN"].Text.Trim();
  2800. //DET.CheckCycle = ur.Cells["CHECKCYCLE"].Text.Trim();
  2801. DET.JudgeTypeCode = ur.Cells["JUDGETYPE"].Value.ToString();
  2802. DET.JudgeType = ur.Cells["JUDGETYPE"].Text.Trim();
  2803. DET.Remark = ur.Cells["REMARK"].Text.Trim();
  2804. DET.OrderLineSqe = ur.Cells["orderLineSqe"].Text.Trim();
  2805. DET.Id = ur.Cells["id"].Value.ToString();
  2806. DET.CreateName = UserInfo.GetUserName();
  2807. DET.CreateTime = DateTime.Now;
  2808. if (String.IsNullOrEmpty(DET.OrderLineSqe))
  2809. {
  2810. DET.OrderLineSqe = strOrderLineSqe;
  2811. }
  2812. else
  2813. {
  2814. if (DET.OrderLineSqe != strOrderLineSqe)
  2815. {
  2816. MessageUtil.ShowTips("非合同行:" + strOrderLineSqe+"检验项目");
  2817. return;
  2818. }
  2819. }
  2820. if (String.IsNullOrEmpty(DET.MatCode))
  2821. {
  2822. MessageUtil.ShowTips("检验项目不能为空");
  2823. return;
  2824. }
  2825. if (String.IsNullOrEmpty(DET.StdminSign))
  2826. {
  2827. MessageUtil.ShowTips("检验项目上限符号不能为空,若文字描述请默认选等于");
  2828. return;
  2829. }
  2830. if (String.IsNullOrEmpty(DET.Id))
  2831. {
  2832. OrderCStdDetail detailstd = new OrderCStdDetail();
  2833. detailstd.MatCode = DET.MatCode;
  2834. detailstd.Validflag = "1";
  2835. detailstd.OrderLineSqe = DET.OrderLineSqe;
  2836. int Count = this.execute<int>("com.hnshituo.pur.order.service.OrderCStdDetailService", "count", new object[] { detailstd});
  2837. if (Count > 0)
  2838. {
  2839. MessageUtil.ShowTips("合同行:" + DET.OrderLineSqe+"已维护"+DET.MatName+"检验项目");
  2840. return;
  2841. }
  2842. }
  2843. alDetail.Add(DET);
  2844. }
  2845. }
  2846. if (alDetail.Count <= 0)
  2847. {
  2848. MessageUtil.ShowTips("请选择需保持的检验项目");
  2849. return;
  2850. }
  2851. CoreResult re = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderCStdDetailService", "doUpdate_batch", new object[] { alDetail,strOrderLineSqe, strMic,UserInfo.GetUserName()});
  2852. if (re.Resultcode != 0)
  2853. {
  2854. MessageUtil.ShowTips("操作失败:"+re.Resultmsg);
  2855. }
  2856. else
  2857. {
  2858. MessageUtil.ShowTips("操作成功");
  2859. getStdDetail(strOrderLineSqe);
  2860. }
  2861. }
  2862. #endregion
  2863. private void btn_editJy_Click(object sender, EventArgs e)
  2864. {
  2865. try{
  2866. UltraGridRow ugr = ultraGrid1.ActiveRow;
  2867. if (ugr == null)
  2868. {
  2869. MessageUtil.ShowWarning("请选择您要查看采购纪要的合同头!");
  2870. return;
  2871. }
  2872. string strRecordId = ugr.Cells["TaskRecordId"].Value.ToString().Trim();
  2873. String strOrderId = ugr.Cells["OrderId"].Value.ToString().Trim();
  2874. if (String.IsNullOrEmpty(strOrderId))
  2875. {
  2876. MessageUtil.ShowTips("该合同头编号为空!");
  2877. return;
  2878. }
  2879. if (String.IsNullOrEmpty(strRecordId))
  2880. {
  2881. MessageUtil.ShowTips("采购纪要号为空,可能未生成采购纪要!");
  2882. return;
  2883. }
  2884. PurTaskRecordEntity record = new PurTaskRecordEntity();
  2885. record.Id = strRecordId;
  2886. record.ProcRecord = jy_procRecord.Text.ToString().Trim();
  2887. if (MessageUtil.ShowYesNoAndQuestion("确定修改纪要:" + record.Id + "?") != DialogResult.Yes)
  2888. {
  2889. return;
  2890. }
  2891. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.purplan.service.TaskRecordService", "doUpdate", new object[] { record });
  2892. if (crt.Resultcode == 0)
  2893. {
  2894. MessageUtil.ShowTips("操作成功!");
  2895. getTaskRecord(strRecordId);
  2896. }
  2897. else
  2898. {
  2899. MessageUtil.ShowTips("操作失败!" + crt.Resultmsg);
  2900. }
  2901. }
  2902. catch (Exception ex)
  2903. {
  2904. MessageUtil.ShowTips("操作失败!" + ex.Message);
  2905. }
  2906. }
  2907. private void cb_standardsCode_ValueChanged(object sender, EventArgs e)
  2908. {
  2909. if (cb_standardsCode.SelectedIndex != -1)
  2910. {
  2911. String mic = cb_standardsCode.Value.ToString().Trim();
  2912. if (String.IsNullOrEmpty(mic))
  2913. {
  2914. dataTable11.Clear();
  2915. MatStdDetail detailstd = new MatStdDetail();
  2916. detailstd.Mic = mic;
  2917. detailstd.Validflag = "1";
  2918. DataTable list_detail = this.execute<DataTable>("com.hnshituo.pur.jhy.service.MatStdDetail_jhyService", "find", new object[] { detailstd, 0, 0 });
  2919. GridHelper.CopyDataToDatatable(list_detail, dataTable11, true);
  2920. }
  2921. }
  2922. }
  2923. private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
  2924. {
  2925. if (e.Row.Cells["status"].Value.ToString().StartsWith("审批不通过") || e.Row.Cells["status"].Value.ToString().StartsWith("草稿"))
  2926. {
  2927. e.Row.Appearance.ForeColor = Color.Red;
  2928. }
  2929. else if (e.Row.Cells["status"].Value.ToString().StartsWith("合同变更中"))
  2930. {
  2931. e.Row.Appearance.ForeColor = Color.Gray;
  2932. }
  2933. else
  2934. {
  2935. e.Row.Appearance.ForeColor = Color.Black;
  2936. }
  2937. if (e.Row.Cells["orderId"].Value.ToString().EndsWith("BG"))
  2938. {
  2939. e.Row.Appearance.ForeColor = Color.Blue;
  2940. }
  2941. }
  2942. private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  2943. {
  2944. }
  2945. private void ultraTabPageControl1_Paint(object sender, PaintEventArgs e)
  2946. {
  2947. }
  2948. private void ultraGrid2_CellChange(object sender, CellEventArgs e)
  2949. {
  2950. if (e.Cell.Column.Header.Caption == "折算数量")
  2951. {
  2952. UltraGridRow ugr2 = ultraGrid2.ActiveRow;
  2953. ugr2.Cells["convertPrice"].Value = (Double.Parse(ugr2.Cells["WithAmtTax"].Text.ToString()) / Double.Parse(ugr2.Cells["convertCount"].Text.ToString().Replace("_", ""))).ToString("f2");
  2954. ugr2.Cells["convertPriceTax"].Value = (Double.Parse(ugr2.Cells["WithoutTaxAmt"].Text.ToString()) / Double.Parse(ugr2.Cells["convertCount"].Text.ToString().Replace("_", ""))).ToString("f2");
  2955. }
  2956. }
  2957. }
  2958. }