public static List <ChiTietHDBH_DTO> TinhTongTien(ChiTietHDBH_DTO ChiTietHDBH_DTO)
{
List <ChiTietHDBH_DTO> Danhsach = new List <ChiTietHDBH_DTO>();
ChiTietHDBH_DTO CTHD;
try
{
con.Open();
SqlCommand cmd = new SqlCommand("proc_CTHD3", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaHD", ChiTietHDBH_DTO.MaHoaDon);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
CTHD = new ChiTietHDBH_DTO();
CTHD.MaHoaDon = reader["MaHoaDon"].ToString();
CTHD.TongTien = Int32.Parse(reader["TongTien"].ToString());
Danhsach.Add(CTHD);
}
reader.Close();
cmd.Dispose();
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(Danhsach);
}
private void frmChiTietHDBH_Load(object sender, EventArgs e)
{
LoadCT();
ChiTietHDBH_DTO ct = new ChiTietHDBH_DTO();
ct.MaHoaDon = tbMaHD.Text;
List <ChiTietHDBH_DTO> List = ChiTietHDBH_BUS.TinhTongTien(ct);
tbTongTien.Text = List[0].TongTien.ToString();
}
public void LoadCT()
{
ChiTietHDBH_DTO ct = new ChiTietHDBH_DTO();
ct.MaHoaDon = tbMaHD.Text;
List <ChiTietHDBH_DTO> List = ChiTietHDBH_BUS.Show_HDBH(ct);
foreach (var item in List)
{
ListViewItem Temon = new ListViewItem(item.TenMon.ToString());
Temon.SubItems.Add(item.SoLuong.ToString());
Temon.SubItems.Add(item.DonGia.ToString());
Temon.SubItems.Add(item.ThanhTien.ToString());
listView1.Items.Add(Temon);
}
}
public static List <ChiTietHDBH_DTO> TinhTongTien(ChiTietHDBH_DTO ChiTietHDBH_DTO)
{
return(ChiTietHDBH_DAO.TinhTongTien(ChiTietHDBH_DTO));
}
public static List <ChiTietHDBH_DTO> Show_HDBH(ChiTietHDBH_DTO ChiTietHDBH_DTO)
{
return(ChiTietHDBH_DAO.Show_HDBH(ChiTietHDBH_DTO));
}
