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

Commstr += \

Comm.CommandText = Commstr;

con.Open();

Comm.ExecuteNonQuery();

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

}

catch (Exception ex)

{

MessageBox.Show(\删除失败\ }

con.Close();

}

private void label6_Click(object sender, EventArgs e) { } } }

- 30 -

4.4、销售模块

1.库存查询 2.客户查询

3.添加，修改，删除订单

bool chaxun = false; bool zhaodao = true; button7.Visible = false; SqlConnection conn = null; string comdstr = \

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

conn = new SqlConnection(Resource1.String1);

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

采购\

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

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

- 31 -

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()

+ \

+ \

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

}

if (zhaodao) {

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

conn.Close(); } }

- 32 -

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) {

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); }

- 33 -

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 listView1_SelectedIndexChanged(object sender, EventArgs e) {

if (listView1.SelectedItems.Count != 0)

{

textBox1.Text = listView1.SelectedItems[0].Text; textBox2.Text = listView1.SelectedItems.Count.ToString(); } }

private void button7_Click(object sender, EventArgs e) {

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

- 34 -

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