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