📄 hsgl.cs
字号:
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = "INSERT INTO tsxxb(编号, 出版社, 价格, 库存数, 类别, 书名, 在库数, 作者) VALUES (?, ?, ?, ?, ?, ?, ?," +
" ?)";
this.oleDbInsertCommand2.Connection = this.oleDbConnection1;
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("编号", System.Data.OleDb.OleDbType.VarWChar, 20, "编号"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("出版社", System.Data.OleDb.OleDbType.VarWChar, 20, "出版社"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("价格", System.Data.OleDb.OleDbType.Currency, 0, "价格"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("库存数", System.Data.OleDb.OleDbType.Integer, 0, "库存数"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("类别", System.Data.OleDb.OleDbType.VarWChar, 20, "类别"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("书名", System.Data.OleDb.OleDbType.VarWChar, 30, "书名"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("在库数", System.Data.OleDb.OleDbType.Integer, 0, "在库数"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("作者", System.Data.OleDb.OleDbType.VarWChar, 20, "作者"));
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT 编号, 出版社, 价格, 库存数, 类别, 书名, 在库数, 作者 FROM tsxxb";
this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand2
//
this.oleDbUpdateCommand2.CommandText = "UPDATE tsxxb SET 编号 = ?, 出版社 = ?, 价格 = ?, 库存数 = ?, 类别 = ?, 书名 = ?, 在库数 = ?, 作者 = " +
"? WHERE (编号 = ?) AND (书名 = ?) AND (价格 = ?) AND (作者 = ?) AND (出版社 = ?) AND (在库数 =" +
" ?) AND (库存数 = ?) AND (类别 = ?)";
this.oleDbUpdateCommand2.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("编号", System.Data.OleDb.OleDbType.VarWChar, 20, "编号"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("出版社", System.Data.OleDb.OleDbType.VarWChar, 20, "出版社"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("价格", System.Data.OleDb.OleDbType.Currency, 0, "价格"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("库存数", System.Data.OleDb.OleDbType.Integer, 0, "库存数"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("类别", System.Data.OleDb.OleDbType.VarWChar, 20, "类别"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("书名", System.Data.OleDb.OleDbType.VarWChar, 30, "书名"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("在库数", System.Data.OleDb.OleDbType.Integer, 0, "在库数"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("作者", System.Data.OleDb.OleDbType.VarWChar, 20, "作者"));
this.oleDbUpdateCommand2.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.oleDbUpdateCommand2.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.oleDbUpdateCommand2.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.oleDbUpdateCommand2.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.oleDbUpdateCommand2.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.oleDbUpdateCommand2.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.oleDbUpdateCommand2.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.oleDbUpdateCommand2.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));
//
// oleDbDataAdapter3
//
this.oleDbDataAdapter3.DeleteCommand = this.oleDbDeleteCommand3;
this.oleDbDataAdapter3.InsertCommand = this.oleDbInsertCommand3;
this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3;
this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "jsxxb", 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.oleDbDataAdapter3.UpdateCommand = this.oleDbUpdateCommand3;
//
// oleDbDeleteCommand3
//
this.oleDbDeleteCommand3.CommandText = "DELETE FROM jsxxb WHERE (编号 = ?) AND (借书日期 = ?) AND (图书编号 = ?) AND (读者编号 = ?)";
this.oleDbDeleteCommand3.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand3.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.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_借书日期", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "借书日期", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand3.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.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_读者编号", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "读者编号", System.Data.DataRowVersion.Original, null));
//
// oleDbInsertCommand3
//
this.oleDbInsertCommand3.CommandText = "INSERT INTO jsxxb(读者编号, 借书日期, 图书编号) VALUES (?, ?, ?)";
this.oleDbInsertCommand3.Connection = this.oleDbConnection1;
this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("读者编号", System.Data.OleDb.OleDbType.VarWChar, 10, "读者编号"));
this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("借书日期", System.Data.OleDb.OleDbType.DBDate, 0, "借书日期"));
this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("图书编号", System.Data.OleDb.OleDbType.VarWChar, 20, "图书编号"));
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT 编号, 读者编号, 借书日期, 图书编号 FROM jsxxb";
this.oleDbSelectCommand3.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand3
//
this.oleDbUpdateCommand3.CommandText = "UPDATE jsxxb SET 读者编号 = ?, 借书日期 = ?, 图书编号 = ? WHERE (编号 = ?) AND (借书日期 = ?) AND (" +
"图书编号 = ?) AND (读者编号 = ?)";
this.oleDbUpdateCommand3.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("读者编号", System.Data.OleDb.OleDbType.VarWChar, 10, "读者编号"));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("借书日期", System.Data.OleDb.OleDbType.DBDate, 0, "借书日期"));
this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("图书编号", System.Data.OleDb.OleDbType.VarWChar, 20, "图书编号"));
this.oleDbUpdateCommand3.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.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_借书日期", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "借书日期", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand3.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.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_读者编号", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "读者编号", System.Data.DataRowVersion.Original, null));
//
// hsgl
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(1016, 590);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.groupBox4);
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 = "hsgl";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "还书管理";
this.Activated += new System.EventHandler(this.hsgl_Activated);
this.groupBox1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
this.groupBox3.ResumeLayout(false);
this.groupBox4.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void JSXX()
{
try
{
System.Data.OleDb.OleDbCommand MySelect = this.oleDbConnection1.CreateCommand();
MySelect.CommandText="SELECT * FROM jsxxb WHERE 读者编号='"+this.textBox1.Text+"'";
this.oleDbDataAdapter3.SelectCommand=MySelect;
this.dataSet21.Clear();
this.oleDbConnection1.Open();
this.oleDbDataAdapter3.Fill(this.dataSet21,"jsxxb");
this.oleDbConnection1.Close();
string []TSBH=new string[dataSet21.Tables["jsxxb"].Rows.Count];
string []JSRQ=new string[dataSet21.Tables["jsxxb"].Rows.Count];
for(int i=0; i<dataSet21.Tables["jsxxb"].Rows.Count;i++)
{
TSBH[i] = dataSet21.Tables["jsxxb"].Rows[i]["图书编号"].ToString();
JSRQ[i] = dataSet21.Tables["jsxxb"].Rows[i]["借书日期"].ToString();
}
int GJ=TSBH.Length;
string []TEXT=new string[GJ];
float JG=0.00F;
System.Data.OleDb.OleDbCommand MySelectTs = this.oleDbConnection1.CreateCommand();
for(int i=0; i<GJ; i++)
{
MySelectTs.CommandText="SELECT * FROM tsxxb WHERE 编号='"+TSBH[i]+"'";
this.oleDbDataAdapter2.SelectCommand=MySelectTs;
this.dataSet21.Clear();
this.oleDbDataAdapter2.Fill(this.dataSet21,"tsxxb");
TEXT[i] = "书名："+dataSet21.Tables["tsxxb"].Rows[0]["书名"].ToString()+"\t\t\t价格："+dataSet21.Tables["tsxxb"].Rows[0]["价格"].ToString()+"元\t\t借书日期："+JSRQ[i];
JG += float.Parse( dataSet21.Tables["tsxxb"].Rows[0]["价格"].ToString());
}
this.labelgj.Text=GJ.ToString()+"本";
this.textBox3.Lines=TEXT;
this.labelzj.Text=JG.ToString()+"元";
}
catch(Exception Exc)
{
MessageBox.Show(Exc.Message);
this.oleDbConnection1.Close();
}
}
private void hsgl_Activated(object sender, System.EventArgs e)
{
this.textBox1.Focus();
}
private void textBox1_Leave(object sender, System.EventArgs e)
{
this.labeldzxm.Text="";
this.labeldzxb.Text="";
this.labeldzsj.Text="";
this.labelxm.Text="";
this.labelxb.Text="";
this.labelgj.Text="";
this.labelzj.Text="";
this.textBox3.Text="";
System.Data.OleDb.OleDbCommand MySelect = this.oleDbConnection1.CreateCommand();
MySelect.CommandText="SELECT * FROM dzxxb WHERE 编号='"+this.textBox1.Text+"'";
System.Data.OleDb.OleDbCommand MySelectCount=this.oleDbConnection1.CreateCommand();
MySelectCount.CommandText="SELECT * FROM jsxxb WHERE 读者编号='"+this.textBox1.Text+"'";
this.oleDbDataAdapter1.SelectCommand=MySelect;
this.oleDbDataAdapter3.SelectCommand=MySelectCount;
this.dataSet21.Clear();
try
{
this.oleDbConnection1.Open();
int If=this.oleDbDataAdapter1.Fill(this.dataSet21,"dzxxb");
this.oleDbConnection1.Close();
if(If==0)
{
DZ=true;
}
else
{
DZ=false;
this.labeldzxm.Text=dataSet21.Tables["dzxxb"].Rows[0]["姓名"].ToString();
this.labeldzxb.Text=dataSet21.Tables["dzxxb"].Rows[0]["性别"].ToString();
this.labeldzsj.Text=dataSet21.Tables["dzxxb"].Rows[0]["手机"].ToString();
this.labelxm.Text=dataSet21.Tables["dzxxb"].Rows[0]["姓名"].ToString();
this.labelxb.Text=dataSet21.Tables["dzxxb"].Rows[0]["性别"].ToString();
JSXX();
}
}
catch(Exception Exc)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -