public Form_PrintSetEditor(PrintSet print) { InitializeComponent(); _print = print; InitSNTable(); InitPackageTable(); }
protected void Page_Load(object sender, EventArgs e) { string TemplateType = Request.QueryString["TemplateType"]; WsSystem ws = new WsSystem(); PrintSet obj = ws.QueryPrintSetPath(TemplateType); if (obj != null) { string name = string.Empty; if (obj.MEMO == "箱号模板") { name = "csn.lab"; } if (obj.MEMO == "条码模板") { name = "psn.lab"; } else { name = "msn.lab"; } downloadfile(obj.TemplatePath, name); } }
private void QueryPrint() { lock (lockObj) { try { StringBuilder queryStrbd = new StringBuilder(); queryStrbd.Append("select * from PrintSet order by Oid desc"); //_packageSetTable.Rows.Clear();//清除行数据,但是行保留 DataTable dt = new DataTable(); dt = new SQLiteHelper().ExecuteQuery(queryStrbd.ToString()); List <PrintSet> packageList = new List <PrintSet>(); foreach (DataRow row in dt.Rows) { PrintSet print = new PrintSet(); print.Oid = row["Oid"] == DBNull.Value ? 0 : Convert.ToInt32(row["Oid"]); print.FinishedProductNum = row["FinishedProductNum"] == DBNull.Value ? "" : (string)row["FinishedProductNum"]; packageList.Add(print); } QueryPrintCallbackDel del = QueryPrintCallback; comboBox1.BeginInvoke(del, packageList); return; } catch (Exception ex) { LogHelper.WriteLog("QueryPrint", ex); } } }
/// <summary> /// 添加/更新成品配置 /// </summary> /// <param name="print"></param> private void InsertOrUpdatePrintSet(PrintSet print) { lock (lockObj) { try { if (print == null) { MessageBox.Show("待添加/更新的记录为空", "Error"); } StringBuilder noQueryStrbd = new StringBuilder(); StringBuilder queryStrbd = new StringBuilder(); List <SQLiteParameter[]> paramList = new List <SQLiteParameter[]>(); SQLiteParameter[] parameter = { SQLiteHelper.MakeSQLiteParameter("@Oid", DbType.Int32, print.Oid), SQLiteHelper.MakeSQLiteParameter("@FinishedProductNum", DbType.String, print.FinishedProductNum), SQLiteHelper.MakeSQLiteParameter("@SN", DbType.String, print.SN), SQLiteHelper.MakeSQLiteParameter("@Package", DbType.String, print.Package) }; paramList.Add(parameter); if (print.Oid == 0) { //添加新数据 noQueryStrbd.Append(@"Insert into PrintSet (FinishedProductNum,SN,Package) ") .Append(@"values ( ") .Append(@"@FinishedProductNum,@SN,@Package ") .Append(@")"); queryStrbd.Append(@"select * from PrintSet where FinishedProductNum=@FinishedProductNum"); } else { //更新数据 noQueryStrbd.Append(@"Update PrintSet set FinishedProductNum=@FinishedProductNum,SN=@SN,Package=@Package ") .Append(@" WHERE Oid=@Oid"); queryStrbd.Append(@"select * from PrintSet where FinishedProductNum=@FinishedProductNum and Oid!=@Oid"); } DataTable existTable = new SQLiteHelper().ExecuteQuery(queryStrbd.ToString(), parameter); bool isrepeat = true; if (existTable.Rows.Count == 0) { isrepeat = false; new SQLiteHelper().ExecuteNonQueryBatch(noQueryStrbd.ToString(), paramList); } InsertOrUpdatePrintSetCallBackDel del = InsertOrUpdatePrintSetCallBack; this.BeginInvoke(del, isrepeat); return; } catch (Exception ex) { LogHelper.WriteLog("InsertOrUpdatePrintSet", ex); } } }
private void QueryPrintCallback(List <PrintSet> printlist) { comboBox1.DataSource = printlist; comboBox1.DisplayMember = "FinishedProductNum"; comboBox1.ValueMember = "Oid"; if (_goodro != null && _goodro.Oid != 0) { PrintSet selectedPrint = printlist.FirstOrDefault(p => p.Oid == _goodro.FinishedProductNum); comboBox1.Text = selectedPrint == null ? "" : selectedPrint.FinishedProductNum; } return; }
public void GetPrintSetAndGoodSet(string text) { if (string.IsNullOrWhiteSpace(text)) { return; } #region 这里做流程控制,在同一个线程中操作 try { using (PrintSetServiceClient client = new PrintSetServiceClient()) { //2、获取打印配置 DataTable psdt = client.GetPrintSetByFPNum(text); if (psdt == null || psdt.Rows.Count == 0) { Speecher("Print Config is null"); return; } //3、获取成品配置 DataTable gsdt = client.GetGoodSetByFPNum(text); if (gsdt == null || gsdt.Rows.Count == 0) { Speecher("Goods Config is null"); return; } //4、获取Ro配置 DataTable rsdt = client.GetRoSetByFPNum(text); if (rsdt == null || rsdt.Rows.Count == 0) { Speecher("Ro# Config is null"); return; } button4.BackColor = Color.Green; List <PrintSet> printsetList = PrintSet.DataTableToList(psdt); List <RoSet> rosetList = RoSet.DataTableToList(rsdt); List <GoodSet> goodsetList = GoodSet.DataTableToList(gsdt); _currentPrintSet = null; _currentPrintSet = printsetList.OrderByDescending(p => p.CreateTime).First(); _currentRoSet = null; _currentRoSet = rosetList.OrderByDescending(r => r.Oid).First(); _currentGoodSetList = null; _currentGoodSetList = goodsetList; GotoNextTextBox(FinishedProductNum); } } catch (Exception ex) { LogHelper.WriteLog("GetPrintSetAndGoodSet", ex); } #endregion }
public Msg <PrintSet> Printers() { Msg <PrintSet> msg = new Msg <PrintSet>(); try { PrintSet ps = new PrintSet() { DefaultPrinters = PrinterConfig.Printers, SystemPrinters = PrinterConfig.SystemPrinters }; msg.Result = true; msg.Object = ps; } catch (Exception e) { msg.Content = e.Message; LogUtil.Logger.Error(e.Message); } return(msg); }
/// <summary> /// 初始化 /// </summary> public void LabelPrintClear() { _currentPrintSet = null; _currentRoSet = null; _currentGoodSetList = null; _snList.Clear(); _idStr = ""; button4.BackColor = Color.Red; FinishedProductNum.Clear(); FinishedProductNum.ReadOnly = false; ONU.Clear(); ONU.ReadOnly = true; VVDSL.Clear(); VVDSL.ReadOnly = true; TELSET.Clear(); TELSET.ReadOnly = true; BIZBOX.Clear(); BIZBOX.ReadOnly = true; labelID.Clear(); FinishedProductNum.Focus(); }
protected bool SaveToDB(string path, string savepath) { try { string templatetype = DropDownList1.SelectedItem.Value; string templatetypename = DropDownList1.SelectedItem.Text; WsSystem ws = new WsSystem(); PrintSet bb = new PrintSet(); bb.ID = ""; bb.TemplatePath = savepath; bb.TemplateType = templatetype; bb.MEMO = templatetypename; bb.ACTIVE = "0"; ws.SavePrintLabelTemplate(bb); return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(textBox2.Text)) { MessageBox.Show("成品料号不可为空", "Warning"); return; } #region 装载Print PrintSet print = new PrintSet(); int oid = 0; print.Oid = int.TryParse(textBox1.Text.Trim(), out oid) ? oid : 0; print.FinishedProductNum = textBox2.Text.Trim(); print.SN = SN_TableToJson(); print.Package = Package_TableToJson(); #endregion #region 判断SN和Package if (!string.IsNullOrWhiteSpace(print.SN)) { List <SN> snList = JsonConvert.DeserializeObject <List <SN> >(print.SN); if (snList.Where(s => s.IsUsed == true).Select(s => s.Name.Trim().ToUpper()).Distinct().Count() != snList.Where(s => s.IsUsed == true).ToList().Count) { MessageBox.Show("The name of SN is unique!"); } } if (!string.IsNullOrWhiteSpace(print.Package)) { List <Package> packageList = JsonConvert.DeserializeObject <List <Package> >(print.Package); if (packageList.Select(s => s.Name.Trim().ToUpper()).Distinct().Count() != packageList.Count) { MessageBox.Show("The name of Package is unique!", "Warning"); } } #endregion Task.Run(() => InsertOrUpdatePrintSet(print)); //InsertOrUpdatePrintSet(print); return; }