/// <summary>
/// 从数据库中得到土地总面积、用房总面积、地上面积、地下面积并存入provinceFDXXsentence1对象中。
/// </summary>
/// <returns></returns>
public static provinceFDXXsentence1 GetInfo()
{
provinceFDXXsentence1 fs = new provinceFDXXsentence1();
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetprovinceFDXXsentence1SQL();
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader())//执行command并得到相应的DataReader
{
myReader.Read();
fs.ZDMJ = Decimal.Parse((((decimal)myReader["ZDMJ"]) * (decimal)0.0015).ToString("0")); //把单位统一为亩
fs.FCMJ = (decimal)myReader["FCMJ"];
fs.DSMJ = (decimal)myReader["DSMJ"];
fs.DXMJ = (decimal)myReader["DXMJ"];
}
}
catch (System.Exception ex)
{
LogHelper.WriteLog(typeof(provinceFDXXsentence1), ex);
}
finally
{
mycon.Close();
}
return(fs);
}
public static provinceFDXXsentence2 GetInfo()
{
provinceFDXXsentence1 fs1 = new provinceFDXXsentence1();
provinceFDXXsentence2 fs = new provinceFDXXsentence2();
string temp;
decimal ZMJ;
IDbConnection mycon = DBhelper.OpenConnection();
try
{
fs1 = provinceFDXXsentence1.GetInfo();
ZMJ = fs1.FCMJ;
string sql = CompilationDocumentSQL.GetprovinceFDXXsentence2SQL();
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader()) //执行command并得到相应的DataReader
{
while (myReader.Read()) //把得到的值赋给fm对象
{
temp = (string)myReader["MC"];
if (temp == "危房")
{
fs.WFZMJ = (decimal)myReader["ZMJ"];
fs.WFZMJB = (Math.Round(fs.WFZMJ / ZMJ * 100, 2)).ToString() + "%";
}
else if (temp == "拆除")
{
fs.CCZMJ = (decimal)myReader["ZMJ"];
fs.CCZMJB = (Math.Round(fs.CCZMJ / ZMJ * 100, 2)).ToString() + "%";
}
else if (temp == "未办权证")
{
fs.NQZZMJ = (decimal)myReader["ZMJ"];
fs.NQZZMJB = (Math.Round(fs.NQZZMJ / ZMJ * 100, 2)).ToString() + "%";
}
else if (temp == "2013年以前")
{
fs.BF2013ZMJ = (decimal)myReader["ZMJ"];
fs.BF2013ZMJB = (Math.Round(fs.BF2013ZMJ / ZMJ * 100, 2)).ToString() + "%";
}
}
}
}
catch (System.Exception ex)
{
LogHelper.WriteLog(typeof(provinceFDXXsentence2), ex);
}
finally
{
mycon.Close();
}
return(fs);
}