📄 formmain.cs
字号:
using System;
using System.Drawing;
using System.Collections;
using System.Windows.Forms;
using System.Data;
using System.Text;
using System.Data.Common;
using System.Data.SqlServerCe;
using System.Data.SqlTypes;
using System.IO;
//using System.OleDb;
namespace WinCE_DBF
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class FormMain : System.Windows.Forms.Form
{
private System.Windows.Forms.TabControl tabControl1;
private System.Windows.Forms.TabPage tabPage1;
private System.Windows.Forms.TabPage tabPage2;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.Label label10;
private System.Windows.Forms.Label label11;
private System.Windows.Forms.TextBox textBoxShip;
private System.Windows.Forms.TextBox textBoxType;
private System.Windows.Forms.TextBox textBoxScan;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.TextBox textBox6;
private System.Windows.Forms.TextBox textBox7;
private System.Windows.Forms.TextBox textBox8;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle2;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle3;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle4;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle5;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle6;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle7;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle8;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle9;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle10;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle11;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle12;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle13;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle14;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle15;
private System.Windows.Forms.ListView listView1;
private System.Windows.Forms.ColumnHeader columnHeader1;
private System.Windows.Forms.ColumnHeader columnHeader2;
private System.Windows.Forms.ColumnHeader columnHeader3;
private System.Windows.Forms.ColumnHeader columnHeader4;
private System.Windows.Forms.ColumnHeader columnHeader5;
private System.Windows.Forms.ColumnHeader columnHeader6;
private System.Windows.Forms.ColumnHeader columnHeader7;
private System.Windows.Forms.ColumnHeader columnHeader8;
private System.Windows.Forms.ColumnHeader columnHeader9;
private System.Windows.Forms.ColumnHeader columnHeader10;
private System.Windows.Forms.ColumnHeader columnHeader11;
private System.Windows.Forms.ColumnHeader columnHeader12;
private System.Windows.Forms.ColumnHeader columnHeader13;
private System.Windows.Forms.ColumnHeader columnHeader14;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Button btLogIn;
private System.Windows.Forms.Button btExit;
private System.Windows.Forms.Button btUpFile;
private System.Windows.Forms.Button btDnFile;
private System.Windows.Forms.Button btSetting;
private System.Windows.Forms.ColumnHeader columnHeader15;
private string UserName;//当前登录的用户名
private string ServerName;//FTP服务器的IP地址
private string FtpUser;//FTP服务器的登录名
private string FtpPsw;//FTP服务器登录密码
private string UpFileName;//上传的文件名
private string DnFileName;//下载的文件名
public FormMain()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
this.tabControl1.SelectedIndexChanged +=new EventHandler(tabControl1_SelectedIndexChanged);
this.textBoxShip.KeyPress +=new KeyPressEventHandler(textBoxShip_KeyPress);
this.textBoxType.KeyPress +=new KeyPressEventHandler(textBoxType_KeyPress);
this.textBoxScan.KeyPress +=new KeyPressEventHandler(textBoxScan_KeyPress);
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
ClearTextBox();
this.textBoxShip.Text="";
this.textBoxType.Text="";
this.textBoxScan.Text="";
}
//清空各个文本框的显示
private void ClearTextBox()
{
this.textBox1.Text="";
this.textBox2.Text="";
this.textBox3.Text="";
this.textBox4.Text="";
this.textBox5.Text="";
this.textBox6.Text="";
this.textBox7.Text="";
this.textBox8.Text="";
}
//检查字符串中的所有字符是否都在'0'-'9'范围中
private int IsNumberChr(String chk)
{
if((chk!="0")&&(chk!="1")&&(chk!="2")&&(chk!="3")&&(chk!="4")&&
(chk!="5")&&(chk!="6")&&(chk!="7")&&(chk!="8")&&(chk!="9"))
return 0;
else
return 1;
}
//存储合法的扫描的生产数据
private void SaveScanData()
{
DateTime dt = DateTime.Now;
SqlCeConnection conn = null;
try
{
conn = new SqlCeConnection ("Data Source = SqlCeDB.sdf");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
//cmd.CommandText = "INSERT INTO up_data(CODE,TYPE,PROD,QUALITY,SIZE,PACKING_NO,QUANTITY,POSITION,TOS,FACTORY,CUST,RUN_CODE,USERR,DATE,TIME) VALUES ('CODE',2,'6','A','89','129','22','55','TOS','F','6','9','USE','2006-12-20','19:12:20')";
cmd.CommandText = "INSERT INTO up_data(CODE,TYPE,PROD,QUALITY,SIZE,PACKING_NO,QUANTITY,POSITION,TOS,FACTORY,CUST,RUN_CODE,USERR,DATE,TIME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlCeParameter("p1", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p2", SqlDbType.Int));
cmd.Parameters.Add(new SqlCeParameter("p3", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p4", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p5", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p6", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p7", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p8", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p9", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p10", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p11", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p12", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p13", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p14", SqlDbType.NText));
cmd.Parameters.Add(new SqlCeParameter("p15", SqlDbType.NText));
cmd.Parameters["p1"].Size = 37;
cmd.Parameters["p3"].Size = 6;
cmd.Parameters["p4"].Size = 7;
cmd.Parameters["p5"].Size = 10;
cmd.Parameters["p6"].Size = 10;
cmd.Parameters["p7"].Size = 3;
cmd.Parameters["p8"].Size = 5;
cmd.Parameters["p9"].Size = 10;
cmd.Parameters["p10"].Size = 1;
cmd.Parameters["p11"].Size = 5;
cmd.Parameters["p12"].Size = 2;
cmd.Parameters["p13"].Size = 4;
cmd.Parameters["p14"].Size = 15;
cmd.Parameters["p15"].Size = 10;
cmd.Prepare();
cmd.Parameters["p1"].Value = this.textBoxScan.Text.Trim();
cmd.Parameters["p2"].Value = Convert.ToInt32(this.textBoxType.Text.Trim(),10);
cmd.Parameters["p3"].Value = this.textBox1.Text.Trim();
cmd.Parameters["p4"].Value = this.textBox2.Text.Trim();
cmd.Parameters["p5"].Value = this.textBox3.Text.Trim();
cmd.Parameters["p6"].Value = this.textBox4.Text.Trim();
cmd.Parameters["p7"].Value = this.textBox5.Text.Trim();
cmd.Parameters["p8"].Value = this.textBox6.Text.Trim();
cmd.Parameters["p9"].Value = "TOS";//"TOS";
cmd.Parameters["p10"].Value = this.textBox7.Text.Trim();
cmd.Parameters["p11"].Value = this.textBox8.Text.Trim();
cmd.Parameters["p12"].Value = "R"; //"RUN_CODE"
cmd.Parameters["p13"].Value = this.UserName; //"USER"
cmd.Parameters["p14"].Value = dt.Date.ToShortDateString();
cmd.Parameters["p15"].Value = dt.ToLongTimeString();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
catch(SqlCeException e)
{
ShowErrors(e);
}
finally
{
if(conn.State == ConnectionState.Open)
conn.Close();
}
}
//查看上传的的数据
private void ViewData()
{
SqlCeConnection conn = null;
conn = new SqlCeConnection ("Data Source =SqlCeDB.sdf");
if(conn.State==ConnectionState.Open)
conn.Close();
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM up_data";
SqlCeDataReader rdr = cmd.ExecuteReader();
listView1.View = View.Details;
listView1.CheckBoxes = false;
listView1.FullRowSelect = true;
listView1.Items.Clear();
while (rdr.Read())
{
string hd;
hd=rdr.GetString(0);
ListViewItem lvt=new ListViewItem(hd);
lvt.SubItems.Clear();
lvt.SubItems.Add(Convert.ToString(rdr.GetInt32(1)));
lvt.SubItems.Add(rdr.GetString(2));
lvt.SubItems.Add(rdr.GetString(3));
lvt.SubItems.Add(rdr.GetString(4));
lvt.SubItems.Add(rdr.GetString(5));
lvt.SubItems.Add(rdr.GetString(6));
lvt.SubItems.Add(rdr.GetString(7));
lvt.SubItems.Add(rdr.GetString(8));
lvt.SubItems.Add(rdr.GetString(9));
lvt.SubItems.Add(rdr.GetString(10));
lvt.SubItems.Add(rdr.GetString(11));
lvt.SubItems.Add(rdr.GetString(12));
lvt.SubItems.Add(rdr.GetString(13));
lvt.SubItems.Add(rdr.GetString(14));
lvt.SubItems[0].Text=hd;
listView1.Items.Add(lvt);
listView1.Update();
}
if(conn.State==ConnectionState.Open)
conn.Close();
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.textBoxScan = new System.Windows.Forms.TextBox();
this.textBoxType = new System.Windows.Forms.TextBox();
this.textBoxShip = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.panel1 = new System.Windows.Forms.Panel();
this.textBox8 = new System.Windows.Forms.TextBox();
this.textBox7 = new System.Windows.Forms.TextBox();
this.textBox6 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox1 = new System.Windows.Forms.TextBox();
this.label11 = new System.Windows.Forms.Label();
this.label10 = new System.Windows.Forms.Label();
this.label9 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.listView1 = new System.Windows.Forms.ListView();
this.columnHeader1 = new System.Windows.Forms.ColumnHeader();
this.columnHeader2 = new System.Windows.Forms.ColumnHeader();
this.columnHeader3 = new System.Windows.Forms.ColumnHeader();
this.columnHeader4 = new System.Windows.Forms.ColumnHeader();
this.columnHeader5 = new System.Windows.Forms.ColumnHeader();
this.columnHeader6 = new System.Windows.Forms.ColumnHeader();
this.columnHeader7 = new System.Windows.Forms.ColumnHeader();
this.columnHeader8 = new System.Windows.Forms.ColumnHeader();
this.columnHeader9 = new System.Windows.Forms.ColumnHeader();
this.columnHeader10 = new System.Windows.Forms.ColumnHeader();
this.columnHeader11 = new System.Windows.Forms.ColumnHeader();
this.columnHeader12 = new System.Windows.Forms.ColumnHeader();
this.columnHeader13 = new System.Windows.Forms.ColumnHeader();
this.columnHeader14 = new System.Windows.Forms.ColumnHeader();
this.columnHeader15 = new System.Windows.Forms.ColumnHeader();
this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTableStyle2 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTableStyle3 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTableStyle4 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTableStyle5 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTableStyle6 = new System.Windows.Forms.DataGridTableStyle();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -