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