public List <JYDetail> GetJYDetails(JYDetailRequest request)
{
string sqlJyDetail = $"select testno,itemno,itemname,testresult,isnull(resultflag,'') as resultflag,isnull(units,'') as units,isnull(ranges,'') as ranges from lis_reqresult where testno='{request.ReqId}' order by seqno";
DataTable dtJyDetail = SqlCommon.ExecuteSqlToDataSet(SqlCommon.GetConnectionStringFromConnectionStrings("HosdataConnectionString"), sqlJyDetail).Tables[0];
if (dtJyDetail != null && dtJyDetail.Rows.Count > 0)
{
List <JYDetail> jYDetails = new List <JYDetail>();
for (int i = 0; i < dtJyDetail.Rows.Count; i++)
{
JYDetail jYDetail = new JYDetail
{
ItemName = dtJyDetail.Rows[i]["itemname"].ToString(),
Result = dtJyDetail.Rows[i]["testresult"].ToString(),
Units = dtJyDetail.Rows[i]["units"].ToString() != "" ? dtJyDetail.Rows[i]["units"].ToString() : "暂无",
ResultRange = dtJyDetail.Rows[i]["ranges"].ToString() != "" ? dtJyDetail.Rows[i]["ranges"].ToString() : "暂无",
Code = dtJyDetail.Rows[i]["itemno"].ToString(),
Other1 = null,
Other2 = null,
Other3 = null,
Other4 = null,
Other5 = null,
HospitalId = ConfigurationManager.AppSettings["HospitalId"],
ReqId = request.ReqId
};
switch (dtJyDetail.Rows[i]["resultflag"].ToString())
{
case "M":
jYDetail.Indicator = "0";
break;
case "L":
jYDetail.Indicator = "1";
break;
case "H":
jYDetail.Indicator = "2";
break;
default:
jYDetail.Indicator = "3";
break;
}
jYDetails.Add(jYDetail);
}
return(jYDetails);
}
else
{
return(null);
}
}
public static JYDetailRequest GetJYDetailRequest(string requestXml)
{
XmlReader xmlReader = XmlReader.Create(new StringReader(requestXml));
XDocument xdoc = XDocument.Load(xmlReader);
JYDetailRequest request = new JYDetailRequest
{
HospitalId = xdoc.Element("request").Element("hospitalId").Value,
ReqId = xdoc.Element("request").Element("reqId").Value,
};
return(request);
}
public string GetJYDetail(string requestXml)
{
string doc;
try
{
JYDetailRequest request = RequestHelper.GetJYDetailRequest(requestXml);
JYDetailBll jYDetailBll = new JYDetailBll();
List <JYDetail> jYDetails = jYDetailBll.GetJYDetails(request);
if (jYDetails == null || jYDetails.Count == 0)
{
XDocument xDoc = new XDocument
(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement
(
"response",
new XElement("resultCode", 1),
new XElement("resultMsg", "未能查询到检验报告详情!"),
new XElement("resultContent")
)
);
doc = xDoc.ToString();
}
else
{
doc = jYDetailBll.ConvertJYDetailToXml(jYDetails);
}
}
catch (Exception)
{
XDocument xDoc = new XDocument
(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement
(
"response",
new XElement("resultCode", 1),
new XElement("resultMsg", "系统出现内部错误!"),
new XElement("resultContent")
)
);
doc = xDoc.ToString();
return(doc);
}
return(doc);
}
public List <JYDetail> GetJYDetails(JYDetailRequest request)
{
JYDetailDal jYDetailDal = new JYDetailDal();
return(jYDetailDal.GetJYDetails(request));
}
