private void LoadFile()
{
try
{
Dictionary <string, string> dictionary = new Dictionary <string, string>();
XmlRead read = new XmlRead();
Dictionary <string, string> item = read.GetItem(FileName.File1);
foreach (KeyValuePair <string, string> pair in item)
{
this.combobox.Items.Add("[" + pair.Key + "]" + pair.Value);
dictionary.Add(pair.Key, pair.Value);
}
this.combobox.Items.Add("----------------------");
Dictionary <string, string> dictionary3 = read.GetItem(FileName.File2);
foreach (KeyValuePair <string, string> pair in dictionary3)
{
this.combobox.Items.Add("[" + pair.Key + "]" + pair.Value);
dictionary.Add(pair.Key, pair.Value);
}
this.file_1.set_FileFilter("Excel文件(*.xls)|*.xls");
this.file_2.set_FileFilter("Excel文件(*.xls)|*.xls");
this.file_1.get_TextBoxFile().Text = IniRead.GetPrivateProfileString("File", "File1Path");
this.file_2.get_TextBoxFile().Text = IniRead.GetPrivateProfileString("File", "File2Path");
this.com_sheet_1.Text = IniRead.GetPrivateProfileString("File", "TableInFile1");
this.com_sheet_2.Text = IniRead.GetPrivateProfileString("File", "TableInFile2");
string privateProfileString = IniRead.GetPrivateProfileString("FieldCon", "FileNumber");
int result = 1;
int.TryParse(privateProfileString, out result);
this.radioButton1.Checked = result == 1;
this.radioButton2.Checked = result == 2;
DataGridView view = this.dataGridView1;
DataTable table = WenBenItem.Items();
foreach (DataRow row in table.Rows)
{
string str2 = IniRead.GetPrivateProfileString("FieldCon", row["key"].ToString());
if (str2 != "0.0")
{
view.Rows[Convert.ToInt32(row["id"]) - 1].Cells["WenJianLie"].Value = str2;
}
}
view.Rows[6].Cells["MoRen"].Value = IniRead.GetPrivateProfileString("FieldCon", "DefaultFuHeRen");
view.Rows[7].Cells["MoRen"].Value = IniRead.GetPrivateProfileString("FieldCon", "DefaultShouKuanRen");
view.Rows[0x13].Cells["MoRen"].Value = IniRead.GetPrivateProfileString("FieldCon", "DefaultShuiLv");
this.combo_1.Text = "[" + IniRead.GetPrivateProfileString("TableCon", "MainTableField") + "]" + read.GetKey1();
this.combo_2.Text = "[" + IniRead.GetPrivateProfileString("TableCon", "AssistantTableField") + "]" + read.GetKey2();
this.txt_1.Text = IniRead.GetPrivateProfileString("TableCon", "MainTableIgnoreRow");
this.txt_2.Text = IniRead.GetPrivateProfileString("TableCon", "AssistantTableIgnoreRow");
}
catch (Exception exception)
{
HandleException.HandleError(exception);
}
}
private void ExcelFormShow()
{
int num;
this.dataGridView1.DataSource = WenBenItem.Items();
if ((this.invtype == InvType.Common) || (this.invtype == InvType.Special))
{
for (num = 1; num < 0x42; num++)
{
if (num < 0x1b)
{
this.dataGridView1.Rows[num].Visible = true;
}
else
{
this.dataGridView1.Rows[num].Visible = false;
}
}
}
else if (this.invtype == InvType.transportation)
{
for (num = 1; num < 0x42; num++)
{
if (num < 0x1b)
{
this.dataGridView1.Rows[num].Visible = false;
}
else if (num < 0x2c)
{
this.dataGridView1.Rows[num].Visible = true;
}
else
{
this.dataGridView1.Rows[num].Visible = false;
}
}
}
else if (this.invtype == InvType.vehiclesales)
{
for (num = 1; num < 0x42; num++)
{
if (num < 0x2c)
{
this.dataGridView1.Rows[num].Visible = false;
}
else
{
this.dataGridView1.Rows[num].Visible = true;
}
}
}
}
public ExcelForm(InvType type)
{
this.invtype = type;
this.Initialize();
this.combobox.Visible = false;
this.dataGridView1.DataSource = WenBenItem.Items();
this.file_1.add_onClickEnd(new FileControl.OnClickEnd(this, (IntPtr)this.file_1_onClickEnd));
this.file_2.add_onClickEnd(new FileControl.OnClickEnd(this, (IntPtr)this.file_2_onClickEnd));
this.dataGridView1.Controls.Add(this.combobox);
this.combobox.SelectedIndexChanged += new EventHandler(this.combobox_SelectedIndexChanged);
this.combobox.Validating += new CancelEventHandler(this.combobox_Validating);
this.combobox.KeyUp += new KeyEventHandler(this.combobox_KeyUp);
this.CheckInTableOneAndTwo(this.radioButton2.Checked);
}
private void YuLanColumnsBind()
{
try
{
DataTable table = WenBenItem.Items();
foreach (DataRow row in table.Rows)
{
DataGridViewColumn dataGridViewColumn = new DataGridViewTextBoxColumn {
Name = row["key"].ToString(),
HeaderText = row["ShuJuXiang"].ToString(),
DataPropertyName = row["key"].ToString()
};
this.dataGridView2.Columns.Add(dataGridViewColumn);
}
this.ExcelFormPreviewShow();
}
catch (Exception exception)
{
HandleException.HandleError(exception);
}
}
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);
}
private DataTable ExcelLoad()
{
DataTable table2;
try
{
string str = this.File1;
string str2 = this.File2;
string privateProfileString = IniRead.GetPrivateProfileString("File", "TableInFile1");
string str4 = IniRead.GetPrivateProfileString("File", "TableInFile2");
string s = IniRead.GetPrivateProfileString("FieldCon", "FileNumber");
int result = 1;
int.TryParse(s, out result);
List <ExcelMappingItem.Relation> yingShe = new List <ExcelMappingItem.Relation>();
DataTable table = WenBenItem.Items();
foreach (DataRow row in table.Rows)
{
string key = row["key"].ToString();
string str7 = IniRead.GetPrivateProfileString("FieldCon", key);
ExcelMappingItem.Relation item = new ExcelMappingItem.Relation {
Key = row["key"].ToString()
};
int num2 = 0;
int.TryParse(str7.Substring(0, str7.IndexOf('.')), out num2);
item.TableFlag = num2;
num2 = 0;
int.TryParse(str7.Substring(str7.LastIndexOf('.') + 1), out num2);
item.ColumnName = num2;
yingShe.Add(item);
}
string defaultFuHeRen = IniRead.GetPrivateProfileString("FieldCon", "DefaultFuHeRen");
string defaultShouKuanRen = IniRead.GetPrivateProfileString("FieldCon", "DefaultShouKuanRen");
string defaultShuiLv = IniRead.GetPrivateProfileString("FieldCon", "DefaultShuiLv");
int num3 = 0;
int.TryParse(IniRead.GetPrivateProfileString("TableCon", "MainTableField"), out num3);
int num4 = num3;
num3 = 0;
int.TryParse(IniRead.GetPrivateProfileString("TableCon", "AssistantTableField"), out num3);
int num5 = num3;
num3 = 0;
int.TryParse(IniRead.GetPrivateProfileString("TableCon", "MainTableIgnoreRow"), out num3);
int num6 = num3;
num3 = 0;
int.TryParse(IniRead.GetPrivateProfileString("TableCon", "AssistantTableIgnoreRow"), out num3);
int subHeadline = num3;
switch (result)
{
case 1:
return(this.GetFileData(str, privateProfileString, num6, yingShe, defaultFuHeRen, defaultShouKuanRen, defaultShuiLv));
case 2:
return(GetFileData(str, str2, privateProfileString, str4, num6, subHeadline, num4, num5, yingShe, defaultFuHeRen, defaultShouKuanRen, defaultShuiLv));
}
table2 = null;
}
catch (Exception)
{
throw;
}
return(table2);
}
