public void loaddvp()
{
//kn.Open();
//string sql = "SELECT dv.MA_DV N'Mã dịch vụ', dv.TEN N'Tên', ldv.LOAIDICHVU N'Loại',dv.GIA N'Giá',dv.DONVITINH N'Đơn vị tính',ctdv.soluong N'Số lượng' FROM dbo.CHITIETDICHVU ctdv, dbo.DICHVU dv, dbo.LOAIDICHVU ldv WHERE dv.MA_LDV = ldv.MA_LDV AND ctdv.MA_DV = dv.MA_DV AND ctdv.MA_PDP = '"+maPdp+"'";
//SqlCommand commandsql = new SqlCommand(sql, kn);
//SqlDataAdapter com = new SqlDataAdapter(commandsql);
//DataTable data = new DataTable();
//com.Fill(data);
//tb_dvp.DataSource = data;
//kn.Close();
oldList = client.getDichVuPdp(idPdp).ToList();
bindData();
}
public void LayTTDV()
{
List <chitietdichvu> list = new List <chitietdichvu>();
list = client.getDichVuPdp(idpdp).ToList();
tb_dv.AutoSize = true;
tb_dv.DataSource = list.Select(c => new { id = c.Dichvu.Id, ten = c.Dichvu.Name, loai = c.Dichvu.Loaidichvu.Loai, gia = c.Dichvu.Gia, dvt = c.Dichvu.Donvitinh, soluong = c.Soluong }).ToList();
double countdv = 0;
for (int i = 0; i < list.Count; i++)
{
countdv = countdv + list[i].Soluong * list[i].Dichvu.Gia;
}
lb_chiphi.Text = countdv.ToString();
}
