public static string UpdateExcludeByCondition(CustomEntityInfo info, IEnumerable <string> props, string condition) { if (string.IsNullOrWhiteSpace(condition)) { condition = "1=1"; } return($"{info.GetBasicUpdateExcludeSql(props)} WHERE {condition}"); }
/// <summary> /// 通过Id加载实体 /// </summary> /// <param name="info"></param> /// <returns></returns> public static string LoadById(CustomEntityInfo info) { if (info.IsSoftDelete) { return($"SELECT {info.GetSelectFields()} FROM {info.TableName} WHERE IsDel=0 AND Id=@Id"); } return($"SELECT {info.GetSelectFields()} FROM {info.TableName} WHERE Id=@Id"); }
public static string UpdateByCondition(CustomEntityInfo info, string kvs, string condition) { if (string.IsNullOrWhiteSpace(condition)) { condition = "1=1"; } return($"UPDATE {info.TableName} SET {kvs} WHERE {condition}"); }
/// <summary> /// 查询实体列表 /// </summary> /// <param name="info">实体信息</param> /// <param name="condition">条件</param> /// <param name="sort">排序</param> /// <returns></returns> public static string Select(CustomEntityInfo info, string condition, string sort) { if (string.IsNullOrWhiteSpace(condition)) { condition = "1=1"; } if (string.IsNullOrWhiteSpace(sort)) { sort = $"{info.KeyFieldName} DESC"; } return($"SELECT {info.GetSelectFields()} FROM {info.TableName} WHERE {condition} ORDER BY {sort}"); }
/// <summary> /// 构造分页查询并返回数据总数的SQL /// </summary> /// <param name="info">实体的信息</param> /// <param name="condition">条件</param> /// <param name="sort">排序</param> /// <param name="pageIndex">当前页码</param> /// <param name="pageSize">每页数量</param> /// <returns></returns> public static string PagingSelectWithTotalCount(CustomEntityInfo info, string condition, string sort, int pageIndex, int pageSize) { if (string.IsNullOrWhiteSpace(condition)) { condition = "1=1"; } if (string.IsNullOrWhiteSpace(sort)) { throw new ArgumentNullException(nameof(sort), "必须提供排序字段"); } pageIndex = pageIndex < 1 ? 1 : pageIndex; pageSize = pageSize < 1 ? 1 : pageSize; return(pageIndex == 1 ? $"SELECT TOP {pageSize} {info.GetSelectFields()} FROM {info.TableName} WHERE {condition} ORDER BY {sort};SELECT @RecordCount=COUNT(0) FROM {info.TableName} WHERE {condition}" : $"SELECT {info.GetSelectFields()} FROM {info.TableName} WHERE {condition} ORDER BY {sort} OFFSET({(pageIndex - 1) * pageSize}) ROW FETCH NEXT {pageSize} ROWS ONLY;SELECT @RecordCount=COUNT(0) FROM {info.TableName} WHERE {condition}"); }
public static string DeleteByCondition(CustomEntityInfo info, string condition) { condition = string.IsNullOrWhiteSpace(condition) ? "1=1" : condition; return($"{info.GetBasicDeleteSql()} WHERE {condition}"); }
public static string DeleteById(CustomEntityInfo info) { return($"{info.GetBasicDeleteSql()} WHERE Id=@Id"); }
public static string UpdateExcludeById(CustomEntityInfo info, IEnumerable <string> props) { return($"{info.GetBasicUpdateExcludeSql(props)} WHERE {info.KeyFieldName}=@Id"); }
public static string UpdateById(CustomEntityInfo info) { return($"{info.GetBasicUpdateSql()} WHERE {info.KeyFieldName}=@Id"); }
public static string InsertAndReturnNewId(CustomEntityInfo info) { return($"{info.GetInsertSql()};SELECT SCOPE_IDENTITY();"); }
public static string Insert(CustomEntityInfo info) { return(info.GetInsertSql()); }