public void ProcessRequest(HttpContext context)
{
string username = context.Request.Params["username"];
string password = context.Request.Params["password"];
if (String.IsNullOrEmpty(username) || String.IsNullOrEmpty(password))
return;
List<ICriterion> criterionList = new List<ICriterion>();
criterionList.Add(Restrictions.Eq("UserName", username));
criterionList.Add(Restrictions.Eq("Password", password));
QueryTerms queryTerms = new QueryTerms();
queryTerms.CriterionList = criterionList;
queryTerms.PersistentClass = typeof(SystemUser);
List<SystemUser> userList = (List<SystemUser>)SystemUserBll.GetSystemUserList(queryTerms, false).Data;
string script = "";
if (userList == null || userList.Count != 1)
{
script = "$('#messageSpan').html(''); setTimeout(\"$('#messageSpan').html('用户名或密码错误……');\", 50);";
}
else
{
HttpContext.Current.Session["SystemUser"] = userList[0];
script = "location.href='Default.htm';";
}
context.Response.Write(script);
}
public IActionResult BuyEvaluateList()
{
QueryTerms qry = new QueryTerms();
qry.flowtyp = "待處理";
return(PartialView("_BuyEvaluateList", GetList(qry, "")));
}
public static ResultModel GetOperationLogList(QueryTerms queryTerms)
{
List<OperationLog> logList = new List<OperationLog>();
int totalCount = 0;
ResultModel result = new ResultModel();
try
{
logList = (List<OperationLog>)(OperationLogDal.GetList(queryTerms));
totalCount = Convert.ToInt32(OperationLogDal.GetTotalCount(queryTerms));
result.Data = logList;
result.DataSize = totalCount;
result.IsSuccess = true;
result.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_SUCCESS;
return result;;
}
catch (Exception exception)
{
result.Data = logList;
result.DataSize = totalCount;
result.IsSuccess = true;
result.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_ERROR;
result.ResultMessage = exception.Message;
return result;
}
}
public async Task <IViewComponentResult> InvokeAsync(string id = null, string sid = null)
{
QueryTerms qry = new QueryTerms();
qry.flowtyp = "待處理";
var list = new BuyEvaluateController(_context, _userRepo, _dptRepo, _emailSender, userManager, roleManager).GetList(qry, "");
return(View(list));
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime=request.Params["textAddTime"];
string cardId=request.Params["textCardId"];
string conComId=request.Params["textConComId"];
string consumerId=request.Params["textConsumerId"];
string itemId=request.Params["textItemId"];
string logId=request.Params["textLogId"];
CriterionAndOrder consumptionLogCriterionAndOrder = new CriterionAndOrder();
consumptionLogCriterionAndOrder.CriteriaName = typeof(ConsumptionLog).FullName;
consumptionLogCriterionAndOrder.CriteriaAsName = "CL";
consumptionLogCriterionAndOrder.OrderList.Add(new Order("CL.AddTime", false));
CriterionAndOrder membershipCardCriterionAndOrder = new CriterionAndOrder();
membershipCardCriterionAndOrder.CriteriaName ="CardRef" ;
membershipCardCriterionAndOrder.CriteriaAsName = "MC";
membershipCardCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder consumptionCombinationCriterionAndOrder = new CriterionAndOrder();
consumptionCombinationCriterionAndOrder.CriteriaName ="ConComRef" ;
consumptionCombinationCriterionAndOrder.CriteriaAsName = "CC";
consumptionCombinationCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder consumerCriterionAndOrder = new CriterionAndOrder();
consumerCriterionAndOrder.CriteriaName ="ConsumerRef" ;
consumerCriterionAndOrder.CriteriaAsName = "C";
consumerCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder serviceItemCriterionAndOrder = new CriterionAndOrder();
serviceItemCriterionAndOrder.CriteriaName ="ItemRef" ;
serviceItemCriterionAndOrder.CriteriaAsName = "SI";
serviceItemCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(addTime))
consumptionLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CL.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(cardId))
consumptionLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CL.CardId", cardId));
if (!String.IsNullOrEmpty(conComId))
consumptionLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CL.ConComId", conComId));
if (!String.IsNullOrEmpty(consumerId))
consumptionLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CL.ConsumerId", consumerId));
if (!String.IsNullOrEmpty(itemId))
consumptionLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CL.ItemId", itemId));
if (!String.IsNullOrEmpty(logId))
consumptionLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CL.LogId", logId));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("CL.LogId").As("PrimaryKey"));
pList.Add(Projections.Property("CL.AddTime").As("AddTime"));
pList.Add(Projections.Property("MC.CardId").As("CardId"));
pList.Add(Projections.Property("CC.ConComId").As("ConComId"));
pList.Add(Projections.Property("C.ConsumerId").As("ConsumerId"));
pList.Add(Projections.Property("SI.ItemId").As("ItemId"));
pList.Add(Projections.Property("CL.LogId").As("LogId"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(ConsumptionLog);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(consumptionLogCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(membershipCardCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(consumptionCombinationCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(consumerCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(serviceItemCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = ConsumptionLogBll.GetConsumptionLogList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling=NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string actualBeginTime=request.Params["textActualBeginTime"];
string actualDurationTime=request.Params["textActualDurationTime"];
string actualEndTime=request.Params["textActualEndTime"];
string actualUserNo=request.Params["textActualUserNo"];
string addTime=request.Params["textAddTime"];
string adminId=request.Params["textAdminId"];
string conferenceId=request.Params["textConferenceId"];
string createrId=request.Params["textCreaterId"];
string maxUserNo=request.Params["textMaxUserNo"];
string password=request.Params["textPassword"];
string reserBeginTime=request.Params["textReserBeginTime"];
string reserDurationTime=request.Params["textReserDurationTime"];
string reserEndTime=request.Params["textReserEndTime"];
string updateTime=request.Params["textUpdateTime"];
CriterionAndOrder conferenceCriterionAndOrder = new CriterionAndOrder();
conferenceCriterionAndOrder.CriteriaName = typeof(Conference).FullName;
conferenceCriterionAndOrder.CriteriaAsName = "C";
conferenceCriterionAndOrder.OrderList.Add(new Order("C.AddTime", false));
CriterionAndOrder systemUserCriterionAndOrder = new CriterionAndOrder();
systemUserCriterionAndOrder.CriteriaName ="AdminRef" ;
systemUserCriterionAndOrder.CriteriaAsName = "SU";
systemUserCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder systemUserCriterionAndOrder = new CriterionAndOrder();
systemUserCriterionAndOrder.CriteriaName ="CreaterRef" ;
systemUserCriterionAndOrder.CriteriaAsName = "SU";
systemUserCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(actualBeginTime))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ActualBeginTime", Convert.ToDateTime(actualBeginTime)));
if (!String.IsNullOrEmpty(actualDurationTime))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ActualDurationTime", Convert.ToInt32(actualDurationTime)));
if (!String.IsNullOrEmpty(actualEndTime))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ActualEndTime", Convert.ToDateTime(actualEndTime)));
if (!String.IsNullOrEmpty(actualUserNo))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ActualUserNo", Convert.ToInt32(actualUserNo)));
if (!String.IsNullOrEmpty(addTime))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(adminId))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.AdminId", adminId));
if (!String.IsNullOrEmpty(conferenceId))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ConferenceId", conferenceId));
if (!String.IsNullOrEmpty(createrId))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.CreaterId", createrId));
if (!String.IsNullOrEmpty(maxUserNo))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.MaxUserNo", Convert.ToInt32(maxUserNo)));
if (!String.IsNullOrEmpty(password))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.Password", password));
if (!String.IsNullOrEmpty(reserBeginTime))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ReserBeginTime", Convert.ToDateTime(reserBeginTime)));
if (!String.IsNullOrEmpty(reserDurationTime))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ReserDurationTime", reserDurationTime));
if (!String.IsNullOrEmpty(reserEndTime))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ReserEndTime", Convert.ToDateTime(reserEndTime)));
if (!String.IsNullOrEmpty(updateTime))
conferenceCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.UpdateTime", Convert.ToDateTime(updateTime)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("C.ConferenceId").As("PrimaryKey"));
pList.Add(Projections.Property("C.ActualBeginTime").As("ActualBeginTime"));
pList.Add(Projections.Property("C.ActualDurationTime").As("ActualDurationTime"));
pList.Add(Projections.Property("C.ActualEndTime").As("ActualEndTime"));
pList.Add(Projections.Property("C.ActualUserNo").As("ActualUserNo"));
pList.Add(Projections.Property("C.AddTime").As("AddTime"));
pList.Add(Projections.Property("SU.UserId").As("AdminId"));
pList.Add(Projections.Property("C.ConferenceId").As("ConferenceId"));
pList.Add(Projections.Property("SU.UserId").As("CreaterId"));
pList.Add(Projections.Property("C.MaxUserNo").As("MaxUserNo"));
pList.Add(Projections.Property("C.Password").As("Password"));
pList.Add(Projections.Property("C.ReserBeginTime").As("ReserBeginTime"));
pList.Add(Projections.Property("C.ReserDurationTime").As("ReserDurationTime"));
pList.Add(Projections.Property("C.ReserEndTime").As("ReserEndTime"));
pList.Add(Projections.Property("C.UpdateTime").As("UpdateTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(Conference);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(conferenceCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(systemUserCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(systemUserCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = ConferenceBll.GetConferenceList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling=NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 根据查询条件获取CardUser表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>查询结果，封装了查询的数据信息</returns>
public static ResultModel GetCardUserList(QueryTerms queryTerms)
{
List<CardUser> cardUserList = new List<CardUser>();
OperationLog log = new OperationLog();
int totalCount = 0;
ResultModel result = new ResultModel();
try
{
log.AddTime = DateTime.Now;
log.IsSuccessId = SymbolicConstant.ISSUCCESS_TRUE;
log.OperationLogId = System.Guid.NewGuid().ToString("N");
log.OperationContent = SymbolicConstant.OPERATIONCONTENT_GETLIST;
log.OperationTable = typeof(CardUser).Name;
log.OperationTypeCode =SymbolicConstant.OPERATIONTYPE_GETLIST;
log.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_SUCCESS;
log.ResultMessage=SymbolicConstant.RESULTMESSAGE_GETLIST_SUCCESS;
log.UserId = CurrentSession.getUser().UserId;
cardUserList = (List<CardUser>)(CardUserDal.GetList(queryTerms));
totalCount=Convert.ToInt32(SystemUserDal.GetTotalCount(queryTerms));
log.TotalCount = totalCount;
result.Data = cardUserList;
result.DataSize = totalCount;
result.IsSuccess = true;
result.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_SUCCESS;
result.ResultMessage = SymbolicConstant.RESULTMESSAGE_GETLIST_SUCCESS;
return result;
}
catch (Exception exception)
{
log.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_ERROR;
log.IsSuccessId = SymbolicConstant.ISSUCCESS_FALSE;
log.ResultMessage=exception.Message;
result.IsSuccess = false;
result.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_ERROR;
result.ResultMessage = exception.Message;
return result;
}
finally
{
OperationLogBll.Insert(log);
}
}
/// <summary> /// Indicates whether this query includes any of the specified terms /// </summary> public bool HasAny(QueryTerms terms) => (ActiveTerms & terms) != 0;
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime=request.Params["textAddTime"];
string description=request.Params["textDescription"];
string imageId=request.Params["textImageId"];
string patientId=request.Params["textPatientId"];
string type=request.Params["textType"];
string updateTime=request.Params["textUpdateTime"];
string url=request.Params["textUrl"];
CriterionAndOrder digitalImageCriterionAndOrder = new CriterionAndOrder();
digitalImageCriterionAndOrder.CriteriaName = typeof(DigitalImage).FullName;
digitalImageCriterionAndOrder.CriteriaAsName = "DI";
digitalImageCriterionAndOrder.OrderList.Add(new Order("DI.AddTime", false));
if (!String.IsNullOrEmpty(addTime))
digitalImageCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DI.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(description))
digitalImageCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DI.Description", description));
if (!String.IsNullOrEmpty(imageId))
digitalImageCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DI.ImageId", imageId));
if (!String.IsNullOrEmpty(patientId))
digitalImageCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DI.PatientId", patientId));
if (!String.IsNullOrEmpty(type))
digitalImageCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DI.Type", type));
if (!String.IsNullOrEmpty(updateTime))
digitalImageCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DI.UpdateTime", Convert.ToDateTime(updateTime)));
if (!String.IsNullOrEmpty(url))
digitalImageCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DI.Url", url));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("DI.ImageId").As("PrimaryKey"));
pList.Add(Projections.Property("DI.AddTime").As("AddTime"));
pList.Add(Projections.Property("DI.Description").As("Description"));
pList.Add(Projections.Property("DI.ImageId").As("ImageId"));
pList.Add(Projections.Property("DI.PatientId").As("PatientId"));
pList.Add(Projections.Property("DI.Type").As("Type"));
pList.Add(Projections.Property("DI.UpdateTime").As("UpdateTime"));
pList.Add(Projections.Property("DI.Url").As("Url"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(DigitalImage);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(digitalImageCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = DigitalImageBll.GetDigitalImageList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling=NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string actualDoctorId=request.Params["textActualDoctorId"];
string actualDoctorId2=request.Params["textActualDoctorId2"];
string actualDoctorId3=request.Params["textActualDoctorId3"];
string actualDoctorId4=request.Params["textActualDoctorId4"];
string addTime=request.Params["textAddTime"];
string arrangeConTime=request.Params["textArrangeConTime"];
string beginConTime=request.Params["textBeginConTime"];
string callerId=request.Params["textCallerId"];
string cancelConResult=request.Params["textCancelConResult"];
string chargeType=request.Params["textChargeType"];
string conFile=request.Params["textConFile"];
string conObjective=request.Params["textConObjective"];
string consulationMode=request.Params["textConsulationMode"];
string consulationType=request.Params["textConsulationType"];
string consultationId=request.Params["textConsultationId"];
string consultationStatus=request.Params["textConsultationStatus"];
string description=request.Params["textDescription"];
string diagnosis=request.Params["textDiagnosis"];
string diagnosisFile=request.Params["textDiagnosisFile"];
string endConTime=request.Params["textEndConTime"];
string itemId=request.Params["textItemId"];
string notPassResult=request.Params["textNotPassResult"];
string processRequestTime=request.Params["textProcessRequestTime"];
string receiverId=request.Params["textReceiverId"];
string requestDoctorId=request.Params["textRequestDoctorId"];
string requestDoctorId2=request.Params["textRequestDoctorId2"];
string requestDoctorId3=request.Params["textRequestDoctorId3"];
string requestDoctorId4=request.Params["textRequestDoctorId4"];
string requestTime=request.Params["textRequestTime"];
string roomId=request.Params["textRoomId"];
string sectionOfficeId=request.Params["textSectionOfficeId"];
string updateTime=request.Params["textUpdateTime"];
CriterionAndOrder consultationCriterionAndOrder = new CriterionAndOrder();
consultationCriterionAndOrder.CriteriaName = typeof(Consultation).FullName;
consultationCriterionAndOrder.CriteriaAsName = "C";
consultationCriterionAndOrder.OrderList.Add(new Order("C.AddTime", false));
CriterionAndOrder serviceItemCriterionAndOrder = new CriterionAndOrder();
serviceItemCriterionAndOrder.CriteriaName ="ItemRef" ;
serviceItemCriterionAndOrder.CriteriaAsName = "SI";
serviceItemCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder consultationRoomCriterionAndOrder = new CriterionAndOrder();
consultationRoomCriterionAndOrder.CriteriaName ="RoomRef" ;
consultationRoomCriterionAndOrder.CriteriaAsName = "CR";
consultationRoomCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(actualDoctorId))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ActualDoctorId", actualDoctorId));
if (!String.IsNullOrEmpty(actualDoctorId2))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ActualDoctorId2", actualDoctorId2));
if (!String.IsNullOrEmpty(actualDoctorId3))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ActualDoctorId3", actualDoctorId3));
if (!String.IsNullOrEmpty(actualDoctorId4))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ActualDoctorId4", actualDoctorId4));
if (!String.IsNullOrEmpty(addTime))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(arrangeConTime))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ArrangeConTime", Convert.ToDateTime(arrangeConTime)));
if (!String.IsNullOrEmpty(beginConTime))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.BeginConTime", Convert.ToDateTime(beginConTime)));
if (!String.IsNullOrEmpty(callerId))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.CallerId", callerId));
if (!String.IsNullOrEmpty(cancelConResult))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.CancelConResult", cancelConResult));
if (!String.IsNullOrEmpty(chargeType))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ChargeType", chargeType));
if (!String.IsNullOrEmpty(conFile))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ConFile", conFile));
if (!String.IsNullOrEmpty(conObjective))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ConObjective", conObjective));
if (!String.IsNullOrEmpty(consulationMode))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ConsulationMode", consulationMode));
if (!String.IsNullOrEmpty(consulationType))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ConsulationType", consulationType));
if (!String.IsNullOrEmpty(consultationId))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ConsultationId", consultationId));
if (!String.IsNullOrEmpty(consultationStatus))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ConsultationStatus", consultationStatus));
if (!String.IsNullOrEmpty(description))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.Description", description));
if (!String.IsNullOrEmpty(diagnosis))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.Diagnosis", diagnosis));
if (!String.IsNullOrEmpty(diagnosisFile))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.DiagnosisFile", diagnosisFile));
if (!String.IsNullOrEmpty(endConTime))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.EndConTime", Convert.ToDateTime(endConTime)));
if (!String.IsNullOrEmpty(itemId))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ItemId", itemId));
if (!String.IsNullOrEmpty(notPassResult))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.NotPassResult", notPassResult));
if (!String.IsNullOrEmpty(processRequestTime))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ProcessRequestTime", Convert.ToDateTime(processRequestTime)));
if (!String.IsNullOrEmpty(receiverId))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.ReceiverId", receiverId));
if (!String.IsNullOrEmpty(requestDoctorId))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.RequestDoctorId", requestDoctorId));
if (!String.IsNullOrEmpty(requestDoctorId2))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.RequestDoctorId2", requestDoctorId2));
if (!String.IsNullOrEmpty(requestDoctorId3))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.RequestDoctorId3", requestDoctorId3));
if (!String.IsNullOrEmpty(requestDoctorId4))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.RequestDoctorId4", requestDoctorId4));
if (!String.IsNullOrEmpty(requestTime))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.RequestTime", Convert.ToDateTime(requestTime)));
if (!String.IsNullOrEmpty(roomId))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.RoomId", roomId));
if (!String.IsNullOrEmpty(sectionOfficeId))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.SectionOfficeId", sectionOfficeId));
if (!String.IsNullOrEmpty(updateTime))
consultationCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.UpdateTime", Convert.ToDateTime(updateTime)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("C.ConsultationId").As("PrimaryKey"));
pList.Add(Projections.Property("C.ActualDoctorId").As("ActualDoctorId"));
pList.Add(Projections.Property("C.ActualDoctorId2").As("ActualDoctorId2"));
pList.Add(Projections.Property("C.ActualDoctorId3").As("ActualDoctorId3"));
pList.Add(Projections.Property("C.ActualDoctorId4").As("ActualDoctorId4"));
pList.Add(Projections.Property("C.AddTime").As("AddTime"));
pList.Add(Projections.Property("C.ArrangeConTime").As("ArrangeConTime"));
pList.Add(Projections.Property("C.BeginConTime").As("BeginConTime"));
pList.Add(Projections.Property("C.CallerId").As("CallerId"));
pList.Add(Projections.Property("C.CancelConResult").As("CancelConResult"));
pList.Add(Projections.Property("C.ChargeType").As("ChargeType"));
pList.Add(Projections.Property("C.ConFile").As("ConFile"));
pList.Add(Projections.Property("C.ConObjective").As("ConObjective"));
pList.Add(Projections.Property("C.ConsulationMode").As("ConsulationMode"));
pList.Add(Projections.Property("C.ConsulationType").As("ConsulationType"));
pList.Add(Projections.Property("C.ConsultationId").As("ConsultationId"));
pList.Add(Projections.Property("C.ConsultationStatus").As("ConsultationStatus"));
pList.Add(Projections.Property("C.Description").As("Description"));
pList.Add(Projections.Property("C.Diagnosis").As("Diagnosis"));
pList.Add(Projections.Property("C.DiagnosisFile").As("DiagnosisFile"));
pList.Add(Projections.Property("C.EndConTime").As("EndConTime"));
pList.Add(Projections.Property("SI.ItemId").As("ItemId"));
pList.Add(Projections.Property("C.NotPassResult").As("NotPassResult"));
pList.Add(Projections.Property("C.ProcessRequestTime").As("ProcessRequestTime"));
pList.Add(Projections.Property("C.ReceiverId").As("ReceiverId"));
pList.Add(Projections.Property("C.RequestDoctorId").As("RequestDoctorId"));
pList.Add(Projections.Property("C.RequestDoctorId2").As("RequestDoctorId2"));
pList.Add(Projections.Property("C.RequestDoctorId3").As("RequestDoctorId3"));
pList.Add(Projections.Property("C.RequestDoctorId4").As("RequestDoctorId4"));
pList.Add(Projections.Property("C.RequestTime").As("RequestTime"));
pList.Add(Projections.Property("CR.RoomId").As("RoomId"));
pList.Add(Projections.Property("C.SectionOfficeId").As("SectionOfficeId"));
pList.Add(Projections.Property("C.UpdateTime").As("UpdateTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(Consultation);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(consultationCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(serviceItemCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(consultationRoomCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = ConsultationBll.GetConsultationList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling=NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 根据查询条件获取ConferenceMember表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>实体列表</returns>
public static IList<ConferenceMember> GetList(QueryTerms queryTerms)
{
return DataAccessUtility.GetList<ConferenceMember>(queryTerms);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime=request.Params["textAddTime"];
string cardTypeId=request.Params["textCardTypeId"];
string description=request.Params["textDescription"];
string expense=request.Params["textExpense"];
string name=request.Params["textName"];
string updateTime=request.Params["textUpdateTime"];
string validityDate=request.Params["textValidityDate"];
string validityTime=request.Params["textValidityTime"];
CriterionAndOrder cardTypeCriterionAndOrder = new CriterionAndOrder();
cardTypeCriterionAndOrder.CriteriaName = typeof(CardType).FullName;
cardTypeCriterionAndOrder.CriteriaAsName = "CT";
cardTypeCriterionAndOrder.OrderList.Add(new Order("CT.AddTime", false));
if (!String.IsNullOrEmpty(addTime))
cardTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CT.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(cardTypeId))
cardTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CT.CardTypeId", cardTypeId));
if (!String.IsNullOrEmpty(description))
cardTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CT.Description", description));
if (!String.IsNullOrEmpty(expense))
cardTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CT.Expense", expense));
if (!String.IsNullOrEmpty(name))
cardTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CT.Name", name));
if (!String.IsNullOrEmpty(updateTime))
cardTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CT.UpdateTime", Convert.ToDateTime(updateTime)));
if (!String.IsNullOrEmpty(validityDate))
cardTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CT.ValidityDate", Convert.ToDateTime(validityDate)));
if (!String.IsNullOrEmpty(validityTime))
cardTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CT.ValidityTime", validityTime));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("CT.CardTypeId").As("PrimaryKey"));
pList.Add(Projections.Property("CT.AddTime").As("AddTime"));
pList.Add(Projections.Property("CT.CardTypeId").As("CardTypeId"));
pList.Add(Projections.Property("CT.Description").As("Description"));
pList.Add(Projections.Property("CT.Expense").As("Expense"));
pList.Add(Projections.Property("CT.Name").As("Name"));
pList.Add(Projections.Property("CT.UpdateTime").As("UpdateTime"));
pList.Add(Projections.Property("CT.ValidityDate").As("ValidityDate"));
pList.Add(Projections.Property("CT.ValidityTime").As("ValidityTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(CardType);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(cardTypeCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = CardTypeBll.GetCardTypeList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling=NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
//keywords是处理AutoComplete下接框查询时设置的传入参数
string keywords = request.Params["keywords"];
string pageName = request.Params["textPageName"];
string url = request.Params["textUrl"];
List<ICriterion> criterionList = new List<ICriterion>();
if (!String.IsNullOrEmpty(pageName))
criterionList.Add(Restrictions.Like("PageName", "%" + pageName + "%"));
if (!String.IsNullOrEmpty(url))
criterionList.Add(Restrictions.Like("Url", "%" + url + "%"));
if (!String.IsNullOrEmpty(keywords))
criterionList.Add(Restrictions.Like("Url", "%" + keywords + "%"));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("PageId").As("PrimaryKey"));
pList.Add(Projections.Property("PageId").As("PageId"));
pList.Add(Projections.Property("PageName").As("PageName"));
pList.Add(Projections.Property("Url").As("Url"));
pList.Add(Projections.Property("AddTime").As("AddTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(WebPage);
queryTerms.ColumnList = pList;
queryTerms.CriterionList = criterionList;
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
queryTerms.OrderList.Add(new Order("Url", false));
ResultModel result = WebPageBll.GetWebPageList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result);
response.Write(jsonString);
}
protected bool IfHavePage(string url)
{
List<ICriterion> criterionList = new List<ICriterion>();
criterionList.Add(Restrictions.Eq("Url", url));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(WebPage);
queryTerms.CriterionList = criterionList;
queryTerms.OrderList.Add(new Order("AddTime", false));
ResultModel result = WebPageBll.GetWebPageList(queryTerms);
List<WebPage> list = (List<WebPage>)result.Data;
if (list.Count == 0)
return false;
return true;
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext contenxt = HttpContext.Current;
HttpRequest request = contenxt.Request;
HttpResponse response = contenxt.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string userName = request.Params["textUserName"];
string realName = request.Params["textRealName"];
string beginAddTime = request.Params["textBeginAddTime"];
string endAddTime = request.Params["textEndAddTime"];
string onlineFlagId = request.Params["selectOnlineFlag"];
CriterionAndOrder systemUserCriterionAndOrder = new CriterionAndOrder();
systemUserCriterionAndOrder.CriteriaName = typeof(SystemUser).FullName;
systemUserCriterionAndOrder.CriteriaAsName = "SU";
systemUserCriterionAndOrder.OrderList.Add(new Order("SU.AddTime", false));
if (!String.IsNullOrEmpty(userName))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Like("SU.UserName", "%" + userName + "%"));
if (!String.IsNullOrEmpty(realName))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Like("SU.RealName", "%" + realName + "%"));
if (!String.IsNullOrEmpty(beginAddTime))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Gt("SU.AddTime", Convert.ToDateTime(beginAddTime)));
if (!String.IsNullOrEmpty(endAddTime))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Lt("SU.AddTime", Convert.ToDateTime(endAddTime)));
if (!String.IsNullOrEmpty(onlineFlagId))
systemUserCriterionAndOrder.CriterionList.Add(Restrictions.Eq("SU.OnlineFlagId", Convert.ToChar(onlineFlagId)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("SU.GenderName").As("GenderName"));
pList.Add(Projections.Property("SU.OnlineFlagName").As("OnlineFlagName"));
pList.Add(Projections.Property("SU.UserId").As("UserId"));
pList.Add(Projections.Property("SU.UserId").As("PrimaryKey"));
pList.Add(Projections.Property("SU.UserName").As("UserName"));
pList.Add(Projections.Property("SU.RealName").As("RealName"));
pList.Add(Projections.Property("SU.AddTime").As("AddTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(SystemUser);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(systemUserCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = SystemUserBll.GetSystemUserList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime=request.Params["textAddTime"];
string chiefComplaint=request.Params["textChiefComplaint"];
string confirmedDiagnostic=request.Params["textConfirmedDiagnostic"];
string consumerId=request.Params["textConsumerId"];
string description=request.Params["textDescription"];
string historyPresentIllness=request.Params["textHistoryPresentIllness"];
string inHospitalDiagnostic=request.Params["textInHospitalDiagnostic"];
string phyExamNum=request.Params["textPhyExamNum"];
string physicalExam=request.Params["textPhysicalExam"];
string physicalExamDate=request.Params["textPhysicalExamDate"];
string recordId=request.Params["textRecordId"];
string representor=request.Params["textRepresentor"];
string updateTime=request.Params["textUpdateTime"];
CriterionAndOrder medicalRecordCriterionAndOrder = new CriterionAndOrder();
medicalRecordCriterionAndOrder.CriteriaName = typeof(MedicalRecord).FullName;
medicalRecordCriterionAndOrder.CriteriaAsName = "MR";
medicalRecordCriterionAndOrder.OrderList.Add(new Order("MR.AddTime", false));
CriterionAndOrder consumerCriterionAndOrder = new CriterionAndOrder();
consumerCriterionAndOrder.CriteriaName ="ConsumerRef" ;
consumerCriterionAndOrder.CriteriaAsName = "C";
consumerCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(addTime))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(chiefComplaint))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.ChiefComplaint", chiefComplaint));
if (!String.IsNullOrEmpty(confirmedDiagnostic))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.ConfirmedDiagnostic", confirmedDiagnostic));
if (!String.IsNullOrEmpty(consumerId))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.ConsumerId", consumerId));
if (!String.IsNullOrEmpty(description))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.Description", description));
if (!String.IsNullOrEmpty(historyPresentIllness))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.HistoryPresentIllness", historyPresentIllness));
if (!String.IsNullOrEmpty(inHospitalDiagnostic))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.InHospitalDiagnostic", inHospitalDiagnostic));
if (!String.IsNullOrEmpty(phyExamNum))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.PhyExamNum", phyExamNum));
if (!String.IsNullOrEmpty(physicalExam))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.PhysicalExam", physicalExam));
if (!String.IsNullOrEmpty(physicalExamDate))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.PhysicalExamDate", Convert.ToDateTime(physicalExamDate)));
if (!String.IsNullOrEmpty(recordId))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.RecordId", recordId));
if (!String.IsNullOrEmpty(representor))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.Representor", representor));
if (!String.IsNullOrEmpty(updateTime))
medicalRecordCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MR.UpdateTime", Convert.ToDateTime(updateTime)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("MR.RecordId").As("PrimaryKey"));
pList.Add(Projections.Property("MR.AddTime").As("AddTime"));
pList.Add(Projections.Property("MR.ChiefComplaint").As("ChiefComplaint"));
pList.Add(Projections.Property("MR.ConfirmedDiagnostic").As("ConfirmedDiagnostic"));
pList.Add(Projections.Property("C.ConsumerId").As("ConsumerId"));
pList.Add(Projections.Property("MR.Description").As("Description"));
pList.Add(Projections.Property("MR.HistoryPresentIllness").As("HistoryPresentIllness"));
pList.Add(Projections.Property("MR.InHospitalDiagnostic").As("InHospitalDiagnostic"));
pList.Add(Projections.Property("MR.PhyExamNum").As("PhyExamNum"));
pList.Add(Projections.Property("MR.PhysicalExam").As("PhysicalExam"));
pList.Add(Projections.Property("MR.PhysicalExamDate").As("PhysicalExamDate"));
pList.Add(Projections.Property("MR.RecordId").As("RecordId"));
pList.Add(Projections.Property("MR.Representor").As("Representor"));
pList.Add(Projections.Property("MR.UpdateTime").As("UpdateTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(MedicalRecord);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(medicalRecordCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(consumerCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = MedicalRecordBll.GetMedicalRecordList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling=NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 根据查询条件获取ServiceItem表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>实体列表</returns>
public static IList<ServiceItem> GetList(QueryTerms queryTerms)
{
return DataAccessUtility.GetList<ServiceItem>(queryTerms);
}
/// <summary>
/// 根据查询条件获取符合查询条件的总记录数
/// </summary>
/// <param name="queryTerms">封装的查询条件</param>
/// <returns>总记录数</returns>
public static object GetTotalCount(QueryTerms queryTerms)
{
return DataAccessUtility.GetTotalCount(queryTerms);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string fartherId = request.Params["selectFartherId"];
string name = request.Params["textName"];
string officeLevel = request.Params["selectOfficeLevel"];
CriterionAndOrder hospitalSectionOfficeCriterionAndOrder = new CriterionAndOrder();
hospitalSectionOfficeCriterionAndOrder.CriteriaName = typeof(HospitalSectionOffice).FullName;
hospitalSectionOfficeCriterionAndOrder.CriteriaAsName = "HSO";
hospitalSectionOfficeCriterionAndOrder.OrderList.Add(new Order("HSO.OfficeLevel", true));
hospitalSectionOfficeCriterionAndOrder.OrderList.Add(new Order("HSO.Name", true));
if (!String.IsNullOrEmpty(fartherId))
hospitalSectionOfficeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("HSO.FartherId", fartherId));
if (!String.IsNullOrEmpty(name))
hospitalSectionOfficeCriterionAndOrder.CriterionList.Add(Restrictions.Like("HSO.Name", "%" + name + "%"));
if (!String.IsNullOrEmpty(officeLevel))
hospitalSectionOfficeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("HSO.OfficeLevel", officeLevel));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("HSO.SectOffId").As("PrimaryKey"));
pList.Add(Projections.Property("HSO.AddTime").As("AddTime"));
pList.Add(Projections.Property("HSO.FartherId").As("FartherId"));
pList.Add(Projections.Property("HSO.Name").As("Name"));
pList.Add(Projections.Property("HSO.OfficeLevel").As("OfficeLevel"));
pList.Add(Projections.Property("HSO.SectOffId").As("SectOffId"));
pList.Add(Projections.Property("HSO.OfficeLevelName").As("OfficeLevelName"));
pList.Add(Projections.Property("HSO.FartherIdName").As("FartherIdName"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(HospitalSectionOffice);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(hospitalSectionOfficeCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = HospitalSectionOfficeBll.GetHospitalSectionOfficeList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 根据角色查询相应功能模块
/// </summary>
protected void GetModuleListByRole()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string roleId= request.Params["roleId"];
CriterionAndOrder moduleCriterionAndOrder = new CriterionAndOrder();
moduleCriterionAndOrder.CriteriaName = typeof(FunctionModule).FullName;
moduleCriterionAndOrder.CriteriaAsName = "FE";
CriterionAndOrder roleCriterionAndOrder = new CriterionAndOrder();
roleCriterionAndOrder.CriteriaName = "Role";
roleCriterionAndOrder.CriteriaAsName = "RO";
roleCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.InnerJoin;
if (!String.IsNullOrEmpty(roleId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("RO.RoleId", roleId));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("FE.ModuleId").As("ModuleId"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(FunctionModule);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(moduleCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(roleCriterionAndOrder);
ResultModel result = FunctionModuleBll.GetFunctionModuleList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime = request.Params["textAddTime"];
string description = request.Params["textDescription"];
string isPublic = request.Params["textIsPublic"];
string moduleId = request.Params["textModuleId"];
string moduleLevelId = request.Params["selectModuleLevelId"];
string moduleName = request.Params["textModuleName"];
string parentModuleId = request.Params["selectParentModuleId"];
string sortFieldId = request.Params["textSortFieldId"];
string order = request.Params["order"];
CriterionAndOrder moduleCriterionAndOrder = new CriterionAndOrder();
moduleCriterionAndOrder.CriteriaName = typeof(FunctionModule).FullName;
moduleCriterionAndOrder.CriteriaAsName = "FM";
if (!String.IsNullOrEmpty(order))
moduleCriterionAndOrder.OrderList.Add(new Order(order, false));
else
moduleCriterionAndOrder.OrderList.Add(new Order("FM.SortFieldId", true));
CriterionAndOrder parentModuleCriterionAndOrder = new CriterionAndOrder();
parentModuleCriterionAndOrder.CriteriaName = "ParentModuleRef";
parentModuleCriterionAndOrder.CriteriaAsName = "PF";
parentModuleCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
parentModuleCriterionAndOrder.OrderList.Add(new Order("PF.SortFieldId", true));
if (!String.IsNullOrEmpty(addTime))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.AddTime", addTime));
if (!String.IsNullOrEmpty(description))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.Description", description));
if (!String.IsNullOrEmpty(isPublic))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.IsPublicId", isPublic));
if (!String.IsNullOrEmpty(moduleId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.ModuleId", moduleId));
if (!String.IsNullOrEmpty(moduleLevelId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.ModuleLevelId", Convert.ToInt32(moduleLevelId)));
if (!String.IsNullOrEmpty(moduleName))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Like("FM.ModuleName", "%" + moduleName + "%"));
if (!String.IsNullOrEmpty(parentModuleId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.ParentModuleId", parentModuleId));
if (!String.IsNullOrEmpty(sortFieldId))
moduleCriterionAndOrder.CriterionList.Add(Restrictions.Eq("FM.SortFieldId", sortFieldId));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("FM.ModuleId").As("ModuleId"));
pList.Add(Projections.Property("FM.ModuleId").As("PrimaryKey"));
pList.Add(Projections.Property("FM.ModuleName").As("ModuleName"));
pList.Add(Projections.Property("FM.UpdateTime").As("UpdateTime"));
pList.Add(Projections.Property("FM.AddTime").As("AddTime"));
pList.Add(Projections.Property("FM.ModuleLevelId").As("ModuleLevelId"));
pList.Add(Projections.Property("FM.ModuleLevelName").As("ModuleLevelName"));
pList.Add(Projections.Property("PF.ModuleId").As("ParentModuleId"));
pList.Add(Projections.Property("PF.ModuleName").As("ParentModuleName"));
pList.Add(Projections.Property("FM.SortFieldId").As("SortFieldId"));
pList.Add(Projections.Property("FM.SortFieldName").As("SortFieldName"));
pList.Add(Projections.Property("FM.IsPublicId").As("IsPublicId"));
pList.Add(Projections.Property("FM.IsPublicName").As("IsPublicName"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(FunctionModule);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(moduleCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(parentModuleCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = FunctionModuleBll.GetFunctionModuleList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 根据查询条件获取ConsultationDigitalImage表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>实体列表</returns>
public static IList<ConsultationDigitalImage> GetList(QueryTerms queryTerms)
{
return DataAccessUtility.GetList<ConsultationDigitalImage>(queryTerms);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime=request.Params["textAddTime"];
string cardId=request.Params["textCardId"];
string cardTypeId=request.Params["textCardTypeId"];
string description=request.Params["textDescription"];
string updateTime=request.Params["textUpdateTime"];
CriterionAndOrder membershipCardCriterionAndOrder = new CriterionAndOrder();
membershipCardCriterionAndOrder.CriteriaName = typeof(MembershipCard).FullName;
membershipCardCriterionAndOrder.CriteriaAsName = "MC";
membershipCardCriterionAndOrder.OrderList.Add(new Order("MC.AddTime", false));
CriterionAndOrder cardTypeCriterionAndOrder = new CriterionAndOrder();
cardTypeCriterionAndOrder.CriteriaName ="CardTypeRef" ;
cardTypeCriterionAndOrder.CriteriaAsName = "CT";
cardTypeCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(addTime))
membershipCardCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MC.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(cardId))
membershipCardCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MC.CardId", cardId));
if (!String.IsNullOrEmpty(cardTypeId))
membershipCardCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MC.CardTypeId", cardTypeId));
if (!String.IsNullOrEmpty(description))
membershipCardCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MC.Description", description));
if (!String.IsNullOrEmpty(updateTime))
membershipCardCriterionAndOrder.CriterionList.Add(Restrictions.Eq("MC.UpdateTime", Convert.ToDateTime(updateTime)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("MC.CardId").As("PrimaryKey"));
pList.Add(Projections.Property("MC.AddTime").As("AddTime"));
pList.Add(Projections.Property("MC.CardId").As("CardId"));
pList.Add(Projections.Property("CT.CardTypeId").As("CardTypeId"));
pList.Add(Projections.Property("MC.Description").As("Description"));
pList.Add(Projections.Property("MC.UpdateTime").As("UpdateTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(MembershipCard);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(membershipCardCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(cardTypeCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = MembershipCardBll.GetMembershipCardList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling=NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 根据查询条件获取CardUser表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>实体列表</returns>
public static IList<CardUser> GetList(QueryTerms queryTerms)
{
return DataAccessUtility.GetList<CardUser>(queryTerms);
}
/// <summary>
/// 根据查询条件获取HospitalExpert表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>实体列表</returns>
public static IList<HospitalExpert> GetList(QueryTerms queryTerms)
{
return DataAccessUtility.GetList<HospitalExpert>(queryTerms);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime = request.Params["textAddTime"];
string code = request.Params["textCode"];
string description = request.Params["textDescription"];
string id = request.Params["textId"];
string name = request.Params["textName"];
string typeName = request.Params["textTypeName"];
string updateTime = request.Params["textUpdateTime"];
string typeId = request.Params["textTypeId"];
CriterionAndOrder dictionaryCriterionAndOrder = new CriterionAndOrder();
dictionaryCriterionAndOrder.CriteriaName = typeof(Dictionary).FullName;
dictionaryCriterionAndOrder.CriteriaAsName = "D";
dictionaryCriterionAndOrder.OrderList.Add(new Order("D.TypeId", true));
dictionaryCriterionAndOrder.OrderList.Add(new Order("D.Code", true));
CriterionAndOrder dictionaryTypeCriterionAndOrder = new CriterionAndOrder();
dictionaryTypeCriterionAndOrder.CriteriaName = "TypeRef";
dictionaryTypeCriterionAndOrder.CriteriaAsName = "DT";
dictionaryTypeCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(addTime))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Gt("D.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(code))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Eq("D.Code", Convert.ToChar(code)));
if (!String.IsNullOrEmpty(description))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Like("D.Description", "%" + description + "%"));
if (!String.IsNullOrEmpty(id))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Eq("D.Id", id));
if (!String.IsNullOrEmpty(name))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Like("D.Name", "%" + name + "%"));
if (!String.IsNullOrEmpty(typeId))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Eq("D.TypeId", typeId));
if (!String.IsNullOrEmpty(typeName))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Like("DT.Name", "%" + typeName + "%"));
if (!String.IsNullOrEmpty(updateTime))
dictionaryCriterionAndOrder.CriterionList.Add(Restrictions.Gt("D.UpdateTime", Convert.ToDateTime(updateTime)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("D.Id").As("PrimaryKey"));
pList.Add(Projections.Property("D.AddTime").As("AddTime"));
pList.Add(Projections.Property("D.Code").As("Code"));
pList.Add(Projections.Property("D.Description").As("Description"));
pList.Add(Projections.Property("D.Id").As("Id"));
pList.Add(Projections.Property("D.Name").As("Name"));
pList.Add(Projections.Property("DT.Id").As("TypeId"));
pList.Add(Projections.Property("DT.Name").As("TypeName"));
pList.Add(Projections.Property("D.UpdateTime").As("UpdateTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(Dictionary);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(dictionaryCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(dictionaryTypeCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = DictionaryBll.GetDictionaryList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary> /// Indicates whether this query includes anything outside of the specified terms /// </summary> public bool HasAtMost(QueryTerms terms) => (ActiveTerms & ~terms) == 0;
/// <summary>
/// 根据查询条件获取RoleRight表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>实体列表</returns>
public static IList<RoleRight> GetList(QueryTerms queryTerms)
{
return DataAccessUtility.GetList<RoleRight>(queryTerms);
}
/// <summary>
/// 根据查询条件获取CardUser表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <param name="isLog">是否写入日志</param>
/// <returns>查询结果，封装了查询的数据信息</returns>
public static ResultModel GetCardUserList(QueryTerms queryTerms, bool isLog)
{
if (isLog)
return GetCardUserList(queryTerms);
List<CardUser> cardUserList = new List<CardUser>();
int totalCount = 0;
ResultModel result = new ResultModel();
try
{
cardUserList = (List<CardUser>)(CardUserDal.GetList(queryTerms));
totalCount=Convert.ToInt32(SystemUserDal.GetTotalCount(queryTerms));
result.Data = cardUserList;
result.DataSize = totalCount;
result.IsSuccess = true;
result.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_SUCCESS;
result.ResultMessage = SymbolicConstant.RESULTMESSAGE_GETLIST_SUCCESS;
return result;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ResultCode = SymbolicConstant.RESULTCODE_GETLIST_ERROR;
result.ResultMessage = exception.Message;
return result;
}
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string beginAddTime = request.Params["textBeginAddTime"];
string endAddTime = request.Params["textEndAddTime"];
string isSuccessId = request.Params["textIsSuccessId"];
string operationTable = request.Params["textOperationTable"];
string operationTypeCode = request.Params["selectOperationTypeCode"];
string resultCode = request.Params["textResultCode"];
string systemUserName = request.Params["textSystemUserName"];
CriterionAndOrder operationLogCriterionAndOrder = new CriterionAndOrder();
operationLogCriterionAndOrder.CriteriaName = typeof(OperationLog).FullName;
operationLogCriterionAndOrder.CriteriaAsName = "OL";
operationLogCriterionAndOrder.OrderList.Add(new Order("OL.AddTime", false));
CriterionAndOrder conLogCriterionAndOrder = new CriterionAndOrder();
conLogCriterionAndOrder.CriteriaName = "ConLogRef";
conLogCriterionAndOrder.CriteriaAsName = "CL";
conLogCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder systemUserCriterionAndOrder = new CriterionAndOrder();
systemUserCriterionAndOrder.CriteriaName = "SystemUserRef";
systemUserCriterionAndOrder.CriteriaAsName = "SU";
systemUserCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(beginAddTime))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Gt("OL.AddTime", Convert.ToDateTime(beginAddTime)));
if (!String.IsNullOrEmpty(endAddTime))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Lt("OL.AddTime", Convert.ToDateTime(endAddTime)));
if (!String.IsNullOrEmpty(isSuccessId))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("OL.IsSuccessId", isSuccessId));
if (!String.IsNullOrEmpty(operationTable))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Like("OL.OperationTable", "%" + operationTable + "%"));
if (!String.IsNullOrEmpty(operationTypeCode))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("OL.OperationTypeCode", operationTypeCode));
if (!String.IsNullOrEmpty(resultCode))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Eq("OL.ResultCode", Convert.ToInt32(resultCode)));
if (!String.IsNullOrEmpty(systemUserName))
operationLogCriterionAndOrder.CriterionList.Add(Restrictions.Like("OL.SystemUserId", "%" + systemUserName + "%"));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("OL.LogId").As("PrimaryKey"));
pList.Add(Projections.Property("OL.AddTime").As("AddTime"));
pList.Add(Projections.Property("OL.IsSuccessText").As("IsSuccessText"));
pList.Add(Projections.Property("OL.LogId").As("LogId"));
pList.Add(Projections.Property("OL.ObjectRecordId").As("ObjectRecordId"));
pList.Add(Projections.Property("OL.OperationContent").As("OperationContent"));
pList.Add(Projections.Property("OL.OperationTable").As("OperationTable"));
pList.Add(Projections.Property("OL.OperationTypeText").As("OperationTypeText"));
pList.Add(Projections.Property("OL.ResultText").As("ResultText"));
pList.Add(Projections.Property("SU.UserId").As("SystemUserId"));
pList.Add(Projections.Property("SU.UserName").As("SystemUserName"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(OperationLog);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(operationLogCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(conLogCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(systemUserCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = OperationLogBll.GetOperationLogList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string userName = request.Params["textUserName"];
string realName = request.Params["textRealName"];
string medCardNum = request.Params["textMedCardNum"];
string memCardNum = request.Params["textMemCardNumber"];
CriterionAndOrder consumerCriterionAndOrder = new CriterionAndOrder();
consumerCriterionAndOrder.CriteriaName = typeof(Consumer).FullName;
consumerCriterionAndOrder.CriteriaAsName = "C";
consumerCriterionAndOrder.OrderList.Add(new Order("C.ConsumerId", false));
CriterionAndOrder systemUserCriterionAndOrder = new CriterionAndOrder();
systemUserCriterionAndOrder.CriteriaName = "UserRef";
systemUserCriterionAndOrder.CriteriaAsName = "SU";
systemUserCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
CriterionAndOrder cardUserListCriterionAndOrder = new CriterionAndOrder();
cardUserListCriterionAndOrder.CriteriaName = "CardUserList";
cardUserListCriterionAndOrder.CriteriaAsName = "CUL";
cardUserListCriterionAndOrder.CriteriaSpecification = CriteriaSpecification.LeftJoin;
if (!String.IsNullOrEmpty(userName))
consumerCriterionAndOrder.CriterionList.Add(Restrictions.Like("SU.UserName", "%" + userName + "%"));
if (!String.IsNullOrEmpty(realName))
consumerCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.RealName", "%" + realName + "%"));
if (!String.IsNullOrEmpty(memCardNum))
consumerCriterionAndOrder.CriterionList.Add(Restrictions.Eq("CUL.CardNum", memCardNum));
if (!String.IsNullOrEmpty(medCardNum))
consumerCriterionAndOrder.CriterionList.Add(Restrictions.Eq("C.MedCardNum", medCardNum));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("C.ConsumerId").As("PrimaryKey"));
//pList.Add(Projections.Property("C.ConsumerId").As("ConsumerId"));
pList.Add(Projections.Property("C.MedCardNum").As("MedCardNum"));
pList.Add(Projections.Property("SU.UserName").As("UserName"));
pList.Add(Projections.Property("SU.RealName").As("RealName"));
pList.Add(Projections.Property("SU.GenderName").As("GenderName"));
pList.Add(Projections.Property("SU.AddTime").As("AddTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(Consumer);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(consumerCriterionAndOrder);
queryTerms.CriterionAndOrderList.Add(systemUserCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = ConsumerBll.GetConsumerList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
public IActionResult BuyEvaluateListIndex(IFormCollection form)
{
List <SelectListItem> listItem = new List <SelectListItem>();
listItem.Add(new SelectListItem {
Text = "待處理", Value = "待處理"
});
listItem.Add(new SelectListItem {
Text = "已處理", Value = "已處理"
});
listItem.Add(new SelectListItem {
Text = "已結案", Value = "已結案"
});
ViewData["Item"] = new SelectList(listItem, "Value", "Text", form["qtyFLOWTYP"]);
//
List <BuyEvaluateListVModel> vm;
QueryTerms qry = new QueryTerms();
if (form["qtyDOCID"] != "")
{
qry.docid = form["qtyDOCID"];
}
if (form["qtyACCNO"] != "")
{
qry.accno = form["qtyACCNO"];
}
//if (form["qtyASSETNO"] != "")
//{
// qry.assetno = form["qtyASSETNO"];
//}
if (form["qtyCNAME"] != "")
{
qry.cname = form["qtyCNAME"];
}
if (form["qtyDPTID"] != "")
{
qry.applydpt = form["qtyDPTID"];
}
if (form["qtyFLOWTYP"] != "")
{
qry.flowtyp = form["qtyFLOWTYP"];
}
if (form["qtyBUDGETID"] != "")
{
qry.budgetid = form["qtyBUDGETID"];
}
if (form["qtyAGREEDATE1"] != "")
{
qry.agreedate1 = form["qtyAGREEDATE1"];
qry.agreedate1 = qry.agreedate1.Replace("-", "/");
ViewData["Sdate"] = qry.agreedate1;
}
if (form["qtyAGREEDATE2"] != "")
{
qry.agreedate2 = form["qtyAGREEDATE2"];
qry.agreedate2 = qry.agreedate2.Replace("-", "/");
ViewData["Edate"] = qry.agreedate2;
}
if (userManager.IsInRole(User, "BuyerMgr"))
{
vm = GetList(qry, "BuyerMgr");
}
else
{
vm = GetList(qry, "");
}
string c = form["qtySTANDARD"];
if (Convert.ToBoolean(c.Split(new char[] { ',' }).GetValue(0)))
{
vm = vm.Where(v => v.IsAgree == true).ToList();
}
//
string[] s = new string[] { "?", "2" };
vm.ForEach(v =>
{
v.DelivCount = _context.Deliveries.Where(d => d.PurchaseNo == v.DocId)
.Join(_context.DelivFlows, d => d.DocId, f => f.DocId,
(d, f) => f).Where(f => s.Contains(f.Status)).Count();
});
return(PartialView("_BuyEvaluateList", vm));
}
/// <summary>
/// 根据查询条件获取CobminationItem表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>实体列表</returns>
public static IList<CobminationItem> GetList(QueryTerms queryTerms)
{
return DataAccessUtility.GetList<CobminationItem>(queryTerms);
}
/// <summary>
/// 根据查询条件获取Dictionary表中符合查询条件的记录
/// </summary>
/// <param name="queryTerms">自定义查询条件</param>
/// <returns>实体列表</returns>
public static IList<Dictionary> GetList(QueryTerms queryTerms)
{
return DataAccessUtility.GetList<Dictionary>(queryTerms);
}
/// <summary>
/// 复杂查询操作
/// </summary>
protected void QueryRecord()
{
HttpContext context = HttpContext.Current;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string pageSize = request.Params["pageSize"];
string pageIndex = request.Params["pageIndex"];
string addTime = request.Params["textAddTime"];
string description = request.Params["textDescription"];
string id = request.Params["textId"];
string name = request.Params["textName"];
string updateTime = request.Params["textUpdateTime"];
//keywords是处理AutoComplete下接框查询时设置的传入参数
string keywords = request.Params["keywords"];
CriterionAndOrder dictionaryTypeCriterionAndOrder = new CriterionAndOrder();
dictionaryTypeCriterionAndOrder.CriteriaName = typeof(DictionaryType).FullName;
dictionaryTypeCriterionAndOrder.CriteriaAsName = "DT";
dictionaryTypeCriterionAndOrder.OrderList.Add(new Order("DT.AddTime", false));
if (!String.IsNullOrEmpty(addTime))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Gt("DT.AddTime", Convert.ToDateTime(addTime)));
if (!String.IsNullOrEmpty(description))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Like("DT.Description", "%" + description + "%"));
if (!String.IsNullOrEmpty(keywords))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Like("DT.Description", "%" + keywords + "%"));
if (!String.IsNullOrEmpty(id))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Eq("DT.Id", id));
if (!String.IsNullOrEmpty(name))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Like("DT.Name", "%" + name + "%"));
if (!String.IsNullOrEmpty(updateTime))
dictionaryTypeCriterionAndOrder.CriterionList.Add(Restrictions.Gt("DT.UpdateTime", Convert.ToDateTime(updateTime)));
ProjectionList pList = Projections.ProjectionList();
pList.Add(Projections.Property("DT.Id").As("PrimaryKey"));
pList.Add(Projections.Property("DT.AddTime").As("AddTime"));
pList.Add(Projections.Property("DT.Description").As("Description"));
pList.Add(Projections.Property("DT.Id").As("Id"));
pList.Add(Projections.Property("DT.Name").As("Name"));
pList.Add(Projections.Property("DT.UpdateTime").As("UpdateTime"));
QueryTerms queryTerms = new QueryTerms();
queryTerms.PersistentClass = typeof(DictionaryType);
queryTerms.ColumnList = pList;
queryTerms.CriterionAndOrderList.Add(dictionaryTypeCriterionAndOrder);
queryTerms.PageSize = Convert.ToInt32(pageSize);
queryTerms.PageIndex = Convert.ToInt32(pageIndex) - 1;
ResultModel result = DictionaryTypeBll.GetDictionaryTypeList(queryTerms);
string jsonString = JsonConvert.SerializeObject(result, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
response.Write(jsonString);
}
public List <BuyEvaluateListVModel> GetList(QueryTerms qry, string role)
{
// Get Login User's details.
var user = _userRepo.Find(ur => ur.UserName == User.Identity.Name).FirstOrDefault();
List <BuyEvaluateListVModel> rv = new List <BuyEvaluateListVModel>();
List <BuyFlowModel> rf = new List <BuyFlowModel>();
List <string> rs = new List <string>();
AppUserModel p = _context.AppUsers.Find(user.Id);
DepartmentModel d = _context.Departments.Find(p.DptId);
switch (qry.flowtyp)
{
case "已處理":
rf = _context.BuyFlows.Where(m => m.Status == "?")
.ToList();
break;
case "已結案":
rf = _context.BuyFlows.Where(m => m.Status == "2")
.ToList();
break;
default:
rf = _context.BuyFlows.Where(m => m.Status == "?")
.Where(m => m.UserId == user.Id)
.ToList();
break;
}
if (!string.IsNullOrEmpty(qry.docid))
{
rf = rf.Where(m => m.DocId == qry.docid).ToList();
}
rf = rf.OrderByDescending(m => m.Rtt).ToList();
if (role == "BuyerMgr")
{
rs = rf.Join(_context.BuyEvaluates, m => m.DocId, f => f.DocId,
(m, f) => new
{
m.DocId,
f.AccDpt,
m.Rtt
})
.OrderByDescending(f => f.Rtt)
.Select(f => f.DocId).Distinct().ToList();
}
else
{
if (qry.flowtyp == "已處理")
{
rs = rf.Join(_context.BuyFlows, m => m.DocId, f => f.DocId,
(m, f) => f)
.Where(f => f.UserId == user.Id)
.Where(f => f.Status == "1")
.Select(f => f.DocId).Distinct().ToList();
}
else
{
rs = rf.Select(m => m.DocId).Distinct().ToList();
}
}
var data = rs.Join(_context.BuyEvaluates, m => m, f => f.DocId,
(m, f) => new
{
f.DocId,
f.UserId,
f.UserName,
f.AccDpt,
f.AccDptNam,
f.PlantCnam,
f.PlantEnam,
f.PlantType,
f.EngId,
f.EngName,
f.BudgetId,
f.AgreeDate,
f.Rtt
}).Join(_context.AppUsers, f => f.UserId, u => u.Id,
(f, u) => new
{
f.DocId,
f.UserId,
f.UserName,
f.AccDpt,
f.AccDptNam,
f.PlantCnam,
f.PlantEnam,
f.PlantType,
f.EngId,
f.EngName,
f.BudgetId,
f.AgreeDate,
f.Rtt,
u.DptId
});
if (!string.IsNullOrEmpty(qry.accno))
{
data = data.Where(f => f.AccDpt == qry.accno);
}
//if (!string.IsNullOrEmpty(qry.assetno))
//{
// data = data.Where(f => f.AssetNo == qry.assetno);
//}
if (!string.IsNullOrEmpty(qry.cname))
{
data = data.Where(f => f.PlantCnam.Contains(qry.cname));
}
if (!string.IsNullOrEmpty(qry.applydpt))
{
data = data.Where(f => f.AccDpt == qry.applydpt);
}
if (!string.IsNullOrEmpty(qry.budgetid))
{
data = data.Where(f => f.BudgetId == qry.budgetid);
}
if (!string.IsNullOrEmpty(qry.agreedate1))
{
data = data.Where(f => f.AgreeDate != null)
.Where(f => f.AgreeDate.Value.CompareTo(DateTime.ParseExact(qry.agreedate1, "yyyy/MM/dd", null)) >= 0);
}
if (!string.IsNullOrEmpty(qry.agreedate2))
{
data = data.Where(f => f.AgreeDate != null)
.Where(f => f.AgreeDate.Value.Date.CompareTo(DateTime.ParseExact(qry.agreedate2, "yyyy/MM/dd", null)) <= 0);
}
data = data.Take((qry.pagecnt + 1) * 100);
string status = "";
if (qry.flowtyp == "已結案")
{
status = "2";
}
else
{
status = "?";
}
var s = new[] { "?", "2" };
data.Join(_context.BuyFlows, m => m.DocId, f => f.DocId,
(m, f) => new
{
buyevaluate = m,
flow = f
}).Where(bf => bf.flow.Status == status)
.ToList()
.ForEach(j => rv.Add(new BuyEvaluateListVModel
{
DocType = "評估",
DocId = j.buyevaluate.DocId,
BudgetId = j.buyevaluate.BudgetId,
UserId = j.buyevaluate.UserId,
UserName = j.buyevaluate.UserName,
CustId = j.buyevaluate.AccDpt,
CustNam = (d = _context.Departments.Find(j.buyevaluate.AccDpt)) == null ? ""
: d.Name_C,
PlantCnam = j.buyevaluate.PlantCnam,
PlantEnam = j.buyevaluate.PlantEnam,
PlantType = j.buyevaluate.PlantType,
EngName = (p = _context.AppUsers.Find(j.buyevaluate.EngId)) == null ? ""
: p.FullName,
Days = DateTime.Now.Subtract(j.buyevaluate.Rtt.GetValueOrDefault()).Days,
Flg = _context.Deliveries.Join(_context.DelivFlows, de => de.DocId, f => f.DocId,
(de, f) =>
new
{
delivery = de,
delivflow = f
}).Where(k => k.delivery.PurchaseNo == j.buyevaluate.DocId)
.Where(k => s.Contains(k.delivflow.Status)).Count() > 0 ?
"E" : j.flow.Status,
FlowUid = j.flow.UserId,
FlowUname = (p = _context.AppUsers.Find(j.flow.UserId)) == null ? "" : p.FullName,
IsAgree = j.buyevaluate.AgreeDate.HasValue ? true : false,
AgreeDate = j.buyevaluate.AgreeDate == null ? "" : j.buyevaluate.AgreeDate.Value.ToString("yyyy/MM/dd")
}));
//
//_context.Dispose();
return(rv);
}
