线下培训的订单

username@email.com

2021-07-07 fe1d552606aa8a989647ff12d7c124dd6ac5a1dd

线下培训的订单

 zhengcaioa/CommonToolsCore/AutoMapperConfigs.cs

@@ -206,6 +206,15 @@
            CreateMap<LZhuanjiahuidum, LZhuanjiahuidumDTO>();
            CreateMap<LZhuanjiahuidumDTO, LZhuanjiahuidum>();

            CreateMap<OrderBanci, OrderBanciDTO>();
            CreateMap<OrderBanciDTO, OrderBanci>();

            CreateMap<OrderBanciDtl, OrderBanciDtlDTO>();
            CreateMap<OrderBanciDtlDTO, OrderBanciDtl>();

            CreateMap<OrderBanciOrder, OrderBanciOrderDTO>();
            CreateMap<OrderBanciOrderDTO, OrderBanciOrder>();

        }
    }
}

 zhengcaioa/DTO/IntentionVisitDTO.cs

@@ -35,7 +35,9 @@
        public string Name { get; set; }

        public string IsYwjl { get; set; }
        

        public string DuanxinNeirong { get; set; }

    }

    public class IntentionVisitDTOSearch : SearchEntity

 zhengcaioa/DTO/OrderBanciDTO.cs

New file
@@ -0,0 +1,38 @@
using System;
using System.Collections.Generic;
using System.Text;

namespace DTO
{
    public class OrderBanciDTO
    {
        public string Id { get; set; }
        public string Banci { get; set; }
        public DateTime? Shijian { get; set; }
        public string ShijianName { get; set; }
        public DateTime? Shijianend { get; set; }
        public string ShijianendName { get; set; }
        public string Didian { get; set; }
        public string RecStatus { get; set; }
        public string Creater { get; set; }
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }
        public List<OrderBanciDtlDTO> orderBanciDtlDTOs{ get; set; }
        public string Mingcheng { get; set; }

        public int? Renshu { get; set; }
        
    }

    public class OrderBanciDTOSearch : SearchEntity
    {
        public string Banci { get; set; }

        public string Shijian { get; set; }

        public string Didian { get; set; }

        public string Createtime { get; set; }
    }
}

 zhengcaioa/DTO/OrderBanciDtlDTO.cs

New file
@@ -0,0 +1,30 @@
using System;
using System.Collections.Generic;
using System.Text;

namespace DTO
{
    public class OrderBanciDtlDTO
    {
        public string Id { get; set; }
        public string Shangxiawu { get; set; }
        public string ShangxiawuName { get; set; }
        public string Shijian { get; set; }
        public string Shixiamg { get; set; }
        public string Zhujiangren { get; set; }
        public string RecStatus { get; set; }
        public string Creater { get; set; }
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }
        public string OrderBanciId { get; set; }
        public int? Sort { get; set; }
    }

    public class OrderBanciDtlDTOSearch : SearchEntity
    {

        public string OrderBanciId { get; set; }
        public string Shixiamg { get; set; }
    }
}

 zhengcaioa/DTO/OrderBanciOrderDTO.cs

New file
@@ -0,0 +1,44 @@
using System;
using System.Collections.Generic;
using System.Text;

namespace DTO
{
    public class OrderBanciOrderDTO
    {
        public string Id { get; set; }
        public DateTime Baomingtime { get; set; }
        public string BaomingtimeName { get; set; }
        public string BanciId { get; set; }
        public string Peixunbanci { get; set; }
        public string KechengleixingId { get; set; }
        public string Kechengleixing { get; set; }
        public string PersonId { get; set; }
        public string Xingming { get; set; }
        public string Lianxidianhua { get; set; }
        public decimal? Xuefei { get; set; }
        public int? Baomingrenshu { get; set; }
        public decimal? Jine { get; set; }
        public string RecStatus { get; set; }
        public string Creater { get; set; }
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }

        public string Shenfenzheng { get; set; }
    }

    public class OrderBanciOrderDTOSearch : SearchEntity
    {
        public string Baomingtime { get; set; }

        public string Peixunbanci { get; set; }

        public string Kechengleixing { get; set; }

        public string Xingming { get; set; }
        public string Lianxidianhua { get; set; }

        public string BanciId { get; set; }
    }
}

 zhengcaioa/DTO/ProjectDTO.cs

@@ -120,5 +120,7 @@

        public string Shuliang { get; set; }

        public string Fenchadayu { get; set; }

    }
}

 zhengcaioa/IServices/IOrderBanciDtlService.cs

New file
@@ -0,0 +1,20 @@
using DTO;
using System;
using System.Collections.Generic;
using System.Text;


namespace IServices
{
    public interface IOrderBanciDtlService
    {
        ResultEntity save(OrderBanciDtlDTO dto);

        OrderBanciDtlDTO Get(string id);

        ResultDataEntity<OrderBanciDtlDTO> SearchByPaging(OrderBanciDtlDTOSearch searchEntity);
        ResultEntity ModifyStatus(string id, string userid);

        List<OrderBanciDtlDTO> GetList(string OrderBanciId = "");
    }
}

 zhengcaioa/IServices/IOrderBanciOrderService.cs

New file
@@ -0,0 +1,21 @@
using DTO;
using System;
using System.Collections.Generic;
using System.Text;


namespace IServices
{
    public interface IOrderBanciOrderService
    {
        ResultEntity save(OrderBanciOrderDTO dto);

        OrderBanciOrderDTO Get(string id);

        ResultDataEntity<OrderBanciOrderDTO> SearchByPaging(OrderBanciOrderDTOSearch searchEntity);

        ResultEntity ModifyStatus(string id, string userid);

        List<OrderBanciOrderDTO> GetList(string[] id);
    }
}

 zhengcaioa/IServices/IOrderBanciService.cs

New file
@@ -0,0 +1,21 @@
using DTO;
using System;
using System.Collections.Generic;
using System.Text;


namespace IServices
{
    public interface IOrderBanciService
    {
        ResultEntity save(OrderBanciDTO dto);

        OrderBanciDTO Get(string id);

        ResultDataEntity<OrderBanciDTO> SearchByPaging(OrderBanciDTOSearch searchEntity);

        ResultEntity ModifyStatus(string id, string userid);

        List<OrderBanciDTO> GetList();
    }
}

 zhengcaioa/Model/IntentionVisit.cs

@@ -23,5 +23,6 @@
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }
        public string DuanxinNeirong { get; set; }
    }
}

 zhengcaioa/Model/IntentionVisitDuanxin.cs

New file
@@ -0,0 +1,19 @@
using System;
using System.Collections.Generic;

#nullable disable

namespace zhengcaioa.Models
{
    public partial class IntentionVisitDuanxin
    {
        public string Id { get; set; }
        public string DuanxinTitle { get; set; }
        public string DuanxinNeirong { get; set; }
        public string RecStatus { get; set; }
        public string Creater { get; set; }
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }
    }
}

 zhengcaioa/Model/OrderBanci.cs

New file
@@ -0,0 +1,23 @@
using System;
using System.Collections.Generic;

#nullable disable

namespace zhengcaioa.Models
{
    public partial class OrderBanci
    {
        public string Id { get; set; }
        public string Banci { get; set; }
        public DateTime? Shijian { get; set; }
        public DateTime? Shijianend { get; set; }
        public string Didian { get; set; }
        public string RecStatus { get; set; }
        public string Creater { get; set; }
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }
        public string Mingcheng { get; set; }
        public int? Renshu { get; set; }
    }
}

 zhengcaioa/Model/OrderBanciDtl.cs

New file
@@ -0,0 +1,23 @@
using System;
using System.Collections.Generic;

#nullable disable

namespace zhengcaioa.Models
{
    public partial class OrderBanciDtl
    {
        public string Id { get; set; }
        public string OrderBanciId { get; set; }
        public string Shangxiawu { get; set; }
        public string Shijian { get; set; }
        public string Shixiamg { get; set; }
        public string Zhujiangren { get; set; }
        public int? Sort { get; set; }
        public string RecStatus { get; set; }
        public string Creater { get; set; }
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }
    }
}

 zhengcaioa/Model/OrderBanciOrder.cs

New file
@@ -0,0 +1,29 @@
using System;
using System.Collections.Generic;

#nullable disable

namespace zhengcaioa.Models
{
    public partial class OrderBanciOrder
    {
        public string Id { get; set; }
        public DateTime Baomingtime { get; set; }
        public string BanciId { get; set; }
        public string Peixunbanci { get; set; }
        public string KechengleixingId { get; set; }
        public string Kechengleixing { get; set; }
        public string PersonId { get; set; }
        public string Xingming { get; set; }
        public string Lianxidianhua { get; set; }
        public decimal? Xuefei { get; set; }
        public int? Baomingrenshu { get; set; }
        public decimal? Jine { get; set; }
        public string RecStatus { get; set; }
        public string Creater { get; set; }
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }
        public string Shenfenzheng { get; set; }
    }
}

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -67,9 +67,13 @@
        public virtual DbSet<IntentionCustomer> IntentionCustomers { get; set; }
        public virtual DbSet<IntentionOrder> IntentionOrders { get; set; }
        public virtual DbSet<IntentionVisit> IntentionVisits { get; set; }
        public virtual DbSet<IntentionVisitDuanxin> IntentionVisitDuanxins { get; set; }
        public virtual DbSet<Liaotian> Liaotians { get; set; }
        public virtual DbSet<LZhuanjiahuidum> LZhuanjiahuida { get; set; }
        public virtual DbSet<Oayouhui> Oayouhuis { get; set; }
        public virtual DbSet<OrderBanci> OrderBancis { get; set; }
        public virtual DbSet<OrderBanciDtl> OrderBanciDtls { get; set; }
        public virtual DbSet<OrderBanciOrder> OrderBanciOrders { get; set; }
        public virtual DbSet<PltAuth> PltAuths { get; set; }
        public virtual DbSet<PltPage> PltPages { get; set; }
        public virtual DbSet<PltRole> PltRoles { get; set; }
@@ -2180,7 +2184,7 @@
                    .HasComment("会费");

                entity.Property(e => e.MemberAuthority)
                    .HasMaxLength(100)
                    .HasMaxLength(500)
                    .HasColumnName("member_authority")
                    .HasComment("会员权限");

@@ -3163,6 +3167,10 @@
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.DuanxinNeirong)
                    .HasMaxLength(500)
                    .HasColumnName("duanxin_neirong");

                entity.Property(e => e.Jdr)
                    .HasMaxLength(500)
                    .HasColumnName("jdr")
@@ -3230,6 +3238,49 @@
                    .HasMaxLength(50)
                    .HasColumnName("zw")
                    .HasComment("职务");
            });

            modelBuilder.Entity<IntentionVisitDuanxin>(entity =>
            {
                entity.ToTable("IntentionVisit_duanxin");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.DuanxinNeirong)
                    .HasMaxLength(500)
                    .HasColumnName("duanxin_neirong");

                entity.Property(e => e.DuanxinTitle)
                    .HasMaxLength(50)
                    .HasColumnName("duanxin_title");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
            });

            modelBuilder.Entity<Liaotian>(entity =>
@@ -3408,6 +3459,205 @@
                    .HasComment("优惠类型");
            });

            modelBuilder.Entity<OrderBanci>(entity =>
            {
                entity.ToTable("order_banci");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Mingcheng)
                    .HasMaxLength(100)
                    .HasColumnName("mingcheng");

                entity.Property(e => e.Banci)
                   .HasMaxLength(100)
                   .HasColumnName("banci");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Didian)
                    .HasMaxLength(500)
                    .HasColumnName("didian");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");


                entity.Property(e => e.Renshu)
                    .HasColumnName("renshu");

                entity.Property(e => e.Shijian)
                    .HasColumnType("datetime")
                    .HasColumnName("shijian");

                entity.Property(e => e.Shijianend)
                    .HasColumnType("datetime")
                    .HasColumnName("shijianend");
            });

            modelBuilder.Entity<OrderBanciDtl>(entity =>
            {
                entity.ToTable("order_banci_dtl");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.OrderBanciId)
                    .HasMaxLength(50)
                    .HasColumnName("order_banci_id");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Shangxiawu)
                    .HasMaxLength(100)
                    .HasColumnName("shangxiawu");

                entity.Property(e => e.Shijian)
                    .HasMaxLength(100)
                    .HasColumnName("shijian");

                entity.Property(e => e.Shixiamg)
                    .HasMaxLength(500)
                    .HasColumnName("shixiamg");

                entity.Property(e => e.Sort)
                    .HasColumnName("sort")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Zhujiangren)
                    .HasMaxLength(100)
                    .HasColumnName("zhujiangren");
            });

            modelBuilder.Entity<OrderBanciOrder>(entity =>
            {
                entity.ToTable("order_banci_order");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.BanciId)
                    .HasMaxLength(50)
                    .HasColumnName("banci_id");

                entity.Property(e => e.Baomingrenshu).HasColumnName("baomingrenshu");

                entity.Property(e => e.Baomingtime)
                    .HasColumnType("datetime")
                    .HasColumnName("baomingtime");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Jine)
                    .HasColumnType("money")
                    .HasColumnName("jine");

                entity.Property(e => e.Kechengleixing)
                    .HasMaxLength(100)
                    .HasColumnName("kechengleixing");

                entity.Property(e => e.KechengleixingId)
                    .HasMaxLength(50)
                    .HasColumnName("kechengleixing_id");

                entity.Property(e => e.Lianxidianhua)
                    .HasMaxLength(100)
                    .HasColumnName("lianxidianhua");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Peixunbanci)
                    .HasMaxLength(100)
                    .HasColumnName("peixunbanci");

                entity.Property(e => e.PersonId)
                    .HasMaxLength(100)
                    .HasColumnName("person_id");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Shenfenzheng)
                  .HasMaxLength(100)
                  .HasColumnName("shenfenzheng");

                entity.Property(e => e.Xingming)
                    .HasMaxLength(100)
                    .HasColumnName("xingming");

                entity.Property(e => e.Xuefei)
                    .HasColumnType("money")
                    .HasColumnName("xuefei");
            });

            modelBuilder.Entity<PltAuth>(entity =>
            {
                entity.ToTable("plt_auth");

 zhengcaioa/Services/IntentionVisitService.cs

@@ -60,6 +60,7 @@
                    updateproject.RecStatus = entity.RecStatus;
                    updateproject.Modifier = entity.Modifier;
                    updateproject.Modifytime = entity.Modifytime;
                    updateproject.DuanxinNeirong = entity.DuanxinNeirong;

                }

@@ -134,19 +135,46 @@
            var query = (from a in _context.IntentionVisits
                         join b in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "visType")
                         on a.VisType equals b.CodeSn
                          into bzsssss
                         from bzzzzz in bzsssss.DefaultIfEmpty()

                         join c in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jtype")
                         on a.Jtype equals c.CodeSn
                           into czsssss
                         from czzzzz in czsssss.DefaultIfEmpty()

                         join d in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "zw")
                          on a.Zw equals d.CodeSn
                            into dzsssss
                         from dzzzzz in dzsssss.DefaultIfEmpty()

                         join e in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "yx")
                         on a.Yx equals e.CodeSn
                           into ezsssss
                         from ezzzzz in ezsssss.DefaultIfEmpty()

                         join f in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jy")
                          on a.Jy equals f.CodeSn
                            into fzsssss
                         from fzzzzz in fzsssss.DefaultIfEmpty()

                         join zz in _context.IntentionCustomers.Where(x => x.RecStatus == "A")
                         on a.Viscustomer equals zz.Id
                         join g in _context.Areas on zz.Sheng equals g.CodeId
                         join h in _context.Areas on zz.City equals h.CodeId
                         join i in _context.Areas on zz.AreaId equals i.CodeId
                           into zzzsssss
                         from zzzzzzz in zzzsssss.DefaultIfEmpty()

                         //join g in _context.Areas on zzzzzzz.Sheng equals g.CodeId
                         //into gzsssss
                         //from gzzzzz in gzsssss.DefaultIfEmpty()

                         //join h in _context.Areas on zzzzzzz.City equals h.CodeId
                         //into hzsssss
                         //from hzzzzz in hzsssss.DefaultIfEmpty()

                         //join i in _context.Areas on zzzzzzz.AreaId equals i.CodeId
                         //into izsssss
                         //from izzzzz in izsssss.DefaultIfEmpty()


                         join zzz in _context.PltUsers.Where(x => x.RecStatus == "A")
                         on a.Creater equals zzz.Id
