public ActionResult ShowDetail(int id)
{
Models.Common.News indexData = new Models.Common.News();
Model.NewsModel oneData = DAL.NewsDAL.GetOneNew(id);
indexData.oneNew = oneData;
return(View("~/Views/Common/ShowDetail.cshtml", indexData));
}
//根据新闻id获取新闻内容
public static Model.NewsModel GetOneNew(int id)
{
Model.NewsModel newOne = null;
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("select * from News ");
sqlStr.Append(" where Id=@Id");
SqlParameter param = new SqlParameter("@Id", SqlDbType.Int)
{
Value = id
};
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.SqlConnectionString, CommandType.Text, sqlStr.ToString(), param);
while (dr.Read())
{
newOne = new Model.NewsModel();
newOne.NewId = Convert.ToInt32(dr["Id"]);
newOne.Title = dr["Title"].ToString();
newOne.NewSource = dr["Source"].ToString();
newOne.SubHead = dr["SubHead"].ToString();
newOne.Author = dr["Author"].ToString();
newOne.Content = dr["Content"].ToString();
newOne.IsShow = Convert.ToBoolean(dr["IsShow"]);
newOne.PubDate = Convert.ToDateTime(dr["PubDate"]);
newOne.CoverUrl = dr["CoverUrl"].ToString();
}
return(newOne);
}
//添加新闻
public static bool AddNews(Model.NewsModel newOne)
{
bool ret = false;
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("insert into News values ");
sqlStr.Append("(");
sqlStr.Append("@Title,@SubHead,@Author,@Source,@Content,@PubDate,@IsShow,@ArticleType,@CoverUrl");
sqlStr.Append(")");
SqlParameter[] paramLsit = new SqlParameter[] {
new SqlParameter("@Title", SqlDbType.NVarChar)
{
Value = newOne.Title
},
new SqlParameter("@SubHead", SqlDbType.NVarChar)
{
Value = String.IsNullOrEmpty(newOne.SubHead)?" ":newOne.SubHead
},
new SqlParameter("@Author", SqlDbType.NVarChar)
{
Value = newOne.Author
},
new SqlParameter("@Source", SqlDbType.NVarChar)
{
Value = String.IsNullOrEmpty(newOne.NewSource)?" ":newOne.NewSource
},
new SqlParameter("@Content", SqlDbType.NVarChar)
{
Value = newOne.Content
},
new SqlParameter("@PubDate", SqlDbType.DateTime)
{
Value = DateTime.Now
},
new SqlParameter("@IsShow", SqlDbType.Bit)
{
Value = newOne.IsShow
},
new SqlParameter("@ArticleType", SqlDbType.Int)
{
Value = newOne.ArticleType
},
new SqlParameter("@CoverUrl", SqlDbType.NVarChar)
{
Value = string.IsNullOrEmpty(newOne.CoverUrl)?" ":newOne.CoverUrl
}
};
int i = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnectionString, System.Data.CommandType.Text, sqlStr.ToString(), paramLsit);
if (i > 0)
{
ret = true;
}
return(ret);
}
//单个修改
public static bool DoModafy(Model.NewsModel oneNew)
{
bool ret = false;
string sqlStr = string.Empty;
sqlStr = "update News set Title=@Title,SubHead=@SubHead,Author=@Author,Source=@Source,Content=@Content,CoverUrl=@CoverUrl where Id=@Id ";
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Title", SqlDbType.NVarChar)
{
Value = oneNew.Title
},
new SqlParameter("@SubHead", SqlDbType.NVarChar)
{
Value = oneNew.SubHead
},
new SqlParameter("@Author", SqlDbType.NVarChar)
{
Value = oneNew.Author
},
new SqlParameter("@Source", SqlDbType.NVarChar)
{
Value = oneNew.NewSource
},
new SqlParameter("@Content", SqlDbType.NVarChar)
{
Value = oneNew.Content
},
new SqlParameter("@CoverUrl", SqlDbType.NVarChar)
{
Value = string.IsNullOrEmpty(oneNew.CoverUrl)?" ":oneNew.CoverUrl
},
new SqlParameter("@Id", SqlDbType.Int)
{
Value = oneNew.NewId
}
};
int i = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnectionString, CommandType.Text, sqlStr, paramList);
if (i > 0)
{
ret = true;
}
return(ret);
}
//获取信息列表
public static List <Model.NewsModel> GetDataList(int type, int count, string order)
{
List <Model.NewsModel> dataList = new List <Model.NewsModel>();
if (string.IsNullOrEmpty(order))
{
order = "Id desc";
}
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("select top(@num) * from News where ArticleType=@type order by {0}", order));
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@num", SqlDbType.Int)
{
Value = count
},
new SqlParameter("@type", SqlDbType.Int)
{
Value = type
}
};
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.SqlConnectionString, CommandType.Text, strSql.ToString(), paramList);
while (dr.Read())
{
Model.NewsModel oneData = new Model.NewsModel();
oneData.NewId = Convert.ToInt32(dr["Id"]);
oneData.Title = dr["Title"].ToString();
oneData.SubHead = dr["SubHead"].ToString();
oneData.Author = dr["Author"].ToString();
oneData.Content = dr["Content"].ToString();
oneData.NewSource = dr["Source"].ToString();
oneData.PubDate = Convert.ToDateTime(dr["PubDate"]);
oneData.CoverUrl = dr["CoverUrl"].ToString();
dataList.Add(oneData);
}
return(dataList);
}
public async Task UpdateNew(Model.NewsModel model)
{
await UpdateAsync(model);
}
//获取信息列表
public static List<Model.NewsModel> GetDataList(int type, int count,string order)
{
List<Model.NewsModel> dataList = new List<Model.NewsModel>();
if (string.IsNullOrEmpty(order))
{
order = "Id desc";
}
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("select top(@num) * from News where ArticleType=@type order by {0}",order));
SqlParameter[] paramList=new SqlParameter[]{
new SqlParameter("@num",SqlDbType.Int){Value=count},
new SqlParameter("@type",SqlDbType.Int){Value=type}
};
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.SqlConnectionString,CommandType.Text,strSql.ToString(),paramList);
while (dr.Read())
{
Model.NewsModel oneData = new Model.NewsModel();
oneData.NewId=Convert.ToInt32(dr["Id"]);
oneData.Title=dr["Title"].ToString();
oneData.SubHead = dr["SubHead"].ToString();
oneData.Author = dr["Author"].ToString();
oneData.Content = dr["Content"].ToString();
oneData.NewSource = dr["Source"].ToString();
oneData.PubDate = Convert.ToDateTime(dr["PubDate"]);
oneData.CoverUrl = dr["CoverUrl"].ToString();
dataList.Add(oneData);
}
return dataList;
}
//根据新闻id获取新闻内容
public static Model.NewsModel GetOneNew(int id)
{
Model.NewsModel newOne = null;
StringBuilder sqlStr=new StringBuilder();
sqlStr.Append("select * from News ");
sqlStr.Append(" where Id=@Id");
SqlParameter param = new SqlParameter("@Id", SqlDbType.Int) { Value = id };
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.SqlConnectionString, CommandType.Text, sqlStr.ToString(), param);
while (dr.Read())
{
newOne = new Model.NewsModel();
newOne.NewId = Convert.ToInt32(dr["Id"]);
newOne.Title = dr["Title"].ToString();
newOne.NewSource = dr["Source"].ToString();
newOne.SubHead = dr["SubHead"].ToString();
newOne.Author = dr["Author"].ToString();
newOne.Content = dr["Content"].ToString();
newOne.IsShow = Convert.ToBoolean(dr["IsShow"]);
newOne.PubDate = Convert.ToDateTime(dr["PubDate"]);
newOne.CoverUrl = dr["CoverUrl"].ToString();
}
return newOne;
}
