Form1.cs 77 KB

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