@@ -158,31 +186,31 @@

                         where a.RecStatus == "A"
                          && (string.IsNullOrWhiteSpace(searchEntity.Vistime) || (a.Vistime >= Vistimestart && a.Vistime <= Vistimeend))
                         && (string.IsNullOrWhiteSpace(searchEntity.Name) || zz.Name.Contains(searchEntity.Name.Trim()))
                          && (string.IsNullOrWhiteSpace(searchEntity.Khly) || zz.Khly == searchEntity.Khly.Trim())
                           && (string.IsNullOrWhiteSpace(searchEntity.Hyfl) || zz.Hyfl == searchEntity.Hyfl.Trim())
                            && (string.IsNullOrWhiteSpace(searchEntity.Khlx) || zz.Khlx == searchEntity.Khlx.Trim())
                             && (string.IsNullOrWhiteSpace(searchEntity.Ywjl) || zz.Ywjl == searchEntity.Ywjl.Trim())
                              && (string.IsNullOrWhiteSpace(searchEntity.Sheng) || zz.Sheng == searchEntity.Sheng.Trim())
                               && (string.IsNullOrWhiteSpace(searchEntity.City) || zz.City == searchEntity.City.Trim())
                                && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || zz.AreaId == searchEntity.AreaId.Trim())
                         && (string.IsNullOrWhiteSpace(searchEntity.Name) || zzzzzzz.Name.Contains(searchEntity.Name.Trim()))
                          && (string.IsNullOrWhiteSpace(searchEntity.Khly) || zzzzzzz.Khly == searchEntity.Khly.Trim())
                           && (string.IsNullOrWhiteSpace(searchEntity.Hyfl) || zzzzzzz.Hyfl == searchEntity.Hyfl.Trim())
                            && (string.IsNullOrWhiteSpace(searchEntity.Khlx) || zzzzzzz.Khlx == searchEntity.Khlx.Trim())
                             && (string.IsNullOrWhiteSpace(searchEntity.Ywjl) || zzzzzzz.Ywjl == searchEntity.Ywjl.Trim())
                              && (string.IsNullOrWhiteSpace(searchEntity.Sheng) || zzzzzzz.Sheng == searchEntity.Sheng.Trim())
                               && (string.IsNullOrWhiteSpace(searchEntity.City) || zzzzzzz.City == searchEntity.City.Trim())
                                && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || zzzzzzz.AreaId == searchEntity.AreaId.Trim())
                                && (string.IsNullOrWhiteSpace(searchEntity.Viscustomer) || a.Viscustomer == searchEntity.Viscustomer.Trim())
                                 && (string.IsNullOrWhiteSpace(searchEntity.Creater) || zz.Creater == searchEntity.Creater.Trim())
                                 && (string.IsNullOrWhiteSpace(searchEntity.Creater) || a.Creater == searchEntity.Creater.Trim())
                         select new IntentionVisitDTO
                         {
                             Id = a.Id,
                             Vistime = a.Vistime,
                             VisType = a.VisType,
                             Viscustomer = a.Viscustomer,
                             Name = zz.Name,
                             Name = zzzzzzz.Name,
                             Jtype = a.Jtype,
                             Jdr = a.Jdr,
                             ShengName = g.Name + "-" + h.Name + "-" + i.Name,
                             VisTypeName = b.Comments,
                             JtypeName = c.Comments,
                             ZwName = d.Comments,
                             YxName = e.Comments,
                             JyName = f.Comments,
                             //ShengName = gzzzzz.Name + "-" + hzzzzz.Name + "-" + izzzzz.Name,
                             VisTypeName = bzzzzz.Comments,
                             JtypeName = czzzzz.Comments,
                             ZwName = dzzzzz.Comments,
                             YxName = ezzzzz.Comments,
                             JyName = fzzzzz.Comments,
                             Zw = a.Zw,
                             Talk = a.Talk,
                             Khfk = a.Khfk,
@@ -197,6 +225,7 @@
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,
                             VistimeName = a.Vistime.ToString("yyyy-MM-dd"),
                             DuanxinNeirong = a.DuanxinNeirong,
                         }
                ).OrderByDescending(x => x.Vistime).ToList();


 zhengcaioa/Services/OrderBanciDtlService.cs

New file
@@ -0,0 +1,221 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AutoMapper;
using DTO;
using IServices;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;
using zhengcaioa.Models;



namespace Services
{
    public class OrderBanciDtlService: IOrderBanciDtlService
    {
        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public OrderBanciDtlService(zhengcaioaContext context, IMapper mapper)
        {
            _context = context;
            _mapper = mapper;
        }
        public ResultEntity save(OrderBanciDtlDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                

                var entity = _mapper.Map<OrderBanciDtl>(dto);


                if (String.IsNullOrEmpty(entity.Id))
                {
                    entity.Id = Guid.NewGuid().ToString();
                    dto.Id = entity.Id;
                    _context.OrderBanciDtls.Add(entity);
                }
                else
                {
                    var updateproject = _context.OrderBanciDtls.Find(entity.Id);

                    updateproject.Shangxiawu = entity.Shangxiawu;
                    updateproject.Shijian = entity.Shijian;
                    
                    updateproject.Shixiamg = entity.Shixiamg;
                    updateproject.Zhujiangren = entity.Zhujiangren;

                    updateproject.RecStatus = entity.RecStatus;
                    updateproject.Modifier = entity.Modifier;
                    updateproject.Modifytime = entity.Modifytime;
                    updateproject.Sort = entity.Sort;
                    updateproject.OrderBanciId = entity.OrderBanciId;

                }

                _context.SaveChanges();
                resultEntity.ReturnID = entity.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";

            }
            return resultEntity;
        }

        public OrderBanciDtlDTO Get(string id)
        {

            var entity = _context.OrderBanciDtls.Find(id);

            if (entity.RecStatus != "A")
            {
                entity = new OrderBanciDtl();
            }

            var result = _mapper.Map<OrderBanciDtlDTO>(entity);


            return result;
        }

        public ResultDataEntity<OrderBanciDtlDTO> SearchByPaging(OrderBanciDtlDTOSearch searchEntity)
        {



            ResultDataEntity<OrderBanciDtlDTO> data = new ResultDataEntity<OrderBanciDtlDTO>();
            List<OrderBanciDtlDTO> list = new List<OrderBanciDtlDTO>();



            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"
                            select new CodeDataEntity()
                            {
                                CodeId = b.Id,
                                CodeTable = b.CodeTable,
                                CodeField = b.CodeField,
                                CodeSn = a.CodeSn,
                                Comments = a.Comments,
                                Contents = a.Contents,
                                RecStatus = a.RecStatus,
                                Sort = a.Sort
                            }
            );

            ///OrderBanciDtls
            ///




            var query = (from a in _context.OrderBanciDtls

                         join d in listCode.Where(x => x.CodeTable == "order_banci_dtl" && x.CodeField == "shangxiawu")
                        on a.Shangxiawu equals d.CodeSn
                          into dzsssss
                         from dzzzzz in dzsssss.DefaultIfEmpty()


                         where a.RecStatus == "A"


                          && (string.IsNullOrWhiteSpace(searchEntity.OrderBanciId) || a.OrderBanciId == searchEntity.OrderBanciId.Trim())

                            && (string.IsNullOrWhiteSpace(searchEntity.Shixiamg) || a.Shixiamg.Contains(searchEntity.Shixiamg.Trim()))
                          


                         select new OrderBanciDtlDTO
                         {
                             Id = a.Id,
                             OrderBanciId = a.OrderBanciId,
                             Shangxiawu = a.Shangxiawu,
                             Shijian = a.Shijian,
                             Shixiamg = a.Shixiamg,
                            Zhujiangren = a.Zhujiangren,
                            Sort = a.Sort,
                             ShangxiawuName = dzzzzz.Comments,





                             Creater = a.Creater,
                             Createtime = a.Createtime,

                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,

                         }
                ).OrderBy(x => x.Sort).ToList();



            if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            data.LoadData(searchEntity, lianlist);
            return data;
        }
 






        /// <summary>
        /// ä¿®æ”¹ä¸»è¡¨çŠ¶æ€
        /// </summary>
        /// <param name="id">主id</param>
        /// <param name="userid">用户</param>
        /// <returns></returns>
        public ResultEntity ModifyStatus(string id, string userid)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;

            var model = _context.OrderBanciDtls.Find(id);
            if (model != null)
            {
                model.RecStatus = "D";
                model.Modifier = userid;
                model.Modifytime = DateTime.Now;
                _context.SaveChanges();
            }

            return result;
        }


        /// <summary>
        /// èŽ·å–所有有效角色
        /// </summary>
        /// <returns></returns>
        public List<OrderBanciDtlDTO> GetList(string OrderBanciId = "")
        {


            var listRole = _context.OrderBanciDtls.Where(r => r.RecStatus == "A").OrderBy(x => x.Sort).ToList();
            if (!string.IsNullOrEmpty(OrderBanciId))
            {
                listRole = listRole.Where(x => x.OrderBanciId == OrderBanciId).ToList();
            }

            var list = _mapper.Map<List<OrderBanciDtlDTO>>(listRole);
            return list;
        }
    }
}

 zhengcaioa/Services/OrderBanciOrderService.cs

New file
@@ -0,0 +1,250 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AutoMapper;
using DTO;
using IServices;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;
using zhengcaioa.Models;



namespace Services
{
    public class OrderBanciOrderService: IOrderBanciOrderService
    {
        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public OrderBanciOrderService(zhengcaioaContext context, IMapper mapper)
        {
            _context = context;
            _mapper = mapper;
        }
        public ResultEntity save(OrderBanciOrderDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {


                var entity = _mapper.Map<OrderBanciOrder>(dto);


                if (String.IsNullOrEmpty(entity.Id))
                {
                    entity.Id = Guid.NewGuid().ToString();
                    dto.Id = entity.Id;
                    _context.OrderBanciOrders.Add(entity);
                }
                else
                {
                    var updateproject = _context.OrderBanciOrders.Find(entity.Id);

                    updateproject.Baomingtime = entity.Baomingtime;
                    updateproject.BanciId = entity.BanciId;

                    updateproject.Peixunbanci = entity.Peixunbanci;
                    updateproject.KechengleixingId = entity.KechengleixingId;
                    updateproject.Kechengleixing = entity.Kechengleixing;
                    updateproject.PersonId = entity.PersonId;
                    updateproject.Xingming = entity.Xingming;
                    updateproject.Lianxidianhua = entity.Lianxidianhua;
                    updateproject.Xuefei = entity.Xuefei;
                    updateproject.Baomingrenshu = entity.Baomingrenshu;
                    

                    updateproject.RecStatus = entity.RecStatus;
                    updateproject.Modifier = entity.Modifier;
                    updateproject.Modifytime = entity.Modifytime;
                    updateproject.Shenfenzheng = entity.Shenfenzheng;
                }

                _context.SaveChanges();
                resultEntity.ReturnID = entity.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";

            }
            return resultEntity;
        }

        public OrderBanciOrderDTO Get(string id)
        {

            var entity = _context.OrderBanciOrders.Find(id);

            if (entity.RecStatus != "A")
            {
                entity = new OrderBanciOrder();
            }

            var result = _mapper.Map<OrderBanciOrderDTO>(entity);


            return result;
        }

