//分页
public List <NewInfo> GetPageList(int start, int end)
{
string sql = "select * from (select row_number() over(order by id) as num,* from T_News) as t where t.num>=@start and t.num<=@end";
SqlParameter[] paras =
{
//new SqlParameter("@start",start),
//new SqlParameter("@end",end)//这两句最好先确定类型，然后再给他们赋值，如下：
new SqlParameter("@start", SqlDbType.Int),
new SqlParameter("@end", SqlDbType.Int)
};
//再给他们赋值
paras[0].Value = start;
paras[1].Value = end;
DataTable da = SqlHelper.GetTable(sql, CommandType.Text, paras);
List <NewInfo> list = null;
if (da.Rows.Count > 0)
{
list = new List <NewInfo>();
NewInfo newInfo = null;
foreach (DataRow row in da.Rows)
{
//遍历所有的行
newInfo = new NewInfo();
LoadEntity(row, newInfo);
//Console.WriteLine("aaaaaaa");
//Console.WriteLine(newInfo);
list.Add(newInfo);
}
}
return(list);
}
public override int GetHashCode()
{
unchecked
{
return((NewInfo.GetHashCode() * 397) ^ OldInfo.GetHashCode());
}
}
public List <NewInfo> GetPageList(int start, int end)
{
string sql = "select * from (select row_number() over(order by id) as num,* from T_News) as t where t.num>=@start and t.num<=@end";
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@start", start),
new SqlParameter("@end", end)
};
DataTable dt = SqlHelper.GetTable(sql, CommandType.Text, pms);
List <NewInfo> list = null;
if (dt.Rows.Count > 0)
{
list = new List <NewInfo>();
NewInfo newInfo = null;
foreach (DataRow row in dt.Rows)
{
newInfo = new NewInfo();
LoadEntity(row, newInfo);
list.Add(newInfo);
}
}
return(list);
}
public ActionResult CreateNews(NewInfo info, FormCollection f)
{
if (Session["account"] is null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
var account = Session["account"] as Account;
var listtopic = f["topicstring"].ToString().Split(new char[] { ',' });
Newspaper news = new Newspaper();
NewspaperService svn = new NewspaperService();
news.Active = 0;
news.PublicationDate = DateTime.Now;
news.Journalist = account.AccountName;
news.Title = info.Title;
news.Image = info.Image;
news.Description = info.Description;
svn.AddNewspaper(news);
var result = svn.GetAll().Last();
MappingService svm = new MappingService();
foreach (var item in listtopic)
{
svm.AddMapping(new Mapping {
NewsId = result.NewsId, TopicId = Int32.Parse(item)
});
}
return(RedirectToAction("CreateNews"));
}
}
public NewInfo GetInfo(string lang)
{
NewInfo x = new NewInfo();
x.social = new Social();
string json = ReadFile();
if (!string.IsNullOrEmpty(json))
{
x = JsonConvert.DeserializeObject <NewInfo>(json);
List <Tran.NewTran> tran = T.LoadData(null, G.recordType.shortDesc, lang);
x.shortDesc = !string.IsNullOrEmpty(lang) && tran.Count > 0 ? tran[0].tran : x.shortDesc;
tran = T.LoadData(null, G.recordType.longDesc, lang);
x.longDesc = !string.IsNullOrEmpty(lang) && tran.Count > 0 ? tran[0].tran : x.longDesc;
tran = T.LoadData(null, G.recordType.about, lang);
x.about = !string.IsNullOrEmpty(lang) && tran.Count > 0 ? tran[0].tran : x.about;
tran = T.LoadData(null, G.recordType.services, lang);
x.services = !string.IsNullOrEmpty(lang) && tran.Count > 0 ? tran[0].tran : x.services;
return(x);
}
else
{
return(x);
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.article_detail);
newsInfo = JsonConvert.DeserializeObject <NewInfo>(Intent.GetStringExtra("newInfo"));
bindControls();
}
/// <summary>
/// 获取信息列表集合
/// </summary>
/// <param name="start">起始条数</param>
/// <param name="end">结束条数</param>
/// <returns></returns>
public List <NewInfo> GetPageList(int start, int end)
{
string sql = "SELECT * FROM (SELECT *,ROW_NUMBER() OVER(ORDER BY Id) AS rownum FROM T_NewInfo) AS t WHERE t.rownum BETWEEN @start AND @end";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@start", SqlDbType.Int),
new SqlParameter("@end", SqlDbType.Int)
};
param[0].Value = start;
param[1].Value = end;
DataTable dtNewInfo = SqlHelper.ExecuteDataTable(sql, CommandType.Text, param);
List <NewInfo> listNewInfo = new List <NewInfo>();
if (dtNewInfo.Rows.Count > 0)
{
foreach (DataRow dr in dtNewInfo.Rows)
{
NewInfo newInfo = new NewInfo();
LoadEntity(newInfo, dr);
listNewInfo.Add(newInfo);
}
}
return(listNewInfo);
}
public ActionResult GetNewDetail()
{
int id = Convert.ToInt32(Request["id"]);
NewInfo newInfo = newInfoService.GetNewInfo(id);
return(Json(newInfo, JsonRequestBehavior.AllowGet));
}
public ActionResult GetNewInfoModel()
{
int id = Convert.ToInt32(Request["id"]);
NewInfo newInfoModel = newInfoBll.GetUserInfoModel(id);
return(Json(newInfoModel, JsonRequestBehavior.AllowGet));
}
public ActionResult GetNewInfoModel()
{
int id = int.Parse(Request["Id"]);
NewInfo newInfo = NewInfoService.GetModel(id);
return(Json(newInfo, JsonRequestBehavior.AllowGet));
}
public ActionResult ShowDetail()
{
int id = int.Parse(Request["id"]);
NewInfo newInfo = newInfoService.GetModel(id);
ViewData.Model = newInfo;
return(View());
}
private void LoadEntity(DataRow dr, NewInfo newInfo)
{
newInfo.Id = Convert.ToInt32(dr["Id"]);
newInfo.Title = dr["Title"].ToString();
newInfo.Author = dr["Author"].ToString();
newInfo.SubDateTime = Convert.ToDateTime(dr["Date"]);
newInfo.Detail = dr["Detail"].ToString();
}
public ActionResult GetNewInfoModel()
{
int id = int.Parse(Request["id"]);
NewInfo newInfo = newInfoService.GetModel(id); //获取到了详细信息
return(Json(newInfo, JsonRequestBehavior.AllowGet)); //JsonRequestBehavior.AllowGet加了这个防止以get方式提交时候报异常
//return Content("aaaaaa");
}
public void LoadEntity(DataRow row, NewInfo newinfo)
{
newinfo.Id = Convert.ToInt32(row["ID"]);
newinfo.Author = row["Author"] != DBNull.Value ? row["Author"].ToString() : string.Empty;
newinfo.Title = row["Title"] != DBNull.Value ? row["Title"].ToString() : string.Empty;
newinfo.Msg = row["Msg"] != DBNull.Value ? row["Msg"].ToString() : string.Empty;
newinfo.ImagePath = row["ImagePath"] != DBNull.Value ? row["ImagePath"].ToString() : string.Empty;
newinfo.SubDataTime = Convert.ToDateTime(row["SubDateTime"]);
}
public ActionResult Add(NewInfo NewInfo)
{
NewInfo.RegTime = DateTime.Now;
NewInfo.ModfiedTime = DateTime.Now;
NewInfo.DelFlag = true;
NewInfo.Status = 1;
NewInfoService.Add(NewInfo);
return(Json(new { status = 1, errorMsg = "操作成功！！" }));
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.article_comments);
newsInfo = JsonConvert.DeserializeObject <NewInfo>(Intent.GetStringExtra("newsInfo"));
InitalComponents();
SetPageTitle("评论列表");
bindControls();
}
private void LoadEntity(NewInfo newInfo, DataRow dr)
{
newInfo.Id = Convert.ToInt32(dr["Id"]);
newInfo.Title = dr["Title"].ToString();
newInfo.Msg = dr["Msg"].ToString();
newInfo.ImagePath = dr["ImagePath"].ToString();
newInfo.Author = dr["Author"].ToString();
newInfo.SubDateTime = Convert.ToDateTime(dr["SubDateTime"]);
}
private void LoadEntity(DataRow row, NewInfo newInfo)
{
newInfo.Id = Convert.ToInt32(row["Id"]);
newInfo.Msg = Convert.ToString(row["Msg"]);
newInfo.Title = Convert.ToString(row["Title"]);
newInfo.SubDateTime = Convert.ToDateTime(row["SubDateTime"]);
newInfo.ImagePath = Convert.ToString(row["ImagePath"]);
newInfo.Author = Convert.ToString(row["Author"]);
}
public string Save(NewInfo x)
{
try {
if (!Directory.Exists(Server.MapPath(folder)))
{
Directory.CreateDirectory(Server.MapPath(folder));
}
WriteFile(path, x);
return(Load(null));
} catch (Exception e) { return("Error: " + e); }
}
private void PageInit()
{
if (Id > 0)
{
NewInfo NewItem = NewBiz.GetNewItem(Id);
ddl_type.SelectedValue = NewItem.ClassId.ToString();
txtArticleTitle.Value = NewItem.NewTitle;
txtSortId.Value = NewItem.SortId.ToString();
txtAddTime.Value = NewItem.AddTime.ToString();
txtArticleContent.Value = NewItem.NewContent;
}
}
public ActionResult EditNewInfo(NewInfo newinfo)
{
newinfo.SubDataTime = DateTime.Now;
if (newInfoService.UpdateEntityInfo(newinfo))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
[ValidateInput(false)] //可以接收提交过来的input标签
public ActionResult AddNewInfo(NewInfo newInfo) //此处用到了自动填充，如果提交的name属性和newinfo的属性的名称一样的时候，自动填充到newInfo对象中
{
newInfo.SubDataTime = DateTime.Now;
if (newInfoService.AddNewInfo(newInfo))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
public ActionResult CreateNews()
{
if (Session["account"] is null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
TopicService sv = new TopicService();
NewInfo s = new NewInfo();
s.Topic = sv.GetAll().ToList();
return(View(s));
}
}
private void PageInit()
{
NewsBLL bll = new NewsBLL();
rpt_list.DataSource = bll.GetTopNewList(2, 10);
rpt_list.DataBind();
NewInfo item = bll.GetNewItem(Id);
if (item != null)
{
this.NewContent = item.NewContent;
}
}
/// <summary>
/// 获取一条记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public NewInfo GetNewInfo(int id)
{
string sql = "select * from T_News where Id = @id";
SqlParameter pars = new SqlParameter("@id", DbType.Int32);
pars.Value = id;
DataTable dt = SqlHelper.GetTable(sql, CommandType.Text, pars);
NewInfo newInfo = null;
if (dt.Rows.Count > 0)
{
newInfo = new NewInfo();
LoadEntity(dt.Rows[0], newInfo);
}
return(newInfo);
}
public static NewInfo GetModel(int id)
{
string sql = "select * from T_News where Id=@id";
NewInfo newInfo = null;
DataTable dt = SqlHelper.GetTable(sql, CommandType.Text, new SqlParameter("@id", id));
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
newInfo = new NewInfo();
newInfo.Title = row["Title"].ToString();
newInfo.Msg = row["Msg"].ToString();
newInfo.Author = row["Author"].ToString();
newInfo.SubDateTime = Convert.ToDateTime(row["SubDateTime"]);
}
return(newInfo);
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
NewInfo NewItem = NewBiz.GetNewItem(Id);
NewItem.ClassId = Convert.ToInt32(ddl_type.SelectedValue);
NewItem.NewTitle = txtArticleTitle.Value;
NewItem.SortId = Convert.ToInt32(txtSortId.Value);
NewItem.AddTime = Convert.ToDateTime(txtAddTime.Value);
NewItem.NewContent = txtArticleContent.Value;
if (NewBiz.UpdateNew(NewItem) > 0)
{
base.ErrorMsg("提交成功！", "NewsList.aspx?pid=" + parentId, 1);
}
else
{
base.ErrorMsg("提交失败！", "NewsList.aspx?pid=" + parentId, 1);
}
}
public static int AddNew(NewInfo item)
{
string spName = "cudo_createnew";
SqlParameter[] paramvalues = new SqlParameter[]
{
new SqlParameter("@classid", item.ClassId),
new SqlParameter("@newtitle", item.NewTitle),
new SqlParameter("@newcontent", item.NewContent),
new SqlParameter("@imgsrc", item.ImgSrc),
new SqlParameter("@intro", item.Intro),
new SqlParameter("@author", item.Author),
new SqlParameter("@source", item.Source),
new SqlParameter("@hit", item.Hit),
new SqlParameter("@sortid", item.SortId),
new SqlParameter("@addtime", item.AddTime)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.StoredProcedure, spName, paramvalues));
}
public NewInfo GetModel(int id)
{
//获取详细内容中的一条新闻的信息
string sql = "select * from T_News where id=@id";
SqlParameter[] paras =
{
new SqlParameter("@id", SqlDbType.Int),
};
paras[0].Value = id;
DataTable da = SqlHelper.GetTable(sql, CommandType.Text, paras);
NewInfo newInfo = null;
if (da.Rows.Count > 0)
{
newInfo = new NewInfo();
LoadEntity(da.Rows[0], newInfo);
}
return(newInfo);//返回一条详细的新闻内容
}
/// <summary>
/// 根据ID获取NewInfo对象
/// </summary>
/// <param name="id">Id</param>
/// <returns>NewInfo对象</returns>
public NewInfo GetUserInfoModel(int id)
{
string sql = "SELECT Id, Title, Msg, ImagePath, Author, SubDateTime FROM T_NewInfo where Id=@id";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@id", SqlDbType.Int)
};
param[0].Value = id;
DataTable dtNewInfo = SqlHelper.ExecuteDataTable(sql, CommandType.Text, param);
NewInfo newInfo = new NewInfo();
if (dtNewInfo.Rows.Count > 0)
{
LoadEntity(newInfo, dtNewInfo.Rows[0]);
}
return(newInfo);
}
