/// <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); }