//static constants #endregion #region private members /// <summary> /// 获取财务管理-团款支出-按计调项显示支出列表查询条件SQL /// </summary> /// <param name="searchInfo"></param> /// <returns></returns> string SQLWhere_GetJiDiaoZhiChuLB(EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo) { if (searchInfo == null) { return(string.Empty); } StringBuilder s = new StringBuilder(); if (searchInfo.CTETime.HasValue) { s.AppendFormat(" AND LeaveDate<'{0}' ", searchInfo.CTETime.Value.AddDays(1)); } if (searchInfo.CTSTime.HasValue) { s.AppendFormat(" AND LeaveDate>'{0}' ", searchInfo.CTSTime.Value.AddDays(-1)); } if (!string.IsNullOrEmpty(searchInfo.GYSName)) { s.AppendFormat(" AND GYSName LIKE '%{0}%' ", searchInfo.GYSName); } if (!string.IsNullOrEmpty(searchInfo.TourCode)) { s.AppendFormat(" AND TourCode LIKE '%{0}%' ", searchInfo.TourCode); } if (searchInfo.TourType.HasValue) { s.AppendFormat(" AND TourType={0} ", (int)searchInfo.TourType.Value); } if (searchInfo.ZhiChuLeiBie.HasValue) { s.AppendFormat(" AND ZhiChuLeiBie={0} ", (int)searchInfo.ZhiChuLeiBie.Value); } return(s.ToString()); }
/// <summary> /// 获取财务管理-团款支出-按计调项显示支出列表合计 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="searchInfo">查询信息</param> /// <param name="zhiChuJinE">支出金额</param> /// <param name="yiDengJiJinE">已登记金额</param> /// <param name="yiZhiFuJinE">已支付金额</param> public void GetJiDiaoZhiChuLBHeJi(int companyId, EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo, out decimal zhiChuJinE, out decimal yiDengJiJinE, out decimal yiZhiFuJinE) { zhiChuJinE = 0; yiDengJiJinE = 0; yiZhiFuJinE = 0; if (companyId < 1) { return; } dal.GetJiDiaoZhiChuLBHeJi(companyId, searchInfo, out zhiChuJinE, out yiDengJiJinE, out yiZhiFuJinE); }
/// <summary> /// 获取财务管理-团款支出-按计调项显示支出列表合计 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="searchInfo">查询信息</param> /// <param name="zhiChuJinE">支出金额</param> /// <param name="yiDengJiJinE">已登记金额</param> /// <param name="yiZhiFuJinE">已支付金额</param> public void GetJiDiaoZhiChuLBHeJi(int companyId, EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo, out decimal zhiChuJinE, out decimal yiDengJiJinE, out decimal yiZhiFuJinE) { zhiChuJinE = 0; yiDengJiJinE = 0; yiZhiFuJinE = 0; StringBuilder cmdText = new StringBuilder(); #region SQL cmdText.Append(" SELECT SUM(ZhiChuJinE) AS ZhiChuJinE, "); cmdText.Append(" SUM(YiDengJiJinE) AS YiDengJiJinE, "); cmdText.Append(" SUM(YiZhiFuJinE) AS YiZhiFuJinE "); cmdText.Append(" FROM view_FinJiDiaoZhiChu "); cmdText.AppendFormat(" WHERE CompanyId={0} ", companyId); cmdText.Append(SQLWhere_GetJiDiaoZhiChuLB(searchInfo)); #endregion DbCommand cmd = _db.GetSqlStringCommand(cmdText.ToString()); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { if (!rdr.IsDBNull(0)) { zhiChuJinE = rdr.GetDecimal(0); } if (!rdr.IsDBNull(1)) { yiDengJiJinE = rdr.GetDecimal(1); } if (!rdr.IsDBNull(2)) { yiZhiFuJinE = rdr.GetDecimal(2); } } } }
/// <summary> /// 获取财务管理-团款支出-按计调项显示支出列表 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="pageSize">每页记录数</param> /// <param name="pageIndex">当前页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="searchInfo">查询信息</param> /// <returns></returns> public IList <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo> GetJiDiaoZhiChuLB(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo) { IList <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo> items = new List <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo>(); StringBuilder cmdQuery = new StringBuilder(); string tableName = "view_FinJiDiaoZhiChu"; string primaryKey = "AnPaiId"; string orderByString = "AnPaiTime DESC"; string fields = "*"; #region SQL cmdQuery.AppendFormat(" CompanyId={0} ", companyId); cmdQuery.Append(SQLWhere_GetJiDiaoZhiChuLB(searchInfo)); #endregion using (IDataReader rdr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString)) { while (rdr.Read()) { var item = new EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo(); item.AnPaiId = rdr.GetString(rdr.GetOrdinal("AnPaiId")); item.CTTime = rdr.GetDateTime(rdr.GetOrdinal("LeaveDate")); item.GYSName = rdr["GYSName"].ToString(); item.RouteName = rdr["RouteName"].ToString(); item.TourCode = rdr["TourCode"].ToString(); item.TourType = (EyouSoft.Model.EnumType.TourStructure.TourType)rdr.GetByte(rdr.GetOrdinal("TourType")); item.YiDengJiJinE = rdr.GetDecimal(rdr.GetOrdinal("YiDengJiJinE")); item.YiZhiFuJinE = rdr.GetDecimal(rdr.GetOrdinal("YiZhiFuJinE")); item.ZhiChuJinE = rdr.GetDecimal(rdr.GetOrdinal("ZhiChuJinE")); item.ZhiChuLeiBie = (EyouSoft.Model.EnumType.CompanyStructure.SupplierType)rdr.GetInt32(rdr.GetOrdinal("ZhiChuLeiBie")); item.TourId = rdr.GetString(rdr.GetOrdinal("TourId")); item.GYSId = rdr.GetInt32(rdr.GetOrdinal("GYSId")); items.Add(item); } } return(items); }
/// <summary> /// 获取财务管理-团款支出-按计调项显示支出列表 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="pageSize">每页记录数</param> /// <param name="pageIndex">当前页索引</param> /// <param name="recordCount">总记录数</param> /// <param name="searchInfo">查询信息</param> /// <returns></returns> public IList <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo> GetJiDiaoZhiChuLB(int companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo searchInfo) { if (companyId < 1) { return(null); } return(dal.GetJiDiaoZhiChuLB(companyId, pageSize, pageIndex, ref recordCount, searchInfo)); }
/// <summary> /// 绑定列表 /// </summary> void BindInfo() { int count = 0; EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo SearchInfo = new EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuSearchInfo(); #region 查询参数 string ddltype = Utils.GetQueryStringValue("tourtype"); string teamNum = Utils.GetQueryStringValue("tourCode"); txt_teamNum.Value = teamNum; string com = Utils.GetQueryStringValue("companyName"); txt_com.Value = com; string comtype = Utils.GetQueryStringValue("comType"); string goDate = Utils.GetQueryStringValue("beginDate"); txt_godate.Value = goDate; if (ddltype != "-1" && ddltype != "") { select.Value = ddltype; SearchInfo.TourType = (EyouSoft.Model.EnumType.TourStructure.TourType)Utils.GetInt(ddltype); } if (teamNum != "") { SearchInfo.TourCode = teamNum; } if (com != "") { SearchInfo.GYSName = com; } if (comtype != "-1" && comtype != "") { ddl_comType.SelectedValue = comtype; SearchInfo.ZhiChuLeiBie = (EyouSoft.Model.EnumType.CompanyStructure.SupplierType)Utils.GetInt(comtype); } SearchInfo.CTSTime = Utils.GetDateTimeNullable(goDate); SearchInfo.CTETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("rdate")); #endregion EyouSoft.BLL.FinanceStructure.BZhiChu newbll = new EyouSoft.BLL.FinanceStructure.BZhiChu(); IList <EyouSoft.Model.FinanceStructure.MLBJiDiaoZhiChuInfo> List = newbll.GetJiDiaoZhiChuLB(CurrentUserCompanyID, 20, Utils.GetInt(Utils.GetQueryStringValue("page")), ref count, SearchInfo); if (List != null && List.Count > 0) { rpt_list1.DataSource = List; rpt_list1.DataBind(); } //合计 decimal ZhichuMoney, yidengjiMoney, yizhifuMoney = 0; newbll.GetJiDiaoZhiChuLBHeJi(CurrentUserCompanyID, SearchInfo, out ZhichuMoney, out yidengjiMoney, out yizhifuMoney); this.lbyidengjimoney.Text = yidengjiMoney.ToString("c2"); this.lbyizhifumoney.Text = yizhifuMoney.ToString("c2"); this.lbzhichumoney.Text = ZhichuMoney.ToString("c2"); //未登记=支出金额-已登记 //未支付=支出金额-已支付 this.lbweizhifumoney.Text = (ZhichuMoney - yizhifuMoney).ToString("c2"); this.lbweidengjimoney.Text = (ZhichuMoney - yidengjiMoney).ToString("c2"); this.rpt_list1.EmptyText = "<tr><td height='30px' bgcolor='#e3f1fc' colspan='11' align='center'>暂时没有数据!</td></tr>"; #region 分页 ExportPageInfo1.intPageSize = 20; ExportPageInfo1.intRecordCount = count; ExportPageInfo1.PageLinkURL = Request.Path + "?"; ExportPageInfo1.UrlParams = Request.QueryString; ExportPageInfo1.CurrencyPage = EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1); #endregion }