/// <summary>
/// 分页获取特价机票信息
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <returns>特价机票集合</returns>
public virtual IList <EyouSoft.Model.TicketStructure.SpecialFares> GetSpecialFares(int pageSize, int pageIndex, ref int recordCount)
{
string fileds = "ID,Title,Category,IsJump,ContentText,Contact,ContactWay,QQ,AddTime";
string orderBy = " AddTime DESC";
string query = string.Empty;
string tableName = "tbl_SpecialFares";
string primaryKey = "ID";
IList <EyouSoft.Model.TicketStructure.SpecialFares> list = new List <EyouSoft.Model.TicketStructure.SpecialFares>();
EyouSoft.Model.TicketStructure.SpecialFares item = null;
using (IDataReader reader = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount,
tableName, primaryKey, fileds, query, orderBy))
{
while (reader.Read())
{
item = new EyouSoft.Model.TicketStructure.SpecialFares()
{
ID = (int)reader["ID"],
Title = reader["Title"].ToString(),
SpecialFaresType = (EyouSoft.Model.TicketStructure.SpecialFaresType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.SpecialFaresType), reader["Category"].ToString()),
IsJump = reader["IsJump"].ToString().Equals("1") ? true : false,
ContentText = reader.IsDBNull(reader.GetOrdinal("ContentText")) ? "" : reader["ContentText"].ToString(),
Contact = reader.IsDBNull(reader.GetOrdinal("Contact")) ? "" : reader["Contact"].ToString(),
ContactWay = reader.IsDBNull(reader.GetOrdinal("ContactWay")) ? "" : reader["ContactWay"].ToString(),
QQ = reader.IsDBNull(reader.GetOrdinal("QQ")) ? "" : reader["QQ"].ToString(),
AddTime = DateTime.Parse(reader["AddTime"].ToString())
};
list.Add(item);
}
}
return(list);
}
/// <summary>
/// 指定条数获取特价机票信息
/// </summary>
/// <param name="topNum">获取数量</param>
/// <returns>特价机票集合</returns>
public virtual IList <EyouSoft.Model.TicketStructure.SpecialFares> GetTopSpecialFares(int topNum)
{
DbCommand comm = this._database.GetSqlStringCommand(SQL_SpecialFares_GetTopSpecialFares);
this._database.AddInParameter(comm, "@topNum", DbType.Int32, topNum);
IList <EyouSoft.Model.TicketStructure.SpecialFares> list = new List <EyouSoft.Model.TicketStructure.SpecialFares>();
EyouSoft.Model.TicketStructure.SpecialFares item = null;
using (IDataReader reader = DbHelper.ExecuteReader(comm, this._database))
{
while (reader.Read())
{
item = new EyouSoft.Model.TicketStructure.SpecialFares()
{
ID = (int)reader["ID"],
Title = reader["Title"].ToString(),
SpecialFaresType = (EyouSoft.Model.TicketStructure.SpecialFaresType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.SpecialFaresType), reader["Category"].ToString()),
IsJump = reader["IsJump"].ToString().Equals("1") ? true : false,
ContentText = reader.IsDBNull(reader.GetOrdinal("ContentText")) ? "" : reader["ContentText"].ToString(),
Contact = reader.IsDBNull(reader.GetOrdinal("Contact")) ? "" : reader["Contact"].ToString(),
ContactWay = reader.IsDBNull(reader.GetOrdinal("ContactWay")) ? "" : reader["ContactWay"].ToString(),
QQ = reader.IsDBNull(reader.GetOrdinal("QQ")) ? "" : reader["QQ"].ToString(),
AddTime = DateTime.Parse(reader["AddTime"].ToString())
};
list.Add(item);
}
}
return(list);
}
/// <summary>
/// 修改特价机票信息
/// </summary>
/// <param name="item">特价机票实体对象</param>
/// <returns>true:成功 false:失败</returns>
public bool ModifySpecialFares(EyouSoft.Model.TicketStructure.SpecialFares item)
{
if (item == null)
{
return(false);
}
return(dal.ModifySpecialFares(item));
}
/// <summary>
/// 添加特价机票信息
/// </summary>
/// <param name="item">特价机票实体对象</param>
/// <returns>true:成功 false:失败</returns>
public virtual bool AddSpecialFares(EyouSoft.Model.TicketStructure.SpecialFares item)
{
DbCommand comm = this._database.GetSqlStringCommand(SQL_SpecialFares_AddSpecialFares);
this._database.AddInParameter(comm, "@Title", DbType.String, item.Title);
this._database.AddInParameter(comm, "@Category", DbType.Byte, (int)item.SpecialFaresType);
this._database.AddInParameter(comm, "@IsJump", DbType.String, item.IsJump ? "1" : "0");
this._database.AddInParameter(comm, "@ContentText", DbType.String, item.ContentText);
this._database.AddInParameter(comm, "@Contact", DbType.String, item.Contact);
this._database.AddInParameter(comm, "@ContactWay", DbType.String, item.ContactWay);
this._database.AddInParameter(comm, "@QQ", DbType.String, item.QQ);
return(DbHelper.ExecuteSql(comm, this._database) > 0 ? true : false);
}
protected void Page_Load(object sender, EventArgs e)
{
(this.Master as UserPublicCenter.MasterPage.NewPublicCenter).HeadMenuIndex = 3;
Utils.AddStylesheetInclude(CssManage.GetCssFilePath("body"));
Utils.AddStylesheetInclude(CssManage.GetCssFilePath("index2011"));
Utils.AddStylesheetInclude(CssManage.GetCssFilePath("InformationStyle"));
int id = Utils.GetInt(Request.QueryString["TicketId"]);
EyouSoft.Model.TicketStructure.SpecialFares model = EyouSoft.BLL.TicketStructure.SpecialFares.CreateInstance().GetSpecialFare(id);
if (model != null)
{
fareTitle = model.Title;
fareContent = model.ContentText;
fareDate = model.AddTime != null?model.AddTime.ToString("yyyy-MM-dd HH:mm") : DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd HH:mm");
fareAuthor = model.Contact;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request.QueryString["EditId"]))
{
EditId = Request.QueryString["EditId"];
}
if (!IsPostBack)
{
if (!CheckMasterGrant(YuYingPermission.机票首页管理_特价机票管理))
{
Utils.ResponseNoPermit(YuYingPermission.机票首页管理_特价机票管理, true);
return;
}
BindTypeList();
if (!string.IsNullOrEmpty(EditId))
{
EyouSoft.Model.TicketStructure.SpecialFares Model = EyouSoft.BLL.TicketStructure.SpecialFares.CreateInstance().GetSpecialFare(int.Parse(EditId));
//调用底层方法
int type = (int)Model.SpecialFaresType;
rdoTypeList.SelectedValue = type.ToString();
bool isGoSanke = Model.IsJump;
if (isGoSanke)
{
ckGoSan.Checked = true;
}
else
{
ckGoSan.Checked = false;
}
fckContent.Value = Model.ContentText;
txtContactName.Value = Model.Contact;
txtContactPhone.Value = Model.ContactWay;
txtQQ.Value = Model.QQ;
txtTitle.Value = Model.Title;
Model = null;
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//类别Id
string typeId = this.rdoTypeList.SelectedValue;
//是否跳转散客平台
bool IsGoSanKe = false;
if (this.ckGoSan.Checked)
{
IsGoSanKe = true;
}
else
{
IsGoSanKe = false;
}
//正文
string content = fckContent.Value;
//标题
string title = Utils.GetText(txtTitle.Value.Trim(), 100);
//联系人
string contactName = Utils.GetText(txtContactName.Value.Trim(), 100);
//联系电话
string contactPhone = Utils.GetText(txtContactPhone.Value.Trim(), 255);
//联系人qq
string contactQQ = Utils.GetText(txtQQ.Value.Trim(), 100);
EyouSoft.Model.TicketStructure.SpecialFares Model = new EyouSoft.Model.TicketStructure.SpecialFares();
Model.QQ = contactQQ;
Model.IsJump = IsGoSanKe;
Model.ContactWay = contactPhone;
Model.ContentText = content;
Model.AddTime = DateTime.Now;
Model.Contact = contactName;
Model.Title = title;
Model.SpecialFaresType = (EyouSoft.Model.TicketStructure.SpecialFaresType) int.Parse(typeId);
bool result = false;
if (!string.IsNullOrEmpty(EditId))
{
Model.ID = int.Parse(EditId);
result = EyouSoft.BLL.TicketStructure.SpecialFares.CreateInstance().ModifySpecialFares(Model);
}
else
{
result = EyouSoft.BLL.TicketStructure.SpecialFares.CreateInstance().AddSpecialFares(Model);
}
#region 输出提醒信息
if (result)
{
MessageBox.ShowAndRedirect(this, Model.ID > 0? "修改成功！" : "添加成功！",
"/AirTicktManage/AirTicketItemList.aspx");
}
else
{
MessageBox.ShowAndRedirect(this, Model.ID > 0 ? "修改失败！" : "添加失败！",
"/AirTicktManage/AirTicketItemList.aspx");
}
#endregion
Model = null;
}
