public int ExecuteSqlList(string[] sqlStr)
        {
            int i = 0;
            using (SQLiteTransaction dbTrans = conn.BeginTransaction())
            {
                using (SQLiteCommand cmd = conn.CreateCommand())
                {
                    try
                    {
                       foreach (string item in sqlStr)
                        {
                            if (item != null && item != "")
                            {
                                cmd.CommandText = item;
                                cmd.CommandType = CommandType.Text;
                                int j=cmd.ExecuteNonQuery();
                                i+=j;
                                 
                            }
                        }
                      
                        dbTrans.Commit();
                    }
                    catch
                    {
                        dbTrans.Rollback();
                    }
                }
            }
            return i;