/// <summary>
/// 医保对码
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public void MedicalInsurancePairCode(MedicalInsurancePairCodesUiParam param)
{
using (var sqlConnection = new SqlConnection(_connectionString))
{
string insertSql = null;
try
{
sqlConnection.Open();
if (param.PairCodeList.Any())
{
string updateSql = "";
var pairCodeIdList = param.PairCodeList.Where(c => c.PairCodeId != null)
.Select(d => d.PairCodeId.ToString()).ToList();
var updateId = CommonHelp.ListToStr(pairCodeIdList);
//更新对码
if (pairCodeIdList.Any())
{
updateSql += $@"update [dbo].[ThreeCataloguePairCode] set [IsDelete]=1,
[DeleteUserId]='{param.UserId}',DeleteTime=GETDATE() where [Id] in ({updateId});";
sqlConnection.Execute(updateSql);
}
var insertParam = param.PairCodeList.ToList();
//新增对码
if (insertParam.Any())
{
foreach (var items in insertParam)
{
insertSql += $@"insert into [dbo].[ThreeCataloguePairCode]
([Id],[OrganizationCode],[OrganizationName],[DirectoryCategoryCode],[State],[ProjectCode],
[FixedEncoding],[CreateTime],[IsDelete],[CreateUserId],[UploadState],[DirectoryCode]) values (
'{Guid.NewGuid()}','{param.OrganizationCode}','{param.OrganizationName}','{items.DirectoryCategoryCode}',0,'{items.ProjectCode}',
'{BitConverter.ToInt64(Guid.Parse(items.DirectoryCode).ToByteArray(), 0)}',GETDATE(),0,'{param.UserId}',0,'{items.DirectoryCode}') ";
}
sqlConnection.Execute(insertSql);
sqlConnection.Close();
}
}
}
catch (Exception e)
{
_log.Debug(insertSql);
throw new Exception(e.Message);
}
}
}
public ApiJsonResultData HospitalThreeCatalogBatchUpload([FromBody] UiInIParam param)
{
return(new ApiJsonResultData(ModelState, new UiInIParam()).RunWithTry(y =>
{ var userBase = webServiceBasicService.GetUserBaseInfo(param.UserId);
var paramIni = new MedicalInsurancePairCodesUiParam();
if (userBase != null && string.IsNullOrWhiteSpace(userBase.OrganizationCode) == false)
{
paramIni.OrganizationCode = userBase.OrganizationCode;
paramIni.OrganizationName = userBase.OrganizationName;
webServiceBasicService.ThreeCataloguePairCodeUpload(
new UpdateThreeCataloguePairCodeUploadParam()
{
User = userBase,
ProjectCodeList = new List <string>()
}
);
}
ImedicalInsuranceSqlRepository.HospitalThreeCatalogBatchUpload(userBase); }));
}
