/// <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; }