public DTOKhoSP LaySoLuongKhoSP(int ma) { ketnoi.TaoKetNoi(); DTOKhoSP dtoDH = null; try { string lenh = "Select * from KhoSP k, SanPham sp, LoaiSP l where k.MaSP=sp.MaSP and sp.MaLoai=l.MaLoai and k.MaSP=@ma"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@ma", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@ma"].Value = ma; DataTable bang = new DataTable(); ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi); ketnoi.TichHopCSDL.Fill(bang); DataRow dong = bang.Rows[0]; dtoDH = new DTOKhoSP(dong); } catch (Exception) { throw; } finally { ketnoi.DongKetNoi(); } return dtoDH; }
public List<DTOKhoSP> LayDSKhoSP() { List<DTOKhoSP> ds = new List<DTOKhoSP>(); string lenh = "Select * from KhoSP k, SanPham sp, LoaiSP l where sp.MaLoai=l.MaLoai and k.MaSP=sp.MaSP"; 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) { DTOKhoSP dtoct = new DTOKhoSP(dongDL); ds.Add(dtoct); } } catch { throw; } finally { ketnoi.DongKetNoi(); } return ds; }
public bool CapNhatSLKhoSP(DTOKhoSP dtoKho) { bool ketqua = false; ketnoi.TaoKetNoi(); try { string lenh = "update KhoSP set Soluong = @sl where MaSP=@ma"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@ma", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters.Add("@sl", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@ma"].Value = dtoKho.MaSP; ketnoi.LenhKetNoi.Parameters["@sl"].Value = dtoKho.Soluong; if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0) ketqua = true; } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return ketqua; }
protected void btnThemSP_Click(object sender, EventArgs e) { XemDSKho.Visible = true; DTOXuLyPhieuGiao dtoct = new DTOXuLyPhieuGiao(); // DTODonDatHang dtoDH = new DTODonDatHang(); dtoct.MaDH = lbMaDH.Text; DTOSanPham dtoSP = new DTOSanPham(); dtoct.MaSP = int.Parse(ddTP.SelectedValue); // dtoSP.TenSP = ddTP.SelectedItem.ToString(); //dtoct.dtoSP = dtoSP; //dtoct.dtoDH = dtoDH; //dtoSP.TenSP = ddTP.SelectedValue; dtoct.SoLuong = int.Parse(txtSoLuong.Text); dtoct.ThanhTien = int.Parse(lbgia.Text) * int.Parse(txtSoLuong.Text); //BLLXuLyDonHang bll = new BLLXuLyDonHang(); //bll.ThemChiTietDH(dtoct); DTOKhoSP dtokho = new DTOKhoSP(); dtokho.MaSP = int.Parse(ddTP.SelectedValue); dtokho.Soluong = int.Parse(lbSLKho.Text) - int.Parse(txtSoLuong.Text); DAO_Entity dao = new DAO_Entity(); dao.CapNhatSLKhoSP(dtokho); DAO_Entity daokh = new DAO_Entity(); daokh.ThemPhieuGiaoHang(dtoct); Response.Redirect(Request.RawUrl); }