public HomeInfo FirstOne(string sql) { DataTable dt = SqlServerDBHelper.GetDataSet(sql); if (dt.Rows.Count == 0) { return(null); } var data = dt.Select().First(); 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() }; return(dal); }
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 HomeList SetGropHome(int count) { HomeList homelist = new HomeList(); for (int i = 0; i < count; i++) { HomeInfo newhome = new HomeInfo(); homelist.Blocks.Add(newhome); } return(homelist); }
public List <HomeList> SetDefaultHome(string uid, List <HomeList> listshome) { listshome[0] = SetGropHome(4); listshome[1] = SetGropHome(5); listshome[2] = SetGropHome(5); listshome[3] = SetGropHome(5); HomeInfo defaulthome00 = new HomeInfo() { ID = "", Name = "studio", Value = "简介", PluginType = PluginType.TextLink.ToString(), Url = "/user/" + uid + "/userview", Color = "#00a300", HeightClass = "nrheight1" }; HomeInfo defaulthome01 = new HomeInfo() { ID = "", Name = "blank", PluginType = PluginType.Blank.ToString(), Color = "#5839bf", HeightClass = "nrheight1" }; HomeInfo defaulthome02 = new HomeInfo() { ID = "", Name = "imageview", PluginType = PluginType.ImageView.ToString(), Color = "#009aac", Plugin = "a4e4845a498442938c267d2a0cfe31e3", HeightClass = "nrheight1" }; HomeInfo defaulthome03 = new HomeInfo() { ID = "", Name = "copyright", Value = "Copyright ©2014 Ananas Studio", PluginType = PluginType.TextLink.ToString(), Url = "javascript:;", Color = "#a000a8", ContentStyle = "font-size:12px;font-weight:normal;font-family: Arial,Helvetica,sans-serif;", HeightClass = "nrheight1" }; listshome[0].Blocks[0] = defaulthome00; listshome[0].Blocks[1] = defaulthome01; listshome[0].Blocks[2] = defaulthome02; listshome[0].Blocks[3] = defaulthome03; HomeInfo defaulthome10 = new HomeInfo() { ID = "", Name = "clock", PluginType = PluginType.ClockPlugin.ToString(), Color = "#2d87ef", HeightClass = "nrheight1" }; HomeInfo defaulthome11 = new HomeInfo() { ID = "", Name = "works", Value = "作品", PluginType = PluginType.TextLink.ToString(), Url = "/user/" + uid + "/userview/works", Color = "#d9532c", HeightClass = "nrheight1" }; HomeInfo defaulthome12 = new HomeInfo() { ID = "", Name = "projects", Value = "工作经历", PluginType = PluginType.TextLink.ToString(), Url = "/user/" + uid + "/userview/projects", Color = "#a000a8", HeightClass = "nrheight1" }; HomeInfo defaulthome13 = new HomeInfo() { ID = "", Name = "weibo", PluginType = PluginType.IconLink.ToString(), Url = "http://weibo.com/u/2381428644", Color = "#009d00", ContentStyle = "fa-weibo", WidthStyle = "float: left; width: 115px;", HeightClass = "nrheight1" }; HomeInfo defaulthome14 = new HomeInfo() { ID = "", Name = "tencent", PluginType = PluginType.IconLink.ToString(), Url = "http://t.qq.com/weiboTfff4053", Color = "#009d00", ContentStyle = "fa-tencent-weibo", WidthStyle = "float: right; width: 114px;", HeightClass = "nrheight1" }; listshome[1].Blocks[0] = defaulthome10; listshome[1].Blocks[1] = defaulthome11; listshome[1].Blocks[2] = defaulthome12; listshome[1].Blocks[3] = defaulthome13; listshome[1].Blocks[4] = defaulthome14; HomeInfo defaulthome23 = new HomeInfo() { ID = "", Name = "qq", PluginType = PluginType.IconLink.ToString(), Url = "http://wpa.qq.com/msgrd?v=3&uin=2208861110&site=qq&menu=yes", Color = "#a000a8", ContentStyle = "fa-qq", WidthStyle = "float: left; width: 115px;", HeightClass = "nrheight1" }; HomeInfo defaulthome24 = new HomeInfo() { WidthStyle = "float: right; width: 114px;", HeightClass = "nrheight1" }; listshome[2].Blocks[3] = defaulthome23; listshome[2].Blocks[4] = defaulthome24; HomeInfo defaulthome30 = new HomeInfo() { ID = "", Name = "musicplay", PluginType = PluginType.MusicPlay.ToString(), Color = "#93d008", Plugin = "53bce25f525c47388e58809897b7cc7c", HeightClass = "nrheight1" }; HomeInfo defaulthome31 = new HomeInfo() { ID = "", Name = "blank", PluginType = PluginType.Blank.ToString(), Color = "#094db5", HeightClass = "nrheight1" }; HomeInfo defaulthome32 = new HomeInfo() { ID = "", Name = "blank", PluginType = PluginType.Blank.ToString(), Color = "#009aac", HeightClass = "nrheight1" }; HomeInfo defaulthome33 = new HomeInfo() { ID = "", Name = "blank", PluginType = PluginType.Blank.ToString(), Color = "#ff5400", WidthStyle = "float: left; width: 115px;", HeightClass = "nrheight1" }; HomeInfo defaulthome34 = new HomeInfo() { ID = "", Name = "weather", Value = "南京", PluginType = PluginType.WeatherPlugin.ToString(), Color = "#5839bf", WidthStyle = "float: right; width: 114px;", HeightClass = "nrheight1" }; listshome[3].Blocks[0] = defaulthome30; listshome[3].Blocks[1] = defaulthome31; listshome[3].Blocks[2] = defaulthome32; listshome[3].Blocks[3] = defaulthome33; listshome[3].Blocks[4] = defaulthome34; return(listshome); }