private ctHoadon getChiTietHoaDon(int i) { ctHoadon hd = new ctHoadon(); hd.MaHD = txt_mahd.Text; hd.Solothuoc = dg_ctiet.Rows[i].Cells[6].Value.ToString().Trim(); hd.Soluong = dg_ctiet.Rows[i].Cells[2].Value.ToString().Trim(); hd.Dongia = dg_ctiet.Rows[i].Cells[3].Value.ToString().Trim(); hd.Mathuoc = dg_ctiet.Rows[i].Cells[0].Value.ToString().Trim(); return(hd); }
public void delete(ctHoadon ch) { openC(); SqlCommand cmd = new SqlCommand("sp_delete_ctHoadon", con); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); closeC(); }
public void update(ctHoadon ch) { openC(); SqlCommand cmd = new SqlCommand("sp_update_ctHoadon", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maHD", ch.MaHD)); cmd.Parameters.Add(new SqlParameter("@solothuoc", ch.Solothuoc)); cmd.Parameters.Add(new SqlParameter("@mathuoc", ch.Mathuoc)); cmd.Parameters.Add(new SqlParameter("@soluong", ch.Soluong)); cmd.Parameters.Add(new SqlParameter("@dongia", ch.Dongia)); cmd.ExecuteNonQuery(); closeC(); }
public void delete(ctHoadon ch) { cth.delete(ch); }
public void update(ctHoadon ch) { cth.update(ch); }
public void insert(ctHoadon ch) { cth.insert(ch); }