        public ResultDataEntity<OrderBanciOrderDTO> SearchByPaging(OrderBanciOrderDTOSearch searchEntity)
        {



            ResultDataEntity<OrderBanciOrderDTO> data = new ResultDataEntity<OrderBanciOrderDTO>();
            List<OrderBanciOrderDTO> list = new List<OrderBanciOrderDTO>();



            //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"
            //                select new CodeDataEntity()
            //                {
            //                    CodeId = b.Id,
            //                    CodeTable = b.CodeTable,
            //                    CodeField = b.CodeField,
            //                    CodeSn = a.CodeSn,
            //                    Comments = a.Comments,
            //                    Contents = a.Contents,
            //                    RecStatus = a.RecStatus,
            //                    Sort = a.Sort
            //                }
            //);

            ///OrderBanciOrders
            ///
            DateTime Baomingtimestart = DateTime.Now;
            DateTime Baomingtimeend = DateTime.Now;
            if (!string.IsNullOrWhiteSpace(searchEntity.Baomingtime))
            {
                string[] Baomingtimes = searchEntity.Baomingtime.Split("|");
                DateTime.TryParse(Baomingtimes[0], out Baomingtimestart);
                DateTime.TryParse(Baomingtimes[1], out Baomingtimeend);
                Baomingtimeend = Baomingtimeend.AddDays(1);
            }

            var query = (from a in _context.OrderBanciOrders




                         where a.RecStatus == "A"
                              && (string.IsNullOrWhiteSpace(searchEntity.Baomingtime) || (a.Baomingtime >= Baomingtimestart && a.Baomingtime <= Baomingtimeend))
                          && (string.IsNullOrWhiteSpace(searchEntity.Peixunbanci) || a.Peixunbanci.Contains(searchEntity.Peixunbanci.Trim()))
                       
                          && (string.IsNullOrWhiteSpace(searchEntity.Kechengleixing) || a.KechengleixingId == searchEntity.Kechengleixing.Trim())

                           && (string.IsNullOrWhiteSpace(searchEntity.Xingming) || a.Xingming.Contains(searchEntity.Xingming.Trim()))

                            && (string.IsNullOrWhiteSpace(searchEntity.Lianxidianhua) || a.Lianxidianhua.Contains(searchEntity.Lianxidianhua.Trim()))

                              && (string.IsNullOrWhiteSpace(searchEntity.BanciId) || a.BanciId == searchEntity.BanciId.Trim())






                         select new OrderBanciOrderDTO
                         {
                             Id = a.Id,
                            
                             Baomingtime = a.Baomingtime,
                             BaomingtimeName =  a.Baomingtime.ToString("yyyy-MM-dd"),
                             BanciId = a.BanciId,
                             Peixunbanci = a.Peixunbanci,
                          

                             KechengleixingId = a.KechengleixingId,

                             Kechengleixing = a.Kechengleixing,

                             PersonId = a.PersonId,
                             Xingming = a.Xingming,
                             Lianxidianhua = a.Lianxidianhua,
                             Xuefei = a.Xuefei??0,
                             Baomingrenshu = a.Baomingrenshu??0,
                             Jine = a.Jine??0,


                             Creater = a.Creater,
                             Createtime = a.Createtime,

                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,
                             Shenfenzheng = a.Shenfenzheng,

                         }
                ).OrderByDescending(x => x.Baomingtime).ThenByDescending(x=>x.Modifytime).ToList();



            if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            data.LoadData(searchEntity, lianlist);
            return data;
        }






        /// <summary>
        /// ä¿®æ”¹ä¸»è¡¨çŠ¶æ€
        /// </summary>
        /// <param name="id">主id</param>
        /// <param name="userid">用户</param>
        /// <returns></returns>
        public ResultEntity ModifyStatus(string id, string userid)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;

            var model = _context.OrderBanciOrders.Find(id);
            if (model != null)
            {
                model.RecStatus = "D";
                model.Modifier = userid;
                model.Modifytime = DateTime.Now;
                _context.SaveChanges();
            }

            return result;
        }


        /// <summary>
        /// èŽ·å–所有有效角色
        /// </summary>
        /// <returns></returns>
        public List<OrderBanciOrderDTO> GetList(string[] id)
        {

            List<OrderBanciOrderDTO> result = new List<OrderBanciOrderDTO>();
            

            if (id != null)
            {
                var listRole = _context.OrderBanciOrders.Where(r => r.RecStatus == "A" &&  id.Contains(r.Id)).ToList();

               

                result = _mapper.Map<List<OrderBanciOrderDTO>>(listRole);
            }


           
            return result;
        }
    }
}

 zhengcaioa/Services/OrderBanciService.cs

New file
@@ -0,0 +1,221 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AutoMapper;
using DTO;
using IServices;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;
using zhengcaioa.Models;



namespace Services
{
    public class OrderBanciService: IOrderBanciService
    {
        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public OrderBanciService(zhengcaioaContext context, IMapper mapper)
        {
            _context = context;
            _mapper = mapper;
        }
        public ResultEntity save(OrderBanciDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                

                var entity = _mapper.Map<OrderBanci>(dto);


                if (String.IsNullOrEmpty(entity.Id))
                {
                    entity.Id = Guid.NewGuid().ToString();
                    dto.Id = entity.Id;
                    _context.OrderBancis.Add(entity);
                }
                else
                {
                    var updateproject = _context.OrderBancis.Find(entity.Id);

                    updateproject.Banci = entity.Banci;
                    updateproject.Shijian = entity.Shijian;

                    updateproject.Shijianend = entity.Shijianend;
                    updateproject.Didian = entity.Didian;

                    updateproject.RecStatus = entity.RecStatus;
                    updateproject.Modifier = entity.Modifier;
                    updateproject.Modifytime = entity.Modifytime;
                    updateproject.Mingcheng = entity.Mingcheng;
                    updateproject.Renshu = entity.Renshu; 
                }

                _context.SaveChanges();
                resultEntity.ReturnID = entity.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";

            }
            return resultEntity;
        }

        public OrderBanciDTO Get(string id)
        {

            var entity = _context.OrderBancis.Find(id);

            if (entity.RecStatus != "A")
            {
                entity = new OrderBanci();
            }

            var result = _mapper.Map<OrderBanciDTO>(entity);


            return result;
        }

        public ResultDataEntity<OrderBanciDTO> SearchByPaging(OrderBanciDTOSearch searchEntity)
        {



            ResultDataEntity<OrderBanciDTO> data = new ResultDataEntity<OrderBanciDTO>();
            List<OrderBanciDTO> list = new List<OrderBanciDTO>();



            //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"
            //                select new CodeDataEntity()
            //                {
            //                    CodeId = b.Id,
            //                    CodeTable = b.CodeTable,
            //                    CodeField = b.CodeField,
            //                    CodeSn = a.CodeSn,
            //                    Comments = a.Comments,
            //                    Contents = a.Contents,
            //                    RecStatus = a.RecStatus,
            //                    Sort = a.Sort
            //                }
            //);

            ///OrderBancis
            ///
            DateTime Shijianstart = DateTime.Now;
            DateTime Shijianend = DateTime.Now;
            if (!string.IsNullOrWhiteSpace(searchEntity.Shijian))
            {
                string[] Shijians = searchEntity.Shijian.Split("|");
                DateTime.TryParse(Shijians[0], out Shijianstart);
                DateTime.TryParse(Shijians[1], out Shijianend);
                //Shijianend = Shijianend.AddDays(1);
            }

            var query = (from a in _context.OrderBancis


                        

                         where a.RecStatus == "A"

                          && (string.IsNullOrWhiteSpace(searchEntity.Banci) || a.Banci.Contains(searchEntity.Banci.Trim()))
                            && (string.IsNullOrWhiteSpace(searchEntity.Shijian) || (a.Shijian >= Shijianstart && a.Shijian <= Shijianend))
                          && (string.IsNullOrWhiteSpace(searchEntity.Didian) || a.Didian.Contains(searchEntity.Didian.Trim()))

                           && (string.IsNullOrWhiteSpace(searchEntity.Createtime) || a.Shijian >= DateTime.Parse(searchEntity.Createtime) )




                         select new OrderBanciDTO
                         {
                             Id = a.Id,
                             Banci = a.Banci,
                             Shijian = a.Shijian,
                             ShijianName = a.Shijian.HasValue? a.Shijian.Value.ToString("yyyy-MM-dd HH:mm"):"",
                             Didian = a.Didian,
                             Shijianend = a.Shijianend,
                             ShijianendName = a.Shijianend.HasValue ? a.Shijianend.Value.ToString("yyyy-MM-dd HH:mm") : "",

                             Mingcheng = a.Mingcheng,

                             Renshu = a.Renshu??0,


                             Creater = a.Creater,
                             Createtime = a.Createtime,

                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,

                         }
                ).OrderByDescending(x => x.Modifytime).ToList();



            if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            data.LoadData(searchEntity, lianlist);
            return data;
        }






        /// <summary>
        /// ä¿®æ”¹ä¸»è¡¨çŠ¶æ€
        /// </summary>
        /// <param name="id">主id</param>
        /// <param name="userid">用户</param>
        /// <returns></returns>
        public ResultEntity ModifyStatus(string id, string userid)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;

            var model = _context.OrderBancis.Find(id);
            if (model != null)
            {
                model.RecStatus = "D";
                model.Modifier = userid;
                model.Modifytime = DateTime.Now;
                _context.SaveChanges();
            }

            return result;
        }


        /// <summary>
        /// èŽ·å–所有有效角色
        /// </summary>
        /// <returns></returns>
        public List<OrderBanciDTO> GetList()
        {


            var listRole = _context.OrderBancis.Where(r => r.RecStatus == "A").ToList();
           

            var list = _mapper.Map<List<OrderBanciDTO>>(listRole);
            return list;
        }
    }
}

 zhengcaioa/Services/ProjectService.cs

