private void ExecuteFiles(string filename)
{
string[] sqls = this.ReadSqls(filename);
MessageBox.Show("获取了" + sqls.Length + "条语句！");
int i = SqliteDbFactory.GetSqliteDbOperator().BatchExecute(sqls);
MessageBox.Show("成功执行了" + i + "条语句！");
}
private void button6_Click(object sender, EventArgs e)
{
int i = SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery("delete from dept where deptid=1");
if (i > 0)
{
MessageBox.Show("修改数据成功！" + i);
}
}
private void button5_Click(object sender, EventArgs e)
{
int i = SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery("update dept set deptname=deptname+'modify' where deptid=1");
if (i > 0)
{
MessageBox.Show("修改数据成功！" + i);
}
}
private void button1_Click(object sender, EventArgs e)
{
int i = SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery("insert into dept(deptid,deptname) values(1,'name1')");
if (i > 0)
{
MessageBox.Show("插入数据成功！" + i);
}
}
public static DataTable GetDictTable(int dicttype)
{
if (dicttype == 3)
{
DataTable dt = new DataTable();
dt.Columns.Add("dicttext", typeof(string));
dt.Columns.Add("dictvalue", typeof(string));
DataRow dr = dt.NewRow();
dr[0] = "正常收货";
dr[1] = "001";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "返厂品";
dr[1] = "000";
dt.Rows.Add(dr);
return(dt);
}
return(SqliteDbFactory.GetSqliteDbOperator().SelectFromSql("select dicttext,dictvalue from mydicts where dicttype=" + dicttype));
}
private void Form2_Load(object sender, EventArgs e)
{
this.dataGrid1.DataSource = SqliteDbFactory.GetSqliteDbOperator().SelectFromTableName("dept");
}
private void button7_Click(object sender, EventArgs e)
{
SqliteDbFactory.GetSqliteDbOperator().DropTable("dept");
MessageBox.Show("Drop表成功！");
}
private void button4_Click(object sender, EventArgs e)
{
SqliteDbFactory.GetSqliteDbOperator().CreateTable("create table dept(deptid integer,deptname varchar(30))");
MessageBox.Show("创建数据表成功！");
}