//KetNoiCMND ketNoiCMND;
//KetNoiKetHon ketNoiKetHon;
//KetNoiHoKhau ketNoiHoKhau;
public KetNoiCongDan()
{
db = Form1.db;
//ketNoiCMND = new KetNoiCMND();
//ketNoiKetHon = new KetNoiKetHon();
//ketNoiHoKhau = new KetNoiHoKhau();
}
public DataTable LayCongDan()
{
QuanLyDanCuModelADO db = new QuanLyDanCuModelADO();
DataSet sd = db.ExecuteQueryDataSet("select * from ConDans", CommandType.Text);
return(sd.Tables[0]);
}
public bool ThietLap(string xa, string quan, string thanhpho)
{
QuanLyDanCuModelADO db = Form1.db;
string sqlString = "delete * from DonViQuanLis";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text));
}
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]);
}
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);
}
}
//KetNoiCongDan ketNoiCongDan;
public KetNoiKhaiSinh()
{
db = Form1.db;
//ketNoiCongDan = new KetNoiCongDan();
}
public KetNoiCMND()
{
db = Form1.db;
}
public KetNoiHoKhau()
{
db = Form1.db;
ketNoiCongDan = new KetNoiCongDan();
}
public KetNoiQuanHe()
{
db = Form1.db;
}
//KetNoiCongDan ketNoiCongDan;
public KetNoiNhanConNuoi()
{
db = Form1.db;
//ketNoiCongDan = new KetNoiCongDan();
}
public void CapNhatNgayHuy(string MaCD, DateTime NgayHuy)
{
QuanLyDanCuModelADO db = new QuanLyDanCuModelADO();
updateNgayHuy(MaCD, NgayHuy);
}
//KetNoiCongDan ketNoiCongDan;
public KetNoiKetHon()
{
db = Form1.db;
//ketNoiCongDan = new KetNoiCongDan();
}
public KetNoiQuanHeHoKhau()
{
db = Form1.db;
ketNoiQuanHe = new KetNoiQuanHe();
}
//KetNoiCongDan ketNoiCongDan;
public KetNoiCapGiayTo()
{
db = Form1.db;
//ketNoiCongDan = new KetNoiCongDan();
}
public KetNoiNguoiDung()
{
quanLyDanCuModelADO = Form1.db;;
}
//KetNoiCongDan ketNoiCongDan;
public KetNoiChungTu()
{
db = Form1.db;
//ketNoiCongDan = new KetNoiCongDan();
}