/// <summary> /// 执行返回单值结果的查询 /// 对于字符串类型的参数,最好指定参数的长度,格式例如是{0:50}; /// 对于Decimal类型,最好指定精度和小数位,例如{0:8.3},表示精度为8,小数位为3 /// </summary> /// <param name="sqlFormat">带格式的查询命令字符串,例如SELECT * FROM TABLE1 WHERE CLASSID={0} AND CLASSNAME={1:50} PRICE={2:8.3}</param> /// <param name="parameters">要替换的参数</param> /// <returns>返回的单值结果</returns> public object FormatExecuteScalar(string sqlFormat, params object[] parameters) { DataParameterFormat formater = new DataParameterFormat(this); string sql = string.Format(formater, sqlFormat, parameters); return(base.ExecuteScalar(sql, CommandType.Text, formater.DataParameters)); }
/// <summary> /// 执行返回数据阅读器的查询 /// 对于字符串类型的参数,最好指定参数的长度,格式例如是{0:50}; /// 对于Decimal类型,最好指定精度和小数位,例如{0:8.3},表示精度为8,小数位为3 /// </summary> /// <param name="sqlFormat">带格式的查询命令字符串,例如SELECT * FROM TABLE1 WHERE CLASSID={0} AND CLASSNAME={1:50} PRICE={2:8.3}</param> /// <param name="parameters">要替换的参数</param> /// <returns>数据阅读器</returns> public IDataReader FormatExecuteDataReader(string sqlFormat, params object[] parameters) { if (parameters == null) { return(base.ExecuteDataReader(sqlFormat)); } else { DataParameterFormat formater = new DataParameterFormat(this); string sql = string.Format(formater, sqlFormat, parameters); return(base.ExecuteDataReader(sql, CommandType.Text, formater.DataParameters)); } }