public int ThemCT_PhieuBanHang(CT_PhieuBanHangDTO ctpbh) { string sql = string.Format("insert into CT_Phieu_Ban_Hang(MaPhieuBanHang, MaSanPham, TenSanPham, SoLuong, DonVi, LoaiGia, DonGia, ThanhTien, CK, ChietKhau, ThanhToan, ViTri)" + "values('{0}', '{1}', N'{2}',{3}, N'{4}',{5}, {6}, {7}, {8}, {9}, {10}, {11})", ctpbh.MaPhieuBanHang, ctpbh.MaSanPham, ctpbh.TenSanPham, ctpbh.SoLuong, ctpbh.DonVi, ctpbh.LoaiGia, ctpbh.DonGia, ctpbh.ThanhTien, ctpbh.CK, ctpbh.ChietKhau, ctpbh.ThanhToan, ctpbh.ViTri); return(db.ExcuteSql(sql)); }
public int KiemTraDanhSachBanCoVuotTonKhoToiThieu() { for (int i = 0; i < grvrootbanhang.RowCount - 1; i++) { SanPhamPhu sp = new SanPhamPhu(); try { int temp = PhieuBanHangBUS.KiemTraHangHoaBanCoVuotTonKhoToiThieu(grvrootbanhang.GetRowCellValue(i, "Mã Hàng").ToString(), int.Parse(grvrootbanhang.GetRowCellValue(i, "Số Lượng").ToString()), cbkhocongty.EditValue.ToString(), grvrootbanhang.GetRowCellValue(i, "Tên Hàng").ToString()); if (temp == 0) { masploi = grvrootbanhang.GetRowCellValue(i, "Mã Hàng").ToString(); return(0); } CT_PhieuBanHangDTO ctpbh = new CT_PhieuBanHangDTO(); ctpbh.ViTri = i; ctpbh.MaPhieuBanHang = txtmaphieubh.Text; ctpbh.MaSanPham = grvrootbanhang.GetRowCellValue(i, "Mã Hàng").ToString(); // sp.ma = grvrootbanhang.GetRowCellValue(i, "Mã Hàng").ToString(); ctpbh.TenSanPham = grvrootbanhang.GetRowCellValue(i, "Tên Hàng").ToString(); ctpbh.SoLuong = int.Parse(grvrootbanhang.GetRowCellValue(i, "Số Lượng").ToString()); //sp.soluong = int.Parse(grvrootbanhang.GetRowCellValue(i, "Số Lượng").ToString()); ctpbh.DonVi = grvrootbanhang.GetRowCellValue(i, "Đơn Vị").ToString(); ctpbh.DonGia = float.Parse(grvrootbanhang.GetRowCellValue(i, "Đơn Giá").ToString()); ctpbh.ChietKhau = float.Parse(grvrootbanhang.GetRowCellValue(i, "Chiết Khấu").ToString()); ctpbh.ThanhToan = float.Parse(grvrootbanhang.GetRowCellValue(i, "Thanh Toán").ToString()); ctpbh.LoaiGia = int.Parse(grvrootbanhang.GetRowCellValue(i, "Loại Giá").ToString()); ctpbh.CK = float.Parse(grvrootbanhang.GetRowCellValue(i, "CK").ToString()); ctpbh.ThanhTien = float.Parse(grvrootbanhang.GetRowCellValue(i, "Thành Tiền").ToString()); } catch { return(-1); } } return(1); }
public int CapNhatCT_PhieuBanHang(CT_PhieuBanHangDTO ctpbh) { string sql = string.Format("update CT_Phieu_Ban_Hang set MaSanPham = '{0}', TenSanPham = N'{1}', DonVi = N'{2}', LoaiGia = {3}, SoLuong = {4}, DonGia = {5}, " + "ThanhTien = {6}, CK = {7}, ChietKhau = {8}, ThanhToan = {9} where MaPhieuBanHang like '{10}' and ViTri = {11}", ctpbh.MaSanPham, ctpbh.TenSanPham, ctpbh.DonVi, ctpbh.LoaiGia, ctpbh.SoLuong, ctpbh.DonGia, ctpbh.ThanhTien, ctpbh.CK, ctpbh.ChietKhau, ctpbh.ThanhToan, ctpbh.MaPhieuBanHang, ctpbh.ViTri); return(db.ExcuteSql(sql)); }
public int ThemCT_PhieuBanHang(CT_PhieuBanHangDTO ctpbh) { return(phieuBanHangDAO.ThemCT_PhieuBanHang(ctpbh)); }
public int CapNhatCT_PhieuBanHang(CT_PhieuBanHangDTO ctpbh) { return(phieuBanHangDAO.CapNhatCT_PhieuBanHang(ctpbh)); }