private void ReadOtp_SaveFile(Excel.Worksheet xlsSheet) { this.uDSConfigOtp = new Infragistics.Win.UltraWinDataSource.UltraDataSource(); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn1 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("No1"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn2 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Name1"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn3 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Status1"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn4 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("No2"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn5 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Name2"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn6 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Status2"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn7 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("No3"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn8 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Name3"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn9 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Status3"); ultraDataColumn1.DataType = typeof(uint); this.uDSConfigOtp.Band.Columns.AddRange(new object[] { ultraDataColumn1, ultraDataColumn2, ultraDataColumn3, ultraDataColumn4, ultraDataColumn5, ultraDataColumn6, ultraDataColumn7, ultraDataColumn8, ultraDataColumn9, }); int boolArrayQuentity = this.m_Otp_Module_Quentity * 32; this.m_abReadedOtpMapUse = new bool[boolArrayQuentity]; try { this.uDSConfigOtp.Rows.Clear(); string rowReadData; string rowStatusDAta; UltraDataRow rowItem = null; int IONameReadCount = 1; int ColumnCount = 1; int IOMapAddressCount = 0; for (int row = 100; row < 200; row++) // { Debug.Write("Row " + row.ToString() + " 입니다." + System.Environment.NewLine); if (((Excel.Range)xlsSheet.Cells[row, 5]).Value2 == null) // null 이면 종료 { break; } if (((Excel.Range)xlsSheet.Cells[row, 6]).Value2 == null) { m_abReadedOtpMapUse[IOMapAddressCount] = false; IOMapAddressCount++; continue; } else { m_abReadedOtpMapUse[IOMapAddressCount] = true; IOMapAddressCount++; } if (ColumnCount == 1) { this.uDSConfigOtp.Rows.Add(); rowItem = this.uDSConfigOtp.Rows[this.uDSConfigOtp.Rows.Count - 1]; } rowReadData = ((Excel.Range)xlsSheet.Cells[row, 6]).Value2.ToString().Trim(); rowStatusDAta = ((Excel.Range)xlsSheet.Cells[row, 7]).Value2.ToString().Trim(); switch (ColumnCount) { case 1: rowItem["NO1"] = IONameReadCount.ToString("00"); rowItem["Name1"] = rowReadData; rowItem["Status1"] = (IOMapAddressCount - 1).ToString("00"); break; case 2: rowItem["NO2"] = IONameReadCount.ToString("00"); rowItem["Name2"] = rowReadData; rowItem["Status2"] = (IOMapAddressCount - 1).ToString("00"); break; case 3: rowItem["NO3"] = IONameReadCount.ToString("00"); rowItem["Name3"] = rowReadData; rowItem["Status3"] = (IOMapAddressCount - 1).ToString("00"); break; } if (ColumnCount == 3) { ColumnCount = 1; } else { ColumnCount++; } IONameReadCount++; } int orc = uDSConfigOtp.Rows.Count; for (int i = 0; i < (12 - orc); i++) { this.uDSConfigOtp.Rows.Add(); } //this.uDSConfigOtp.Rows.Add(); } catch { //MessageBox.Show("ERROR !! READ TO EXCEL FILE !!"); } finally { } }
private void ReadMotionSet_SaveFile(Excel.Worksheet xlsSheet) { Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn1 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("No"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn2 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("AxName"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn3 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("LimitPos"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn4 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("LimitNeg"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn5 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("PosOrigin"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn6 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("OnOff"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn7 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("PosStart"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn8 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Error"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn9 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Position"); Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn10 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Speed"); ultraDataColumn1.DataType = typeof(uint); this.uDSConfigMotion.Band.Columns.AddRange(new object[] { ultraDataColumn1, ultraDataColumn2, ultraDataColumn3, ultraDataColumn4, ultraDataColumn5, ultraDataColumn6, ultraDataColumn7, ultraDataColumn8, ultraDataColumn9, ultraDataColumn10 }); try { this.uDSConfigMotion.Rows.Clear(); string[] rowReadData = new string[9]; UltraDataRow rowItem = null; int IONameReadCount = 1; int ColumnCount = 1; for (int row = 2; row < 100; row++) // { Debug.Write("Row " + row.ToString() + " 입니다." + System.Environment.NewLine); if (((Excel.Range)xlsSheet.Cells[row, 1]).Value2 == null) // null 이면 종료 { break; } this.uDSConfigMotion.Rows.Add(); rowItem = this.uDSConfigMotion.Rows[row - 2]; for (int col = 1; col < 10; col++) { rowReadData[col - 1] = ((Excel.Range)xlsSheet.Cells[row, col]).Value2.ToString();//.Trim(); } rowItem["No"] = this.uDSConfigMotion.Rows.Count; rowItem["AxName"] = rowReadData[0]; rowItem["LimitPos"] = rowReadData[1]; rowItem["LimitNeg"] = rowReadData[2]; rowItem["PosOrigin"] = rowReadData[3]; rowItem["OnOff"] = rowReadData[4]; rowItem["PosStart"] = rowReadData[5]; rowItem["Error"] = rowReadData[6]; rowItem["Position"] = rowReadData[7]; rowItem["Speed"] = rowReadData[8]; } this.uDSConfigMotion.Rows.Add(); this.uDSConfigMotion.Rows.Add(); this.uDSConfigMotion.Rows.Add(); this.uDSConfigMotion.Rows.Add(); this.uDSConfigMotion.Rows.Add(); this.uDSConfigMotion.Rows.Add(); this.uDSConfigMotion.Rows.Add(); this.uDSConfigMotion.Rows.Add(); this.uDSConfigMotion.Rows.Add(); } catch { //MessageBox.Show("ERROR !! READ TO EXCEL FILE !!"); } finally { } }