@@ -334,6 +334,15 @@
                }
            }

            if (!string.IsNullOrWhiteSpace(searchEntity.Fenchadayu))
            {
                decimal aaaa = 0;
                decimal.TryParse(searchEntity.Fenchadayu, out aaaa);
                if (aaaa > 0)
                {
                    sql.Append(" and exists ( select b.[ProjectId] from [Projectzhongbiao] b  where  a.[Id]=b.[ProjectId] and  (b.[defen]-a.[drhx_defen])  >= " + aaaa + " ) ");
                }
            }

            if (!string.IsNullOrWhiteSpace(searchEntity.Shuliang))
            {

 zhengcaioa/zhengcaioa/Controllers/BusinessOrder/CooperOrderController.cs

@@ -740,7 +740,7 @@

            if (OrderType == "02" )
            {
                if(OrderType1== "电话咨询" || OrderType1 == "当面咨询" || OrderType1 == "代拟质疑答复" || OrderType1 == "代拟投诉处理决定" || OrderType1 == "竞争对手和评审专家查询" || OrderType1 == "政采贷")
                if(OrderType1== "电话咨询" || OrderType1 == "当面咨询" || OrderType1 == "代拟质疑答复" || OrderType1 == "代拟投诉处理决定" || OrderType1 == "竞争对手和评审专家参加政府采购数据信息查询" || OrderType1 == "政采贷")
                {
                    var shi = _fiServiceService.GetList().Where(x => x.ServiceTypeTop == OrderType && x.ServiceType == OrderType1).FirstOrDefault();
                    result = JsonConvert.SerializeObject(shi);

 zhengcaioa/zhengcaioa/Controllers/BusinessOrder/OrderBanciController.cs

New file
@@ -0,0 +1,324 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AutoMapper;
using AngleSharp.Html.Parser;
using DTO;
using IServices;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Bot.Builder.Integration.AspNet.Core;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using System.Net.Http;
using System.Threading.Tasks;
using zhengcaioa.Models;
using zhengcaioa.IService;
using CommonToolsCore;
using Services;

namespace zhengcaioa.Controllers.BusinessOrder
{
   
    public class OrderBanciController : Controller
    {
        private readonly ILogger<OrderBanciController> _logger;
        private readonly ILiaotianService _liaotianService;
        private readonly IOrderBanciService _orderBanciService;
        private readonly IOrderBanciDtlService _orderBanciDtlService;


        public OrderBanciController(ILogger<OrderBanciController> logger, ILiaotianService liaotianService, IOrderBanciService orderBanciService, IOrderBanciDtlService orderBanciDtlService)
        {
            _logger = logger;
            _liaotianService = liaotianService;
            _orderBanciService = orderBanciService;
            _orderBanciDtlService = orderBanciDtlService;
        }

        [CheckLogin]
        public IActionResult Index()
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            List<ActionEntity> actionlist = new List<ActionEntity>();
            ActionEntity actionEntity = new ActionEntity();
            actionEntity.OpenType = 0;
            actionEntity.ActionUrl = "";
            actionEntity.ActionFun = "Search";
            actionEntity.PageIco = "fa fa-search";
            actionEntity.ActionName = "查询";
            actionlist.Add(actionEntity);
            ActionEntity actionEntity1 = new ActionEntity();
            actionEntity1.OpenType = 0;
            actionEntity1.ActionUrl = "";
            actionEntity1.ActionFun = "Add";
            actionEntity1.PageIco = "fa fa-plus";
            actionEntity1.ActionName = "新增";
            actionlist.Add(actionEntity1);
            ViewData["ActionInfo"] = actionlist;



           

            return View();

        }
        [CheckLogin]
        public IActionResult GetList(OrderBanciDTOSearch search)
        {
            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());
            return new JsonResult(_orderBanciService.SearchByPaging(search));
        }
        [CheckLogin]
        public IActionResult Edit(string id = null)
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;

            OrderBanciDTO dto = new OrderBanciDTO();
            if (!String.IsNullOrEmpty(id))
            {
                dto = _orderBanciService.Get(id);
                if (dto.Shijian.HasValue)
                {
                    dto.ShijianName = dto.Shijian.Value.ToString("yyyy-MM-dd HH:mm");
                }
                if (dto.Shijianend.HasValue)
                {
                    dto.ShijianendName = dto.Shijianend.Value.ToString("yyyy-MM-dd HH:mm");
                }

            }
            else
            {
                dto.Shijian = DateTime.Now;
                dto.ShijianName = dto.Shijian.Value.ToString("yyyy-MM-dd HH:mm");
                dto.Shijianend = DateTime.Now;
                dto.ShijianendName = dto.Shijianend.Value.ToString("yyyy-MM-dd HH:mm");
            }





            
           



            ViewData.Model = dto;
            return View();
        }


        /// <summary>
        /// ä¿å­˜
        /// </summary>
        /// <param name="data">岗位实体类对象</param>
        /// <returns></returns>
        /// 
        [CheckLogin]
        [HttpPost]
        public IActionResult Save(OrderBanciDTO data)
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            data.RecStatus = "A";
            if (String.IsNullOrEmpty(data.Id))
            {
                data.Creater = curentuser.Id;
                data.Createtime = DateTime.Now;
            }
            data.Modifier = curentuser.Id;
            data.Modifytime = DateTime.Now;

            ResultEntity resultEntity = _orderBanciService.save(data);

            return new JsonResult(resultEntity);
        }


        /// <summary>
        /// åˆ é™¤ä¸»ä¿¡æ¯
        /// </summary>
        /// <param name="info">实体</param>
        /// <returns></returns>
        /// 
        [CheckLogin]
        public IActionResult Nullify(string Id = "")
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            return new JsonResult(_orderBanciService.ModifyStatus(Id, curentuser.Id));
        }





        [CheckLogin]
        public IActionResult IndexDtl(string OrderBanciId)
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            List<ActionEntity> actionlist = new List<ActionEntity>();
            ActionEntity actionEntity = new ActionEntity();
            actionEntity.OpenType = 0;
            actionEntity.ActionUrl = "";
            actionEntity.ActionFun = "Search";
            actionEntity.PageIco = "fa fa-search";
            actionEntity.ActionName = "查询";
            actionlist.Add(actionEntity);
            ActionEntity actionEntity1 = new ActionEntity();
            actionEntity1.OpenType = 0;
            actionEntity1.ActionUrl = "";
            actionEntity1.ActionFun = "Add";
            actionEntity1.PageIco = "fa fa-plus";
            actionEntity1.ActionName = "新增";
            actionlist.Add(actionEntity1);
            ViewData["ActionInfo"] = actionlist;

            ViewBag.OrderBanciId = OrderBanciId;



            return View();

        }
        [CheckLogin]
        public IActionResult GetListDtl(OrderBanciDtlDTOSearch search)
        {
            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());
            return new JsonResult(_orderBanciDtlService.SearchByPaging(search));
        }
        [CheckLogin]
        public IActionResult EditDtl(string id = null,string OrderBanciId = null)
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;

            OrderBanciDtlDTO dto = new OrderBanciDtlDTO();
            if (!String.IsNullOrEmpty(id))
            {
                dto = _orderBanciDtlService.Get(id);
                

            }
            else
            {
                dto.OrderBanciId = OrderBanciId;
            }



            ViewData["shangxiawu"] = _liaotianService.GetSYScode("order_banci_dtl", "shangxiawu");






            ViewData.Model = dto;
            return View();
        }


        /// <summary>
        /// ä¿å­˜
        /// </summary>
        /// <param name="data">岗位实体类对象</param>
        /// <returns></returns>
        /// 
        [CheckLogin]
        [HttpPost]
        public IActionResult SaveDtl(OrderBanciDtlDTO data)
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            data.RecStatus = "A";
            if (String.IsNullOrEmpty(data.Id))
            {
                data.Creater = curentuser.Id;
                data.Createtime = DateTime.Now;
            }
            data.Modifier = curentuser.Id;
            data.Modifytime = DateTime.Now;

            ResultEntity resultEntity = _orderBanciDtlService.save(data);

            return new JsonResult(resultEntity);
        }


        /// <summary>
        /// åˆ é™¤ä¸»ä¿¡æ¯
        /// </summary>
        /// <param name="info">实体</param>
        /// <returns></returns>
        /// 
        [CheckLogin]
        public IActionResult NullifyDtl(string Id = "")
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            return new JsonResult(_orderBanciDtlService.ModifyStatus(Id, curentuser.Id));
        }



        //获取当前的培训
        public IActionResult GetBanCi()
        {
            ReturnMsg<OrderBanciDTO> returnMsg = new ReturnMsg<OrderBanciDTO>();
            returnMsg.code = 2;
            try
            {
                OrderBanciDTOSearch search = new OrderBanciDTOSearch();
                search.page = 1;
                search.rows = 1000;
                search.Createtime = DateTime.Now.Date.ToString();
                ResultDataEntity < OrderBanciDTO > resultDataEntity  = _orderBanciService.SearchByPaging(search);
                var ssss = resultDataEntity.DataList.OrderBy(x=>x.Shijian).FirstOrDefault();

                if (ssss != null)
                {
                 var sysCodeDtls    =  _liaotianService.GetSYScode("order_banci_dtl", "shangxiawu");
                    List<OrderBanciDtlDTO> orderBanciDtlDTOs  = _orderBanciDtlService.GetList(ssss.Id);
                    if(orderBanciDtlDTOs!=null&& orderBanciDtlDTOs.Count > 0)
                    {
                        foreach (var orderBanciDtlDTO in orderBanciDtlDTOs)
                        {
                        var  sysCodeDtl   = sysCodeDtls.Where(x => x.CodeSn == orderBanciDtlDTO.Shangxiawu).FirstOrDefault();
                            if (sysCodeDtl != null)
                            {
                                orderBanciDtlDTO.ShangxiawuName = sysCodeDtl.Comments;
                            }
                        }
                    }
                    

                    ssss.orderBanciDtlDTOs = orderBanciDtlDTOs;
                    returnMsg.code = 1;
                    returnMsg.count = 1;
                    returnMsg.returnObj = ssss;
                }


              

            }
            catch (Exception ex)
            {
                returnMsg.code = 2;
                returnMsg.error = "没有获取到token";
                returnMsg.count = 0;

            }
            return new JsonResult(returnMsg);
        }

    }
}

 zhengcaioa/zhengcaioa/Controllers/BusinessOrder/OrderBanciOrderController.cs

New file
@@ -0,0 +1,265 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AutoMapper;
using AngleSharp.Html.Parser;
using DTO;
using IServices;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Bot.Builder.Integration.AspNet.Core;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using System.Net.Http;
using System.Threading.Tasks;
using zhengcaioa.Models;
using zhengcaioa.IService;
using CommonToolsCore;
using Services;
using System.Transactions;

namespace zhengcaioa.Controllers.BusinessOrder
{
    public class OrderBanciOrderController : Controller
    {
        private readonly ILogger<OrderBanciOrderController> _logger;
        private readonly ILiaotianService _liaotianService;
        private readonly IOrderBanciService _orderBanciService;
        private readonly IOrderBanciDtlService _orderBanciDtlService;
        private readonly IOrderBanciOrderService _orderBanciOrderService;

        public OrderBanciOrderController(ILogger<OrderBanciOrderController> logger, ILiaotianService liaotianService, IOrderBanciService orderBanciService, IOrderBanciDtlService orderBanciDtlService
            ,IOrderBanciOrderService orderBanciOrderService)
        {
            _logger = logger;
            _liaotianService = liaotianService;
            _orderBanciService = orderBanciService;
            _orderBanciDtlService = orderBanciDtlService;
            _orderBanciOrderService = orderBanciOrderService;
        }

        [CheckLogin]
        public IActionResult Index()
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            List<ActionEntity> actionlist = new List<ActionEntity>();
            ActionEntity actionEntity = new ActionEntity();
            actionEntity.OpenType = 0;
            actionEntity.ActionUrl = "";
            actionEntity.ActionFun = "Search";
            actionEntity.PageIco = "fa fa-search";
            actionEntity.ActionName = "查询";
            actionlist.Add(actionEntity);
            //ActionEntity actionEntity1 = new ActionEntity();
            //actionEntity1.OpenType = 0;
            //actionEntity1.ActionUrl = "";
            //actionEntity1.ActionFun = "Add";
            //actionEntity1.PageIco = "fa fa-plus";
            //actionEntity1.ActionName = "新增";
            //actionlist.Add(actionEntity1);
            ActionEntity actionEntity3 = new ActionEntity();
            actionEntity3.OpenType = 0;
            actionEntity3.ActionUrl = "";
            actionEntity3.ActionFun = "Print";
            actionEntity3.PageIco = "fa fa-print";
            actionEntity3.ActionName = "打印";
            actionlist.Add(actionEntity3);


            ActionEntity actionEntity4 = new ActionEntity();
            actionEntity4.OpenType = 0;
            actionEntity4.ActionUrl = "";
            actionEntity4.ActionFun = "Duanxin";
            actionEntity4.PageIco = "";
            actionEntity4.ActionName = "发送短信";
            actionlist.Add(actionEntity4);

            ViewData["ActionInfo"] = actionlist;

            ViewBag.kechengleixing = _liaotianService.GetSYScode("order_banci_order", "kechengleixing_id").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();



            return View();

        }
        [CheckLogin]
        public IActionResult GetList(OrderBanciOrderDTOSearch search)
        {
            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());
            return new JsonResult(_orderBanciOrderService.SearchByPaging(search));
        }



        [CheckLogin]
        public IActionResult print(OrderBanciOrderDTOSearch search)
        {
            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());
            search.rows = 1000;
            search.page = 1;
            ViewBag.listLiaotianDTO = _orderBanciOrderService.SearchByPaging(search).DataList as List<OrderBanciOrderDTO>;



            return View();
        }

        [CheckLogin]
        public IActionResult Duanxin(string id = null)
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            ViewData["baifangid"] = id;



            return View();
        }

        [CheckLogin]
        public IActionResult Fasong(string neirong, string baifangid)
        {
            ResultEntity resultEntity = new ResultEntity();
            resultEntity.Result = true;
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            List<OrderBanciOrderDTO> result = new List<OrderBanciOrderDTO>();

            if (baifangid != null)
            {
                result = _orderBanciOrderService.GetList(baifangid.Split(","));
            }
            else
            {
                resultEntity.Result = false;
                resultEntity.Message = "无联系人号码";
            }
            string customename = "";
            StringBuilder number = new StringBuilder(); ;
            if (result != null && result.Count > 0)
            {
                for (int i = 0; i < result.Count; i++)
                {
                    number.Append(result[i].Lianxidianhua);
                    customename += result[i].Xingming + ",";
                    if (i != result.Count - 1)
                    {
                        number.Append(",");
                    }
                }
            }
            else
            {
                resultEntity.Result = false;
                resultEntity.Message = "无联系人";
            }

            string sss = SMSHelper.PushWToUserMES(number.ToString(), neirong);
            if (int.Parse(sss) <= 0)
            {
                resultEntity.Result = false;
                resultEntity.Message = "短信发送失败";
                return new JsonResult(resultEntity);
            }
           
            _logger.LogInformation(curentuser.UserName + "发送短信给客户" + customename);
            return new JsonResult(resultEntity);
        }




        /// <summary>
        /// ä¿å­˜
        /// </summary>
        /// <param name="data">岗位实体类对象</param>
        /// <returns></returns>
        /// 
        [HttpPost]
        public IActionResult Save([FromBody] OrderBanciOrderDTO data)
        {
            //var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            //ViewData["curentuser"] = curentuser;
            ReturnMsg<OrderBanciOrderDTO> returnMsg = new ReturnMsg<OrderBanciOrderDTO>();
            returnMsg.code = 2;
            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    data.RecStatus = "A";
                    if (String.IsNullOrEmpty(data.Id))
                    {
                        data.Creater = "1";
                        data.Createtime = DateTime.Now;
                    }
                    data.Modifier = "1";
                    data.Modifytime = DateTime.Now;

                    OrderBanciOrderDTOSearch search = new OrderBanciOrderDTOSearch();
                    search.page = 1;
                    search.rows = 1000;
                    search.BanciId = data.BanciId;
                    ResultDataEntity<OrderBanciOrderDTO> resultDataEntity = _orderBanciOrderService.SearchByPaging(search);


                    data.Baomingrenshu = search.totalrows + 1;
                    data.Jine = resultDataEntity.DataList.Sum(x => x.Xuefei);
                    data.Jine += data.Xuefei;
                    ResultEntity resultEntity = _orderBanciOrderService.save(data);
                    if (resultEntity.Result)
                    {
                        returnMsg.code = 1;
                        returnMsg.count = 1;
                        returnMsg.returnObj = data;
                    }
                    else
                    {
                        returnMsg.error = resultEntity.Message;
                    }
                    scope.Complete();
                }
            }
            catch (Exception ex)
            {
                returnMsg.code = 2;
                returnMsg.error = "没有获取到token";
                returnMsg.count = 0;

            }

            return new JsonResult(returnMsg);
        }



        //获取当前的报名的人数
        public IActionResult GetBaoMingRenShu([FromBody] OrderBanciOrderDTOSearch search)
        {
            ReturnMsg<List<OrderBanciOrderDTO>> returnMsg = new ReturnMsg<List<OrderBanciOrderDTO>>();
            returnMsg.code = 2;
            try
            {
                
                search.page = 1;
                search.rows = 1;
                ResultDataEntity<OrderBanciOrderDTO> resultDataEntity = _orderBanciOrderService.SearchByPaging(search);

                returnMsg.code = 1;
                returnMsg.count = search.totalrows;
                returnMsg.returnObj = resultDataEntity.DataList;

            }
            catch (Exception ex)
            {
                returnMsg.code = 2;
                returnMsg.error = "没有获取到token";
                returnMsg.count = 0;

            }
            return new JsonResult(returnMsg);
        }
    }
}

 zhengcaioa/zhengcaioa/Controllers/Customer/IntentionVisitController.cs

