/// <summary>
/// 带参数的存储过程
/// </summary>
/// <param name="cmdText"></param>
/// <param name="spr"></param>
/// <returns></returns>
public static List <Dictionary <string, object> > ExecuteNonQueryPro(string cmdText, List <SqlParameter> spr)
{
List <Dictionary <string, object> > resDics = new List <Dictionary <string, object> >();
var connDics = new ConnectionHelper().GetOrgConnDic();
foreach (var dic in connDics)
{
Dictionary <string, object> resDic = new Dictionary <string, object>();
resDic["code"] = dic["code"];
resDic["name"] = dic["name"];
ISqlHelper sqlHelper = SqlConvertHelper.GetInstallSqlHelper(dic["connectionstring"]);
resDic["data"] = sqlHelper.ExecuteNonQueryPro(cmdText, spr);
resDics.Add(resDic);
}
return(resDics);
}
/// <summary>
/// 不带参数的文本查询
/// </summary>
/// <param name="cmdText"></param>
/// <returns></returns>
public static List <Dictionary <string, object> > GetDataSet(string cmdText)
{
List <Dictionary <string, object> > resDics = new List <Dictionary <string, object> >();
var connDics = new ConnectionHelper().GetOrgConnDic();
foreach (var dic in connDics)
{
Dictionary <string, object> resDic = new Dictionary <string, object>();
resDic["code"] = dic["code"];
resDic["name"] = dic["name"];
ISqlHelper sqlHelper = SqlConvertHelper.GetInstallSqlHelper(dic["connectionstring"]);
resDic["data"] = sqlHelper.GetDataSet(cmdText);
resDics.Add(resDic);
}
return(resDics);
}