根据删除的知识点查询

username@email.com

2022-02-11 b0c19dd2793b5ada90b303b7ec23a670cdbf48f6

根据删除的知识点查询

 zhengcaioa/DTO/ExpertTestTopicDTO.cs

@@ -74,6 +74,9 @@

        public string Falv { get; set; }
        
        public string shanchuzhishitype { get; set; }
        


    }
}

 zhengcaioa/IServices/ILiaotianService.cs

@@ -18,6 +18,7 @@

        List<SysCodeDtl> GetSYScode(string code_table, string code_field);

        List<SysCodeDtl> GetSYScodeshanchu(string code_table, string code_field);

        List<LiaotianDTO> SearchForPrint(LiaotianDTOSearch searchEntity);


 zhengcaioa/Model/zcUserInfoN_db/zcUserInfoN_dbContext.cs

@@ -26,7 +26,7 @@
            if (!optionsBuilder.IsConfigured)
            {
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263.
                optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=zcUserInfoN_db;User ID=sa;Password=123456");
                optionsBuilder.UseSqlServer("Data Source=172.26.97.147;Initial Catalog=zcUserInfoN_db;User ID=sa;Password=Za20222812");
            }
        }


 zhengcaioa/Model/zcweb/zcwebContext.cs

@@ -25,7 +25,7 @@
            if (!optionsBuilder.IsConfigured)
            {
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263.
                optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=zcweb;User ID=sa;Password=123456");
                optionsBuilder.UseSqlServer("Data Source=172.26.97.147;Initial Catalog=zcweb;User ID=sa;Password=Za20222812");
            }
        }


 zhengcaioa/Model/zhengcaioaContext.cs

@@ -143,7 +143,7 @@
            if (!optionsBuilder.IsConfigured)
            {
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263.
                optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=zhengcaioa;User ID=sa;Password=123456");
                optionsBuilder.UseSqlServer("Data Source=172.26.97.147;Initial Catalog=zhengcaioa;User ID=sa;Password=Za20222812");
            }
        }


 zhengcaioa/Services/ExpertTestTopicService.cs

