/// <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);
}
/// <summary>
/// 从数据库中获取各类用房名称和面积存入FDXXsentence2对象中。
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static List <countryFDXXsentence2> GetInfo(int id)
{
List <countryFDXXsentence2> lstFS = new List <countryFDXXsentence2>();
countryFDXXsentence2 fs;
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetcountryFDXXsentence2SQL(id);
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader()) //执行command并得到相应的DataReader
{
while (myReader.Read()) //把得到的值赋给fm对象
{
fs = new countryFDXXsentence2();
fs.GNGL = (string)myReader["FCZK_GNGL"];
fs.GNGL_MJ = (decimal)myReader["SUM(FCMJ)"];
lstFS.Add(fs);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(countryFDXXsentence2), ex);
}
finally
{
mycon.Close();
}
return(lstFS);
}
/// <summary>
/// 从数据库中得到各类住房栋数、占地总面积、总建筑面积并存入countryFDXXsentence1对象中。
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static countryFDXXsentence1 GetInfo(int id)
{
countryFDXXsentence1 fs = new countryFDXXsentence1();
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetcountryFDXXsentence1SQL(id);
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader())//执行command并得到相应的DataReader
{
myReader.Read();
fs.count = (decimal)myReader["FCS"];
fs.ZDZMJ = (decimal)myReader["ZDXX_ZDMJ"];
fs.ZJZMJ = (decimal)myReader["B_FCMJ"];
}
}
catch (System.Exception ex)
{
LogHelper.WriteLog(typeof(countryFDXXsentence1), ex);
}
finally
{
mycon.Close();
}
return(fs);
}
/// <summary>
/// 从数据库中获取一行行表格数据，并存入FDXXmodel中。（省公司公司）
/// </summary>
/// <returns></returns>
public static List <FDXXtbl_province_summary> GetInfo()
{
List <FDXXtbl_province_summary> lstFDXX = new List <FDXXtbl_province_summary>();
FDXXtbl_province_summary fm;
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetFDXXprovincesummarySQL();
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader()) //执行command并得到相应的DataReader
{
while (myReader.Read()) //把得到的值赋给fm对象
{
fm = new FDXXtbl_province_summary();
fm.DWMC = (string)myReader["DWMC"];
fm.ZDMJ = Decimal.Parse((((decimal)myReader["ZDMJ"]) * (decimal)0.0015).ToString("0")); //把单位统一为亩
fm.FCMJ = (decimal)myReader["FCMJ"];
fm.DSMJ = (decimal)myReader["DSMJ"];
fm.DXMJ = (decimal)myReader["DXMJ"];
lstFDXX.Add(fm);
}
}
}
catch (System.Exception ex)
{
LogHelper.WriteLog(typeof(FDXXtbl_province_summary), ex);
}
finally
{
mycon.Close();
}
return(lstFDXX);
}
/// <summary>
/// 从数据库中获取一行行表格数据，并存入FDXXmodel中。（市级公司）
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static List <FDXXtbl_city> GetInfo(int id)
{
List <FDXXtbl_city> lstFDXX = new List <FDXXtbl_city>();
FDXXtbl_city fm;
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetFDXXcitySQL(id);
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader()) //执行command并得到相应的DataReader
{
while (myReader.Read()) //把得到的值赋给fm对象
{
fm = new FDXXtbl_city();
fm.DWMC = (string)myReader["DWMC"];
fm.ZDS = (decimal)myReader["ZDS"];
fm.ZDMJ = (decimal)myReader["ZDMJ"];
fm.FCS = (decimal)myReader["FCS"];
fm.FCMJ = (decimal)myReader["FCMJ"];
lstFDXX.Add(fm);
}
}
}
catch (System.Exception ex)
{
LogHelper.WriteLog(typeof(FDXXtbl_city), ex);
}
finally
{
mycon.Close();
}
return(lstFDXX);
}
/// <summary>
/// 读取合计信息。（县级公司）
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static FDXXtbl_country GetTotalInfo(int id)
{
FDXXtbl_country fm = new FDXXtbl_country();
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetFDXXcountrytotalSQL(id);
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader()) //执行command并得到相应的DataReader
{
myReader.Read(); //把得到的值赋给fm对象
fm.ZDXX_ZDMJ = Math.Round((decimal)myReader["ZDMJ"], 0);
fm.ZMJ = Math.Round((decimal)myReader["FCMJ"], 0);
fm.FCXX_DSMJ = Math.Round((decimal)myReader["DSMJ"], 0);
fm.FCXX_DXMJ = Math.Round((decimal)myReader["DXMJ"], 0);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(FDXXtbl_country), ex);
}
finally
{
mycon.Close();
}
return(fm);
}
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);
}
/// <summary>
/// 从数据库中获取一行行表格数据，并存入FDXXmodel中。（县级公司）
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static List <FDXXtbl_country> GetInfo(int id)
{
List <FDXXtbl_country> lstFDXX = new List <FDXXtbl_country>();
FDXXtbl_country fm;
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetFDXXcountrySQL(id);
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader()) //执行command并得到相应的DataReader
{
while (myReader.Read()) //把得到的值赋给fm对象
{
fm = new FDXXtbl_country();
fm.ZDXX_ID = int.Parse(((decimal)myReader["ZDXX_ID"]).ToString()); //(int)myReader["ZDXX_ID"];
fm.ZDXX_MC = (string)myReader["ZDXX_MC"];
fm.ZDXX_ZDMJ = Decimal.Parse((((decimal)myReader["ZDXX_ZDMJ"]) * 2000 / 3).ToString("0")); //把单位统一为平方米
fm.FCXX_ID = int.Parse(((decimal)myReader["FCXX_ID"]).ToString()); //(int)myReader["FCXX_ID"];
fm.FCXX_JZMC = (string)myReader["FCXX_JZMC"];
fm.FCXX_DSCS = (decimal)myReader["FCXX_DSCS"];
fm.FCXX_DXCS = (decimal)myReader["FCXX_DXCS"];
fm.FCXX_JZJG = (string)myReader["FCXX_JZJG"];
fm.FCXX_JSND = (decimal)myReader["FCZK_JSND"];
fm.ZMJ = Math.Round((decimal)myReader["ZMJ"], 2);
fm.FCXX_DSMJ = Math.Round((decimal)myReader["FCXX_DSMJ"], 2);
fm.FCXX_DXMJ = Math.Round((decimal)myReader["FCXX_DXMJ"], 2);
fm.FCZK_SYGN = (string)myReader["FCZK_SYGN"];
fm.FCZK_SYBM = (string)myReader["FCZK_SYBM"];
if (!DBNull.Value.Equals(myReader["FCXX_BZ"]))
{
fm.FCXX_BZ = (string)myReader["FCXX_BZ"]; //判断FCXX_BZ是否为空值（DBNull）
}
else
{
fm.FCXX_BZ = "";
}
lstFDXX.Add(fm);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(FDXXtbl_country), ex);
}
finally
{
mycon.Close();
}
return(lstFDXX);
}
/// <summary>
/// 从数据库中获取建成投运10年内的房屋面积、建成投运10-20年内的房屋面积和建成投运30年以上的房屋面积并存入FDXXsentence3对象中。
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static countryFDXXsentence3 GetInfo(int id)
{
countryFDXXsentence3 fs = new countryFDXXsentence3();
string temp = "";
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetcountryFDXXsentence3SQL(id);
IDbCommand mycom = DBFactory.getSingleton().getCommand(sql, mycon);
using (IDataReader myReader = mycom.ExecuteReader()) //执行command并得到相应的DataReader
{
while (myReader.Read()) //把得到的值赋给fm对象
{
temp = (string)myReader["TJXM"];
if (temp == "10年以内（含10年）")
{
fs.FWMJ_10 = (decimal)myReader["FCMJ"];
}
else if (temp == "10-20年（含20年）")
{
fs.FWMJ_1020 = (decimal)myReader["FCMJ"];
}
else if (temp == "20-30年（含30年）")
{
fs.FWMJ_2030 = (decimal)myReader["FCMJ"];
}
else
{
fs.FWMJ_30 = (decimal)myReader["FCMJ"];
}
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(countryFDXXsentence3), ex);
}
finally
{
mycon.Close();
}
return(fs);
}
public static List <FDXXtbl_province_analysis> GetInfo()
{
List <FDXXtbl_province_analysis> lstFDXX = new List <FDXXtbl_province_analysis>();
IDbConnection mycon = DBhelper.OpenConnection();
try
{
string sql = CompilationDocumentSQL.GetFDXXprovinceanalysisSQL();
DataTable t = DBhelper.GetDatatable(sql, mycon);
//DataTable t = DataHelper.Get_datatable(mycon, sql);
/*------------------------------排序------------------------------*/
//将datatable存入自定义数组
for (int i = 0; i < t.Rows.Count; i++)
{
FDXXtbl_province_analysis fa = new FDXXtbl_province_analysis();
fa.DW = Convert.ToString(t.Rows[i][0]);
fa.TJXM = Convert.ToString(t.Rows[i][1]);
fa.FCMJ = Convert.ToDouble(t.Rows[i][2]);
switch (fa.TJXM)
{
case "合计": fa.order = 1; break;
case "本部": fa.order = 2; break;
case "供电公司": fa.order = 3; break;
case "培训单位": fa.order = 4; break;
case "直属单位": fa.order = 5; break;
case "调度生产管理用房": fa.order = 6; break;
case "营销服务用房": fa.order = 7; break;
case "运维检修用房": fa.order = 8; break;
case "物资仓储用房": fa.order = 9; break;
case "教育培训用房": fa.order = 10; break;
case "科研实验用房": fa.order = 11; break;
case "其它用房": fa.order = 12; break;
case "10年以内（含10年）": fa.order = 13; break;
case "10-20年（含20年）": fa.order = 14; break;
case "20-30年（含30年）": fa.order = 15; break;
case "30年以上": fa.order = 16; break;
case "危房": fa.order = 17; break;
case "正常": fa.order = 18; break;
case "规划拆除": fa.order = 19; break;
case "尚未规划拆除": fa.order = 20; break;
case "已办理土地证": fa.order = 21; break;
case "未办理土地证": fa.order = 22; break;
case "已办理房产证": fa.order = 23; break;
case "未办理房产证": fa.order = 24; break;
default:
break;
}
lstFDXX.Add(fa);
}
//对List中的表数据进行排序
lstFDXX = lstFDXX.OrderBy(s => s.order).ToList <FDXXtbl_province_analysis>();
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(FDXXtbl_province_analysis), ex);
}
finally
{
mycon.Close();
}
return(lstFDXX);
}
