public ToolSix(string mdbFilePath)
{
Init(mdbFilePath);
SheetName = "表6";
StartRow = 4;
StartCell = 3;
StartRow2 = 74;
TypeDict = new Dictionary <int, PotentialFive>();
SSum = new PotentialFive()
{
Up = new PotentialBase(),
Down = new PotentialBase()
};
}
public void Working()
{
using (OleDbConnection connection = new OleDbConnection(ConnectionString))
{
connection.Open();
using (OleDbCommand Command = connection.CreateCommand())
{
double val = .0;
foreach (var code in Codes)
{
var five = new PotentialFive();
foreach (var sf in SFS)
{
Command.CommandText = string.Format("Select SUM(JZRJQL),SUM(TZQDQL),SUM(SSCCQL),SUM(YYSSCCQL) from GYYD where HYDM='{0}' AND SFGSQY='{1}'AND TDSYQK='1'", code, sf);
using (var reader = Command.ExecuteReader())
{
if (reader.Read())
{
var values = new PotentialBase()
{
JZRJQL = double.TryParse(reader[0].ToString(), out val) ? val : .0,
TZQDQL = double.TryParse(reader[1].ToString(), out val) ? val : .0,
SSCCQL = double.TryParse(reader[2].ToString(), out val) ? val : .0,
YYSSCCQL = double.TryParse(reader[3].ToString(), out val) ? val : .0
};
switch (sf)
{
case "是":
five.Up = values;
break;
case "否":
five.Down = values;
break;
}
}
}
}
TypeDict.Add(code, five);
SSum = SSum + five;
}
}
connection.Close();
}
}
public ToolFive(string mdbFilePath)
{
Init(mdbFilePath);
SheetName = "表5";
StartRow = 3;
StartCell = 3;
StartRow2 = 45;
PotentialDict = new Dictionary <string, PotentialFive>();
FPotentialDict = new Dictionary <string, PotentialFive>();
PotentialSum = new PotentialFive()
{
Up = new PotentialBase(),
Down = new PotentialBase()
};
FPotentialSum = new PotentialFive()
{
Up = new PotentialBase(),
Down = new PotentialBase()
};
}
public void Working()
{
using (OleDbConnection connection = new OleDbConnection(ConnectionString))
{
connection.Open();
using (OleDbCommand Command = connection.CreateCommand())
{
double val = .0;
foreach (var region in Regions)
{
PotentialFive five = new PotentialFive();
foreach (var sf in SFS)
{
Command.CommandText = string.Format("Select SUM(JZRJQL),SUM(TZQDQL),SUM(SSCCQL),SUM(YYSSCCQL) from GYYD where XZJDMC='{0}' AND SFGSQY='{1}' AND TDSYQK='1'", region, sf);
using (var reader = Command.ExecuteReader())
{
if (reader.Read())
{
var values = new PotentialBase()
{
JZRJQL = double.TryParse(reader[0].ToString(), out val)?val:.0,
TZQDQL = double.TryParse(reader[1].ToString(), out val)?val:.0,
SSCCQL = double.TryParse(reader[2].ToString(), out val)?val:.0,
YYSSCCQL = double.TryParse(reader[3].ToString(), out val)?val:.0
};
switch (sf)
{
case "是":
five.Up = values;
break;
case "否":
five.Down = values;
break;
}
}
}
}
PotentialDict.Add(region, five);
PotentialSum = PotentialSum + five;
}
string str = string.Empty;
foreach (var terrace in Terraces)
{
PotentialFive five = new PotentialFive();
foreach (var sf in SFS)
{
if (terrace == "其他")
{
str = string.Format("from GYYD where SFWYCYPT='否' AND TDSYQK='1' AND SFGSQY='{0}'", sf);
}
else
{
str = string.Format("from GYYD where CYPTMC Like '%{0}%' AND TDSYQK='1' AND SFGSQY='{1}'", terrace, sf);
}
Command.CommandText = string.Format("Select SUM(JZRJQL),SUM(TZQDQL),SUM(SSCCQL),SUM(YYSSCCQL) {0}", str);
using (var reader = Command.ExecuteReader())
{
if (reader.Read())
{
var values = new PotentialBase()
{
JZRJQL = double.TryParse(reader[0].ToString(), out val) ? val : .0,
TZQDQL = double.TryParse(reader[1].ToString(), out val) ? val : .0,
SSCCQL = double.TryParse(reader[2].ToString(), out val) ? val : .0,
YYSSCCQL = double.TryParse(reader[3].ToString(), out val) ? val : .0
};
switch (sf)
{
case "是":
five.Up = values;
break;
case "否":
five.Down = values;
break;
}
}
}
}
FPotentialDict.Add(terrace, five);
FPotentialSum = FPotentialSum + five;
}
}
connection.Close();
}
}
