/// <summary>
/// 获取机票实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Eyousoft_yhq.Model.GYSticket GetModel(string id)
{
Eyousoft_yhq.Model.GYSticket model = null;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("SELECT ID , CusName , CusSex , CusMob , PlaneTicket , IssueTime , Remark,OpertorID,OrderState,TicketState FROM GYSTicket ");
strSql.Append(" where id=@id ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "id", System.Data.DbType.AnsiStringFixedLength, id);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new Eyousoft_yhq.Model.GYSticket();
model.ID = dr.GetString(dr.GetOrdinal("ID"));;
model.CusName = dr.GetString(dr.GetOrdinal("CusName"));
model.CusSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("CusSex"));
model.CusMob = dr.GetString(dr.GetOrdinal("CusMob"));
model.PlaneTicket = dr.GetString(dr.GetOrdinal("PlaneTicket"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.Remark = dr.GetString(dr.GetOrdinal("Remark"));
model.OpertorID = dr.GetString(dr.GetOrdinal("OpertorID"));
model.orderState = (Eyousoft_yhq.Model.TickOrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.payState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("TicketState"));
}
}
return(model);
}
/// <summary>
/// 修改产品信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Eyousoft_yhq.Model.GYSticket model)
{
if (string.IsNullOrEmpty(model.ID))
{
return(false);
}
model.IssueTime = DateTime.Now;
return(dal.Update(model));
}
/// <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.GYSticket> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.GysTicketSer serModel)
{
IList <Eyousoft_yhq.Model.GYSticket> list = new List <Eyousoft_yhq.Model.GYSticket>();
string tableName = "GYSTicket";
string fileds = " ID , CusName , CusSex , CusMob , PlaneTicket , IssueTime , Remark, OpertorID,OrderState,TicketState ";
string orderByString = "IssueTime desc";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.OpertorID))
{
query.AppendFormat(" and OpertorID = '{0}' ", serModel.OpertorID);
}
if (!string.IsNullOrEmpty(serModel.cusName))
{
query.AppendFormat(" and CusName LIKE '%{0}%' ", serModel.cusName);
}
if (!string.IsNullOrEmpty(serModel.cusMob))
{
query.AppendFormat(" and CusMob LIKE '%{0}%' ", serModel.cusMob);
}
if (!string.IsNullOrEmpty(serModel.tickNO))
{
query.AppendFormat(" and PlaneTicket LIKE '%{0}%' ", serModel.tickNO);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.GYSticket model = new Eyousoft_yhq.Model.GYSticket();
model.ID = dr.GetString(dr.GetOrdinal("ID"));;
model.CusName = dr.GetString(dr.GetOrdinal("CusName"));
model.CusSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("CusSex"));
model.CusMob = dr.GetString(dr.GetOrdinal("CusMob"));
model.PlaneTicket = dr.GetString(dr.GetOrdinal("PlaneTicket"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.Remark = dr.GetString(dr.GetOrdinal("Remark"));
model.OpertorID = dr.GetString(dr.GetOrdinal("OpertorID"));
model.orderState = (Eyousoft_yhq.Model.TickOrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.payState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("TicketState"));
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 返回分页列表
/// </summary>
/// <param name="serModel"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.GYSticket> GetList(Eyousoft_yhq.Model.GysTicketSer serModel)
{
IList <Eyousoft_yhq.Model.GYSticket> list = new List <Eyousoft_yhq.Model.GYSticket>();
StringBuilder query = new StringBuilder();
query.Append("select ID , CusName , CusSex , CusMob , PlaneTicket , IssueTime , Remark, OpertorID,OrderState,TicketState from GYSTicket where 1=1");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.OpertorID))
{
query.AppendFormat(" and OpertorID = '{0}' ", serModel.OpertorID);
}
}
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.GYSticket model = new Eyousoft_yhq.Model.GYSticket();
model.ID = dr.GetString(dr.GetOrdinal("ID"));;
model.CusName = dr.GetString(dr.GetOrdinal("CusName"));
model.CusSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("CusSex"));
model.CusMob = dr.GetString(dr.GetOrdinal("CusMob"));
model.PlaneTicket = dr.GetString(dr.GetOrdinal("PlaneTicket"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.Remark = dr.GetString(dr.GetOrdinal("Remark"));
model.OpertorID = dr.GetString(dr.GetOrdinal("OpertorID"));
model.orderState = (Eyousoft_yhq.Model.TickOrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.payState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("TicketState"));
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 修改产品信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Eyousoft_yhq.Model.GYSticket model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" UPDATE GYSTicket SET CusName = @CusName , CusSex = @CusSex , CusMob = @CusMob , PlaneTicket = @PlaneTicket , IssueTime = @IssueTime , Remark = @Remark ,OpertorID=@OpertorID ,OrderState=@OrderState,TicketState=@TicketState WHERE ID = @ID ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ID", DbType.AnsiStringFixedLength, model.ID);
this._db.AddInParameter(cmd, "CusName", DbType.String, model.CusName);
this._db.AddInParameter(cmd, "CusSex", DbType.Int32, (int)model.CusSex);
this._db.AddInParameter(cmd, "CusMob", DbType.String, model.CusMob);
this._db.AddInParameter(cmd, "PlaneTicket", DbType.String, model.PlaneTicket);
this._db.AddInParameter(cmd, "IssueTime", DbType.DateTime, model.IssueTime);
this._db.AddInParameter(cmd, "Remark", DbType.String, model.Remark);
this._db.AddInParameter(cmd, "OpertorID", DbType.AnsiStringFixedLength, model.OpertorID);
this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)model.orderState);
this._db.AddInParameter(cmd, "TicketState", DbType.Byte, (int)model.payState);
return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 车票/景点门票添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Eyousoft_yhq.Model.GYSticket model)
{
model.ID = Guid.NewGuid().ToString();
model.IssueTime = DateTime.Now;
return(dal.Add(model));
}
/// <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.GYSticket> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.GysTicketSer serModel)
{
IList<Eyousoft_yhq.Model.GYSticket> list = new List<Eyousoft_yhq.Model.GYSticket>();
string tableName = "GYSTicket";
string fileds = " ID , CusName , CusSex , CusMob , PlaneTicket , IssueTime , Remark, OpertorID,OrderState,TicketState ";
string orderByString = "IssueTime desc";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.OpertorID))
{
query.AppendFormat(" and OpertorID = '{0}' ", serModel.OpertorID);
}
if (!string.IsNullOrEmpty(serModel.cusName))
{
query.AppendFormat(" and CusName LIKE '%{0}%' ", serModel.cusName);
}
if (!string.IsNullOrEmpty(serModel.cusMob))
{
query.AppendFormat(" and CusMob LIKE '%{0}%' ", serModel.cusMob);
}
if (!string.IsNullOrEmpty(serModel.tickNO))
{
query.AppendFormat(" and PlaneTicket LIKE '%{0}%' ", serModel.tickNO);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.GYSticket model = new Eyousoft_yhq.Model.GYSticket();
model.ID = dr.GetString(dr.GetOrdinal("ID")); ;
model.CusName = dr.GetString(dr.GetOrdinal("CusName"));
model.CusSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("CusSex"));
model.CusMob = dr.GetString(dr.GetOrdinal("CusMob"));
model.PlaneTicket = dr.GetString(dr.GetOrdinal("PlaneTicket"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.Remark = dr.GetString(dr.GetOrdinal("Remark"));
model.OpertorID = dr.GetString(dr.GetOrdinal("OpertorID"));
model.orderState = (Eyousoft_yhq.Model.TickOrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.payState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("TicketState"));
list.Add(model);
}
}
return list;
}
/// <summary>
/// 获取机票实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Eyousoft_yhq.Model.GYSticket GetModel(string id)
{
Eyousoft_yhq.Model.GYSticket model = null;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("SELECT ID , CusName , CusSex , CusMob , PlaneTicket , IssueTime , Remark,OpertorID,OrderState,TicketState FROM GYSTicket ");
strSql.Append(" where id=@id ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "id", System.Data.DbType.AnsiStringFixedLength, id);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new Eyousoft_yhq.Model.GYSticket();
model.ID = dr.GetString(dr.GetOrdinal("ID")); ;
model.CusName = dr.GetString(dr.GetOrdinal("CusName"));
model.CusSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("CusSex"));
model.CusMob = dr.GetString(dr.GetOrdinal("CusMob"));
model.PlaneTicket = dr.GetString(dr.GetOrdinal("PlaneTicket"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.Remark = dr.GetString(dr.GetOrdinal("Remark"));
model.OpertorID = dr.GetString(dr.GetOrdinal("OpertorID"));
model.orderState = (Eyousoft_yhq.Model.TickOrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.payState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("TicketState"));
}
}
return model;
}
/// <summary>
/// 返回分页列表
/// </summary>
/// <param name="serModel"></param>
/// <returns></returns>
public IList<Eyousoft_yhq.Model.GYSticket> GetList(Eyousoft_yhq.Model.GysTicketSer serModel)
{
IList<Eyousoft_yhq.Model.GYSticket> list = new List<Eyousoft_yhq.Model.GYSticket>();
StringBuilder query = new StringBuilder();
query.Append("select ID , CusName , CusSex , CusMob , PlaneTicket , IssueTime , Remark, OpertorID,OrderState,TicketState from GYSTicket where 1=1");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.OpertorID))
{
query.AppendFormat(" and OpertorID = '{0}' ", serModel.OpertorID);
}
}
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.GYSticket model = new Eyousoft_yhq.Model.GYSticket();
model.ID = dr.GetString(dr.GetOrdinal("ID")); ;
model.CusName = dr.GetString(dr.GetOrdinal("CusName"));
model.CusSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("CusSex"));
model.CusMob = dr.GetString(dr.GetOrdinal("CusMob"));
model.PlaneTicket = dr.GetString(dr.GetOrdinal("PlaneTicket"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.Remark = dr.GetString(dr.GetOrdinal("Remark"));
model.OpertorID = dr.GetString(dr.GetOrdinal("OpertorID"));
model.orderState = (Eyousoft_yhq.Model.TickOrderState)dr.GetByte(dr.GetOrdinal("OrderState"));
model.payState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("TicketState"));
list.Add(model);
}
}
return list;
}
