/// <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();
}
}
