//分页 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); }