/// <summary> /// 手机号码管理 /// </summary> /// <param name="phone">手机号码</param> /// <param name="yzm">验证码</param> /// <param name="password">密码</param> /// <param name="type">1 安全手机号码,2 展示手机号码</param> /// <param name=""></param> /// <returns></returns> public string phonemanage(string phone, string password, string yzm, int type = 1) { using (var db = new shhouseEntities()) { try { var user_details = db.user_details.Find(User.userid); if (type == 1) { //var uservalidityrecord = db.Database.SqlQuery<int>(" select top 1 eid from user_validityrecord where userid = @userid and codetype = 2 and checkcode = @checkcode and state = 0 and validity > getdate() order by addtime desc ", new SqlParameter[] { new SqlParameter("@userid", User.userid), new SqlParameter("@checkcode", yzm) }); var uservalidityrecord = db.user_validityrecord.SqlQuery(" select top 1 * from user_validityrecord where userid = " + User.userid + " and codetype = 1 and checkcode = '" + yzm + "' and state = 0 and validity > getdate() order by validity desc ").FirstOrDefault(); if (uservalidityrecord == null) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "验证码错误!" })); } uservalidityrecord.state = "1"; user_details.mobile = phone; db.SaveChanges(); //string path = System.Web.HttpContext.Current.Server.MapPath($"~/tokens/" + Utils.MD5(User.userid.ToString()) + ".json"); //Utils.DeleteFile(path); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功!" })); } else { if (!string.IsNullOrEmpty(password)) { password = Utils.MD5(password); } var user_member = db.user_member.Where(p => p.userid == User.userid && p.password == password).FirstOrDefault(); if (user_member == null) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "密码错误!" })); } user_details.mobile_zs = phone; db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功" })); } } catch (Exception e) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败,请稍后再试!" })); } } }
public string AddTempl(int ttype, string tname, string tcontent) { int userid = User.userid; using (shhouseEntities ent = new shhouseEntities()) { try { house_template tt = new house_template() { ttype = ttype, tname = tname, tcontent = tcontent, userid = userid, createtime = DateTime.Now }; ent.house_template.Add(tt); ent.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "提交成功" })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "提交失败,请稍后再试" })); } } }
/// <summary> /// 根据手机号重设新密码 /// </summary> /// <param name="mobile"></param> /// <param name="smscode"></param> /// <param name="newpassword"></param> /// <returns></returns> public string findpassword(string mobile, string smscode, string newpassword) { using (var db = new shhouseEntities()) { try { var user_details = db.user_details.Where(x => x.mobile == mobile).FirstOrDefault(); var uservalidityrecord = db.user_validityrecord.SqlQuery(" select top 1 * from user_validityrecord where userid = " + user_details.userid + " and codetype = 1 and checkcode = '" + smscode + "' and state = 0 and validity > getdate() order by validity desc ").FirstOrDefault(); if (uservalidityrecord == null) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "验证码错误!" })); } uservalidityrecord.state = "1"; var user_member = db.user_member.Find(user_details.userid); user_member.password = Utils.MD5(newpassword); db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功!" })); } catch (Exception e) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败,请稍后再试!" })); } } }
/// <summary> /// 修改密码 /// </summary> /// <param name="oldpassword">旧密码</param> /// <param name="newpassword">新密码</param> /// <param name=""></param> /// <returns></returns> public string ChangePassword(string oldpassword, string newpassword) { oldpassword = Utils.MD5(oldpassword); using (var db = new shhouseEntities()) { try { var user_member = db.user_member.Where(p => p.userid == User.userid && p.password == oldpassword).FirstOrDefault(); if (user_member == null) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "旧密码错误", data = "" })); } else { var user_member1 = db.user_member.Find(User.userid); user_member.password = Utils.MD5(newpassword); db.SaveChanges(); } //string path = System.Web.HttpContext.Current.Server.MapPath($"~/tokens/" + Utils.MD5(User.userid.ToString()) + ".json"); //Utils.DeleteFile(path); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功" })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败,请稍后再试!" })); } } }
/// <summary> /// 拨打电话消费1e币 /// </summary> /// <param name="类型">type=0关注 1 取消关注</param> /// <returns></returns> public string call(int eb = 1) { using (var db = new shhouseEntities()) { try { var user_details = db.user_details.Find(User.userid); var user_member = db.user_member.Find(User.userid); if (eb > user_member.ebtotalnum) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "e币余额不足!" })); } user_member.ebtotalnum = user_member.ebtotalnum - eb; db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "消费成功!", data = new { ebtotal = user_member.ebtotalnum } })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "兑换失败!" })); } } }
/// <summary> /// 元宝兑换e币 /// </summary> /// <param name="元宝数">ybnum</param> /// <returns></returns> public string APPybToeb(int ybnum) { using (var db = new shhouseEntities()) { try { var user_details = db.user_details.Find(User.userid); var user_member = db.user_member.Find(User.userid); if (ybnum > user_details.silvertotal) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "兑换元宝大于已拥有的数量!" })); } user_details.silvertotal = user_details.silvertotal - ybnum; user_member.ebtotalnum = user_member.ebtotalnum + (ybnum / 100); db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "兑换成功!", data = new { ybtotal = user_details.silvertotal, ebtotal = user_member.ebtotalnum } })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "兑换失败!" })); } } }
/// <summary> /// 更新经纪人接口 /// </summary> /// <param name="userid">经纪人ID </param> /// <param name="username">用户名</param> /// <param name="password">密码</param> /// <param name="mobile">手机</param> /// <param name="realname">真实姓名</param> /// <param name="erpgh">erp工号</param> /// <returns></returns> public string Editjjr(int?userid = null, string username = null, string password = null, string mobile = null, string realname = null, string erpgh = null) { using (var db = new shhouseEntities()) { try { var user_member = db.user_member.Find(userid); user_member.username = username; user_member.password = Utils.MD5(password); user_member.erpgh = erpgh; var user_details = db.user_details.Find(userid); user_details.realname = realname; user_details.mobile = mobile; db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功" })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败,请稍后再试" })); } } }
public string FocusOn(int userid, int agentid) { try { using (shhouseEntities ent = new shhouseEntities()) { var Single = ent.AgentCollection.Where(p => p.UserID == userid && p.AgentID == agentid).FirstOrDefault(); if (Single == null) { var AgentCollection = new AgentCollection { UserID = userid, AgentID = agentid, AddTime = DateTime.Now }; ent.AgentCollection.Add(AgentCollection); ent.SaveChanges(); } } return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "关注成功!" })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "暂无数据,请稍后再试!" })); } }
/// <summary> /// 修改状态 /// </summary> /// <param name="ID"></param> /// <param name="IsLink"></param> /// <param name="IsFollow"></param> /// <param name="IsDel"></param> /// <returns></returns> public string EditState(int ID, int?IsLink = null, int?IsFollow = null, int?IsDel = null) { try { using (var db = new shhouseEntities()) { house_agentize_wuxi agentize = db.house_agentize_wuxi.Find(ID); if (IsDel != null) { agentize.IsDel = IsDel; } if (IsLink != null) { agentize.IsLink = IsLink; } if (IsFollow != null) { agentize.IsFollow = IsFollow; } db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功!" })); } } catch (Exception e) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "网络异常,请稍后再试!", data = e })); } }
/// <summary> /// 添加取消委托记录 /// </summary> /// <param name="FollowID">跟进原因ID </param> /// <param name="Followtext">跟进原因文本</param> /// <param name="Cusid">需求ID</param> /// <returns></returns> public string AddFollow(int FollowID, string Followtext, int Cusid) { try { timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; using (var db = new shhouseEntities()) { var follow = new house_agentfollow_wuxi { Cusid = Cusid, AgentID = User.userid, FollowText = Followtext, exe_date = DateTime.Now }; db.house_agentfollow_wuxi.Add(follow); db.SaveChanges(); } return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "取消委托成功!" })); } catch (Exception e) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "网络异常,请稍后再试!", data = e })); } }
/// <summary> /// 关注小区 /// </summary> /// <returns></returns> public string VillageCollection(int VillageID, int type) { using (var db = new shhouseEntities()) { try { var VillageCollections = db.VillageCollection.Where(x => x.UserID == User.userid && x.VillageID == VillageID).FirstOrDefault(); if (type == 0) { if (VillageCollections != null) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "此小区已经关注过了!" })); } var VillageCollection = new VillageCollection { UserID = User.userid, VillageID = VillageID, Addtime = DateTime.Now }; db.VillageCollection.Add(VillageCollection); db.SaveChanges(); } else { db.VillageCollection.Remove(VillageCollections); db.SaveChanges(); } return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "成功!", })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "关注失败!" })); } } }
public string MessageAdd(string title, string content, int isshow = 1) { timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; int userid = User.userid; DateTime time = DateTime.Now; using (shhouseEntities db = new shhouseEntities()) { try { user_noteinfo myuser_noteinfo = new user_noteinfo(); myuser_noteinfo.userid = userid; myuser_noteinfo.infotype = 1; myuser_noteinfo.title = title; myuser_noteinfo.content = content; myuser_noteinfo.addtime = time; myuser_noteinfo.isshow = isshow; myuser_noteinfo.city = 3; db.user_noteinfo.Add(myuser_noteinfo); db.SaveChanges(); int eid = myuser_noteinfo.eid; if (eid > 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 = "发布失败,请稍后再试" })); } } }
/// <summary> /// 删除求购求租 http://192.168.1.223/GR_house_require/Delete /// </summary> /// <param name="eid"></param> /// <returns></returns> public string Delete(int eid) { timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; using (shhouseEntities ent = new shhouseEntities()) { try { var house_require_wuxi = ent.house_require_wuxi.FirstOrDefault(p => p.eid == eid); if (User.userid != house_require_wuxi.userid) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "非本人信息不能修改", data = null })); } house_require_wuxi.isdel = 1; int isok = ent.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 = "网路异常" })); } } }
/// <summary> /// 取消关联 /// </summary> /// <param name="HouseIDs">房源ID字符串,以逗号隔开</param> /// <returns></returns> public string Cancelbinding(string HouseIDs = null) { using (var db = new shhouseEntities()) { try { if (HouseIDs != null) { if (HouseIDs != null && HouseIDs.Length > 0) { string[] HouseID = HouseIDs.Split(','); for (int i = 0; i < HouseID.Length; i++) { int iHouseID = int.Parse(HouseID[i]); var BringCustomer = db.BringCustomer.Where(m => m.HouseID == iHouseID && m.Userid == User.userid && m.IsSelf == 1).FirstOrDefault(); var usermember = db.user_member.Where(m => m.userid == User.userid).FirstOrDefault(); if (BringCustomer != null) { db.BringCustomer.Remove(BringCustomer); usermember.houseusenum = usermember.houseusenum - 1; } } } db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "取消关联成功!" })); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "参数么的传!" })); } } catch (Exception E) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "网络异常,请稍后在试!" })); } } }
/// <summary> /// 删除经纪人 /// </summary> /// <param name="userid">经纪人ID </param> /// <returns></returns> public string Deletejjr(int?userid = null) { using (var db = new shhouseEntities()) { try { var user_member = db.user_member.Find(userid); user_member.state = -2; db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "删除成功" })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "删除失败,请稍后再试" })); } } }
public string EditTempl(int templateid, int ttype, string tname, string tcontent) { int userid = User.userid; using (shhouseEntities ent = new shhouseEntities()) { try { house_template tm = ent.house_template.FirstOrDefault(p => p.templateid == templateid && p.userid == userid); if (tm == null) { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "没有找到模板" })); } else { tm.ttype = ttype; tm.tname = tname; tm.tcontent = tcontent; ent.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "提交成功" })); } } catch { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "提交失败,请稍后再试" })); } } }
/// <summary> /// 签到 /// </summary> /// <returns></returns> public string SignIn() { using (var db = new shhouseEntities()) { DateTime sdt = DateTime.Now.Date; DateTime dt = DateTime.Now.Date.AddDays(1); var SignIn = db.SignIn.Where(x => x.UserID == User.userid && x.exe_date >= sdt && x.exe_date < dt).FirstOrDefault(); if (SignIn != null) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "今日已签过!" })); } else { var stephen = new SignIn { UserID = User.userid, exe_date = DateTime.Now }; var user_score_wuxi = new user_score_wuxi { userid = User.userid, addtime = DateTime.Now, score = 5, obtaindirections = "签到积分" }; var userdetails = db.user_details.Where(p => p.userid == User.userid).FirstOrDefault(); userdetails.scoretotal = userdetails.scoretotal + 5; db.user_score_wuxi.Add(user_score_wuxi); db.SignIn.Add(stephen); db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "签到成功!" })); } } }
/// <summary> /// 个人服务 /// </summary> /// <param name="yjrate">佣金比例</param> /// <param name="servicetype">服务类型</param> /// <param name=""></param> /// <returns></returns> public string PersonalService(decimal yjrate, string servicetype) { using (var db = new shhouseEntities()) { try { var user_member = db.user_member.Find(User.userid); user_member.yjrate = yjrate; user_member.servicetype = servicetype; db.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功", data = "" })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败,请稍后再试", data = "" })); } } }
public string DeleteTempl(int templateid) { int userid = User.userid; using (shhouseEntities ent = new shhouseEntities()) { try { house_template tm = ent.house_template.FirstOrDefault(p => p.templateid == templateid && p.userid == userid); if (tm == null) { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "没有找到模板" })); } else { ent.house_template.Remove(tm); ent.SaveChanges(); return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "提交成功" })); } } catch { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "提交失败,请稍后再试" })); } } }
/// <summary> /// 发送手机短信所用方法 /// </summary> /// <param name="mobile"></param> /// <returns></returns> private void insert_validityrecord(string sID, int iHours, string sBody, string sCode, int iType) { try { using (var db = new shhouseEntities()) { var user_validityrecord = new user_validityrecord() { userid = int.Parse(sID), validity = DateTime.Now.AddHours(24), checkcode = sCode, codetype = iType, state = "0", body = "" }; db.user_validityrecord.Add(user_validityrecord); db.SaveChanges(); } } catch { } }
public string CancelAttention(int userid, int agentid) { try { using (shhouseEntities ent = new shhouseEntities()) { var Single = ent.AgentCollection.Where(p => p.UserID == userid && p.AgentID == agentid).FirstOrDefault(); if (Single != null) { ent.AgentCollection.Remove(Single); ent.SaveChanges(); } } return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "关注成功!" })); } catch { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "暂无数据,请稍后再试!" })); } }
/// <summary> /// 店铺设置 /// </summary> /// <param name="remarkxuanyan">宣言</param> /// <param name="remark">详情</param> /// <param name="knowarea">最熟悉的区域</param> /// <param name="knowvillage">最熟悉的小区</param> /// <returns></returns> public string shopset(string remarkxuanyan, string remark, string knowarea, string knowvillage) { try { using (var db = new shhouseEntities()) { var userdetails = db.user_details.Where(p => p.userid == User.userid).FirstOrDefault(); userdetails.remark_xuanyan = remarkxuanyan; userdetails.remark = remark; userdetails.know_area = knowarea; userdetails.know_village = knowvillage; db.SaveChanges(); } } catch { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "操作失败,请稍侯再试!" })); } return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功!" })); }
/// <summary> /// 注册账号 http://192.168.1.223/GR_Home/RegistByMobile /// </summary> /// <param name="username">用户名</param> /// <param name="password">密码</param> /// <param name="mobile">手机号码</param> /// <param name="realname">真实姓名</param> /// <param name="smscode">验证码</param> /// <returns></returns> public string RegistByMobile(string password, string mobile, string smscode) { if (string.IsNullOrEmpty(password)) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "用户名或密码为空,提交失败!", data = null })); } if (!Utils.IsSafeSqlString(mobile)) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "您输入的手机号码包含不安全的字符,因此无法提交!", data = null })); } if (User_Common.IsHaveMobile(mobile.Trim()) > 0) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "您所输入的手机号码已被使用过, 请输入其他的手机号码!", data = null })); } using (var db = new shhouseEntities()) { var uservalidityrecord = db.user_validityrecord.SqlQuery(" select top 1 * from user_validityrecord where Mobile = " + mobile + " and codetype = 1 and checkcode = '" + smscode + "'" + " and state = 0 and validity > getdate() order by validity desc ").FirstOrDefault(); if (uservalidityrecord == null) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "验证码错误或已经失效请重新获取!", data = null })); } uservalidityrecord.state = "1"; db.SaveChanges(); var intuser = db.Database.ExecuteSqlCommand(User_Common.GR_adduserbymobile_sql, new SqlParameter[] { new SqlParameter("@parentid", "0"), new SqlParameter("@parentpath", ""), new SqlParameter("@mobile", mobile.Trim()), new SqlParameter("@telfirst", ""), new SqlParameter("@tel", ""), new SqlParameter("@linkman", ""), new SqlParameter("@area", ""), new SqlParameter("@city", 3), new SqlParameter("@storetotal", "0"), new SqlParameter("@housetotal", "5"), new SqlParameter("@agenttotal", "0"), new SqlParameter("@refamount", "7"), new SqlParameter("@userid2", "0"), //new SqlParameter("@username", Utils.CheckData(username.Trim())), //new SqlParameter("@realname", Utils.CheckData(realname.Trim())), new SqlParameter("@password", Utils.MD5(password.Trim())), new SqlParameter("@addip", Utils.GetRealIP()), new SqlParameter("@roleid", 5), //为五的时候为个人会员 new SqlParameter("@origin", ""), new SqlParameter("@originpath", ""), new SqlParameter("@ismobilelock", "0"), new SqlParameter("@validity_begintime", "1990-1-1"), new SqlParameter("@validity_endtime", "1990-1-1"), new SqlParameter("@deptname", ""), new SqlParameter("@company", ""), new SqlParameter("@address", "") }); if (intuser.ToString() == "-99") { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "手机号码重复,请重新输入!", data = null })); } else if (CharString.IntConvert(intuser) > 0) { return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "注册成功!", data = null })); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "注册失败,网络异常!", data = null })); } } return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "网络异常", data = null })); }
public string OrderViewAdd2(int houseid, int housetype, string content) { try { string sTitle = housetype == 1 ? "预约看房--出售" : "预约看房--出租"; string sUid = ""; string sUname = ""; string sMobile = ""; string sHouseType = housetype.ToString(); content = "用户:" + User.user_details.realname + " 手机:" + User.user_details.mobile + " 房源编号:S" + houseid + "<br /><br />留言内容:" + content; using (var db = new shhouseEntities()) { if (housetype == 1) { //通过房源找用户信息 var persons = (from a in db.house_sale_search_wuxi join b in db.user_details on a.userid equals b.userid into dc from dci in dc.DefaultIfEmpty() where a.saleid == houseid select new { dci.userid, dci.mobile, dci.realname }).FirstOrDefault(); if (persons != null) { sUid = persons.userid.ToString(); sUname = persons.realname; sMobile = persons.mobile.ToString(); } } if (housetype == 2) { var persons = (from a in db.house_rent_search_wuxi join b in db.user_details on a.userid equals b.userid into dc from dci in dc.DefaultIfEmpty() where a.rentid == houseid select new { dci.userid, dci.mobile, dci.realname }).FirstOrDefault(); if (persons != null) { sUid = persons.userid.ToString(); sUname = persons.realname; sMobile = persons.mobile.ToString(); } } if (string.IsNullOrEmpty(sUid)) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "房源不存在。", data = null })); } user_send myuser_send = new user_send(); myuser_send.msgtitle = sTitle; myuser_send.msgcontent = content; myuser_send.userid = User.userid; myuser_send.username = User.user_details.realname; myuser_send.msgreciveusername = sUname; myuser_send.origin = 1; myuser_send.city = 3; myuser_send.isdel = 0; myuser_send.issystem = 0; myuser_send.addtime = DateTime.Now; db.user_send.Add(myuser_send); db.SaveChanges(); int msgid = myuser_send.msgid; //return JsonConvert.SerializeObject(new repmsg { state = 2, msg = "2房源"+ msgid + "|"+ myuser_send.msgid + "不存在。", data = null }); user_recive myuser_recive = new user_recive(); myuser_recive.msgreciveuser = int.Parse(sUid); myuser_recive.msgid = msgid; myuser_recive.isread = 0; myuser_recive.isdel = 0; db.user_recive.Add(myuser_recive); int insertuser_recive = db.SaveChanges(); if (insertuser_recive > 0) { string sContent = "您于 " + DateTime.Now.ToString("yyyy-MM-dd HH:mm ") + " 收到一条预约看房留言,请注意查收。【e房网】"; string sReturn = SMS.SendSMS_New(sMobile, sContent); house_agent_sms myhouse_agent_sms = new house_agent_sms(); myhouse_agent_sms.userid = int.Parse(sUid); myhouse_agent_sms.houseid = houseid; myhouse_agent_sms.housetype = Convert.ToInt16(sHouseType); myhouse_agent_sms.addtime = DateTime.Now; myhouse_agent_sms.remark = sContent; myhouse_agent_sms.status = sReturn; myhouse_agent_sms.OrderUserid = User.userid; db.house_agent_sms.Add(myhouse_agent_sms); int inserthouse_agent_sms = db.SaveChanges(); if (inserthouse_agent_sms > 0) { return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "预约成功", data = null })); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "网络异常", data = null })); } } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "网络异常", data = null })); } } } catch { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "网络异常", data = null })); } }
/// <summary> /// 登录 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public string login(string username, string password) { string sValue = ""; if (DateTime.Now.Hour != 1) { if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password)) { string sRoleid = "", sCity = "", sName = "", sState = "", sSerieslogin = "", sDeptpath = "", passwords = "", sBegintime = "", sEndtime = "", sLastlogintime = "", sSeriestime = "", sUserid = "", sPermition = "", sMobile = "", roleid = ""; passwords = Utils.MD5(password); using (var db = new shhouseEntities()) { var persons = (from a in db.user_member join b in db.user_details on a.userid equals b.userid into dc from dci in dc.DefaultIfEmpty() join c in db.user_validity on a.userid equals c.userid into ec from eci in ec.DefaultIfEmpty() where (a.username == username || dci.mobile == username) && a.password == passwords && (a.roleid == 3 || a.roleid == 4) select new { a.userid, a.username, a.roleid, a.city, a.deptpath, a.state, a.serieslogin, eci.begintime, eci.endtime, a.lastlogintime, a.seriestime, a.mobile, }).FirstOrDefault(); if (persons != null) { sUserid = persons.userid.ToString(); sName = persons.username; sRoleid = persons.roleid.ToString(); sCity = persons.city.ToString(); sDeptpath = persons.deptpath; sState = persons.state.ToString(); sBegintime = persons.begintime.ToString(); //开始时间 sEndtime = persons.endtime.ToString(); //截止时间 sLastlogintime = persons.lastlogintime.ToString(); sSeriestime = persons.seriestime.ToString(); sMobile = persons.mobile.ToString(); roleid = persons.roleid.ToString(); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "用户名或密码输入错误。", data = null })); } } if (sState == "-1")//锁定 { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "抱歉,您的账户已被冻结,请联系您的主管或管理员。", data = null })); } else if (sState == "-2") { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "抱歉,您的账户已被删除,请联系您的主管或管理员", data = null })); } if (!string.IsNullOrEmpty(sEndtime) && sBegintime != sEndtime) { if (sRoleid == "4" && !string.IsNullOrEmpty(sDeptpath)) { sDeptpath = "," + sDeptpath; sDeptpath = sDeptpath.Replace(",0,", ""); using (var db = new shhouseEntities()) { var user_validity = db.user_validity.SqlQuery("select * from user_validity where userid = (select top 1 userid from user_member where deptid in(" + sDeptpath + "))").FirstOrDefault(); if (user_validity != null) { sEndtime = user_validity.endtime.ToString(); } } } if (Convert.ToDateTime(CharString.DateConvert(sEndtime)) < Convert.ToDateTime(DateTime.Now.ToShortDateString())) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "您的账户服务期已截止,请去续费充值!", data = null })); } } DateTime sdt = DateTime.Now.Date; DateTime dt = DateTime.Now.Date.AddDays(1); //更新用户表 using (var db = new shhouseEntities()) { var user_member = db.user_member.Find(int.Parse(sUserid)); user_member.lastlogintime = user_member.logintime; user_member.lastloginip = user_member.loginip; user_member.logincount = user_member.logincount + 1; user_member.logintime = DateTime.Now; user_member.loginip = Utils.GetRealIP(); var user_details = db.user_details.Find(int.Parse(sUserid)); user_details.logintimenum = Utils.GetUnixNum(DateTime.Now); user_details.logintime = DateTime.Now; db.SaveChanges(); db.Database.ExecuteSqlCommand("UPDATE user_search_all_wuxi set LastLoginTime = (datediff(S,'1970-01-01 00:00:00', getdate()) - 8 * 3600) where userid =@sUserid", new SqlParameter[] { new SqlParameter("@sUserid", sUserid) }); } ////写入token //string token = Utils.MD5(sUserid); //string tokenjson=JsonConvert.SerializeObject(new { userid = sUserid, Lastlogintime = sLastlogintime}); //System.IO.File.WriteAllText(Server.MapPath($"~/tokens/{token}.json"), tokenjson); //return JsonConvert.SerializeObject(new repmsg { state = 1, msg = "登录成功", data = token }); string token = Utils.MD5(sUserid); using (var db = new shhouseEntities()) { //写入token db.Database.ExecuteSqlCommand("delete from user_logintoken where userid = @sUserid", new SqlParameter[] { new SqlParameter("@sUserid", sUserid) }); user_logintoken myuser_Logintoken = new user_logintoken(); myuser_Logintoken.UserID = int.Parse(sUserid); myuser_Logintoken.token = token; myuser_Logintoken.loninTime = DateTime.Now; db.user_logintoken.Add(myuser_Logintoken); db.SaveChanges(); } return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "登录成功", data = token })); //return JsonConvert.SerializeObject(new repmsg { state = 1, msg = "登录成功", // data = new // { // token = token, // roleid = roleid // } // }); } return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "用户名或密码不能为空", data = null })); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "凌晨 1:00 - 2:00 数据维护中...", data = null })); } }
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 = "发布失败,请稍后再试" })); } } }
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 = "修改失败,请稍后再试" })); } } }
///// <summary> ///// 修改基本资料 账号 手机号码 正式姓名 姓名 生日 证件类型 身份证号 ///// </summary> ///// <param name="username">账号</param> ///// <param name="mobile">手机号码</param> ///// <param name="realname">真实姓名</param> ///// <param name="sexuality">性别</param> ///// <param name="birth">生日</param> ///// <param name="cardtype">证件类型</param> ///// <param name="idnumber">身份证号</param> ///// <returns></returns> //public string UserModify(string username, string mobile, string realname, string sexuality, string birth , string cardtype , string idnumber ) //{ // string sql = string.Empty; // sql += " update user_details set username=@username where userid=@userid "; // sql += " update user_details set mobile=@mobile where userid=@userid "; // sql += " update user_details set realname=@realname where userid=@userid "; // sql += " update user_details set sexuality=@sexuality where userid=@userid "; // sql += " update user_details set birth=@birth where userid=@userid "; // sql += " update user_details set cardtype=@cardtype where userid=@userid "; // sql += " update user_details set idnumber=@idnumber where userid=@userid "; // using (shhouseEntities db = new shhouseEntities()) // { // try // { // var edituser = db.Database.ExecuteSqlCommand(sql, // new SqlParameter[]{ // new SqlParameter("@userid", User.userid), // new SqlParameter("@username", username), // new SqlParameter("@mobile", mobile), // new SqlParameter("@realname", realname), // new SqlParameter("@sexuality", sexuality), // new SqlParameter("@birth", birth), // new SqlParameter("@cardtype", cardtype), // new SqlParameter("@idnumber", idnumber) // }); // return JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功" }); // } // catch (Exception e) // { // return JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败,请稍后再试!" }); // } // } //} /// <summary> /// 修改基本资料 http://192.168.1.223/GR_User/UserModify /// </summary> /// <param name="realname">真实姓名</param> /// <param name="sexuality">性别</param> /// <param name="birth">生日</param> /// <param name="cardtype">证件类型</param> /// <param name="idnumber">身份证号</param> /// <returns></returns> public string UserModify(string realname = null, int?sexuality = null, string photoname = null, string birthday = null, string cardtype = null, string idnumber = null, string NickName = null) { using (shhouseEntities db = new shhouseEntities()) { user_details myuser_details = db.user_details.Find(User.userid); user_member myuser_member = db.user_member.Find(User.userid); bool isModify = false; if (realname != null && myuser_details.realname != realname) { myuser_details.realname = realname; isModify = true; } if (sexuality != null && myuser_details.sexuality != sexuality) { myuser_details.sexuality = sexuality; isModify = true; } if (photoname != null && myuser_details.photoname != photoname) { myuser_details.photoname = photoname; isModify = true; } if (birthday != null && myuser_details.birthday != Convert.ToDateTime(birthday)) { myuser_details.birthday = Convert.ToDateTime(birthday); isModify = true; } if (cardtype != null && myuser_details.CardType != cardtype) { myuser_details.CardType = cardtype; isModify = true; } if (idnumber != null && myuser_details.idnumber != idnumber) { myuser_details.idnumber = idnumber; isModify = true; } if (NickName != null && myuser_member.NickName != NickName) { myuser_member.NickName = NickName; isModify = true; } if (isModify == false) { return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "提交成功,您信息未做任何调整", data = null }, timeFormat)); } int isok = db.SaveChanges(); if (isok > 0) { return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功", data = null }, timeFormat)); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败", data = null })); } } }
/// <summary> /// 发送验证短信验证码 http://192.168.1.223/GR_Home/SendSmsCode /// </summary> /// <param name="mobile"></param> /// <returns></returns> public string SendSmsCode(string mobile) { bool flg = false; string sID = "", sEmail = "", sMobile = ""; if (!string.IsNullOrEmpty(mobile)) { //查询用户信息 using (var db = new shhouseEntities()) { var persons = db.user_details.Where(x => x.mobile == mobile).FirstOrDefault(); //var persons = (from u in db.user_details join b in db.user_member on u.userid equals b.userid where b.mobile == mobile select u).FirstOrDefault(); if (persons != null) { sID = persons.userid.ToString(); sEmail = persons.email; sMobile = persons.mobile; flg = true; } else { sID = "0"; sEmail = null; sMobile = mobile; flg = true; } } if (flg) { Random random = new Random(); string sCode = random.Next(111111, 1000000).ToString(); if (SMS.SendSMS_New(sMobile, "验证码:" + sCode + " 【e房网】") != "100") { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "短信发送失败,请稍侯再试", data = null })); } else { //添加到数据库 using (var db = new shhouseEntities()) { var user_validityrecord = new user_validityrecord() { userid = int.Parse(sID), //用户id validity = DateTime.Now.AddHours(24), //有效期 checkcode = sCode, //验证码 codetype = 1, //类型 发短信为1 发邮件为2 这里默认为1 state = "0", //是否有效 状态 body = "", //描述 Mobile = mobile //新增用户手机号码 }; db.user_validityrecord.Add(user_validityrecord); db.SaveChanges(); } } } return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "发送成功", data = null })); } return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "发送失败", data = null })); }
public string Editminprice(int houseid, double minprice) { int userid = User.userid; using (shhouseEntities ent = new shhouseEntities()) { try { house_sale_search_wuxi myhouse_sale_search_wuxi = ent.house_sale_search_wuxi.Find(houseid); if (userid != myhouse_sale_search_wuxi.userid) { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "非本人信息不能修改", data = null })); } myhouse_sale_search_wuxi.minprice = minprice; //计算均价 double minarea = Convert.ToDouble(myhouse_sale_search_wuxi.minarea.ToString()); double avgprice = 0; if (minarea != 0) { avgprice = Math.Round(minprice / minarea, 2) * 10000; } myhouse_sale_search_wuxi.avgprice = avgprice; int searchprice = 0; int intminprice = Convert.ToInt32(minprice); string sql_c = "select typeid from base_samtype where parentid = 13 and Convert(int, space1)<= '" + intminprice + "' and Convert(int, space2)>'" + intminprice + "'"; searchprice = ent.Database.SqlQuery <int>(sql_c).DefaultIfEmpty().First(); myhouse_sale_search_wuxi.searchprice = Convert.ToInt16(searchprice.ToString()); int isok = ent.SaveChanges(); if (isok > 0) { return(JsonConvert.SerializeObject(new repmsg { state = 1, msg = "修改成功", data = houseid }, timeFormat)); } else { return(JsonConvert.SerializeObject(new repmsg { state = 2, msg = "修改失败", data = null })); } } catch (Exception e) { return(JsonConvert.SerializeObject(new repmsg { state = 0, msg = "提交失败,请稍后再试" })); } } }