/// <summary>
/// Gets the delete SQL.
/// </summary>
public static SqlBatch GetDeleteSql <T>(this IDataHelper dh, T model, string otherWhereCondition, object paramUsingModel)
{
return(GetDeleteSql <T>(dh, model, otherWhereCondition, paramKeyAndValue: AttributeHelper.GetParamsArrayByModel(dh, paramUsingModel)));
}
/// <summary>
/// Gets the paged result.
/// </summary>
public static PagedResult <T> GetPagedResult <T>(this IDataHelper dh, string sourceSql, string orderColumnName, bool isAsc, int pageNumber, int pageSize, object paramUsingModel) where T : new()
{
return(GetPagedResult <T>(dh, sourceSql, orderColumnName, isAsc, pageNumber, pageSize, AttributeHelper.GetParamsArrayByModel(dh, paramUsingModel)));
}
/// <summary>
/// Gets the update SQL by where.
/// </summary>
public static SqlBatch GetUpdateSqlByWhere <T>(this IDataHelper dh, T model, bool isNullMeansIgnore, string whereCondition, object paramUsingModel)
{
return(GetUpdateSqlByWhere(dh, model, isNullMeansIgnore, whereCondition, paramKeyAndValue: AttributeHelper.GetParamsArrayByModel(dh, paramUsingModel)));
}
/// <summary>
/// Gets the list.
/// </summary>
public static List <T> GetList <T>(this IDataHelper dh, string tsqlParamed, object paramUsingModel) where T : new()
{
return(GetList <T>(dh, tsqlParamed, paramKeyAndValue: AttributeHelper.GetParamsArrayByModel(dh, paramUsingModel)));
}
/// <summary>
/// Gets the Inserts into tables if selectSqlCondition(such as 'select 1 from student where name=@name') has no record SQL.
/// </summary>
public static SqlBatch GetInsertIfNotExistSql <T>(this IDataHelper dh, T model, string selectSqlCondition, object paramUsingModel)
{
return(GetInsertIfNotExistSql <T>(dh, model, selectSqlCondition, paramKeyAndValue: AttributeHelper.GetParamsArrayByModel(dh, paramUsingModel)));
}
/// <summary>
/// Gets the one by where.
/// </summary>
public static T GetOneByWhere <T>(this IDataHelper dh, string whereCondition, object paramUsingModel) where T : new()
{
return(GetOneByWhere <T>(dh, whereCondition, paramKeyAndValue: AttributeHelper.GetParamsArrayByModel(dh, paramUsingModel)));
}
/// <summary>
/// Executes the no query. but the parameter using model.
/// </summary>
public static int ExecNoQuery(this IDataHelper dh, string tsqlParamed, object paramUsingModel)
{
return(dh.ExecNoQuery(tsqlParamed, paramKeyAndValue: AttributeHelper.GetParamsArrayByModel(dh, paramUsingModel)));
}