/// <summary> /// 添加 /// </summary> /// <param name="model">团队定制实体</param> /// <returns>true:成功 false:失败</returns> public bool Add(EyouSoft.Model.HotelStructure.HotelTourCustoms model) { if (model == null) { return(false); } return(dal.Add(model)); }
/// <summary> /// 添加 /// </summary> /// <param name="model">团队定制实体</param> /// <returns>true:成功 false:失败</returns> public bool Add(EyouSoft.Model.HotelStructure.HotelTourCustoms model) { DbCommand dc = this._database.GetSqlStringCommand(Sql_HotelTourCustoms_INSERT); this._database.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId); this._database.AddInParameter(dc, "HotelCode", DbType.String, model.HotelCode); this._database.AddInParameter(dc, "HotelName", DbType.String, model.HotelName); this._database.AddInParameter(dc, "HotelStar", DbType.Int32, (int)model.HotelStar); this._database.AddInParameter(dc, "CityCode", DbType.String, model.CityCode); this._database.AddInParameter(dc, "LocationAsk", DbType.String, model.LocationAsk); this._database.AddInParameter(dc, "RoomAsk", DbType.String, model.RoomAsk); this._database.AddInParameter(dc, "LiveStartDate", DbType.DateTime, model.LiveStartDate); this._database.AddInParameter(dc, "LiveEndDate", DbType.DateTime, model.LiveEndDate); this._database.AddInParameter(dc, "RoomCount", DbType.Int32, model.RoomCount); this._database.AddInParameter(dc, "PeopleCount", DbType.Int32, model.PeopleCount); this._database.AddInParameter(dc, "BudgetMin", DbType.Decimal, model.BudgetMin); this._database.AddInParameter(dc, "BudgetMax", DbType.Decimal, model.BudgetMax); this._database.AddInParameter(dc, "Payment", DbType.Int32, (int)model.Payment); this._database.AddInParameter(dc, "GuestType", DbType.Int32, (int)model.GuestType); this._database.AddInParameter(dc, "TourType", DbType.Int32, (int)model.TourType); this._database.AddInParameter(dc, "OtherRemark", DbType.String, model.OtherRemark); this._database.AddInParameter(dc, "TreatState", DbType.Int32, (int)model.TreatState); return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false); }
/// <summary> /// 获取团队定制实体 /// </summary> /// <param name="Id">主键编号</param> /// <returns>团队预定实体</returns> public EyouSoft.Model.HotelStructure.HotelTourCustoms GetModel(int Id) { EyouSoft.Model.HotelStructure.HotelTourCustoms model = null; var strSql = new StringBuilder(); strSql.Append( @" SELECT [Id],[CompanyId],[HotelCode],[HotelName],[HotelStar],[CityCode],[LocationAsk],[RoomAsk], [LiveStartDate],[LiveEndDate],[RoomCount],[PeopleCount],[BudgetMin],[BudgetMax],[Payment],[GuestType], [TourType],[OtherRemark],[TreatState],[TreateTime],[OperatorId], (select top 1 ContactName,ContactSex,ContactTel,ContactFax,ContactMobile,ContactEmail,QQ,MQ,MSN from tbl_CompanyUser where tbl_CompanyUser.CompanyId = tbl_HotelTourCustoms.CompanyId and IsDeleted = '0' and IsEnable = '1' and IsAdmin = '1' for xml raw,root('Root')) as Contact from tbl_HotelTourCustoms where Id=@Id; "); DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString()); this._database.AddInParameter(dc, "Id", DbType.Int32, Id); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database)) { if (dr.Read()) { model = new EyouSoft.Model.HotelStructure.HotelTourCustoms(); if (!dr.IsDBNull(dr.GetOrdinal("BudgetMax"))) { model.BudgetMax = dr.GetDecimal(dr.GetOrdinal("BudgetMax")); } if (!dr.IsDBNull(dr.GetOrdinal("BudgetMin"))) { model.BudgetMin = dr.GetDecimal(dr.GetOrdinal("BudgetMin")); } model.CityCode = dr[dr.GetOrdinal("CityCode")].ToString(); model.CompanyId = dr[dr.GetOrdinal("CompanyId")].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("GuestType"))) { model.GuestType = (EyouSoft.HotelBI.HBEGuestTypeIndicator) int.Parse(dr[dr.GetOrdinal("GuestType")].ToString()); } model.HotelCode = dr[dr.GetOrdinal("HotelCode")].ToString(); model.HotelName = dr[dr.GetOrdinal("HotelName")].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("HotelStar"))) { model.HotelStar = (EyouSoft.HotelBI.HotelRankEnum) int.Parse(dr[dr.GetOrdinal("HotelStar")].ToString()); } model.Id = dr.GetInt32(dr.GetOrdinal("Id")); if (!dr.IsDBNull(dr.GetOrdinal("LiveEndDate"))) { model.LiveEndDate = dr.GetDateTime(dr.GetOrdinal("LiveEndDate")); } if (!dr.IsDBNull(dr.GetOrdinal("LiveStartDate"))) { model.LiveStartDate = dr.GetDateTime(dr.GetOrdinal("LiveStartDate")); } model.LocationAsk = dr[dr.GetOrdinal("LocationAsk")].ToString(); model.OtherRemark = dr[dr.GetOrdinal("OtherRemark")].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("Payment"))) { model.Payment = (EyouSoft.HotelBI.HBEPaymentType) int.Parse(dr[dr.GetOrdinal("Payment")].ToString()); } model.PeopleCount = dr.GetInt32(dr.GetOrdinal("PeopleCount")); model.RoomAsk = dr[dr.GetOrdinal("RoomAsk")].ToString(); model.RoomCount = dr.GetInt32(dr.GetOrdinal("RoomCount")); if (!dr.IsDBNull(dr.GetOrdinal("TourType"))) { model.TourType = (EyouSoft.Model.HotelStructure.TourTypeList) int.Parse(dr[dr.GetOrdinal("TourType")].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("TreatState"))) { model.TreatState = (EyouSoft.Model.HotelStructure.OrderStateList) int.Parse(dr[dr.GetOrdinal("TreatState")].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("TreateTime"))) { model.TreateTime = dr.GetDateTime(dr.GetOrdinal("TreateTime")); } model.OperatorId = dr.GetInt32(dr.GetOrdinal("OperatorId")); #region 2011-12-20线路改版增加 if (!dr.IsDBNull(dr.GetOrdinal("Contact"))) { var xRoot = XElement.Parse(dr.GetString(dr.GetOrdinal("Contact"))); var xRows = Common.Utility.GetXElements(xRoot, "row"); if (xRows != null && xRows.Any()) { model.Contact = new Model.CompanyStructure.ContactPersonInfo(); foreach (var t in xRows) { if (t == null) { continue; } model.Contact.ContactName = Common.Utility.GetXAttributeValue(t, "ContactName"); model.Contact.ContactSex = (Model.CompanyStructure.Sex) Common.Utility.GetInt(Common.Utility.GetXAttributeValue(t, "ContactSex")); model.Contact.Tel = Common.Utility.GetXAttributeValue(t, "ContactTel"); model.Contact.Fax = Common.Utility.GetXAttributeValue(t, "ContactFax"); model.Contact.Mobile = Common.Utility.GetXAttributeValue(t, "ContactMobile"); model.Contact.Email = Common.Utility.GetXAttributeValue(t, "ContactEmail"); model.Contact.QQ = Common.Utility.GetXAttributeValue(t, "QQ"); model.Contact.MQ = Common.Utility.GetXAttributeValue(t, "MQ"); model.Contact.MSN = Common.Utility.GetXAttributeValue(t, "MSN"); } } } #endregion } } return(model); }
/// <summary> /// 获取团队定制列表 /// </summary> /// <param name="PageSize">每页显示条数</param> /// <param name="PageIndex">当前页码</param> /// <param name="RecordCount">总记录数</param> /// <param name="SearchInfo">团队定制查询实体</param> /// <returns>团队定制列表</returns> public IList <EyouSoft.Model.HotelStructure.HotelTourCustoms> GetList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.HotelStructure.SearchTourCustomsInfo SearchInfo) { IList <EyouSoft.Model.HotelStructure.HotelTourCustoms> list = new List <EyouSoft.Model.HotelStructure.HotelTourCustoms>(); string tableName = "tbl_HotelTourCustoms"; string fields = @" Id,CompanyId,HotelCode,HotelName,HotelStar,LiveStartDate,LiveEndDate,RoomCount,PeopleCount,Payment, IssueTime,TreatState,RoomAsk,OtherRemark,LocationAsk,GuestType,TourType,BudgetMin,BudgetMax, (select top 1 ContactName,ContactSex,ContactTel,ContactFax,ContactMobile,ContactEmail,QQ,MQ,MSN from tbl_CompanyUser where tbl_CompanyUser.CompanyId = tbl_HotelTourCustoms.CompanyId and IsDeleted = '0' and IsEnable = '1' and IsAdmin = '1' for xml raw,root('Root')) as Contact"; string orderByStr = " IssueTime DESC "; string PrimaryKey = "Id"; StringBuilder strWhere = new StringBuilder(" 1=1 "); if (SearchInfo != null) { if (!string.IsNullOrEmpty(SearchInfo.HotelCode)) { strWhere.AppendFormat(" and HotelCode='{0}' ", SearchInfo.HotelCode); } if (!string.IsNullOrEmpty(SearchInfo.HotelName)) { strWhere.AppendFormat(" and HotelName like '%{0}%' ", SearchInfo.HotelName); } if (SearchInfo.CheckInSDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',LiveStartDate) >= 0 ", SearchInfo.CheckInSDate.Value.ToString()); } if (SearchInfo.CheckInEDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',LiveStartDate) <= 0 ", SearchInfo.CheckInEDate.Value.ToString()); } if (SearchInfo.CheckOutSDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',LiveEndDate) >= 0 ", SearchInfo.CheckOutSDate.Value.ToString()); } if (SearchInfo.CheckOutEDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',LiveEndDate) <= 0 ", SearchInfo.CheckOutEDate.Value.ToString()); } if (!string.IsNullOrEmpty(SearchInfo.CompanyId)) { strWhere.AppendFormat(" and CompanyId = '{0}' ", SearchInfo.CompanyId); } } using (IDataReader dr = DbHelper.ExecuteReader(this._database, PageSize, PageIndex, ref RecordCount, tableName, PrimaryKey, fields, strWhere.ToString(), orderByStr)) { while (dr.Read()) { EyouSoft.Model.HotelStructure.HotelTourCustoms model = new EyouSoft.Model.HotelStructure.HotelTourCustoms(); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.CompanyId = dr["CompanyId"].ToString(); model.HotelName = dr[dr.GetOrdinal("HotelName")].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("HotelCode"))) { model.HotelCode = dr[dr.GetOrdinal("HotelCode")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("LiveStartDate"))) { model.LiveStartDate = dr.GetDateTime(dr.GetOrdinal("LiveStartDate")); } if (!dr.IsDBNull(dr.GetOrdinal("LiveEndDate"))) { model.LiveEndDate = dr.GetDateTime(dr.GetOrdinal("LiveEndDate")); } model.RoomCount = dr.GetInt32(dr.GetOrdinal("RoomCount")); model.PeopleCount = dr.GetInt32(dr.GetOrdinal("PeopleCount")); if (!dr.IsDBNull(dr.GetOrdinal("Payment"))) { model.Payment = (EyouSoft.HotelBI.HBEPaymentType) int.Parse(dr[dr.GetOrdinal("Payment")].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("TreatState"))) { model.TreatState = (EyouSoft.Model.HotelStructure.OrderStateList) int.Parse(dr[dr.GetOrdinal("TreatState")].ToString()); } model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.RoomAsk = dr["RoomAsk"].ToString(); model.OtherRemark = dr["OtherRemark"].ToString(); model.LocationAsk = dr["LocationAsk"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("GuestType"))) { model.GuestType = (EyouSoft.HotelBI.HBEGuestTypeIndicator)dr.GetByte(dr.GetOrdinal("GuestType")); } if (!dr.IsDBNull(dr.GetOrdinal("TourType"))) { model.TourType = (EyouSoft.Model.HotelStructure.TourTypeList)dr.GetByte(dr.GetOrdinal("TourType")); } if (!dr.IsDBNull(dr.GetOrdinal("BudgetMin"))) { model.BudgetMin = dr.GetDecimal(dr.GetOrdinal("BudgetMin")); } if (!dr.IsDBNull(dr.GetOrdinal("BudgetMax"))) { model.BudgetMax = dr.GetDecimal(dr.GetOrdinal("BudgetMax")); } model.HotelStar = (EyouSoft.HotelBI.HotelRankEnum)dr.GetByte(dr.GetOrdinal("HotelStar")); #region 2011-12-20线路改版增加 if (!dr.IsDBNull(dr.GetOrdinal("Contact"))) { var xRoot = XElement.Parse(dr.GetString(dr.GetOrdinal("Contact"))); var xRows = Common.Utility.GetXElements(xRoot, "row"); if (xRows != null && xRows.Any()) { model.Contact = new Model.CompanyStructure.ContactPersonInfo(); foreach (var t in xRows) { if (t == null) { continue; } model.Contact.ContactName = Common.Utility.GetXAttributeValue(t, "ContactName"); model.Contact.ContactSex = (Model.CompanyStructure.Sex) Common.Utility.GetInt(Common.Utility.GetXAttributeValue(t, "ContactSex")); model.Contact.Tel = Common.Utility.GetXAttributeValue(t, "ContactTel"); model.Contact.Fax = Common.Utility.GetXAttributeValue(t, "ContactFax"); model.Contact.Mobile = Common.Utility.GetXAttributeValue(t, "ContactMobile"); model.Contact.Email = Common.Utility.GetXAttributeValue(t, "ContactEmail"); model.Contact.QQ = Common.Utility.GetXAttributeValue(t, "QQ"); model.Contact.MQ = Common.Utility.GetXAttributeValue(t, "MQ"); model.Contact.MSN = Common.Utility.GetXAttributeValue(t, "MSN"); } } } #endregion list.Add(model); model = null; } } return(list); }
/// <summary> /// 保存提交信息 /// </summary> protected void Save() { bool result = false; //验证是否添加成功 EyouSoft.Model.HotelStructure.HotelTourCustoms Model_TotelTourCustoms = new EyouSoft.Model.HotelStructure.HotelTourCustoms(); EyouSoft.BLL.HotelStructure.HotelTourCustoms Bll_TotelTourCustoms = new EyouSoft.BLL.HotelStructure.HotelTourCustoms(); Model_TotelTourCustoms.CompanyId = CompanyID;//公司编号 if (string.IsNullOrEmpty(Utils.GetFormValue("startDateTime"))) { SetErrorMsg(false, "请填写入住时间"); return; } if (string.IsNullOrEmpty(Utils.GetFormValue("endDateTime"))) { SetErrorMsg(false, "请填写离店时间"); return; } if (Utils.GetFormValue(this.tos_destination.UniqueID) == "0") { SetErrorMsg(false, "请填写城市"); return; } Model_TotelTourCustoms.LiveStartDate = Utils.GetDateTime(Utils.GetFormValue("startDateTime")); Model_TotelTourCustoms.LiveEndDate = Utils.GetDateTime(Utils.GetFormValue("endDateTime")); Model_TotelTourCustoms.CityCode = Utils.GetFormValue(this.tos_destination.UniqueID); Model_TotelTourCustoms.LocationAsk = Utils.GetString(Utils.GetFormValue("tos_statusrequirement"), ""); //地理位置要求 Model_TotelTourCustoms.HotelStar = (EyouSoft.HotelBI.HotelRankEnum)Utils.GetInt(Utils.GetFormValue(tos_starrequirement.UniqueID).Trim()); //星级要求 Model_TotelTourCustoms.RoomAsk = Utils.GetString(Utils.GetFormValue("tos_roomtyperequirements"), ""); //房型要求 Model_TotelTourCustoms.GuestType = (EyouSoft.HotelBI.HBEGuestTypeIndicator)Utils.GetInt(Utils.GetFormValue(this.tos_visitorstype.UniqueID).Trim()); //宾客类型 Model_TotelTourCustoms.TourType = (EyouSoft.Model.HotelStructure.TourTypeList)Utils.GetInt(Utils.GetFormValue(this.tos_teamtype.UniqueID).Trim()); //团队类型 Model_TotelTourCustoms.OtherRemark = Utils.GetString(Utils.GetFormValue("textarea"), ""); //其它要求 if (Utils.GetInt(Utils.GetFormValue("tos_result")) == 1) //有指定酒店 { if (Utils.GetFormValue("tos_HotelName") == "请填写酒店官方名称") { SetErrorMsg(false, "请填写酒店官方名称"); return; } else { Model_TotelTourCustoms.HotelName = Utils.GetString(Utils.GetFormValue("tos_HotelName"), ""); //酒店名称 } } else { Model_TotelTourCustoms.HotelName = ""; //酒店名称为空 } if (Utils.GetInt(Utils.GetFormValue("tos_roomnumber")) == 0) //团队预订的房间数量是0 { SetErrorMsg(false, "请填写预订的房间数量!"); return; } if (Utils.GetInt(Utils.GetFormValue("tos_roomnumber")) < 7) //预订的房间数量小于7 { SetErrorMsg(false, "至少要预订7间房间!"); return; } Model_TotelTourCustoms.RoomCount = Utils.GetInt(Utils.GetFormValue("tos_roomnumber")); //房间数量 if (Utils.GetInt(Utils.GetFormValue("tos_Number")) == 0) //入住的人数是0 { SetErrorMsg(false, "请填写入住的人数!"); return; } Model_TotelTourCustoms.PeopleCount = Utils.GetInt(Utils.GetFormValue("tos_Number")); //入住人数 if (Utils.GetDecimal(Utils.GetFormValue("tos_budget1")) == 0) { SetErrorMsg(false, "请填写团队房预算最小数!"); return; } Model_TotelTourCustoms.BudgetMin = Utils.GetDecimal(Utils.GetFormValue("tos_budget1")); //团房预算最小值 if (Utils.GetDecimal(Utils.GetFormValue("tos_budget2")) == 0) { SetErrorMsg(false, "请填写团队房预算最大数!"); return; } if (Utils.GetDecimal(Utils.GetFormValue("tos_budget1")) > Utils.GetDecimal(Utils.GetFormValue("tos_budget2"))) { SetErrorMsg(false, "团队房预算最大数不能小于最小数!"); return; } Model_TotelTourCustoms.BudgetMax = Utils.GetDecimal(Utils.GetFormValue("tos_budget2")); //团房预算最大值 result = Bll_TotelTourCustoms.Add(Model_TotelTourCustoms); //执行添加的方法 if (result) { SetErrorMsg(true, "提交成功!"); } else { SetErrorMsg(false, "提交失败"); } Model_TotelTourCustoms = null; //释放资源 Bll_TotelTourCustoms = null; }