/// <summary>
/// 获取纳税人各种资产汇总值
/// </summary>
/// <param name="nsrsbh">总机构纳税人识别号</param>
/// <param name="nd">年度</param>
/// <param name="pcNsrfzjgbh">要排除的分支机构纳税人识别号</param>
/// <returns>装载总机构及分支机构资产数据的对象</returns>
public NSRZJG GetSumInfoByNsrsbhNd(string nsrsbh, string nd, string pcNsrfzjgbh)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
@"select NSRZJG.GZZE,mm.fzjggzze,
NSRZJG.ZCZE,mm.fzjgzcze,NSRZJG.SRZE,mm.fzjgSrze
from NSRZJG
LEFT JOIN (select sum(NSRFZJG.sxysGzze) as fzjggzze,sum(NSRFZJG.sxysZcze)
as fzjgzcze,sum(NSRFZJG.sxysSrze)as fzjgSrze,nsrsbh,ND from NSRFZJG where fzjgnsrsbh !=@fzjgnsrsbh GROUP BY nsrsbh,ND) mm
on mm.nsrsbh=NSRZJG.nsrsbh and mm.ND=NSRZJG.ND
where NSRZJG.nsrsbh=@nsrsbh and NSRZJG.nd=@nd ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@nsrsbh", DbType.String, 50),
new SQLiteParameter("@fzjgnsrsbh", DbType.String, 50),
new SQLiteParameter("@nd", DbType.String, 4)
};
parameters[0].Value = nsrsbh;
parameters[1].Value = pcNsrfzjgbh;
parameters[2].Value = nd;
NSRZJG zjg = new NSRZJG();
DataSet ds = SQLiteHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow row = ds.Tables[0].Rows[i];
zjg.GZZE = Convert.ToDecimal(row["GZZE"].ToString());
zjg.ZCZE = Convert.ToDecimal(row["ZCZE"].ToString());
zjg.SRZE = Convert.ToDecimal(row["SRZE"].ToString());
NSRFZJG fzjg = new NSRFZJG();
if (row["fzjggzze"] != DBNull.Value)
{
fzjg.sxysGzze = Convert.ToDecimal(row["fzjggzze"].ToString());
}
if (row["fzjgzcze"] != DBNull.Value)
{
fzjg.sxysZcze = Convert.ToDecimal(row["fzjgzcze"].ToString());
}
if (row["fzjgSrze"] != DBNull.Value)
{
fzjg.sxysSrze = Convert.ToDecimal(row["fzjgSrze"].ToString());
}
zjg.NSRFZJG = fzjg;
}
}
return(zjg);
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(NSRFZJG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(zjgNsrsbh) from NSRFZJG");
strSql.Append(" where zjgNsrsbh=@zjgNsrsbh and fzjgNsrsbh=@fzjgNsrsbh and nd=@nd");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@zjgNsrsbh", DbType.String, 50),
new SQLiteParameter("@fzjgNsrsbh", DbType.String, 50),
new SQLiteParameter("@nd", DbType.String, 4)
};
parameters[0].Value = model.zjgNsrsbh;
parameters[1].Value = model.fzjgNsrsbh;
parameters[2].Value = model.ND;
return(SQLiteHelper.Exists(strSql.ToString(), parameters));
}
public IList <NSRFZJG> GetModelListBySqlStr(string sql)
{
IDataReader dr = null;
List <NSRFZJG> fzjgList = new List <NSRFZJG>();
using (dr = SQLiteHelper.ExecuteReader(sql))
{
while (dr.Read())
{
NSRFZJG model = new NSRFZJG();
if (dr["nsrsbh"] != DBNull.Value)
{
model.nsrsbh = dr["nsrsbh"].ToString();
}
if (dr["zjgNsrsbh"] != DBNull.Value)
{
model.zjgNsrsbh = dr["zjgNsrsbh"].ToString();
}
if (dr["fzjgNsrsbh"] != DBNull.Value)
{
model.fzjgNsrsbh = dr["fzjgNsrsbh"].ToString();
}
if (dr["fzjgMc"] != DBNull.Value)
{
model.fzjgMc = dr["fzjgMc"].ToString();
}
if (dr["sxysSrze"] != DBNull.Value)
{
model.sxysSrze = decimal.Parse(dr["sxysSrze"].ToString());
}
if (dr["sxysGzze"] != DBNull.Value)
{
model.sxysGzze = decimal.Parse(dr["sxysGzze"].ToString());
}
if (dr["sxysZcze"] != DBNull.Value)
{
model.sxysZcze = decimal.Parse(dr["sxysZcze"].ToString());
}
if (dr["sxysHj"] != DBNull.Value)
{
model.sxysHj = decimal.Parse(dr["sxysHj"].ToString());
}
if (dr["fpbl"] != DBNull.Value)
{
model.fpbl = dr["fpbl"].ToString();
}
if (dr["fpse"] != DBNull.Value)
{
model.fpse = decimal.Parse(dr["fpse"].ToString());
}
if (dr["kjzg"] != DBNull.Value)
{
model.kjzg = dr["kjzg"].ToString();
}
if (dr["LXDH"] != DBNull.Value)
{
model.LXDH = dr["LXDH"].ToString();
}
if (dr["YYDZ"] != DBNull.Value)
{
model.YYDZ = dr["YYDZ"].ToString();
}
if (dr["ND"] != DBNull.Value)
{
model.ND = dr["ND"].ToString();
}
if (dr["rqQ"] != DBNull.Value)
{
model.rqQ = dr["rqQ"].ToString();
}
if (dr["rqZ"] != DBNull.Value)
{
model.rqZ = dr["rqZ"].ToString();
}
fzjgList.Add(model);
}
}
return(fzjgList);
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(NSRFZJG model)
{
return(dal.Exists(model));
}
