public int insertguest(SiteGroupCms.Entity.Guest obj) { using (DbOperHandler _doh = new Common().Doh()) { _doh.Reset(); _doh.AddFieldItem("username", obj.Username); _doh.AddFieldItem("title", obj.Title); _doh.AddFieldItem("content", obj.Content); _doh.AddFieldItem("userip", IPHelp.ClientIP); return(_doh.Insert("yy_postinfo")); } }
public void updateguest() { SiteGroupCms.Entity.Guest guest = new SiteGroupCms.Entity.Guest(); SiteGroupCms.Dal.GuestDal guestdal = new Dal.GuestDal(); SiteGroupCms.Entity.Repost repost = new Entity.Repost(); SiteGroupCms.Dal.RepostDal repostdal = new Dal.RepostDal(); guest.Id = Str2Int(Request.Form["guestid"]); guest.Username = Request.Form["username"]; guest.Addtime = Validator.StrToDate(Request.Form["addtime"], DateTime.Now); guest.Title = Request.Form["title"]; guest.Content = Request.Form["content"]; guest.Audit = Request.Form["audit"] == "true" ? 1 : 0; int res1 = guestdal.updateguest(guest); int res2 = 0; repost.Followid = Str2Int(Request.Form["guestid"]); List <SiteGroupCms.Entity.Repost> lists = repostdal.GetList(repost.Followid); if (lists == null)//添加 { repost.Content = Request.Form["recontent"]; repost.Addtime = Validator.StrToDate(Request.Form["retime"], DateTime.Now); res2 = repostdal.Insertentity(repost); } else //修改或者删除 { repost.Content = Request.Form["recontent"]; if (repost.Content != "") //修改 { repost.Addtime = Validator.StrToDate(Request.Form["retime"], DateTime.Now); res2 = repostdal.Updateentity(repost); new SiteGroupCms.Dal.LogDal().SaveLog(34); } else { res2 = repostdal.deletebyfollowid(repost); } } if ((res1 + res2) > 0) { _response = "{\"IsError\":false,\"Message\":\"保存成功\",\"Data\":0}"; new SiteGroupCms.Dal.LogDal().SaveLog(22); } else { _response = "{\"IsError\":true,\"Message\":\"保存失败\",\"Data\":0}"; } }
public int updateguest(SiteGroupCms.Entity.Guest obj) { using (DbOperHandler _doh = new Common().Doh()) { _doh.Reset(); _doh.ConditionExpress = "id=@id"; _doh.AddConditionParameter("@id", obj.Id); _doh.AddFieldItem("username", obj.Username); _doh.AddFieldItem("title", obj.Title); _doh.AddFieldItem("content", obj.Content); _doh.AddFieldItem("userip", IPHelp.ClientIP); _doh.AddFieldItem("audit", obj.Audit); if (obj.Addtime.ToString() != "0001/1/1 0:00:00") { _doh.AddFieldItem("addtime", obj.Addtime.ToString()); } return(_doh.Update("yy_postinfo")); } }
public SiteGroupCms.Entity.Guest GetEntity(int id) { SiteGroupCms.Entity.Guest dos = new SiteGroupCms.Entity.Guest(); using (DbOperHandler _doh = new Common().Doh()) { _doh.Reset(); _doh.SqlCmd = "SELECT * FROM [yy_postinfo] WHERE [id]=" + id; DataTable dt = _doh.GetDataTable(); if (dt.Rows.Count > 0) { dos.Id = Convert.ToInt32(dt.Rows[0]["id"].ToString()); dos.Title = dt.Rows[0]["title"].ToString(); dos.Content = dt.Rows[0]["content"].ToString(); dos.Addtime = Validator.StrToDate(dt.Rows[0]["addtime"].ToString(), DateTime.Now); dos.Userip = dt.Rows[0]["userip"].ToString(); dos.Audit = Convert.ToInt32(dt.Rows[0]["audit"].ToString()); dos.Username = dt.Rows[0]["username"].ToString(); } } return(dos); }