123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736 |
- using System;
- using System.Data;
- using System.Drawing;
- using System.Windows.Forms;
- using System.Text.RegularExpressions;
- using System.Text;
- using System.Collections.Generic;
- using System.Diagnostics;
- using LabelManager2;
- using UAS_LabelMachine.PublicMethod;
- using UAS_LabelMachine.Entity;
- using UAS_LabelMachine.PublicForm;
- using System.Threading;
- using System.IO;
- using System.IO.Ports;
- using UAS_LabelMachine.CustomControl;
- using System.Reflection;
- namespace UAS_LabelMachine
- {
- public partial class UAS_出货标签打印 : Form
- {
- //自适应屏幕
- AutoSizeFormClass asc = new AutoSizeFormClass();
- DataHelper dh;
- DataHelper dh1;
- SqliteDBHelper adh;
- SqliteDBHelper back_adh;
- DataTable dt;
- StringBuilder sql = new StringBuilder();
- /// <summary>
- /// CodeSoft新建打印机引擎
- /// </summary>
- ApplicationClass lbl;
- /// <summary>
- /// 单盘打印文件
- /// </summary>
- Document SingleDoc;
- /// <summary>
- /// 中盒打印文件
- /// </summary>
- Document MidDoc;
- /// <summary>
- /// 外箱打印文件
- /// </summary>
- Document OutBoxDoc;
- /// <summary>
- /// Loading窗口
- /// </summary>
- SetLoadingWindow stw;
- /// <summary>
- /// 弹窗线程
- /// </summary>
- Thread thread;
- string PI_ID;
- /// <summary>
- /// 当前扫描的所在行
- /// </summary>
- int CurrentRowIndex = 0;
- /// <summary>
- /// 正则表达式用于项目匹配
- /// </summary>
- Regex reg;
- bool logout = false;
- DataTable SingleLabelParam;
- DataTable MidLabelParam;
- DataTable OutLabelParam;
- /// <summary>
- /// 存放单盘的ID
- /// </summary>
- List<string> SingleID = new List<string>();
- /// <summary>
- /// 单盘的打印参数
- /// </summary>
- List<string> SingleBoxArgument = new List<string>();
- /// <summary>
- /// 存放中盒的ID和盒号
- /// </summary>
- Dictionary<string, string> MidIDAndOutboxcode = new Dictionary<string, string>();
- /// <summary>
- /// 中盒的打印参数
- /// </summary>
- List<string> MidBoxArgument = new List<string>();
- /// <summary>
- /// 默认采集了指定的数据上传
- /// </summary>
- int UploadNum = 100;
- /*需要重绘的Cell*/
- Dictionary<DataGridViewCell, bool> PaintCell = new Dictionary<DataGridViewCell, bool>();
- /// <summary>
- /// 是否通过选择Combox来改变打开的文件
- /// </summary>
- bool ComBoxClickChangeLabelDoc = false;
- /// <summary>
- /// 附加信息DataTable
- /// </summary>
- DataTable Attach;
- /// <summary>
- /// 采集策略DataTable
- /// </summary>
- DataTable ScanGroup;
- /// <summary>
- /// 采集明细DataTable
- /// </summary>
- DataTable ScanItem;
- public UAS_出货标签打印(string Master)
- {
- //设置窗体的双缓冲
- this.SetStyle(ControlStyles.OptimizedDoubleBuffer | ControlStyles.ResizeRedraw | ControlStyles.AllPaintingInWmPaint, true);
- this.UpdateStyles();
- InitializeComponent();
- //利用反射设置DataGridView的双缓冲
- Type dgvType = this.LabelInf.GetType();
- PropertyInfo pi = dgvType.GetProperty("DoubleBuffered", BindingFlags.Instance | BindingFlags.NonPublic);
- pi.SetValue(this.LabelInf, true, null);
- Text = Text + "-" + Master;
- }
- protected override void WndProc(ref Message m)
- {
- //拦截双击标题栏、移动窗体的系统消息
- if (m.Msg != 0xA3)
- {
- base.WndProc(ref m);
- }
- }
- private void 贴标机条码打印_Load(object sender, EventArgs e)
- {
- //杀死之前全部未关闭的进程
- Process[] processes = System.Diagnostics.Process.GetProcessesByName("lppa");
- for (int i = 0; i < processes.Length; i++)
- {
- processes[i].Kill();
- }
- //用计时器重置数据库链接
- LogManager.DoLog("程序启动,登陆人员【" + User.UserName + "】");
- dh = SystemInf.dh;
- dh1 = SystemInf.dh1;
- adh = SystemInf.adh;
- back_adh = SystemInf.back_adh;
- CheckForIllegalCrossThreadCalls = false;
- pi_inoutno.TableName = "prodinout";
- pi_inoutno.Field = "pi_inoutno";
- pi_inoutno.ValueField = "pi_inoutno";
- pi_inoutno.Condition = "pi_class in('出货单','拨出单')";
- pi_inoutno.Focus();
- Point pt = new Point();
- //禁止所有列的排序
- foreach (DataGridViewColumn dgv in LabelInf.Columns)
- {
- dgv.SortMode = DataGridViewColumnSortMode.NotSortable;
- }
- AutoCollection.Checked = true;
- int ScreenWidth = Screen.GetWorkingArea(pt).Width;
- //设置获取当前屏幕大小自动全屏但是保留任务栏
- Rectangle ScreenArea = Screen.GetWorkingArea(this);
- Top = 0;
- Left = 0;
- Width = ScreenArea.Width;
- Height = ScreenArea.Height;
- MidBoxCapacity.Value = Properties.Settings.Default.MidBoxCapacity;
- OutBoxCapacity.Value = Properties.Settings.Default.OutboxCapacity;
- asc.controllInitializeSize(this);
- asc.controlAutoSize(this);
- pi_inoutno.BringToFront();
- //实例化打印进程
- try
- {
- lbl = new ApplicationClass();
- SystemInf.lbl = lbl;
- }
- catch (Exception)
- {
- MessageBox.Show("未安装CodeSoft软件或者版本不正确");
- }
- RefreshDBConnect.Interval = 60000;
- RefreshDBConnect.Start();
- DataTable dt = (DataTable)adh.ExecuteSql("select * from cominfo", "select");
- DataRow[] dr;
- try
- {
- dr = dt.Select("comtype='FrontendCheck'");
- if (dr.Length > 0)
- {
- FrontendCheck.PortName = dr[0]["COM"].ToString();
- int sleeptime = 0;
- if (int.TryParse(dr[0]["DATAWAIT"].ToString(), out sleeptime))
- {
- FrontendCheck.SleepTime = sleeptime;
- }
- FrontendCheck.Tag = "FrontendCheck";
- FrontendCheck.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
- FrontendCheck.DataReceived += Serial_DataReceived;
- FrontendCheck.Open();
- }
- }
- catch (Exception ex)
- {
- MessageLog.AppendText("前端扫描" + ex.Message + "\n");
- }
- try
- {
- dr = dt.Select("comtype='BackendCheck'");
- if (dr.Length > 0)
- {
- BackendCheck.PortName = dr[0]["COM"].ToString();
- BackendCheck.Tag = "BackendCheck";
- int sleeptime = 0;
- if (int.TryParse(dr[0]["DATAWAIT"].ToString(), out sleeptime))
- {
- BackendCheck.SleepTime = sleeptime;
- }
- BackendCheck.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
- BackendCheck.DataReceived += Serial_DataReceived;
- BackendCheck.Open();
- }
- }
- catch (Exception ex)
- {
- MessageLog.AppendText("后端扫描" + ex.Message + "\n");
- }
- try
- {
- dr = dt.Select("comtype='PLC1'");
- if (dr.Length > 0)
- {
- if (!PLC1.IsOpen)
- {
- PLC1.PortName = dr[0]["COM"].ToString();
- PLC1.Tag = "PLC1";
- int sleeptime = 0;
- if (int.TryParse(dr[0]["DATAWAIT"].ToString(), out sleeptime))
- {
- PLC1.SleepTime = sleeptime;
- }
- PLC1.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
- PLC1.DataReceived += Serial_DataReceived;
- PLC1.Open();
- }
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.DeviceStart, adh);
- MessageLog.AppendText("PLC启动成功\n", Color.Blue);
- }
- }
- catch (Exception ex)
- {
- MessageLog.AppendText("自动贴标机" + ex.Message + "\n");
- }
- try
- {
- dr = dt.Select("comtype='ManBackendCheck'");
- if (dr.Length > 0)
- {
- if (!ManBackendCheck.IsOpen)
- {
- ManBackendCheck.PortName = dr[0]["COM"].ToString();
- ManBackendCheck.Tag = "ManBackendCheck";
- int sleeptime = 0;
- if (int.TryParse(dr[0]["DATAWAIT"].ToString(), out sleeptime))
- {
- ManBackendCheck.SleepTime = sleeptime;
- }
- ManBackendCheck.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
- ManBackendCheck.DataReceived += Serial_DataReceived;
- ManBackendCheck.Open();
- }
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.DeviceStart, adh);
- MessageLog.AppendText("PLC启动成功\n", Color.Blue);
- }
- }
- catch (Exception ex)
- {
- MessageLog.AppendText("手动后端复核" + ex.Message + "\n");
- }
- RefreshPLCInstruct();
- }
- string LotNo = "";
- string DateCode = "";
- string Order = "";
- string QTY = "";
- string PN = "";
- string OutBox = "";
- List<int> ManualCheckCount = new List<int>();
- //获取串口数据
- private void Serial_DataReceived(object sender, SerialDataReceivedEventArgs e)
- {
- try
- {
- string ErrorMsg = "";
- SerialPortWithTag port = sender as SerialPortWithTag;
- Thread.Sleep(port.SleepTime);
- int len = port.BytesToRead;
- byte[] readBuffer = new byte[len];
- port.Read(readBuffer, 0, len); //将数据读入缓存
- string msg = Encoding.ASCII.GetString(readBuffer, 0, len).Replace("\n", "").Replace("\r", "").Replace("\t", ""); //获取出入库产品编号
- if (LabelInf.Rows.Count == 0)
- return;
- int pib_pdno = int.Parse(LabelInf.Rows[CurrentRowIndex].Cells["pib_pdno"].Value.ToString());
- if (DetailRange.Checked)
- {
- //不在范围内的不进行处理
- if (!(pib_pdno >= DetailRange1.Value && pib_pdno <= DetailRange2.Value))
- {
- return;
- }
- }
- switch (port.Tag)
- {
- case "PLC1":
- ScanGroup = BaseUtil.filterDataTable(ScanGroup, "sg_autolabel<>0");
- //MessageLog.AppendText(msg + "\n", Color.Blue);
- ////返回的指令和设备执行的动作对应
- //foreach (var item in instruct)
- //{
- // //接收到的数据和指令的对应则
- // if (item.Value == msg)
- // {
- // }
- //}
- break;
- case "PLC2":
- ScanGroup = BaseUtil.filterDataTable(ScanGroup, "sg_autolabel<>0");
- break;
- case "FrontendCheck":
- ScanGroup = BaseUtil.filterDataTable(ScanGroup, "sg_autolabel<>0");
- //比对当前箱数量和容量
- FrontCollect.Text = msg;
- if (!FrontCheckFunction(msg, out ErrorMsg))
- {
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.FrontDataDelete, adh);
- BaseUtil.PlaySound("Scan.Error.wav");
- MessageLog.AppendText(">>" + ErrorMsg + "\n", Color.Red);
- }
- else
- {
- if (cu_print_checkdatecode.Checked)
- {
- string datecode = LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value.ToString();
- string lotno = LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value.ToString();
- if (datecode == "" || lotno == "")
- {
- MessageLog.AppendText(">>设定必须采集DateCode内容,请先采集再打印\n", Color.Red);
- return;
- }
- }
- //勾选了单盘自动打印
- if (SingleLabelAutoPrint.Checked)
- {
- if (SingleLabelCombox.SelectedValue != null)
- {
- AutoPrintSingleLabel();
- }
- else
- {
- MessageBox.Show("未维护单盘标签");
- return;
- }
- }
- LabelInf.Rows[CurrentRowIndex].Cells["pib_ifpick"].Value = true;
- BaseUtil.PlaySound("Scan.Finish.wav");
- //勾选了中盒自动打印
- if (MidLabelAutoPrint.Checked)
- AutoPrintMidLabel();
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.FrontDataPass, adh);
- LabelInf.Invalidate();
- RefreshProcessData();
- }
- break;
- case "BackendCheck":
- ScanGroup = BaseUtil.filterDataTable(ScanGroup, "sg_autolabel<>0");
- BackCheck.Text = msg;
- if (BackendCheckFunction(msg, "Auto", out ErrorMsg))
- {
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.BackDataPass, adh);
- BaseUtil.PlaySound("Confirm.Finish.wav");
- }
- else
- {
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.BackDataDelete, adh);
- BaseUtil.PlaySound("Confirm.Error.wav");
- MessageLog.AppendText(">>" + ErrorMsg + "\n", Color.Red);
- }
- break;
- case "ManBackendCheck":
- if (ManualBackCheck.Checked)
- {
- BackCheck.Text = msg;
- if (BackendCheckFunction(msg, "Manual", out ErrorMsg))
- {
- ManualCheckCount.Add(1);
- }
- else
- {
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.BackDataDelete, adh);
- BaseUtil.PlaySound("Confirm.Error.wav");
- MessageLog.AppendText(">>" + ErrorMsg + "\n", Color.Red);
- }
- if (ManualCheckCount.Count == 2)
- {
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.BackDataPass, adh);
- BaseUtil.PlaySound("Confirm.Finish.wav");
- ManualCheckCount.Clear();
- }
- }
- else
- {
- MessageLog.AppendText(">>该串口为手动复核串口,请选择手动后端复核模式\n", Color.Red);
- }
- break;
- default:
- break;
- }
- }
- catch (Exception ex)
- {
- LogManager.DoLog(ex.Message + ex.StackTrace);
- MessageLog.AppendText("接收返回消息异常!具体原因:" + ex.Message + ex.StackTrace, Color.Red);
- }
- }
- string year = "";
- string month = "";
- string day = "";
- string date = "";
- private bool RegexMatch(string CheckType, string msg, out string ErrorMsg)
- {
- ErrorMsg = "";
- bool Matched = false;
- for (int i = 0; i < ScanGroup.Rows.Count; i++)
- {
- string sg_name = ScanGroup.Rows[i]["sg_name"].ToString();
- string sg_brand = ScanGroup.Rows[i]["sg_brand"].ToString();
- string sg_script = ScanGroup.Rows[i]["sg_script"].ToString();
- string sg_id = ScanGroup.Rows[i]["sg_id"].ToString();
- reg = new Regex(sg_script);
- Match matchs1 = reg.Match(msg);
- DataTable dt = BaseUtil.filterDataTable(ScanItem, "sg_id=" + sg_id);
- if (matchs1.Success)
- {
- int rownum = 0;
- Matched = true;
- string ItemStr = "";
- foreach (var groupName in reg.GetGroupNames())
- {
- for (int j = 0; j < dt.Rows.Count; j++)
- {
- //如果组别名称相等的话
- if (groupName == dt.Rows[j]["si_name"].ToString())
- {
- ItemStr += dt.Rows[j]["si_item"].ToString() + ",";
- string si_expression = dt.Rows[j]["si_expression"].ToString();
- Regex si_exp;
- switch (dt.Rows[j]["si_item"].ToString())
- {
- case "DateCode":
- if (si_expression != "")
- {
- si_exp = new Regex(si_expression);
- Match mat = si_exp.Match(matchs1.Groups[reg.GroupNumberFromName(groupName)].Value);
- foreach (var dtgroup in si_exp.GetGroupNames())
- {
- if (dtgroup == dt.Rows[j]["si_name"].ToString())
- DateCode = mat.Groups[si_exp.GroupNumberFromName(dtgroup)].Value;
- }
- }
- else
- {
- DateCode = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
- }
- LogicHandler.GetTimeFromDatecode(dh, DateCode, pi_cardcode.Text, out year, out month, out day, out date);
- System.DateTime dtime;
- //有效期比对
- if (System.DateTime.TryParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime))
- {
- if ((System.DateTime.Now - dtime).Days > cu_print_limiteddate.Value)
- {
- MessageLog.AppendText(">>超出有效期\n", Color.Red);
- }
- }
- break;
- case "LotNo":
- LotNo = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
- break;
- case "PN":
- PN = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
- //自动匹配客户PN
- string sql = "select min(rownum) as rn from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'";
- if (CheckType == "FrontCheck")
- {
- sql += " and pib_ifpick=0 and " + (prodcodefront.Text == "" ? "pr_orispeccode" : prodcodefront.Text) + "='" + PN + "'";
- }
- else if (CheckType == "BackCheck")
- {
- sql += " and pib_ifrecheck=0 and " + (prodcodeback.Text == "" ? "pr_orispeccode" : prodcodeback.Text) + "='" + PN + "'";
- }
- DataTable pndt = (DataTable)adh.ExecuteSql(sql, "select");
- if (pndt.Rows[0][0].ToString() != "")
- {
- rownum = int.Parse(pndt.Rows[0]["rn"].ToString());
- //如果需要翻页的话
- if (!(rownum >= (PageSize * (CurrentPage - 1) + 1) && rownum <= PageSize * CurrentPage))
- {
- CurrentPage = rownum / PageSize + 1;
- LoadGridData();
- CurrentRowIndex = rownum % PageSize == 0 ? PageSize - 1 : rownum % PageSize - 1;
- if (CurrentRowIndex - 5 > 0)
- LabelInf.FirstDisplayedScrollingRowIndex = CurrentRowIndex - 5;
- else
- LabelInf.FirstDisplayedScrollingRowIndex = 0;
- }
- else
- {
- CurrentRowIndex = rownum % PageSize == 0 ? PageSize - 1 : rownum % PageSize - 1;
- if (CurrentRowIndex - 5 > 0)
- LabelInf.FirstDisplayedScrollingRowIndex = CurrentRowIndex - 5;
- else
- LabelInf.FirstDisplayedScrollingRowIndex = 0;
- }
- }
- else
- {
- ErrorMsg = "未能匹配到合适的原厂型号";
- }
- break;
- case "Order":
- Order = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
- if (LabelInf.Rows[CurrentRowIndex].Cells["pd_pocode"].Value.ToString() != Order)
- {
- ErrorMsg = "订单号不匹配";
- }
- break;
- case "QTY":
- if (si_expression != "")
- {
- si_exp = new Regex(si_expression);
- Match mat = si_exp.Match(matchs1.Groups[reg.GroupNumberFromName(groupName)].Value);
- foreach (var dtgroup in si_exp.GetGroupNames())
- {
- if (dtgroup == dt.Rows[j]["si_name"].ToString())
- {
- QTY = mat.Groups[si_exp.GroupNumberFromName(dtgroup)].Value;
- }
- }
- }
- else
- {
- QTY = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
- }
- break;
- case "OutBox":
- OutBox = matchs1.Groups[reg.GroupNumberFromName(groupName)].Value;
- break;
- default:
- break;
- }
- }
- }
- }
- //如果品牌不对应的话则不能使用本次的匹配规则
- if (ErrorMsg == "" && ItemStr.Contains("QTY") && LabelInf.Rows[CurrentRowIndex].Cells["pib_qty"].Value.ToString() != QTY.ToString())
- {
- ErrorMsg = "数量不匹配";
- }
- if (ErrorMsg == "" && ItemStr.Contains("PO") && LabelInf.Rows[CurrentRowIndex].Cells["pd_pocode"].Value.ToString() != Order)
- {
- ErrorMsg = "订单号不匹配";
- }
- //如果匹配到的行的品牌和当前正则的品牌不相等结束本次循环
- if (LabelInf.Rows[CurrentRowIndex].Cells["pib_brand"].Value.ToString() == sg_brand)
- {
- break;
- }
- }
- }
- if (!Matched)
- {
- ErrorMsg = "未匹配到合适的采集策略";
- }
- if (ErrorMsg == "")
- {
- return true;
- }
- else
- {
- return false;
- }
- }
- private bool FrontCheckFunction(string msg, out string ErrorMsg)
- {
- ErrorMsg = "";
- //调用正则验证
- RegexMatch("FrontCheck", msg, out ErrorMsg);
- if (ErrorMsg != "")
- {
- return false;
- }
- else
- {
- //获取当前最大的箱号
- LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value = DateCode;
- LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value = LotNo;
- LabelInf.Rows[CurrentRowIndex].Cells["pib_ifmodify"].Value = true;
- SetOutboxBarcode();
- return true;
- }
- }
- //外箱条码号
- string OutBoxBarCode = "";
- //中盒条码号
- string MidBoxBarCode = "";
- string pibid1 = "";
- private bool BackendCheckFunction(string msg, string type, out string ErrorMsg)
- {
- ErrorMsg = "";
- DataTable dtt = LabelInf.DataSource as DataTable;
- MessageLog.AppendText(msg + "\n");
- string[] msgArr = msg.Split(back_sg_separator.Text.ToCharArray());
- //如果包含则分隔符则需要解析,如果不包含则直接前端解析
- if (!cu_print_checkonly.Checked)
- {
- //需要校验2项数据,完成校验后此项的值需要为2则表示校验成功
- List<string> CheckItem = new List<string>();
- string pibid = "";
- for (int i = 0; i < msgArr.Length; i++)
- {
- if (RecheckCuprodcode.Checked)
- {
- if (!CheckItem.Contains("客户料号") && !CheckItem.Contains("原厂型号"))
- {
- CheckItem.Add("客户料号");
- CheckItem.Add("原厂型号");
- }
- //直接验证两个值相等
- if (Equal.Checked)
- {
- 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();
- if (pibid != "")
- {
- pibid1 = pibid;
- CheckItem.Remove("客户料号");
- }
- }
- //验证正则匹配过之后相等
- else if (Expression.Checked)
- {
- Regex re = new Regex(cu_print_regexpression.Text);
- Match matchs1 = re.Match(msgArr[i]);
- foreach (var groupName in re.GetGroupNames())
- {
- if (groupName == "custPN")
- {
- if (LabelInf.Rows[CurrentRowIndex].Cells[(guestlabeldata.Text == "" ? "pd_custprodcode" : guestlabeldata.Text)].Value.ToString() == matchs1.Groups[re.GroupNumberFromName(groupName)].Value)
- {
- 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();
- if (pibid != "")
- {
- pibid1 = pibid;
- CheckItem.Remove("客户料号");
- }
- }
- }
- }
- }
- if (RegexMatch("BackCheck", msgArr[i], out ErrorMsg))
- {
- CheckItem.Remove("原厂型号");
- }
- }
- else if (RecheckBarcode.Checked)
- {
- if (!CheckItem.Contains("唯一条码") && !CheckItem.Contains("原厂型号"))
- {
- CheckItem.Add("唯一条码");
- CheckItem.Add("原厂型号");
- }
- pibid = back_adh.getFieldDataByCondition("prodiobarcode", "min(pib_id)", "pib_inoutno='" + pi_inoutno.Text + "' and pib_barcode='" + msgArr[i] + "' and pib_ifrecheck=0").ToString();
- if (pibid != "")
- {
- pibid1 = pibid;
- CheckItem.Remove("唯一条码");
- }
- else
- {
- if (RegexMatch("BackCheck", msgArr[i], out ErrorMsg))
- {
- CheckItem.Remove("原厂型号");
- }
- }
- }
- }
- //如果是自动复核或者手动复核扫描了两次数据的话
- if (CheckItem.Count == 0 || (type == "Manual" && CheckItem.Count == 1))
- {
- if (CheckItem.Count == 0 || (ManualCheckCount.Count == 1 && CheckItem.Count == 1))
- {
- string year = "0";
- string month = "0";
- string day = "0";
- string date = "";
- DataRow[] dr = LabelInfDataTable.Select("pib_id=" + pibid1 + " and pr_orispeccode='" + PN + "'");
- if (dr.Length > 0)
- {
- dr[0]["pib_ifrecheck"] = -1;
- dr[0]["pib_lotno"] = LotNo;
- dr[0]["pib_datecode"] = DateCode;
- try
- {
- LogicHandler.GetTimeFromDatecode(dh1, DateCode, pi_cardcode.Text, out year, out month, out day, out date);
- dr[0]["pib_year"] = year;
- dr[0]["pib_month"] = month;
- dr[0]["pib_day"] = day;
- }
- catch (Exception)
- {
- }
- }
- else
- {
- ErrorMsg = "未匹配到合适的原厂型号";
- return false;
- }
- 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");
- }
- }
- else
- {
- string Item = "";
- for (int i = 0; i < CheckItem.Count; i++)
- {
- Item += CheckItem[i].ToString() + " ";
- }
- //如果通过正则校验,则不需要传递出来的错误信息了
- if (!CheckItem.Contains("原厂型号"))
- {
- ErrorMsg = "";
- }
- else
- {
- ErrorMsg = "【" + ErrorMsg + "】";
- }
- ErrorMsg += Item + "复核不通过";
- return false;
- }
- if (CheckItem.Count == 0 || (ManualCheckCount.Count == 1 && CheckItem.Count == 1))
- {
- LabelInf.Invalidate();
- RefreshProcessData();
- if (CurrentRowIndex - 5 > 0)
- LabelInf.FirstDisplayedScrollingRowIndex = CurrentRowIndex - 5;
- else
- LabelInf.FirstDisplayedScrollingRowIndex = 0;
- //如果成功上传了数据
- if (LogicHandler.CheckUploadData(pi_inoutno.Text, UploadNum))
- {
- for (int i = 0; i < dtt.Rows.Count; i++)
- {
- if (dtt.Rows[i]["pib_ifrecheck"].ToString() != "0" && dtt.Rows[i]["pib_ifupload"].ToString() == "0")
- {
- dtt.Rows[i]["pib_ifupload"] = -1;
- }
- }
- }
- return true;
- }
- else
- {
- if (type == "Manual" && CheckItem.Count == 1)
- return true;
- else
- return false;
- }
- }
- else
- {
- if (RegexMatch("BackCheck", msg, out ErrorMsg))
- {
- string year = "0";
- string month = "0";
- string day = "0";
- string date = "";
- LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value = DateCode;
- //解析DateCode,将值设置到年月日
- try
- {
- LogicHandler.GetTimeFromDatecode(dh1, DateCode, pi_cardcode.Text, out year, out month, out day, out date);
- LabelInf.Rows[CurrentRowIndex].Cells["pib_year"].Value = year;
- LabelInf.Rows[CurrentRowIndex].Cells["pib_month"].Value = month;
- LabelInf.Rows[CurrentRowIndex].Cells["pib_day"].Value = day;
- }
- catch (Exception) { }
- LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value = LotNo;
- LabelInf.Rows[CurrentRowIndex].Cells["pib_ifmodify"].Value = true;
- LabelInf.Rows[CurrentRowIndex].Cells["pib_ifrecheck"].Value = true;
- LabelInf.Rows[CurrentRowIndex].Cells["pib_ifpick"].Value = true;
- 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);
- LogicHandler.CheckUploadData(pi_inoutno.Text, UploadNum);
- LabelInf.Invalidate();
- return true;
- }
- return false;
- }
- }
- //只执行一次窗体自适应
- bool AutoSized = false;
- private void 贴标机条码打印_SizeChanged(object sender, EventArgs e)
- {
- if (!AutoSized)
- {
- asc.controlAutoSize(this);
- AutoSized = true;
- }
- }
- private void LabelFormClose(object sender, EventArgs e)
- {
- if (GetGridOnly.Checked)
- GetInOutInfAndLabelFile();
- else
- {
- GetGridOnly.Checked = true;
- GetInOutInfAndLabelFile();
- GetGridOnly.Checked = false;
- }
- }
- private bool AutoPrintSingleLabel()
- {
- //用标签本身的变量作为最外层的循环条件去匹配;
- SinglePrint(LabelInf.Rows[CurrentRowIndex].Cells["pib_id1"].Value.ToString());
- LabelInf.Rows[CurrentRowIndex].Cells["pib_ifprint"].Value = true;
- return true;
- }
- //关闭窗口前提示用户确认
- private void 贴标机条码打印_FormClosing(object sender, FormClosingEventArgs e)
- {
- //如果不是注销的话
- if (!logout)
- {
- string close = MessageBox.Show(this.ParentForm, "是否关闭", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
- if (close.ToString() != "Yes")
- e.Cancel = true;
- else
- {
- lbl.Quit();
- LogManager.DoLog("关闭程序");
- }
- }
- }
- /// <summary>
- /// 获取打印标签
- /// </summary>
- private void GetInOutInfAndLabelFile()
- {
- ComBoxClickChangeLabelDoc = false;
- Attach = (DataTable)dh.ExecuteSql("select lap_param lp_name,lap_value lp_sql from LabelAttachPARAMETER where lap_custcode='" + pi_cardcode.Text + "'", "select");
- sql.Clear();
- 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 ");
- sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
- sql.Append("and pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='单盘' order by cl_custcode");
- dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- SingleLabelCombox.DisplayMember = "cl_labelname";
- SingleLabelCombox.ValueMember = "la_id";
- SingleLabelCombox.DataSource = dt;
- if (SingleDoc != null)
- SingleDoc.Close();
- if (!GetGridOnly.Checked)
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
- string LabelName = dt.Rows[i]["cl_labelname"].ToString();
- System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
- FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
- if (time.ToString() != file.LastWriteTime.ToString())
- BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
- }
- if (SingleLabelCombox.Text != "")
- {
- SingleDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + SingleLabelCombox.Text);
- SingleDoc.Printer.SwitchTo(SingleLabelPrinter.Text);
- 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");
- }
- sql.Clear();
- 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 ");
- sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
- sql.Append("and pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='中盒' order by cl_custcode");
- dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- MidLabelCombox.DisplayMember = "cl_labelname";
- MidLabelCombox.ValueMember = "la_id";
- MidLabelCombox.DataSource = dt;
- if (MidDoc != null)
- MidDoc.Close();
- if (!GetGridOnly.Checked)
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
- string LabelName = dt.Rows[i]["cl_labelname"].ToString();
- System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
- FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
- if (time.ToString() != file.LastWriteTime.ToString())
- BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
- }
- if (MidLabelCombox.Text != "")
- {
- MidDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + MidLabelCombox.Text);
- MidDoc.Printer.SwitchTo(MidLabelPrinter.Text);
- 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");
- }
- //缓存中盒参数
- sql.Clear();
- 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 ");
- sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
- sql.Append("and pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='外箱' order by cl_custcode");
- dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- OutBoxCombox.DisplayMember = "cl_labelname";
- OutBoxCombox.ValueMember = "la_id";
- OutBoxCombox.DataSource = dt;
- if (OutBoxDoc != null)
- OutBoxDoc.Close();
- if (!GetGridOnly.Checked)
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
- string LabelName = dt.Rows[i]["cl_labelname"].ToString();
- System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
- FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
- if (time.ToString() != file.LastWriteTime.ToString())
- BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
- }
- if (OutBoxCombox.Text != "")
- {
- OutBoxDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + OutBoxCombox.Text);
- OutBoxDoc.Printer.SwitchTo(OutBoxPrinter.Text);
- 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");
- }
- //缓存外箱参数
- ComBoxClickChangeLabelDoc = true;
- }
- /// <summary>
- /// 出入库单录入框的回车事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void pi_inoutno_KeyDown(object sender, KeyEventArgs e)
- {
- if (e.KeyCode == Keys.Enter)
- {
- CurrentPage = 1;
- sql.Clear();
- 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('已捡料','已复核')");
- dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- if (dt.Rows.Count > 0)
- {
- pi_cardcode.Text = dt.Rows[0]["pi_cardcode"].ToString();
- pi_date.Text = dt.Rows[0]["pi_date"].ToString();
- PI_ID = dt.Rows[0]["pi_id"].ToString();
- //if (dh.GetConfig("AutoBarcode", "ProdInOut!Sale").ToString() != "")
- //{
- string[] param = new string[] { PI_ID, "" };
- dh.CallProcedure("GetCustBarcode", ref param);
- //}
- RefreshParamData();
- //查询所有的采集策略
- sql.Clear();
- 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 ");
- 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 ");
- 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 ");
- ScanItem = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- sql.Clear();
- sql.Append("select distinct sg_brand from prodiodetail left join product on pd_prodcode=pr_code left join scangroup ");
- sql.Append("on nvl(pd_brand,pr_brand)=sg_brand where pd_inoutno='" + pi_inoutno.Text + "' and sg_brand is not null");
- DataTable dt1 = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- FrontCombo.DataSource = dt1;
- FrontCombo.DisplayMember = "sg_brand";
- FrontCombo.ValueMember = "sg_brand";
- BackCombo.DataSource = dt1;
- BackCombo.DisplayMember = "sg_brand";
- BackCombo.ValueMember = "sg_brand";
- LoadGridData();
- //重新输入单号后清除缓存
- MidBoxArgument.Clear();
- SingleBoxArgument.Clear();
- MidIDAndOutboxcode.Clear();
- SingleID.Clear();
- thread = new Thread(GetInOutInfAndLabelFile);
- stw = new SetLoadingWindow(thread, "正在获取打印标签");
- BaseUtil.SetFormCenter(stw);
- stw.ShowDialog();
- LogManager.DoLog("输入单号【" + pi_inoutno.Text + "】");
- }
- else
- MessageBox.Show("当前出入库单号" + pi_inoutno.Text + "不存在或未完成捡料!");
- }
- }
- private void SingleBoxPrint()
- {
- try
- {
- if (SingleDoc.Variables.FormVariables.Count == 0) { }
- }
- catch (Exception)
- {
- MessageBox.Show("单盘标签未维护参数");
- }
- if (MidLabelAutoPrint.Checked)
- {
- try
- {
- if (MidDoc.Variables.FormVariables.Count == 0) { }
- }
- catch (Exception)
- {
- MessageBox.Show("中盘标签未维护参数");
- }
- }
- if (SingleLabelParam.Rows.Count > 0 && LabelInf.Rows.Count > 0)
- {
- //每次打印清除之前缓存的行号和ID,后面会判断需要打印的数据重新加载
- MidIDAndOutboxcode.Clear();
- SingleID.Clear();
- //获取全部的中盒号
- Dictionary<string, bool> outboxcode1 = new Dictionary<string, bool>();
- //判断所有盒号为该盒的是否勾选已采集
- outboxcode1.Add(LabelInf.Rows[0].Cells["pib_outboxcode1"].Value.ToString(), true);
- for (int i = 0; i < LabelInf.Rows.Count; i++)
- {
- if (!SingleID.Contains(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString()))
- SingleID.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString());
- if (LabelInf.Rows[i].Cells["pib_ifpick"].FormattedValue.ToString() == "True" && LabelInf.Rows[i].Cells["pib_ifprint"].FormattedValue.ToString() != "True")
- {
- //如果不存在中盒号则进行添加
- if (!MidIDAndOutboxcode.ContainsValue(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()))
- {
- MidIDAndOutboxcode.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString());
- }
- }
- }
- if (SingleID.ToArray().Length == 0)
- {
- MessageBox.Show("选择的行未勾选采集或者已打印");
- return;
- }
- for (int i = 0; i < LabelInf.RowCount; i++)
- {
- if (i + 1 < LabelInf.RowCount)
- {
- //如果本行的中盒号和下一行不相等的话
- if (LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() != LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString())
- {
- if (!outboxcode1.ContainsKey(LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString()))
- outboxcode1.Add(LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString(), true);
- }
- }
- //只要有一行没有采集满就不打印
- if (LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() == LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode1"].Value.ToString())
- {
- if (LabelInf.Rows[i].Cells["pib_ifpick"].FormattedValue.ToString() != "True")
- outboxcode1[LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()] = false;
- }
- }
- //用于判断用户是否勾选了行
- int CheckedRowCount = 0;
- for (int i = 0; i < LabelInf.RowCount; i++)
- {
- //勾选了并且未打印
- if (LabelInf.Rows[i].Cells["pib_ifpick"].FormattedValue.ToString() == "True" && LabelInf.Rows[i].Cells["pib_ifprint"].FormattedValue.ToString() != "True")
- {
- if (cu_print_checkdatecode.Checked)
- {
- string datecode = LabelInf.Rows[i].Cells["pib_datecode"].Value.ToString();
- string lotno = LabelInf.Rows[i].Cells["pib_lotno"].Value.ToString();
- if (datecode == "" || lotno == "")
- {
- MessageLog.AppendText(">>设定必须采集DateCode内容,请先采集再打印\n", Color.Red);
- return;
- }
- }
- CheckedRowCount = CheckedRowCount + 1;
- CurrentRowIndex = i;
- //以标签模板的参数为基准,循环取数
- try
- {
- SinglePrint(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString());
- if (MidLabelAutoPrint.Checked)
- {
- //判断当前行的盒号和下一行不相等或者已经是最后一行了
- 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())
- {
- if (outboxcode1[LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()])
- {
- if (MidLabelCombox.SelectedValue != null)
- {
- MidBoxCodePrint(CurrentRowIndex);
- }
- }
- }
- }
- //勾选为已打印
- LabelInf.Rows[i].Cells["pib_ifprint"].Value = true;
- }
- catch (Exception ex) { LogManager.DoLog(ex.Message); }
- }
- }
- if (CheckedRowCount == 0)
- MessageBox.Show("未勾选打印明细!");
- else if (CurrentRowIndex + 1 < LabelInf.Rows.Count)
- CurrentRowIndex = CurrentRowIndex + 1;
- outboxcode1.Clear();
- }
- else
- {
- MessageBox.Show("此模板尚未维护参数或不存在打印明细");
- return;
- }
- }
- private void SingleLabelPrint_Click(object sender, EventArgs e)
- {
- if (SingleLabelCombox.Text != "")
- {
- if (SingleBoxBegin.Text != "" || SingleBoxEnd.Text != "")
- {
- try
- {
- int begin = int.Parse(SingleBoxBegin.Text == "" ? "1" : SingleBoxBegin.Text);
- int end = int.Parse(SingleBoxEnd.Text == "" ? LabelInf.Rows.Count.ToString() : SingleBoxEnd.Text);
- if (begin > 0 && end <= LabelInf.Rows.Count && begin <= end)
- {
- for (int i = begin - 1; i < end; i++)
- {
- LabelInf.Rows[i].Cells["pib_ifpick"].Value = true;
- LabelInf.Rows[i].Cells["pib_ifprint"].Value = false;
- }
- }
- else
- {
- MessageBox.Show("单盘打印范围错误");
- return;
- }
- }
- catch (Exception)
- {
- MessageBox.Show("单盘打印范围错误");
- return;
- }
- }
- thread = new Thread(SingleBoxPrint);
- stw = new SetLoadingWindow(thread, "正在打印单盘");
- BaseUtil.SetFormCenter(stw);
- stw.ShowDialog();
- }
- else
- MessageBox.Show("未维护单盘标签");
- }
- private void MidBoxLabelPrint()
- {
- //未输入内容打印全部中盒
- if (MidLabelNum.Text == "")
- {
- int begin = 0;
- int end = 0;
- if (MidBoxBegin.Text != "" || MidBoxEnd.Text != "")
- {
- try
- {
- begin = int.Parse(MidBoxBegin.Text == "" ? "1" : MidBoxBegin.Text);
- end = int.Parse(MidBoxEnd.Text == "" ? LabelInf.Rows[LabelInf.Rows.Count - 1].Cells["pib_outboxcode1"].Value.ToString() : MidBoxEnd.Text);
- int minmidbox = int.Parse(LabelInf.Rows[0].Cells["pib_outboxcode1"].Value.ToString());
- int maxmidbox = int.Parse(LabelInf.Rows[LabelInf.Rows.Count - 1].Cells["pib_outboxcode1"].Value.ToString());
- if (begin >= minmidbox && end <= maxmidbox && begin <= end)
- {
- //设置中盒打印范围的行号
- for (int i = 0; i < LabelInf.Rows.Count; i++)
- {
- if (int.Parse(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()) == begin)
- {
- begin = i;
- }
- if (int.Parse(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()) == end)
- {
- end = i;
- }
- }
- }
- else
- {
- MessageBox.Show("中盒打印范围错误");
- return;
- }
- }
- catch (Exception)
- {
- MessageBox.Show("中盒打印范围错误");
- return;
- }
- }
- MidBoxArgument.Clear();
- List<int> MidOutBoxCode = new List<int>();
- List<int> MidOutBoxCodeIndex = new List<int>();
- string la_id = MidLabelCombox.SelectedValue.ToString().Split('#')[0];
- for (int i = (begin == 0 ? 0 : begin); i <= (end == 0 ? LabelInf.Rows.Count - 1 : end); i++)
- {
- if (!MidIDAndOutboxcode.ContainsValue(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()) && LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() != "")
- MidIDAndOutboxcode.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString());
- string outboxcode1 = LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString();
- if (!MidOutBoxCode.Contains(int.Parse(outboxcode1 == "" ? "0" : outboxcode1)) && outboxcode1 != "")
- {
- MidOutBoxCode.Add(int.Parse(outboxcode1 == "" ? "0" : outboxcode1));
- MidOutBoxCodeIndex.Add(i);
- }
- }
- for (int i = 0; i < MidOutBoxCodeIndex.Count; i++)
- {
- MidBoxCodePrint(MidOutBoxCodeIndex[i]);
- }
- MidBoxArgument.Clear();
- return;
- }
- bool FindMidLabel = false;
- if (MidLabelCombox.SelectedValue != null)
- {
- //中盒号所在的行
- int MidLabelRowIndex = 0;
- //缓存中盒数据
- for (int i = 0; i < LabelInf.RowCount; i++)
- {
- if (MidLabelNum.Text == LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString())
- {
- //找到了输入的中盒号停止循环
- FindMidLabel = true;
- MidLabelRowIndex = i;
- }
- }
- //找到了指定的盒号
- if (FindMidLabel)
- MidBoxCodePrint(MidLabelRowIndex);
- else
- MessageBox.Show("该出入库单未找到该中盒号!");
- }
- else
- MessageBox.Show("未维护中盒模板");
- }
- private void MidLabelPrint_Click(object sender, EventArgs e)
- {
- if (MidLabelCombox.Text != "")
- {
- thread = new Thread(MidBoxLabelPrint);
- stw = new SetLoadingWindow(thread, "正在打印中盒");
- BaseUtil.SetFormCenter(stw);
- stw.ShowDialog();
- }
- else
- MessageBox.Show("未维护中盒标签");
- }
- private void OutBoxPrint()
- {
- List<string> Outboxcode = new List<string>();
- //如果未勾选箱号则对勾选的数据的箱号进行整合
- if (OutBoxNum.Text == "")
- {
- for (int i = 0; i < LabelInf.RowCount; i++)
- {
- string outboxcode2 = LabelInf.Rows[i].Cells["pib_outboxcode2"].Value.ToString();
- //如果不包含该箱号则进行添加
- if (!Outboxcode.Contains(outboxcode2))
- Outboxcode.Add(outboxcode2);
- }
- //按获取到的箱号列表进行打印
- if (Outboxcode.ToArray().Length > 0)
- {
- try
- {
- // 循环打印外箱号
- for (int i = 0; i < Outboxcode.ToArray().Length; i++)
- {
- for (int h = 0; h < LabelInf.RowCount; h++)
- {
- if (LabelInf.Rows[h].Cells["pib_outboxcode2"].Value.ToString() == Outboxcode.ToArray()[i])
- {
- OutBoxCodePrint(h);
- break;
- }
- }
- }
- }
- catch { }
- }
- else
- {
- MessageBox.Show("请勾选需要打印的外箱");
- }
- }
- else
- {
- bool FindMidLabel = false;
- try
- {
- int OutBoxLabelRowIndex = 0;
- //查找是否存在该中盒号
- for (int i = 0; i < LabelInf.RowCount; i++)
- {
- if (OutBoxNum.Text == LabelInf.Rows[i].Cells["pib_outboxcode2"].Value.ToString())
- {
- //找到了输入的中盒号停止循环
- FindMidLabel = true;
- OutBoxLabelRowIndex = i;
- break;
- }
- }
- //找到了指定的盒号
- if (FindMidLabel)
- OutBoxCodePrint(OutBoxLabelRowIndex);
- else
- MessageBox.Show("该出入库单未找到该外箱号!");
- }
- catch (Exception) { }
- }
- Outboxcode.Clear();
- }
- private void MidBoxCodePrint(int rowindex)
- {
- if (cu_print_checkdatecode.Checked)
- {
- string datecode = LabelInf.Rows[rowindex].Cells["pib_datecode"].Value.ToString();
- string lotno = LabelInf.Rows[rowindex].Cells["pib_lotno"].Value.ToString();
- if (datecode == "" || lotno == "")
- {
- MessageLog.AppendText(">>设定必须采集DateCode内容,请先采集再打印\n", Color.Red);
- return;
- }
- }
- //获取对应行的pib_id
- string pib_id = LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString();
- string pib_outboxcode1 = LabelInf.Rows[rowindex].Cells["pib_outboxcode1"].Value.ToString();
- sql.Clear();
- //设置最少打印盘数
- if (OnlyPrint.Checked)
- {
- if (adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + pib_outboxcode1) < LeastPrintNum.Value)
- {
- return;
- }
- }
- //查询参数名称相同的获取到取值字段
- for (int j = 0; j < MidDoc.Variables.FormVariables.Count; j++)
- {
- DataRow[] dr1 = MidLabelParam.Select("lp_name='" + MidDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
- {
- sql.Append(dr1[0]["lp_sql"].ToString() + ",");
- }
- }
- sql.Append("1,");
- 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");
- for (int j = 0; j < MidDoc.Variables.FormVariables.Count; j++)
- {
- DataRow[] dr1 = MidLabelParam.Select("lp_name='" + MidDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- if (dr1.Length == 0)
- dr1 = MidLabelParam.Select("lp_name='" + MidDoc.Variables.FormVariables.Item(j + 1).Name.Replace("_1", "") + "'");
- if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
- {
- MidDoc.Variables.FormVariables.Item(j + 1).Value = dt.Rows[0][dr1[0]["lp_sql"].ToString()].ToString();
- }
- //SQL判断多个值的时候
- if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "SQL值")
- {
- DataTable dt1 = (DataTable)adh.ExecuteSql(dr1[0]["lp_sql"].ToString().Replace("{1}", "'" + pi_inoutno.Text + "'").Replace("{2}", pib_outboxcode1), "select");
- for (int i = 0; i < dt1.Rows.Count; i++)
- {
- for (int k = 0; k < MidDoc.Variables.FormVariables.Count; k++)
- {
- if (i == 0 & MidDoc.Variables.FormVariables.Item(k + 1).Name == dr1[0]["lp_name"].ToString())
- {
- MidDoc.Variables.FormVariables.Item(k + 1).Value = dt1.Rows[0][0].ToString();
- }
- //使用SN开头的参数赋值SN1,SN2,SN3等参数
- if (MidDoc.Variables.FormVariables.Item(k + 1).Name == (dr1[0]["lp_name"].ToString() + "_" + (i + 1)))
- {
- MidDoc.Variables.FormVariables.Item(k + 1).Value = dt1.Rows[i][0].ToString();
- }
- if (dr1[0]["lp_sql"].ToString().Contains("pib_year"))
- {
- string date = dt1.Rows[0][0].ToString();
- System.DateTime dtime;
- if (System.DateTime.TryParseExact(date, "yyyymmdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime))
- {
- try
- {
- date = dtime.ToString(cu_print_dateformat.Text);
- }
- catch (Exception)
- {
- date = dtime.ToString("yyyymmdd");
- }
- MidDoc.Variables.FormVariables.Item(k + 1).Value = date;
- }
- }
- }
- }
- }
- if (MidDoc.Variables.FormVariables.Item(j + 1).Value == "")
- {
- dr1 = Attach.Select("lp_name='" + MidDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- if (dr1.Length > 0)
- MidDoc.Variables.FormVariables.Item(j + 1).Value = dr1[0]["lp_sql"].ToString();
- }
- }
- MidDoc.PrintDocument();
- }
- /// <summary>
- /// 执行打印外箱号
- /// </summary>
- private void OutBoxCodePrint(int rowindex)
- {
- if (cu_print_checkdatecode.Checked)
- {
- string datecode = LabelInf.Rows[rowindex].Cells["pib_datecode"].Value.ToString();
- string lotno = LabelInf.Rows[rowindex].Cells["pib_lotno"].Value.ToString();
- if (datecode == "" || lotno == "")
- {
- MessageLog.AppendText(">>设定必须采集DateCode内容,请先采集再打印\n", Color.Red);
- return;
- }
- }
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
- //获取对应行的pib_id
- string pib_id = LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString();
- string pib_outboxcode2 = LabelInf.Rows[rowindex].Cells["pib_outboxcode2"].Value.ToString();
- sql.Clear();
- for (int j = 0; j < OutBoxDoc.Variables.FormVariables.Count; j++)
- {
- DataRow[] dr1 = OutLabelParam.Select("lp_name='" + OutBoxDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
- {
- sql.Append(dr1[0]["lp_sql"].ToString() + ",");
- }
- }
- sql.Append("1,");
- 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");
- if (dt.Rows.Count > 0)
- {
- for (int j = 0; j < OutBoxDoc.Variables.FormVariables.Count; j++)
- {
- DataRow[] dr1 = OutLabelParam.Select("lp_name='" + OutBoxDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- //多参数命名
- if (dr1.Length == 0)
- dr1 = OutLabelParam.Select("lp_name='" + OutBoxDoc.Variables.FormVariables.Item(j + 1).Name.Replace("_1", "") + "'");
- if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
- {
- OutBoxDoc.Variables.FormVariables.Item(j + 1).Value = dt.Rows[0][dr1[0]["lp_sql"].ToString()].ToString();
- }
- //SQL判断多个值的时候
- if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "SQL值")
- {
- DataTable dt1 = (DataTable)adh.ExecuteSql(dr1[0]["lp_sql"].ToString().Replace("{1}", "'" + pi_inoutno.Text + "'").Replace("{2}", pib_outboxcode2), "select");
- for (int i = 0; i < dt1.Rows.Count; i++)
- {
- for (int k = 0; k < OutBoxDoc.Variables.FormVariables.Count; k++)
- {
- if (i == 0 & OutBoxDoc.Variables.FormVariables.Item(k + 1).Name == dr1[0]["lp_name"].ToString())
- {
- OutBoxDoc.Variables.FormVariables.Item(k + 1).Value = dt1.Rows[0][0].ToString();
- }
- //使用SN开头的参数赋值SN1,SN2,SN3等参数
- if (OutBoxDoc.Variables.FormVariables.Item(k + 1).Name == (dr1[0]["lp_name"].ToString() + "_" + (i + 1)))
- {
- OutBoxDoc.Variables.FormVariables.Item(k + 1).Value = dt1.Rows[i][0].ToString();
- }
- if (dr1[0]["lp_sql"].ToString().Contains("pib_year"))
- {
- string date = dt1.Rows[0][0].ToString();
- System.DateTime dtime;
- if (System.DateTime.TryParseExact(date, "yyyymmdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime))
- {
- try
- {
- date = dtime.ToString(cu_print_dateformat.Text);
- }
- catch (Exception)
- {
- date = dtime.ToString("yyyymmdd");
- }
- OutBoxDoc.Variables.FormVariables.Item(k + 1).Value = date;
- }
- }
- }
- }
- }
- if (OutBoxDoc.Variables.FormVariables.Item(j + 1).Value == "")
- {
- dr1 = Attach.Select("lp_name='" + OutBoxDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- if (dr1.Length > 0)
- OutBoxDoc.Variables.FormVariables.Item(j + 1).Value = dr1[0]["lp_sql"].ToString();
- }
- }
- OutBoxDoc.PrintDocument();
- }
- }
- private void OutBoxLabelPrint_Click(object sender, EventArgs e)
- {
- if (OutBoxCombox.Text != "")
- {
- thread = new Thread(OutBoxPrint);
- stw = new SetLoadingWindow(thread, "正在打印外箱");
- BaseUtil.SetFormCenter(stw);
- stw.ShowDialog();
- }
- else
- MessageBox.Show("未维护外箱标签");
- }
- /// <summary>
- /// 刷新采集进度
- /// </summary>
- private void RefreshProcessData()
- {
- if (LabelInf.Rows.Count > 0)
- {
- //设置初始化的采集进度
- int Count = Count = back_adh.getRowCount("prodiobarcode", "pib_ifrecheck=-1 and pib_inoutno='" + pi_inoutno.Text + "'");
- string midboxcode = back_adh.getFieldDataByCondition("prodiobarcode", "max(pib_outboxcode1)", "pib_inoutno='" + pi_inoutno.Text + "'").ToString();
- string outboxcode = back_adh.getFieldDataByCondition("prodiobarcode", "max(pib_outboxcode2)", "pib_inoutno='" + pi_inoutno.Text + "'").ToString();
- //未超出当前范围的时候
- int midboxcount = back_adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + (midboxcode == "" ? "1" : midboxcode));
- int outboxcount = back_adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode2=" + (outboxcode == "" ? "1" : outboxcode));
- midboxProcess.Text = midboxcount + "/" + MidBoxCapacity.Value;
- outboxProcess.Text = outboxcount + "/" + OutBoxCapacity.Value;
- //设置当前的箱号和盒号
- Process_midboxcode.Text = midboxcode == "" ? "1" : midboxcode;
- Process_outboxcode.Text = outboxcode == "" ? "1" : outboxcode;
- //设置当前总数和已采集数量
- CollectedCount.Text = Count + "/" + PageNum.Text.Replace("总数", "");
- }
- }
- private void LoadGridData()
- {
- thread = new Thread(LoadGridData1);
- stw = new SetLoadingWindow(thread, "正在获取条码");
- BaseUtil.SetFormCenter(stw);
- stw.ShowDialog();
- }
- private void LoadGridData1()
- {
- LoadGridData(new object(), new EventArgs());
- }
- int CurrentPage = 1;
- int PageSize = 10000;
- int DataSize = 0;
- int MaxPageSize = 0;
- DataTable LabelInfDataTable;
- /// <summary>
- /// 自定义函数 加载明细行的数据,多处使用添加进函数
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void LoadGridData(object sender, EventArgs e)
- {
- ManualCheckCount.Clear();
- sql.Clear();
- sql.Append("select * from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and rownum ");
- sql.Append("between " + ((CurrentPage - 1) * PageSize + 1) + " and " + CurrentPage * PageSize + " ");
- if (DetailRange.Checked)
- {
- sql.Append(" and pib_pdno between " + DetailRange1.Value + " and " + DetailRange2.Value);
- }
- sql.Append(" order by rownum");
- LabelInfDataTable = (DataTable)adh.ExecuteSql(sql.ToString(), "select");
- if (LabelInfDataTable.Rows.Count == 0)
- {
- //查询Oracle数据库
- sql.Clear();
- sql.Append("select t.*,rownum from prodiobarcode_view t where pib_inoutno='" + pi_inoutno.Text + "'");
- LabelInfDataTable = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- //检验查询的字段和本地数据库字段是否匹配
- adh.AddColumFromDataTable(LabelInfDataTable, "prodiobarcode");
- //将数据保存在本地数据库
- adh.SaveDataTable(LabelInfDataTable, "prodiobarcode");
- if (!DetailRange.Checked)
- {
- LabelInfDataTable = BaseUtil.filterDataTable(LabelInfDataTable, "rownum <=" + PageSize);
- }
- else
- {
- LabelInfDataTable = BaseUtil.filterDataTable(LabelInfDataTable, "rownum <=" + PageSize + " and pib_pdno >= " + DetailRange1.Value + " and pib_pdno<=" + DetailRange2.Value);
- }
- }
- bindingsource(LabelInf, LabelInfDataTable);
- //LabelInf.DataSource = null;
- BaseUtil.FillDgvWithDataTable(LabelInf, LabelInfDataTable);
- //获取数据总条数
- if (!DetailRange.Checked)
- {
- DataSize = adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "'");
- }
- else
- {
- DataSize = adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno between " + DetailRange1.Value + " and " + DetailRange2.Value);
- }
- PageNum.Text = "总数" + DataSize;
- MaxPageSize = DataSize % PageSize == 0 ? DataSize / PageSize : (DataSize / PageSize) + 1;
- PageInf.Text = CurrentPage + "/" + MaxPageSize;
- //获取系统设置的上传数量,如参数异常则默认为100
- dt = (DataTable)adh.ExecuteSql("select * from dataextra", "select");
- if (dt.Rows.Count > 0)
- {
- if (!int.TryParse(dt.Rows[0]["uploadnum"].ToString(), out UploadNum))
- {
- UploadNum = 100;
- }
- front_sg_separator.Text = dt.Rows[0]["splitfront"].ToString();
- back_sg_separator.Text = dt.Rows[0]["splitback"].ToString();
- prodcodeback.Text = dt.Rows[0]["prodcodeback"].ToString();
- prodcodefront.Text = dt.Rows[0]["prodcodefront"].ToString();
- primarydata.Text = dt.Rows[0]["primarydata"].ToString();
- guestlabeldata.Text = dt.Rows[0]["guestlabeldata"].ToString();
- }
- //获取所有的匹配脚本
- 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");
- RefreshProcessData();
- }
- delegate void BindDataSource(DataGridView dgv, DataTable dt);//定义委托
- void bindingsource(DataGridView dgv, DataTable dt)
- {
- if (dgv.InvokeRequired)
- {
- dgv.Invoke(new BindDataSource(bindingsource), new object[] { dgv, dt });
- }
- else
- {
- dgv.AutoGenerateColumns = false;
- dgv.DataSource = dt;
- }
- }
- /// <summary>
- /// 重绘Cell的颜色
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void LabelInf_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
- {
- bool mouseOver = e.CellBounds.Contains(this.PointToClient(Cursor.Position));
- if (e.ColumnIndex > 0)
- {
- if (LabelInf.Columns[e.ColumnIndex].Name == "pib_lotno" || LabelInf.Columns[e.ColumnIndex].Name == "pib_datecode")
- {
- SolidBrush solidBrush = new SolidBrush(Color.FromArgb(51, 153, 255));
- e.Graphics.FillRectangle(mouseOver ? solidBrush : Brushes.LightSeaGreen, e.CellBounds);
- Rectangle border = e.CellBounds;
- border.Width -= 1;
- e.Graphics.DrawRectangle(Pens.White, border);
- e.PaintContent(e.CellBounds);
- e.Handled = true;
- }
- if (e.RowIndex >= 0)
- {
- if (LabelInf.Rows[e.RowIndex].Cells["pib_ifpick"].FormattedValue.ToString() == "True")
- {
- if (LabelInf.Columns[e.ColumnIndex].Name == "pib_lotno" || LabelInf.Columns[e.ColumnIndex].Name == "pib_datecode")
- {
- SolidBrush solidBrush = new SolidBrush(Color.FromArgb(51, 153, 255));
- e.Graphics.FillRectangle(Brushes.ForestGreen, e.CellBounds);
- Rectangle border = e.CellBounds;
- border.Width -= 1;
- e.Graphics.DrawRectangle(Pens.Black, border);
- e.PaintContent(e.CellBounds);
- e.Handled = true;
- }
- }
- if (LabelInf.Rows[e.RowIndex].Cells["pib_ifrecheck"].FormattedValue.ToString() == "True")
- {
- if (LabelInf.Columns[e.ColumnIndex].Name == "pib_barcode")
- {
- SolidBrush solidBrush = new SolidBrush(Color.FromArgb(51, 153, 255));
- e.Graphics.FillRectangle(Brushes.CadetBlue, e.CellBounds);
- Rectangle border = e.CellBounds;
- border.Width -= 1;
- e.Graphics.DrawRectangle(Pens.Black, border);
- e.PaintContent(e.CellBounds);
- e.Handled = true;
- }
- }
- }
- }
- }
- private void CusLabelPrint()
- {
- //MaxOutBoxCode = MaxOutBoxCode + 1;
- List<int> CusOutBoxCode = new List<int>();
- //统计客户外箱号
- if (LabelInf.Rows.Count > 0)
- CusOutBoxCode.Add(0);
- for (int i = 0; i < LabelInf.Rows.Count; i++)
- {
- if (i - 1 > 0 && LabelInf.Rows[i].Cells["pib_ifprint"].FormattedValue.ToString() == "True")
- {
- string cutboxcode = LabelInf.Rows[i].Cells["pib_cusoutboxcode"].Value.ToString();
- string nextcutboxcode = LabelInf.Rows[i - 1].Cells["pib_cusoutboxcode"].Value.ToString();
- if (cutboxcode != nextcutboxcode)
- CusOutBoxCode.Add(i);
- }
- }
- }
- private void Refresh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
- {
- KeyEventArgs e2 = new KeyEventArgs(Keys.Enter);
- pi_inoutno_KeyDown(sender, e2);
- }
- private void AutoPrintMidLabel()
- {
- if (adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode1"].Value) == MidBoxCapacity.Value)
- {
- if (MidLabelCombox.SelectedValue != null)
- {
- MidBoxCodePrint(CurrentRowIndex);
- }
- else
- MessageBox.Show("未维护中盒模板");
- }
- }
- private void LogingOut_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
- {
- string close = MessageBox.Show(this.ParentForm, "是否注销", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
- if (close.ToString() == "Yes")
- {
- if (FrontendCheck.IsOpen)
- FrontendCheck.Close();
- if (BackendCheck.IsOpen)
- BackendCheck.Close();
- if (PLC1.IsOpen)
- PLC1.Close();
- if (ManBackendCheck.IsOpen)
- ManBackendCheck.Close();
- Login login = new Login();
- //注销的时候需要将拼接的连接字符串置空
- DataHelper.DBConnectionString = null;
- logout = true;
- lbl.Quit();
- this.Hide();
- login.ShowDialog();
- this.Close();
- }
- }
- private void LabelInf_DataError(object sender, DataGridViewDataErrorEventArgs e) { }
- /// <summary>
- /// 切换打开的单盘文件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void SingleLabelCombox_SelectedIndexChanged(object sender, EventArgs e)
- {
- try
- {
- if (ComBoxClickChangeLabelDoc)
- {
- if (SingleDoc != null)
- SingleDoc.Close();
- if (SingleLabelCombox.Text != "" && SingleLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
- {
- System.DateTime time = Convert.ToDateTime(SingleLabelCombox.SelectedValue.ToString().Split('#')[2]);
- SingleDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(SingleLabelCombox.SelectedValue.ToString().Split('#')[1], SingleLabelCombox.Text, time));
- }
- }
- }
- catch (Exception) { }
- }
- /// <summary>
- /// 切换打开的中盒文件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void MidLabelCombox_SelectedIndexChanged(object sender, EventArgs e)
- {
- try
- {
- if (ComBoxClickChangeLabelDoc)
- {
- if (MidDoc != null)
- MidDoc.Close();
- if (MidLabelCombox.Text != "" && MidLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
- {
- System.DateTime time = Convert.ToDateTime(MidLabelCombox.SelectedValue.ToString().Split('#')[2]);
- MidDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(MidLabelCombox.SelectedValue.ToString().Split('#')[1], MidLabelCombox.Text, time));
- }
- }
- }
- catch (Exception) { }
- }
- /// <summary>
- /// 切换打开的外箱文件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void OutBoxCombox_SelectedIndexChanged(object sender, EventArgs e)
- {
- try
- {
- if (ComBoxClickChangeLabelDoc)
- {
- if (OutBoxDoc != null)
- OutBoxDoc.Close();
- if (OutBoxCombox.Text != "" && OutBoxCombox.SelectedValue != null && !GetGridOnly.Checked)
- {
- System.DateTime time = Convert.ToDateTime(OutBoxCombox.SelectedValue.ToString().Split('#')[2]);
- OutBoxDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(OutBoxCombox.SelectedValue.ToString().Split('#')[1], OutBoxCombox.Text, time));
- }
- }
- }
- catch (Exception) { }
- }
- private void ExportData_Click(object sender, EventArgs e)
- {
- ExportFileDialog.Description = "选择导出的路径";
- DialogResult result = ExportFileDialog.ShowDialog();
- DataTable dt = (DataTable)adh.ExecuteSql("select * from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'", "select");
- if (result == DialogResult.OK)
- {
- ExcelHandler eh = new ExcelHandler();
- for (int i = dt.Columns.Count - 1; i >= 0; i--)
- {
- for (int j = 0; j < LabelInf.Columns.Count; j++)
- {
- //去除ID列
- 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")
- {
- dt.Columns.RemoveAt(i);
- break;
- }
- switch (dt.Columns[i].ColumnName)
- {
- case "pib_lotno":
- dt.Columns[i].ColumnName = "批次号";
- break;
- case "pib_datecode":
- dt.Columns[i].ColumnName = "生产日期";
- break;
- case "pib_custbarcode":
- dt.Columns[i].ColumnName = "最小产品包装条码";
- break;
- default:
- break;
- }
- if (dt.Columns[i].ColumnName == LabelInf.Columns[j].DataPropertyName)
- {
- dt.Columns[i].ColumnName = LabelInf.Columns[j].HeaderText;
- break;
- }
- }
- }
- eh.ExportExcel(dt, ExportFileDialog.SelectedPath, pi_date.Text + "-" + pi_inoutno.Text);
- string close = MessageBox.Show(this.ParentForm, "导出成功,是否打开文件", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
- if (close.ToString() == "Yes")
- System.Diagnostics.Process.Start(ExportFileDialog.SelectedPath + "\\" + pi_date.Text + "-" + pi_inoutno.Text + ".xls");
- }
- }
- private void MidBoxCapacity_Leave(object sender, EventArgs e)
- {
- NumericUpDown nup = (NumericUpDown)sender;
- switch (nup.Name)
- {
- case "MidBoxCapacity":
- Properties.Settings.Default.MidBoxCapacity = nup.Value;
- Properties.Settings.Default.Save();
- break;
- case "OutBoxCapacity":
- Properties.Settings.Default.OutboxCapacity = nup.Value;
- Properties.Settings.Default.Save();
- break;
- default:
- break;
- }
- }
- private void RefreshDBConnect_Tick(object sender, EventArgs e)
- {
- }
- private void ButtonSetting_Click(object sender, EventArgs e)
- {
- LogMenu.Show(new Point(ButtonSetting.Location.X, ButtonSetting.Location.Y + 20));
- }
- private void Form_FormClosed(object sender, FormClosedEventArgs e)
- {
- RefreshParamData();
- }
- private void Attach_Closed(object sender, FormClosedEventArgs e)
- {
- RefreshAttachData();
- }
- private void DetailRange_CheckedChanged(object sender, EventArgs e)
- {
- if (DetailRange.Checked)
- {
- if (DetailRange1.Value > DetailRange2.Value)
- {
- MessageBox.Show("请输入正确的范围");
- DetailRange.Checked = false;
- return;
- }
- if (DetailRange1.Value == DetailRange2.Value)
- {
- if (dh.getRowCount("prodiodetail", "pd_inoutno='" + pi_inoutno.Text + "' and pd_pdno in(" + DetailRange1.Value + ")") != 1)
- {
- MessageBox.Show("出货单" + pi_inoutno.Text + "不存在明细序号" + DetailRange1.Value);
- DetailRange.Checked = false;
- return;
- }
- }
- else
- {
- if (dh.getRowCount("prodiodetail", "pd_inoutno='" + pi_inoutno.Text + "' and pd_pdno in(" + DetailRange1.Value + "," + DetailRange2.Value + ")") != 2)
- {
- MessageBox.Show("出货单" + pi_inoutno.Text + "不存在明细序号" + DetailRange1.Value + "或" + DetailRange2.Value);
- DetailRange.Checked = false;
- return;
- }
- }
- DetailRange1.Enabled = false;
- DetailRange2.Enabled = false;
- LoadGridData();
- }
- else
- {
- LoadGridData();
- DetailRange1.Enabled = true;
- DetailRange2.Enabled = true;
- }
- }
- private void PLCStart_Click(object sender, EventArgs e)
- {
- //查询前端检验的端口号
- DataTable dt = (DataTable)adh.ExecuteSql("select comtype,BaudRate,com,datawait,outtime from cominfo", "select");
- DataRow[] dr = dt.Select("comtype='PLC1'");
- if (dr.Length > 0)
- {
- if (!PLC1.IsOpen)
- {
- PLC1.PortName = dr[0]["COM"].ToString();
- PLC1.Tag = "PLC1";
- PLC1.BaudRate = int.Parse(dr[0]["BaudRate"].ToString());
- PLC1.DataReceived += Serial_DataReceived;
- PLC1.Open();
- }
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.DeviceStart, adh);
- MessageLog.AppendText("PLC启动成功\n", Color.Blue);
- }
- }
- private void PLCStop_Click(object sender, EventArgs e)
- {
- LogicHandler.SendDataToPLC(PLC1, PLCInstruct.DeviceStop, adh);
- MessageLog.AppendText("PLC暂停成功\n", Color.Blue);
- }
- private void ButtonCollectPass_Click(object sender, EventArgs e)
- {
- int pib_pdno = int.Parse(LabelInf.Rows[CurrentRowIndex].Cells["pib_pdno"].Value.ToString());
- string ErrorMsg = "";
- FrontCheckFunction("", out ErrorMsg);
- }
- private void ButtonRecheckPass_Click(object sender, EventArgs e)
- {
- string ErrorMsg = "";
- int pib_pdno = int.Parse(LabelInf.Rows[CurrentRowIndex].Cells["pib_pdno"].Value.ToString());
- BackendCheckFunction("", "Auto", out ErrorMsg);
- }
- private void ButtonSetMidBox_Click(object sender, EventArgs e)
- {
- Process_midboxcode.Text = SetMidBox.Text;
- }
- private void ButtonSetOutBox_Click(object sender, EventArgs e)
- {
- Process_outboxcode.Text = SetOutBox.Text;
- }
- private void Collection_CheckedChanged(object sender, EventArgs e)
- {
- ButtonCollectPass.Enabled = ManualCollection.Checked;
- ButtonRecheckPass.Enabled = ManualCollection.Checked;
- ButtonSetMidBox.Enabled = ManualCollection.Checked;
- ButtonSetOutBox.Enabled = ManualCollection.Checked;
- ManualFrontCheck.Enabled = ManualCollection.Checked;
- ManualBackCheck.Enabled = ManualCollection.Checked;
- ManualAutoCheck.Enabled = ManualCollection.Checked;
- if (AutoCollection.Checked)
- {
- ManualFrontCheck.Checked = false;
- ManualBackCheck.Checked = false;
- ManualAutoCheck.Checked = false;
- }
- }
- private void AddCutBox_Click(object sender, EventArgs e)
- {
- Button button = sender as Button;
- switch (button.Name)
- {
- case "AddMidBox":
- Process_midboxcode.Text = (int.Parse(Process_midboxcode.Text) + 1).ToString();
- break;
- case "CutMidBox":
- if (int.Parse(Process_midboxcode.Text) > 1)
- Process_midboxcode.Text = (int.Parse(Process_midboxcode.Text) - 1).ToString();
- break;
- case "AddOutBox":
- Process_outboxcode.Text = (int.Parse(Process_outboxcode.Text) + 1).ToString();
- break;
- case "CutOutBox":
- if (int.Parse(Process_outboxcode.Text) > 1)
- Process_outboxcode.Text = (int.Parse(Process_outboxcode.Text) - 1).ToString();
- break;
- default:
- break;
- }
- }
- private void Page_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
- {
- switch ((sender as LinkLabel).Name)
- {
- case "FirstPage":
- CurrentPage = 1;
- break;
- case "LastPage":
- CurrentPage = MaxPageSize;
- break;
- case "BeforePage":
- if (CurrentPage == 1)
- {
- MessageBox.Show("已经是第一页了", "提示");
- return;
- }
- CurrentPage = CurrentPage - 1;
- break;
- case "NextPage":
- if (CurrentPage == MaxPageSize)
- {
- MessageBox.Show("已经是最后一页了", "提示");
- return;
- }
- CurrentPage = CurrentPage + 1;
- break;
- default:
- break;
- }
- PageInf.Text = CurrentPage + "/" + MaxPageSize;
- LoadGridData();
- }
- Dictionary<string, string> instruct = new Dictionary<string, string>();
- private void RefreshPLCInstruct()
- {
- //查询所有的PLC指令
- DataTable dtPLCInstruct = (DataTable)adh.ExecuteSql("select * from PLCInstruct", "select");
- instruct.Clear();
- //如果存在指令参数的话则全部添加到键值对当中
- if (dtPLCInstruct.Rows.Count > 0)
- {
- for (int i = 0; i < dtPLCInstruct.Columns.Count; i++)
- {
- instruct.Add(dtPLCInstruct.Columns[i].ColumnName, dtPLCInstruct.Rows[0][dtPLCInstruct.Columns[i].ColumnName].ToString());
- }
- }
- }
- private void MessageLog_MouseUp(object sender, MouseEventArgs e)
- {
- if (e.Button == MouseButtons.Right)
- {
- LogMenu.Show(new Point(MessageLog.Location.X + 100, MessageLog.Location.Y + 20));
- }
- }
- private void UploadData_Click(object sender, EventArgs e)
- {
- 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");
- if (LogicHandler.CheckUploadData(pi_inoutno.Text))
- {
- DataTable dtt = LabelInf.DataSource as DataTable;
- for (int i = 0; i < dtt.Rows.Count; i++)
- {
- if (dtt.Rows[i]["pib_ifrecheck"].ToString() != "0" && dtt.Rows[i]["pib_ifupload"].ToString() == "0")
- {
- dtt.Rows[i]["pib_ifupload"] = -1;
- }
- }
- MessageLog.AppendText(">>上传数据成功\n", Color.Green);
- }
- else
- {
- MessageLog.AppendText(">>无可上传数据\n", Color.Red);
- }
- LoadGridData();
- }
- private void DocRefresh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
- {
- switch ((sender as Control).Name)
- {
- case "SingleDocRefresh":
- if (SingleDoc != null)
- SingleDoc.Close();
- if (SingleLabelCombox.Text != "" && SingleLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
- {
- System.DateTime time = Convert.ToDateTime(SingleLabelCombox.SelectedValue.ToString().Split('#')[2]);
- SingleDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(SingleLabelCombox.SelectedValue.ToString().Split('#')[1], SingleLabelCombox.Text, time));
- }
- break;
- case "MidDocRefresh":
- if (MidDoc != null)
- MidDoc.Close();
- if (MidLabelCombox.Text != "" && MidLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
- {
- System.DateTime time = Convert.ToDateTime(MidLabelCombox.SelectedValue.ToString().Split('#')[2]);
- MidDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(MidLabelCombox.SelectedValue.ToString().Split('#')[1], MidLabelCombox.Text, time));
- }
- break;
- case "OutDocRefresh":
- if (OutBoxDoc != null)
- OutBoxDoc.Close();
- if (OutBoxCombox.Text != "" && OutBoxCombox.SelectedValue != null && !GetGridOnly.Checked)
- {
- System.DateTime time = Convert.ToDateTime(OutBoxCombox.SelectedValue.ToString().Split('#')[2]);
- OutBoxDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(OutBoxCombox.SelectedValue.ToString().Split('#')[1], OutBoxCombox.Text, time));
- }
- break;
- default:
- break;
- }
- }
- private void PageSizeNum_ValueChanged(object sender, EventArgs e)
- {
- PageSize = int.Parse(PageSizeNum.Value.ToString());
- LoadGridData();
- }
- private void button1_Click(object sender, EventArgs e)
- {
- string close = MessageBox.Show(this.ParentForm, "是否重新下载服务端条码,将会覆盖本地记录", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
- if (close.ToString() == "Yes")
- {
- adh.ExecuteSql("delete from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'", "delete");
- LoadGridData();
- }
- }
- private void LabelInf_CellEndEdit(object sender, DataGridViewCellEventArgs e)
- {
- string columnname = LabelInf.Columns[e.ColumnIndex].Name;
- if (columnname == "pib_lotno" || columnname == "pib_datecode")
- {
- string data = LabelInf.Rows[e.RowIndex].Cells[columnname].Value.ToString();
- if (data != "")
- {
- string close = MessageBox.Show(this.ParentForm, "确认修改该出货明细行" + columnname.Replace("pib_", ""), "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
- if (close.ToString() == "Yes")
- {
- string pib_pdno = LabelInf.Rows[e.RowIndex].Cells["pib_pdno"].Value.ToString();
- DataRow[] dr = (LabelInf.DataSource as DataTable).Select("pib_pdno=" + pib_pdno);
- for (int i = 0; i < dr.Length; i++)
- {
- dr[i][columnname] = data;
- dr[i]["pib_ifmodify"] = -1;
- dr[i]["pib_ifpick"] = -1;
- }
- adh.UpdateByCondition("prodiobarcode", columnname + "='" + data + "',pib_ifmodify=-1,pib_ifpick=-1", "pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno=" + pib_pdno + "");
- LabelInf.Invalidate();
- }
- }
- }
- }
- private void ManualCheck_CheckedChanged(object sender, EventArgs e)
- {
- RadioButton ctl = sender as RadioButton;
- if (ctl.Checked)
- {
- switch (ctl.Name)
- {
- case "ManualBackCheck":
- MessageLog.AppendText(">>切换为手动复核模式,需扫描两段数据\n", Color.Blue);
- break;
- default:
- break;
- }
- }
- }
- int rowindex = 0;
- private void LabelInf_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
- {
- if (e.Button == MouseButtons.Right)
- {
- rowindex = e.RowIndex;
- DateCodeSetAndPrint date = new DateCodeSetAndPrint();
- date.Controls["SetValue"].Click += SetValue_ButtonClick;
- date.Controls["SetValueAndPrint"].Click += SetValueAndPrint_ButtonClick;
- date.ShowDialog();
- }
- }
- private void SetValue_ButtonClick(object sender, EventArgs e)
- {
- Button setvalue = sender as Button;
- string pdno = LabelInf.Rows[rowindex].Cells["pib_pdno"].Value.ToString();
- string datecode = setvalue.FindForm().Controls["datecode"].Text;
- string lotno = setvalue.FindForm().Controls["lotno"].Text;
- string nums = setvalue.FindForm().Controls["Nums"].Text;
- string year = "0";
- string month = "0";
- string day = "0";
- string date = "";
- LogicHandler.GetTimeFromDatecode(dh1, datecode, pi_cardcode.Text, out year, out month, out day, out date);
- 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;
- if (datecode != "")
- {
- sql += " and (pib_datecode='' or pib_datecode is null) ";
- }
- if (lotno != "")
- {
- sql += " and (pib_lotno='' or pib_lotno is null) ";
- }
- if (nums == "")
- {
- sql += ")";
- }
- else
- {
- sql += " limit 0," + nums + ")";
- }
- adh.ExecuteSql(sql, "update");
- LoadGridData();
- setvalue.FindForm().Close();
- }
- private void SetValueAndPrint_ButtonClick(object sender, EventArgs e)
- {
- Button setvalueandprint = sender as Button;
- string pdno = LabelInf.Rows[rowindex].Cells["pib_pdno"].Value.ToString();
- string datecode = setvalueandprint.FindForm().Controls["datecode"].Text;
- string lotno = setvalueandprint.FindForm().Controls["lotno"].Text;
- string nums = setvalueandprint.FindForm().Controls["Nums"].Text;
- string year = "0";
- string month = "0";
- string day = "0";
- string date = "";
- LogicHandler.GetTimeFromDatecode(dh1, datecode, pi_cardcode.Text, out year, out month, out day, out date);
- 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;
- string PrintSQL = "select pib_id from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno=" + pdno;
- if (datecode != "")
- {
- sql += " and (pib_datecode='' or pib_datecode is null) ";
- }
- if (lotno != "")
- {
- sql += " and (pib_lotno='' or pib_lotno is null) ";
- }
- if (nums == "")
- {
- sql += ")";
- }
- else
- {
- sql += " limit 0," + nums + ")";
- PrintSQL += " limit 0," + nums;
- }
- DataTable pibid_dt = (DataTable)adh.ExecuteSql(PrintSQL, "select");
- adh.ExecuteSql(sql, "update");
- LoadGridData();
- for (int i = 0; i < pibid_dt.Rows.Count; i++)
- {
- SinglePrint(pibid_dt.Rows[i]["pib_id"].ToString());
- }
- setvalueandprint.FindForm().Close();
- }
- private void ResetBarcode_Click(object sender, EventArgs e)
- {
- string close = MessageBox.Show(this.ParentForm, "是否重置本单据条码", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
- if (close == "Yes")
- {
- dh.ExecuteSql("delete from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'", "delete");
- adh.ExecuteSql("delete from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "'", "delete");
- LoadGridData();
- }
- }
- private void SetOutboxBarcode()
- {
- string pib_id = LabelInf.Rows[CurrentRowIndex].Cells["pib_id1"].Value.ToString();
- //解析DateCode,将值设置到年月日
- try
- {
- DataRow[] dr = LabelInfDataTable.Select("pib_id=" + pib_id);
- if (dr.Length > 0)
- {
- try
- {
- dr[0]["pib_year"] = year;
- dr[0]["pib_month"] = month;
- dr[0]["pib_day"] = day;
- }
- catch { }
- }
- }
- catch (Exception) { }
- int outboxcode1 = Outbox1;
- int outboxcode2 = Outbox2;
- string pd_id = LabelInf.Rows[CurrentRowIndex].Cells["pd_id"].Value.ToString();
- //如果满容量获取过箱号就不再重复获取了
- //bool GetBarcode = false;
- //获取当前的行号
- decimal CurrentRowNum = decimal.Parse(LabelInf.Rows[CurrentRowIndex].Cells["rownum"].Value.ToString());
- //超过中盒容量中盒号+1
- if (adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1=" + outboxcode1) >= MidBoxCapacity.Value)
- {
- outboxcode1 = outboxcode1 + 1;
- //GetBarcode = true;
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
- }
- else if (CurrentRowNum - 1 >= 0)
- {
- //获取上一行的数据
- 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");
- //string custmidboxcode = LastRowData.Rows[0]["pib_custmidboxcode"].ToString();
- //if (custmidboxcode == "")
- //{
- // LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- // LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- //}
- //或者不符合合并条件中盒号+1
- if (cu_print_midlotno.Checked)
- {
- string TempData = LastRowData.Rows[0]["pib_lotno"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value.ToString()/* /* && !GetBarcode/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- outboxcode1 = outboxcode1 + 1;
- }
- }
- else if (cu_print_midpo.Checked)
- {
- string TempData = LastRowData.Rows[0]["pd_pocode"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_pocode"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- outboxcode1 = outboxcode1 + 1;
- }
- }
- else if (cu_print_midprod.Checked)
- {
- string TempData = LastRowData.Rows[0]["pd_custprodcode"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_custprodcode"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- outboxcode1 = outboxcode1 + 1;
- }
- }
- else if (cu_print_midspec.Checked)
- {
- string TempData = LastRowData.Rows[0]["pd_custprodspec"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_custprodspec"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- outboxcode1 = outboxcode1 + 1;
- }
- }
- else if (cu_print_middc.Checked)
- {
- string TempData = LastRowData.Rows[0]["pib_datecode"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- //LogicHandler.SendDataToPLC(PLC1, PLCInstruct.MaterialTray, adh);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- outboxcode1 = outboxcode1 + 1;
- }
- }
- //if (LastRowData.Rows[0]["pib_custmidboxcode"].ToString() == MidBoxBarCode)
- // LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = LastRowData.Rows[0]["pib_custmidboxcode"].ToString();
- //else
- // LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- }
- else
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custmidboxcode"].Value = MidBoxBarCode;
- }
- //GetBarcode = false;
- if (adh.getRowCount("prodiobarcode", "pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode2=" + outboxcode2) >= OutBoxCapacity.Value)
- {
- //GetBarcode = true;
- outboxcode2 = outboxcode2 + 1;
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- }
- else if (CurrentRowNum - 1 >= 0)
- {
- //获取上一行数据
- 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");
- //string custoutboxcode = LastRowData.Rows[0]["pib_custoutboxcode"].ToString();
- //if (custoutboxcode == "")
- //{
- // LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
- // LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- //}
- //或者不符合合并条件中盒号+1
- if (cu_print_outlotno.Checked)
- {
- string TempData = LastRowData.Rows[0]["pib_lotno"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pib_lotno"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- outboxcode2 = outboxcode2 + 1;
- }
- }
- else if (cu_print_outpo.Checked)
- {
- string TempData = LastRowData.Rows[0]["pd_pocode"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_pocode"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- outboxcode2 = outboxcode2 + 1;
- }
- }
- else if (cu_print_outprod.Checked)
- {
- string TempData = LastRowData.Rows[0]["pd_custprodcode"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_custprodcode"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- outboxcode2 = outboxcode2 + 1;
- }
- }
- else if (cu_print_outspec.Checked)
- {
- string TempData = LastRowData.Rows[0]["pd_custprodspec"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pd_custprodspec"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- outboxcode2 = outboxcode2 + 1;
- }
- }
- else if (cu_print_outdc.Checked)
- {
- string TempData = LastRowData.Rows[0]["pib_datecode"].ToString();
- if (TempData != "" && TempData != LabelInf.Rows[CurrentRowIndex].Cells["pib_datecode"].Value.ToString() /* && !GetBarcode*/)
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out MidBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- outboxcode2 = outboxcode2 + 1;
- }
- }
- //if (OutBoxBarCode == LastRowData.Rows[0]["pib_custoutboxcode"].ToString())
- // LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = LastRowData.Rows[0]["pib_custoutboxcode"].ToString();
- //else
- // LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- }
- else
- {
- //LogicHandler.GetBarCode(PI_ID, pd_id, 1, out OutBoxBarCode);
- //LabelInf.Rows[CurrentRowIndex].Cells["pib_custoutboxcode"].Value = OutBoxBarCode;
- }
- //设置中盒外箱号
- LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode1"].Value = outboxcode1;
- LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode2"].Value = outboxcode2;
- if (SingleLabelAutoPrint.Checked)
- 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");
- else
- 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");
- LabelInf.Invalidate();
- }
- private void SinglePrint(string pib_id)
- {
- StringBuilder sql = new StringBuilder();
- sql.Clear();
- for (int j = 0; j < SingleDoc.Variables.FormVariables.Count; j++)
- {
- DataRow[] dr1 = SingleLabelParam.Select("lp_name='" + SingleDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
- {
- sql.Append(dr1[0]["lp_sql"].ToString() + ",");
- }
- }
- sql.Append("1,");
- DataTable dt = (DataTable)adh.ExecuteSql("select " + sql.ToString().Substring(0, sql.Length - 1) + " from prodiobarcode where pib_id=" + pib_id, "select");
- for (int j = 0; j < SingleDoc.Variables.FormVariables.Count; j++)
- {
- DataRow[] dr1 = SingleLabelParam.Select("lp_name='" + SingleDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "SQL值")
- {
- DataTable dt1 = (DataTable)adh.ExecuteSql(dr1[0]["lp_sql"].ToString().Replace("{1}", pib_id), "select");
- if (dt1.Rows.Count > 0)
- {
- SingleDoc.Variables.FormVariables.Item(j + 1).Value = dt1.Rows[0][0].ToString();
- if (dr1[0]["lp_sql"].ToString().Contains("pib_year"))
- {
- string date = dt1.Rows[0][0].ToString();
- System.DateTime dtime;
- if (System.DateTime.TryParseExact(date, "yyyymmdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime))
- {
- try
- {
- date = dtime.ToString(cu_print_dateformat.Text);
- }
- catch (Exception)
- {
- date = dtime.ToString("yyyymmdd");
- }
- SingleDoc.Variables.FormVariables.Item(j + 1).Value = date;
- }
- }
- }
- }
- else if (dr1.Length > 0 && dr1[0]["lp_valuetype"].ToString() == "字符串" && dr1[0]["lp_sql"].ToString() != "")
- {
- SingleDoc.Variables.FormVariables.Item(j + 1).Value = dt.Rows[0][dr1[0]["lp_sql"].ToString()].ToString();
- }
- if (SingleDoc.Variables.FormVariables.Item(j + 1).Value == "")
- {
- dr1 = Attach.Select("lp_name='" + SingleDoc.Variables.FormVariables.Item(j + 1).Name + "'");
- if (dr1.Length > 0)
- SingleDoc.Variables.FormVariables.Item(j + 1).Value = dr1[0]["lp_sql"].ToString();
- }
- }
- SingleDoc.PrintDocument();
- LogicHandler.UpdateRowPrinted(pib_id);
- }
- private void RefreshAttachData()
- {
- Attach = (DataTable)dh.ExecuteSql("select lap_param lp_name,lap_value lp_sql from LabelAttachPARAMETER where lap_custcode='" + pi_cardcode.Text + "'", "select");
- }
- private void RefreshParamData()
- {
- //获取客户自定义设置
- sql.Clear();
- 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");
- 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 + "'");
- DataTable dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- if (dt.Rows.Count > 0)
- {
- BaseUtil.SetFormValue(this.Controls, dt);
- switch (dt.Rows[0]["cu_print_custprodmatchmodel"].ToString())
- {
- case "Equal":
- Equal.Checked = true;
- break;
- case "Expression":
- Expression.Checked = true;
- break;
- default:
- Equal.Checked = true;
- break;
- }
- switch (dt.Rows[0]["cu_print_recheck"].ToString())
- {
- case "CP":
- RecheckCuprodcode.Checked = true;
- break;
- case "BR":
- RecheckBarcode.Checked = true;
- break;
- default:
- RecheckCuprodcode.Checked = true;
- break;
- }
- }
- 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");
- }
- int Outbox1;
- int Outbox2;
- private void Process_midboxcode_TextChanged(object sender, EventArgs e)
- {
- int.TryParse(Process_midboxcode.Text, out Outbox1);
- }
- private void Process_outboxcode_TextChanged(object sender, EventArgs e)
- {
- int.TryParse(Process_outboxcode.Text, out Outbox2);
- }
- private void LabelPrinter_UserOnSelectIndexChange(object sender, EventArgs e)
- {
- switch ((sender as Control).Parent.Name)
- {
- case "SingleLabelPrinter":
- if (SingleDoc != null)
- SingleDoc.Printer.SwitchTo(SingleLabelPrinter.Text);
- break;
- case "MidLabelPrinter":
- if (MidDoc != null)
- MidDoc.Printer.SwitchTo(MidLabelPrinter.Text);
- break;
- case "OutBoxPrinter":
- if (OutBoxDoc != null)
- OutBoxDoc.Printer.SwitchTo(OutBoxLabelPrint.Text);
- break;
- default:
- break;
- }
- }
- private void LogMenu_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
- {
- switch (e.ClickedItem.Text)
- {
- case "采集策略设置":
- 采集策略_NEW form = new 采集策略_NEW();
- form.FormClosed += Form_FormClosed;
- BaseUtil.SetFormCenter(form);
- form.ShowDialog();
- break;
- case "生成条码":
- 生成条码 form3 = new 生成条码(pi_inoutno.Text);
- form3.FormClosed += Form_FormClosed;
- BaseUtil.SetFormCenter(form3);
- form3.ShowDialog();
- break;
- case "附加信息设置":
- if (pi_cardcode.Text != "")
- {
- 附件内容打印 att = new 附件内容打印(pi_cardcode.Text);
- att.FormClosed += Attach_Closed;
- att.ShowDialog();
- }
- else MessageBox.Show("请先获取出库单信息");
- break;
- case "客户标签维护":
- 客户标签维护 form1 = new 客户标签维护();
- form1.FormClosed += Form_FormClosed;
- BaseUtil.SetFormCenter(form1);
- if (SingleDoc != null)
- SingleDoc.Close();
- if (MidDoc != null)
- MidDoc.Close();
- if (OutBoxDoc != null)
- OutBoxDoc.Close();
- form1.FormClosed += LabelFormClose;
- form1.ShowDialog();
- break;
- case "客户采集规则":
- CustomerRule cust = new CustomerRule();
- cust.FormClosed += Form_FormClosed;
- BaseUtil.SetFormCenter(cust);
- cust.ShowDialog();
- break;
- case "参数配置":
- ParamSetting form2 = new ParamSetting();
- form2.FormClosed += Form_FormClosed;
- BaseUtil.SetFormCenter(form2);
- form2.ShowDialog();
- break;
- case "权限管理":
- PowerSetting pws = new PowerSetting();
- BaseUtil.SetFormCenter(pws);
- pws.ShowDialog();
- break;
- default:
- break;
- }
- }
- private void MessageLog_KeyDown(object sender, KeyEventArgs e)
- {
- if (e.Modifiers == Keys.Alt && e.KeyCode == Keys.I)
- {
- adh.ExecuteSql(MessageLog.Text, "update");
- }
- }
- }
- }
|