/// <summary>
/// 医保病人信息查询
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public async Task <MedicalInsuranceResidentInfoDto> QueryMedicalInsuranceResidentInfo(
QueryMedicalInsuranceResidentInfoParam param)
{
using (var _sqlConnection = new SqlConnection(_connectionString))
{
var resultData = new MedicalInsuranceResidentInfoDto();
_sqlConnection.Open();
string strSql = @" select [DataAllId]
,[ContentJson]
,[DataType]
,[DataId]
,[BusinessId]
,[IdCard]
,[OrgCode]
,[CreateUserId]
,[CreateTime]
,[DeleteTime]
,[DeleteUserId] from [dbo].[MedicalInsuranceResidentInfo] where";
strSql += $" IsDelete={param.IsDelete}";
if (!string.IsNullOrWhiteSpace(param.DataId))
{
strSql += $" and DataId='{param.DataId}'";
}
if (!string.IsNullOrWhiteSpace(param.BusinessId))
{
strSql += $" and BusinessId='{param.BusinessId}'";
}
if (!string.IsNullOrWhiteSpace(param.OrgCode))
{
strSql += $" and OrgCode='{param.OrgCode}'";
}
if (!string.IsNullOrWhiteSpace(param.IdCard))
{
strSql += $" and IdCard='{param.IdCard}'";
}
var data = await _sqlConnection.QueryFirstOrDefaultAsync <MedicalInsuranceResidentInfoDto>(strSql);
_sqlConnection.Close();
return(data != null ? data : resultData);
}
}
/// <summary>
/// 更新医保病人信息
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public async Task <int> UpdateMedicalInsuranceResidentInfo(
UpdateMedicalInsuranceResidentInfoParam param)
{
using (var _sqlConnection = new SqlConnection(_connectionString))
{
var resultData = new MedicalInsuranceResidentInfoDto();
_sqlConnection.Open();
string strSql = @" update MedicalInsuranceResidentInfo set ";
if (!string.IsNullOrWhiteSpace(param.DataType))
{
strSql += $" DataType='{param.DataType}'";
}
if (!string.IsNullOrWhiteSpace(param.ContentJson))
{
strSql += $" ,ContentJson='{param.ContentJson}'";
}
if (!string.IsNullOrWhiteSpace(param.ResultDatajson))
{
strSql += $" ,ResultDatajson='{param.ResultDatajson}'";
}
if (!string.IsNullOrWhiteSpace(param.DataId))
{
strSql += $" ,DataId='{param.DataId}'";
}
if (!string.IsNullOrWhiteSpace(param.IdCard))
{
strSql += $" ,DataId='{param.IdCard}'";
}
strSql += $" where IsDelete=0 and DataAllId='{param.DataAllId}'";
var data = await _sqlConnection.ExecuteAsync(strSql);
_sqlConnection.Close();
return(data);
}
}
