CStaticMethod.cs.svn-base 43 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using System.Drawing;
  5. using System.Data;
  6. using System.Windows.Forms;
  7. using System.Collections;
  8. using CoreFS.CA06;
  9. using Core.LgMes.Client.lgClassModel;
  10. using Infragistics.Win.UltraWinGrid;
  11. using System.Runtime.InteropServices;
  12. namespace Core.LgMes.Client.LgJobMgt
  13. {
  14. public class CStaticMethod
  15. {
  16. /// <summary>
  17. /// 设置控件样式
  18. /// </summary>
  19. /// <param name="ulgrid"></param>
  20. /// <param name="intFlag">颜色标致</param>
  21. public static void SetUltraGridStyle(UltraGrid ulgrid,int intFlag)
  22. {
  23. Color CardBackColor =Color.PapayaWhip;
  24. Color RowBackColor = Color.LightBlue;
  25. switch (intFlag)
  26. {
  27. case 1:
  28. CardBackColor = Color.Honeydew;// Color.LightCyan;
  29. break;
  30. case 2:
  31. CardBackColor = Color.PapayaWhip;
  32. break;
  33. default:
  34. break;
  35. }
  36. ulgrid.DisplayLayout.Override.CardAreaAppearance.BackColor = CardBackColor; //卡片样式背景
  37. ulgrid.DisplayLayout.Override.HeaderAppearance.BackColor = CardBackColor; //表头背景
  38. ulgrid.DisplayLayout.Override.RowAppearance.BackColor = RowBackColor; //行的背景色
  39. //ulgrid.DisplayLayout.Override.CellAppearance.FontData.Bold = Infragistics.Win.DefaultableBoolean.True; //单元格字体加粗
  40. ulgrid.DisplayLayout.BorderStyle = Infragistics.Win.UIElementBorderStyle.None; //设置边框
  41. }
  42. //==========================================================
  43. // 获取子窗体弹出的位置坐标
  44. //==========================================================
  45. public static Point GetChildWindowLocation(Size ChildWindowSize)
  46. {
  47. int width = Cursor.Position.X + ChildWindowSize.Width - Screen.PrimaryScreen.Bounds.Width;
  48. int height = Cursor.Position.Y + ChildWindowSize.Height - Screen.PrimaryScreen.Bounds.Height + 30;
  49. width = (width > 0) ? (Cursor.Position.X - width) : Cursor.Position.X; // X坐标
  50. height = (height > 0) ? (Cursor.Position.Y - height + 10) : (Cursor.Position.Y + 10); // Y坐标
  51. return new Point(width, height);
  52. }
  53. public static void ResetTableRows(ref DataTable ATable, int newRowsCount)
  54. {
  55. int arows = Math.Abs(ATable.Rows.Count - newRowsCount);
  56. string[] sTmp = new string[ATable.Columns.Count];
  57. if (ATable.Rows.Count < newRowsCount)
  58. {
  59. for (int i = 0; i < arows; i++)
  60. ATable.Rows.Add(sTmp);
  61. }
  62. else
  63. {
  64. for (int i = arows - 1; i >= 0; i--)
  65. ATable.Rows[i].Delete();
  66. }
  67. }
  68. public static void AppendTableRows(ref DataTable ATable, int newRowsCount)
  69. {
  70. string[] sTmp = new string[ATable.Columns.Count];
  71. for (int i = 0; i < newRowsCount; i++)
  72. ATable.Rows.Add(sTmp);
  73. }
  74. /// <summary>
  75. /// 获取熔炼号函数
  76. /// </summary>
  77. /// <param name="heatProcessNumb"></param>
  78. /// <returns></returns>
  79. public static string getSmeltingID(string heatProcessNumb)
  80. {
  81. heatProcessNumb = heatProcessNumb.Trim();
  82. if (heatProcessNumb == "")
  83. return "";
  84. string subStr = heatProcessNumb.Substring((int)OBJLEN.nHeatProcessNo-(int)OBJLEN.nHeatNo, (int)OBJLEN.nHeatNo);
  85. return subStr;
  86. }
  87. /// <summary>
  88. /// 获取脱硫号函数
  89. /// </summary>
  90. /// <param name="heatProcessNumb"></param>
  91. /// <returns></returns>
  92. public static string getHudwIdID(string heatProcessNumb)
  93. {
  94. heatProcessNumb = heatProcessNumb.Trim();
  95. if (heatProcessNumb == "")
  96. return "";
  97. string subStr = heatProcessNumb.Substring((int)OBJLEN.nHudwProcessNo - (int)OBJLEN.nHudwId, (int)OBJLEN.nHudwId);
  98. return subStr;
  99. }
  100. /// <summary>i
  101. /// 转换熔炼号为中间带-的化学检验号
  102. /// </summary>
  103. /// <param name="SmeltID"></param>
  104. /// <returns></returns>
  105. public static string ConvertSmeltID(string SmeltID)
  106. {
  107. if (SmeltID.Trim().Equals(string.Empty))
  108. return "";
  109. string szStr = SmeltID.Substring(0, 3) + "-" + SmeltID.Substring(SmeltID.Length - 5);
  110. return szStr;
  111. }
  112. /// <summary>
  113. /// 作业路线转换
  114. /// </summary>
  115. /// <param name="szZYLX"></param>
  116. /// <returns></returns>
  117. public static string ConvertJobRoute(string szZYLX)
  118. {
  119. ArrayList ar = new ArrayList();
  120. string szLX = "";
  121. int nLen = 0;
  122. while (szZYLX.Length > 0)
  123. {
  124. nLen = szZYLX.IndexOf("LG", 1);
  125. if (nLen > 0)
  126. {
  127. szLX = szZYLX.Substring(0, nLen);
  128. szZYLX = szZYLX.Substring(nLen);
  129. }
  130. else
  131. {
  132. szLX = szZYLX.Substring(0);
  133. szZYLX = "";
  134. }
  135. ar.Add(szLX);
  136. }
  137. for (int i = 0; i < ar.Count; i++)
  138. {
  139. switch (ar[i].ToString())
  140. {
  141. case "LG2020000":
  142. szZYLX += "转炉->";
  143. break;
  144. case "LG20200001":
  145. szZYLX += "1#转炉->";
  146. break;
  147. case "LG20200002":
  148. szZYLX += "2#转炉->";
  149. break;
  150. case "LG20200003":
  151. szZYLX += "3#转炉->";
  152. break;
  153. case "LG2030000":
  154. szZYLX += "钢包站->";
  155. break;
  156. case "LG20300001":
  157. szZYLX += "1#钢包站->";
  158. break;
  159. case "LG20300002":
  160. szZYLX += "2#钢包站->";
  161. break;
  162. case "LG20300003":
  163. szZYLX += "3#钢包站->";
  164. break;
  165. case "LG2040000":
  166. szZYLX += "精炼炉->";
  167. break;
  168. case "LG20400001":
  169. szZYLX += "1#精炼炉->";
  170. break;
  171. case "LG20400002":
  172. szZYLX += "2#精炼炉->";
  173. break;
  174. case "LG20400003":
  175. szZYLX += "3#精炼炉->";
  176. break;
  177. case "LG2050000":
  178. szZYLX += "连铸机";
  179. break;
  180. case "LG20500001":
  181. szZYLX += "1#连铸机";
  182. break;
  183. case "LG20500002":
  184. szZYLX += "2#连铸机";
  185. break;
  186. case "LG20500003":
  187. szZYLX += "3#连铸机";
  188. break;
  189. case "LG20500004":
  190. szZYLX += "4#连铸机";
  191. break;
  192. default:
  193. break;
  194. }
  195. }
  196. return szZYLX;
  197. }
  198. /// <summary>
  199. /// 获取当前班次
  200. /// </summary>
  201. /// <returns></returns>
  202. public static string GetCurrentClass(CoreFS.CA06.OpeBase ope)
  203. {
  204. string strErr = "";
  205. string strSqlID = "GetCurrDuty.Select";
  206. Core.Mes.Client.Common.CommonClientToServer ccs = new Core.Mes.Client.Common.CommonClientToServer();
  207. ccs.ob = ope;
  208. //获取班次班别信息
  209. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassCommonModule",
  210. "GetCurrDuty", strSqlID, out strErr);
  211. if (strErr == "" && ds != null)
  212. {
  213. if(ds.Tables[0]!=null && ds.Tables[0].Rows.Count>0)
  214. return ds.Tables[0].Rows[0][0].ToString();
  215. }
  216. return "";
  217. }
  218. /// <summary>
  219. /// 班次转换
  220. /// </summary>
  221. /// <returns></returns>
  222. public static string ClassConvert(string szClassID)
  223. {
  224. if (szClassID.Trim() == "")
  225. return "";
  226. if(szClassID.Length ==2)
  227. szClassID = szClassID.Substring(1);
  228. string szClassName = "";
  229. switch (szClassID)
  230. {
  231. case "1":
  232. szClassName = "甲";
  233. break;
  234. case "2":
  235. szClassName = "乙";
  236. break;
  237. case "3":
  238. szClassName = "丙";
  239. break;
  240. case "4":
  241. szClassName = "丁";
  242. break;
  243. default:
  244. break;
  245. }
  246. return szClassName;
  247. }
  248. /// <summary>
  249. /// 时间计算返回分
  250. /// </summary>
  251. /// <param name="startTime"></param>
  252. /// <param name="endTime"></param>
  253. /// <returns></returns>
  254. public static int caculateTime(DateTime startTime, DateTime endTime)
  255. {
  256. int lStayDuration = 0;
  257. TimeSpan odtSpan;
  258. if (endTime > startTime)
  259. {
  260. odtSpan = endTime - startTime;
  261. lStayDuration = Convert.ToInt32(System.Math.Round(odtSpan.TotalMinutes));
  262. }
  263. else if (startTime != endTime)
  264. {
  265. if (startTime > DateTime.Now)
  266. lStayDuration = 0;
  267. else
  268. {
  269. odtSpan = DateTime.Now - startTime;
  270. lStayDuration = Convert.ToInt32(System.Math.Round(odtSpan.TotalMinutes));
  271. }
  272. }
  273. return lStayDuration;
  274. }
  275. /// <summary>
  276. /// 时间计算返回秒
  277. /// </summary>
  278. /// <param name="startTime"></param>
  279. /// <param name="endTime"></param>
  280. /// <returns></returns>
  281. public static int caculateTimeSeconds(DateTime startTime, DateTime endTime)
  282. {
  283. int lStayDuration = 0;
  284. TimeSpan odtSpan;
  285. if (endTime > startTime)
  286. {
  287. odtSpan = endTime - startTime;
  288. lStayDuration = Convert.ToInt32(System.Math.Round(odtSpan.TotalSeconds));
  289. }
  290. else if (startTime != endTime)
  291. {
  292. if (startTime > DateTime.Now)
  293. lStayDuration = 0;
  294. else
  295. {
  296. odtSpan = DateTime.Now - startTime;
  297. lStayDuration = Convert.ToInt32(System.Math.Round(odtSpan.TotalSeconds));
  298. }
  299. }
  300. return lStayDuration;
  301. }
  302. /// <summary>
  303. /// 将秒转换成时间
  304. /// </summary>
  305. /// <param name="strSeconds"></param>
  306. /// <returns></returns>
  307. public static string caculateSecondsTime(string strSeconds)
  308. {
  309. string strTime = "0′0″";
  310. if (!string.IsNullOrEmpty(strSeconds) && strSeconds.Length > 0)
  311. {
  312. TimeSpan tsTime = new TimeSpan(0, 0, Convert.ToInt16(strSeconds));
  313. if (tsTime.Hours > 0)
  314. strTime = Convert.ToString(tsTime.Hours) + "′" + Convert.ToString(tsTime.Minutes)+ "′" + Convert.ToString(tsTime.Seconds) + "″";
  315. else
  316. strTime = Convert.ToString(tsTime.Minutes)+ "′" + Convert.ToString(tsTime.Seconds)+ "″";
  317. }
  318. return strTime;
  319. }
  320. /// <summary>
  321. /// 获取两个时间段的差值
  322. /// </summary>
  323. /// <param name="startTime"></param>
  324. /// <param name="endTime"></param>
  325. /// <returns></returns>
  326. public static int JudgeTime(DateTime startTime, DateTime endTime)
  327. {
  328. int lStayDuration = 0;
  329. TimeSpan odtSpan;
  330. if (endTime > startTime)
  331. {
  332. odtSpan = endTime - startTime;
  333. lStayDuration = Convert.ToInt32(System.Math.Round(odtSpan.TotalMinutes));
  334. }
  335. return lStayDuration;
  336. }
  337. /// <summary>
  338. /// 验证数据有效性(Number)
  339. /// </summary>
  340. /// <param name="szVal"></param>
  341. public static void CheckNumValidate(string szVal)
  342. {
  343. try
  344. {
  345. Convert.ToDecimal(szVal);
  346. }
  347. catch (Exception ex)
  348. {
  349. MessageBox.Show(ex.Message, "提示");
  350. }
  351. }
  352. /// <summary>
  353. /// 验证数据有效性(Double)
  354. /// </summary>
  355. /// <param name="AValue"></param>
  356. /// <returns></returns>
  357. public static bool IsDouble(string AValue)
  358. {
  359. try
  360. {
  361. Convert.ToDouble(AValue);
  362. return true;
  363. }
  364. catch
  365. {
  366. return false;
  367. }
  368. }
  369. /// <summary>
  370. /// 检查是否为当天的记录
  371. /// </summary>
  372. /// <param name="RemotingHelp"></param>
  373. /// <param name="szGW"></param>
  374. /// <param name="szBC"></param>
  375. /// <returns></returns>
  376. public static bool CheckIsTodayNote( string szTableName, string szWhere)
  377. {
  378. try
  379. {
  380. string szOut = "";//, szWhere = "";
  381. #region "在数据库里面查找炉号是否为当天生成的炉号记录"
  382. //szWhere = " where to_char(czsj, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd') and lh='"+szLH+"'";
  383. //CallingMessage par = new CallingMessage();
  384. //par.ServerName = "lgResMgt";
  385. //par.AssemblyName = "Core.QG.Server.InfoCollect";
  386. //par.ClassName = "Core.QG.Server.InfoCollect.SendCommand";
  387. //par.MethodName = "QueryStove";
  388. //par.args = new object[] { szTableName, szWhere };
  389. object obj = null;// RemotingHelp.ExecuteMethod(par, out szOut);
  390. if (szOut == "" && obj != null)
  391. {
  392. DataTable dt = ((DataSet)obj).Tables[0];
  393. if (dt.Rows.Count > 0)
  394. {
  395. return true;
  396. }
  397. else
  398. {
  399. return false;
  400. }
  401. }
  402. #endregion
  403. }
  404. catch { }
  405. return false;
  406. }
  407. /// <summary>
  408. /// 检查是否有修改权限
  409. /// </summary>
  410. /// <param name="RemotingHelp"></param>
  411. /// <param name="szTableName"></param>
  412. /// <param name="szWhere"></param>
  413. /// <returns></returns>
  414. public static bool CheckIsPurview()
  415. {
  416. try
  417. {
  418. string szOut = "";//, szWhere = "";
  419. #region ""
  420. CoreFS.CA06.FrmBase ccf = new FrmBase();
  421. string szWhere = " and a.loginid='" + ccf.UserInfo.GetUserID() +"'";
  422. //CallingMessage par = new CallingMessage();
  423. //par.ServerName = "lgResMgt";
  424. //par.AssemblyName = "Core.QG.Server.InfoCollect";
  425. //par.ClassName = "Core.QG.Server.InfoCollect.SendCommand";
  426. //par.MethodName = "QueryUpdatePurview";
  427. //par.args = new object[] { szWhere };
  428. object obj = null;// RemotingHelp.ExecuteMethod(par, out szOut);
  429. if (szOut == "" && obj != null)
  430. {
  431. DataTable dt = ((DataSet)obj).Tables[0];
  432. if (dt.Rows.Count > 0 && dt.Rows[0]["UPDATEFLAG"].ToString() == "1")
  433. {
  434. return true;
  435. }
  436. else
  437. {
  438. return false;
  439. }
  440. }
  441. #endregion
  442. }
  443. catch { }
  444. return false;
  445. }
  446. /// <summary>
  447. /// 设置元素标准值
  448. /// </summary>
  449. /// <param name="row">表行数</param>
  450. /// <param name="dr">行记录</param>
  451. /// <param name="dt">被设置的表</param>
  452. public static void SetStandardElemData(int row, DataRow dr, ref DataTable dt)
  453. {
  454. try
  455. {
  456. // 取得元素名称
  457. string szEleName = dr["itemcode"].ToString();
  458. dt.Rows[row]["TYPESYMBOL"] = dr["STDSTYLE"].ToString() == "1" ? "内控" : (dr["STDSTYLE"].ToString() == "2" ? "放行" : "特殊");
  459. if (dr["stdmax"].ToString() != "" && dr["stdmin"].ToString() != "")
  460. dt.Rows[row][szEleName] = dr["stdmin"].ToString() + "~" + dr["stdmax"].ToString();
  461. else if (dr["stdmax"].ToString() != "" && dr["stdmin"].ToString() == "")
  462. dt.Rows[row][szEleName] = "≤ " + dr["stdmax"].ToString();
  463. else if (dr["stdmax"].ToString() == "" && dr["stdmin"].ToString() != "")
  464. dt.Rows[row][szEleName] = "> " + dr["stdmin"].ToString();
  465. }
  466. catch { }
  467. }
  468. /// <summary>
  469. /// 设置化学元素实时值
  470. /// </summary>
  471. /// <param name="row"></param>
  472. /// <param name="obj"></param>
  473. /// <param name="key"></param>
  474. /// <param name="dt"></param>
  475. public static void SetCraftElemGridData(int row, JOB_CHEMELEMENT obj, string key, ref DataTable dt)
  476. {
  477. try
  478. {
  479. dt.Rows[0]["TYPESYMBOL"] = "内控";
  480. dt.Rows[1]["TYPESYMBOL"] = "放行";
  481. dt.Rows[2]["TYPESYMBOL"] = "特殊";
  482. if (row < dt.Rows.Count)
  483. {
  484. dt.Rows[row]["TYPESYMBOL"] = key;
  485. dt.Rows[row]["C"] = obj.C;
  486. dt.Rows[row]["Si"] = obj.SI;
  487. dt.Rows[row]["Mn"] = obj.MN;
  488. dt.Rows[row]["P"] = obj.P;
  489. dt.Rows[row]["S"] = obj.S;
  490. dt.Rows[row]["Als"] = obj.ALS;
  491. dt.Rows[row]["V"] = obj.V;
  492. dt.Rows[row]["Nb"] = obj.NB;
  493. dt.Rows[row]["Ti"] = obj.TI;
  494. dt.Rows[row]["Ca"] = obj.CA;
  495. dt.Rows[row]["B"] = obj.B;
  496. dt.Rows[row]["Asn"] = obj.ASN;
  497. dt.Rows[row]["Sn"] = obj.SN;
  498. dt.Rows[row]["Cu"] = obj.CU;
  499. dt.Rows[row]["Sb"] = obj.SB;
  500. dt.Rows[row]["Alt"] = obj.ALT;
  501. dt.Rows[row]["Cr"] = obj.CR;
  502. dt.Rows[row]["Ni"] = obj.NI;
  503. dt.Rows[row]["Mo"] = obj.MO;
  504. dt.Rows[row]["O"] = obj.O;
  505. dt.Rows[row]["N"] = obj.N;
  506. dt.Rows[row]["H"] = obj.H;
  507. dt.Rows[row]["Ceq"] = obj.CEQ;
  508. dt.Rows[row]["Pcm"] = obj.PCM;
  509. dt.Rows[row]["Cev"] = obj.CEV;
  510. }
  511. //C、Si、Mn、P、S、Als、V、Nb、Ti、As、Sn、Cu、Sb、Alt、O、N、H
  512. }
  513. catch (Exception ex)
  514. {
  515. string Msg = ex.Message;
  516. }
  517. }
  518. /// <summary>
  519. /// 设置温度实时值
  520. /// </summary>
  521. /// <param name="dt"></param>
  522. public static void SetGridTemperature(ref DataTable dt, string szXMM, string szSDFW, string szSJZ, int row)
  523. {
  524. dt.Rows[row]["项目名"] = szXMM;
  525. dt.Rows[row]["设定范围"] = szSDFW;
  526. dt.Rows[row]["实际值"] = szSJZ;
  527. }
  528. /// <summary>
  529. /// 设置温度实时值
  530. /// </summary>
  531. /// <param name="dt"></param>
  532. public static void SetGridTemperature(ref DataTable dt, string szXmm, string szSDFW,string szSJZ,string szDate, int row)
  533. {
  534. dt.Rows[row]["项目名"] = szXmm;
  535. dt.Rows[row]["设定范围"] = szSDFW;
  536. dt.Rows[row]["实际值"] = szSJZ;
  537. dt.Rows[row]["采样时间"] =szDate;
  538. }
  539. /// <summary>
  540. /// 与标准值进行比对
  541. /// </summary>
  542. /// <param name="dtStd">工艺标准表</param>
  543. /// <param name="dtSource">被填充数据源的表</param>
  544. /// <param name="szCode">比对的编码</param>
  545. /// <param name="uGrd">被填充数据的GRID</param>
  546. /// <param name="uGrd">被填充的数据行</param>
  547. /// <param name="strName">岗位编码</param>
  548. public static void CompareStandard(DataTable dtStd, ref DataTable dtSource, string szCode, ref Infragistics.Win.UltraWinGrid.UltraGrid uGrd, int row,string strName)
  549. {
  550. DataRow[] dr = null;
  551. Decimal dZXZ = 0, dZDZ = 0, dVal = 0;
  552. if (dtStd != null && dtStd.Rows.Count > 0)
  553. {
  554. try
  555. {
  556. dr = dtStd.Select(" ITEM1 = '" + szCode +"' and Name_='"+ strName +"'");
  557. if (dr.Length > 0)
  558. {
  559. if (dr[0]["ITEM1MAX"].ToString() != "" && dr[0]["ITEM1MIN"].ToString() != "")
  560. dtSource.Rows[row]["设定范围"] = dr[0]["ITEM1MIN"].ToString() + "-" + dr[0]["ITEM1MAX"].ToString();
  561. else if (dr[0]["ITEM1MAX"].ToString() != "" && dr[0]["ITEM1MIN"].ToString() == "")
  562. dtSource.Rows[row]["设定范围"] = "≤ " + dr[0]["ITEM1MAX"].ToString();
  563. else if (dr[0]["ITEM1MAX"].ToString() == "" && dr[0]["ITEM1MIN"].ToString() != "")
  564. dtSource.Rows[row]["设定范围"] = "> " + dr[0]["ITEM1MIN"].ToString();
  565. if (!string.IsNullOrEmpty(dr[0]["ITEM1MIN"].ToString()))
  566. dZXZ = Convert.ToDecimal(dr[0]["ITEM1MIN"]);
  567. if(!string.IsNullOrEmpty(dr[0]["ITEM1MAX"].ToString()))
  568. dZDZ = Convert.ToDecimal(dr[0]["ITEM1MAX"]);
  569. //获取当前实际值
  570. if (!string.IsNullOrEmpty(uGrd.DisplayLayout.Rows[row].Cells["实际值"].Value.ToString()))
  571. dVal =Convert.ToDecimal(uGrd.DisplayLayout.Rows[row].Cells["实际值"].Value);
  572. if ((dVal > 0) && (dVal < dZXZ ))
  573. uGrd.DisplayLayout.Rows[row].Cells["实际值"].Appearance.ForeColor = Color.Red; // 下限报警红色显示
  574. else if ((dVal > 0) && (dVal > dZDZ) && dZDZ>0)
  575. uGrd.DisplayLayout.Rows[row].Cells["实际值"].Appearance.ForeColor = Color.Red; // 上限报警蓝色显示
  576. else
  577. uGrd.DisplayLayout.Rows[row].Cells["实际值"].Appearance.ForeColor = Color.Black;
  578. }
  579. }
  580. catch { }
  581. uGrd.Refresh();
  582. }
  583. }
  584. /// <summary>
  585. /// 设置Grid 的编辑性
  586. /// </summary>
  587. /// <param name="Grid"></param>
  588. public static void SetRowEdit(ref Infragistics.Win.UltraWinGrid.UltraGrid Grid)
  589. {
  590. foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in Grid.Rows)
  591. {
  592. row.Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
  593. }
  594. }
  595. /// <summary>
  596. /// 解析工艺路线
  597. /// </summary>
  598. /// <param name="strPlan_Lines">工艺编码路线</param>
  599. /// <returns></returns>
  600. public static string analysPlan_Lines(string strPlan_Lines)
  601. {
  602. string strLines = "";
  603. try
  604. {
  605. for (int i = 0; i < strPlan_Lines.Length; i += 1)
  606. {
  607. string StationCode = strPlan_Lines.Substring(i, 1);
  608. switch (StationCode)
  609. {
  610. case "A":
  611. strLines = strLines + "混铁炉";
  612. break;
  613. case "B":
  614. strLines = strLines + "->脱硫";
  615. break;
  616. case "C":
  617. strLines = strLines + "->转炉";
  618. break;
  619. case "D":
  620. strLines = strLines + "->吹氩站";
  621. break;
  622. case "E":
  623. strLines = strLines + "->精炼";
  624. break;
  625. case "F":
  626. strLines = strLines + "->RH炉";
  627. break;
  628. case "I":
  629. strLines = strLines + "->VD炉";
  630. break;
  631. case "G":
  632. strLines = strLines + "->连铸机";
  633. break;
  634. }
  635. }
  636. }
  637. catch
  638. {
  639. }
  640. if (strLines.Length < 2)
  641. return "";
  642. if (strLines.IndexOf("->", 0) == 0)
  643. {
  644. int len = strLines.Length;
  645. strLines = strLines.Substring(2, len - 2);
  646. }
  647. return strLines;
  648. }
  649. /// <summary>
  650. /// 解析作业路线
  651. /// </summary>
  652. /// <param name="craftPath">路线代码</param>
  653. /// <returns></returns>
  654. public static string analysPath(string craftPath)
  655. {
  656. string path = "";
  657. try
  658. {
  659. for (int i = 0; i < craftPath.Length; i += 2)
  660. {
  661. string StationCode = craftPath.Substring(i, 2);
  662. switch (StationCode)
  663. {
  664. case "A1":
  665. path = path + "1#混铁炉";
  666. break;
  667. case "A2":
  668. path = path + "2#混铁炉";
  669. break;
  670. case "B1":
  671. path = path + "->1#脱硫";
  672. break;
  673. case "B2":
  674. path = path + "->2#脱硫";
  675. break;
  676. case "C1":
  677. path = path + "->1#转炉";
  678. break;
  679. case "C2":
  680. path = path + "->2#转炉";
  681. break;
  682. case "C3":
  683. path = path + "->3#转炉";
  684. break;
  685. case "D1":
  686. path = path + "->1#吹氩站";
  687. break;
  688. case "D2":
  689. path = path + "->2#吹氩站";
  690. break;
  691. case "D3":
  692. path = path + "->3#吹氩站";
  693. break;
  694. case "E1":
  695. path = path + "->1#精炼";
  696. break;
  697. case "E2":
  698. path = path + "->2#精炼";
  699. break;
  700. case "E3":
  701. path = path + "->3#精炼";
  702. break;
  703. case "F1":
  704. path = path + "->1#RH炉";
  705. break;
  706. case "F2":
  707. path = path + "->2#RH炉";
  708. break;
  709. case "I1":
  710. path = path + "->1#VD炉";
  711. break;
  712. case "I2":
  713. path = path + "->2#VD炉";
  714. break;
  715. case "G1":
  716. path = path + "->1#连铸机";
  717. break;
  718. case "G2":
  719. path = path + "->2#连铸机";
  720. break;
  721. case "G3":
  722. path = path + "->3#连铸机";
  723. break;
  724. case "G4":
  725. path = path + "->4#连铸机";
  726. break;
  727. }
  728. }
  729. }
  730. catch
  731. {
  732. }
  733. if (path.Length < 2)
  734. return "";
  735. if (path.IndexOf("->", 0) == 0)
  736. {
  737. int len = path.Length;
  738. path = path.Substring(2, len - 2);
  739. }
  740. return path;
  741. }
  742. /// <summary>
  743. /// 根据岗位号获取工序
  744. /// </summary>
  745. /// <param name="_DEVICE_POSITION">岗位编码</param>
  746. /// <returns>工序代码</returns>
  747. public static string analysProcess(string _DEVICE_POSITION)
  748. {
  749. string strProcess = ""; //工序代码
  750. if (!string.IsNullOrEmpty(_DEVICE_POSITION))
  751. {
  752. switch (_DEVICE_POSITION.Substring(0, 3))
  753. {
  754. case "HMP":
  755. strProcess="B";
  756. break;
  757. case "BOF":
  758. strProcess = "C";
  759. break;
  760. case "CAS":
  761. strProcess = "D";
  762. break;
  763. case "LFS":
  764. strProcess = "E";
  765. break;
  766. case "RHS":
  767. strProcess = "F";
  768. break;
  769. case "CCM":
  770. strProcess = "G";
  771. break;
  772. case "VDS":
  773. strProcess = "I";
  774. break;
  775. default:
  776. break;
  777. }
  778. }
  779. return strProcess;
  780. }
  781. /// <summary>
  782. /// 根据岗位号获取工序中文名
  783. /// </summary>
  784. /// <param name="_DEVICE_POSITION">岗位编码</param>
  785. /// <returns>工序中文名</returns>
  786. public static string analysChineseName(string _DEVICE_POSITION)
  787. {
  788. string strChineseName = ""; //工序代码
  789. if (!string.IsNullOrEmpty(_DEVICE_POSITION))
  790. {
  791. switch (_DEVICE_POSITION.Substring(0, 3))
  792. {
  793. case "HMP":
  794. strChineseName = "脱硫站";
  795. break;
  796. case "BOF":
  797. strChineseName = "转炉";
  798. break;
  799. case "CAS":
  800. strChineseName = "吹氩站";
  801. break;
  802. case "LFS":
  803. strChineseName = "LF炉";
  804. break;
  805. case "RHS":
  806. strChineseName = "RH炉";
  807. break;
  808. case "VDS":
  809. strChineseName = "VD炉";
  810. break;
  811. case "CCM":
  812. strChineseName = "连铸机";
  813. break;
  814. default:
  815. break;
  816. }
  817. }
  818. return strChineseName;
  819. }
  820. /// <summary>
  821. /// 根据代码解析工位名
  822. /// </summary>
  823. /// <param name="_DEVICE_POSITION">岗位编码,BOF01_FRONT</param>
  824. /// <returns>工位中文名</returns>
  825. public static string analysPosName(string _DEVICE_POSITION)
  826. {
  827. string strChineseName = ""; //工序代码
  828. string strPos = ""; //岗位
  829. string strWsID = ""; //工位
  830. if (!string.IsNullOrEmpty(_DEVICE_POSITION))
  831. {
  832. strPos = _DEVICE_POSITION.Substring(0, 3);
  833. strWsID = _DEVICE_POSITION.Substring(6);
  834. switch (strWsID)
  835. {
  836. case "IDLE":
  837. strChineseName = "缓冲位";
  838. break;
  839. case "FRONT":
  840. if (strPos == "CAS" || strPos == "CCM")
  841. strChineseName = "等待位";
  842. else if (strPos == "LFS" || strPos == "RHS")
  843. strChineseName = "1#小车位";
  844. else if (strPos == "HMP") strChineseName = "小车位";
  845. break;
  846. case "DEVICE":
  847. if (strPos == "BOF")
  848. strChineseName = "吹炼位";
  849. else if (strPos == "CCM")
  850. strChineseName = "浇铸位";
  851. else
  852. strChineseName = "处理位";
  853. break;
  854. case "BACK":
  855. if (strPos == "BOF")
  856. strChineseName = "出钢位";
  857. else
  858. strChineseName = "2#小车位";
  859. break;
  860. case "OVER":
  861. strChineseName = "生产结束";
  862. break;
  863. default:
  864. break;
  865. }
  866. }
  867. return strChineseName;
  868. }
  869. /// <summary>
  870. /// 解析执行状态
  871. /// </summary>
  872. /// <param name="heatState">执行状态代码</param>
  873. /// <returns></returns>
  874. public static string analysHeat_State(string heatState)
  875. {
  876. string strHeat_State = "";
  877. if (!string.IsNullOrEmpty(heatState.Trim()))
  878. {
  879. switch (heatState)
  880. {
  881. case "03":
  882. strHeat_State = "计划状态";
  883. break;
  884. case "04":
  885. strHeat_State = "正在转炉";
  886. break;
  887. case "05":
  888. strHeat_State = "正在吹氩";
  889. break;
  890. case "06":
  891. strHeat_State = "正在精炼炉";
  892. break;
  893. case "07":
  894. strHeat_State = "正在RH炉";
  895. break;
  896. case "08":
  897. strHeat_State = "正在连铸";
  898. break;
  899. case "09":
  900. strHeat_State = "生产完成";
  901. break;
  902. default:
  903. strHeat_State = "执行异常";
  904. break;
  905. }
  906. }
  907. return strHeat_State;
  908. }
  909. /// <summary>
  910. /// 解析成分作业路线
  911. /// </summary>
  912. /// <param name="craftPath">成分编码</param>
  913. /// <returns></returns>
  914. public static string ChemelementPath(string craftPath)
  915. {
  916. string path = "";
  917. try
  918. {
  919. string StationCode = craftPath.Substring(0, 1);
  920. switch (StationCode)
  921. {
  922. case "B":
  923. path = "脱硫";
  924. break;
  925. case "C":
  926. path = "转炉";
  927. break;
  928. case "D":
  929. if (craftPath.Substring(0, 2) == "DQ")
  930. path = "CAS前";
  931. else if (craftPath.Substring(0, 2) == "DH")
  932. path = "CAS后";
  933. break;
  934. case "E":
  935. path = "LF炉";
  936. break;
  937. case "F":
  938. path = "RH炉";
  939. break;
  940. case "I":
  941. path = "VD炉";
  942. break;
  943. case "G":
  944. path = "连铸";
  945. break;
  946. }
  947. }
  948. catch
  949. {
  950. }
  951. return path;
  952. }
  953. /// <summary>
  954. /// 将长整型转换浮点型
  955. /// </summary>
  956. /// <param name="lgValue"></param>
  957. /// <returns></returns>
  958. public static float LongToFloat(long lgValue)
  959. {
  960. float flValue = 0;
  961. try
  962. {
  963. if (lgValue >= 0)
  964. {
  965. byte[] btValue = CStaticMethod.LongToHex(lgValue);
  966. flValue = CStaticMethod.HexToFloat(btValue);
  967. }
  968. }
  969. catch { }
  970. return flValue;
  971. }
  972. private static unsafe byte[] LongToHex(long lValue)
  973. {
  974. long[] lValuePtr = new long[1];
  975. int sizeOfValue = Marshal.SizeOf(typeof(long));
  976. byte[] byteValue = new byte[sizeOfValue];
  977. lValuePtr[0] = lValue;
  978. fixed (long* pTempValue = lValuePtr)
  979. {
  980. Marshal.Copy(new IntPtr(pTempValue), byteValue, 0, sizeOfValue);
  981. }
  982. return byteValue;
  983. }
  984. private static unsafe float HexToFloat(byte[] byteValue)
  985. {
  986. float[] fltValuePtr = new float[1];
  987. int sizeOfValue = Marshal.SizeOf(typeof(float));
  988. fixed (float* pTempValue = fltValuePtr)
  989. {
  990. Marshal.Copy(byteValue, 0, new IntPtr(pTempValue), sizeOfValue);
  991. }
  992. return fltValuePtr[0];
  993. }
  994. /// <summary>
  995. /// 获取窗体工具栏信息
  996. /// </summary>
  997. /// <param name="strFromKey">窗体KEY</param>
  998. /// <param name="strCustominfo">窗体自定议参数</param>
  999. /// <param name="ob">URL</param>
  1000. /// <returns>LIST<structButton></returns>
  1001. public static List<structButton> GetFromToolInfo(string strFromKey, string strCustominfo,OpeBase ob)
  1002. {
  1003. string strErr = "";
  1004. List<structButton> sblist = new List<structButton>();
  1005. try
  1006. {
  1007. ArrayList arry = new ArrayList();
  1008. if (strCustominfo.Length > 0)
  1009. {
  1010. arry.Add("GetFromToolInfo_Custom.Select");//此ID为XML文件ID
  1011. arry.Add(strFromKey);
  1012. arry.Add(strCustominfo);
  1013. }
  1014. else
  1015. {
  1016. arry.Add("GetFromToolInfo.Select");//此ID为XML文件ID
  1017. arry.Add(strFromKey);
  1018. }
  1019. Core.Mes.Client.Common.CommonClientToServer ccTs = new Core.Mes.Client.Common.CommonClientToServer();
  1020. ccTs.ob = ob;
  1021. //获取指定岗位后台实时跟踪信息
  1022. DataSet ds = ccTs.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassCommonModule",
  1023. "GetFromToolInfo", arry, out strErr);
  1024. if (strErr == "" && ds != null)
  1025. {
  1026. if (ds.Tables[0].Rows.Count > 0)
  1027. {
  1028. foreach(DataRow dr in ds.Tables[0].Rows)
  1029. {
  1030. structButton sbut = new structButton();
  1031. sbut.Caption = dr["CAPTION"].ToString();
  1032. sbut.Key = dr["KEY"].ToString();
  1033. sbut.ImageKey = dr["IMAGE"].ToString();
  1034. sbut.Enable = true;
  1035. sblist.Add(sbut);
  1036. }
  1037. }
  1038. }
  1039. return sblist;
  1040. }
  1041. catch
  1042. {
  1043. return sblist;
  1044. }
  1045. }
  1046. /// <summary>
  1047. /// 获取作业温度标准
  1048. /// </summary>
  1049. /// <returns></returns>
  1050. public static DataTable GetJobStandardTemp(CoreFS.CA06.OpeBase ope,string strSteelCode)
  1051. {
  1052. string strErr = "";
  1053. ArrayList arry = new ArrayList();
  1054. arry.Add("GetJobStandardTemp.Select");//此ID为XML文件ID
  1055. arry.Add(strSteelCode);
  1056. Core.Mes.Client.Common.CommonClientToServer ccTs = new Core.Mes.Client.Common.CommonClientToServer();
  1057. ccTs.ob = ope;
  1058. //获取作业温度标准
  1059. DataSet ds = ccTs.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassCommonModule",
  1060. "GetJobStandardTemp", arry, out strErr);
  1061. if (strErr == "" && ds != null)
  1062. {
  1063. return ds.Tables[0];
  1064. }
  1065. return null;
  1066. }
  1067. /// <summary>
  1068. /// 获取物料消耗标准
  1069. /// </summary>
  1070. /// <returns></returns>
  1071. public static DataTable GetJobStandardMateriel(CoreFS.CA06.OpeBase ope, string strSteelCode)
  1072. {
  1073. string strErr = "";
  1074. ArrayList arry = new ArrayList();
  1075. arry.Add("GetJobStandardMateriel.Select");//此ID为XML文件ID
  1076. arry.Add(strSteelCode);
  1077. Core.Mes.Client.Common.CommonClientToServer ccTs = new Core.Mes.Client.Common.CommonClientToServer();
  1078. ccTs.ob = ope;
  1079. //获取作业温度标准
  1080. DataSet ds = ccTs.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassCommonModule",
  1081. "GetJobStandardMateriel", arry, out strErr);
  1082. if (strErr == "" && ds != null)
  1083. {
  1084. return ds.Tables[0];
  1085. }
  1086. return null;
  1087. }
  1088. }
  1089. /// <summary>
  1090. /// 枚举对象长度
  1091. /// </summary>
  1092. public enum OBJLEN : int
  1093. {
  1094. /// <summary>
  1095. /// 加热处理号长度
  1096. /// </summary>
  1097. nHeatProcessNo=15,
  1098. /// <summary>
  1099. /// 炉号长度
  1100. /// </summary>
  1101. nHeatNo = 10,
  1102. /// <summary>
  1103. /// 岗位编码长度
  1104. /// </summary>
  1105. nDevCode = 2,
  1106. /// <summary>
  1107. /// 处理次数长度
  1108. /// </summary>
  1109. nDealTime = 2,
  1110. /// <summary>
  1111. /// 岗位编码字母长度
  1112. /// </summary>
  1113. nDevStr=1,
  1114. /// <summary>
  1115. /// 脱硫处理号
  1116. /// </summary>
  1117. nHudwProcessNo=14,
  1118. /// <summary>
  1119. /// 脱硫号
  1120. /// </summary>
  1121. nHudwId=9
  1122. }
  1123. }