UIK080012.cs 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  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;
  10. using System.Collections;
  11. namespace Core.LZMes.Client.UIK
  12. {
  13. public partial class UIK080012 : FrmBase
  14. {
  15. public UIK080012()
  16. {
  17. InitializeComponent();
  18. }
  19. public override void ToolBar_Click(object sender, string ToolbarKey)
  20. {
  21. switch (ToolbarKey)
  22. {
  23. case "Query":
  24. this.doQuery();
  25. break;
  26. case "Save":
  27. this.doSave();
  28. this.doQuery();
  29. break;
  30. }
  31. }
  32. #region 初始化
  33. private void init()
  34. {
  35. string commCodeCd = "E04002";
  36. DataTable dt = new DataTable();
  37. CoreClientParam ccp = new CoreClientParam();
  38. ccp.ServerName = "UIB.COM.ComDBQuery";
  39. ccp.MethodName = "doSimpleQuery";
  40. ArrayList paramArray = new ArrayList();
  41. paramArray.Add("UIECOMM00_SELECT.COMM_CODE");
  42. paramArray.Add(commCodeCd);
  43. ccp.ServerParams = new object[] { paramArray };
  44. ccp.SourceDataTable = dt;
  45. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  46. Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboOPTTYPE, ref dt, "E04002");
  47. }
  48. #endregion
  49. #region 查询
  50. public void doQuery()
  51. {
  52. try
  53. {
  54. this.dataSet2.Tables[0].Clear();
  55. string opType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboOPTTYPE.Value));
  56. ArrayList arrayParam = new ArrayList();
  57. arrayParam.Add("UIK080012.OrdPrc.Select");
  58. //合同号
  59. string ordNo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraTextEditor1.Text));
  60. arrayParam.Add(ordNo);
  61. //订单号
  62. string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraTextEditor2.Text));
  63. arrayParam.Add(ordSeq);
  64. //交货期
  65. string delToDateFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd")));
  66. arrayParam.Add(delToDateFrom);
  67. string delToDateTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd")));
  68. arrayParam.Add(delToDateTo);
  69. string ComboOPTTYPE = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboOPTTYPE.Value));
  70. arrayParam.Add(ComboOPTTYPE);
  71. CoreClientParam ccp = new CoreClientParam();
  72. ccp.ServerName = "UIB.COM.ComDBQuery";
  73. ccp.MethodName = "doSimpleQuery";
  74. ccp.ServerParams = new object[] { arrayParam };
  75. ccp.SourceDataTable = this.dataSet2.Tables[0];
  76. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  77. }
  78. catch (Exception e)
  79. {
  80. MessageBox.Show(e.ToString());
  81. }
  82. }
  83. #endregion
  84. #region 保存
  85. public void doSave()
  86. {
  87. try
  88. {
  89. string regID = this.UserInfo.GetUserID();
  90. string regSHIFT = this.UserInfo.GetUserOrder();
  91. string regGROUP = this.UserInfo.GetUserGroup();
  92. //this.dataSet2.Tables[0].Clear();
  93. this.ultraGrid2.UpdateData();
  94. string ordno = "";
  95. string ordseq = "";
  96. StringBuilder retpt = new StringBuilder();
  97. // 生产处
  98. if (this.ultraCheckEditor1.Checked == true) { retpt.Append("S").Append("|"); }
  99. //炼钢
  100. if (this.ultraCheckEditor2.Checked == true) { retpt.Append("R").Append("|"); }
  101. // 热轧
  102. if (this.ultraCheckEditor3.Checked == true) { retpt.Append("L").Append("|"); }
  103. DataRow[] selectedRows = dataSet2.Tables[0].Select("CHK ='True'");
  104. CoreClientParam ccp;
  105. for (int i = 0; i < selectedRows.Length; i++)
  106. {
  107. ccp = new CoreClientParam();
  108. ordno = selectedRows[i]["ORD_NO"].ToString();
  109. ordseq = selectedRows[i]["ORD_SEQ"].ToString();
  110. ccp.ServerName = "UIK.UIK08.UIK080012";
  111. ccp.MethodName = "doSave";
  112. ccp.ServerParams = new object[] { ordno, ordseq, retpt.ToString(), regID, regSHIFT, regGROUP };
  113. ccp.SourceDataTable = this.dataSet2.Tables[0];
  114. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  115. }
  116. }
  117. catch (Exception e)
  118. {
  119. // MessageBox.Show(e.ToString());
  120. }
  121. }
  122. #endregion
  123. private void UIK080012_Load(object sender, EventArgs e)
  124. {
  125. init();
  126. }
  127. }
  128. }