/// <summary> /// 获取团队定制回复列表 /// </summary> /// <param name="PageSize">每页显示条数</param> /// <param name="PageIndex">当前页码</param> /// <param name="RecordCount">总记录数</param> /// <param name="TourOrderId">团队定制订单ID</param> /// <returns>团队定制回复列表</returns> public virtual IList <EyouSoft.Model.HotelStructure.HotelTourCustomsAsk> GetListAsk(int PageSize, int PageIndex, ref int RecordCount, int TourOrderId) { IList <EyouSoft.Model.HotelStructure.HotelTourCustomsAsk> list = new List <EyouSoft.Model.HotelStructure.HotelTourCustomsAsk>(); string tableName = "tbl_HotelTourCustomsAsk"; string fields = "Id,TourOrderID,AskName,AskTime,AskContent"; string primaryKey = "Id"; string orderByStr = "AskTime desc"; string strWhere = string.Empty; if (TourOrderId > 0) { strWhere = " TourOrderID=" + TourOrderId.ToString(); } using (IDataReader dr = DbHelper.ExecuteReader(this._database, PageSize, PageIndex, ref RecordCount, tableName, primaryKey, fields, strWhere, orderByStr)) { while (dr.Read()) { EyouSoft.Model.HotelStructure.HotelTourCustomsAsk model = new EyouSoft.Model.HotelStructure.HotelTourCustomsAsk(); model.ID = dr[dr.GetOrdinal("Id")].ToString(); model.AskContent = dr[dr.GetOrdinal("AskContent")].ToString(); model.AskName = dr[dr.GetOrdinal("AskName")].ToString(); model.AskTime = dr[dr.GetOrdinal("AskTime")].ToString(); model.TourOrderID = dr.GetInt32(dr.GetOrdinal("TourOrderID")); list.Add(model); model = null; } } return(list); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!CheckMasterGrant(YuYingPermission.酒店后台管理_团队订单管理)) { Utils.ResponseNoPermit(YuYingPermission.酒店后台管理_团队订单管理, true); return; } string tid = Utils.GetQueryStringValue("tid"); if (Utils.GetQueryStringValue("method") == "save")//保存回复 { EyouSoft.Model.HotelStructure.HotelTourCustomsAsk askModel = new EyouSoft.Model.HotelStructure.HotelTourCustomsAsk(); askModel.AskContent = Server.HtmlDecode(Utils.GetQueryStringValue("content")); askModel.AskName = MasterUserInfo.UserName; askModel.AskTime = DateTime.Now.ToString(); askModel.TourOrderID = Utils.GetInt(tid); if (EyouSoft.BLL.HotelStructure.HotelTourCustoms.CreateInstance().AddAsk(askModel)) //添加回复 { Utils.ResponseMeg(true, "操作成功!"); } else { Utils.ResponseMeg(false, "操作失败!"); } } else { txtDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); //初始化显示值 txtLinkPerson.Value = MasterUserInfo.ContactName; hdTid.Value = tid; } } }
/// <summary> /// 添加回复 /// </summary> /// <param name="model">团队定制回复实体</param> /// <returns>true:成功 false:失败</returns> public bool AddAsk(EyouSoft.Model.HotelStructure.HotelTourCustomsAsk model) { if (model == null) { return(false); } return(dal.AddAsk(model)); }
/// <summary> /// 添加酒店团队订单回复 /// </summary> /// <param name="model">团队订单回复实体</param> /// <returns>true:成功 false:失败</returns> public virtual bool AddAsk(EyouSoft.Model.HotelStructure.HotelTourCustomsAsk model) { DbCommand dc = this._database.GetSqlStringCommand(Sql_HotelTourCustomsAsk_INSERT); this._database.AddInParameter(dc, "Id", DbType.AnsiStringFixedLength, Guid.NewGuid().ToString()); this._database.AddInParameter(dc, "TourOrderID", DbType.Int32, model.TourOrderID); this._database.AddInParameter(dc, "AskName", DbType.String, model.AskName); this._database.AddInParameter(dc, "AskContent", DbType.String, model.AskContent); return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false); }