public int BookOk(int bid)
{
try
{
HQ_BookRoom book = new HQ_BookRoom();
book["id"] = bid;
book.OStatus = 1;
book.LastOperateTime = DateTime.Now;
book.Save();
}
catch
{
return 0;
}
try
{
SearchModel sm = new SearchModel("uv_bookroom");
sm["id"] = bid;
sm.AddSearch("RoomName_G", "PhoneNum_G");
var broom = sm.LoadEntity<HQ_BookRoom>();
if (broom != null)
{
NM.Util.SendUserInfo _U = new NM.Util.SendUserInfo() { isLog = 1, orgid = 555, username = broom.PhoneNum_G };
NM.Util.MsgSend.DirectSend(string.Format("尊敬的会员您好，您已成功预订 {0} 。", broom.RoomName_G), broom.PhoneNum_G, _U);
}
}
catch { }
return 1;
}
public ActionResult Index(int id)
{
SearchModel sm = new SearchModel("HQ_DisplayContent");
sm["ID"] = id;
var entity = sm.LoadEntity<HQ_DisplayContent>();
return View(entity);
}
public static int IsMoneyEnouth(int roomid, long userid, DateTime sdate, DateTime edate, out decimal balance, out int shopUserId, out string phoneNum, out decimal cost,out decimal price)
{
balance = 0;
shopUserId = 0;
phoneNum = string.Empty;
cost = 0;
price = 0;
var days = edate.Subtract(sdate).Days;
if (days <= 0)
{
return 0;
}
var userType = 1;
var sm = new SearchModel("uv_MemberWithAmount");
sm["id"] = userid;
sm.AddSearch("PhoneNum", "ShopUserID_G", "Balance_G");
var member = sm.LoadEntity<HQ_Member>();
if (member != null)
{
balance = member.Balance_G;
shopUserId = member.ShopUserID_G;
phoneNum = member.PhoneNum;
userType = member.UserType;
}
else
{
return 0;
}
sm = new SearchModel("hq_room");
sm["id"] = roomid;
sm.AddSearch("price", "vipprice");
var room = sm.LoadEntity<HQ_Room>();
if (room != null)
{
price = userType == 2 ? room.VipPrice : room.Price;
}
if (price == 0)
{
return 0;
}
cost = price * days;
balance = balance - cost;
if (balance < 0)
{
return -1;
}
return 1;
}
public ActionResult RoomIndex(int id)
{
SearchModel sm = new SearchModel("HQ_DisplayContent");
sm["ID"] = id;
var entity = sm.LoadEntity<HQ_DisplayContent>();
ViewBag.VillageID = id;
sm = new SearchModel("hq_article");
sm["refid"] = id;
ViewBag.Descs = sm.Load<HQ_Article>().Data;
return View(entity);
}
public ActionResult Index()
{
SearchModel sm = new SearchModel("HQ_Article");
sm["ACategory"] = (int)EnumArticleCategory.SilderImg;
var entity = sm.LoadEntity<HQ_Article>();
if (entity != null)
{
ViewBag.SilderImgs = entity.AContent;
}
else
{
ViewBag.SilderImgs = string.Empty;
}
sm = new SearchModel("HQ_DisplayPanel");
sm["DPanelType"] = (int)EnumDPanelType.Distination;
sm.PageIndex = 1;
sm.PageSize = 12;
sm.OrderBy("id");
ViewBag.DistList = sm.Load<HQ_DisplayPanel>().Data;
return View();
}
public JsonResult GetAdvPBottom()
{
SearchModel sm = new SearchModel("HQ_Advertisement");
sm["ID"] = 1;
HQ_Advertisement adv = sm.LoadEntity<HQ_Advertisement>();
return this.JsonNet(adv);
}
public void LoadRoomDetail(int roomid)
{
SearchModel sm = new SearchModel("hq_room");
sm["id"] = roomid;
var result = sm.LoadEntity<HQ_Room>();
if (result != null)
{
OutResult(new { Name = result.Name, Description = reg.Replace(result.Description, (match) => { return "<img class='uimg' _src='" + match.Groups[1].Value + "' />"; }) });
}
}
public ActionResult ArticleIndex(int atype)
{
SearchModel sm = new SearchModel("HQ_Article");
sm["ACategory"] = atype;
var entity = sm.LoadEntity<HQ_Article>();
if (entity == null)
{
return View(new HQ_Article() { AContent = "维护中。。。" });
}
return View(entity);
}
public ActionResult ViewGuidInfo(int id)
{
SearchModel sm = new SearchModel("HQ_Article");
sm["ID"] = id;
var article = sm.LoadEntity<HQ_Article>();
return View(article);
}
public static int IsMoneyEnouth(int orderid,out decimal balance, out int shopUserId, out string phoneNum, out decimal cost)
{
balance = 0;
shopUserId = 0;
phoneNum = string.Empty;
cost = 0;
var price = 0;
var userid = 0;
var sm = new SearchModel("hq_bookroom");
sm["ID"] = orderid;
var order = sm.LoadEntity<HQ_BookRoom>();
if (order == null)
{
return 0;
}
price = order.Price;
userid = order.MemberID;
var sdate = order.BookStartTime;
var edate = order.BookEndTime;
var days = edate.Subtract(sdate).Days;
if (days <= 0)
{
return 0;
}
sm = new SearchModel("uv_MemberWithAmount");
sm["id"] = userid;
sm.AddSearch("PhoneNum", "ShopUserID_G", "Balance_G");
var member = sm.LoadEntity<HQ_Member>();
if (member != null)
{
balance = member.Balance_G;
shopUserId = member.ShopUserID_G;
phoneNum = member.PhoneNum;
}
else
{
return 0;
}
cost = price * days;
balance = balance - cost;
if (balance < 0)
{
return -1;
}
return 1;
}
public JsonResult GetSilderImg()
{
SearchModel sm = new SearchModel("HQ_Article");
sm["ACategory"] = (int)EnumArticleCategory.SilderImg;
var entity = sm.LoadEntity<HQ_Article>();
if (entity != null)
{
return this.JsonNet(entity);
}
return null;
}
public static int IsRoomEnough(int roomid, DateTime sdate, DateTime edate)
{
if (sdate >= edate)
{
return 0;
}
SearchModel smroom = new SearchModel("hq_room");
smroom["ID"] = roomid;
smroom.AddSearch("RCount");
var rcount = smroom.LoadEntity<HQ_Room>().RCount;
SearchEntity sm = SearchEntity.FormSql("select count(1) id from hq_bookroom where roomid=@roomid and isnull(isdelete,0)=0 and bookendtime>=@stime and bookstarttime<=@etime",
new SqlParameter("roomid", roomid), new SqlParameter("stime", sdate), new SqlParameter("etime", edate.Subtract(new TimeSpan(1, 0, 0, 0))));
var bcount = sm.LoadValue<Int32>();
if (bcount >= rcount)
{
return 0;
}
return 1;
}
public void LoadSilderImgs()
{
SearchModel sm = new SearchModel("HQ_Article");
sm["ACategory"] = (int)EnumArticleCategory.SilderImg;
var entity = sm.LoadEntity<HQ_Article>();
string plstr = string.Empty;
if (entity != null)
{
plstr = entity.AContent;
}
OutResult(plstr);
}
public JsonResult SaveMember(HQ_Member entity)
{
#region 用户名、手机号码是否重复
SearchModel sm = SearchEntity.FormSql<SearchModel>("select count(id) from hq_member where username=@uname and isnull(isdelete,0)=0 and id<>@id",
new SqlParameter("uname", entity.UserName), new SqlParameter("id", entity.ID));
int count = sm.LoadValue<int>();
if (count > 0)
{
return ExController.JsonNet(new { ID = -1 });
}
sm = SearchEntity.FormSql<SearchModel>("select count(id) from hq_member where phonenum=@pnum and isnull(isdelete,0)=0 and id<>@id",
new SqlParameter("pnum", entity.PhoneNum), new SqlParameter("id", entity.ID));
count = sm.LoadValue<int>();
if (count > 0)
{
return ExController.JsonNet(new { ID = -2 });
}
#endregion
try
{
using (var scope = new TransactionScope())
{
if (entity.ID == 0)
{
var password = "******";
#region 维护新增数据
entity.UserPsw = MD5.EncryptString(password);
entity.ShopPsw = entity.UserPsw;
entity.CreateBy = LoginInfo.Current.UserName;
entity.CreateOn = DateTime.Now;
if (entity.UserType == 2)
{
entity.OpenVipDate = DateTime.Now.Date;
}
#endregion
entity.Save();
HttpClient _httpClient = new HttpClient();
_httpClient.BaseAddress = new Uri("http://mall.chinalvju.com/");
var dic = new Dictionary<string, string>();
dic.Add("UserName", entity.PhoneNum);
dic.Add("NickName", entity.UserName);
dic.Add("Password", password);
dic.Add("ConfirmPassword", password);
_httpClient.PostAsync("Account/Register", new FormUrlEncodedContent(dic));
}
else
{
#region 维护修改数据
entity.EditBy = LoginInfo.Current.UserName;
entity.EditOn = DateTime.Now;
if (entity.UserType == 2)
{
entity.OpenVipDate = DateTime.Now.Date;
}
#endregion
sm = new SearchModel("uv_MemberWithAmount");
sm["id"] = entity.ID;
var oldMem = sm.LoadEntity<HQ_Member>();
if (oldMem.PhoneNum != entity.PhoneNum)
{
Shop_Member s_mem = new Shop_Member();
s_mem["UserID"] = oldMem.ShopUserID_G;
s_mem["UserName"] = entity.PhoneNum;
s_mem.Save();
}
entity.Save();
}
scope.Complete();
}
return ExController.JsonNet(entity);
}
catch
{
return ExController.JsonNet(new { ID = 0 });
}
}
public long ChangeUserPsw(string oldPsw, string newPsw)
{
SearchModel se = new SearchModel("hq_member");
se["ID"] = LoginInfo.Current.UserID;
var user = se.LoadEntity<HQ_Member>();
if (user.UserPsw.Equals(MD5.EncryptString(oldPsw)))
{
user = new HQ_Member();
user["ID"] = LoginInfo.Current.UserID;
user.UserPsw = MD5.EncryptString(newPsw);
return user.Save();
}
return 0;
}
public int IsMemberExist(string username)
{
if (username == null || username.Length == 0)
{
return -1;
}
SearchModel sm = new SearchModel("HQ_Member");
sm.MemberName = username;
var entity = sm.LoadEntity<HQ_Member>();
if (entity == null)
{
return 0;
}
return 1;
}
public void Login(string uname, string psw)
{
SearchModel sm = new SearchModel("HQ_Member");
sm.MemberName = uname;
var member = sm.LoadEntity<HQ_Member>();
if (member == null || member.UserPsw != MD5.EncryptString(psw))
{
OutResult(new { id = 0 });
return;
}
OutResult(new { id = member.ID, phone = member.PhoneNum, header = member.HeaderImg_G });
}
public long ChangeUserPhone(string phone, string yzm)
{
if (phone == null || phone.Length == 0 || !(Regex.Match(phone, @"^[1][3,5,8][0-9]{9}$", RegexOptions.Compiled).Success))
{
return -1;//手机号码错误
}
var omcode = base.HttpContext.Cache["msg-" + phone];
if (omcode == null || omcode.ToString().Length == 0)
{
return -2;//已发送的短信验证码不存在
}
if (yzm == null || yzm.Length == 0 || !yzm.Equals(omcode.ToString()))
{
return -2;//输入的短信验证码错误
}
SearchModel sm = new SearchModel("uv_MemberWithAmount");
sm["ID"] = LoginInfo.Current.UserID;
sm.AddSearch("PhoneNum", "ShopUserID_G");
var mem = sm.LoadEntity<HQ_Member>();
try
{
using (var scope = new TransactionScope())
{
if (mem.PhoneNum != phone)
{
Shop_Member s_mem = new Shop_Member();
s_mem["UserID"] = mem.ShopUserID_G;
s_mem["UserName"] = phone;
s_mem.Save();
}
HQ_Member user = new HQ_Member();
user["ID"] = LoginInfo.Current.UserID;
user.PhoneNum = phone;
user.Save();
scope.Complete();
}
}
catch
{
return 0;
}
return 1;
}
public long CancelBook(HQ_BookRoom broom)
{
var sm = new SearchModel("hq_bookroom");
//var sm = new SearchModel("uv_bookroom");
sm["id"] = broom.ID;
var room = sm.LoadEntity<HQ_BookRoom>();
if (room.OStatus == 0 || room.CanCancelBook_G == 1)
{
#region NoUse
//sm = new SearchModel("uv_MemberWithAmount");
//sm["id"] = room.MemberID;
//sm.AddSearch("ShopUserID_G", "Balance_G");
//var member = sm.LoadEntity<HQ_Member>();
//if (member == null)
//{
// return 0;
//}
//var toBalance = member.Balance_G + room.AllPrice_G;
//using (TransactionScope scope = new TransactionScope())
//{
// broom.OStatus = 4;
// broom.Save();
// //扣款后不能退订，所以退订时不会涉及用户金额问题
// //Shop_Accounts_UsersExp uexp = new Shop_Accounts_UsersExp();
// //uexp["UserID"] = member.ShopUserID_G;
// //uexp["Balance"] = toBalance;
// //uexp.Save();
// scope.Complete();
// return 1;
//}
#endregion
broom.OStatus = 4;
broom.LastOperateTime = DateTime.Now;
broom.Save();
return 1;
}
return -1;
}
public JsonResult GetArticle(int atype)
{
SearchModel sm = new SearchModel("HQ_Article");
sm["ACategory"] = atype;
var entity = sm.LoadEntity<HQ_Article>();
if (entity != null)
{
return this.JsonNet(entity);
}
return null;
}
public void LoadArticleDetail(int ptype, int vid)
{
SearchModel sm = null;
if (ptype == 1 || ptype == 3 || ptype == 4 || ptype == 5)
{
sm = new SearchModel("HQ_DisplayContent");
sm["ID"] = vid;
sm.AddSearch("Name", "DContent");
var dcon = sm.LoadEntity<HQ_DisplayContent>();
if (dcon != null)
{
OutResult(new { Name = dcon.Name, Content = reg.Replace(dcon.DContent, (match) => { return "<img class='uimg' _src='" + match.Groups[1].Value + "' />"; }) });
return;
}
}
else if (ptype == 2)
{
sm = new SearchModel("HQ_Article");
sm["ID"] = vid;
sm.AddSearch("Title", "AContent");
var article = sm.LoadEntity<HQ_Article>();
if (article != null)
{
OutResult(new { Name = article.Title, Content = reg.Replace(article.AContent, (match) => { return "<img class='uimg' _src='" + match.Groups[1].Value + "' />"; }) });
return;
}
}
OutResult(new { Name = "...", Content = "您要查找的内容不存在！" });
}
public string GetCopyright()
{
SearchModel sm = new SearchModel("hq_article");
sm["ACategory"] = (int)EnumArticleCategory.Copyright;
return sm.LoadEntity<HQ_Article>().AContent;
}
public string SearchAgenter(string name)
{
if (name == null || name.Length == 0)
{
return string.Empty;
}
SearchModel sm = new SearchModel("HQ_Agenter");
sm.AgenterName = name;
var agenter = sm.LoadEntity<HQ_Agenter>();
if (agenter != null)
{
return agenter.AContent;
}
return string.Empty;
}
public JsonResult LoadCurrUserInfo()
{
if (LoginVerify.IsLogin("Client"))
{
SearchModel sm = new SearchModel("hq_member");
sm["id"] = LoginInfo.Current.UserID;
var member = sm.LoadEntity<HQ_Member>();
if (member != null)
{
return this.JsonNet(new { Phone = member.PhoneNum, Pwd = MD5.DecryptString(member.ShopPsw) });
}
}
return this.JsonNet(new { Phone = "" });
}
public void Register(string uname, string psw, string phone, string yzm)
{
try
{
lock (MemberController.memRegLockObj)
{
SearchModel sm = new SearchModel("HQ_Member");
sm.MemberName = uname;
var entity = sm.LoadEntity<HQ_Member>();
if (entity != null)
{
OutResult(new { ResultID = -1 });
return;
}
var omcode = base.HttpContext.Cache["msg-" + phone];
if (omcode == null || omcode.ToString().Length == 0)
{
OutResult(new { ResultID = -3 });
return;
}
if (yzm == null || yzm.Length == 0 || !yzm.Equals(omcode.ToString()))
{
OutResult(new { ResultID = -4 });
return;
}
HQ_Member member = new HQ_Member();
member.UserName = uname;
member.UserPsw = MD5.EncryptString(psw);
member.ShopPsw = member.UserPsw;
member.PhoneNum = phone;
member.UserType = (int)EnumUserType.Normal;
member.Save();
}
//注册商城用户
HttpClient _httpClient = new HttpClient();
_httpClient.BaseAddress = new Uri("http://mall.chinalvju.com/");
var dic = new Dictionary<string, string>();
dic.Add("UserName", phone);
dic.Add("NickName", uname);
dic.Add("Password", psw);
dic.Add("ConfirmPassword", psw);
_httpClient.PostAsync("Account/Register", new FormUrlEncodedContent(dic));
}
catch
{
OutResult(new { ResultID = 0 });
return;
}
OutResult(new { ResultID = 1 });
}
public long ImportMember(string fpath)
{
fpath = Server.MapPath("~/" + fpath);
if (!System.IO.File.Exists(fpath))
{
return 0;
}
var list = G.Util.Tool.ExcelHelper.Read<HQ_Member>(fpath, new string[] {
"UserName","PhoneNum","MemberMedical"
}, 1, (e) =>
{
e.PhoneNum = e.PhoneNum;
e.UserPsw = e.PhoneNum.Substring(5);
e.UserType = (int)EnumUserType.Normal;
e.CreateBy = LoginInfo.Current.UserName;
e.CreateOn = DateTime.Now;
});
HttpClient _httpClient = new HttpClient();
_httpClient.BaseAddress = new Uri("http://mall.chinalvju.com/");
try
{
using (var scope = new TransactionScope())
{
foreach (var l in list)
{
SearchModel se = new SearchModel("uv_MemberWithAmount");
se["UserName"] = l.UserName;
se.AddSearch("ID", "PhoneNum", "ShopUserID_G");
var member = se.LoadEntity<HQ_Member>();
if (member == null)
{
se = new SearchModel("HQ_Member");
se["PhoneNum"] = l.PhoneNum;
se.AddSearch("count(id)");
var memCount = se.LoadValue<int>();
if (memCount > 0)
{
continue;
}
var dic = new Dictionary<string, string>();
dic.Add("UserName", l.PhoneNum);
dic.Add("NickName", l.UserName);
dic.Add("Password", l.UserPsw);
dic.Add("ConfirmPassword", l.UserPsw);
_httpClient.PostAsync("Account/Register", new FormUrlEncodedContent(dic));
l.UserPsw = MD5.EncryptString(l.UserPsw);
l.ShopPsw = l.UserPsw;
l.Save();
}
else
{
if (!l.PhoneNum.Equals(member.PhoneNum))
{
//手机号码变化时，修改商城用户手机号码
Shop_Member s_mem = new Shop_Member();
s_mem["UserID"] = member.ShopUserID_G;
s_mem["UserName"] = l.PhoneNum;
s_mem.Save();
}
var mem = new HQ_Member();
mem["id"] = member.ID;
mem.PhoneNum = l.PhoneNum;
mem.MemberMedical = l.MemberMedical;
mem.Save();
}
}
scope.Complete();
}
return 1;
}
catch
{
return 0;
}
}
public ActionResult MemberIndex()
{
SearchModel sm = new SearchModel("uv_MemberWithAmount");
sm["id"] = LoginInfo.Current.UserID;
ViewBag.Member = sm.LoadEntity<HQ_Member>();
return View();
}
public int MemberLogin(string username, string userpsw, string yzm, int isrem)
{
var syzm = base.Session["yzm"];
if (syzm == null || !syzm.ToString().Equals(yzm, StringComparison.CurrentCultureIgnoreCase))
{
return -2;
}
SearchModel sm = new SearchModel("HQ_Member");
sm.MemberName = username;
var member = sm.LoadEntity<HQ_Member>();
if (member == null)
{
return -1;
}
if (member.UserPsw != MD5.EncryptString(userpsw))
{
return 0;
}
LoginInfo info = new LoginInfo(username);
info.SystemID = "Client";
info.UserID = member.ID;
var userType = member.UserType;
if (userType == 2 && member.OpenVipDate.AddYears(3) < DateTime.Now.Date)
{
userType = 1;
HQ_Member mem = new HQ_Member();
mem["ID"] = member.ID;
mem.UserType = 1;
mem.Save();
}
info.UserType = userType;
LoginInfo.SetLoginToken(info, isrem == 1 ? true : false);
return 1;
}
public void LoadAnswer(int answerid)
{
SearchModel sm = new SearchModel("HQ_MemberAnswer");
sm["id"] = answerid;
var entity = sm.LoadEntity<HQ_MemberAnswer>();
if (entity != null)
{
var e = new HQ_MemberAnswer();
e["ID"] = entity.ID;
e.IsView = 1;
e.Save();
OutResult(new { Answer = entity.Answer });
}
else
{
OutResult(new { Answer = string.Empty });
}
}
