23769fb750a6c88954f6b5f246ce6a341438642c.svn-base 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151
  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.UIE
  12. {
  13. public partial class UIE041070 : FrmBase
  14. {
  15. public UIE041070()
  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. }
  27. }
  28. public string Condition
  29. {
  30. set
  31. {
  32. string[] array = value.Trim().Split(new char[] { '|' });
  33. if (array.Length < 3) return;
  34. this.textORD_NO.Text = array[0];
  35. this.ComboORD_SEQ.Value = array[1];
  36. this.ComboPROG_CD.Value = array[2];
  37. this.DoQuery();
  38. }
  39. }
  40. public void init()
  41. {
  42. string commCodeCd = "E01002";
  43. DataTable dt = new DataTable();
  44. CoreClientParam ccp = new CoreClientParam();
  45. ccp.ServerName = "UIB.COM.ComDBQuery";
  46. ccp.MethodName = "doSimpleQuery";
  47. ArrayList paramArray = new ArrayList();
  48. paramArray.Add("UIECOMM00_SELECT.COMM_CODE");
  49. paramArray.Add(commCodeCd);
  50. ccp.ServerParams = new object[] { paramArray };
  51. ccp.SourceDataTable = dt;
  52. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  53. Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboPROG_CD, ref dt, "E01002");
  54. }
  55. public void getOrdSeq()
  56. {
  57. try
  58. {
  59. string ordNO = this.textORD_NO.Text;
  60. DataTable dt = new DataTable();
  61. ArrayList paramArray = new ArrayList();
  62. paramArray.Add("UIECOMM00_SELECT.ORD_SEQ");
  63. paramArray.Add(ordNO);
  64. CoreClientParam ccp = new CoreClientParam();
  65. ccp.ServerName = "UIB.COM.ComDBQuery";
  66. ccp.MethodName = "doSimpleQuery";
  67. ccp.ServerParams = new object[] { paramArray };
  68. ccp.SourceDataTable = dt;
  69. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  70. Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboORD_SEQ, ref dt, "ORD_SEQ");
  71. }
  72. catch (Exception EX)
  73. {
  74. MessageBox.Show(EX.ToString());
  75. }
  76. }
  77. private void DoQuery()
  78. {
  79. try
  80. {
  81. string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textORD_NO.Text));
  82. string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboORD_SEQ.Value));
  83. string progCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboPROG_CD.Value));
  84. this.dataSet1.Tables[0].Clear();
  85. CoreClientParam ccp = new CoreClientParam();
  86. ccp.ServerName = "UIB.COM.ComDBQuery";
  87. ccp.MethodName = "doSimpleQuery";
  88. ArrayList paramArray = new ArrayList();
  89. paramArray.Add("UIE041070.COIL.Select");
  90. paramArray.Add(ordNO);
  91. paramArray.Add(ordSeq);
  92. paramArray.Add(progCD);
  93. paramArray.Add(ordNO);
  94. paramArray.Add(ordSeq);
  95. paramArray.Add(progCD);
  96. paramArray.Add(ordNO);
  97. paramArray.Add(ordSeq);
  98. paramArray.Add(progCD);
  99. paramArray.Add(ordNO);
  100. paramArray.Add(ordSeq);
  101. paramArray.Add(progCD);
  102. paramArray.Add(ordNO);
  103. paramArray.Add(ordSeq);
  104. paramArray.Add(progCD);
  105. paramArray.Add(ordNO); //
  106. paramArray.Add(ordSeq);//
  107. paramArray.Add(progCD);//
  108. ccp.ServerParams = new object[] { paramArray};
  109. ccp.SourceDataTable = this.dataSet1.Tables[0];
  110. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  111. Console.WriteLine(this.dataSet1.Tables[0].ToString());
  112. }
  113. catch (Exception EX)
  114. {
  115. MessageBox.Show(EX.ToString());
  116. }
  117. }
  118. private void UIE041070_Load(object sender, EventArgs e)
  119. {
  120. init();
  121. }
  122. private void textORD_NO_Leave(object sender, EventArgs e)
  123. {
  124. this.getOrdSeq();
  125. }
  126. private void ultraGrid1_AfterCellActivate(object sender, EventArgs e)
  127. {
  128. Infragistics.Win.UltraWinGrid.UltraGrid tt = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
  129. string matNO = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveRow.Cells["MAT_NO"].Value));
  130. UIE041090 frm = new UIE041090();
  131. frm.ob = this.ob;
  132. frm.Condition = matNO;
  133. frm.ShowDialog();
  134. }
  135. }
  136. }