public void InitM()
{
double temp = .0;
using (OleDbConnection connection = new OleDbConnection(ConnectionString))
{
connection.Open();
using (OleDbCommand Command = connection.CreateCommand())
{
Command.CommandText = "Select DKBH,PZYDMJ,TDDJMJ,DYMJ,YDZMJ,WJPZYDMJ,JZZMJ,JZZDMJ,WPZJZMJ,WPZJZZDMJ,SFWYCYPT,CYPTMC,TDSYQK,YKFTDMJ,WKFTDMJ from GYYD";
using (var reader = Command.ExecuteReader())
{
string DKBH = string.Empty;
while (reader.Read())
{
DKBH = reader[0].ToString().Trim();
if (!string.IsNullOrEmpty(DKBH) && !AreaDict.ContainsKey(DKBH))
{
AreaDict.Add(DKBH, new Union()
{
AreaBase = new AreaBase()
{
PZYDMJ = double.TryParse(reader[1].ToString(), out temp) ? temp : 0,
TDDJMJ = double.TryParse(reader[2].ToString(), out temp) ? temp : 0,
DYMJ = double.TryParse(reader[3].ToString(), out temp) ? temp : 0
},
AreaOne = new AreaOne()
{
YDZMJ = double.TryParse(reader[4].ToString(), out temp) ? temp : 0,
WJPZYDMJ = double.TryParse(reader[5].ToString(), out temp) ? temp : 0,
JZZMJ = double.TryParse(reader[6].ToString(), out temp) ? temp : 0,
JZZDMJ = double.TryParse(reader[7].ToString(), out temp) ? temp : 0,
WPZJZMJ = double.TryParse(reader[8].ToString(), out temp) ? temp : 0,
WPZJZZDMJ = double.TryParse(reader[9].ToString(), out temp) ? temp : 0,
SFWYCYPT = reader[10].ToString() == "是" ? true : false,
CYPTMC = reader[11].ToString(),
TDSYQK = reader[12].ToString(),
YKFTDMJ = double.TryParse(reader[13].ToString(), out temp) ? temp : 0,
WKFTDMJ = double.TryParse(reader[14].ToString(), out temp) ? temp : 0
}
});
}
}
}
Command.CommandText = "Select DKBH,SJYT from TDSJYTJG";
using (var reader = Command.ExecuteReader())
{
string DKBH = string.Empty;
string SJYT = string.Empty;
while (reader.Read())
{
DKBH = reader[0].ToString();
SJYT = reader[1].ToString();
if (!string.IsNullOrEmpty(DKBH) && !string.IsNullOrEmpty(SJYT))
{
if (!WayDict.ContainsKey(DKBH))
{
WayDict.Add(DKBH, SJYT);
}
else
{
WayDict[DKBH] = WayDict[DKBH] + "," + SJYT;
}
}
}
}
Command.CommandText = "Select QYBH,SFGXQY,HYDM,XZJDMC,SFGSQY,CYRS,LJGDZCTZ,YDL2012,YDL2013,YDL2014,GSRKSS2012,GSRKSS2013,GSRKSS2014,DSRKSS2012,DSRKSS2013,DSRKSS2014,ZYYSR2012,ZYYSR2013,ZYYSR2014,QYMC from YDDW";
using (var reader = Command.ExecuteReader())
{
string QYBH = string.Empty;
while (reader.Read())
{
QYBH = reader[0].ToString();
if (!string.IsNullOrEmpty(QYBH) && !FacDict.ContainsKey(QYBH))
{
try
{
double val = 0.0;
FacDict.Add(QYBH, new MergeBase()
{
SFGXQY = reader[1].ToString() == "是" ? true : false,
HYDM = reader[2].ToString(),
XZJDMC = reader[3].ToString(),
SFGSQY = reader[4].ToString() == "是" ? true : false,
CYRS = int.Parse(reader[5].ToString()),
LJGDZCTZ = double.TryParse(reader[6].ToString(), out val)?val:.0,
YDL2012 = double.TryParse(reader[7].ToString(), out val)?val:.0,
YDL2013 = double.TryParse(reader[8].ToString(), out val)?val:.0,
YDL2014 = double.TryParse(reader[9].ToString(), out val)?val:.0,
GSRKSS2012 = double.TryParse(reader[10].ToString(), out val)?val:.0,
GSRKSS2013 = double.TryParse(reader[11].ToString(), out val)?val:.0,
GSRKSS2014 = double.TryParse(reader[12].ToString(), out val)?val:.0,
DSRKSS2012 = double.TryParse(reader[13].ToString(), out val)?val:.0,
DSRKSS2013 = double.TryParse(reader[14].ToString(), out val)?val:.0,
DSRKSS2014 = double.TryParse(reader[15].ToString(), out val)?val:.0,
ZYYSR2012 = double.TryParse(reader[16].ToString(), out val)?val:.0,
ZYYSR2013 = double.TryParse(reader[17].ToString(), out val)?val:.0,
ZYYSR2014 = double.TryParse(reader[18].ToString(), out val)?val:.0
});
var qymc = reader[19].ToString().Trim();
if (!string.IsNullOrEmpty(qymc))
{
YDDWDict.Add(QYBH, qymc);
}
Console.WriteLine("成功");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
}
}
Command.CommandText = "Select DKBH,COUNT(*) from GYYD_YDDW Group By DKBH";
using (var reader = Command.ExecuteReader())
{
string DKBH = string.Empty;
int val = 0;
while (reader.Read())
{
DKBH = reader[0].ToString();
if (!string.IsNullOrEmpty(DKBH) && !NumberDict.ContainsKey(DKBH))
{
NumberDict.Add(DKBH, int.TryParse(reader[1].ToString(), out val) ? val : 0);
}
}
}
}
connection.Close();
}
}
