public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("bi_t_supcust_info") == false)
{
string sql = "create table bi_t_supcust_info(supcust_no varchar(20),supcust_flag varchar(1),sup_name varchar(50),sup_tel varchar(20),sup_pyname varchar(50)";
sql += ",display_flag varchar(1),credit_amt decimal(18,4),other1 varchar(60),cust_level varchar(1),is_retail varchar(10),primary key (supcust_no,supcust_flag)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("bi_t_item_cls") == false)
{
string sql;
sql = "create table bi_t_item_cls(item_clsno varchar(20),item_flag varchar(1),item_clsname varchar(100),display_flag varchar(1),is_stop varchar(1)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("t_click_log") == false)
{
string sql;
sql = "create table t_click_log(flow_id varchar(10),cus_id varchar(10),jh varchar(10),click_num varchar(10),oper_id varchar(20),oper_date datetime) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("bt_sysn_info") == false)
{
string sql;
sql = "CREATE TABLE bt_sysn_info(table_name VARCHAR(50), sysn_time DATETIME) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("t_print_log") == false)
{
string sql;
sql = "create table t_print_log(sheet_no varchar(20) primary key,print_count integer,oper_id varchar(20),oper_date datetime) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("bi_t_branch_info") == false)
{
string sql;
sql = "create table bi_t_branch_info(branch_no varchar(20) PRIMARY KEY,branch_name varchar(200)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("sa_t_operator_i") == false)
{
string sql = "create table sa_t_operator_i(oper_id varchar(20),oper_type varchar(20),oper_name varchar(50),oper_pw varchar(50)";
sql += ",oper_status varchar(1),update_time datetime,is_branch varchar(1),is_admin varchar(1),branch_no varchar(20)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("sys_t_sheet_no") == false)
{
string sql;
sql = "create table sys_t_sheet_no(sheet_id varchar(20),sheet_value integer) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
sql = "insert into sys_t_sheet_no values('PI',0)";
d.ExecuteScalar(sql, null);
sql = "insert into sys_t_sheet_no values('SO',0)";
d.ExecuteScalar(sql, null);
sql = "insert into sys_t_sheet_no values('RI',0)";
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("bt_par_setting") == false)
{
string sql;
sql = "create table bt_par_setting(par_id varchar(20), par_val varchar(50)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("sys_t_system") == false)
{
string sql = "create table sys_t_system(sys_var_id varchar(20),sys_var_name varchar(40),sys_var_value varchar(250),is_changed varchar(2)";
sql += ",sys_var_desc varchar(100),sys_ver_flag varchar(1),update_time datetime) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("bi_t_cust_price") == false)
{
string sql = "create table bi_t_cust_price(cust_id varchar(20),item_no varchar(20),price_type varchar(1)";
sql += ",new_price decimal(18,4),top_price decimal(18,4),bottom_price decimal(18,4),last_price decimal(18,4)";
sql += ",top_sheet_no varchar(20),bottom_sheet_no varcahr(20),last_sheet_no varchar(20)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("bi_t_sup_item") == false)
{
string sql = "create table bi_t_sup_item(sup_id varchar(20),item_no varchar(20),price decimal(18,4),top_price decimal(18,4)";
sql += ",bottom_price decimal(18,4),last_price decimal(18,4),top_sheet_no varchar(20),bottom_sheet_no varchar(20),last_sheet_no varchar(20)";
sql += ",spec_from datetime,spec_to datetime,spec_price decimal(18,4),item_status varchar(20)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("ic_t_inout_store_master") == false)
{
string sql = "create table ic_t_inout_store_master(sheet_no varchar(20) primary key,trans_no varchar(2),branch_no varchar(20)";
sql += ",supcust_no varchar(20),total_amount decimal(18,4),inout_amount decimal(18,4),approve_flag varchar(1),oper_date datetime";
sql += ",oper_id varchar(20),is_upload varchar(1),pay_way varchar(20)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("sm_t_salesheet_detail") == false)
{
string sql = "create table sm_t_salesheet_detail(sheet_no varchar(20),item_no varchar(20),item_subno varchar(20),item_name varchar(60),unit_no varchar(20),sale_price decimal(18,4)";
sql += ",real_price decimal(18,4),cost_price decimal(18,4),sale_qnty decimal(18,4),sale_money decimal(18,4),barcode varchar(20),sheet_sort integer,other3 varchar(60)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
//other3:是否赠送：1赠送
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("bi_t_item_info") == false)
{
string sql = "create table bi_t_item_info(item_no varchar(20) PRIMARY KEY,item_subno varchar(20),item_subname varchar(100),item_clsno varchar(20)";
sql += ",item_name varchar(100),item_brand varchar(20),item_brandname varchar(100),unit_no varchar(20),item_size varchar(20),product_area varchar(100)";
sql += ",barcode varchar(20),price decimal(18,4),base_price decimal(18, 4),sale_price decimal(18, 4),display_flag varchar(1),item_flag varchar(1)";
sql += ",base_price2 decimal(18, 4),base_price3 decimal(18, 4),base_price4 decimal(18, 4),base_price5 decimal(18, 4)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("sm_t_salesheet") == false)
{
string sql = "create table sm_t_salesheet(sheet_no varchar(20) primary key,branch_no varchar(20),cust_no varchar(20),pay_way varchar(20)";
sql += ",coin_no varchar(50),real_amount decimal(18,4),total_amount decimal(18,4),paid_amount decimal(18,4),approve_flag varchar(1)";
sql += ",oper_id varchar(20),sale_man varchar(20),oper_date datetime,pay_date datetime,is_upload varchar(1),discount decimal(18,4)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
//discount整单折扣
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("ic_t_branch_stock") == false)
{
string sql;
sql = "create table ic_t_branch_stock(branch_no varchar(20),item_no varchar(20),stock_qty decimal(18,4)";
sql += ",cost_price decimal(18,4),display_flag varchar(1),last_price decimal(18,4),fifo_price decimal(18,4)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("t_order_detail") == false)
{
string sql = "CREATE TABLE t_order_detail(flow_id INTEGER,sheet_no VARCHAR(20),item_no VARCHAR(20),item_subno VARCHAR(20),item_name VARCHAR(50)";
sql += ",unit_no varchar(20),oper_id VARCHAR(20),oper_date DATETIME,qty DECIMAL(18, 4),price DECIMAL(18, 4),amt DECIMAL(18, 4),jh VARCHAR(20)";
sql += ",cost_price decimal(18,4),branch_no varchar(20),cus_no varchar(20),sup_no varchar(20),approve_flag varchar(1),is_upload VARCHAR(1)";
sql += ",update_time datetime,update_oper varchar(20),source_price decimal(18, 4),discount decimal(18, 4),is_give varchar(1))";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("ot_pay_flow") == false)
{
string sql;
sql = "CREATE TABLE ot_pay_flow(sheet_no varchar(50),flow_id INTEGER,cus_no VARCHAR(20),oper_id VARCHAR(20),oper_date DATETIME";
sql += ",pay_way VARCHAR(50),sale_amount DECIMAL(18, 4),pay_amount DECIMAL(18, 4),old_amount DECIMAL(18, 4),ml DECIMAL(18, 4)";
sql += ",jh VARCHAR(20),approve_flag VARCHAR(1),remark VARCHAR(50),is_upload char(1)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
}
public static void Upgrade(SQLiteByHandClose db)
{
if (db.ExistTable("ic_t_inout_store_detail") == false)
{
string sql = "create table ic_t_inout_store_detail(sheet_no varchar(20),item_no varchar(20),item_subno varchar(20),item_name varchar(60),unit_no varchar(20),in_qty decimal(18,4)";
sql += ",orgi_price decimal(18,4),valid_price decimal(18,4),cost_price decimal(18,4),valid_date datetime,barcode varchar(20),sheet_sort integer,other3 varchar(60)) ";
DB.IDB d = db;
d.ExecuteScalar(sql, null);
}
//other3: 是否赠送：1赠送
}