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