public DTOChiTietPhieuNhapVL(DataRow dong) { dtoPhieuNhapVL = new DTOPhieuNVL_SX(dong); dtoVatLieu = new DTOVatLieu(dong); SoLuongThuc = (int)dong["Soluongthuc"]; SoLuongGiao = (int)dong["Soluonggiao"]; }
public DTOChiTietPhieuDatNCC(DataRow dong) { PhieuDat = new DTOPhieuDatVatLieuCC(dong); dtoVatLieu = new DTOVatLieu(dong); SoLuong = (int)dong["SoLuong"]; ThanhTien = (decimal)dong["Thanhtien"]; }
public DTOChiTietPhieuDatNCC(DataRow dong) { PhieuDat = new DTOPhieuDatVatLieuCC(dong); dtoVatLieu = new DTOVatLieu(dong); SoLuong = (int)dong["SoLuong"]; ThanhTien = (decimal)dong["Thanhtien"]; }
public DTOChiTietPhieuNhapVL(DataRow dong) { dtoPhieuNhapVL = new DTOPhieuNVL_SX(dong); dtoVatLieu = new DTOVatLieu(dong); SoLuongThuc = (int)dong["Soluongthuc"]; SoLuongGiao = (int)dong["Soluonggiao"]; }
public DTOChiTietPhieuGiao(DataRow dong) { dtoPhieuGiao = new DTOPhieuGiao(dong); dtoVatLieu = new DTOVatLieu(dong); SoluongGiao = (int)dong["SoLuongGiao"]; }
public DTOChiTietPhieuGiao(DataRow dong) { dtoPhieuGiao = new DTOPhieuGiao(dong); dtoVatLieu = new DTOVatLieu(dong); SoluongGiao = (int)dong["SoLuongGiao"]; }
public DTOVatLieu LayThongTinVatLieu(string maSua) { ketnoi.TaoKetNoi(); DTOVatLieu dtoVL = null; try { string lenh = "select * from VatLieu,NhaCungCap where MaVL = @maSua and VatLieu.MaNCC = NhaCungCap.MaNCC "; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@maSua", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@maSua"].Value = maSua; DataTable bang = new DataTable(); ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi); ketnoi.TichHopCSDL.Fill(bang); DataRow dong = bang.Rows[0]; dtoVL = new DTOVatLieu(dong); } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return dtoVL; }
public bool XoaVatLieu(DTOVatLieu dtoVL) { bool kq = false; ketnoi.TaoKetNoi(); try { string lenh = "delete from VatLieu where MaVL = @mavl"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@mavl", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@mavl"].Value = dtoVL.MaVL; if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0) { kq = true; } } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return kq; }
public bool capnhatdanhsach(DTOVatLieu dtoVL) { bool kq = false; ketnoi.TaoKetNoi(); try { string lenh = "update VatLieu set TenVL = @tenvl , MaNCC = @mancc , Donvi = @donvi ,Gia = @gia where MaVL = @maVL"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@maVL", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters.Add("@tenvl", SqlDbType.NVarChar); ketnoi.LenhKetNoi.Parameters.Add("@mancc", SqlDbType.Int);//mancc ketnoi.LenhKetNoi.Parameters.Add("@donvi", SqlDbType.NVarChar); ketnoi.LenhKetNoi.Parameters.Add("@gia", SqlDbType.Decimal); ketnoi.LenhKetNoi.Parameters.Add("@sl", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@maVL"].Value = dtoVL.MaVL; ketnoi.LenhKetNoi.Parameters["@tenvl"].Value = dtoVL.TenVL; ketnoi.LenhKetNoi.Parameters["@mancc"].Value = dtoVL.dtoNCC.MaNCC; ketnoi.LenhKetNoi.Parameters["@donvi"].Value = dtoVL.Donvi; ketnoi.LenhKetNoi.Parameters["@gia"].Value = dtoVL.Gia; ketnoi.LenhKetNoi.Parameters["@sl"].Value = dtoVL.Soluong; if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0) { kq = true; } } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return kq; }
//ThemVL public bool ThemVatLieu(DTOVatLieu dtoVL) { bool kq = false; ketnoi.TaoKetNoi(); try { string lenh = " insert into VatLieu (TenVL ,MaNCC ,Donvi ,Gia, SoLuong) values (@tenvl ,@mancc ,@donvi ,@gia, @sl)"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); //ketnoi.LenhKetNoi.Parameters.Add("@maVL", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters.Add("@tenvl", SqlDbType.NVarChar); ketnoi.LenhKetNoi.Parameters.Add("@mancc", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters.Add("@donvi", SqlDbType.NVarChar); ketnoi.LenhKetNoi.Parameters.Add("@gia", SqlDbType.Decimal); ketnoi.LenhKetNoi.Parameters.Add("@sl", SqlDbType.Int); //ketnoi.LenhKetNoi.Parameters["@maVL"].Value = dtoVL.MaVL; ketnoi.LenhKetNoi.Parameters["@tenvl"].Value = dtoVL.TenVL; ketnoi.LenhKetNoi.Parameters["@mancc"].Value = dtoVL.dtoNCC.MaNCC; ketnoi.LenhKetNoi.Parameters["@donvi"].Value = dtoVL.Donvi; ketnoi.LenhKetNoi.Parameters["@gia"].Value = dtoVL.Gia; ketnoi.LenhKetNoi.Parameters["@sl"].Value = dtoVL.Soluong; if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0) { kq = true; } } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return kq; }
// Tao danh sach Vat Lieu public List<DTOVatLieu> TaoDSVL() { List<DTOVatLieu> ds = new List<DTOVatLieu>(); string lenh = "select * from VatLieu VL ,NhaCungCap NCC where VL.MaNCC = NCC.MaNCC"; ketnoi.TaoKetNoi(); DataTable bang = new DataTable(); try { ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi); ketnoi.TichHopCSDL.Fill(bang); foreach (DataRow dongDL in bang.Rows) { DTOVatLieu dtovl = new DTOVatLieu(dongDL); ds.Add(dtovl); } } catch (Exception) { throw; } finally { ketnoi.DongKetNoi(); } return ds; }