FrmTappingHole.cs 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807
  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 Core.Mes.ClientFrameWork;
  9. using System.Collections;
  10. using Infragistics.Win;
  11. using Infragistics.Win.UltraWinGrid;
  12. using Infragistics.Win.UltraWinGrid.ExcelExport;
  13. using System.IO;
  14. using System.Diagnostics;
  15. using System.Threading;
  16. using Core.Mes.IBaseInterface;
  17. using CoreFS.CA06;
  18. using Core.Mes.Client.Common;
  19. namespace Core.LgMes.Client.LgDeviceManager
  20. {
  21. public partial class FrmTappingHole :frmStyleBase
  22. {
  23. private ValueList vlstShift, vlstShiftClone;
  24. private string strCurrID = ""; //保存当前选中转炉炉座
  25. private bool bSelected = false;
  26. private bool bRefreshNow = false;
  27. private Color clrWarn = Color.Red; //警告颜色
  28. private bool bBold = false; //
  29. private Thread _getDataThread;
  30. private Thread _setDataThread;
  31. private bool _bIfGetData = true;
  32. private bool _bIfSetData = true;
  33. private delegate void GetDataOperate();
  34. private delegate void SetDataOperate();
  35. public FrmTappingHole()
  36. {
  37. InitializeComponent();
  38. }
  39. //private void StartupThread()
  40. //{
  41. // try
  42. // {
  43. // _getDataThread = new Thread(new ThreadStart(GetData));
  44. // _getDataThread.IsBackground = true;
  45. // _getDataThread.Start();
  46. // }
  47. // catch { }
  48. // try
  49. // {
  50. // _setDataThread = new Thread(new ThreadStart(SetData));
  51. // _setDataThread.IsBackground = true;
  52. // _setDataThread.Start();
  53. // }
  54. // catch { }
  55. //}
  56. //private void GetData()
  57. //{
  58. // while (_bIfGetData)
  59. // {
  60. // try
  61. // {
  62. // if (!this.On_Off_Thread)
  63. // {
  64. // Thread.Sleep(500);
  65. // continue;
  66. // }
  67. // try
  68. // {
  69. // this.Invoke(new GetDataOperate(proc_GetBaseInfo));
  70. // Thread.Sleep(5000);
  71. // }
  72. // catch { }
  73. // }
  74. // catch { }
  75. // }
  76. //}
  77. //private void SetData()
  78. //{
  79. // while (_bIfSetData)
  80. // {
  81. // try
  82. // {
  83. // if (!this.On_Off_Thread)
  84. // {
  85. // Thread.Sleep(500);
  86. // continue;
  87. // }
  88. // try
  89. // {
  90. // this.Invoke(new SetDataOperate(proc_SetBaseInfo));
  91. // Thread.Sleep(500);
  92. // }
  93. // catch { }
  94. // }
  95. // catch { }
  96. // }
  97. //}
  98. private void FrmTappingHole_Load(object sender, EventArgs e)
  99. {
  100. try
  101. {
  102. ultDTFrom.DateTime = DateTime.Today.AddDays(-30);
  103. ultDTTo.DateTime = DateTime.Today;
  104. cbxSJ.Checked = true;
  105. cbxGL.BackColor = Color.Lime;
  106. }
  107. catch { }
  108. vlstShift = proc_ValueListBcbb();
  109. vlstShiftClone = proc_ValueListBcbb();
  110. proc_GetUseInfo();
  111. //StartupThread();
  112. }
  113. private ValueList proc_ValueListBcbb()
  114. {
  115. ValueList vlist = new ValueList();
  116. try
  117. {
  118. vlist.ValueListItems.Add("11", "白-甲");
  119. vlist.ValueListItems.Add("12", "白-乙");
  120. vlist.ValueListItems.Add("13", "白-丙");
  121. vlist.ValueListItems.Add("14", "白-丁");
  122. vlist.ValueListItems.Add("21", "中-甲");
  123. vlist.ValueListItems.Add("22", "中-乙");
  124. vlist.ValueListItems.Add("23", "中-丙");
  125. vlist.ValueListItems.Add("24", "中-丁");
  126. vlist.ValueListItems.Add("31", "夜-甲");
  127. vlist.ValueListItems.Add("32", "夜-乙");
  128. vlist.ValueListItems.Add("33", "夜-丙");
  129. vlist.ValueListItems.Add("34", "夜-丁");
  130. }
  131. catch { }
  132. return vlist;
  133. }
  134. private void LocateRecord(string strID, bool bSelect)
  135. {
  136. try
  137. {
  138. for (int i = 0; i < ultraGrid1.Rows.Count; i++)
  139. {
  140. if (Convert.ToString(ultraGrid1.Rows[i].Cells["炉座号"].Value) == strID)
  141. {
  142. ultraGrid1.ActiveRow = ultraGrid1.Rows[i];
  143. ultraGrid1.Rows[i].Selected = bSelect;
  144. return;
  145. }
  146. }
  147. }
  148. catch { }
  149. }
  150. private void proc_SetForeColorforBaseInfo()
  151. {
  152. try
  153. {
  154. UltraGridRow row;
  155. for (int i = 0; i < ultraGrid1.Rows.Count; i++)
  156. {
  157. row = ultraGrid1.Rows[i];
  158. if (string.IsNullOrEmpty(Convert.ToString(row.Cells["出钢口编号"].Value)))
  159. {
  160. row.Cells["炉座号"].Appearance.ForeColor = clrWarn;
  161. row.Cells["炉座号"].Appearance.FontData.Bold =
  162. (bBold ? DefaultableBoolean.True : DefaultableBoolean.False);
  163. }
  164. else
  165. {
  166. row.Cells["炉座号"].Appearance.ForeColor = Color.Black;
  167. row.Cells["炉座号"].Appearance.FontData.Bold = DefaultableBoolean.False;
  168. }
  169. }
  170. }
  171. catch { }
  172. finally
  173. {
  174. bBold = !bBold;
  175. }
  176. }
  177. private void proc_SetBackColorforUseInfo()
  178. {
  179. try
  180. {
  181. UltraGridRow row;
  182. string strStatus = "";
  183. for (int i = 0; i < ultraGrid2.Rows.Count; i++)
  184. {
  185. row = ultraGrid2.Rows[i];
  186. strStatus = Convert.ToString(row.Cells["当前状态"].Value);
  187. if (strStatus.Equals("使用"))
  188. {
  189. row.Appearance.BackColor = Color.LightGreen;
  190. }
  191. else if (strStatus.Equals("下线"))
  192. {
  193. row.Appearance.BackColor = Color.FromArgb(210, 208, 208);
  194. }
  195. }
  196. }
  197. catch { }
  198. }
  199. private void proc_GetBaseInfo()
  200. {
  201. bRefreshNow = true;
  202. try
  203. {
  204. string strErr = "";
  205. string strSql = "select "
  206. + "a.POSITION 炉座号, b.ID_ 出钢口编号, AGE_G 使用次数, "
  207. + "to_char(TIME_ON, 'yyyy-MM-dd HH24:mi:ss') 时间, SHIFT_ON 班组, OPTOR_ON 操作人员, "
  208. + "TAPTIME_H 头炉, TAPTIME_T 尾炉, '' 换上, '' 出钢时间 from "
  209. + "("
  210. + "select '1#转炉' POSITION from dual "
  211. + "union all "
  212. + "select '2#转炉' POSITION from dual "
  213. + "union all "
  214. + "select '3#转炉' POSITION from dual "
  215. + ") a, "
  216. + "(select * from "
  217. + "(select t.*, row_number() over (partition by t.POSITION order by length(t.ID_) desc, t.ID_ desc, t.CYCLE_ desc) XH "
  218. + "from DEV_CGK_INFO t where t.STATUS = '使用' and t.POSITION is not null) where XH = 1 "
  219. + ") b "
  220. + "where a.POSITION = b.POSITION(+)"
  221. + "order by a.POSITION";
  222. CallingMessage par = new CallingMessage();
  223. par.ServerName = "LgDeviceManager";
  224. par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
  225. par.ClassName = "Core.LgMes.Server.LgDeviceManager.jjqmanager";
  226. par.MethodName = "ExecuteCommand_Return";
  227. par.args = new object[] { strSql };
  228. DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);
  229. if (strErr == "" && ds != null && ds.Tables.Count > 0)
  230. {
  231. ultraGrid1.DataSource = ds.Tables[0];
  232. ultraGrid1.DataBind();
  233. try
  234. {
  235. ultraGrid1.DisplayLayout.Bands[0].Columns["班组"].ValueList = vlstShiftClone;
  236. }
  237. catch (Exception ex) { Console.WriteLine(ex.Message); }
  238. }
  239. if (ultraGrid1.Rows.Count > 0)
  240. {
  241. if (strCurrID.Length > 0)
  242. LocateRecord(strCurrID, bSelected);
  243. }
  244. else
  245. strCurrID = "";
  246. }
  247. catch { }
  248. finally
  249. {
  250. bRefreshNow = false;
  251. }
  252. }
  253. public void proc_GetUseInfo()
  254. {
  255. try
  256. {
  257. string strWhere = "";
  258. if (cbxSJ.Checked)
  259. {
  260. string strFrom = ultDTFrom.DateTime.ToString("yyyy-MM-dd");
  261. string strTo = ultDTTo.DateTime.ToString("yyyy-MM-dd");
  262. strWhere += " and to_char(TIME_ON, 'yyyy-MM-dd') between '" + strFrom + "' and '" + strTo + "'";
  263. }
  264. if (cbxLZ.Checked && cbbLZ.SelectedIndex > -1)
  265. {
  266. strWhere += " and substr(ID_, 1, 1) = '" + Convert.ToString(cbbLZ.SelectedIndex + 1) + "' ";
  267. }
  268. string strErr = "";
  269. string strSql = "select "
  270. + "ID_ 出钢口编号, STATUS 当前状态, "
  271. + "case STATUS when '使用' then POSITION end 炉座,"
  272. + "nvl(AGE_G, 0) 使用次数, HEATNO_H 头炉炉号, HEATNO_T 尾炉炉号, "
  273. + "to_char(TIME_ON, 'yyyy-MM-dd HH24:mi:ss') 时间, "
  274. + "SHIFT_ON 班组, OPTOR_ON 操作人员, '' 换上, "
  275. + "TAPTIME_H 头炉, TAPTIME_T 尾炉, '' 出钢时间, "
  276. + "to_char(TIME_OFF, 'yyyy-MM-dd HH24:mi:ss') 时间2, "
  277. + "SHIFT_OFF 班组2, OPTOR_OFF 操作人员2, '' 换下, "
  278. + "MEMO 备注, CYCLE_ 周期编号 "
  279. + "from DEV_CGK_INFO "
  280. + "where 1 = 1 " + strWhere + " "
  281. + "order by STATUS, POSITION, length(ID_) desc, ID_ desc, CYCLE_ desc";
  282. CallingMessage par = new CallingMessage();
  283. par.ServerName = "LgDeviceManager";
  284. par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
  285. par.ClassName = "Core.LgMes.Server.LgDeviceManager.jjqmanager";
  286. par.MethodName = "ExecuteCommand_Return";
  287. par.args = new object[] { strSql };
  288. DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);
  289. if (strErr == "" && ds != null && ds.Tables.Count > 0)
  290. {
  291. ultraGrid2.DataSource = ds.Tables[0];
  292. ultraGrid2.DataBind();
  293. try
  294. {
  295. ultraGrid2.DisplayLayout.Bands[0].Columns["班组"].ValueList = vlstShift;
  296. ultraGrid2.DisplayLayout.Bands[0].Columns["班组2"].ValueList = vlstShift;
  297. }
  298. catch { }
  299. }
  300. proc_SetBackColorforUseInfo();
  301. if (ultraGrid2.Rows.Count == 0)
  302. {
  303. proc_ResetEditArea();
  304. }
  305. }
  306. catch (Exception ex)
  307. {
  308. MessageBox.Show("使用记录查询过程中出错!\r\n" + ex.Message, "提示");
  309. }
  310. }
  311. private void proc_SetBaseInfo()
  312. {
  313. try
  314. {
  315. proc_SetForeColorforBaseInfo();
  316. }
  317. catch { }
  318. }
  319. private void proc_ResetEditArea()
  320. {
  321. try
  322. {
  323. tbxCGKBH.Clear();
  324. tbxCGKBH.Tag = null;
  325. tbxDQZT.Clear();
  326. tbxLZH.Clear();
  327. tbxTLLH.Clear();
  328. tbxWLLH.Clear();
  329. nudLGCS.Value = nudTLCGSJ.Value = nudWLCGSJ.Value = 0;
  330. dateTimePicker1.Value = dateTimePicker2.Value = null;
  331. tbxMemo.Clear();
  332. }
  333. catch (Exception ex)
  334. {
  335. MessageBox.Show(ex.Message);
  336. }
  337. }
  338. private void proc_Edit()
  339. {
  340. try
  341. {
  342. if (ultraGrid2.Rows.Count == 0)
  343. return;
  344. if (ultraGrid2.ActiveRow == null)
  345. {
  346. MessageBox.Show("请选择需要修改的出钢口使用信息", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  347. return;
  348. }
  349. if (MessageBox.Show("确认修改当前出钢口使用信息吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
  350. return;
  351. UltraGridRow row = ultraGrid2.ActiveRow;
  352. string strID = Convert.ToString(row.Cells["出钢口编号"].Value);
  353. string strCycle = Convert.ToString(row.Cells["周期编号"].Value);
  354. string strTllh = tbxTLLH.Text.Trim();
  355. string strWllh = tbxWLLH.Text.Trim();
  356. string strLgcx = Convert.ToString(nudLGCS.Value).Trim();
  357. string strTlcgsj = Convert.ToString(nudTLCGSJ.Value).Trim();
  358. string strWlcgsj = Convert.ToString(nudWLCGSJ.Value).Trim();
  359. string strFrom = dateTimePicker1.Text.Trim();
  360. string strTo = dateTimePicker2.Text.Trim();
  361. string strMemo = tbxMemo.Text.Trim();
  362. string strErr = "";
  363. string strSql = "update "
  364. + "DEV_CGK_INFO set "
  365. + "AGE_G = to_number('" + strLgcx + "'), "
  366. + "HEATNO_H = '" + strTllh + "', "
  367. + "HEATNO_T = '" + strWllh + "', "
  368. + "TAPTIME_H = to_number('" + strTlcgsj + "'), "
  369. + "TAPTIME_T = to_number('" + strWlcgsj + "'), "
  370. + "TIME_ON = to_date('" + strFrom + "', 'yyyy-MM-dd HH24:mi:ss'), "
  371. + "TIME_OFF = to_date('" + strTo + "', 'yyyy-MM-dd HH24:mi:ss'), "
  372. + "MEMO = '" + strMemo + "' "
  373. + "where ID_ = '" + strID + "' and CYCLE_ = to_number(" + strCycle + ") ";
  374. CallingMessage par = new CallingMessage();
  375. par.ServerName = "LgDeviceManager";
  376. par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
  377. par.ClassName = "Core.LgMes.Server.LgDeviceManager.jjqmanager";
  378. par.MethodName = "ExecuteCommand_NonReturn";
  379. par.args = new object[] { strSql };
  380. ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);
  381. if (!string.IsNullOrEmpty(strErr))
  382. {
  383. MessageBox.Show("出钢口使用信息修改失败!\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  384. return;
  385. }
  386. proc_GetUseInfo();
  387. try
  388. {
  389. for (int i = 0; i < ultraGrid2.Rows.Count; i++)
  390. {
  391. if (Convert.ToString(ultraGrid2.Rows[i].Cells["出钢口编号"].Value) == strID &&
  392. Convert.ToString(ultraGrid2.Rows[i].Cells["周期编号"].Value) == strCycle)
  393. {
  394. ultraGrid2.ActiveRow = ultraGrid2.Rows[i];
  395. ultraGrid2.Rows[i].Selected = true;
  396. break;
  397. }
  398. }
  399. }
  400. catch { }
  401. MessageBox.Show("出钢口使用信息修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  402. }
  403. catch (Exception ex)
  404. {
  405. MessageBox.Show("出钢口使用信息修改过程中出错!\r\n" + ex.Message, "提示");
  406. }
  407. }
  408. private void proc_Del()
  409. {
  410. try
  411. {
  412. if (ultraGrid2.Rows.Count == 0)
  413. return;
  414. if (ultraGrid2.ActiveRow == null)
  415. {
  416. MessageBox.Show("请选择需要删除的出钢口使用信息", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  417. return;
  418. }
  419. if (MessageBox.Show("确认删除当前出钢口使用信息吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
  420. return;
  421. UltraGridRow row = ultraGrid2.ActiveRow;
  422. string strID = Convert.ToString(row.Cells["出钢口编号"].Value);
  423. string strCycle = Convert.ToString(row.Cells["周期编号"].Value);
  424. string strErr = "";
  425. string strSql = "select nvl(STATUS, '不明') STATUS from DEV_CGK_INFO where ID_ = '" + strID + "' and CYCLE_ = to_number(" + strCycle + ") ";
  426. CallingMessage par = new CallingMessage();
  427. par.ServerName = "LgDeviceManager";
  428. par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
  429. par.ClassName = "Core.LgMes.Server.LgDeviceManager.jjqmanager";
  430. par.MethodName = "ExecuteCommand_Return";
  431. par.args = new object[] { strSql };
  432. DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);
  433. if (!(strErr == "" && ds != null && ds.Tables.Count > 0))
  434. {
  435. MessageBox.Show("出钢口使用信息删除失败!\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  436. return;
  437. }
  438. if (ds.Tables[0].Rows.Count > 0)
  439. {
  440. if (!Convert.ToString(ds.Tables[0].Rows[0]["STATUS"]).Equals("使用"))
  441. {
  442. MessageBox.Show("出钢口已经下线,不能删除使用信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  443. return;
  444. }
  445. }
  446. else
  447. {
  448. MessageBox.Show("出钢口使用信息不存在!\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  449. return;
  450. }
  451. strSql = "delete from DEV_CGK_INFO where ID_ = '" + strID + "' and CYCLE_ = to_number(" + strCycle + ") ";
  452. par.MethodName = "ExecuteCommand_NonReturn";
  453. par.args = new object[] { strSql };
  454. ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);
  455. if (!string.IsNullOrEmpty(strErr))
  456. {
  457. MessageBox.Show("出钢口使用信息删除失败!\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  458. return;
  459. }
  460. proc_GetUseInfo();
  461. MessageBox.Show("出钢口使用信息删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  462. }
  463. catch (Exception ex)
  464. {
  465. MessageBox.Show("出钢口使用信息删除过程中出错!\r\n" + ex.Message, "提示");
  466. }
  467. }
  468. //private static UltraGridExcelExporter ultraGridExcelExporter1 = new UltraGridExcelExporter();
  469. //public static void ExportData(ref UltraGrid ultGrid, string strFileName)
  470. //{
  471. // try
  472. // {
  473. // if (ultGrid.Rows.Count == 0) return;
  474. // if (strFileName.Length == 0)
  475. // strFileName = "未命名";
  476. // SaveFileDialog dlg = new SaveFileDialog();
  477. // dlg.Title = "保存";
  478. // dlg.OverwritePrompt = true;
  479. // dlg.Filter = "Excel文件(*.xls)|*.xls";
  480. // dlg.AddExtension = true;
  481. // dlg.FileName = strFileName;
  482. // if (dlg.ShowDialog() == DialogResult.OK)
  483. // {
  484. // strFileName = dlg.FileName;
  485. // ultraGridExcelExporter1.Export(ultGrid, strFileName);
  486. // if (MessageBox.Show("数据导出成功!\r\n需要打开所导出文件吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
  487. // {
  488. // ultraGridExcelExporter1.Export(ultGrid, strFileName);
  489. // ProcessStartInfo p = new ProcessStartInfo(strFileName);
  490. // p.WorkingDirectory = Path.GetDirectoryName(strFileName);
  491. // Process.Start(p);
  492. // }
  493. // }
  494. // }
  495. // catch (Exception ex)
  496. // {
  497. // MessageBox.Show(ex.Message);
  498. // }
  499. //}
  500. //private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  501. //{
  502. // switch (e.Tool.Key)
  503. // {
  504. // case "Close":
  505. // this.Close();
  506. // break;
  507. // case "Select":
  508. // proc_GetUseInfo();
  509. // break;
  510. // case "Modfiy":
  511. // proc_Edit();
  512. // break;
  513. // case "Delete":
  514. // proc_Del();
  515. // break;
  516. // case "Export":
  517. // string strFileName = "出钢口使用记录";
  518. // ExportData(ref ultraGrid2, strFileName);
  519. // break;
  520. // }
  521. //}
  522. private void ultraGrid1_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
  523. {
  524. try
  525. {
  526. if (e.Row == null)
  527. return;
  528. string strBof = Convert.ToString(e.Row.Cells["炉座号"].Value);
  529. string strId = "";
  530. string strErr = "";
  531. string strSql = "select * from DEV_CGK_INFO where STATUS = '使用' and POSITION = '" + strBof + "'";
  532. CallingMessage par = new CallingMessage();
  533. par.ServerName = "LgDeviceManager";
  534. par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
  535. par.ClassName = "Core.LgMes.Server.LgDeviceManager.jjqmanager";
  536. par.MethodName = "ExecuteCommand_Return";
  537. par.args = new object[] { strSql };
  538. DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);
  539. if (!(strErr == "" && ds != null && ds.Tables.Count > 0))
  540. {
  541. MessageBox.Show(strBof + "信息获取失败!\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  542. return;
  543. }
  544. if (ds.Tables[0].Rows.Count > 0)
  545. {
  546. strId = Convert.ToString(ds.Tables[0].Rows[0]["ID_"]).Trim();
  547. }
  548. else
  549. {
  550. strId = "";
  551. }
  552. FrmTapHoleOperate frm = new FrmTapHoleOperate(strBof, strId);
  553. frm.Tag = this;
  554. frm.ShowDialog();
  555. }
  556. catch (Exception ex)
  557. {
  558. MessageBox.Show(ex.Message, "提示");
  559. }
  560. }
  561. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  562. {
  563. try
  564. {
  565. if (ultraGrid2.ActiveRow == null)
  566. return;
  567. UltraGridRow row = ultraGrid2.ActiveRow;
  568. tbxCGKBH.Text = Convert.ToString(row.Cells["出钢口编号"].Value);
  569. tbxCGKBH.Tag = Convert.ToString(row.Cells["周期编号"].Value);
  570. tbxDQZT.Text = Convert.ToString(row.Cells["当前状态"].Value);
  571. tbxLZH.Text = Convert.ToString(row.Cells["炉座"].Value);
  572. tbxTLLH.Text = Convert.ToString(row.Cells["头炉炉号"].Value);
  573. tbxWLLH.Text = Convert.ToString(row.Cells["尾炉炉号"].Value);
  574. try
  575. {
  576. nudLGCS.Value = Convert.ToDecimal(row.Cells["使用次数"].Value);
  577. }
  578. catch
  579. {
  580. nudLGCS.Value = 0;
  581. }
  582. try
  583. {
  584. nudTLCGSJ.Value = Convert.ToDecimal(row.Cells["头炉"].Value);
  585. }
  586. catch
  587. {
  588. nudTLCGSJ.Value = 0;
  589. }
  590. try
  591. {
  592. nudWLCGSJ.Value = Convert.ToDecimal(row.Cells["尾炉"].Value);
  593. }
  594. catch
  595. {
  596. nudWLCGSJ.Value = 0;
  597. }
  598. if (string.IsNullOrEmpty(Convert.ToString(row.Cells["时间"].Value)))
  599. {
  600. dateTimePicker1.FormatString = " ";
  601. dateTimePicker1.Text = "";
  602. }
  603. else
  604. {
  605. try
  606. {
  607. dateTimePicker1.Value = Convert.ToDateTime(row.Cells["时间"].Value);
  608. }
  609. catch
  610. {
  611. dateTimePicker1.Value = DateTime.Now;
  612. }
  613. }
  614. if (string.IsNullOrEmpty(Convert.ToString(row.Cells["时间2"].Value)))
  615. {
  616. dateTimePicker2.ReadOnly = true;
  617. dateTimePicker2.Text = "";
  618. dateTimePicker2.Nullable = true;
  619. dateTimePicker2.Value = null;
  620. }
  621. else
  622. {
  623. dateTimePicker2.ReadOnly = false;
  624. try
  625. {
  626. dateTimePicker2.Value = Convert.ToDateTime(row.Cells["时间2"].Value);
  627. }
  628. catch
  629. {
  630. dateTimePicker2.Value = DateTime.Now;
  631. }
  632. }
  633. tbxMemo.Text = Convert.ToString(row.Cells["备注"].Value);
  634. }
  635. catch (Exception ex)
  636. {
  637. MessageBox.Show(ex.Message, "提示");
  638. }
  639. }
  640. private void cbxLZ_CheckedChanged(object sender, EventArgs e)
  641. {
  642. cbbLZ.Enabled = cbxLZ.Checked;
  643. }
  644. private void cbxSJ_CheckedChanged(object sender, EventArgs e)
  645. {
  646. ultDTFrom.Enabled = cbxSJ.Checked;
  647. ultDTTo.Enabled = cbxSJ.Checked;
  648. }
  649. private void cbxGL_CheckedChanged(object sender, EventArgs e)
  650. {
  651. try
  652. {
  653. if (cbxGL.Checked)
  654. {
  655. this.ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
  656. }
  657. else
  658. {
  659. this.ultraGrid2.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
  660. this.ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  661. }
  662. }
  663. catch { }
  664. }
  665. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  666. {
  667. try
  668. {
  669. if (bRefreshNow) return;
  670. UltraGridRow row = ultraGrid1.ActiveRow;
  671. if (row != null)
  672. {
  673. strCurrID = Convert.ToString(row.Cells["炉座号"].Value);
  674. bSelected = ultraGrid1.ActiveRow.Selected;
  675. }
  676. }
  677. catch
  678. {
  679. strCurrID = "";
  680. }
  681. }
  682. }
  683. }