private void btn_Delete_Click(object sender, EventArgs e)
{
if (strategyList.SelectedItems.Count != 1)
{
return;
}
DialogResult result = MessageBox.Show("确定删除", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (result == DialogResult.Cancel)
{
return;
}
string strid = strategyList.SelectedItems[0].SubItems[3].Text;
foreach (var v in baseList)
{
if (strid == v.userId + "")
{
if (v.runStatus == EnumRunStatus.运行中)
{
MessageBox.Show("运行中无法删除");
return;
}
}
}
try
{
int uid = int.Parse(strid);
SqLiteHelper sqlHelper = new SqLiteHelper();
sqlHelper.SqliteOpen();
sqlHelper.DeleteValuesAND(
"attrbute",
new string[] { "fk_uid" },
new string[] { strid },
new string[] { "=" }
);
sqlHelper.DeleteValuesAND(
"user",
new string[] { "uid" },
new string[] { strid },
new string[] { "=" }
);
sqlHelper.SqliteClose();
strategyList.Items.RemoveAt(strategyList.SelectedItems[0].Index);
}
catch
{
return;
}
}
static void dllMain(string[] args)
{
sql = new SqLiteHelper();
sql.SqliteOpen("");
//创建名为table1的数据表
sql.CreateTable("table1", new string[] { "ID", "Name", "Age", "Email" }, new string[] { "INTEGER", "TEXT", "INTEGER", "TEXT" });
//插入两条数据
sql.InsertValues("table1", new string[] { "1", "张三", "22", "*****@*****.**" });
sql.InsertValues("table1", new string[] { "2", "李四", "25", "*****@*****.**" });
//更新数据，将Name="张三"的记录中的Name改为"Zhang3"
sql.UpdateValues("table1", new string[] { "Name" }, new string[] { "ZhangSan" }, "Name", "Zhang3");
//删除Name="张三"且Age=26的记录,DeleteValuesOR方法类似
sql.DeleteValuesAND("table1", new string[] { "Name", "Age" }, new string[] { "张三", "22" }, new string[] { "=", "=" });
//读取整张表
SQLiteDataReader reader = sql.ReadFullTable("table1");
while (reader.Read())
{
//读取ID
Log("" + reader.GetInt32(reader.GetOrdinal("ID")));
//读取Name
Log("" + reader.GetString(reader.GetOrdinal("Name")));
//读取Age
Log("" + reader.GetInt32(reader.GetOrdinal("Age")));
//读取Email
Log(reader.GetString(reader.GetOrdinal("Email")));
}
while (true)
{
Console.ReadLine();
}
}
