public DTOSanPhamCT(DataRow dongDL) { MaSP = (int)dongDL["MaSP"]; TenSP = dongDL["TenSP"].ToString(); Gia = (int)dongDL["Gia"]; dtoLoaiSP = new DTOLoaiSP(dongDL); }
public DTOSanPham(DataRow dongDL) { MaSP = (int)dongDL["MaSP"]; TenSP = dongDL["TenSP"].ToString(); Gia = (int)dongDL["Gia"]; dtoLoaiSP = new DTOLoaiSP(dongDL); //LoaiSP = new DTOLoaiSP(dongDL); soluong = (int)dongDL["soluong"]; //GiaSP = (int)dongDL["GiaSP"]; }
protected void btnLuuSP_Click(object sender, EventArgs e) { DTOLoaiSP dtoLSP = new DTOLoaiSP(); dtoLSP.TenLSP = txtLSP.Text; DAO_Entity daoLSP = new DAO_Entity(); if (KiemTraNhap() == "") { daoLSP.ThemLoaiSP(dtoLSP); Response.Redirect("~/QLBophan_Admin/QLCauHinhLoaiSP/LoaiSP.aspx"); } else { ThemLoaiSP.Visible = true; lbLoi.Text = KiemTraNhap(); } }
//Lấy TT loai sp do vao listbox public List<DTOLoaiSP> LayDSLSP() { List<DTOLoaiSP> dsLSP = new List<DTOLoaiSP>(); string lenh = "select * from LoaiSP"; 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) { DTOLoaiSP dtoLSP = new DTOLoaiSP(dongDL); dsLSP.Add(dtoLSP); } } catch (Exception) { throw; } finally { ketnoi.DongKetNoi(); } return dsLSP; }
public DTOLoaiSP LayThongTinLoaiSP(string maSua) { ketnoi.TaoKetNoi(); DTOLoaiSP dtoloaisp = null; try { string lenh = "select * from LoaiSP where MaLoai = @maSua "; 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]; dtoloaisp = new DTOLoaiSP(dong); } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return dtoloaisp; }
//Xoa LoaiKH public bool XoaLoaiSP(DTOLoaiSP dtoloaisp) { bool kq = false; ketnoi.TaoKetNoi(); try { string lenh = "delete from LoaiSP where MaLoai = @malsp"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@malsp", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@malsp"].Value = dtoloaisp.MaLSP; if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0) { kq = true; } } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return kq; }
//Them LoaiKH public bool ThemLoaiSP(DTOLoaiSP dtoloaisp) { bool kq = false; ketnoi.TaoKetNoi(); try { string lenh = " insert into LoaiSP(TenLoai) values (@tenlsp)"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); //ketnoi.LenhKetNoi.Parameters.Add("@malkh", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters.Add("@tenlsp", SqlDbType.NVarChar); //ketnoi.LenhKetNoi.Parameters["@malkh"].Value = dtoloaikh.MaLKH; ketnoi.LenhKetNoi.Parameters["@tenlsp"].Value = dtoloaisp.TenLSP; if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0) { kq = true; } } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return kq; }