public static bool saveLogistic(Logistic s) { String sql = "insert into logistic( lNo, eNo, wNo, time, addressee, address_in)"; sql += " values('" + s.lNo + "', '" + s.eNo; sql += "', '" + s.wNo + "', '" + s.time + "', '" + s.addressee; sql += "', '" + s.address_in + "')"; return(execNonQuery(sql)); }
private void Button2_Click(object sender, EventArgs e) { if (choose.Count == 0) { MessageBox.Show("请你添加商品"); return; } string addressee = textBox1.Text; string logiNo = textBox4.Text; string time = textBox2.Text; string warehouseNo = chooseWNo; string address_in = textBox3.Text; if (logiNo == "" || time == "" || addressee == "" || address_in == "") { MessageBox.Show("请完整填写信息"); return; } Logistic temp = new Logistic(logiNo, companyNo, warehouseNo, time, addressee, address_in); if (LogisticCtrl.saveLogistic(temp) == false) { MessageBox.Show("添加快递单出错"); return; } for (int i = 0; i < choose.Count; i++) { Detail.Detail detail = new Detail.Detail(logiNo, choose[i].SubItems[0].Text, choose[i].SubItems[5].Text); if (DetailCtrl.saveDetail(detail) == false) { LogisticCtrl.recoverStock(choose[i].SubItems[0].Text, warehouseNo, choose[i].SubItems[5].Text); MessageBox.Show("添加快递流水出错"); return; } } choose.Clear(); Button4_Click(null, null); MessageBox.Show("添加成功"); return; }