public bool updateCT_HoaDonDatHang(CT_HoaDonNhapHang _CT_hoaDonNhapHang) { try { SqlCommand cmd = new SqlCommand("CT_HOADONHAPHANG_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maHD", SqlDbType.VarChar, 10)).Value = _CT_hoaDonNhapHang.MaHD; cmd.Parameters.Add(new SqlParameter("@maSP", SqlDbType.Date)).Value = _CT_hoaDonNhapHang.MaSP; cmd.Parameters.Add(new SqlParameter("@soLuong", SqlDbType.Int)).Value = _CT_hoaDonNhapHang.SoLuong; cmd.Parameters.Add(new SqlParameter("@thanhTien", SqlDbType.Int)).Value = _CT_hoaDonNhapHang.ThanhTien; cmd.Parameters.Add(new SqlParameter("@ghiChu", SqlDbType.VarChar, 100)).Value = _CT_hoaDonNhapHang.GhiChu; cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)).Value = _CT_hoaDonNhapHang.IsActive; if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { conn.Close(); Console.WriteLine("Lỗi: " + e.Message); return(false); } }
public CT_HoaDonNhapHang getCT_HoaDonNhapHang(string _maHD) { try { SqlCommand cmd = new SqlCommand("CT_HOADONNHAPHANG_getHoaDonNhapHang", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@maHD", SqlDbType.VarChar, 10)).Value = _maHD; if (conn.State != ConnectionState.Open) { conn.Open(); } SqlDataReader dr = cmd.ExecuteReader(); CT_HoaDonNhapHang CT_hoadonnhaphang = null; if (dr.Read()) { CT_hoadonnhaphang = new CT_HoaDonNhapHang(); CT_hoadonnhaphang.MaHD = dr["MaHD"].ToString(); CT_hoadonnhaphang.MaSP = dr["MaSP"].ToString(); CT_hoadonnhaphang.SoLuong = (int)dr["SoLuong"]; CT_hoadonnhaphang.ThanhTien = (int)dr["ThanhTien"]; CT_hoadonnhaphang.GhiChu = dr["GhiChu"].ToString(); CT_hoadonnhaphang.IsActive = (Convert.ToInt32(dr["IsActive"]) == 1) ? true : false; } conn.Close(); return(CT_hoadonnhaphang); } catch (Exception e) { conn.Close(); Console.WriteLine("Lỗi: " + e.Message); return(null); } }
public bool addCT_HoaDonNhapHang(CT_HoaDonNhapHang _CT_hoaDonNhapHang) { try { SqlCommand cmd = new SqlCommand("CT_HOADONHAPHANG_Insert", conn); cmd.CommandType = CommandType.StoredProcedure; _maHD = cmd.Parameters.Add(new SqlParameter("@maHD", SqlDbType.VarChar, 10)); _maSP = cmd.Parameters.Add(new SqlParameter("@maSP", SqlDbType.VarChar, 10)); _soLuong = cmd.Parameters.Add(new SqlParameter("@maNV", SqlDbType.Int)); _thanhTien = cmd.Parameters.Add(new SqlParameter("@thanhTien", SqlDbType.Int)); _ghiChu = cmd.Parameters.Add(new SqlParameter("@ghiChu", SqlDbType.NVarChar, 100)); _isActive = cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)); //Get value to parameters: _maHD.Value = _CT_hoaDonNhapHang.MaHD; _maSP.Value = _CT_hoaDonNhapHang.MaSP; _soLuong.Value = _CT_hoaDonNhapHang.SoLuong; _thanhTien.Value = _CT_hoaDonNhapHang.ThanhTien; _ghiChu.Value = _CT_hoaDonNhapHang.GhiChu; _isActive.Value = _CT_hoaDonNhapHang.IsActive; if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { conn.Close(); Console.WriteLine("Lỗi: " + e.Message); return(false); } }
public void UpdateCTHDN(CT_HoaDonNhapHang ex) { bus.UpdateCTHDN(ex); }
public void XoaCTHoaDonNhap(CT_HoaDonNhapHang ex) { bus.XoaCTHoaDonNhap(ex); }
public void DeleteCT_HoaDonNhap(CT_HoaDonNhapHang ex) { bus.DeleteCT_HoaDonNhap(ex); }
public void AddCTHD(CT_HoaDonNhapHang exx) { bus.AddCTHD(exx); }
public bool updateCT_HoaDonDatHang(CT_HoaDonNhapHang _CT_hoadonnhaphang) { return(objCT_HDNH.updateCT_HoaDonDatHang(_CT_hoadonnhaphang)); }
public bool addCT_HoaDonNhapHang(CT_HoaDonNhapHang _CT_hoadonnhaphang) { return(objCT_HDNH.addCT_HoaDonNhapHang(_CT_hoadonnhaphang)); }
public void UpdateCTHDN(CT_HoaDonNhapHang ex) { KetNoi.ExecuteReader(@"update CT_HoaDonNhapHang Set SoLuong=" + ex.SoLuong + ",DonGia=" + ex.DonGia + ",KhuyenMai=" + ex.KhuyenMai + ",ThanhTien=" + ex.ThanhTien + ",TrangThai=N'" + ex.TrangThai + "' Where MaHDNH=N'" + ex.MaHDNH + "' and MaLK=N'" + ex.MaLK + "' "); }
public void XoaCTHoaDonNhap(CT_HoaDonNhapHang ex) { KetNoi.ExecuteReader(@"Delete From CT_HoaDonNhapHang Where MaHDNH=N'" + ex.MaHDNH + "' and MaLK=N'" + ex.MaLK + "'"); }
public void AddCTHD(CT_HoaDonNhapHang exx) { KetNoi.ExecuteReader(@"insert into CT_HoaDonNhapHang(MaHDNH,MaLK,SoLuong,DonGia,KhuyenMai,ThanhTien,TrangThai) values(N'" + exx.MaHDNH + "',N'" + exx.MaLK + "'," + exx.SoLuong + "," + exx.DonGia + "," + exx.KhuyenMai + "," + exx.ThanhTien + ",N'" + exx.TrangThai + "')"); }