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