@@ -117,11 +117,14 @@

                dto.VisType = "01";
                dto.Jtype = "02";
                dto.Jdr = "02";
                //dto.Jdr = "02";
                dto.Talk = "介绍公司业务内容和产品。";
                dto.Yx = "03";
                dto.Jy = "02";
                
                dto.Zw = "02";



            }



 zhengcaioa/zhengcaioa/Startup.cs

@@ -136,6 +136,10 @@
            services.AddScoped(typeof(IWfRunProcessService), typeof(WfRunProcessService));
            services.AddScoped(typeof(IWfNeeddeelService), typeof(WfNeeddeelService));
            services.AddScoped(typeof(IWfHistoryService), typeof(WfHistorieservice));
            services.AddScoped(typeof(IOrderBanciDtlService), typeof(OrderBanciDtlService));
            services.AddScoped(typeof(IOrderBanciService), typeof(OrderBanciService));
            services.AddScoped(typeof(IOrderBanciOrderService), typeof(OrderBanciOrderService));
            

            //定时执行
            services.AddHostedService<TimedBackgroundService>();

 zhengcaioa/zhengcaioa/Views/CooperOrder/Edit.cshtml

@@ -611,7 +611,7 @@
                        $("#Price").val("");
                   

                    if (OrderType != "02" || sheng == "电话咨询" || sheng == "当面咨询" || sheng == "代拟质疑答复" || sheng == "代拟投诉处理决定" || sheng == "竞争对手和评审专家查询" || sheng == "政采贷") {
                    if (OrderType != "02" || sheng == "电话咨询" || sheng == "当面咨询" || sheng == "代拟质疑答复" || sheng == "代拟投诉处理决定" || sheng == "竞争对手和评审专家参加政府采购数据信息查询" || sheng == "政采贷") {
                        if (OrderType == "01") {
                            $("#Price").val(data.Danjia);
                        } else if (OrderType == "05") {
@@ -739,7 +739,7 @@
                data: "",
                success: function (data) {
                    var city = $("#OrderType2");
                    if (order_type != "02" || order_type1 == "电话咨询" || order_type1 == "当面咨询" || order_type1 == "代拟质疑答复" || order_type1 == "代拟投诉处理决定" || order_type1 == "竞争对手和评审专家查询" || order_type1 == "政采贷") {
                    if (order_type != "02" || order_type1 == "电话咨询" || order_type1 == "当面咨询" || order_type1 == "代拟质疑答复" || order_type1 == "代拟投诉处理决定" || order_type1 == "竞争对手和评审专家参加政府采购数据信息查询" || order_type1 == "政采贷") {


                    } else {

 zhengcaioa/zhengcaioa/Views/IntentionVisit/Edit.cshtml

@@ -198,13 +198,13 @@



                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">接待人<i class="red">*</i></label>
                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">接待人</label>
                                    <div class="col-sm-2 col-md-2" grouptype="Vdata">
                                        <input class="form-control" label="接待人" name="Jdr" id="Jdr" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Jdr">

                                    </div>

                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">职务<i class="red">*</i></label>
                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">职务</label>
                                    <div class="col-sm-2 col-md-2" grouptype="Vdata">
                                        <select id="Zw" class="form-control" name="Zw" data-placeholder="选择 åºåˆ— ...">
                                            <option value="" hassubinfo="true">请选择</option>
@@ -419,11 +419,16 @@
                toastr.warning("访问业务不能为空");
                return;
            };

            //if ($("#Zw").val() == '') {
            //    toastr.warning("职务不能为空");
            //    return;
            //};
            
            if ($("#Jdr").val() == '') {
                toastr.warning("接待人不能为空");
                return;
            }
            //if ($("#Jdr").val() == '') {
            //    toastr.warning("接待人不能为空");
            //    return;
            //}




 zhengcaioa/zhengcaioa/Views/IntentionVisit/Index.cshtml

@@ -26,7 +26,7 @@
                }
            },

            { label: '所属区域', name: 'ShengName', labtype: 'txt', hidden: false, width: 100  },
            //{ label: '所属区域', name: 'ShengName', labtype: 'txt', hidden: false, width: 100  },
            { label: '客户单位', name: 'Name', labtype: 'txt', hidden: false, width: 100  },
            { label: '拜访方式', name: 'VisTypeName', labtype: 'txt', hidden: false, width: 100 },
            { label: '接待人', name: 'Jdr', labtype: 'txt', hidden: false, width: 100},
@@ -35,7 +35,7 @@
            { label: '客户反馈', name: 'Khfk', labtype: 'txt', hidden: false, width: 100 },
            { label: '成交意向', name: 'YxName', labtype: 'txt', hidden: false, width: 100 },
            { label: '跟踪建议', name: 'JyName', labtype: 'txt', hidden: false, width: 100 },
            { label: '录入人', name: 'CreaterName', labtype: 'txt', hidden: false, width: 100 },
            { label: '访问人', name: 'CreaterName', labtype: 'txt', hidden: false, width: 100 },

        ];
        dataUrl = "/IntentionVisit/GetList?Viscustomer=@Viscustomer";
@@ -50,7 +50,7 @@
            { label: '区县', name: 'AreaId', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '2%', cccwidth: '8%' },
            { label: '客户单位', name: 'Name', labtype: 'txt', hidden: false },
            { label: '拜访时间', name: 'Vistime', labtype: 'datearea', hidden: false },
            { label: '录入人', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(creater), cwidth: '5%', cccwidth: '8%'}, 
            { label: '访问人', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(creater), cwidth: '5%', cccwidth: '8%'}, 




 zhengcaioa/zhengcaioa/Views/OrderBanci/Edit.cshtml

New file
@@ -0,0 +1,369 @@
@model DTO.OrderBanciDTO
@using DTO;
@using zhengcaioa.Models;
@{

   


}
@{
    Layout = null;
}

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="ThemeBucket">
    <title>@(SiteConfig.SiteName)</title>
    <link href="~/css/bootstrap.min.css" rel="stylesheet">
    <link href="~/css/font-awesome.min.css" rel="stylesheet">
    <link href="~/css/animate.min.css" rel="stylesheet">

    @*<link href="~/css/plugins/iCheck/custom.css" rel="stylesheet">*@
    <link href="~/css/style.min.css" rel="stylesheet">
    <link href="~/css/plugins/chosen/chosen.css" rel="stylesheet">
    @*<link href="~/js/plugins/layer/skin/layer.css" rel="stylesheet">*@
    @*<link href="~/css/plugins/datapicker/datepicker3.css" rel="stylesheet">*@
    <link href="~/css/style.min.css" rel="stylesheet">
    <link href="~/css/plugins/toastr/toastr.min.css" rel="stylesheet" />
    <link href="~/css/plugins/webuploader/webuploader.css" rel="stylesheet" />

    <style type="text/css">
        .webuploader-pick {
            position: relative;
            display: inline-block;
            cursor: pointer;
            background: #00b7ee;
            padding: 8px 14px 7px 14px;
            color: #fff;
            text-align: center;
            border-radius: 3px;
            overflow: hidden;
        }

        div.clearfix > label {
            padding-top: 8px;
        }

        .chosen-container {
            border-radius: 1px;
            border: 1px solid #e5e6e7;
        }

        .col-md-1.control-label {
            padding-right: 0px;
            font-weight: 400;
        }
    </style>

    <!-- jqgrid-->
    @*<link href="~/css/plugins/jqgrid/ui.jqgrid.css" rel="stylesheet">*@
    <script language="javascript" src="~/js/jquery.min.js" type="text/javascript"></script>
    <script src="~/js/bootstrap.min.js"></script>
    @*<script src="~/js/plugins/bootstro/bootstro.js"></script>*@

    <!--容器-->
    @*<script language="javascript" src="~/js/datehelper.js" type="text/javascript"></script>*@
    @*<script language="javascript" src="~/js/plugins/query/jquery.query-object.js" type="text/javascript"></script>*@
    @*<script language="javascript" src="~/js/plugins/iCheck/icheck.min.js" type="text/javascript"></script>*@
    <script language="javascript" src="~/js/plugins/chosen/chosen.jquery.js" type="text/javascript"></script>
    @*<script language="javascript" src="~/js/plugins/datapicker/bootstrap-datepicker.js" type="text/javascript"></script>*@
    <script language="javascript" src="~/js/plugins/layer/layer.js" type="text/javascript"></script>
    @*<script src="~/js/plugins/jqgrid/jquery.jqGrid.min.js" type="text/javascript"></script>*@
    @*<script src="~/js/plugins/jqgrid/i18n/grid.locale-cn.js" type="text/javascript"></script>*@
    <script src="~/js/plugins/toastr/toastr.min.js" type="text/javascript"></script>
    <script src="~/js/plugins/webuploader/webuploader.min.js"></script>

    <script language="javascript" src="~/js/common-layout.js" type="text/javascript"></script>
    <script src="~/js/plugins/layer/laydate/laydate.js" type="text/javascript"></script>
    @*<script src="~/js/plugins/iTexbox/itextbox.js" type="text/javascript"></script>*@
    @*<script src="~/js/plugins/iuploader/iuploader.js"></script>*@
    <script src="~/js/TUJS.js"></script>
</head>
<body class="gray-bg" style="overflow:auto">
    <form id="formtest">
        <div class="wrapper wrapper-content" id="ibox-content" style="padding:15px;">
            <div class="row">
                <div class="col-sm-12">
                    <div class="ibox float-e-margins">
                        <div class="ibox-title">
                            <h5>                            <i class="fa fa-list"></i>&nbsp;基本信息</h5>
                        </div>
                        <div id="div_content" class="ibox-content" style="background-color:white;">
                            <div class="row">
                                <div class="clearfix layer-area" style="padding-bottom:15px;">




                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">班次<i class="red">*</i></label>
                                    <div class="col-sm-2 col-md-2" grouptype="Vdata">
                                        <input class="form-control" label="班次" name="Banci" id="Banci" labtype="txt" addvisible="true" maxlength="100" editvisible="true" reg="" ismust="true" type="text" value="@Model.Banci">

                                    </div>



                                </div>
                                <div class="clearfix layer-area" style="padding-bottom:15px;">




                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">名称<i class="red">*</i></label>
                                    <div class="col-sm-6 col-md-6" grouptype="Vdata">
                                        <input class="form-control" label="名称" name="Mingcheng" id="Mingcheng" labtype="txt" addvisible="true" maxlength="100" editvisible="true" reg="" ismust="true" type="text" value="@Model.Mingcheng">

                                    </div>



                                </div>

                                <div class="clearfix layer-area" style="padding-bottom:15px;">

                                    <label class="text-right col-sm-1 col-md-1 control-label">开始时间<i class="red">*</i></label>
                                    <div class="col-sm-2 col-md-2">
                                        <input id="Shijian" class="form-control" label="开始时间" name="Shijian" labtype="txt" addvisible="true" editvisible="true" reg="" ismust="true" type="text" value="@Model.ShijianName" readonly="readonly">

                                    </div>

                                    <input type="hidden" id="Id" name="Id" value="@Model.Id" />
                                </div>
                                <div class="clearfix layer-area" style="padding-bottom:15px;">

                                    <label class="text-right col-sm-1 col-md-1 control-label">结束时间<i class="red">*</i></label>
                                    <div class="col-sm-2 col-md-2">
                                        <input id="Shijianend" class="form-control" label="结束时间" name="Shijianend" labtype="txt" addvisible="true" editvisible="true" reg="" ismust="true" type="text" value="@Model.ShijianendName" readonly="readonly">

                                    </div>

                                    <input type="hidden" id="Id" name="Id" value="@Model.Id" />
                                </div>

                                <div class="clearfix layer-area" style="padding-bottom:15px;">




                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">地点<i class="red">*</i></label>
                                    <div class="col-sm-8 col-md-8" grouptype="Vdata">
                                        <input class="form-control" label="地点" name="Didian" id="Didian" labtype="txt" addvisible="true" maxlength="100" editvisible="true" reg="" ismust="true" type="text" value="@Model.Didian">

                                    </div>



                                </div>
                                <div class="clearfix layer-area" style="padding-bottom:15px;">




                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">人数<i class="red">*</i></label>
                                    <div class="col-sm-2 col-md-2" grouptype="Vdata">
                                        <input class="form-control" label="人数" name="Renshu" id="Renshu" labtype="txt" addvisible="true" maxlength="100" editvisible="true" reg="" ismust="true" type="text" value="@Model.Renshu" oninput="if(value.length>8)value=value.slice(0,10)"  onkeyup = "value=value.replace(/[^\d]/g,'')" >

 

                                    </div>



                                </div>








                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="wrapper wrapper-content" style="margin-top:0px"></div>
        <div class="ibox-content" id="top" style="z-index:100; position:fixed; height:50px; width:100%;bottom:0; text-align: right; padding-top:8px ">
            <div class="" style="float:right;" data-bootstro-width="500px" data-bootstro-content="功能按钮：“保存”，“删除”">
                <a class="btn btn-success" href="javascript:void(0)" onclick="delPosition();" style="margin-left:4px; border-radius:4px;">
                    <i class="glyphicon glyphicon-remove"></i>&nbsp;&nbsp;<span class="bold">删除</span>
                </a>

                <a class="btn btn-success" href="javascript:void(0)" onclick="savePosition();" style="margin-left:4px; border-radius:4px;">
                    <i class="glyphicon glyphicon-ok"></i>&nbsp;&nbsp;<span class="bold">提交</span>
                </a>
            </div>
        </div>

    </form>
    <script type="text/javascript">
        var hh = document.body.clientHeight - $('.ibox-title').height() - $("#top").height() * 2 - 95;
        $("#div_content").height(hh);

        toastr.options = {
            "closeButton": true,
            "debug": false,
            "progressBar": true,
            "positionClass": "toast-bottom-right",
            "onclick": null,
            "showDuration": "300",
            "hideDuration": "600",
            "timeOut": "4500",
            "extendedTimeOut": "600",
            "showEasing": "swing",
            "hideEasing": "linear",
            "showMethod": "fadeIn",
            "hideMethod": "fadeOut"
        };

        laydate({ elem: "#Shijian", format: 'YYYY-MM-DD hh:mm', istime: true, event: "focus" });
        laydate({ elem: "#Shijianend", format: 'YYYY-MM-DD hh:mm', istime: true, event: "focus" });
        var id = '@Model.Id';
        var bUpload = false;
        var bAdd = false; // æ–°å¢žæ“ä½œ
        var fileId = ""; // ä¸Šä¼ æ–‡ä»¶ç”Ÿæˆçš„Id
        var bEditFile = false; // ç¼–辑时，是否关联了附件
        var bDeleteFile = false; // åˆ é™¤æ“ä½œ
        var attachment_id = 0; // é™„件id
        var imgLoad = new Object();



        var delPosition = function () {


            if (id == null || id == '') {
                toastr.warning("请先保存");
                return;
            }
            $.ajax({
                type: "GET",
                url: "/OrderBanci/Nullify?id=" + id,
                dataType: "json",
                global: false,
                data: '',
                success: function (data) {


                    if (data.Result) {
                        //  parent._afterSave(true);
                        parent.layer.msg('删除成功', { icon: 6 });
                        _pageAutoClose();//自动关闭页面方法
                    }
                    else {
                        // toastr.error("");
                        parent.layer.msg('删除失败', { icon: 5 });
                    }

                },
                error: function () {
                    if ($.isNumber(imgLoad)) {
                        parent.layer.close(imgLoad);
                    }
                    //toastr.error("保存失败");

                    parent.layer.msg('保存失败', { icon: 5 });
                }
            });

        }

        // ä¿å­˜å²—位信息
        var savePosition = function () {

            if ($("#Shijian").val() == '') {
                toastr.warning("开始时间不能为空");
                return;
            }

            if ($("#Shijianend").val() == '') {
                toastr.warning("结束时间不能为空");
                return;
            }

            if ($.trim($("#Banci").val()) == '') {
                toastr.warning("班次不能为空");
                return;
            }
            if ($.trim($("#Mingcheng").val()) == '') {
                toastr.warning("名称不能为空");
                return;
            }
            if ($.trim($("#Renshu").val()) == '') {
                toastr.warning("人数不能为空");
                return;
            }

            if ($.trim($("#Didian").val()) == '') {
                toastr.warning("地点不能为空");
                return;
            }
            






            //var data = { id: $("#Id").val(), StartTime:$("#StartTime").val(), Sheng: $("#Sheng").val(), job_level: $("#Job_level").val().toString(), ExistsAttachment: fileId != "" }
            $.ajax({
                type: "POST",
                url: "/OrderBanci/Save",
                dataType: "json",
                global: false,
                data: $('form').serializeArray(),
                success: function (data) {



                        if (data.Result) {
                            //  parent._afterSave(true);
                            parent.layer.msg('成功保存', { icon: 6 });
                            //window.location = "/Project/add?id=" + data.ReturnID;


                            try {
                                _pageAutoClose();//自动关闭页面方法
                            }
                            catch (err) {
                                parent._CloseTab1("/OrderBanci/Edit/");
                            }

                        }
                        else {
                            // toastr.error("失败");
                            parent.layer.msg(data.Message, { icon: 5 });
                        }

                },
                error: function () {


                    parent.layer.msg('失败', { icon: 5 });
                }
            });
        }






        function _pageAutoClose() {
            parent.window._reloadPageData();
            var index = parent.layer.getFrameIndex(window.name);
            parent.layer.isRefresh = true;
            parent.layer.closeAll('loading');
            parent.layer.close(index);
            return false;
        }
    </script>
</body>
</html>

 zhengcaioa/zhengcaioa/Views/OrderBanci/EditDtl.cshtml

New file
@@ -0,0 +1,361 @@
@model DTO.OrderBanciDtlDTO
@using DTO;
@using zhengcaioa.Models;
@{

    List<SysCodeDtl> shangxiawu = ViewData["shangxiawu"] as List<SysCodeDtl>; //上下午


}
@{
    Layout = null;
}

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="ThemeBucket">
    <title>@(SiteConfig.SiteName)</title>
    <link href="~/css/bootstrap.min.css" rel="stylesheet">
    <link href="~/css/font-awesome.min.css" rel="stylesheet">
    <link href="~/css/animate.min.css" rel="stylesheet">

    @*<link href="~/css/plugins/iCheck/custom.css" rel="stylesheet">*@
    <link href="~/css/style.min.css" rel="stylesheet">
    <link href="~/css/plugins/chosen/chosen.css" rel="stylesheet">
    @*<link href="~/js/plugins/layer/skin/layer.css" rel="stylesheet">*@
    @*<link href="~/css/plugins/datapicker/datepicker3.css" rel="stylesheet">*@
    <link href="~/css/style.min.css" rel="stylesheet">
    <link href="~/css/plugins/toastr/toastr.min.css" rel="stylesheet" />
    <link href="~/css/plugins/webuploader/webuploader.css" rel="stylesheet" />

    <style type="text/css">
        .webuploader-pick {
            position: relative;
            display: inline-block;
            cursor: pointer;
            background: #00b7ee;
            padding: 8px 14px 7px 14px;
            color: #fff;
            text-align: center;
            border-radius: 3px;
            overflow: hidden;
        }

        div.clearfix > label {
            padding-top: 8px;
        }

        .chosen-container {
            border-radius: 1px;
            border: 1px solid #e5e6e7;
        }

        .col-md-1.control-label {
            padding-right: 0px;
            font-weight: 400;
        }
    </style>

    <!-- jqgrid-->
    @*<link href="~/css/plugins/jqgrid/ui.jqgrid.css" rel="stylesheet">*@
    <script language="javascript" src="~/js/jquery.min.js" type="text/javascript"></script>
    <script src="~/js/bootstrap.min.js"></script>
    @*<script src="~/js/plugins/bootstro/bootstro.js"></script>*@

    <!--容器-->
    @*<script language="javascript" src="~/js/datehelper.js" type="text/javascript"></script>*@
    @*<script language="javascript" src="~/js/plugins/query/jquery.query-object.js" type="text/javascript"></script>*@
    @*<script language="javascript" src="~/js/plugins/iCheck/icheck.min.js" type="text/javascript"></script>*@
    <script language="javascript" src="~/js/plugins/chosen/chosen.jquery.js" type="text/javascript"></script>
    @*<script language="javascript" src="~/js/plugins/datapicker/bootstrap-datepicker.js" type="text/javascript"></script>*@
    <script language="javascript" src="~/js/plugins/layer/layer.js" type="text/javascript"></script>
    @*<script src="~/js/plugins/jqgrid/jquery.jqGrid.min.js" type="text/javascript"></script>*@
    @*<script src="~/js/plugins/jqgrid/i18n/grid.locale-cn.js" type="text/javascript"></script>*@
    <script src="~/js/plugins/toastr/toastr.min.js" type="text/javascript"></script>
    <script src="~/js/plugins/webuploader/webuploader.min.js"></script>

    <script language="javascript" src="~/js/common-layout.js" type="text/javascript"></script>
    <script src="~/js/plugins/layer/laydate/laydate.js" type="text/javascript"></script>
    @*<script src="~/js/plugins/iTexbox/itextbox.js" type="text/javascript"></script>*@
    @*<script src="~/js/plugins/iuploader/iuploader.js"></script>*@
    <script src="~/js/TUJS.js"></script>
</head>
<body class="gray-bg" style="overflow:auto">
    <form id="formtest">
        <div class="wrapper wrapper-content" id="ibox-content" style="padding:15px;">
            <div class="row">
                <div class="col-sm-12">
                    <div class="ibox float-e-margins">
                        <div class="ibox-title">
                            <h5>                            <i class="fa fa-list"></i>&nbsp;基本信息</h5>
                        </div>
                        <div id="div_content" class="ibox-content" style="background-color:white;">
                            <div class="row">

                                <div class="clearfix layer-area" style="padding-bottom:15px;">

                                    <label class="text-right col-sm-1 col-md-1 control-label">上下午<i class="red">*</i></label>
                                    <div class="col-sm-2 col-md-2">
                                        <select id="shangxiawu" class="form-control" name="shangxiawu" data-placeholder="选择 åºåˆ— ..." style="font-weight:normal;">
                                            <option value="" hassubinfo="true">请选择</option>
                                            @foreach (var item in shangxiawu)
                                            {
                                                @if (!item.CodeSn.Equals(Model.Shangxiawu))
                                                {
                                                    <option value="@item.CodeSn" hassubinfo="true">
                                                        @item.Comments
                                                    </option>
                                                }
                                                else
                                                {
                                                    <option value="@item.CodeSn" hassubinfo="true" selected="selected">
                                                        @item.Comments
                                                    </option>
                                                }

                                            }


                                        </select>

                                    </div>






                                </div>

                                <div class="clearfix layer-area" style="padding-bottom:15px;">

                                    <label class="text-right col-sm-1 col-md-1 control-label">时间<i class="red">*</i></label>
                                    <div class="col-sm-2 col-md-2">
                                        <input class="form-control" label="时间" name="Shijian" id="Shijian" labtype="txt" addvisible="true" maxlength="100" editvisible="true" reg="" ismust="true" type="text" value="@Model.Shijian">

                                    </div>

                                    <input type="hidden" id="Id" name="Id" value="@Model.Id" />
                                    <input type="hidden" id="OrderBanciId" name="OrderBanciId" value="@Model.OrderBanciId" />
                                </div>
                                <div class="clearfix layer-area" style="padding-bottom:15px;">




                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">事项<i class="red">*</i></label>
                                    <div class="col-sm-8 col-md-8" grouptype="Vdata">
                                        <input class="form-control" label="事项" name="Shixiamg" id="Shixiamg" labtype="txt" addvisible="true" maxlength="100" editvisible="true" reg="" ismust="true" type="text" value="@Model.Shixiamg">

                                    </div>



                                </div>
                                <div class="clearfix layer-area" style="padding-bottom:15px;">




                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">主讲人</label>
                                    <div class="col-sm-8 col-md-8" grouptype="Vdata">
                                        <input class="form-control" label="主讲人" name="Zhujiangren" id="Zhujiangren" labtype="txt" addvisible="true" maxlength="100" editvisible="true" reg="" ismust="true" type="text" value="@Model.Zhujiangren">

                                    </div>



                                </div>

                                <div class="clearfix layer-area" style="padding-bottom:15px;">

                                    <label class="text-right col-sm-1 col-md-1 control-label">排序</label>
                                    <div class="col-sm-2 col-md-2">
                                        <input class="form-control" label="排序" name="Sort" id="Sort" labtype="txt" addvisible="true" maxlength="100" editvisible="true" reg="" ismust="true" type="number" value="@Model.Sort">

                                    </div>

                                    
                                </div>






                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="wrapper wrapper-content" style="margin-top:0px"></div>
        <div class="ibox-content" id="top" style="z-index:100; position:fixed; height:50px; width:100%;bottom:0; text-align: right; padding-top:8px ">
            <div class="" style="float:right;" data-bootstro-width="500px" data-bootstro-content="功能按钮：“保存”，“删除”">
                <a class="btn btn-success" href="javascript:void(0)" onclick="delPosition();" style="margin-left:4px; border-radius:4px;">
                    <i class="glyphicon glyphicon-remove"></i>&nbsp;&nbsp;<span class="bold">删除</span>
                </a>

                <a class="btn btn-success" href="javascript:void(0)" onclick="savePosition();" style="margin-left:4px; border-radius:4px;">
                    <i class="glyphicon glyphicon-ok"></i>&nbsp;&nbsp;<span class="bold">提交</span>
                </a>
            </div>
        </div>

    </form>
    <script type="text/javascript">
        var hh = document.body.clientHeight - $('.ibox-title').height() - $("#top").height() * 2 - 95;
        $("#div_content").height(hh);

        toastr.options = {
            "closeButton": true,
            "debug": false,
            "progressBar": true,
            "positionClass": "toast-bottom-right",
            "onclick": null,
            "showDuration": "300",
            "hideDuration": "600",
            "timeOut": "4500",
            "extendedTimeOut": "600",
            "showEasing": "swing",
            "hideEasing": "linear",
            "showMethod": "fadeIn",
            "hideMethod": "fadeOut"
        };

         

        var id = '@Model.Id';
        var bUpload = false;
        var bAdd = false; // æ–°å¢žæ“ä½œ
        var fileId = ""; // ä¸Šä¼ æ–‡ä»¶ç”Ÿæˆçš„Id
        var bEditFile = false; // ç¼–辑时，是否关联了附件
        var bDeleteFile = false; // åˆ é™¤æ“ä½œ
        var attachment_id = 0; // é™„件id
        var imgLoad = new Object();



        var delPosition = function () {


            if (id == null || id == '') {
                toastr.warning("请先保存");
                return;
            }
            $.ajax({
                type: "GET",
                url: "/OrderBanci/NullifyDtl?id=" + id,
                dataType: "json",
                global: false,
                data: '',
                success: function (data) {


                    if (data.Result) {
                        //  parent._afterSave(true);
                        parent.layer.msg('删除成功', { icon: 6 });
                        _pageAutoClose();//自动关闭页面方法
                    }
                    else {
                        // toastr.error("");
                        parent.layer.msg('删除失败', { icon: 5 });
                    }

                },
                error: function () {
                    if ($.isNumber(imgLoad)) {
                        parent.layer.close(imgLoad);
                    }
                    //toastr.error("保存失败");

                    parent.layer.msg('保存失败', { icon: 5 });
                }
            });

        }

        // ä¿å­˜å²—位信息
        var savePosition = function () {

            if ($("#shangxiawu").val() == '') {
                toastr.warning("上下午不能为空");
                return;
            }

            if ($.trim($("#Shijian").val()) == '') {
                toastr.warning("时间不能为空");
                return;
            }


            if ($.trim($("#Shixiamg").val()) == '') {
                toastr.warning("事项不能为空");
                return;
            }







            //var data = { id: $("#Id").val(), StartTime:$("#StartTime").val(), Sheng: $("#Sheng").val(), job_level: $("#Job_level").val().toString(), ExistsAttachment: fileId != "" }
            $.ajax({
                type: "POST",
                url: "/OrderBanci/SaveDtl",
                dataType: "json",
                global: false,
                data: $('form').serializeArray(),
                success: function (data) {



                        if (data.Result) {
                            //  parent._afterSave(true);
                            parent.layer.msg('成功保存', { icon: 6 });
                            //window.location = "/Project/add?id=" + data.ReturnID;


                            try {
                                _pageAutoClose();//自动关闭页面方法
                            }
                            catch (err) {
                                parent._CloseTab1("/OrderBanci/EditDtl/");
                            }

                        }
                        else {
                            // toastr.error("失败");
                            parent.layer.msg(data.Message, { icon: 5 });
                        }

                },
                error: function () {


                    parent.layer.msg('失败', { icon: 5 });
                }
            });
        }






        function _pageAutoClose() {
            parent.window._reloadPageData();
            var index = parent.layer.getFrameIndex(window.name);
            parent.layer.isRefresh = true;
            parent.layer.closeAll('loading');
            parent.layer.close(index);
            return false;
        }
    </script>
</body>
</html>

 zhengcaioa/zhengcaioa/Views/OrderBanci/Index.cshtml

New file
@@ -0,0 +1,79 @@
@{
    ViewBag.Title = "OrderBanci";
    Layout = "~/Views/Shared/_Layout_Search.cshtml";
}
@section headerStyle{
    <script type="text/javascript">
       
        dataCol = [
            { label: 'id', name: 'Id', labtype: 'txt', hidden: true },

            {
                label: '班次', name: 'Banci', labtype: 'txt', hidden: false, width: 100,
                formatter: function (cellvalue, options, rowObject) {
                    return "<a onclick=\"OpenWindow('" + cellvalue.replace(/'/g, '') + "','98%','100%', '/OrderBanci/Edit?id=" + rowObject.Id + "')\"  >" + cellvalue + "</a>";
                }
            },
            { label: '名称', name: 'Mingcheng', labtype: 'txt', hidden: false, width: 200 },
            { label: '开始时间', name: 'ShijianName', labtype: 'txt', hidden: false, width: 200 },
            { label: '结束时间', name: 'ShijianendName', labtype: 'txt', hidden: false, width: 200 },
            { label: '地点', name: 'Didian', labtype: 'txt', hidden: false, width: 400 },
            { label: '人数', name: 'Renshu', labtype: 'txt', hidden: false, width: 200 },
            {
                label: '培训时间', name: 'Creater', labtype: 'txt', hidden: false, width: 100,
                formatter: function (cellvalue, options, rowObject) {
                    return "<a onclick=\"OpenWindow('" + rowObject.Banci.replace(/'/g, '') + "','98%','100%', '/OrderBanci/IndexDtl?OrderBanciId=" + rowObject.Id + "')\"  >培训时间</a>";
                }
            },
          

        ];
        dataUrl = "/OrderBanci/GetList";
        searchCol = [
            { label: '开始时间', name: 'Shijian', labtype: 'datearea', hidden: false },
            { label: '班次', name: 'Banci', labtype: 'txt', hidden: false },
            { label: '地点', name: 'Didian', labtype: 'txt', hidden: false },







        ];
        var _pageAdd = function () {
            OpenWindow("新增班次", "98%", "90%", "/OrderBanci/Edit/");
        }




        var _afterSave = function (result) {
            if (result) {
                toastr.success("保存成功");
            } else {
                toastr.error("保存失败");
            }
        }

        var _afterDel = function (result) {
            if (result) {
                toastr.success("删除成功");
            } else {
                /**/
                toastr.error("删除成功");
        /**/
    }
}
    </script>
}

@section footerScripts{
    <script type="text/javascript">





    </script>
}

 zhengcaioa/zhengcaioa/Views/OrderBanci/IndexDtl.cshtml

New file
@@ -0,0 +1,69 @@
@{
    ViewBag.Title = "OrderBanciDtl";
    Layout = "~/Views/Shared/_Layout_Search.cshtml";
    string OrderBanciId = ViewBag.OrderBanciId as string;
}
@section headerStyle{
    <script type="text/javascript">

        dataCol = [
            { label: 'id', name: 'Id', labtype: 'txt', hidden: true },

            {
                label: '上下午', name: 'ShangxiawuName', labtype: 'txt', hidden: false, width: 100,
                formatter: function (cellvalue, options, rowObject) {
                    return "<a onclick=\"OpenWindow('" + cellvalue.replace(/'/g, '') + "','98%','100%', '/OrderBanci/EditDtl?id=" + rowObject.Id + "')\"  >" + cellvalue + "</a>";
                }
            },

            { label: '时间', name: 'Shijian', labtype: 'txt', hidden: false, width: 100  },
            { label: '事项', name: 'Shixiamg', labtype: 'txt', hidden: false, width: 400 },
            { label: '主讲人', name: 'Zhujiangren', labtype: 'txt', hidden: false, width: 100 },
            { label: '排序', name: 'Sort', labtype: 'txt', hidden: false, width: 100 },

        ];
        dataUrl = "/OrderBanci/GetListDtl?OrderBanciId=@OrderBanciId";
        searchCol = [

            { label: '事项', name: 'Shixiamg', labtype: 'txt', hidden: false },




        ];
        var _pageAdd = function () {
            OpenWindow("新增班次", "98%", "90%", "/OrderBanci/EditDtl?OrderBanciId=@OrderBanciId");
        }




        var _afterSave = function (result) {
            if (result) {
                toastr.success("保存成功");
            } else {
                toastr.error("保存失败");
            }
        }

        var _afterDel = function (result) {
            if (result) {
                toastr.success("删除成功");
            } else {
                /**/
                toastr.error("删除成功");
        /**/
    }
}
    </script>
}

@section footerScripts{
    <script type="text/javascript">





    </script>
}

 zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Duanxin.cshtml

New file
@@ -0,0 +1,225 @@
@model DTO.CooperatecustomCustomerDTO
@using DTO;
@using zhengcaioa.Models;
@{
    string baifangid = ViewData["baifangid"] as string; //拜访方式


}
@{
    Layout = null;
}

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="ThemeBucket">
    <title>@(SiteConfig.SiteName)</title>
    <link href="~/css/bootstrap.min.css" rel="stylesheet">
    <link href="~/css/font-awesome.min.css" rel="stylesheet">
    <link href="~/css/animate.min.css" rel="stylesheet">

    @*<link href="~/css/plugins/iCheck/custom.css" rel="stylesheet">*@
    <link href="~/css/style.min.css" rel="stylesheet">
    <link href="~/css/plugins/chosen/chosen.css" rel="stylesheet">
    @*<link href="~/js/plugins/layer/skin/layer.css" rel="stylesheet">*@
    @*<link href="~/css/plugins/datapicker/datepicker3.css" rel="stylesheet">*@
    <link href="~/css/style.min.css" rel="stylesheet">
    <link href="~/css/plugins/toastr/toastr.min.css" rel="stylesheet" />
    <link href="~/css/plugins/webuploader/webuploader.css" rel="stylesheet" />

    <style type="text/css">
        .webuploader-pick {
            position: relative;
            display: inline-block;
            cursor: pointer;
            background: #00b7ee;
            padding: 8px 14px 7px 14px;
            color: #fff;
            text-align: center;
            border-radius: 3px;
            overflow: hidden;
        }

        div.clearfix > label {
            padding-top: 8px;
        }

        .chosen-container {
            border-radius: 1px;
            border: 1px solid #e5e6e7;
        }

        .col-md-1.control-label {
            padding-right: 0px;
            font-weight: 400;
        }
    </style>

    <!-- jqgrid-->
    @*<link href="~/css/plugins/jqgrid/ui.jqgrid.css" rel="stylesheet">*@
    <script language="javascript" src="~/js/jquery.min.js" type="text/javascript"></script>
    <script src="~/js/bootstrap.min.js"></script>
    @*<script src="~/js/plugins/bootstro/bootstro.js"></script>*@

    <!--容器-->
    @*<script language="javascript" src="~/js/datehelper.js" type="text/javascript"></script>*@
    @*<script language="javascript" src="~/js/plugins/query/jquery.query-object.js" type="text/javascript"></script>*@
    @*<script language="javascript" src="~/js/plugins/iCheck/icheck.min.js" type="text/javascript"></script>*@
    <script language="javascript" src="~/js/plugins/chosen/chosen.jquery.js" type="text/javascript"></script>
    @*<script language="javascript" src="~/js/plugins/datapicker/bootstrap-datepicker.js" type="text/javascript"></script>*@
    <script language="javascript" src="~/js/plugins/layer/layer.js" type="text/javascript"></script>
    @*<script src="~/js/plugins/jqgrid/jquery.jqGrid.min.js" type="text/javascript"></script>*@
    @*<script src="~/js/plugins/jqgrid/i18n/grid.locale-cn.js" type="text/javascript"></script>*@
    <script src="~/js/plugins/toastr/toastr.min.js" type="text/javascript"></script>
    <script src="~/js/plugins/webuploader/webuploader.min.js"></script>

    <script language="javascript" src="~/js/common-layout.js" type="text/javascript"></script>
    <script src="~/js/plugins/layer/laydate/laydate.js" type="text/javascript"></script>
    @*<script src="~/js/plugins/iTexbox/itextbox.js" type="text/javascript"></script>*@
    @*<script src="~/js/plugins/iuploader/iuploader.js"></script>*@
    <script src="~/js/TUJS.js"></script>
</head>
<body class="gray-bg" style="overflow:auto">
    <form id="formtest">
        <div class="wrapper wrapper-content" id="ibox-content" style="padding:15px;">
            <div class="row">
                <div class="col-sm-12">
                    <div class="ibox float-e-margins">
                        <div class="ibox-title">
                            <h5>                            <i class="fa fa-list"></i>&nbsp;群发短信</h5>
                        </div>
                        <div id="div_content" class="ibox-content" style="background-color:white;">
                            <div class="row">

                                <input type="hidden" id="baifangid" name="baifangid" value="@baifangid" />



                                <div class="clearfix layer-area" style="padding-bottom:15px;">
                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">短信内容<i class="red">*</i></label>
                                    <div class="col-sm-8 col-md-8">
                                        <textarea class="form-control bt" id="neirong" name="neirong" title="短信内容" isempty="" maxlength="4000" length="long"></textarea>
                                    </div>
                                </div>







                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="wrapper wrapper-content" style="margin-top:0px"></div>
        <div class="ibox-content" id="top" style="z-index:100; position:fixed; height:50px; width:100%;bottom:0; text-align: right; padding-top:8px ">
            <div class="" style="float:right;" data-bootstro-width="500px" data-bootstro-content="功能按钮：“保存”，“删除”">
                @*<a class="btn btn-success" href="javascript:void(0)" onclick="delPosition();" style="margin-left:4px; border-radius:4px;">
                        <i class="glyphicon glyphicon-remove"></i>&nbsp;&nbsp;<span class="bold">删除</span>
                    </a>*@

                <a class="btn btn-success" href="javascript:void(0)" onclick="savePosition();" style="margin-left:4px; border-radius:4px;">
                    <i class="glyphicon glyphicon-ok"></i>&nbsp;&nbsp;<span class="bold">提交</span>
                </a>
            </div>
        </div>

    </form>
    <script type="text/javascript">
        var hh = document.body.clientHeight - $('.ibox-title').height() - $("#top").height() * 2 - 95;
        $("#div_content").height(hh);

        toastr.options = {
            "closeButton": true,
            "debug": false,
            "progressBar": true,
            "positionClass": "toast-bottom-right",
            "onclick": null,
            "showDuration": "300",
            "hideDuration": "600",
            "timeOut": "4500",
            "extendedTimeOut": "600",
            "showEasing": "swing",
            "hideEasing": "linear",
            "showMethod": "fadeIn",
            "hideMethod": "fadeOut"
        };






        // ä¿å­˜å²—位信息
        var savePosition = function () {





            if ($.trim($("#neirong").val()) == '') {
                toastr.warning("交谈内容不能为空");
                return;
            }



            var data = { neirong: $("#neirong").val(), baifangid: $("#baifangid").val()}
            $.ajax({
                type: "POST",
                url: "/OrderBanciOrder/Fasong",
                dataType: "json",
                global: false,
                data: data,
                success: function (data) {



                        if (data.Result) {
                            //  parent._afterSave(true);
                            parent.layer.msg('短信发送成功', { icon: 6 });
                            //window.location = "/Project/add?id=" + data.ReturnID;



                                _pageAutoClose();//自动关闭页面方法


                        }
                        else {
                            // toastr.error("失败");
                            parent.layer.msg(data.Message, { icon: 5 });
                        }

                },
                error: function () {


                    parent.layer.msg('失败', { icon: 5 });
                }
            });
        }






        function _pageAutoClose() {
            parent.window._reloadPageData();
            var index = parent.layer.getFrameIndex(window.name);
            parent.layer.isRefresh = true;
            parent.layer.closeAll('loading');
            parent.layer.close(index);
            return false;
        }
    </script>
</body>
</html>

 zhengcaioa/zhengcaioa/Views/OrderBanciOrder/Index.cshtml

New file
@@ -0,0 +1,123 @@
@{
    ViewBag.Title = "OrderBanciOrder";
    Layout = "~/Views/Shared/_Layout_Search.cshtml";
}
@section headerStyle{
    <script type="text/javascript">
        var kechengleixing = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.kechengleixing))';
        gridConfig = { multiselect: true, selectcol: "Id" };
        dataCol = [
            { label: 'id', name: 'Id', labtype: 'txt', hidden: true },

            {
                label: '报名时间', name: 'BaomingtimeName', labtype: 'txt', hidden: false, width: 100
                //,
                //formatter: function (cellvalue, options, rowObject) {
                //    return "<a onclick=\"OpenWindow('" + cellvalue.replace(/'/g, '') + "','98%','100%', '/OrderBanciOrder/Edit?id=" + rowObject.Id + "')\"  >" + cellvalue + "</a>";
                //}
            },
            { label: '培训班次', name: 'Peixunbanci', labtype: 'txt', hidden: false, width: 100 },
            { label: '课程类型', name: 'Kechengleixing', labtype: 'txt', hidden: false, width: 100 },
            { label: '姓名', name: 'Xingming', labtype: 'txt', hidden: false, width: 100 },
            { label: '联系电话', name: 'Lianxidianhua', labtype: 'txt', hidden: false, width: 100 },
            { label: '身份证', name: 'Shenfenzheng', labtype: 'txt', hidden: false, width: 100 },
            { label: '学费', name: 'Xuefei', labtype: 'txt', hidden: false, width: 100 },
            { label: '报名人数', name: 'Baomingrenshu', labtype: 'txt', hidden: false, width: 100 },
            { label: '金额', name: 'Jine', labtype: 'txt', hidden: false, width: 100 },


        ];
        dataUrl = "/OrderBanciOrder/GetList";
        searchCol = [
            { label: '报名时间', name: 'Baomingtime', labtype: 'datearea', hidden: false },
            { label: '培训班次', name: 'Peixunbanci', labtype: 'txt', hidden: false },
            { label: '课程类型', name: 'Kechengleixing', labtype: 'combox', hidden: false, data: JSON.parse(kechengleixing)/*, cwidth: '5%', cccwidth: '8%' */ },
            { label: '姓名', name: 'Xingming', labtype: 'txt', hidden: false },
            { label: '联系电话', name: 'Lianxidianhua', labtype: 'txt', hidden: false },






        ];
        //var _pageAdd = function () {
        //    OpenWindow("新增班次", "98%", "90%", "/OrderBanciOrder/Edit/");
        //}




        var _afterSave = function (result) {
            if (result) {
                toastr.success("保存成功");
            } else {
                toastr.error("保存失败");
            }
        }

        var _afterDel = function (result) {
            if (result) {
                toastr.success("删除成功");
            } else {
                /**/
                toastr.error("删除成功");
        /**/
    }
        }

        var _pageDuanxin = function () {
            var duanxin = GetGridSelect();
            var baifangid = "";
            if (duanxin != '') {
                for (var i = 0; i < duanxin.length; i++) {
                    baifangid += duanxin[i] + ','
                }
                baifangid = baifangid.substring(0, baifangid.length - 1);
            } else {
                toastr.error("请选择订单");
                return;
            }

            OpenWindow("群发短信", "50%", "50%", "/OrderBanciOrder/Duanxin?id=" + baifangid);

        }


        var _pagePrint = function () {

            var Baomingtime = $("#PBSBaomingtime").val();
            var Peixunbanci = $("#PBSPeixunbanci").val();
            var Kechengleixing = $("#PBSKechengleixing").val();
            var Xingming = $("#PBSXingming").val();
            var Lianxidianhua = $("#PBSLianxidianhua").val();
            


            var Createtimestart = $("#PBSCreatetimestart").val();

            var Createtimeend = $("#PBSCreatetimeend").val();
            var Createtime = '';
            if (Createtimestart != '' && Createtimeend != '') {
                Createtime = Createtimestart + '|' + Createtimeend;
            }


            var url = "/OrderBanciOrder/print?Baomingtime=" + Baomingtime + "&Peixunbanci=" + Peixunbanci + "&Kechengleixing=" + Kechengleixing + "&Xingming=" + Xingming + "&Lianxidianhua=" + Lianxidianhua;
            var me = window.open(url, "打印");  //打开新窗口


        }

    </script>
}

