国产凌凌漆经典对白，谁知道在那下或者谁直接发我QQ。。

更新时间2018-03-12 14:05:49

sssusing System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace WindowsApplication1
{
public partial class frmAddBooks : Form
{ public frmAddBooks()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
try
{
if (DBHelper.connection.State != ConnectionState.Open)
{ DBHelper.connection.Open();
}
int num1;
int num2;
if(cmbchuban.Text=="人民出版社")
{
num1 = 2;
}
else if (cmbchuban.Text == "科学技术出版社")
{
num1 = 1;
}
else
{
num1 = 3;
}
if (cmbtype.Text=="计算机类")
{
num2 = 1;
}
else if (cmbtype.Text == "文学类")
{
num2 = 2;
}
else
{
num2 = 3;
} string sql = string.Format("insert Book values({0},"{1}",{2},{3},"{4}",{5},{6},"{7}")", textbianhao.Text, textmingcheng.Text,num1, num2, textcunfang.Text, textshuliang.Text, textjiage.Text, textshijian.Text);
SqlCommand command = new SqlCommand(sql, DBHelper.connection);
int count = command.ExecuteNonQuery();
if (count == 1)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message);
}
finally
{
if (DBHelper.connection.State != ConnectionState.Closed)
{
DBHelper.connection.Close();
}
}
} private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
}
}