System.Text.Encoding.UTF8.GetString((System.Byte[])dt.Rows[i]["StoreName"])
取得结果集的存储过程
CREATE DEFINER = 'root'@'localhost'
PROCEDURE etm_chain.P_StoreClientCount(IN P_CreateMonth VARCHAR(7))
BEGIN DECLARE P_StoreName, P_DataBaseName VARCHAR(50);
DECLARE strSql TEXT;
DECLARE curs CURSOR FOR
SELECT storename
, databasename
FROM
c_store;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET P_DataBaseName = NULL;
SET strSql = '';
OPEN curs;
FETCH curs INTO P_StoreName, P_DataBaseName;
WHILE P_DataBaseName IS NOT NULL
DO
IF ifnull(P_CreateMonth,'') = '' THEN
SET strSql = concat(strSql, 'select count(*) MemberCount ,''', P_StoreName, ''' as StoreName from ', P_DataBaseName, '.member union ');
ELSE
SET strSql = concat(strSql, 'select count(*) MemberCount , ''', P_StoreName, ''' ) as StoreName from ', P_DataBaseName, '.member where date_format(createtime,"%Y-%m")=''', P_CreateMonth, ''' union ');
END IF;
FETCH curs INTO P_StoreName, P_DataBaseName;
END WHILE;
CLOSE curs;
SET strSql = concat(strSql, 'select 1,1 from c_store where 1=2;');
SET @P_strSql = strSql;
PREPARE result FROM @P_strSql;
EXECUTE result;
END