FrmScrapSteel.cs 52 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Text;
  7. using System.Windows.Forms;
  8. using CoreFS.CA06;
  9. using System.Threading;
  10. using System.Diagnostics;
  11. using System.IO;
  12. using Infragistics.Win.UltraWinGrid;
  13. using System.Collections;
  14. using Core.Mes.Client.Common;
  15. namespace Core.LgMes.Client.LgResMgt
  16. {
  17. public partial class FrmScrapSteel : Core.Mes.Client.Common.frmStyleBase
  18. {
  19. private System.Threading.Thread myThread_FG;
  20. private string _strSendSucceededForBof1 = "";
  21. private string _strSendSucceededForBof2 = "";
  22. private string _strSendSucceededForBof3 = "";
  23. public FrmScrapSteel()
  24. {
  25. InitializeComponent();
  26. CheckForIllegalCrossThreadCalls = false;
  27. }
  28. private void checkBox2_CheckedChanged(object sender, EventArgs e)
  29. {
  30. if (this.checkBox2.Checked == true)
  31. {
  32. this.udte_StartTime.Enabled = true;
  33. this.udte_EndTime.Enabled = true;
  34. }
  35. else
  36. {
  37. this.udte_StartTime.Enabled = false;
  38. this.udte_EndTime.Enabled = false;
  39. }
  40. }
  41. private void checkBox1_CheckedChanged(object sender, EventArgs e)
  42. {
  43. if (this.checkBox1.Checked == true)
  44. {
  45. this.ute_DH.Enabled = true;
  46. }
  47. else
  48. {
  49. this.ute_DH.Enabled = false;
  50. }
  51. }
  52. private void FrmScrapSteel_Load(object sender, EventArgs e)
  53. {
  54. label1.BackColor = Color.LightGreen;
  55. label3.BackColor = Color.LightCyan;
  56. label18.BackColor = Color.White;
  57. this.udte_StartTime.Text = System.DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd")+" 00:00:00";
  58. this.udte_EndTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd")+" 23:59:59";
  59. GetRLMX_Data();
  60. GetZL_SCJH();
  61. GetZL_Thread();
  62. this.utlcbdevNo.SelectedIndex = 3;
  63. cbb_FGZL.SelectedIndex = 0;
  64. }
  65. /// <summary>
  66. /// 获取转炉生产计划记录
  67. /// </summary>
  68. private void GetZL_SCJH()
  69. {
  70. try
  71. {
  72. string szOut = "",strWhere = "";
  73. int RowID_1 = 0, RowID_2 = 0, RowID_3 = 0;
  74. this.dataTable2.Rows.Clear();
  75. this.dataTable3.Rows.Clear();
  76. this.dataTable4.Rows.Clear();
  77. if (this.checkBox2.Checked == true)
  78. {
  79. strWhere = " and PLAN_MAKING_TIME between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') ";
  80. }
  81. else
  82. {
  83. //strWhere = " and a.aim_grade_code=b.steelcode and (heat_state='03' or heat_state='04') and PLAN_MAKING_TIME between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') ";
  84. strWhere = " and PLAN_MAKING_TIME between to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00','yyyy-MM-dd HH24:mi:ss') and to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd HH24:mi:ss')";
  85. }
  86. ArrayList arry = new ArrayList();
  87. ArrayList sqlList = new ArrayList();
  88. arry.Add("GetZL_SCJH.query");
  89. sqlList.Add(strWhere);
  90. CoreClientParam CCP_LgEts = new CoreClientParam();
  91. DataTable dt = new DataTable();
  92. CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  93. CCP_LgEts.MethodName = "doQuery";
  94. CCP_LgEts.ServerParams = new object[] { arry, sqlList };
  95. CCP_LgEts.SourceDataTable = dt;
  96. this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
  97. DataSet ds = new DataSet();
  98. ds.Tables.Add(dt);
  99. szOut = CCP_LgEts.ReturnInfo;
  100. //DataSet ds = null;// (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "GetZYJH_Data", new object[] { strWhere }, out szOut);
  101. if (szOut == "")
  102. {
  103. if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
  104. {
  105. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  106. {
  107. if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "1")
  108. {
  109. DataRow dr = this.dataTable2.NewRow();
  110. for (int j = 0; j < this.dataTable2.Columns.Count; j++)
  111. {
  112. dr[this.dataTable2.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable2.Columns[j].ColumnName.ToString()].ToString();
  113. }
  114. this.dataTable2.Rows.Add(dr);
  115. if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
  116. {
  117. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  118. {
  119. cell.Appearance.BackColor = Color.White;//计划状态
  120. }
  121. }
  122. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
  123. {
  124. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  125. cell.Appearance.BackColor = Color.LightGreen;//生产状态
  126. }
  127. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
  128. {
  129. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  130. cell.Appearance.BackColor = Color.LightCyan;//生产完成
  131. }
  132. RowID_1 += 1;
  133. }
  134. if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "2")
  135. {
  136. DataRow dr = this.dataTable3.NewRow();
  137. for (int j = 0; j < this.dataTable3.Columns.Count; j++)
  138. {
  139. dr[this.dataTable3.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable3.Columns[j].ColumnName.ToString()].ToString();
  140. }
  141. this.dataTable3.Rows.Add(dr);
  142. if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
  143. {
  144. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  145. {
  146. cell.Appearance.BackColor = Color.White;//计划状态
  147. }
  148. }
  149. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
  150. {
  151. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  152. cell.Appearance.BackColor = Color.LightGreen;//生产状态
  153. }
  154. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
  155. {
  156. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  157. cell.Appearance.BackColor = Color.LightCyan;//生产状态
  158. }
  159. RowID_2 += 1;
  160. }
  161. if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "3")
  162. {
  163. DataRow dr = this.dataTable4.NewRow();
  164. for (int j = 0; j < this.dataTable4.Columns.Count; j++)
  165. {
  166. dr[this.dataTable4.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable4.Columns[j].ColumnName.ToString()].ToString();
  167. }
  168. this.dataTable4.Rows.Add(dr);
  169. if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
  170. {
  171. foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
  172. {
  173. cell.Appearance.BackColor = Color.White;//计划状态
  174. }
  175. }
  176. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
  177. {
  178. foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
  179. cell.Appearance.BackColor = Color.LightGreen;//计划状态
  180. }
  181. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
  182. {
  183. foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
  184. cell.Appearance.BackColor = Color.LightCyan;//生成完成
  185. }
  186. RowID_3 += 1;
  187. }
  188. }
  189. }
  190. }
  191. }
  192. catch (Exception ex)
  193. {
  194. MessageBox.Show(ex.Message);
  195. }
  196. }
  197. /// <summary>
  198. /// 打开窗体时自动取入炉明细数据
  199. /// </summary>
  200. private void GetRLMX_Data()
  201. {
  202. try
  203. {
  204. this.dataTable1.Rows.Clear();
  205. string szOut = "", strWhere = "";
  206. if (this.checkBox2.Checked == true)
  207. {
  208. strWhere = " where JOBDATE between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') ";
  209. }
  210. else
  211. {
  212. strWhere = " where JOBDATE between to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00','yyyy-MM-dd HH24:mi:ss') and to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd HH24:mi:ss')";
  213. }
  214. if (this.checkBox1.Checked == true)
  215. {
  216. strWhere += " and CHARGENO = '" + ute_DH.Text.ToString().Trim() + "' ";
  217. }
  218. ArrayList arry = new ArrayList();
  219. ArrayList sqlList = new ArrayList();
  220. arry.Add("GetRLMX_Data.query");
  221. sqlList.Add(strWhere);
  222. CoreClientParam CCP_LgEts = new CoreClientParam();
  223. DataTable dt = new DataTable();
  224. CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  225. CCP_LgEts.MethodName = "doQuery";
  226. CCP_LgEts.ServerParams = new object[] { arry, sqlList };
  227. CCP_LgEts.SourceDataTable = dt;
  228. this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
  229. DataSet ds = new DataSet();
  230. ds.Tables.Add(dt);
  231. szOut = CCP_LgEts.ReturnInfo;
  232. //DataSet ds = null;// (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "GetRLMX_Data", new object[] { strWhere }, out szOut);
  233. if (szOut == "")
  234. {
  235. if (ds.Tables[0].Rows.Count > 0)
  236. {
  237. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  238. {
  239. DataRow dr = this.dataTable1.NewRow();
  240. for (int j = 0; j < this.dataTable1.Columns.Count; j++)
  241. {
  242. if (dataTable1.Columns[j].ColumnName == "BC")
  243. {
  244. string v_BC = "";
  245. if (ds.Tables[0].Rows[i]["BC"].ToString().Length > 1)
  246. v_BC = ds.Tables[0].Rows[i]["BC"].ToString().Trim().Substring(1, 1);
  247. if (v_BC == "1")
  248. dr[dataTable1.Columns[j].ColumnName] = "甲班";
  249. if (v_BC == "2")
  250. dr[dataTable1.Columns[j].ColumnName] = "乙班";
  251. if (v_BC == "3")
  252. dr[dataTable1.Columns[j].ColumnName] = "丙班";
  253. if (v_BC == "4")
  254. dr[dataTable1.Columns[j].ColumnName] = "丁班";
  255. }
  256. else if (dataTable1.Columns[j].ColumnName == "ZYSJ")
  257. {
  258. dr["ZYSJ"] = Convert.ToDateTime(ds.Tables[0].Rows[i]["ZYSJ"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
  259. }
  260. else
  261. {
  262. if (ds.Tables[0].Columns.Contains(dataTable1.Columns[j].ColumnName) && !string.IsNullOrEmpty(ds.Tables[0].Rows[i][dataTable1.Columns[j].ColumnName].ToString()))
  263. dr[dataTable1.Columns[j].ColumnName] = ds.Tables[0].Rows[i][dataTable1.Columns[j].ColumnName].ToString();
  264. }
  265. }
  266. this.dataTable1.Rows.Add(dr);
  267. }
  268. this.dataTable1.AcceptChanges();
  269. SetSteelSum();
  270. }
  271. }
  272. }
  273. catch (Exception ex)
  274. {
  275. MessageBox.Show(ex.Message);
  276. }
  277. }
  278. /// <summary>
  279. /// 统计废钢重量
  280. /// </summary>
  281. private void SetSteelSum()
  282. {
  283. UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[0];
  284. band.Summaries.Clear();
  285. SummarySettings summary = band.Summaries.Add(SummaryType.Count, band.Columns[1]);
  286. summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
  287. summary.DisplayFormat = "合计:";
  288. for (int i = 7; i < 14; i++)
  289. {
  290. summary = band.Summaries.Add(SummaryType.Sum, band.Columns[i]);
  291. summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
  292. summary.DisplayFormat = " {0:#####.00}";
  293. summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
  294. summary.Appearance.ForeColor = Color.DarkBlue;
  295. summary.Appearance.BackColor = Color.White;
  296. }
  297. band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
  298. }
  299. /// <summary>
  300. /// 菜单栏
  301. /// </summary>
  302. /// <param name="sender"></param>
  303. /// <param name="ToolbarKey"></param>
  304. public override void ToolBar_Click(object sender, string ToolbarKey)
  305. {
  306. base.ToolBar_Click(sender, ToolbarKey);
  307. switch (ToolbarKey)
  308. {
  309. case "Add"://新增
  310. try
  311. {
  312. ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  313. }
  314. catch
  315. {
  316. return;
  317. }
  318. AddNewData();
  319. GetRLMX_Data();
  320. break;
  321. case "Update"://修改
  322. if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(ultNo.Text.Trim()))
  323. {
  324. DialogResult result;
  325. string mk = "确实要修改吗?";
  326. result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo,
  327. MessageBoxIcon.Question);
  328. if (result == DialogResult.Yes)
  329. {
  330. if (ultraGrid1.ActiveRow != null)
  331. {
  332. try
  333. {
  334. DateTime aa = Convert.ToDateTime(ute_RLSJ.Text.ToString());
  335. string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim();
  336. UpdateDataRow(strXH);
  337. GetRLMX_Data();
  338. }
  339. catch
  340. {
  341. MessageBox.Show("入炉时间 不是合法的日期时间!\n\n请重新选择入炉时间!", "提示");
  342. }
  343. }
  344. else
  345. {
  346. MessageBox.Show("请选择需要修改的记录!", "提示");
  347. }
  348. }
  349. }
  350. else
  351. MessageBox.Show("请选择需要修改的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  352. break;
  353. case "Delete"://删除
  354. if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(this.ultNo.Text.Trim()))
  355. {
  356. DialogResult result;
  357. string mk = "确实要删除吗?";
  358. result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo,
  359. MessageBoxIcon.Question);
  360. if (result == DialogResult.Yes)
  361. {
  362. string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim();
  363. DeleteDataRow(strXH);
  364. GetRLMX_Data();
  365. }
  366. }
  367. else
  368. {
  369. MessageBox.Show("请选择要删除的行!", "提示");
  370. }
  371. break;
  372. case "Query":// 查询
  373. GetRLMX_Data();
  374. GetZL_SCJH();
  375. break;
  376. case "Export"://导Excel
  377. try
  378. {
  379. if (ultraTabControl1.SelectedTab.Text.Trim() != "入炉明细") return;
  380. if (ultraGrid1.ActiveRow != null)
  381. {
  382. string StrfileName = string.Format(System.Windows.Forms.Application.StartupPath + "\\Report\\{0}.xls", "废钢配斗信息");
  383. this.ultraGridExcelExporter1.Export(this.ultraGrid1, StrfileName);
  384. ProcessStartInfo p = new ProcessStartInfo(StrfileName);
  385. p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
  386. Process.Start(p);
  387. }
  388. else
  389. {
  390. MessageBox.Show("入炉明细信息不能为空!", "提示");
  391. return;
  392. }
  393. }
  394. catch (Exception ex)
  395. {
  396. MessageBox.Show(ex.Message);
  397. }
  398. break;
  399. case "Exit":
  400. this.Close();
  401. break;
  402. default:
  403. break;
  404. }
  405. }
  406. /// <summary>
  407. /// 新增记录
  408. /// </summary>
  409. private void AddNewData()
  410. {
  411. try
  412. {
  413. if (ute_DH2.Text.Trim().Length == 0)
  414. {
  415. MessageBox.Show("溜槽号不能为空,请输入溜槽号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  416. return;
  417. }
  418. if (ute_ZZ.Text.Trim().Length == 0)
  419. {
  420. MessageBox.Show("没有废钢信息,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  421. return;
  422. }
  423. string strErr = "";
  424. string m_szCurrClass = "";
  425. ArrayList arry = new ArrayList();
  426. arry.Add("GetClassCode.query");
  427. CommonClientToServer ccs = new CommonClientToServer();
  428. ccs.ob = this.ob;
  429. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  430. if (ds.Tables[0].Rows.Count > 0)
  431. {
  432. m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
  433. }
  434. string[] ArrayCZXX = new string[21] { "", "", "", "", "", "", "", "", "", "", "", "", "","","","","","","","",""}; //保存信息
  435. ArrayCZXX[0] = ute_DH2.Text.Trim();
  436. ArrayCZXX[1] = ute_STZL.Text.Trim();
  437. ArrayCZXX[2] = ute_RLZL.Text.Trim();
  438. ArrayCZXX[3] = ute_LH.Text.Trim();
  439. ArrayCZXX[4] = ute_CLZ.Text.Trim();
  440. ArrayCZXX[5] = ute_ZZ.Text.Trim();
  441. int v_BC = this.cbb_BC.SelectedIndex + 1;
  442. //ArrayCZXX[6] = Core.LgMes.Client.LgResMgt.StaticFunction.GetClassCode() + Convert.ToString(v_BC); //班次
  443. ArrayCZXX[6] = m_szCurrClass; //班次
  444. ArrayCZXX[7] = ute_HGLZ.Text.Trim();
  445. ArrayCZXX[8] = ute_DZ.Text.Trim();
  446. ArrayCZXX[9] = cbb_FGZL.Text.Trim();
  447. ArrayCZXX[10] = ute_ZGZL.Text.Trim();
  448. ArrayCZXX[11] = Convert.ToDateTime(ute_RLSJ.Text.Trim().ToString()).ToString("yyyy-MM-dd HH:mm:ss");
  449. ArrayCZXX[12] = ute_BZ.Text.Trim();
  450. ArrayCZXX[13] = this.UserInfo.GetUserName();
  451. if (this.utlcbdevNo.SelectedItem != null)
  452. ArrayCZXX[14] = this.utlcbdevNo.SelectedItem.DataValue.ToString();
  453. else
  454. ArrayCZXX[14] = "";
  455. ArrayCZXX[15] = ute_C.Text.Trim();
  456. ArrayCZXX[16] = ute_Si.Text.Trim();
  457. ArrayCZXX[17] = ute_Mn.Text.Trim();
  458. ArrayCZXX[18] = ute_P.Text.Trim();
  459. ArrayCZXX[19] = ute_S.Text.Trim();
  460. ArrayCZXX[20] = ute_As.Text.Trim();
  461. string strError = "";
  462. string SQLid="AddNewData.Add";
  463. //if (ute_LH.Text.Trim().Length > 0)
  464. //{
  465. Cursor oldCursor = this.Cursor;
  466. this.Cursor = Cursors.WaitCursor;//等待光标
  467. try
  468. {
  469. CoreClientParam ccp = new CoreClientParam();
  470. ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
  471. ccp.MethodName = "procedure_A";
  472. ccp.ServerParams = new object[] { "res_lg_lfsmanage.InsertFG ", ArrayCZXX };
  473. ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  474. strError = ccp.ReturnInfo;
  475. if (strError != "")
  476. {
  477. this.Cursor = oldCursor;
  478. MessageBox.Show("新增不成功,查看输入的熔炼号废钢是否已添加!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  479. return;
  480. }
  481. else
  482. {
  483. MessageBox.Show(" 废钢新增成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  484. this.Cursor = oldCursor;
  485. }
  486. }
  487. catch (System.Exception exp)
  488. {
  489. this.Cursor = oldCursor;
  490. MessageBox.Show("新增不成功!\n" + exp.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  491. }
  492. //}
  493. }
  494. catch(Exception ex)
  495. {
  496. MessageBox.Show(ex.Message);
  497. }
  498. }
  499. /// <summary>
  500. /// 删除记录
  501. /// </summary>
  502. private void DeleteDataRow(string strXH)
  503. {
  504. try
  505. {
  506. string szOut = "";
  507. string[] strParams = new string[1] { strXH };
  508. CoreClientParam ccp = new CoreClientParam();
  509. ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
  510. ccp.MethodName = "procedure_A";
  511. ccp.ServerParams = new object[] { "RES_LG_LFSMANAGE.DeleteFG", strParams };
  512. ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  513. szOut = ccp.ReturnInfo;
  514. if (szOut != "")
  515. {
  516. MessageBox.Show(szOut, "删除失败!");
  517. }
  518. else
  519. {
  520. MessageBox.Show("废钢信息删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  521. ClearData();//清除控件内容
  522. }
  523. }
  524. catch(Exception ex)
  525. {
  526. MessageBox.Show(ex.Message);
  527. }
  528. }
  529. /// <summary>
  530. /// 清除内容
  531. /// </summary>
  532. private void ClearData()
  533. {
  534. ute_DH2.Text = "";
  535. ute_STZL.Text = "";
  536. ute_RLZL.Text = "";
  537. ute_LH.Text = "";
  538. ute_CLZ.Text = "";
  539. ute_ZZ.Text = "";
  540. cbb_BC.Text = "";
  541. ute_HGLZ.Text = "";
  542. ute_DZ.Text = "";
  543. cbb_FGZL.Text = "";
  544. ute_ZGZL.Text = "";
  545. ute_RLSJ.Text = "";
  546. ute_BZ.Text = "";
  547. ute_C.Text = "";
  548. ute_Si.Text = "";
  549. ute_Mn.Text = "";
  550. ute_P.Text = "";
  551. ute_S.Text = "";
  552. ute_As.Text = "";
  553. }
  554. private void ultraGrid1_Click(object sender, EventArgs e)
  555. {
  556. if (this.ultraGrid1.ActiveRow != null)
  557. {
  558. #region 先清除控件内的信息
  559. ClearData();
  560. #endregion
  561. #region 选中ultragrid中一行时,自动将对应的值赋给下面的控件
  562. ute_DH2.Text = this.ultraGrid1.ActiveRow.Cells["ZDDH"].Value.ToString();
  563. ute_STZL.Text = this.ultraGrid1.ActiveRow.Cells["STZL"].Value.ToString();
  564. ute_RLZL.Text = this.ultraGrid1.ActiveRow.Cells["RLZL"].Value.ToString();
  565. ute_LH.Text = this.ultraGrid1.ActiveRow.Cells["LH"].Value.ToString();
  566. ute_CLZ.Text = this.ultraGrid1.ActiveRow.Cells["CLZL"].Value.ToString();
  567. ute_ZZ.Text = this.ultraGrid1.ActiveRow.Cells["ZZ"].Value.ToString();
  568. cbb_BC.Text = this.ultraGrid1.ActiveRow.Cells["BC"].Value.ToString();
  569. ute_HGLZ.Text = this.ultraGrid1.ActiveRow.Cells["HGZL"].Value.ToString();
  570. ute_DZ.Text = this.ultraGrid1.ActiveRow.Cells["DZ"].Value.ToString();
  571. cbb_FGZL.Text = this.ultraGrid1.ActiveRow.Cells["FGZL"].Value.ToString();
  572. ute_ZGZL.Text = this.ultraGrid1.ActiveRow.Cells["ZGZL"].Value.ToString();
  573. ute_RLSJ.Text = Convert.ToDateTime(this.ultraGrid1.ActiveRow.Cells["ZYSJ"].Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
  574. ute_BZ.Text = this.ultraGrid1.ActiveRow.Cells["BZ"].Value.ToString();
  575. ultNo.Text = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString();
  576. if (!string.IsNullOrEmpty(this.ultraGrid1.ActiveRow.Cells["GWBH"].Value.ToString()))
  577. utlcbdevNo.Text = this.ultraGrid1.ActiveRow.Cells["GWBH"].Value.ToString();
  578. ute_C.Text = this.ultraGrid1.ActiveRow.Cells["C"].Value.ToString();
  579. ute_Mn.Text = this.ultraGrid1.ActiveRow.Cells["Mn"].Value.ToString();
  580. ute_P.Text = this.ultraGrid1.ActiveRow.Cells["P"].Value.ToString();
  581. ute_S.Text = this.ultraGrid1.ActiveRow.Cells["S"].Value.ToString();
  582. ute_As.Text = this.ultraGrid1.ActiveRow.Cells["Asn"].Value.ToString();
  583. #endregion
  584. }
  585. }
  586. /// <summary>
  587. /// 修改废钢配斗记录
  588. /// </summary>
  589. /// <param name="strXH"></param>
  590. private void UpdateDataRow(string strXH)
  591. {
  592. try
  593. {
  594. string[] ArrayCZXX = new string[22] { "","", "", "", "", "", "", "", "", "", "", "", "", "", "" ,"","","","","","",""}; //保存信息
  595. string strErr = "";
  596. string m_szCurrClass = "";
  597. ArrayList arry = new ArrayList();
  598. arry.Add("GetClassCode.query");
  599. CommonClientToServer ccs = new CommonClientToServer();
  600. ccs.ob = this.ob;
  601. //arry.Add("");
  602. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  603. if (ds.Tables[0].Rows.Count > 0)
  604. {
  605. m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString();
  606. }
  607. ArrayCZXX[0] = ute_DH2.Text.Trim();
  608. ArrayCZXX[1] = ute_STZL.Text.Trim();
  609. ArrayCZXX[2] = ute_RLZL.Text.Trim();
  610. ArrayCZXX[3] = ute_LH.Text.Trim();
  611. ArrayCZXX[4] = ute_CLZ.Text.Trim();
  612. ArrayCZXX[5] = ute_ZZ.Text.Trim();
  613. ArrayCZXX[6] = m_szCurrClass;
  614. ArrayCZXX[7] = ute_HGLZ.Text.Trim();
  615. ArrayCZXX[8] = ute_DZ.Text.Trim();
  616. ArrayCZXX[9] = cbb_FGZL.Text.Trim();
  617. ArrayCZXX[10] = ute_ZGZL.Text.Trim();
  618. ArrayCZXX[11] = ute_RLSJ.Text.Trim();
  619. ArrayCZXX[12] = ute_BZ.Text.Trim();
  620. ArrayCZXX[13] = this.UserInfo.GetUserName();
  621. ArrayCZXX[14] = strXH.ToString().Trim();
  622. if (this.utlcbdevNo.SelectedItem != null)
  623. ArrayCZXX[15] = this.utlcbdevNo.SelectedItem.DataValue.ToString();
  624. else
  625. ArrayCZXX[15] = "";
  626. ArrayCZXX[16] = ute_C.Text.Trim();
  627. ArrayCZXX[17] = ute_Si.Text.Trim();
  628. ArrayCZXX[18] = ute_Mn.Text.Trim();
  629. ArrayCZXX[19] = ute_P.Text.Trim();
  630. ArrayCZXX[20] = ute_S.Text.Trim();
  631. ArrayCZXX[21] = ute_As.Text.Trim();
  632. Cursor oldCursor = this.Cursor;
  633. this.Cursor = Cursors.WaitCursor;//等待光标
  634. try
  635. {
  636. string strError = "";
  637. CoreClientParam ccp = new CoreClientParam();
  638. ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
  639. ccp.MethodName = "procedure_A";
  640. ccp.ServerParams = new object[] { "RES_LG_LFSMANAGE.UpdateFG", ArrayCZXX };
  641. ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  642. strError = ccp.ReturnInfo;
  643. if (strError != "")
  644. {
  645. this.Cursor = oldCursor;
  646. MessageBox.Show("保存不成功!\n" + strError, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  647. return;
  648. }
  649. else
  650. {
  651. this.Cursor = oldCursor;
  652. }
  653. }
  654. catch (System.Exception exp)
  655. {
  656. this.Cursor = oldCursor;
  657. MessageBox.Show("保存不成功!\n" + exp.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  658. }
  659. }
  660. catch (Exception ex)
  661. {
  662. MessageBox.Show(ex.Message);
  663. }
  664. }
  665. //<summary>
  666. //实时刷新当前转炉正在冶炼的熔炼号
  667. //</summary>
  668. private void GetZL_Thread()
  669. {
  670. try
  671. {
  672. myThread_FG = new Thread(new ThreadStart(getZLCurrentLH));
  673. myThread_FG.Priority = ThreadPriority.Normal;
  674. myThread_FG.Start();
  675. }
  676. catch (Exception ex)
  677. {
  678. MessageBox.Show(ex.Message);
  679. }
  680. }
  681. /// <summary>
  682. /// 取当前转炉正在冶炼熔炼号 CVT01_DEVICE
  683. /// </summary>
  684. private void getZLCurrentLH()
  685. {
  686. try
  687. {
  688. System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false;
  689. while (true)
  690. {
  691. if (!this.On_Off_Thread)
  692. {
  693. System.Threading.Thread.Sleep(500);
  694. continue;
  695. }
  696. this.ute_ZL1.Text = "";
  697. this.ute_ZL2.Text = "";
  698. this.ute_ZL3.Text = "";
  699. //初始化颜色
  700. ute_ZL1.Appearance.BackColor = Color.White;//.Gainsboro;
  701. ute_ZL2.Appearance.BackColor = Color.White;
  702. ute_ZL3.Appearance.BackColor = Color.White;
  703. string strError = "";
  704. ArrayList arry = new ArrayList();
  705. arry.Clear();
  706. arry.Add("getZLCurrentLH.query");
  707. CommonClientToServer ccs = new CommonClientToServer();
  708. ccs.ob = this.ob;
  709. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strError);
  710. if (strError == "")
  711. {
  712. if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
  713. {
  714. //初始化颜色
  715. ute_ZL1.Appearance.BackColor = Color.White;
  716. ute_ZL2.Appearance.BackColor = Color.White;
  717. ute_ZL3.Appearance.BackColor = Color.White;
  718. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  719. {
  720. string v_ZLH = ds.Tables[0].Rows[i]["objectpos"].ToString().Substring(3, 2);
  721. string v_LH = (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(5, ds.Tables[0].Rows[i]["objectid"].ToString().Length - 5));
  722. if (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(0, 1) == "V") v_LH = "V" + v_LH;
  723. if (v_ZLH == "01")
  724. {
  725. this.ute_ZL1.Text = v_LH;
  726. if (_strSendSucceededForBof1 == "N") ute_ZL1.Appearance.BackColor = Color.White;
  727. if (_strSendSucceededForBof1 == "" || _strSendSucceededForBof1 == "N") HeatNo_HudwId_Exist(v_LH,"01");
  728. if (_strSendSucceededForBof1 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue;
  729. }
  730. if (v_ZLH == "02")
  731. {
  732. this.ute_ZL2.Text = v_LH;
  733. if (_strSendSucceededForBof2 == "N") ute_ZL2.Appearance.BackColor = Color.White;
  734. if (_strSendSucceededForBof2 == "" || _strSendSucceededForBof2 == "N") HeatNo_HudwId_Exist(v_LH,"02");
  735. if (_strSendSucceededForBof2 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue;
  736. }
  737. if (v_ZLH == "03")
  738. {
  739. this.ute_ZL3.Text = v_LH;
  740. if (_strSendSucceededForBof3 == "N") ute_ZL3.Appearance.BackColor = Color.White;
  741. if (_strSendSucceededForBof3 == "" || _strSendSucceededForBof3 == "N") HeatNo_HudwId_Exist(v_LH,"03");
  742. if (_strSendSucceededForBof3 == "Y") ute_ZL3.Appearance.BackColor = Color.LightBlue;
  743. }
  744. }
  745. }
  746. if (ute_ZL1.Text.Trim().Length == 0) _strSendSucceededForBof1 = "N";
  747. if (ute_ZL2.Text.Trim().Length == 0) _strSendSucceededForBof2 = "N";
  748. if (ute_ZL3.Text.Trim().Length == 0) _strSendSucceededForBof3 = "N";
  749. }
  750. Thread.Sleep(10000);
  751. }
  752. }
  753. catch
  754. {
  755. }
  756. }
  757. private void ute_RLSJ_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  758. {
  759. FrmSetTime frm = new FrmSetTime(null);
  760. frm.Location = StaticFunction.GetChildWindowLocation(frm.Size);
  761. frm.AutoSize = true;
  762. if (frm.ShowDialog() == DialogResult.OK)
  763. { }
  764. if(Convert.ToString(frm._returnTime).Substring(0,8)!="2000-1-1")
  765. ute_RLSJ.Text = Convert.ToDateTime(frm._returnTime).ToString("yyyy-MM-dd HH:mm:ss");
  766. }
  767. /// <summary>
  768. /// 发送废钢到1#转炉
  769. /// </summary>
  770. /// <param name="sender"></param>
  771. /// <param name="e"></param>
  772. private void button1_Click(object sender, EventArgs e)
  773. {
  774. try
  775. {
  776. this.ultraGrid1.DisplayLayout.Bands[0].Override.WrapHeaderText = Infragistics.Win.DefaultableBoolean.True;
  777. string v_LH = this.ute_ZL1.Text.Trim().ToString();
  778. if (v_LH.Length == 0)
  779. {
  780. MessageBox.Show("1#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
  781. return;
  782. }
  783. string v_FGZL = this.ute_RLZL.Text.Trim().ToString();
  784. string v_STZL = this.ute_STZL.Text.Trim().ToString();
  785. string v_ZLH = "01";
  786. string szOut = "";
  787. string v_XH = this.ultNo.Text.Trim();
  788. string[] strParams = new string[7] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH,"",""};
  789. if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim()) )
  790. {
  791. CoreClientParam ccp = new CoreClientParam();
  792. ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
  793. ccp.MethodName = "procedure_A";
  794. ccp.ServerParams = new object[] { "res_lg_lfsmanage.SendFG_ZL ", strParams };
  795. ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  796. szOut = ccp.ReturnInfo;
  797. if (szOut != "")
  798. {
  799. MessageBox.Show(szOut);
  800. }
  801. else
  802. {
  803. GetRLMX_Data();
  804. _strSendSucceededForBof1 = "Y";
  805. MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  806. }
  807. }
  808. else
  809. MessageBox.Show("序号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  810. }
  811. catch (Exception ex)
  812. {
  813. MessageBox.Show(ex.Message);
  814. }
  815. }
  816. /// <summary>
  817. /// 发送废钢到2#转炉
  818. /// </summary>
  819. /// <param name="sender"></param>
  820. /// <param name="e"></param>
  821. private void button2_Click(object sender, EventArgs e)
  822. {
  823. try
  824. {
  825. string v_LH = this.ute_ZL2.Text.Trim().ToString();
  826. if (v_LH.Length == 0)
  827. {
  828. MessageBox.Show("2#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  829. return;
  830. }
  831. string v_FGZL = this.ute_RLZL.Text.Trim().ToString();
  832. string v_STZL = this.ute_STZL.Text.Trim().ToString();
  833. string v_ZLH = "02";
  834. string szOut = "";
  835. string v_XH = this.ultNo.Text.Trim();
  836. string[] strParams = new string[7] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH, "", "" };
  837. if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim()))
  838. {
  839. CoreClientParam ccp = new CoreClientParam();
  840. ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
  841. ccp.MethodName = "procedure_A";
  842. ccp.ServerParams = new object[] { "res_lg_lfsmanage.SendFG_ZL ", strParams };
  843. ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  844. szOut = ccp.ReturnInfo;
  845. if (szOut != "")
  846. {
  847. MessageBox.Show(szOut);
  848. }
  849. else
  850. {
  851. GetRLMX_Data();
  852. _strSendSucceededForBof2 = "Y";
  853. MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  854. }
  855. }
  856. else
  857. MessageBox.Show("熔炼号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  858. }
  859. catch (Exception ex)
  860. {
  861. MessageBox.Show(ex.Message);
  862. }
  863. }
  864. /// <summary>
  865. /// 发送废钢到3#转炉
  866. /// </summary>
  867. /// <param name="sender"></param>
  868. /// <param name="e"></param>
  869. private void button3_Click(object sender, EventArgs e)
  870. {
  871. try
  872. {
  873. string v_LH = this.ute_ZL3.Text.Trim().ToString();
  874. if (v_LH.Length == 0)
  875. {
  876. MessageBox.Show("3#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  877. return;
  878. }
  879. string v_FGZL = this.ute_RLZL.Text.Trim().ToString();
  880. string v_STZL = this.ute_STZL.Text.Trim().ToString();
  881. string v_ZLH = "3";
  882. string szOut = "";
  883. string v_XH = this.ultNo.Text.Trim();
  884. if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim()))
  885. {
  886. //hengxing Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "SendZL1_FG", new object[] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH }, out szOut);
  887. if (szOut != "")
  888. {
  889. MessageBox.Show(szOut);
  890. }
  891. else
  892. {
  893. GetRLMX_Data();
  894. _strSendSucceededForBof3 = "Y";
  895. MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  896. }
  897. }
  898. else
  899. MessageBox.Show("熔炼号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  900. }
  901. catch (Exception ex)
  902. {
  903. MessageBox.Show(ex.Message);
  904. }
  905. }
  906. private void ute_CLZ_KeyPress(object sender, KeyPressEventArgs e)
  907. {
  908. if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '\b' || e.KeyChar == '-'))
  909. {
  910. e.Handled = true;
  911. }
  912. }
  913. private void ultraGrid2_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
  914. {
  915. }
  916. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  917. {
  918. if (e.Tab.Index == 1)
  919. GetZL_SCJH();
  920. }
  921. private void ultraGrid3_Click(object sender, EventArgs e)
  922. {
  923. DialogResult dgr = new DialogResult();
  924. if (ultraGrid3.ActiveRow != null)
  925. {
  926. ute_LH.Text = ultraGrid3.ActiveRow.Cells["StoveID"].Value.ToString();
  927. utlcbdevNo.SelectedIndex = 1;
  928. string ShiftCode = "", str = "";
  929. if (dgr != DialogResult.Cancel)
  930. {
  931. //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
  932. ArrayList arry = new ArrayList();
  933. arry.Add("GetClassCode.query");
  934. CommonClientToServer ccs = new CommonClientToServer();
  935. ccs.ob = this.ob;
  936. //arry.Add("");
  937. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
  938. if (ds.Tables[0].Rows.Count > 0)
  939. {
  940. ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
  941. }
  942. if (!string.IsNullOrEmpty(ShiftCode))
  943. {
  944. cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
  945. }
  946. }
  947. }
  948. }
  949. private void ultraGrid2_Click(object sender, EventArgs e)
  950. {
  951. DialogResult dgr = new DialogResult();
  952. if (ultraGrid2.ActiveRow != null)
  953. {
  954. ute_LH.Text = ultraGrid2.ActiveRow.Cells["StoveID"].Value.ToString();
  955. utlcbdevNo.SelectedIndex = 0;
  956. string ShiftCode = "", str = "";
  957. if (dgr != DialogResult.Cancel)
  958. {
  959. //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
  960. ArrayList arry = new ArrayList();
  961. arry.Add("GetClassCode.query");
  962. CommonClientToServer ccs = new CommonClientToServer();
  963. ccs.ob = this.ob;
  964. //arry.Add("");
  965. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
  966. if (ds.Tables[0].Rows.Count > 0)
  967. {
  968. ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
  969. }
  970. if (!string.IsNullOrEmpty(ShiftCode))
  971. {
  972. cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
  973. }
  974. }
  975. }
  976. }
  977. private void ultraGrid4_Click(object sender, EventArgs e)
  978. {
  979. DialogResult dgr = new DialogResult();
  980. if (ultraGrid4.ActiveRow != null)
  981. {
  982. ute_LH.Text = ultraGrid4.ActiveRow.Cells["StoveID"].Value.ToString();
  983. utlcbdevNo.SelectedIndex = 2;
  984. string ShiftCode = "", str = "";
  985. if (dgr != DialogResult.Cancel)
  986. {
  987. //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
  988. ArrayList arry = new ArrayList();
  989. arry.Add("GetClassCode.query");
  990. CommonClientToServer ccs = new CommonClientToServer();
  991. ccs.ob = this.ob;
  992. //arry.Add("");
  993. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
  994. if (ds.Tables[0].Rows.Count > 0)
  995. {
  996. ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
  997. }
  998. if (!string.IsNullOrEmpty(ShiftCode))
  999. {
  1000. cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
  1001. }
  1002. }
  1003. }
  1004. }
  1005. private void ute_RLSJ_KeyPress(object sender, KeyPressEventArgs e)
  1006. {
  1007. if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '\b'))
  1008. {
  1009. e.Handled = true;
  1010. }
  1011. }
  1012. private void ute_RLZL_ValueChanged(object sender, EventArgs e)
  1013. {
  1014. Double dRlzl = 0, dDz = 0, dStzl = 0, dZlz = 0, dHgzl = 0, dZgzl = 0; //入炉重量,斗重,生铁重量,重料重,合格料重,渣钢重量
  1015. try
  1016. {
  1017. //生铁重量
  1018. if (!string.IsNullOrEmpty(ute_STZL.Text.Trim()))
  1019. dStzl = Convert.ToDouble(ute_STZL.Text.Trim());
  1020. //重料重
  1021. if (!string.IsNullOrEmpty(ute_CLZ.Text.Trim()))
  1022. dZlz = Convert.ToDouble(ute_CLZ.Text.Trim());
  1023. //合格料重
  1024. if (!string.IsNullOrEmpty(ute_HGLZ.Text.Trim()))
  1025. dHgzl = Convert.ToDouble(ute_HGLZ.Text.Trim());
  1026. //渣钢重量
  1027. if (!string.IsNullOrEmpty(ute_ZGZL.Text.Trim()))
  1028. dZgzl = Convert.ToDouble(ute_ZGZL.Text.Trim());
  1029. //斗重
  1030. if (!string.IsNullOrEmpty(ute_DZ.Text.Trim()))
  1031. dDz = Convert.ToDouble(ute_DZ.Text.Trim());
  1032. dRlzl = dStzl + dZlz + dHgzl + dZgzl;//入炉重量
  1033. ute_RLZL.Text = Convert.ToString(dRlzl); //入炉重量
  1034. ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量
  1035. }
  1036. catch
  1037. {
  1038. }
  1039. }
  1040. /// <summary>
  1041. /// 判断是否已经发送废钢
  1042. /// </summary>
  1043. /// <熔炼号="strID"></param>
  1044. /// <炉座号="strGw"></param>
  1045. private void HeatNo_HudwId_Exist(string strID, string strGw)
  1046. {
  1047. string strErr = "";
  1048. try
  1049. {
  1050. ArrayList arry = new ArrayList();
  1051. arry.Add("HeatNo_HudwId_Exist.query");
  1052. CommonClientToServer ccs = new CommonClientToServer();
  1053. ccs.ob = this.ob;
  1054. arry.Add(strID);
  1055. arry.Add(strID);
  1056. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  1057. if (strErr == "")
  1058. {
  1059. switch (strGw)
  1060. {
  1061. case "01":
  1062. _strSendSucceededForBof1 = ds.Tables[0].Rows[0]["intCount"].ToString();
  1063. break;
  1064. case "02":
  1065. _strSendSucceededForBof2 = ds.Tables[0].Rows[0]["intCount"].ToString();
  1066. break;
  1067. case "03":
  1068. _strSendSucceededForBof3 = ds.Tables[0].Rows[0]["intCount"].ToString();
  1069. break;
  1070. default:
  1071. break;
  1072. }
  1073. }
  1074. }
  1075. catch
  1076. {
  1077. }
  1078. }
  1079. }
  1080. }