/// <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"]) }); }