/// <summary>
/// 获取单个
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="dataProvider"></param>
/// <param name="strSql">查询语句</param>
/// <param name="param">参数</param>
/// <returns></returns>
public static T GetOne <T>(this BaseDataProvider dataProvider, string strSql, object param)
{
var idbCon = dataProvider.GetIDbConnection();
var data = idbCon.Query <T>(strSql, param);
idbCon.Close();
return(data.FirstOrDefault());
}
/// <summary>
/// 修改
/// </summary>
/// <param name="dataProvider"></param>
/// <param name="strSql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static int Update(this BaseDataProvider dataProvider, string strSql, object param)
{
var idbCon = dataProvider.GetIDbConnection();
var data = idbCon.Execute(strSql, param);
idbCon.Close();
return(data);
}
/// <summary>
/// 获取列表
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="dataProvider"></param>
/// <param name="strSql">查询语句</param>
/// <param name="param">参数</param>
/// <returns></returns>
public static IList <T> GetList <T>(this BaseDataProvider dataProvider, string strSql, object param)
{
var idbCon = dataProvider.GetIDbConnection();
var data = idbCon.Query <T>(strSql, param);
idbCon.Close();
return(data.ToList());
}