/// <summary>
/// 得到一个对象实体
/// </summary>
public ShowShop.Model.SystemInfo.Article GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Channel,Title,SubTitle,KeyWord,Content,CopyFrom,LinkUrl,Author,Users,Editor,Hits,Introduction,CreateTime,UpdateTime,IsTop,IsElite,IsPic,IsPageType,State,Area,Property,ImagesAddress,ImagesSoure,BrowseCount from yxs_Article ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = Id;
ShowShop.Model.SystemInfo.Article model = new ShowShop.Model.SystemInfo.Article();
DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.Channel = ds.Tables[0].Rows[0]["Channel"].ToString();
model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
model.SubTitle = ds.Tables[0].Rows[0]["SubTitle"].ToString();
model.KeyWord = ds.Tables[0].Rows[0]["KeyWord"].ToString();
model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
model.CopyFrom = ds.Tables[0].Rows[0]["CopyFrom"].ToString();
model.LinkUrl = ds.Tables[0].Rows[0]["LinkUrl"].ToString();
model.Author = ds.Tables[0].Rows[0]["Author"].ToString();
model.Users = ds.Tables[0].Rows[0]["Users"].ToString();
model.Editor = ds.Tables[0].Rows[0]["Editor"].ToString();
if (ds.Tables[0].Rows[0]["Hits"].ToString() != "")
{
model.Hits = int.Parse(ds.Tables[0].Rows[0]["Hits"].ToString());
}
model.Introduction = ds.Tables[0].Rows[0]["Introduction"].ToString();
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["IsTop"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsTop"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsTop"].ToString().ToLower() == "true"))
{
model.IsTop = true;
}
else
{
model.IsTop = false;
}
}
if (ds.Tables[0].Rows[0]["IsElite"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsElite"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsElite"].ToString().ToLower() == "true"))
{
model.IsElite = true;
}
else
{
model.IsElite = false;
}
}
if (ds.Tables[0].Rows[0]["IsPic"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsPic"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsPic"].ToString().ToLower() == "true"))
{
model.IsPic = true;
}
else
{
model.IsPic = false;
}
}
if (ds.Tables[0].Rows[0]["IsPageType"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsPageType"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsPageType"].ToString().ToLower() == "true"))
{
model.IsPageType = true;
}
else
{
model.IsPageType = false;
}
}
if (ds.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString());
}
model.Area = ds.Tables[0].Rows[0]["Area"].ToString();
model.Property = ds.Tables[0].Rows[0]["Property"].ToString();
model.ImagesAddress = ds.Tables[0].Rows[0]["ImagesAddress"].ToString();
if (ds.Tables[0].Rows[0]["ImagesSoure"].ToString() != "")
{
model.ImagesSoure = int.Parse(ds.Tables[0].Rows[0]["ImagesSoure"].ToString());
}
if (ds.Tables[0].Rows[0]["BrowseCount"].ToString() != "")
{
model.BrowseCount = int.Parse(ds.Tables[0].Rows[0]["BrowseCount"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 根据条件得到列表的前几条数据
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public List<ShowShop.Model.SystemInfo.Article> GetAllByWhere(int len, string strWhere)
{
List<ShowShop.Model.SystemInfo.Article> list = new List<ShowShop.Model.SystemInfo.Article>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top " + len.ToString() + " Id,Channel,Title,SubTitle,KeyWord,Content,CopyFrom,LinkUrl,Author,Users,Editor,Hits,Introduction,CreateTime,UpdateTime,IsTop,IsElite,IsPic,IsPageType,State,Area,Property,ImagesAddress,ImagesSoure,BrowseCount from yxs_Article ");
if (strWhere != null && strWhere != "")
{
strSql.Append("where " + strWhere + " ");
}
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
{
while (reader.Read())
{
ShowShop.Model.SystemInfo.Article model = new ShowShop.Model.SystemInfo.Article();
model.Id = Convert.ToInt32(reader["Id"]);
model.Channel = reader["Channel"].ToString();
model.Title = reader["Title"].ToString();
model.SubTitle = reader["SubTitle"].ToString();
model.KeyWord = reader["KeyWord"].ToString();
model.Content = reader["Content"].ToString();
model.CopyFrom = reader["CopyFrom"].ToString();
model.LinkUrl = reader["LinkUrl"].ToString();
model.Author = reader["Author"].ToString();
model.Users = reader["Users"].ToString();
model.Editor = reader["Editor"].ToString();
model.Hits = Convert.ToInt32(reader["Hits"]);
model.Introduction = reader["Introduction"].ToString();
model.CreateTime = Convert.ToDateTime(reader["CreateTime"]);
model.UpdateTime = Convert.ToDateTime(reader["UpdateTime"]);
model.IsTop = Convert.ToBoolean(reader["IsTop"]);
model.IsElite = Convert.ToBoolean(reader["IsElite"]);
model.IsPic = Convert.ToBoolean(reader["IsPic"]);
model.IsPageType = Convert.ToBoolean(reader["IsPageType"]);
model.State = Convert.ToInt32(reader["State"]);
model.Area = reader["Area"].ToString();
model.Property = reader["Property"].ToString();
model.ImagesAddress = reader["ImagesAddress"].ToString();
model.ImagesSoure = Convert.ToInt32(reader["ImagesSoure"].ToString());
model.BrowseCount = Convert.ToInt32(reader["BrowseCount"].ToString());
list.Add(model);
}
}
return list;
}