private void ComboboxSave()
{
XmlRead read = new XmlRead();
int result = 0;
try
{
int num2;
read.Delete(FileName.File1);
int.TryParse(this.txt_1.Text, out result);
result--;
if (result < 0)
{
result = 0;
}
DataTable table = ExcelRead.ExcelToDataTable(this.file_1.get_TextBoxFile().Text, this.com_sheet_1.Text.Trim() + "$", 0);
for (num2 = 0; num2 < table.Columns.Count; num2++)
{
int num3 = num2 + 1;
read.File1AppendChild("1." + num3.ToString(), table.Rows[Convert.ToInt32(result)][num2].ToString());
}
read.Delete(FileName.File2);
int.TryParse(this.txt_2.Text, out result);
result--;
if (result < 0)
{
result = 0;
}
if (File.Exists(this.file_2.get_TextBoxFile().Text.Trim()))
{
DataTable table2 = ExcelRead.ExcelToDataTable(this.file_2.get_TextBoxFile().Text, this.com_sheet_2.Text.Trim() + "$", 0);
for (num2 = 0; num2 < table2.Columns.Count; num2++)
{
read.File2AppendChild("2." + ((num2 + 1)).ToString(), table.Rows[Convert.ToInt32(result)][num2].ToString());
}
}
Regex regex = new Regex(@"^\[\d+\]");
read.SetKey1(regex.Replace(this.combo_1.Text.Trim(), string.Empty));
read.SetKey2(regex.Replace(this.combo_2.Text.Trim(), string.Empty));
}
catch (Exception exception)
{
MessageBoxHelper.Show(exception.ToString(), "异常");
}
}
private void comboboxBind()
{
this.combobox.Items.Clear();
int result = 0;
try
{
int num2;
int.TryParse(this.txt_1.Text, out result);
result--;
if (result < 0)
{
result = 0;
}
DataTable table = new DataTable();
if (File.Exists(this.file_1.get_TextBoxFile().Text))
{
table = ExcelRead.ExcelToDataTable(this.file_1.get_TextBoxFile().Text, this.com_sheet_1.Text.Trim() + "$", 0);
for (num2 = 1; num2 <= table.Columns.Count; num2++)
{
this.combobox.Items.Add("1." + num2);
}
this.combobox.Items.Add("----------------------");
result = 0;
int.TryParse(this.txt_2.Text, out result);
result--;
if (result < 0)
{
result = 0;
}
}
if (this.radioButton2.Checked && File.Exists(this.file_2.get_TextBoxFile().Text))
{
DataTable table2 = ExcelRead.ExcelToDataTable(this.file_2.get_TextBoxFile().Text, this.com_sheet_2.Text.Trim() + "$", 0);
for (num2 = 1; num2 <= table2.Columns.Count; num2++)
{
this.combobox.Items.Add("2." + num2);
}
}
}
catch
{
}
}
private void ReadExcelTableHead(AisinoCMB combox, string path, string sheetName, int HeadRow)
{
try
{
HeadRow--;
if (HeadRow < 0)
{
HeadRow = 0;
}
combox.Items.Clear();
DataTable table = ExcelRead.ExcelToDataTable(path, sheetName + "$", 0);
for (int i = 0; i < table.Columns.Count; i++)
{
int num2 = i + 1;
combox.Items.Add("[" + num2.ToString() + "]" + table.Rows[HeadRow][i].ToString());
}
}
catch (Exception exception)
{
MessageBoxHelper.Show(exception.ToString(), "异常");
}
}
public static DataTable GetFileData(string File1, string File2, string sheet1, string sheet2, int MainHeadline, int SubHeadline, int key1, int key2, List <ExcelMappingItem.Relation> Relationlist, string DefaultFuHeRen, string DefaultShouKuanRen, string DefaultShuiLv)
{
DataRow current;
int num5;
string str;
int num8;
int num9;
string str3;
long num10;
string str4;
DataTable table = new DataTable();
DataTable table2 = WenBenItem.Items();
using (IEnumerator enumerator = table2.Rows.GetEnumerator())
{
while (enumerator.MoveNext())
{
current = (DataRow)enumerator.Current;
table.Columns.Add(current["key"].ToString());
}
}
DataTable table3 = ExcelRead.ExcelToDataTable(MainHeadline, File1, sheet1 + "$");
DataTable table4 = new DataTable();
if (File2.Length > 0)
{
table4 = ExcelRead.ExcelToDataTable(SubHeadline, File2, sheet2 + "$");
}
int num = 0;
int num2 = 0;
int columnName = 0;
int num4 = 0;
for (num5 = 0; num5 < Relationlist.Count; num5++)
{
ExcelMappingItem.Relation relation = Relationlist[num5];
if (relation.TableFlag == 1)
{
num++;
if (columnName < Relationlist[num5].ColumnName)
{
columnName = Relationlist[num5].ColumnName;
}
}
else if ((File2.Length > 0) && (relation.TableFlag == 2))
{
num2++;
if (num4 < Relationlist[num5].ColumnName)
{
num4 = Relationlist[num5].ColumnName;
}
}
}
if (columnName > table3.Columns.Count)
{
int count = columnName - table3.Columns.Count;
CommonTool.AddBlankColumns(table3, count);
}
if ((File2.Length > 0) && (num4 > table4.Columns.Count))
{
int num7 = num4 - table4.Columns.Count;
CommonTool.AddBlankColumns(table4, num7);
}
if (File2 == string.Empty)
{
for (num5 = 0; num5 < table3.Rows.Count; num5++)
{
current = table.NewRow();
foreach (ExcelMappingItem.Relation relation2 in Relationlist)
{
if (relation2.TableFlag == 1)
{
str = table3.Rows[num5][relation2.ColumnName - 1].ToString();
current[relation2.Key] = table3.Rows[num5][relation2.ColumnName - 1];
}
else if ((relation2.TableFlag == 2) && (File2 != string.Empty))
{
foreach (DataRow row2 in table4.Rows)
{
if (row2[key2].ToString() == table3.Rows[num5][key1].ToString())
{
if (!(relation2.Key == "DanJuHaoMa"))
{
current[relation2.Key] = row2[relation2.ColumnName - 1];
}
break;
}
}
}
}
num8 = 0;
num9 = 0;
while (num9 < table.Columns.Count)
{
if (current[num9].ToString().Trim().Length > 0)
{
break;
}
num8++;
num9++;
}
if (num8 != table.Columns.Count)
{
if (Convert.ToString(current["FuHeRen"]) == string.Empty)
{
current["FuHeRen"] = DefaultFuHeRen;
}
if (Convert.ToString(current["ShouKuanRen"]) == string.Empty)
{
current["ShouKuanRen"] = DefaultShouKuanRen;
}
if (Convert.ToString(current["ShuiLv"]) == string.Empty)
{
current["ShuiLv"] = DefaultShuiLv;
}
str3 = Convert.ToString(current["GouFangShuiHao"]).ToUpper();
if (str3.Contains("E+") || str3.Contains("E-"))
{
num10 = 0L;
if (long.TryParse(str3, NumberStyles.Any, null, out num10))
{
str4 = num10.ToString();
current["GouFangShuiHao"] = str4;
}
}
table.Rows.Add(current);
}
}
return(table);
}
for (num5 = 0; num5 < table3.Rows.Count; num5++)
{
for (int i = 0; i < table4.Rows.Count; i++)
{
if (table3.Rows[num5][key1].ToString() != table4.Rows[i][key2].ToString())
{
continue;
}
current = table.NewRow();
foreach (ExcelMappingItem.Relation relation2 in Relationlist)
{
if (relation2.TableFlag == 1)
{
str = table3.Rows[num5][relation2.ColumnName - 1].ToString();
current[relation2.Key] = table3.Rows[num5][relation2.ColumnName - 1];
}
else if (((relation2.TableFlag == 2) && (File2 != string.Empty)) && (relation2.Key != "DanJuHaoMa"))
{
current[relation2.Key] = table4.Rows[i][relation2.ColumnName - 1];
}
}
num8 = 0;
for (num9 = 0; num9 < table.Columns.Count; num9++)
{
if (current[num9].ToString().Trim().Length > 0)
{
break;
}
num8++;
}
if (num8 != table.Columns.Count)
{
if (Convert.ToString(current["FuHeRen"]) == string.Empty)
{
current["FuHeRen"] = DefaultFuHeRen;
}
if (Convert.ToString(current["ShouKuanRen"]) == string.Empty)
{
current["ShouKuanRen"] = DefaultShouKuanRen;
}
if (Convert.ToString(current["ShuiLv"]) == string.Empty)
{
current["ShuiLv"] = DefaultShuiLv;
}
str3 = Convert.ToString(current["GouFangShuiHao"]).ToUpper();
if (str3.Contains("E+") || str3.Contains("E-"))
{
num10 = 0L;
if (long.TryParse(str3, NumberStyles.Any, null, out num10))
{
str4 = num10.ToString();
current["GouFangShuiHao"] = str4;
}
}
table.Rows.Add(current);
}
}
}
return(table);
}
