/// <summary> /// 绑定 /// </summary> void BindInfo() { EyouSoft.BLL.FinanceStructure.CashierRegister bll = new EyouSoft.BLL.FinanceStructure.CashierRegister(SiteUserInfo); int sumcount = 0; EyouSoft.Model.FinanceStructure.QueryCashierRegisterInfo model = new EyouSoft.Model.FinanceStructure.QueryCashierRegisterInfo(); model.CompanyId = CurrentUserCompanyID; model.CustomerId = Utils.GetInt(Utils.GetQueryStringValue("comid")); //model.EndTime = Utils.GetDateTime( txt_date.Value); model.PaymentBank = Utils.GetQueryStringValue("bank"); model.StartTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("begin")); txt_bank.Value = model.PaymentBank; txt_com.Value = Utils.GetQueryStringValue("com"); hd_comId.Value = Utils.GetQueryStringValue("comid"); txt_date.Value = Utils.GetQueryStringValue("begin"); IList <EyouSoft.Model.FinanceStructure.CashierRegisterInfo> ilist = bll.GetList(model, 20, Utils.GetInt(Request.QueryString["page"], 1), ref sumcount); rpt_list.DataSource = ilist; rpt_list.DataBind(); //合计 bll.GetCashierRegisterMoney(model, ref paymentCount, ref totalAmount); ExportPageInfo1.intPageSize = 20; ExportPageInfo1.intRecordCount = sumcount; ExportPageInfo1.PageLinkURL = Request.Path + "?"; ExportPageInfo1.UrlParams = Request.QueryString; ExportPageInfo1.CurrencyPage = EyouSoft.Common.Utils.GetInt(Request.QueryString["page"], 1); }
/// <summary> /// 获取出纳登帐信息 /// </summary> /// <param name="model">出纳登帐信息查询实体</param> /// <param name="HaveUserIds">用户Id集合,半角逗号分割</param> /// <param name="PageSize">每页条数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">总记录数</param> /// <returns></returns> public IList <EyouSoft.Model.FinanceStructure.CashierRegisterInfo> GetList(EyouSoft.Model.FinanceStructure.QueryCashierRegisterInfo model, string HaveUserIds, int PageSize, int PageIndex, ref int RecordCount) { IList <EyouSoft.Model.FinanceStructure.CashierRegisterInfo> list = new List <EyouSoft.Model.FinanceStructure.CashierRegisterInfo>(); string strFiles = " [ID],[PaymentTime],[PaymentCount],[PaymentBank],[Customer],[CustomerID],[Contacter],[ContactTel],[Remark],[CompanyID],[RegisterTime],[OperatorId],[TotalAmount] "; string strOrder = string.Empty; string strWhere = this.GetSqlWhere(model, HaveUserIds, ref strOrder); using (IDataReader dr = DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, "tbl_CashierRegister", "ID", strFiles, strWhere, strOrder)) { EyouSoft.Model.FinanceStructure.CashierRegisterInfo tmpModel = null; while (dr.Read()) { tmpModel = new EyouSoft.Model.FinanceStructure.CashierRegisterInfo(); if (!dr.IsDBNull(dr.GetOrdinal("ID"))) { tmpModel.RegisterId = int.Parse(dr["ID"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("PaymentTime"))) { tmpModel.PaymentTime = DateTime.Parse(dr["PaymentTime"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("PaymentCount"))) { tmpModel.PaymentCount = decimal.Parse(dr["PaymentCount"].ToString()); } tmpModel.PaymentBank = dr["PaymentBank"].ToString(); tmpModel.CustomerName = dr["Customer"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("CustomerID"))) { tmpModel.CustomerId = int.Parse(dr["CustomerID"].ToString()); } tmpModel.Contacter = dr["Contacter"].ToString(); tmpModel.ContactTel = dr["ContactTel"].ToString(); tmpModel.Remark = dr["Remark"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("CompanyID"))) { tmpModel.CompanyId = int.Parse(dr["CompanyID"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("RegisterTime"))) { tmpModel.CreateTime = DateTime.Parse(dr["RegisterTime"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("OperatorId"))) { tmpModel.OperatorId = int.Parse(dr["OperatorId"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("TotalAmount"))) { tmpModel.TotalAmount = decimal.Parse(dr["TotalAmount"].ToString()); } list.Add(tmpModel); } } return(list); }
/// <summary> /// 根据查询实体获取SqlWhere条件 /// </summary> /// <param name="model">查询实体</param> /// <param name="HaveUserIds">用户Id集合,半角逗号分割</param> /// <param name="strOrder">排序语句</param> /// <returns>SqlWhere条件</returns> private string GetSqlWhere(EyouSoft.Model.FinanceStructure.QueryCashierRegisterInfo model, string HaveUserIds , ref string strOrder) { if (model == null) { return(string.Empty); } StringBuilder strWhere = new StringBuilder(" 1 = 1 "); if (model.CompanyId > 0) { strWhere.AppendFormat(" and CompanyID = {0} ", model.CompanyId); } if (model.CustomerId > 0) { strWhere.AppendFormat(" and CustomerID = {0} ", model.CustomerId); } if (!string.IsNullOrEmpty(model.PaymentBank)) { strWhere.AppendFormat(" and PaymentBank like '%{0}%' ", model.PaymentBank); } if (model.StartTime.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',PaymentTime) >= 0 ", model.StartTime.Value.ToShortDateString()); } if (model.EndTime.HasValue) { strWhere.AppendFormat(" and datediff(dd,PaymentTime,'{0}') >= 0 ", model.EndTime.Value.ToShortDateString()); } if (!string.IsNullOrEmpty(HaveUserIds)) { strWhere.AppendFormat(" and OperatorId in ({0}) ", HaveUserIds); } switch (model.OrderIndex) { case 0: strOrder = " PaymentTime asc "; break; case 1: strOrder = " PaymentTime desc "; break; } return(strWhere.ToString()); }