public void Working()
{
foreach (var region in Regions)
{
AParcel aprcel = new AParcel();
SQLText = string.Format("Select COUNT(*),SUM(WKFTDMJ) from GYYD where XZJDMC='{0}' AND TDSYQK<>'1'", region); //未开发总规模
aprcel.HE = ExecuteReader(SQLText);
SQLText = string.Format("Select COUNT(*),SUM(WKFTDMJ) from GYYD where XZJDMC='{0}' AND TDSYQK='2'", region); //整宗未开发
aprcel.WKF = ExecuteReader(SQLText);
SQLText = string.Format("Select COUNT(*),SUM(WKFTDMJ) from GYYD where XZJDMC='{0}' AND TDSYQK='3'", region);
aprcel.BFWKF = ExecuteReader(SQLText);
aprcel = aprcel / 10000;
ParcelDict.Add(region, aprcel);
RegionSum = RegionSum + aprcel;
}
foreach (var terrace in Terraces)
{
AParcel aprcel = new AParcel();
SQLText = string.Format("Select COUNT(*),SUM(WKFTDMJ) from GYYD where CYPTMC Like '%{0}%' AND TDSYQK<>'1'", terrace); //未开发总规模
aprcel.HE = ExecuteReader(SQLText);
SQLText = string.Format("Select COUNT(*),SUM(WKFTDMJ) from GYYD where CYPTMC Like '%{0}%' AND TDSYQK='2'", terrace); //整宗未开发
aprcel.WKF = ExecuteReader(SQLText);
SQLText = string.Format("Select COUNT(*),SUM(WKFTDMJ) from GYYD where CYPTMC Like '%{0}%' AND TDSYQK='3'", terrace);
aprcel.BFWKF = ExecuteReader(SQLText);
aprcel = aprcel / 10000;
TerraceDict.Add(terrace, aprcel);
TerraceSum = TerraceSum + aprcel;
}
}
public ToolThree(string mdbFilePath)
{
ParcelDict = new Dictionary <string, AParcel>();
TerraceDict = new Dictionary <string, AParcel>();
RegionSum = new AParcel()
{
WKF = new Parcel(),
BFWKF = new Parcel(),
HE = new Parcel()
};
TerraceSum = new AParcel()
{
WKF = new Parcel(),
BFWKF = new Parcel(),
HE = new Parcel()
};
SheetName = "表3";
StartRow = 5;
StartCell = 2;
StartRow2 = 31;
Init(mdbFilePath);
}
public void WriteHelper(AParcel Aparcel, ISheet Sheet, int Row, int Line)
{
WriteBase(Aparcel.HE, Sheet, Row, Line);
WriteBase(Aparcel.WKF, Sheet, Row, Line + 2);
WriteBase(Aparcel.BFWKF, Sheet, Row, Line + 4);
}