public FormConf() { InitializeComponent(); VWConf vwConf = VWConf.Instance; textBoxWorkFolder.Text = vwConf.WorkFolder; textBoxChengXuDanFolder.Text = vwConf.ListFolder; textBoxCIMCOFolder.Text = vwConf.CIMCOExe; textBoxJiaGongTimeFolder.Text = vwConf.TimeFolder; checkBoxOpenpgmList.Checked = vwConf.OpenpgmList; checkBoxOpenpgmTimeList.Checked = vwConf.OpenpgmTimeList; }
private void Init() { VWConf vwConf = VWConf.Instance; LoadComboBox(comboBoxPartName, vwConf.PartsNameList); LoadComboBox(comboBoxBenchMark, vwConf.StandardList); LoadComboBox(comboBoxProcedure, vwConf.ProcedureList); LoadComboBox(comboBoxLeftRight, vwConf.LfPartsList); LoadComboBox(comboBoxModuleName, vwConf.MoldNameList); LoadComboBox(comboBoxSide, vwConf.SideList); LoadComboBox(comboBoxSingleName, vwConf.SingleNameList); toolStripStatusLabelVer.Text = VWConf.Version; }
private void buttonConfirm_Click(object sender, EventArgs e) { VWConf vwConf = VWConf.Instance; vwConf.WorkFolder = textBoxWorkFolder.Text; vwConf.ListFolder = textBoxChengXuDanFolder.Text; vwConf.CIMCOExe = textBoxCIMCOFolder.Text; vwConf.TimeFolder = textBoxJiaGongTimeFolder.Text; vwConf.OpenpgmList = checkBoxOpenpgmList.Checked; vwConf.OpenpgmTimeList = checkBoxOpenpgmTimeList.Checked; vwConf.Save(); this.Close(); }
//程序单输出 public bool WritePgmList(string fileName, NCListData exceldata) { Microsoft.Office.Interop.Excel.Application xls = new Microsoft.Office.Interop.Excel.Application(); _Workbook book = null; _Worksheet sheet = null; try { book = xls.Workbooks.Open(fileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); xls.Visible = false; xls.DisplayAlerts = true; sheet = (_Worksheet)book.Worksheets.get_Item(1); Microsoft.Office.Interop.Excel.Range cellRange = sheet.Cells; NCDoc doc = exceldata.NcDoc; VWConf vwConf = VWConf.Instance; int timeTotle = 0; //Jobs明细输出 List <NCJob> jobs = doc.Jobs; for (int i = 0; i < jobs.Count; i++) { NCJob job = jobs[i]; //程序名 cellRange[i + 23, 1] = job.NC_Job; //加工内容 cellRange[i + 23, 3] = vwConf.GetProgramDispString(job.NC_Job_Code); //刀具-直径 cellRange[i + 23, 5] = "D" + job.Tool_D; //刀具-半径 cellRange[i + 23, 6] = "R" + job.Tool_R; //刀具-悬长 cellRange[i + 23, 7] = job.TotalToolLength; //加工角度 cellRange[i + 23, 8] = job.MachineAxis; //余量 cellRange[i + 23, 11] = job.Stockallow; //料厚 cellRange[i + 23, 12] = job.Wallthick; //步距 cellRange[i + 23, 13] = job.Stepover; //F值 cellRange[i + 23, 14] = job.F; //刀补 cellRange[i + 23, 15] = job.IsR ? "有" : ""; //理论用时 cellRange[i + 23, 16] = job.NCTime; timeTotle += job.Time_Seconds; } //2-19行基本信息 cellRange[2, 2] = exceldata.ProjectName; cellRange[2, 5] = exceldata.ModuleName; cellRange[4, 2] = exceldata.PartName; cellRange[4, 5] = exceldata.SingleName; cellRange[6, 2] = exceldata.Procedure; cellRange[6, 5] = exceldata.LeftRight; cellRange[8, 2] = DateTime.Now.ToString("yyyy-MM-dd"); cellRange[8, 5] = exceldata.BenchMark; cellRange[11, 2] = VWUtil.FormatHMS(timeTotle); cellRange[11, 5] = exceldata.Side; cellRange[16, 2] = doc.NC_Documentation; cellRange[18, 2] = doc.PUTNC_Datei; //图片 Microsoft.Office.Interop.Excel.Range picRange = null; picRange = sheet.get_Range("R2", Missing.Value); picRange.Select(); Microsoft.Office.Interop.Excel.Pictures pics = (Microsoft.Office.Interop.Excel.Pictures)sheet.Pictures(Missing.Value); pics.Delete(); pics.Insert(exceldata.PicturePath, Missing.Value); book.Save(); book.Close(false, Missing.Value, Missing.Value); return(true); } catch (Exception ex) { return(false); } finally { xls.Quit(); xls = null; sheet = null; book = null; GC.Collect(); } }