/// <summary> /// 获取发票已登记列表合计信息 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="crmId">客户单位编号</param> /// <param name="searchInfo">查询实体</param> /// <param name="kaiPiaoJinE">开票金额合计</param> public void GetFaPiaosHeJi(int companyId, int crmId, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo, out decimal kaiPiaoJinE) { kaiPiaoJinE = 0; if (companyId < 1 || crmId < 1) { return; } dal.GetFaPiaosHeJi(companyId, crmId, searchInfo, out kaiPiaoJinE); }
/// <summary> /// 初始化发票登记列表 /// </summary> void InitLB() { int pageSize = 12; int pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); int recordCount = 0; int keHuDanWeiId = Utils.GetInt(Utils.GetQueryStringValue("kehudanweiid")); var searchInfo = new EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo(); searchInfo.KPETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("kpetime")); searchInfo.KPRen = Utils.GetQueryStringValue("kaipiaoren"); searchInfo.KPSTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("kpstime")); var bll = new EyouSoft.BLL.FinanceStructure.BFaPiao(); var items = bll.GetFaPiaos(CurrentUserCompanyID, keHuDanWeiId, pageSize, pageIndex, ref recordCount, searchInfo); if (items != null && items.Count > 0) { phLB.Visible = true; phEmpty.Visible = false; rptLB.DataSource = items; rptLB.DataBind(); paging.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?"; paging.UrlParams = Request.QueryString; paging.intPageSize = pageSize; paging.CurrencyPage = pageIndex; paging.intRecordCount = recordCount; decimal kaiPiaoJinE; bll.GetFaPiaosHeJi(CurrentUserCompanyID, keHuDanWeiId, searchInfo, out kaiPiaoJinE); ltrKaiPiaoJinEHeJi.Text = kaiPiaoJinE.ToString("C2"); } else { phLB.Visible = false; phEmpty.Visible = true; } bll = null; }
/// <summary> /// 获取发票已登记列表合计信息 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="crmId">客户单位编号</param> /// <param name="searchInfo">查询实体</param> /// <param name="kaiPiaoJinE">开票金额合计</param> public void GetFaPiaosHeJi(int companyId, int crmId, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo, out decimal kaiPiaoJinE) { kaiPiaoJinE = 0; StringBuilder cmdText = new StringBuilder(); #region SQL cmdText.Append(" SELECT SUM(JinE) AS KaiPiaoJinE FROM tbl_FinFaPiao WHERE IsDelete='0' "); cmdText.AppendFormat(" AND CompanyId={0} ", companyId); cmdText.AppendFormat(" AND CrmId={0} ", crmId); if (searchInfo != null) { if (searchInfo.KPETime.HasValue) { cmdText.AppendFormat(" AND RiQi<'{0}' ", searchInfo.KPETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(searchInfo.KPRen)) { cmdText.AppendFormat(" AND KaiPiaoRen LIKE '%{0}%' ", searchInfo.KPRen); } if (searchInfo.KPSTime.HasValue) { cmdText.AppendFormat(" AND RiQi>'{0}' ", searchInfo.KPSTime.Value.AddDays(-1)); } } #endregion DbCommand cmd = _db.GetSqlStringCommand(cmdText.ToString()); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { if (!rdr.IsDBNull(0)) { kaiPiaoJinE = rdr.GetDecimal(0); } } } }
/// <summary> /// 获取发票已登记列表 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="crmId">客户单位编号</param> /// <param name="pageSize">每页记录数</param> /// <param name="pageIndex">当前页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="searchInfo">查询信息</param> /// <returns></returns> public IList <EyouSoft.Model.FinanceStructure.MFaPiaoInfo> GetFaPiaos(int companyId, int crmId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo) { IList <EyouSoft.Model.FinanceStructure.MFaPiaoInfo> items = new List <EyouSoft.Model.FinanceStructure.MFaPiaoInfo>(); StringBuilder cmdQuery = new StringBuilder(); string tableName = "tbl_FinFaPiao"; string primaryKey = "Id"; string orderByString = "RiQi DESC"; string fields = "*"; #region SQL cmdQuery.AppendFormat(" IsDelete='0' AND CompanyId={0} AND CrmId={1} ", companyId, crmId); if (searchInfo != null) { if (searchInfo.KPETime.HasValue) { cmdQuery.AppendFormat(" AND RiQi<'{0}' ", searchInfo.KPETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(searchInfo.KPRen)) { cmdQuery.AppendFormat(" AND KaiPiaoRen LIKE '%{0}%' ", searchInfo.KPRen); } if (searchInfo.KPSTime.HasValue) { cmdQuery.AppendFormat(" AND RiQi>'{0}' ", searchInfo.KPSTime.Value.AddDays(-1)); } } #endregion using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString)) { while (rdr.Read()) { var item = new EyouSoft.Model.FinanceStructure.MFaPiaoInfo(); item.BeiZhu = rdr["BeiZhu"].ToString(); item.CaoZuoRenId = rdr.GetInt32(rdr.GetOrdinal("CaoZuoRenId")); item.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId")); item.CrmId = rdr.GetInt32(rdr.GetOrdinal("CrmId")); item.Id = rdr.GetString(rdr.GetOrdinal("Id")); item.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE")); item.KaiPiaoRen = rdr["KaiPiaoRen"].ToString(); item.KaiPiaoRenId = rdr.GetInt32(rdr.GetOrdinal("KaiPiaoRenId")); item.PiaoHao = rdr["PiaoHao"].ToString(); item.RiQi = rdr.GetDateTime(rdr.GetOrdinal("RiQi")); items.Add(item); } } return(items); }
/// <summary> /// 获取发票已登记列表 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="crmId">客户单位编号</param> /// <param name="pageSize">每页记录数</param> /// <param name="pageIndex">当前页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="searchInfo">查询信息</param> /// <returns></returns> public IList <EyouSoft.Model.FinanceStructure.MFaPiaoInfo> GetFaPiaos(int companyId, int crmId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MFaPiaoSearchInfo searchInfo) { if (companyId < 1 || crmId < 1) { return(null); } return(dal.GetFaPiaos(companyId, crmId, pageSize, pageIndex, ref recordCount, searchInfo)); }