@@ -186,8 +186,7 @@
            var listCode = (from a in _context.SysCodeDtls
                            join b in _context.SysCodes
                            on a.CodeId equals b.Id
                            where a.RecStatus == "A"
                                          && b.RecStatus == "A"
                            where  b.RecStatus == "A"
                            select new CodeDataEntity()
                            {
                                CodeId = b.Id,
@@ -281,7 +280,7 @@

                               && (string.IsNullOrWhiteSpace(searchEntity.Falv) || lll.Falv == searchEntity.Falv.Trim())


                                && (string.IsNullOrWhiteSpace(searchEntity.shanchuzhishitype) || a.Zhishitype == searchEntity.shanchuzhishitype.Trim()) 


                         select  new ExpertTestTopicDTO
@@ -837,8 +836,8 @@

                            join f in listCode.Where(x => x.CodeTable == "expert_test_topic" && x.CodeField == "zhishitype")
                       on a.Zhishitype equals f.CodeSn
                       into fsssss
                            from fff in fsssss.DefaultIfEmpty()
                       //into fsssss
                       //     from fff in fsssss.DefaultIfEmpty()


                            where a.RecStatus == "A"
@@ -850,7 +849,7 @@
                                Topictype = a.Topictype,
                                TopictypeName = eee.Comments,
                                Zhishitype = a.Zhishitype,
                                ZhishitypeName = fff.Comments,
                                ZhishitypeName = f.Comments,
                                Fenshu = a.Fenshu ?? 0,
                                Fenzhi = a.Fenzhi??0,
                                FenshuName = (a.Fenshu ?? 0).ToString("0.##"),

 zhengcaioa/Services/LiaotianService.cs

@@ -107,6 +107,27 @@

            return sysCodeDtls;
        }
        public List<SysCodeDtl> GetSYScodeshanchu(string code_table, string code_field)
        {


            List<SysCodeDtl> sysCodeDtls = (from e in _context.SysCodes
                                            join c in _context.SysCodeDtls
                                            on e.Id equals c.CodeId
                                            where e.RecStatus == "A"
                                            && c.RecStatus == "D"
                                            && e.CodeTable == code_table
                                            && e.CodeField == code_field
                                            select c).OrderBy(x => x.Sort).ToList();







            return sysCodeDtls;
        }

        public ResultDataEntity<LiaotianDTO> SearchByPaging(LiaotianDTOSearch searchEntity)
        {

 zhengcaioa/zhengcaioa/Controllers/ExpertTest/ExpertTestTopicController.cs

@@ -95,6 +95,7 @@
            ViewBag.shenpi_status = _liaotianService.GetSYScode("expert_test_topic", "shenpi_status").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.Falv = _liaotianService.GetSYScode("expert_test_topicjiexi", "falv").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();

            ViewBag.shanchuzhishitype = _liaotianService.GetSYScodeshanchu("expert_test_topic", "zhishitype").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();

            var areaDTOs = _areaService.GetList().Where(x => x.ParentId == "0     ").ToList();
            foreach (var areaDTO in areaDTOs)

 zhengcaioa/zhengcaioa/Model/UserPage.cs

@@ -27,10 +27,22 @@
        {
            List<PageEntity> entityList = new List<PageEntity>();

            var builder = new ConfigurationBuilder()
               .SetBasePath(Directory.GetCurrentDirectory())
            var connectionString = "";
                try
            {
                var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory())
            .AddJsonFile("appsettings.Development.json");
                connectionString = builder.Build().GetValue<string>("ConnectionStrings:" + "DefaultConnection");
            }
            catch
            {
                var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory())
               .AddJsonFile("appsettings.json");
            var connectionString = builder.Build().GetValue<string>("ConnectionStrings:" + "DefaultConnection");
                connectionString = builder.Build().GetValue<string>("ConnectionStrings:" + "DefaultConnection");

            }

            
            var dbContextOptionBuilder = new DbContextOptionsBuilder<zhengcaioaContext>();
            using (var db = new zhengcaioaContext(dbContextOptionBuilder.UseSqlServer(connectionString).Options))
            {

 zhengcaioa/zhengcaioa/Views/ExpertTestTopic/Index.cshtml

@@ -12,6 +12,7 @@
        var shenpi_status = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.shenpi_status))';
        var Area = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.Area))';
        var Falv = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.Falv))';
        var shanchuzhishitype = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.shanchuzhishitype))';
        loseherght = 60;
        dataCol = [
            { label: 'id', name: 'Id', labtype: 'txt', hidden: true },
@@ -56,7 +57,7 @@

            { label: '试题', name: 'Topic', labtype: 'txt', hidden: false },


            { label: '删除知识点', name: 'shanchuzhishitype', labtype: 'combox', hidden: false, data: JSON.parse(shanchuzhishitype), cwidth: '5%', cccwidth: '15%' },




 zhengcaioa/zhengcaioa/appsettings.json

@@ -1,8 +1,8 @@
{
  "ConnectionStrings": {
    "DefaultConnection": "server=localhost;database=zhengcaioa;uid=sa;pwd=123456;",
    "zcwebConnection": "server=localhost;database=zcweb;uid=sa;pwd=123456;",
    "zcUserInfoNConnection": "server=localhost;database=zcUserInfoN_db;uid=sa;pwd=123456;"
    "DefaultConnection": "server=172.26.97.147;database=zhengcaioa;uid=sa;pwd=Za20222812;",
    "zcwebConnection": "server=172.26.97.147;database=zcweb;uid=sa;pwd=Za20222812;",
    "zcUserInfoNConnection": "server=172.26.97.147;database=zcUserInfoN_db;uid=sa;pwd=Za20222812;"
  },
  "Logging": {
    "LogLevel": {