UAS_出货标签管理.cs 133 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736
  1. using System;
  2. using System.Data;
  3. using System.Drawing;
  4. using System.Windows.Forms;
  5. using System.Text.RegularExpressions;
  6. using System.Text;
  7. using System.Collections.Generic;
  8. using System.Diagnostics;
  9. using LabelManager2;
  10. using UAS_LabelMachine.PublicMethod;
  11. using UAS_LabelMachine.Entity;
  12. using UAS_LabelMachine.PublicForm;
  13. using System.Threading;
  14. using System.IO;
  15. using System.IO.Ports;
  16. using UAS_LabelMachine.CustomControl;
  17. using System.Reflection;
  18. namespace UAS_LabelMachine
  19. {
  20. public partial class UAS_出货标签打印 : Form
  21. {
  22. //自适应屏幕
  23. AutoSizeFormClass asc = new AutoSizeFormClass();
  24. DataHelper dh;
  25. DataHelper dh1;
  26. SqliteDBHelper adh;
  27. SqliteDBHelper back_adh;
  28. DataTable dt;
  29. StringBuilder sql = new StringBuilder();
  30. /// <summary>
  31. /// CodeSoft新建打印机引擎
  32. /// </summary>
  33. ApplicationClass lbl;
  34. /// <summary>
  35. /// 单盘打印文件
  36. /// </summary>
  37. Document SingleDoc;
  38. /// <summary>
  39. /// 中盒打印文件
  40. /// </summary>
  41. Document MidDoc;
  42. /// <summary>
  43. /// 外箱打印文件
  44. /// </summary>
  45. Document OutBoxDoc;
  46. /// <summary>
  47. /// Loading窗口
  48. /// </summary>
  49. SetLoadingWindow stw;
  50. /// <summary>
  51. /// 弹窗线程
  52. /// </summary>
  53. Thread thread;
  54. string PI_ID;
  55. /// <summary>
  56. /// 当前扫描的所在行
  57. /// </summary>
  58. int CurrentRowIndex = 0;
  59. /// <summary>
  60. /// 正则表达式用于项目匹配
  61. /// </summary>
  62. Regex reg;
  63. bool logout = false;
  64. DataTable SingleLabelParam;
  65. DataTable MidLabelParam;
  66. DataTable OutLabelParam;
  67. /// <summary>
  68. /// 存放单盘的ID
  69. /// </summary>
  70. List<string> SingleID = new List<string>();
  71. /// <summary>
  72. /// 单盘的打印参数
  73. /// </summary>
  74. List<string> SingleBoxArgument = new List<string>();
  75. /// <summary>
  76. /// 存放中盒的ID和盒号
  77. /// </summary>
  78. Dictionary<string, string> MidIDAndOutboxcode = new Dictionary<string, string>();
  79. /// <summary>
  80. /// 中盒的打印参数
  81. /// </summary>
  82. List<string> MidBoxArgument = new List<string>();
  83. /// <summary>
  84. /// 默认采集了指定的数据上传
  85. /// </summary>
  86. int UploadNum = 100;
  87. /*需要重绘的Cell*/
  88. Dictionary<DataGridViewCell, bool> PaintCell = new Dictionary<DataGridViewCell, bool>();
  89. /// <summary>
  90. /// 是否通过选择Combox来改变打开的文件
  91. /// </summary>
  92. bool ComBoxClickChangeLabelDoc = false;
  93. /// <summary>
  94. /// 附加信息DataTable
  95. /// </summary>
  96. DataTable Attach;
  97. /// <summary>
  98. /// 采集策略DataTable
  99. /// </summary>
  100. DataTable ScanGroup;
  101. /// <summary>
  102. /// 采集明细DataTable
  103. /// </summary>
  104. DataTable ScanItem;
  105. public UAS_出货标签打印(string Master)
  106. {
  107. //设置窗体的双缓冲
  108. this.SetStyle(ControlStyles.OptimizedDoubleBuffer | ControlStyles.ResizeRedraw | ControlStyles.AllPaintingInWmPaint, true);
  109. this.UpdateStyles();
  110. InitializeComponent();
  111. //利用反射设置DataGridView的双缓冲
  112. Type dgvType = this.LabelInf.GetType();
  113. PropertyInfo pi = dgvType.GetProperty("DoubleBuffered", BindingFlags.Instance | BindingFlags.NonPublic);
  114. pi.SetValue(this.LabelInf, true, null);
  115. Text = Text + "-" + Master;
  116. }
  117. protected override void WndProc(ref Message m)
  118. {
  119. //拦截双击标题栏、移动窗体的系统消息
  120. if (m.Msg != 0xA3)
  121. {
  122. base.WndProc(ref m);
  123. }
  124. }
  125. private void 贴标机条码打印_Load(object sender, EventArgs e)
  126. {
  127. //杀死之前全部未关闭的进程
  128. Process[] processes = System.Diagnostics.Process.GetProcessesByName("lppa");
  129. for (int i = 0; i < processes.Length; i++)
  130. {
  131. processes[i].Kill();
  132. }
  133. //用计时器重置数据库链接
  134. LogManager.DoLog("程序启动,登陆人员【" + User.UserName + "】");
  135. dh = SystemInf.dh;
  136. dh1 = SystemInf.dh1;
  137. adh = SystemInf.adh;
  138. back_adh = SystemInf.back_adh;
  139. CheckForIllegalCrossThreadCalls = false;
  140. pi_inoutno.TableName = "prodinout";
  141. pi_inoutno.Field = "pi_inoutno";
  142. pi_inoutno.ValueField = "pi_inoutno";
  143. pi_inoutno.Condition = "pi_class in('出货单','拨出单')";
  144. pi_inoutno.Focus();
  145. Point pt = new Point();
  146. //禁止所有列的排序
  147. foreach (DataGridViewColumn dgv in LabelInf.Columns)
  148. {
  149. dgv.SortMode = DataGridViewColumnSortMode.NotSortable;
  150. }
  151. AutoCollection.Checked = true;
  152. int ScreenWidth = Screen.GetWorkingArea(pt).Width;
  153. //设置获取当前屏幕大小自动全屏但是保留任务栏
  154. Rectangle ScreenArea = Screen.GetWorkingArea(this);
  155. Top = 0;
  156. Left = 0;
  157. Width = ScreenArea.Width;
  158. Height = ScreenArea.Height;
  159. MidBoxCapacity.Value = Properties.Settings.Default.MidBoxCapacity;
  160. OutBoxCapacity.Value = Properties.Settings.Default.OutboxCapacity;
  161. asc.controllInitializeSize(this);
  162. asc.controlAutoSize(this);
  163. pi_inoutno.BringToFront();
  164. //实例化打印进程
  165. try
  166. {
  167. lbl = new ApplicationClass();
  168. SystemInf.lbl = lbl;
  169. }
  170. catch (Exception)
  171. {
  172. MessageBox.Show("未安装CodeSoft软件或者版本不正确");
  173. }
  174. RefreshDBConnect.Interval = 60000;
  175. RefreshDBConnect.Start();
  176. DataTable dt = (DataTable)adh.ExecuteSql("select * from cominfo", "select");
  177. DataRow[] dr;
  178. try
  179. {
  180. dr = dt.Select("comtype='FrontendCheck'");
  181. if (dr.Length > 0)
  182. {
  183. FrontendCheck.PortName = dr[0]["COM"].ToString();
  184. int sleeptime = 0;
  185. if (int.TryParse(dr[0]["DATAWAIT"].ToString(), out sleeptime))
  186. {
  187. FrontendCheck.SleepTime = sleeptime;
  188. }
  189. FrontendCheck.Tag = "FrontendCheck";
  190. FrontendCheck.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
  191. FrontendCheck.DataReceived += Serial_DataReceived;
  192. FrontendCheck.Open();
  193. }
  194. }
  195. catch (Exception ex)
  196. {
  197. MessageLog.AppendText("前端扫描" + ex.Message + "\n");
  198. }
  199. try
  200. {
  201. dr = dt.Select("comtype='BackendCheck'");
  202. if (dr.Length > 0)
  203. {
  204. BackendCheck.PortName = dr[0]["COM"].ToString();
  205. BackendCheck.Tag = "BackendCheck";
  206. int sleeptime = 0;
  207. if (int.TryParse(dr[0]["DATAWAIT"].ToString(), out sleeptime))
  208. {
  209. BackendCheck.SleepTime = sleeptime;
  210. }
  211. BackendCheck.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
  212. BackendCheck.DataReceived += Serial_DataReceived;
  213. BackendCheck.Open();
  214. }
  215. }
  216. catch (Exception ex)
  217. {
  218. MessageLog.AppendText("后端扫描" + ex.Message + "\n");
  219. }
  220. try
  221. {
  222. dr = dt.Select("comtype='PLC1'");
  223. if (dr.Length > 0)
  224. {
  225. if (!PLC1.IsOpen)
  226. {
  227. PLC1.PortName = dr[0]["COM"].ToString();
  228. PLC1.Tag = "PLC1";
  229. int sleeptime = 0;
  230. if (int.TryParse(dr[0]["DATAWAIT"].ToString(), out sleeptime))
  231. {
  232. PLC1.SleepTime = sleeptime;
  233. }
  234. PLC1.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
  235. PLC1.DataReceived += Serial_DataReceived;
  236. PLC1.Open();
  237. }
  238. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.DeviceStart, adh);
  239. MessageLog.AppendText("PLC启动成功\n", Color.Blue);
  240. }
  241. }
  242. catch (Exception ex)
  243. {
  244. MessageLog.AppendText("自动贴标机" + ex.Message + "\n");
  245. }
  246. try
  247. {
  248. dr = dt.Select("comtype='ManBackendCheck'");
  249. if (dr.Length > 0)
  250. {
  251. if (!ManBackendCheck.IsOpen)
  252. {
  253. ManBackendCheck.PortName = dr[0]["COM"].ToString();
  254. ManBackendCheck.Tag = "ManBackendCheck";
  255. int sleeptime = 0;
  256. if (int.TryParse(dr[0]["DATAWAIT"].ToString(), out sleeptime))
  257. {
  258. ManBackendCheck.SleepTime = sleeptime;
  259. }
  260. ManBackendCheck.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
  261. ManBackendCheck.DataReceived += Serial_DataReceived;
  262. ManBackendCheck.Open();
  263. }
  264. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.DeviceStart, adh);
  265. MessageLog.AppendText("PLC启动成功\n", Color.Blue);
  266. }
  267. }
  268. catch (Exception ex)
  269. {
  270. MessageLog.AppendText("手动后端复核" + ex.Message + "\n");
  271. }
  272. RefreshPLCInstruct();
  273. }
  274. string LotNo = "";
  275. string DateCode = "";
  276. string Order = "";
  277. string QTY = "";
  278. string PN = "";
  279. string OutBox = "";
  280. List<int> ManualCheckCount = new List<int>();
  281. //获取串口数据
  282. private void Serial_DataReceived(object sender, SerialDataReceivedEventArgs e)
  283. {
  284. try
  285. {
  286. string ErrorMsg = "";
  287. SerialPortWithTag port = sender as SerialPortWithTag;
  288. Thread.Sleep(port.SleepTime);
  289. int len = port.BytesToRead;
  290. byte[] readBuffer = new byte[len];
  291. port.Read(readBuffer, 0, len); //将数据读入缓存
  292. string msg = Encoding.ASCII.GetString(readBuffer, 0, len).Replace("\n", "").Replace("\r", "").Replace("\t", ""); //获取出入库产品编号
  293. if (LabelInf.Rows.Count == 0)
  294. return;
  295. int pib_pdno = int.Parse(LabelInf.Rows[CurrentRowIndex].Cells["pib_pdno"].Value.ToString());
  296. if (DetailRange.Checked)
  297. {
  298. //不在范围内的不进行处理
  299. if (!(pib_pdno >= DetailRange1.Value && pib_pdno <= DetailRange2.Value))
  300. {
  301. return;
  302. }
  303. }
  304. switch (port.Tag)
  305. {
  306. case "PLC1":
  307. ScanGroup = BaseUtil.filterDataTable(ScanGroup, "sg_autolabel<>0");
  308. //MessageLog.AppendText(msg + "\n", Color.Blue);
  309. ////返回的指令和设备执行的动作对应
  310. //foreach (var item in instruct)
  311. //{
  312. // //接收到的数据和指令的对应则
  313. // if (item.Value == msg)
  314. // {
  315. // }
  316. //}
  317. break;
  318. case "PLC2":
  319. ScanGroup = BaseUtil.filterDataTable(ScanGroup, "sg_autolabel<>0");
  320. break;
  321. case "FrontendCheck":
  322. ScanGroup = BaseUtil.filterDataTable(ScanGroup, "sg_autolabel<>0");
  323. //比对当前箱数量和容量
  324. FrontCollect.Text = msg;
  325. if (!FrontCheckFunction(msg, out ErrorMsg))
  326. {
  327. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.FrontDataDelete, adh);
  328. BaseUtil.PlaySound("Scan.Error.wav");
  329. MessageLog.AppendText(">>" + ErrorMsg + "\n", Color.Red);
  330. }
  331. else
  332. {
  333. if (cu_print_checkdatecode.Checked)
  334. {
  335. string datecode = LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value.ToString();
  336. string lotno = LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value.ToString();
  337. if (datecode == "" || lotno == "")
  338. {
  339. MessageLog.AppendText(">>设定必须采集DateCode内容,请先采集再打印\n", Color.Red);
  340. return;
  341. }
  342. }
  343. //勾选了单盘自动打印
  344. if (SingleLabelAutoPrint.Checked)
  345. {
  346. if (SingleLabelCombox.SelectedValue != null)
  347. {
  348. AutoPrintSingleLabel();
  349. }
  350. else
  351. {
  352. MessageBox.Show("未维护单盘标签");
  353. return;
  354. }
  355. }
  356. LabelInf.Rows[CurrentRowIndex].Cells["pib_ifpick"].Value = true;
  357. BaseUtil.PlaySound("Scan.Finish.wav");
  358. //勾选了中盒自动打印
  359. if (MidLabelAutoPrint.Checked)
  360. AutoPrintMidLabel();
  361. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.FrontDataPass, adh);
  362. LabelInf.Invalidate();
  363. RefreshProcessData();
  364. }
  365. break;
  366. case "BackendCheck":
  367. ScanGroup = BaseUtil.filterDataTable(ScanGroup, "sg_autolabel<>0");
  368. BackCheck.Text = msg;
  369. if (BackendCheckFunction(msg, "Auto", out ErrorMsg))
  370. {
  371. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.BackDataPass, adh);
  372. BaseUtil.PlaySound("Confirm.Finish.wav");
  373. }
  374. else
  375. {
  376. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.BackDataDelete, adh);
  377. BaseUtil.PlaySound("Confirm.Error.wav");
  378. MessageLog.AppendText(">>" + ErrorMsg + "\n", Color.Red);
  379. }
  380. break;
  381. case "ManBackendCheck":
  382. if (ManualBackCheck.Checked)
  383. {
  384. BackCheck.Text = msg;
  385. if (BackendCheckFunction(msg, "Manual", out ErrorMsg))
  386. {
  387. ManualCheckCount.Add(1);
  388. }
  389. else
  390. {
  391. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.BackDataDelete, adh);
  392. BaseUtil.PlaySound("Confirm.Error.wav");
  393. MessageLog.AppendText(">>" + ErrorMsg + "\n", Color.Red);
  394. }
  395. if (ManualCheckCount.Count == 2)
  396. {
  397. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.BackDataPass, adh);
  398. BaseUtil.PlaySound("Confirm.Finish.wav");
  399. ManualCheckCount.Clear();
  400. }
  401. }
  402. else
  403. {
  404. MessageLog.AppendText(">>该串口为手动复核串口,请选择手动后端复核模式\n", Color.Red);
  405. }
  406. break;
  407. default:
  408. break;
  409. }
  410. }
  411. catch (Exception ex)
  412. {
  413. LogManager.DoLog(ex.Message + ex.StackTrace);
  414. MessageLog.AppendText("接收返回消息异常!具体原因:" + ex.Message + ex.StackTrace, Color.Red);
  415. }
  416. }
  417. string year = "";
  418. string month = "";
  419. string day = "";
  420. string date = "";
  421. private bool RegexMatch(string CheckType, string msg, out string ErrorMsg)
  422. {
  423. ErrorMsg = "";
  424. bool Matched = false;
  425. for (int i = 0; i < ScanGroup.Rows.Count; i++)
  426. {
  427. string sg_name = ScanGroup.Rows[i]["sg_name"].ToString();
  428. string sg_brand = ScanGroup.Rows[i]["sg_brand"].ToString();
  429. string sg_script = ScanGroup.Rows[i]["sg_script"].ToString();
  430. string sg_id = ScanGroup.Rows[i]["sg_id"].ToString();
  431. reg = new Regex(sg_script);
  432. Match matchs1 = reg.Match(msg);
  433. DataTable dt = BaseUtil.filterDataTable(ScanItem, "sg_id=" + sg_id);
  434. if (matchs1.Success)
  435. {
  436. int rownum = 0;
  437. Matched = true;
  438. string ItemStr = "";
  439. foreach (var groupName in reg.GetGroupNames())
  440. {
  441. for (int j = 0; j < dt.Rows.Count; j++)
  442. {
  443. //如果组别名称相等的话
  444. if (groupName == dt.Rows[j]["si_name"].ToString())
  445. {
  446. ItemStr += dt.Rows[j]["si_item"].ToString() + ",";
  447. string si_expression = dt.Rows[j]["si_expression"].ToString();
  448. Regex si_exp;
  449. switch (dt.Rows[j]["si_item"].ToString())
  450. {
  451. case "DateCode":
  452. if (si_expression != "")
  453. {
  454. si_exp = new Regex(si_expression);
  455. Match mat = si_exp.Match(matchs1.Groups[reg.GroupNumberFromName(groupName)].Value);
  456. foreach (var dtgroup in si_exp.GetGroupNames())
  457. {
  458. if (dtgroup == dt.Rows[j]["si_name"].ToString())
  459. DateCode = mat.Groups[si_exp.GroupNumberFromName(dtgroup)].Value;
  460. }
  461. }
  462. else
  463. {
  464. DateCode = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
  465. }
  466. LogicHandler.GetTimeFromDatecode(dh, DateCode, pi_cardcode.Text, out year, out month, out day, out date);
  467. System.DateTime dtime;
  468. //有效期比对
  469. if (System.DateTime.TryParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime))
  470. {
  471. if ((System.DateTime.Now - dtime).Days > cu_print_limiteddate.Value)
  472. {
  473. MessageLog.AppendText(">>超出有效期\n", Color.Red);
  474. }
  475. }
  476. break;
  477. case "LotNo":
  478. LotNo = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
  479. break;
  480. case "PN":
  481. PN = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
  482. //自动匹配客户PN
  483. string sql = "select min(rownum) as rn from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'";
  484. if (CheckType == "FrontCheck")
  485. {
  486. sql += " and pib_ifpick=0 and " + (prodcodefront.Text == "" ? "pr_orispeccode" : prodcodefront.Text) + "='" + PN + "'";
  487. }
  488. else if (CheckType == "BackCheck")
  489. {
  490. sql += " and pib_ifrecheck=0 and " + (prodcodeback.Text == "" ? "pr_orispeccode" : prodcodeback.Text) + "='" + PN + "'";
  491. }
  492. DataTable pndt = (DataTable)adh.ExecuteSql(sql, "select");
  493. if (pndt.Rows[0][0].ToString() != "")
  494. {
  495. rownum = int.Parse(pndt.Rows[0]["rn"].ToString());
  496. //如果需要翻页的话
  497. if (!(rownum >= (PageSize * (CurrentPage - 1) + 1) && rownum <= PageSize * CurrentPage))
  498. {
  499. CurrentPage = rownum / PageSize + 1;
  500. LoadGridData();
  501. CurrentRowIndex = rownum % PageSize == 0 ? PageSize - 1 : rownum % PageSize - 1;
  502. if (CurrentRowIndex - 5 > 0)
  503. LabelInf.FirstDisplayedScrollingRowIndex = CurrentRowIndex - 5;
  504. else
  505. LabelInf.FirstDisplayedScrollingRowIndex = 0;
  506. }
  507. else
  508. {
  509. CurrentRowIndex = rownum % PageSize == 0 ? PageSize - 1 : rownum % PageSize - 1;
  510. if (CurrentRowIndex - 5 > 0)
  511. LabelInf.FirstDisplayedScrollingRowIndex = CurrentRowIndex - 5;
  512. else
  513. LabelInf.FirstDisplayedScrollingRowIndex = 0;
  514. }
  515. }
  516. else
  517. {
  518. ErrorMsg = "未能匹配到合适的原厂型号";
  519. }
  520. break;
  521. case "Order":
  522. Order = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
  523. if (LabelInf.Rows[CurrentRowIndex].Cells["pd_pocode"].Value.ToString() != Order)
  524. {
  525. ErrorMsg = "订单号不匹配";
  526. }
  527. break;
  528. case "QTY":
  529. if (si_expression != "")
  530. {
  531. si_exp = new Regex(si_expression);
  532. Match mat = si_exp.Match(matchs1.Groups[reg.GroupNumberFromName(groupName)].Value);
  533. foreach (var dtgroup in si_exp.GetGroupNames())
  534. {
  535. if (dtgroup == dt.Rows[j]["si_name"].ToString())
  536. {
  537. QTY = mat.Groups[si_exp.GroupNumberFromName(dtgroup)].Value;
  538. }
  539. }
  540. }
  541. else
  542. {
  543. QTY = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
  544. }
  545. break;
  546. case "OutBox":
  547. OutBox = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
  548. break;
  549. default:
  550. break;
  551. }
  552. }
  553. }
  554. }
  555. //如果品牌不对应的话则不能使用本次的匹配规则
  556. if (ErrorMsg == "" && ItemStr.Contains("QTY") && LabelInf.Rows[CurrentRowIndex].Cells["pib_qty"].Value.ToString() != QTY.ToString())
  557. {
  558. ErrorMsg = "数量不匹配";
  559. }
  560. if (ErrorMsg == "" && ItemStr.Contains("PO") && LabelInf.Rows[CurrentRowIndex].Cells["pd_pocode"].Value.ToString() != Order)
  561. {
  562. ErrorMsg = "订单号不匹配";
  563. }
  564. //如果匹配到的行的品牌和当前正则的品牌不相等结束本次循环
  565. if (LabelInf.Rows[CurrentRowIndex].Cells["pib_brand"].Value.ToString() == sg_brand)
  566. {
  567. break;
  568. }
  569. }
  570. }
  571. if (!Matched)
  572. {
  573. ErrorMsg = "未匹配到合适的采集策略";
  574. }
  575. if (ErrorMsg == "")
  576. {
  577. return true;
  578. }
  579. else
  580. {
  581. return false;
  582. }
  583. }
  584. private bool FrontCheckFunction(string msg, out string ErrorMsg)
  585. {
  586. ErrorMsg = "";
  587. //调用正则验证
  588. RegexMatch("FrontCheck", msg, out ErrorMsg);
  589. if (ErrorMsg != "")
  590. {
  591. return false;
  592. }
  593. else
  594. {
  595. //获取当前最大的箱号
  596. LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value = DateCode;
  597. LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value = LotNo;
  598. LabelInf.Rows[CurrentRowIndex].Cells["pib_ifmodify"].Value = true;
  599. SetOutboxBarcode();
  600. return true;
  601. }
  602. }
  603. //外箱条码号
  604. string OutBoxBarCode = "";
  605. //中盒条码号
  606. string MidBoxBarCode = "";
  607. string pibid1 = "";
  608. private bool BackendCheckFunction(string msg, string type, out string ErrorMsg)
  609. {
  610. ErrorMsg = "";
  611. DataTable dtt = LabelInf.DataSource as DataTable;
  612. MessageLog.AppendText(msg + "\n");
  613. string[] msgArr = msg.Split(back_sg_separator.Text.ToCharArray());
  614. //如果包含则分隔符则需要解析,如果不包含则直接前端解析
  615. if (!cu_print_checkonly.Checked)
  616. {
  617. //需要校验2项数据,完成校验后此项的值需要为2则表示校验成功
  618. List<string> CheckItem = new List<string>();
  619. string pibid = "";
  620. for (int i = 0; i < msgArr.Length; i++)
  621. {
  622. if (RecheckCuprodcode.Checked)
  623. {
  624. if (!CheckItem.Contains("客户料号") && !CheckItem.Contains("原厂型号"))
  625. {
  626. CheckItem.Add("客户料号");
  627. CheckItem.Add("原厂型号");
  628. }
  629. //直接验证两个值相等
  630. if (Equal.Checked)
  631. {
  632. pibid = back_adh.getFieldDataByCondition("prodiobarcode", "min(pib_id)", "pib_inoutno='" + pi_inoutno.Text + "' and " + (guestlabeldata.Text == "" ? "pd_custprodcode" : guestlabeldata.Text) + "='" + msgArr[i] + "' and pib_ifrecheck=0").ToString();
  633. if (pibid != "")
  634. {
  635. pibid1 = pibid;
  636. CheckItem.Remove("客户料号");
  637. }
  638. }
  639. //验证正则匹配过之后相等
  640. else if (Expression.Checked)
  641. {
  642. Regex re = new Regex(cu_print_regexpression.Text);
  643. Match matchs1 = re.Match(msgArr[i]);
  644. foreach (var groupName in re.GetGroupNames())
  645. {
  646. if (groupName == "custPN")
  647. {
  648. if (LabelInf.Rows[CurrentRowIndex].Cells[(guestlabeldata.Text == "" ? "pd_custprodcode" : guestlabeldata.Text)].Value.ToString() == matchs1.Groups[re.GroupNumberFromName(groupName)].Value)
  649. {
  650. pibid = back_adh.getFieldDataByCondition("prodiobarcode", "min(pib_id)", "pib_inoutno='" + pi_inoutno.Text + "' and " + (guestlabeldata.Text == "" ? "pd_custprodcode" : guestlabeldata.Text) + "='" + msgArr[i] + "' and pib_ifrecheck=0").ToString();
  651. if (pibid != "")
  652. {
  653. pibid1 = pibid;
  654. CheckItem.Remove("客户料号");
  655. }
  656. }
  657. }
  658. }
  659. }
  660. if (RegexMatch("BackCheck", msgArr[i], out ErrorMsg))
  661. {
  662. CheckItem.Remove("原厂型号");
  663. }
  664. }
  665. else if (RecheckBarcode.Checked)
  666. {
  667. if (!CheckItem.Contains("唯一条码") && !CheckItem.Contains("原厂型号"))
  668. {
  669. CheckItem.Add("唯一条码");
  670. CheckItem.Add("原厂型号");
  671. }
  672. pibid = back_adh.getFieldDataByCondition("prodiobarcode", "min(pib_id)", "pib_inoutno='" + pi_inoutno.Text + "' and pib_barcode='" + msgArr[i] + "' and pib_ifrecheck=0").ToString();
  673. if (pibid != "")
  674. {
  675. pibid1 = pibid;
  676. CheckItem.Remove("唯一条码");
  677. }
  678. else
  679. {
  680. if (RegexMatch("BackCheck", msgArr[i], out ErrorMsg))
  681. {
  682. CheckItem.Remove("原厂型号");
  683. }
  684. }
  685. }
  686. }
  687. //如果是自动复核或者手动复核扫描了两次数据的话
  688. if (CheckItem.Count == 0 || (type == "Manual" && CheckItem.Count == 1))
  689. {
  690. if (CheckItem.Count == 0 || (ManualCheckCount.Count == 1 && CheckItem.Count == 1))
  691. {
  692. string year = "0";
  693. string month = "0";
  694. string day = "0";
  695. string date = "";
  696. DataRow[] dr = LabelInfDataTable.Select("pib_id=" + pibid1 + " and pr_orispeccode='" + PN + "'");
  697. if (dr.Length > 0)
  698. {
  699. dr[0]["pib_ifrecheck"] = -1;
  700. dr[0]["pib_lotno"] = LotNo;
  701. dr[0]["pib_datecode"] = DateCode;
  702. try
  703. {
  704. LogicHandler.GetTimeFromDatecode(dh1, DateCode, pi_cardcode.Text, out year, out month, out day, out date);
  705. dr[0]["pib_year"] = year;
  706. dr[0]["pib_month"] = month;
  707. dr[0]["pib_day"] = day;
  708. }
  709. catch (Exception)
  710. {
  711. }
  712. }
  713. else
  714. {
  715. ErrorMsg = "未匹配到合适的原厂型号";
  716. return false;
  717. }
  718. back_adh.ExecuteSql("update prodiobarcode set pib_year='" + year + "',pib_month='" + month + "',pib_day='" + day + "',pib_ifrecheck=-1,pib_datecode='" + DateCode + "',pib_lotno='" + LotNo + "' where pib_id=" + pibid1 + " and pr_orispeccode='" + PN + "'", "update");
  719. }
  720. }
  721. else
  722. {
  723. string Item = "";
  724. for (int i = 0; i < CheckItem.Count; i++)
  725. {
  726. Item += CheckItem[i].ToString() + " ";
  727. }
  728. //如果通过正则校验,则不需要传递出来的错误信息了
  729. if (!CheckItem.Contains("原厂型号"))
  730. {
  731. ErrorMsg = "";
  732. }
  733. else
  734. {
  735. ErrorMsg = "【" + ErrorMsg + "】";
  736. }
  737. ErrorMsg += Item + "复核不通过";
  738. return false;
  739. }
  740. if (CheckItem.Count == 0 || (ManualCheckCount.Count == 1 && CheckItem.Count == 1))
  741. {
  742. LabelInf.Invalidate();
  743. RefreshProcessData();
  744. if (CurrentRowIndex - 5 > 0)
  745. LabelInf.FirstDisplayedScrollingRowIndex = CurrentRowIndex - 5;
  746. else
  747. LabelInf.FirstDisplayedScrollingRowIndex = 0;
  748. //如果成功上传了数据
  749. if (LogicHandler.CheckUploadData(pi_inoutno.Text, UploadNum))
  750. {
  751. for (int i = 0; i < dtt.Rows.Count; i++)
  752. {
  753. if (dtt.Rows[i]["pib_ifrecheck"].ToString() != "0" && dtt.Rows[i]["pib_ifupload"].ToString() == "0")
  754. {
  755. dtt.Rows[i]["pib_ifupload"] = -1;
  756. }
  757. }
  758. }
  759. return true;
  760. }
  761. else
  762. {
  763. if (type == "Manual" && CheckItem.Count == 1)
  764. return true;
  765. else
  766. return false;
  767. }
  768. }
  769. else
  770. {
  771. if (RegexMatch("BackCheck", msg, out ErrorMsg))
  772. {
  773. string year = "0";
  774. string month = "0";
  775. string day = "0";
  776. string date = "";
  777. LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value = DateCode;
  778. //解析DateCode,将值设置到年月日
  779. try
  780. {
  781. LogicHandler.GetTimeFromDatecode(dh1, DateCode, pi_cardcode.Text, out year, out month, out day, out date);
  782. LabelInf.Rows[CurrentRowIndex].Cells["pib_year"].Value = year;
  783. LabelInf.Rows[CurrentRowIndex].Cells["pib_month"].Value = month;
  784. LabelInf.Rows[CurrentRowIndex].Cells["pib_day"].Value = day;
  785. }
  786. catch (Exception) { }
  787. LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value = LotNo;
  788. LabelInf.Rows[CurrentRowIndex].Cells["pib_ifmodify"].Value = true;
  789. LabelInf.Rows[CurrentRowIndex].Cells["pib_ifrecheck"].Value = true;
  790. LabelInf.Rows[CurrentRowIndex].Cells["pib_ifpick"].Value = true;
  791. adh.ExecuteSQLTran("update prodiobarcode set pib_year='" + year + "',pib_month='" + month + "',pib_day='" + day + "',pib_lotno='" + LotNo + "',pib_datecode='" + DateCode + "',pib_ifpick=-1,pib_ifmodify=-1,pib_ifrecheck=-1 where pib_id=" + LabelInf.Rows[CurrentRowIndex].Cells["pib_id1"].Value);
  792. LogicHandler.CheckUploadData(pi_inoutno.Text, UploadNum);
  793. LabelInf.Invalidate();
  794. return true;
  795. }
  796. return false;
  797. }
  798. }
  799. //只执行一次窗体自适应
  800. bool AutoSized = false;
  801. private void 贴标机条码打印_SizeChanged(object sender, EventArgs e)
  802. {
  803. if (!AutoSized)
  804. {
  805. asc.controlAutoSize(this);
  806. AutoSized = true;
  807. }
  808. }
  809. private void LabelFormClose(object sender, EventArgs e)
  810. {
  811. if (GetGridOnly.Checked)
  812. GetInOutInfAndLabelFile();
  813. else
  814. {
  815. GetGridOnly.Checked = true;
  816. GetInOutInfAndLabelFile();
  817. GetGridOnly.Checked = false;
  818. }
  819. }
  820. private bool AutoPrintSingleLabel()
  821. {
  822. //用标签本身的变量作为最外层的循环条件去匹配;
  823. SinglePrint(LabelInf.Rows[CurrentRowIndex].Cells["pib_id1"].Value.ToString());
  824. LabelInf.Rows[CurrentRowIndex].Cells["pib_ifprint"].Value = true;
  825. return true;
  826. }
  827. //关闭窗口前提示用户确认
  828. private void 贴标机条码打印_FormClosing(object sender, FormClosingEventArgs e)
  829. {
  830. //如果不是注销的话
  831. if (!logout)
  832. {
  833. string close = MessageBox.Show(this.ParentForm, "是否关闭", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  834. if (close.ToString() != "Yes")
  835. e.Cancel = true;
  836. else
  837. {
  838. lbl.Quit();
  839. LogManager.DoLog("关闭程序");
  840. }
  841. }
  842. }
  843. /// <summary>
  844. /// 获取打印标签
  845. /// </summary>
  846. private void GetInOutInfAndLabelFile()
  847. {
  848. ComBoxClickChangeLabelDoc = false;
  849. Attach = (DataTable)dh.ExecuteSql("select lap_param lp_name,lap_value lp_sql from LabelAttachPARAMETER where lap_custcode='" + pi_cardcode.Text + "'", "select");
  850. sql.Clear();
  851. sql.Append("select to_char(nvl(cl_date,sysdate),'YYYY-MM-DD HH24:Mi:SS') cl_date,cl_labelname,cl_isdefault,la_id||'#'||cl_labelurl||'#'||to_char(cl_date,'YYYY-MM-DD HH24:Mi:SS') la_id,cl_custcode from customerlabel left join prodinout on pi_cardcode=cl_custcode ");
  852. sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
  853. sql.Append("and pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='单盘' order by cl_custcode");
  854. dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  855. SingleLabelCombox.DisplayMember = "cl_labelname";
  856. SingleLabelCombox.ValueMember = "la_id";
  857. SingleLabelCombox.DataSource = dt;
  858. if (SingleDoc != null)
  859. SingleDoc.Close();
  860. if (!GetGridOnly.Checked)
  861. for (int i = 0; i < dt.Rows.Count; i++)
  862. {
  863. string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
  864. string LabelName = dt.Rows[i]["cl_labelname"].ToString();
  865. System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
  866. FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
  867. if (time.ToString() != file.LastWriteTime.ToString())
  868. BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
  869. }
  870. if (SingleLabelCombox.Text != "")
  871. {
  872. SingleDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + SingleLabelCombox.Text);
  873. SingleDoc.Printer.SwitchTo(SingleLabelPrinter.Text);
  874. SingleLabelParam = (DataTable)dh.ExecuteSql("select lp_name,lp_sql,lp_valuetype from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + SingleLabelCombox.SelectedValue.ToString().Split('#')[0], "select");
  875. }
  876. sql.Clear();
  877. sql.Append("select to_char(nvl(cl_date,sysdate),'YYYY-MM-DD HH24:Mi:SS') cl_date,cl_labelname,cl_isdefault,la_id||'#'||cl_labelurl||'#'||to_char(cl_date,'YYYY-MM-DD HH24:Mi:SS') la_id,cl_custcode from customerlabel left join prodinout on pi_cardcode=cl_custcode ");
  878. sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
  879. sql.Append("and pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='中盒' order by cl_custcode");
  880. dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  881. MidLabelCombox.DisplayMember = "cl_labelname";
  882. MidLabelCombox.ValueMember = "la_id";
  883. MidLabelCombox.DataSource = dt;
  884. if (MidDoc != null)
  885. MidDoc.Close();
  886. if (!GetGridOnly.Checked)
  887. for (int i = 0; i < dt.Rows.Count; i++)
  888. {
  889. string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
  890. string LabelName = dt.Rows[i]["cl_labelname"].ToString();
  891. System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
  892. FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
  893. if (time.ToString() != file.LastWriteTime.ToString())
  894. BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
  895. }
  896. if (MidLabelCombox.Text != "")
  897. {
  898. MidDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + MidLabelCombox.Text);
  899. MidDoc.Printer.SwitchTo(MidLabelPrinter.Text);
  900. MidLabelParam = (DataTable)dh.ExecuteSql("select lp_name,lp_sql,lp_valuetype from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + MidLabelCombox.SelectedValue.ToString().Split('#')[0], "select");
  901. }
  902. //缓存中盒参数
  903. sql.Clear();
  904. sql.Append("select to_char(nvl(cl_date,sysdate),'YYYY-MM-DD HH24:Mi:SS') cl_date,cl_labelname,cl_isdefault,la_id||'#'||cl_labelurl||'#'||to_char(cl_date,'YYYY-MM-DD HH24:Mi:SS') la_id,cl_custcode from customerlabel left join prodinout on pi_cardcode=cl_custcode ");
  905. sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
  906. sql.Append("and pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='外箱' order by cl_custcode");
  907. dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  908. OutBoxCombox.DisplayMember = "cl_labelname";
  909. OutBoxCombox.ValueMember = "la_id";
  910. OutBoxCombox.DataSource = dt;
  911. if (OutBoxDoc != null)
  912. OutBoxDoc.Close();
  913. if (!GetGridOnly.Checked)
  914. for (int i = 0; i < dt.Rows.Count; i++)
  915. {
  916. string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
  917. string LabelName = dt.Rows[i]["cl_labelname"].ToString();
  918. System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
  919. FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
  920. if (time.ToString() != file.LastWriteTime.ToString())
  921. BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
  922. }
  923. if (OutBoxCombox.Text != "")
  924. {
  925. OutBoxDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + OutBoxCombox.Text);
  926. OutBoxDoc.Printer.SwitchTo(OutBoxPrinter.Text);
  927. OutLabelParam = (DataTable)dh.ExecuteSql("select lp_name,lp_sql,lp_valuetype from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + OutBoxCombox.SelectedValue.ToString().Split('#')[0], "select");
  928. }
  929. //缓存外箱参数
  930. ComBoxClickChangeLabelDoc = true;
  931. }
  932. /// <summary>
  933. /// 出入库单录入框的回车事件
  934. /// </summary>
  935. /// <param name="sender"></param>
  936. /// <param name="e"></param>
  937. private void pi_inoutno_KeyDown(object sender, KeyEventArgs e)
  938. {
  939. if (e.KeyCode == Keys.Enter)
  940. {
  941. CurrentPage = 1;
  942. sql.Clear();
  943. sql.Append("select pi_id,pi_cardcode,to_char(pi_date,'yyyymmdd')pi_date from prodinout where pi_inoutno='" + pi_inoutno.Text + "' and pi_pdastatus in('已捡料','已复核')");
  944. dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  945. if (dt.Rows.Count > 0)
  946. {
  947. pi_cardcode.Text = dt.Rows[0]["pi_cardcode"].ToString();
  948. pi_date.Text = dt.Rows[0]["pi_date"].ToString();
  949. PI_ID = dt.Rows[0]["pi_id"].ToString();
  950. //if (dh.GetConfig("AutoBarcode", "ProdInOut!Sale").ToString() != "")
  951. //{
  952. string[] param = new string[] { PI_ID, "" };
  953. dh.CallProcedure("GetCustBarcode", ref param);
  954. //}
  955. RefreshParamData();
  956. //查询所有的采集策略
  957. sql.Clear();
  958. sql.Append("select sg_id,sg_brand,si_item ,sg_script,max(si_expression)si_expression,instr(sg_name,si_name)itemindex,sg_name,si_name,sg_step from prodiodetail left join ");
  959. sql.Append("product on pd_prodcode=pr_code left join scangroup on nvl(pd_brand,pr_brand) =sg_brand left join scanitem on sg_id=si_sgid ");
  960. sql.Append("where pd_inoutno='" + pi_inoutno.Text + "' and si_enable=-1 group by sg_id,sg_script,sg_brand,si_item,sg_name,si_name,sg_step order by sg_step,itemindex ");
  961. ScanItem = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  962. sql.Clear();
  963. sql.Append("select distinct sg_brand from prodiodetail left join product on pd_prodcode=pr_code left join scangroup ");
  964. sql.Append("on nvl(pd_brand,pr_brand)=sg_brand where pd_inoutno='" + pi_inoutno.Text + "' and sg_brand is not null");
  965. DataTable dt1 = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  966. FrontCombo.DataSource = dt1;
  967. FrontCombo.DisplayMember = "sg_brand";
  968. FrontCombo.ValueMember = "sg_brand";
  969. BackCombo.DataSource = dt1;
  970. BackCombo.DisplayMember = "sg_brand";
  971. BackCombo.ValueMember = "sg_brand";
  972. LoadGridData();
  973. //重新输入单号后清除缓存
  974. MidBoxArgument.Clear();
  975. SingleBoxArgument.Clear();
  976. MidIDAndOutboxcode.Clear();
  977. SingleID.Clear();
  978. thread = new Thread(GetInOutInfAndLabelFile);
  979. stw = new SetLoadingWindow(thread, "正在获取打印标签");
  980. BaseUtil.SetFormCenter(stw);
  981. stw.ShowDialog();
  982. LogManager.DoLog("输入单号【" + pi_inoutno.Text + "】");
  983. }
  984. else
  985. MessageBox.Show("当前出入库单号" + pi_inoutno.Text + "不存在或未完成捡料!");
  986. }
  987. }
  988. private void SingleBoxPrint()
  989. {
  990. try
  991. {
  992. if (SingleDoc.Variables.FormVariables.Count == 0) { }
  993. }
  994. catch (Exception)
  995. {
  996. MessageBox.Show("单盘标签未维护参数");
  997. }
  998. if (MidLabelAutoPrint.Checked)
  999. {
  1000. try
  1001. {
  1002. if (MidDoc.Variables.FormVariables.Count == 0) { }
  1003. }
  1004. catch (Exception)
  1005. {
  1006. MessageBox.Show("中盘标签未维护参数");
  1007. }
  1008. }
  1009. if (SingleLabelParam.Rows.Count > 0 && LabelInf.Rows.Count > 0)
  1010. {
  1011. //每次打印清除之前缓存的行号和ID,后面会判断需要打印的数据重新加载
  1012. MidIDAndOutboxcode.Clear();
  1013. SingleID.Clear();
  1014. //获取全部的中盒号
  1015. Dictionary<string, bool> outboxcode1 = new Dictionary<string, bool>();
  1016. //判断所有盒号为该盒的是否勾选已采集
  1017. outboxcode1.Add(LabelInf.Rows[0].Cells["pib_outboxcode1"].Value.ToString(), true);
  1018. for (int i = 0; i < LabelInf.Rows.Count; i++)
  1019. {
  1020. if (!SingleID.Contains(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString()))
  1021. SingleID.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString());
  1022. if (LabelInf.Rows[i].Cells["pib_ifpick"].FormattedValue.ToString() == "True" && LabelInf.Rows[i].Cells["pib_ifprint"].FormattedValue.ToString() != "True")
  1023. {
  1024. //如果不存在中盒号则进行添加
  1025. if (!MidIDAndOutboxcode.ContainsValue(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()))
  1026. {
  1027. MidIDAndOutboxcode.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString());
  1028. }
  1029. }
  1030. }
  1031. if (SingleID.ToArray().Length == 0)
  1032. {
  1033. MessageBox.Show("选择的行未勾选采集或者已打印");
  1034. return;
  1035. }
  1036. for (int i = 0; i < LabelInf.RowCount; i++)
  1037. {
  1038. if (i + 1 < LabelInf.RowCount)
  1039. {
  1040. //如果本行的中盒号和下一行不相等的话
  1041. if (LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() != LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString())
  1042. {
  1043. if (!outboxcode1.ContainsKey(LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString()))
  1044. outboxcode1.Add(LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString(), true);
  1045. }
  1046. }
  1047. //只要有一行没有采集满就不打印
  1048. if (LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() == LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode1"].Value.ToString())
  1049. {
  1050. if (LabelInf.Rows[i].Cells["pib_ifpick"].FormattedValue.ToString() != "True")
  1051. outboxcode1[LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()] = false;
  1052. }
  1053. }
  1054. //用于判断用户是否勾选了行
  1055. int CheckedRowCount = 0;
  1056. for (int i = 0; i < LabelInf.RowCount; i++)
  1057. {
  1058. //勾选了并且未打印
  1059. if (LabelInf.Rows[i].Cells["pib_ifpick"].FormattedValue.ToString() == "True" && LabelInf.Rows[i].Cells["pib_ifprint"].FormattedValue.ToString() != "True")
  1060. {
  1061. if (cu_print_checkdatecode.Checked)
  1062. {
  1063. string datecode = LabelInf.Rows[i].Cells["pib_datecode"].Value.ToString();
  1064. string lotno = LabelInf.Rows[i].Cells["pib_lotno"].Value.ToString();
  1065. if (datecode == "" || lotno == "")
  1066. {
  1067. MessageLog.AppendText(">>设定必须采集DateCode内容,请先采集再打印\n", Color.Red);
  1068. return;
  1069. }
  1070. }
  1071. CheckedRowCount = CheckedRowCount + 1;
  1072. CurrentRowIndex = i;
  1073. //以标签模板的参数为基准,循环取数
  1074. try
  1075. {
  1076. SinglePrint(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString());
  1077. if (MidLabelAutoPrint.Checked)
  1078. {
  1079. //判断当前行的盒号和下一行不相等或者已经是最后一行了
  1080. if (i + 1 == LabelInf.RowCount || LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() != LabelInf.Rows[i + 1 == LabelInf.RowCount ? i : i + 1].Cells["pib_outboxcode1"].Value.ToString())
  1081. {
  1082. if (outboxcode1[LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()])
  1083. {
  1084. if (MidLabelCombox.SelectedValue != null)
  1085. {
  1086. MidBoxCodePrint(CurrentRowIndex);
  1087. }
  1088. }
  1089. }
  1090. }
  1091. //勾选为已打印
  1092. LabelInf.Rows[i].Cells["pib_ifprint"].Value = true;
  1093. }
  1094. catch (Exception ex) { LogManager.DoLog(ex.Message); }
  1095. }
  1096. }
  1097. if (CheckedRowCount == 0)
  1098. MessageBox.Show("未勾选打印明细!");
  1099. else if (CurrentRowIndex + 1 < LabelInf.Rows.Count)
  1100. CurrentRowIndex = CurrentRowIndex + 1;
  1101. outboxcode1.Clear();
  1102. }
  1103. else
  1104. {
  1105. MessageBox.Show("此模板尚未维护参数或不存在打印明细");
  1106. return;
  1107. }
  1108. }
  1109. private void SingleLabelPrint_Click(object sender, EventArgs e)
  1110. {
  1111. if (SingleLabelCombox.Text != "")
  1112. {
  1113. if (SingleBoxBegin.Text != "" || SingleBoxEnd.Text != "")
  1114. {
  1115. try
  1116. {
  1117. int begin = int.Parse(SingleBoxBegin.Text == "" ? "1" : SingleBoxBegin.Text);
  1118. int end = int.Parse(SingleBoxEnd.Text == "" ? LabelInf.Rows.Count.ToString() : SingleBoxEnd.Text);
  1119. if (begin > 0 && end <= LabelInf.Rows.Count && begin <= end)
  1120. {
  1121. for (int i = begin - 1; i < end; i++)
  1122. {
  1123. LabelInf.Rows[i].Cells["pib_ifpick"].Value = true;
  1124. LabelInf.Rows[i].Cells["pib_ifprint"].Value = false;
  1125. }
  1126. }
  1127. else
  1128. {
  1129. MessageBox.Show("单盘打印范围错误");
  1130. return;
  1131. }
  1132. }
  1133. catch (Exception)
  1134. {
  1135. MessageBox.Show("单盘打印范围错误");
  1136. return;
  1137. }
  1138. }
  1139. thread = new Thread(SingleBoxPrint);
  1140. stw = new SetLoadingWindow(thread, "正在打印单盘");
  1141. BaseUtil.SetFormCenter(stw);
  1142. stw.ShowDialog();
  1143. }
  1144. else
  1145. MessageBox.Show("未维护单盘标签");
  1146. }
  1147. private void MidBoxLabelPrint()
  1148. {
  1149. //未输入内容打印全部中盒
  1150. if (MidLabelNum.Text == "")
  1151. {
  1152. int begin = 0;
  1153. int end = 0;
  1154. if (MidBoxBegin.Text != "" || MidBoxEnd.Text != "")
  1155. {
  1156. try
  1157. {
  1158. begin = int.Parse(MidBoxBegin.Text == "" ? "1" : MidBoxBegin.Text);
  1159. end = int.Parse(MidBoxEnd.Text == "" ? LabelInf.Rows[LabelInf.Rows.Count - 1].Cells["pib_outboxcode1"].Value.ToString() : MidBoxEnd.Text);
  1160. int minmidbox = int.Parse(LabelInf.Rows[0].Cells["pib_outboxcode1"].Value.ToString());
  1161. int maxmidbox = int.Parse(LabelInf.Rows[LabelInf.Rows.Count - 1].Cells["pib_outboxcode1"].Value.ToString());
  1162. if (begin >= minmidbox && end <= maxmidbox && begin <= end)
  1163. {
  1164. //设置中盒打印范围的行号
  1165. for (int i = 0; i < LabelInf.Rows.Count; i++)
  1166. {
  1167. if (int.Parse(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()) == begin)
  1168. {
  1169. begin = i;
  1170. }
  1171. if (int.Parse(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()) == end)
  1172. {
  1173. end = i;
  1174. }
  1175. }
  1176. }
  1177. else
  1178. {
  1179. MessageBox.Show("中盒打印范围错误");
  1180. return;
  1181. }
  1182. }
  1183. catch (Exception)
  1184. {
  1185. MessageBox.Show("中盒打印范围错误");
  1186. return;
  1187. }
  1188. }
  1189. MidBoxArgument.Clear();
  1190. List<int> MidOutBoxCode = new List<int>();
  1191. List<int> MidOutBoxCodeIndex = new List<int>();
  1192. string la_id = MidLabelCombox.SelectedValue.ToString().Split('#')[0];
  1193. for (int i = (begin == 0 ? 0 : begin); i <= (end == 0 ? LabelInf.Rows.Count - 1 : end); i++)
  1194. {
  1195. if (!MidIDAndOutboxcode.ContainsValue(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()) && LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() != "")
  1196. MidIDAndOutboxcode.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString());
  1197. string outboxcode1 = LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString();
  1198. if (!MidOutBoxCode.Contains(int.Parse(outboxcode1 == "" ? "0" : outboxcode1)) && outboxcode1 != "")
  1199. {
  1200. MidOutBoxCode.Add(int.Parse(outboxcode1 == "" ? "0" : outboxcode1));
  1201. MidOutBoxCodeIndex.Add(i);
  1202. }
  1203. }
  1204. for (int i = 0; i < MidOutBoxCodeIndex.Count; i++)
  1205. {
  1206. MidBoxCodePrint(MidOutBoxCodeIndex[i]);
  1207. }
  1208. MidBoxArgument.Clear();
  1209. return;
  1210. }
  1211. bool FindMidLabel = false;
  1212. if (MidLabelCombox.SelectedValue != null)
  1213. {
  1214. //中盒号所在的行
  1215. int MidLabelRowIndex = 0;
  1216. //缓存中盒数据
  1217. for (int i = 0; i < LabelInf.RowCount; i++)
  1218. {
  1219. if (MidLabelNum.Text == LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString())
  1220. {
  1221. //找到了输入的中盒号停止循环
  1222. FindMidLabel = true;
  1223. MidLabelRowIndex = i;
  1224. }
  1225. }
  1226. //找到了指定的盒号
  1227. if (FindMidLabel)
  1228. MidBoxCodePrint(MidLabelRowIndex);
  1229. else
  1230. MessageBox.Show("该出入库单未找到该中盒号!");
  1231. }
  1232. else
  1233. MessageBox.Show("未维护中盒模板");
  1234. }
  1235. private void MidLabelPrint_Click(object sender, EventArgs e)
  1236. {
  1237. if (MidLabelCombox.Text != "")
  1238. {
  1239. thread = new Thread(MidBoxLabelPrint);
  1240. stw = new SetLoadingWindow(thread, "正在打印中盒");
  1241. BaseUtil.SetFormCenter(stw);
  1242. stw.ShowDialog();
  1243. }
  1244. else
  1245. MessageBox.Show("未维护中盒标签");
  1246. }
  1247. private void OutBoxPrint()
  1248. {
  1249. List<string> Outboxcode = new List<string>();
  1250. //如果未勾选箱号则对勾选的数据的箱号进行整合
  1251. if (OutBoxNum.Text == "")
  1252. {
  1253. for (int i = 0; i < LabelInf.RowCount; i++)
  1254. {
  1255. string outboxcode2 = LabelInf.Rows[i].Cells["pib_outboxcode2"].Value.ToString();
  1256. //如果不包含该箱号则进行添加
  1257. if (!Outboxcode.Contains(outboxcode2))
  1258. Outboxcode.Add(outboxcode2);
  1259. }
  1260. //按获取到的箱号列表进行打印
  1261. if (Outboxcode.ToArray().Length > 0)
  1262. {
  1263. try
  1264. {
  1265. // 循环打印外箱号
  1266. for (int i = 0; i < Outboxcode.ToArray().Length; i++)
  1267. {
  1268. for (int h = 0; h < LabelInf.RowCount; h++)
  1269. {
  1270. if (LabelInf.Rows[h].Cells["pib_outboxcode2"].Value.ToString() == Outboxcode.ToArray()[i])
  1271. {
  1272. OutBoxCodePrint(h);
  1273. break;
  1274. }
  1275. }
  1276. }
  1277. }
  1278. catch { }
  1279. }
  1280. else
  1281. {
  1282. MessageBox.Show("请勾选需要打印的外箱");
  1283. }
  1284. }
  1285. else
  1286. {
  1287. bool FindMidLabel = false;
  1288. try
  1289. {
  1290. int OutBoxLabelRowIndex = 0;
  1291. //查找是否存在该中盒号
  1292. for (int i = 0; i < LabelInf.RowCount; i++)
  1293. {
  1294. if (OutBoxNum.Text == LabelInf.Rows[i].Cells["pib_outboxcode2"].Value.ToString())
  1295. {
  1296. //找到了输入的中盒号停止循环
  1297. FindMidLabel = true;
  1298. OutBoxLabelRowIndex = i;
  1299. break;
  1300. }
  1301. }
  1302. //找到了指定的盒号
  1303. if (FindMidLabel)
  1304. OutBoxCodePrint(OutBoxLabelRowIndex);
  1305. else
  1306. MessageBox.Show("该出入库单未找到该外箱号!");
  1307. }
  1308. catch (Exception) { }
  1309. }
  1310. Outboxcode.Clear();
  1311. }
  1312. private void MidBoxCodePrint(int rowindex)
  1313. {
  1314. if (cu_print_checkdatecode.Checked)
  1315. {
  1316. string datecode = LabelInf.Rows[rowindex].Cells["pib_datecode"].Value.ToString();
  1317. string lotno = LabelInf.Rows[rowindex].Cells["pib_lotno"].Value.ToString();
  1318. if (datecode == "" || lotno == "")
  1319. {
  1320. MessageLog.AppendText(">>设定必须采集DateCode内容,请先采集再打印\n", Color.Red);
  1321. return;
  1322. }
  1323. }
  1324. //获取对应行的pib_id
  1325. string pib_id = LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString();
  1326. string pib_outboxcode1 = LabelInf.Rows[rowindex].Cells["pib_outboxcode1"].Value.ToString();
  1327. sql.Clear();
  1328. //设置最少打印盘数
  1329. if (OnlyPrint.Checked)
  1330. {
  1331. if (adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + pib_outboxcode1) < LeastPrintNum.Value)
  1332. {
  1333. return;
  1334. }
  1335. }
  1336. //查询参数名称相同的获取到取值字段
  1337. for (int j = 0; j < MidDoc.Variables.FormVariables.Count; j++)
  1338. {
  1339. DataRow[] dr1 = MidLabelParam.Select("lp_name='" + MidDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  1340. if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
  1341. {
  1342. sql.Append(dr1[0]["lp_sql"].ToString() + ",");
  1343. }
  1344. }
  1345. sql.Append("1,");
  1346. DataTable dt = (DataTable)adh.ExecuteSql("select " + sql.ToString().Substring(0, sql.Length - 1) + " from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + (pib_outboxcode1 == "" ? "0" : pib_outboxcode1), "select");
  1347. for (int j = 0; j < MidDoc.Variables.FormVariables.Count; j++)
  1348. {
  1349. DataRow[] dr1 = MidLabelParam.Select("lp_name='" + MidDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  1350. if (dr1.Length == 0)
  1351. dr1 = MidLabelParam.Select("lp_name='" + MidDoc.Variables.FormVariables.Item(j + 1).Name.Replace("_1", "") + "'");
  1352. if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
  1353. {
  1354. MidDoc.Variables.FormVariables.Item(j + 1).Value = dt.Rows[0][dr1[0]["lp_sql"].ToString()].ToString();
  1355. }
  1356. //SQL判断多个值的时候
  1357. if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "SQL值")
  1358. {
  1359. DataTable dt1 = (DataTable)adh.ExecuteSql(dr1[0]["lp_sql"].ToString().Replace("{1}", "'" + pi_inoutno.Text + "'").Replace("{2}", pib_outboxcode1), "select");
  1360. for (int i = 0; i < dt1.Rows.Count; i++)
  1361. {
  1362. for (int k = 0; k < MidDoc.Variables.FormVariables.Count; k++)
  1363. {
  1364. if (i == 0 & MidDoc.Variables.FormVariables.Item(k + 1).Name == dr1[0]["lp_name"].ToString())
  1365. {
  1366. MidDoc.Variables.FormVariables.Item(k + 1).Value = dt1.Rows[0][0].ToString();
  1367. }
  1368. //使用SN开头的参数赋值SN1,SN2,SN3等参数
  1369. if (MidDoc.Variables.FormVariables.Item(k + 1).Name == (dr1[0]["lp_name"].ToString() + "_" + (i + 1)))
  1370. {
  1371. MidDoc.Variables.FormVariables.Item(k + 1).Value = dt1.Rows[i][0].ToString();
  1372. }
  1373. if (dr1[0]["lp_sql"].ToString().Contains("pib_year"))
  1374. {
  1375. string date = dt1.Rows[0][0].ToString();
  1376. System.DateTime dtime;
  1377. if (System.DateTime.TryParseExact(date, "yyyymmdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime))
  1378. {
  1379. try
  1380. {
  1381. date = dtime.ToString(cu_print_dateformat.Text);
  1382. }
  1383. catch (Exception)
  1384. {
  1385. date = dtime.ToString("yyyymmdd");
  1386. }
  1387. MidDoc.Variables.FormVariables.Item(k + 1).Value = date;
  1388. }
  1389. }
  1390. }
  1391. }
  1392. }
  1393. if (MidDoc.Variables.FormVariables.Item(j + 1).Value == "")
  1394. {
  1395. dr1 = Attach.Select("lp_name='" + MidDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  1396. if (dr1.Length > 0)
  1397. MidDoc.Variables.FormVariables.Item(j + 1).Value = dr1[0]["lp_sql"].ToString();
  1398. }
  1399. }
  1400. MidDoc.PrintDocument();
  1401. }
  1402. /// <summary>
  1403. /// 执行打印外箱号
  1404. /// </summary>
  1405. private void OutBoxCodePrint(int rowindex)
  1406. {
  1407. if (cu_print_checkdatecode.Checked)
  1408. {
  1409. string datecode = LabelInf.Rows[rowindex].Cells["pib_datecode"].Value.ToString();
  1410. string lotno = LabelInf.Rows[rowindex].Cells["pib_lotno"].Value.ToString();
  1411. if (datecode == "" || lotno == "")
  1412. {
  1413. MessageLog.AppendText(">>设定必须采集DateCode内容,请先采集再打印\n", Color.Red);
  1414. return;
  1415. }
  1416. }
  1417. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
  1418. //获取对应行的pib_id
  1419. string pib_id = LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString();
  1420. string pib_outboxcode2 = LabelInf.Rows[rowindex].Cells["pib_outboxcode2"].Value.ToString();
  1421. sql.Clear();
  1422. for (int j = 0; j < OutBoxDoc.Variables.FormVariables.Count; j++)
  1423. {
  1424. DataRow[] dr1 = OutLabelParam.Select("lp_name='" + OutBoxDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  1425. if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
  1426. {
  1427. sql.Append(dr1[0]["lp_sql"].ToString() + ",");
  1428. }
  1429. }
  1430. sql.Append("1,");
  1431. DataTable dt = (DataTable)adh.ExecuteSql("select " + sql.ToString().Substring(0, sql.Length - 1) + " from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode2=" + (pib_outboxcode2 == "" ? "0" : pib_outboxcode2), "select");
  1432. if (dt.Rows.Count > 0)
  1433. {
  1434. for (int j = 0; j < OutBoxDoc.Variables.FormVariables.Count; j++)
  1435. {
  1436. DataRow[] dr1 = OutLabelParam.Select("lp_name='" + OutBoxDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  1437. //多参数命名
  1438. if (dr1.Length == 0)
  1439. dr1 = OutLabelParam.Select("lp_name='" + OutBoxDoc.Variables.FormVariables.Item(j + 1).Name.Replace("_1", "") + "'");
  1440. if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
  1441. {
  1442. OutBoxDoc.Variables.FormVariables.Item(j + 1).Value = dt.Rows[0][dr1[0]["lp_sql"].ToString()].ToString();
  1443. }
  1444. //SQL判断多个值的时候
  1445. if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "SQL值")
  1446. {
  1447. DataTable dt1 = (DataTable)adh.ExecuteSql(dr1[0]["lp_sql"].ToString().Replace("{1}", "'" + pi_inoutno.Text + "'").Replace("{2}", pib_outboxcode2), "select");
  1448. for (int i = 0; i < dt1.Rows.Count; i++)
  1449. {
  1450. for (int k = 0; k < OutBoxDoc.Variables.FormVariables.Count; k++)
  1451. {
  1452. if (i == 0 & OutBoxDoc.Variables.FormVariables.Item(k + 1).Name == dr1[0]["lp_name"].ToString())
  1453. {
  1454. OutBoxDoc.Variables.FormVariables.Item(k + 1).Value = dt1.Rows[0][0].ToString();
  1455. }
  1456. //使用SN开头的参数赋值SN1,SN2,SN3等参数
  1457. if (OutBoxDoc.Variables.FormVariables.Item(k + 1).Name == (dr1[0]["lp_name"].ToString() + "_" + (i + 1)))
  1458. {
  1459. OutBoxDoc.Variables.FormVariables.Item(k + 1).Value = dt1.Rows[i][0].ToString();
  1460. }
  1461. if (dr1[0]["lp_sql"].ToString().Contains("pib_year"))
  1462. {
  1463. string date = dt1.Rows[0][0].ToString();
  1464. System.DateTime dtime;
  1465. if (System.DateTime.TryParseExact(date, "yyyymmdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime))
  1466. {
  1467. try
  1468. {
  1469. date = dtime.ToString(cu_print_dateformat.Text);
  1470. }
  1471. catch (Exception)
  1472. {
  1473. date = dtime.ToString("yyyymmdd");
  1474. }
  1475. OutBoxDoc.Variables.FormVariables.Item(k + 1).Value = date;
  1476. }
  1477. }
  1478. }
  1479. }
  1480. }
  1481. if (OutBoxDoc.Variables.FormVariables.Item(j + 1).Value == "")
  1482. {
  1483. dr1 = Attach.Select("lp_name='" + OutBoxDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  1484. if (dr1.Length > 0)
  1485. OutBoxDoc.Variables.FormVariables.Item(j + 1).Value = dr1[0]["lp_sql"].ToString();
  1486. }
  1487. }
  1488. OutBoxDoc.PrintDocument();
  1489. }
  1490. }
  1491. private void OutBoxLabelPrint_Click(object sender, EventArgs e)
  1492. {
  1493. if (OutBoxCombox.Text != "")
  1494. {
  1495. thread = new Thread(OutBoxPrint);
  1496. stw = new SetLoadingWindow(thread, "正在打印外箱");
  1497. BaseUtil.SetFormCenter(stw);
  1498. stw.ShowDialog();
  1499. }
  1500. else
  1501. MessageBox.Show("未维护外箱标签");
  1502. }
  1503. /// <summary>
  1504. /// 刷新采集进度
  1505. /// </summary>
  1506. private void RefreshProcessData()
  1507. {
  1508. if (LabelInf.Rows.Count > 0)
  1509. {
  1510. //设置初始化的采集进度
  1511. int Count = Count = back_adh.getRowCount("prodiobarcode", "pib_ifrecheck=-1 and pib_inoutno='" + pi_inoutno.Text + "'");
  1512. string midboxcode = back_adh.getFieldDataByCondition("prodiobarcode", "max(pib_outboxcode1)", "pib_inoutno='" + pi_inoutno.Text + "'").ToString();
  1513. string outboxcode = back_adh.getFieldDataByCondition("prodiobarcode", "max(pib_outboxcode2)", "pib_inoutno='" + pi_inoutno.Text + "'").ToString();
  1514. //未超出当前范围的时候
  1515. int midboxcount = back_adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + (midboxcode == "" ? "1" : midboxcode));
  1516. int outboxcount = back_adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode2=" + (outboxcode == "" ? "1" : outboxcode));
  1517. midboxProcess.Text = midboxcount + "/" + MidBoxCapacity.Value;
  1518. outboxProcess.Text = outboxcount + "/" + OutBoxCapacity.Value;
  1519. //设置当前的箱号和盒号
  1520. Process_midboxcode.Text = midboxcode == "" ? "1" : midboxcode;
  1521. Process_outboxcode.Text = outboxcode == "" ? "1" : outboxcode;
  1522. //设置当前总数和已采集数量
  1523. CollectedCount.Text = Count + "/" + PageNum.Text.Replace("总数", "");
  1524. }
  1525. }
  1526. private void LoadGridData()
  1527. {
  1528. thread = new Thread(LoadGridData1);
  1529. stw = new SetLoadingWindow(thread, "正在获取条码");
  1530. BaseUtil.SetFormCenter(stw);
  1531. stw.ShowDialog();
  1532. }
  1533. private void LoadGridData1()
  1534. {
  1535. LoadGridData(new object(), new EventArgs());
  1536. }
  1537. int CurrentPage = 1;
  1538. int PageSize = 10000;
  1539. int DataSize = 0;
  1540. int MaxPageSize = 0;
  1541. DataTable LabelInfDataTable;
  1542. /// <summary>
  1543. /// 自定义函数 加载明细行的数据,多处使用添加进函数
  1544. /// </summary>
  1545. /// <param name="sender"></param>
  1546. /// <param name="e"></param>
  1547. private void LoadGridData(object sender, EventArgs e)
  1548. {
  1549. ManualCheckCount.Clear();
  1550. sql.Clear();
  1551. sql.Append("select * from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and rownum ");
  1552. sql.Append("between " + ((CurrentPage - 1) * PageSize + 1) + " and " + CurrentPage * PageSize + " ");
  1553. if (DetailRange.Checked)
  1554. {
  1555. sql.Append(" and pib_pdno between " + DetailRange1.Value + " and " + DetailRange2.Value);
  1556. }
  1557. sql.Append(" order by rownum");
  1558. LabelInfDataTable = (DataTable)adh.ExecuteSql(sql.ToString(), "select");
  1559. if (LabelInfDataTable.Rows.Count == 0)
  1560. {
  1561. //查询Oracle数据库
  1562. sql.Clear();
  1563. sql.Append("select t.*,rownum from prodiobarcode_view t where pib_inoutno='" + pi_inoutno.Text + "'");
  1564. LabelInfDataTable = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  1565. //检验查询的字段和本地数据库字段是否匹配
  1566. adh.AddColumFromDataTable(LabelInfDataTable, "prodiobarcode");
  1567. //将数据保存在本地数据库
  1568. adh.SaveDataTable(LabelInfDataTable, "prodiobarcode");
  1569. if (!DetailRange.Checked)
  1570. {
  1571. LabelInfDataTable = BaseUtil.filterDataTable(LabelInfDataTable, "rownum <=" + PageSize);
  1572. }
  1573. else
  1574. {
  1575. LabelInfDataTable = BaseUtil.filterDataTable(LabelInfDataTable, "rownum <=" + PageSize + " and pib_pdno >= " + DetailRange1.Value + " and pib_pdno<=" + DetailRange2.Value);
  1576. }
  1577. }
  1578. bindingsource(LabelInf, LabelInfDataTable);
  1579. //LabelInf.DataSource = null;
  1580. BaseUtil.FillDgvWithDataTable(LabelInf, LabelInfDataTable);
  1581. //获取数据总条数
  1582. if (!DetailRange.Checked)
  1583. {
  1584. DataSize = adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "'");
  1585. }
  1586. else
  1587. {
  1588. DataSize = adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno between " + DetailRange1.Value + " and " + DetailRange2.Value);
  1589. }
  1590. PageNum.Text = "总数" + DataSize;
  1591. MaxPageSize = DataSize % PageSize == 0 ? DataSize / PageSize : (DataSize / PageSize) + 1;
  1592. PageInf.Text = CurrentPage + "/" + MaxPageSize;
  1593. //获取系统设置的上传数量,如参数异常则默认为100
  1594. dt = (DataTable)adh.ExecuteSql("select * from dataextra", "select");
  1595. if (dt.Rows.Count > 0)
  1596. {
  1597. if (!int.TryParse(dt.Rows[0]["uploadnum"].ToString(), out UploadNum))
  1598. {
  1599. UploadNum = 100;
  1600. }
  1601. front_sg_separator.Text = dt.Rows[0]["splitfront"].ToString();
  1602. back_sg_separator.Text = dt.Rows[0]["splitback"].ToString();
  1603. prodcodeback.Text = dt.Rows[0]["prodcodeback"].ToString();
  1604. prodcodefront.Text = dt.Rows[0]["prodcodefront"].ToString();
  1605. primarydata.Text = dt.Rows[0]["primarydata"].ToString();
  1606. guestlabeldata.Text = dt.Rows[0]["guestlabeldata"].ToString();
  1607. }
  1608. //获取所有的匹配脚本
  1609. ScanGroup = (DataTable)dh.ExecuteSql("select distinct sg_brand,sg_id,sg_autolabel,sg_name,sg_script from prodiobarcode left join scangroup on pib_brand=sg_brand where pib_inoutno='" + pi_inoutno.Text + "' and sg_id is not null", "select");
  1610. RefreshProcessData();
  1611. }
  1612. delegate void BindDataSource(DataGridView dgv, DataTable dt);//定义委托
  1613. void bindingsource(DataGridView dgv, DataTable dt)
  1614. {
  1615. if (dgv.InvokeRequired)
  1616. {
  1617. dgv.Invoke(new BindDataSource(bindingsource), new object[] { dgv, dt });
  1618. }
  1619. else
  1620. {
  1621. dgv.AutoGenerateColumns = false;
  1622. dgv.DataSource = dt;
  1623. }
  1624. }
  1625. /// <summary>
  1626. /// 重绘Cell的颜色
  1627. /// </summary>
  1628. /// <param name="sender"></param>
  1629. /// <param name="e"></param>
  1630. private void LabelInf_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
  1631. {
  1632. bool mouseOver = e.CellBounds.Contains(this.PointToClient(Cursor.Position));
  1633. if (e.ColumnIndex > 0)
  1634. {
  1635. if (LabelInf.Columns[e.ColumnIndex].Name == "pib_lotno" || LabelInf.Columns[e.ColumnIndex].Name == "pib_datecode")
  1636. {
  1637. SolidBrush solidBrush = new SolidBrush(Color.FromArgb(51, 153, 255));
  1638. e.Graphics.FillRectangle(mouseOver ? solidBrush : Brushes.LightSeaGreen, e.CellBounds);
  1639. Rectangle border = e.CellBounds;
  1640. border.Width -= 1;
  1641. e.Graphics.DrawRectangle(Pens.White, border);
  1642. e.PaintContent(e.CellBounds);
  1643. e.Handled = true;
  1644. }
  1645. if (e.RowIndex >= 0)
  1646. {
  1647. if (LabelInf.Rows[e.RowIndex].Cells["pib_ifpick"].FormattedValue.ToString() == "True")
  1648. {
  1649. if (LabelInf.Columns[e.ColumnIndex].Name == "pib_lotno" || LabelInf.Columns[e.ColumnIndex].Name == "pib_datecode")
  1650. {
  1651. SolidBrush solidBrush = new SolidBrush(Color.FromArgb(51, 153, 255));
  1652. e.Graphics.FillRectangle(Brushes.ForestGreen, e.CellBounds);
  1653. Rectangle border = e.CellBounds;
  1654. border.Width -= 1;
  1655. e.Graphics.DrawRectangle(Pens.Black, border);
  1656. e.PaintContent(e.CellBounds);
  1657. e.Handled = true;
  1658. }
  1659. }
  1660. if (LabelInf.Rows[e.RowIndex].Cells["pib_ifrecheck"].FormattedValue.ToString() == "True")
  1661. {
  1662. if (LabelInf.Columns[e.ColumnIndex].Name == "pib_barcode")
  1663. {
  1664. SolidBrush solidBrush = new SolidBrush(Color.FromArgb(51, 153, 255));
  1665. e.Graphics.FillRectangle(Brushes.CadetBlue, e.CellBounds);
  1666. Rectangle border = e.CellBounds;
  1667. border.Width -= 1;
  1668. e.Graphics.DrawRectangle(Pens.Black, border);
  1669. e.PaintContent(e.CellBounds);
  1670. e.Handled = true;
  1671. }
  1672. }
  1673. }
  1674. }
  1675. }
  1676. private void CusLabelPrint()
  1677. {
  1678. //MaxOutBoxCode = MaxOutBoxCode + 1;
  1679. List<int> CusOutBoxCode = new List<int>();
  1680. //统计客户外箱号
  1681. if (LabelInf.Rows.Count > 0)
  1682. CusOutBoxCode.Add(0);
  1683. for (int i = 0; i < LabelInf.Rows.Count; i++)
  1684. {
  1685. if (i - 1 > 0 && LabelInf.Rows[i].Cells["pib_ifprint"].FormattedValue.ToString() == "True")
  1686. {
  1687. string cutboxcode = LabelInf.Rows[i].Cells["pib_cusoutboxcode"].Value.ToString();
  1688. string nextcutboxcode = LabelInf.Rows[i - 1].Cells["pib_cusoutboxcode"].Value.ToString();
  1689. if (cutboxcode != nextcutboxcode)
  1690. CusOutBoxCode.Add(i);
  1691. }
  1692. }
  1693. }
  1694. private void Refresh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
  1695. {
  1696. KeyEventArgs e2 = new KeyEventArgs(Keys.Enter);
  1697. pi_inoutno_KeyDown(sender, e2);
  1698. }
  1699. private void AutoPrintMidLabel()
  1700. {
  1701. if (adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode1"].Value) == MidBoxCapacity.Value)
  1702. {
  1703. if (MidLabelCombox.SelectedValue != null)
  1704. {
  1705. MidBoxCodePrint(CurrentRowIndex);
  1706. }
  1707. else
  1708. MessageBox.Show("未维护中盒模板");
  1709. }
  1710. }
  1711. private void LogingOut_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
  1712. {
  1713. string close = MessageBox.Show(this.ParentForm, "是否注销", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  1714. if (close.ToString() == "Yes")
  1715. {
  1716. if (FrontendCheck.IsOpen)
  1717. FrontendCheck.Close();
  1718. if (BackendCheck.IsOpen)
  1719. BackendCheck.Close();
  1720. if (PLC1.IsOpen)
  1721. PLC1.Close();
  1722. if (ManBackendCheck.IsOpen)
  1723. ManBackendCheck.Close();
  1724. Login login = new Login();
  1725. //注销的时候需要将拼接的连接字符串置空
  1726. DataHelper.DBConnectionString = null;
  1727. logout = true;
  1728. lbl.Quit();
  1729. this.Hide();
  1730. login.ShowDialog();
  1731. this.Close();
  1732. }
  1733. }
  1734. private void LabelInf_DataError(object sender, DataGridViewDataErrorEventArgs e) { }
  1735. /// <summary>
  1736. /// 切换打开的单盘文件
  1737. /// </summary>
  1738. /// <param name="sender"></param>
  1739. /// <param name="e"></param>
  1740. private void SingleLabelCombox_SelectedIndexChanged(object sender, EventArgs e)
  1741. {
  1742. try
  1743. {
  1744. if (ComBoxClickChangeLabelDoc)
  1745. {
  1746. if (SingleDoc != null)
  1747. SingleDoc.Close();
  1748. if (SingleLabelCombox.Text != "" && SingleLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
  1749. {
  1750. System.DateTime time = Convert.ToDateTime(SingleLabelCombox.SelectedValue.ToString().Split('#')[2]);
  1751. SingleDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(SingleLabelCombox.SelectedValue.ToString().Split('#')[1], SingleLabelCombox.Text, time));
  1752. }
  1753. }
  1754. }
  1755. catch (Exception) { }
  1756. }
  1757. /// <summary>
  1758. /// 切换打开的中盒文件
  1759. /// </summary>
  1760. /// <param name="sender"></param>
  1761. /// <param name="e"></param>
  1762. private void MidLabelCombox_SelectedIndexChanged(object sender, EventArgs e)
  1763. {
  1764. try
  1765. {
  1766. if (ComBoxClickChangeLabelDoc)
  1767. {
  1768. if (MidDoc != null)
  1769. MidDoc.Close();
  1770. if (MidLabelCombox.Text != "" && MidLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
  1771. {
  1772. System.DateTime time = Convert.ToDateTime(MidLabelCombox.SelectedValue.ToString().Split('#')[2]);
  1773. MidDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(MidLabelCombox.SelectedValue.ToString().Split('#')[1], MidLabelCombox.Text, time));
  1774. }
  1775. }
  1776. }
  1777. catch (Exception) { }
  1778. }
  1779. /// <summary>
  1780. /// 切换打开的外箱文件
  1781. /// </summary>
  1782. /// <param name="sender"></param>
  1783. /// <param name="e"></param>
  1784. private void OutBoxCombox_SelectedIndexChanged(object sender, EventArgs e)
  1785. {
  1786. try
  1787. {
  1788. if (ComBoxClickChangeLabelDoc)
  1789. {
  1790. if (OutBoxDoc != null)
  1791. OutBoxDoc.Close();
  1792. if (OutBoxCombox.Text != "" && OutBoxCombox.SelectedValue != null && !GetGridOnly.Checked)
  1793. {
  1794. System.DateTime time = Convert.ToDateTime(OutBoxCombox.SelectedValue.ToString().Split('#')[2]);
  1795. OutBoxDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(OutBoxCombox.SelectedValue.ToString().Split('#')[1], OutBoxCombox.Text, time));
  1796. }
  1797. }
  1798. }
  1799. catch (Exception) { }
  1800. }
  1801. private void ExportData_Click(object sender, EventArgs e)
  1802. {
  1803. ExportFileDialog.Description = "选择导出的路径";
  1804. DialogResult result = ExportFileDialog.ShowDialog();
  1805. DataTable dt = (DataTable)adh.ExecuteSql("select * from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'", "select");
  1806. if (result == DialogResult.OK)
  1807. {
  1808. ExcelHandler eh = new ExcelHandler();
  1809. for (int i = dt.Columns.Count - 1; i >= 0; i--)
  1810. {
  1811. for (int j = 0; j < LabelInf.Columns.Count; j++)
  1812. {
  1813. //去除ID列
  1814. if (dt.Columns[i].ColumnName.Contains("id") || dt.Columns[i].ColumnName == "pib_barcode" || dt.Columns[i].ColumnName == "pib_pdno" || dt.Columns[i].ColumnName == "pib_ifpick" || dt.Columns[i].ColumnName == "pib_ifprint" || dt.Columns[i].ColumnName == "pib_datecode1" || dt.Columns[i].ColumnName == "pr_vendprodcode")
  1815. {
  1816. dt.Columns.RemoveAt(i);
  1817. break;
  1818. }
  1819. switch (dt.Columns[i].ColumnName)
  1820. {
  1821. case "pib_lotno":
  1822. dt.Columns[i].ColumnName = "批次号";
  1823. break;
  1824. case "pib_datecode":
  1825. dt.Columns[i].ColumnName = "生产日期";
  1826. break;
  1827. case "pib_custbarcode":
  1828. dt.Columns[i].ColumnName = "最小产品包装条码";
  1829. break;
  1830. default:
  1831. break;
  1832. }
  1833. if (dt.Columns[i].ColumnName == LabelInf.Columns[j].DataPropertyName)
  1834. {
  1835. dt.Columns[i].ColumnName = LabelInf.Columns[j].HeaderText;
  1836. break;
  1837. }
  1838. }
  1839. }
  1840. eh.ExportExcel(dt, ExportFileDialog.SelectedPath, pi_date.Text + "-" + pi_inoutno.Text);
  1841. string close = MessageBox.Show(this.ParentForm, "导出成功,是否打开文件", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  1842. if (close.ToString() == "Yes")
  1843. System.Diagnostics.Process.Start(ExportFileDialog.SelectedPath + "\\" + pi_date.Text + "-" + pi_inoutno.Text + ".xls");
  1844. }
  1845. }
  1846. private void MidBoxCapacity_Leave(object sender, EventArgs e)
  1847. {
  1848. NumericUpDown nup = (NumericUpDown)sender;
  1849. switch (nup.Name)
  1850. {
  1851. case "MidBoxCapacity":
  1852. Properties.Settings.Default.MidBoxCapacity = nup.Value;
  1853. Properties.Settings.Default.Save();
  1854. break;
  1855. case "OutBoxCapacity":
  1856. Properties.Settings.Default.OutboxCapacity = nup.Value;
  1857. Properties.Settings.Default.Save();
  1858. break;
  1859. default:
  1860. break;
  1861. }
  1862. }
  1863. private void RefreshDBConnect_Tick(object sender, EventArgs e)
  1864. {
  1865. }
  1866. private void ButtonSetting_Click(object sender, EventArgs e)
  1867. {
  1868. LogMenu.Show(new Point(ButtonSetting.Location.X, ButtonSetting.Location.Y + 20));
  1869. }
  1870. private void Form_FormClosed(object sender, FormClosedEventArgs e)
  1871. {
  1872. RefreshParamData();
  1873. }
  1874. private void Attach_Closed(object sender, FormClosedEventArgs e)
  1875. {
  1876. RefreshAttachData();
  1877. }
  1878. private void DetailRange_CheckedChanged(object sender, EventArgs e)
  1879. {
  1880. if (DetailRange.Checked)
  1881. {
  1882. if (DetailRange1.Value > DetailRange2.Value)
  1883. {
  1884. MessageBox.Show("请输入正确的范围");
  1885. DetailRange.Checked = false;
  1886. return;
  1887. }
  1888. if (DetailRange1.Value == DetailRange2.Value)
  1889. {
  1890. if (dh.getRowCount("prodiodetail", "pd_inoutno='" + pi_inoutno.Text + "' and pd_pdno in(" + DetailRange1.Value + ")") != 1)
  1891. {
  1892. MessageBox.Show("出货单" + pi_inoutno.Text + "不存在明细序号" + DetailRange1.Value);
  1893. DetailRange.Checked = false;
  1894. return;
  1895. }
  1896. }
  1897. else
  1898. {
  1899. if (dh.getRowCount("prodiodetail", "pd_inoutno='" + pi_inoutno.Text + "' and pd_pdno in(" + DetailRange1.Value + "," + DetailRange2.Value + ")") != 2)
  1900. {
  1901. MessageBox.Show("出货单" + pi_inoutno.Text + "不存在明细序号" + DetailRange1.Value + "或" + DetailRange2.Value);
  1902. DetailRange.Checked = false;
  1903. return;
  1904. }
  1905. }
  1906. DetailRange1.Enabled = false;
  1907. DetailRange2.Enabled = false;
  1908. LoadGridData();
  1909. }
  1910. else
  1911. {
  1912. LoadGridData();
  1913. DetailRange1.Enabled = true;
  1914. DetailRange2.Enabled = true;
  1915. }
  1916. }
  1917. private void PLCStart_Click(object sender, EventArgs e)
  1918. {
  1919. //查询前端检验的端口号
  1920. DataTable dt = (DataTable)adh.ExecuteSql("select comtype,BaudRate,com,datawait,outtime from cominfo", "select");
  1921. DataRow[] dr = dt.Select("comtype='PLC1'");
  1922. if (dr.Length > 0)
  1923. {
  1924. if (!PLC1.IsOpen)
  1925. {
  1926. PLC1.PortName = dr[0]["COM"].ToString();
  1927. PLC1.Tag = "PLC1";
  1928. PLC1.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
  1929. PLC1.DataReceived += Serial_DataReceived;
  1930. PLC1.Open();
  1931. }
  1932. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.DeviceStart, adh);
  1933. MessageLog.AppendText("PLC启动成功\n", Color.Blue);
  1934. }
  1935. }
  1936. private void PLCStop_Click(object sender, EventArgs e)
  1937. {
  1938. LogicHandler.SendDataToPLC(PLC1, PLCInstruct.DeviceStop, adh);
  1939. MessageLog.AppendText("PLC暂停成功\n", Color.Blue);
  1940. }
  1941. private void ButtonCollectPass_Click(object sender, EventArgs e)
  1942. {
  1943. int pib_pdno = int.Parse(LabelInf.Rows[CurrentRowIndex].Cells["pib_pdno"].Value.ToString());
  1944. string ErrorMsg = "";
  1945. FrontCheckFunction("", out ErrorMsg);
  1946. }
  1947. private void ButtonRecheckPass_Click(object sender, EventArgs e)
  1948. {
  1949. string ErrorMsg = "";
  1950. int pib_pdno = int.Parse(LabelInf.Rows[CurrentRowIndex].Cells["pib_pdno"].Value.ToString());
  1951. BackendCheckFunction("", "Auto", out ErrorMsg);
  1952. }
  1953. private void ButtonSetMidBox_Click(object sender, EventArgs e)
  1954. {
  1955. Process_midboxcode.Text = SetMidBox.Text;
  1956. }
  1957. private void ButtonSetOutBox_Click(object sender, EventArgs e)
  1958. {
  1959. Process_outboxcode.Text = SetOutBox.Text;
  1960. }
  1961. private void Collection_CheckedChanged(object sender, EventArgs e)
  1962. {
  1963. ButtonCollectPass.Enabled = ManualCollection.Checked;
  1964. ButtonRecheckPass.Enabled = ManualCollection.Checked;
  1965. ButtonSetMidBox.Enabled = ManualCollection.Checked;
  1966. ButtonSetOutBox.Enabled = ManualCollection.Checked;
  1967. ManualFrontCheck.Enabled = ManualCollection.Checked;
  1968. ManualBackCheck.Enabled = ManualCollection.Checked;
  1969. ManualAutoCheck.Enabled = ManualCollection.Checked;
  1970. if (AutoCollection.Checked)
  1971. {
  1972. ManualFrontCheck.Checked = false;
  1973. ManualBackCheck.Checked = false;
  1974. ManualAutoCheck.Checked = false;
  1975. }
  1976. }
  1977. private void AddCutBox_Click(object sender, EventArgs e)
  1978. {
  1979. Button button = sender as Button;
  1980. switch (button.Name)
  1981. {
  1982. case "AddMidBox":
  1983. Process_midboxcode.Text = (int.Parse(Process_midboxcode.Text) + 1).ToString();
  1984. break;
  1985. case "CutMidBox":
  1986. if (int.Parse(Process_midboxcode.Text) > 1)
  1987. Process_midboxcode.Text = (int.Parse(Process_midboxcode.Text) - 1).ToString();
  1988. break;
  1989. case "AddOutBox":
  1990. Process_outboxcode.Text = (int.Parse(Process_outboxcode.Text) + 1).ToString();
  1991. break;
  1992. case "CutOutBox":
  1993. if (int.Parse(Process_outboxcode.Text) > 1)
  1994. Process_outboxcode.Text = (int.Parse(Process_outboxcode.Text) - 1).ToString();
  1995. break;
  1996. default:
  1997. break;
  1998. }
  1999. }
  2000. private void Page_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
  2001. {
  2002. switch ((sender as LinkLabel).Name)
  2003. {
  2004. case "FirstPage":
  2005. CurrentPage = 1;
  2006. break;
  2007. case "LastPage":
  2008. CurrentPage = MaxPageSize;
  2009. break;
  2010. case "BeforePage":
  2011. if (CurrentPage == 1)
  2012. {
  2013. MessageBox.Show("已经是第一页了", "提示");
  2014. return;
  2015. }
  2016. CurrentPage = CurrentPage - 1;
  2017. break;
  2018. case "NextPage":
  2019. if (CurrentPage == MaxPageSize)
  2020. {
  2021. MessageBox.Show("已经是最后一页了", "提示");
  2022. return;
  2023. }
  2024. CurrentPage = CurrentPage + 1;
  2025. break;
  2026. default:
  2027. break;
  2028. }
  2029. PageInf.Text = CurrentPage + "/" + MaxPageSize;
  2030. LoadGridData();
  2031. }
  2032. Dictionary<string, string> instruct = new Dictionary<string, string>();
  2033. private void RefreshPLCInstruct()
  2034. {
  2035. //查询所有的PLC指令
  2036. DataTable dtPLCInstruct = (DataTable)adh.ExecuteSql("select * from PLCInstruct", "select");
  2037. instruct.Clear();
  2038. //如果存在指令参数的话则全部添加到键值对当中
  2039. if (dtPLCInstruct.Rows.Count > 0)
  2040. {
  2041. for (int i = 0; i < dtPLCInstruct.Columns.Count; i++)
  2042. {
  2043. instruct.Add(dtPLCInstruct.Columns[i].ColumnName, dtPLCInstruct.Rows[0][dtPLCInstruct.Columns[i].ColumnName].ToString());
  2044. }
  2045. }
  2046. }
  2047. private void MessageLog_MouseUp(object sender, MouseEventArgs e)
  2048. {
  2049. if (e.Button == MouseButtons.Right)
  2050. {
  2051. LogMenu.Show(new Point(MessageLog.Location.X + 100, MessageLog.Location.Y + 20));
  2052. }
  2053. }
  2054. private void UploadData_Click(object sender, EventArgs e)
  2055. {
  2056. adh.ExecuteSql("update prodiobarcode set pib_ifpick=0,pib_ifprint=0,pib_ifmodify=0 where pib_inoutno='" + pi_inoutno.Text + "' and pib_ifrecheck=0", "update");
  2057. if (LogicHandler.CheckUploadData(pi_inoutno.Text))
  2058. {
  2059. DataTable dtt = LabelInf.DataSource as DataTable;
  2060. for (int i = 0; i < dtt.Rows.Count; i++)
  2061. {
  2062. if (dtt.Rows[i]["pib_ifrecheck"].ToString() != "0" && dtt.Rows[i]["pib_ifupload"].ToString() == "0")
  2063. {
  2064. dtt.Rows[i]["pib_ifupload"] = -1;
  2065. }
  2066. }
  2067. MessageLog.AppendText(">>上传数据成功\n", Color.Green);
  2068. }
  2069. else
  2070. {
  2071. MessageLog.AppendText(">>无可上传数据\n", Color.Red);
  2072. }
  2073. LoadGridData();
  2074. }
  2075. private void DocRefresh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
  2076. {
  2077. switch ((sender as Control).Name)
  2078. {
  2079. case "SingleDocRefresh":
  2080. if (SingleDoc != null)
  2081. SingleDoc.Close();
  2082. if (SingleLabelCombox.Text != "" && SingleLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
  2083. {
  2084. System.DateTime time = Convert.ToDateTime(SingleLabelCombox.SelectedValue.ToString().Split('#')[2]);
  2085. SingleDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(SingleLabelCombox.SelectedValue.ToString().Split('#')[1], SingleLabelCombox.Text, time));
  2086. }
  2087. break;
  2088. case "MidDocRefresh":
  2089. if (MidDoc != null)
  2090. MidDoc.Close();
  2091. if (MidLabelCombox.Text != "" && MidLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
  2092. {
  2093. System.DateTime time = Convert.ToDateTime(MidLabelCombox.SelectedValue.ToString().Split('#')[2]);
  2094. MidDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(MidLabelCombox.SelectedValue.ToString().Split('#')[1], MidLabelCombox.Text, time));
  2095. }
  2096. break;
  2097. case "OutDocRefresh":
  2098. if (OutBoxDoc != null)
  2099. OutBoxDoc.Close();
  2100. if (OutBoxCombox.Text != "" && OutBoxCombox.SelectedValue != null && !GetGridOnly.Checked)
  2101. {
  2102. System.DateTime time = Convert.ToDateTime(OutBoxCombox.SelectedValue.ToString().Split('#')[2]);
  2103. OutBoxDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(OutBoxCombox.SelectedValue.ToString().Split('#')[1], OutBoxCombox.Text, time));
  2104. }
  2105. break;
  2106. default:
  2107. break;
  2108. }
  2109. }
  2110. private void PageSizeNum_ValueChanged(object sender, EventArgs e)
  2111. {
  2112. PageSize = int.Parse(PageSizeNum.Value.ToString());
  2113. LoadGridData();
  2114. }
  2115. private void button1_Click(object sender, EventArgs e)
  2116. {
  2117. string close = MessageBox.Show(this.ParentForm, "是否重新下载服务端条码,将会覆盖本地记录", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  2118. if (close.ToString() == "Yes")
  2119. {
  2120. adh.ExecuteSql("delete from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'", "delete");
  2121. LoadGridData();
  2122. }
  2123. }
  2124. private void LabelInf_CellEndEdit(object sender, DataGridViewCellEventArgs e)
  2125. {
  2126. string columnname = LabelInf.Columns[e.ColumnIndex].Name;
  2127. if (columnname == "pib_lotno" || columnname == "pib_datecode")
  2128. {
  2129. string data = LabelInf.Rows[e.RowIndex].Cells[columnname].Value.ToString();
  2130. if (data != "")
  2131. {
  2132. string close = MessageBox.Show(this.ParentForm, "确认修改该出货明细行" + columnname.Replace("pib_", ""), "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  2133. if (close.ToString() == "Yes")
  2134. {
  2135. string pib_pdno = LabelInf.Rows[e.RowIndex].Cells["pib_pdno"].Value.ToString();
  2136. DataRow[] dr = (LabelInf.DataSource as DataTable).Select("pib_pdno=" + pib_pdno);
  2137. for (int i = 0; i < dr.Length; i++)
  2138. {
  2139. dr[i][columnname] = data;
  2140. dr[i]["pib_ifmodify"] = -1;
  2141. dr[i]["pib_ifpick"] = -1;
  2142. }
  2143. adh.UpdateByCondition("prodiobarcode", columnname + "='" + data + "',pib_ifmodify=-1,pib_ifpick=-1", "pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno=" + pib_pdno + "");
  2144. LabelInf.Invalidate();
  2145. }
  2146. }
  2147. }
  2148. }
  2149. private void ManualCheck_CheckedChanged(object sender, EventArgs e)
  2150. {
  2151. RadioButton ctl = sender as RadioButton;
  2152. if (ctl.Checked)
  2153. {
  2154. switch (ctl.Name)
  2155. {
  2156. case "ManualBackCheck":
  2157. MessageLog.AppendText(">>切换为手动复核模式,需扫描两段数据\n", Color.Blue);
  2158. break;
  2159. default:
  2160. break;
  2161. }
  2162. }
  2163. }
  2164. int rowindex = 0;
  2165. private void LabelInf_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
  2166. {
  2167. if (e.Button == MouseButtons.Right)
  2168. {
  2169. rowindex = e.RowIndex;
  2170. DateCodeSetAndPrint date = new DateCodeSetAndPrint();
  2171. date.Controls["SetValue"].Click += SetValue_ButtonClick;
  2172. date.Controls["SetValueAndPrint"].Click += SetValueAndPrint_ButtonClick;
  2173. date.ShowDialog();
  2174. }
  2175. }
  2176. private void SetValue_ButtonClick(object sender, EventArgs e)
  2177. {
  2178. Button setvalue = sender as Button;
  2179. string pdno = LabelInf.Rows[rowindex].Cells["pib_pdno"].Value.ToString();
  2180. string datecode = setvalue.FindForm().Controls["datecode"].Text;
  2181. string lotno = setvalue.FindForm().Controls["lotno"].Text;
  2182. string nums = setvalue.FindForm().Controls["Nums"].Text;
  2183. string year = "0";
  2184. string month = "0";
  2185. string day = "0";
  2186. string date = "";
  2187. LogicHandler.GetTimeFromDatecode(dh1, datecode, pi_cardcode.Text, out year, out month, out day, out date);
  2188. string sql = "update prodiobarcode set pib_autoset=-1,pib_ifrecheck=-1,pib_ifpick=-1,pib_ifmodify=-1,pib_lotno='" + lotno + "',pib_datecode='" + datecode + "',pib_year='" + year + "',pib_month='" + month + "',pib_day='" + day + "' where pib_id in (select pib_id from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno=" + pdno;
  2189. if (datecode != "")
  2190. {
  2191. sql += " and (pib_datecode='' or pib_datecode is null) ";
  2192. }
  2193. if (lotno != "")
  2194. {
  2195. sql += " and (pib_lotno='' or pib_lotno is null) ";
  2196. }
  2197. if (nums == "")
  2198. {
  2199. sql += ")";
  2200. }
  2201. else
  2202. {
  2203. sql += " limit 0," + nums + ")";
  2204. }
  2205. adh.ExecuteSql(sql, "update");
  2206. LoadGridData();
  2207. setvalue.FindForm().Close();
  2208. }
  2209. private void SetValueAndPrint_ButtonClick(object sender, EventArgs e)
  2210. {
  2211. Button setvalueandprint = sender as Button;
  2212. string pdno = LabelInf.Rows[rowindex].Cells["pib_pdno"].Value.ToString();
  2213. string datecode = setvalueandprint.FindForm().Controls["datecode"].Text;
  2214. string lotno = setvalueandprint.FindForm().Controls["lotno"].Text;
  2215. string nums = setvalueandprint.FindForm().Controls["Nums"].Text;
  2216. string year = "0";
  2217. string month = "0";
  2218. string day = "0";
  2219. string date = "";
  2220. LogicHandler.GetTimeFromDatecode(dh1, datecode, pi_cardcode.Text, out year, out month, out day, out date);
  2221. string sql = "update prodiobarcode set pib_autoset=-1,pib_ifrecheck=-1,pib_ifpick=-1,pib_ifmodify=-1,pib_ifprint=-1,pib_lotno='" + lotno + "',pib_datecode='" + datecode + "',pib_year='" + year + "',pib_month='" + month + "',pib_day='" + day + "' where pib_id in (select pib_id from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno=" + pdno;
  2222. string PrintSQL = "select pib_id from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno=" + pdno;
  2223. if (datecode != "")
  2224. {
  2225. sql += " and (pib_datecode='' or pib_datecode is null) ";
  2226. }
  2227. if (lotno != "")
  2228. {
  2229. sql += " and (pib_lotno='' or pib_lotno is null) ";
  2230. }
  2231. if (nums == "")
  2232. {
  2233. sql += ")";
  2234. }
  2235. else
  2236. {
  2237. sql += " limit 0," + nums + ")";
  2238. PrintSQL += " limit 0," + nums;
  2239. }
  2240. DataTable pibid_dt = (DataTable)adh.ExecuteSql(PrintSQL, "select");
  2241. adh.ExecuteSql(sql, "update");
  2242. LoadGridData();
  2243. for (int i = 0; i < pibid_dt.Rows.Count; i++)
  2244. {
  2245. SinglePrint(pibid_dt.Rows[i]["pib_id"].ToString());
  2246. }
  2247. setvalueandprint.FindForm().Close();
  2248. }
  2249. private void ResetBarcode_Click(object sender, EventArgs e)
  2250. {
  2251. string close = MessageBox.Show(this.ParentForm, "是否重置本单据条码", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  2252. if (close == "Yes")
  2253. {
  2254. dh.ExecuteSql("delete from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'", "delete");
  2255. adh.ExecuteSql("delete from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'", "delete");
  2256. LoadGridData();
  2257. }
  2258. }
  2259. private void SetOutboxBarcode()
  2260. {
  2261. string pib_id = LabelInf.Rows[CurrentRowIndex].Cells["pib_id1"].Value.ToString();
  2262. //解析DateCode,将值设置到年月日
  2263. try
  2264. {
  2265. DataRow[] dr = LabelInfDataTable.Select("pib_id=" + pib_id);
  2266. if (dr.Length > 0)
  2267. {
  2268. try
  2269. {
  2270. dr[0]["pib_year"] = year;
  2271. dr[0]["pib_month"] = month;
  2272. dr[0]["pib_day"] = day;
  2273. }
  2274. catch { }
  2275. }
  2276. }
  2277. catch (Exception) { }
  2278. int outboxcode1 = Outbox1;
  2279. int outboxcode2 = Outbox2;
  2280. string pd_id = LabelInf.Rows[CurrentRowIndex].Cells["pd_id"].Value.ToString();
  2281. //如果满容量获取过箱号就不再重复获取了
  2282. //bool GetBarcode = false;
  2283. //获取当前的行号
  2284. decimal CurrentRowNum = decimal.Parse(LabelInf.Rows[CurrentRowIndex].Cells["rownum"].Value.ToString());
  2285. //超过中盒容量中盒号+1
  2286. if (adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + outboxcode1) >= MidBoxCapacity.Value)
  2287. {
  2288. outboxcode1 = outboxcode1 + 1;
  2289. //GetBarcode = true;
  2290. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2291. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2292. //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
  2293. }
  2294. else if (CurrentRowNum - 1 >= 0)
  2295. {
  2296. //获取上一行的数据
  2297. DataTable LastRowData = (DataTable)adh.ExecuteSql("select pib_lotno,pib_custmidboxcode,pib_custoutboxcode,pd_pocode,pd_custprodcode,pd_custprodspec,pib_datecode from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and rownum=" + (CurrentRowNum == 1 ? 1 : CurrentRowNum - 1), "select");
  2298. //string custmidboxcode = LastRowData.Rows[0]["pib_custmidboxcode"].ToString();
  2299. //if (custmidboxcode == "")
  2300. //{
  2301. // LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2302. // LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2303. //}
  2304. //或者不符合合并条件中盒号+1
  2305. if (cu_print_midlotno.Checked)
  2306. {
  2307. string TempData = LastRowData.Rows[0]["pib_lotno"].ToString();
  2308. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value.ToString()/* /* && !GetBarcode/)
  2309. {
  2310. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2311. //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
  2312. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2313. outboxcode1 = outboxcode1 + 1;
  2314. }
  2315. }
  2316. else if (cu_print_midpo.Checked)
  2317. {
  2318. string TempData = LastRowData.Rows[0]["pd_pocode"].ToString();
  2319. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_pocode"].Value.ToString() /* && !GetBarcode*/)
  2320. {
  2321. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2322. //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
  2323. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2324. outboxcode1 = outboxcode1 + 1;
  2325. }
  2326. }
  2327. else if (cu_print_midprod.Checked)
  2328. {
  2329. string TempData = LastRowData.Rows[0]["pd_custprodcode"].ToString();
  2330. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_custprodcode"].Value.ToString() /* && !GetBarcode*/)
  2331. {
  2332. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2333. //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
  2334. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2335. outboxcode1 = outboxcode1 + 1;
  2336. }
  2337. }
  2338. else if (cu_print_midspec.Checked)
  2339. {
  2340. string TempData = LastRowData.Rows[0]["pd_custprodspec"].ToString();
  2341. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_custprodspec"].Value.ToString() /* && !GetBarcode*/)
  2342. {
  2343. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2344. //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
  2345. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2346. outboxcode1 = outboxcode1 + 1;
  2347. }
  2348. }
  2349. else if (cu_print_middc.Checked)
  2350. {
  2351. string TempData = LastRowData.Rows[0]["pib_datecode"].ToString();
  2352. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value.ToString() /* && !GetBarcode*/)
  2353. {
  2354. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2355. //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
  2356. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2357. outboxcode1 = outboxcode1 + 1;
  2358. }
  2359. }
  2360. //if (LastRowData.Rows[0]["pib_custmidboxcode"].ToString() == MidBoxBarCode)
  2361. // LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = LastRowData.Rows[0]["pib_custmidboxcode"].ToString();
  2362. //else
  2363. // LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2364. }
  2365. else
  2366. {
  2367. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2368. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
  2369. }
  2370. //GetBarcode = false;
  2371. if (adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode2=" + outboxcode2) >= OutBoxCapacity.Value)
  2372. {
  2373. //GetBarcode = true;
  2374. outboxcode2 = outboxcode2 + 1;
  2375. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
  2376. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2377. }
  2378. else if (CurrentRowNum - 1 >= 0)
  2379. {
  2380. //获取上一行数据
  2381. DataTable LastRowData = (DataTable)adh.ExecuteSql("select pib_lotno,pib_custmidboxcode,pib_custoutboxcode,pd_pocode,pd_custprodcode,pd_custprodspec,pib_datecode from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and rownum=" + (CurrentRowNum == 1 ? 1 : CurrentRowNum - 1), "select");
  2382. //string custoutboxcode = LastRowData.Rows[0]["pib_custoutboxcode"].ToString();
  2383. //if (custoutboxcode == "")
  2384. //{
  2385. // LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
  2386. // LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2387. //}
  2388. //或者不符合合并条件中盒号+1
  2389. if (cu_print_outlotno.Checked)
  2390. {
  2391. string TempData = LastRowData.Rows[0]["pib_lotno"].ToString();
  2392. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value.ToString() /* && !GetBarcode*/)
  2393. {
  2394. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
  2395. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2396. outboxcode2 = outboxcode2 + 1;
  2397. }
  2398. }
  2399. else if (cu_print_outpo.Checked)
  2400. {
  2401. string TempData = LastRowData.Rows[0]["pd_pocode"].ToString();
  2402. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_pocode"].Value.ToString() /* && !GetBarcode*/)
  2403. {
  2404. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
  2405. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2406. outboxcode2 = outboxcode2 + 1;
  2407. }
  2408. }
  2409. else if (cu_print_outprod.Checked)
  2410. {
  2411. string TempData = LastRowData.Rows[0]["pd_custprodcode"].ToString();
  2412. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_custprodcode"].Value.ToString() /* && !GetBarcode*/)
  2413. {
  2414. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
  2415. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2416. outboxcode2 = outboxcode2 + 1;
  2417. }
  2418. }
  2419. else if (cu_print_outspec.Checked)
  2420. {
  2421. string TempData = LastRowData.Rows[0]["pd_custprodspec"].ToString();
  2422. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_custprodspec"].Value.ToString() /* && !GetBarcode*/)
  2423. {
  2424. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
  2425. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2426. outboxcode2 = outboxcode2 + 1;
  2427. }
  2428. }
  2429. else if (cu_print_outdc.Checked)
  2430. {
  2431. string TempData = LastRowData.Rows[0]["pib_datecode"].ToString();
  2432. if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value.ToString() /* && !GetBarcode*/)
  2433. {
  2434. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
  2435. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2436. outboxcode2 = outboxcode2 + 1;
  2437. }
  2438. }
  2439. //if (OutBoxBarCode == LastRowData.Rows[0]["pib_custoutboxcode"].ToString())
  2440. // LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = LastRowData.Rows[0]["pib_custoutboxcode"].ToString();
  2441. //else
  2442. // LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2443. }
  2444. else
  2445. {
  2446. //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
  2447. //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
  2448. }
  2449. //设置中盒外箱号
  2450. LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode1"].Value = outboxcode1;
  2451. LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode2"].Value = outboxcode2;
  2452. if (SingleLabelAutoPrint.Checked)
  2453. adh.ExecuteSql("update prodiobarcode set pib_year='" + year + "',pib_month='" + month + "',pib_day='" + day + "',pib_outboxcode2=" + outboxcode2 + ",pib_outboxcode1=" + outboxcode1 + ",pib_custoutboxcode='" + OutBoxBarCode + "',pib_custmidboxcode='" + MidBoxBarCode + "',pib_lotno='" + LotNo + "',pib_datecode='" + DateCode + "',pib_ifpick=-1,pib_ifmodify=-1,pib_ifprint=-1 where pib_id=" + pib_id, "update");
  2454. else
  2455. adh.ExecuteSql("update prodiobarcode set pib_year='" + year + "',pib_month='" + month + "',pib_day='" + day + "',pib_outboxcode2=" + outboxcode2 + ",pib_outboxcode1=" + outboxcode1 + ",pib_custoutboxcode='" + OutBoxBarCode + "',pib_custmidboxcode='" + MidBoxBarCode + "',pib_lotno='" + LotNo + "',pib_datecode='" + DateCode + "',pib_ifpick=-1,pib_ifmodify=-1 where pib_id=" + pib_id, "update");
  2456. LabelInf.Invalidate();
  2457. }
  2458. private void SinglePrint(string pib_id)
  2459. {
  2460. StringBuilder sql = new StringBuilder();
  2461. sql.Clear();
  2462. for (int j = 0; j < SingleDoc.Variables.FormVariables.Count; j++)
  2463. {
  2464. DataRow[] dr1 = SingleLabelParam.Select("lp_name='" + SingleDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  2465. if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
  2466. {
  2467. sql.Append(dr1[0]["lp_sql"].ToString() + ",");
  2468. }
  2469. }
  2470. sql.Append("1,");
  2471. DataTable dt = (DataTable)adh.ExecuteSql("select " + sql.ToString().Substring(0, sql.Length - 1) + " from prodiobarcode where pib_id=" + pib_id, "select");
  2472. for (int j = 0; j < SingleDoc.Variables.FormVariables.Count; j++)
  2473. {
  2474. DataRow[] dr1 = SingleLabelParam.Select("lp_name='" + SingleDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  2475. if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "SQL值")
  2476. {
  2477. DataTable dt1 = (DataTable)adh.ExecuteSql(dr1[0]["lp_sql"].ToString().Replace("{1}", pib_id), "select");
  2478. if (dt1.Rows.Count > 0)
  2479. {
  2480. SingleDoc.Variables.FormVariables.Item(j + 1).Value = dt1.Rows[0][0].ToString();
  2481. if (dr1[0]["lp_sql"].ToString().Contains("pib_year"))
  2482. {
  2483. string date = dt1.Rows[0][0].ToString();
  2484. System.DateTime dtime;
  2485. if (System.DateTime.TryParseExact(date, "yyyymmdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime))
  2486. {
  2487. try
  2488. {
  2489. date = dtime.ToString(cu_print_dateformat.Text);
  2490. }
  2491. catch (Exception)
  2492. {
  2493. date = dtime.ToString("yyyymmdd");
  2494. }
  2495. SingleDoc.Variables.FormVariables.Item(j + 1).Value = date;
  2496. }
  2497. }
  2498. }
  2499. }
  2500. else if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
  2501. {
  2502. SingleDoc.Variables.FormVariables.Item(j + 1).Value = dt.Rows[0][dr1[0]["lp_sql"].ToString()].ToString();
  2503. }
  2504. if (SingleDoc.Variables.FormVariables.Item(j + 1).Value == "")
  2505. {
  2506. dr1 = Attach.Select("lp_name='" + SingleDoc.Variables.FormVariables.Item(j + 1).Name + "'");
  2507. if (dr1.Length > 0)
  2508. SingleDoc.Variables.FormVariables.Item(j + 1).Value = dr1[0]["lp_sql"].ToString();
  2509. }
  2510. }
  2511. SingleDoc.PrintDocument();
  2512. LogicHandler.UpdateRowPrinted(pib_id);
  2513. }
  2514. private void RefreshAttachData()
  2515. {
  2516. Attach = (DataTable)dh.ExecuteSql("select lap_param lp_name,lap_value lp_sql from LabelAttachPARAMETER where lap_custcode='" + pi_cardcode.Text + "'", "select");
  2517. }
  2518. private void RefreshParamData()
  2519. {
  2520. //获取客户自定义设置
  2521. sql.Clear();
  2522. sql.Append("select cu_print_middc,cu_print_limiteddate,cu_print_outdc,cu_print_dateformat,cu_print_checkdatecode,cu_print_midlotno,nvl(cu_print_custprodmatchmodel,'Equal')cu_print_custprodmatchmodel,cu_print_midspec,cu_print_midpo,cu_print_midprod,cu_print_outlotno,cu_print_outspec,cu_print_outpo");
  2523. sql.Append(",cu_print_outprod,cu_print_checkonly,nvl(cu_print_papercount,0)cu_print_papercount,cu_print_regexpression,cu_print_recheck from customer where cu_code='" + pi_cardcode.Text + "'");
  2524. DataTable dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  2525. if (dt.Rows.Count > 0)
  2526. {
  2527. BaseUtil.SetFormValue(this.Controls, dt);
  2528. switch (dt.Rows[0]["cu_print_custprodmatchmodel"].ToString())
  2529. {
  2530. case "Equal":
  2531. Equal.Checked = true;
  2532. break;
  2533. case "Expression":
  2534. Expression.Checked = true;
  2535. break;
  2536. default:
  2537. Equal.Checked = true;
  2538. break;
  2539. }
  2540. switch (dt.Rows[0]["cu_print_recheck"].ToString())
  2541. {
  2542. case "CP":
  2543. RecheckCuprodcode.Checked = true;
  2544. break;
  2545. case "BR":
  2546. RecheckBarcode.Checked = true;
  2547. break;
  2548. default:
  2549. RecheckCuprodcode.Checked = true;
  2550. break;
  2551. }
  2552. }
  2553. ScanGroup = (DataTable)dh.ExecuteSql("select distinct sg_brand,sg_id,sg_autolabel,sg_name,sg_script from prodiobarcode left join scangroup on pib_brand=sg_brand where pib_inoutno='" + pi_inoutno.Text + "' and sg_id is not null", "select");
  2554. }
  2555. int Outbox1;
  2556. int Outbox2;
  2557. private void Process_midboxcode_TextChanged(object sender, EventArgs e)
  2558. {
  2559. int.TryParse(Process_midboxcode.Text, out Outbox1);
  2560. }
  2561. private void Process_outboxcode_TextChanged(object sender, EventArgs e)
  2562. {
  2563. int.TryParse(Process_outboxcode.Text, out Outbox2);
  2564. }
  2565. private void LabelPrinter_UserOnSelectIndexChange(object sender, EventArgs e)
  2566. {
  2567. switch ((sender as Control).Parent.Name)
  2568. {
  2569. case "SingleLabelPrinter":
  2570. if (SingleDoc != null)
  2571. SingleDoc.Printer.SwitchTo(SingleLabelPrinter.Text);
  2572. break;
  2573. case "MidLabelPrinter":
  2574. if (MidDoc != null)
  2575. MidDoc.Printer.SwitchTo(MidLabelPrinter.Text);
  2576. break;
  2577. case "OutBoxPrinter":
  2578. if (OutBoxDoc != null)
  2579. OutBoxDoc.Printer.SwitchTo(OutBoxLabelPrint.Text);
  2580. break;
  2581. default:
  2582. break;
  2583. }
  2584. }
  2585. private void LogMenu_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
  2586. {
  2587. switch (e.ClickedItem.Text)
  2588. {
  2589. case "采集策略设置":
  2590. 采集策略_NEW form = new 采集策略_NEW();
  2591. form.FormClosed += Form_FormClosed;
  2592. BaseUtil.SetFormCenter(form);
  2593. form.ShowDialog();
  2594. break;
  2595. case "生成条码":
  2596. 生成条码 form3 = new 生成条码(pi_inoutno.Text);
  2597. form3.FormClosed += Form_FormClosed;
  2598. BaseUtil.SetFormCenter(form3);
  2599. form3.ShowDialog();
  2600. break;
  2601. case "附加信息设置":
  2602. if (pi_cardcode.Text != "")
  2603. {
  2604. 附件内容打印 att = new 附件内容打印(pi_cardcode.Text);
  2605. att.FormClosed += Attach_Closed;
  2606. att.ShowDialog();
  2607. }
  2608. else MessageBox.Show("请先获取出库单信息");
  2609. break;
  2610. case "客户标签维护":
  2611. 客户标签维护 form1 = new 客户标签维护();
  2612. form1.FormClosed += Form_FormClosed;
  2613. BaseUtil.SetFormCenter(form1);
  2614. if (SingleDoc != null)
  2615. SingleDoc.Close();
  2616. if (MidDoc != null)
  2617. MidDoc.Close();
  2618. if (OutBoxDoc != null)
  2619. OutBoxDoc.Close();
  2620. form1.FormClosed += LabelFormClose;
  2621. form1.ShowDialog();
  2622. break;
  2623. case "客户采集规则":
  2624. CustomerRule cust = new CustomerRule();
  2625. cust.FormClosed += Form_FormClosed;
  2626. BaseUtil.SetFormCenter(cust);
  2627. cust.ShowDialog();
  2628. break;
  2629. case "参数配置":
  2630. ParamSetting form2 = new ParamSetting();
  2631. form2.FormClosed += Form_FormClosed;
  2632. BaseUtil.SetFormCenter(form2);
  2633. form2.ShowDialog();
  2634. break;
  2635. case "权限管理":
  2636. PowerSetting pws = new PowerSetting();
  2637. BaseUtil.SetFormCenter(pws);
  2638. pws.ShowDialog();
  2639. break;
  2640. default:
  2641. break;
  2642. }
  2643. }
  2644. private void MessageLog_KeyDown(object sender, KeyEventArgs e)
  2645. {
  2646. if (e.Modifiers == Keys.Alt && e.KeyCode == Keys.I)
  2647. {
  2648. adh.ExecuteSql(MessageLog.Text, "update");
  2649. }
  2650. }
  2651. }
  2652. }