public bool Delete(string maHDBanHang) { try { bool kt = false; hdbh = new Constants.HDBanHang(); Sql = new Constants.Sql(); string sql = Sql.DeleteHDBanHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("@maHDBanHang", SqlDbType.VarChar, 20).Value = maHDBanHang; int i = cmd.ExecuteNonQuery(); if (i == 1) { kt = true; } else { kt = false; } cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return(kt); } catch (Exception ex) { string s = ex.Message; return(false); } }
/// <summary> /// Select Bảng /// </summary> /// <returns></returns> public Entities.HDBanHang[] Select() { SelectKH(); Sql = new Constants.Sql(); hdbh = new Constants.HDBanHang(); string sql = Sql.SelectHDBanHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //Insert Category into ArrayList List <Entities.HDBanHang> arr = new List <Entities.HDBanHang>(); while (dr.Read()) { Entities.HDBanHang hdbanhang = new Entities.HDBanHang(); hdbanhang.HDBanHangID = Convert.ToInt32(dr[hdbh.HDBanHangID].ToString()); hdbanhang.MaHDBanHang = dr[hdbh.MaHDBanHang].ToString(); hdbanhang.NgayBan = DateTime.Parse(dr[hdbh.NgayBan].ToString()); hdbanhang.MaKhachHang = dr[hdbh.MaKhachHang].ToString(); hdbanhang.TenKhachHang = TimTenKH(dr[hdbh.MaKhachHang].ToString()); hdbanhang.NoHienThoi = dr[hdbh.NoHienThoi].ToString(); hdbanhang.NguoiNhanHang = dr[hdbh.NguoiNhanHang].ToString(); hdbanhang.HinhThucThanhToan = dr[hdbh.HinhThucThanhToan].ToString(); hdbanhang.MaKho = dr[hdbh.MaKho].ToString(); hdbanhang.HanThanhToam = DateTime.Parse(dr[hdbh.HanThanhToam].ToString()); hdbanhang.MaDonDatHang = dr[hdbh.MaDonDatHang].ToString(); hdbanhang.MaNhanVien = dr[hdbh.MaNhanVien].ToString(); hdbanhang.MaTienTe = dr[hdbh.MaTienTe].ToString(); hdbanhang.ChietKhau = dr[hdbh.ChietKhau].ToString(); hdbanhang.ThanhToanNgay = dr[hdbh.ThanhToanNgay].ToString(); hdbanhang.ThanhToanKhiLapPhieu = dr[hdbh.ThanhToanKhiLapPhieu].ToString(); hdbanhang.ThueGTGT = dr[hdbh.ThueGTGT].ToString(); hdbanhang.TongTienThanhToan = dr[hdbh.TongTienThanhToan].ToString(); hdbanhang.LoaiHoaDon = (Boolean)dr[hdbh.LoaiHoaDon]; hdbanhang.MaThe = dr[hdbh.MaThe].ToString(); hdbanhang.GiaTriThe = dr[hdbh.GiaTriThe].ToString(); hdbanhang.GhiChu = dr[hdbh.GhiChu].ToString(); hdbanhang.Deleted = (Boolean)dr[hdbh.Deleted]; hdbanhang.KhachTra = dr["KhachTra"].ToString(); hdbanhang.ChietKhauTongHoaDon = dr["ChietKhauTongHoaDon"].ToString(); hdbanhang.MaTheGiaTri = dr[hdbh.MaTheGiaTri].ToString(); hdbanhang.GiaTriTheGiaTri = dr[hdbh.GiaTriTheGiaTri].ToString(); arr.Add(hdbanhang); } int n = arr.Count; if (n == 0) { return(null); } cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return(arr.ToArray()); }
/// <summary> /// Select Bảng /// </summary> /// <returns></returns> public Entities.HDBanHang[] Select(string Cot, string Kieu, string Giatri, string makh) { hdbh = new Constants.HDBanHang(); Sql = new Constants.Sql(); string sql = ""; if (Kieu == "like") { sql = "select * from HDBanHang where " + Cot + " " + Kieu + " '%" + Giatri + "%' and MaKhachHang ='" + makh + "' and Deleted =0"; } else { sql = "select * from HDBanHang where " + Cot + " " + Kieu + " '" + Giatri + "' and MaKhachHang ='" + makh + "' and Deleted =0"; } Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //Insert Category into ArrayList List <Entities.HDBanHang> arr = new List <Entities.HDBanHang>(); while (dr.Read()) { Entities.HDBanHang hdbanhang = new Entities.HDBanHang(); hdbanhang.HDBanHangID = Convert.ToInt32(dr[hdbh.HDBanHangID].ToString()); hdbanhang.MaHDBanHang = dr[hdbh.MaHDBanHang].ToString(); hdbanhang.NgayBan = DateTime.Parse(dr[hdbh.NgayBan].ToString()); hdbanhang.MaKhachHang = dr[hdbh.MaKhachHang].ToString(); hdbanhang.NoHienThoi = dr[hdbh.NoHienThoi].ToString(); hdbanhang.NguoiNhanHang = dr[hdbh.NguoiNhanHang].ToString(); hdbanhang.HinhThucThanhToan = dr[hdbh.HinhThucThanhToan].ToString(); hdbanhang.MaKho = dr[hdbh.MaKho].ToString(); hdbanhang.HanThanhToam = DateTime.Parse(dr[hdbh.HanThanhToam].ToString()); hdbanhang.MaDonDatHang = dr[hdbh.MaDonDatHang].ToString(); hdbanhang.MaNhanVien = dr[hdbh.MaNhanVien].ToString(); hdbanhang.MaTienTe = dr[hdbh.MaTienTe].ToString(); hdbanhang.ChietKhau = dr[hdbh.ChietKhau].ToString(); hdbanhang.ThanhToanNgay = dr[hdbh.ThanhToanNgay].ToString(); hdbanhang.ThueGTGT = dr[hdbh.ThueGTGT].ToString(); hdbanhang.TongTienThanhToan = dr[hdbh.TongTienThanhToan].ToString(); hdbanhang.LoaiHoaDon = (Boolean)dr[hdbh.LoaiHoaDon]; hdbanhang.GhiChu = dr[hdbh.GhiChu].ToString(); hdbanhang.Deleted = (Boolean)dr[hdbh.Deleted]; arr.Add(hdbanhang); } int n = arr.Count; if (n == 0) { return(null); } cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return(arr.ToArray()); }
public bool UpdateThanhToanNgay(Entities.HDBanHang hdbh1) { try { hdbh = new Constants.HDBanHang(); Sql = new Constants.Sql(); string sql = Sql.UpdateThanhToanngay; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(hdbh.HanhDong, SqlDbType.NVarChar, 20).Value = hdbh1.HanhDong; cmd.Parameters.Add(hdbh.MaHDBanHang, SqlDbType.VarChar, 20).Value = hdbh1.MaHDBanHang; cmd.Parameters.Add(hdbh.ThanhToanNgay, SqlDbType.Float).Value = hdbh1.ThanhToanNgay; int i = cmd.ExecuteNonQuery(); bool kt = false; if (i == 1) { kt = true; } else { kt = false; } cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return(kt); } catch (Exception ex) { string s = ex.Message; return(false); } }
public bool InsertUpdate(Entities.HDBanHang hdbh1) { try { hdbh = new Constants.HDBanHang(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateHDBanHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(hdbh.HanhDong, SqlDbType.NVarChar, 20).Value = hdbh1.HanhDong; cmd.Parameters.Add(hdbh.HDBanHangID, SqlDbType.Int).Value = hdbh1.HDBanHangID; cmd.Parameters.Add(hdbh.MaHDBanHang, SqlDbType.VarChar, 20).Value = hdbh1.MaHDBanHang; cmd.Parameters.Add(hdbh.NgayBan, SqlDbType.DateTime).Value = hdbh1.NgayBan; cmd.Parameters.Add(hdbh.MaKhachHang, SqlDbType.NVarChar, 20).Value = hdbh1.MaKhachHang; cmd.Parameters.Add(hdbh.NoHienThoi, SqlDbType.Float).Value = hdbh1.NoHienThoi; cmd.Parameters.Add(hdbh.NguoiNhanHang, SqlDbType.NVarChar, 200).Value = hdbh1.NguoiNhanHang; cmd.Parameters.Add(hdbh.HinhThucThanhToan, SqlDbType.NVarChar, 200).Value = hdbh1.HinhThucThanhToan; cmd.Parameters.Add(hdbh.MaKho, SqlDbType.VarChar, 20).Value = hdbh1.MaKho; cmd.Parameters.Add(hdbh.HanThanhToam, SqlDbType.DateTime).Value = hdbh1.HanThanhToam; cmd.Parameters.Add(hdbh.MaDonDatHang, SqlDbType.VarChar, 20).Value = hdbh1.MaDonDatHang; cmd.Parameters.Add(hdbh.MaNhanVien, SqlDbType.VarChar, 20).Value = hdbh1.MaNhanVien; cmd.Parameters.Add(hdbh.MaTienTe, SqlDbType.VarChar, 20).Value = hdbh1.MaTienTe; cmd.Parameters.Add(hdbh.ChietKhau, SqlDbType.Float).Value = hdbh1.ChietKhau; cmd.Parameters.Add(hdbh.ThanhToanNgay, SqlDbType.Float).Value = hdbh1.ThanhToanNgay; cmd.Parameters.Add(hdbh.ThanhToanKhiLapPhieu, SqlDbType.Float).Value = hdbh1.ThanhToanKhiLapPhieu; cmd.Parameters.Add(hdbh.ThueGTGT, SqlDbType.Float).Value = hdbh1.ThueGTGT; cmd.Parameters.Add(hdbh.TongTienThanhToan, SqlDbType.Float).Value = hdbh1.TongTienThanhToan; cmd.Parameters.Add(hdbh.LoaiHoaDon, SqlDbType.Bit).Value = hdbh1.LoaiHoaDon; cmd.Parameters.Add(hdbh.MaThe, SqlDbType.VarChar).Value = hdbh1.MaThe; cmd.Parameters.Add(hdbh.GiaTriThe, SqlDbType.Float).Value = hdbh1.GiaTriThe; cmd.Parameters.Add(hdbh.GhiChu, SqlDbType.NVarChar, 100).Value = hdbh1.GhiChu; cmd.Parameters.Add(hdbh.Deleted, SqlDbType.Bit).Value = hdbh1.Deleted; cmd.Parameters.Add(hdbh.KhachTra, SqlDbType.Float).Value = hdbh1.KhachTra; cmd.Parameters.Add(hdbh.ChietKhauTongHoaDon, SqlDbType.Float).Value = hdbh1.ChietKhauTongHoaDon; cmd.Parameters.Add(hdbh.MaTheGiaTri, SqlDbType.VarChar, 20).Value = hdbh1.MaTheGiaTri; cmd.Parameters.Add(hdbh.GiaTriTheGiaTri, SqlDbType.Float).Value = hdbh1.GiaTriTheGiaTri; int i = cmd.ExecuteNonQuery(); bool kt = false; if (i == 1) { kt = true; } else { kt = false; } // trừ số lượng new BizLogic.ChiTietKhoHangTheoHoaHonNhap().TruSoLuong(hdbh1.ChiTietKhoHangTheoHoaHonNhap); // insert chi tiết hóa đơn new BizLogic.ChiTietHDBanHang().InsertUpdate(hdbh1.ChiTietHDBanHang); if (!hdbh1.LoaiHoaDon) { // cập nhật trạng thái if (hdbh1.DonDatHang != null) { new BizLogic.DonDatHang().CapNhatTrangThaiDonDatHang(hdbh1.DonDatHang); } // update dư nợ if (hdbh1.KhachHang != null) { new BizLogic.KhachHang().Update(hdbh1.KhachHang); } } else { // update thẻ vip if (hdbh1.TheVip != null) { new BizLogic.TheVip().Update(hdbh1.TheVip); } if (hdbh1.TheGiamGia != null) { new BizLogic.TheGiamGia().Update(hdbh1.TheGiamGia); } } cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return(kt); } catch (Exception ex) { string s = ex.Message; return(false); } }