/// <summary> /// 初始化列表 /// </summary> protected void InitOrders() { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); #region 查询实体 var memeber = new Eyousoft_yhq.BLL.Member().GetModel(HuiYuanInfo.UserID); if (memeber == null || !memeber.IsAgent) return; Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.MemberID = memeber.UserID; serchModel.PromotionCode = memeber.PollCode == "" ? "未知" : memeber.PromotionCode; serchModel.PaymentState = Eyousoft_yhq.Model.PaymentState.已支付; pageIndex = UtilsCommons.GetPagingIndex("Page"); #endregion var list = bll.GetFYList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rpt_orders.DataSource = list; rpt_orders.DataBind(); this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?"; this.ExporPageInfoSelect1.intPageSize = pageSize; this.ExporPageInfoSelect1.CurrencyPage = pageIndex; this.ExporPageInfoSelect1.intRecordCount = recordCount; this.ExporPageInfoSelect1.UrlParams = Request.QueryString; litMsg.Visible = false; } else { rpt_orders.Visible = false; } }
protected void InitOrders(string Type) { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("OrderType"), (int)Eyousoft_yhq.Model.PaymentState.未支付); serchModel.MemberID = userInfo.UserID; pageIndex = Utils.GetInt(Utils.GetQueryStringValue("pageindex")); var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel); int isPage = 0; if (recordCount % pageSize != 0) { isPage = recordCount / pageSize + 1; } else { isPage = recordCount / pageSize; } if (list != null && list.Count > 0) { if (isPage >= pageIndex) { rpt_orders.DataSource = list; rpt_orders.DataBind(); } } }
/// <summary> /// 初始化列表 /// </summary> protected void InitOrders() { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); #region 查询实体 Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.OrderCode = Utils.GetQueryStringValue("orderCode"); serchModel.ConfirmCode = Utils.GetQueryStringValue("ConfirmCode"); serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("StartTime")); serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("EndTime")); serchModel.AppUser = Utils.GetQueryStringValue("AppUser"); serchModel.ConSumState = Eyousoft_yhq.Model.ConSumState.已消费; pageIndex = UtilsCommons.GetPagingIndex("Page"); if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商) { serchModel.ChanPinFaBuRenId = HuiYuanInfo.UserId; } #endregion var list = bll.GetScanList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rpt_orders.DataSource = list; rpt_orders.DataBind(); BindPage(); litMsg.Visible = false; } else { rpt_orders.Visible = false; } }
/// <summary> /// 页面初始化 /// </summary> private void PageInit() { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); #region 查询实体 Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtStartTime")); serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtEndTime") + " 23:59:59"); serchModel.XSTime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtXStartTime")); serchModel.XETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtXEndTime") + " 23:59:59"); serchModel.OrderCode = Utils.GetQueryStringValue("txtOrderCode"); serchModel.AppUserId = HuiYuanInfo.UserID; serchModel.ConSumState = Eyousoft_yhq.Model.ConSumState.已消费; pageIndex = UtilsCommons.GetPagingIndex("Page"); #endregion var list = bll.GetScanList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { this.rpOrder.DataSource = list; this.rpOrder.DataBind(); BindPage(); } else { Literal1.Text = "<tr align=\"center\"> <td colspan=\"11\">没有相关数据</td></tr>"; } }
/// <summary> /// 页面初始化 /// </summary> private void PageInit() { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); #region 查询实体 Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtStartTime")); serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("txtEndTime") + " 23:59:59"); serchModel.RouteName = Utils.GetQueryStringValue("txtRouteName"); serchModel.OrderPrice = Utils.GetDecimal(Utils.GetQueryStringValue("txtOrderPrice")); serchModel.MemberID = HuiYuanInfo.UserID; pageIndex = UtilsCommons.GetPagingIndex("Page"); #endregion btnAppUser.Visible = EyouSoft.Common.Page.HuiyuanPage.GetUserInfo().IsAdmin == "1"; var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { this.rpOrder.DataSource = list; this.rpOrder.DataBind(); BindPage(); } else { Literal1.Text = "<tr align=\"center\"> <td colspan=\"11\">没有相关数据</td></tr>"; } }
/// <summary> /// 初始化列表 /// </summary> protected void InitOrders() { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); #region 查询实体 Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.MemberID = Utils.GetQueryStringValue("userid"); serchModel.PromotionCode = Utils.GetQueryStringValue("Code") == "" ? "未知" : Utils.GetQueryStringValue("Code"); serchModel.PaymentState = Eyousoft_yhq.Model.PaymentState.已支付; pageIndex = UtilsCommons.GetPagingIndex("Page"); #endregion var list = bll.GetFYList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rpt_orders.DataSource = list; rpt_orders.DataBind(); this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?"; this.ExporPageInfoSelect1.intPageSize = pageSize; this.ExporPageInfoSelect1.CurrencyPage = pageIndex; this.ExporPageInfoSelect1.intRecordCount = recordCount; this.ExporPageInfoSelect1.UrlParams = Request.QueryString; litMsg.Visible = false; var Countlist = bll.GetList(serchModel); for (int i = 0; i < Countlist.Count; i++) { sumPayED += Countlist[i].RebackMoney; sumBacK += Countlist[i].backMoney; } lblPayED.Text = sumPayED.ToString("C2"); lblBacK.Text = sumBacK.ToString("C2"); } else { plaHJ.Visible = false; rpt_orders.Visible = false; } }
protected void InitOrders(string Type) { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("OrderType"), (int)Eyousoft_yhq.Model.PaymentState.未支付); serchModel.MemberID = userInfo.UserID; var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rpt_orders.DataSource = list; rpt_orders.DataBind(); litMsg.Visible = false; } else { PlaceHolder1.Visible = false; litMsg.Visible = true; } }
/// <summary> /// 初始化列表 /// </summary> protected void InitOrders() { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); #region 查询实体 Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.OrderCode = Utils.GetQueryStringValue("orderCode"); serchModel.ConfirmCode = Utils.GetQueryStringValue("ConfirmCode"); serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("StartTime")); serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("EndTime")); serchModel.OrderState = (Eyousoft_yhq.Model.OrderState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.OrderState), Utils.GetQueryStringValue("sleorderstatus")); serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("slepaystatus")); if (!string.IsNullOrEmpty(Utils.GetQueryStringValue("jiesuan"))) { serchModel.jiesuan = (Eyousoft_yhq.Model.JSfangshi)Utils.GetInt(Utils.GetQueryStringValue("jiesuan")); } pageIndex = UtilsCommons.GetPagingIndex("Page"); if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商) { serchModel.ChanPinFaBuRenId = HuiYuanInfo.UserId; phSMDZD.Visible = false; } #endregion var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rpt_orders.DataSource = list; rpt_orders.DataBind(); BindPage(); litMsg.Visible = false; } else { rpt_orders.Visible = false; } }
/// <summary> /// 初始化列表 /// </summary> protected void InitOrders() { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); #region 查询实体 Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.OrderCode = Utils.GetQueryStringValue("orderCode"); serchModel.ConfirmCode = Utils.GetQueryStringValue("ConfirmCode"); serchModel.STime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("StartTime")); serchModel.ETime = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("EndTime")); serchModel.OrderState = (Eyousoft_yhq.Model.OrderState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.OrderState), Utils.GetQueryStringValue("sleorderstatus")); serchModel.PaymentState = (Eyousoft_yhq.Model.PaymentState?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.PaymentState), Utils.GetQueryStringValue("slepaystatus")); if (!string.IsNullOrEmpty(Utils.GetQueryStringValue("jiesuan"))) serchModel.jiesuan = (Eyousoft_yhq.Model.JSfangshi)Utils.GetInt(Utils.GetQueryStringValue("jiesuan")); pageIndex = UtilsCommons.GetPagingIndex("Page"); if (HuiYuanInfo.LeiXing == Eyousoft_yhq.Model.WebmasterLeiXing.供应商) { serchModel.ChanPinFaBuRenId = HuiYuanInfo.UserId; phSMDZD.Visible = false; } #endregion var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rpt_orders.DataSource = list; rpt_orders.DataBind(); BindPage(); litMsg.Visible = false; } else { rpt_orders.Visible = false; } }
/// <summary> /// 初始化列表 /// </summary> protected void InitOrders() { Eyousoft_yhq.BLL.Order bll = new Eyousoft_yhq.BLL.Order(); #region 查询实体 var memeber = new Eyousoft_yhq.BLL.Member().GetModel(HuiYuanInfo.UserID); if (memeber == null || !memeber.IsAgent) { return; } Eyousoft_yhq.Model.MSearchOrder serchModel = new Eyousoft_yhq.Model.MSearchOrder(); serchModel.MemberID = memeber.UserID; serchModel.PromotionCode = memeber.PollCode == "" ? "未知" : memeber.PromotionCode; serchModel.PaymentState = Eyousoft_yhq.Model.PaymentState.已支付; pageIndex = UtilsCommons.GetPagingIndex("Page"); #endregion var list = bll.GetFYList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rpt_orders.DataSource = list; rpt_orders.DataBind(); this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?"; this.ExporPageInfoSelect1.intPageSize = pageSize; this.ExporPageInfoSelect1.CurrencyPage = pageIndex; this.ExporPageInfoSelect1.intRecordCount = recordCount; this.ExporPageInfoSelect1.UrlParams = Request.QueryString; litMsg.Visible = false; } else { rpt_orders.Visible = false; } }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Order> GetList(Eyousoft_yhq.Model.MSearchOrder serModel) { IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>(); StringBuilder query = new StringBuilder(); query.Append("select * from view_Order where 1=1"); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.MemberID)) { query.AppendFormat(" and MemberID = '{0}' ", serModel.MemberID); } if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.ConfirmCode)) { query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode); } if (serModel.OrderState.HasValue) { query.AppendFormat(" AND OrderState = '{0}' ", (int)serModel.OrderState.Value); } if (serModel.PaymentState.HasValue) { query.AppendFormat(" AND PayState = '{0}' ", (int)serModel.PaymentState.Value); } if (serModel.STime.HasValue) { query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value); } if (serModel.ETime.HasValue) { query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(serModel.RouteName)) { query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName); } if (serModel.OrderPrice != 0) { query.AppendFormat(" AND OrderPrice = '{0}' ", serModel.OrderPrice); } if (!string.IsNullOrEmpty(serModel.PromotionCode)) { query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' )", serModel.PromotionCode); } } query.Append(" order by IssueTime DESC "); DbCommand cmd = this._db.GetSqlStringCommand(query.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), model.OrderID); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); list.Add(model); } }; return(list); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Order> GetScanList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>(); string tableName = "view_OrderScan"; string fileds = " * "; string orderByString = " AppTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (serModel.ConSumState.HasValue) { query.AppendFormat(" AND ConSumState = '{0}' ", (int)serModel.ConSumState.Value); } if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.ConfirmCode)) { query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode); } if (!string.IsNullOrEmpty(serModel.AppUserId)) { query.AppendFormat(" and AppUserId = '{0}' ", serModel.AppUserId); } if (!string.IsNullOrEmpty(serModel.AppUser)) { query.AppendFormat(" and AppUserName like '%{0}%' ", serModel.ConfirmCode); } if (serModel.STime.HasValue) { query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value); } if (serModel.ETime.HasValue) { query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1)); } if (serModel.XSTime.HasValue) { query.AppendFormat(" AND AppTime>='{0}' ", serModel.XSTime.Value); } if (serModel.XETime.HasValue) { query.AppendFormat(" AND AppTime< '{0}' ", serModel.XETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(serModel.RouteName)) { query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.AppTime = dr.IsDBNull(dr.GetOrdinal("AppTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("AppTime")); model.AppUserName = dr.IsDBNull(dr.GetOrdinal("AppUserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("AppUserName")); model.AppMobNo = dr.IsDBNull(dr.GetOrdinal("AppMobNo")) ? "" : dr.GetString(dr.GetOrdinal("AppMobNo")); list.Add(model); } }; return(list); }
/// <summary> /// 获取返佣 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Order> GetFYList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>(); string tableName = "view_Order"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" PayState=2 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.MemberID)) { query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' OR MemberID = '{1}' ) ", serModel.PromotionCode, serModel.MemberID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); list.Add(model); } }; return(list); }
/// <summary> /// 获取返佣 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Order> GetFYList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { return(dal.GetFYList(PageSize, PageIndex, ref RecordCount, serModel)); }
public IList <Eyousoft_yhq.Model.Order> GetList(Eyousoft_yhq.Model.MSearchOrder serModel) { return(dal.GetList(serModel)); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Order> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>(); string tableName = "view_Order"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.MemberID)) { query.AppendFormat(" and MemberID = '{0}' ", serModel.MemberID); } if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.ConfirmCode)) { query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode); } if (!string.IsNullOrEmpty(serModel.AppUserId)) { query.AppendFormat(" and AppUserId = '{0}' ", serModel.AppUserId); } if (!string.IsNullOrEmpty(serModel.AppUser)) { query.AppendFormat(" and AppUserName like '%{0}%' ", serModel.ConfirmCode); } if (serModel.OrderState.HasValue) { query.AppendFormat(" AND OrderState = '{0}' ", (int)serModel.OrderState.Value); } if (serModel.ConSumState.HasValue) { query.AppendFormat(" AND ConSumState = '{0}' ", (int)serModel.ConSumState.Value); } if (serModel.PaymentState.HasValue) { query.AppendFormat(" AND PayState = '{0}' ", (int)serModel.PaymentState.Value); } if (serModel.STime.HasValue) { query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value); } if (serModel.ETime.HasValue) { query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1)); } if (serModel.XSTime.HasValue) { query.AppendFormat(" AND AppTime>='{0}' ", serModel.XSTime.Value); } if (serModel.XETime.HasValue) { query.AppendFormat(" AND AppTime< '{0}' ", serModel.XETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(serModel.RouteName)) { query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName); } if (serModel.OrderPrice != 0) { query.AppendFormat(" AND OrderPrice = '{0}' ", serModel.OrderPrice); } if (!string.IsNullOrEmpty(serModel.PromotionCode)) { query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' )", serModel.PromotionCode); } if (serModel.jiesuan.HasValue) { query.AppendFormat(" AND JState = '{0}' ", (int)serModel.jiesuan.Value); } if (!string.IsNullOrEmpty(serModel.ChanPinFaBuRenId)) { query.AppendFormat(" AND ChanPinFaBuRenId='{0}' ", serModel.ChanPinFaBuRenId); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), model.OrderID); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.AppTime = dr.IsDBNull(dr.GetOrdinal("AppTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("AppTime")); model.AppUserName = dr.IsDBNull(dr.GetOrdinal("AppUserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("AppUserName")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); model.WeiDianName = dr["WeiDianName"].ToString(); list.Add(model); } }; return(list); }