/// <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>
/// <param name="model">总机构信息</param>
/// <param name="tran">事务对象</param>
/// <returns>更新结果</returns>
public int Update(NSRZJG model, object tran)
{
return(dal.Update(model, tran));
}
