private void btnSearch_Click(object sender, EventArgs e) { try { sql = new SqLiteHelper(); //读取整张表 SQLiteDataAdapter da = sql.ReadFullTabledataAdapterNotDelete("TryGameToDo"); if (da != null) { ClearData("TryGameToDo"); da.Fill(ds, "TryGameToDo"); this.dataGridView1.DataSource = ds.Tables[0]; foreach (DataTable item in ds.Tables) { if (this.cbTable.FindString(item.TableName) == -1) { cbTable.Items.Add(item.TableName); } } } } catch (Exception ex) { MessageBox.Show("系统发生异常,请联系管理员!", "错误"); LogHelper.WriteLog("异常", ex); } }
private void btnDelete_Click(object sender, EventArgs e) { try { //让用户选择是否删除 MessageBoxButtons btn = MessageBoxButtons.YesNoCancel; if (MessageBox.Show("确定要删除数据吗?", "删除数据", btn) == DialogResult.Yes) { //取出选中行里面绑定的对象 //TryGameToDo tryGameToDoObject = dataGridView1.SelectedRows[0].DataBoundItem as TryGameToDo; TryGameToDo tryGameToDoObject = new TryGameToDo(); DataRowView rowView = this.dataGridView1.CurrentRow.DataBoundItem as DataRowView; if (rowView != null) { DataRow currentRow = rowView.Row; tryGameToDoObject.Id = long.Parse(currentRow["Id"].ToString()); tryGameToDoObject.Url = currentRow["Url"].ToString(); tryGameToDoObject.UserName = currentRow["UserName"].ToString(); tryGameToDoObject.PassWord = currentRow["PassWord"].ToString(); tryGameToDoObject.ReMark = currentRow["ReMark"].ToString(); tryGameToDoObject.DeadLine = DateTime.Parse(currentRow["DeadLine"].ToString()); tryGameToDoObject.IsDeleted = true; } sql = new SqLiteHelper(); //更新数据 sql.UpdateValues("TryGameToDo", new string[] { "IsDeleted", }, new string[] { tryGameToDoObject.IsDeleted.ToString() }, "Id", tryGameToDoObject.Id.ToString()); //刷新数据 //读取整张表 SQLiteDataAdapter da = sql.ReadFullTabledataAdapterNotDelete("TryGameToDo"); if (da != null) { ClearData("TryGameToDo"); da.Fill(ds, "TryGameToDo"); this.dataGridView1.DataSource = ds.Tables[0]; foreach (DataTable item in ds.Tables) { if (this.cbTable.FindString(item.TableName) == -1) { cbTable.Items.Add(item.TableName); } } } } } catch (Exception ex) { MessageBox.Show("系统发生异常,请联系管理员!", "错误"); LogHelper.WriteLog("异常", ex); } }
private void frmToList_Load(object sender, EventArgs e) { try { this.rtNotice.Text = "数据来源自本地,不会影响线上数据,可随意更改"; this.rtNotice.BackColor = Color.Gray; sql = new SqLiteHelper(); //读取整张表 SQLiteDataAdapter da = sql.ReadFullTabledataAdapterNotDelete("TryGameToDo"); if (da != null) { ClearData("TryGameToDo"); da.Fill(ds, "TryGameToDo"); this.dataGridView1.DataSource = ds.Tables[0]; foreach (DataTable item in ds.Tables) { if (this.cbTable.FindString(item.TableName) == -1) { cbTable.Items.Add(item.TableName); } } /* * 通知:便于跟踪待办 * */ timer1.Enabled = true; foreach (DataTable item in ds.Tables) { timer1.Interval = defaulttimerInterval * item.Rows.Count; } timer1.Start(); } } catch (Exception ex) { MessageBox.Show("系统发生异常,请联系管理员!", "错误"); LogHelper.WriteLog("打开待办窗体异常", ex); } }
private void btnSave_Click(object sender, EventArgs e) { try { DataTable cdt = ds.Tables[0].GetChanges(); for (int i = 0; i < cdt.Rows.Count; i++) { if (cdt.Rows[i].RowState == DataRowState.Deleted) { //删除方法 } else if (cdt.Rows[i].RowState == DataRowState.Modified) { //更新方法 TryGameToDo tryGameToDoObject = new TryGameToDo(); tryGameToDoObject.Id = Convert.ToInt64(dataGridView1.Rows[i].Cells[0].Value); tryGameToDoObject.Url = Convert.ToString(dataGridView1.Rows[i].Cells[1].Value); tryGameToDoObject.UserName = Convert.ToString(dataGridView1.Rows[i].Cells[2].Value); tryGameToDoObject.PassWord = Convert.ToString(dataGridView1.Rows[i].Cells[3].Value); tryGameToDoObject.ReMark = Convert.ToString(dataGridView1.Rows[i].Cells[4].Value); tryGameToDoObject.DeadLine = Convert.ToDateTime(dataGridView1.Rows[i].Cells[5].Value); tryGameToDoObject.IsDeleted = Convert.ToBoolean(dataGridView1.Rows[i].Cells[6].Value); sql = new SqLiteHelper(); //更新数据 sql.UpdateValues("TryGameToDo", new string[] { "Url", "UserName", "PassWord", "ReMark", "DeadLine", "IsDeleted" }, new string[] { tryGameToDoObject.Url, tryGameToDoObject.UserName, tryGameToDoObject.PassWord, tryGameToDoObject.ReMark, tryGameToDoObject.DeadLine.ToString(), tryGameToDoObject.IsDeleted.ToString() }, "Id", tryGameToDoObject.Id.ToString()); //刷新数据 //读取整张表 SQLiteDataAdapter da = sql.ReadFullTabledataAdapterNotDelete("TryGameToDo"); if (da != null) { ClearData("TryGameToDo"); da.Fill(ds, "TryGameToDo"); foreach (DataTable item in ds.Tables) { if (this.cbTable.FindString(item.TableName) == -1) { cbTable.Items.Add(item.TableName); } } } } else if (cdt.Rows[i].RowState == DataRowState.Added) { //新增方法 } } ////删除Name="张三"且Age=26的记录,DeleteValuesOR方法类似 //sql.DeleteValuesAND("TryGameToDo", new string[] { "Name", "Age" }, new string[] { "张三", "22" }, new string[] { "=", "=" }); } catch (Exception ex) { MessageBox.Show("系统发生异常,请联系管理员!", "错误"); LogHelper.WriteLog("异常", ex); } }