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 JsonResult LoadRooms(int villageId) { SearchModel sm = new SearchModel("HQ_Room"); sm["VillageID"] = villageId; var data = sm.Load<HQ_Room>().Data; return this.JsonNet(data); }
public JsonResult LoadBenefits(int page) { var psize = 7; if (page > 1) { psize = psize + (page - 1) * 4; } SearchModel sm = new SearchModel("HQ_DisplayPanel"); sm["DPanelType"] = (int)EnumDPanelType.MemberBenefit; sm.OrderBy("id"); sm.PageIndex = 1; sm.PageSize = psize; var result = sm.Load<HQ_DisplayPanel>(); List<HQ_DisplayPanel> list = null; if (page == 1) { list = result.Data; } else { list = new List<HQ_DisplayPanel>(); for (var i = 7 + (page - 2) * 4; i < result.Data.Count; ++i) { list.Add(result.Data[i]); } } return this.JsonNet(new { Data = list, PageCount = result.PageCount }); }
public JsonResult LoadBenefitDetails(int destinationId) { SearchModel sm = new SearchModel("HQ_DisplayContent"); sm["DPanelID"] = destinationId; sm.AddSearch("ID", "Name"); var result = sm.Load<HQ_DisplayContent>(); return this.JsonNet(result.Data); }
public JsonResult LoadCheaperDetails(int cheaperid) { SearchModel sm = new SearchModel("HQ_DisplayContent"); sm["DPanelID"] = cheaperid; sm.AddSearch("ID", "Name"); var result = sm.Load<HQ_DisplayContent>(); return this.JsonNet(result.Data); }
public JsonResult GetLinks(SearchModel sm, int page_g, int psize_g) { sm.SearchID = "HQ_FLink"; sm.OrderBy("ID", GOMFrameWork.DataEntity.EnumOrderBy.Desc); sm.PageIndex = page_g; sm.PageSize = psize_g; var result = sm.Load<HQ_FLink>(); return ExController.JsonNet(result); }
public void CheckNewAnswer(int uid) { SearchModel sm = new SearchModel("uv_memberask"); sm["MemberID"] = uid; sm.NewAnswerID = 0; sm.AnswerViewed = 0; sm.AddSearch("count(1)"); var newcount = sm.LoadValue<int>(); OutResult(new { ncount = newcount }); }
public JsonResult LoadDContentDesc(SearchModel se, int page_g, int psize_g) { se.SearchID = "hq_article"; se["acategory"] = (int)EnumArticleCategory.RoomDesc; se.OrderBy("id"); se.PageIndex = page_g; se.PageSize = psize_g; return ExController.JsonNet(se.Load<HQ_Article>()); }
public JsonResult LoadJsonData(int dPanelType) { SearchModel sm = new SearchModel("HQ_DisplayPanel"); sm["DPanelType"] = dPanelType; var distinations = sm.Load<HQ_DisplayPanel>().Data; var select = HtmlSelect.GetHtmlSelectByCollection<HQ_DisplayPanel>(distinations, (e) => { return new HtmlSelectItem() { k = e.Name, v = (int)e.ID }; }); return ExController.JsonNet(new { Detinations = select }); }
public JsonResult LoadHotRoom(int destinationid, int dtype, int pindex = 1, int psize = 3) { SearchModel sm = new SearchModel("uv_VillageRoom_Hot"); sm["DPanelID"] = destinationid; sm["DType"] = dtype; sm.PageIndex = pindex; sm.PageSize = psize; sm.OrderBy("bcount", GOMFrameWork.DataEntity.EnumOrderBy.Desc); var rooms = sm.Load<HQ_Room>(); return this.JsonNet(rooms); }
public JsonResult LoadData(SearchModel se) { #region 查询条件初始化 Example:se["Field"] = "value"; se.SearchID = "hq_advertisement"; se.OrderBy("id"); #endregion var result = se.Load<HQ_Advertisement>(); return ExController.JsonNet(result); }
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 JsonResult LoadJsonData() { SearchModel sm=new SearchModel("uv_DisplayContent"); sm.AddSearch("ID","Name"); sm["DPanelType"]=(int)EnumDPanelType.Distination; sm.OrderBy("DPanelID"); var result= sm.Load<HQ_DisplayContent>(); var items= HtmlSelect.GetHtmlSelectByCollection<HQ_DisplayContent>(result.Data,(e)=> { return new HtmlSelectItem(){ k=e.Name,v=(int)e.ID}; }); return ExController.JsonNet(new { Villages=items }); }
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 JsonResult LoadAgenterList(SearchModel se, int page_g, int psize_g) { #region 查询条件初始化 Example:se["Field"] = "value"; se.SearchID="HQ_Agenter"; se.OrderBy("id", EnumOrderBy.Desc); #endregion se.PageIndex = page_g; se.PageSize = psize_g; var result = se.Load<HQ_Agenter>(); return ExController.JsonNet(result); }
public JsonResult LoadDestinations(SearchModel se, int page_g, int psize_g) { #region 查询条件初始化 Example:se["Field"] = "value"; se.SearchID = "HQ_DisplayPanel"; se["DPanelType"] = (int)EnumDPanelType.Distination; se.OrderBy("id", EnumOrderBy.Desc); #endregion se.PageIndex = page_g; se.PageSize = psize_g; var result = se.Load<HQ_DisplayPanel>(); return ExController.JsonNet(result); }
public JsonResult LoadAsks(SearchModel se, int page_g, int psize_g) { #region 查询条件初始化 Example:se["Field"] = "value"; se.SearchID = "uv_memberask"; //......................... se.OrderBy("id", EnumOrderBy.Desc); #endregion se.PageIndex = page_g; se.PageSize = psize_g; var result = se.Load<HQ_MemberAsk>(); return this.JsonNet(result); }
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 string GetCopyright() { SearchModel sm = new SearchModel("hq_article"); sm["ACategory"] = (int)EnumArticleCategory.Copyright; return sm.LoadEntity<HQ_Article>().AContent; }
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 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 int SendMsgCode(string phone, string type) { if (type == null || type.Length == 0) { return -2;//系统错误 } if (phone != null && phone.Length > 0 && Regex.Match(phone, @"^[1][3,5,8][0-9]{9}$", RegexOptions.Compiled).Success) { var msgKey = string.Empty; if ("1".Equals(type)) { SearchModel se = new SearchModel("hq_member"); se["PhoneNum"] = phone; se.AddSearch("count(1)"); var count = se.LoadValue<int>(); if (count > 0) { return 9; } msgKey = "用户注册短信验证码:"; } if ("3".Equals(type)) { SearchModel se = new SearchModel("hq_member"); se["PhoneNum"] = phone; se.AddSearch("count(1)"); var count = se.LoadValue<int>(); if (count > 0) { return 9; } msgKey = "用户修改手机号码短信验证码:"; } if ("2".Equals(type)) { msgKey = "用户找回密码验证码:"; } var yzm = string.Empty; foreach (var i in Ran.GetRandomArray(6, 0, 9)) { yzm += i.ToString(); } SendUserInfo _U = new SendUserInfo() { isLog = 1, orgid = 555, username = phone }; if (MsgSend.DirectSend(msgKey + yzm, phone, _U)) { base.HttpContext.Cache["msg-" + phone] = yzm; return 1; } else { return 0; } } else { 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 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 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 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 JsonResult GetAdvPBottom() { SearchModel sm = new SearchModel("HQ_Advertisement"); sm["ID"] = 1; HQ_Advertisement adv = sm.LoadEntity<HQ_Advertisement>(); return this.JsonNet(adv); }
public JsonResult GetFLink(int ltype) { SearchModel sm = new SearchModel("hq_flink"); sm["LinkType"] = ltype; var links = sm.Load<HQ_FLink>().Data; return ExController.JsonNet(links); }