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);
}
}
private void btnTimCMND_Click(object sender, EventArgs e)
{
//Hủy đăng ký thường trú
if (comBoBoxChucNang.SelectedIndex == 1)
{
string imfor = null;
//Tìm hiện thông tin Công dân
QuanLyCongDan QLCD = new QuanLyCongDan();
CongDan CD = QLCD.TimCD_CMND(txtCMND_Search.Text.Trim(), ref imfor);
txtMaCD.Text = CD.MaCD;
txtHoVaTen.Text = CD.HoLot + " " + CD.Ten;
txtNgaySinh.Text = CD.NgaySinh.ToShortDateString();
txtTonGiao.Text = CD.TonGiao;
txtNoiSong.Text = CD.DiaChiThuongTru;
txtCMND.Text = CD.soCMND;
txtDanToc.Text = CD.DanToc;
txtQuocTich.Text = CD.QuocTich;
//Tìm Hiện thông tin thường trú
QuanLyThuongTru QLTT = new QuanLyThuongTru();
ThuongTru TT = QLTT.TimThuongTru_CMND(CD.MaCD, ref imfor);
datePick_NgayDK.Value = TT.NgayDK;
datePick_NgayDen.Value = TT.NgayDen;
if (TT.SoDK <= 9)
{
txtSoQL.Text = "0" + TT.SoDK.ToString();
}
else
{
txtSoQL.Text = TT.SoDK.ToString();
}
txtSoQuyen.Text = TT.SoQuyen;
DevExpress.XtraEditors.XtraMessageBox.Show(imfor);
}
else
{
//Thêm đăng ký thường trú
string imfor = null;
QuanLyCongDan QLCD = new QuanLyCongDan();
CongDan CD = new CongDan();
CD = QLCD.TimCD_CMND(txtCMND_Search.Text.Trim(), ref imfor);
txtMaCD.Text = CD.MaCD;
txtHoVaTen.Text = CD.HoLot + " " + CD.Ten;
txtNgaySinh.Text = CD.NgaySinh.ToShortDateString();
txtTonGiao.Text = CD.TonGiao;
txtNoiSong.Text = CD.DiaChiThuongTru;
txtCMND.Text = CD.soCMND;
txtDanToc.Text = CD.DanToc;
txtQuocTich.Text = CD.QuocTich;
DevExpress.XtraEditors.XtraMessageBox.Show(imfor);
}
}
public bool create(ThuongTru TT)
{
try
{
string sqlString = "INSERT INTO ThuongTrus VALUES ('" + TT.SoQuyen + "','" + TT.SoDK + "','" + TT.MaCD + "',N'" + TT.NgayDK + "','" + TT.MaHoKhau + "','" + TT.NoiDKThuongTru + "','" + TT.NgayDen.ToShortDateString() + "','" + TT.NgayHuy.Value.ToShortDateString() + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text));
}
catch (Exception e)
{
MessageBox.Show("Lỗi create Thuong Tru + " + e.Message);
return(false);
}
}
public ThuongTru TimMaCD(string MaCD)
{
string sqlString = "select * from ThuongTrus where MaCD = " + MaCD + "";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
DataTable dt = ds.Tables[0];
List <ThuongTru> thuongtrus = new List <ThuongTru>();
foreach (DataRow dr in dt.Rows)
{
ThuongTru tt = findById((string)dr.ItemArray[0]);
thuongtrus.Add(tt);
}
return(thuongtrus[0]);
}
public int getIDLast()
{
string sqlString = "select * from ThuongTrus ";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
DataTable dt = ds.Tables[0];
List <ThuongTru> lstThuongtru = new List <ThuongTru>();
foreach (DataRow dr in dt.Rows)
{
ThuongTru tt = findById((string)dr.ItemArray[0]);
lstThuongtru.Add(tt);
}
ThuongTru ttr = lstThuongtru.LastOrDefault();
return(ttr.SoDK);
}
public void TaoMoi(ThuongTru TT)
{
try
{
string sqlString = "select * from ThuongTrus ";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
DataTable dt = ds.Tables[0];
List <ThuongTru> thuongtrus = new List <ThuongTru>();
foreach (DataRow dr in dt.Rows)
{
ThuongTru tt = findById((string)dr.ItemArray[0]);
thuongtrus.Add(tt);
}
ThuongTru tts = thuongtrus.LastOrDefault();
int MaxSoDk = tts.SoDK;
TT.SoDK = MaxSoDk + 1;
create(TT);
}
catch (Exception e)
{
}
}
