/// <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 = "提交失败，请稍后再试"
}));
}
}
}
