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 }); } }