/// <summary> /// 执行查询的存储过程,不分页 /// </summary> /// <typeparam name="T">类型参数必须是引用类型;这一点也适用于任何类、接口、委托或数组类型。</typeparam> /// <param name="iEntity">参数实体</param> /// <param name="errMsg">错误信息</param> /// <returns></returns> private IEnumerable <T> GetListing <T>(ISPEntity iEntity, ref string errMsg) where T : class { StoredProcedureMappingAttribute attribute = DMSExpression.GetStoredProcedureMappingAttribute(iEntity.GetType()); DMSDbProvider provider = DMSExpression.GetDbProvider(attribute.DMSDbType, attribute.ConfigName); using (var conn = provider.GetOpenConnection()) { DynamicParameters parameters = GetParameters(iEntity); return(DMSDbAccess.Query <T>(conn, attribute.Name, attribute.Name, parameters, 0, null, true, 30, System.Data.CommandType.StoredProcedure)); } }
/// <summary> /// 执行更新,删除,插入的存储过程 /// </summary> /// <param name="iEntity">存储过程实体类</param> /// <param name="errMsg">错误信息</param> /// <returns></returns> public bool ExecuteNoQuery(ISPEntity iEntity, ref string errMsg) { StoredProcedureMappingAttribute attribute = DMSExpression.GetStoredProcedureMappingAttribute(iEntity.GetType()); DMSDbProvider provider = DMSExpression.GetDbProvider(attribute.DMSDbType, attribute.ConfigName); using (var conn = provider.GetOpenConnection()) { DynamicParameters parameters = GetParameters(iEntity); int resultValue = DMSDbAccess.Execute(conn, attribute.Name, attribute.Name, parameters, null, 30, System.Data.CommandType.StoredProcedure); if (resultValue > 0) { return(true); } return(false); } }