public void Working()
{
foreach (var region in Regions)
{
DataOne one = new DataOne();
foreach (var val in SFS)
{
ReadData(new string[]{
string.Format("Select SUM(GYYD.PZYDMJ),SUM(YDDW.TDZMJ),SUM(GYYD.YDZMJ),SUM(GYYD.JZZMJ),SUM(GYYD.JZZDMJ),SUM(GYYD.WPZJZMJ),SUM(GYYD.WPZJZZDMJ),SUM(GYYD.TDDJMJ),SUM(GYYD.DYMJ),SUM(GYYD.CZQYSL) from {0} where GYYD.XZJDMC={1} AND YDDW.SFGSQY={2}", ViewName, region, val),
string.Format("Select * from YDDW inner join GYYD_YDDW on "),
string.Format("Select COUNT(*) from YDDW where SFGXQY=是 AND XZJDMC={0} AND SFGSQY={1}", region, val),
string.Format("Select SUM(CYRS),SUM(LJGDZCTZ),SUM(YDL2012),SUM(YDL2013),SUM(YDL2014),SUM(GSRKSS2012),SUM(GSRKSS2013),SUM(GSRKSS2014),SUM(DSRKSS2012),SUM(DSRKSS2013),SUM(DSRKSS2014),SUM(ZYYSR2012),SUM(ZYYSR2013),SUM(ZYYSR2014) from YDDW where XZJDMC={0} AND SFGSQY={1}", region, val)
});
DataBase databse = Translate(queue);
switch (val)
{
case "是":
one.Up = databse;
break;
case "否":
one.Down = databse;
break;
}
}
RegionsDict.Add(region, one);
RegionSum = RegionSum + one;
}
foreach (var terrace in Terraces)
{
DataOne one = new DataOne();
var list = GetBase(string.Format("Select DKBH from GYYD where CYPTMC Like '%{0}%'", terrace));
SQLText = string.Format("Create View {0} As Select GYYD_YDDW.QYBH As QYBH from GYYD inner join GYYD_YDDW on GYYD.DKBH=GYYD_YDDW.DKBH where GYYD.CYPTMC Like '%{1}%' Group By GYYD_YDDW.QYBH", TempView2, terrace);
ExecuteQuery(SQLText);
foreach (var val in SFS)
{
ReadData(new string[]{
string.Format("Select SUM(GYYD.PZYDMJ),SUM(YDDW.TDZMJ),SUM(GYYD.YDZMJ),SUM(GYYD.JZZMJ),SUM(GYYD.JZZDMJ),SUM(GYYD.WPZJZMJ),SUM(GYYD.WPZJZZDMJ),SUM(GYYD.TDDJMJ),SUM(GYYD.DYMJ),SUM(GYYD.CZQYSL) from {0} where GYYD.CYPTMC LIKE '%{1}%' AND YDDW.SFGSQY={2}", ViewName, terrace, val),
string.Format("Select COUNT(*) from {0} inner join YDDW on YDDW.QYBH={0}.QYBH where YDDW.SFGXQY=是 AND SFGSQY={1}", TempView2, val),
string.Format("Select SUM(YDDW.CYRS),SUM(YDDW.LJGDZCTZ),SUM(YDDW.YDL2012),SUM(YDDW.YDL2013),SUM(YDDW.YDL2014),SUM(YDDW.GSRKSS2012),SUM(YDDW.GSRKSS2013),SUM(YDDW.GSRKSS2014),SUM(YDDW.DSRKSS2012),SUM(YDDW.DSRKSS2013),SUM(YDDW.DSRKSS2014),SUM(YDDW.ZYYSR2012),SUM(YDDW.ZYYSR2013),SUM(YDDW.ZYYSR2014) from YDDW inner join {0} on YDDW.QYBH={0}.QYBH where SFGSQY={1}", TempView2, val)
});
DataBase database = Translate(queue);
switch (val)
{
case "是":
one.Up = database;
break;
case "否":
one.Down = database;
break;
}
}
SQLText = string.Format("Drop View {0}", TempView2);
ExecuteQuery(SQLText);
TerraceDict.Add(terrace, one);
TerraceSum = TerraceSum + one;
}
}
public void Doing()
{
#region 获取 乡镇
foreach (var region in Regions)
{
DataOne one = new DataOne();
foreach (var val in SFS)
{
//SQLText = string.Format("Select SUM(PZYDMJ),SUM(YDZMJ),SUM(WJPZYDMJ),SUM(JZZMJ),SUM(JZZDMJ),SUM(WPZJZMJ),SUM(WPZJZZDMJ),SUM(TDDJMJ),SUM(DYMJ),SUM(CZQYSL),SUM(SFGXQY),SUM(CYRS),SUM(LJGDZCTZ),SUM(YDL2012),SUM(YDL2013),SUM(YDL2014),SUM(GSRKSS2012),SUM(GSRKSS2013),SUM(GSRKSS2014),SUM(DSRKSS2012),SUM(DSRKSS2013),SUM(DSRKSS2014),SUM(ZYYSR2012),SUM(ZYYSR2013),SUM(ZYYSR2014) from GYYD where XZJDMC='{0}' AND TDSYQK='1' AND SFGSQY='{1}'", region, val);
//ReadData(new string[] { SQLText });
ReadData(new string[]{
string.Format("Select SUM(PZYDMJ),SUM(YDZMJ),SUM(WJPZYDMJ),SUM(JZZMJ),SUM(JZZDMJ),SUM(WPZJZMJ),SUM(WPZJZZDMJ),SUM(TDDJMJ),SUM(DYMJ),SUM(CZQYSL) from GYYD_YDDW where XZQMC='{0}' AND TDSYQK='1' AND SFGSQY='{1}'", region, val),
string.Format("Select Count(*) from GYYD_YDDW where XZQMC='{0}' AND TDSYQK='1' AND SFGSQY='{1}' AND SFGXQY='是'", region, val),
string.Format("Select SUM(CYRS),SUM(LJGDZCTZ),SUM(YDL2012),SUM(YDL2013),SUM(YDL2014),SUM(GSRKSS2012),SUM(GSRKSS2013),SUM(GSRKSS2014),SUM(DSRKSS2012),SUM(DSRKSS2013),SUM(DSRKSS2014),SUM(ZYYSR2012),SUM(ZYYSR2013),SUM(ZYYSR2014) from GYYD_YDDW where XZQMC='{0}' AND TDSYQK='1' AND SFGSQY='{1}'",region,val)
});
var database = Translate(queue)/10000;
switch (val)
{
case "是":
one.Up = database;
break;
case "否":
one.Down = database;
break;
}
}
RegionsDict.Add(region, one);
RegionSum = RegionSum + one;
}
#endregion
#region 获取 工业园
foreach (var terrace in Terraces)
{
DataOne one = new DataOne();
foreach (var val in SFS)
{
string str = string.Empty;
if (terrace == "其他")
{
str = string.Format("from GYYD_YDDW where SFWYCYPT='否' AND TDSYQK='1' AND SFGSQY='{0}'", val);
//SQLText = string.Format("Select SUM(PZYDMJ),SUM(YDZMJ),SUM(WJPZYDMJ),SUM(JZZMJ),SUM(JZZDMJ),SUM(WPZJZMJ),SUM(WPZJZZDMJ),SUM(TDDJMJ),SUM(DYMJ),SUM(CZQYSL),SUM(SFGXQY),SUM(CYRS),SUM(LJGDZCTZ),SUM(YDL2012),SUM(YDL2013),SUM(YDL2014),SUM(GSRKSS2012),SUM(GSRKSS2013),SUM(GSRKSS2014),SUM(DSRKSS2012),SUM(DSRKSS2013),SUM(DSRKSS2014),SUM(ZYYSR2012),SUM(ZYYSR2013),SUM(ZYYSR2014) from GYYD where SFWYCYPT='否' AND TDSYQK='1' AND SFGSQY='{0}'", val);
}
else
{
str = string.Format("from GYYD_YDDW where CYPTMC Like '%{0}%' AND TDSYQK='1' AND SFGSQY='{1}'",terrace, val);
//SQLText = string.Format("Select SUM(PZYDMJ),SUM(YDZMJ),SUM(WJPZYDMJ),SUM(JZZMJ),SUM(JZZDMJ),SUM(WPZJZMJ),SUM(WPZJZZDMJ),SUM(TDDJMJ),SUM(DYMJ),SUM(CZQYSL),SUM(SFGXQY),SUM(CYRS),SUM(LJGDZCTZ),SUM(YDL2012),SUM(YDL2013),SUM(YDL2014),SUM(GSRKSS2012),SUM(GSRKSS2013),SUM(GSRKSS2014),SUM(DSRKSS2012),SUM(DSRKSS2013),SUM(DSRKSS2014),SUM(ZYYSR2012),SUM(ZYYSR2013),SUM(ZYYSR2014) from GYYD where CYPTMC Like '%{0}%' AND TDSYQK='1' AND SFGSQY='{1}'", terrace, val);
}
//ReadData(new string[] { SQLText });
ReadData(new string[]{
string.Format("Select SUM(PZYDMJ),SUM(YDZMJ),SUM(WJPZYDMJ),SUM(JZZMJ),SUM(JZZDMJ),SUM(WPZJZMJ),SUM(WPZJZZDMJ),SUM(TDDJMJ),SUM(DYMJ),SUM(CZQYSL) {0}",str),
string.Format("Select Count(*) {0} AND SFGXQY='是'",str),
string.Format("Select SUM(CYRS),SUM(LJGDZCTZ),SUM(YDL2012),SUM(YDL2013),SUM(YDL2014),SUM(GSRKSS2012),SUM(GSRKSS2013),SUM(GSRKSS2014),SUM(DSRKSS2012),SUM(DSRKSS2013),SUM(DSRKSS2014),SUM(ZYYSR2012),SUM(ZYYSR2013),SUM(ZYYSR2014) {0}",str)
});
DataBase database = Translate(queue)/10000;
switch (val)
{
case "是":
one.Up = database;
break;
case "否":
one.Down = database;
break;
}
}
TerraceDict.Add(terrace, one);
TerraceSum = TerraceSum + one;
}
#endregion
}
