阅读:1625
回复:4
|
调用DBSQLHelper 参数问题
执行存储过程调用ExecuteStoreProcedureByDataSet方法paras参数应该传什么值?
/// <summary> /// 执行存储过程,返回DataSet /// </summary> /// <param name="connectionCode">连接池名称</param> /// <param name="procedureName">存储过程名</param> /// <param name="paras">sql语句</param> /// <returns></returns> public static DataSet ExecuteStoreProcedureByDataSet(string connectionCode, string procedureName, Parameter[] paras) { var dbObject = OThinker.H3.WorkSheet.AppUtility.Engine.SettingManager.GetBizDbConnectionConfig(connectionCode); var ds = new DataSet(); if (dbObject == null) return ds; var factory = new CommandFactory(dbObject.DbType, dbObject.DbConnectionString); var command = factory.CreateCommand(); command.ExecuteProcedure(procedureName, paras, ds); return ds; } 图片:QQ截图20170726140502.png 图片:无标题.png @岩竹玉雨@武汉技术支持团队@开始懂了@t156965365@越王勾践 |