/// <summary> /// 获取一个订单 /// </summary> /// <param name="serModel">订单编号</param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MJiPiaoBaoCun> GetList(Eyousoft_yhq.Model.MJiPiaoBaoCunSer serModel) { IList <Eyousoft_yhq.Model.MJiPiaoBaoCun> list = new List <MJiPiaoBaoCun>(); StringBuilder StrSql = new StringBuilder(); StrSql.Append("select * from tbl_PlanTicket where 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.OpeatorID)) { StrSql.AppendFormat(" and OpeatorID = '{0}' ", serModel.OpeatorID); } if (serModel.payState.HasValue && serModel.payState == TickOrderPayState.未支付) { StrSql.AppendFormat(" and payState = '{0}' ", (int)serModel.payState.Value); } } StrSql.Append(" order by IssueTime DESC "); DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { while (dr.Read()) { Eyousoft_yhq.Model.MJiPiaoBaoCun model = new Eyousoft_yhq.Model.MJiPiaoBaoCun(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderID")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.OpeatorID = dr.GetString(dr.GetOrdinal("OpeatorID")); model.OpeatorName = dr.GetString(dr.GetOrdinal("OpeatorName")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.JpAdress = dr.IsDBNull(dr.GetOrdinal("JpAdress")) ? "" : dr.GetString(dr.GetOrdinal("JpAdress")); model.ModifyTag = dr.IsDBNull(dr.GetOrdinal("ModifyTag")) ? "" : dr.GetString(dr.GetOrdinal("ModifyTag")); model.payState = (TickOrderPayState)dr.GetByte(dr.GetOrdinal("payState")); model.InsPrice = dr.GetDecimal(dr.GetOrdinal("InsPrice")); list.Add(model); } } return(list); }
/// <summary> /// 初始化订单列表 /// </summary> void initOrders() { TickOrderPayState zfzt = TickOrderPayState.未支付; var serModel = new Eyousoft_yhq.Model.MJiPiaoBaoCunSer(); serModel.OpeatorID = userInfo.UserID; serModel.payState = TickOrderPayState.未支付; if (Utils.GetQueryStringValue("Pay") == "1") { serModel.payState = TickOrderPayState.已支付; zfzt = TickOrderPayState.已支付; } var list = new Eyousoft_yhq.BLL.BJiPiaoBaoCun().GetList(serModel); if (list == null || list.Count <= 0) { return; } StringBuilder orderListStr = new StringBuilder(); for (int i = 0; i < list.Count; i++) { string policyXML = new com._8222666.fxb2b.Service().XmlSubmit( getIdentityXMLString() , string.Format("<QuerySubsOrder_1_3><SubsOrderNo>{0}</SubsOrderNo></QuerySubsOrder_1_3>", list[i].OrderCode) , ""); orderListStr.Append(getOrderStr(policyXML, zfzt, list[i].OrderID, list[i].OrderCode, list[i].payState.ToString())); } if (zfzt == TickOrderPayState.未支付) { litNoPay.Text = orderListStr.ToString(); } else { litPay.Text = orderListStr.ToString(); } }
/// <summary> /// 获取一个订单列表 /// </summary> /// <param name="serModel">订单编号</param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MJiPiaoBaoCun> GetList(Eyousoft_yhq.Model.MJiPiaoBaoCunSer serModel) { return(dal.GetList(serModel)); }
/// <summary> /// 初始化订单列表 /// </summary> void initOrders() { TickOrderPayState zfzt = TickOrderPayState.未支付; var serModel = new Eyousoft_yhq.Model.MJiPiaoBaoCunSer(); serModel.OpeatorID = userInfo.UserID; serModel.payState = TickOrderPayState.未支付; if (Utils.GetQueryStringValue("Pay") == "1") { serModel.payState = TickOrderPayState.已支付; zfzt = TickOrderPayState.已支付; } var list = new Eyousoft_yhq.BLL.BJiPiaoBaoCun().GetList(serModel); if (list == null || list.Count <= 0) return; StringBuilder orderListStr = new StringBuilder(); for (int i = 0; i < list.Count; i++) { string policyXML = new com._8222666.fxb2b.Service().XmlSubmit( getIdentityXMLString() , string.Format("<QuerySubsOrder_1_3><SubsOrderNo>{0}</SubsOrderNo></QuerySubsOrder_1_3>", list[i].OrderCode) , ""); orderListStr.Append(getOrderStr(policyXML, zfzt, list[i].OrderID, list[i].OrderCode, list[i].payState.ToString())); } if (zfzt == TickOrderPayState.未支付) { litNoPay.Text = orderListStr.ToString(); } else { litPay.Text = orderListStr.ToString(); } }