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);
}