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));
}
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);
}));
}
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));
}
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);
}
}
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));
}
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));
}
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);
}
/// <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));
}
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));
}
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));
}
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);
}
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);
}
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);
}
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;
}
/// <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));
}
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 { }));
}
}
/// <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));
}
//获取信息
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));
}
/// <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));
}
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));
}
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);
}));
}
