/// <summary>
/// 根据条件分页获取列表 GetList(int currentPageIndex, int pageSize, out int totalCount, string strWhere, string orderBy)
/// </summary>
/// <param name="currentPageIndex">当前页码(int)</param>
/// <param name="pageSize">分页大小(int)</param>
/// <param name="totalCount">总记录数(out int)</param>
/// <param name="strWhere">查询条件(string)</param>
/// <param name="orderBy">排序字段(string)</param>
/// <returns>返回List<CustomersInfo>类型数据,未查询到数据则返回null</returns>
public List <DailyInfo> GetList(int currentPageIndex, int pageSize, out int totalCount, string strWhere, string orderBy)
{
if (!string.IsNullOrEmpty(strWhere))
{
strWhere = " and " + strWhere;
}
return(SqlMethodHelper.Find(SqlHelper.GetPagingStoredProcedureParameters("XSBlog_Daily", "*", strWhere, orderBy, pageSize, currentPageIndex, 3), out totalCount, ReaderBind));
}
/// <summary>
/// 获得树形列表
/// </summary>
/// <returns></returns>
public List <CategoryInfo> GetTreeList()
{
var strSql = new StringBuilder();
strSql.Append(" select Id, Guid, Name, parent_Guid, Order_Id, Image_Url, Image_Key, Blog_Guid, User_Guid ");
strSql.Append(" from dbo.F_XSBlog_GetCategorys('00000000-0000-0000-0000-000000000000') ");
strSql.Append(" order by order_id ");
return(SqlMethodHelper.Find(strSql.ToString(), ReaderBind, null));
}
/// <summary>
/// 装载数据实体 BlogInfo
/// </summary>
/// <param name="dr">数据读取器</param>
/// <returns>BlogInfo</returns>
private BlogInfo ReaderBind(IDataReader dr)
{
return(new BlogInfo
{
Id = SqlMethodHelper.Convert <decimal>(dr["Id"]),
Guid = SqlMethodHelper.Convert <Guid>(dr["Guid"]).ToString(),
Name = SqlMethodHelper.Convert <string>(dr["Name"]),
Tag = SqlMethodHelper.Convert <string>(dr["Tag"]),
Order = SqlMethodHelper.Convert <int>(dr["Order"])
});
}
/// <summary>
/// 根据条件分页获取列表 GetList(int currentPageIndex, int pageSize, out int totalCount, string strWhere, string orderBy)
/// </summary>
/// <param name="currentPageIndex">当前页码(int)</param>
/// <param name="pageSize">分页大小(int)</param>
/// <param name="totalCount">总记录数(out int)</param>
/// <param name="strWhere">查询条件(string)</param>
/// <param name="orderBy">排序字段(string)</param>
/// <returns>返回List<CustomersInfo>类型数据,未查询到数据则返回null</returns>
public List <UserInfo> GetList(int currentPageIndex, int pageSize, out int totalCount, string strWhere, string orderBy)
{
if (string.IsNullOrEmpty(strWhere))
{
strWhere = " 1=1 ";
}
strWhere = string.IsNullOrEmpty(strWhere) ? "" : " AND " + strWhere;
if (string.IsNullOrEmpty(orderBy))
{
}
return(SqlMethodHelper.Find(SqlHelper.GetPagingStoredProcedureParameters("XSBlog_User", "*", strWhere, orderBy, pageSize, currentPageIndex, 3), out totalCount, ReaderBind));
}
/// <summary>
/// 装载数据实体 AlbumInfo
/// </summary>
/// <param name="dr">数据读取器</param>
/// <returns>AlbumInfo</returns>
private AlbumInfo ReaderBind(IDataReader dr)
{
return(new AlbumInfo
{
Id = SqlMethodHelper.Convert <decimal>(dr["Id"]),
Guid = SqlMethodHelper.Convert <Guid>(dr["Guid"]).ToString(),
Name = SqlMethodHelper.Convert <string>(dr["Name"]),
BlogGuid = SqlMethodHelper.Convert <Guid>(dr["Blog_Guid"]).ToString(),
UserGuid = SqlMethodHelper.Convert <Guid>(dr["User_Guid"]).ToString(),
CreateTime = SqlMethodHelper.Convert <DateTime>(dr["Create_Time"]),
OrderId = SqlMethodHelper.Convert <int>(dr["Order_Id"])
});
}
/// <summary>
/// 装载数据实体 UserInfo
/// </summary>
/// <param name="dr">数据读取器</param>
/// <returns>UserInfo</returns>
private UserInfo ReaderBind(IDataReader dr)
{
return(new UserInfo
{
Id = SqlMethodHelper.Convert <decimal>(dr["Id"]),
Guid = SqlMethodHelper.Convert <Guid>(dr["Guid"]).ToString(),
Name = SqlMethodHelper.Convert <string>(dr["Name"]),
Tag = SqlMethodHelper.Convert <string>(dr["Tag"]),
LoginName = SqlMethodHelper.Convert <string>(dr["Login_Name"]),
LoginPwd = SqlMethodHelper.Convert <string>(dr["Login_Pwd"]),
Email = SqlMethodHelper.Convert <string>(dr["Email"])
});
}
/// <summary>
/// 装载数据实体 MoodInfo
/// </summary>
/// <param name="dr">数据读取器</param>
/// <returns>MoodInfo</returns>
private MoodInfo ReaderBind(IDataReader dr)
{
return(new MoodInfo
{
Id = SqlMethodHelper.Convert <int>(dr["Id"]),
Guid = SqlMethodHelper.Convert <Guid>(dr["Guid"]).ToString(),
Name = SqlMethodHelper.Convert <string>(dr["Name"]),
Content = SqlMethodHelper.Convert <string>(dr["Content"]),
CreateTime = SqlMethodHelper.Convert <DateTime>(dr["Create_Time"]),
BlogGuid = SqlMethodHelper.Convert <Guid>(dr["Blog_Guid"]).ToString(),
UserGuid = SqlMethodHelper.Convert <Guid>(dr["User_Guid"]).ToString()
});
}
/// <summary>
/// 装载数据实体 CategoryInfo
/// </summary>
/// <param name="dr">数据读取器</param>
/// <returns>CategoryInfo</returns>
private CategoryInfo ReaderBind(IDataReader dr)
{
return(new CategoryInfo
{
Id = SqlMethodHelper.Convert <decimal>(dr["Id"]),
Guid = SqlMethodHelper.Convert <Guid>(dr["Guid"]).ToString(),
Name = SqlMethodHelper.Convert <string>(dr["Name"]),
OrderId = SqlMethodHelper.Convert <int>(dr["Order_Id"]),
BlogGuid = SqlMethodHelper.Convert <Guid>(dr["Blog_Guid"]).ToString(),
UserGuid = SqlMethodHelper.Convert <Guid>(dr["User_Guid"]).ToString(),
ImageUrl = SqlMethodHelper.Convert <string>(dr["Image_Url"]),
ImageKey = SqlMethodHelper.Convert <Guid>(dr["Image_Key"]).ToString(),
ParentGuid = SqlMethodHelper.Convert <Guid>(dr["Parent_Guid"]).ToString()
});
}
/// <summary>
/// 得到一个对象实体 GetModelById(int categoryId)
/// </summary>
public CategoryInfo GetModelById(int categoryId)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name ,Order_Id, Blog_Guid, User_Guid, Image_Url, Image_Key, Parent_Guid ");
strSql.Append(" from XSBlog_Category ");
strSql.Append(" where ");
strSql.Append(" Id = @Id ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Id", (DbType)SqlDbType.Int, categoryId)
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 得到一个对象实体 GetModel(Guid Guid)
/// </summary>
public CategoryInfo GetModel(string guid)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name ,Order_Id, Blog_Guid, User_Guid, Image_Url, Image_Key, Parent_Guid ");
strSql.Append(" from XSBlog_Category ");
strSql.Append(" where ");
strSql.Append(" Guid = @Guid ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Guid", (DbType)SqlDbType.UniqueIdentifier, ConvertHelper.GetGuid(guid))
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 得到一个对象实体 GetModelById(int id)
/// </summary>
public DailyInfo GetModelById(int id)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Content, Create_Time, Blog_Guid, User_Guid, Category_Guid, Is_Draft, Is_Stick, Is_Home, Is_Special, Page_View, Comments_Num ");
strSql.Append(" from XSBlog_Daily ");
strSql.Append(" where ");
strSql.Append(" Id = @Id ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Id", (DbType)SqlDbType.Int, id)
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 得到一个对象实体 GetModel(Guid Guid)
/// </summary>
public UserInfo GetModel(string guid)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Tag, Login_Name, Login_Pwd, Email ");
strSql.Append(" from XSBlog_User ");
strSql.Append(" where ");
strSql.Append(" Guid = @Guid ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Guid", (DbType)SqlDbType.UniqueIdentifier, ConvertHelper.GetGuid(guid))
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 得到一个对象实体 GetModel(Guid Guid)
/// </summary>
public BlogInfo GetModel(string guid)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Tag, Order ");
strSql.Append(" from XSBlog_Blog ");
strSql.Append(" where ");
strSql.Append(" Guid = @Guid ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Guid", (DbType)SqlDbType.VarChar, ConvertHelper.GetGuid(guid))
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 装载数据实体 PhotoInfo
/// </summary>
/// <param name="dr">数据读取器</param>
/// <returns>PhotoInfo</returns>
private PhotoInfo ReaderBind(IDataReader dr)
{
return(new PhotoInfo
{
Id = SqlMethodHelper.Convert <int>(dr["Id"]),
Guid = SqlMethodHelper.Convert <Guid>(dr["Guid"]).ToString(),
Name = SqlMethodHelper.Convert <string>(dr["Name"]),
Tag = SqlMethodHelper.Convert <string>(dr["Tag"]),
ImageUrl = SqlMethodHelper.Convert <string>(dr["Image_Url"]),
ImageKey = SqlMethodHelper.Convert <Guid>(dr["Image_Key"]).ToString(),
UserGuid = SqlMethodHelper.Convert <Guid>(dr["User_Guid"]).ToString(),
AlbumGuid = SqlMethodHelper.Convert <Guid>(dr["Album_Guid"]).ToString(),
Createtime = SqlMethodHelper.Convert <DateTime>(dr["Create_time"]),
IsCover = SqlMethodHelper.Convert <bool>(dr["Is_Cover"])
});
}
/// <summary>
/// 得到一个对象实体 GetModel(Guid Guid)
/// </summary>
public PhotoInfo GetModel(string guid)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Tag, Image_Url, Image_Key, User_Guid, Album_Guid, Create_time, Is_Cover ");
strSql.Append(" from XSBlog_Photo ");
strSql.Append(" where ");
strSql.Append(" Guid = @Guid ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Guid", (DbType)SqlDbType.UniqueIdentifier, ConvertHelper.GetGuid(guid))
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 得到一个对象实体 GetModelById(int id)
/// </summary>
public PhotoInfo GetModelById(int id)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Tag, Image_Url, Image_Key, User_Guid, Album_Guid, Create_time, Is_Cover ");
strSql.Append(" from XSBlog_Photo ");
strSql.Append(" where ");
strSql.Append(" Id = @Id ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Id", (DbType)SqlDbType.Int, id)
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 得到一个对象实体 GetModelById(int id)
/// </summary>
public AlbumInfo GetModelById(int id)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Blog_Guid, User_Guid, Create_Time,Order_Id ");
strSql.Append(" from XSBlog_Album ");
strSql.Append(" where ");
strSql.Append(" Id = @Id ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Id", (DbType)SqlDbType.Int, id)
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 得到一个对象实体 GetModel(Guid Guid)
/// </summary>
public MoodInfo GetModel(string guid)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Content, Create_Time, Blog_Guid, User_Guid ");
strSql.Append(" from XSBlog_Mood ");
strSql.Append(" where ");
strSql.Append(" Guid = @Guid ");
DbParameter[] parameters =
{
SqlHelper.MakeInParam("@Guid", (DbType)SqlDbType.UniqueIdentifier, ConvertHelper.GetGuid(guid))
};
return(SqlMethodHelper.FindOne(strSql.ToString(), ReaderBind, parameters));
}
/// <summary>
/// 获得前几条数据
/// </summary>
/// <param name="count"></param>
/// <param name="strWhere"></param>
/// <param name="orderBy"></param>
/// <returns></returns>
public List <PhotoInfo> GetTopList(int count, string strWhere, string orderBy)
{
var strSql = new StringBuilder();
strSql.Append("select top " + count +
" Id, Guid, Name, Tag, Image_Url, Image_Key, User_Guid, Album_Guid, Create_time, Is_Cover ");
strSql.Append(" from XSBlog_Photo ");
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" where " + strWhere);
}
if (!string.IsNullOrEmpty(orderBy))
{
strSql.Append(" order by " + orderBy);
}
return(SqlMethodHelper.Find(strSql.ToString(), ReaderBind, null));
}
/// <summary>
/// 获得前几条数据
/// </summary>
/// <param name="count"></param>
/// <param name="strWhere"></param>
/// <param name="orderBy"></param>
/// <returns></returns>
public List <DailyInfo> GetTopList(int count, string strWhere, string orderBy)
{
var strSql = new StringBuilder();
strSql.Append("select top " + count +
" Id, Guid, Name, Content, Create_Time, Blog_Guid, User_Guid, Category_Guid, Is_Draft, Is_Stick, Is_Home, Is_Special, Page_View, Comments_Num ");
strSql.Append(" from XSBlog_Daily ");
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" where " + strWhere);
}
if (!string.IsNullOrEmpty(orderBy))
{
strSql.Append(" order by " + orderBy);
}
return(SqlMethodHelper.Find(strSql.ToString(), ReaderBind, null));
}
/// <summary>
/// 根据条件获取列表 GetList(string strWhere,string orderBy=null)
/// </summary>
/// <param name="strWhere">strWhere</param>
/// <param name="orderBy">orderBy</param>
/// <returns>返回List(UserInfo)类型数据,未查询到数据则返回null</returns>
public List <UserInfo> GetList(string strWhere, string orderBy = null)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Tag, Login_Name, Login_Pwd, Email ");
strSql.Append(" from XSBlog_User ");
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" where " + strWhere);
}
if (string.IsNullOrEmpty(orderBy))
{
}
else
{
strSql.Append(" order by " + orderBy);
}
return(SqlMethodHelper.Find(strSql.ToString(), ReaderBind, null));
}
/// <summary>
/// 根据条件获取列表 GetList(string strWhere,string orderBy=null)
/// </summary>
/// <param name="strWhere">strWhere</param>
/// <param name="orderBy">orderBy</param>
/// <returns>返回List(MoodInfo)类型数据,未查询到数据则返回null</returns>
public List <MoodInfo> GetList(string strWhere, string orderBy = null)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name, Content, Create_Time, Blog_Guid, User_Guid ");
strSql.Append(" from XSBlog_Mood ");
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" where " + strWhere);
}
if (string.IsNullOrEmpty(orderBy))
{
}
else
{
strSql.Append(" order by " + orderBy);
}
return(SqlMethodHelper.Find(strSql.ToString(), ReaderBind, null));
}
/// <summary>
/// 根据条件获取列表 GetList(string strWhere,string orderBy=null)
/// </summary>
/// <param name="strWhere">strWhere</param>
/// <param name="orderBy">orderBy</param>
/// <returns>返回List(CategoryInfo)类型数据,未查询到数据则返回null</returns>
public List <CategoryInfo> GetList(string strWhere, string orderBy = null)
{
var strSql = new StringBuilder();
strSql.Append("select Id, Guid, Name ,Order_Id, Blog_Guid, User_Guid, Image_Url, Image_Key, Parent_Guid ");
strSql.Append(" from XSBlog_Category ");
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" where " + strWhere);
}
if (string.IsNullOrEmpty(orderBy))
{
}
else
{
strSql.Append(" order by " + orderBy);
}
return(SqlMethodHelper.Find(strSql.ToString(), ReaderBind, null));
}
/// <summary>
/// 装载数据实体 DailyInfo
/// </summary>
/// <param name="dr">数据读取器</param>
/// <returns>DailyInfo</returns>
private DailyInfo ReaderBind(IDataReader dr)
{
return(new DailyInfo
{
Id = SqlMethodHelper.Convert <decimal>(dr["Id"]),
Guid = SqlMethodHelper.Convert <Guid>(dr["Guid"]).ToString(),
Name = SqlMethodHelper.Convert <string>(dr["Name"]),
Content = SqlMethodHelper.Convert <string>(dr["Content"]),
CreateTime = SqlMethodHelper.Convert <DateTime>(dr["Create_Time"]),
BlogGuid = SqlMethodHelper.Convert <Guid>(dr["Blog_Guid"]).ToString(),
UserGuid = SqlMethodHelper.Convert <Guid>(dr["User_Guid"]).ToString(),
CategoryGuid = SqlMethodHelper.Convert <Guid>(dr["Category_Guid"]).ToString(),
IsDraft = SqlMethodHelper.Convert <bool>(dr["Is_Draft"]),
IsStick = SqlMethodHelper.Convert <bool>(dr["Is_Stick"]),
IsHome = SqlMethodHelper.Convert <bool>(dr["Is_Home"]),
IsSpecial = SqlMethodHelper.Convert <int>(dr["Is_Special"]),
PageView = SqlMethodHelper.Convert <int>(dr["Page_View"]),
CommentsNum = SqlMethodHelper.Convert <int>(dr["Comments_Num"])
});
}
