public void delete(dtohoadon k)
{
openC();
SqlCommand cmd = new SqlCommand("sp_delete_HOADON", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MAHD", k.MAHD));
cmd.ExecuteNonQuery();
closeC();
}
public void insert(dtohoadon k)
{
openC();
SqlCommand cmd = new SqlCommand("sp_insert_HOADON", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MAHD", k.MAHD));
cmd.Parameters.Add(new SqlParameter("@NGAY", k.NGAY));
cmd.Parameters.Add(new SqlParameter("@MAKHACH", k.MAKHACH));
cmd.Parameters.Add(new SqlParameter("@MANV", k.MANV));
cmd.Parameters.Add(new SqlParameter("@TONGTIEN", k.TONGTIEN));
cmd.Parameters.Add(new SqlParameter("@CHIETKHAU", k.CHIETKHAU));
cmd.ExecuteNonQuery();
closeC();
}
