示例#1
0
        /// <summary>根据ArrayList返回SQLiteCommand(string类型List数组传递参数)</summary>
        /// <param name="dataTypes">对应索引数据参数操作类型数组,1 长字符串,2 日期型Null值,3 长整数型Null值,4 浮点Null值,其它 字符型</param>
        /// <param name="param">string类型List数组</param>
        /// <returns>返回一个SQLiteCommand</returns>
        public static SQLiteCommand GetSqlArrCom(List <int> dataTypes, List <string> param)
        {
            SQLiteCommand ArrayCom = new SQLiteCommand();

            if (param == null)
            {
                return(ArrayCom);
            }
            for (int i = 0; i < param.Count; i++)
            {
                ParametersAdd(ref ArrayCom, DataOften.GetIntListVal(dataTypes, i), "@Par" + i, param[i]);
            }
            return(ArrayCom);
        }