示例#1
0
        public ActionResult GetUserInfo()
        {
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;

            string name       = Request["name"];
            string remark     = Request["remark"];
            int    totalCount = 0;
            //构建搜索条件
            UserInfoParam userInfoParam = new UserInfoParam()
            {
                PageIndex  = pageIndex,
                PageSize   = pageSize,
                TotalCount = totalCount,
                UName      = name,
                Remark     = remark
            };


            //var userInfoList = userInfoService.LoadPageEntities<int>(pageIndex, pageSize, out totalCount, u => u.DelFlag == 0, u => u.Id, true);
            var userInfoList = userInfoService.LoadSearchEntities(userInfoParam);

            var temp = from u in userInfoList
                       select new { u.Id, u.UName, u.UPwd, u.Remark, u.SubTime };

            return(Json(new { rows = temp, total = userInfoParam.TotalCount }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetHref()
        {
            UserInfoParam uip = new UserInfoParam();

            uip.PageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            uip.PageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;

            uip.TotalCount = 0;
            uip.CityID     = LoginUser.CityID;
            uip.Str        = Request["Str"] != null ? Request["Str"] : null;
            uip.Isee       = Request["Isee"] != null?Convert.ToBoolean(Request["Isee"]) : false;

            uip.C_id = LoginUser.ID;
            var actioninfolist = T_QiuZhuQiuGouService.LoadSearchEntities(uip);
            var temp           = from a in actioninfolist
                                 select new
            {
                ID         = a.ID,
                Hname      = a.Hname,
                QuYu       = a.QuYu,
                JuShi      = a.JuShi,
                Money      = a.Money,
                FBtime     = a.FBtime,
                Hperson    = a.Hperson,
                Photo      = a.Photo,
                GuiShuDi   = a.GuiShuDi,
                ClickCount = a.SeeQzCzs.Count,
                IsQZ       = "QZ"
            };

            return(Json(new { rows = temp, total = uip.TotalCount }, JsonRequestBehavior.AllowGet));
        }
示例#3
0
        public ActionResult SubmitForm(UserEntity userEntity, UserLogOnEntity userLogOnEntity, string keyValue)
        {   //组织机构编号
            string organizationCode = null;

            if (userEntity.F_IsHisAccount == null)
            {
                userEntity.F_IsHisAccount = false;
            }
            //是否机构账户
            if (userEntity.F_IsHisAccount == true)
            {
                var inputParam = new UserInfoParam()
                {
                    UserName           = userEntity.F_Account,
                    Pwd                = userLogOnEntity.F_UserPassword,
                    ManufacturerNumber = userEntity.F_ManufacturerNumber,
                };
                string inputParamJson   = JsonConvert.SerializeObject(inputParam, Formatting.Indented);
                var    verificationCode = _basicService.GetVerificationCode("01", inputParamJson);
                //获取userid
                if (verificationCode == null)
                {
                    throw  new  Exception("基层用户登陆失败!!!");
                }
                userEntity.F_HisUserId = verificationCode.UserId;
                organizationCode       = verificationCode.OrganizationCode;
            }
            userApp.SubmitForm(userEntity, userLogOnEntity, keyValue);
            //是否机构账户
            if (userEntity.F_IsHisAccount == true)
            { //更新机构编号
                organizeApp.UpDateEnCode(userEntity.F_DepartmentId, organizationCode);
            }
            return(Success("操作成功。"));
        }
        public ApiJsonResultData AddHospitalOperator(AddHospitalOperatorParam param)
        {
            return(new ApiJsonResultData(ModelState).RunWithTry(y =>
            {
                if (string.IsNullOrWhiteSpace(param.ManufacturerNumber))
                {
                    throw new Exception("厂商编号不能为空!!!");
                }
                var inputParam = new UserInfoParam()
                {
                    UserName = param.UserAccount,
                    Pwd = param.UserPwd,
                    ManufacturerNumber = param.ManufacturerNumber,
                };
                string inputParamJson = JsonConvert.SerializeObject(inputParam, Formatting.Indented);
                var verificationCode = _webServiceBasicService.GetVerificationCode("01", inputParamJson);
                if (verificationCode != null)
                {
                    param.OrganizationCode = verificationCode.OrganizationCode;
                    param.HisUserName = verificationCode.UserName;
                }

                _systemManage.AddHospitalOperator(param);
            }));
        }
示例#5
0
        public ActionResult GetUserInfo()
        {
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;

            string name   = Request["name"];
            string remark = Request["remark"];
            string zhgl   = Request["zhgl"] != null ? Request["zhgl"] : string.Empty;
            //构建搜索条件
            int           totalCount    = 0;
            UserInfoParam userInfoParam = new UserInfoParam()
            {
                PageIndex  = pageIndex,
                PageSize   = pageSize,
                TotalCount = totalCount,
                UserName   = name,
                Remark     = remark
                             //IsMaster = true,
                             //C_id = zhgl != null ? zhgl != string.Empty ? LoginUser.ID : 0 : 0
            };
            var userInfoList = UserInfoService.LoadSearchEntities(userInfoParam);
            var temp         = from u in userInfoList
                               select new { ID          = u.ID, UserName = u.UName, UserPass = u.UPwd, Remark = u.Remark, RegTime = u.SubTime, OverTime = u.OverTime,
                                            UserXiaoHao = u.UserXiaoHao,
                                            Click       = u.Click,
                                            ThisMastr   = u.ThisMastr,
                                            MasterID    = u.MasterID,
                                            CityID      = u.CityID,
                                            Umoney      = u.Umoney };

            return(Json(new { rows = temp, total = userInfoParam.TotalCount }, JsonRequestBehavior.AllowGet));
        }
示例#6
0
        public static void SetInfoParam(UserInfoParam userInfoParam, IBLL.IT_ItemsService T_ItemsService)
        {
            if (userInfoParam.Tval != null)
            {
                #region MyRegion
                string   str  = userInfoParam.Tval.ToString();
                string[] list = str.Split(',');
                for (int i = 0; i < list.Length; i++)
                {
                    string[] ti     = list[i].Split('>');
                    int      cc     = int.Parse(ti[0]);
                    var      this_i = T_ItemsService.LoadEntities(x => x.ID == cc).FirstOrDefault();
                    switch (this_i.Icons)
                    {
                    case 0:
                        userInfoParam.money = ti[1].Trim() == "0" ? null : this_i.StrID.ToString();
                        break;

                    case 1:
                        userInfoParam.Pingmu = ti[1].Trim() == "0" ? null : this_i.StrID.ToString();
                        break;

                    case 2:
                        userInfoParam.Tingshi = ti[1].Trim() == "0" ? null : this_i.StrID.ToString();
                        break;

                    case 3:
                        userInfoParam.Zhuanxiu = ti[1].Trim() == "0" ? null : ti[1].ToString().Trim() == "装修" ? null : ti[1];
                        break;
                    }
                }
                #endregion
            }
        }
        /// <summary>
        /// 医保信息回写至基层系统
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>



        public UserInfoDto GetUserBaseInfo(string param)
        {
            var data = _systemManageRepository.QueryHospitalOperator(new QueryHospitalOperatorParam()
            {
                UserId = param
            });

            if (string.IsNullOrWhiteSpace(data.HisUserAccount))
            {
                throw new Exception("当前用户未授权,基层账户信息,请重新授权!!!");
            }
            else
            {
                var inputParam = new UserInfoParam()
                {
                    UserName           = data.HisUserAccount,
                    Pwd                = data.HisUserPwd,
                    ManufacturerNumber = data.ManufacturerNumber,
                };
                string inputParamJson   = JsonConvert.SerializeObject(inputParam, Formatting.Indented);
                var    verificationCode = GetVerificationCode("01", inputParamJson);

                return(verificationCode);
            }
        }
示例#8
0
        public ActionResult GetUserInfo()
        {
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;

            string name   = Request["name"];
            string remark = Request["remark"];
            //构建搜索条件
            int           totalCount    = 0;
            UserInfoParam userInfoParam = new UserInfoParam()
            {
                PageIndex  = pageIndex,
                PageSize   = pageSize,
                TotalCount = totalCount,
                UserName   = name,
                Remark     = remark
            };

            //short delFlag = (short)DelFlagEnum.Normarl;
            //var userInfoList=UserInfoService.LoadPageEntities<int>(pageIndex, pageSize, out totalCount, c => c.DelFlag == delFlag, c => c.id, true);

            var userInfoList = UserInfoService.LoadSerachEntities(userInfoParam);
            var temp         = from u in userInfoList
                               select new { ID = u.id, UserName = u.UName, UserPass = u.UPwd, Remark = u.Remark, RegTime = u.SubTime };

            return(Json(new { rows = temp, total = userInfoParam.TotalCount }, JsonRequestBehavior.AllowGet));
        }
        public JsonResult GetData(UserInfoParam userInfoParam)
        {
            var queryData = SMUSERTBService.LoadSearchEntities(userInfoParam);
            var data      = queryData.Select(u => u.ToPoCo());

            //构造成Json的格式传递
            var result = new { total = data.Count(), rows = data };

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
示例#10
0
        public ActionResult GetHref()
        {
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 15;

            var    totalCount = int.MaxValue;
            var    CityID     = UserInfo_CityService.LoadEntities(x => x.UserInfo_ID == LoginUser.ID).FirstOrDefault();
            string Str        = Request["Str"];
            //构建搜索条件
            UserInfoParam userInfoParam = new UserInfoParam()
            {
                C_id       = Convert.ToInt32(LoginUser.ID),
                PageIndex  = pageIndex,
                PageSize   = pageSize,
                TotalCount = totalCount,
                Str        = Str,
                Tval       = Request["Tval"]
            };

            MyhtmlInfoController.SetInfoParam(userInfoParam, T_ItemsService);
            //MyhtmlInfoController mhc = new MyhtmlInfoController();
            //mhc.SetInfoParam
            //找到所有该人员信息
            var savelist       = T_SaveHtmlDataService.LoadPageEntities <DateTime>(pageIndex, pageSize, out totalCount, x => x.UserInfo.MasterID == LoginUser.ID && x.DelFlag == Delflag, x => x.SaveTime, false).DefaultIfEmpty();
            var ActionInfoList = T_FGJHtmlDataService.LoadSearchFrist(userInfoParam, false, false);

            var temp = from a in ActionInfoList
                       from b in savelist
                       where b.HtmldataID == a.ID
                       select new
            {
                ID          = a.ID,
                HLName      = a.HLName,
                Image_str   = (a.Image_str.IndexOf("有") >= 0 ? "有" : "无"),
                FbTime      = a.FbTime,
                PersonName  = a.PersonName,
                Address     = a.Address,
                photo       = a.photo,
                Laiyuan     = a.Laiyuan,
                FwSumMoney  = a.FwSumMoney,
                FwHuXing    = a.FwHuXing,
                FwLoucheng  = a.FwLoucheng,
                FwZhuangxiu = a.FwZhuangxiu,
                FwChaoxiang = a.FwChaoxiang,
                FwNianxian  = a.FwNianxian,
                FwMianji    = a.FwMianji,
                FwBiaoJi    = b.BiaoJiId,
                FwBiaoJiID  = b.ID,
                FwColors    = b.T_BiaoJiInfo.Colors,
                FwUserName  = b.UserInfo.UName
            };

            return(Json(new { rows = temp, total = userInfoParam.TotalCount }, JsonRequestBehavior.AllowGet));
        }
示例#11
0
        public ActionResult GetHref()
        {
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 15;

            var    totalCount = int.MaxValue;
            var    CityID     = UserInfo_CityService.LoadEntities(x => x.UserInfo_ID == LoginUser.ID).FirstOrDefault();
            string Str        = Request["Str"];
            //构建搜索条件
            UserInfoParam userInfoParam = new UserInfoParam()
            {
                //C_id =null,
                PageIndex  = pageIndex,
                PageSize   = pageSize,
                TotalCount = totalCount,
                Str        = Str,
                MasterID   = (bool)LoginUser.ThisMastr ? LoginUser.ID : (int)LoginUser.MasterID,
                Tval       = Request["Tval"]
            };

            MyhtmlInfoController.SetInfoParam(userInfoParam, T_ItemsService);

            var tem = T_SaveHtmlDataService.LoadSearchEntities(userInfoParam, true);
            //var tem = T_SaveHtmlDataService.LoadSearch(userInfoParam);
            //找到所有该人员信息
            // var savelist = T_SaveHtmlDataService.LoadPageEntities<DateTime>(pageIndex, pageSize, out totalCount, x => x.DelFlag == Delflag && x.GongGong == hidden, x => x.SaveTime, false).DefaultIfEmpty();

            // var ActionInfoList = T_FGJHtmlDataService.LoadSearchEntities(userInfoParam, false, true);

            var temp = from a in tem
                       select new
            {
                ID          = a.ID,
                HLName      = a.T_FGJHtmlData.HLName,
                Image_str   = (a.T_FGJHtmlData.Image_str.IndexOf("有") >= 0 ? "有" : "无"),
                FbTime      = a.T_FGJHtmlData.FbTime,
                PersonName  = a.T_FGJHtmlData.PersonName,
                Address     = a.T_FGJHtmlData.Address,
                Laiyuan     = a.T_FGJHtmlData.Laiyuan,
                FwSumMoney  = a.T_FGJHtmlData.FwSumMoney,
                FwHuXing    = a.T_FGJHtmlData.FwHuXing,
                FwLoucheng  = a.T_FGJHtmlData.FwLoucheng,
                FwZhuangxiu = a.T_FGJHtmlData.FwZhuangxiu,
                FwChaoxiang = a.T_FGJHtmlData.FwChaoxiang,
                FwNianxian  = a.T_FGJHtmlData.FwNianxian,
                FwMianji    = a.T_FGJHtmlData.FwMianji,
                FwBiaoJi    = a.BiaoJiId,
                FwBiaoJiID  = a.ID,
                FwColors    = a.T_BiaoJiInfo.Colors,
                FWsaveName  = a.UserInfo.UName
            };

            return(Json(new { rows = temp, total = userInfoParam.TotalCount }, JsonRequestBehavior.AllowGet));
        }
        private async Task <UserInfoDto> GetUserBaseInfo()
        {
            var inputParam = new UserInfoParam()
            {
                用户名  = "liqian",
                密码   = "123",
                厂商编号 = "510303001",
            };
            string inputParamJson   = JsonConvert.SerializeObject(inputParam, Formatting.Indented);
            var    verificationCode = await _webServiceBasicService.GetVerificationCode("01", inputParamJson);

            return(verificationCode);
        }
示例#13
0
        /// <summary>
        /// 多条件搜索
        /// </summary>
        /// <param name="userInfoParam"></param>
        /// <returns></returns>
        public IQueryable <UserInfo> LoadSearchEntities(UserInfoParam userInfoParam)
        {
            var temp = CurrentDBSession.UserInfoDal.LoadEntities(u => u.DelFlag == 0);

            if (!string.IsNullOrEmpty(userInfoParam.UName))
            {
                temp = temp.Where(u => u.UName.Contains(userInfoParam.UName));
            }
            if (!string.IsNullOrEmpty(userInfoParam.Remark))
            {
                temp = temp.Where(u => u.Remark.Contains(userInfoParam.Remark));
            }
            userInfoParam.TotalCount = temp.Count();
            return(temp.OrderBy <UserInfo, int>(u => u.Id).Skip((userInfoParam.PageIndex - 1) * userInfoParam.PageSize).Take(userInfoParam.PageSize));
        }
示例#14
0
        public ActionResult GetUserInfo()
        {
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;

            string name   = Request["name"];
            string remark = Request["remark"];
            string zhgl   = Request["zhgl"] != null ? Request["zhgl"] : string.Empty;
            //构建搜索条件
            int           totalCount    = 0;
            UserInfoParam userInfoParam = new UserInfoParam()
            {
                PageIndex  = pageIndex,
                PageSize   = pageSize,
                TotalCount = totalCount,
                UserName   = name,
                Remark     = remark,
                BumenID    = LoginUser.BuMenID

                             //IsMaster = true,
                             //C_id = zhgl != null ? zhgl != string.Empty ? LoginUser.ID : 0 : 0
            };
            var userInfoList = UserInfoService.LoadSearchEntities(userInfoParam);
            var temp         = from u in userInfoList
                               select new {
                ID             = u.ID,
                UserName       = u.UName,
                UserPass       = u.UPwd,
                Remark         = u.Remark,
                RegTime        = u.SubTime,
                PerSonName     = u.PerSonName,
                BuMenID        = u.BuMenID,
                BuMen          = u.Inventory_BumenInfoSet.Name,
                UPwd           = u.UPwd,
                BumenName      = u.Inventory_BumenInfoSet.Name,
                UserNumber     = u.UserNumber,
                DingDingNumber = u.DingDingNumber,
                Position_ID    = u.Position_ID,
                Position       = u.Inventory_Position.Name,
                Sex            = u.Sex,
                SexStr         = u.Sex == 0?"男":u.Sex == 1?"女":"未知",
                Photo          = u.Photo,
                Bak            = u.Bak
            };

            return(Json(new { rows = temp, total = userInfoParam.TotalCount }, JsonRequestBehavior.AllowGet));
        }
示例#15
0
        public IQueryable <T_QiuZhuQiuGou> LoadSearchEntities(UserInfoParam uip)
        {
            var temp = this.GetCurrentDbSession.T_QiuZhuQiuGouDal.LoadEntities(x => x.CityID == uip.CityID);

            if (!string.IsNullOrEmpty(uip.Str))
            {
                temp = temp.Where <T_QiuZhuQiuGou>(u => u.GuiShuDi.Contains(uip.Str) || u.Hname.Contains(uip.Str) || u.QuYu.Contains(uip.Str));
            }
            if (uip.Isee)
            {
                var czdata = this.GetCurrentDbSession.SeeQzCzDal.LoadEntities(x => x.UserID == uip.C_id && x.QiuZhuID != null);
                temp = czdata.Select(x => x.T_QiuZhuQiuGou);
            }
            uip.TotalCount = temp.Count();
            return(temp.OrderByDescending <T_QiuZhuQiuGou, DateTime>(u => u.FBtime).Skip <T_QiuZhuQiuGou>((uip.PageIndex - 1) * uip.PageSize).Take <T_QiuZhuQiuGou>(uip.PageSize));
        }
示例#16
0
        public int GetSeachdata(long XmsID, int pageIndex, int pageSize)
        {
            var           CityID     = UserInfo_CityService.LoadEntities(x => x.UserInfo_ID == LoginUser.ID).FirstOrDefault();
            var           totalCount = 0;
            UserInfoParam Uxms       = new UserInfoParam();
            var           xms        = ScrherSAVEService.LoadEntities(x => x.ID == XmsID && x.DEL == 0).FirstOrDefault();

            Uxms.PageIndex  = pageIndex;
            Uxms.PageSize   = pageSize;
            Uxms.TotalCount = totalCount;
            Uxms.ssve       = xms;
            Uxms.C_id       = CityID.T_City_ID;

            T_FGJHtmlDataService.LoadSearchPM(Uxms);
            return(Uxms.TotalCount);
        }
示例#17
0
        public UserInfo GetUserInfo(UserInfoParam param)
        {
            UserInfo userinfo  = null;
            string   sqlstring = "select * from userinfo where UIUId=@UIUId " +
                                 " limit 1";
            var sqlParams = new
            {
                UId = param.UId
            };
            List <UserInfo> userinfos = hackMySqlHelper.DapperQuery <UserInfo>(sqlstring, sqlParams, false);

            if (userinfos != null && userinfos.Count > 0)
            {
                userinfo = userinfos[0];
            }
            return(userinfo);
        }
    {/// <summary>
     /// 获取个人基础资料
     /// </summary>
     /// <param name="param"></param>
        public UserInfoDto GetUserInfo(UserInfoParam param)
        {
            UserInfoDto resultData = new UserInfoDto();
            // var Data = XmlHelp.DeSerializerModel(new IdentificationSpecialDownloadListDto());

            var xmlStr = XmlHelp.SaveXml(param);

            if (xmlStr)
            {
                int result = WorkersMedicalInsurance.CallService_cxjb("CXJB001");
                if (result == 1)
                {
                    resultData = XmlHelp.DeSerializerModel(new UserInfoDto());
                }
            }

            return(resultData);
        }
示例#19
0
        private void button1_Click(object sender, EventArgs e)
        {
            var user = new UserInfoParam();

            //XmlHelp.DeSerializerModel(user);

            //var residentMedical = new ResidentMedicalInsurance();
            //residentMedical.GetUserInfo(user);

            //var param = new IdentificationSpecialSettlementParam()
            // {   PI_SFBZ ="1231223",
            //     PI_FYMX=
            //          new List<IdentificationSpecialSettlementPI_FYMXParam>()
            //         { new IdentificationSpecialSettlementPI_FYMXParam()
            //         {
            //             BKE019 = "123",
            //             AAE013 = "123222",
            //             AKA074 = "122222"
            //         }}
            //};
            //var data = XmlHelp.SaveXml(param);
            //Logs.LogWrite(new LogParam(){Msg = "123",Name = "123",OperatorCode = "3444",Params = "dddd"});
            // XmlHelp.IdentificationSpecialQueryDeSerializerModel(new IdentificationSpecialQueryDto());
            //var ddd=   HttpHelp.CreateGetHttpResponse("http://192.168.101.105:50839/Test/GetInpatientInfo");
            //string url = "http://192.168.101.105:50839/Test/GetInpatientInfo";
            //var ddd=   HttpHelp.HttpGet(url);



            // Resident.GetUserInfo();
            //var hisbase = new HisBaseParam()
            //{
            //    YbOrgCode = "123",
            //    OrgID = Guid.NewGuid(),
            //    BID = Guid.Empty,
            //    EmpID = Guid.Parse("A2A4866484DC40F0A10FB7482603AABD"),
            //    BsCode = "003",
            //    TransKey = Guid.NewGuid(),
            //};
            //ResidentTest.HospitalizationRegister(new QueryInpatientInfoBasicParam()
            //{
            //    IdCard = "510821198604156818",InstitutionalNumber = "51072600000000000000000513435964"
            //}, hisbase);
        }
        /// <summary>
        /// 多条件搜索用户信息
        /// </summary>
        /// <param name="userInfoSearchParam">用户查询参数实体</param>
        /// <returns></returns>
        public IQueryable <SMUSERTB> LoadSearchEntities(UserInfoParam userInfoSearchParam)
        {
            Expression <Func <SMUSERTB, bool> > whereLambda = PredicateBuilder.True <SMUSERTB>();

            if (!string.IsNullOrEmpty(userInfoSearchParam.UserName))
            {
                whereLambda = whereLambda.And(u => u.USER_NAME.Contains(userInfoSearchParam.UserName));
            }
            if (!string.IsNullOrEmpty(userInfoSearchParam.GenderName))
            {
                whereLambda = whereLambda.And(u => u.GENDER == userInfoSearchParam.GenderName);
            }
            if (!string.IsNullOrEmpty(userInfoSearchParam.StatusName))
            {
                whereLambda = whereLambda.And(u => u.STATUS == userInfoSearchParam.StatusName);
            }
            int count = 0;
            IQueryable <SMUSERTB> queryData = null;

            if (!string.IsNullOrEmpty(userInfoSearchParam.order) && !string.IsNullOrEmpty(userInfoSearchParam.sort))
            {
                bool isAsc = userInfoSearchParam.order == "asc" ? true : false;
                queryData = LoadPageEntities <SMUSERTB>(userInfoSearchParam.page, userInfoSearchParam.rows, out count, whereLambda, userInfoSearchParam.sort, isAsc);
            }
            else
            {
                queryData = LoadPageEntities <SMUSERTB>(userInfoSearchParam.page, userInfoSearchParam.rows, out count, whereLambda, userInfoSearchParam.sort, null);
            }
            userInfoSearchParam.TotalCount = count;

            foreach (var item in queryData)
            {
                if (item.SMROLETB != null)
                {
                    item.SysRoleId = string.Empty;
                    foreach (var it in item.SMROLETB)
                    {
                        item.SysRoleId += it.ROLE_NAME + ' ';
                    }
                }
            }
            return(queryData);
        }
示例#21
0
        private void button1_Click(object sender, EventArgs e)
        {
            //居民保险
            //string baseParam = JsonConvert.SerializeObject(new HisBaseParam()
            //{
            //    YbOrgCode = "99999",
            //    EmpID = "E075AC49FCE443778F897CF839F3B924",
            //    OrgID = "51072600000000000000000513435964",
            //    BID= "6721F4DA50B349AF9F5F387707C1647A",
            //    BsCode = "23",
            //    TransKey = "6721F4DA50B349AF9F5F387707C1647A"
            //});
            var paramEntity = new UserInfoParam();

            paramEntity.PI_CRBZ = "1";
            paramEntity.PI_SFBZ = "513701199002124815";

            //var data = _residentd.GetUserInfo(JsonConvert.SerializeObject(paramEntity), JsonConvert.DeserializeObject<HisBaseParam>(baseParam));
            //textBox1.Text = data;
        }
示例#22
0
        /// <summary>
        /// 条件搜索
        /// </summary>
        /// <param name="userInfoParam"></param>
        /// <returns></returns>
        public IQueryable <UserInfo> LoadSearchEntities(UserInfoParam userInfoParam)
        {
            var delFlag   = (short)DelFlagEnum.Normal;
            var skipCount = (userInfoParam.PageIndex - 1) * userInfoParam.PageSize;
            var temp      = GetCurrentSession.UserInfoDal.LoadEntities(u => u.DelFlag == delFlag);

            if (!string.IsNullOrEmpty(userInfoParam.UserName))
            {
                temp = temp.Where(u => u.UserName.Contains(userInfoParam.UserName));
            }
            if (!string.IsNullOrEmpty(userInfoParam.Remark))
            {
                temp = temp.Where(u => u.Remark.Contains(userInfoParam.Remark));
            }
            userInfoParam.TotalCount = temp.Count();

            return(temp.OrderBy(u => u.UserID)
                   .Skip(skipCount)
                   .Take(userInfoParam.PageSize));
        }
示例#23
0
        public HackResponse Post([FromBody] UserInfoParam param)
        {
            UserInfo userinfo = service.GetUserInfo(param);

            if (userinfo == null)
            {
                bool isSuc = service.AddUserInfo(param);
                return
                    (new HackResponse
                         (HackResType.Success, HackRspCode.HackRspCode_0000, "查询成功",
                         new { isSucess = isSuc }));
            }
            else
            {
                return
                    (new HackResponse
                         (HackResType.DataError, HackRspCode.HackRspCode_3000,
                         "重复添加", new { }));
            }
        }
示例#24
0
        /// <summary>
        /// 多条件搜索用户信息
        /// </summary>
        /// <param name="userInfoSerachParam"></param>
        /// <returns></returns>
        public IQueryable <UserInfo> LoadSerachEntities(UserInfoParam userInfoSerachParam)
        {
            short delFlag = (short)DelFlagEnum.Normarl;
            var   temp    = this.GetCurrentDbSession.UserInfoDal.LoadEntities(c => c.DelFlag == delFlag);

            //拼接查询条件
            if (!string.IsNullOrEmpty(userInfoSerachParam.UserName))
            {
                temp = temp.Where <UserInfo>(u => u.UName.Contains(userInfoSerachParam.UserName));
            }
            if (!string.IsNullOrEmpty(userInfoSerachParam.Remark))
            {
                temp = temp.Where <UserInfo>(u => u.UName.Contains(userInfoSerachParam.Remark));
            }

            userInfoSerachParam.TotalCount = temp.Count();

            return(temp.OrderBy <UserInfo, int>(u => u.id).Skip <UserInfo>
                       ((userInfoSerachParam.PageIndex - 1) * userInfoSerachParam.PageSize).Take <UserInfo>
                       (userInfoSerachParam.PageSize));
        }
示例#25
0
        //获取信息
        public ActionResult GetFanChan()
        {
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;

            //构建搜索条件
            int           totalCount    = 0;
            UserInfoParam userInfoParam = new UserInfoParam()
            {
                PageIndex  = pageIndex,
                PageSize   = int.MaxValue,
                TotalCount = totalCount,
                Items      = Request["item"] == null ? "2" : Request["item"],
                IsMaster   = Request["IsHSZ"] == null ? false : Convert.ToBoolean(Request["IsHSZ"]),
                IsTop      = Request["IsTop"] == null ? true : Convert.ToBoolean(Request["IsTop"])
            };
            var temp = BzcmText_FanChanService.LoadSearchEntities(userInfoParam).OrderBy(x => x.IsTop_shor);

            return(Json(new { rows = temp, total = userInfoParam.TotalCount }, JsonRequestBehavior.AllowGet));
        }
示例#26
0
        /// <summary>
        /// 获取用户信息
        /// </summary>
        /// <returns></returns>
        public ActionResult GetUserInfo()
        {
            var pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            var pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;

            var name   = Request["name"];
            var remark = Request["remark"];
            //构建搜索条件
            int totalCount    = 0;
            var userInfoParam = new UserInfoParam()
            {
                UserName   = name,
                Remark     = remark,
                PageIndex  = pageIndex,
                PageSize   = pageSize,
                TotalCount = totalCount
            };

            //short delFlag = (short)DelFlagEnum.Normal;
            //var userInfoList = UserInfoBll.LoadPageEntities(pageIndex, pageSize, out totalCount,
            //    c => c.DelFlag == delFlag,
            //    c => c.UserID, true);

            var temp = UserInfoBll.LoadSearchEntities(userInfoParam)
                       .Select(u => new
            {
                ID       = u.UserID,
                UserName = u.UserName,
                UserPass = u.UserPwd,
                Remark   = u.Remark,
                RegTime  = u.SubTime,
            });

            return(Json(new
            {
                rows = temp,
                total = userInfoParam.TotalCount
            }, JsonRequestBehavior.AllowGet));
        }
示例#27
0
        public bool AddUserInfo(UserInfoParam param)
        {
            string sqlstring = @"INSERT INTO userinfo
(
UIUId,
UIHomeAddress,
UIWorkAddress,
UIHomeLat,
UIHomeLon,
UIWorkLat,
UIWorkLon,
UIRole)
VALUES
( 
    @UIUId,
    @UIHomeAddress,
    @UIWorkAddress,
    @UIHomeLat,
    @UIHomeLon,
    @UIWorkLat,
    @UIWorkLon,
    @UIRole)";
            var    sqlParams = new
            {
                UId           = param.UId,
                UIHomeAddress = param.UIHomeAddress,
                UIWorkAddress = param.UIWorkAddress,
                UIHomeLat     = param.UIHomeLat,
                UIHomeLon     = param.UIHomeLon,
                UIWorkLat     = param.UIWorkLat,
                UIWorkLon     = param.UIWorkLon,
                UIRole        = param.UIRole
            };

            bool isSuc = hackMySqlHelper.DapperExcute(sqlstring, sqlParams);

            return(isSuc);
        }
        public ActionResult getdata()
        {
            int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;

            int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 25;

            UserInfoParam uim = new UserInfoParam();

            uim.Uptime     = Convert.ToDateTime(Request["UpTime"]);
            uim.Dwtime     = Convert.ToDateTime(Request["DwTime"]);
            uim.Jhname     = Request["Jhname"] == null ? 0 : Request["Jhname"].Length <= 0 ? 0 : int.Parse(Request["Jhname"]);
            uim.adduser    = Request["addUser"] == null ? 0 : Request["addUser"].Length <= 0 ? 0 : int.Parse(Request["addUser"]);
            uim.SHuser     = Request["SHuser"] == null ? 0 : Request["SHuser"].Length <= 0 ? 0 : int.Parse(Request["SHuser"]);
            uim.CPtext     = Request["CPtext"] == null ? 0 : Request["CPtext"].Length <= 0 ? 0 : int.Parse(Request["CPtext"]);
            uim.zt         = Request["shzt"] == null ? 0 : Request["shzt"].Length <= 0 ? -1 : int.Parse(Request["shzt"]);
            uim.PageIndex  = pageIndex;
            uim.PageSize   = pageSize;
            uim.TotalCount = 0;
            var temp  = T_SczzDanjuService.LoadSearchEntities(uim);
            var Rtemp = Fromnew(temp);

            return(Json(new { rows = Rtemp, total = uim.TotalCount }, JsonRequestBehavior.AllowGet));
        }
示例#29
0
        public IQueryable <YXB_Kh_list> loadBaoBeientities(UserInfoParam ups)
        {
            var temp = this.GetCurrentDbSession.YXB_Kh_listDal.LoadEntities(x => x.DelFlag == 0 && x.NewTime >= ups.Uptime && x.NewTime <= ups.Dwtime && x.UserInfo.BuMenID == ups.BumenID).DefaultIfEmpty();

            if (ups.Person > 0)
            {
                temp = temp.Where(x => x.AddUser == ups.Person);
            }
            if (ups.KHname > 0)
            {
                temp = temp.Where(x => x.id == ups.KHname);
            }
            if (ups.addess != null)
            {
                if (ups.addess.Trim().Length > 0)
                {
                    temp = temp.Where(x => x.T_BaoJiaToP.Where(w => w.Addess.Contains(ups.addess)).Count() > 0);
                }
            }

            ups.TotalCount = temp.Count();
            return(temp.OrderByDescending <YXB_Kh_list, DateTime>(u => u.NewTime).Skip <YXB_Kh_list>((ups.PageIndex - 1) * ups.PageSize).Take <YXB_Kh_list>(ups.PageSize));
        }
        public ApiJsonResultData GetUserInfoLogin([FromBody] GetUserInfoLoginUiParam param)
        {
            return(new ApiJsonResultData(ModelState).RunWithTry(y =>
            {
                var inputParam = new UserInfoParam()
                {
                    UserName = param.UserName,
                    Pwd = param.pwd,
                    ManufacturerNumber = "510303001",
                };
                string inputParamJson = JsonConvert.SerializeObject(inputParam, Formatting.Indented);
                var verificationCode = webServiceBasicService.GetVerificationCode("01", inputParamJson);
                y.Data = verificationCode;


                //var queryResidentParam = new QueryMedicalInsuranceResidentInfoParam()
                //{
                //    BusinessId = "26F6B97CE2F2494182B6CB7942BBA96F",
                //    MedicalInsuranceState = 3
                //};
                //var residentData = ImedicalInsuranceSqlRepository.QueryMedicalInsuranceResidentInfo(queryResidentParam);
            }));
        }