/// <summary>
/// 返回第一行第一列
/// </summary>
/// <param name="sql">存储过程名称或则纯sql语句</param>
/// <param name="cmdType">CommandType 【SQL脚本Text】 【简单存储过程StoredProcedure】</param>
/// <param name="pms"></param>
/// <returns></returns>
public object ExecuteScalar(string sql, CommandType cmdType, params SqlParameter[] pms)
{
try
{
ReadDataBase.OpenSharedConnection();
object flentCount = null;
try
{
using (var cmd = WriteDataBase.CreateCommand(ReadDataBase._sharedConnection, sql, true, pms))
{
cmd.CommandType = cmdType;
if (pms != null && pms.Count() > 0)
{
cmd.Parameters.Clear();
foreach (SqlParameter item in pms)
{
cmd.Parameters.Add(item);
}
}
flentCount = cmd.ExecuteScalar();
return(flentCount);
}
}
catch (Exception ex)
{
//todu.....异常日志,关闭连接
ReadDataBase.CloseSharedConnection();
log.Info("ExecuteScalar:" + ex);
}
finally
{
ReadDataBase.CloseSharedConnection();
}
return(flentCount);
}
catch (Exception ex)
{
log.Info("ExecuteScalar:" + ex);
}
finally
{
ReadDataBase.CloseSharedConnection();
}
return(null);
}
/// <summary>
/// 查询或则DataSet
/// </summary>
/// <param name="sql">存储过程名称或则纯sql语句</param>
/// <param name="cmdType">CommandType 【SQL脚本Text】 【简单存储过程StoredProcedure】</param>
/// <param name="pms"></param>
/// <returns></returns>
public DataSet QueryFillDataSet(string sql, CommandType cmdType, params SqlParameter[] pms)
{
try
{
ReadDataBase.OpenSharedConnection();
DataSet ds = new DataSet();
using (var cmd = ReadDataBase.CreateCommand(ReadDataBase._sharedConnection, sql, true, pms))
{
cmd.CommandType = cmdType;
if (pms != null && pms.Count() > 0)
{
cmd.Parameters.Clear();
foreach (SqlParameter item in pms)
{
cmd.Parameters.Add(item);
}
}
using (DbDataAdapter dbDataAdapter = ReadDataBase._factory.CreateDataAdapter())
{
dbDataAdapter.SelectCommand = (DbCommand)cmd;
dbDataAdapter.Fill(ds);
return(ds);
}
}
}
catch (Exception ex)
{
log.Info("QueryFillDataSet:" + ex);
//todu.....异常日志,关闭连接
ReadDataBase.CloseSharedConnection();
return(null);
}
finally
{
//关闭连接
ReadDataBase.CloseSharedConnection();
}
}
