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