private void btnToDo_Click(object sender, EventArgs e)
{
try {
string[] str = new string[dataGridView1.Rows.Count];
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Selected == true)
{
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[6].Value);
tryGameToDoObject.IsDeleted = false;
//sql = new SqLiteHelper("data source=mydb.db");
sql = new SqLiteHelper();
//创建名为TryGameToDo的数据表
sql.CreateTable("TryGameToDo", new string[] { "Id", "Url", "UserName", "PassWord", "ReMark", "DeadLine", "IsDeleted" }, new string[] { "INTEGER", "TEXT", "TEXT", "TEXT", "TEXT", "TEXT", "TEXT" });
//插入数据
sql.InsertValues("TryGameToDo", new string[] { tryGameToDoObject.Id.ToString(), tryGameToDoObject.Url, tryGameToDoObject.UserName, tryGameToDoObject.PassWord, tryGameToDoObject.ReMark, tryGameToDoObject.DeadLine.ToString(), tryGameToDoObject.IsDeleted.ToString() });
}
}
}
catch (Exception ex)
{
MessageBox.Show("系统发生异常，请联系管理员！", "错误");
LogHelper.WriteLog("窗体异常", ex);
}
}
private void Init()
{
//ConsoleManager.Show();//打开信息打印窗口
LoginCommand = new DelegateCommand <Login>(runLoginCommand);
LoginKeyDownCommand = new DelegateCommand <Login>(runLoginKeyDownCommand);
sql = SqLiteHelper.getInstance;
sql.ConnectionString = "data source=mydb.db";
sql.CreateTable("userTB", new string[] { "id", "username", "passwd", "userpower", "itemlist", "times" }, new string[] { "integer primary key AUTOINCREMENT", "varchar2(100) not null", "varchar2(100) not null", "int not null", "varchar2(100) not null", "int not null" });
//创建名为table1的数据表
DataTable dt = sql.ExecuteQuery("select count(*) from userTB");
int count = Convert.ToInt32(dt.Rows[0][0].ToString());
if (count == 0)
{
//是新表，需要创建管理员账户
sql.InsertValues("userTB", new string[] { null, "admin", "123456", "2", "1,1,1,1", "0" });
}
}
