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
{
}
}
public CNIAMDSConfigMotion()
{
this.uDSConfigMotion = new Infragistics.Win.UltraWinDataSource.UltraDataSource();
}
