public DataTable GetDataTable(string pSQL, CommandType pCmdType)
{
IDbHelpParam dhp = new TransHelpParam(pSQL, pCmdType);
return(GetDataTable(dhp));
}
public DataTable GetDataTable(string pSQL, CommandType pCmdType, IDataParameter[] pArrParam)
{
IDbHelpParam dhp = new TransHelpParam(pSQL, pCmdType, pArrParam);
return(GetDataTable(dhp));
}
public int Update(string pSQL, CommandType pCmdType, IDataParameter[] pArrParam)
{
IDbHelpParam dhp = new TransHelpParam(pSQL, pCmdType, pArrParam);
return(Update(dhp));
}
public DataTable GetDataTable(string pSQL)
{
IDbHelpParam dhp = new TransHelpParam(pSQL);
return(GetDataTable(dhp));
}
public string First(string pSQL, CommandType pCmdType, IDataParameter[] pArrParam, string pReturn)
{
IDbHelpParam dhp = new TransHelpParam(pSQL, pCmdType, pArrParam);
return(First(dhp, pReturn));
}
public int Update(string pSQL)
{
IDbHelpParam dhp = new TransHelpParam(pSQL);
return(Update(dhp));
}
public string First(string pSQL, string pReturn)
{
IDbHelpParam dhp = new TransHelpParam(pSQL);
return(First(dhp, pReturn));
}
public string First(string pSQL, IDataParameter[] pArrParam)
{
IDbHelpParam dhp = new TransHelpParam(pSQL, pArrParam);
return(First(dhp, string.Empty));
}
/// <summary>
/// 第一行第一列 可能为null
/// </summary>
/// <param name="pSQL">sql 语句</param>
/// <param name="pCmdType">设置CommandType</param>
/// <param name="pArrParam">IDataParameter 参数数组</param>
/// <returns></returns>
public object Scalar(string pSQL, CommandType pCmdType, IDataParameter[] pArrParam)
{
IDbHelpParam dhp = new TransHelpParam(pSQL, pCmdType, pArrParam);
return(Scalar(dhp));
}
public string First(string pSQL)
{
IDbHelpParam dhp = new TransHelpParam(pSQL);
return(First(dhp, string.Empty));
}
public object Scalar(string pSQL)
{
IDbHelpParam dhp = new TransHelpParam(pSQL);
return(Scalar(dhp));
}
public IDataReader Read(string pSQL, CommandType pCmdType, IDataParameter[] pArrParam)
{
IDbHelpParam dhp = new TransHelpParam(pSQL, pCmdType, pArrParam);
return(Read(dhp));
}
public IDataReader Read(string pSQL)
{
IDbHelpParam dhp = new TransHelpParam(pSQL);
return(Read(dhp));
}
public DataSet GetDataSet(string pSQL, IDataParameter[] pArrParam)
{
IDbHelpParam dhp = new TransHelpParam(pSQL, pArrParam);
return(GetDataSet(dhp));
}
public DataSet GetDataSet(string pSQL)
{
IDbHelpParam dhp = new TransHelpParam(pSQL);
return(GetDataSet(dhp));
}