/// <summary> /// 摘要:执行无返回值不固定个数参数SQL语句(不带事务) /// </summary> /// <param name="conString">连接串名称,若默认连接串名称可以为null</param> /// <param name="sql">SQL语句</param> /// <param name="parameterNames">参数名称</param> /// <param name="parameterValues">参数值</param> /// <returns>影响行数</returns> public static int ExeParaSqlForNonQueryAccUp(string sql, List <string> parameterNames, List <object> parameterValues) { int iReturn = 0; List <OleDbParameter> cmdParms = new List <OleDbParameter>(); if (parameterNames.Count > 1) { for (int i = 1; i < parameterNames.Count; i++) { cmdParms.Add(new OleDbParameter(parameterNames[i], parameterValues[i])); } cmdParms.Add(new OleDbParameter(parameterNames[0], parameterValues[0])); } else { for (int i = 0; i < parameterNames.Count; i++) { cmdParms.Add(new OleDbParameter(parameterNames[i], parameterValues[i])); } } iReturn = DbHelperACE.ExecuteSql(sql, cmdParms.ToArray()); return(iReturn); }
/// <summary> /// 摘要:执行返回数据集不固定个数参数SQL语句(不带事务) /// </summary> /// <param name="conString">连接串名称,若默认连接串名称可以为null</param> /// <param name="sql">SELECT SQL语句</param> /// <param name="parameterNames">参数名称</param> /// <param name="parameterValues">参数值</param> /// <returns>数据集</returns> public static DataSet ExeParaSqlForDataSetAccess(string sql, List <string> parameterNames, List <object> parameterValues) { DataSet dsResult = new DataSet(); List <OleDbParameter> cmdParms = new List <OleDbParameter>(); for (int i = 0; i < parameterNames.Count; i++) { cmdParms.Add(new OleDbParameter(parameterNames[i], parameterValues[i])); } dsResult = DbHelperACE.Query(sql, cmdParms.ToArray()); return(dsResult); }