using Plugin.SNGenerateTool; using Plugin.SNGenerateTool.Entity; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Drawing.Drawing2D; using System.Globalization; using System.IO; using System.Reflection; using System.Runtime.InteropServices; using System.Text; using System.Timers; using System.Windows.Forms; public class Form1 : Form { private Point Point; private string iniFile = Path.Combine(Application.StartupPath, "Config", "UserSettings.ini"); private UserSettings settings1; private UserSettings settings2; private DataTable table = new DataTable(); private bool flag; private string[] years = new string[30] { "1", "2", "3", "4", "5", "6", "7", "8", "9", "A", "B", "C", "D", "E", "F", "G", "H", "J", "K", "L", "M", "N", "P", "R", "S", "T", "V", "W", "X", "Y" }; private string[] months = new string[12] { "1", "2", "3", "4", "5", "6", "7", "8", "9", "A", "B", "C" }; private string[] days = new string[31] { "1", "2", "3", "4", "5", "6", "7", "8", "9", "A", "B", "C", "D", "E", "F", "G", "H", "J", "K", "L", "M", "N", "P", "R", "S", "T", "V", "W", "X", "Y", "Z" }; private string[] F18CY = new string[10] { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9" }; private System.Timers.Timer timer = new System.Timers.Timer(); private string fileNameWithoutExt = string.Empty; private ProgressBar progressBar = new ProgressBar(); private IContainer components = null; private ToolStripPanel BottomToolStripPanel; private ToolStripPanel TopToolStripPanel; private ToolStripPanel RightToolStripPanel; private ToolStripPanel LeftToolStripPanel; private ToolStripContentPanel ContentPanel; private TabControl tabControl1; private TabPage tabPage1; private Panel panel1; private GroupBox groupBox2; private TextBox txt_FactoryCode; private Label label4; private TextBox txt_PCODE; private TextBox txt_LineNo1; private Label label5; private Label label6; private GroupBox groupBox1; private TextBox txt_StartSN; private Label label1; private TextBox txt_SNPrefix; private Label label2; private TabPage tabPage2; private StatusStrip statusStrip1; private GroupBox groupBox3; private TextBox txt_StartDHUIDSN; private Label label11; private TextBox txt_ShiftsNo; private Label label12; private TextBox txt_Date2; private Label label13; private TextBox txt_PN; private Label label14; private TextBox txt_VendorCode; private Label label15; private Label label17; private TextBox txt_EndDaySN; private TextBox txt_MinSpecialSN; private Label label10; private TextBox txt_StartDaySN; private Label label9; private TextBox txt_Date1; private Label label8; private Label label7; private TextBox txt_EndSN; private TextBox txt_MaxSpecialSN; private Label label18; private TextBox txt_EndDHUIDSN; private Label label19; private GroupBox groupBox4; private TextBox txt_HW; private TextBox txt_GeelyHWSD; private Label label21; private Label label20; private TextBox txt_SW; private Label label25; private TextBox txt_VolvoDU; private Label label24; private TextBox txt_VolvoHWSD; private Label label23; private TextBox txt_GeelyDU; private Label label22; private Button btn_ClearText; private Button btn_ImportData; private Button btn_CreateSN; private DataGridView dataGridView1; private ToolStripStatusLabel toolStripStatusLabel1; private ToolStripStatusLabel toolStripStatusLabel2; private ToolStripStatusLabel toolStripStatusLabel3; private ToolStripStatusLabel toolStripStatusLabel4; private ToolStripStatusLabel toolStripStatusLabel5; private ToolStripStatusLabel toolStripStatusLabel6; private ToolTip toolTip1; private ErrorProvider errorProvider1; private Label label3; private Label lbl_Title; private TextBox txt_MachineCode; private Label label16; private Button btn_Close; private Button btn_Minimize; private ToolStripStatusLabel toolStripStatusLabel7; private ToolStripStatusLabel toolStripStatusLabel8; private DataGridView dataGridView2; private Panel panel2; private Label label28; private Label label27; private Button btn_Delete; private Button btn_Modify; private Button btn_Query; private ComboBox cbox_Field; private TextBox tbx_content; private ComboBox cbox_Model; private Label label26; private TextBox txt_SXBL; private Label label29; private TextBox txt_SXDISXBL; private Label label30; private TextBox tbx_OrderID; private Button btn_OpenDlg; private Button btn_Export; [DllImport("kernel32")] private static extern long WritePrivateProfileString(string section, string key, string val, string filePath); [DllImport("kernel32")] private static extern int GetPrivateProfileString(string section, string key, string def, StringBuilder retVal, int size, string filePath); public Form1() { InitializeComponent(); settings1 = new UserSettings(iniFile); SetMainForm(); SetTabControl(); SetToolStrip(); SetToolTip(); SetErrorProvider(); SetControls(base.Controls); SetDataGridColumn(dataGridView1); Timer(timer, Realtime); } private string GetVersion() { return "程序集版本:" + Assembly.GetExecutingAssembly().GetName().Version.ToString(); } private void SetMainForm() { Text = "E04 SN Generate Tool"; base.ControlBox = false; base.FormBorderStyle = FormBorderStyle.None; base.StartPosition = FormStartPosition.CenterScreen; BackColor = Color.FromArgb(71, 236, 255); } private void SetTabControl() { tabControl1.DrawMode = TabDrawMode.OwnerDrawFixed; tabControl1.ItemSize = new Size(75, 25); tabControl1.SizeMode = TabSizeMode.Fixed; } private void SetToolStrip() { statusStrip1.BackColor = Color.FromArgb(227, 237, 243); statusStrip1.ForeColor = Color.MediumBlue; toolStripStatusLabel1.Text = ""; toolStripStatusLabel1.AutoSize = false; toolStripStatusLabel1.Width = 700; toolStripStatusLabel2.Text = "当前用户:"; toolStripStatusLabel3.Text = ""; toolStripStatusLabel3.AutoSize = false; toolStripStatusLabel3.Width = 50; toolStripStatusLabel4.Text = GetVersion(); toolStripStatusLabel5.Text = ""; toolStripStatusLabel5.AutoSize = false; toolStripStatusLabel5.Width = 50; toolStripStatusLabel6.Text = "系统时间:" + DateTime.Now.ToString("G"); toolStripStatusLabel7.Text = ""; toolStripStatusLabel7.AutoSize = false; toolStripStatusLabel7.Width = 50; toolStripStatusLabel8.Text = "0行"; } private void SetToolTip() { toolTip1.InitialDelay = 10; toolTip1.ReshowDelay = 10; toolTip1.SetToolTip(txt_Date1, "日期格式:yyyyMMdd"); toolTip1.SetToolTip(txt_Date2, "日期格式:yyyyMMdd"); toolTip1.SetToolTip(btn_Minimize, "最小化"); toolTip1.SetToolTip(btn_Close, "关闭"); } private void SetErrorProvider() { errorProvider1.BlinkStyle = ErrorBlinkStyle.AlwaysBlink; } private void SetControls(Control.ControlCollection controls) { foreach (Control control in controls) { if (control is TabControl tabControl) { tabControl.DrawItem += tabControl1_DrawItem; } else if (control is Panel panel) { panel.BackColor = Color.FromArgb(227, 237, 243); } else if (control is GroupBox groupBox) { groupBox.ForeColor = ColorTranslator.FromHtml("#442A9D"); } else if (control is TextBox textBox) { textBox.ImeMode = ImeMode.Disable; if (textBox.Name == "txt_Date1" || textBox.Name == "txt_Date2") { textBox.Text = DateTime.Now.ToString("yyyyMMdd"); } if (textBox.Name == "txt_EndDaySN" || textBox.Name == "txt_MaxSpecialSN" || textBox.Name == "txt_EndDHUIDSN") { textBox.Enabled = false; } textBox.KeyPress += textBox_KeyPress; if (textBox.Name == "tbx_content") { textBox.Validated += textBox_Validated; } else { textBox.Validating += textBox_Validating; } } else if (control is Label label) { label.ForeColor = ColorTranslator.FromHtml("#442A9D"); if (label.Name == "lbl_Title") { label.MouseDown += LabelMouseDown; label.MouseMove += LabelMouseMove; } } else if (control is Button button) { if (button.Name == "btn_Minimize" || button.Name == "btn_Close" || button.Name == "btn_OpenDlg") { button.BackColor = Color.Transparent; button.BackgroundImageLayout = ImageLayout.Zoom; button.FlatStyle = FlatStyle.Flat; button.FlatAppearance.BorderSize = 0; button.FlatAppearance.MouseOverBackColor = Color.FromArgb(9, 229, 255); button.FlatAppearance.MouseDownBackColor = Color.FromArgb(64, 177, 255); } else { button.BackColor = ColorTranslator.FromHtml("#442A9D"); button.ForeColor = Color.White; button.FlatStyle = FlatStyle.Flat; button.FlatAppearance.BorderColor = Color.FromArgb(0, 0, 0, 0); button.FlatAppearance.BorderSize = 0; button.FlatAppearance.MouseDownBackColor = Color.FromArgb(58, 102, 127); } button.Cursor = Cursors.Hand; } else if (control is DataGridView dataGridStyle) { SetDataGridStyle(dataGridStyle); } else if (control is ComboBox comboBox) { if (comboBox.Name == "cbox_Model") { ComboBox.ObjectCollection items = comboBox.Items; object[] items2 = settings1.Models.Split(','); items.AddRange(items2); comboBox.DropDownStyle = ComboBoxStyle.DropDownList; } else { ComboBox.ObjectCollection items3 = comboBox.Items; object[] items2 = settings1.Field.Split(','); items3.AddRange(items2); comboBox.DropDownStyle = ComboBoxStyle.DropDownList; } comboBox.Validating += ComboBox_Validating; } if (control.HasChildren) { SetControls(control.Controls); } } } private void tabControl1_DrawItem(object sender, DrawItemEventArgs e) { Font font; Brush brush; Brush brush2; if (e.Index == tabControl1.SelectedIndex) { font = new Font(e.Font, FontStyle.Bold); brush = new LinearGradientBrush(e.Bounds, Color.FromArgb(71, 236, 255), Color.FromArgb(0, 150, 255), LinearGradientMode.Vertical); brush2 = new SolidBrush(Color.FromArgb(255, 255, 255)); } else { font = e.Font; brush = new SolidBrush(SystemColors.Control); brush2 = new SolidBrush(Color.DimGray); } string s = tabControl1.TabPages[e.Index].Text; StringFormat stringFormat = new StringFormat(); stringFormat.LineAlignment = StringAlignment.Center; stringFormat.Alignment = StringAlignment.Center; e.Graphics.FillRectangle(brush, e.Bounds); Rectangle bounds = e.Bounds; bounds = new Rectangle(bounds.X, bounds.Y + 4, bounds.Width, bounds.Height - 4); e.Graphics.DrawString(s, font, brush2, bounds, stringFormat); } private void GDIPaint(object sender, PaintEventArgs e) { Label label = sender as Label; Graphics graphics = e.Graphics; Color color = Color.FromArgb(71, 236, 255); Color color2 = Color.FromArgb(64, 177, 255); Color color3 = Color.FromArgb(9, 229, 255); Color color4 = Color.FromArgb(0, 150, 255); Brush brush = new LinearGradientBrush(label.ClientRectangle, color, color2, LinearGradientMode.Vertical); graphics.FillRectangle(brush, label.ClientRectangle); } private void LabelMouseDown(object sender, MouseEventArgs e) { Point = e.Location; } private void LabelMouseMove(object sender, MouseEventArgs e) { if (e.Button == MouseButtons.Left) { base.Location = new Point(base.Location.X + e.X - Point.X, base.Location.Y + e.Y - Point.Y); } } private void textBox_Validated(object sender, EventArgs e) { TextBox textBox = sender as TextBox; ValidatingText(textBox, "此项为必填项"); } private void textBox_Validating(object sender, CancelEventArgs e) { TextBox textBox = sender as TextBox; ValidatingText(textBox, "此项为必填项"); } private void ComboBox_Validated(object sender, EventArgs e) { ComboBox comboBox = sender as ComboBox; ValidatingText(comboBox, "请选择查询字段"); } private void ComboBox_Validating(object sender, CancelEventArgs e) { ComboBox comboBox = sender as ComboBox; ValidatingText(comboBox, "请选择查询字段"); } private void textBox_KeyPress(object sender, KeyPressEventArgs e) { TextBox textBox = sender as TextBox; if (textBox.Name == "txt_StartSN" || textBox.Name == "txt_EndSN" || textBox.Name == "txt_StartDaySN" || textBox.Name == "txt_EndDaySN" || textBox.Name == "txt_MinSpecialSN" || textBox.Name == "txt_MaxSpecialSN" || textBox.Name == "txt_StartDHUIDSN" || textBox.Name == "txt_EndDHUIDSN") { if (char.IsDigit(e.KeyChar) || e.KeyChar == '\b' || char.IsControl(e.KeyChar)) { e.Handled = false; } else { e.Handled = true; } } else if (char.IsLetterOrDigit(e.KeyChar) || char.IsPunctuation(e.KeyChar) || e.KeyChar == '\b' || char.IsControl(e.KeyChar)) { e.Handled = false; } else { e.Handled = true; } e.KeyChar = char.ToUpper(e.KeyChar); } private bool ValidatingText(TextBox textBox, string errorMsg) { if (textBox.Text.Length == 0) { errorProvider1.SetError(textBox, errorMsg); return false; } errorProvider1.SetError(textBox, string.Empty); return true; } private bool ValidatingText(ComboBox comboBox, string errorMsg) { if (comboBox.Text.Length == 0) { errorProvider1.SetError(comboBox, errorMsg); return false; } errorProvider1.SetError(comboBox, string.Empty); return true; } private void SetDataGridColumn(DataGridView dataGrid) { string[] array = new string[23] { "GUID", "Orderid", "Model", "MESSN", "XDSN", "DHUID", "ProductSN", "HW", "SW", "GeelyDU", "GeelyHWSD", "SXBL", "SXDI_SXBL", "ECUDAPN", "ECUCAPN", "HSMKey", "JtagKey", "TEEKey", "Status", "CreateTime", "ModifyTime", "IsPrint", "PrintTime" }; for (int i = 0; i < array.Length; i++) { table.Columns.Add(array[i]); } dataGrid.DataSource = table.DefaultView; } private void SetDataGridStyle(DataGridView dataGrid) { dataGrid.BackgroundColor = Color.White; dataGrid.AllowUserToAddRows = false; dataGrid.AllowUserToDeleteRows = false; dataGrid.AllowUserToOrderColumns = false; dataGrid.AllowUserToResizeColumns = true; dataGrid.AllowUserToResizeRows = false; dataGrid.ReadOnly = true; dataGrid.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; dataGrid.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; dataGrid.RowHeadersWidth = 35; dataGrid.ColumnHeadersHeight = 30; dataGrid.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; foreach (DataGridViewColumn column in dataGrid.Columns) { column.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; column.SortMode = DataGridViewColumnSortMode.Programmatic; } dataGrid.RowPostPaint += dataGridView_RowPostPaint; dataGrid.RowHeadersDefaultCellStyle.Padding = new Padding(dataGridView1.RowHeadersWidth); } private void dataGridView_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e) { DataGridView dataGridView = sender as DataGridView; Rectangle bounds = new Rectangle(e.RowBounds.Location.X, e.RowBounds.Location.Y, dataGridView1.RowHeadersWidth - 1, e.RowBounds.Height); TextRenderer.DrawText(e.Graphics, (e.RowIndex + 1).ToString(), dataGridView.RowHeadersDefaultCellStyle.Font, bounds, dataGridView.RowHeadersDefaultCellStyle.ForeColor, TextFormatFlags.VerticalCenter); List list = new List { e.RowIndex + 1 }; } private void btn_CreateSN_Click(object sender, EventArgs e) { SaveSettings(cbox_Model.Text, iniFile); CreateSN(); } private void CreateSN() { if (table.Rows.Count > 0) { table.Clear(); } try { int num = Convert.ToInt32(txt_StartSN.Text); int num2 = Convert.ToInt32(txt_EndSN.Text); int num3 = Convert.ToInt32(txt_StartDaySN.Text); int num4 = Convert.ToInt32(txt_MinSpecialSN.Text); int num5 = Convert.ToInt32(txt_StartDHUIDSN.Text); int num6 = Convert.ToInt32(txt_Date1.Text.Substring(0, 4)) % 2001; int num7 = Convert.ToInt32(txt_Date1.Text.Substring(4, 2)) - 1; int num8 = Convert.ToInt32(txt_Date1.Text.Substring(6, 2)) - 1; if (Convert.ToInt32(txt_Date1.Text.Substring(0, 4)) < 2020) { MessageBox.Show("生产日期中的年份早于当前年份!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } int num9 = Convert.ToInt32(txt_Date1.Text.Substring(0, 4)) % 2020; GregorianCalendar gregorianCalendar = new GregorianCalendar(); DateTime time = DateTime.ParseExact(txt_Date1.Text, "yyyyMMdd", CultureInfo.CurrentCulture); int weekOfYear = gregorianCalendar.GetWeekOfYear(time, CalendarWeekRule.FirstFullWeek, DayOfWeek.Monday); int num10 = 0; switch (time.DayOfWeek.ToString()) { case "Monday": num10 = 1; break; case "Tuesday": num10 = 2; break; case "Wednesday": num10 = 3; break; case "Thursday": num10 = 4; break; case "Friday": num10 = 5; break; case "Saturday": num10 = 6; break; case "Sunday": num10 = 7; break; } if (txt_StartSN.Text != null && txt_EndSN.Text != null && num <= num2 && txt_EndSN.TextLength < 5) { int num11 = num; int num12 = num3; int num13 = num4; int num14 = num5; while (num11 <= num2) { DataRow dataRow = table.NewRow(); if (num12.ToString().Length < 5 && num13.ToString().Length < 8 && num14.ToString().Length < 5) { string text = txt_PCODE.Text.Trim() + years[num6] + num13.ToString().PadLeft(7, '0'); string text2 = HashPlus.GetHashMD5(text).ToUpper(); text2 = text2.Substring(0, 8) + "-" + text2.Substring(8, 4) + "-" + text2.Substring(12, 4) + "-" + text2.Substring(16, 4) + "-" + text2.Substring(20, 12); string text3 = txt_SNPrefix.Text + num11.ToString().PadLeft(4, '0'); string text4 = txt_PCODE.Text + txt_MachineCode.Text + txt_FactoryCode.Text + txt_LineNo1.Text + years[num6] + months[num7] + days[num8] + num12.ToString().PadLeft(4, '0') + num13.ToString().PadLeft(7, '0'); string text5 = txt_VendorCode.Text + txt_PN.Text + years[num6] + months[num7] + days[num8] + txt_ShiftsNo.Text + num14.ToString().PadLeft(4, '0'); string empty = string.Empty; empty = F18CY[num9] + weekOfYear.ToString().PadLeft(2, '0') + num10 + num12.ToString().PadLeft(4, '0'); if (text3.Length != 14 && text4.Length != 24 && text5.Length != 24) { MessageBox.Show("MESSN / XDSN / DHUID长度有误,请检查输入的数据是否有误!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } dataRow["GUID"] = text2; dataRow["Orderid"] = tbx_OrderID.Text.Trim(); dataRow["Model"] = cbox_Model.Text.Trim(); dataRow["MESSN"] = text3.Trim(); dataRow["XDSN"] = text4.Trim(); dataRow["DHUID"] = text5.Trim(); dataRow["ProductSN"] = empty.Trim(); dataRow["HW"] = txt_HW.Text.PadRight(16, '0').Trim(); dataRow["SW"] = txt_SW.Text.Trim(); dataRow["SXBL"] = txt_SXBL.Text.Trim(); dataRow["SXDI_SXBL"] = txt_SXDISXBL.Text.Trim(); dataRow["GeelyDU"] = txt_GeelyDU.Text.Trim(); dataRow["GeelyHWSD"] = txt_GeelyHWSD.Text.Trim(); dataRow["ECUDAPN"] = txt_VolvoDU.Text.Trim(); dataRow["ECUCAPN"] = txt_VolvoHWSD.Text.Trim(); dataRow["Status"] = 0; dataRow["CreateTime"] = Convert.ToDateTime(DateTime.Now.ToString("G")); table.Rows.Add(dataRow); num11++; num12++; num13++; num14++; continue; } MessageBox.Show("日流水号或连续号位数超出范围", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); break; } dataGridView1.DataSource = table.DefaultView; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; toolStripStatusLabel8.Text = $"{table.Rows.Count}行"; } else { MessageBox.Show("请检查所有文本框是否有填写,并确认SN的流水号及位数是否有误", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } catch (Exception ex) { MessageBox.Show(ex.Message, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } private void btn_ImportData_Click(object sender, EventArgs e) { ImportData(); } private void ImportData() { //if (MessageBox.Show("确认是否导入数据库?", "消息提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes) //{ // return; //} //if (table.Rows.Count != 0) //{ // PwdForm pwdForm = new PwdForm(); // if (pwdForm.ShowDialog() != DialogResult.OK) // { // return; // } // using (SqlConnection sqlConnection = new SqlConnection(settings1.DBConn)) // { // try // { // sqlConnection.Open(); // SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(sqlConnection); // sqlBulkCopy.DestinationTableName = "SNDTL"; // sqlBulkCopy.WriteToServer(table); // sqlBulkCopy.Close(); // MessageBox.Show("数据导入成功!", "消息提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); // return; // } // catch (SqlException ex) // { // throw new Exception(ex.Message); // } // finally // { // sqlConnection.Close(); // } // } //} MessageBox.Show("数据为空,导入失败,请生成序列号后再导入!", "消息提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); } private void btn_ClearText_Click(object sender, EventArgs e) { ClearText(base.Controls); } private void ClearText(Control.ControlCollection controls) { foreach (Control control in controls) { if (control is TextBox textBox) { textBox.ResetText(); } if (control.HasChildren) { ClearText(control.Controls); } } } private void btn_Mininimze_Click(object sender, EventArgs e) { base.WindowState = FormWindowState.Minimized; } private void btn_Close_Click(object sender, EventArgs e) { Close(); } private void MainForm_Paint(object sender, PaintEventArgs e) { Graphics graphics = e.Graphics; Color color = Color.FromArgb(71, 236, 255); Color color2 = Color.FromArgb(64, 177, 255); Color color3 = Color.FromArgb(9, 229, 255); Color color4 = Color.FromArgb(0, 150, 255); Brush brush = new LinearGradientBrush(base.ClientRectangle, color, color2, LinearGradientMode.Vertical); graphics.FillRectangle(brush, base.ClientRectangle); } private void Timer(System.Timers.Timer t, Action action) { t.Elapsed += action.Invoke; t.AutoReset = true; t.Enabled = true; } private void Realtime(object sender, EventArgs e) { timer.Interval = 1000.0; toolStripStatusLabel6.Text = "系统时间:" + DateTime.Now.ToString("G"); timer.Enabled = true; } private void cbx_Field_SelectedIndexChanged(object sender, EventArgs e) { if (cbox_Field.Text.Equals("最大连续号")) { tbx_content.Visible = false; btn_Query_Click(sender, e); } else { tbx_content.Visible = true; } } private void btn_Query_Click(object sender, EventArgs e) { if (cbox_Field.Text.Equals("最大连续号")) { using (SqlConnection sqlConnection = new SqlConnection(settings1.DBConn)) { string empty = string.Empty; string text = cbox_Field.Text; string text2 = text; if (text2 == "最大连续号") { empty = "Subtring(XDSN,0,7)Substring(XDSN,11,1)Right(XDSN,7)"; } string text3 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE 'SHU1011%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE1"; string text4 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE 'SHU104S%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE2"; string text5 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE 'SHU206S%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE3"; string text6 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE '02647G1%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE4"; string text7 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE '02647G2%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE5"; string text8 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE '02648G3%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE6"; string text9 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE '02648G1%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE7"; string text10 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE '02648G2%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE8"; string text11 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE '02601P3%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLE9"; string text12 = "select * FROM (select TOP(1) * FROM DBO.SNDTL WHERE XDSN LIKE 'DHU057L%' ORDER BY SUBSTRING(XDSN,0,7)+SUBSTRING(XDSN,11,1)+RIGHT(XDSN,7) DESC) AS TABLEA"; string cmdText = text3 + "\r\nUNION\r\n" + text4 + "\r\nUNION\r\n" + text5 + "\r\nUNION\r\n" + text6 + "\r\nUNION\r\n" + text7 + "\r\nUNION\r\n" + text8 + "\r\nUNION\r\n" + text9 + "\r\nUNION\r\n" + text10 + "\r\nUNION\r\n" + text11 + "\r\nUNION\r\n" + text12; using (SqlCommand selectCommand = new SqlCommand(cmdText, sqlConnection)) { sqlConnection.Open(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(selectCommand); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet); dataGridView2.DataSource = dataSet.Tables[0]; dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; toolStripStatusLabel8.Text = $"{dataSet.Tables[0].Rows.Count}行"; sqlDataAdapter.Dispose(); dataSet.Dispose(); sqlConnection.Close(); return; } } } if (!ValidatingText(cbox_Field, "请选择查询字段") || !ValidatingText(tbx_content, "请输入查询内容")) { return; } using (SqlConnection sqlConnection2 = new SqlConnection(settings1.DBConn)) { string text13 = string.Empty; switch (cbox_Field.Text) { case "工单号": text13 = "orderid"; break; case "机型": text13 = "Model"; break; case "过站码": text13 = "MESSN"; break; case "XDSN": text13 = "XDSN"; break; case "DHUID": text13 = "DHUID"; break; case "GeelyDU": text13 = "DU"; break; case "硬件版本": text13 = "HW"; break; case "软件版本": text13 = "SW"; break; case "JtagKey": text13 = "JtagKey"; break; } string cmdText2 = "select * from [dbo].[SNDTL] where " + text13 + " like @value"; using (SqlCommand sqlCommand = new SqlCommand(cmdText2, sqlConnection2)) { sqlCommand.Parameters.AddWithValue("@value", "%" + tbx_content.Text + "%"); sqlConnection2.Open(); SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter(sqlCommand); DataSet dataSet2 = new DataSet(); sqlDataAdapter2.Fill(dataSet2); dataGridView2.DataSource = dataSet2.Tables[0]; dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; toolStripStatusLabel8.Text = $"{dataSet2.Tables[0].Rows.Count}行"; sqlDataAdapter2.Dispose(); dataSet2.Dispose(); sqlConnection2.Close(); } } } private void tbx_content_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == '\r') { btn_Query_Click(sender, e); } } private void btn_Modify_Click(object sender, EventArgs e) { MessageBox.Show("此功能暂未开放!", "Tips:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } private void btn_Delete_Click(object sender, EventArgs e) { MessageBox.Show("此功能暂未开放!", "Tips:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } private void tabControl1_SelectedIndexChanged(object sender, EventArgs e) { ShowDataGridRows(base.Controls); } private void ShowDataGridRows(Control.ControlCollection controls) { foreach (Control control in controls) { if (control is DataGridView dataGridView) { toolStripStatusLabel8.Text = $"{dataGridView.Rows}行"; } if (control.HasChildren) { ShowDataGridRows(control.Controls); } } } private void cbx_Model_SelectedIndexChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(fileNameWithoutExt)) { string file = Path.Combine(Environment.CurrentDirectory, "Config", fileNameWithoutExt + ".ini"); settings2 = new UserSettings(cbox_Model.Text, file); } else { settings2 = new UserSettings(cbox_Model.Text, iniFile); } GetVal(); Commonparams(cbox_Model.Text); } private void Commonparams(string model) { switch (model) { case "E371-H-CN": txt_SNPrefix.Text = $"002101G1{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU1011"; break; case "E371-L-CN": txt_SNPrefix.Text = $"002101G2{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU1011"; break; case "HY11-H-CN": txt_SNPrefix.Text = $"002104S1{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU104S"; break; case "HY11-L-CN": txt_SNPrefix.Text = $"002104S2{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU104S"; break; case "HS11-H-CN": txt_SNPrefix.Text = $"002104S3{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU104S"; break; case "HS11-L-CN": txt_SNPrefix.Text = $"002104S4{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU104S"; break; case "HY11-H-EU": txt_SNPrefix.Text = $"002206S1{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU206S"; break; case "HY11-L-EU": txt_SNPrefix.Text = $"002206S2{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU206S"; break; case "HS11-H-EU": txt_SNPrefix.Text = $"002206S3{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU206S"; break; case "HS11-L-EU": txt_SNPrefix.Text = $"002206S4{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "SHU206S"; break; case "E245-H-CN": txt_SNPrefix.Text = $"002647G1{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "02647G1"; break; case "E245-L-CN": txt_SNPrefix.Text = $"002647G2{DateTime.Now:yyMMdd}"; txt_PCODE.Text = "02647G2"; break; } if (model.Contains("E245")) { txt_MachineCode.Text = "0"; txt_FactoryCode.Text = "D"; txt_LineNo1.Text = "9"; txt_VendorCode.Text = "999722"; txt_ShiftsNo.Text = "0"; } else { txt_MachineCode.Text = "0"; txt_FactoryCode.Text = "D"; txt_LineNo1.Text = "1"; txt_VendorCode.Text = "999722"; txt_ShiftsNo.Text = "A"; } } private void txt_StartSN_TextChanged(object sender, EventArgs e) { TextBox textBox = txt_StartDHUIDSN; string text2 = (txt_StartDaySN.Text = txt_StartSN.Text); textBox.Text = text2; } private void txt_StartDaySN_TextChanged(object sender, EventArgs e) { txt_StartDHUIDSN.Text = txt_StartDaySN.Text; } private void txt_Date1_TextChanged(object sender, EventArgs e) { txt_Date2.Text = txt_Date1.Text; } private void txt_GeelyDU_TextChanged(object sender, EventArgs e) { txt_PN.Text = txt_GeelyDU.Text.Split('/')[0]; } private void GetVal() { tbx_OrderID.Text = settings2.OrderId; cbox_Model.SelectedItem = settings2.Model; txt_SNPrefix.Text = settings2.SNPrefix; txt_StartSN.Text = settings2.MESSstartSN; txt_EndSN.Text = settings2.MESEndSN; txt_Date1.Text = settings2.XDSNDate; txt_StartDaySN.Text = settings2.XDSNDaySN; txt_MinSpecialSN.Text = settings2.XDSNSpecialSN; txt_PN.Text = settings2.PartNo; txt_HW.Text = settings2.HW; txt_SW.Text = settings2.SW; txt_GeelyDU.Text = settings2.GeelyDU; txt_GeelyHWSD.Text = settings2.GeelyHWSD; txt_SXBL.Text = settings2.SXBL; txt_SXDISXBL.Text = settings2.SXDISXBL; txt_VolvoDU.Text = settings2.VolvoDU; txt_VolvoHWSD.Text = settings2.VolvoHWSD; } private void SaveSettings(string file) { if (!File.Exists(file)) { MessageBox.Show("配置文件不存在,保存失败", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } WritePrivateProfileString("Settings", "OrderId", tbx_OrderID.Text, file); WritePrivateProfileString("Settings", "PartNo", txt_PN.Text, file); WritePrivateProfileString("Settings", "HW", txt_HW.Text, file); WritePrivateProfileString("Settings", "SW", txt_SW.Text, file); WritePrivateProfileString("Settings", "GeelyDU", txt_GeelyDU.Text, file); WritePrivateProfileString("Settings", "GeelyHWSD", txt_GeelyHWSD.Text, file); WritePrivateProfileString("Settings", "SXBL", txt_SXBL.Text, file); WritePrivateProfileString("Settings", "SXDISXBL", txt_SXDISXBL.Text, file); WritePrivateProfileString("Settings", "VolvoDU", txt_VolvoDU.Text, file); WritePrivateProfileString("Settings", "VolvoHWSD", txt_VolvoHWSD.Text, file); } private void SaveSettings(string section, string file) { if (!File.Exists(file)) { MessageBox.Show("配置文件不存在,保存失败", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } WritePrivateProfileString(section, "OrderId", tbx_OrderID.Text, file); WritePrivateProfileString(section, "SNPrefix", txt_SNPrefix.Text, file); WritePrivateProfileString(section, "MESStartSN", txt_StartSN.Text, file); WritePrivateProfileString(section, "MESEndSN", txt_EndSN.Text, file); WritePrivateProfileString(section, "XDSNDate", txt_Date1.Text, file); WritePrivateProfileString(section, "XDSNDaySN", txt_StartDaySN.Text, file); WritePrivateProfileString(section, "XDSNSpecialSN", txt_MinSpecialSN.Text, file); WritePrivateProfileString(section, "PartNo", txt_PN.Text, file); WritePrivateProfileString(section, "HW", txt_HW.Text, file); WritePrivateProfileString(section, "SW", txt_SW.Text, file); WritePrivateProfileString(section, "GeelyDU", txt_GeelyDU.Text, file); WritePrivateProfileString(section, "GeelyHWSD", txt_GeelyHWSD.Text, file); WritePrivateProfileString(section, "SXBL", txt_SXBL.Text, file); WritePrivateProfileString(section, "SXDISXBL", txt_SXDISXBL.Text, file); WritePrivateProfileString(section, "VolvoDU", txt_VolvoDU.Text, file); WritePrivateProfileString(section, "VolvoHWSD", txt_VolvoHWSD.Text, file); } private void btn_OpenDlg_Click(object sender, EventArgs e) { cbox_Model.SelectedIndexChanged -= cbx_Model_SelectedIndexChanged; OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.InitialDirectory = Path.Combine(Application.StartupPath, "Config"); openFileDialog.Filter = "INI文件(*.ini)|*.ini|所有文件(*.*)|*.*"; openFileDialog.Multiselect = false; if (openFileDialog.ShowDialog() == DialogResult.OK) { fileNameWithoutExt = Path.GetFileNameWithoutExtension(openFileDialog.FileName); tbx_OrderID.Text = fileNameWithoutExt; string file = Path.Combine(Environment.CurrentDirectory, "Config", fileNameWithoutExt + ".ini"); settings2 = new UserSettings("Config", file); GetVal(); Commonparams(cbox_Model.Text); } else { openFileDialog.Dispose(); } cbox_Model.SelectedIndexChanged += cbx_Model_SelectedIndexChanged; fileNameWithoutExt = string.Empty; } private void btn_Export_Click(object sender, EventArgs e) { if (dataGridView2.DataSource != null) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Excel 97-2003工作簿|*.xls"; DialogResult dialogResult = saveFileDialog.ShowDialog(); if (dialogResult == DialogResult.OK) { progressBar.Value = 0; progressBar.Minimum = 0; progressBar.Maximum = ((DataTable)dataGridView2.DataSource).Rows.Count; string fileName = saveFileDialog.FileName; //if (nPOIHelper.ExportExcel((DataTable)dataGridView2.DataSource, "导出数据", fileName, progressBar)) //{ // MessageBox.Show("数据导出完成!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); // return; //} MessageBox.Show("数据导出失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand); progressBar.Value = 0; } } else { MessageBox.Show("未发现数据,导出失败!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } protected override void Dispose(bool disposing) { if (disposing && components != null) { components.Dispose(); } base.Dispose(disposing); } private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.BottomToolStripPanel = new System.Windows.Forms.ToolStripPanel(); this.TopToolStripPanel = new System.Windows.Forms.ToolStripPanel(); this.RightToolStripPanel = new System.Windows.Forms.ToolStripPanel(); this.LeftToolStripPanel = new System.Windows.Forms.ToolStripPanel(); this.ContentPanel = new System.Windows.Forms.ToolStripContentPanel(); this.tabControl1 = new System.Windows.Forms.TabControl(); this.tabPage1 = new System.Windows.Forms.TabPage(); this.dataGridView1 = new System.Windows.Forms.DataGridView(); this.panel1 = new System.Windows.Forms.Panel(); this.groupBox4 = new System.Windows.Forms.GroupBox(); this.txt_SXBL = new System.Windows.Forms.TextBox(); this.label29 = new System.Windows.Forms.Label(); this.txt_SXDISXBL = new System.Windows.Forms.TextBox(); this.label30 = new System.Windows.Forms.Label(); this.btn_ClearText = new System.Windows.Forms.Button(); this.txt_GeelyHWSD = new System.Windows.Forms.TextBox(); this.label21 = new System.Windows.Forms.Label(); this.btn_ImportData = new System.Windows.Forms.Button(); this.txt_SW = new System.Windows.Forms.TextBox(); this.label25 = new System.Windows.Forms.Label(); this.btn_CreateSN = new System.Windows.Forms.Button(); this.txt_VolvoDU = new System.Windows.Forms.TextBox(); this.txt_VolvoHWSD = new System.Windows.Forms.TextBox(); this.label23 = new System.Windows.Forms.Label(); this.label24 = new System.Windows.Forms.Label(); this.txt_GeelyDU = new System.Windows.Forms.TextBox(); this.label22 = new System.Windows.Forms.Label(); this.txt_HW = new System.Windows.Forms.TextBox(); this.label20 = new System.Windows.Forms.Label(); this.groupBox3 = new System.Windows.Forms.GroupBox(); this.txt_EndDHUIDSN = new System.Windows.Forms.TextBox(); this.label19 = new System.Windows.Forms.Label(); this.txt_StartDHUIDSN = new System.Windows.Forms.TextBox(); this.label11 = new System.Windows.Forms.Label(); this.txt_ShiftsNo = new System.Windows.Forms.TextBox(); this.label12 = new System.Windows.Forms.Label(); this.txt_Date2 = new System.Windows.Forms.TextBox(); this.label13 = new System.Windows.Forms.Label(); this.txt_PN = new System.Windows.Forms.TextBox(); this.label14 = new System.Windows.Forms.Label(); this.txt_VendorCode = new System.Windows.Forms.TextBox(); this.label15 = new System.Windows.Forms.Label(); this.groupBox2 = new System.Windows.Forms.GroupBox(); this.txt_MachineCode = new System.Windows.Forms.TextBox(); this.label16 = new System.Windows.Forms.Label(); this.txt_MaxSpecialSN = new System.Windows.Forms.TextBox(); this.label18 = new System.Windows.Forms.Label(); this.label17 = new System.Windows.Forms.Label(); this.txt_EndDaySN = new System.Windows.Forms.TextBox(); this.txt_MinSpecialSN = new System.Windows.Forms.TextBox(); this.label10 = new System.Windows.Forms.Label(); this.txt_StartDaySN = new System.Windows.Forms.TextBox(); this.label9 = new System.Windows.Forms.Label(); this.txt_Date1 = new System.Windows.Forms.TextBox(); this.label8 = new System.Windows.Forms.Label(); this.txt_FactoryCode = new System.Windows.Forms.TextBox(); this.label4 = new System.Windows.Forms.Label(); this.txt_PCODE = new System.Windows.Forms.TextBox(); this.txt_LineNo1 = new System.Windows.Forms.TextBox(); this.label5 = new System.Windows.Forms.Label(); this.label6 = new System.Windows.Forms.Label(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.tbx_OrderID = new System.Windows.Forms.TextBox(); this.btn_OpenDlg = new System.Windows.Forms.Button(); this.cbox_Model = new System.Windows.Forms.ComboBox(); this.label26 = new System.Windows.Forms.Label(); this.label3 = new System.Windows.Forms.Label(); this.label7 = new System.Windows.Forms.Label(); this.txt_EndSN = new System.Windows.Forms.TextBox(); this.txt_StartSN = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.txt_SNPrefix = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.tabPage2 = new System.Windows.Forms.TabPage(); this.dataGridView2 = new System.Windows.Forms.DataGridView(); this.panel2 = new System.Windows.Forms.Panel(); this.btn_Export = new System.Windows.Forms.Button(); this.tbx_content = new System.Windows.Forms.TextBox(); this.cbox_Field = new System.Windows.Forms.ComboBox(); this.btn_Delete = new System.Windows.Forms.Button(); this.btn_Modify = new System.Windows.Forms.Button(); this.btn_Query = new System.Windows.Forms.Button(); this.label28 = new System.Windows.Forms.Label(); this.label27 = new System.Windows.Forms.Label(); this.statusStrip1 = new System.Windows.Forms.StatusStrip(); this.toolStripStatusLabel1 = new System.Windows.Forms.ToolStripStatusLabel(); this.toolStripStatusLabel2 = new System.Windows.Forms.ToolStripStatusLabel(); this.toolStripStatusLabel3 = new System.Windows.Forms.ToolStripStatusLabel(); this.toolStripStatusLabel4 = new System.Windows.Forms.ToolStripStatusLabel(); this.toolStripStatusLabel5 = new System.Windows.Forms.ToolStripStatusLabel(); this.toolStripStatusLabel6 = new System.Windows.Forms.ToolStripStatusLabel(); this.toolStripStatusLabel7 = new System.Windows.Forms.ToolStripStatusLabel(); this.toolStripStatusLabel8 = new System.Windows.Forms.ToolStripStatusLabel(); this.toolTip1 = new System.Windows.Forms.ToolTip(this.components); this.errorProvider1 = new System.Windows.Forms.ErrorProvider(this.components); this.lbl_Title = new System.Windows.Forms.Label(); this.btn_Close = new System.Windows.Forms.Button(); this.btn_Minimize = new System.Windows.Forms.Button(); this.tabControl1.SuspendLayout(); this.tabPage1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)this.dataGridView1).BeginInit(); this.panel1.SuspendLayout(); this.groupBox4.SuspendLayout(); this.groupBox3.SuspendLayout(); this.groupBox2.SuspendLayout(); this.groupBox1.SuspendLayout(); this.tabPage2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)this.dataGridView2).BeginInit(); this.panel2.SuspendLayout(); this.statusStrip1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)this.errorProvider1).BeginInit(); base.SuspendLayout(); this.BottomToolStripPanel.Location = new System.Drawing.Point(0, 0); this.BottomToolStripPanel.Name = "BottomToolStripPanel"; this.BottomToolStripPanel.Orientation = System.Windows.Forms.Orientation.Horizontal; this.BottomToolStripPanel.RowMargin = new System.Windows.Forms.Padding(3, 0, 0, 0); this.BottomToolStripPanel.Size = new System.Drawing.Size(0, 0); this.TopToolStripPanel.Location = new System.Drawing.Point(0, 0); this.TopToolStripPanel.Name = "TopToolStripPanel"; this.TopToolStripPanel.Orientation = System.Windows.Forms.Orientation.Horizontal; this.TopToolStripPanel.RowMargin = new System.Windows.Forms.Padding(3, 0, 0, 0); this.TopToolStripPanel.Size = new System.Drawing.Size(0, 0); this.RightToolStripPanel.Location = new System.Drawing.Point(0, 0); this.RightToolStripPanel.Name = "RightToolStripPanel"; this.RightToolStripPanel.Orientation = System.Windows.Forms.Orientation.Horizontal; this.RightToolStripPanel.RowMargin = new System.Windows.Forms.Padding(3, 0, 0, 0); this.RightToolStripPanel.Size = new System.Drawing.Size(0, 0); this.LeftToolStripPanel.Location = new System.Drawing.Point(0, 0); this.LeftToolStripPanel.Name = "LeftToolStripPanel"; this.LeftToolStripPanel.Orientation = System.Windows.Forms.Orientation.Horizontal; this.LeftToolStripPanel.RowMargin = new System.Windows.Forms.Padding(3, 0, 0, 0); this.LeftToolStripPanel.Size = new System.Drawing.Size(0, 0); this.ContentPanel.AutoScroll = true; this.ContentPanel.Size = new System.Drawing.Size(1578, 819); this.tabControl1.Controls.Add(this.tabPage1); this.tabControl1.Controls.Add(this.tabPage2); this.tabControl1.Location = new System.Drawing.Point(0, 81); this.tabControl1.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.tabControl1.Name = "tabControl1"; this.tabControl1.SelectedIndex = 0; this.tabControl1.Size = new System.Drawing.Size(1902, 925); this.tabControl1.TabIndex = 1; this.tabControl1.SelectedIndexChanged += new System.EventHandler(tabControl1_SelectedIndexChanged); this.tabPage1.Controls.Add(this.dataGridView1); this.tabPage1.Controls.Add(this.panel1); this.tabPage1.Location = new System.Drawing.Point(4, 25); this.tabPage1.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.tabPage1.Name = "tabPage1"; this.tabPage1.Padding = new System.Windows.Forms.Padding(3, 2, 3, 2); this.tabPage1.Size = new System.Drawing.Size(1894, 896); this.tabPage1.TabIndex = 0; this.tabPage1.Text = "创建号码◢"; this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView1.Location = new System.Drawing.Point(5, 298); this.dataGridView1.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.dataGridView1.Name = "dataGridView1"; this.dataGridView1.RowHeadersWidth = 51; this.dataGridView1.RowTemplate.Height = 30; this.dataGridView1.Size = new System.Drawing.Size(1886, 594); this.dataGridView1.TabIndex = 0; this.panel1.Controls.Add(this.groupBox4); this.panel1.Controls.Add(this.groupBox3); this.panel1.Controls.Add(this.groupBox2); this.panel1.Controls.Add(this.groupBox1); this.panel1.Location = new System.Drawing.Point(5, 5); this.panel1.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(1886, 289); this.panel1.TabIndex = 0; this.groupBox4.Controls.Add(this.txt_SXBL); this.groupBox4.Controls.Add(this.label29); this.groupBox4.Controls.Add(this.txt_SXDISXBL); this.groupBox4.Controls.Add(this.label30); this.groupBox4.Controls.Add(this.btn_ClearText); this.groupBox4.Controls.Add(this.txt_GeelyHWSD); this.groupBox4.Controls.Add(this.label21); this.groupBox4.Controls.Add(this.btn_ImportData); this.groupBox4.Controls.Add(this.txt_SW); this.groupBox4.Controls.Add(this.label25); this.groupBox4.Controls.Add(this.btn_CreateSN); this.groupBox4.Controls.Add(this.txt_VolvoDU); this.groupBox4.Controls.Add(this.txt_VolvoHWSD); this.groupBox4.Controls.Add(this.label23); this.groupBox4.Controls.Add(this.label24); this.groupBox4.Controls.Add(this.txt_GeelyDU); this.groupBox4.Controls.Add(this.label22); this.groupBox4.Controls.Add(this.txt_HW); this.groupBox4.Controls.Add(this.label20); this.groupBox4.Location = new System.Drawing.Point(5, 183); this.groupBox4.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.groupBox4.Name = "groupBox4"; this.groupBox4.Padding = new System.Windows.Forms.Padding(3, 2, 3, 2); this.groupBox4.Size = new System.Drawing.Size(1876, 100); this.groupBox4.TabIndex = 21; this.groupBox4.TabStop = false; this.groupBox4.Text = "版本信息"; this.txt_SXBL.Location = new System.Drawing.Point(800, 22); this.txt_SXBL.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_SXBL.Name = "txt_SXBL"; this.txt_SXBL.Size = new System.Drawing.Size(202, 25); this.txt_SXBL.TabIndex = 29; this.label29.AutoSize = true; this.label29.Location = new System.Drawing.Point(755, 27); this.label29.Name = "label29"; this.label29.Size = new System.Drawing.Size(39, 15); this.label29.TabIndex = 31; this.label29.Text = "SXBL"; this.txt_SXDISXBL.Location = new System.Drawing.Point(801, 63); this.txt_SXDISXBL.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_SXDISXBL.Name = "txt_SXDISXBL"; this.txt_SXDISXBL.Size = new System.Drawing.Size(201, 25); this.txt_SXDISXBL.TabIndex = 28; this.label30.AutoSize = true; this.label30.Location = new System.Drawing.Point(716, 68); this.label30.Name = "label30"; this.label30.Size = new System.Drawing.Size(79, 15); this.label30.TabIndex = 30; this.label30.Text = "SXDI_SXBL"; this.btn_ClearText.Location = new System.Drawing.Point(1751, 41); this.btn_ClearText.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.btn_ClearText.Name = "btn_ClearText"; this.btn_ClearText.Size = new System.Drawing.Size(110, 47); this.btn_ClearText.TabIndex = 8; this.btn_ClearText.Text = "清空内容"; this.btn_ClearText.UseVisualStyleBackColor = true; this.btn_ClearText.Click += new System.EventHandler(btn_ClearText_Click); this.txt_GeelyHWSD.Location = new System.Drawing.Point(444, 63); this.txt_GeelyHWSD.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_GeelyHWSD.Name = "txt_GeelyHWSD"; this.txt_GeelyHWSD.Size = new System.Drawing.Size(201, 25); this.txt_GeelyHWSD.TabIndex = 2; this.label21.AutoSize = true; this.label21.Location = new System.Drawing.Point(351, 68); this.label21.Name = "label21"; this.label21.Size = new System.Drawing.Size(87, 15); this.label21.TabIndex = 19; this.label21.Text = "Geely HWSD"; this.btn_ImportData.Location = new System.Drawing.Point(1622, 41); this.btn_ImportData.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.btn_ImportData.Name = "btn_ImportData"; this.btn_ImportData.Size = new System.Drawing.Size(110, 47); this.btn_ImportData.TabIndex = 7; this.btn_ImportData.Text = "导入数据库"; this.btn_ImportData.UseVisualStyleBackColor = true; this.btn_ImportData.Click += new System.EventHandler(btn_ImportData_Click); this.txt_SW.Location = new System.Drawing.Point(89, 63); this.txt_SW.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_SW.Name = "txt_SW"; this.txt_SW.Size = new System.Drawing.Size(236, 25); this.txt_SW.TabIndex = 1; this.label25.AutoSize = true; this.label25.Location = new System.Drawing.Point(16, 68); this.label25.Name = "label25"; this.label25.Size = new System.Drawing.Size(67, 15); this.label25.TabIndex = 27; this.label25.Text = "软件版本"; this.btn_CreateSN.Location = new System.Drawing.Point(1490, 41); this.btn_CreateSN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.btn_CreateSN.Name = "btn_CreateSN"; this.btn_CreateSN.Size = new System.Drawing.Size(110, 47); this.btn_CreateSN.TabIndex = 6; this.btn_CreateSN.Text = "生成序列号"; this.btn_CreateSN.UseVisualStyleBackColor = true; this.btn_CreateSN.Click += new System.EventHandler(btn_CreateSN_Click); this.txt_VolvoDU.Location = new System.Drawing.Point(1155, 22); this.txt_VolvoDU.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_VolvoDU.Name = "txt_VolvoDU"; this.txt_VolvoDU.Size = new System.Drawing.Size(202, 25); this.txt_VolvoDU.TabIndex = 5; this.txt_VolvoHWSD.Location = new System.Drawing.Point(1155, 63); this.txt_VolvoHWSD.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_VolvoHWSD.Name = "txt_VolvoHWSD"; this.txt_VolvoHWSD.Size = new System.Drawing.Size(202, 25); this.txt_VolvoHWSD.TabIndex = 4; this.label23.AutoSize = true; this.label23.Location = new System.Drawing.Point(1062, 68); this.label23.Name = "label23"; this.label23.Size = new System.Drawing.Size(87, 15); this.label23.TabIndex = 23; this.label23.Text = "Volvo HWSD"; this.label24.AutoSize = true; this.label24.Location = new System.Drawing.Point(1062, 27); this.label24.Name = "label24"; this.label24.Size = new System.Drawing.Size(71, 15); this.label24.TabIndex = 25; this.label24.Text = "Volvo DU"; this.txt_GeelyDU.Location = new System.Drawing.Point(443, 22); this.txt_GeelyDU.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_GeelyDU.Name = "txt_GeelyDU"; this.txt_GeelyDU.Size = new System.Drawing.Size(202, 25); this.txt_GeelyDU.TabIndex = 3; this.txt_GeelyDU.TextChanged += new System.EventHandler(txt_GeelyDU_TextChanged); this.label22.AutoSize = true; this.label22.Location = new System.Drawing.Point(366, 27); this.label22.Name = "label22"; this.label22.Size = new System.Drawing.Size(71, 15); this.label22.TabIndex = 21; this.label22.Text = "Geely DU"; this.txt_HW.Location = new System.Drawing.Point(89, 22); this.txt_HW.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_HW.Name = "txt_HW"; this.txt_HW.Size = new System.Drawing.Size(236, 25); this.txt_HW.TabIndex = 0; this.label20.AutoSize = true; this.label20.Location = new System.Drawing.Point(16, 27); this.label20.Name = "label20"; this.label20.Size = new System.Drawing.Size(67, 15); this.label20.TabIndex = 17; this.label20.Text = "硬件版本"; this.groupBox3.Controls.Add(this.txt_EndDHUIDSN); this.groupBox3.Controls.Add(this.label19); this.groupBox3.Controls.Add(this.txt_StartDHUIDSN); this.groupBox3.Controls.Add(this.label11); this.groupBox3.Controls.Add(this.txt_ShiftsNo); this.groupBox3.Controls.Add(this.label12); this.groupBox3.Controls.Add(this.txt_Date2); this.groupBox3.Controls.Add(this.label13); this.groupBox3.Controls.Add(this.txt_PN); this.groupBox3.Controls.Add(this.label14); this.groupBox3.Controls.Add(this.txt_VendorCode); this.groupBox3.Controls.Add(this.label15); this.groupBox3.Location = new System.Drawing.Point(5, 119); this.groupBox3.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.groupBox3.Name = "groupBox3"; this.groupBox3.Padding = new System.Windows.Forms.Padding(3, 2, 3, 2); this.groupBox3.Size = new System.Drawing.Size(1876, 59); this.groupBox3.TabIndex = 12; this.groupBox3.TabStop = false; this.groupBox3.Text = "DHUID"; this.txt_EndDHUIDSN.Location = new System.Drawing.Point(1147, 22); this.txt_EndDHUIDSN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_EndDHUIDSN.Name = "txt_EndDHUIDSN"; this.txt_EndDHUIDSN.Size = new System.Drawing.Size(84, 25); this.txt_EndDHUIDSN.TabIndex = 5; this.label19.AutoSize = true; this.label19.Location = new System.Drawing.Point(1119, 27); this.label19.Name = "label19"; this.label19.Size = new System.Drawing.Size(22, 15); this.label19.TabIndex = 15; this.label19.Text = "到"; this.txt_StartDHUIDSN.Location = new System.Drawing.Point(1032, 22); this.txt_StartDHUIDSN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_StartDHUIDSN.Name = "txt_StartDHUIDSN"; this.txt_StartDHUIDSN.Size = new System.Drawing.Size(82, 25); this.txt_StartDHUIDSN.TabIndex = 4; this.label11.AutoSize = true; this.label11.Location = new System.Drawing.Point(940, 27); this.label11.Name = "label11"; this.label11.Size = new System.Drawing.Size(82, 15); this.label11.TabIndex = 10; this.label11.Text = "生产流水号"; this.txt_ShiftsNo.Location = new System.Drawing.Point(848, 22); this.txt_ShiftsNo.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_ShiftsNo.Name = "txt_ShiftsNo"; this.txt_ShiftsNo.Size = new System.Drawing.Size(69, 25); this.txt_ShiftsNo.TabIndex = 3; this.label12.AutoSize = true; this.label12.Location = new System.Drawing.Point(756, 27); this.label12.Name = "label12"; this.label12.Size = new System.Drawing.Size(82, 15); this.label12.TabIndex = 8; this.label12.Text = "生产班次号"; this.txt_Date2.Location = new System.Drawing.Point(632, 22); this.txt_Date2.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_Date2.Name = "txt_Date2"; this.txt_Date2.Size = new System.Drawing.Size(104, 25); this.txt_Date2.TabIndex = 2; this.label13.AutoSize = true; this.label13.Location = new System.Drawing.Point(556, 27); this.label13.Name = "label13"; this.label13.Size = new System.Drawing.Size(67, 15); this.label13.TabIndex = 6; this.label13.Text = "生产日期"; this.txt_PN.Location = new System.Drawing.Point(308, 22); this.txt_PN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_PN.Name = "txt_PN"; this.txt_PN.Size = new System.Drawing.Size(229, 25); this.txt_PN.TabIndex = 1; this.label14.AutoSize = true; this.label14.Location = new System.Drawing.Point(7, 27); this.label14.Name = "label14"; this.label14.Size = new System.Drawing.Size(82, 15); this.label14.TabIndex = 0; this.label14.Text = "供应商代码"; this.txt_VendorCode.Location = new System.Drawing.Point(100, 22); this.txt_VendorCode.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_VendorCode.Name = "txt_VendorCode"; this.txt_VendorCode.Size = new System.Drawing.Size(100, 25); this.txt_VendorCode.TabIndex = 0; this.label15.AutoSize = true; this.label15.Location = new System.Drawing.Point(215, 27); this.label15.Name = "label15"; this.label15.Size = new System.Drawing.Size(82, 15); this.label15.TabIndex = 2; this.label15.Text = "零部件编号"; this.groupBox2.Controls.Add(this.txt_MachineCode); this.groupBox2.Controls.Add(this.label16); this.groupBox2.Controls.Add(this.txt_MaxSpecialSN); this.groupBox2.Controls.Add(this.label18); this.groupBox2.Controls.Add(this.label17); this.groupBox2.Controls.Add(this.txt_EndDaySN); this.groupBox2.Controls.Add(this.txt_MinSpecialSN); this.groupBox2.Controls.Add(this.label10); this.groupBox2.Controls.Add(this.txt_StartDaySN); this.groupBox2.Controls.Add(this.label9); this.groupBox2.Controls.Add(this.txt_Date1); this.groupBox2.Controls.Add(this.label8); this.groupBox2.Controls.Add(this.txt_FactoryCode); this.groupBox2.Controls.Add(this.label4); this.groupBox2.Controls.Add(this.txt_PCODE); this.groupBox2.Controls.Add(this.txt_LineNo1); this.groupBox2.Controls.Add(this.label5); this.groupBox2.Controls.Add(this.label6); this.groupBox2.Location = new System.Drawing.Point(5, 59); this.groupBox2.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.groupBox2.Name = "groupBox2"; this.groupBox2.Padding = new System.Windows.Forms.Padding(3, 2, 3, 2); this.groupBox2.Size = new System.Drawing.Size(1876, 55); this.groupBox2.TabIndex = 9; this.groupBox2.TabStop = false; this.groupBox2.Text = "XDSN"; this.txt_MachineCode.Location = new System.Drawing.Point(284, 22); this.txt_MachineCode.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_MachineCode.Name = "txt_MachineCode"; this.txt_MachineCode.Size = new System.Drawing.Size(97, 25); this.txt_MachineCode.TabIndex = 1; this.label16.AutoSize = true; this.label16.Location = new System.Drawing.Point(204, 27); this.label16.Name = "label16"; this.label16.Size = new System.Drawing.Size(67, 15); this.label16.TabIndex = 15; this.label16.Text = "整机代码"; this.txt_MaxSpecialSN.Location = new System.Drawing.Point(1487, 22); this.txt_MaxSpecialSN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_MaxSpecialSN.Name = "txt_MaxSpecialSN"; this.txt_MaxSpecialSN.Size = new System.Drawing.Size(92, 25); this.txt_MaxSpecialSN.TabIndex = 8; this.label18.AutoSize = true; this.label18.Location = new System.Drawing.Point(1458, 27); this.label18.Name = "label18"; this.label18.Size = new System.Drawing.Size(22, 15); this.label18.TabIndex = 13; this.label18.Text = "到"; this.label17.AutoSize = true; this.label17.Location = new System.Drawing.Point(1163, 27); this.label17.Name = "label17"; this.label17.Size = new System.Drawing.Size(22, 15); this.label17.TabIndex = 9; this.label17.Text = "到"; this.txt_EndDaySN.Location = new System.Drawing.Point(1192, 22); this.txt_EndDaySN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_EndDaySN.Name = "txt_EndDaySN"; this.txt_EndDaySN.Size = new System.Drawing.Size(92, 25); this.txt_EndDaySN.TabIndex = 6; this.txt_MinSpecialSN.Location = new System.Drawing.Point(1360, 22); this.txt_MinSpecialSN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_MinSpecialSN.Name = "txt_MinSpecialSN"; this.txt_MinSpecialSN.Size = new System.Drawing.Size(92, 25); this.txt_MinSpecialSN.TabIndex = 7; this.label10.AutoSize = true; this.label10.Location = new System.Drawing.Point(1297, 26); this.label10.Name = "label10"; this.label10.Size = new System.Drawing.Size(52, 15); this.label10.TabIndex = 10; this.label10.Text = "连续号"; this.txt_StartDaySN.Location = new System.Drawing.Point(1073, 22); this.txt_StartDaySN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_StartDaySN.Name = "txt_StartDaySN"; this.txt_StartDaySN.Size = new System.Drawing.Size(85, 25); this.txt_StartDaySN.TabIndex = 5; this.txt_StartDaySN.TextChanged += new System.EventHandler(txt_StartDaySN_TextChanged); this.label9.AutoSize = true; this.label9.Location = new System.Drawing.Point(993, 27); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(67, 15); this.label9.TabIndex = 8; this.label9.Text = "日流水号"; this.txt_Date1.Location = new System.Drawing.Point(877, 22); this.txt_Date1.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_Date1.Name = "txt_Date1"; this.txt_Date1.Size = new System.Drawing.Size(97, 25); this.txt_Date1.TabIndex = 4; this.txt_Date1.TextChanged += new System.EventHandler(txt_Date1_TextChanged); this.label8.AutoSize = true; this.label8.Location = new System.Drawing.Point(797, 27); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(67, 15); this.label8.TabIndex = 6; this.label8.Text = "生产日期"; this.txt_FactoryCode.Location = new System.Drawing.Point(492, 22); this.txt_FactoryCode.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_FactoryCode.Name = "txt_FactoryCode"; this.txt_FactoryCode.Size = new System.Drawing.Size(97, 25); this.txt_FactoryCode.TabIndex = 2; this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(16, 27); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(47, 15); this.label4.TabIndex = 0; this.label4.Text = "PCODE"; this.txt_PCODE.Location = new System.Drawing.Point(73, 22); this.txt_PCODE.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_PCODE.Name = "txt_PCODE"; this.txt_PCODE.Size = new System.Drawing.Size(96, 25); this.txt_PCODE.TabIndex = 0; this.txt_LineNo1.Location = new System.Drawing.Point(684, 22); this.txt_LineNo1.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_LineNo1.Name = "txt_LineNo1"; this.txt_LineNo1.Size = new System.Drawing.Size(97, 25); this.txt_LineNo1.TabIndex = 3; this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(412, 27); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(67, 15); this.label5.TabIndex = 2; this.label5.Text = "工厂代码"; this.label6.AutoSize = true; this.label6.Location = new System.Drawing.Point(604, 27); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(67, 15); this.label6.TabIndex = 4; this.label6.Text = "产线编号"; this.groupBox1.Controls.Add(this.tbx_OrderID); this.groupBox1.Controls.Add(this.btn_OpenDlg); this.groupBox1.Controls.Add(this.cbox_Model); this.groupBox1.Controls.Add(this.label26); this.groupBox1.Controls.Add(this.label3); this.groupBox1.Controls.Add(this.label7); this.groupBox1.Controls.Add(this.txt_EndSN); this.groupBox1.Controls.Add(this.txt_StartSN); this.groupBox1.Controls.Add(this.label1); this.groupBox1.Controls.Add(this.txt_SNPrefix); this.groupBox1.Controls.Add(this.label2); this.groupBox1.Location = new System.Drawing.Point(3, 2); this.groupBox1.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.groupBox1.Name = "groupBox1"; this.groupBox1.Padding = new System.Windows.Forms.Padding(3, 2, 3, 2); this.groupBox1.Size = new System.Drawing.Size(1878, 52); this.groupBox1.TabIndex = 8; this.groupBox1.TabStop = false; this.groupBox1.Text = "SN"; this.tbx_OrderID.Location = new System.Drawing.Point(70, 17); this.tbx_OrderID.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.tbx_OrderID.Name = "tbx_OrderID"; this.tbx_OrderID.Size = new System.Drawing.Size(172, 25); this.tbx_OrderID.TabIndex = 13; this.btn_OpenDlg.Location = new System.Drawing.Point(248, 15); this.btn_OpenDlg.Name = "btn_OpenDlg"; this.btn_OpenDlg.Size = new System.Drawing.Size(41, 27); this.btn_OpenDlg.TabIndex = 12; this.btn_OpenDlg.Text = "..."; this.btn_OpenDlg.UseVisualStyleBackColor = true; this.btn_OpenDlg.Click += new System.EventHandler(btn_OpenDlg_Click); this.cbox_Model.FormattingEnabled = true; this.cbox_Model.Location = new System.Drawing.Point(390, 16); this.cbox_Model.Name = "cbox_Model"; this.cbox_Model.Size = new System.Drawing.Size(192, 23); this.cbox_Model.TabIndex = 11; this.cbox_Model.SelectedIndexChanged += new System.EventHandler(cbx_Model_SelectedIndexChanged); this.label26.AutoSize = true; this.label26.Location = new System.Drawing.Point(351, 19); this.label26.Name = "label26"; this.label26.Size = new System.Drawing.Size(37, 15); this.label26.TabIndex = 10; this.label26.Text = "机型"; this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(12, 20); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(52, 15); this.label3.TabIndex = 9; this.label3.Text = "工单号"; this.label7.AutoSize = true; this.label7.Location = new System.Drawing.Point(1110, 18); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(22, 15); this.label7.TabIndex = 8; this.label7.Text = "到"; this.txt_EndSN.Location = new System.Drawing.Point(1139, 14); this.txt_EndSN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_EndSN.Name = "txt_EndSN"; this.txt_EndSN.Size = new System.Drawing.Size(92, 25); this.txt_EndSN.TabIndex = 3; this.txt_StartSN.Location = new System.Drawing.Point(1016, 14); this.txt_StartSN.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_StartSN.Name = "txt_StartSN"; this.txt_StartSN.Size = new System.Drawing.Size(89, 25); this.txt_StartSN.TabIndex = 2; this.txt_StartSN.TextChanged += new System.EventHandler(txt_StartSN_TextChanged); this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(612, 18); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(53, 15); this.label1.TabIndex = 0; this.label1.Text = "SN前缀"; this.txt_SNPrefix.Location = new System.Drawing.Point(676, 14); this.txt_SNPrefix.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.txt_SNPrefix.Name = "txt_SNPrefix"; this.txt_SNPrefix.Size = new System.Drawing.Size(231, 25); this.txt_SNPrefix.TabIndex = 1; this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(953, 18); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(52, 15); this.label2.TabIndex = 2; this.label2.Text = "流水号"; this.tabPage2.Controls.Add(this.dataGridView2); this.tabPage2.Controls.Add(this.panel2); this.tabPage2.Location = new System.Drawing.Point(4, 25); this.tabPage2.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.tabPage2.Name = "tabPage2"; this.tabPage2.Padding = new System.Windows.Forms.Padding(3, 2, 3, 2); this.tabPage2.Size = new System.Drawing.Size(1894, 896); this.tabPage2.TabIndex = 1; this.tabPage2.Text = "查询号码◢"; this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView2.Location = new System.Drawing.Point(4, 83); this.dataGridView2.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.dataGridView2.Name = "dataGridView2"; this.dataGridView2.RowHeadersWidth = 51; this.dataGridView2.RowTemplate.Height = 30; this.dataGridView2.Size = new System.Drawing.Size(1886, 809); this.dataGridView2.TabIndex = 1; this.panel2.Controls.Add(this.btn_Export); this.panel2.Controls.Add(this.tbx_content); this.panel2.Controls.Add(this.cbox_Field); this.panel2.Controls.Add(this.btn_Delete); this.panel2.Controls.Add(this.btn_Modify); this.panel2.Controls.Add(this.btn_Query); this.panel2.Controls.Add(this.label28); this.panel2.Controls.Add(this.label27); this.panel2.Location = new System.Drawing.Point(3, 5); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(1888, 73); this.panel2.TabIndex = 0; this.btn_Export.Location = new System.Drawing.Point(1718, 11); this.btn_Export.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.btn_Export.Name = "btn_Export"; this.btn_Export.Size = new System.Drawing.Size(110, 47); this.btn_Export.TabIndex = 22; this.btn_Export.Text = "导出数据"; this.btn_Export.UseVisualStyleBackColor = true; this.btn_Export.Click += new System.EventHandler(btn_Export_Click); this.tbx_content.Location = new System.Drawing.Point(424, 24); this.tbx_content.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.tbx_content.Name = "tbx_content"; this.tbx_content.Size = new System.Drawing.Size(383, 25); this.tbx_content.TabIndex = 21; this.tbx_content.KeyPress += new System.Windows.Forms.KeyPressEventHandler(tbx_content_KeyPress); this.cbox_Field.FormattingEnabled = true; this.cbox_Field.Location = new System.Drawing.Point(97, 24); this.cbox_Field.Name = "cbox_Field"; this.cbox_Field.Size = new System.Drawing.Size(199, 23); this.cbox_Field.TabIndex = 20; this.cbox_Field.SelectedIndexChanged += new System.EventHandler(cbx_Field_SelectedIndexChanged); this.btn_Delete.Location = new System.Drawing.Point(1436, 11); this.btn_Delete.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.btn_Delete.Name = "btn_Delete"; this.btn_Delete.Size = new System.Drawing.Size(110, 47); this.btn_Delete.TabIndex = 19; this.btn_Delete.Text = "删除"; this.btn_Delete.UseVisualStyleBackColor = true; this.btn_Delete.Visible = false; this.btn_Delete.Click += new System.EventHandler(btn_Delete_Click); this.btn_Modify.Location = new System.Drawing.Point(1295, 11); this.btn_Modify.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.btn_Modify.Name = "btn_Modify"; this.btn_Modify.Size = new System.Drawing.Size(110, 47); this.btn_Modify.TabIndex = 18; this.btn_Modify.Text = "修改"; this.btn_Modify.UseVisualStyleBackColor = true; this.btn_Modify.Visible = false; this.btn_Modify.Click += new System.EventHandler(btn_Modify_Click); this.btn_Query.Location = new System.Drawing.Point(1577, 11); this.btn_Query.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); this.btn_Query.Name = "btn_Query"; this.btn_Query.Size = new System.Drawing.Size(110, 47); this.btn_Query.TabIndex = 17; this.btn_Query.Text = "查询"; this.btn_Query.UseVisualStyleBackColor = true; this.btn_Query.Click += new System.EventHandler(btn_Query_Click); this.label28.AutoSize = true; this.label28.Location = new System.Drawing.Point(351, 27); this.label28.Name = "label28"; this.label28.Size = new System.Drawing.Size(67, 15); this.label28.TabIndex = 14; this.label28.Text = "查询内容"; this.label27.AutoSize = true; this.label27.Location = new System.Drawing.Point(24, 27); this.label27.Name = "label27"; this.label27.Size = new System.Drawing.Size(67, 15); this.label27.TabIndex = 11; this.label27.Text = "查询字段"; this.statusStrip1.ImageScalingSize = new System.Drawing.Size(24, 24); this.statusStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[8] { this.toolStripStatusLabel1, this.toolStripStatusLabel2, this.toolStripStatusLabel3, this.toolStripStatusLabel4, this.toolStripStatusLabel5, this.toolStripStatusLabel6, this.toolStripStatusLabel7, this.toolStripStatusLabel8 }); this.statusStrip1.Location = new System.Drawing.Point(0, 1007); this.statusStrip1.Name = "statusStrip1"; this.statusStrip1.Padding = new System.Windows.Forms.Padding(1, 0, 12, 0); this.statusStrip1.Size = new System.Drawing.Size(1902, 26); this.statusStrip1.TabIndex = 2; this.statusStrip1.Text = "statusStrip1"; this.toolStripStatusLabel1.Name = "toolStripStatusLabel1"; this.toolStripStatusLabel1.Size = new System.Drawing.Size(167, 20); this.toolStripStatusLabel1.Text = "toolStripStatusLabel1"; this.toolStripStatusLabel2.Name = "toolStripStatusLabel2"; this.toolStripStatusLabel2.Size = new System.Drawing.Size(167, 20); this.toolStripStatusLabel2.Text = "toolStripStatusLabel2"; this.toolStripStatusLabel3.Name = "toolStripStatusLabel3"; this.toolStripStatusLabel3.Size = new System.Drawing.Size(167, 20); this.toolStripStatusLabel3.Text = "toolStripStatusLabel3"; this.toolStripStatusLabel4.Name = "toolStripStatusLabel4"; this.toolStripStatusLabel4.Size = new System.Drawing.Size(167, 20); this.toolStripStatusLabel4.Text = "toolStripStatusLabel4"; this.toolStripStatusLabel5.Name = "toolStripStatusLabel5"; this.toolStripStatusLabel5.Size = new System.Drawing.Size(167, 20); this.toolStripStatusLabel5.Text = "toolStripStatusLabel5"; this.toolStripStatusLabel6.Name = "toolStripStatusLabel6"; this.toolStripStatusLabel6.Size = new System.Drawing.Size(167, 20); this.toolStripStatusLabel6.Text = "toolStripStatusLabel6"; this.toolStripStatusLabel7.Name = "toolStripStatusLabel7"; this.toolStripStatusLabel7.Size = new System.Drawing.Size(167, 20); this.toolStripStatusLabel7.Text = "toolStripStatusLabel7"; this.toolStripStatusLabel8.Name = "toolStripStatusLabel8"; this.toolStripStatusLabel8.Size = new System.Drawing.Size(167, 20); this.toolStripStatusLabel8.Text = "toolStripStatusLabel8"; this.errorProvider1.ContainerControl = this; this.lbl_Title.Font = new System.Drawing.Font("微软雅黑", 30f, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134); this.lbl_Title.Location = new System.Drawing.Point(0, 0); this.lbl_Title.Name = "lbl_Title"; this.lbl_Title.Size = new System.Drawing.Size(1902, 66); this.lbl_Title.TabIndex = 3; this.lbl_Title.Text = "SN Generate Tool"; //this.btn_Close.BackgroundImage = Hexiv.JK.SNGenerateTool.Properties.Resources.关闭3; this.btn_Close.Location = new System.Drawing.Point(1858, 5); this.btn_Close.Name = "btn_Close"; this.btn_Close.Size = new System.Drawing.Size(32, 32); this.btn_Close.TabIndex = 5; this.btn_Close.UseVisualStyleBackColor = false; this.btn_Close.Click += new System.EventHandler(btn_Close_Click); //this.btn_Minimize.BackgroundImage = Hexiv.JK.SNGenerateTool.Properties.Resources.最小化; this.btn_Minimize.Location = new System.Drawing.Point(1803, 5); this.btn_Minimize.Name = "btn_Minimize"; this.btn_Minimize.Size = new System.Drawing.Size(32, 32); this.btn_Minimize.TabIndex = 4; this.btn_Minimize.UseVisualStyleBackColor = false; this.btn_Minimize.Click += new System.EventHandler(btn_Mininimze_Click); base.AutoScaleDimensions = new System.Drawing.SizeF(8f, 15f); base.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; base.ClientSize = new System.Drawing.Size(1902, 1033); base.Controls.Add(this.btn_Close); base.Controls.Add(this.btn_Minimize); base.Controls.Add(this.lbl_Title); base.Controls.Add(this.tabControl1); base.Controls.Add(this.statusStrip1); //base.Icon = (System.Drawing.Icon)resources.GetObject("$this.Icon"); base.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2); base.Name = "MainForm"; this.Text = "Form1"; base.Paint += new System.Windows.Forms.PaintEventHandler(MainForm_Paint); this.tabControl1.ResumeLayout(false); this.tabPage1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)this.dataGridView1).EndInit(); this.panel1.ResumeLayout(false); this.groupBox4.ResumeLayout(false); this.groupBox4.PerformLayout(); this.groupBox3.ResumeLayout(false); this.groupBox3.PerformLayout(); this.groupBox2.ResumeLayout(false); this.groupBox2.PerformLayout(); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); this.tabPage2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)this.dataGridView2).EndInit(); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); this.statusStrip1.ResumeLayout(false); this.statusStrip1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)this.errorProvider1).EndInit(); base.ResumeLayout(false); base.PerformLayout(); } }