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);
}
public void xuatpgiao(DTOXuLyPhieuGiao dtoCtDH)
{
DAO_Entity dao = new DAO_Entity();
dao.ThemPhieuGiaoHang(dtoCtDH);
}
public bool ThemPhieuGiaoHang(DTOXuLyPhieuGiao dtoCtDH)
{
bool ketqua = false;
ketnoi.TaoKetNoi();
try
{
string lenh = "insert into XuLyPhieuGiao(MaDH, MaSP, SoLuong, ThanhTien) values (@madh, @masp, @sl, @tt)";
ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi);
ketnoi.LenhKetNoi.Parameters.Add("@madh", SqlDbType.VarChar);
ketnoi.LenhKetNoi.Parameters.Add("@masp", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters.Add("@sl", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters.Add("@tt", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters["@madh"].Value = dtoCtDH.MaDH;
ketnoi.LenhKetNoi.Parameters["@masp"].Value = dtoCtDH.MaSP;
ketnoi.LenhKetNoi.Parameters["@sl"].Value = dtoCtDH.SoLuong;
ketnoi.LenhKetNoi.Parameters["@tt"].Value = dtoCtDH.ThanhTien;
if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0)
ketqua = true;
}
catch (Exception)
{
throw;
}
finally
{
ketnoi.DongKetNoi();
}
return ketqua;
}
public List<DTOXuLyPhieuGiao> LayDSPhieuGiao(string ma)
{
List<DTOXuLyPhieuGiao> ds = new List<DTOXuLyPhieuGiao>();
string lenh = "Select * from XuLyPhieuGiao ct, DonDH dh, KhachHang kh, SanPham sp, LoaiSP lsp, LoaiKH l where dh.MaDH=" + ma + " and kh.MaLKH=l.MaLKH and kh.MaKH=dh.MaKH and ct.MaDH=dh.MaDH and ct.MaSP=sp.MaSP and sp.MaLoai = lsp.MaLoai";
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)
{
DTOXuLyPhieuGiao dtoct = new DTOXuLyPhieuGiao(dongDL);
ds.Add(dtoct);
}
}
catch
{
throw;
}
finally
{
ketnoi.DongKetNoi();
}
return ds;
}
