frmOrderOK.cs 42 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931
  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.Tool;
  12. using Infragistics.Win.UltraWinGrid;
  13. using Pur.Entity.configureEntity;
  14. using Pur.Entity.pur_orderEntiy;
  15. using com.hnshituo.pur.vo;
  16. using System.Collections;
  17. using Pur.order;
  18. using Core.Mes.Client.Comm.Server;
  19. using Pur.Pop_upWindow;
  20. using Pur.Entity.pur_planEntity;
  21. using System.Text.RegularExpressions;
  22. using com.hnshituo.ck;
  23. namespace Pur.pur_plan
  24. {
  25. public partial class frmOrderOK : FrmPmsBase
  26. {
  27. UltraGridRow uge = null;
  28. private String init_Mode_Id = "";
  29. private String init_OrderTitleCode = "";
  30. private String isAllowSplit = "0";
  31. public frmOrderOK()
  32. {
  33. InitializeComponent();
  34. }
  35. // 构造函数
  36. public frmOrderOK(OpeBase ob,UltraGridRow ugr)
  37. {
  38. InitializeComponent();
  39. this.ob = ob;
  40. uge = ugr;
  41. }
  42. // 界面加载
  43. private void frmOrderOK_Load(object sender, EventArgs e)
  44. {
  45. init();
  46. }
  47. //界面初始化
  48. private void init()
  49. {
  50. try
  51. {
  52. this.Cursor = Cursors.WaitCursor;
  53. String strTaskId = uge.Cells["TaskId"].Value.ToString();
  54. if (testStatusTask(strTaskId) == false)
  55. {
  56. this.Close();
  57. return;
  58. }
  59. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.purplan.service.TaskOfferMService", "getSuppResM", new object[] { strTaskId });
  60. GridHelper.CopyDataToDatatable(dt, dataTable1, true);
  61. GridHelper.RefreshAndAutoSize(ultraGrid1);
  62. //初始化合同控件
  63. initDropDownList();
  64. //Grid不可编辑
  65. GridHelper.SetExcludeColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] { });
  66. if (this.isAllowSplit == "1")
  67. {
  68. GridHelper.SetExcludeColumnsActive(ultraGrid2.DisplayLayout.Bands[0], new string[] { "CHK", "ASKDELIVERDATE", "createQty" });
  69. ultraGrid2.DisplayLayout.Bands[0].Columns["createQty"].CellAppearance.BackColor = Color.FromArgb(255, 255, 128);
  70. }
  71. else
  72. {
  73. GridHelper.SetExcludeColumnsActive(ultraGrid2.DisplayLayout.Bands[0], new string[] { "CHK", "ASKDELIVERDATE"});
  74. ultraGrid2.DisplayLayout.Bands[0].Columns["createQty"].CellAppearance.BackColor =Color.White;
  75. }
  76. }
  77. catch (Exception ex)
  78. {
  79. MessageUtil.ShowTips("加载数据失败:" + ex.Message);
  80. }
  81. finally
  82. {
  83. this.Cursor = Cursors.Default;
  84. }
  85. }
  86. //初始化DropDownList控件
  87. private void initDropDownList()
  88. {
  89. //合同类别
  90. DataTable dt1 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1200" }, this.ob);
  91. comm.FilComboboxAdd(txt_OrderType, dt1, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  92. txt_OrderType.SelectedIndex = -1;
  93. //合同分类
  94. DataTable dt3 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1220" }, this.ob);
  95. comm.FilComboboxAdd(txt_OrderClass, dt3, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  96. txt_OrderClass.SelectedIndex = 0;
  97. //货币代码
  98. //throw new NotImplementedException();
  99. DataTable dt4 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1001" }, this.ob);
  100. comm.FilComboboxAdd(txt_Currency, dt4, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  101. txt_Currency.SelectedIndex = 0;
  102. //加载运输条件
  103. DataTable dt6 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1105" }, this.ob);
  104. comm.FilComboboxAdd(txt_deliveryCondition, dt6, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
  105. txt_deliveryCondition.SelectedIndex = -1;
  106. //加载运输方式
  107. DataTable dt7 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1102" }, this.ob);
  108. comm.FilComboboxAdd(txt_deliveryType, dt7, "baseCode", "baseName", "validflag NOT in ('0')", true, "/", "");
  109. txt_deliveryType.SelectedIndex = -1;
  110. //加载合同金额分类
  111. //DataTable dt10 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1222" }, this.ob);
  112. //comm.FilComboboxAdd(txt_OrderMoneyType, dt10, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  113. //txt_OrderMoneyType.SelectedIndex = -1;
  114. //接收方式
  115. DataTable dt5 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1101" }, this.ob);
  116. comm.FilComboboxAdd(txt_ReceiveType, dt5, "baseCode", "baseName", "validflag NOT in ('0')", false, "/", "");
  117. txt_ReceiveType.SelectedIndex = 0;
  118. }
  119. /// <summary>
  120. /// 工具菜单栏
  121. /// </summary>
  122. /// <param name="sender"></param>
  123. /// <param name="e"></param>
  124. private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)// 工具菜单栏
  125. {
  126. switch (e.Tool.Key.ToString())
  127. {
  128. case "doRefresh":
  129. init();
  130. break;
  131. case "ok":
  132. AddOrder();
  133. break;
  134. case "Esc":
  135. this.Close();
  136. break;
  137. }
  138. }
  139. /// <summary>
  140. /// 生成合同
  141. /// </summary>
  142. private void AddOrder()// 生成合同
  143. {
  144. ultraGrid2.UpdateData();
  145. if (ultraGrid1.ActiveRow == null)
  146. {
  147. MessageUtil.ShowTips("无中标供应商");
  148. return;
  149. }
  150. if (ultraGrid2.ActiveRow == null)
  151. {
  152. MessageUtil.ShowTips("无中标物料或者请先选择中标物料");
  153. return;
  154. }
  155. UltraGridRow ugm = ultraGrid1.ActiveRow;
  156. UltraGridRow ugc = ultraGrid2.ActiveRow;
  157. String strOfferId = ugm.GetCellValue("OFFERID").ToString().Trim();//报价单
  158. String strTaskRecord=ugm.GetCellValue("remark").ToString().Trim();//纪要号
  159. String strTaskId = ugm.GetCellValue("taskId").ToString().Trim();//任务单
  160. if (String.IsNullOrEmpty(strTaskRecord))
  161. {
  162. MessageUtil.ShowTips("数据异常,选中行的采购纪要号为空,可能还未生成采购纪要!");
  163. return;
  164. }
  165. if (String.IsNullOrEmpty(strOfferId))
  166. {
  167. MessageUtil.ShowTips("数据异常,选中行的报价单号为空!");
  168. return;
  169. }
  170. if (String.IsNullOrEmpty(strTaskId))
  171. {
  172. MessageUtil.ShowTips("数据异常,选中行的任务单号为空,可能还未生成采购纪要!");
  173. return;
  174. }
  175. if (testStatusRecord(strTaskRecord) == false)
  176. {
  177. return;
  178. }
  179. if (testStatusTask(strTaskId) == false)
  180. {
  181. return;
  182. }
  183. PurTaskOfferMEntity offerM = this.execute<PurTaskOfferMEntity>("com.hnshituo.pur.purplan.service.TaskOfferMService", "findById", new object[] { strOfferId });
  184. String strSuppCode = offerM.SuppCode;//供应商
  185. if(String.IsNullOrEmpty(strSuppCode))
  186. {
  187. MessageUtil.ShowTips("数据异常,选中行的供应商编号为空!");
  188. return;
  189. }
  190. Supp supp = this.execute<Supp>("com.hnshituo.pur.configure.service.SuppService", "findById", new object[] { strSuppCode });
  191. if (testInputData() == false)
  192. {
  193. return;
  194. }
  195. OrderM Odm = new OrderM();
  196. //Odm.PorderId
  197. Odm.Status = "0";//草稿状态
  198. Odm.Validflag = "1";
  199. Odm.BuyerName =UserInfo.GetUserName();//合同提报业务员
  200. Odm.CreateName = UserInfo.GetUserName();
  201. Odm.CreateUserid = UserInfo.GetUserID();
  202. Odm.CreateTime = DateTime.Now;
  203. Odm.SignDate = DateTime.Now;
  204. Odm.SignAddress = "天津市";
  205. Odm.SuppCode = supp.SuppCode;//供应商代码
  206. Odm.SuppName = supp.SuppName;//供应商名称
  207. //Odm.TaxRateName = supp.SuppTaxRate;//税率
  208. Odm.AftPaymentAmt1 = 0;
  209. Odm.TaskRecordId = strTaskRecord;
  210. //if (Odm.TaxRateName == "" || Odm.TaxRateName == "NULL")
  211. //{
  212. // if (MessageUtil.ShowYesNoAndQuestion("供应商:" + strSuppCode + "未维护税率,若生成合同将默认税率为为0%,是否继续?") == DialogResult.Yes)
  213. // {
  214. // Odm.TaxRateName = "0%";
  215. // }
  216. // else
  217. // {
  218. // return;
  219. // }
  220. //}
  221. Odm.Currency = txt_Currency.Value == null ? "" : txt_Currency.Value.ToString().Trim();
  222. Odm.DeliveryCondition = txt_deliveryCondition.Value == null ? "" : txt_deliveryCondition.Value.ToString().Trim();
  223. Odm.DeliveryType = txt_deliveryType.Value == null ? "" : txt_deliveryType.Value.ToString().Trim();
  224. Odm.OrderClass = txt_OrderClass.Value == null ? "" : txt_OrderClass.Value.ToString().Trim();
  225. Odm.OrderType = txt_OrderType.Value == null ? "" : txt_OrderType.Value.ToString().Trim();
  226. Odm.ModeId = init_Mode_Id;
  227. Odm.ModeName = txt_ModeName.Text.ToString().Trim();
  228. Odm.OrderTitleCode = init_OrderTitleCode;
  229. Odm.BuyerDeptCode = UserInfo.GetDeptid();
  230. Odm.BuyerDeptDesc = UserInfo.GetDepartment();
  231. double amtwithtax = 0;
  232. double amtwithouttax = 0;
  233. double amttax = 0;
  234. int i=0;
  235. ArrayList list = new ArrayList();
  236. foreach (UltraGridRow uRows in ultraGrid2.Rows)
  237. {
  238. if (Convert.ToBoolean(uRows.GetCellValue("CHK")) == true)
  239. {
  240. i = i + 1;
  241. String strLineId = uRows.GetCellValue("Id").ToString().Trim();
  242. if (String.IsNullOrEmpty(strLineId))
  243. {
  244. MessageUtil.ShowTips("物料" + uRows.GetCellValue("itemName") + "无报价单行号,数据异常!");
  245. return;
  246. }
  247. PurTaskOfferCEntity oc = this.execute<PurTaskOfferCEntity>("com.hnshituo.pur.purplan.service.TaskOfferCService", "findById", new object[] { strLineId });
  248. OrderC odC = new OrderC();
  249. odC.OfferType = oc.OfferType;
  250. odC.ResPriceFreight = oc.ResPriceFreight;
  251. odC.ResPricePackage = oc.ResPricePackage;
  252. odC.TaskOfferCId = oc.Id;//报价单行号
  253. odC.TaskLineId = oc.TaskLineId;//任务单行号
  254. odC.SuppCode = supp.SuppCode;//供应商代码
  255. odC.SuppName = supp.SuppName;//供应商名称
  256. odC.ItemName = oc.ItemName;//物料简称
  257. odC.ItemCode = oc.ItemCode;
  258. odC.ItemUom = oc.ItemUom;//采购单位(个、袋、桶)
  259. odC.ItemUomId = oc.ItemUomId;
  260. odC.ItemUnique = oc.ItemUnique;//唯一码
  261. odC.ItemStandardsCode = oc.ItemStandardsCode;//标准值
  262. odC.ItemStandardsId = oc.ItemStandardsId;//标准编码
  263. odC.ItemUomConefficient = oc.ItemUomConefficient;//转换系数
  264. odC.WeightUnit = oc.WeightUnit;//库存单位
  265. odC.BuyerName = UserInfo.GetUserName();//采购员
  266. if (testHasStandards_jhy(odC) == false)
  267. {
  268. return;
  269. }
  270. //更新物料属性
  271. odC.ItemAttr = oc.ItemAttr;
  272. odC.ItemAttrId = oc.ItemAttrId;
  273. odC.PurLineId = oc.MrLineId;
  274. odC.Validflag = "1";
  275. odC.CreateName = UserInfo.GetUserName();
  276. odC.CreateUserid = UserInfo.GetUserID();
  277. odC.CreateTime = DateTime.Now;
  278. odC.ReceiveType = txt_ReceiveType.Value == null ? "" : txt_ReceiveType.Value.ToString();
  279. odC.PaymentCode = oc.PaymentCode;
  280. odC.PackageType = oc.PackageType;
  281. odC.StartDate = DateTime.Now;
  282. if (String.IsNullOrEmpty(uRows.GetCellValue("ASKDELIVERDATE") == null ? "" : uRows.GetCellValue("ASKDELIVERDATE").ToString()))
  283. {
  284. MessageUtil.ShowTips("物料:" + odC.ItemName + "要求的交期不能为空!");
  285. return;
  286. }
  287. odC.EndDate = Convert.ToDateTime(uRows.GetCellValue("ASKDELIVERDATE"));
  288. //金额计算
  289. double bidQty = 0;
  290. double canUseQty = 0;
  291. double createQty = 0;
  292. double.TryParse(uRows.Cells["createQty"].Value.ToString(), out createQty);
  293. double.TryParse(uRows.Cells["bidWinQty"].Value.ToString(), out bidQty);
  294. double.TryParse(uRows.Cells["canUseQty"].Value.ToString(), out canUseQty);
  295. createQty = Math.Round(createQty, 3, MidpointRounding.AwayFromZero);
  296. bidQty = Math.Round(bidQty, 3, MidpointRounding.AwayFromZero);
  297. canUseQty = Math.Round(canUseQty, 3, MidpointRounding.AwayFromZero);
  298. if (createQty > canUseQty)
  299. {
  300. MessageUtil.ShowTips("编制量不能大于剩余可编制量");
  301. return;
  302. }
  303. if (createQty > bidQty)
  304. {
  305. MessageUtil.ShowTips("编制量不能大于中标量");
  306. return;
  307. }
  308. odC.Qty = createQty;//采购数量
  309. odC.PriceWithTax = oc.BidWinWithTaxPrice;
  310. if (odC.Qty == null || oc.BidWinWithTaxPrice == null)
  311. {
  312. MessageUtil.ShowTips("物料:" + odC.SuppCode + "中标数量、中标含税单价不能为空!");
  313. return;
  314. }
  315. if (oc.BidWinWithTaxPrice<0)
  316. {
  317. MessageUtil.ShowTips("物料:" + odC.SuppCode + "中标含税单价需大于等于0!");
  318. return;
  319. }
  320. if (isRightRate(uRows.GetCellValue("TaxRateName")))
  321. {
  322. MessageUtil.ShowTips("物料" + uRows.GetCellValue("itemName") + "无税率或者输入税率异常(例:13%),请确定!");
  323. return;
  324. }
  325. odC.TaxRateName = uRows.GetCellValue("TaxRateName").ToString();
  326. odC.CkQty = odC.Qty * oc.ItemUomConefficient;
  327. list.Add(odC);
  328. }
  329. }
  330. if (i == 0)
  331. {
  332. MessageUtil.ShowTips("未选择物料!");
  333. return;
  334. }
  335. if (amtwithtax > 10000000000)
  336. {
  337. MessageUtil.ShowTips("合同最大采购额度为100亿!");
  338. return;
  339. }
  340. CoreResult re2 = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "insert_orderC", new object[] { Odm, list });
  341. if (re2.Resultcode == 0)
  342. {
  343. String tempOrderId=re2.Resultmsg.ToString().Trim();
  344. if (doSureOrder(tempOrderId) == "1")//确认退出
  345. {
  346. CoreResult re3 = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "doEffectOrderData", new object[] { tempOrderId });//正式启用合同
  347. if (re3.Resultcode == 0)
  348. {
  349. MessageUtil.ShowTips("创建成功,生成合同:" + tempOrderId);
  350. init();
  351. return;
  352. }
  353. else
  354. {
  355. CoreResult re5 = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "doClearOrderData", new object[] { tempOrderId });//清除合同数据
  356. if (re5.Resultcode != 0)
  357. {
  358. MessageUtil.ShowTips("操作失败:" + re5.Resultmsg);
  359. }
  360. else
  361. {
  362. MessageUtil.ShowTips("操作失败:" + re3.Resultmsg);
  363. }
  364. }
  365. }
  366. else
  367. {
  368. //清除无效合同数据
  369. CoreResult re4 = this.execute<CoreResult>("com.hnshituo.pur.order.service.OrderMService", "doClearOrderData", new object[] { tempOrderId });//清除合同数据
  370. if (re4.Resultcode != 0)
  371. {
  372. MessageUtil.ShowTips("操作失败:"+re4.Resultmsg);
  373. init();
  374. }
  375. }
  376. }
  377. else
  378. {
  379. MessageBox.Show("操作失败:" + re2.Resultmsg);
  380. return;
  381. }
  382. }
  383. /// <summary>
  384. /// 是否维护检验项目
  385. /// </summary>
  386. /// <param name="odC"></param>
  387. /// <returns></returns>
  388. private bool testHasStandards_jhy(OrderC odC)
  389. {
  390. DataTable dt8 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1229" }, this.ob);
  391. if (dt8== null)
  392. {
  393. MessageUtil.ShowTips("基础数据配置出错,请维护检化验物料限制条件");
  394. return false;
  395. }
  396. if (dt8.Rows.Count <= 0)
  397. {
  398. MessageUtil.ShowTips("基础数据配置出错,请维护检化验物料限制条件");
  399. return false;
  400. }
  401. DataRow row = dt8.Select("baseCode = '122901'")[0];
  402. if (row["memo"].ToString() == "1")
  403. {
  404. MatEntity mat = this.execute<MatEntity>("com.hnshituo.pur.configure.service.MatService", "findById", new object[] { odC.ItemCode});
  405. if (mat.MeteringFlag == "1")
  406. {
  407. MatStdBaseinfo baseinfo = new MatStdBaseinfo();
  408. baseinfo.ProductStd = odC.ItemStandardsCode;
  409. baseinfo.ItemCode = odC.ItemCode;
  410. baseinfo.Validflag = "1";
  411. List<MatStdBaseinfo> list_baseinfo = this.execute<List<MatStdBaseinfo>>("com.hnshituo.pur.jhy.service.MatStdBaseinfo_jhyService", "find", new object[] { baseinfo, 0, 0 });
  412. if (list_baseinfo == null)
  413. {
  414. MessageUtil.ShowTips("物料:" + odC.ItemName + "未维护检验标准,请联系质保部维护");
  415. return false;
  416. }
  417. if (list_baseinfo.Count <= 0)
  418. {
  419. MessageUtil.ShowTips("物料:" + odC.ItemName + "未维护检验标准,请联系质保部维护");
  420. return false;
  421. }
  422. //else
  423. //{
  424. // MatStdDetail detail = new MatStdDetail();
  425. // detail.Mic = list_baseinfo[0].Mic;
  426. // detail.Validflag = "1";
  427. // List<MatStdDetail> list_detail = this.execute<List<MatStdDetail>>("com.hnshituo.pur.jhy.service.MatStdBaseinfo_jhyService", "find", new object[] { detail, 0, 0 });
  428. // if (list_detail == null)
  429. // {
  430. // MessageUtil.ShowTips("物料:" + odC.ItemName + "未维护检验项目,请联系质保部维护");
  431. // return false;
  432. // }
  433. // if (list_detail.Count <= 0)
  434. // {
  435. // MessageUtil.ShowTips("物料:" + odC.ItemName + "未维护检验项目,请联系质保部维护");
  436. // return false;
  437. // }
  438. //}
  439. }
  440. }
  441. return true;
  442. }
  443. private string doSureOrder(string tempOrderId)
  444. {
  445. //合同预览
  446. try
  447. {
  448. String tempTips = "0";
  449. if (String.IsNullOrEmpty(tempOrderId))
  450. {
  451. MessageUtil.ShowWarning("请选择合同的合同编号为空!");
  452. return tempTips;
  453. }
  454. OrderM Omg = this.execute<OrderM>("com.hnshituo.pur.order.service.OrderMService", "findById", new object[] { tempOrderId });
  455. if (Omg == null)
  456. {
  457. MessageUtil.ShowWarning("未发现合同:" + tempOrderId + "信息记录");
  458. return tempTips;
  459. }
  460. OrderModeM omm = this.execute<OrderModeM>("com.hnshituo.pur.order.service.OrderModeMService", "findById", new object[] { Omg.ModeId });
  461. this.Cursor = Cursors.WaitCursor;
  462. string strurl = "";
  463. DataTable dt = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1223" }, this.ob);
  464. DataRow[] drArr = dt.Select("validflag='1'");
  465. if (drArr.Length != 1)
  466. {
  467. MessageUtil.ShowTips("基础数据维护错误:报表系统需维护有效的Ip且只能维护一个有效ip!");
  468. return tempTips;
  469. }
  470. String TipsEnv = drArr[0]["baseName"].ToString();
  471. String strUrlPort = "http://172.54.10.42:8080";//报表系统IP
  472. String[] str = strUrlPort.Split(':');
  473. String strUrl = str[0] + ":" + str[1];
  474. if (ob.MainUrl.StartsWith(strUrl))
  475. {
  476. //测试环境
  477. if (TipsEnv == "2")
  478. {
  479. if (Omg.OrderType == "120024")
  480. {
  481. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev_GT.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  482. }
  483. else
  484. {
  485. if (omm.OrderClass == "122002")
  486. {
  487. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMMDev.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  488. }
  489. else
  490. {
  491. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  492. }
  493. }
  494. }
  495. else
  496. {
  497. if (Omg.OrderType == "120024")
  498. {
  499. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder_GT.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  500. }
  501. else
  502. {
  503. if (omm.OrderClass == "122002")
  504. {
  505. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMM.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  506. }
  507. else
  508. {
  509. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  510. }
  511. }
  512. }
  513. }
  514. else
  515. {
  516. //测试环境
  517. if (TipsEnv == "2")
  518. {
  519. if (Omg.OrderType == "120024")
  520. {
  521. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev_GT.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  522. }
  523. else
  524. {
  525. if (omm.OrderClass == "122002")
  526. {
  527. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMMDev.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  528. }
  529. else
  530. {
  531. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  532. }
  533. }
  534. }
  535. else
  536. {
  537. if (Omg.OrderType == "120024")
  538. {
  539. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder_GT.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  540. }
  541. else
  542. {
  543. if (omm.OrderClass == "122002")
  544. {
  545. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrderMM.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  546. }
  547. else
  548. {
  549. strurl = strUrlPort + "/webroot/decision/view/report?viewlet=RepPurOrder.cpt&op=view" + "&cmbOrder=" + tempOrderId;
  550. }
  551. }
  552. }
  553. }
  554. //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
  555. //{
  556. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrderDev.cpt&__bypagesize__=false" + "&cmbOrder=" + tempOrderId;
  557. //}
  558. //else
  559. //{
  560. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepPurOrder.cpt&__bypagesize__=false" + "&cmbOrder=" + tempOrderId;
  561. //}
  562. FrmPurOrderReview fBug = new FrmPurOrderReview(ob, strurl);
  563. fBug.AutoSize = true;
  564. //fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  565. //fBug.WindowState = FormWindowState.Maximized;
  566. fBug.Text = "待生成合同确定";
  567. fBug.ShowDialog();
  568. if (fBug.Tips == "1")
  569. {
  570. tempTips = fBug.Tips;
  571. return tempTips;
  572. }
  573. else
  574. {
  575. return tempTips;
  576. }
  577. }
  578. finally
  579. {
  580. this.Cursor = Cursors.Default;
  581. }
  582. }
  583. //验证税率
  584. private bool isRightRate(object p)
  585. {
  586. if (p == null)
  587. {
  588. return true;
  589. }
  590. String strP = p.ToString().Trim();
  591. if (!Regex.IsMatch(strP, @"^[1-2]{0,1}[0-9]%$"))
  592. {
  593. return true;
  594. }
  595. return false;
  596. }
  597. private bool testStatusRecord(string strTaskRecord)
  598. {
  599. String strRecordId = strTaskRecord;
  600. PurTaskRecordEntity taskRecord = this.execute<PurTaskRecordEntity>("com.hnshituo.pur.purplan.service.TaskRecordService", "findById", new object[] { strRecordId });
  601. if (taskRecord == null)
  602. {
  603. MessageUtil.ShowTips("未发现纪要:" + strRecordId + "信息记录,可能已被作废!或请刷新界面重新操作!");
  604. return false;
  605. }
  606. if (taskRecord.Validflag == "0")
  607. {
  608. MessageUtil.ShowTips("纪要:" + strRecordId + "信息记录可能已被作废!或请刷新界面重新操作!");
  609. return false;
  610. }
  611. if (taskRecord.Status != "3")
  612. {
  613. MessageUtil.ShowTips("纪要:" + strRecordId + "信息未生效,无法生成合同!或请刷新界面重新操作!");
  614. return false;
  615. }
  616. return true;
  617. }
  618. private bool testStatusTask(string strTaskId)
  619. {
  620. PurTaskMEntity PurTaskM = this.execute<PurTaskMEntity>("com.hnshituo.pur.purplan.service.TaskMService", "findById", new object[] { strTaskId });
  621. if (PurTaskM == null)
  622. {
  623. MessageUtil.ShowTips("未发现任务单:" + strTaskId + "信息记录,可能已被作废!或请刷新界面重新操作!");
  624. return false;
  625. }
  626. if (PurTaskM.Validflag == "0")
  627. {
  628. MessageUtil.ShowTips("任务单:" + strTaskId + "信息记录可能已被作废!或请刷新界面重新操作!");
  629. return false;
  630. }
  631. if (PurTaskM.Status== "11")
  632. {
  633. MessageUtil.ShowTips("任务单:" + strTaskId + "已完成合同生成!");
  634. return false;
  635. }
  636. if (PurTaskM.Status != "10")
  637. {
  638. MessageUtil.ShowTips("任务单:" + strTaskId + "不在“待生成合同”状态,无法生成合同!");
  639. return false;
  640. }
  641. this.isAllowSplit = PurTaskM.IsAllowSplit;
  642. return true;
  643. }
  644. /// <summary>
  645. /// 点击主表
  646. /// </summary>
  647. /// <param name="sender"></param>
  648. /// <param name="e"></param>
  649. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)// 点击主表
  650. {
  651. getOrderRow();
  652. }
  653. private void getOrderRow()
  654. {
  655. UltraGridRow uRow = ultraGrid1.ActiveRow;
  656. if (uRow != null)
  657. {
  658. String strOfferId = uRow.GetCellValue("OFFERID").ToString().Trim();//报价单
  659. if (String.IsNullOrEmpty(strOfferId))
  660. {
  661. MessageUtil.ShowTips("数据异常,选中行的报价单号为空!");
  662. return;
  663. }
  664. PurTaskOfferMEntity offerM = this.execute<PurTaskOfferMEntity>("com.hnshituo.pur.purplan.service.TaskOfferMService", "findById", new object[] { strOfferId });
  665. String strSuppCode = offerM.SuppCode;//供应商
  666. if (String.IsNullOrEmpty(strSuppCode))
  667. {
  668. MessageUtil.ShowTips("数据异常,选中行的供应商编号为空!");
  669. return;
  670. }
  671. Supp supp = this.execute<Supp>("com.hnshituo.pur.configure.service.SuppService", "findById", new object[] { strSuppCode });
  672. txt_deliveryCondition.Value = offerM.DeliveryCondition == null ? "" : offerM.DeliveryCondition;
  673. txt_deliveryType.Value = offerM.DeliveryType == null ? "" : offerM.DeliveryType;
  674. txt_Currency.Value = supp.SuppRegCapCurrency;
  675. if (txt_Currency.Value == null)
  676. {
  677. txt_Currency.SelectedIndex = 0;//默认选择人民币
  678. }
  679. txt_ReceiveType.Value = offerM.ReceiveType;
  680. PurTaskOfferCEntity TkoC = new PurTaskOfferCEntity();
  681. TkoC.TaskId = uRow.Cells["TaskId"].Value.ToString();
  682. TkoC.Validflag = "1";
  683. TkoC.IsBid = "1";
  684. TkoC.OfferId = strOfferId;
  685. TkoC.SuppCode = strSuppCode;
  686. TkoC.DeleteName = "1";//查询未生成合同的
  687. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.purplan.service.TaskOfferCService", "findTaskOfferC", new object[] { TkoC });
  688. double sumCurrency = 0;//中标含税总金额
  689. dt.Columns.Add("BIDWITHOUTTAXAMT", Type.GetType("System.String"));
  690. dt.Columns.Add("BIDWITHTAXAMT", Type.GetType("System.String"));
  691. dt.Columns.Add("createQty", Type.GetType("System.String"));
  692. foreach (DataRow row in dt.Rows)
  693. {
  694. if (row["canUseQty"] == DBNull.Value)
  695. {
  696. MessageUtil.ShowTips("中标数据异常,物料" + row["ITEMNAME"] + "剩余可编制数量为为空或小于0");
  697. continue;
  698. }
  699. double canUseQty = Convert.ToDouble(row["canUseQty"]);
  700. if (canUseQty <= 0)
  701. {
  702. MessageUtil.ShowTips("中标数据异常,物料" + row["ITEMNAME"] + "剩余可编制数量为为空或小于0");
  703. continue;
  704. }
  705. row["createQty"] = canUseQty;
  706. if (row["BIDWINWITHTAXPRICE"] == DBNull.Value)
  707. {
  708. MessageUtil.ShowTips("中标数据异常,物料" + row["ITEMNAME"] + "中标含税为空或小于0");
  709. continue;
  710. }
  711. double BIDWINWITHTAXPRICE = Convert.ToDouble(row["BIDWINWITHTAXPRICE"]);
  712. if (BIDWINWITHTAXPRICE < 0)
  713. {
  714. MessageUtil.ShowTips("中标数据异常,物料" + row["ITEMNAME"] + "中标含税为空或小于0");
  715. continue;
  716. }
  717. double TaxRate = 0;
  718. String strTaxRate = "";
  719. if (row["TAXRATENAME"] == DBNull.Value || String.IsNullOrEmpty(row["TAXRATENAME"].ToString().Trim()))
  720. {
  721. if (supp.SuppTaxRate == "NULL" || String.IsNullOrEmpty(supp.SuppTaxRate))
  722. {
  723. MessageUtil.ShowTips("请维护供应商税率");
  724. return;
  725. }
  726. else
  727. {
  728. strTaxRate = supp.SuppTaxRate;
  729. TaxRate = Convert.ToDouble(strTaxRate.TrimEnd('%')) / 100;
  730. }
  731. }
  732. else
  733. {
  734. strTaxRate = row["TAXRATENAME"].ToString().Trim();
  735. TaxRate = Convert.ToDouble(strTaxRate.TrimEnd('%')) / 100;
  736. }
  737. double BIDWITHTAXAMT = BIDWINWITHTAXPRICE * canUseQty;
  738. row["BIDWITHTAXAMT"] = BIDWITHTAXAMT;
  739. double BIDWINWITHOUTTAXPRICE = Math.Round(BIDWINWITHTAXPRICE / (1 + TaxRate), 2);
  740. row["BIDWINWITHOUTTAXPRICE"] = BIDWINWITHOUTTAXPRICE;
  741. double BIDWITHOUTTAXAMT = BIDWINWITHOUTTAXPRICE * canUseQty;
  742. row["BIDWITHOUTTAXAMT"] = BIDWITHOUTTAXAMT;
  743. row["TAXRATENAME"] = strTaxRate;
  744. row["BIDWINTAXAMT"] = BIDWITHTAXAMT - BIDWITHOUTTAXAMT;
  745. sumCurrency = sumCurrency + BIDWITHOUTTAXAMT;
  746. }
  747. GridHelper.CopyDataToDatatable(dt, dataTable2, true);
  748. GridHelper.RefreshAndAutoSize(ultraGrid2);
  749. //DataTable dt10 = ServerHelper.GetData("com.hnshituo.pur.configure.service.impl.CoreBaseInfoNew.doQuery", new Object[] { "1222" }, this.ob);
  750. //foreach (DataRow row in dt10.Rows)
  751. //{
  752. // if ((Convert.ToDouble(row["memo1"])<=sumCurrency/10000)&&(sumCurrency/10000<Convert.ToDouble(row["memo2"])))
  753. // {
  754. // txt_OrderMoneyType.Value = row["basecode"].ToString().Trim();
  755. // }
  756. //}
  757. foreach (UltraGridRow row in ultraGrid2.Rows)
  758. {
  759. row.Cells["CHK"].Value = true;
  760. }
  761. }
  762. }
  763. /// <summary>
  764. /// 合同模板弹窗
  765. /// </summary>
  766. /// <param name="sender"></param>
  767. /// <param name="e"></param>
  768. private void txt_ModeName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  769. {
  770. String strOrderType=txt_OrderType.SelectedIndex == -1 ? "" : txt_OrderType.Value.ToString().Trim();
  771. FrmPop_upOrderMode Pop = new FrmPop_upOrderMode(this.ob, strOrderType);
  772. Pop.ShowDialog();
  773. if (Pop.ModeId == null)
  774. return;
  775. txt_ModeName.Text = Pop.ModeName.ToString();
  776. init_Mode_Id = Pop.ModeId.ToString();
  777. }
  778. /// <summary>
  779. /// 抬头弹窗
  780. /// </summary>
  781. /// <param name="sender"></param>
  782. /// <param name="e"></param>
  783. private void txt_TitleName_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  784. {
  785. FrmPop_upTitle Pot = new FrmPop_upTitle(this.ob);
  786. Pot.ShowDialog();
  787. if (Pot.Id == null)
  788. return;
  789. init_OrderTitleCode = Pot.Id;
  790. txt_TitleName.Text = Pot.TitleName;
  791. }
  792. /// <summary>
  793. /// 清空编辑区
  794. /// </summary>
  795. private void clearTab()
  796. {
  797. //合同类别
  798. txt_OrderType.SelectedIndex = -1;
  799. //合同分类
  800. txt_OrderClass.SelectedIndex = 0;
  801. //货币代码
  802. txt_Currency.SelectedIndex = 0;
  803. //加载运输条件
  804. txt_deliveryCondition.SelectedIndex = -1;
  805. //加载运输方式
  806. txt_deliveryType.SelectedIndex = -1;
  807. //加载合同金额分类
  808. //txt_OrderMoneyType.SelectedIndex = -1;
  809. txt_TitleName.Text = "";
  810. txt_ModeName.Text = "";
  811. init_Mode_Id = "";
  812. init_OrderTitleCode = "";
  813. txt_ReceiveType.SelectedIndex = -1;
  814. }
  815. /// <summary>
  816. /// 测试编辑区数据有效性
  817. /// </summary>
  818. /// <returns></returns>
  819. private bool testInputData()
  820. {
  821. if (txt_Currency.SelectedIndex == -1)
  822. {
  823. MessageUtil.ShowTips("合同货币类型未选择!");
  824. txt_Currency.Focus();
  825. return false;
  826. }
  827. if (txt_OrderType.SelectedIndex == -1)
  828. {
  829. MessageUtil.ShowTips("合同类别未选择!");
  830. txt_OrderType.Focus();
  831. return false;
  832. }
  833. if (txt_OrderClass.SelectedIndex == -1)
  834. {
  835. MessageUtil.ShowTips("合同分类未选择!");
  836. txt_OrderClass.Focus();
  837. return false;
  838. }
  839. //if (txt_OrderMoneyType.SelectedIndex == -1)
  840. //{
  841. // MessageUtil.ShowTips("合同金额分类未选择!");
  842. // txt_OrderMoneyType.Focus();
  843. // return false;
  844. //}
  845. if (txt_ReceiveType.SelectedIndex == -1)
  846. {
  847. MessageUtil.ShowTips("合同接收方式未选择!");
  848. txt_ReceiveType.Focus();
  849. return false;
  850. }
  851. if (init_Mode_Id == "")
  852. {
  853. MessageUtil.ShowTips("合同模板未选择!");
  854. txt_ModeName.Focus();
  855. return false;
  856. }
  857. if (init_OrderTitleCode == "")
  858. {
  859. MessageUtil.ShowTips("合同买方未选择!");
  860. txt_TitleName.Focus();
  861. return false;
  862. }
  863. return true;
  864. }
  865. private void ultraGrid2_CellChange(object sender, CellEventArgs e)
  866. {
  867. if (e.Cell.Column.Key == "createQty")//采购数量
  868. {
  869. object o = e.Cell.Value;
  870. ultraGrid2.UpdateData();
  871. double bidQty = 0;
  872. double canUseQty = 0;
  873. double createQty = 0;
  874. double.TryParse(ultraGrid2.ActiveRow.Cells["createQty"].Value.ToString(), out createQty);
  875. double.TryParse(ultraGrid2.ActiveRow.Cells["bidWinQty"].Value.ToString(), out bidQty);
  876. double.TryParse(ultraGrid2.ActiveRow.Cells["canUseQty"].Value.ToString(), out canUseQty);
  877. createQty=Math.Round(createQty,3, MidpointRounding.AwayFromZero);
  878. bidQty=Math.Round(bidQty,3, MidpointRounding.AwayFromZero);
  879. canUseQty = Math.Round(canUseQty, 3, MidpointRounding.AwayFromZero);
  880. if (createQty > canUseQty)
  881. {
  882. MessageUtil.ShowTips("编制量不能大于剩余可编制量");
  883. e.Cell.Value = o;
  884. return;
  885. }
  886. if (createQty > bidQty)
  887. {
  888. MessageUtil.ShowTips("编制量不能大于中标量");
  889. e.Cell.Value = o;
  890. return;
  891. }
  892. }
  893. }
  894. }
  895. }