public UserInfo FirstOne(string sql) { DataTable dt = SqlServerDBHelper.GetDataSet(sql); if (dt.Rows.Count == 0) { return(null); } var data = dt.Select().First(); 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 = GetImageUrl(data["ImageUrl"].ToString()), Projects = data["Projects"].ToString(), Background = data["Background"].ToString() }; return(dal); }
public FilesInfo FirstImageOne(string sql) { DataTable dt = SqlServerDBHelper.GetDataSet(sql); if (dt.Rows.Count == 0) { return(null); } var data = dt.Select().First(); 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(), Size = data["Custom"].ToString().Split(';'), Remark = data["Remark"].ToString(), CoverUrl = data["CoverUrl"].ToString() }; return(dal); }
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 CommentInfo FirstOne(string sql) { DataTable dt = SqlServerDBHelper.GetDataSet(sql); if (dt.Rows.Count == 0) { return(null); } var data = dt.Select().First(); 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") }; return(dal); }
public WorkInfo FirstOne(string sql) { DataTable dt = SqlServerDBHelper.GetDataSet(sql); if (dt.Rows.Count == 0) { return(null); } var data = dt.Select().First(); 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") }; return(dal); }