frmScrapSteel.cs 88 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008
  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 System.Collections;
  10. using CoreFS.CA06;
  11. using Infragistics.Win.UltraWinGrid;
  12. using System.Threading;
  13. using System.Diagnostics;
  14. using System.IO;
  15. using Core.StlMes.Client.LgCommon;
  16. using Infragistics.Win.UltraWinEditors;
  17. using Infragistics.Win.Misc;
  18. namespace Core.StlMes.Client.LgResMgt
  19. {
  20. public partial class frmScrapSteel : frmStyleBase
  21. {
  22. private System.Threading.Thread myThread_FG;
  23. private ArrayList MaterCode; //物料编码
  24. private ArrayList MaterName; //物料名称
  25. private ArrayList MaterValue; //物料重量
  26. private ArrayList EditorNameList;
  27. private ArrayList EditorValueList;
  28. private string _strSendSucceededForBof1 = "";
  29. private string _strSendSucceededForBof2 = "";
  30. private string _strSendSucceededForBof3 = "";
  31. private string _strSendSucceededForBof4 = "";
  32. private string _strSendSucceededForBof5 = "";
  33. private bool ok_flag = false;
  34. public string workshopNo = "";
  35. public frmScrapSteel()
  36. {
  37. InitializeComponent();
  38. CheckForIllegalCrossThreadCalls = false;
  39. MaterCode = new ArrayList();
  40. MaterName = new ArrayList();
  41. MaterValue = new ArrayList();
  42. EditorNameList = new ArrayList();
  43. EditorValueList = new ArrayList();
  44. }
  45. private void checkBox1_CheckedChanged(object sender, EventArgs e)
  46. {
  47. this.ute_DH.Enabled = checkBox1.Checked;
  48. }
  49. private void frmScrapSteel_Load(object sender, EventArgs e)
  50. {
  51. workshopNo = this.CustomInfo;
  52. label1.BackColor = Color.LightGreen;
  53. label3.BackColor = Color.LightCyan;
  54. label18.BackColor = Color.White;
  55. this.udte_StartTime.Text = System.DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd") + " 00:00:00";
  56. this.udte_EndTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59";
  57. ultraTabControl1.Tabs[0].Selected = true;
  58. chkSend.Checked = true;
  59. InitFrm();
  60. GetZL_Thread();
  61. cbb_BC.SelectedIndex = 0;
  62. GetZL_SCJH();
  63. GetConfigMater();
  64. setMaterEnable();
  65. }
  66. // 根据体系显示控件
  67. /// <summary>
  68. /// 根据体系显示控件
  69. /// </summary>
  70. private void InitFrm()
  71. {
  72. EditorNameList.Add(materName1);
  73. EditorNameList.Add(materName2);
  74. EditorNameList.Add(materName3);
  75. EditorNameList.Add(materName4);
  76. EditorNameList.Add(materName5);
  77. EditorNameList.Add(materName6);
  78. EditorValueList.Add(materValue1);
  79. EditorValueList.Add(materValue2);
  80. EditorValueList.Add(materValue3);
  81. EditorValueList.Add(materValue4);
  82. EditorValueList.Add(materValue5);
  83. EditorValueList.Add(materValue6);
  84. if (workshopNo == "1")
  85. {
  86. ultraGroupBox2.Text = "1#转炉";
  87. ultraGroupBox3.Text = "2#转炉";
  88. ultraGroupBox4.Visible = false;
  89. splitter2.Visible = false;
  90. label15.Text = "1#转炉";
  91. label16.Text = "2#转炉";
  92. label17.Visible = false;
  93. ute_ZL3.Visible = false;
  94. button3.Visible = false;
  95. utlcbdevNo.Items.Clear();
  96. utlcbdevNo.Items.Add("01","1#转炉");
  97. utlcbdevNo.Items.Add("02","2#转炉");
  98. }
  99. else
  100. {
  101. ultraGroupBox2.Text = "3#转炉";
  102. ultraGroupBox3.Text = "4#转炉";
  103. ultraGroupBox4.Text = "5#转炉";
  104. ultraGroupBox4.Visible = true;
  105. splitter2.Visible = true;
  106. label15.Text = "3#转炉";
  107. label16.Text = "4#转炉";
  108. label17.Text = "5#转炉";
  109. utlcbdevNo.Items.Clear();
  110. utlcbdevNo.Items.Add("03","3#转炉");
  111. utlcbdevNo.Items.Add("04","4#转炉");
  112. utlcbdevNo.Items.Add("05","5#转炉");
  113. }
  114. }
  115. // 获取转炉生产计划记录
  116. /// <summary>
  117. /// 获取转炉生产计划记录
  118. /// </summary>
  119. private void GetZL_SCJH()
  120. {
  121. try
  122. {
  123. string szOut = "", strWhere = "";
  124. int RowID_1 = 0, RowID_2 = 0, RowID_3 = 0;
  125. string strStartTime = "";
  126. string strEndTime = "";
  127. this.dataTable2.Rows.Clear();
  128. this.dataTable3.Rows.Clear();
  129. this.dataTable4.Rows.Clear();
  130. if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
  131. {
  132. MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  133. udte_EndTime.Focus();
  134. return;
  135. }
  136. else
  137. {
  138. strStartTime = this.udte_StartTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  139. strEndTime = this.udte_EndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  140. }
  141. strWhere = " and PLAN_MAKING_TIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') ";
  142. //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') ";
  143. // 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')";
  144. ArrayList arry = new ArrayList();
  145. ArrayList sqlList = new ArrayList();
  146. arry.Add("GetZL_SCJH.query");
  147. sqlList.Add(strWhere);
  148. CoreClientParam CCP_LgEts = new CoreClientParam();
  149. DataTable dt = new DataTable();
  150. CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  151. CCP_LgEts.MethodName = "doQuery";
  152. CCP_LgEts.ServerParams = new object[] { arry, sqlList };
  153. CCP_LgEts.SourceDataTable = dt;
  154. this.ExecuteSortResultByQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
  155. DataSet ds = new DataSet();
  156. ds.Tables.Add(dt);
  157. szOut = CCP_LgEts.ReturnInfo;
  158. //DataSet ds = null;// (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "GetZYJH_Data", new object[] { strWhere }, out szOut);
  159. if (szOut == "")
  160. {
  161. if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
  162. {
  163. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  164. {
  165. if (workshopNo == "1") //1体系 1,2转炉
  166. {
  167. if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "1")
  168. {
  169. DataRow dr = this.dataTable2.NewRow();
  170. for (int j = 0; j < this.dataTable2.Columns.Count; j++)
  171. {
  172. dr[this.dataTable2.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable2.Columns[j].ColumnName.ToString()].ToString();
  173. }
  174. this.dataTable2.Rows.Add(dr);
  175. if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
  176. {
  177. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  178. {
  179. cell.Appearance.BackColor = Color.White;//计划状态
  180. }
  181. }
  182. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
  183. {
  184. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  185. cell.Appearance.BackColor = Color.LightGreen;//生产状态
  186. }
  187. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
  188. {
  189. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  190. cell.Appearance.BackColor = Color.LightCyan;//生产完成
  191. }
  192. RowID_1 += 1;
  193. }
  194. if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "2")
  195. {
  196. DataRow dr = this.dataTable3.NewRow();
  197. for (int j = 0; j < this.dataTable3.Columns.Count; j++)
  198. {
  199. dr[this.dataTable3.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable3.Columns[j].ColumnName.ToString()].ToString();
  200. }
  201. this.dataTable3.Rows.Add(dr);
  202. if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
  203. {
  204. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  205. {
  206. cell.Appearance.BackColor = Color.White;//计划状态
  207. }
  208. }
  209. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
  210. {
  211. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  212. cell.Appearance.BackColor = Color.LightGreen;//生产状态
  213. }
  214. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
  215. {
  216. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  217. cell.Appearance.BackColor = Color.LightCyan;//生产状态
  218. }
  219. RowID_2 += 1;
  220. }
  221. }
  222. else //2体系 3,4,5转炉
  223. {
  224. if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "3")
  225. {
  226. DataRow dr = this.dataTable2.NewRow();
  227. for (int j = 0; j < this.dataTable2.Columns.Count; j++)
  228. {
  229. dr[this.dataTable2.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable2.Columns[j].ColumnName.ToString()].ToString();
  230. }
  231. this.dataTable2.Rows.Add(dr);
  232. if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
  233. {
  234. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  235. {
  236. cell.Appearance.BackColor = Color.White;//计划状态
  237. }
  238. }
  239. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
  240. {
  241. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  242. cell.Appearance.BackColor = Color.LightGreen;//生产状态
  243. }
  244. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
  245. {
  246. foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
  247. cell.Appearance.BackColor = Color.LightCyan;//生产完成
  248. }
  249. RowID_1 += 1;
  250. }
  251. if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "4")
  252. {
  253. DataRow dr = this.dataTable3.NewRow();
  254. for (int j = 0; j < this.dataTable3.Columns.Count; j++)
  255. {
  256. dr[this.dataTable3.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable3.Columns[j].ColumnName.ToString()].ToString();
  257. }
  258. this.dataTable3.Rows.Add(dr);
  259. if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
  260. {
  261. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  262. {
  263. cell.Appearance.BackColor = Color.White;//计划状态
  264. }
  265. }
  266. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
  267. {
  268. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  269. cell.Appearance.BackColor = Color.LightGreen;//生产状态
  270. }
  271. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
  272. {
  273. foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
  274. cell.Appearance.BackColor = Color.LightCyan;//生产状态
  275. }
  276. RowID_2 += 1;
  277. }
  278. if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "5")
  279. {
  280. DataRow dr = this.dataTable4.NewRow();
  281. for (int j = 0; j < this.dataTable4.Columns.Count; j++)
  282. {
  283. dr[this.dataTable4.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable4.Columns[j].ColumnName.ToString()].ToString();
  284. }
  285. this.dataTable4.Rows.Add(dr);
  286. if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
  287. {
  288. foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
  289. {
  290. cell.Appearance.BackColor = Color.White;//计划状态
  291. }
  292. }
  293. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
  294. {
  295. foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
  296. cell.Appearance.BackColor = Color.LightGreen;//计划状态
  297. }
  298. else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
  299. {
  300. foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
  301. cell.Appearance.BackColor = Color.LightCyan;//生成完成
  302. }
  303. RowID_3 += 1;
  304. }
  305. }
  306. }
  307. }
  308. }
  309. PublicMethod.RefreshAndAutoSize(ultraGrid2);
  310. PublicMethod.RefreshAndAutoSize(ultraGrid3);
  311. PublicMethod.RefreshAndAutoSize(ultraGrid4);
  312. }
  313. catch (Exception ex)
  314. {
  315. MessageBox.Show(ex.Message);
  316. }
  317. }
  318. // 获得已经配置的物料
  319. /// <summary>
  320. /// 获得已经配置的物料
  321. /// </summary>
  322. public void GetConfigMater()
  323. {
  324. try
  325. {
  326. string strErr = "";
  327. ArrayList arry = new ArrayList();
  328. arry.Add("ScrapSteel.Config");
  329. arry.Add(workshopNo);
  330. CommonClientToServer ccs = new CommonClientToServer();
  331. ccs.ob = this.ob;
  332. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  333. if (ds != null && ds.Tables[0].Rows.Count > 0)
  334. {
  335. string matercode = "";
  336. string matername = "";
  337. int m = 0;
  338. int count=ds.Tables[0].Rows.Count;
  339. for (int i = 0; i < count; i++)
  340. {
  341. matercode = ds.Tables[0].Rows[i]["SCRAPSTEELCODE"].ToString();
  342. matername = ds.Tables[0].Rows[i]["SCRAPSTEELNAME"].ToString();
  343. try
  344. {
  345. ((UltraLabel)EditorNameList[i]).Tag = matercode;
  346. ((UltraLabel)EditorNameList[i]).Text = matername;
  347. m++;
  348. }
  349. catch { }
  350. }
  351. for (int j = m; j < EditorNameList.Count; j++)
  352. {
  353. ((UltraLabel)EditorNameList[j]).Text = "";
  354. }
  355. for (int n = 0; n < EditorValueList.Count; n++)
  356. {
  357. ((UltraTextEditor)EditorValueList[n]).Text = "";
  358. }
  359. }
  360. setMaterEnable();
  361. }
  362. catch { }
  363. }
  364. // 取入炉明细数据主表
  365. /// <summary>
  366. /// 取入炉明细数据主表
  367. /// </summary>
  368. private void GetRLMX_Data()
  369. {
  370. try
  371. {
  372. this.ultraDataSource1.Rows.Clear();
  373. this.dataTable1.Rows.Clear();
  374. DataSet SetMain = new DataSet();
  375. string szOut = "", strWhere = "";
  376. string strStartTime = "";
  377. string strEndTime = "";
  378. if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
  379. {
  380. MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  381. udte_EndTime.Focus();
  382. return;
  383. }
  384. else
  385. {
  386. strStartTime = this.udte_StartTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  387. strEndTime = this.udte_EndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  388. }
  389. strWhere = " where JOBDATE between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') and WORKSHOPNO='" + workshopNo + "' ";
  390. // 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')";
  391. if (this.checkBox1.Checked)
  392. {
  393. strWhere += " and CHARGENO = '" + ute_DH.Text.ToString().Trim() + "' ";
  394. }
  395. if (this.chkSend.Checked)
  396. {
  397. strWhere += " and (heatno is null or stationcode is null) ";
  398. }
  399. //获取主表信息
  400. ArrayList arry = new ArrayList();
  401. ArrayList sqlList = new ArrayList();
  402. arry.Add("GetRLMX_Data.query");
  403. sqlList.Add(strWhere);
  404. CoreClientParam CCP_LgEts = new CoreClientParam();
  405. DataTable dt = new DataTable();
  406. CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  407. CCP_LgEts.MethodName = "doQuery";
  408. CCP_LgEts.ServerParams = new object[] { arry, sqlList };
  409. CCP_LgEts.SourceDataTable = dt;
  410. this.ExecuteSortResultByQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
  411. SetMain.Tables.Clear();
  412. SetMain.Tables.Add(dt.Copy());
  413. SetMain.Tables[0].TableName = "Main";
  414. DataSet ds = new DataSet();
  415. ds.Tables.Add(dt.Copy());
  416. szOut = CCP_LgEts.ReturnInfo;
  417. if (szOut != "" || ds.Tables[0].Rows.Count == 0)
  418. {
  419. ultraGrid1.DataSource = this.ultraDataSource1;
  420. return;
  421. }
  422. //获取从表信息
  423. strWhere = " where FEEDINGTIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') and WORKSHOPNO='" + workshopNo + "' ";
  424. if (this.chkSend.Checked)
  425. {
  426. strWhere += " and ISSEND ='0'";
  427. }
  428. ArrayList arry1 = new ArrayList();
  429. ArrayList sqlList1 = new ArrayList();
  430. arry1.Add("ScrapSteelMaterAdd.Query");
  431. sqlList1.Add(strWhere);
  432. CoreClientParam ccp = new CoreClientParam();
  433. DataTable dt1 = new DataTable();
  434. ccp.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  435. ccp.MethodName = "doQuery";
  436. ccp.ServerParams = new object[] { arry1, sqlList1 };
  437. ccp.SourceDataTable = dt1;
  438. this.ExecuteSortResultByQueryToDataTable(ccp, CoreInvokeType.Internal);
  439. DataSet ds1 = new DataSet();
  440. dt1.TableName = "Child";
  441. ds1.Tables.Add(dt1.Copy());
  442. szOut = CCP_LgEts.ReturnInfo;
  443. if (szOut != "" || ds1.Tables[0].Rows.Count == 0)
  444. {
  445. ultraGrid1.DataSource = this.ultraDataSource1;
  446. return;
  447. }
  448. SetMain.Tables.Add(ds1.Tables[0].Copy());
  449. SetMain.Relations.Clear();
  450. SetMain.Relations.Add("Band 1", SetMain.Tables["Main"].Columns["JOBID"], SetMain.Tables["Child"].Columns["JOBID"]);
  451. this.ultraGrid1.DataSource = SetMain;
  452. foreach (UltraGridRow row in ultraGrid1.Rows)
  453. {
  454. if (row.Cells["HEATNO"].Value.ToString().Trim() == "" && row.Cells["STATIONCODE"].Value.ToString().Trim() == "")
  455. {
  456. row.Appearance.BackColor = Color.LightCyan;//未发送状态
  457. }
  458. else if (row.Cells["HEATNO"].Value.ToString().Trim() != "" && row.Cells["STATIONCODE"].Value.ToString().Trim() != "")
  459. {
  460. row.Appearance.BackColor = Color.LightGreen;//发送状态
  461. }
  462. else
  463. {
  464. row.Appearance.BackColor = Color.White;//未知状态
  465. }
  466. }
  467. SetSteelSum();
  468. PublicMethod.RefreshAndAutoSize(ultraGrid1);
  469. }
  470. catch (Exception ex)
  471. {
  472. MessageBox.Show(ex.Message);
  473. }
  474. }
  475. // 统计废钢重量
  476. /// <summary>
  477. /// 统计废钢重量
  478. /// </summary>
  479. private void SetSteelSum()
  480. {
  481. UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[0];
  482. band.Summaries.Clear();
  483. SummarySettings summary = band.Summaries.Add(SummaryType.Count, band.Columns[5]);
  484. summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
  485. summary.DisplayFormat = "合计:";
  486. for (int i = 6; i < 10; i++)
  487. {
  488. summary = band.Summaries.Add(SummaryType.Sum, band.Columns[i]);
  489. summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
  490. summary.DisplayFormat = " {0:#####.00}";
  491. summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
  492. summary.Appearance.ForeColor = Color.DarkBlue;
  493. summary.Appearance.BackColor = Color.White;
  494. }
  495. band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
  496. }
  497. // 新增记录
  498. /// <summary>
  499. /// 新增记录
  500. /// </summary>
  501. private void AddNewData()
  502. {
  503. try
  504. {
  505. if (ute_DH2.Text.Trim().Length == 0)
  506. {
  507. MessageBox.Show("料斗号不能为空,请输入料斗号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  508. ute_DH2.Focus();
  509. return;
  510. }
  511. if (ute_ZZ.Text.Trim().Length == 0)
  512. {
  513. MessageBox.Show("废钢总量不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  514. return;
  515. }
  516. if (ute_ZZ.Text.Trim() == "0")
  517. {
  518. MessageBox.Show("废钢总量不能为零,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  519. return;
  520. }
  521. //查询当前班次
  522. string strErr = "";
  523. string m_szCurrClass = "";
  524. ArrayList arry = new ArrayList();
  525. arry.Add("GetClassCode.query"); // 位于 QueryLgIntegration.xml 中
  526. CommonClientToServer ccs = new CommonClientToServer();
  527. ccs.ob = this.ob;
  528. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  529. if (ds.Tables[0].Rows.Count > 0)
  530. {
  531. m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString();
  532. }
  533. GetAllMater();
  534. if (MaterCode.Count==0)
  535. {
  536. MessageBox.Show("没有物料信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  537. return;
  538. }
  539. strErr = "";
  540. string strSqlID = "frmScrapMater.Add";
  541. object[] sArgs = new object[12];
  542. sArgs[0] = MaterCode; //物料编码
  543. sArgs[1] = MaterName; //物料名称
  544. sArgs[2] = MaterValue; //物料重量
  545. sArgs[3] = ute_DH2.Text.Trim(); //料斗号
  546. sArgs[4] = (ute_RLSJ.Text.ToString() == ""?DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"):
  547. (Convert.ToDateTime(ute_RLSJ.Text.Trim())).ToString("yyyy-MM-dd HH:mm:ss")); //入炉时间
  548. sArgs[5] = ute_RLZL.Text.Trim() == "" ? "0" : ute_RLZL.Text.Trim(); //入炉重量
  549. sArgs[6] = ute_DZ.Text.Trim() == "" ? "0" : ute_DZ.Text.Trim(); // 料斗重
  550. sArgs[7] = ute_ZZ.Text.Trim() == "" ? "0" : ute_ZZ.Text.Trim(); //总重
  551. sArgs[8] = this.UserInfo.GetUserName(); //操作人
  552. sArgs[9] = m_szCurrClass.Substring(0,1) + cbb_BC.Value.ToString().Trim(); //班次班组
  553. sArgs[10] = ute_BZ.Text.Trim(); //备注
  554. sArgs[11] = workshopNo;
  555. try
  556. {
  557. CommonClientToServer ccTs = new CommonClientToServer();
  558. ccTs.ob = ob;
  559. string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
  560. "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
  561. if (strErr != "")
  562. {
  563. ok_flag = false;
  564. MessageBox.Show("新增失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  565. return;
  566. }
  567. else
  568. {
  569. ok_flag = true;
  570. MessageBox.Show(" 废钢新增成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  571. }
  572. }
  573. catch { }
  574. }
  575. catch { }
  576. }
  577. // 获取物料值
  578. /// <summary>
  579. /// 获取物料值
  580. /// </summary>
  581. private void GetAllMater()
  582. {
  583. try
  584. {
  585. MaterCode.Clear();
  586. MaterName.Clear();
  587. MaterValue.Clear();
  588. GetAllMaterFun(materName1, materValue1);
  589. GetAllMaterFun(materName2, materValue2);
  590. GetAllMaterFun(materName3, materValue3);
  591. GetAllMaterFun(materName4, materValue4);
  592. GetAllMaterFun(materName5, materValue5);
  593. GetAllMaterFun(materName6, materValue6);
  594. }
  595. catch { }
  596. }
  597. private void GetAllMaterFun(UltraLabel editor1,UltraTextEditor editor2)
  598. {
  599. try
  600. {
  601. if (editor1.Text.Trim() != "")
  602. {
  603. MaterCode.Add(editor1.Tag.ToString());
  604. MaterName.Add(editor1.Text.Trim());
  605. MaterValue.Add(editor2.Text.Trim() == "" ? "0" : editor2.Text.Trim());
  606. }
  607. }
  608. catch { }
  609. }
  610. // 删除记录
  611. /// <summary>
  612. /// 删除记录
  613. /// </summary>
  614. private void DeleteDataRow()
  615. {
  616. try
  617. {
  618. if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
  619. {
  620. MessageBox.Show("没有有效的废钢信息可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  621. return;
  622. }
  623. if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen || ute_LH.Text.Trim() != "")
  624. {
  625. MessageBox.Show("选取的废钢信息已发送不能删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  626. return;
  627. }
  628. string strXH = ultNo.Text.Trim();
  629. if (strXH == "") return;
  630. DialogResult dr = MessageBox.Show("是否确认删除废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
  631. if (dr == DialogResult.No) return;
  632. string strErr = "";
  633. string strSqlID = "frmScrapMater.Delete";
  634. object[] sArgs = new object[1];
  635. sArgs[0] = strXH; //序号
  636. try
  637. {
  638. CommonClientToServer ccTs = new CommonClientToServer();
  639. ccTs.ob = ob;
  640. string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
  641. "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
  642. if (strErr != "")
  643. {
  644. MessageBox.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  645. }
  646. else
  647. {
  648. MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  649. GetRLMX_Data();
  650. }
  651. }
  652. catch { }
  653. }
  654. catch { }
  655. }
  656. // 清除编辑区内容
  657. /// <summary>
  658. /// 清除编辑区内容
  659. /// </summary>
  660. private void ClearData()
  661. {
  662. ute_DH2.Text = "";
  663. materValue1.Text = "";
  664. materValue2.Text = "";
  665. materValue3.Text = "";
  666. materValue4.Text = "";
  667. materValue5.Text = "";
  668. materValue6.Text = "";
  669. utlcbdevNo.SelectedIndex = -1;
  670. ute_RLZL.Text = "";
  671. ute_LH.Text = "";
  672. ute_ZZ.Text = "";
  673. cbb_BC.SelectedIndex=0;
  674. ute_DZ.Text = "";
  675. ute_RLSJ.Text = "";
  676. ute_BZ.Text = "";
  677. }
  678. // 清除编辑区内容
  679. /// <summary>
  680. /// 清除编辑区内容
  681. /// </summary>
  682. private void ClearData1()
  683. {
  684. ute_DH2.Text = "";
  685. materValue1.Text = "";
  686. materValue2.Text = "";
  687. materValue3.Text = "";
  688. materValue4.Text = "";
  689. materValue5.Text = "";
  690. materValue6.Text = "";
  691. ute_RLZL.Text = "";
  692. ute_LH.Text = "";
  693. ute_ZZ.Text = "";
  694. cbb_BC.SelectedIndex = 0;
  695. ute_DZ.Text = "";
  696. ute_RLSJ.Text = "";
  697. ute_BZ.Text = "";
  698. }
  699. // 修改记录
  700. /// <summary>
  701. /// 修改记录
  702. /// </summary>
  703. /// <param name="strXH"></param>
  704. private void UpdateDataRow(string strXH)
  705. {
  706. try
  707. {
  708. if (ute_DH2.Text.Trim().Length == 0)
  709. {
  710. MessageBox.Show("料斗号不能为空,请输入料斗号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  711. ute_DH2.Focus();
  712. return;
  713. }
  714. if (ute_ZZ.Text.Trim().Length == 0)
  715. {
  716. MessageBox.Show("废钢总量不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  717. return;
  718. }
  719. if (ute_ZZ.Text.Trim() == "0")
  720. {
  721. MessageBox.Show("废钢总量不能为零,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  722. return;
  723. }
  724. //查询当前班次
  725. string strErr = "";
  726. string m_szCurrClass = "";
  727. ArrayList arry = new ArrayList();
  728. arry.Add("GetClassCode.query"); // 位于 QueryLgIntegration.xml 中
  729. CommonClientToServer ccs = new CommonClientToServer();
  730. ccs.ob = this.ob;
  731. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  732. if (ds.Tables[0].Rows.Count > 0)
  733. {
  734. m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString();
  735. }
  736. GetAllMater();
  737. if (MaterCode.Count == 0)
  738. {
  739. MessageBox.Show("没有物料信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  740. return;
  741. }
  742. strErr = "";
  743. string strSqlID = "frmScrapMater.Update";
  744. object[] sArgs = new object[13];
  745. sArgs[0] = MaterCode; //物料编码
  746. sArgs[1] = MaterName; //物料名称
  747. sArgs[2] = MaterValue; //物料重量
  748. sArgs[3] = ultNo.Text.Trim(); //序号
  749. sArgs[4] = ute_DH2.Text.Trim(); //料斗号
  750. sArgs[5] = (ute_RLSJ.Text.ToString() == "" ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") :
  751. (Convert.ToDateTime(ute_RLSJ.Text.Trim())).ToString("yyyy-MM-dd HH:mm:ss")); //入炉时间
  752. sArgs[6] = ute_RLZL.Text.Trim() == "" ? "0" : ute_RLZL.Text.Trim(); //入炉重量
  753. sArgs[7] = ute_DZ.Text.Trim() == "" ? "0" : ute_DZ.Text.Trim(); // 料斗重
  754. sArgs[8] = ute_ZZ.Text.Trim() == "" ? "0" : ute_ZZ.Text.Trim(); //总重
  755. sArgs[9] = this.UserInfo.GetUserName(); //操作人
  756. sArgs[10] = m_szCurrClass.Substring(0, 1) + cbb_BC.Value.ToString().Trim(); //班次班组
  757. sArgs[11] = ute_BZ.Text.Trim(); //备注
  758. sArgs[12] = workshopNo;
  759. try
  760. {
  761. CommonClientToServer ccTs = new CommonClientToServer();
  762. ccTs.ob = ob;
  763. string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
  764. "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
  765. if (strErr != "")
  766. {
  767. ok_flag = false;
  768. MessageBox.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
  769. return;
  770. }
  771. else
  772. {
  773. ok_flag = true;
  774. MessageBox.Show(" 修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  775. }
  776. }
  777. catch { }
  778. }
  779. catch { }
  780. }
  781. // 取消发送
  782. /// <summary>
  783. /// 取消发送
  784. /// </summary>
  785. private void CancelSend()
  786. {
  787. try
  788. {
  789. string strXH = ultNo.Text.Trim();
  790. string strLH = ute_LH.Text.Trim();
  791. string strStation = "01";
  792. try
  793. {
  794. strStation = "0" + utlcbdevNo.Text.Trim().Substring(0, 1);
  795. }
  796. catch { }
  797. if (strLH == "")
  798. {
  799. MessageBox.Show("你选择的废钢信息还未发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  800. return;
  801. }
  802. if (strLH != ute_ZL1.Text.Trim() && strLH != ute_ZL2.Text.Trim() && strLH != ute_ZL3.Text.Trim())
  803. {
  804. MessageBox.Show("该炉次号不在转炉工序,不能取消!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  805. return;
  806. }
  807. DialogResult dr = MessageBox.Show("确定取消已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
  808. if (dr == DialogResult.No) return;
  809. String strErr = "";
  810. string strSqlID = "frmScrapMater.Cancel";
  811. object[] sArgs = new object[2];
  812. sArgs[0] = strLH; //炉号
  813. sArgs[1] = strXH; //序号
  814. CommonClientToServer ccTs = new CommonClientToServer();
  815. ccTs.ob = ob;
  816. string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
  817. "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
  818. if (strErr != "")
  819. {
  820. MessageBox.Show("废钢信息取消发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  821. }
  822. else
  823. {
  824. MessageBox.Show("废钢信息取消发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  825. GetRLMX_Data();
  826. HeatNo_HudwId_Exist(strLH, strStation);
  827. }
  828. }
  829. catch { }
  830. }
  831. //实时刷新当前转炉正在冶炼的熔炼号
  832. ///<summary>
  833. ///实时刷新当前转炉正在冶炼的熔炼号
  834. ///</summary>
  835. private void GetZL_Thread()
  836. {
  837. try
  838. {
  839. myThread_FG = new Thread(new ThreadStart(getZLCurrentLH));
  840. myThread_FG.Priority = ThreadPriority.Normal;
  841. myThread_FG.Start();
  842. }
  843. catch (Exception ex)
  844. {
  845. MessageBox.Show(ex.Message);
  846. }
  847. }
  848. // 取当前转炉正在冶炼熔炼号 C##01_DEVICE
  849. /// <summary>
  850. /// 取当前转炉正在冶炼熔炼号 CVT01_DEVICE
  851. /// </summary>
  852. private void getZLCurrentLH()
  853. {
  854. try
  855. {
  856. System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false;
  857. while (true)
  858. {
  859. if (!this.On_Off_Thread)
  860. {
  861. System.Threading.Thread.Sleep(500);
  862. continue;
  863. }
  864. this.ute_ZL1.Text = "";
  865. this.ute_ZL2.Text = "";
  866. this.ute_ZL3.Text = "";
  867. //初始化颜色
  868. ute_ZL1.Appearance.BackColor = Color.White;//.Gainsboro;
  869. ute_ZL2.Appearance.BackColor = Color.White;
  870. ute_ZL3.Appearance.BackColor = Color.White;
  871. string strError = "";
  872. ArrayList arry = new ArrayList();
  873. arry.Clear();
  874. arry.Add("getZLCurrentLH.query");
  875. CommonClientToServer ccs = new CommonClientToServer();
  876. ccs.ob = this.ob;
  877. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strError);
  878. if (strError == "")
  879. {
  880. if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
  881. {
  882. //初始化颜色
  883. ute_ZL1.Appearance.BackColor = Color.White;
  884. ute_ZL2.Appearance.BackColor = Color.White;
  885. ute_ZL3.Appearance.BackColor = Color.White;
  886. for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  887. {
  888. string v_ZLH = ds.Tables[0].Rows[i]["objectpos"].ToString().Substring(3, 2);
  889. string v_LH = (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(5, ds.Tables[0].Rows[i]["objectid"].ToString().Length - 5));
  890. // if (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(0, 1) == "V") v_LH = "V" + v_LH;
  891. if (workshopNo == "1")
  892. {
  893. if (v_ZLH == "01")
  894. {
  895. this.ute_ZL1.Text = v_LH;
  896. HeatNo_HudwId_Exist(v_LH, "01");
  897. }
  898. if (v_ZLH == "02")
  899. {
  900. this.ute_ZL2.Text = v_LH;
  901. HeatNo_HudwId_Exist(v_LH, "02");
  902. }
  903. }
  904. else
  905. {
  906. if (v_ZLH == "03")
  907. {
  908. this.ute_ZL1.Text = v_LH;
  909. HeatNo_HudwId_Exist(v_LH, "03");
  910. }
  911. if (v_ZLH == "04")
  912. {
  913. this.ute_ZL2.Text = v_LH;
  914. HeatNo_HudwId_Exist(v_LH, "04");
  915. }
  916. if (v_ZLH == "05")
  917. {
  918. this.ute_ZL3.Text = v_LH;
  919. HeatNo_HudwId_Exist(v_LH, "05");
  920. }
  921. }
  922. }
  923. }
  924. }
  925. Thread.Sleep(10000);
  926. }
  927. }
  928. catch
  929. {
  930. }
  931. }
  932. // 判断是否已经发送废钢
  933. /// <summary>
  934. /// 判断是否已经发送废钢
  935. /// </summary>
  936. /// <熔炼号="strID"></param>
  937. /// <炉座号="strGw"></param>
  938. private void HeatNo_HudwId_Exist(string strID, string strGw)
  939. {
  940. string strErr = "";
  941. try
  942. {
  943. ArrayList arry = new ArrayList();
  944. arry.Add("HeatNo_HudwId_Exist.query");
  945. CommonClientToServer ccs = new CommonClientToServer();
  946. ccs.ob = this.ob;
  947. arry.Add(strID);
  948. arry.Add(strID);
  949. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  950. if (strErr == "")
  951. {
  952. switch (strGw)
  953. {
  954. case "01":
  955. _strSendSucceededForBof1 = ds.Tables[0].Rows[0]["intCount"].ToString()=="0"?"N":"Y";
  956. if (_strSendSucceededForBof1 == "N") ute_ZL1.Appearance.BackColor = Color.White;
  957. if (_strSendSucceededForBof1 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue;
  958. break;
  959. case "02":
  960. _strSendSucceededForBof2 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
  961. if (_strSendSucceededForBof2 == "N") ute_ZL2.Appearance.BackColor = Color.White;
  962. if (_strSendSucceededForBof2 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue;
  963. break;
  964. case "03":
  965. _strSendSucceededForBof3 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
  966. if (_strSendSucceededForBof3 == "N") ute_ZL1.Appearance.BackColor = Color.White;
  967. if (_strSendSucceededForBof3 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue;
  968. break;
  969. case "04":
  970. _strSendSucceededForBof4 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
  971. if (_strSendSucceededForBof4 == "N") ute_ZL2.Appearance.BackColor = Color.White;
  972. if (_strSendSucceededForBof4 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue;
  973. break;
  974. case "05":
  975. _strSendSucceededForBof5 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
  976. if (_strSendSucceededForBof5 == "N") ute_ZL3.Appearance.BackColor = Color.White;
  977. if (_strSendSucceededForBof5 == "Y") ute_ZL3.Appearance.BackColor = Color.LightBlue;
  978. break;
  979. default:
  980. break;
  981. }
  982. }
  983. }
  984. catch
  985. {
  986. }
  987. }
  988. // 点击修改或删除时显示确认和取消按钮
  989. /// <summary>
  990. /// 点击修改或删除时显示确认和取消按钮
  991. /// </summary>
  992. /// <param name="bEnable"></param>
  993. private void SetDetailToolBarEnable(bool bEnable,string flag)
  994. {
  995. int count = this.ultraToolbarsManager1.Tools.Count;
  996. for (int i = 0; i < count; i++)
  997. {
  998. this.ultraToolbarsManager1.Tools[i].SharedProps.Enabled = !bEnable;
  999. }
  1000. if (bEnable == true && flag == "add")
  1001. {
  1002. this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Visible = true;
  1003. this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Enabled = true;
  1004. }
  1005. else
  1006. {
  1007. this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Visible = false;
  1008. this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Enabled = false;
  1009. }
  1010. this.ultraToolbarsManager1.Tools["ok"].SharedProps.Enabled = bEnable;
  1011. this.ultraToolbarsManager1.Tools["cancel"].SharedProps.Enabled = bEnable;
  1012. this.ultraToolbarsManager1.Tools["ok"].SharedProps.Visible = bEnable;
  1013. this.ultraToolbarsManager1.Tools["cancel"].SharedProps.Visible = bEnable;
  1014. }
  1015. // 设置物料区域是否可编辑
  1016. /// <summary>
  1017. /// 设置物料区域是否可编辑
  1018. /// </summary>
  1019. /// <param name="t_Enable"></param>
  1020. private void setMaterEnable()
  1021. {
  1022. try
  1023. {
  1024. setMaterEnableFun(materName1, materValue1);
  1025. setMaterEnableFun(materName2, materValue2);
  1026. setMaterEnableFun(materName3, materValue3);
  1027. setMaterEnableFun(materName4, materValue4);
  1028. setMaterEnableFun(materName5, materValue5);
  1029. setMaterEnableFun(materName6, materValue6);
  1030. }
  1031. catch { }
  1032. }
  1033. private void setMaterEnableFun(UltraLabel editro1, UltraTextEditor editro2)
  1034. {
  1035. try
  1036. {
  1037. if (editro1.Text.Trim() == "")
  1038. {
  1039. editro1.Enabled = false;
  1040. editro2.Enabled = false;
  1041. }
  1042. else
  1043. {
  1044. editro1.Enabled = true;
  1045. editro2.Enabled = true;
  1046. }
  1047. }
  1048. catch { }
  1049. }
  1050. // 设置编辑区域是否可编辑
  1051. /// <summary>
  1052. /// 设置编辑区域是否可编辑
  1053. /// </summary>
  1054. /// <param name="t_Enable"></param>
  1055. private void setToolEnable(bool t_Enable)
  1056. {
  1057. try
  1058. {
  1059. ute_DH2.ReadOnly = t_Enable;
  1060. materValue1.ReadOnly = t_Enable;
  1061. materValue2.ReadOnly = t_Enable;
  1062. materValue3.ReadOnly = t_Enable;
  1063. materValue4.ReadOnly = t_Enable;
  1064. materValue5.ReadOnly = t_Enable;
  1065. materValue6.ReadOnly = t_Enable;
  1066. ute_RLZL.ReadOnly = t_Enable;
  1067. cbb_BC.ReadOnly = t_Enable;
  1068. ute_DZ.ReadOnly = t_Enable;
  1069. ute_RLSJ.ReadOnly = t_Enable;
  1070. ute_BZ.ReadOnly = t_Enable;
  1071. }
  1072. catch { }
  1073. }
  1074. // 系统菜单栏
  1075. /// <summary>
  1076. /// 系统菜单栏
  1077. /// </summary>
  1078. /// <param name="sender"></param>
  1079. /// <param name="ToolbarKey"></param>
  1080. public override void ToolBar_Click(object sender, string ToolbarKey)
  1081. {
  1082. base.ToolBar_Click(sender, ToolbarKey);
  1083. switch (ToolbarKey)
  1084. {
  1085. case "Add"://新增
  1086. try
  1087. {
  1088. ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  1089. }
  1090. catch
  1091. {
  1092. return;
  1093. }
  1094. AddNewData();
  1095. GetRLMX_Data();
  1096. break;
  1097. case "Update"://修改
  1098. if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(ultNo.Text.Trim()))
  1099. {
  1100. DialogResult result;
  1101. string mk = "确实要修改吗?";
  1102. result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo,
  1103. MessageBoxIcon.Question);
  1104. if (result == DialogResult.Yes)
  1105. {
  1106. if (ultraGrid1.ActiveRow != null)
  1107. {
  1108. try
  1109. {
  1110. DateTime aa = Convert.ToDateTime(ute_RLSJ.Text.ToString());
  1111. string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim();
  1112. // UpdateDataRow(strXH);
  1113. GetRLMX_Data();
  1114. }
  1115. catch
  1116. {
  1117. MessageBox.Show("入炉时间 不是合法的日期时间!\n\n请重新选择入炉时间!", "提示");
  1118. }
  1119. }
  1120. else
  1121. {
  1122. MessageBox.Show("请选择需要修改的记录!", "提示");
  1123. }
  1124. }
  1125. }
  1126. else
  1127. MessageBox.Show("请选择需要修改的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1128. break;
  1129. case "Delete"://删除
  1130. if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(this.ultNo.Text.Trim()))
  1131. {
  1132. DialogResult result;
  1133. string mk = "确实要删除吗?";
  1134. result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo,
  1135. MessageBoxIcon.Question);
  1136. if (result == DialogResult.Yes)
  1137. {
  1138. string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim();
  1139. DeleteDataRow();
  1140. GetRLMX_Data();
  1141. }
  1142. }
  1143. else
  1144. {
  1145. MessageBox.Show("请选择要删除的行!", "提示");
  1146. }
  1147. break;
  1148. case "Query":// 查询
  1149. if (ultraTabControl1.SelectedTab.Key == "Plan")
  1150. {
  1151. GetZL_SCJH();
  1152. }
  1153. else
  1154. {
  1155. GetRLMX_Data();
  1156. }
  1157. break;
  1158. case "Config":
  1159. try
  1160. {
  1161. frmSteelConfiger config = new frmSteelConfiger(ob);
  1162. config.Tag = this;
  1163. config.WorkShopNo = workshopNo;
  1164. config.ShowDialog();
  1165. }
  1166. catch (Exception ex)
  1167. {
  1168. MessageBox.Show(ex.Message);
  1169. }
  1170. break;
  1171. case "Export"://导出Excel
  1172. try
  1173. {
  1174. Core.Mes.Client.Comm.Globals.ulGridToExcel(ultraGrid1, Text);
  1175. }
  1176. catch (Exception ex)
  1177. {
  1178. MessageBox.Show(ex.Message);
  1179. }
  1180. break;
  1181. case "Cancel"://取消发送
  1182. try
  1183. {
  1184. CancelSend();
  1185. }
  1186. catch (Exception ex)
  1187. {
  1188. MessageBox.Show(ex.Message);
  1189. }
  1190. break;
  1191. case "Exit":
  1192. this.Close();
  1193. break;
  1194. default:
  1195. break;
  1196. }
  1197. }
  1198. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  1199. {
  1200. try
  1201. {
  1202. if (this.ultraGrid1.Rows.Count == 0 || this.ultraGrid1.ActiveRow == null)
  1203. {
  1204. return;
  1205. }
  1206. UltraGridRow row = null;
  1207. if (ultraGrid1.ActiveRow.HasParent())
  1208. {
  1209. row = ultraGrid1.ActiveRow.ParentRow;
  1210. }
  1211. else
  1212. {
  1213. row = ultraGrid1.ActiveRow;
  1214. }
  1215. SetDetailToolBarEnable(false,"");
  1216. setToolEnable(true);
  1217. ClearData();
  1218. ultNo.Text = row.Cells["JOBID"].Value.ToString();
  1219. ute_LH.Text = row.Cells["HEATNO"].Value.ToString();
  1220. utlcbdevNo.Text = row.Cells["STATIONCODE"].Value.ToString();
  1221. ute_DH2.Text = row.Cells["CHARGENO"].Value.ToString();
  1222. ute_RLSJ.Text = row.Cells["JOBDATE"].Value.ToString();
  1223. ute_RLZL.Text = row.Cells["JOINSTOVEWGT"].Value.ToString();
  1224. ute_DZ.Text = row.Cells["CHUTEWGT"].Value.ToString();
  1225. ute_ZZ.Text = row.Cells["TOTALWGT"].Value.ToString();
  1226. ute_BZ.Text = row.Cells["MEMO"].Value.ToString();
  1227. cbb_BC.Text = row.Cells["SHIFTCODE"].Value.ToString();
  1228. if (row.HasChild())
  1229. {
  1230. string matercode = "";
  1231. string matername = "";
  1232. string matervalue = "";
  1233. int m=0;
  1234. for (int i = 0; i < row.ChildBands["Band 1"].Rows.Count; i++)
  1235. {
  1236. matercode = row.ChildBands["Band 1"].Rows[i].Cells["SCRAPSTEELCODE"].Value.ToString();
  1237. matername = row.ChildBands["Band 1"].Rows[i].Cells["SCRAPSTEELNAME"].Value.ToString();
  1238. matervalue = row.ChildBands["Band 1"].Rows[i].Cells["JMWGT"].Value.ToString();
  1239. try
  1240. {
  1241. ((UltraLabel)EditorNameList[i]).Tag = matercode;
  1242. ((UltraLabel)EditorNameList[i]).Text = matername;
  1243. ((UltraTextEditor)EditorValueList[i]).Text = matervalue;
  1244. m++;
  1245. }
  1246. catch { }
  1247. }
  1248. for (int j = m; j < EditorNameList.Count; j++)
  1249. {
  1250. ((UltraLabel)EditorNameList[j]).Text="";
  1251. }
  1252. setMaterEnable();
  1253. }
  1254. }
  1255. catch { }
  1256. }
  1257. private void ute_RLSJ_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1258. {
  1259. try
  1260. {
  1261. frmSetTime frm = new frmSetTime(e.Context);
  1262. //frm.Location = ClsControlPack.GetChildWindowLocation(frm.Size);
  1263. frm.Location = new Point(556,376);//ClsControlPack.GetChildWindowLocation(frm.Size);
  1264. frm.AutoSize = true;
  1265. if (frm.ShowDialog() == DialogResult.OK)
  1266. {
  1267. ute_RLSJ.Text = (Convert.ToDateTime(frm.SelectDate.ToString())).ToString("yyyy-MM-dd HH:mm:ss");
  1268. ute_RLSJ.Update();
  1269. }
  1270. }
  1271. catch{}
  1272. }
  1273. // 发送废钢到1#或3#转炉
  1274. /// <summary>
  1275. /// 发送废钢到1#或3#转炉
  1276. /// </summary>
  1277. /// <param name="sender"></param>
  1278. /// <param name="e"></param>
  1279. private void button1_Click(object sender, EventArgs e)
  1280. {
  1281. try
  1282. {
  1283. string v_LH = this.ute_ZL1.Text.Trim().ToString();
  1284. if (v_LH.Length == 0)
  1285. {
  1286. if (workshopNo == "1")
  1287. {
  1288. MessageBox.Show("1#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1289. }
  1290. else
  1291. {
  1292. MessageBox.Show("3#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1293. }
  1294. return;
  1295. }
  1296. if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
  1297. {
  1298. MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1299. return;
  1300. }
  1301. if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
  1302. {
  1303. MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1304. return;
  1305. }
  1306. if (ute_ZL1.Appearance.BackColor == Color.LightBlue)
  1307. {
  1308. DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
  1309. if (dr == DialogResult.No) return;
  1310. }
  1311. this.ultraGrid1.DisplayLayout.Bands[0].Override.WrapHeaderText = Infragistics.Win.DefaultableBoolean.True;
  1312. string v_XH = this.ultNo.Text.Trim();
  1313. string v_RLZL = ute_RLZL.Text.Trim();
  1314. string v_ZLH = "";
  1315. if (workshopNo == "1")
  1316. {
  1317. v_ZLH = "01";
  1318. }
  1319. else
  1320. {
  1321. v_ZLH = "03";
  1322. }
  1323. if (v_RLZL == "0" || v_RLZL == "")
  1324. {
  1325. MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1326. return;
  1327. }
  1328. if (v_XH == "")
  1329. {
  1330. MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1331. return;
  1332. }
  1333. string strErr = "";
  1334. string strSqlID = "frmScrapMater.Send";
  1335. object[] sArgs = new object[3];
  1336. sArgs[0] = v_LH; //炉号
  1337. sArgs[1] = v_ZLH; //炉座号
  1338. sArgs[2] = v_XH; //序号
  1339. CommonClientToServer ccTs = new CommonClientToServer();
  1340. ccTs.ob = ob;
  1341. string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
  1342. "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
  1343. if (strErr != "")
  1344. {
  1345. MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1346. return;
  1347. }
  1348. else
  1349. {
  1350. GetRLMX_Data();
  1351. if (workshopNo == "1")
  1352. {
  1353. _strSendSucceededForBof1 = "Y";
  1354. HeatNo_HudwId_Exist(v_LH, "01");
  1355. }
  1356. else
  1357. {
  1358. _strSendSucceededForBof3 = "Y";
  1359. HeatNo_HudwId_Exist(v_LH, "03");
  1360. }
  1361. MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1362. }
  1363. }
  1364. catch { }
  1365. }
  1366. // 发送废钢到2#或4#转炉
  1367. /// <summary>
  1368. /// 发送废钢到2#或4#转炉
  1369. /// </summary>
  1370. /// <param name="sender"></param>
  1371. /// <param name="e"></param>
  1372. private void button2_Click(object sender, EventArgs e)
  1373. {
  1374. try
  1375. {
  1376. string v_LH = this.ute_ZL2.Text.Trim().ToString();
  1377. if (v_LH.Length == 0)
  1378. {
  1379. if (workshopNo == "1")
  1380. {
  1381. MessageBox.Show("2#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1382. }
  1383. else
  1384. {
  1385. MessageBox.Show("4#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1386. }
  1387. return;
  1388. }
  1389. if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
  1390. {
  1391. MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1392. return;
  1393. }
  1394. if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
  1395. {
  1396. MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1397. return;
  1398. }
  1399. if (ute_ZL2.Appearance.BackColor == Color.LightBlue)
  1400. {
  1401. DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
  1402. if (dr == DialogResult.No) return;
  1403. }
  1404. string v_XH = this.ultNo.Text.Trim();
  1405. string v_RLZL = ute_RLZL.Text.Trim();
  1406. string v_ZLH = "";
  1407. if (workshopNo == "1")
  1408. {
  1409. v_ZLH = "02";
  1410. }
  1411. else
  1412. {
  1413. v_ZLH = "04";
  1414. }
  1415. if (v_RLZL == "0" || v_RLZL == "")
  1416. {
  1417. MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1418. return;
  1419. }
  1420. if (v_XH == "")
  1421. {
  1422. MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1423. return;
  1424. }
  1425. string strErr = "";
  1426. string strSqlID = "frmScrapMater.Send";
  1427. object[] sArgs = new object[3];
  1428. sArgs[0] = v_LH; //炉号
  1429. sArgs[1] = v_ZLH; //炉座号
  1430. sArgs[2] = v_XH; //序号
  1431. CommonClientToServer ccTs = new CommonClientToServer();
  1432. ccTs.ob = ob;
  1433. string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
  1434. "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
  1435. if (strErr != "")
  1436. {
  1437. MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1438. return;
  1439. }
  1440. else
  1441. {
  1442. GetRLMX_Data();
  1443. if (workshopNo == "1")
  1444. {
  1445. _strSendSucceededForBof2 = "Y";
  1446. HeatNo_HudwId_Exist(v_LH, "02");
  1447. }
  1448. else
  1449. {
  1450. _strSendSucceededForBof4 = "Y";
  1451. HeatNo_HudwId_Exist(v_LH, "04");
  1452. }
  1453. MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1454. }
  1455. }
  1456. catch { }
  1457. }
  1458. // 发送废钢到5#转炉
  1459. /// <summary>
  1460. /// 发送废钢到5#转炉
  1461. /// </summary>
  1462. /// <param name="sender"></param>
  1463. /// <param name="e"></param>
  1464. private void button3_Click(object sender, EventArgs e)
  1465. {
  1466. try
  1467. {
  1468. string v_LH = this.ute_ZL3.Text.Trim().ToString();
  1469. if (v_LH.Length == 0)
  1470. {
  1471. MessageBox.Show("5#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1472. return;
  1473. }
  1474. if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
  1475. {
  1476. MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1477. return;
  1478. }
  1479. if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
  1480. {
  1481. MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1482. return;
  1483. }
  1484. if (ute_ZL3.Appearance.BackColor == Color.LightBlue)
  1485. {
  1486. DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
  1487. if (dr == DialogResult.No) return;
  1488. }
  1489. string v_XH = this.ultNo.Text.Trim();
  1490. string v_RLZL = ute_RLZL.Text.Trim();
  1491. string v_ZLH = "05";
  1492. if (v_RLZL == "0" || v_RLZL == "")
  1493. {
  1494. MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1495. return;
  1496. }
  1497. if (v_XH == "")
  1498. {
  1499. MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1500. return;
  1501. }
  1502. string strErr = "";
  1503. string strSqlID = "frmScrapMater.Send";
  1504. object[] sArgs = new object[3];
  1505. sArgs[0] = v_LH; //炉号
  1506. sArgs[1] = v_ZLH; //炉座号
  1507. sArgs[2] = v_XH; //序号
  1508. CommonClientToServer ccTs = new CommonClientToServer();
  1509. ccTs.ob = ob;
  1510. string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
  1511. "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
  1512. if (strErr != "")
  1513. {
  1514. MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1515. return;
  1516. }
  1517. else
  1518. {
  1519. GetRLMX_Data();
  1520. _strSendSucceededForBof5 = "Y";
  1521. HeatNo_HudwId_Exist(v_LH, "05");
  1522. MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1523. }
  1524. }
  1525. catch { }
  1526. }
  1527. // 选择生产计划隐藏相应功能
  1528. /// <summary>
  1529. /// 选择生产计划隐藏相应功能
  1530. /// </summary>
  1531. /// <param name="sender"></param>
  1532. /// <param name="e"></param>
  1533. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1534. {
  1535. if (e.Tab.Index == 1)
  1536. GetZL_SCJH();
  1537. if (ultraTabControl1.SelectedTab.Key == "Plan")
  1538. {
  1539. ultraToolbarsManager1.Enabled = false;
  1540. this.ToolBarItemEnable(this, "Cancel", false);
  1541. this.ToolBarItemEnable(this, "Export", false);
  1542. label28.Text = "计划开始时间";
  1543. label2.Text = "计划结束时间";
  1544. groupBox6.Size=new System.Drawing.Size(228, 40);
  1545. label1.Text = "生产状态";
  1546. label1.BackColor = Color.LightGreen;
  1547. label18.Text = "计划状态";
  1548. label18.BackColor = Color.White;
  1549. label3.Text = "结束状态";
  1550. label3.Visible = true;
  1551. checkBox1.Enabled = false;
  1552. chkSend.Enabled = false;
  1553. udte_EndTime.Location = new Point(317, 11);
  1554. if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
  1555. {
  1556. //MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1557. udte_EndTime.Focus();
  1558. return;
  1559. }
  1560. GetZL_SCJH();
  1561. }
  1562. else
  1563. {
  1564. ultraToolbarsManager1.Enabled = true;
  1565. this.ToolBarItemEnable(this, "Cancel", true);
  1566. this.ToolBarItemEnable(this, "Export", true);
  1567. label28.Text = "入炉时间 从";
  1568. label2.Text = "到";
  1569. groupBox6.Size = new System.Drawing.Size(163, 40);
  1570. label18.Text = "已发送";
  1571. label18.BackColor = Color.LightGreen;
  1572. label1.Text = "未发送";
  1573. label1.BackColor = Color.LightCyan;
  1574. label3.Visible = false;
  1575. chkSend.Enabled = true;
  1576. checkBox1.Enabled = true;
  1577. udte_EndTime.Location = new Point(265, 11);
  1578. if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
  1579. {
  1580. // MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1581. udte_EndTime.Focus();
  1582. return;
  1583. }
  1584. GetRLMX_Data();
  1585. }
  1586. }
  1587. private void ultraGrid3_Click(object sender, EventArgs e)
  1588. {
  1589. }
  1590. private void ultraGrid2_Click(object sender, EventArgs e)
  1591. {
  1592. DialogResult dgr = new DialogResult();
  1593. if (ultraGrid2.ActiveRow != null)
  1594. {
  1595. ute_LH.Text = ultraGrid2.ActiveRow.Cells["StoveID"].Value.ToString();
  1596. utlcbdevNo.SelectedIndex = 0;
  1597. string ShiftCode = "", str = "";
  1598. if (dgr != DialogResult.Cancel)
  1599. {
  1600. //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
  1601. ArrayList arry = new ArrayList();
  1602. arry.Add("GetClassCode.query");
  1603. CommonClientToServer ccs = new CommonClientToServer();
  1604. ccs.ob = this.ob;
  1605. //arry.Add("");
  1606. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
  1607. if (ds.Tables[0].Rows.Count > 0)
  1608. {
  1609. ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
  1610. }
  1611. if (!string.IsNullOrEmpty(ShiftCode))
  1612. {
  1613. cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
  1614. }
  1615. }
  1616. }
  1617. }
  1618. private void ultraGrid4_Click(object sender, EventArgs e)
  1619. {
  1620. DialogResult dgr = new DialogResult();
  1621. if (ultraGrid4.ActiveRow != null)
  1622. {
  1623. ute_LH.Text = ultraGrid4.ActiveRow.Cells["StoveID"].Value.ToString();
  1624. utlcbdevNo.SelectedIndex = 2;
  1625. string ShiftCode = "", str = "";
  1626. if (dgr != DialogResult.Cancel)
  1627. {
  1628. //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
  1629. ArrayList arry = new ArrayList();
  1630. arry.Add("GetClassCode.query");
  1631. CommonClientToServer ccs = new CommonClientToServer();
  1632. ccs.ob = this.ob;
  1633. //arry.Add("");
  1634. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
  1635. if (ds.Tables[0].Rows.Count > 0)
  1636. {
  1637. ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
  1638. }
  1639. if (!string.IsNullOrEmpty(ShiftCode))
  1640. {
  1641. cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
  1642. }
  1643. }
  1644. }
  1645. }
  1646. private void ute_RLSJ_KeyPress(object sender, KeyPressEventArgs e)
  1647. {
  1648. if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '\b'))
  1649. {
  1650. e.Handled = true;
  1651. }
  1652. }
  1653. private void ute_ZZ_ValueChanged(object sender, EventArgs e)
  1654. {
  1655. Double dRlzl = 0, dDz = 0, dFg = 0; //入炉重量,斗重, 废钢重量
  1656. try
  1657. {
  1658. //废钢重量
  1659. if (!string.IsNullOrEmpty(materValue1.Text.Trim()))
  1660. {
  1661. dFg += Convert.ToDouble(materValue1.Text.Trim());
  1662. }
  1663. if (!string.IsNullOrEmpty(materValue2.Text.Trim()))
  1664. {
  1665. dFg += Convert.ToDouble(materValue2.Text.Trim());
  1666. }
  1667. if (!string.IsNullOrEmpty(materValue3.Text.Trim()))
  1668. {
  1669. dFg += Convert.ToDouble(materValue3.Text.Trim());
  1670. }
  1671. if (!string.IsNullOrEmpty(materValue4.Text.Trim()))
  1672. {
  1673. dFg += Convert.ToDouble(materValue4.Text.Trim());
  1674. }
  1675. if (!string.IsNullOrEmpty(materValue5.Text.Trim()))
  1676. {
  1677. dFg += Convert.ToDouble(materValue5.Text.Trim());
  1678. }
  1679. if (!string.IsNullOrEmpty(materValue6.Text.Trim()))
  1680. {
  1681. dFg += Convert.ToDouble(materValue6.Text.Trim());
  1682. }
  1683. if (!string.IsNullOrEmpty(ute_DZ.Text.Trim()))
  1684. {
  1685. dDz += Convert.ToDouble(ute_DZ.Text.Trim());
  1686. }
  1687. dRlzl = dFg;//入炉重量
  1688. if (dRlzl == 0)
  1689. {
  1690. if (!string.IsNullOrEmpty(ute_RLZL.Text.Trim()))
  1691. {
  1692. dRlzl = Convert.ToDouble(ute_RLZL.Text.Trim());
  1693. }
  1694. }
  1695. ute_RLZL.Text = Convert.ToString(dRlzl); //入炉重量
  1696. ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量
  1697. }
  1698. catch
  1699. {
  1700. }
  1701. }
  1702. private void ute_RLZL_ValueChanged(object sender, EventArgs e)
  1703. {
  1704. try
  1705. {
  1706. string strRlzl = ute_RLZL.Text.Trim();
  1707. if (ute_RLZL.Focused)
  1708. {
  1709. for (int i = 0; i < EditorValueList.Count; i++)
  1710. {
  1711. ((Infragistics.Win.UltraWinEditors.UltraTextEditor)EditorValueList[i]).Text = "0";
  1712. }
  1713. Double dRlzl = 0, dDz = 0;
  1714. if (!string.IsNullOrEmpty(strRlzl))
  1715. {
  1716. dDz += Convert.ToDouble(strRlzl);
  1717. }
  1718. if (!string.IsNullOrEmpty(ute_DZ.Text.Trim()))
  1719. {
  1720. dDz += Convert.ToDouble(ute_DZ.Text.Trim());
  1721. }
  1722. ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量
  1723. }
  1724. }
  1725. catch { }
  1726. }
  1727. private void NumberInput_KeyPress(object sender, KeyPressEventArgs e)
  1728. {
  1729. if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.'))
  1730. {
  1731. e.Handled = true;
  1732. }
  1733. char[] arrary = ((UltraTextEditor)sender).Text.ToCharArray();
  1734. if (e.KeyChar == '.')
  1735. {
  1736. if (arrary.Length == 0)
  1737. {
  1738. ((UltraTextEditor)sender).Text = "0.";
  1739. ((UltraTextEditor)sender).SelectionStart = ((UltraTextEditor)sender).Text.Trim().Length;
  1740. e.Handled = true;
  1741. }
  1742. else
  1743. {
  1744. for (int i = 0; i < arrary.Length; i++)
  1745. {
  1746. if (arrary[i] == '.')
  1747. e.Handled = true;
  1748. }
  1749. }
  1750. }
  1751. if (arrary.Length == 1)
  1752. {
  1753. if (e.KeyChar == '0')
  1754. {
  1755. if (arrary[0] == '0')
  1756. e.Handled = true;
  1757. }
  1758. if (arrary[0] == '0' && e.KeyChar != '.' && e.KeyChar != '\b' && e.KeyChar != '0'&&!(Char.IsNumber(e.KeyChar)))
  1759. {
  1760. ((UltraTextEditor)sender).Text = e.KeyChar.ToString();
  1761. ((UltraTextEditor)sender).SelectionStart = ((UltraTextEditor)sender).Text.Trim().Length;
  1762. e.Handled = true;
  1763. }
  1764. }
  1765. }
  1766. private void HeatNoInput_KeyPress(object sender, KeyPressEventArgs e)
  1767. {
  1768. if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b'))
  1769. {
  1770. e.Handled = true;
  1771. }
  1772. }
  1773. private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  1774. {
  1775. string Job_ID = ultNo.Text.Trim();
  1776. switch (e.Tool.Key)
  1777. {
  1778. case "add":
  1779. // ClearData1();
  1780. SetDetailToolBarEnable(true,"add");
  1781. setToolEnable(false);
  1782. this.uTbMTool.Tools["ok"].Tag = "add";
  1783. ultNo.Clear();
  1784. ute_LH.Clear();
  1785. utlcbdevNo.SelectedIndex = -1;
  1786. ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  1787. for (int i = 0; i < EditorValueList.Count; i++)
  1788. {
  1789. ((Infragistics.Win.UltraWinEditors.UltraTextEditor)EditorValueList[i]).Text = "0";
  1790. }
  1791. ute_RLZL.Text = "0";
  1792. ute_DZ.Text = "0";
  1793. ute_ZZ.Text = "0";
  1794. break;
  1795. case "edit":
  1796. if (ultraGrid1.Rows.Count==0)
  1797. {
  1798. MessageBox.Show("无有效信息可以修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1799. return;
  1800. }
  1801. if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen || ute_LH.Text.Trim() != "")
  1802. {
  1803. MessageBox.Show("选取的废钢信息已发送不能修改!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  1804. return;
  1805. }
  1806. SetDetailToolBarEnable(true,"edit");
  1807. setToolEnable(false);
  1808. this.uTbMTool.Tools["ok"].Tag = "edit";
  1809. break;
  1810. case "del":
  1811. if (Job_ID.Length == 0)
  1812. {
  1813. MessageBox.Show("无有效的数据可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  1814. return;
  1815. }
  1816. DeleteDataRow();
  1817. break;
  1818. case "ok":
  1819. string flag = this.uTbMTool.Tools["ok"].Tag.ToString();
  1820. if (flag == "edit")
  1821. {
  1822. if (Job_ID.Length == 0)
  1823. {
  1824. MessageBox.Show("无有效的数据可操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  1825. return;
  1826. }
  1827. }
  1828. if (flag == "add")
  1829. {
  1830. AddNewData();
  1831. }
  1832. if (flag == "edit")
  1833. {
  1834. UpdateDataRow(Job_ID);
  1835. }
  1836. if (!ok_flag) return;
  1837. SetDetailToolBarEnable(false,"");
  1838. setToolEnable(true);
  1839. GetRLMX_Data();
  1840. break;
  1841. case "cancel":
  1842. SetDetailToolBarEnable(false,"");
  1843. setToolEnable(true);
  1844. ultraGrid1_AfterRowActivate(null,null);
  1845. break;
  1846. case "left":
  1847. if (ultraGrid1.Rows.Count == 0) return;
  1848. //将位置移动到前一条记录
  1849. try
  1850. {
  1851. if (ultraGrid1.ActiveRow == null)
  1852. {
  1853. ultraGrid1.Rows[0].Activate();
  1854. }
  1855. else
  1856. {
  1857. int nIndex = ultraGrid1.ActiveRow.Index;
  1858. nIndex = nIndex - 1;
  1859. if (nIndex < 0) nIndex = ultraGrid1.Rows.Count-1;
  1860. ultraGrid1.Rows[nIndex].Activate();
  1861. }
  1862. }
  1863. catch { }
  1864. break;
  1865. case "right":
  1866. if (ultraGrid1.Rows.Count == 0) return;
  1867. //将位置移动到后一条记录
  1868. try
  1869. {
  1870. if (ultraGrid1.ActiveRow == null)
  1871. {
  1872. ultraGrid1.Rows[0].Activate();
  1873. }
  1874. else
  1875. {
  1876. int nIndex = ultraGrid1.ActiveRow.Index;
  1877. nIndex = nIndex + 1;
  1878. if (nIndex >= ultraGrid1.Rows.Count) nIndex = 0;
  1879. ultraGrid1.Rows[nIndex].Activate();
  1880. }
  1881. }
  1882. catch { }
  1883. break;
  1884. case "Custom": //初始化物料
  1885. try
  1886. {
  1887. GetConfigMater();
  1888. materValue1.Text = "";
  1889. materValue2.Text = "";
  1890. materValue3.Text = "";
  1891. materValue4.Text = "";
  1892. materValue5.Text = "";
  1893. materValue6.Text = "";
  1894. }
  1895. catch { }
  1896. break;
  1897. }
  1898. }
  1899. private void chkSend_CheckedChanged(object sender, EventArgs e)
  1900. {
  1901. GetRLMX_Data();
  1902. }
  1903. }
  1904. }