public List <Check_BeForeResultInfo> GetBeforeResultList(string states, QueryCoditionByCheckResult queryCoditionByCheckResult, bool isadmin, string curryydm, int page, int limit, ref int totalcount)
{
List <Check_BeForeResultInfo> datalist = new List <Check_BeForeResultInfo>();
using (var db = _dbContext.GetIntance()) //从数据库中
{
if (isadmin)
{
datalist = db.Queryable <Check_BeForeResultInfo>()
.WhereIF(!string.IsNullOrEmpty(states), it => it.RuleLevel == states)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.RegisterCode), it => it.RegisterCode.Contains(queryCoditionByCheckResult.RegisterCode))
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.Name), it => it.Name.Contains(queryCoditionByCheckResult.Name))
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.InstitutionCode), it => it.InstitutionCode == queryCoditionByCheckResult.InstitutionCode)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.InstitutionLevel), it => it.InstitutionGradeCode == queryCoditionByCheckResult.InstitutionLevel)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.ICDCode), it => it.ICDCode == queryCoditionByCheckResult.ICDCode)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.IdNumber), it => it.IdNumber == queryCoditionByCheckResult.IdNumber).ToPageList(page, limit, ref totalcount);
}
else if (curryydm.Substring(0, 2) == "15") //是医院
{
datalist = db.Queryable <Check_BeForeResultInfo>()
.Where(it => it.InstitutionCode == curryydm)
.WhereIF(!string.IsNullOrEmpty(states), it => it.RuleLevel == states)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.RegisterCode), it => it.RegisterCode.Contains(queryCoditionByCheckResult.RegisterCode))
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.Name), it => it.Name.Contains(queryCoditionByCheckResult.Name))
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.InstitutionCode), it => it.InstitutionCode == queryCoditionByCheckResult.InstitutionCode)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.InstitutionLevel), it => it.InstitutionGradeCode == queryCoditionByCheckResult.InstitutionLevel)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.ICDCode), it => it.ICDCode == queryCoditionByCheckResult.ICDCode)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.IdNumber), it => it.IdNumber == queryCoditionByCheckResult.IdNumber).ToPageList(page, limit, ref totalcount);
}
else //旗县医保局
{
var XAreaCode = returnXAreaCode(curryydm);
datalist = db.Queryable <Check_BeForeResultInfo>()
.Where(it => it.InstitutionCode.Substring(0, 6) == XAreaCode.Substring(0, 6))
.WhereIF(!string.IsNullOrEmpty(states), it => it.RuleLevel == states)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.RegisterCode), it => it.RegisterCode == queryCoditionByCheckResult.RegisterCode)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.RegisterCode), it => it.RegisterCode.Contains(queryCoditionByCheckResult.RegisterCode))
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.Name), it => it.Name.Contains(queryCoditionByCheckResult.Name))
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.InstitutionLevel), it => it.InstitutionGradeCode == queryCoditionByCheckResult.InstitutionLevel)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.ICDCode), it => it.ICDCode == queryCoditionByCheckResult.ICDCode)
.WhereIF(!string.IsNullOrEmpty(queryCoditionByCheckResult.IdNumber), it => it.IdNumber == queryCoditionByCheckResult.IdNumber).ToPageList(page, limit, ref totalcount);
}
return(datalist);
}
}
public IActionResult GetFisrtInfos2(string querystr, string states, int page, int limit)
{
QueryCoditionByCheckResult result = new QueryCoditionByCheckResult();
if (!string.IsNullOrEmpty(querystr))
{
result = JsonConvert.DeserializeObject <QueryCoditionByCheckResult>(querystr);
}
var resultCountModel = new RespResultCountViewModel();
int totalcount = 0;
bool isadmin = false;
string curryydm = User.GetCurrentUserOrganizeId();
if (User.GetCurrentUserName() == "admin" || _afterCheckService.IsCityYBJ(curryydm)) //如果为管理员或市医保 可查看所有
{
isadmin = true;
}
try
{
var data = _complaintMZService.GetFisrtInfos2(states, result, isadmin, curryydm, page, limit, ref totalcount);
if (data != null)
{
resultCountModel.code = 0;
resultCountModel.msg = "获取数据成功";
resultCountModel.data = data.checkResultInfoEntities2;
resultCountModel.complaindata = data.Record;
resultCountModel.count = totalcount;
}
else
{
resultCountModel.code = -1;
resultCountModel.msg = "没有检索到数据";
}
return(Ok(resultCountModel));
}
catch (Exception ex)
{
resultCountModel.code = -1;
resultCountModel.msg = "操作失败:" + ex.ToString();
return(Ok(resultCountModel));
}
}
public IActionResult GetComplaintStatesList(string rulescode, string states, string querystr, string flag, int page, int limit)
{
var resultCountModel = new RespResultCountViewModel();
try
{
QueryCoditionByCheckResult queryCoditionByCheckResult = new QueryCoditionByCheckResult();
if (!string.IsNullOrEmpty(querystr))
{
queryCoditionByCheckResult = JsonConvert.DeserializeObject <QueryCoditionByCheckResult>(querystr);
}
bool isadmin = false;
string curryydm = User.GetCurrentUserOrganizeId();
if (User.GetCurrentUserName() == "admin" || _afterCheckService.IsCityYBJ(curryydm)) //如果为管理员或者市医保局 可查看所有
{
isadmin = true;
}
int count = 0;
var data = _afterCheckService.GetComplaintStateList(queryCoditionByCheckResult, rulescode, states, isadmin, curryydm, page, limit, ref count);
if (data != null)
{
resultCountModel.code = 0;
resultCountModel.msg = "成功";
resultCountModel.data = data;
resultCountModel.count = count;
}
else
{
resultCountModel.code = 0;
resultCountModel.count = count;
resultCountModel.data = data;
resultCountModel.msg = "没有检索到数据";
}
return(Ok(resultCountModel));
}
catch (Exception ex)
{
resultCountModel.code = -1;
resultCountModel.msg = "操作失败:" + ex.ToString();
return(Ok(resultCountModel));
}
}
public IActionResult GetComplaintInfoList(string rulescode, string querystr, int page, int limit)
{
QueryCoditionByCheckResult result = new QueryCoditionByCheckResult();
if (!string.IsNullOrEmpty(querystr))
{
result = JsonConvert.DeserializeObject <QueryCoditionByCheckResult>(querystr);
}
int totalcount = 0;
var resultCountModel = new RespResultCountViewModel();
bool isadmin = false;
string curryydm = User.GetCurrentUserOrganizeId();
if (User.GetCurrentUserName() == "admin" || _supervisionInfoService.IsCityYBJ(curryydm)) //如果为管理员或市医保 可查看所有
{
isadmin = true;
}
try
{
var data = _supervisionInfoService.GetComplaintInfoList(rulescode, result, isadmin, curryydm, page, limit, ref totalcount);
if (data != null)
{
resultCountModel.code = 0;
resultCountModel.msg = "获取申诉信息数据成功";
resultCountModel.data = data;
resultCountModel.count = totalcount;
}
else
{
resultCountModel.code = -1;
resultCountModel.msg = "没有检索到数据";
}
return(Ok(resultCountModel));
}
catch (Exception ex)
{
resultCountModel.code = -1;
resultCountModel.msg = "操作失败:" + ex.ToString();
return(Ok(resultCountModel));
}
}
public List <Check_Complain_MZLEntity> GetListByStates(string step, string states, QueryCoditionByCheckResult queryCoditionByCheckResult, bool isAdmin, string curryydm, int page, int limit, ref int count)
{
var list = new List <Check_Complain_MZLEntity>();
string bt1 = ((page - 1) * limit + 1).ToString();
string bt2 = (page * limit).ToString();
string querystr = string.Empty;
if (!string.IsNullOrEmpty(step) && step != "0")
{
if (step == "22")
{
querystr += " AND uni.StatesBS = '1' ";
querystr += " AND uni.IsSceondFK = '1' ";
}
else
{
querystr += " AND uni.StatesBS = '" + step + "' ";
}
}
if (!string.IsNullOrEmpty(states))
{
querystr += " AND uni.YDLevel = '" + states + "' ";
}
if (!string.IsNullOrEmpty(queryCoditionByCheckResult.RegisterCode))
{
querystr += " AND uni.RegisterCode = '" + queryCoditionByCheckResult.RegisterCode + "' ";
}
if (!string.IsNullOrEmpty(queryCoditionByCheckResult.Name))
{
querystr += " AND uni.PersonName = '" + queryCoditionByCheckResult.Name + "' ";
}
if (!string.IsNullOrEmpty(queryCoditionByCheckResult.InstitutionCode))
{
querystr += " AND uni.InstitutionCode = '" + queryCoditionByCheckResult.InstitutionCode + "' ";
}
if (!string.IsNullOrEmpty(queryCoditionByCheckResult.InstitutionLevel))
{
querystr += " AND uni.InstitutionLevel = '" + queryCoditionByCheckResult.InstitutionLevel + "' ";
}
if (!string.IsNullOrEmpty(queryCoditionByCheckResult.ICDCode))
{
querystr += " AND uni.ICDCode = '" + queryCoditionByCheckResult.ICDCode + "' ";
}
if (!string.IsNullOrEmpty(queryCoditionByCheckResult.IdNumber))
{
querystr += " AND uni.IdNumber = '" + queryCoditionByCheckResult.IdNumber + "' ";
}
if (queryCoditionByCheckResult.StartSettleTime != null)
{
querystr += " AND uni.SettlementDate >= '" + queryCoditionByCheckResult.StartSettleTime + "' ";
}
else
{
querystr += " AND uni.SettlementDate >= '" + new DateTime(DateTime.Now.Year, 1, 1).ToString("yyyy-MM-dd") + "' ";
}
if (queryCoditionByCheckResult.EndSettleTime != null)
{
querystr += " AND uni.SettlementDate <= '" + queryCoditionByCheckResult.EndSettleTime + "' ";
}
else
{
querystr += " AND uni.SettlementDate <= '" + new DateTime(DateTime.Now.Year, 12, 1).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + "' ";
}
using (var db = _dbContext.GetIntance())
{
if (isAdmin)
{
list = db.Ado.SqlQuery <Check_Complain_MZLEntity>(@"
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY uni.SettlementDate DESC) AS RowId,uni.PersonalCode,
uni.RegisterCode,uni.PersonName,uni.InstitutionCode,uni.InstitutionName,uni.DiseaseName,
uni.YDDescription,uni.IdNumber,uni.SettlementDate,uni.DSHWGJ,uni.DSHWGS,uni.YSHWGJ,uni.YSHWGS,
uni.ALLMoney,uni.ALLCount,uni.YDLevel,uni.SHLCStates,uni.StatesBS,uni.IsSceondFK,uni.InstitutionLevel
FROM (
SELECT PersonalCode,RegisterCode,Name AS PersonName,InstitutionCode,InstitutionName,DiseaseName,
ResultDescription AS YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ZWGJE AS ALLMoney,ZWGSL AS ALLCount,YDDJ AS YDLevel,SHLCZT AS SHLCStates,'5' AS StatesBS,'0' AS IsSceondFK,InstitutionLevel,ICDCode
FROM dbo.Check_ResultInfoMain WHERE SHStates is NULL AND DSHWGS <> 0 AND DataType = '2'
UNION ALL
SELECT PersonalCode,RegisterCode,PersonName,InstitutionCode,InstitutionName,DiseaseName,
YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ALLMoney,ALLCount,YDLevel,SHLCStates,ComplaintStatus AS StatesBS,IsSceondFK,InstitutionLevel,ICDCode
FROM dbo.Check_Complain_MZL ) uni WHERE 1=1 " + querystr + " ) AS tj where tj.RowId BETWEEN " + bt1 + " AND " + bt2);
count = db.Ado.GetInt(@" SELECT COUNT(1) FROM (
SELECT ROW_NUMBER() OVER(ORDER BY uni.SettlementDate DESC) AS RowId,uni.PersonalCode,
uni.RegisterCode,uni.PersonName,uni.InstitutionCode,uni.InstitutionName,uni.DiseaseName,
uni.YDDescription,uni.IdNumber,uni.SettlementDate,uni.DSHWGJ,uni.DSHWGS,uni.YSHWGJ,uni.YSHWGS,
uni.ALLMoney,uni.ALLCount,uni.YDLevel,uni.SHLCStates,uni.StatesBS,uni.IsSceondFK,uni.InstitutionLevel
FROM (
SELECT PersonalCode,RegisterCode,Name AS PersonName,InstitutionCode,InstitutionName,DiseaseName,
ResultDescription AS YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ZWGJE AS ALLMoney,ZWGSL AS ALLCount,YDDJ AS YDLevel,SHLCZT AS SHLCStates,'5' AS StatesBS,'0' AS IsSceondFK,InstitutionLevel,ICDCode
FROM dbo.Check_ResultInfoMain WHERE SHStates is NULL AND DSHWGS <> 0 AND DataType = '2'
UNION ALL
SELECT PersonalCode,RegisterCode,PersonName,InstitutionCode,InstitutionName,DiseaseName,
YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ALLMoney,ALLCount,YDLevel,SHLCStates,ComplaintStatus AS StatesBS,IsSceondFK,InstitutionLevel,ICDCode
FROM dbo.Check_Complain_MZL ) uni WHERE 1=1 " + querystr + " ) AS tj");
}
else if (curryydm.Substring(0, 2) == "15") //是医院
{
querystr += " AND uni.InstitutionCode = '" + curryydm + "' ";
list = db.Ado.SqlQuery <Check_Complain_MZLEntity>(@"
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY uni.SettlementDate DESC) AS RowId,uni.PersonalCode,
uni.RegisterCode,uni.PersonName,uni.InstitutionCode,uni.InstitutionName,uni.DiseaseName,
uni.YDDescription,uni.IdNumber,uni.SettlementDate,uni.DSHWGJ,uni.DSHWGS,uni.YSHWGJ,uni.YSHWGS,
uni.ALLMoney,uni.ALLCount,uni.YDLevel,uni.SHLCStates,uni.StatesBS,uni.IsSceondFK,uni.InstitutionLevel
FROM (
SELECT PersonalCode,RegisterCode,Name AS PersonName,InstitutionCode,InstitutionName,DiseaseName,
ResultDescription AS YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ZWGJE AS ALLMoney,ZWGSL AS ALLCount,YDDJ AS YDLevel,SHLCZT AS SHLCStates,'5' AS StatesBS,'0' AS IsSceondFK,InstitutionLevel,ICDCode
FROM dbo.Check_ResultInfoMain WHERE SHStates is NULL AND DSHWGS <> 0 AND DataType = '2'
UNION ALL
SELECT PersonalCode,RegisterCode,PersonName,InstitutionCode,InstitutionName,DiseaseName,
YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ALLMoney,ALLCount,YDLevel,SHLCStates,ComplaintStatus AS StatesBS,IsSceondFK,InstitutionLevel,ICDCode
FROM dbo.Check_Complain_MZL ) uni WHERE 1=1 " + querystr + " ) AS tj where tj.RowId BETWEEN " + bt1 + " AND " + bt2);
count = db.Ado.GetInt(@" SELECT COUNT(1) FROM (
SELECT ROW_NUMBER() OVER(ORDER BY uni.SettlementDate DESC) AS RowId,uni.PersonalCode,
uni.RegisterCode,uni.PersonName,uni.InstitutionCode,uni.InstitutionName,uni.DiseaseName,
uni.YDDescription,uni.IdNumber,uni.SettlementDate,uni.DSHWGJ,uni.DSHWGS,uni.YSHWGJ,uni.YSHWGS,
uni.ALLMoney,uni.ALLCount,uni.YDLevel,uni.SHLCStates,uni.StatesBS,uni.IsSceondFK,uni.InstitutionLevel
FROM (
SELECT PersonalCode,RegisterCode,Name AS PersonName,InstitutionCode,InstitutionName,DiseaseName,
ResultDescription AS YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ZWGJE AS ALLMoney,ZWGSL AS ALLCount,YDDJ AS YDLevel,SHLCZT AS SHLCStates,'5' AS StatesBS,'0' AS IsSceondFK,InstitutionLevel,ICDCode
FROM dbo.Check_ResultInfoMain WHERE SHStates is NULL AND DSHWGS <> 0 AND DataType = '2'
UNION ALL
SELECT PersonalCode,RegisterCode,PersonName,InstitutionCode,InstitutionName,DiseaseName,
YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ALLMoney,ALLCount,YDLevel,SHLCStates,ComplaintStatus AS StatesBS,IsSceondFK,InstitutionLevel,ICDCode
FROM dbo.Check_Complain_MZL ) uni WHERE 1=1 " + querystr + " ) AS tj");
}
else
{
var XAreaCode = returnXAreaCode(curryydm).Substring(0, 6);
querystr += " AND SUBSTRING(uni.FamilyCode,0,7) = '" + XAreaCode + "' ";
if (!string.IsNullOrEmpty(queryCoditionByCheckResult.InstitutionCode))
{
querystr += " AND uni.InstitutionCode = '" + queryCoditionByCheckResult.InstitutionCode + "' ";
}
list = db.Ado.SqlQuery <Check_Complain_MZLEntity>(@"
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY uni.SettlementDate DESC) AS RowId,uni.PersonalCode,
uni.RegisterCode,uni.PersonName,uni.InstitutionCode,uni.InstitutionName,uni.DiseaseName,
uni.YDDescription,uni.IdNumber,uni.SettlementDate,uni.DSHWGJ,uni.DSHWGS,uni.YSHWGJ,uni.YSHWGS,
uni.ALLMoney,uni.ALLCount,uni.YDLevel,uni.SHLCStates,uni.StatesBS,uni.IsSceondFK,uni.InstitutionLevel
FROM (
SELECT PersonalCode,RegisterCode,Name AS PersonName,InstitutionCode,InstitutionName,DiseaseName,
ResultDescription AS YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ZWGJE AS ALLMoney,ZWGSL AS ALLCount,YDDJ AS YDLevel,SHLCZT AS SHLCStates,'5' AS StatesBS,'0' AS IsSceondFK,FamilyCode,InstitutionLevel,ICDCode
FROM dbo.Check_ResultInfoMain WHERE SHStates is NULL AND DSHWGS <> 0 AND DataType = '2'
UNION ALL
SELECT PersonalCode,RegisterCode,PersonName,InstitutionCode,InstitutionName,DiseaseName,
YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ALLMoney,ALLCount,YDLevel,SHLCStates,ComplaintStatus AS StatesBS,IsSceondFK,FamilyCode,InstitutionLevel,ICDCode
FROM dbo.Check_Complain_MZL ) uni WHERE 1=1 " + querystr + " ) AS tj where tj.RowId BETWEEN " + bt1 + " AND " + bt2);
count = db.Ado.GetInt(@" SELECT COUNT(1) FROM (
SELECT ROW_NUMBER() OVER(ORDER BY uni.SettlementDate DESC) AS RowId,uni.PersonalCode,
uni.RegisterCode,uni.PersonName,uni.InstitutionCode,uni.InstitutionName,uni.DiseaseName,
uni.YDDescription,uni.IdNumber,uni.SettlementDate,uni.DSHWGJ,uni.DSHWGS,uni.YSHWGJ,uni.YSHWGS,
uni.ALLMoney,uni.ALLCount,uni.YDLevel,uni.SHLCStates,uni.StatesBS,uni.IsSceondFK,uni.InstitutionLevel
FROM (
SELECT PersonalCode,RegisterCode,Name AS PersonName,InstitutionCode,InstitutionName,DiseaseName,
ResultDescription AS YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ZWGJE AS ALLMoney,ZWGSL AS ALLCount,YDDJ AS YDLevel,SHLCZT AS SHLCStates,'5' AS StatesBS,'0' AS IsSceondFK,FamilyCode,InstitutionLevel,ICDCode
FROM dbo.Check_ResultInfoMain WHERE SHStates is NULL AND DSHWGS <> 0 AND DataType = '2'
UNION ALL
SELECT PersonalCode,RegisterCode,PersonName,InstitutionCode,InstitutionName,DiseaseName,
YDDescription,IdNumber,SettlementDate,DSHWGJ,DSHWGS,YSHWGJ,YSHWGS,
ALLMoney,ALLCount,YDLevel,SHLCStates,ComplaintStatus AS StatesBS,IsSceondFK,FamilyCode,InstitutionLevel,ICDCode
FROM dbo.Check_Complain_MZL ) uni WHERE 1=1 " + querystr + " ) AS tj");
}
}
return(list);
}
