/// <summary>
/// 添加三大目录
/// </summary>
/// <param name="param"></param>
/// <param name="type"></param>
/// <returns></returns>
public async Task AddCatalog(UserInfoDto userInfo, List <CatalogDto> param, CatalogTypeEnum type)
{
using (var _sqlConnection = new SqlConnection(_connectionString))
{
//排除已有项目
_sqlConnection.Open();
if (param.Any())
{
var paramNew = new List <CatalogDto>();
//获取唯一编码
var catalogDtoIdList = param.Select(c => c.目录编码).ToList();
var ids = ListToStr(catalogDtoIdList);
string sqlstr = $"select 目录编码 from [dbo].[三大目录] where 目录编码 in({ids})";
var idListNew = await _sqlConnection.QueryAsync <string>(sqlstr);
//排除已有项目
paramNew = idListNew.Any() == true?param.Where(c => !idListNew.Contains(c.目录编码)).ToList()
: param;
string insterCount = null;
if (paramNew.Any())
{
foreach (var itmes in paramNew)
{
string insterSql = $@"
insert into [dbo].[三大目录]([目录编码],[目录名称],[助记码],[目录类别编码],[目录类别名称],[单位],[规格],[剂型],
[生产厂家名称],[备注],[创建时间],CreateTime,UpdateTime,IsDelete,DeleteTime,CreateUserId)
values('{itmes.目录编码}','{itmes.目录名称}','{itmes.助记码}',{Convert.ToInt16(type)},'{itmes.目录类别名称}','{itmes.单位}','{itmes.规格}',
'{itmes.剂型}', '{itmes.生产厂家名称}','{itmes.备注}', '{itmes.创建时间}',GETDATE(),GETDATE(),0,null,'{userInfo.职员ID}');";
insterCount += insterSql;
}
await _sqlConnection.ExecuteAsync(insterCount);
}
}
_sqlConnection.Close();
}
}
public CatalogType(string t, CatalogTypeEnum v)
{
Text = t;
Value = v;
}
