private void LoadData()
{
DTO_QuyDinh qd = qdd.QuyDinh();
txtSoDLToiDa.Text = qd.SoDLToiDa.ToString();
txtSoLuongQuan.Text = qd.SoQuan.ToString();
txtSLMatHang.Text = qd.SoMatHang.ToString();
txtSLDonViTinh.Text = qd.SoDVT.ToString();
}
private DTO_QuyDinh QuyDinh()
{
DTO_QuyDinh q = new DTO_QuyDinh();
q.SoDLToiDa = int.Parse(txtSoDLToiDa.Text);
q.SoDVT = int.Parse(txtSLDonViTinh.Text);
q.SoMatHang = int.Parse(txtSLMatHang.Text);
q.SoQuan = int.Parse(txtSoLuongQuan.Text);
return(q);
}
public void CapNhatTheLe_INSERT(DTO_QuyDinh dl)
{
//"set dateformat dmy Insert into PhieuMuonSach Values ('" + dl.ID_TheDocGia + "',N'" + dl.ID_Sach + "','" + dl.Ten_NguoiMuon + "','" + dl.NgayMuon + "','" + dl.NgayHenTra + "','" + dl.Sl_SachMuon + "','" + dl.GhiChu + "','" + dl.TrangThai_PhieuMuon + "')"
xl.table_Command(" insert into TheLoaiSach values('" + dl.TheLoaiThayDoi + "','')");
}
public DataTable dtgLoad_Select(DTO_QuyDinh dl)
{
return(xl.table_Select("select ID_TheLoaiSach,Ten_TheLoaiSach from TheLoaiSach"));
}
public void CapNhatThayDoi_INSERT(DTO_QuyDinh dl)
{
//"set dateformat dmy Insert into PhieuMuonSach Values ('" + dl.ID_TheDocGia + "',N'" + dl.ID_Sach + "','" + dl.Ten_NguoiMuon + "','" + dl.NgayMuon + "','" + dl.NgayHenTra + "','" + dl.Sl_SachMuon + "','" + dl.GhiChu + "','" + dl.TrangThai_PhieuMuon + "')"
xl.table_Command(" UPDATE QuyDinh SET TuoiToiDa = '" + dl.TuoiToiDaThayDoi + "', TuoiToiThieu = '" + dl.TuoiToiThieuThayDoi + "',ThoiHanThe ='" + dl.ThoiHanTheThayDoi + "', NamXuatBan ='" + dl.NamXuatBanThayDoi + "', SoSachMuonToiDa = '" + dl.SoSachMuonToiDaThayDoi + "', SoNgayMuonToiDa = '" + dl.SoNgayMuonToiDaThayDoi + "' WHERE ID_QuyDinh = 1");
}
public DataTable Load_Select(DTO_QuyDinh dl)
{
return(xl.table_Select("select * from QuyDinh"));
}
public bool ChinhSuaQuyDinh(DTO_QuyDinh q)
{
return(qd.ChinhSuaQuyDinh(q));
}
