| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598 |
- using LabelManager2;
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Diagnostics;
- using System.Drawing;
- using System.Threading;
- using System.Windows.Forms;
- using UAS_MES_NEW.DataOperate;
- using UAS_MES_NEW.Entity;
- using UAS_MES_NEW.PublicForm;
- using UAS_MES_NEW.PublicMethod;
- namespace UAS_MES_NEW.Make
- {
- public partial class Make_TestCollectionqrcode2 : Form
- {
- DataHelper dh = null;
- DataTable dt = null;
- //当前工序的名称
- string ErrorMessage = "";
- //用于保存是否之前输入的ms_sncode
- string LastSncode;
- string oMakeCode = "";
- string oMSID = "";
- string ifrework = "";
- string reworkstatus = "";
- LogStringBuilder sql = new LogStringBuilder();
- AutoSizeFormClass asc = new AutoSizeFormClass();
- /// <summary>
- /// 已选的不良
- /// </summary>
- List<string> ChoosedList = new List<string>();
- /// <summary>
- /// 待选的不良
- /// </summary>
- List<string> WaitList = new List<string>();
- bool AutoCut = false;
- bool LockSn = false;
- DataTable Dbfind;
- Thread InitPrint;
- ApplicationClass lbl;
- public BarTender.Application engine;
- public Make_TestCollectionqrcode2()
- {
- InitializeComponent();
- }
- private void TestCollection_Load(object sender, EventArgs e)
- {
- GoodProduct.Checked = true;
- asc.controllInitializeSize(this);
- ms_sncode.Focus();
- Process[] processes = System.Diagnostics.Process.GetProcessesByName("lppa");
- Process[] processes1 = System.Diagnostics.Process.GetProcessesByName("bartend");
- for (int i = 0; i < processes1.Length; i++)
- {
- processes1[i].Kill();
- }
- for (int i = 0; i < processes.Length; i++)
- {
- processes[i].Kill();
- }
- InitPrint = new Thread(InPrint);
- SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
- BaseUtil.SetFormCenter(stw);
- stw.ShowDialog();
- //设置锁定工单
- LockMakeCode.GetMakeCodeCtl(ma_code);
- ma_code.SetLockCheckBox(LockMakeCode);
- ControlLockTimer.Tick += ControlLockTimer_Tick;
- ControlLockTimer.Interval = 100;
- //lockCheckBox1.GetMakeCodeCtl(US_ID);
- //US_ID.SetLockCheckBox(lockCheckBox1);
- //US_ID.TableName = "upcsku";
- //US_ID.SelectField = "US_ID # ID,US_PRODUCTCOLOR # PRODUCT_COLOR,US_COLORCODE # 颜色号,US_SKU # SKU,US_UPC # UPC,US_LOCATION # 出货地";
- //US_ID.FormName = Name;
- //US_ID.SetValueField = new string[] { "US_ID","US_SKU", "US_PRODUCTCOLOR", "US_COLORCODE", "US_UPC","US_LOCATION" };
- //US_ID.Condition = "1=1";
- //US_ID.DbChange += US_SKU_DbChange;
- //工单号放大镜配置
- ma_code.TableName = "make left join product on ma_prodcode=pr_code";
- ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_spec # 产品规格,ma_softversion # 软件版本,ma_appversion # APP版本,ma_rom # ROM ,ma_ram # RAM,ma_salecode # 销售单号,pr_sendchecktype # 产品送检方式";
- ma_code.FormName = Name;
- ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_spec", "ma_softversion", "ma_appversion", "ma_rom", "ma_ram", "ma_salecode", "nvl(pr_sendchecktype,'LineCode')pr_sendchecktype" };
- ma_code.Condition = "ma_statuscode='STARTED'";
- ma_code.DbChange += Ma_code_DbChange;
- dh = SystemInf.dh;
- StepCount.StepCode = User.CurrentStepCode;
- StepCount.Source = User.UserSourceCode;
- StepCount.LineCode = User.UserLineCode;
- StepCount.Dh = dh;
- StepCount.Start();
- }
- private void US_SKU_DbChange(object sender, EventArgs e)
- {
- //Dbfind = US_ID.ReturnData;
- //BaseUtil.SetFormValue(this.Controls, Dbfind);
- }
- private void InPrint()
- {
- try
- {
- engine = new BarTender.Application();
- lbl = new ApplicationClass();
- BaseUtil.WriteLbl();
- }
- catch (Exception ex)
- {
- OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
- }
- }
- private void ControlLockTimer_Tick(object sender, EventArgs e)
- {
- this.Activate();
- ms_sncode.Focus();
- }
- private void Ma_code_DbChange(object sender, EventArgs e)
- {
- Dbfind = ma_code.ReturnData;
- BaseUtil.SetFormValue(this.Controls, Dbfind);
- LoadCollectedNum();
- }
- private void CleanInfo_Click(object sender, EventArgs e)
- {
- OperateResult.Clear();
- }
- private void ms_code_KeyDown(object sender, KeyEventArgs e)
- {
- if (e.KeyCode == Keys.Enter)
- {
- string softversion = "";
- string othid = "";
- string appver = "";
- string rom = "";
- string ram = "";
- string mac = "";
- string bt = "";
- string listmac = "";
- string listbt = "";
- try
- {
- String[] message = ms_sncode.Text.Split(';');
- if (getframeid.Checked)
- {
- if (message.Length != 8)
- {
- OperateResult.AppendText(">>需要采集相框ID,采集二维码解析出" + message.Length + "个数据,不符合要求\n", Color.Red, ms_sncode);
- return;
- }
- ms_sncode.Text = message[0];
- bt = message[2];
- mac = message[1];
- softversion = message[3];
- othid = message[4];
- appver = message[5];
- rom = message[6];
- ram = message[7];
- }
- else
- {
- if (message.Length != 7)
- {
- OperateResult.AppendText(">>不需要采集相框ID,采集二维码解析出" + message.Length + "个数据,不符合要求\n", Color.Red, ms_sncode);
- return;
- }
- ms_sncode.Text = message[0];
- bt = message[2];
- mac = message[1];
- softversion = message[3];
- //othid = message[4];
- appver = message[4];
- rom = message[5];
- ram = message[6];
- }
- DataGridViewRow row = new DataGridViewRow();
- row.CreateCells(LabelDataGridView);
- row.Cells[0].Value = ms_sncode.Text;
- row.Cells[3].Value = softversion;
- row.Cells[4].Value = othid;
- row.Cells[5].Value = appver;
- row.Cells[6].Value = rom;
- row.Cells[2].Value = mac;
- row.Cells[1].Value = bt;
- row.Cells[7].Value = ram;
- LabelDataGridView.Rows.Insert(0, row);
- //int index = LabelDataGridView.Rows.Add();
- //LabelDataGridView.Rows[index].Cells["SN"].Value = ms_sncode.Text;
- //LabelDataGridView.Rows[index].Cells["softversion"].Value = softversion;
- //LabelDataGridView.Rows[index].Cells["xkid"].Value = othid;
- //LabelDataGridView.Rows[index].Cells["mmi1"].Value = mmi1;
- //LabelDataGridView.Rows[index].Cells["mmi2"].Value = mmi2;
- //LabelDataGridView.Rows[index].Cells["wifis"].Value = mac;
- //LabelDataGridView.Rows[index].Cells["bts"].Value = bt;
- //LabelDataGridView.Rows[index].Cells["opentime"].Value = opentime;
- }
- catch (Exception ex)
- {
- OperateResult.AppendText(">>" + ex.Message + "\n", Color.Red, ms_sncode);
- return;
- }
- WaitList.Clear();
- ChoosedList.Clear();
- if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
- {
- bool NoteAlready = LogicHandler.CheckDiffMakeCodeBeforeStepCheck(ms_sncode.Text, ma_code.Text, NoteForChange.Checked, out oMakeCode, out ErrorMessage);
- if (!NoteAlready)
- {
- OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
- return;
- }
- if (LogicHandler.CheckStepSNAndMacode(oMakeCode, User.UserSourceCode, ms_sncode.Text, User.UserCode, out oMakeCode, out oMSID, out ErrorMessage))
- {
- //是否提示过工单切换框,检测前后执行
- if (!LogicHandler.CheckDiffMakeCodeAfterStepCheck(ms_sncode.Text, oMakeCode, NoteForChange.Checked, NoteAlready, ma_code, out ErrorMessage))
- {
- OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
- return;
- }
- if (ma_code.Text != oMakeCode && oMakeCode != null)
- {
- dt = (DataTable)dh.ExecuteSql("select ma_code,ma_prodcode,ma_softversion,ma_salecode,pr_spec,nvl(pr_sendchecktype,'LineCode')pr_sendchecktype,ma_qty,ma_appversion,ma_rom,ma_ram from make left join product on ma_prodcode=pr_code where ma_code='" + oMakeCode + "'", "select");
- if (dt.Rows.Count > 0)
- {
- BaseUtil.SetFormValue(this.Controls, dt);
- LockMakeCode.Checked = true;
- }
- }
- dt = (DataTable)dh.ExecuteSql("select ms_nextstepcode,ms_sncode,ms_reworkstatus,nvl(ms_ifrework,0)ms_ifrework,ms_stepcode,ms_status,nvl(ms_netcode,' ') ms_netcode,nvl(st_ifrepair,0) st_ifrepair from makeserial left join step on ms_stepcode=st_code where ms_id='" + oMSID + "'", "select");
- string status = dt.Rows[0]["ms_status"].ToString();
- reworkstatus = dt.Rows[0]["ms_reworkstatus"].ToString();
- string stepcode = dt.Rows[0]["ms_stepcode"].ToString();
- string ifrepair = dt.Rows[0]["st_ifrepair"].ToString();
- string sncode = dt.Rows[0]["ms_sncode"].ToString();
- string ms_netcode = dt.Rows[0]["ms_netcode"].ToString();
- string ms_nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
- //if (ms_netcode != " " && dh.CheckExist("makeserial", "ms_netcode = '" + ms_netcode + "' and ms_sncode <>'" + ms_sncode.Text + "'"))
- //{
- // string othersn = dh.getFieldDataByCondition("makeserial", "ms_sncode", "ms_netcode = '" + ms_netcode + "' and ms_sncode <>'" + ms_sncode.Text + "'").ToString();
- // OperateResult.AppendText(">>" + ms_sncode.Text + "对应wifibox:"+ms_netcode+"已被SN:"+othersn+"使用\n", Color.Red, ms_sncode);
- // return;
- //}
- if (sncode != ms_sncode.Text)
- {
- OperateResult.AppendText(">>" + ms_sncode.Text + " 序列号已执行过转号,不允许使用TSN采集\n", Color.Red, ms_sncode);
- return;
- }
- ifrework = dt.Rows[0]["ms_ifrework"].ToString();
- //string softversioncheck = dh.GetConfig("softversion", "sys").ToString();
- if (softversion != ma_softversion.Text)
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "对应软件版本:" + softversion + "与工单维护软件版本:" + ma_softversion.Text + "不一致\n", Color.Red);
- return;
- }
- if (appver != ma_appversion.Text)
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "对应APP版本:" + appver + "与工单维护APP版本:" + ma_appversion.Text + "不一致\n", Color.Red);
- return;
- }
- if (rom != ma_rom.Text)
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "对应ROM:" + rom + "与工单维护ROM:" + ma_rom.Text + "不一致\n", Color.Red);
- return;
- }
- if (ram != ma_ram.Text)
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "对应RAM:" + ram + "与工单维护RAM:" + ma_ram.Text + "不一致\n", Color.Red);
- return;
- }
- //if (!mmi1.Contains("PASS") || !mmi2.Contains("PASS"))
- //{
- // OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "未通过MMI测试\n", Color.Red);
- // return;
- //}
- //if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_length = -1 ") && mmi1.Contains("UNKNOWN"))
- //{
- // OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " MMI1信息异常\n", Color.Red);
- // return;
- //}
- //if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_width = -1 ") && mmi2.Contains("UNKNOWN"))
- //{
- // OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " MMI2信息异常\n", Color.Red);
- // return;
- //}
- if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_volume = -1 ") && bt.Contains("UNKNOWN"))
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " BT信息异常\n", Color.Red);
- return;
- }
- if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_height = -1 ") && mac.Contains("UNKNOWN"))
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " WIFI信息异常\n", Color.Red);
- return;
- }
- if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_palletheight = -1 ") && othid.Contains("UNKNOWN"))
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " 相框ID信息异常\n", Color.Red);
- return;
- }
- listmac = dh.getFieldDataByCondition("makesnlist", "msl_mac", "msl_sncode ='" + ms_sncode.Text + "' and msl_makecode = '" + ma_code.Text + "'").ToString();
- if (listmac != "" && listmac != mac.ToUpper())
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " 导入WIFI为:" + listmac + ",与二维码mac:" + mac + "不一致\n", Color.Red);
- return;
- }
- listbt = dh.getFieldDataByCondition("makesnlist", "msl_bt", "msl_sncode ='" + ms_sncode.Text + "' and msl_makecode = '" + ma_code.Text + "'").ToString();
- if (listbt != "" && listbt != bt.ToUpper())
- {
- OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " 导入BT为:" + listbt + ",与二维码BT:" + bt + "不一致\n", Color.Red);
- return;
- }
- dh.ExecuteSql("update makeserial set MS_SOFTVERSION = '" + softversion + "',ms_othid1 = '" + othid + "'," +
- "ms_mac = '" + mac + "',ms_bt = '" + bt + "',ms_appver = '" + appver + "' where ms_sncode = '" + ms_sncode.Text + "' and ms_makecode = '" + ma_code.Text + "'", "update");
- //if (US_SKU.Text != "")
- //{
- // dh.ExecuteSql("update makeserial set ms_sku = '" + US_SKU.Text + "' where ms_sncode = '" + ms_sncode.Text + "' and ms_makecode = '" + ma_code.Text + "'", "update");
- //}
- //if (US_UPC.Text != "")
- //{
- // dh.ExecuteSql("update makeserial set ms_upc = '" + US_UPC.Text + "' where ms_sncode = '" + ms_sncode.Text + "' and ms_makecode = '" + ma_code.Text + "'", "update");
- //}
- //if (US_LOCATION.Text != "")
- //{
- // dh.ExecuteSql("update makeserial set MS_location = '" + US_LOCATION.Text + "' where ms_sncode = '" + ms_sncode.Text + "' and ms_makecode = '" + ma_code.Text + "'", "update");
- //}
- if (autoprint.Checked)
- {
- if (PrintLabel.Text.ToUpper().Contains(".BTW"))
- {
- if (Print.SinglePrint(Tag.ToString(), engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, ms_sncode.Text, int.Parse(PrintNum.Text), oMakeCode, ma_prodcode.Text, "机身标", "0", out ErrorMessage))
- {
- //提示用户打印成功
- OperateResult.AppendText(">>序列号:" + ms_sncode.Text + "打印成功\n", Color.Green);
- }
- else
- {
- OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
- }
- }
- else
- {
- if (Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, ms_sncode.Text, int.Parse(PrintNum.Text), oMakeCode, ma_prodcode.Text, "机身标", "0", out ErrorMessage))
- {
- //提示用户打印成功
- OperateResult.AppendText(">>序列号:" + ms_sncode.Text + "打印成功\n", Color.Green);
- }
- else
- {
- OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
- }
- }
- }
- SetCollectResult();
- }
- else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
- }
- else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
- }
- }
- /// <summary>
- /// 设置良品或者不良品的采集结果
- /// </summary>
- private void SetCollectResult()
- {
- string ErrorMessage = "";
- //如果勾选的是不良品
- if (Reject.Checked)
- {
- OperateResult.AppendText(">>请采集不良代码\n", Color.Green);
- //勾选了自动产生代码
- if (AutoBadCode.Checked)
- Save_Click(new object(), new EventArgs());
- }
- else if (GoodProduct.Checked)
- {
- //如果不是返修的
- if (ifrework == "0")
- {
- dt = (DataTable)dh.ExecuteSql("select mb_id,bc_name,mbr_mbid from makebad left join makebadreason on mbr_mbid=mb_id left join badcode on mb_badcode=bc_code where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and mb_status=0", "select");
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- if (dt.Rows[i]["mb_id"].ToString() != dt.Rows[i]["mbr_mbid"].ToString())
- ErrorMessage += "【" + dt.Rows[i]["bc_name"].ToString() + "】";
- }
- //存在不良记录
- if (ErrorMessage != "")
- {
- OperateResult.AppendText(">>序列号:" + ms_sncode.Text + " 已经判为不良品,不允许修改!\n", Color.Red);
- return;
- }
- else
- {
- //良品信息采集
- if (LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, ms_sncode.Text, "良品采集", "检测合格", User.UserCode, out ErrorMessage))
- {
- //提示正确返回时传递的信息
- if (ErrorMessage.Contains("AFTERSUCCESS"))
- OperateResult.AppendText(">>" + ErrorMessage + "\n");
- LastSncode = ms_sncode.Text;
- OperateResult.AppendText(">>" + ms_sncode.Text + "良品采集成功\n", Color.Green, ms_sncode);
- //记录操作日志
- LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集良品", "采集良品成功", LastSncode, ob_checkno.Text);
- }
- else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
- }
- }
- else
- {
- if (reworkstatus != "3")
- {
- if (LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, ms_sncode.Text, "良品采集", "检测合格", User.UserCode, out ErrorMessage))
- {
- //提示正确返回时传递的信息
- if (ErrorMessage.Contains("AFTERSUCCESS"))
- OperateResult.AppendText(">>" + ErrorMessage + "\n");
- LastSncode = ms_sncode.Text;
- OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为良品\n", Color.Green, ms_sncode);
- //记录操作日志
- LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集良品", "采集良品成功", LastSncode, ob_checkno.Text);
- }
- else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
- }
- else
- {
- OperateResult.AppendText(">>返修的不良序列号必须先进行维修\n", Color.Red);
- }
- }
- }
- //加载页面信息
- LoadCollectedNum();
- }
- private void 测试采集_SizeChanged(object sender, EventArgs e)
- {
- asc.controlAutoSize(this);
- }
- private void LoadCollectedNum()
- {
- dt = (DataTable)dh.ExecuteSql("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty from make left join makecraftdetail on mcd_macode=ma_code where ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'", "select");
- BaseUtil.SetFormValue(Controls, dt);
- }
- private void Save_Click(object sender, EventArgs e)
- {
- if (ms_sncode.Text == "")
- {
- OperateResult.AppendText(">>序列号不允许为空\n", Color.Red);
- return;
- }
- if (GoodProduct.Checked)
- ms_code_KeyDown(sender, new KeyEventArgs(Keys.Enter));
- }
- private void GoodProduct_CheckedChanged(object sender, EventArgs e)
- {
- if (GoodProduct.Checked)
- {
- Save.Visible = false;
- }
- else
- {
- Save.Visible = true;
- }
- if (ms_sncode.Text == "")
- {
- ms_sncode.Focus();
- }
- }
- /// <summary>
- /// 工单变化修改数量
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void ma_code_UserControlTextChanged(object sender, EventArgs e)
- {
- if (ma_code.Text.Length > 4)
- {
- BaseUtil.CleanControlsText(mcd_inqty, mcd_remainqty, ob_nowcheckqty);
- LoadCollectedNum();
- //LoadCheckQTY();
- }
- }
- private void Make_TestCollection_FormClosing(object sender, FormClosingEventArgs e)
- {
- BaseUtil.ClosePrint(lbl);
- if (engine != null)
- engine.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges);
- dh.Dispose();
- }
- private void ma_prodcode_TextChanged(object sender, EventArgs e)
- {
- DataTable dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode='" + ma_prodcode.Text + "' and la_templatetype='机身标' and la_statuscode='AUDITED' order by la_isdefault", "select");
- if (dt.Rows.Count == 0)
- {
- return;
- }
- PrintLabel.DataSource = dt;
- PrintLabel.DisplayMember = "la_url";
- PrintLabel.ValueMember = "la_id";
- }
- private void Make_TestCollection_KeyDown(object sender, KeyEventArgs e)
- {
- if (e.Modifiers == Keys.Control && e.KeyCode == Keys.Q)
- {
- if (!LockSn)
- {
- ControlLockTimer.Start();
- LockSn = true;
- Lock_label.Visible = true;
- }
- else
- {
- ControlLockTimer.Stop();
- LockSn = false;
- Lock_label.Visible = false;
- }
- }
- }
- private void button1_Click(object sender, EventArgs e)
- {
- }
- }
- }
|