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

listView8.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()); item.SubItems.Add(dr[3].ToString()); }

//客户信息查看

item.SubItems.Add(dr[4].ToString().Trim(' '));

item.SubItems.Add(DateTime.Parse(dr[5].ToString()).Year.ToString() + \ + \listView8.Items.Add(item); comdstr = \客户姓名,联系手机,联系电话,\

+ \邮箱,地址,结余,公司名称,上次联系时间 from 客户\ mycomand = new SqlCommand(comdstr, con); con.Open();

dr = mycomand.ExecuteReader(); listView6.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(' ')); item.SubItems.Add(dr[7].ToString()); listView6.Items.Add(item); }//供货商查询

comdstr = \姓名,电话,手机,\

+ \邮箱,地址,结余,公司名称 from 供货商\ mycomand = new SqlCommand(comdstr, con); con.Open();

dr = mycomand.ExecuteReader(); listView5.Items.Clear(); while (dr.Read()) {

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

- 20 -

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(' ')); listView5.Items.Add(item); }

4.3、采购模块

1.库存查询 2.采购单查询 3.供货商查询

4.修改、删除采购单

- 21 -

conn = new SqlConnection(Resource1.String1);

comdstr = \账单编号,名称,进货数量,单价,供货商姓名,进货日期 from

采购\

mycomand = new SqlCommand(comdstr, conn); conn.Open();

dr = mycomand.ExecuteReader(); listView4.Items.Clear(); while (dr.Read()) {

try {

chaxun = (textBox3.Text.Trim(' ') == \

== dr[4].ToString().Trim(' ')) && (textBox4.Text.Trim(' ') == \

dr[0].ToString().Trim(' ')) && (textBox7.Text.Trim(' ') == \

DateTime.Parse(dr[5].ToString()).Year.ToString()) && (textBox6.Text.Trim(' ') == \ DateTime.Parse(dr[5].ToString()).Month.ToString())

&& (textBox8.Text.Trim(' ') == \

DateTime.Parse(dr[5].ToString()).Day.ToString());

}

catch (Exception ex) {

MessageBox.Show(\请输入正确的日期\ } if (chaxun)

{

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

item.SubItems.Add(dr[4].ToString().Trim(' '));

item.SubItems.Add(DateTime.Parse(dr[5].ToString()).Year.ToString()

+\DateTime.Parse(dr[5].ToString()).Month.ToString()+ \DateTime.Parse(dr[5].ToString()).Day.ToString());

listView4.Items.Add(item); zhaodao = false; } }

if (zhaodao)

{

MessageBox.Show(\该账单不存在，请检查输入是否正确\

- 22 -

+

} }

finally {

conn.Close(); } }

private void button1_Click(object sender, EventArgs e) {

if (!(textBox1.Text.Trim(' ')!=\ textBox2.Text.Trim(' ') !=\ textBox5.Text.Trim(' ')!=\ {

MessageBox.Show(\请先输入\ goto end; }

DateTime dt = new DateTime(System.DateTime.Today.Year, System.DateTime.Today.Month, System.DateTime.

Today.Day, System.DateTime.Now.Hour,

System.DateTime.Now.Minute, System.DateTime.Now.Second);

bool fin = false; int i = 0;

foreach (ListViewItem item in listView4.Items) {

if (textBox1.Text == item.SubItems[1].Text) {

fin = true; break; } i++; } if (fin) {

listView4.Items[i].SubItems[2].Text = textBox2.Text; listView4.Items[i].SubItems[3].Text = textBox5.Text; } else {

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

- 23 -

ListViewItemitem = new ListViewItem(listView4.Items[0].SubItems[0].Text); item.SubItems.Add(textBox1.Text);

item.SubItems.Add(textBox2.Text); item.SubItems.Add(textBox5.Text);

item.SubItems.Add(listView4.Items[0].SubItems[4].Text); item.SubItems.Add(listView4.Items[0].SubItems[5].Text);

listView4.Items.Add(item); } else { try

{

ListViewItem item = new ListViewItem(dt.Year.ToString() +dt.Month.ToString().PadLeft(2,'0')+

dt.Day.ToString().PadLeft(2,'0')+dt.Hour.ToString().PadLeft(2,'0')+ dt.Minute.ToString().PadLeft(2, '0').PadLeft(2, '0') + dt.Second.ToString().PadLeft(2, '0'));

item.SubItems.Add(textBox1.Text); item.SubItems.Add(textBox2.Text); item.SubItems.Add(textBox5.Text); item.SubItems.Add(\

item.SubItems.Add(dt.Year.ToString() + \

+ dt.Day.ToString()); listView4.Items.Add(item); }

catch (Exception ex) {

MessageBox.Show(\请先输入\ } }

} end: ; }

private void button7_Click(object sender, EventArgs e) {

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

string comandstr = \

foreach (ListViewItem item in listView4.Items)

{

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

- 24 -

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