public List <WorkInfo> GetWorksWhere(string strwhere) { List <WorkInfo> dals = new List <WorkInfo>(); string sql = "select * from Ananas_Work where " + strwhere; SqlDataReader data = SqlServerDBHelper.GetReader(sql); while (data.Read()) { WorkInfo dal = new WorkInfo() { ID = data["ID"].ToString(), UID = data["UID"].ToString(), Content = data["Content"].ToString(), Title = data["Title"].ToString(), Type = data["Type"].ToString(), Cover = data["Cover"].ToString(), Reading = data["Reading"].ToString(), Zaning = data["Zaning"].ToString(), CreateDate = ((DateTime)data["CreateDate"]).ToString(@"yyyy-MM-dd HH:mm") }; dals.Add(dal); } return(dals); }
//特殊处理获取子表 public List <WorkInfo> GetWorksWhereWithDetail(string strwhere) { List <WorkInfo> dals = new List <WorkInfo>(); string sql = "select * from Ananas_Work where " + strwhere; SqlDataReader data = SqlServerDBHelper.GetReader(sql); while (data.Read()) { WorkInfo dal = new WorkInfo() { ID = data["ID"].ToString(), UID = data["UID"].ToString(), Content = data["Content"].ToString(), Title = data["Title"].ToString(), Type = data["Type"].ToString(), Cover = data["Cover"].ToString(), Reading = data["Reading"].ToString(), Zaning = data["Zaning"].ToString(), ZanCount = SqlServerDBHelper.GetScalar("select COUNT(*) from Ananas_Comment where WorkID='" + data["ID"].ToString() + "' and Type='" + CommentType.Zan + "'"), CommentsCount = SqlServerDBHelper.GetScalar("select COUNT(*) from Ananas_Comment where WorkID='" + data["ID"].ToString() + "' and Type='" + CommentType.Commrnt + "'"), CreateDate = ((DateTime)data["CreateDate"]).ToString(@"yyyy-MM-dd HH:mm") }; dals.Add(dal); } return(dals); }
public List <UserInfo> GetAll() { List <UserInfo> dals = new List <UserInfo>(); string sql = "select * from Ananas_User"; SqlDataReader data = SqlServerDBHelper.GetReader(sql); while (data.Read()) { UserInfo dal = new UserInfo() { ID = data["ID"].ToString(), Name = data["Name"].ToString(), sName = data["sName"].ToString(), Password = data["Password"].ToString(), Role = (int)data["RoleID"], Skin = data["Skin"].ToString(), Email = data["Email"].ToString(), Introduction = data["Introduction"].ToString(), ImageUrl = data["ImageUrl"].ToString(), Projects = data["Projects"].ToString(), Background = data["Background"].ToString() }; dals.Add(dal); } return(dals); }
//特殊处理图片子表 public List <FilesInfo> GetImageWithDetail(string strwhere) { List <FilesInfo> dals = new List <FilesInfo>(); string sql = "select * from Ananas_File where " + strwhere; SqlDataReader data = SqlServerDBHelper.GetReader(sql); while (data.Read()) { FilesInfo dal = new FilesInfo() { ID = data["ID"].ToString(), UID = data["UID"].ToString(), Name = data["Name"].ToString(), State = data["State"].ToString(), Type = data["Type"].ToString(), Extension = data["Extension"].ToString(), CreateDate = (DateTime)data["CreateDate"], Url = data["Url"].ToString(), Describe = data["Describe"].ToString(), Owner = data["Owner"].ToString(), ParentID = data["ParentID"].ToString(), IsPrivate = data["IsPrivate"].ToString(), Custom = data["Custom"].ToString(), FirstSize = this.GetFirstSize(data["Custom"].ToString()), SizeList = this.GetSizeList(data["Custom"].ToString()), Remark = data["Remark"].ToString(), CoverUrl = data["CoverUrl"].ToString() }; dals.Add(dal); } return(dals); }
public List <HomeInfo> GetHomeWhere(string strwhere) { List <HomeInfo> dals = new List <HomeInfo>(); string sql = "select * from Ananas_Home where " + strwhere; SqlDataReader data = SqlServerDBHelper.GetReader(sql); while (data.Read()) { HomeInfo dal = new HomeInfo() { ID = data["ID"].ToString(), UID = data["UID"].ToString(), Name = data["Name"].ToString(), Value = data["Value"].ToString(), Type = data["Type"].ToString(), Url = data["Url"].ToString(), Color = data["Color"].ToString(), PluginType = data["PluginType"].ToString(), Plugin = data["Plugin"].ToString(), WidthStyle = data["WidthStyle"].ToString(), HeightClass = data["HeightClass"].ToString(), GroupID = data["GroupID"].ToString(), Order = data["Order"].ToString(), ContentStyle = data["ContentStyle"].ToString(), Remark = data["Remark"].ToString() }; dals.Add(dal); } return(dals); }
public List <HomeList> GetHomeWhereWithBlock(string strwhere) { List <HomeList> dals = new List <HomeList>(); string sql = "select * from Ananas_Home where " + strwhere; SqlDataReader data = SqlServerDBHelper.GetReader(sql); while (data.Read()) { HomeList dal = new HomeList() { ID = data["ID"].ToString(), UID = data["UID"].ToString(), Type = data["Type"].ToString(), Order = data["Order"].ToString(), GroupClass = data["Value"].ToString(), Blocks = this.GetHomeWhere("GroupID ='" + data["ID"].ToString() + "'").OrderBy(d => d.Order).ToList() }; dals.Add(dal); } return(dals); }
public List <CommentInfo> GetCommentSql(string sql) { List <CommentInfo> dals = new List <CommentInfo>(); //string sql = "select * from Ananas_Comment where " + strwhere; SqlDataReader data = SqlServerDBHelper.GetReader(sql); while (data.Read()) { CommentInfo dal = new CommentInfo() { ID = data["ID"].ToString(), WorkID = data["WorkID"].ToString(), Content = data["Content"].ToString(), IP = data["IP"].ToString(), Type = data["Type"].ToString(), Remark = data["Remark"].ToString(), UID = data["UID"].ToString(), CreateDate = ((DateTime)data["CreateDate"]).ToString(@"yyyy-MM-dd HH:mm") }; dals.Add(dal); } return(dals); }