Exemplo n.º 1
0
 public GiayKhaiSinh findByMaCD(string maCD)
 {
     try
     {
         string       sqlString = "select * from GiayKhaiSinhs where MaCD = " + maCD + "";
         DataSet      ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         GiayKhaiSinh gks       = new GiayKhaiSinh()
         {
             So      = (string)ds.Tables[0].Rows[0].ItemArray[0],
             MaQuyen = (string)ds.Tables[0].Rows[0].ItemArray[1],
             MaCD    = (string)ds.Tables[0].Rows[0].ItemArray[2],
             //CongDan = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[2]),
             NoiSinh  = (string)ds.Tables[0].Rows[0].ItemArray[3],
             MaCD_Cha = (string)ds.Tables[0].Rows[0].ItemArray[4],
             //Cha = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[4]),
             MaCD_Me = (string)ds.Tables[0].Rows[0].ItemArray[5],
             //Me = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[5]),
             MaCD_NguoiKhai = (string)ds.Tables[0].Rows[0].ItemArray[6],
             //NguoiKhai = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[6]),
             QuanHe          = (string)ds.Tables[0].Rows[0].ItemArray[7],
             NgayDK_KhaiSinh = (DateTime)ds.Tables[0].Rows[0].ItemArray[8],
         };
         return(gks);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi findByMaCD KhaiSinh!!! + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 2
0
        public CongDan TimMaCD(string MaCD)
        {
            string  sqlString = "select * from CongDans where MaCD = '" + MaCD + "'";
            DataSet ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
            //CongDan cd = new CongDan()
            //{
            //    MaCD = (string)ds.Tables[0].Rows[0].ItemArray[0],
            //    HoLot = (string)ds.Tables[0].Rows[0].ItemArray[1],
            //    Ten = (string)ds.Tables[0].Rows[0].ItemArray[2],
            //    GioiTinh = (bool)ds.Tables[0].Rows[0].ItemArray[3],
            //    NgaySinh = (DateTime)ds.Tables[0].Rows[0].ItemArray[4],
            //    QuocTich = (string)ds.Tables[0].Rows[0].ItemArray[5],
            //    DanToc = (string)ds.Tables[0].Rows[0].ItemArray[6],
            //    TonGiao = (string)ds.Tables[0].Rows[0].ItemArray[7],
            //    QueQuan = (string)ds.Tables[0].Rows[0].ItemArray[8],
            //    soCMND = (string)ds.Tables[0].Rows[0].ItemArray[9],
            //    MaHK = (string)ds.Tables[0].Rows[0].ItemArray[10],
            //    SDT = (string)ds.Tables[0].Rows[0].ItemArray[11],
            //    DiaChiThuongTru = (string)ds.Tables[0].Rows[0].ItemArray[12],
            //    DiaChiTamTru = (string)ds.Tables[0].Rows[0].ItemArray[13],
            //    NgheNghiep = (string)ds.Tables[0].Rows[0].ItemArray[14],
            //    MaGDKKetHon = (string)ds.Tables[0].Rows[0].ItemArray[15],
            //    ConSong = (bool)ds.Tables[0].Rows[0].ItemArray[16],
            //    HinhAnh = (string)ds.Tables[0].Rows[0].ItemArray[17],

            //};
            CongDan cd = findById((string)ds.Tables[0].Rows[0].ItemArray[0]);

            return(cd);
        }
Exemplo n.º 3
0
 public GiayNhanConNuoi findById(string id)
 {
     try
     {
         string          sqlString = "select * from GiayNhanConNuois where MaGiayNhanConNuoi = " + id + "";
         DataSet         ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         GiayNhanConNuoi gncn      = new GiayNhanConNuoi()
         {
             MaGiayNhanConNuoi = (string)ds.Tables[0].Rows[0].ItemArray[0],
             MaQuyen           = (string)ds.Tables[0].Rows[0].ItemArray[1],
             MaCD_Cha          = (string)ds.Tables[0].Rows[0].ItemArray[2],
             //Cha = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[2]),
             MaCD_Me = (string)ds.Tables[0].Rows[0].ItemArray[3],
             //Me = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[3]),
             MaCD_Con = (string)ds.Tables[0].Rows[0].ItemArray[4],
             //Con = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[4]),
             NoiDangKi  = (string)ds.Tables[0].Rows[0].ItemArray[5],
             NgayDangKi = (DateTime)ds.Tables[0].Rows[0].ItemArray[6],
             GhiChu     = (string)ds.Tables[0].Rows[0].ItemArray[7]
         };
         return(gncn);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi findById GiayNhanConNuoi + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 4
0
 public ThuongTru findById(string id)
 {
     try
     {
         string    sqlString = "select * from ThuongTrus where So = " + id + "";
         DataSet   ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         ThuongTru gks       = new ThuongTru()
         {
             SoQuyen        = (string)ds.Tables[0].Rows[0].ItemArray[0],
             SoDK           = (int)ds.Tables[0].Rows[0].ItemArray[1],
             MaCD           = (string)ds.Tables[0].Rows[0].ItemArray[2],
             NgayDK         = (DateTime)ds.Tables[0].Rows[0].ItemArray[3],
             MaHoKhau       = (string)ds.Tables[0].Rows[0].ItemArray[4],
             NoiDKThuongTru = (string)ds.Tables[0].Rows[0].ItemArray[5],
             NgayDen        = (DateTime)ds.Tables[0].Rows[0].ItemArray[6],
             NgayHuy        = (DateTime)ds.Tables[0].Rows[0].ItemArray[7],
         };
         return(gks);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi FindById ThuongTru!!! + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 5
0
 public List <HoKhau_QuanHe> findByMaHK(string id)
 {
     try
     {
         string               sqlString      = "select * from HoKhau_QuanHe Where maHK = '" + id + "'";
         DataSet              ds             = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         DataTable            dt             = ds.Tables[0];
         List <HoKhau_QuanHe> hoKhau_QuanHes = new List <HoKhau_QuanHe>();
         foreach (DataRow dr in dt.Rows)
         {
             HoKhau_QuanHe hk = new HoKhau_QuanHe()
             {
                 maHK     = (string)dr.ItemArray[0],
                 maCD     = (string)dr.ItemArray[1],
                 idQuanHe = (int)dr.ItemArray[2],
                 QuanHe   = ketNoiQuanHe.findById((int)ds.Tables[0].Rows[0].ItemArray[2])
             };
             hoKhau_QuanHes.Add(hk);
         }
         return(hoKhau_QuanHes);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi findByMaHK HoKhau_QuanHe + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 6
0
 public GiayChungTu findById(string id)
 {
     try
     {
         string      sqlString = "select * from GiayChungTus where MaGiayChungTu = " + id + "";
         DataSet     ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         GiayChungTu gct       = new GiayChungTu()
         {
             MaGiayChungTu = (string)ds.Tables[0].Rows[0].ItemArray[0],
             MaQuyen       = (string)ds.Tables[0].Rows[0].ItemArray[1],
             MaCD          = (string)ds.Tables[0].Rows[0].ItemArray[2],
             //CongDan = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[2]),
             CoQuanBaoTu    = (string)ds.Tables[0].Rows[0].ItemArray[3],
             NoiChet        = (string)ds.Tables[0].Rows[0].ItemArray[4],
             NguyenNhan     = (string)ds.Tables[0].Rows[0].ItemArray[5],
             MaCD_NguoiKhai = (string)ds.Tables[0].Rows[0].ItemArray[6],
             //NguoiKhai = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[6]),
             NgayTu = (DateTime)ds.Tables[0].Rows[0].ItemArray[7],
         };
         return(gct);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi findById ChungTu + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 7
0
        public HoKhau TimHK(string MaHK)
        {
            string  sqlString = "select * from HoKhaus where SoHK = " + MaHK + "";
            DataSet ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
            HoKhau  hk        = new HoKhau()
            {
                SoHK   = (string)ds.Tables[0].Rows[0].ItemArray[0],
                DiaChi = (string)ds.Tables[0].Rows[0].ItemArray[1],
            };

            return(hk);
        }
Exemplo n.º 8
0
        public DataTable LayCongDan()
        {
            QuanLyDanCuModelADO db = new QuanLyDanCuModelADO();
            DataSet             sd = db.ExecuteQueryDataSet("select * from ConDans", CommandType.Text);

            return(sd.Tables[0]);
        }
Exemplo n.º 9
0
 public CMND findById(string id)
 {
     try
     {
         string  sqlString = "select * from CMNDs where MaSo = " + id + "";
         DataSet ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         CMND    cmnd      = new CMND()
         {
             MaSo    = (string)ds.Tables[0].Rows[0].ItemArray[0],
             NgayCap = (DateTime)ds.Tables[0].Rows[0].ItemArray[1],
             NoiCap  = (string)ds.Tables[0].Rows[0].ItemArray[2],
         };
         return(cmnd);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi findById CMND + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 10
0
 public Array getArray()
 {
     try
     {
         string        sqlString = "select * from QuanHes ";
         DataSet       ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         DataTable     dt        = ds.Tables[0];
         List <QuanHe> quanHes   = new List <QuanHe>();
         foreach (DataRow dr in dt.Rows)
         {
             QuanHe qh = findById((int)dr.ItemArray[0]);
             quanHes.Add(qh);
         }
         return(quanHes.ToArray());
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi getArray QuanHe + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 11
0
 public CapGiayTo findById(int id)
 {
     try
     {
         string    sqlString = "select * from CapGiayToes where id = " + id + "";
         DataSet   ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         CapGiayTo cgt       = new CapGiayTo()
         {
             id   = (int)ds.Tables[0].Rows[0].ItemArray[0],
             MaCD = (string)ds.Tables[0].Rows[0].ItemArray[1],
             //CongDan = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[1]),
             LoaiGiayTo = (string)ds.Tables[0].Rows[0].ItemArray[2],
             NgayCap    = (DateTime)ds.Tables[0].Rows[0].ItemArray[3]
         };
         return(cgt);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi findById CapGiayTo + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 12
0
        public NguoiDung KiemTraDangNhap(string user, string pass)
        {
            string    sqlString = "select * from NguoiDungs where username = '******' AND password = '******'";
            DataSet   ds        = quanLyDanCuModelADO.ExecuteQueryDataSet(sqlString, CommandType.Text);
            NguoiDung nd        = new NguoiDung()
            {
                username = (string)ds.Tables[0].Rows[0].ItemArray[0],
                password = (string)ds.Tables[0].Rows[0].ItemArray[1],
                IDQuyen  = (bool)ds.Tables[0].Rows[0].ItemArray[2]
            };

            return(nd);
        }
Exemplo n.º 13
0
        public DonViQuanLi LayDonVi()
        {
            QuanLyDanCuModelADO db        = Form1.db;
            string             sqlString  = "select * from DonViQuanLis ";
            DataSet            ds         = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
            DataTable          dt         = ds.Tables[0];
            List <DonViQuanLi> thuongtrus = new List <DonViQuanLi>();

            foreach (DataRow dr in dt.Rows)
            {
                DonViQuanLi tt = findById((string)dr.ItemArray[0]);
                thuongtrus.Add(tt);
            }
            return(thuongtrus[0]);
        }
Exemplo n.º 14
0
        public void TaoMoi(TamVang TV)
        {
            try
            {
                string         sqlString  = "select * from TamVangs ";
                DataSet        ds         = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
                DataTable      dt         = ds.Tables[0];
                List <TamVang> thuongtrus = new List <TamVang>();
                foreach (DataRow dr in dt.Rows)
                {
                    TamVang tt = findById((string)dr.ItemArray[0]);
                    thuongtrus.Add(tt);
                }

                TamVang tts     = thuongtrus.LastOrDefault();
                int     MaxSoDk = tts.SoDK;
                TV.SoDK = MaxSoDk + 1;

                create(TV);
            }
            catch (Exception e)
            {
            }
        }
Exemplo n.º 15
0
 public GiayDangKiKetHon findById(string id)
 {
     try
     {
         string           sqlString = "select * from GiayDangKiKetHons where MaGDKKetHon = " + id + "";
         DataSet          ds        = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         GiayDangKiKetHon gdkkh     = new GiayDangKiKetHon()
         {
             MaGDKKetHon = (string)ds.Tables[0].Rows[0].ItemArray[0],
             MaQuyen     = (string)ds.Tables[0].Rows[0].ItemArray[1],
             MaCD_Chong  = (string)ds.Tables[0].Rows[0].ItemArray[2],
             //Chong = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[2]),
             MaCD_Vo = (string)ds.Tables[0].Rows[0].ItemArray[3],
             //Vo = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[3]),
             NgayDangKi = (DateTime)ds.Tables[0].Rows[0].ItemArray[4],
         };
         return(gdkkh);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi findById KetHon + " + e.Message);
         return(null);
     }
 }
Exemplo n.º 16
0
 public DonViQuanLi findById(string id)
 {
     try
     {
         QuanLyDanCuModelADO db = Form1.db;
         string      sqlString  = "select * from DonViQuanLis where So = " + id + "";
         DataSet     ds         = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
         DonViQuanLi gks        = new DonViQuanLi()
         {
             id       = (int)ds.Tables[0].Rows[0].ItemArray[0],
             Phuong   = (string)ds.Tables[0].Rows[0].ItemArray[1],
             Quan     = (string)ds.Tables[0].Rows[0].ItemArray[2],
             ThanhPho = (string)ds.Tables[0].Rows[0].ItemArray[3],
         };
         return(gks);
     }
     catch (Exception e)
     {
         MessageBox.Show("Lỗi FindById TamVang!!! + " + e.Message);
         return(null);
     }
 }