private void listView4_DoubleClick(object sender, EventArgs e) { if (listView4.SelectedItems.Count != 1 || listView3.SelectedItems.Count != 1) { MessageBox.Show("请选择要删除的产品和订单"); return; } DateTime t1 = Convert.ToDateTime(listView3.SelectedItems[0].SubItems[3].Text).Date; DateTime t2 = DateTime.Now.Date; if (DateTime.Compare(t1, t2) <= 0) { MessageBox.Show("此快递单不能修改"); return; } string lNo = this.listView3.SelectedItems[0].SubItems[0].Text.ToString(); string wName = this.listView3.SelectedItems[0].SubItems[2].Text.ToString(); string pNo = this.listView4.SelectedItems[0].SubItems[0].Text.ToString(); string num = this.listView4.SelectedItems[0].SubItems[2].Text.ToString(); Hashtable hs = Productctrl.listDept(); string wNo = (string)hs[wName]; if (DetailCtrl.deleteDetail(lNo, pNo, num, wNo)) { MessageBox.Show("删除产品成功!"); } ListView3_Click(null, null); if (DetailCtrl.lnum(lNo) == 0) { LogisticCtrl.loadLogistic(listView3); } }
public static bool deleteLogistic(string logiNo) { LogisticCtrl.recoverStock(logiNo); String sql = " delete from logistic " + " where lNo ='" + logiNo + "'"; DetailCtrl.deleteDetail(logiNo); return(execNonQuery(sql)); }