public string Edit(int eid, string title, string minprice, string minarea, int housetype, string remark, string linkman, string tel, string county, string habitableroom) { timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; int userid = User.userid; using (shhouseEntities db = new shhouseEntities()) { try { int countyid = 0; try { countyid = db.Database.SqlQuery <int>(@"select areaid from dbo.base_area where areaname=@county", new SqlParameter[] { new SqlParameter("@county", county) }).First(); } catch { } house_require_wuxi myhouse_require_wuxi = db.house_require_wuxi.Find(eid); if (userid != myhouse_require_wuxi.userid) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "非本人信息不能修改", data = null })); } myhouse_require_wuxi.countyid = countyid; myhouse_require_wuxi.title = title; myhouse_require_wuxi.minprice = minprice; myhouse_require_wuxi.minarea = minarea; myhouse_require_wuxi.habitableroom = habitableroom; myhouse_require_wuxi.rentype = 0; myhouse_require_wuxi.housetype = housetype; myhouse_require_wuxi.remark = remark; myhouse_require_wuxi.linkman = linkman; myhouse_require_wuxi.tel = linkman + ",," + tel; int isok = db.SaveChanges(); if (isok > 0) { return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功", data = eid }, timeFormat)); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败", data = null })); } } catch { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "修改失败,请稍后再试" })); } } }
public string Add( string title, string minprice, string minarea, int housetype, string remark, string linkman, string tel, string county, string habitableroom) { timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; int userid = User.userid; DateTime time = DateTime.Now; string addtime = time.ToString(); int unixdate = Utils.GetUnixNum(time); string addip = Utils.GetRealIP(); int _hid = 0; using (shhouseEntities db = new shhouseEntities()) { try { int countyid = 0; try { countyid = db.Database.SqlQuery <int>(@"select areaid from dbo.base_area where areaname=@county", new SqlParameter[] { new SqlParameter("@county", county) }).First(); } catch { } house_require_wuxi myhouse_require_wuxi = new house_require_wuxi(); myhouse_require_wuxi.userid = userid; myhouse_require_wuxi.countyid = countyid; myhouse_require_wuxi.title = title; myhouse_require_wuxi.minprice = minprice; myhouse_require_wuxi.minarea = minarea; myhouse_require_wuxi.habitableroom = habitableroom; myhouse_require_wuxi.rentype = 0; myhouse_require_wuxi.housetype = housetype; myhouse_require_wuxi.remark = remark; myhouse_require_wuxi.linkman = linkman; myhouse_require_wuxi.tel = linkman + ",," + tel; myhouse_require_wuxi.hitcount = 0; myhouse_require_wuxi.isdel = 0; myhouse_require_wuxi.addtime = time; myhouse_require_wuxi.unixdate = unixdate; myhouse_require_wuxi.addip = addip; db.house_require_wuxi.Add(myhouse_require_wuxi); db.SaveChanges(); int eid = myhouse_require_wuxi.eid; if (eid > 0) { // 添加积分 appUserScore.ScoreAdd(userid.ToString(), userscore.suggestRent, "app求租房源积分"); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "发布成功", data = eid }, timeFormat)); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "发布失败", data = null })); } } catch { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "发布失败,请稍后再试" })); } } }