public void Sua(NoiSanXuatDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Update DanhMucNoiSanXuat Set MaNoiSanXuat = ?, TenNoiSanXuat = ?, GhiChu = ? Where Id = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaBacSy", OleDbType.WChar).Value = itemDTO.MaNoiSanXuat;
cmd.Parameters.Add("@TenBacSy", OleDbType.WChar).Value = itemDTO.TenNoiSanXuat;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;
cmd.ExecuteNonQuery();
cn.Close();
}
public void Them(NoiSanXuatDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Insert into DanhMucNoiSanXuat (MaNoiSanXuat,TenNoiSanXuat,GhiChu) values (?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaNoiSanXuat", OleDbType.WChar).Value = itemDTO.MaNoiSanXuat;
cmd.Parameters.Add("@TenNoiSanXuat", OleDbType.WChar).Value = itemDTO.TenNoiSanXuat;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.ExecuteNonQuery();
cn.Close();
}
public BindingList<NoiSanXuatDTO> LayDanhSach()
{
BindingList<NoiSanXuatDTO> danhSach = new BindingList<NoiSanXuatDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From DanhMucNoiSanXuat";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
NoiSanXuatDTO itemDTO = new NoiSanXuatDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.MaNoiSanXuat = (string)dr["MaNoiSanXuat"];
itemDTO.TenNoiSanXuat = (string)dr["TenNoiSanXuat"];
itemDTO.GhiChu = (string)dr["GhiChu"];
danhSach.Add(itemDTO);
}
return danhSach;
}
public void Them(NoiSanXuatDTO itemDTO)
{
NoiSanXuatDAO itemDAO = new NoiSanXuatDAO();
itemDAO.Them(itemDTO);
}
public void Sua(NoiSanXuatDTO itemDTO)
{
NoiSanXuatDAO itemDAO = new NoiSanXuatDAO();
itemDAO.Sua(itemDTO);
}
