public IActionResult GetjcHeader(string idcard)
{
//JObject res = Methods.JhDbManager.dynamicToJObject(dy);
Console.WriteLine("请求日期：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\n检查报告的入参idcard" + idcard);
string patientno = string.Empty;//DJLSH
SqlServiceSoapClient client = new SqlServiceSoapClient(SqlServiceSoapClient.EndpointConfiguration.SqlServiceSoap);
string res = client.GetResultAsync(idcard).Result.Body.GetResultResult;
List <JObject> jobj = Methods.JhDbManager.GetTbyString <List <JObject> >(res);
if (jobj == null)
{
goto Continue;
}
if (jobj.Count == 0)
{
goto Continue;
}
for (int i = 0; i < jobj.Count; i++)
{
var item = jobj.ElementAtOrDefault(i);
if (item.ContainsKey("DJLSH"))
{
if (i == jobj.Count - 1)
{
patientno += "'" + item.GetValue("DJLSH", StringComparison.OrdinalIgnoreCase).ToString() + "'";
}
else
{
patientno += "'" + item.GetValue("DJLSH", StringComparison.OrdinalIgnoreCase).ToString() + "'" + ",";
}
}
}
Continue:
if (string.IsNullOrEmpty(patientno))
{
string Sql = $"select p.card_no from com_patientinfo p where p.idenno='{idcard}' and p.is_valid='1'";
patientno = "'" + Methods.JhDbManager.getSqlReturnOne(Sql, hisSql) + "'";
}
string sql = $"select r.lab_apply_no \"id\", r.paritemname \"title\",r.micro_flag \"iswsw\",r.patient_id \"patientId\",\'' \"patientName\",r.report_date_time \"sendTime\",\'枝江市人民医院' \"hospitalName\" from v_lis_report_zhyy r where (r.patient_id in({patientno}) and r.file_visit_type in ('1','3')) or (r.patient_id in ({patientno}) and r.file_visit_type in ('1','3')) and r.is_valid = '1'";
var dt = Methods.JhDbManager.QuerySql(sql, this.Configuration.GetConnectionString("Lis").ToString());
ArrayList arr = Methods.JhDbManager.getJObject(dt);
if (arr == null)
{
return(new JsonResult(new { msg = "没有找到如何检测报告的信息！", data = new { }, code = 404 }));
}
if (arr.Count == 0)
{
return(new JsonResult(new { msg = "没有找到如何检测报告的信息！", data = new { }, code = 404 }));
}
return(new JsonResult(new { msg = "查询成功！", data = arr, code = 200 }));
}
public IActionResult bindCard([FromBody] dynamic dynamic)//直接点参数
{
JObject res = Methods.JhDbManager.dynamicToJObject(dynamic);
Console.WriteLine("请求日期：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\n查询患者基本信息的入参" + res.ToString());
string idcard = string.Empty;
try
{
idcard = res.GetValue("idcard").ToString();
}
catch
{
return(new JsonResult(new { msg = "你输入的参数有误！", data = "参数错误", code = 403 }));
}
string sql = $" select o.is_valid \"status\", o.card_no \"patientId\", o.name \"patientName\", o.card_no \"cardNo\", o.idenno \"idCardNo\", decode(o.linkman_tel, '', o.home_tel, o.linkman_tel) \"phone\", o.home \"address\" from zjhis.com_patientinfo o where o.idenno ='{idcard}' and o.CARD_NO not like 'T%'";
var dt = new DataTable();
try
{
dt = Methods.JhDbManager.QuerySql(sql, this.Configuration.GetConnectionString("Default").ToString());
if (dt == null || dt.Rows.Count == 0)
{
SqlServiceSoapClient client = new SqlServiceSoapClient(SqlServiceSoapClient.EndpointConfiguration.SqlServiceSoap);
string result = client.GetResultAsync(idcard).Result.Body.GetResultResult;
List <JObject> jobj = Methods.JhDbManager.GetTbyString <List <JObject> >(result);
return(new JsonResult(new { msg = "查询成功！", data = jobj, code = 200 }));
}
}
catch (Exception ex)
{
return(new JsonResult(new { msg = "没有找到如何检测报告的信息！", data = ex.Message, code = 404 }));
}
ArrayList arr = Methods.JhDbManager.getJObject(dt);
if (arr.Count == 0 || arr == null)
{
return(new JsonResult(new { msg = "没有找到如何检测报告的信息！", data = "查询结果为空", code = 404 }));
}
return(new JsonResult(new { msg = "查询成功！", data = arr, code = 200 }));
}
public SqlServiceSoapClient(EndpointConfiguration endpointConfiguration, System.ServiceModel.EndpointAddress remoteAddress) :
base(SqlServiceSoapClient.GetBindingForEndpoint(endpointConfiguration), remoteAddress)
{
this.Endpoint.Name = endpointConfiguration.ToString();
ConfigureEndpoint(this.Endpoint, this.ClientCredentials);
}
public SqlServiceSoapClient(EndpointConfiguration endpointConfiguration) :
base(SqlServiceSoapClient.GetBindingForEndpoint(endpointConfiguration), SqlServiceSoapClient.GetEndpointAddress(endpointConfiguration))
{
this.Endpoint.Name = endpointConfiguration.ToString();
ConfigureEndpoint(this.Endpoint, this.ClientCredentials);
}
