System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SQLite;
using System.Data.Common;

namespace WM
{
    class SQLHelper
    {
        //建库
        public DbConnection getCon()
        {
            DbConnection con = new SQLiteConnection();
            con.ConnectionString = "Data Source=WebMan.db";
            return con;
        }
        //建表
        public void CreateWebTable(DbConnection con)
        {
            con.Open();
            try
            {
                using (DbCommand com = con.CreateCommand())
                {
                    com.CommandText = "create table webtable( id integer primary key ,username varchar(20),qiyename varchar(50),webname varchar(50),tel varchar(20),lianxiren varchar(20),fufeidate varchar(10),daoqidate varchar(10),price varchar(10),status varchar(10),yewuyuan varchar(15),mark varchar(50))";
                    com.ExecuteNonQuery();
                    com.CommandText = "create table yewutable( id integer primary key ,num varchar(20),workername varchar(20),gender varchar(5),age varchar(5),bear varchar(10),fromwhere varchar(60),mark varchar(50))";
                    com.ExecuteNonQuery();
                    com.CommandText = "create table usertable( id integer primary key,username varchar(20),pwd varchar(20))";
                    com.ExecuteNonQuery();
                }
            }
            catch (Exception)
            {

            }  
        }
        //查询
        public DataSet Query(DbConnection con,string sql)
        {
            DataSet ds = new DataSet();
            DbDataAdapter da = new SQLiteDataAdapter(sql, (SQLiteConnection)con);
            da.Fill(ds);
            return ds;
        }
        //其它操作
        public int Control(DbConnection con, string sql)
        {
            int i = 0;
            using (DbCommand com = con.CreateCommand())
            {
                com.CommandText = sql;
                i = com.ExecuteNonQuery();
            }
            return i;
        }
    }
}