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