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();
}
}
