public void AddHouseManOrg()
{
EzhkhInsertDataDb ezhkhInsertDataDb = new EzhkhInsertDataDb();
var wb2 = new XLWorkbook(@"C:\temp\МУП УД.xlsx");
for (int i = 4; i <= 108; i++)
{
string str = ezhkhInsertDataDb.InsertHouseManOrg(
Convert.ToString(wb2.Worksheet(1).Row(i).Cell(1).Value).Trim(),
"02.03.2015", "17729406");
if (str != "ЗАГРУЖЕНО")
{
Console.WriteLine(str);
}
}
wb2.Save();
}
public void AddHouseManOrgFromFile()
{
EzhkhInsertDataDb ezhkhInsertDataDb = new EzhkhInsertDataDb();
var wb2 = new XLWorkbook(@"C:\temp\forImport.xlsx");
for (int i = 3; i <= 9; i++)
{
if (Convert.ToString(wb2.Worksheet(1).Row(i).Cell(5).Value).Trim() != "")
{
string str = ezhkhInsertDataDb.InsertHouseManOrg(
Convert.ToString(wb2.Worksheet(1).Row(i).Cell(5).Value).Trim(),
Convert.ToString(wb2.Worksheet(1).Row(i).Cell(4).Value).Trim().Substring(0, 10),
"17731219");
if (str != "ЗАГРУЖЕНО")
{
Console.WriteLine(str + "||1||" + i.ToString());
}
}
}
for (int i = 4; i <= 6; i++)
{
if (Convert.ToString(wb2.Worksheet(2).Row(i).Cell(5).Value).Trim() != "")
{
string str = ezhkhInsertDataDb.InsertHouseManOrg(
Convert.ToString(wb2.Worksheet(2).Row(i).Cell(5).Value).Trim(),
Convert.ToString(wb2.Worksheet(2).Row(i).Cell(4).Value).Trim().Substring(0, 10),
"17731219");
if (str != "ЗАГРУЖЕНО")
{
Console.WriteLine(str + "||2||" + i.ToString());
}
}
}
for (int i = 4; i <= 30; i++)
{
if (Convert.ToString(wb2.Worksheet(3).Row(i).Cell(5).Value).Trim() != "")
{
string str = ezhkhInsertDataDb.InsertHouseManOrg(
Convert.ToString(wb2.Worksheet(3).Row(i).Cell(5).Value).Trim(),
Convert.ToString(wb2.Worksheet(3).Row(i).Cell(4).Value).Trim().Substring(0, 10),
"17731219");
if (str != "ЗАГРУЖЕНО")
{
Console.WriteLine(str + "||3||" + i.ToString());
}
}
}
for (int i = 3; i <= 68; i++)
{
if (Convert.ToString(wb2.Worksheet(4).Row(i).Cell(5).Value).Trim() != "")
{
string str = ezhkhInsertDataDb.InsertHouseManOrg(
Convert.ToString(wb2.Worksheet(4).Row(i).Cell(5).Value).Trim(),
Convert.ToString(wb2.Worksheet(4).Row(i).Cell(4).Value).Trim().Substring(0, 10),
"17731219");
if (str != "ЗАГРУЖЕНО")
{
Console.WriteLine(str + "||4||" + i.ToString());
}
}
}
wb2.Save();
}