Form1.cs 76 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633
  1. using CarMeterSystem.OptionCls;
  2. using com.hnshituo.core.webapp.vo;
  3. using Common;
  4. using iCore.Rtdb.RtdbTable;
  5. using MeterConditionLibrary;
  6. using MeterModelLibrary;
  7. using MeterModuleLibrary.uc;
  8. using MeterPlugInLibrary;
  9. using System;
  10. using System.Collections;
  11. using System.Collections.Generic;
  12. using System.Data;
  13. using System.Diagnostics;
  14. using System.Drawing;
  15. using System.IO;
  16. using System.Linq;
  17. using System.Windows.Forms;
  18. using SystemOffLine;
  19. namespace CarMeterSystem
  20. {
  21. public partial class Form1 : Form
  22. {
  23. public Form1()
  24. {
  25. InitializeComponent();
  26. }
  27. private Log l = Log.GetInstance();
  28. private Print printClass = new Print();//打印
  29. //内存表
  30. private MemoryTableDataSocket MemoClass = new MemoryTableDataSocket("");
  31. //实时表数据采集
  32. private DataCollectionControl collection = new DataCollectionControl();
  33. //图片控制器含图片压缩及上传curl
  34. private ImageCurlControl imageCurlControl = new ImageCurlControl();
  35. //与监控界面对接的表
  36. private MeterWorkMonitorService meterWorkMonitor = new MeterWorkMonitorService();
  37. //零点报警表
  38. private meterworkzeroalarmservice zeroAlarmService = new meterworkzeroalarmservice();
  39. //车号修正
  40. private CarNoModfiy modfiy = new CarNoModfiy();
  41. /// <summary>
  42. /// 这个是保存前一次采集中的车号信息
  43. /// </summary>
  44. private string preCarNo = "";
  45. //验证对射
  46. private validParkStatus valid = new validParkStatus();
  47. //语音播报
  48. private VoicePlay vicPlayClass = new VoicePlay();
  49. private LED_Control led_controler = null;
  50. //监控表操作
  51. private MeterMonitorWeightService monitorWeightService = new MeterMonitorWeightService();
  52. private MeterWorkScheduledHelpService meterWorkScheduledHelpService = new MeterWorkScheduledHelpService();
  53. //验证校秤数据
  54. private validCalibration vCalib = new validCalibration();
  55. private MeterWorkCarActualFirstService workCarActualFirstService = new MeterWorkCarActualFirstService(); //一次计量数据
  56. //查询当前是否校秤
  57. private bool bRelation = true;
  58. /// <summary>
  59. /// 欢迎界面
  60. /// </summary>
  61. private frmWelcome_Jisco frmWelcome = new frmWelcome_Jisco();//欢迎
  62. /// <summary>
  63. /// 计量页
  64. /// </summary>
  65. private frmOneYardToEnd fcc = null;
  66. /// <summary>
  67. /// 基础数据载入
  68. /// </summary>
  69. private BaseDbCls bd = new BaseDbCls();
  70. //扫码修正车号标识
  71. private bool codeFlag = false;
  72. private List<ucBusinessType> lu = new List<ucBusinessType>();
  73. private bool isVoiceDownCar = false;//车上人员请下车播放一次
  74. private bool isShowFrmWelcome = false; //是否显示欢迎界面;在这个测试界面,不显示欢迎界面
  75. private bool isOpened = false;//是否已经打开了扫码计量界面
  76. private SerialPortES sweepCodeClass = new SerialPortES();
  77. private SerialPortES sweepCodeClass2 = new SerialPortES();
  78. private void Form1_Load(object sender, EventArgs e)
  79. {
  80. //*
  81. try
  82. {
  83. //CollectModel temp = new CollectModel();
  84. //temp.weight = 501;
  85. //PbCache.collect = temp;
  86. //frmMatMsgInfo frmMatMsgInfo = new frmMatMsgInfo();
  87. //frmMatMsgInfo.Show();
  88. // 计量页
  89. fcc = new frmOneYardToEnd();
  90. timer1.Start();
  91. //2021年6月21日 杨秀东添加
  92. if (isShowFrmWelcome)
  93. {
  94. frmWelcome.Show();
  95. frmWelcome.Visible = true;
  96. }
  97. LoginCls lg = new LoginCls();
  98. if (lg.LoginIn())
  99. {
  100. //if (SystemUpdate(false))
  101. //{
  102. // return;
  103. //}
  104. // 加载并验证基本配置
  105. if (bd.setBaseDb() && bd.getBaseDb())
  106. {
  107. if (!string.IsNullOrEmpty(PbCache.sportInfo.ledIp))
  108. {
  109. led_controler = new LED_Control(PbCache.sportInfo.ledIp);
  110. }
  111. //调用该方法时已赋值
  112. RESTfulResult<List<MeterWorkMonitor>> rm = meterWorkMonitor.doQueryOneWf(new MeterWorkMonitor { validFlag = "1", pointNo = PbCache.sportInfo.baseSpotNo });
  113. if (!rm.Succeed)
  114. {
  115. l.WriteLog(1, "载入监控表数据异常");
  116. return;
  117. }
  118. else if (rm.Data != null && rm.Data.Count > 0)
  119. {
  120. if (string.IsNullOrEmpty(PbCache.collect_no))
  121. {
  122. PbCache.collect_no = rm.Data[0].collectionCode;
  123. MemoClass = new MemoryTableDataSocket(PbCache.collect_no);
  124. }
  125. }
  126. else
  127. {
  128. //l.WriteLog(1, "为配置监控数据");
  129. //return;
  130. }
  131. //若未校秤的话,也不允许计量
  132. //载入界面业务按钮
  133. if (PbCache.businessType != null && PbCache.businessType.Count > 0)
  134. {
  135. foreach (ComBaseInfo info in PbCache.businessType)
  136. {
  137. ucBusinessType uc = new ucBusinessType();
  138. switch (info.baseCode)
  139. {
  140. case "001006003":
  141. uc.setControl(info.baseName, info.memo, info.baseCode);
  142. break;
  143. case "001006001":
  144. case "001006002":
  145. uc.setControl(info.baseName, info.memo, info.baseCode);
  146. break;
  147. default:
  148. uc.setControl(info.baseName, info.memo, info.baseCode);
  149. break;
  150. }
  151. uc.Dock = DockStyle.Top;
  152. //uc.setControl("","","",);
  153. uc.ucEvent += new EventHandler(ucEvents);
  154. lu.Add(uc);
  155. panel7.Controls.Add(uc);
  156. }
  157. }
  158. //开启基础进程
  159. l.WriteLog(0, "系统登录成功");
  160. collection.EventDataCollectionArgs += new EventDataCollection(EventData);//数据采集
  161. collection.Start(PbCache.sportInfo.baseSpotNo, PbCache.sportInfo.baseSpotName);
  162. imageCurlControl.Start(); //图片采集线程
  163. //新扫码线程
  164. if (AppConfigCache._comPara?.Split(new char[] { ',' })?.Length == 5)
  165. {
  166. sweepCodeClass.StartThreadSweep(AppConfigCache._comPara); //扫码线程
  167. }
  168. if (AppConfigCache._comPara2?.Split(new char[] { ',' })?.Length == 5)
  169. {
  170. sweepCodeClass2.StartThreadSweep(AppConfigCache._comPara2); //扫码线程
  171. }
  172. }
  173. else
  174. {
  175. l.WriteLog(0, "系统登录失败");
  176. }
  177. }
  178. else
  179. {
  180. l.WriteLog(0, "按IP地址找不到计量点信息,系统登录失败");
  181. }
  182. }
  183. catch (Exception ex)
  184. {
  185. l.WriteLog(0, "系统加载失败:" + ex.Message);
  186. }
  187. //*/
  188. }
  189. #region
  190. //*
  191. /// <summary>
  192. /// 委托的方式调用控件的点击事件
  193. /// </summary>
  194. /// <param name="sender"></param>
  195. /// <param name="e"></param>
  196. public void ucEvents(object sender, EventArgs e)
  197. {
  198. Control control = (Control)sender;
  199. ucBusinessType um = control.Parent.Parent as ucBusinessType;
  200. try
  201. {
  202. switch (control.Name)
  203. {
  204. case "btnContext":
  205. case "btnPurchase":
  206. {
  207. PbCache.bussinessTypeName = um._bussiness == null ? "" : um._bussiness;
  208. PbCache.bussinessTypeCode = um._code;
  209. switch (um._code)
  210. {
  211. case "001006003":
  212. frmInternalTransport frm = new frmInternalTransport();
  213. frm.ShowDialog();
  214. break;
  215. /*
  216. case "001006001":
  217. case "001006002":
  218. frmCarSalePurchase frmCar = new frmCarSalePurchase();
  219. frmCar.ShowDialog();
  220. break;
  221. //*/
  222. default:
  223. frmCarSalePurchase frmCar = new frmCarSalePurchase();
  224. frmCar.ShowDialog();
  225. break;
  226. }
  227. };
  228. break;
  229. default: break;
  230. }
  231. }
  232. catch (Exception ex)
  233. {
  234. //MessageBox.Show("操作异常:" + ex.Message);
  235. }
  236. }
  237. //*/
  238. #endregion
  239. #region
  240. private void setWelecomeVis(bool visb)
  241. {
  242. /*
  243. if (frmWelcome.InvokeRequired)
  244. {
  245. Action<bool> action = new Action<bool>(setWelecomeVis);
  246. Invoke(action, new object[] { visb });
  247. }
  248. else
  249. {
  250. if (frmWelcome.Visible != visb)
  251. {
  252. frmWelcome.Visible = visb;
  253. frmWelcome.setLogin();
  254. }
  255. }
  256. //*/
  257. }
  258. #endregion
  259. private int iCount = 0, iHodeTime = 0;
  260. private bool flagCarMonit = false;//车号修正
  261. private bool bEditCar = false; //手动修正车号
  262. private bool isOpenMeter = false; //是否已打开计量界面,若已经打开则这里关于超量程及红外的语音将停止播报
  263. private string firstCode = "";//上次扫码的信息
  264. private string ledTxt = "";
  265. private bool isLedWrite = false;//是否写入一次LED
  266. private string sPreNo = ""; //记录重量曲线变化
  267. private int preWgt = 0;//前一次重量,用于重量曲线
  268. private string sCarNo = "";
  269. private int iCountPark = 0;
  270. private string editCarNo = "";
  271. private bool isResFlag = true;
  272. private string RFIDCarNo = "";
  273. private string isWriteRFID = AppConfigCache.isWriteRFID;
  274. //EventData实例化
  275. RESTfulResult<string> rmsEventDataLastTime = new RESTfulResult<string>();
  276. RESTfulResult<List<MeterWorkMonitor>> rmUpdateEventDataMonitor = new RESTfulResult<List<MeterWorkMonitor>>();
  277. MeterWorkMonitor updateEventDataMonitor = new MeterWorkMonitor();
  278. MeterMonitorWeight meterMonitorWeightEventData1 = new MeterMonitorWeight();
  279. MeterMonitorWeight meterMonitorWeightEventData2 = new MeterMonitorWeight();
  280. MeterWorkMonitor mwUpdate = new MeterWorkMonitor();
  281. PbModelDbService<List<PbModelDb>> pbpRFIDEventData = new PbModelDbService<List<PbModelDb>>();
  282. RESTfulResult<List<PbModelDb>> rmTRFIDEventData = new RESTfulResult<List<PbModelDb>>();
  283. RESTfulResult<string> rmsmwUpdateEventData = new RESTfulResult<string>();
  284. MeterWorkScheduledHelp meterWorkScheduledHelp1 = new MeterWorkScheduledHelp();
  285. MeterWorkScheduledHelp meterWorkScheduledHelpRFID = new MeterWorkScheduledHelp();
  286. RESTfulResult<string> rmsdoUpdateWfEventData = new RESTfulResult<string>();
  287. RESTfulResult<string> rmssEventData = new RESTfulResult<string>();
  288. MeterWorkMonitor meterWorkMonitorEventDataI = new MeterWorkMonitor();
  289. MeterWorkCarActualFirstService mwcfs = new MeterWorkCarActualFirstService();
  290. RESTfulResult<string> rmsSweepCodeClass = new RESTfulResult<string>();
  291. frmOneYardToEnd frmOneYardToEnd = new frmOneYardToEnd();
  292. /// <summary>
  293. /// 数据采集
  294. /// </summary>
  295. /// <param name="o"></param>
  296. /// <param name="e"></param>
  297. private void EventData(object o, DataCollectionArgs e)
  298. {
  299. if (!timer1.Enabled)
  300. {
  301. timer1.Enabled = true;
  302. l.WriteLog(32, "定时器重启(timer1_Tick:frmMain),车号:" + PbCache.resultCarNo + "||" + (PbCache.collect == null ? "" : PbCache.collect.carno));
  303. }
  304. #region
  305. //num++;
  306. //e.carno = "湘G88888";
  307. //if (num < 20)
  308. //{
  309. // e.weight = 23580;
  310. // e.weightStatus = 1;
  311. //}
  312. //else if (num < 26)
  313. //{
  314. // e.weight = 23580;
  315. // e.weightStatus = 0;
  316. //}
  317. //else if (num < 39)
  318. //{
  319. // e.weight = 23580;
  320. // e.weightStatus = 0;
  321. //}
  322. //else if (num < 45)
  323. //{
  324. // e.weight = 15000;
  325. // e.weightStatus = 1;
  326. //}
  327. //else
  328. //{
  329. // e.weight = 400;
  330. //}
  331. #endregion
  332. //这里每隔0.5秒执行一次
  333. try
  334. {
  335. if (e.carno == "nown")
  336. {
  337. e.carno = "";
  338. }
  339. #region 扫码信息
  340. //if (string.IsNullOrEmpty(sweepCodeClass.StrCode))
  341. //{
  342. // if (string.IsNullOrEmpty(PbCache.strCode))
  343. // {
  344. // codeFlag = false;
  345. // firstCode = "";
  346. // PbCache.strCode = "";
  347. // l.WriteLog(12, "主线程扫码值为空时清空;sweepCodeClass.StrCode值为" + sweepCodeClass.StrCode + " ;PbCache.strCode值为:" + PbCache.strCode);
  348. // }
  349. //}
  350. //else
  351. //{
  352. // codeFlag = true;
  353. // frmOneYardToEnd frmOneYardToEnd = new frmOneYardToEnd();
  354. // Hashtable hashTable = new Hashtable();
  355. // hashTable.Add("message", sweepCodeClass.StrCode);
  356. // rmsSweepCodeClass = mwcfs.DecryptionForWfTest(hashTable);
  357. // if (rmsSweepCodeClass.Code == "0")
  358. // {
  359. // PbCache.collect.carno = rmsSweepCodeClass.Data;
  360. // PbCache.strCode = rmsSweepCodeClass.Data;
  361. // }
  362. // if (rmsSweepCodeClass.Code == "1")
  363. // {
  364. // vicPlayClass.GetVoicePlay("车号二维码已过期", PbCache.collect.carno);
  365. // frmOneYardToEnd.setMsgInfo("车号二维码已过期");
  366. // }
  367. // if (rmsSweepCodeClass.Code == "2")
  368. // {
  369. // vicPlayClass.GetVoicePlay("不是有效车号二维码", PbCache.collect.carno);
  370. // frmOneYardToEnd.setMsgInfo("不是有效车号二维码");
  371. // }
  372. // if (rmsSweepCodeClass.Code == "9")
  373. // {
  374. // vicPlayClass.GetVoicePlay("不是有效车号二维码", PbCache.collect.carno);
  375. // frmOneYardToEnd.setMsgInfo("不是有效车号二维码");
  376. // }
  377. // l.WriteLog(12, "测试扫码值" + rmsSweepCodeClass.Data);
  378. //}
  379. // 司机扫码为空,取工控机二维码
  380. if (string.IsNullOrEmpty(sweepCodeClass2.StrCode))
  381. {
  382. if (string.IsNullOrEmpty(sweepCodeClass.StrCode))
  383. {
  384. if (string.IsNullOrEmpty(PbCache.strCode))
  385. {
  386. codeFlag = false;
  387. firstCode = "";
  388. PbCache.strCode = "";
  389. l.WriteLog(12, "主线程扫码值为空时清空;sweepCodeClass.StrCode值为" + sweepCodeClass.StrCode + " ;PbCache.strCode值为:" + PbCache.strCode);
  390. }
  391. }
  392. else
  393. {
  394. DecodeQRCode(sweepCodeClass.StrCode);
  395. }
  396. }
  397. else
  398. {
  399. DecodeQRCode(sweepCodeClass2.StrCode);
  400. }
  401. #endregion
  402. #region 秤上无车10分钟获取一次基础数据
  403. if (iCount < 1200)
  404. {
  405. iCount++;
  406. }
  407. else
  408. {
  409. try
  410. {
  411. //秤上没有车时,每隔10分钟获取一次基础数据
  412. if (e.weight < 500)
  413. {
  414. if (bd.setBaseDb())
  415. {
  416. l.WriteLog(0, "十分钟获取基础数据成功");
  417. }
  418. else
  419. {
  420. l.WriteLog(0, "十分钟获取基础数据失败");
  421. }
  422. iCount = 0;
  423. }
  424. }
  425. catch (Exception ex)
  426. {
  427. l.WriteLog(0, "十分钟获取基础数据失败:" + ex.Message);
  428. iCount = 0;
  429. }
  430. }
  431. #endregion
  432. #region 每10秒写入一次当前时间
  433. if (iCount % 20 == 0)
  434. {
  435. //更新在线时间
  436. rmsEventDataLastTime = meterWorkMonitor.doUpdateWfBySpotNo(new MeterWorkMonitor { pointNo = PbCache.sportInfo.baseSpotNo });
  437. if (!rmsEventDataLastTime.Succeed)
  438. {
  439. l.WriteLog(0, "frmMain.EventData异常:写入时间异常,原因:" + rmsEventDataLastTime.ResultMessage);
  440. }
  441. }
  442. #endregion
  443. #region
  444. //一旦界面锁定则不采集数据
  445. PbCache.collect.pointid = PbCache.sportInfo.baseSpotNo;
  446. PbCache.collect.parkStatus = e.parkStatus;
  447. PbCache.collect.datetime = e.datetime;
  448. PbCache.collect.licType = e.licType;
  449. if (testFlag)
  450. {
  451. sCarNo = testCarNo;
  452. //PbCache.collect.carno = testCarNo;
  453. PbCache.collect.weight = testWgt;
  454. PbCache.collect.weightStatus = 0;
  455. PbCache.monitorResult.valid_park_status = true;
  456. PbCache.collect.parkStatus = 0;
  457. if (PbCache.collect.weight > e.weight)
  458. e.weight = PbCache.collect.weight;
  459. PbCache.strCode = testPlanNo;
  460. e.carno = testCarNo;
  461. //PbCache.strQRCode = testCode;
  462. }
  463. else
  464. {
  465. PbCache.collect.weight = e.weight;
  466. PbCache.collect.weightStatus = e.weightStatus;
  467. }
  468. if (PbCache.collect != null && PbCache.collect.weightStatus == 0)
  469. {
  470. if (string.IsNullOrEmpty(PbCache.resultWgt))
  471. {
  472. PbCache.resultWgt = e.weight + "";
  473. }
  474. if (!string.IsNullOrEmpty(PbCache.resultWgt) && e.weight > Convert.ToInt32(PbCache.resultWgt))
  475. {
  476. PbCache.resultWgt = e.weight + "";
  477. }
  478. if (!string.IsNullOrEmpty(e.carno) && PbCache.resultCarNo != e.carno)
  479. {
  480. PbCache.resultCarNo = e.carno + "";
  481. l.WriteLog(28, "车号賦值跟蹤:PbCache.resultCarNo" + PbCache.resultCarNo + "||e.carno" + e.carno);
  482. }
  483. }
  484. //*/
  485. // 更新监控表
  486. //doLive();
  487. //重量大于500的情况下
  488. if (e.weight > 500)
  489. {
  490. isResFlag = true;
  491. if (PbCache.dtStartTime == null)
  492. PbCache.dtStartTime = DateTime.Now;
  493. isLedWrite = true;
  494. PbCache.strState = "0";
  495. #region 车上人员请下车
  496. try
  497. {
  498. //界面未锁定的情况下,有车号,如果重量稳定了,停车线验证通过,未超量程的情况下,则按钮可用
  499. if (PbCache.collect != null && !string.IsNullOrEmpty(PbCache.collect.carno) && PbCache.collect.weightStatus == 0 && PbCache.monitorResult.valid_park_status && PbCache.collect.weight < PbCache.range.upperRange)
  500. {
  501. if (!isVoiceDownCar)
  502. {
  503. isVoiceDownCar = true;
  504. vicPlayClass.GetVoicePlay("车上人员请下车", PbCache.collect.carno);
  505. }
  506. }
  507. }
  508. catch { }
  509. #endregion
  510. setWelecomeVis(false);
  511. //每隔1秒刷一次计量实时监控表数据值
  512. if (iCount % 2 == 0)
  513. {
  514. //调用该方法时已赋值
  515. updateEventDataMonitor.validFlag = "1";
  516. updateEventDataMonitor.pointNo = PbCache.sportInfo.baseSpotNo;
  517. rmUpdateEventDataMonitor = meterWorkMonitor.doQueryOneWf(updateEventDataMonitor);
  518. if (!rmUpdateEventDataMonitor.Succeed)
  519. {
  520. l.WriteLog(0, "frmMain.EventData异常419:" + rmUpdateEventDataMonitor.ResultMessage);
  521. }
  522. else
  523. {
  524. if (rmUpdateEventDataMonitor.Data != null && rmUpdateEventDataMonitor.Data.Count > 0)
  525. {
  526. PbCache.monitor = rmUpdateEventDataMonitor.Data[0];
  527. if (string.IsNullOrEmpty(PbCache.collect_no))
  528. {
  529. PbCache.collect_no = rmUpdateEventDataMonitor.Data[0].collectionCode;
  530. }
  531. if (ledTxt != rmUpdateEventDataMonitor.Data[0].ledWriter && rmUpdateEventDataMonitor.Data[0].ledWriter != "")
  532. {
  533. //调用LED信息写入******************************
  534. ledTxt = rmUpdateEventDataMonitor.Data[0].ledWriter;
  535. }
  536. if (string.IsNullOrEmpty(ledTxt))
  537. {
  538. ledTxt = "欢迎使用酒钢汽车衡智能计量系统!";
  539. }
  540. }
  541. }
  542. #region 2021-03-29
  543. #region 摄像头当前采集的车号与上次采集的不一样且当前未勾选不验证,且当前车号未进行手动修正的情况下
  544. if (preCarNo != e.carno && PbCache.monitor != null && PbCache.monitor.validCarno != "0" && !bEditCar)
  545. {
  546. flagCarMonit = false;
  547. }
  548. preCarNo = e.carno;
  549. #endregion
  550. if (!flagCarMonit)
  551. {
  552. sCarNo = e.carno;
  553. }
  554. //*
  555. //有车号,且重量稳定的情况下,只修正一次车号
  556. if (!string.IsNullOrEmpty(e.carno) && e.weightStatus == 0 && !flagCarMonit && PbCache.monitor != null && PbCache.monitor.carMonitor == "1" && PbCache.monitor.carMonitorLvl > 0)
  557. {
  558. flagCarMonit = true;
  559. string methods = "";
  560. for (int i = 0; i <= PbCache.monitor.carMonitorLvl; i++)
  561. {
  562. methods += "CarNoTrustCorrect" + i + ",";
  563. }
  564. editCarNo = modfiy.CarNoCorrect(e.carno, methods.Substring(0, methods.Length - 1));
  565. sCarNo = editCarNo;
  566. //mwUpdate
  567. }
  568. //勾选了不验证车号的情况
  569. if (PbCache.monitor.validCarno == "0")
  570. {
  571. flagCarMonit = true;
  572. }
  573. #endregion
  574. #region 每隔1秒写入一次重量曲线
  575. try
  576. {
  577. if (preWgt != e.weight)
  578. {
  579. preWgt = e.weight;
  580. sPreNo = PbCache.sportInfo.baseSpotNo + DateTime.Now.ToString("yyyyMMddHHmmssfff");
  581. meterMonitorWeightEventData1.weightNo = sPreNo;
  582. meterMonitorWeightEventData1.baseSpotNo = PbCache.sportInfo.baseSpotNo;
  583. meterMonitorWeightEventData1.baseSpotName = PbCache.sportInfo.baseSpotName;
  584. meterMonitorWeightEventData1.collectWeight = e.weight + "";
  585. meterMonitorWeightEventData1.collectStartTime = PbCache.dtStartTime.Value;
  586. meterMonitorWeightEventData1.collectEndTime = DateTime.Now;
  587. meterMonitorWeightEventData1.spotTypeNo = "001002001";
  588. meterMonitorWeightEventData1.spotTypeName = "汽车衡";
  589. meterMonitorWeightEventData1.actualFirstNo = PbCache.actualFirstNo;
  590. monitorWeightService.doAddWf(meterMonitorWeightEventData1);
  591. }
  592. else
  593. {
  594. if (!string.IsNullOrEmpty(sPreNo))
  595. {
  596. meterMonitorWeightEventData2.weightNo = sPreNo;
  597. meterMonitorWeightEventData2.collectEndTime = DateTime.Now;
  598. monitorWeightService.doUpdateWf(meterMonitorWeightEventData2);
  599. }
  600. }
  601. }
  602. catch { }
  603. #endregion
  604. #region 停留超时
  605. iHodeTime++;
  606. mwUpdate.pointNo = PbCache.sportInfo.baseSpotNo;
  607. mwUpdate.editCar = editCarNo;
  608. if (PbCache.holdTime != null && PbCache.holdTime.Count > 0)
  609. {
  610. if (PbCache.holdTime[0].retentionTime != null)
  611. {
  612. if (PbCache.holdTime[0].retentionTime.Value < iHodeTime)
  613. {
  614. l.WriteLog(33, "iHodeTime:" + iHodeTime + ",PbCache.holdTime[0].retentionTime.Value:" + PbCache.holdTime[0].retentionTime.Value + ",mwUpdate.stopOverTime:" + mwUpdate.stopOverTime);
  615. PbCache.isOvertimeAlarm = true; //是否超时报警
  616. mwUpdate.stopOverTime = "1"; //写入一次停留超时
  617. //mwUpdate.isHelp = "1";//派位
  618. //mwUpdate.isTakeOver = "1";
  619. iHodeTime = 99999;//不再增长避免超出
  620. }
  621. }
  622. }
  623. #endregion
  624. #region RFID识别车号信息
  625. mwUpdate.rfidCar = "";
  626. mwUpdate.photoCar = e.vdioCarNos;
  627. mwUpdate.scanCar = "";
  628. if (testFlag)
  629. {
  630. mwUpdate.scanCar = PbCache.collect.carno;
  631. }
  632. //mwUpdate.photoCar = PbCache.collect.carno;
  633. if (!string.IsNullOrEmpty(e.RfidNos))
  634. {
  635. string sqls = @"SELECT RFID_ID id,CAR_NO text FROM METER_BASE_RFID_INFO where RFID_CODE = '" + e.RfidNos + "'";
  636. rmTRFIDEventData = pbpRFIDEventData.executeSqlDataWf(sqls);
  637. if (rmTRFIDEventData.Data == null || rmTRFIDEventData.Data.Count == 0)
  638. { }
  639. else
  640. {
  641. mwUpdate.rfidCar = rmTRFIDEventData.Data[0].text;
  642. sCarNo = rmTRFIDEventData.Data[0].text;
  643. RFIDCarNo = rmTRFIDEventData.Data[0].text;
  644. }
  645. }
  646. #endregion
  647. #region 计量员修改的车号信息
  648. if (PbCache.monitor != null && !string.IsNullOrEmpty(PbCache.monitor.setCar))
  649. {
  650. sCarNo = PbCache.monitor.setCar;
  651. bEditCar = true;
  652. flagCarMonit = true;
  653. codeFlag = false;
  654. sweepCodeClass.StrCode = "";
  655. sweepCodeClass2.StrCode = "";
  656. }
  657. #endregion
  658. #region 重量信息
  659. if (!PbCache.isLockFrm)
  660. {
  661. mwUpdate.wgt = e.weight;
  662. }
  663. else
  664. {
  665. mwUpdate.wgt = Convert.ToInt32(PbCache.lockWgt);
  666. }
  667. #endregion
  668. #region 写入一次监控表,将重量/车号停留超时等信息写入
  669. mwUpdate.msgInfo = PbCache.ResultMessage;
  670. mwUpdate.weightStatus = PbCache.collect.weightStatus;
  671. //另外初始化一次监控数据
  672. rmsmwUpdateEventData = meterWorkMonitor.doUpdateWf(mwUpdate);
  673. if (!rmsmwUpdateEventData.Succeed)
  674. {
  675. l.WriteLog(0, "frmMain.EventData异常583:写入信息异常" + mwUpdate);
  676. }
  677. #endregion
  678. //验证对射
  679. valid.ValidMethod();
  680. if (!isOpenMeter)
  681. {
  682. //if (PbCache.range != null && PbCache.range.upperRange < e.weight)
  683. if (PbCache.range != null && PbCache.range.upperRange < e.weight)
  684. {
  685. //超量程
  686. vicPlayClass.GetVoicePlay("已超量程", e.carno);
  687. //return;
  688. }
  689. else if (e.weightStatus == 0)
  690. {
  691. if (!PbCache.monitorResult.valid_park_status)
  692. {
  693. iCountPark++;
  694. if (iCountPark > 9)
  695. {
  696. //重量稳定,且对射验证不合格
  697. vicPlayClass.GetVoicePlay("您的车辆未停到位", e.carno);
  698. //return;
  699. iCountPark = 0; //2021年7月27日5s播一次,然后重新在播
  700. }
  701. }
  702. else
  703. {
  704. iCountPark = 0;
  705. }
  706. }
  707. }
  708. if (!lu[0].bcEnable)
  709. {
  710. foreach (ucBusinessType uc in lu)
  711. {
  712. uc.setControlEnable(true);
  713. }
  714. }
  715. if ((sweepCodeClass.StrCode == "" || sweepCodeClass2.StrCode == "") && !codeFlag)
  716. {
  717. PbCache.collect.carno = sCarNo;
  718. }
  719. }
  720. PbCache.collect.carno = sCarNo;
  721. //写入LED信息
  722. //if (PbCache.sportInfo != null && PbCache.ledInfo != PbCache.OldLedInfo)
  723. //{
  724. // PbCache.OldLedInfo = PbCache.ledInfo;
  725. // if (PbCache.monitor != null && PbCache.monitor.ledKeep == "0")
  726. // {
  727. // //led_controler.setOneLineMsg(PbCache.sportInfo.ledIp, PbCache.ledInfo);
  728. // }
  729. //}
  730. }
  731. else
  732. {
  733. isOpened = false; //下次上秤直接打开主界面
  734. if (e.weight > 10 && e.weight < 500)
  735. {
  736. //重量小于500,大于10
  737. MeterWorkMonitor mwUpdate = new MeterWorkMonitor();
  738. mwUpdate.pointNo = PbCache.sportInfo.baseSpotNo;
  739. mwUpdate.wgt = e.weight;
  740. rmsdoUpdateWfEventData = meterWorkMonitor.doUpdateWf(mwUpdate);
  741. }
  742. if (e.weight > 0 && e.weight < 200)
  743. {
  744. doOperateLive();
  745. }
  746. if (e.weight == 0)
  747. {
  748. PbCache.isZeroAlarm = false;
  749. }
  750. editCarNo = "";
  751. firstCode = ""; //历史的扫码枪的值
  752. preCarNo = "";
  753. sCarNo = "";
  754. sPreNo = "";
  755. preWgt = 0;
  756. //不等于空的时候说明写过一次日志了
  757. if (!testFlag)
  758. {
  759. isResFlag = false;
  760. meterWorkScheduledHelp1.baseSpotNo = PbCache.sportInfo.baseSpotNo;
  761. meterWorkScheduledHelp1.baseSpotName = PbCache.sportInfo.baseSpotName;
  762. meterWorkScheduledHelp1.carNo = string.IsNullOrEmpty(PbCache.collect.carno) ? PbCache.resultCarNo : PbCache.collect.carno;
  763. meterWorkScheduledHelp1.helpContent = "车号:" + (string.IsNullOrEmpty(PbCache.collect.carno) ? (string.IsNullOrEmpty(PbCache.resultCarNo) ? "未识别" : PbCache.resultCarNo) : PbCache.collect.carno) + ";重量:" + (PbCache.lockWgt == 0 ? PbCache.resultWgt : PbCache.lockWgt + "") + ";提示信息:" + PbCache.resultMsgAll;
  764. meterWorkScheduledHelp1.warmType = "5";
  765. meterWorkScheduledHelp1.warmTypeName = "计量提示跟踪";
  766. meterWorkScheduledHelpService.add(meterWorkScheduledHelp1);
  767. l.WriteLog(28, "车号:" + (string.IsNullOrEmpty(PbCache.collect.carno) ? (string.IsNullOrEmpty(PbCache.resultCarNo) ? "未识别" : PbCache.resultCarNo) : PbCache.collect.carno) + ";重量:" + (PbCache.lockWgt == 0 ? PbCache.resultWgt : PbCache.lockWgt + "") + ";提示信息:" + PbCache.resultMsgAll);
  768. }
  769. //不等于空的时候说明写过一次日志了
  770. if (!string.IsNullOrEmpty(RFIDCarNo) && isWriteRFID == "1")
  771. {
  772. meterWorkScheduledHelp1.baseSpotNo = PbCache.sportInfo.baseSpotNo;
  773. meterWorkScheduledHelp1.baseSpotName = PbCache.sportInfo.baseSpotName;
  774. meterWorkScheduledHelp1.carNo = string.IsNullOrEmpty(PbCache.collect.carno) ? PbCache.resultCarNo : PbCache.collect.carno;
  775. meterWorkScheduledHelp1.helpContent = RFIDCarNo;
  776. meterWorkScheduledHelp1.warmType = "7";
  777. meterWorkScheduledHelp1.warmTypeName = "RFID识别率";
  778. meterWorkScheduledHelpService.add(meterWorkScheduledHelp1);
  779. RFIDCarNo = "";
  780. }
  781. PbCache.isOvertimeAlarm = false; //是否超时报警
  782. PbCache.strCode = "";
  783. PbCache.strState = "";
  784. PbCache.ResultMessage = "";
  785. PbCache.resultMsgAll = "";
  786. PbCache.resultCarNo = "";
  787. PbCache.resultWgt = "";
  788. bEditCar = false;
  789. isVoiceDownCar = false;
  790. flagCarMonit = false;
  791. iHodeTime = 0;
  792. isOpenMeter = false;
  793. PbCache.isLockFrm = false;
  794. PbCache.dtStartTime = null;
  795. PbCache.voiceOver = true;
  796. if (PbCache.collect != null && !string.IsNullOrEmpty(PbCache.collect.carno))
  797. {
  798. PbCache.collect.carno = "";
  799. }
  800. setWelecomeVis(true);
  801. if (lu[0].bcEnable)
  802. {
  803. foreach (ucBusinessType uc in lu)
  804. {
  805. uc.setControlEnable(false);
  806. }
  807. }
  808. meterWorkMonitorEventDataI.pointNo = PbCache.sportInfo.baseSpotNo;
  809. meterWorkMonitorEventDataI.validWgt = "1";
  810. meterWorkMonitorEventDataI.validCarno = "1";
  811. meterWorkMonitorEventDataI.validTareTime = "1";
  812. meterWorkMonitorEventDataI.validMatTime = "1";
  813. meterWorkMonitorEventDataI.validTimeInterval = "1";
  814. meterWorkMonitorEventDataI.validParkStatus = "1";
  815. meterWorkMonitorEventDataI.validExceedWgt = "1";
  816. meterWorkMonitorEventDataI.validPredictionDiff = "1";
  817. meterWorkMonitorEventDataI.validLianda = "1";
  818. meterWorkMonitorEventDataI.validMatClick = "1";
  819. meterWorkMonitorEventDataI.setCar = "";
  820. meterWorkMonitorEventDataI.rfidCar = "";
  821. meterWorkMonitorEventDataI.photoCar = "";
  822. meterWorkMonitorEventDataI.scanCar = "";
  823. meterWorkMonitorEventDataI.editCar = "";
  824. meterWorkMonitorEventDataI.zeroState = "0";
  825. meterWorkMonitorEventDataI.carErr = "0";
  826. meterWorkMonitorEventDataI.ferroalloyResult = "0";
  827. meterWorkMonitorEventDataI.wgtErr = "0";
  828. meterWorkMonitorEventDataI.stopOverTime = "0";
  829. meterWorkMonitorEventDataI.msgInfo = "";
  830. meterWorkMonitorEventDataI.ledWriter = "";
  831. meterWorkMonitorEventDataI.isOverWgt = "";
  832. meterWorkMonitorEventDataI.isHelp = "0";
  833. meterWorkMonitorEventDataI.wgt = e.weight;
  834. //*
  835. //另外初始化一次监控数据
  836. RESTfulResult<string> rmssEventData = meterWorkMonitor.doUpdateWf(meterWorkMonitorEventDataI);
  837. if (!rmssEventData.Succeed)
  838. {
  839. l.WriteLog(0, "frmMain.EventData异常754:写入信息异常");
  840. }
  841. //*/
  842. //LED写入
  843. if (isLedWrite)
  844. {
  845. isLedWrite = false;
  846. }
  847. }
  848. #endregion
  849. }
  850. catch (Exception ex)
  851. {
  852. l.WriteLog(0, "frmMain.EventData异常:" + ex.Message);
  853. }
  854. }
  855. private void DecodeQRCode(string strCode)
  856. {
  857. codeFlag = true;
  858. //frmOneYardToEnd frmOneYardToEnd = new frmOneYardToEnd();
  859. Hashtable hashTable = new Hashtable();
  860. hashTable.Add("message", strCode);
  861. rmsSweepCodeClass = mwcfs.DecryptionForWfTest(hashTable);
  862. if (rmsSweepCodeClass.Code == "0")
  863. {
  864. PbCache.collect.carno = rmsSweepCodeClass.Data;
  865. PbCache.strCode = rmsSweepCodeClass.Data;
  866. }
  867. if (rmsSweepCodeClass.Code == "1")
  868. {
  869. vicPlayClass.GetVoicePlay("车号二维码已过期", PbCache.collect.carno);
  870. frmOneYardToEnd.setMsgInfo("车号二维码已过期");
  871. }
  872. if (rmsSweepCodeClass.Code == "2")
  873. {
  874. vicPlayClass.GetVoicePlay("不是有效车号二维码", PbCache.collect.carno);
  875. frmOneYardToEnd.setMsgInfo("不是有效车号二维码");
  876. }
  877. if (rmsSweepCodeClass.Code == "9")
  878. {
  879. vicPlayClass.GetVoicePlay("不是有效车号二维码", PbCache.collect.carno);
  880. frmOneYardToEnd.setMsgInfo("不是有效车号二维码");
  881. }
  882. l.WriteLog(12, "测试扫码值" + rmsSweepCodeClass.Data);
  883. }
  884. private delegate void ShowBtnTare(bool flag);//定义委托 期限皮重按钮
  885. private int testWgt = 1000;
  886. private string testCarNo = "", testPlanNo = "";
  887. private bool testFlag = false;
  888. /// <summary>
  889. /// 截图测试
  890. /// </summary>
  891. /// <param name="sender"></param>
  892. /// <param name="e"></param>
  893. private void button2_Click(object sender, EventArgs e)
  894. {
  895. CameraShotCls cameraShot = new CameraShotCls();
  896. //cameraShot.CapMethod("1");
  897. _ = Invoke(new Action(() => { cameraShot.CapMethod("15"); }));
  898. }
  899. //测试打印
  900. private string strFirstNo = "";
  901. private void btnTestPrint_Click(object sender, EventArgs e)
  902. {
  903. Print1(txtPlanNo.Text);
  904. }
  905. //弹窗
  906. private static FrmMessage FrmMess(string strMess, string strBtnSaveInfo)
  907. {
  908. FrmMessage frmMessage = new FrmMessage();
  909. frmMessage.StartPosition = FormStartPosition.Manual;
  910. frmMessage.Location = new Point(350, 450);
  911. frmMessage.ShowMessage = strMess;
  912. frmMessage.BtnSaveText = strBtnSaveInfo;
  913. frmMessage.BtnCancelText = "取消";
  914. return frmMessage;
  915. }
  916. private class PrintCls
  917. {
  918. public int printNum { get; set; }
  919. public MeterWorkCarActual printDb { get; set; }
  920. public int iType { get; set; } //0毛 1 皮 2净
  921. public string qrCode { get; set; }
  922. }
  923. private PrintCls printData = new PrintCls();
  924. private void Print1(string firstNo)
  925. {
  926. try
  927. {
  928. //lg.WriteLog(1, "打印开始");
  929. #region 获取打印信息,若需要打印则调用打印操作
  930. List<PrintCls> prrintC = new List<PrintCls>();
  931. string sql = @"select actual_no actualNo,
  932. prediction_no predictionNo,
  933. car_no carNo,
  934. matter_no matterNo,
  935. matter_name matterName,
  936. gross_weight grossWeight,
  937. gross_time grossTime,
  938. tare_weight tareWeight,
  939. tare_time tareTime,
  940. net_weight netWeight,
  941. net_Time netTime,
  942. 'x' meterTypeNo,
  943. meter_type_name meterTypeName,
  944. spec_name specName,
  945. forwarding_unit_name forwardingUnitName,
  946. receiving_uint_name receivingUintName,
  947. load_point_name loadPointName,
  948. add_weight addWeight,
  949. '1' uploadFlag --1结净数据 0一次表数据
  950. from meter_work_car_actual where actual_first1_no = '" + firstNo + @"' or actual_first2_no='" + firstNo + @"'
  951. union all
  952. select t.actual_first_no actualNo,
  953. t.prediction_no predictionNo,
  954. t.car_no carNo,
  955. t.matter_no matterNo,
  956. t.matter_name matterName,
  957. t.meter_weight grossWeight,
  958. t.create_time grossTime,
  959. 0 tareWeight,
  960. t.create_time tareTime,
  961. 0 netWeight,
  962. null netTime,
  963. t.weight_type meterTypeNo, --0毛重 否则皮重
  964. t.meter_type_name meterTypeName,
  965. t.spec_name specName,
  966. t.forwarding_unit_name forwardingUnitName,
  967. t.receiving_uint_name receivingUintName,
  968. t.load_point_name loadPointName,
  969. t.add_weight addWeight,
  970. '0' uploadFlag
  971. from METER_WORK_CAR_ACTUAL_FIRST t
  972. where t.actual_first_no = '" + firstNo + "' or t.actual_first_no = (select max(actual_first2_no) from meter_work_car_actual where actual_first1_no='" + firstNo + "')";
  973. //查下如果有毛重或者结净数据,则可进入打印判断
  974. PbModelDbService<List<MeterWorkCarActual>> pbModelDbService = new PbModelDbService<List<MeterWorkCarActual>>();
  975. RESTfulResult<List<MeterWorkCarActual>> rm = pbModelDbService.executeSqlDataWf(sql);
  976. //lg.WriteLog(1, "打印第一个sql:" + sql);
  977. if (rm.Succeed)
  978. {
  979. if (rm.Data != null && rm.Data.Count > 0)
  980. {
  981. //2021年6月26日 对一车联运的进行处理;用一次计量编号查二次计量数据,
  982. sql = @"select t3.actual_no actualNo, t3.prediction_no predictionNo, t3.car_no carNo, t3.matter_no matterNo, t3.matter_name matterName,
  983. t3.gross_weight grossWeight, t3.gross_time grossTime, t3.tare_weight tareWeight, t3.tare_time tareTime, t3.net_weight netWeight,
  984. t3.net_Time netTime, 'x' meterTypeNo, t3.meter_type_name meterTypeName, t3.spec_name specName,
  985. t3.forwarding_unit_name forwardingUnitName, t3.receiving_uint_name receivingUintName, t3.load_point_name loadPointName,
  986. t3.add_weight addWeight, '1' uploadFlag from meter_work_car_actual_first t2
  987. left join meter_work_car_actual t3 on t2.actual_first_no = t3.actual_first1_no
  988. where t2.prediction_combination in (select t.prediction_combination
  989. from meter_work_car_actual_first t
  990. where t3.value_flag = '0' and t.actual_first_no = '" + firstNo + @"' and
  991. instr(t.prediction_combination, '20') > 0) order by t3.net_time desc";
  992. RESTfulResult<List<MeterWorkCarActual>> rmLy = pbModelDbService.executeSqlDataWf(sql);
  993. if (rmLy.Succeed && rmLy.Data != null && rmLy.Data.Count == 1)
  994. {
  995. rm.Data = rmLy.Data; //一车联运,将毛重替换为净重数据
  996. }
  997. //若有毛重或者净重,找到对应数据的物料信息,若有,那么去找打印配置信息数据
  998. List<MeterWorkCarActual> mwa = rm.Data.Where(s => !string.IsNullOrEmpty(s.matterNo) && (s.meterTypeNo == "x" || s.meterTypeNo == "0")).ToList();
  999. if (mwa != null && mwa.Count > 0 && !string.IsNullOrEmpty(mwa[0].matterNo))
  1000. {
  1001. sql = @"select BASE_SPOT_NO baseSpotNo,
  1002. load_point_no loadPointNo,
  1003. matter_no matterNo,
  1004. METER_TYPE_NO meterTypeNo,
  1005. weight_type_name weightTypeName,
  1006. PRINT_NUM printNum
  1007. from METER_BASE_BILL_PRINT
  1008. where matter_no = '" + mwa[0].matterNo + @"'
  1009. and nvl(BASE_SPOT_NO, '" + PbCache.sportInfo.baseSpotNo + @"') = '" + PbCache.sportInfo.baseSpotNo + @"'
  1010. and nvl(load_point_no, '" + (mwa[0].loadPointNo == null ? "1" : mwa[0].loadPointNo) + @"') = '" + (mwa[0].loadPointNo == null ? "1" : mwa[0].loadPointNo) + @"'";
  1011. //lg.WriteLog(1, "打印第二个sql:" + sql); and nvl(METER_TYPE_NO, '" + PbCache.bussinessTypeCode + @"') = '" + PbCache.bussinessTypeCode + @"'
  1012. //and nvl(METER_TYPE_NO, '') = ''
  1013. PbModelDbService<List<MeterBaseBillPrint>> pbPrintService = new PbModelDbService<List<MeterBaseBillPrint>>();
  1014. RESTfulResult<List<MeterBaseBillPrint>> rmPint = pbPrintService.executeSqlDataWf(sql);
  1015. if (rmPint.Succeed)
  1016. {
  1017. if (rmPint.Data != null && rmPint.Data.Count > 0)
  1018. {
  1019. //若有净重信息:1毛重时间晚于皮重时间,则打印毛、皮、净重,2毛重早于皮重,打印皮、净
  1020. //若只有毛重信息则打印毛重
  1021. List<MeterBaseBillPrint> lGrossprint = rmPint.Data.Where(s => s.weightTypeName.Contains("毛")).ToList();
  1022. List<MeterBaseBillPrint> lTarePrint = rmPint.Data.Where(s => s.weightTypeName.Contains("皮")).ToList();
  1023. List<MeterBaseBillPrint> lNetprint = rmPint.Data.Where(s => s.weightTypeName.Contains("净")).ToList();
  1024. List<MeterWorkCarActual> mwaChild = mwa.Where(s => s.meterTypeNo == "x").ToList();
  1025. if (mwaChild != null && mwaChild.Count > 0) //若有净重信息
  1026. {
  1027. if (lTarePrint != null && lTarePrint.Count > 0)
  1028. {
  1029. //获取非毛,非净重信息如果没有则用的期限皮,此时不打,否则则打印
  1030. MeterWorkCarActual mwca = rm.Data.Where(s => s.meterTypeNo != "x" && s.meterTypeNo != "0").FirstOrDefault();
  1031. if (mwca != null)
  1032. {
  1033. PrintCls cls = new PrintCls();
  1034. cls.printNum = (int)(lTarePrint[0].printNum == null ? 0 : lTarePrint[0].printNum.Value);
  1035. cls.iType = 1;//皮重
  1036. cls.printDb = mwca;
  1037. prrintC.Add(cls);
  1038. }
  1039. }
  1040. if (lGrossprint != null && lGrossprint.Count > 0)
  1041. {
  1042. //获取毛重信息
  1043. MeterWorkCarActual mwca = rm.Data.Where(s => s.meterTypeNo == "0").FirstOrDefault();
  1044. if (mwca != null)
  1045. {
  1046. PrintCls cls = new PrintCls();
  1047. cls.printNum = (int)(lGrossprint[0].printNum == null ? 0 : lGrossprint[0].printNum.Value);
  1048. cls.iType = 0;//毛重
  1049. cls.printDb = mwca;
  1050. prrintC.Add(cls);
  1051. }
  1052. }
  1053. if (lNetprint != null && lNetprint.Count > 0)
  1054. {
  1055. //获取净重信息
  1056. MeterWorkCarActual mwca = rm.Data.Where(s => s.meterTypeNo == "x").FirstOrDefault();
  1057. if (mwca != null)
  1058. {
  1059. PrintCls cls = new PrintCls();
  1060. cls.printNum = (int)(lNetprint[0].printNum == null ? 0 : lNetprint[0].printNum.Value);
  1061. cls.iType = 2;//净重
  1062. cls.printDb = mwca;
  1063. prrintC.Add(cls);
  1064. }
  1065. }
  1066. }
  1067. else //只有毛重信息则打印毛重
  1068. {
  1069. if (lGrossprint != null && lGrossprint.Count > 0)
  1070. {
  1071. //获取毛重信息
  1072. MeterWorkCarActual mwca = rm.Data.Where(s => s.meterTypeNo == "0").FirstOrDefault();
  1073. if (mwca != null)
  1074. {
  1075. PrintCls cls = new PrintCls();
  1076. cls.printNum = (int)(lGrossprint[0].printNum == null ? 0 : lGrossprint[0].printNum.Value);
  1077. cls.iType = 0;//毛重
  1078. cls.printDb = mwca;
  1079. prrintC.Add(cls);
  1080. }
  1081. }
  1082. }
  1083. if (prrintC != null && prrintC.Count > 0)
  1084. {
  1085. FrmMessage frmMessage = FrmMess("是否打印第【1】张票据!", "打印");
  1086. if (frmMessage.ShowDialog(this) == DialogResult.OK)
  1087. {
  1088. l.WriteLog(10, "车号【" + PbCache.lockCarNo + "】是否打印选择了【是】");
  1089. l.WriteLog(15, PbCache.lockCarNo + "是否打印选择了【是】");
  1090. strFirstNo = firstNo;
  1091. //printDocument1.PrinterSettings.PrinterName = PbCache.sportInfo.printerName;//strPntSvrName;
  1092. System.Drawing.Printing.PaperSize customSize1 = new System.Drawing.Printing.PaperSize("TestPaper", 398, 433); //101mm*110mm,换算成英寸
  1093. printDocument1.DefaultPageSettings.PaperSize = customSize1;//将自定义的Papersize赋给PrintDocument
  1094. System.Drawing.Printing.Margins marginss = new System.Drawing.Printing.Margins(0, 0, 0, 0);
  1095. printDocument1.DefaultPageSettings.Margins = marginss;
  1096. printDocument1.PrintController = new System.Drawing.Printing.StandardPrintController();
  1097. foreach (PrintCls db in prrintC)
  1098. {
  1099. switch (db.printDb.meterTypeNo)
  1100. {
  1101. case "0": //毛
  1102. db.qrCode = db.printDb.actualNo + "," + db.printDb.grossWeight + "," + "1";
  1103. break;
  1104. case "x": //净
  1105. db.qrCode = db.printDb.actualNo + "," + db.printDb.netWeight + "," + "2";
  1106. break;
  1107. default: //皮
  1108. db.qrCode = db.printDb.actualNo + "," + db.printDb.grossWeight + "," + "1";
  1109. break;
  1110. }
  1111. RESTfulResult<string> rQRCode = workCarActualFirstService.doQRCodeWf(db.qrCode);
  1112. db.qrCode = rQRCode.Data;
  1113. for (int i = 0; i < db.printNum; i++)
  1114. {
  1115. if (i == 0)
  1116. {
  1117. printData = db;
  1118. printDocument1.Print();
  1119. l.WriteLog(10, "当前第" + (i + 1) + "次打印:" + printData.iType + " 车号:" + db.printDb.carNo + ",二维码:" + db.qrCode);
  1120. }
  1121. else
  1122. {
  1123. FrmMessage frmMessageContinue = FrmMess("已打印【" + i + "】张,是否继续打印第【" + (i + 1) + "】张票据!", "打印");
  1124. if (frmMessageContinue.ShowDialog(this) == DialogResult.OK)
  1125. {
  1126. printData = db;
  1127. printDocument1.Print();
  1128. l.WriteLog(10, "当前第" + (i + 1) + "次打印:" + printData.iType + " 车号:" + db.printDb.carNo + ",二维码:" + db.qrCode);
  1129. }
  1130. else
  1131. {
  1132. l.WriteLog(10, "车号【" + PbCache.lockCarNo + "】第" + i + "次是否打印,选择了【否】");
  1133. }
  1134. }
  1135. //printData = db;
  1136. //printDocument1.Print();
  1137. //lg.WriteLog(11, "当前打印:" + printData.iType + " 车号:" + db.printDb.carNo);
  1138. }
  1139. }
  1140. }
  1141. else
  1142. {
  1143. l.WriteLog(10, "车号【" + PbCache.lockCarNo + "】是否打印选择了【否】");
  1144. l.WriteLog(15, PbCache.lockCarNo + "是否打印选择了【否】");
  1145. }
  1146. }
  1147. }
  1148. }
  1149. else
  1150. {
  1151. l.WriteLog(10, "车号【" + PbCache.lockCarNo + "】获取打印配置数据信息异常sql:【" + sql + "】");
  1152. }
  1153. }
  1154. }
  1155. }
  1156. else
  1157. {
  1158. l.WriteLog(10, "车号【" + PbCache.lockCarNo + "】获取计量数据信息异常sql:【" + sql + "】");
  1159. }
  1160. #endregion 获取打印信息,若需要打印则调用打印操作
  1161. }
  1162. catch (Exception ex)
  1163. {
  1164. l.WriteLog(10, "车号【" + PbCache.lockCarNo + "】打印异常" + ex);
  1165. }
  1166. }
  1167. private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
  1168. {
  1169. try
  1170. {
  1171. if (printData != null && printData.printDb != null)
  1172. {
  1173. printClass.PrintAllPage(e, printData.printDb, printData.qrCode);
  1174. /*
  1175. //结净打印
  1176. if (printData.iType == 2)
  1177. {
  1178. printClass.PrintPage(e, printData.printDb, PbCache.strQRCode);
  1179. }
  1180. else //非结净打印
  1181. {
  1182. printClass.PrintWgtPage(e, printData.printDb, PbCache.strQRCode);
  1183. }
  1184. //*/
  1185. }
  1186. }
  1187. catch (Exception ex)
  1188. {
  1189. l.WriteLog(11, "打印异常" + ex);
  1190. }
  1191. }
  1192. /// <summary>
  1193. /// 重量大于500,直接打开主界面
  1194. /// </summary>
  1195. /// <param name="sender"></param>
  1196. /// <param name="e"></param>
  1197. private void timer1_Tick(object sender, EventArgs e)
  1198. {
  1199. //timer1.Stop();
  1200. try
  1201. {
  1202. if (!isOpened && PbCache.collect?.weight > 500)
  1203. {
  1204. PbCache.bussinessTypeName = "";
  1205. PbCache.bussinessTypeCode = "";
  1206. if (fcc.Visible == false)
  1207. {
  1208. fcc.Visible = true;
  1209. fcc.init();
  1210. }
  1211. }
  1212. timer1.Interval = 1000;
  1213. }
  1214. catch (Exception ee)
  1215. {
  1216. //GlobalInstanceController.Instance.LastCallMessage = ee.Message;
  1217. timer1.Interval = 1000;
  1218. }
  1219. //timer1.Start();
  1220. }
  1221. /// <summary>
  1222. /// 操作Live表的数据:零点报警
  1223. /// </summary>
  1224. private void doOperateLive()
  1225. {
  1226. if (PbCache.collect_no == null)
  1227. {
  1228. return;
  1229. }
  1230. List<LiveData> ll = MemoClass.getWarnInfo(PbCache.collect_no);
  1231. if (ll != null)
  1232. {
  1233. foreach (LiveData lv in ll)
  1234. {
  1235. switch (lv.Tagname.Replace(PbCache.collect_no, ""))
  1236. {
  1237. case "StaticStatus"://车辆检测 "0、东西方向激光均无报警;否则报警
  1238. break;
  1239. case "SwitchLight"://PLC红绿灯控制模式状态 "PLC有三种控制模式:1、自动、2、远控;3、检修
  1240. break;
  1241. case "LightWest"://红绿灯:1、为绿灯;2、为红灯;"
  1242. break;
  1243. case "ZeroWeightStatus": //0、其它,1、零点报警,红绿灯变红,
  1244. if (((lv.Value ?? "0") + "").Equals("1"))
  1245. {
  1246. doInsertZeroAlarm();
  1247. PbCache.isZeroAlarm = true;
  1248. }
  1249. else
  1250. {
  1251. PbCache.isZeroAlarm = false;
  1252. }
  1253. break;
  1254. }
  1255. }
  1256. }
  1257. }
  1258. /// <summary>
  1259. /// 操作Live表的数据:零点报警
  1260. /// </summary>
  1261. private void doLive()
  1262. {
  1263. if (PbCache.collect_no == null)
  1264. {
  1265. return;
  1266. }
  1267. List<LiveData> ll = MemoClass.getWarnInfo(PbCache.collect_no);
  1268. MeterWorkMonitor mwm = new MeterWorkMonitor();
  1269. mwm.pointNo = PbCache.sportInfo.baseSpotNo;
  1270. mwm.redGreenLightState = "0";
  1271. if (ll != null)
  1272. {
  1273. foreach (LiveData lv in ll)
  1274. {
  1275. switch (lv.Tagname.Replace(PbCache.collect_no, ""))
  1276. {
  1277. case "PowerStatus":
  1278. mwm.powerState = lv.Value.ToString();
  1279. break;
  1280. case "PlcWatchDog":
  1281. if (int.Parse(lv.Value.ToString()) >= 0 && int.Parse(lv.Value.ToString()) <= 0)
  1282. {
  1283. mwm.plcState = 0.ToString();
  1284. }
  1285. break;
  1286. case "InfraredWest":
  1287. if (lv.Value.ToString() == "2")
  1288. {
  1289. mwm.leftInfraredRayState = "0";
  1290. }
  1291. else
  1292. {
  1293. mwm.leftInfraredRayState = lv.Value.ToString();
  1294. }
  1295. break;
  1296. case "InfraredEast":
  1297. if (lv.Value.ToString() == "2")
  1298. {
  1299. mwm.rightInfraredRayState = "0";
  1300. }
  1301. else
  1302. {
  1303. mwm.rightInfraredRayState = lv.Value.ToString();
  1304. }
  1305. break;
  1306. case "AmplifierState":
  1307. mwm.amplifierState = lv.Value.ToString();
  1308. break;
  1309. case "LampState":
  1310. if (lv.Value.ToString() == "2")
  1311. {
  1312. mwm.lampState = "0";
  1313. }
  1314. else
  1315. {
  1316. mwm.lampState = lv.Value.ToString();
  1317. }
  1318. break;
  1319. case "InfraredLeft":
  1320. if (lv.Value.ToString() == "2")
  1321. {
  1322. mwm.frontInfraredRayState = "0";
  1323. }
  1324. else
  1325. {
  1326. mwm.frontInfraredRayState = lv.Value.ToString();
  1327. }
  1328. break;
  1329. case "InfraredRight":
  1330. if (lv.Value.ToString() == "2")
  1331. {
  1332. mwm.rearInfraredRayState = "0";
  1333. }
  1334. else
  1335. {
  1336. mwm.rearInfraredRayState = lv.Value.ToString();
  1337. }
  1338. break;
  1339. case "ZeroWeightStatus":
  1340. mwm.zeroState = lv.Value.ToString();
  1341. break;
  1342. case "RfidState":
  1343. mwm.rfidState = lv.Value.ToString();
  1344. if (((lv.Value ?? "0") + "").Equals("1"))
  1345. {
  1346. doInsertZeroAlarm();
  1347. PbCache.isZeroAlarm = true;
  1348. }
  1349. else
  1350. {
  1351. PbCache.isZeroAlarm = false;
  1352. }
  1353. break;
  1354. }
  1355. }
  1356. }
  1357. RESTfulResult<string> rms = meterWorkMonitor.doUpdateWf(mwm);
  1358. }
  1359. /// <summary>
  1360. /// 新增零点报警的数据
  1361. /// </summary>
  1362. private void doInsertZeroAlarm()
  1363. {
  1364. if (!PbCache.isZeroAlarm)
  1365. {
  1366. PbCache.isZeroAlarm = true;
  1367. MeterWorkZeroAlarm workZeroAlarm = new MeterWorkZeroAlarm();
  1368. workZeroAlarm.zeroWeight = PbCache.collect.weight;
  1369. workZeroAlarm.spotTypeNo = PbCache.sportInfo.spotTypeNo;
  1370. workZeroAlarm.spotTypeName = PbCache.sportInfo.spotTypeName;
  1371. workZeroAlarm.baseSpotNo = PbCache.sportInfo.baseSpotNo;
  1372. workZeroAlarm.baseSpotName = PbCache.sportInfo.baseSpotName;
  1373. workZeroAlarm.scalePointNo = PbCache.collect_no;
  1374. workZeroAlarm.createManNo = PbCache.sportInfo.baseSpotNo;
  1375. workZeroAlarm.createManName = PbCache.sportInfo.baseSpotName;
  1376. RESTfulResult<String> rms = zeroAlarmService.doInsertZeroAlarm(workZeroAlarm);
  1377. if (rms.Succeed)
  1378. {
  1379. l.WriteLog(20, "新增成功:" + workZeroAlarm.baseSpotName + ":" + workZeroAlarm.zeroWeight);
  1380. }
  1381. else
  1382. {
  1383. l.WriteLog(20, "操作失败:" + workZeroAlarm.baseSpotName + ":" + workZeroAlarm.zeroWeight + rms.Data + rms.Message);
  1384. }
  1385. }
  1386. }
  1387. private void button3_Click(object sender, EventArgs e)
  1388. {
  1389. string limsResult = "";
  1390. JGLimsInterface gLimsInterface = new JGLimsInterface();
  1391. }
  1392. /// <summary>
  1393. /// 查询重量信息,显示在界面上面
  1394. /// </summary>
  1395. /// <param name="sender"></param>
  1396. /// <param name="e"></param>
  1397. private void button4_Click(object sender, EventArgs e)
  1398. {
  1399. try
  1400. {
  1401. string sqls = @"select '毛重:' || t.gross_weight / 1000 || ' T / 皮重:' || t.tare_weight / 1000 || ' T / 净重:' || t.net_weight / 1000 || ' T ' as text
  1402. from meter_work_car_actual t where t.value_flag = '0' and T.Prediction_No = '" + txtPlanNo.Text + @"'";
  1403. PbModelDbService<List<PbModelDb>> pbRelation = new PbModelDbService<List<PbModelDb>>();
  1404. RESTfulResult<List<PbModelDb>> rmRelation = pbRelation.executeSqlDataWf(sqls);
  1405. if (rmRelation.Succeed && rmRelation.Data != null && rmRelation.Data.Count > 0)
  1406. {
  1407. MessageBox.Show(rmRelation.Data[0].text);
  1408. }
  1409. else
  1410. {
  1411. MessageBox.Show("空");
  1412. }
  1413. }
  1414. catch (Exception ex)
  1415. {
  1416. }
  1417. }
  1418. private void button1_Click(object sender, EventArgs e)
  1419. {
  1420. isOpened = false;
  1421. testFlag = true;
  1422. PbCache.isTest= true;
  1423. testWgt = (int)numericUpDown1.Value;
  1424. //CollectModel model = new CollectModel();
  1425. //model.weight = testWgt;
  1426. //PbCache.collect = model;
  1427. testCarNo = textBox1.Text.Trim();
  1428. testPlanNo = txtPlanNo.Text.Trim();
  1429. }
  1430. private void Form1_FormClosing(object sender, FormClosingEventArgs e)
  1431. {
  1432. collection.Stop();
  1433. imageCurlControl.Stop();
  1434. sweepCodeClass.CloseThread();
  1435. sweepCodeClass2.CloseThread();
  1436. timer1.Stop();
  1437. timer1.Dispose();
  1438. }
  1439. private bool SystemUpdate(bool isMessage)
  1440. {
  1441. ReleaseList releaseList = new ReleaseList(Application.StartupPath + @"\" + GlobalVariable.Instance.ReleaseFileName);
  1442. DownloadTools dt = new DownloadTools();
  1443. try
  1444. {
  1445. bool isDownload = dt.IsDownloadFile(GlobalVariable.Instance.LocalPath, GlobalVariable.Instance.ReleaseURL, GlobalVariable.Instance.ReleaseFileName);
  1446. if (!isDownload)
  1447. {
  1448. if (isMessage) MessageBox.Show("无法连接到远程主机!", Application.ProductName);
  1449. return false;
  1450. }
  1451. }
  1452. catch (Exception e)
  1453. {
  1454. MessageBox.Show(e.Message);
  1455. }
  1456. bool flag = this.CheckUpdate(releaseList);
  1457. if (flag)
  1458. {
  1459. MessageBox.Show("有新版本,现在更新");
  1460. string t = dt.DownloadFile(Application.StartupPath, GlobalVariable.Instance.ReleaseURL, GlobalVariable.Instance.ApplicationUpdater);
  1461. this.Close();
  1462. Application.Exit();
  1463. GC.Collect();
  1464. Process.Start(Application.StartupPath + @"\" + GlobalVariable.Instance.ApplicationUpdater);
  1465. return true;
  1466. }
  1467. else
  1468. {
  1469. if (isMessage) MessageBox.Show("你的系统已经是最新版本,不需要更新!", Application.ProductName);
  1470. return false;
  1471. }
  1472. }
  1473. private bool CheckUpdate(ReleaseList localRelease)
  1474. {
  1475. try
  1476. {
  1477. string fileNameAll = Application.StartupPath + "\\" + GlobalVariable.Instance.LocalPath + "\\" + GlobalVariable.Instance.ReleaseFileName;
  1478. ReleaseList remoteRelease = new ReleaseList(fileNameAll);
  1479. return (((localRelease != null) && (remoteRelease != null)) && localRelease.ReleaseDate.CompareTo(remoteRelease.ReleaseDate) < 0);
  1480. }
  1481. catch (Exception exception)
  1482. {
  1483. MessageBox.Show(exception.Message);
  1484. }
  1485. return false;
  1486. }
  1487. }
  1488. }