예제 #1
0
 /// <summary>
 /// 获取版本删除数据
 /// </summary>
 private void CallGetDataDelRev(List <ExportDto.MPART> PartDatas, bool IsOnly)
 {
     DataDelPartRev = new DataTable();
     if (!IsOnly)
     {
         List <ExportDto.PARTREV_DEL> data = new List <ExportDto.PARTREV_DEL>();
         var items = PartDatas.Where(o => o.TypeCode == "M").ToList();
         foreach (var item in items)
         {
             ExportDto.PARTREV_DEL obj = new ExportDto.PARTREV_DEL();
             obj.Company     = "001";
             obj.AltMethod   = "";
             obj.PartNum     = item.PartNum;
             obj.RevisionNum = item.PartRev_RevisionNum;
             data.Add(obj);
         }
         DataDelPartRev = Utility.ListToDataTable(data, "_", "#");
     }
     Utility.ExportExcel(DataDelPartRev, SaveFolderPath + "\\PART_REV_DEL.xls");
     pecentExe += 20;
     lblStatus  = "版本删除数据已就绪...";
 }
예제 #2
0
        private void buttonStartSync_Click(object sender, EventArgs e)
        {
            buttonStartSync.Enabled = false;
            labelSyncStatus.Text    = "开始同步";

            buttonOk_Click(sender, e);
            buttonGetBOO_Click(sender, e);
            buttonGetBOM_Click(sender, e);

            string MM = DateTime.Now.ToString("yyyyMMddhhmmss");

            FileHelper.CreateDir("DMT" + MM, Application.StartupPath + @"\ExcelImport");
            SaveFolderPath = Application.StartupPath + @"\ExcelImport\DMT" + MM;

            var partA   = BOM.Select(o => o.MtlPartNum).Distinct().ToList();
            var partB   = BOM.Select(o => o.PartNum).Distinct().ToList();
            var part    = partA.Union(partB).ToArray();
            var lists   = PLM.GetNewPLMPart(part, null);
            var PARTBOM = Utilities.MapTo <List <ExportDto.MPART> >(lists);

            PART = PART.Union(PARTBOM).Distinct().ToList();
            foreach (var item in PART)
            {
                item.TrackLots              = "TRUE";
                item.NonStock               = Utilities.CheckNonStock(item.PartNum).ToString().ToUpper();
                item.PartPlant_NonStock     = item.NonStock;
                item.PartPlant_CostMethod   = item.CostMethod;
                item.PartWhse_WarehouseCode = "YJK";
                item.PartRev_RevisionNum    = item.TypeCode == "M" ? textBoxPartRev.Text : "";
                item.PartRev_RevShortDesc   = item.PartRev_RevisionNum;
            }
            foreach (var item in BOO)
            {
                item.ECOGroupID = "usersync";
            }
            foreach (var item in BOM)
            {
                item.ECOGroupID = "usersync";
            }

            DataTable dt = Utility.ListToDataTable(PART, "_", "#");

            Utility.ExportExcel(dt, SaveFolderPath + "\\PART.xls");
            dt = Utility.ListToDataTable(BOO, "_", "#");
            Utility.ExportExcel(dt, SaveFolderPath + "\\BOO.xls");
            dt = Utility.ListToDataTable(BOM, "_", "#");
            Utility.ExportExcel(dt, SaveFolderPath + "\\BOM.xls");

            List <ExportDto.PARTREV_DEL> part_rev_del = new List <ExportDto.PARTREV_DEL>();
            var items = PART.Where(o => o.TypeCode == "M").ToList();

            foreach (var item in items)
            {
                ExportDto.PARTREV_DEL obj = new ExportDto.PARTREV_DEL();
                obj.Company     = "001";
                obj.AltMethod   = "";
                obj.PartNum     = item.PartNum;
                obj.RevisionNum = item.PartRev_RevisionNum;
                part_rev_del.Add(obj);
            }
            dt = Utility.ListToDataTable(part_rev_del, "_", "#");
            Utility.ExportExcel(dt, SaveFolderPath + "\\PART_REV_DEL.xls");

            StartSync();
        }