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