QCM030805.cs 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239
  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. using Infragistics.Win.UltraWinGrid;
  12. using System.Diagnostics;
  13. namespace Core.LZMes.Client.QCM
  14. {
  15. public partial class QCM030805 : FrmBase
  16. {
  17. public QCM030805()
  18. {
  19. InitializeComponent();
  20. }
  21. public override void ToolBar_Click(object sender, string ToolbarKey)
  22. {
  23. switch (ToolbarKey)
  24. {
  25. case"Query":
  26. this.DoQuery();
  27. break;
  28. case "Update":
  29. this.Edit();
  30. break;
  31. case "Update1":
  32. this.Update1();
  33. break;
  34. case "Export":
  35. this.DoExport();
  36. break;
  37. }
  38. }
  39. private void Edit()
  40. {
  41. try
  42. {
  43. UltraGridRow ugr = this.ultraGrid2.ActiveRow;
  44. if (ugr == null)
  45. return;
  46. string heat_no = ugr.Cells["HEAT_NO"].Value.ToString();
  47. string assay_no = ugr.Cells["ASSAY_NO"].Value.ToString();
  48. string pline_code = ugr.Cells["pline_code"].Value.ToString();
  49. if(String.IsNullOrEmpty(txt_heat_no.Text.Trim())) {
  50. MessageBox.Show("修改号炉号不能为空!!");
  51. return;
  52. }
  53. if(String.IsNullOrEmpty(txt_assay_no.Text.Trim())) {
  54. MessageBox.Show("修改号检验号不能为空!!");
  55. return;
  56. }
  57. string new_heat_no = txt_heat_no.Text.Trim();
  58. string new_assay_no = txt_assay_no.Text.Trim();
  59. if (MessageBox.Show("是否确认把炉号:" + heat_no + " 检验号 " + assay_no + " 修改为【" + new_heat_no + "】【" + new_assay_no + "】!", "提示", MessageBoxButtons.YesNo) == DialogResult.No) return;
  60. ArrayList list1 = new ArrayList();
  61. list1.Add(heat_no);
  62. list1.Add(assay_no);
  63. list1.Add(pline_code);
  64. list1.Add(new_heat_no);
  65. list1.Add(new_assay_no);
  66. list1.Add(this.UserInfo.GetUserName());
  67. CoreClientParam ccp = new CoreClientParam();
  68. ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
  69. ccp.MethodName = "UpdateChemeInfo";
  70. ccp.ServerParams = new object[] { list1 };
  71. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  72. if (ccp.ReturnCode == -1)
  73. {
  74. return;
  75. }
  76. DoQuery();
  77. MessageBox.Show("修改成功!");
  78. }
  79. catch(Exception EX)
  80. {
  81. MessageBox.Show(EX.ToString());
  82. }
  83. }
  84. public static bool IsNumberal(string input)
  85. {
  86. bool flag = true;
  87. int count = 0;
  88. int count1 = 0;
  89. if (input.Length == 0)
  90. {
  91. flag = false;
  92. }
  93. else
  94. {
  95. char[] x = input.ToCharArray();
  96. for (int i = 0; i < input.Length; i++)
  97. {
  98. if (!char.IsNumber(x[i]) && x[i] != '.' && x[i] != '-')
  99. {
  100. flag = false; break;
  101. }
  102. if (x[i] == '.')
  103. {
  104. count++;
  105. if (i == 0 || i == input.Length - 1) flag = false;
  106. }
  107. if (x[i] == '-')
  108. {
  109. count1++;
  110. if (i > 1) flag = false;
  111. }
  112. }
  113. if (count > 1 || count1 > 1) flag = false;
  114. }
  115. return flag;
  116. }
  117. private void Update1()
  118. {
  119. try
  120. {
  121. UltraGridRow ugr = this.ultraGrid2.ActiveRow;
  122. if (ugr == null)
  123. return;
  124. string assay_no = ugr.Cells["ASSAY_NO"].Value.ToString();
  125. string heat_no = ugr.Cells["HEAT_NO"].Value.ToString();
  126. if (String.IsNullOrEmpty(this.textBox2.Text.Trim()) && String.IsNullOrEmpty(this.textBox3.Text.Trim()))
  127. {
  128. MessageBox.Show("成分信息不能为空!");
  129. return;
  130. }
  131. if (!IsNumberal(this.textBox2.Text.Trim()) && this.textBox2.Text.Trim() != "")
  132. {
  133. MessageBox.Show("请输入数字!");
  134. return;
  135. }
  136. if (!IsNumberal(this.textBox3.Text.Trim()) && this.textBox3.Text.Trim() != "")
  137. {
  138. MessageBox.Show("请输入数字!");
  139. return;
  140. }
  141. string new_heat_no = txt_heat_no.Text.Trim();
  142. string new_assay_no = txt_assay_no.Text.Trim();
  143. if (MessageBox.Show("是否确认修改化验号:" + assay_no + "的成分信息!", "提示", MessageBoxButtons.YesNo) == DialogResult.No) return;
  144. ArrayList list1 = new ArrayList();
  145. list1.Add(assay_no);
  146. list1.Add(this.textBox2.Text.Trim().ToString());
  147. list1.Add(this.textBox3.Text.Trim().ToString());
  148. list1.Add(this.UserInfo.GetUserName());
  149. list1.Add(heat_no);
  150. CoreClientParam ccp = new CoreClientParam();
  151. ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
  152. ccp.MethodName = "UpdateChemeInfo1";
  153. ccp.ServerParams = new object[] { list1 };
  154. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  155. if (ccp.ReturnCode == -1)
  156. {
  157. return;
  158. }
  159. DoQuery();
  160. MessageBox.Show("修改成功!");
  161. }
  162. catch (Exception EX)
  163. {
  164. MessageBox.Show(EX.ToString());
  165. }
  166. }
  167. private void DoQuery()
  168. {
  169. DoQueryMe();
  170. }
  171. //查询待判信息
  172. private void DoQueryMe()
  173. {
  174. try
  175. {
  176. this.dataSet3.Clear();
  177. string heatno = this.textBox1.Text.Trim();
  178. CoreClientParam ccp = new CoreClientParam();
  179. ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
  180. ccp.MethodName = "GetElement";
  181. ccp.SourceDataTable = this.dataSet3.Tables[0];
  182. ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), heatno};
  183. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  184. }
  185. catch (Exception ex)
  186. {
  187. System.Diagnostics.Debug.WriteLine(ex.ToString());
  188. MessageBox.Show("系统出错,请联系管理人员", "警告");
  189. }
  190. }
  191. private void QCM030803_Load(object sender, EventArgs e)
  192. {
  193. this.ultraGrid2.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons;
  194. this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-3);
  195. }
  196. private void DoExport()
  197. {
  198. try
  199. {
  200. if (this.ultraGrid2.Rows.Count == 0)
  201. {
  202. MessageBox.Show("没有可以导出的数据", "提示");
  203. return;
  204. }
  205. if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
  206. {
  207. string fName = this.saveFileDialog1.FileName;
  208. this.ultraGridExcelExporter1.Export(this.ultraGrid2, fName);
  209. Process.Start(fName);
  210. }
  211. }
  212. catch (Exception ex)
  213. {
  214. System.Diagnostics.Debug.WriteLine(ex.ToString());
  215. }
  216. }
  217. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  218. {
  219. UltraGridRow ugr = this.ultraGrid2.ActiveRow;
  220. if (ugr == null)
  221. return;
  222. txt_heat_no.Text = ugr.Cells["HEAT_NO"].Value.ToString();
  223. txt_assay_no.Text = ugr.Cells["ASSAY_NO"].Value.ToString();
  224. }
  225. }
  226. }