数据库课程设计报告 (销售管理)(8)

string comandstr = \

foreach (ListViewItem item in listView4.Items)

{

comandstr = \采购 ( 账单编号,名称,进货数量,单价\

+ \供货商姓名,采购员编号,进货日期,采购员姓名)values('\ comandstr += item.SubItems[0].Text; comandstr += \ comandstr += item.SubItems[1].Text; comandstr += \

comandstr += item.SubItems[2].Text; comandstr += \

comandstr += item.SubItems[3].Text; comandstr += \

comandstr += item.SubItems[4].Text; comandstr += \ comandstr += label7.Text; comandstr += \

comandstr += item.SubItems[5].Text; comandstr += \

comandstr += label6.Text;

comandstr += \

SqlConnection conn = new SqlConnection (Resource1.String1);

SqlCommand Com = conn.CreateCommand(); try {

conn.Open();

Com.CommandText = comandstr; Com.ExecuteNonQuery(); }

catch (Exception ec)

{

MessageBox.Show(\添加失败\ goto end; }

conn.Close();

} } else

{

MessageBox.Show(\请输入账单\ }

MessageBox.Show(\添加成功\

- 35 -

end: ;

}

private void BForm_Load(object sender, EventArgs e) {

SqlConnection conn = null; string comdstr = \

string comdstr1 = \

SqlCommand mycomand = null; SqlDataReader dr = null; SqlCommand mycomand1 = null; SqlDataReader dr1 = null; try {

conn = new SqlConnection(Resource1.String1); comdstr1 = \商品名称,库存量 from 库存\ mycomand1 = new SqlCommand(comdstr1, conn); conn.Open();

dr1 = mycomand1.ExecuteReader(); listView1.Items.Clear(); while (dr1.Read())

{

ListViewItem item = new ListViewItem(dr1[0].ToString().Trim(' ')); item.SubItems.Add(dr1[1].ToString()); listView1.Items.Add(item);

}

dr1.Close();

comdstr = \姓名,电话,手机,\邮箱,地址,结余,公司名称 from 供货商\ mycomand = new SqlCommand(comdstr, conn); dr = mycomand.ExecuteReader(); listView3.Items.Clear(); while (dr.Read()) {

ListViewItem item = new ListViewItem(dr[0].ToString().Trim(' ')); item.SubItems.Add(dr[1].ToString().Trim(' ')); item.SubItems.Add(dr[2].ToString().Trim(' ')); item.SubItems.Add(dr[3].ToString().Trim(' ')); item.SubItems.Add(dr[4].ToString().Trim(' '));

item.SubItems.Add(dr[5].ToString());

item.SubItems.Add(dr[6].ToString().Trim(' ')); listView3.Items.Add(item);

- 36 -

}

}

finally {

conn.Close(); } }

private void button9_Click(object sender, EventArgs e) {

listView4.Items.Clear(); button7.Visible = true; }

private void button10_Click(object sender, EventArgs e) {

if (listView3.SelectedItems.Count != 0) {

int i = 0;

while (i < listView4.Items.Count)

{

listView4.Items[i].SubItems[4].Text =

listView3.SelectedItems[0].SubItems[0].Text; i++; }

} else {

MessageBox.Show(\请选择供货商\ } }

private void button4_Click(object sender, EventArgs e) {

string Commstr = \

SqlConnection con = new SqlConnection(Resource1.String1); SqlCommand Comm = con.CreateCommand(); try

{

Commstr = \采购 where 账单编号='\ if (listView4.SelectedItems.Count != 0) {

- 37 -

Commstr += listView4.SelectedItems[0].SubItems[0].Text; Commstr += \名称='\

Commstr += listView4.SelectedItems[0].SubItems[1].Text; Commstr += \

Comm.CommandText = Commstr; con.Open();

Comm.ExecuteNonQuery();

listView4.Items.Remove(listView4.SelectedItems[0]); }

} finally {

con.Close(); } }

private void button8_Click(object sender, EventArgs e) {

string Commstr = \

SqlConnection con = new SqlConnection(Resource1.String1); SqlCommand Comm = con.CreateCommand(); try {

Commstr = \采购 set 进货数量=\ if (listView4.SelectedItems.Count != 0)

{

Commstr += listView4.SelectedItems[0].SubItems[2].Text; Commstr += \单价=\

Commstr += listView4.SelectedItems[0].SubItems[3].Text; Commstr += \账单编号='\

Commstr += listView4.SelectedItems[0].SubItems[0].Text; Commstr += \名称='\

Commstr += listView4.SelectedItems[0].SubItems[1].Text; Commstr += \

Comm.CommandText = Commstr; con.Open();

Comm.ExecuteNonQuery(); }

}

finally

- 38 -

{

con.Close();

}

MessageBox.Show(\修改成功\ }

private void listView4_SelectedIndexChanged(object sender, EventArgs e) {

if (listView4.SelectedItems.Count != 0) {

textBox1.Text = listView4.SelectedItems[0].SubItems[1].Text; textBox2.Text = listView4.SelectedItems[0].SubItems[2].Text; textBox5.Text = listView4.SelectedItems[0].SubItems[3].Text; } }

private void button2_Click(object sender, EventArgs e) {

xiugai xu = new xiugai();

if (listView3.SelectedItems.Count != 0)

{

xu.textBox1.Text = listView3.SelectedItems[0].SubItems[0].Text;

xu.textBox2.Text = listView3.SelectedItems[0].SubItems[1].Text; xu.textBox3.Text = listView3.SelectedItems[0].SubItems[2].Text; xu.textBox4.Text = listView3.SelectedItems[0].SubItems[3].Text; xu.textBox5.Text = listView3.SelectedItems[0].SubItems[4].Text;

xu.textBox6.Text = listView3.SelectedItems[0].SubItems[5].Text; xu.textBox7.Text = listView3.SelectedItems[0].SubItems[6].Text; listView3.Items.Remove(listView3.SelectedItems[0]); }

xu.Show(); }

private void button5_Click(object sender, EventArgs e) {

xiugai xu = new xiugai(); xu.Show(); }

private void button6_Click(object sender, EventArgs e) {

string Commstr = \

SqlConnection con = new SqlConnection(Resource1.String1); SqlCommand Comm = con.CreateCommand();

- 39 -

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库数据库课程设计报告 (销售管理)(8)在线全文阅读。