public DTOHoaDonBH(DataRow dongDL) { MaHDBH = dongDL["MaHDBH"].ToString(); MaKH = (int)dongDL["MaKH"]; NgayHDBH = (DateTime)dongDL["NgayHDBH"]; TongTien = (int)dongDL["TongTien"]; dtoxl = new DTOXLSC_HDBH(dongDL); }
public DTOHoaDonBH(DataRow dongDL) { MaHDBH = dongDL["MaHDBH"].ToString(); MaKH = (int)dongDL["MaKH"]; NgayHDBH = (DateTime)dongDL["NgayHDBH"]; TongTien = (int)dongDL["TongTien"]; dtoxl = new DTOXLSC_HDBH(dongDL); }
protected void btnLuu_Click(object sender, EventArgs e) { if (Session["dsThanhPhamTra"] != null) { dsThanhPhamTra = (List<DTOChiTietDH>)Session["dsThanhPhamTra"]; int dem = 0; string maDH = lbMaDH.Text; foreach (DTOChiTietDH dtoCTDH in dsThanhPhamTra) { DTOXLSC_HDBH dtoct = new DTOXLSC_HDBH(); dtoct.MaDH = lbMaDH.Text; dtoct.MaSP = dtoCTDH.dtoSP.MaSP; dtoct.Soluong = dtoCTDH.SoLuong; dtoct.ThanhTien = dtoCTDH.ThanhTien; if (daoEntities.ThemXuLyTraHang(dtoct)) { DTOChiTietDH dtoChiTietDHTra = new DTOChiTietDH(); DTOChiTietDH dtoChiTietDonHangDat = daoEntities.LayChiTietDonHangTheoMaDHMaSP(maDH, dtoCTDH.dtoSP.MaSP); dtoChiTietDHTra.MaDH = lbMaDH.Text; dtoChiTietDHTra.MaSP = dtoCTDH.dtoSP.MaSP; dtoChiTietDHTra.SoLuong = dtoChiTietDonHangDat.SoLuong - dtoCTDH.SoLuong; dtoChiTietDHTra.ThanhTien = dtoChiTietDonHangDat.ThanhTien - dtoCTDH.ThanhTien; if (daoEntities.CapNhatChiTietDH(dtoChiTietDHTra)) dem++; } } if(dem == dsThanhPhamTra.Count) { DTODonDatHang dtoDonHang = daoEntities.LayDHTheoMa(maDH); int tongTienTra = int.Parse(lbTongTien.Text), tongTienDaDat = dtoDonHang.TongTien, congnoCu = dtoDonHang.CongNoDH, tongTienPhaiTra = 0, congnoConLai = 0; tongTienPhaiTra = tongTienDaDat - tongTienTra; congnoConLai = congnoCu - tongTienTra; daoEntities.CapNhatDonHang(maDH, tongTienPhaiTra, congnoConLai); } Response.Redirect(Request.RawUrl); } }
public bool ThemXuLyTraHang(DTOXLSC_HDBH dtoXL) { bool ketqua = false; ketnoi.TaoKetNoi(); try { string lenh = "insert into XLSC_HDBH(MaDH, MaSP, Soluong, ThanhTien) values (@madh, @masp, @sl, @tt)"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@madh", SqlDbType.VarChar); ketnoi.LenhKetNoi.Parameters.Add("@masp", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters.Add("@sl", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters.Add("@tt", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@madh"].Value = dtoXL.MaDH; ketnoi.LenhKetNoi.Parameters["@masp"].Value = dtoXL.MaSP; ketnoi.LenhKetNoi.Parameters["@sl"].Value = dtoXL.Soluong; ketnoi.LenhKetNoi.Parameters["@tt"].Value = dtoXL.ThanhTien; if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0) ketqua = true; } catch (Exception) { throw; } finally { ketnoi.DongKetNoi(); } return ketqua; }
public List<DTOXLSC_HDBH> LayDSXLSL_HDBH(string ma) { List<DTOXLSC_HDBH> ds = new List<DTOXLSC_HDBH>(); string lenh = "Select * from XLSC_HDBH ct, DonDH dh, KhachHang kh, SanPham sp, LoaiSP lsp, LoaiKH l where dh.MaDH=" + ma + " and kh.MaLKH=l.MaLKH and kh.MaKH=dh.MaKH and ct.MaDH=dh.MaDH and ct.MaSP=sp.MaSP and sp.MaLoai = lsp.MaLoai"; ketnoi.TaoKetNoi(); DataTable bang = new DataTable(); try { ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); //dong bo lenh ket noi voi du lieu trong database ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi); ketnoi.TichHopCSDL.Fill(bang); foreach (DataRow dongDL in bang.Rows) { DTOXLSC_HDBH dtoct = new DTOXLSC_HDBH(dongDL); ds.Add(dtoct); } } catch { throw; } finally { ketnoi.DongKetNoi(); } return ds; }