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("创建数据表成功！");
}
