Form1.cs 78 KB

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