@section footerScripts{
    <script type="text/javascript">





    </script>
}

 zhengcaioa/zhengcaioa/Views/OrderBanciOrder/print.cshtml

New file
@@ -0,0 +1,123 @@
@using DTO;
@{
    ViewBag.Title = "Liaotian";
    Layout = null;
    List<OrderBanciOrderDTO> liaotianDTOs = ViewBag.listLiaotianDTO as List<OrderBanciOrderDTO>; //问题类型
}

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta http-equiv="Pragma" content="no-cache">
    <meta http-equiv="Cache-Control" content="no-siteapp" />
    <meta http-equiv="Cache-Control" content="no-cache">
    <meta http-equiv="Expires" content="0">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
    <meta name="renderer" content="webkit">
    <title>@SiteConfig.SiteName</title>
    <meta name="keywords" content="@SiteConfig.Keywords">
    <meta name="description" content="@SiteConfig.Description">
    <meta name="author" content="@SiteConfig.Author">
    <link rel="icon" type="image/x-icon" href="@SiteConfig.ShortcutIcon">
    <!-- uc强制竖屏 -->
    <meta name="screen-orientation" content="portrait">
    <!-- QQ强制竖屏 -->
    <meta name="x5-orientation" content="portrait">
    <!-- UC强制全屏 -->
    <meta name="full-screen" content="yes">
    <!-- QQ强制全屏 -->
    <meta name="x5-fullscreen" content="true">
    <!--[if lt IE 9]>
    <meta http-equiv="refresh" content="0;ie.html" />
    <![endif]-->
    <script src="~/js/jquery.min.js"></script>
    <style type="text/css">
        body {
            text-align: left;
            font-size: 12px;
        }

        table {
            border-collapse: collapse;
            border: none;
            width: 900px;
            margin-left: 0px;
            text-align: center;
        }

        td {
            border: solid #000000 1px;
        }
    </style>
</head>
<body>
    <button type="button" onclick="onprint()">打印</button>
    <div id="printArea">
        @if (liaotianDTOs != null && liaotianDTOs.Count > 0)
        {


            <table>
                @*<tr>
                        <td style="width:10%;"> é—®é¢˜ç±»åˆ«</td>
                        <td style="width:10%;"> é¢˜ç›®ç±»åˆ«</td>
                        <td style="width:30%;"> é—®é¢˜</td>
                        <td style="width:50%;"> å›žç­”</td>
                    </tr>*@


                @{
                    int i = 1;
                }
                <tr>
                    <td style="width:4%;">  ç¼–号</td>
                    <td style="width:7%;"> æŠ¥åæ—¶é—´</td>
                    <td style="width:7%;"> åŸ¹è®­ç­æ¬¡</td>
                    <td style="width:7%;"> è¯¾ç¨‹ç±»åž‹</td>
                    <td style="width:7%;"> å§“名</td>
                    <td style="width:7%;"> è”系电话</td>
                    <td style="width:7%;"> èº«ä»½è¯</td>
                    <td style="width:7%;"> å­¦è´¹</td>
                    <td style="width:7%;"> æŠ¥åäººæ•°</td>
                    <td style="width:7%;"> é‡‘额</td>

                </tr>
                @foreach (var liaotianDTO in liaotianDTOs)
                {

                    <tr>
                        <td>  @i</td>
                        <td>   @liaotianDTO.BaomingtimeName</td>
                        <td>   @liaotianDTO.Peixunbanci</td>
                        <td>   @liaotianDTO.Kechengleixing</td>
                        <td>   @liaotianDTO.Xingming</td>
                        <td>   @liaotianDTO.Lianxidianhua</td>
                        <td>   @liaotianDTO.Shenfenzheng</td>
                        <td>   @liaotianDTO.Xuefei.Value.ToString("F2")</td>
                        <td>   @liaotianDTO.Baomingrenshu</td>
                        <td>   @liaotianDTO.Jine.Value.ToString("F2")</td>
                    </tr>

                    i++;
                }

            </table>
        }
    </div>
</body>
<script type="text/javascript">

    function printHtml(html) {
        var bodyHtml = document.body.innerHTML;
        document.body.innerHTML = html;
        window.print();
        document.body.innerHTML = bodyHtml;
    }
    function onprint() {
        var html = $("#printArea").html();
        printHtml(html);
    }
</script>
</html>

 zhengcaioa/zhengcaioa/Views/Project/Select.cshtml

@@ -11,7 +11,7 @@
        var ShiFouyReasonname = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShiFouyReasonname))';
        

        loseherght = 90;
        loseherght = 110;
        dataCol = [
            { label: 'id', name: 'Id', labtype: 'txt', hidden: true },

@@ -109,6 +109,7 @@
            { label: '录入人', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(Creater)/*, cwidth: '5%', cccwidth: '8%'*/ },
            
            { label: '分差小于', name: 'Fencha', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */ },
            { label: '分差大于', name: 'Fenchadayu', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */ },
            { label: '供应商数量', name: 'Shuliang', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */ },

        ];
@@ -241,6 +242,7 @@
            $("#PBSNamesToubiao").parent().next().remove();
            $("#PBSReasonname").parent().after("<br>");
            $("#PBSCreater").parent().next().remove();
            $("#PBSFenchadayu").parent().after("<br>");
           
        }); 
        

 ±íÐÞ¸Ä.sql

@@ -1,6 +1,238 @@
USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[order_banci_order]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='order_banci_order')  --查询表名costSeparateConfig是否存在  
drop table  [order_banci_order] 
GO
CREATE TABLE [dbo].[order_banci_order](
    [Id] [nvarchar](50) NOT NULL,
    [baomingtime] [datetime] NOT NULL,
    [banci_id] [nvarchar](50)  NULL,
    [peixunbanci] [nvarchar](100)  NULL,
    [kechengleixing_id] [nvarchar](50) NULL,
    [kechengleixing] [nvarchar](100) NULL,
    [person_id] [nvarchar](100)  NULL,
    [xingming] [nvarchar](100)  NULL,
    [lianxidianhua] [nvarchar](100)  NULL,
    [shenfenzheng] [nvarchar](100)  NULL,
    [xuefei] [money] NULL,
    [baomingrenshu] [int] NULL,
    [jine] [money] NULL,
	
    [rec_status] [nvarchar](1) NOT NULL,
    [creater] [nvarchar](50) NOT NULL,
    [createtime] [datetime] NOT NULL,
    [modifier] [nvarchar](50) NOT NULL,
    [modifytime] [datetime] NOT NULL,
 CONSTRAINT [PK_order_banci_order] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO







USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[order_banci]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='order_banci')  --查询表名costSeparateConfig是否存在  
drop table  [order_banci] 
GO
CREATE TABLE [dbo].[order_banci](
    [Id] [nvarchar](50) NOT NULL,
    [banci] [nvarchar](100)  NULL,
    [mingcheng] [nvarchar](100)  NULL,
    [shijian] [datetime]   NULL,
    [shijianend] [datetime]   NULL,
    [didian] [nvarchar](500) NULL,
    [renshu] [int]  NULL,
    [rec_status] [nvarchar](1) NOT NULL,
    [creater] [nvarchar](50) NOT NULL,
    [createtime] [datetime] NOT NULL,
    [modifier] [nvarchar](50) NOT NULL,
    [modifytime] [datetime] NOT NULL,
 CONSTRAINT [PK_order_banci] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO



USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[order_banci_dtl]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='order_banci_dtl')  --查询表名costSeparateConfig是否存在  
drop table  [order_banci_dtl] 
GO
CREATE TABLE [dbo].[order_banci_dtl](
    [Id] [nvarchar](50) NOT NULL,
    [order_banci_id] [nvarchar](50)   NULL,
    [shangxiawu] [nvarchar](100)  NULL,
    [shijian] [nvarchar](100)  NULL,
    [shixiamg] [nvarchar](500) NULL,
    [zhujiangren] [nvarchar](100)  NULL,
    [sort] [int]  NULL,
    [rec_status] [nvarchar](1) NOT NULL,
    [creater] [nvarchar](50) NOT NULL,
    [createtime] [datetime] NOT NULL,
    [modifier] [nvarchar](50) NOT NULL,
    [modifytime] [datetime] NOT NULL,
 CONSTRAINT [PK_order_banci_dtl] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_order_sort]  DEFAULT (0) FOR [sort]
GO
ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO













USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[IntentionVisit_duanxin]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='IntentionVisit_duanxin')  --查询表名costSeparateConfig是否存在  
drop table  [IntentionVisit_duanxin] 
GO
CREATE TABLE [dbo].[IntentionVisit_duanxin](
    [Id] [nvarchar](50) NOT NULL,
    [duanxin_title] [nvarchar](50) NULL,
    [duanxin_neirong] [nvarchar](500) NULL,

    [rec_status] [nvarchar](1) NOT NULL,
    [creater] [nvarchar](50) NOT NULL,
    [createtime] [datetime] NOT NULL,
    [modifier] [nvarchar](50) NOT NULL,
    [modifytime] [datetime] NOT NULL,
 CONSTRAINT [PK_IntentionVisit_duanxin] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO

 


 ALTER TABLE [dbo].[IntentionVisit] ADD [duanxin_neirong] [nvarchar](500) NULL
GO













USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[fi_member]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO