public bool create(GiayDangKiKetHon entity) { try { string sqlString = "INSERT INTO GiayDangKiKetHons VALUES ('" + entity.MaGDKKetHon + "','" + entity.MaQuyen + "','" + entity.MaCD_Chong + "','" + entity.MaCD_Vo + "','" + entity.NgayDangKi.ToShortDateString() + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create KetHon + " + e.Message); return(false); } }
public bool edit(GiayDangKiKetHon enitity) { try { string sqlString = " UPDATE GiayDangKiKetHons " + " SET MaGDKKetHon = '" + enitity.MaGDKKetHon + "'" + ",MaQuyen = '" + enitity.MaQuyen + "'" + ",MaCD_Chong = '" + enitity.MaCD_Chong + "'" + ",MaCD_Vo = '" + enitity.MaCD_Vo + "'" + ",NgayDangKi = '" + enitity.NgayDangKi.ToShortDateString() + "' " + "WHERE MaGDKKetHon = '" + enitity.MaGDKKetHon + "'"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi edit KetHon + " + e.Message); return(false); } }
public bool create(string so, string maQuyen, CongDan chong, CongDan vo, DateTime ngayDK) { GiayDangKiKetHon giayDangKiKetHon = new GiayDangKiKetHon(so, maQuyen, chong, vo, ngayDK); if (ketHonDAO.create(giayDangKiKetHon)) { if (!congDanController.chuyenTrangThaiKetHon(chong.MaCD, so)) { //MessageBox.Show("Chuyển trạng thái Chồng thất bại"); return(false); } if (!congDanController.chuyenTrangThaiKetHon(vo.MaCD, so)) { //MessageBox.Show("Chuyển trạng thái Vợ thất bại"); return(false); } return(true); } return(false); }
private void Form3_Load(object sender, EventArgs e) { txtCMNDChong_Search.Select(); GiayDangKiKetHon last = ketHonController.ketHonDAO.getLast(); if (last == null) { txtSoQL.Text = "001"; txtSoQuyen.Text = "GKH" + DateTime.Now.Year + "-" + (DateTime.Now.Month > 9 ? "" + DateTime.Now.Month : "0" + DateTime.Now.Month); txtSoQL.Enabled = false; txtSoQuyen.Enabled = false; } else { string temp = last.MaQuyen.Substring(8, 2); txtSoQL.Text = (int.Parse(last.MaGDKKetHon) + 1) < 10 ? "00" + (int.Parse(last.MaGDKKetHon) + 1) : ((int.Parse(last.MaGDKKetHon) + 1) < 100 ? "0" + (int.Parse(last.MaGDKKetHon) + 1) : "" + (int.Parse(last.MaGDKKetHon) + 1)); txtSoQuyen.Text = "GKH" + DateTime.Now.Year + "-" + (DateTime.Now.Month > 9 ? "" + DateTime.Now.Month : "0" + DateTime.Now.Month); txtSoQL.Enabled = false; txtSoQuyen.Enabled = false; } }
public GiayDangKiKetHon getLast() { try { string sqlString = "select * from GiayDangKiKetHons "; DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text); DataTable dt = ds.Tables[0]; List <GiayDangKiKetHon> giayDangKiKetHons = new List <GiayDangKiKetHon>(); foreach (DataRow dr in dt.Rows) { GiayDangKiKetHon gdkkh = findById((string)dr.ItemArray[0]); giayDangKiKetHons.Add(gdkkh); } return(giayDangKiKetHons.LastOrDefault()); } catch (Exception e) { MessageBox.Show("Lỗi getLast KetHon+ " + e.Message); return(null); } }
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); } }