private void ctmnXoa_Click(object sender, EventArgs e) { string i = trvDonVi.SelectedNode.Text; { if (trvDonVi.SelectedNode.Level == 0) { if (MessageBox.Show("Xóa: " + i + " ?" + ((trvDonVi.SelectedNode.Level == 0) ? "\nCác cá nhân thuộc đơn vị này sẽ chuyển vào nhóm chưa phân loại [...]" : ""), "THÔNG BÁO", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { Obj_DonVi o = MyMainForm.CreateObjDonVi((long)trvDonVi.SelectedNode.Tag); int c = MyMainForm.DonVi.Delete(o); RefreshTreeNode(); } } else { if (MessageBox.Show("Xóa: " + i + " ?" + ((trvDonVi.SelectedNode.Level == 0) ? "\nHồ sơ thi đua của thành viên này cũng sẽ bị xóa!" : ""), "THÔNG BÁO", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { Obj_CaNhan o = MyMainForm.CreateObjCaNhan((long)trvDonVi.SelectedNode.Tag); int c = MyMainForm.CaNhan.Delete(o); if (c == 1) { trvDonVi.SelectedNode.Remove(); } //RefreshTreeNode(); } } } }
public int Delete(Obj_DonVi obj_DonVi) { SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection); cm.CommandType = CommandType.Text; cm.CommandText = "DELETE FROM " + LocalTable.TableName + " WHERE id = " + obj_DonVi.ID; DbAccess.OpenConnection(); int i = cm.ExecuteNonQuery(); DbAccess.CloseConnection(); if (i == 1) { foreach (DataRow item in LocalTable.Rows) { if ((long)item[0] == obj_DonVi.ID) { LocalTable.Rows.Remove(item); LocalTable.AcceptChanges(); break; } } } return(i); }
public int Delete(Obj_DonVi obj_DonVi) { if (obj_DonVi.ID == 0) { return(-1); } return(DonVi.Delete(obj_DonVi)); }
public Obj_DonVi CreateObjDonVi(DataRow row) { Obj_DonVi o = new Obj_DonVi() { ID = (long)row["id"], Loai = (row["loai"] == DBNull.Value) ? "" : row["loai"].ToString(), TenDonVi = (row["tenDonVi"] == DBNull.Value) ? "" : row["tenDonVi"].ToString(), DiaDiem = (row["diaDiem"] == DBNull.Value) ? "" : row["diaDiem"].ToString(), Email = (row["email"] == DBNull.Value) ? "" : row["email"].ToString(), Phone = (row["phone"] == DBNull.Value) ? "" : row["phone"].ToString(), TrangThai = (row["trangThai"] == DBNull.Value) ? false : true }; return(o); }
public int Update(Obj_DonVi obj_DonVi) { SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection); cm.CommandType = CommandType.Text; cm.CommandText = "UPDATE " + LocalTable.TableName + " SET " + "loai = @loai, " + "tenDonVi = @tenDonVi, " + "diaDiem = @diaDiem, " + "email = @email, " + "phone = @phone, " + "trangThai = @trangThai" + " WHERE id = @id"; cm.Parameters.Add(new SQLiteParameter("@loai", obj_DonVi.Loai)); cm.Parameters.Add(new SQLiteParameter("@tenDonVi", obj_DonVi.TenDonVi)); cm.Parameters.Add(new SQLiteParameter("@diaDiem", obj_DonVi.DiaDiem)); cm.Parameters.Add(new SQLiteParameter("@email", obj_DonVi.Email)); cm.Parameters.Add(new SQLiteParameter("@phone", obj_DonVi.Phone)); cm.Parameters.Add(new SQLiteParameter("@trangThai", obj_DonVi.TrangThai)); cm.Parameters.Add(new SQLiteParameter("@id", obj_DonVi.ID)); DbAccess.OpenConnection(); int i = cm.ExecuteNonQuery(); DbAccess.CloseConnection(); if (i == 1) { foreach (DataRow item in LocalTable.Rows) { if ((long)item[0] == obj_DonVi.ID) { item[1] = obj_DonVi.Loai; item[2] = obj_DonVi.TenDonVi; item[3] = obj_DonVi.DiaDiem; item[4] = obj_DonVi.Email; item[5] = obj_DonVi.Phone; item[6] = obj_DonVi.TrangThai; LocalTable.AcceptChanges(); break; } } } return(i); }
public int Insert(Obj_DonVi obj_DonVi) { SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection); cm.CommandType = CommandType.Text; cm.CommandText = "INSERT INTO " + LocalTable.TableName + " VALUES (" + "@id, " + "@loai, " + "@tenDonVi, " + "@diaDiem, " + "@email, " + "@phone, " + "@trangThai)"; cm.Parameters.Add(new SQLiteParameter("@id", obj_DonVi.ID)); cm.Parameters.Add(new SQLiteParameter("@loai", obj_DonVi.Loai)); cm.Parameters.Add(new SQLiteParameter("@tenDonVi", obj_DonVi.TenDonVi)); cm.Parameters.Add(new SQLiteParameter("@diaDiem", obj_DonVi.DiaDiem)); cm.Parameters.Add(new SQLiteParameter("@email", obj_DonVi.Email)); cm.Parameters.Add(new SQLiteParameter("@phone", obj_DonVi.Phone)); cm.Parameters.Add(new SQLiteParameter("@trangThai", obj_DonVi.TrangThai)); DbAccess.OpenConnection(); int i = cm.ExecuteNonQuery(); DbAccess.CloseConnection(); if (i == 1) { DataRow item = LocalTable.NewRow(); item[0] = obj_DonVi.ID; item[1] = obj_DonVi.Loai; item[2] = obj_DonVi.TenDonVi; item[3] = obj_DonVi.DiaDiem; item[4] = obj_DonVi.Email; item[5] = obj_DonVi.Phone; item[6] = obj_DonVi.TrangThai; LocalTable.Rows.Add(item); LocalTable.AcceptChanges(); } return(i); }
private void trvDonVi_AfterSelect(object sender, TreeViewEventArgs e) { if (e.Node == null) { return; } dynamic o; if (e.Node.Level == 0) { o = MyMainForm.CreateObjDonVi((long)e.Node.Tag); if (MyMainForm.FormDonVi != null && !MyMainForm.FormDonVi.IsDisposed && (long)e.Node.Tag != 0) { MyMainForm.FormDonVi.ObjDonVi = o; MyMainForm.FormDonVi.IsEditMode = true; } } else { o = MyMainForm.CreateObjCaNhan((long)e.Node.Tag); if (MyMainForm.FormCaNhan != null && !MyMainForm.FormCaNhan.IsDisposed) { MyMainForm.FormCaNhan.ObjCaNhan = o; MyMainForm.FormCaNhan.IsEditMode = true; } Obj_DonVi p = MyMainForm.CreateObjDonVi((long)e.Node.Parent.Tag); if (MyMainForm.FormDonVi != null && !MyMainForm.FormDonVi.IsDisposed && (long)e.Node.Parent.Tag != 0) { MyMainForm.FormDonVi.ObjDonVi = p; MyMainForm.FormDonVi.IsEditMode = true; } } StringBuilder s = new StringBuilder(); s.Append((e.Node.Level == 0) ? "[ID: G-" : "[ID: P-"); s.Append(string.Format("{0:000}", o.ID) + "] "); s.Append("[Phone: " + o.Phone + "] " + "[Email:" + o.Email + "]"); lbl_CaNhanTapThe.Text = s.ToString(); }
public int UpdateInfo(Obj_DonVi obj_DonVi) { return(DonVi.Update(obj_DonVi)); }
public int Insert(Obj_DonVi obj_DonVi) { return(DonVi.Insert(obj_DonVi)); }