• c# .net6 在线条码打印基于

    条码打印基于:BarTender、ORM EF架构

    UI展示：

    主页代码：

    1. using NPOI.OpenXmlFormats.Spreadsheet;
    2. using ServerSide.Models;
    3. using System;
    4. using System.Collections.Generic;
    5. using System.ComponentModel;
    6. using System.Data;
    7. using System.Drawing;
    8. using System.Linq;
    9. using System.Text;
    10. using System.Threading.Tasks;
    11. using System.Windows.Forms;
    12.  
    13. namespace PlantProcessControlSystem.BarCodePrint
    14. {
    15.     //tss_nowdate
    16.     public partial class Main_BarCodePrint_Frm : Form
    17.     {
    18.         private System.Windows.Forms.Timer timer;
    19.         //1.声明自适应类实例  
    20.         private AutoSizeFormClass asc = null;
    21.         private AutoSetControlSize ass = null;
    22.  
    23.         public Main_BarCodePrint_Frm()
    24.         {
    25.             InitializeComponent();
    26.             ass = new AutoSetControlSize(this, this.Width, this.Height);
    27.         }
    28.  
    29.         #region 窗体控件事件
    30.         private void btn_Close_Click(object sender, EventArgs e)
    31.         {
    32.             if (((Button)sender).Name == "btn_Close")//窗体关闭
    33.             {
    34.                 //DialogResult result = MessageBox.Show("是否确认退出??","提醒",MessageBoxButtons.YesNo,MessageBoxIcon.Warning);
    35.                 //if (result == DialogResult.Yes)
    36.                 //    Application.Exit();
    37.                 //else
    38.                 //    return;
    39.                 //this.Hide();//隐藏
    40.                 //tlrm_Show.Enabled = true;//控件可使用
    41.                 Environment.Exit(0);
    42.                 //Application.Exit();
    43.             }
    44.             else if (((Button)sender).Name == "btn_WinMinSize")//窗体最小化
    45.             {
    46.                 this.WindowState = FormWindowState.Minimized;
    47.             }
    48.             else if (((Button)sender).Name == "btn_WinMaxSize")//窗体最大化
    49.             {
    50.                 if (this.WindowState == FormWindowState.Normal)
    51.                     this.WindowState = FormWindowState.Maximized;
    52.                 else
    53.                     this.WindowState = FormWindowState.Normal;
    54.             }
    55.         }
    56.         #endregion
    57.  
    58.         #region 时间同步
    59.         private void Timer_Tick(object sender, EventArgs e)
    60.         {
    61.             tss_nowdate.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
    62.         }
    63.         #endregion
    64.  
    65.         #region 窗体加载
    66.         private void Main_BarCodePrint_Frm_Load(object sender, EventArgs e)
    67.         {
    68.             timer = new System.Windows.Forms.Timer();
    69.             timer.Interval = 1000;
    70.             timer.Tick += Timer_Tick;
    71.             timer.Enabled = true;
    72.         }
    73.         #endregion
    74.  
    75.         #region 窗体移动
    76.         private Point mouseOff;//鼠标移动位置变量
    77.         private bool leftFlag;//标签是否为左键
    78.  
    79.         private void Frm_MouseDown(object sender, MouseEventArgs e)
    80.         {
    81.             if (e.Button == MouseButtons.Left)
    82.             {
    83.                 mouseOff = new Point(-e.X, -e.Y); //得到变量的值
    84.                 leftFlag = true;                  //点击左键按下时标注为true;
    85.             }
    86.         }
    87.  
    88.         private void Frm_MouseMove(object sender, MouseEventArgs e)
    89.         {
    90.             if (leftFlag)
    91.             {
    92.                 Point mouseSet = Control.MousePosition;
    93.                 mouseSet.Offset(mouseOff.X, mouseOff.Y);  //设置移动后的位置
    94.                 Location = mouseSet;
    95.             }
    96.         }
    97.  
    98.         private void Frm_MouseUp(object sender, MouseEventArgs e)
    99.         {
    100.             if (leftFlag)
    101.             {
    102.                 leftFlag = false;//释放鼠标后标注为false;
    103.             }
    104.         }
    105.         #endregion
    106.  
    107.         #region 移动鼠标
    108.         private void MainFrm_Move(object sender, EventArgs e)
    109.         {
    110.             // 获取当前鼠标的坐标
    111.             Point cursorPosition = Cursor.Position;
    112.             TS_X.Text = cursorPosition.X.ToString();
    113.             TS_Y.Text = cursorPosition.Y.ToString();
    114.             tss_State.Text = "当前状态:操作";
    115.         }
    116.         #endregion
    117.  
    118.         #region 装载窗体
    119.         /// 
    120.         /// 装载窗体
    121.         /// 
    122.         /// 
    123.         private void OpenForm(Form childFrom)
    124.         {
    125.             //首先判断容器中是否有其他的窗体
    126.             foreach (Control item in this.Panel_Winfrm.Controls)
    127.             {
    128.                 if (item is Form)
    129.                 {
    130.                     ((Form)item).Close();
    131.                 }
    132.             }
    133.             //嵌入新的窗体
    134.             childFrom.TopLevel = false;//将子窗体设置成非顶级控件
    135.             // childFrom.FormBorderStyle = FormBorderStyle.None;//去掉窗体边框（目前不需要了）
    136.             childFrom.Parent = this.Panel_Winfrm;//设置窗体的容器
    137.             childFrom.Dock = DockStyle.Fill;//随着容器大小自动调整窗体大小（目前可能没有效果）
    138.             childFrom.Show();
    139.         }
    140.         #endregion
    141.  
    142.         #region 窗体自适应
    143.         private void MainFrm_SizeChanged(object sender, EventArgs e)
    144.         {
    145.             asc = new AutoSizeFormClass(this);
    146.             asc.controlAutoSize(this);
    147.         }
    148.  
    149.         private void MainFrm_Resize(object sender, EventArgs e)
    150.         {
    151.             ass.setControls((this.Width) / ass.X, (this.Height) / ass.Y, this);
    152.         }
    153.         #endregion
    154.  
    155.         #region 树形菜单单击事件
    156.         private void treeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
    157.         {
    158.             if (e.Node.Text == "配置.客户信息")
    159.             {
    160.                 CfgClientInfoFrm cfgClientInfoFrm = new CfgClientInfoFrm();
    161.                 this.OpenForm(cfgClientInfoFrm);
    162.             }
    163.             else if (e.Node.Text == "配置.产品信息")
    164.             {
    165.                 CfgProductInfoFrm cfgProductInfoFrm = new CfgProductInfoFrm();
    166.                 this.OpenForm(cfgProductInfoFrm);
    167.             }
    168.             else if (e.Node.Text == "配置.订单信息")
    169.             {
    170.                 CfgOrderInfoFrm cfgOrderInfoFrm = new CfgOrderInfoFrm();
    171.                 this.OpenForm(cfgOrderInfoFrm);
    172.             }
    173.             else if (e.Node.Text == "配置.条码工序信息")
    174.             {
    175.                 CfgBarCodeWkInfoFrm cfgBarCodeWkInfoFrm = new CfgBarCodeWkInfoFrm();
    176.                 this.OpenForm(cfgBarCodeWkInfoFrm);
    177.             }
    178.             else if ((e.Node.Text == "在线.条码打印"))
    179.             {
    180.                 OnLineBarCodePrintFrm onLineBarCodePrintFrm = new OnLineBarCodePrintFrm();
    181.                 this.OpenForm(onLineBarCodePrintFrm);
    182.             }
    183.             else if (e.Node.Text == "配置.打印模板")
    184.             {
    185.                 CfgBarCodePrintTemplateFrm cfgBarCodePrintTemplateFrm = new CfgBarCodePrintTemplateFrm();
    186.                 this.OpenForm(cfgBarCodePrintTemplateFrm);
    187.             }
    188.             else if (e.Node.Text == "配置.条码打印参数")
    189.             {
    190.                 CfgBarCodePrintInfoFrm cfgBarCodePrintInfoFrm = new CfgBarCodePrintInfoFrm();
    191.                 cfgBarCodePrintInfoFrm.callBack += new Action<bool>((b) =>
    192.                 {
    193.                     if (b == false) this.Hide();
    194.                     else this.Show();
    195.  
    196.                 });
    197.                 this.OpenForm((cfgBarCodePrintInfoFrm));
    198.             }
    199.             else if (e.Node.Text == "配置.动态字段")
    200.             {
    201.                 CfgBarCodeInfoFrm cfgBarCodeInfoFrm = new CfgBarCodeInfoFrm();
    202.                 this.OpenForm(cfgBarCodeInfoFrm);
    203.             }
    204.         }
    205.         #endregion
    206.     }
    207. }

    1. using ServerSide.DAL;
    2. using ServerSide.Models;
    3. using System;
    4. using System.Collections.Generic;
    5. using System.ComponentModel;
    6. using System.Data;
    7. using System.Drawing;
    8. using System.Linq;
    9. using System.Text;
    10. using System.Threading.Tasks;
    11. using System.Windows.Forms;
    12.  
    13. namespace PlantProcessControlSystem.BarCodePrint
    14. {
    15.     public partial class CfgBarCodeWkInfoFrm : Form
    16.     {
    17.         private List processinformations;//工序信息
    18.         private Processinformation oldProcessinformation;//旧的工序信息
    19.         public string errInfo;//错误信息
    20.         public CfgBarCodeWkInfoFrm()
    21.         {
    22.             InitializeComponent();
    23.         }
    24.  
    25.         #region 初始化界面
    26.         private void InitWinFrmTable()
    27.         {
    28.             using (EFContext db = new EFContext())
    29.             {
    30.                 this.processinformations = new List();
    31.                 this.processinformations = db!.Processinformation!.ToList();
    32.                 this.dataSource.DataSource = processinformations;
    33.  
    34.                 txt_Process.Text = "";
    35.                 txt_Process.Enabled = false;
    36.             }
    37.             this.btn_Del.Enabled = false;
    38.             this.btn_Rework.Enabled = false;
    39.             this.dataSource.ClearSelection();
    40.         }
    41.         #endregion
    42.  
    43.         #region 返回
    44.         private void btn_Result_Click(object sender, EventArgs e)
    45.         {
    46.             this.InitWinFrmTable();
    47.             this.pe_Processinfo.Visible = false;
    48.         }
    49.         #endregion
    50.  
    51.         #region 添加
    52.         private void btn_Add_Click(object sender, EventArgs e)
    53.         {
    54.             this.lbl_ItemName.Text = "添加";
    55.             this.pe_Processinfo.Visible = true;
    56.             this.btn_Del.Enabled = false;
    57.             this.btn_Rework.Enabled = false;
    58.             this.txt_Process.Text = "";
    59.             this.oldProcessinformation = null;
    60.             this.txt_Process.Enabled = true;
    61.         }
    62.         #endregion
    63.  
    64.         #region 删除
    65.         private void btn_Del_Click(object sender, EventArgs e)
    66.         {
    67.             this.pe_Processinfo.Visible = true;
    68.             this.lbl_ItemName.Text = "删除";
    69.             this.txt_Process.Enabled = false;
    70.             this.btn_Save.Focus();
    71.         }
    72.         #endregion
    73.  
    74.         #region 修改
    75.         private void btn_Rework_Click(object sender, EventArgs e)
    76.         {
    77.             this.pe_Processinfo.Visible = true;
    78.             this.lbl_ItemName.Text = "修改";
    79.             this.txt_Process.Enabled = true;
    80.             this.txt_Process.SelectAll();
    81.             this.txt_Process.Focus();
    82.         }
    83.         #endregion
    84.  
    85.         #region 保存
    86.         private void btn_Save_Click(object sender, EventArgs e)
    87.         {
    88.             if (txt_Process.Text != string.Empty && txt_Process.Text.Length > 0)
    89.             {
    90.                 using (EFContext db = new EFContext())
    91.                 {
    92.                     if (lbl_ItemName.Text == "添加")
    93.                     {
    94.                         Processinformation processinformation = new Processinformation
    95.                         {
    96.                             PrsName = txt_Process.Text
    97.                         };
    98.                         db?.Processinformation?.Add(processinformation);
    99.                     }
    100.                     else if (lbl_ItemName.Text == "修改")
    101.                     {
    102.                         db!.Processinformation!.ToList().ForEach((p) =>
    103.                         {
    104.                             if (p.PrsInfoID == oldProcessinformation.PrsInfoID)
    105.                                 p.PrsName = txt_Process.Text;
    106.                         });
    107.                     }
    108.                     else if (lbl_ItemName.Text == "删除")
    109.                     {
    110.                         db?.Processinformation?.Remove(oldProcessinformation);
    111.                     }
    112.                     int result = db!.SaveChanges();
    113.                     if (result <= 0)
    114.                         MessageBox.Show("数据保存失败!!", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    115.                 }
    116.                 this.pe_Processinfo.Visible = false;
    117.                 this.InitWinFrmTable();
    118.             }
    119.         }
    120.         #endregion
    121.  
    122.         #region 窗体加载
    123.         private void CfgBarCodeWkInfoFrm_Load(object sender, EventArgs e)
    124.         {
    125.             this.InitWinFrmTable();
    126.             this.dataSource.ClearSelection();
    127.         }
    128.         #endregion
    129.  
    130.         #region 点击选择
    131.         private void dataSource_CellClick(object sender, DataGridViewCellEventArgs e)
    132.         {
    133.             try
    134.             {
    135.                 if (e.RowIndex >= 0)
    136.                 {
    137.                     if (processinformations[e.RowIndex] != null)
    138.                     {
    139.                         this.oldProcessinformation = new Processinformation();
    140.                         this.oldProcessinformation = processinformations[e.RowIndex];
    141.                         this.btn_Del.Enabled = true;
    142.                         this.btn_Rework.Enabled = true;
    143.  
    144.                         this.txt_Process.Text = processinformations[e.RowIndex].PrsName;
    145.                     }
    146.                     else
    147.                     {
    148.                         this.btn_Del.Enabled = false;
    149.                         this.btn_Rework.Enabled = false;
    150.                     }
    151.                 }
    152.                 this.pe_Processinfo.Visible = false;
    153.             }
    154.             catch (Exception ex)
    155.             {
    156.                 this.errInfo = string.Empty;
    157.                 MessageBox.Show($@"{ex.Message}", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
    158.             }
    159.         }
    160.         #endregion
    161.     }
    162. }

    1. using ServerSide.DAL;
    2. using ServerSide.Models;
    3. using System;
    4. using System.Collections.Generic;
    5. using System.ComponentModel;
    6. using System.Data;
    7. using System.Drawing;
    8. using System.Linq;
    9. using System.Text;
    10. using System.Threading.Tasks;
    11. using System.Windows.Forms;
    12.  
    13. namespace PlantProcessControlSystem.BarCodePrint
    14. {
    15.     public partial class CfgProductInfoFrm : Form
    16.     {
    17.         private List productNames;//产品名称
    18.         private ProductNames oldproductName;
    19.         private string ErrInfo;//错误信息
    20.         public CfgProductInfoFrm()
    21.         {
    22.             InitializeComponent();
    23.         }
    24.  
    25.         #region 初始化界面
    26.         private void InitWinFrmTable()
    27.         {
    28.             using (EFContext db = new EFContext())
    29.             {
    30.                 productNames = new List();
    31.                 productNames = db!.ProductNames!.ToList();
    32.                 this.dataSource.DataSource = productNames;
    33.  
    34.                 cmb_Client.Items.Clear();
    35.                 db!.ClientInfo!.ToList().ForEach((c) => cmb_Client.Items.Add(c.ClientName));
    36.  
    37.                 txt_ProductName.Text = "";
    38.                 txt_ProductName.Enabled = false;
    39.                 cmb_Client.Enabled = true;
    40.  
    41.             }
    42.             this.btn_Del.Enabled = false;
    43.             this.btn_Rework.Enabled = false;
    44.             this.dataSource.ClearSelection();
    45.         }
    46.         #endregion
    47.  
    48.         #region 窗体加载
    49.         private void CfgProductInfoFrm_Load(object sender, EventArgs e)
    50.         {
    51.             this.InitWinFrmTable();
    52.         }
    53.         #endregion
    54.  
    55.         #region 修改
    56.         private void btn_Rework_Click(object sender, EventArgs e)
    57.         {
    58.             this.pe_ProductInfo.Visible = true;
    59.             this.lbl_ItemName.Text = "修改";
    60.             this.txt_ProductName.SelectAll();
    61.             this.txt_ProductName.Focus();
    62.         }
    63.         #endregion
    64.  
    65.         #region 册除
    66.         private void btn_Del_Click(object sender, EventArgs e)
    67.         {
    68.             this.pe_ProductInfo.Visible = true;
    69.             this.lbl_ItemName.Text = "删除";
    70.             this.txt_ProductName.Enabled = false;
    71.             this.cmb_Client.Enabled = false;
    72.  
    73.         }
    74.         #endregion
    75.  
    76.         #region 添加
    77.         private void btn_Add_Click(object sender, EventArgs e)
    78.         {
    79.             this.lbl_ItemName.Text = "添加";
    80.             this.pe_ProductInfo.Visible = true;
    81.             this.btn_Del.Enabled = false;
    82.             this.btn_Rework.Enabled = false;
    83.             this.txt_ProductName.Text = "";
    84.             this.oldproductName = null;
    85.         }
    86.         #endregion
    87.  
    88.         #region 返回
    89.         private void btn_Result_Click(object sender, EventArgs e)
    90.         {
    91.             this.InitWinFrmTable();
    92.             this.pe_ProductInfo.Visible = false;
    93.         }
    94.         #endregion
    95.  
    96.         #region 保存
    97.         private void btn_Save_Click(object sender, EventArgs e)
    98.         {
    99.             if (txt_ProductName.Text != string.Empty && txt_ProductName.Text.Length > 0)
    100.             {
    101.                 using (EFContext db = new EFContext())
    102.                 {
    103.                     if (lbl_ItemName.Text == "添加")
    104.                     {
    105.                         ProductNames productNames = new ProductNames
    106.                         {
    107.                             ClientId = db?.ClientInfo?.ToList()?.Where(c => c.ClientName == cmb_Client.Text)?.FirstOrDefault()?.ClientId,
    108.                             ProductName = txt_ProductName.Text
    109.                         };
    110.                         db?.ProductNames?.Add(productNames);
    111.                     }
    112.                     else if (lbl_ItemName.Text == "修改")
    113.                     {
    114.                         oldproductName.ProductName = txt_ProductName.Text;
    115.                         db?.ProductNames?.ToList().ForEach(p =>
    116.                         {
    117.                             if (p.ProductId == oldproductName.ProductId)
    118.                                 p.ProductName = txt_ProductName.Text;
    119.                         });
    120.                     }
    121.                     else if (lbl_ItemName.Text == "删除")
    122.                     {
    123.                         db?.ProductNames?.Remove(oldproductName);
    124.                     }
    125.                     int result = db.SaveChanges();
    126.                     if (result <= 0) MessageBox.Show("数据保存失败!!", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    127.                 }
    128.             }
    129.             this.pe_ProductInfo.Visible = false;
    130.             this.InitWinFrmTable();
    131.  
    132.         }
    133.         #endregion
    134.  
    135.         #region 选择客户名称
    136.         private void cmb_Client_SelectedIndexChanged(object sender, EventArgs e)
    137.         {
    138.             if (cmb_Client.Text != string.Empty)
    139.             {
    140.                 txt_ProductName.Enabled = true;
    141.                 txt_ProductName.Focus();
    142.             }
    143.         }
    144.         #endregion
    145.  
    146.         #region 点击选择
    147.         private void dataSource_CellClick(object sender, DataGridViewCellEventArgs e)
    148.         {
    149.             try
    150.             {
    151.                 if (e.RowIndex >= 0)
    152.                 {
    153.                     if (productNames[e.RowIndex] != null)
    154.                     {
    155.                         //txt_UserName.Text = allAuthorizedUsers[e.RowIndex].UserName;
    156.                         //txt_NickName.Text = allAuthorizedUsers[e.RowIndex].NickName;
    157.                         //pte_Image.Image = ImageHelper.ByteToImage(allAuthorizedUsers[e.RowIndex].Picture);
    158.                         //pnl_Edit.Visible = true;
    159.                         using (EFContext db = new EFContext())
    160.                         {
    161.                             this.cmb_Client.Text = db?.ClientInfo?.ToList()?.Where(c => c?.ClientId == productNames[e.RowIndex]?.ClientId)?.FirstOrDefault()?.ClientName;
    162.                         }
    163.                         this.oldproductName = new ProductNames();
    164.                         this.oldproductName = productNames[e.RowIndex];
    165.                         this.btn_Del.Enabled = true;
    166.                         this.btn_Rework.Enabled = true;
    167.  
    168.                         this.txt_ProductName.Text = productNames[e.RowIndex].ProductName;
    169.                         //this.btn_Query.Enabled = true;
    170.                     }
    171.                     else
    172.                     {
    173.                         this.btn_Del.Enabled = false;
    174.                         this.btn_Rework.Enabled = false;
    175.                     }
    176.                 }
    177.                 this.pe_ProductInfo.Visible = false;
    178.             }
    179.             catch (Exception ex)
    180.             {
    181.                 //LogHelper.Error("授权信息", ex);
    182.                 this.ErrInfo = string.Empty;
    183.                 MessageBox.Show($@"{ex.Message}", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
    184.                 //WMessageBox wMessageBox = new WMessageBox(ex.Message, Color.Red);
    185.             }
    186.         }
    187.         #endregion
    188.     }
    189. }

    1. using NPOI.OpenXmlFormats.Spreadsheet;
    2. using ServerSide.DAL;
    3. using ServerSide.Models;
    4. using System;
    5. using System.Collections.Generic;
    6. using System.ComponentModel;
    7. using System.Data;
    8. using System.Drawing;
    9. using System.Linq;
    10. using System.Text;
    11. using System.Threading.Tasks;
    12. using System.Windows.Forms;
    13.  
    14. namespace PlantProcessControlSystem.BarCodePrint
    15. {
    16.     public partial class CfgOrderInfoFrm : Form
    17.     {
    18.         private List configBarCodeOrderInfoEntities;//配置订单信息
    19.         private ConfigBarCodeOrderInfoEntity oldconfigBarCodeOrderInfoEntity;//
    20.         public string ErrInfo;//错误日志
    21.         public CfgOrderInfoFrm()
    22.         {
    23.             InitializeComponent();
    24.             this.InitWinFrmTable();
    25.         }
    26.  
    27.         #region 初始化界面
    28.         private void InitWinFrmTable()
    29.         {
    30.             using (EFContext db = new EFContext())
    31.             {
    32.                 configBarCodeOrderInfoEntities = new List();
    33.                 db?.ConfigBarCodeOrderInfoEntity?.ToList().ForEach(c => configBarCodeOrderInfoEntities.Add(c));
    34.                 dtgv_dataSource.DataSource = configBarCodeOrderInfoEntities;//数据源
    35.  
    36.                 cmb_ProductName.Text = "";//产品名称
    37.                 cmb_ProductName.Items.Clear();
    38.                 db?.ProductNames?.ToList().ForEach(p => cmb_ProductName.Items.Add(p.ProductName));
    39.                 txt_OrderNum.Text = "";//订单号
    40.  
    41.                 txt_BoxNum.Text = "";//外箱序号
    42.                 txt_OrderTotal.Text = "";//订单总数
    43.  
    44.                 cmb_Binding_Nbr.Text = "";//绑码数
    45.                 cmb_Binding_Nbr.Items.Clear();
    46.                 for (int i = 1; i <= 60; i++)
    47.                     cmb_Binding_Nbr.Items.Add(i.ToString());
    48.             }
    49.  
    50.             btn_Del.Enabled = false;//删除
    51.             btn_Rework.Enabled = false;//修改
    52.             btn_Query.Enabled = false;//查询
    53.  
    54.             this.txt_OrderNum.Enabled = true;
    55.             this.cmb_ProductName.Enabled = true;
    56.             this.txt_BoxNum.Enabled = true;
    57.             this.txt_OrderTotal.Enabled = true;
    58.             this.cmb_Binding_Nbr.Enabled = true;
    59.             pe_OrderInfo.Visible = false;
    60.  
    61.         }
    62.         #endregion
    63.  
    64.         #region 添加
    65.         private void btn_Add_Click(object sender, EventArgs e)
    66.         {
    67.             this.lbl_ItemName.Text = "添加";
    68.             this.btn_Del.Enabled = false;
    69.             this.btn_Rework.Enabled = false;
    70.             oldconfigBarCodeOrderInfoEntity = null;
    71.             this.InitWinFrmTable();
    72.             this.pe_OrderInfo.Visible = true;
    73.         }
    74.         #endregion
    75.  
    76.         #region 删除
    77.         private void btn_Del_Click(object sender, EventArgs e)
    78.         {
    79.             this.lbl_ItemName.Text = "删除";
    80.             this.pe_OrderInfo.Visible = true;
    81.             this.txt_OrderNum.Enabled = false;
    82.             this.cmb_ProductName.Enabled = false;
    83.             this.txt_BoxNum.Enabled = false;
    84.             this.txt_OrderTotal.Enabled = false;
    85.             this.cmb_Binding_Nbr.Enabled = false;
    86.         }
    87.         #endregion
    88.  
    89.         #region 修改
    90.         private void btn_Rework_Click(object sender, EventArgs e)
    91.         {
    92.             this.lbl_ItemName.Text = "修改";
    93.             this.txt_OrderNum.Enabled = true;
    94.             this.cmb_ProductName.Enabled = true;
    95.             this.txt_BoxNum.Enabled = true;
    96.             this.txt_OrderTotal.Enabled = true;
    97.             this.cmb_Binding_Nbr.Enabled = true;
    98.             this.pe_OrderInfo.Visible = true;
    99.         }
    100.         #endregion
    101.  
    102.         #region 保存
    103.         private void btn_Save_Click(object sender, EventArgs e)
    104.         {
    105.             using (EFContext db = new EFContext())
    106.             {
    107.                 if (txt_BoxNum.Text != string.Empty &&
    108.                     txt_OrderNum.Text != string.Empty &&
    109.                     txt_OrderTotal.Text != string.Empty &&
    110.                     cmb_Binding_Nbr.Text != string.Empty &&
    111.                     cmb_ProductName.Text != string.Empty)
    112.                 {
    113.                     if (this.lbl_ItemName.Text == "添加")
    114.                     {
    115.                         oldconfigBarCodeOrderInfoEntity = new ConfigBarCodeOrderInfoEntity
    116.                         {
    117.                             OrderInfo = txt_OrderNum.Text.Trim(),
    118.                             ProductId = db?.ProductNames?.ToList()?.Where(p => p.ProductName == cmb_ProductName.Text)?.FirstOrDefault()?.ProductId,
    119.                             OrderCount = Convert.ToInt32(txt_OrderTotal.Text.Trim()),
    120.                             CartonSerialNumber = txt_BoxNum?.Text.Trim(),
    121.                             PackingBindingCode = Convert.ToInt32(cmb_Binding_Nbr.Text.Trim()),
    122.                             FuselageScanCount = 0,
    123.                             GiftBoxScanCount = 0,
    124.                             MasterCartonScanCount = 0
    125.                         };
    126.                         db?.ConfigBarCodeOrderInfoEntity?.Add(oldconfigBarCodeOrderInfoEntity);
    127.                     }
    128.                     else if (this.lbl_ItemName.Text == "修改")
    129.                     {
    130.                         db?.ConfigBarCodeOrderInfoEntity?.ToList().ForEach((c) =>
    131.                         {
    132.                             if (c.WorkOrderId == oldconfigBarCodeOrderInfoEntity.WorkOrderId)
    133.                             {
    134.                                 c.OrderInfo = txt_OrderNum.Text.Trim();
    135.                                 c.ProductId = db?.ProductNames?.ToList()?.Where(p => p?.ProductName?.Trim() == cmb_ProductName.Text.Trim())?.FirstOrDefault()?.ProductId;
    136.                                 c.OrderCount = Convert.ToInt32(txt_OrderTotal.Text.Trim());
    137.                                 c.CartonSerialNumber = txt_BoxNum?.Text.Trim();
    138.                                 c.PackingBindingCode = Convert.ToInt32(cmb_Binding_Nbr?.Text.Trim());
    139.                             }
    140.                         });
    141.                     }
    142.                     else if (this.lbl_ItemName.Text == "删除")
    143.                     {
    144.                         db?.ConfigBarCodeOrderInfoEntity?.Remove(oldconfigBarCodeOrderInfoEntity);
    145.                     }
    146.                     int result = db!.SaveChanges();
    147.                     if (result <= 0) MessageBox.Show("数据保存失败!!", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    148.                     this.pe_OrderInfo.Visible = false;
    149.                     this.InitWinFrmTable();//初始化界面
    150.                 }
    151.             }
    152.         }
    153.         #endregion
    154.  
    155.         #region 表单选择
    156.         private void dtgv_dataSource_CellClick(object sender, DataGridViewCellEventArgs e)
    157.         {
    158.             try
    159.             {
    160.                 if (e.RowIndex >= 0)
    161.                 {
    162.                     if (configBarCodeOrderInfoEntities[e.RowIndex] != null)
    163.                     {
    164.                         this.oldconfigBarCodeOrderInfoEntity = new ConfigBarCodeOrderInfoEntity();
    165.                         this.oldconfigBarCodeOrderInfoEntity.WorkOrderId = configBarCodeOrderInfoEntities[e.RowIndex].WorkOrderId;
    166.                         this.oldconfigBarCodeOrderInfoEntity.ProductId = configBarCodeOrderInfoEntities[e.RowIndex].ProductId;
    167.                         this.oldconfigBarCodeOrderInfoEntity.OrderInfo = configBarCodeOrderInfoEntities[e.RowIndex].OrderInfo;
    168.                         this.oldconfigBarCodeOrderInfoEntity.CartonSerialNumber = configBarCodeOrderInfoEntities[e.RowIndex].CartonSerialNumber;
    169.                         this.oldconfigBarCodeOrderInfoEntity.OrderCount = configBarCodeOrderInfoEntities[e.RowIndex].OrderCount;
    170.                         this.oldconfigBarCodeOrderInfoEntity.FuselageScanCount = configBarCodeOrderInfoEntities[e.RowIndex].FuselageScanCount;
    171.                         this.oldconfigBarCodeOrderInfoEntity.GiftBoxScanCount = configBarCodeOrderInfoEntities[e.RowIndex].GiftBoxScanCount;
    172.                         this.oldconfigBarCodeOrderInfoEntity.MasterCartonScanCount = configBarCodeOrderInfoEntities[e.RowIndex].MasterCartonScanCount;
    173.                         this.oldconfigBarCodeOrderInfoEntity.PackingBindingCode = configBarCodeOrderInfoEntities[e.RowIndex].PackingBindingCode;
    174.  
    175.                         this.txt_OrderNum.Text = configBarCodeOrderInfoEntities[e.RowIndex].OrderInfo;//订单数
    176.                         this.txt_OrderTotal.Text = configBarCodeOrderInfoEntities[e.RowIndex].OrderCount.ToString();//订单总数
    177.                         using (EFContext db = new EFContext())
    178.                         {
    179.                             this.cmb_ProductName.Text = db?.ProductNames?.ToList()?.Where(p => p.ProductId == configBarCodeOrderInfoEntities[e.RowIndex].ProductId)?.FirstOrDefault()?.ProductName;//产品名称
    180.                         }
    181.                         this.txt_BoxNum.Text = configBarCodeOrderInfoEntities[e.RowIndex].CartonSerialNumber;//外箱
    182.                         //this.txt_OrderTotal.Text = configBarCodeOrderInfoEntities[e.RowIndex].OrderCount.ToString();//订单总数
    183.                         this.cmb_Binding_Nbr.Text = configBarCodeOrderInfoEntities[e.RowIndex].PackingBindingCode.ToString();//绑码数
    184.                     }
    185.                 }
    186.                 this.pe_OrderInfo.Visible = false;
    187.                 btn_Del.Enabled = e.RowIndex >= 0 ? true : false;
    188.                 btn_Rework.Enabled = e.RowIndex >= 0 ? true : false;
    189.  
    190.             }
    191.             catch (Exception ex)
    192.             {
    193.                 this.ErrInfo = $@"{ex.Message}";
    194.  
    195.                 MessageBox.Show($@"{ex.Message}", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
    196.             }
    197.         }
    198.         #endregion
    199.  
    200.         #region 返回
    201.         private void btn_Result_Click(object sender, EventArgs e)
    202.         {
    203.             this.pe_OrderInfo.Visible = false;
    204.             this.InitWinFrmTable();
    205.         }
    206.         #endregion
    207.     }
    208. }

    1. using ServerSide.DAL;
    2. using ServerSide.Models;
    3. using System;
    4. using System.Collections.Generic;
    5. using System.ComponentModel;
    6. using System.Data;
    7. using System.Drawing;
    8. using System.Linq;
    9. using System.Text;
    10. using System.Threading.Tasks;
    11. using System.Windows.Forms;
    12.  
    13. namespace PlantProcessControlSystem.BarCodePrint
    14. {
    15.     public partial class CfgBarCodeWkInfoFrm : Form
    16.     {
    17.         private List processinformations;//工序信息
    18.         private Processinformation oldProcessinformation;//旧的工序信息
    19.         public string errInfo;//错误信息
    20.         public CfgBarCodeWkInfoFrm()
    21.         {
    22.             InitializeComponent();
    23.         }
    24.  
    25.         #region 初始化界面
    26.         private void InitWinFrmTable()
    27.         {
    28.             using (EFContext db = new EFContext())
    29.             {
    30.                 this.processinformations = new List();
    31.                 this.processinformations = db!.Processinformation!.ToList();
    32.                 this.dataSource.DataSource = processinformations;
    33.  
    34.                 txt_Process.Text = "";
    35.                 txt_Process.Enabled = false;
    36.             }
    37.             this.btn_Del.Enabled = false;
    38.             this.btn_Rework.Enabled = false;
    39.             this.dataSource.ClearSelection();
    40.         }
    41.         #endregion
    42.  
    43.         #region 返回
    44.         private void btn_Result_Click(object sender, EventArgs e)
    45.         {
    46.             this.InitWinFrmTable();
    47.             this.pe_Processinfo.Visible = false;
    48.         }
    49.         #endregion
    50.  
    51.         #region 添加
    52.         private void btn_Add_Click(object sender, EventArgs e)
    53.         {
    54.             this.lbl_ItemName.Text = "添加";
    55.             this.pe_Processinfo.Visible = true;
    56.             this.btn_Del.Enabled = false;
    57.             this.btn_Rework.Enabled = false;
    58.             this.txt_Process.Text = "";
    59.             this.oldProcessinformation = null;
    60.             this.txt_Process.Enabled = true;
    61.         }
    62.         #endregion
    63.  
    64.         #region 删除
    65.         private void btn_Del_Click(object sender, EventArgs e)
    66.         {
    67.             this.pe_Processinfo.Visible = true;
    68.             this.lbl_ItemName.Text = "删除";
    69.             this.txt_Process.Enabled = false;
    70.             this.btn_Save.Focus();
    71.         }
    72.         #endregion
    73.  
    74.         #region 修改
    75.         private void btn_Rework_Click(object sender, EventArgs e)
    76.         {
    77.             this.pe_Processinfo.Visible = true;
    78.             this.lbl_ItemName.Text = "修改";
    79.             this.txt_Process.Enabled = true;
    80.             this.txt_Process.SelectAll();
    81.             this.txt_Process.Focus();
    82.         }
    83.         #endregion
    84.  
    85.         #region 保存
    86.         private void btn_Save_Click(object sender, EventArgs e)
    87.         {
    88.             if (txt_Process.Text != string.Empty && txt_Process.Text.Length > 0)
    89.             {
    90.                 using (EFContext db = new EFContext())
    91.                 {
    92.                     if (lbl_ItemName.Text == "添加")
    93.                     {
    94.                         Processinformation processinformation = new Processinformation
    95.                         {
    96.                             PrsName = txt_Process.Text
    97.                         };
    98.                         db?.Processinformation?.Add(processinformation);
    99.                     }
    100.                     else if (lbl_ItemName.Text == "修改")
    101.                     {
    102.                         db!.Processinformation!.ToList().ForEach((p) =>
    103.                         {
    104.                             if (p.PrsInfoID == oldProcessinformation.PrsInfoID)
    105.                                 p.PrsName = txt_Process.Text;
    106.                         });
    107.                     }
    108.                     else if (lbl_ItemName.Text == "删除")
    109.                     {
    110.                         db?.Processinformation?.Remove(oldProcessinformation);
    111.                     }
    112.                     int result = db!.SaveChanges();
    113.                     if (result <= 0)
    114.                         MessageBox.Show("数据保存失败!!", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    115.                 }
    116.                 this.pe_Processinfo.Visible = false;
    117.                 this.InitWinFrmTable();
    118.             }
    119.         }
    120.         #endregion
    121.  
    122.         #region 窗体加载
    123.         private void CfgBarCodeWkInfoFrm_Load(object sender, EventArgs e)
    124.         {
    125.             this.InitWinFrmTable();
    126.             this.dataSource.ClearSelection();
    127.         }
    128.         #endregion
    129.  
    130.         #region 点击选择
    131.         private void dataSource_CellClick(object sender, DataGridViewCellEventArgs e)
    132.         {
    133.             try
    134.             {
    135.                 if (e.RowIndex >= 0)
    136.                 {
    137.                     if (processinformations[e.RowIndex] != null)
    138.                     {
    139.                         this.oldProcessinformation = new Processinformation();
    140.                         this.oldProcessinformation = processinformations[e.RowIndex];
    141.                         this.btn_Del.Enabled = true;
    142.                         this.btn_Rework.Enabled = true;
    143.  
    144.                         this.txt_Process.Text = processinformations[e.RowIndex].PrsName;
    145.                     }
    146.                     else
    147.                     {
    148.                         this.btn_Del.Enabled = false;
    149.                         this.btn_Rework.Enabled = false;
    150.                     }
    151.                 }
    152.                 this.pe_Processinfo.Visible = false;
    153.             }
    154.             catch (Exception ex)
    155.             {
    156.                 this.errInfo = string.Empty;
    157.                 MessageBox.Show($@"{ex.Message}", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
    158.             }
    159.         }
    160.         #endregion
    161.     }
    162. }

    1. using ServerSide.DAL;
    2. using ServerSide.Models;
    3. using System;
    4. using System.Collections.Generic;
    5. using System.ComponentModel;
    6. using System.Data;
    7. using System.Drawing;
    8. using System.Linq;
    9. using System.Text;
    10. using System.Threading.Tasks;
    11. using System.Windows.Forms;
    12.  
    13. namespace PlantProcessControlSystem.BarCodePrint
    14. {
    15.     public partial class CfgBarCodeInfoFrm : Form
    16.     {
    17.         private List configBarCodeInfoEntitys;//配置动态字段信息
    18.         private ConfigBarCodeInfoEntity oldConfigBarCodeInfoEntity;//旧的配置动态字段信息
    19.         public string errInfo;//错误信息
    20.         public CfgBarCodeInfoFrm()
    21.         {
    22.             InitializeComponent();
    23.         }
    24.  
    25.         #region 初始化界面
    26.         private void InitWinFrmTable()
    27.         {
    28.             using (EFContext db = new EFContext())
    29.             {
    30.                 this.configBarCodeInfoEntitys = new List();
    31.                 this.configBarCodeInfoEntitys = db!.ConfigBarCodeInfoEntity!.ToList();
    32.                 this.dataSource.DataSource = this.configBarCodeInfoEntitys;
    33.  
    34.                 txt_Process.Text = "";
    35.                 txt_Process.Enabled = false;
    36.  
    37.                 txt_Description.Text = "";
    38.                 txt_Description.Enabled = false;
    39.             }
    40.             this.btn_Del.Enabled = false;
    41.             this.btn_Rework.Enabled = false;
    42.             this.dataSource.ClearSelection();
    43.         }
    44.         #endregion
    45.  
    46.         #region 返回
    47.         private void btn_Result_Click(object sender, EventArgs e)
    48.         {
    49.             this.InitWinFrmTable();
    50.             this.pe_Processinfo.Visible = false;
    51.         }
    52.         #endregion
    53.  
    54.         #region 添加
    55.         private void btn_Add_Click(object sender, EventArgs e)
    56.         {
    57.             this.lbl_ItemName.Text = "添加";
    58.             this.pe_Processinfo.Visible = true;
    59.             this.btn_Del.Enabled = false;
    60.             this.btn_Rework.Enabled = false;
    61.             this.txt_Process.Text = "";
    62.             this.oldConfigBarCodeInfoEntity = null;
    63.             this.txt_Process.Enabled = true;
    64.             this.txt_Description.Enabled = true;
    65.         }
    66.         #endregion
    67.  
    68.         #region 删除
    69.         private void btn_Del_Click(object sender, EventArgs e)
    70.         {
    71.             this.pe_Processinfo.Visible = true;
    72.             this.lbl_ItemName.Text = "删除";
    73.             this.txt_Process.Enabled = false;
    74.             this.txt_Description.Enabled = false;
    75.             this.btn_Save.Focus();
    76.         }
    77.         #endregion
    78.  
    79.         #region 修改
    80.         private void btn_Rework_Click(object sender, EventArgs e)
    81.         {
    82.             this.pe_Processinfo.Visible = true;
    83.             this.lbl_ItemName.Text = "修改";
    84.             this.txt_Process.Enabled = true;
    85.             this.txt_Description.Enabled = true;
    86.             this.txt_Process.SelectAll();
    87.             this.txt_Process.Focus();
    88.         }
    89.         #endregion
    90.  
    91.         #region 保存
    92.         private void btn_Save_Click(object sender, EventArgs e)
    93.         {
    94.             if ((txt_Process.Text != string.Empty && txt_Process.Text.Length > 0)&&
    95.                 (txt_Description.Text!=string.Empty&&txt_Description.Text.Length>0))
    96.             {
    97.                 using (EFContext db = new EFContext())
    98.                 {
    99.                     if (lbl_ItemName.Text == "添加")
    100.                     {
    101.                         ConfigBarCodeInfoEntity configBarCodeInfoEntity = new ConfigBarCodeInfoEntity
    102.                         {
    103.                             ConfigBarCodeName = txt_Process.Text,
    104.                             ConfigDescription=txt_Description.Text
    105.                         };
    106.                         db?.ConfigBarCodeInfoEntity?.Add(configBarCodeInfoEntity);
    107.                     }
    108.                     else if (lbl_ItemName.Text == "修改")
    109.                     {
    110.                         db!.ConfigBarCodeInfoEntity!.ToList().ForEach((p) =>
    111.                         {
    112.                             if (p.cfBarCodeID == oldConfigBarCodeInfoEntity.cfBarCodeID)
    113.                             {
    114.                                 p.ConfigBarCodeName = txt_Process.Text;
    115.                                 p.ConfigDescription=txt_Description.Text;
    116.                             }  
    117.                         });
    118.                     }
    119.                     else if (lbl_ItemName.Text == "删除")
    120.                     {
    121.                         db?.ConfigBarCodeInfoEntity?.Remove(oldConfigBarCodeInfoEntity);
    122.                     }
    123.                     int result = db!.SaveChanges();
    124.                     if (result <= 0)
    125.                         MessageBox.Show("数据保存失败!!", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    126.                 }
    127.                 this.pe_Processinfo.Visible = false;
    128.                 this.InitWinFrmTable();
    129.             }
    130.         }
    131.         #endregion
    132.  
    133.         #region 窗体加载
    134.         private void CfgBarCodeWkInfoFrm_Load(object sender, EventArgs e)
    135.         {
    136.             this.InitWinFrmTable();
    137.             this.dataSource.ClearSelection();
    138.         }
    139.         #endregion
    140.  
    141.         #region 点击选择
    142.         private void dataSource_CellClick(object sender, DataGridViewCellEventArgs e)
    143.         {
    144.             try
    145.             {
    146.                 if (e.RowIndex >= 0)
    147.                 {
    148.                     if (configBarCodeInfoEntitys[e.RowIndex] != null)
    149.                     {
    150.                         this.oldConfigBarCodeInfoEntity = new ConfigBarCodeInfoEntity();
    151.                         this.oldConfigBarCodeInfoEntity = configBarCodeInfoEntitys[e.RowIndex];
    152.                         this.btn_Del.Enabled = true;
    153.                         this.btn_Rework.Enabled = true;
    154.  
    155.                         this.txt_Process.Text = configBarCodeInfoEntitys[e.RowIndex].ConfigBarCodeName;
    156.                         this.txt_Description.Text = configBarCodeInfoEntitys[e.RowIndex].ConfigDescription;
    157.                     }
    158.                     else
    159.                     {
    160.                         this.btn_Del.Enabled = false;
    161.                         this.btn_Rework.Enabled = false;
    162.                     }
    163.                 }
    164.                 this.pe_Processinfo.Visible = false;
    165.             }
    166.             catch (Exception ex)
    167.             {
    168.                 this.errInfo = string.Empty;
    169.                 MessageBox.Show($@"{ex.Message}", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
    170.             }
    171.         }
    172.         #endregion
    173.     }
    174. }

    1. using NPOI.SS.Formula.Functions;
    2. using Org.BouncyCastle.Tls.Crypto;
    3. using ServerSide.Common;
    4. using ServerSide.DAL;
    5. using ServerSide.Models;
    6. using System;
    7. using System.Collections.Generic;
    8. using System.ComponentModel;
    9. using System.Data;
    10. using System.Drawing;
    11. using System.Linq;
    12. using System.Text;
    13. using System.Threading.Tasks;
    14. using System.Windows.Forms;
    15.  
    16. namespace PlantProcessControlSystem
    17. {
    18.     public partial class CfgBarCodePrintTemplateFrm : Form
    19.     {
    20.         private List configBarCodePrintTemplates;//斑码打印模板配置
    21.         private ConfigBarCodePrintTemplate oldconfigBarCodePrintTemplate;//旧的模板配置信息
    22.         public string errInfo;//错误日志
    23.         public CfgBarCodePrintTemplateFrm()
    24.         {
    25.             InitializeComponent();
    26.             this.InitWinFrmTable();
    27.         }
    28.  
    29.         #region 初始化界面
    30.         private void InitWinFrmTable()
    31.         {
    32.             using (EFContext db = new EFContext())
    33.             {
    34.                 configBarCodePrintTemplates = new List();
    35.                 configBarCodePrintTemplates = db!.ConfigBarCodePrintTemplate!.ToList();
    36.                 this.dataSource.DataSource = configBarCodePrintTemplates;
    37.  
    38.                 //客户信息
    39.                 this.cmb_Client.Items.Clear();
    40.                 db!.ClientInfo!.ToList()!.ForEach((c) =>
    41.                 {
    42.                     cmb_Client.Items.Add(c.ClientName);
    43.                 });
    44.                 this.cmb_Client.Text = "";
    45.                 this.cmb_Client.Enabled = true;
    46.  
    47.                 //工序信息
    48.                 this.cmb_Processinformation.Items.Clear();
    49.                 db!.Processinformation!.ToList()!.ForEach(p =>
    50.                 {
    51.                     this.cmb_Processinformation.Items.Add(p.PrsName);
    52.                 });
    53.                 this.cmb_Processinformation.Text = "";
    54.                 this.cmb_Processinformation.Enabled = true;
    55.             }
    56.             //this.gb_PrintModel.Visible = false;
    57.             this.txt_PrintTemplateDownPath.Text = "";
    58.             this.txt_TemplateName.Text = "";
    59.             this.btn_Del.Enabled = false;
    60.             this.btn_Rework.Enabled = false;
    61.             this.dataSource.ClearSelection();
    62.             this.panel_Edit.Visible = false;
    63.             templateName = string.Empty;
    64.         }
    65.         #endregion
    66.  
    67.         #region 选择文档
    68.         //private List fileServiceModels;
    69.         private FileProcesService fProcesService;
    70.         private string selectFileName;//选择文件名称
    71.         private void btn_Example_Click(object sender, EventArgs e)
    72.         {
    73.             selectFileName = string.Empty;
    74.             this.txt_PrintTemplateDownPath.Text = "";
    75.             fProcesService = new FileProcesService();
    76.             fProcesService.SelectFile(out selectFileName, "所有文件(*.btw) | *.btw");
    77.             string[] arrayStr = selectFileName.Split('\\');
    78.             if (this.UploadFile(selectFileName, arrayStr[arrayStr.Length - 1]))//上传模板
    79.             {
    80.                 txt_PrintTemplateDownPath.Text = templateName;//上传模板文件全路径
    81.                 txt_TemplateName.Text = arrayStr[arrayStr.Length - 1];//上传模板名称
    82.             }
    83.         }
    84.         #endregion
    85.  
    86.         #region 返回
    87.         private void btn_Result_Click(object sender, EventArgs e)
    88.         {
    89.             this.panel_Edit.Visible = false;
    90.             this.InitWinFrmTable();
    91.         }
    92.         #endregion
    93.  
    94.         #region 添加
    95.         private void btn_Add_Click(object sender, EventArgs e)
    96.         {
    97.             this.lbl_ItemName.Text = "添加";
    98.             this.btn_Del.Enabled = false;
    99.             this.btn_Rework.Enabled = false;
    100.             this.InitWinFrmTable();
    101.             this.panel_Edit.Visible = true;
    102.  
    103.         }
    104.         #endregion
    105.  
    106.         #region 删除
    107.         private void btn_Del_Click(object sender, EventArgs e)
    108.         {
    109.             this.lbl_ItemName.Text = "删除";
    110.             this.panel_Edit.Visible = true;
    111.             this.cmb_Client.Enabled = false;
    112.             this.txt_PrintTemplateDownPath.Enabled = false;
    113.             this.txt_TemplateName.Enabled = false;
    114.             this.cmb_Processinformation.Enabled = false;
    115.         }
    116.         #endregion
    117.  
    118.         #region 修改
    119.         private void btn_Rework_Click(object sender, EventArgs e)
    120.         {
    121.             this.lbl_ItemName.Text = "修改";
    122.             //this.txt_TemplateName.Enabled = true;
    123.             //this.txt_PrintTemplateDownPath.Enabled = true;
    124.             this.cmb_Client.Enabled = true;
    125.             //this.InitWinFrmTable();
    126.             this.panel_Edit.Visible = true;
    127.         }
    128.         #endregion
    129.  
    130.         #region 表单点击事件
    131.         private void dataSource_CellClick(object sender, DataGridViewCellEventArgs e)
    132.         {
    133.             try
    134.             {
    135.                 if (e.RowIndex >= 0)
    136.                 {
    137.                     if (configBarCodePrintTemplates[e.RowIndex] != null)
    138.                     {
    139.                         this.oldconfigBarCodePrintTemplate = new ConfigBarCodePrintTemplate();
    140.                         this.oldconfigBarCodePrintTemplate = configBarCodePrintTemplates[e.RowIndex];
    141.                         this.btn_Del.Enabled = true;
    142.                         this.btn_Rework.Enabled = true;
    143.  
    144.                         using (EFContext db = new EFContext())
    145.                         {
    146.                             this.cmb_Client.Text = db?.ClientInfo?.ToList()?.Where(c => c.ClientId == configBarCodePrintTemplates[e.RowIndex].ClientId)?.FirstOrDefault()?.ClientName;
    147.                             this.cmb_Processinformation.Text = db?.Processinformation?.ToList()?.Where(p => p.PrsInfoID == this.oldconfigBarCodePrintTemplate.PrsInfoID)?.FirstOrDefault()?.PrsName;
    148.                         }
    149.                         this.txt_TemplateName.Text = this.oldconfigBarCodePrintTemplate.TempateName;//打印模板名称
    150.                         this.txt_PrintTemplateDownPath.Text = this.oldconfigBarCodePrintTemplate.TempateDownPath;//打印模板下载路径
    151.                     }
    152.                     else
    153.                     {
    154.                         this.btn_Del.Enabled = false;
    155.                         this.btn_Rework.Enabled = false;
    156.                     }
    157.                 }
    158.             }
    159.             catch (Exception ex)
    160.             {
    161.                 this.errInfo = string.Empty;
    162.                 MessageBox.Show($@"{ex.Message}", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
    163.             }
    164.         }
    165.         #endregion
    166.  
    167.         #region 保存
    168.         private void btn_Save_Click(object sender, EventArgs e)
    169.         {
    170.             if (cmb_Client.Text != string.Empty &&
    171.                 txt_TemplateName.Text != string.Empty &&
    172.                 txt_PrintTemplateDownPath.Text != string.Empty &&
    173.                 cmb_Processinformation.Text != string.Empty)
    174.             {
    175.                 using (EFContext db = new EFContext())
    176.                 {
    177.                     if (lbl_ItemName.Text == "添加")
    178.                     {
    179.                         ConfigBarCodePrintTemplate cfgbptemplate = new ConfigBarCodePrintTemplate
    180.                         {
    181.                             ClientId = db?.ClientInfo?.ToList().Where(c => c.ClientName == cmb_Client.Text)?.FirstOrDefault()?.ClientId,
    182.                             PrsInfoID = db?.Processinformation?.ToList().Where(p => p.PrsName == cmb_Processinformation.Text.Trim())?.FirstOrDefault()?.PrsInfoID,
    183.                             TempateDownPath = txt_PrintTemplateDownPath.Text.Trim(),
    184.                             TempateName = txt_TemplateName.Text.Trim()
    185.                         };
    186.                         db?.ConfigBarCodePrintTemplate?.Add(cfgbptemplate);
    187.                     }
    188.                     else if (lbl_ItemName.Text == "修改")
    189.                     {
    190.                         db?.ConfigBarCodePrintTemplate?.ToList().ForEach(c =>
    191.                         {
    192.                             if (c.BarCodePrintId == oldconfigBarCodePrintTemplate.BarCodePrintId)
    193.                             {
    194.                                 c.ClientId = db?.ClientInfo?.ToList()?.Where(c => c.ClientName == cmb_Client.Text)?.FirstOrDefault()?.ClientId;//客户
    195.                                 c.TempateDownPath = txt_PrintTemplateDownPath.Text.Trim();
    196.                                 c.TempateName = txt_TemplateName.Text.Trim();
    197.                             }
    198.                         });
    199.                     }
    200.                     else if (lbl_ItemName.Text == "删除")
    201.                     {
    202.                         db?.ConfigBarCodePrintTemplate?.Remove(oldconfigBarCodePrintTemplate);
    203.                     }
    204.                     int result = db!.SaveChanges();
    205.                     if (result <= 0)
    206.                         MessageBox.Show("数据保存失败!!", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    207.                 }
    208.                 this.panel_Edit.Visible = false;
    209.                 this.InitWinFrmTable();//初始化界面
    210.             }
    211.         }
    212.         #endregion
    213.  
    214.         #region 上传日志
    215.         /// 
    216.         /// 上传日志信息
    217.         /// 
    218.         /// 
    219.         /// 上传文件路径
    220.         /// 上传文件名及路径
    221.         /// 
    222.         public bool UploadLog(string uploadFilePath, string fileName, string processFile,bool isLogPass=false)
    223.         {
    224.             try
    225.             {
    226.                 if(uploadFilePath!=string.Empty&&fileName!=string.Empty)
    227.                 {
    228.                     string networkPath = string.Empty;
    229.                     if (!File.Exists(@"\\10.2.2.163\Data\PASS.OK"))
    230.                     {
    231.                         NetworkShareConnect mess = new NetworkShareConnect();
    232.                         if (mess.connectToShare(networkPath, "test", "Admin123") != "OK")
    233.                         {
    234.                             MessageBox.Show($@"{networkPath}:服务器连接失败", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    235.                             return false;
    236.                         }
    237.                     }
    238.                     if (isLogPass)//是PASS
    239.                     {
    240.                         if (!Directory.Exists($@"\\10.2.2.163\data\LOG\PASS\{processFile}\{DateTime.Now.ToString("yyyyMMdd")}"))
    241.                             Directory.CreateDirectory($@"\\10.2.2.163\data\LOG\{processFile}\PASS\{DateTime.Now.ToString("yyyyMMdd")}");//创建文件夹
    242.                         System.IO.File.Copy(uploadFilePath, $@"\\10.2.2.163\data\LOG\{processFile}\PASS\{DateTime.Now.ToString("yyyyMMdd")}\{fileName}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.log");
    243.                         if (System.IO.File.Exists($@"\\10.2.2.163\data\LOG\{processFile}\PASS\{DateTime.Now.ToString("yyyyMMdd")}\{fileName}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.log"))
    244.                             return true;
    245.                     }
    246.                     else if (!isLogPass)//是FAIL
    247.                     {
    248.                         if (!Directory.Exists($@"\\10.2.2.163\data\LOG\{processFile}\FAIL\{DateTime.Now.ToString("yyyyMMdd")}"))
    249.                             Directory.CreateDirectory($@"\\10.2.2.163\data\LOG\{processFile}\FAIL\{DateTime.Now.ToString("yyyyMMdd")}");//创建文件夹
    250.                         System.IO.File.Copy(uploadFilePath, $@"\\10.2.2.163\data\LOG\{processFile}\FAIL\{DateTime.Now.ToString("yyyyMMdd")}\{fileName}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.FA");
    251.                         if (System.IO.File.Exists($@"\\10.2.2.163\data\LOG\{processFile}\FAIL\{DateTime.Now.ToString("yyyyMMdd")}\{fileName}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.FA"))
    252.                             return true;
    253.                     }
    254.                 }
    255.             }
    256.             catch(Exception ex)
    257.             {
    258.                 MessageBox.Show(ex.Message, "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    259.                 return false;
    260.             }
    261.             return false;
    262.         }
    263.         #endregion
    264.  
    265.         #region 上传模板
    266.         private string templateName = string.Empty;
    267.         private bool UploadFile(string uploadFilePath, string fileName)
    268.         {
    269.             try
    270.             {
    271.                 if (uploadFilePath != string.Empty)
    272.                 {
    273.                     string networkPath = string.Empty;
    274.                     //networkPath = $@"\\10.2.2.163\BarCode\{cmb_Processinformation.Text}\{fileName}";
    275.                     networkPath = $@"\\10.2.2.163\BarCode\{cmb_Processinformation.Text}";
    276.                     if (!File.Exists(@"\\10.2.2.163\Data\PASS.OK"))
    277.                     {
    278.                         NetworkShareConnect mess = new NetworkShareConnect();
    279.                         if (mess.connectToShare(networkPath, "test", "Admin123") != "OK")
    280.                         {
    281.                             MessageBox.Show($@"{networkPath}:服务器连接失败", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    282.                             return false;
    283.                         }
    284.                     }
    285.                     if (System.IO.File.Exists($@"\\10.2.2.163\BarCode\{cmb_Processinformation.Text}\{fileName}"))
    286.                         System.IO.File.Delete($@"\\10.2.2.163\BarCode\{cmb_Processinformation.Text}\{fileName}");
    287.  
    288.                     if (System.IO.File.Exists($@"\\10.2.2.163\BarCode\{cmb_Processinformation.Text}\{fileName}"))
    289.                     {
    290.                         MessageBox.Show($"打印模板:{fileName}名称在服务器中已存在", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    291.                         return false;
    292.                     }
    293.                     else
    294.                     {
    295.                         //MessageBox.Show(txt_PrintModelSample.Text);
    296.                         //MessageBox.Show(networkPath);
    297.                         System.IO.File.Copy(uploadFilePath, $@"\\10.2.2.163\BarCode\{cmb_Processinformation.Text}\{fileName}");
    298.                         if (System.IO.File.Exists($@"\\10.2.2.163\BarCode\{cmb_Processinformation.Text}\{fileName}") == true)
    299.                         {
    300.                             templateName = $@"\\10.2.2.163\BarCode\{cmb_Processinformation.Text}\{fileName}";
    301.                             return true;
    302.                         }
    303.                         else
    304.                         {
    305.                             MessageBox.Show($"打印模板:{fileName}上传服务器失败", "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    306.                             return false;
    307.                         }
    308.                     }
    309.                 }
    310.             }
    311.             catch (Exception ex)
    312.             {
    313.                 MessageBox.Show(ex.Message, "系统提醒", MessageBoxButtons.OK, MessageBoxIcon.Error);
    314.                 return false;
    315.             }
    316.             return false;
    317.         }
    318.         #endregion
    319.  
    320.     }
    321. }

    1.条码打印实现类

    1. using ServerSide.Models;
    2. using System;
    3. using System.Collections.Generic;
    4. using System.Linq;
    5. using System.Text;
    6. using System.Threading.Tasks;
    7.  
    8. namespace ServerSide.Common
    9. {
    10.     public class BarTenderHelper
    11.     {
    12.         public event Action<string> callBack;
    13.         private PrintConfigEntity pcEntity;
    14.         private BarTender.Application btapp;//引用方法1
    15.         private BarTender.Format btformat;//引用方法2
    16.         public BarTenderHelper(PrintConfigEntity pcfEntity)
    17.         {
    18.             this.pcEntity= pcfEntity;
    19.         }
    20.  
    21.         #region 条码打印
    22.         public Boolean BarTenderPrint()
    23.         {
    24.             try
    25.             {
    26.                 this.btapp = new BarTender.Application();
    27.                 this.btformat = this.btapp.Formats.Open(this.pcEntity.PTemplate, false, "");//设置模板文件
    28.                 this.btformat.PrintSetup.NumberSerializedLabels = Convert.ToInt32(this.pcEntity.PCount);//设置打印份数
    29.                 this.pcEntity.ScanDt.ForEach((d) => {
    30.                     this.btformat.SetNamedSubStringValue(d.BarCodeName, d.BarCodeString);
    31.                 });
    32.                 this.btformat.PrintOut(true,Convert.ToBoolean(this.pcEntity.IsShowPrint));//打印提示
    33.                 this.btapp.Quit(BarTender.BtSaveOptions.btPromptSave);//退出并改变BarTender模板
    34.                 return true;
    35.             }
    36.             catch (Exception ex)
    37.             {
    38.                 this.callBack(ex.Message);
    39.                 return false;
    40.             }
    41.         }
    42.         #endregion
    43.     }
    44. }

    实体类：

    1. using System;
    2. using System.Collections.Generic;
    3. using System.ComponentModel.DataAnnotations;
    4. using System.ComponentModel.DataAnnotations.Schema;
    5. using System.Linq;
    6. using System.Text;
    7. using System.Threading.Tasks;
    8.  
    9. namespace ServerSide.Models
    10. {
    11.     #region 配置动态字段信息
    12.     public class ConfigBarCodeInfoEntity
    13.     {
    14.  
    15.         /// 
    16.         /// 配置动态条码ID
    17.         /// 
    18.         [Key]
    19.         [DatabaseGenerated(DatabaseGeneratedOption.Identity)] //自增
    20.         public int ?cfBarCodeID { get; set; }
    21.  
    22.  
    23.         /// 
    24.         /// 动态字段名称
    25.         /// 
    26.         [Required]//不允许为空
    27.         [StringLength(50)]
    28.         public string? ConfigBarCodeName { get; set; }
    29.  
    30.  
    31.         /// 
    32.         /// 项目描述
    33.         /// 
    34.         [Required]
    35.         [StringLength(80)]
    36.         public string? ConfigDescription { get; set; }
    37.  
    38.         public DateTime? CreateTim { get; set; } = DateTime.Now;//创建时间     
    39.     }
    40.     #endregion
    41. }
    1. using System;
    2. using System.Collections.Generic;
    3. using System.ComponentModel.DataAnnotations;
    4. using System.ComponentModel.DataAnnotations.Schema;
    5. using System.Linq;
    6. using System.Text;
    7. using System.Threading.Tasks;
    8.  
    9. namespace ServerSide.Models
    10. {
    11.     /// 
    12.     /// 条码配置
    13.     /// 
    14.     public class BarCodeCfig
    15.     {
    16.         /// 
    17.         /// 配置ID
    18.         /// 
    19.         [Key]
    20.         [DatabaseGenerated(DatabaseGeneratedOption.Identity)] //自增
    21.         public int ?CfigId { get; set; }
    22.  
    23.         /// 
    24.         /// 客户ID
    25.         /// 
    26.         [ForeignKey("ClientId")]//设置导航属性
    27.         //public ClientInfo? ClientInfo { get; set; }
    28.         public int? ClientId { get; set; }//外键
    29.  
    30.         /// 
    31.         /// 产品ID
    32.         /// 
    33.         [ForeignKey("ProductId")]//设置导航属性
    34.         //public ProductNames? ProductNames { get; set; }
    35.         public int? ProductId { get; set; }//外键
    36.  
    37.  
    38.         /// 
    39.         /// 订单ID
    40.         /// 
    41.         [ForeignKey("WorkOrderId")]//设置导航属性
    42.         //public ProductNames? ProductNames { get; set; }
    43.         public int? WorkOrderId { get; set; }//外键
    44.  
    45.         /// 
    46.         /// 工序ID
    47.         /// 
    48.         [ForeignKey("PrsInfoID")]//设置导航属性
    49.         //public Processinformation? Processinformation { get; set; }
    50.         public int? PrsInfoID { get; set; }//外键
    51.  
    52.         /// 
    53.         /// 配置打印模板ID
    54.         /// 
    55.         [Required]//不允许为空
    56.         [ForeignKey("BarCodePrintId")]//打印模板ID
    57.         //public ConfigBarCodeInfoEntity? ConfigBarCodeInfoEntity { get; set; }
    58.         public int? BarCodePrintId { get; set; }//外键
    59.  
    60.         /// 
    61.         /// 配置参数值
    62.         /// 
    63.         [StringLength(255)]
    64.         public string? CfgArgsValue { get; set; }
    65.  
    66.         public DateTime? CreateTim { get; set; } = DateTime.Now;//创建时间
    67.  
    68.     }
    69. }
    1. using System;
    2. using System.Collections.Generic;
    3. using System.ComponentModel.DataAnnotations.Schema;
    4. using System.ComponentModel.DataAnnotations;
    5. using System.Linq;
    6. using System.Text;
    7. using System.Threading.Tasks;
    8.  
    9. namespace ServerSide.Models
    10. {
    11.     /// 
    12.     /// 配置打印模板
    13.     /// 
    14.     public class ConfigBarCodePrintTemplate
    15.     {
    16.         /// 
    17.         /// 打印模板ID
    18.         /// 
    19.  
    20.         [Key]
    21.         [DatabaseGenerated(DatabaseGeneratedOption.Identity)] //自增
    22.         public int BarCodePrintId { get; set; }
    23.  
    24.  
    25.         /// 
    26.         /// 客户ID
    27.         /// 
    28.         [ForeignKey("ClientId")]//设置导航属性
    29.         //public ClientInfo? ClientInfo { get; set; }
    30.         public int? ClientId { get; set; }//外键
    31.  
    32.         /// 
    33.         /// 工序ID
    34.         /// 
    35.         [ForeignKey("PrsInfoID")]//设置导航属性
    36.         //public Processinformation? Processinformation { get; set; }
    37.         public int? PrsInfoID { get; set; }//外键
    38.  
    39.  
    40.         /// 
    41.         /// 模板名称
    42.         /// 
    43.         [Required]
    44.         [StringLength(100)]
    45.         public string? TempateName { get; set; }
    46.  
    47.  
    48.         /// 
    49.         /// 模板下载路径
    50.         /// 
    51.         [Required]
    52.         [StringLength(255)]
    53.         public string? TempateDownPath { get; set; }
    54.     }
    55. }
    1. using System;
    2. using System.Collections.Generic;
    3. using System.ComponentModel.DataAnnotations.Schema;
    4. using System.ComponentModel.DataAnnotations;
    5. using System.Linq;
    6. using System.Text;
    7. using System.Threading.Tasks;
    8.  
    9. namespace ServerSide.Models
    10. {
    11.     /// 
    12.     /// 配置打印模板
    13.     /// 
    14.     public class ConfigBarCodePrintTemplate
    15.     {
    16.         /// 
    17.         /// 打印模板ID
    18.         /// 
    19.  
    20.         [Key]
    21.         [DatabaseGenerated(DatabaseGeneratedOption.Identity)] //自增
    22.         public int BarCodePrintId { get; set; }
    23.  
    24.  
    25.         /// 
    26.         /// 客户ID
    27.         /// 
    28.         [ForeignKey("ClientId")]//设置导航属性
    29.         //public ClientInfo? ClientInfo { get; set; }
    30.         public int? ClientId { get; set; }//外键
    31.  
    32.         /// 
    33.         /// 工序ID
    34.         /// 
    35.         [ForeignKey("PrsInfoID")]//设置导航属性
    36.         //public Processinformation? Processinformation { get; set; }
    37.         public int? PrsInfoID { get; set; }//外键
    38.  
    39.  
    40.         /// 
    41.         /// 模板名称
    42.         /// 
    43.         [Required]
    44.         [StringLength(100)]
    45.         public string? TempateName { get; set; }
    46.  
    47.  
    48.         /// 
    49.         /// 模板下载路径
    50.         /// 
    51.         [Required]
    52.         [StringLength(255)]
    53.         public string? TempateDownPath { get; set; }
    54.     }
    55. }
    1. using System;
    2. using System.Collections.Generic;
    3. using System.ComponentModel.DataAnnotations.Schema;
    4. using System.ComponentModel.DataAnnotations;
    5. using System.Linq;
    6. using System.Text;
    7. using System.Threading.Tasks;
    8.  
    9. namespace ServerSide.Models
    10. {
    11.     /// 
    12.     /// 配置打印模板
    13.     /// 
    14.     public class ConfigBarCodePrintTemplate
    15.     {
    16.         /// 
    17.         /// 打印模板ID
    18.         /// 
    19.  
    20.         [Key]
    21.         [DatabaseGenerated(DatabaseGeneratedOption.Identity)] //自增
    22.         public int BarCodePrintId { get; set; }
    23.  
    24.  
    25.         /// 
    26.         /// 客户ID
    27.         /// 
    28.         [ForeignKey("ClientId")]//设置导航属性
    29.         //public ClientInfo? ClientInfo { get; set; }
    30.         public int? ClientId { get; set; }//外键
    31.  
    32.         /// 
    33.         /// 工序ID
    34.         /// 
    35.         [ForeignKey("PrsInfoID")]//设置导航属性
    36.         //public Processinformation? Processinformation { get; set; }
    37.         public int? PrsInfoID { get; set; }//外键
    38.  
    39.  
    40.         /// 
    41.         /// 模板名称
    42.         /// 
    43.         [Required]
    44.         [StringLength(100)]
    45.         public string? TempateName { get; set; }
    46.  
    47.  
    48.         /// 
    49.         /// 模板下载路径
    50.         /// 
    51.         [Required]
    52.         [StringLength(255)]
    53.         public string? TempateDownPath { get; set; }
    54.     }
    55. }
    1. using System;
    2. using System.Collections.Generic;
    3. using System.ComponentModel.DataAnnotations;
    4. using System.ComponentModel.DataAnnotations.Schema;
    5. using System.Linq;
    6. using System.Text;
    7. using System.Threading.Tasks;
    8.  
    9. namespace ServerSide.Models
    10. {
    11.     #region 配置打印的订单信息
    12.     public class ConfigBarCodeOrderInfoEntity
    13.     {
    14.         /// 
    15.         /// 订单ID
    16.         /// 
    17.         [Key]
    18.         [DatabaseGenerated(DatabaseGeneratedOption.Identity)] //自增
    19.         public int WorkOrderId { get; set; }
    20.  
    21.         /// 
    22.         /// 产品ID
    23.         /// 
    24.         [ForeignKey("ProductId")]//设置导航属性
    25.         //public ProductNames? ProductNames { get; set; }
    26.         public int? ProductId { get; set; }//外键
    27.  
    28.         /// 
    29.         /// 订单号
    30.         /// 
    31.         [Required]
    32.         [StringLength(150)]
    33.         public string ?OrderInfo { get; set; }
    34.  
    35.         /// 
    36.         /// 订单总数
    37.         /// 
    38.         [Required]
    39.         public int? OrderCount { get; set; }
    40.  
    41.         /// 
    42.         /// 外箱序号
    43.         /// 
    44.         [Required]
    45.         [StringLength(100)]
    46.         public string ?CartonSerialNumber { get; set; }
    47.  
    48.         /// 
    49.         /// 机身扫描总数
    50.         /// 
    51.         [Required]
    52.         public int? FuselageScanCount { get; set; } = 0;
    53.  
    54.         /// 
    55.         /// 彩盒扫描总数
    56.         /// 
    57.         [Required]
    58.         public int? GiftBoxScanCount { get; set; } = 0;
    59.  
    60.         /// 
    61.         /// 外箱扫描总数
    62.         /// 
    63.         [Required]
    64.         public int? MasterCartonScanCount { get; set; } = 0;
    65.  
    66.         /// 
    67.         /// 装箱绑码数
    68.         /// 
    69.         [Required]
    70.         public int PackingBindingCode { get; set; } = 1;
    71.  
    72.         public DateTime? CreateTim { get; set; } = DateTime.Now;//创建时间
    73.     }
    74.     #endregion
    75. }
    1. using System;
    2. using System.Collections.Generic;
    3. using System.ComponentModel.DataAnnotations;
    4. using System.ComponentModel.DataAnnotations.Schema;
    5. using System.Linq;
    6. using System.Text;
    7. using System.Threading.Tasks;
    8.  
    9. namespace ServerSide.Models
    10. {
    11.     /// 
    12.     /// 产品名称
    13.     /// 
    14.     public class ProductNames
    15.     {
    16.  
    17.         /// 
    18.         /// 产品ID
    19.         /// 
    20.         [Key]
    21.         [DatabaseGenerated(DatabaseGeneratedOption.Identity)] //自增
    22.         public int? ProductId { get; set; }
    23.  
    24.         /// 
    25.         /// 客户ID
    26.         /// 
    27.         [ForeignKey("ClientId")]//设置导航属性
    28.         //public ClientInfo? ClientInfo { get; set; }
    29.         public int? ClientId { get; set; }//外键
    30.  
    31.         /// 
    32.         /// 产品名称
    33.         /// 
    34.         [Required]
    35.         [StringLength(100)]
    36.         public string? ProductName { get; set; }
    37.  
    38.         public DateTime? CreateTim { get; set; } = DateTime.Now;//创建时间
    39.  
    40.     }
    41. }

  • 相关阅读:
    《低代码指南》——维格云和Airtable的比较
    “2024杭州国际物联网展览会”定于4月份在杭州国际博览中心召开
    网络安全（黑客）自学
    RPA在票据处理中的应用
    微信小程序报request:fail url not in domain list的解决方法
    Maven dependency 详解
    栈和队列1——栈的实现及其oj（括号匹配问题）
    JVM 双亲委派模型
    【网络服务&数据库教程】09 Rsync 实操
    【Visual Leak Detector】核心源码剖析（VLD 2.5.1）
  • 原文地址：https://blog.csdn.net/u013934107/article/details/134097988