/// <summary> /// vuong hung =================lay bang DonDatHang================ /// </summary> /// <returns></returns> public Entities.DonDatHang[] sp_LayBang_DonDatHang(Entities.DonDatHang giatri) { List <Entities.DonDatHang> arr = null; try { dh = new Constants.DonDatHang(); Sql = new Constants.Sql(); string sql = Sql.sp_LayBang_DonDatHang; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("MaDonDatHang", SqlDbType.VarChar, 20).Value = giatri.MaDonDatHang; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new List <Entities.DonDatHang>(); while (dr.Read()) { dondathang = new Entities.DonDatHang(); dondathang.DonDatHangID = Convert.ToInt32(dr[dh.DonDatHangID].ToString()); dondathang.MaDonDatHang = dr[dh.MaDonDatHang].ToString(); dondathang.LoaiDonDatHang = Convert.ToBoolean(dr[dh.LoaiDonDatHang].ToString()); dondathang.NgayDonHang = Convert.ToDateTime(dr[dh.NgayDonHang].ToString()); dondathang.MaNhaCungCap = dr[dh.MaNhaCungCap].ToString(); dondathang.NoHienThoi = dr[dh.NoHienThoi].ToString(); dondathang.TrangThaiDonDatHang = dr[dh.TrangThaiDonDatHang].ToString(); dondathang.NgayNhapDuKien = Convert.ToDateTime(dr[dh.NgayNhapDuKien].ToString()); dondathang.HinhThucThanhToan = dr[dh.HinhThucThanhToan].ToString(); dondathang.MaKho = dr[dh.MaKho].ToString().ToUpper(); dondathang.MaNhanVien = dr[dh.MaNhanVien].ToString().ToUpper(); dondathang.MaTienTe = dr[dh.MaTienTe].ToString().ToUpper(); dondathang.ThueGTGT = Double.Parse(0 + dr[dh.ThueGTGT].ToString()).ToString(); dondathang.Phivanchuyen = Double.Parse(0 + dr[dh.Phivanchuyen].ToString()).ToString(); dondathang.PhiKhac = Double.Parse(0 + dr[dh.PhiKhac].ToString()).ToString(); dondathang.GhiChu = "" + dr[dh.GhiChu].ToString(); dondathang.Deleted = Convert.ToBoolean(dr[dh.Deleted].ToString()); dondathang.Makhachhang = dr[dh.MaKhachHang].ToString(); arr.Add(dondathang); } int n = arr.Count; if (n == 0) { return(null); } } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(arr.ToArray()); }
public LoaiThue() { lt = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; loaithue = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public TheoHangHoa() { thh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; theohanghoa = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public LSGDNhapMua() { lsgd = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; lichsugiaodich = null; cn = null; }
public NhomHang() { nhh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; nhomhanghoa = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public LSGDTTNCC() { tt = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; thanhtoan = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public ThongTinDatHang() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; dondathang = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public TaiKhoan() { tk = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; taikhoan = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public ThongTinNhaCungCap() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; cungcap = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public TheoNhomHang() { tnh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; theonhomhang = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public DonHang() { lsgd = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; lichsugiaodich = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public TraLaiNhaCungCap() { tlncc = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; tralainhacungcap = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public NhomKH() { nkh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; nhomkhachhang = null; cn = null; }
public NhomQuyen() { nq = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; nhomquyen = null; cn = null; }
public ThueH() { dvt = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; donvitinh = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public ChiTietDonDatHang() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; dondathang = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public KhachHangTraLai() { khtl = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; khachhangtralai = null; cn = null; }
public LoaiHangHoa() { lhh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; loaihanghoa = null; cn = null; }
public CapNhatGia() { cng = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; capnhatgia = null; cn = null; }
public QuyDoi() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; cla = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public XuatHang() { xh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; xuathang = null; cn = null; }
public HangHoa() { hh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; hanghoa = null; cn = null; }
public KhoHang() { kh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; khohang = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public CongTy() { ncc = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; nhacungcap = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public HangHoaNCC() { lsgd = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; lichsugiaodich = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public LSGDTraLaiNCC() { lsgd = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; lichsugiaodich = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public ChiTietHoaDonNhap() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; hoadonnhap = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public BaoCaoNhapHangTheoMatHang() { kh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; khachhang = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public ThongTinNhanVien() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; nhanvien = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public ThongTinHoaDonNhap() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; hoadonnhap = null; cn = null; }