📄 smcx.cs
字号:
this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "tsxxb", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("编号", "编号"),
new System.Data.Common.DataColumnMapping("出版社", "出版社"),
new System.Data.Common.DataColumnMapping("价格", "价格"),
new System.Data.Common.DataColumnMapping("库存数", "库存数"),
new System.Data.Common.DataColumnMapping("类别", "类别"),
new System.Data.Common.DataColumnMapping("书名", "书名"),
new System.Data.Common.DataColumnMapping("在库数", "在库数"),
new System.Data.Common.DataColumnMapping("作者", "作者")})});
this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM tsxxb WHERE (编号 = ?) AND (书名 = ?) AND (价格 = ?) AND (作者 = ?) AND (出版社 " +
"= ?) AND (在库数 = ?) AND (库存数 = ?) AND (类别 = ?)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_编号", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_书名", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "书名", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_价格", System.Data.OleDb.OleDbType.Currency, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "价格", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_作者", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "作者", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_出版社", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出版社", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_在库数", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "在库数", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_库存数", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "库存数", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_类别", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类别", System.Data.DataRowVersion.Original, null));
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Registry Path=;Data Source="".\tsglxt.mdb"";Jet OLEDB:System database=;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:Database Locking Mode=1;Jet OLEDB:SFP=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Global Partial Bulk Ops=2;Mode=Share Deny None;Extended Properties=;Jet OLEDB:Engine Type=5";
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO tsxxb(编号, 出版社, 价格, 库存数, 类别, 书名, 在库数, 作者) VALUES (?, ?, ?, ?, ?, ?, ?," +
" ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("编号", System.Data.OleDb.OleDbType.VarWChar, 20, "编号"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("出版社", System.Data.OleDb.OleDbType.VarWChar, 20, "出版社"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("价格", System.Data.OleDb.OleDbType.Currency, 0, "价格"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("库存数", System.Data.OleDb.OleDbType.Integer, 0, "库存数"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("类别", System.Data.OleDb.OleDbType.VarWChar, 20, "类别"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("书名", System.Data.OleDb.OleDbType.VarWChar, 30, "书名"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("在库数", System.Data.OleDb.OleDbType.Integer, 0, "在库数"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("作者", System.Data.OleDb.OleDbType.VarWChar, 20, "作者"));
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT 编号, 出版社, 价格, 库存数, 类别, 书名, 在库数, 作者 FROM tsxxb";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = "UPDATE tsxxb SET 编号 = ?, 出版社 = ?, 价格 = ?, 库存数 = ?, 类别 = ?, 书名 = ?, 在库数 = ?, 作者 = " +
"? WHERE (编号 = ?) AND (书名 = ?) AND (价格 = ?) AND (作者 = ?) AND (出版社 = ?) AND (在库数 =" +
" ?) AND (库存数 = ?) AND (类别 = ?)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("编号", System.Data.OleDb.OleDbType.VarWChar, 20, "编号"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("出版社", System.Data.OleDb.OleDbType.VarWChar, 20, "出版社"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("价格", System.Data.OleDb.OleDbType.Currency, 0, "价格"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("库存数", System.Data.OleDb.OleDbType.Integer, 0, "库存数"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("类别", System.Data.OleDb.OleDbType.VarWChar, 20, "类别"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("书名", System.Data.OleDb.OleDbType.VarWChar, 30, "书名"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("在库数", System.Data.OleDb.OleDbType.Integer, 0, "在库数"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("作者", System.Data.OleDb.OleDbType.VarWChar, 20, "作者"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_编号", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_书名", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "书名", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_价格", System.Data.OleDb.OleDbType.Currency, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "价格", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_作者", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "作者", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_出版社", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出版社", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_在库数", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "在库数", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_库存数", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "库存数", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_类别", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类别", System.Data.DataRowVersion.Original, null));
//
// smcx
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(936, 422);
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.groupBox1);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.Name = "smcx";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "书目查询";
this.Closing += new System.ComponentModel.CancelEventHandler(this.smcx_Closing);
this.groupBox1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
this.groupBox3.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void button3_Click(object sender, System.EventArgs e)
{
System.Data.OleDb.OleDbCommand MySelect = this.oleDbConnection1.CreateCommand();
MySelect.CommandText="SELECT * FROM tsxxb";
this.oleDbDataAdapter1.SelectCommand=MySelect;
this.dataSet21.Clear();
try
{
this.oleDbConnection1.Open();
this.oleDbDataAdapter1.Fill(this.dataSet21,"tsxxb");
this.oleDbConnection1.Close();
}
catch(Exception Exc)
{
MessageBox.Show(Exc.Message);
this.oleDbConnection1.Close();
}
}
private void button2_Click(object sender, System.EventArgs e)
{
this.dataSet21.Clear();
}
private void button4_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, System.EventArgs e)
{
string ComStr="";
try
{
System.Data.OleDb.OleDbCommand MySelect = this.oleDbConnection1.CreateCommand();
if(this.textBox1.Text != "")
{
ComStr="SELECT * FROM tsxxb WHERE 编号='"+this.textBox1.Text+"'";
}
else
{
if(this.textBox2.Text != "")
{
if(ComStr == "")
{
ComStr="SELECT * FROM tsxxb WHERE 书名='"+this.textBox2.Text+"'";
}
else
{
ComStr+=" AND 书名='"+this.textBox2.Text+"'";
}
}
if(this.textBox3.Text != "")
{
if(ComStr == "")
{
ComStr="SELECT * FROM tsxxb WHERE 类别='"+this.textBox3.Text+"'";
}
else
{
ComStr+=" AND 类别='"+this.textBox3.Text+"'";
}
}
if(this.textBox4.Text != "")
{
if(ComStr == "")
{
ComStr="SELECT * FROM tsxxb WHERE 作者='"+this.textBox4.Text+"'";
}
else
{
ComStr+=" AND 作者='"+this.textBox4.Text+"'";
}
}
if(this.textBox5.Text != "")
{
if(ComStr == "")
{
ComStr="SELECT * FROM tsxxb WHERE 出版社='"+this.textBox5.Text+"'";
}
else
{
ComStr+=" AND 出版社='"+this.textBox5.Text+"'";
}
}
if(ComStr == "")
{
MessageBox.Show("无查询条件，默认查询所有记录．","查询提示：",MessageBoxButtons.OK,MessageBoxIcon.Information);
ComStr="SELECT * FROM tsxxb";
}
}
MySelect.CommandText=ComStr;
this.oleDbDataAdapter1.SelectCommand=MySelect;
this.dataSet21.Clear();
this.oleDbConnection1.Open();
this.oleDbDataAdapter1.Fill(dataSet21,"tsxxb");
this.oleDbConnection1.Close();
}
catch(Exception Exc)
{
MessageBox.Show(Exc.Message);
this.oleDbConnection1.Close();
}
}
private void button4_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
switch((int)e.KeyCode)
{
case 27:
this.Close();
break;
case 13:
if(this.button1.Focused || this.textBox1.Focused || this.textBox2.Focused || this.textBox3.Focused || this.textBox4.Focused || this.textBox5.Focused)
{
button1_Click(null,null);
}
if(this.button2.Focused)
{
button2_Click(null,null);
}
if(this.button3.Focused)
{
button3_Click(null,null);
}
if(this.button4.Focused)
{
this.Close();
}
break;
case 38:
case 37:
if(this.textBox5.Focused)
{
this.textBox4.Focus();
}
else
{
if(this.textBox4.Focused)
{
this.textBox3.Focus();
}
else
{
if(this.textBox3.Focused)
{
this.textBox2.Focus();
}
else
{
if(this.textBox2.Focused)
{
this.textBox1.Focus();
}
else
{
if(this.textBox1.Focused)
{
this.textBox5.Focus();
}
}
}
}
}
break;
case 40:
case 39:
if(this.textBox5.Focused)
{
this.textBox1.Focus();
}
else
{
if(this.textBox1.Focused)
{
this.textBox2.Focus();
}
else
{
if(this.textBox2.Focused)
{
this.textBox3.Focus();
}
else
{
if(this.textBox3.Focused)
{
this.textBox4.Focus();
}
else
{
if(this.textBox4.Focused)
{
this.textBox5.Focus();
}
}
}
}
}
break;
}
}
public void CXBH(jsgl V)
{
V.textBox2.Text=BH;
}
private void smcx_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
int ReN = this.dataGrid1.CurrentRowIndex;
if(ReN == -1)
{
BH="";
}
else
{
BH=dataSet21.Tables["tsxxb"].Rows[ReN]["编号"].ToString();
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -