批量插入数据

最新推荐文章于 2024-09-16 10:36:43 发布

王雨祥

最新推荐文章于 2024-09-16 10:36:43 发布

阅读量504

点赞数

分类专栏： ASP.NET 文章标签： c#

本文链接：https://blog.csdn.net/weixin_44310519/article/details/122538322

版权

ASP.NET 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

  DataTable table = new DataTable(tableName);//DateTable 类型 需要与数据表的顺序一致才可以，否则会报错或数据插入失败
 using (SqlConnection connectPIMS = new SqlConnection("数据库连接字符串")){
                                connectPIMS.Open();
                                using (SqlBulkCopy bulkCopy = new     SqlBulkCopy(PIMSConnectString, SqlBulkCopyOptions.KeepIdentity))
                                {
                                    var dt = table;
                                    bulkCopy.DestinationTableName = tableName;
                                    bulkCopy.BatchSize = dt.Rows.Count;
                                    int resultCount = 0;
                                    bulkCopy.BulkCopyTimeout = 300;
                                    try
                                    {
                                        if (dt != null && dt.Rows.Count != 0)
                                            bulkCopy.WriteToServer(dt);
                                    }
                                    catch (Exception e)
                                    {
                                    }
                                }
                            }

  Expression<Func<TblApqpppap, bool>> tblPpap = o =>o.PpaptaskNum== ppapTaskNum;
  Expression<Func<TblPpapversion, bool>> tblPPAPVersion = o =>o.Ppapversion== ppapVersion;
  
 public async Task<PPAPDeatilModelVO> GetPPAPDetailsByPPAPNOOrVersion(Expression<Func<TblApqpppap, bool>> tblPpapConditon, Expression<Func<TblPpapversion, bool>> tblPPAPVersion)
        {
            var db = await base.GetDbContextAsync() as NioPIMSContext;
            var resultData =
                db.TblApqpppap.Where(tblPpapConditon)
                .Join(db.TblPpapversion.Where(tblPPAPVersion), ppap => ppap.Ppapid, ppapv => ppapv.Ppapid, (ppap, ppapv) => new
                {
                    ppap,
                    ppapv
                }).Join(db.TblCommodity, temp => temp.ppapv.CommodityId, comm => comm.CommodityId, (temp, comm) => new
                {
                    temp.ppap,
                    temp.ppapv,
                    comm
                })
                .Join(db.TblManufacturingBody, temp => temp.ppapv.ManufacturingBodyId, manu => manu.ManufacturingBodyId, (temp, manu) =>
                new
                {
                    temp.ppap,
                    temp.ppapv,
                    temp.comm,
                    manu
                })
                .Join(db.TblPqm, temp => temp.ppapv.Pqmid, pqm => pqm.Pqmid, (temp, pqm) => new
                {
                    temp.ppap,
                    temp.ppapv,
                    temp.comm,
                    temp.manu,
                    pqm

                }).Join(db.UrUsers, temp => temp.pqm.UserId.ToString(), user => user.UserId, (temp, user) => new
                {
                    temp.ppap,
                    temp.ppapv,
                    temp.comm,
                    temp.manu,
                    temp.pqm,
                    user
                })
                .Select(data => new PPAPDeatilModelVO
                {
                    PPAPID = data.ppap.Ppapid,
                    PPAPTaskNum = data.ppap.PpaptaskNum,
                    PPAPVersion = data.ppapv.Ppapversion,
                    Status = data.ppapv.Status.Value,
                    PPAPResult = data.ppapv.Ppapresult.Value,
                    PlanApproveDate = data.ppapv.PlanApproveDate,
                    ActualApproveDate = data.ppapv.ActualApproveDate,
                    ExpireDate = data.ppapv.ExpireDate,
                    FullPlanApproveDate = data.ppapv.FullPlanApproveDate,
                    FullActualApproveDate = data.ppapv.FullActualApproveDate,
                    CommodityID = data.comm.CommodityId,
                    Commodity = data.comm.Commodity,
                    ManufacturingBodyID = data.ppapv.ManufacturingBodyId,
                    ManufacturingBodyChineseName = data.manu.ManufacturingBodyName,
                    ManufacturingBodyEngilsgName = data.manu.ManufacturingBodyNameEn,
                    ManufacturingBodyCode = data.manu.ManufacturingBodyCode,
                    LevelID = data.ppapv.LevelId,
                    PQMID = data.pqm.Pqmid,
                    PQMUserName = data.user.UserLoginName
                }).ToList().FirstOrDefault();
            //查询SubmitLevel数据信息
            resultData.submitLevel = db.TblPpapsubmitLevel.ToList().Where(submit => submit.LevelId == resultData.LevelID.Value)
                   .Select(r => { var m = r.SubmitLevel; return m; }).FirstOrDefault();
            return resultData;
        }