public bool CheckApproveUser(string UserID, int iType) { messageContent.InnerHtml = ""; HotelInfoEntity _hotelinfoEntity = new HotelInfoEntity(); _hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); hotelInfoDBEntity.SalesID = UserID; _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); DataSet dsResult = HotelInfoBP.CheckApproveUser(_hotelinfoEntity).QueryResult; if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { messageContent.InnerHtml = "该用户非订单审核人员,请确认!"; return false; } if (iType == 1) { dsResult = HotelInfoBP.CheckApproveUserBandHotel(_hotelinfoEntity).QueryResult; if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { messageContent.InnerHtml = "该订单审核人员未绑定酒店,请确认!"; return false; } } return true; }
public static HotelInfoEntity GetHotelList(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("CITYID",OracleType.VarChar), new OracleParameter("TRADEAREAID",OracleType.VarChar), new OracleParameter("SALES",OracleType.VarChar), }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); if (string.IsNullOrEmpty(dbParm.HotelID)) parm[0].Value = DBNull.Value; else parm[0].Value = dbParm.HotelID; if (string.IsNullOrEmpty(dbParm.City)) parm[1].Value = DBNull.Value; else parm[1].Value = dbParm.City; if (string.IsNullOrEmpty(dbParm.AreaID)) parm[2].Value = DBNull.Value; else parm[2].Value = dbParm.AreaID; if (string.IsNullOrEmpty(dbParm.SalesID)) parm[3].Value = DBNull.Value; else parm[3].Value = dbParm.SalesID; hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelPlanInfo", "t_lm_b_hotelplan_search_list", false, parm); return hotelInfoEntity; }
public static HotelInfoEntity BedTypeListSelect(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("KEYWORD",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); if (!String.IsNullOrEmpty(dbParm.KeyWord)) { parm[0].Value = dbParm.KeyWord; } else { parm[0].Value = DBNull.Value; } DataSet dsResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_room_bed_select", false, parm); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { Hashtable alNm = GetBedTagNm(); for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++) { dsResult.Tables[0].Rows[i]["BEDTG"] = SetBedTagNm(dsResult.Tables[0].Rows[i]["bed_tag"].ToString(), alNm); } } hotelInfoEntity.QueryResult = dsResult; return hotelInfoEntity; }
public static HotelInfoEntity BindHotelList(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); parm[0].Value = dbParm.HotelID; hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_hotelinfo_bind", false, parm); return hotelInfoEntity; }
public static HotelInfoEntity BedTypeListDetail(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("BEDCD",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); parm[0].Value = dbParm.BedCode; hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_room_bed_detail", false, parm); return hotelInfoEntity; }
public static HotelInfoEntity BindUpdatePrRoomData(HotelInfoEntity hotelInfoEntity) { HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); OracleParameter[] dlmParm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("PRICECD",OracleType.VarChar) }; dlmParm[0].Value = dbParm.HotelID; dlmParm[1].Value = dbParm.PriceCode; hotelInfoEntity.QueryResult = DbManager.Query("HotelInfo", "t_price_room_list", false, dlmParm); return hotelInfoEntity; }
public static string SetBDlonglatTude(string Longitude, string Latitude) { HotelInfoEntity hotelinfoEntity = new HotelInfoEntity(); hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); hotelInfoDBEntity.Longitude = Longitude; hotelInfoDBEntity.Latitude = Latitude; hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); return HotelInfoBP.SetBDlonglatTude(hotelinfoEntity); }
/// <summary> /// 生成房型列表 -- Oracle /// </summary> /// <param name="strHotelID"></param> public static DataSet BindBalanceRoomList(string strHotelID) { HotelInfoEntity _hotelinfoEntity = new HotelInfoEntity(); _hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); hotelInfoDBEntity.HotelID = strHotelID;//酒店ID _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); DataSet dsResult = HotelInfoBP.GetBalanceRoomListByHotel(_hotelinfoEntity).QueryResult; return dsResult; }
public static HotelInfoEntity BedTypeListSelect(HotelInfoEntity hotelInfoEntity) { hotelInfoEntity.LogMessages.MsgType = MessageType.INFO; hotelInfoEntity.LogMessages.Content = _nameSpaceClass + "BedTypeListSelect"; LoggerHelper.LogWriter(hotelInfoEntity.LogMessages); try { return HotelInfoDA.BedTypeListSelect(hotelInfoEntity); } catch (Exception ex) { hotelInfoEntity.LogMessages.MsgType = MessageType.ERROR; hotelInfoEntity.LogMessages.Content = _nameSpaceClass + "BedTypeListSelect Error: " + ex.Message; LoggerHelper.LogWriter(hotelInfoEntity.LogMessages); throw ex; } }
/// <summary> /// 根据时间段 HotelID 取计划 -- 接口 /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <param name="strHotelID"></param> /// <returns></returns> public static DataSet GetBindLmbarPlanList(string startDate, string endDate, string strHotelID) { HotelInfoEntity _hotelinfoEntity = new HotelInfoEntity(); _hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); hotelInfoDBEntity.HotelID = strHotelID; hotelInfoDBEntity.SalesStartDT = startDate; hotelInfoDBEntity.SalesEndDT = endDate; _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); DataSet dsResult = HotelInfoBP.GetPlanListByIndiscriminatelyRateCode(_hotelinfoEntity).QueryResult; return dsResult; }
public static DataTable GetHotel(string hotelID, string cityID, string areaID, string SalesID) { DataTable dtResult = new DataTable(); HotelInfoEntity _hotelinfoEntity = new HotelInfoEntity(); _hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); hotelInfoDBEntity.HotelID = hotelID == "" ? "" : hotelID.Substring((hotelID.IndexOf('[') + 1), (hotelID.IndexOf(']') - 1));//酒店ID hotelInfoDBEntity.City = cityID == "" ? "" : cityID.Substring((cityID.IndexOf('[') + 1), (cityID.IndexOf(']') - 1)); //"";//城市ID hotelInfoDBEntity.Bussiness = areaID == "" ? "" : areaID.Substring((areaID.IndexOf('[') + 1), (areaID.IndexOf(']') - 1));//"";//商圈ID hotelInfoDBEntity.SalesID = SalesID == "" ? "" : SalesID.Substring((SalesID.IndexOf('[') + 1), (SalesID.IndexOf(']') - 1));//"";//销售 _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); dtResult = HotelPlanInfoBP.GetHotelList(_hotelinfoEntity).QueryResult.Tables[0]; return dtResult; }
public static HotelInfoEntity GetBalHotelRoomList(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); parm[0].Value = dbParm.HotelID; hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_balanceroom_proomlist", true, parm); return hotelInfoEntity; }
public static HotelInfoEntity GetBalanceRoomListByHotelAndPriceCode(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("PRICECODE",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); parm[0].Value = dbParm.HotelID; parm[1].Value = dbParm.PriceCode; hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_balancerom_byhotelandpricecode", true, parm); return hotelInfoEntity; }
public static HotelInfoEntity GetBalanceRoomHistory(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("ROOMCD",OracleType.VarChar), new OracleParameter("STARTDT",OracleType.VarChar), new OracleParameter("ENDDT",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); parm[0].Value = dbParm.HotelID; if (String.IsNullOrEmpty(dbParm.HRoomList)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.HRoomList; } if (String.IsNullOrEmpty(dbParm.InDateFrom)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.InDateFrom; } if (String.IsNullOrEmpty(dbParm.InDateTo)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.InDateTo; } DataSet dsResult = new DataSet(); DataSet dsRoomList = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_balancerom_roomlist", true, parm); DataSet dsDataList = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_balancerom_select", true, parm); int iLmCount = 0; string Cols = string.Empty; dsResult.Tables.Add(new DataTable()); dsResult.Tables[0].Columns.Add("EFFECTDT"); foreach (DataRow drCol in dsRoomList.Tables[0].Rows) { if ("LMBAR".Equals(drCol["rate_code"].ToString().ToUpper())) { iLmCount = iLmCount + 1; } dsResult.Tables[0].Columns.Add(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper()); Cols = Cols + GetColsNameByRoomTypeCode(dbParm.HotelID, drCol["room_type_code"].ToString()) + ","; } string strDate = string.Empty; foreach (DataRow drVal in dsDataList.Tables[0].Rows) { if (!strDate.Equals(drVal["EFFECTDATE"].ToString())) { strDate = drVal["EFFECTDATE"].ToString(); DataRow[] drList = dsDataList.Tables[0].Select("EFFECTDATE='" + strDate + "'"); if (drList.Count() == 0) { continue; } DataRow drRow = dsResult.Tables[0].NewRow(); drRow["EFFECTDT"] = strDate; string strColNM = string.Empty; foreach (DataRow drTemp in drList) { strColNM = drTemp["rate_code"].ToString().ToUpper() + "-" + drTemp["room_type_code"].ToString().ToUpper(); drRow[strColNM] = ("42".Equals(drTemp["commision_mode"].ToString())) ? drTemp["commision"].ToString() + "%" : drTemp["commision"].ToString() + "元"; } dsResult.Tables[0].Rows.Add(drRow); } } dsResult.Tables[0].Columns["EFFECTDT"].ColumnName = "日期/房型"; hotelInfoEntity.LMCount = iLmCount; hotelInfoEntity.LM2Count = dsResult.Tables[0].Columns.Count - iLmCount - 1; hotelInfoEntity.Cols = Cols.Trim(','); hotelInfoEntity.QueryResult = dsResult; return hotelInfoEntity; }
public static HotelInfoEntity ExportBalanceRoomHistory(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("ROOMCD",OracleType.VarChar), new OracleParameter("STARTDT",OracleType.VarChar), new OracleParameter("ENDDT",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); parm[0].Value = dbParm.HotelID; if (String.IsNullOrEmpty(dbParm.HRoomList)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.HRoomList; } if (String.IsNullOrEmpty(dbParm.InDateFrom)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.InDateFrom; } if (String.IsNullOrEmpty(dbParm.InDateTo)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.InDateTo; } DataSet dsResult = new DataSet(); DataSet dsRoomList = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_balancerom_roomlist", true, parm); DataSet dsDataList = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_balancerom_select", true, parm); System.Collections.Hashtable htRoomNm = new System.Collections.Hashtable(); dsResult.Tables.Add(new DataTable()); dsResult.Tables[0].Columns.Add("EFFECTDT"); foreach (DataRow drCol in dsRoomList.Tables[0].Rows) { dsResult.Tables[0].Columns.Add(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper()); if (!htRoomNm.ContainsKey(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper())) { htRoomNm.Add(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper(), GetColsNameByRoomTypeCode(dbParm.HotelID, drCol["room_type_code"].ToString())); } } string strDate = string.Empty; foreach (DataRow drVal in dsDataList.Tables[0].Rows) { if (!strDate.Equals(drVal["EFFECTDATE"].ToString())) { strDate = drVal["EFFECTDATE"].ToString(); DataRow[] drList = dsDataList.Tables[0].Select("EFFECTDATE='" + strDate + "'"); if (drList.Count() == 0) { continue; } DataRow drRow = dsResult.Tables[0].NewRow(); drRow["EFFECTDT"] = strDate; string strColNM = string.Empty; foreach (DataRow drTemp in drList) { strColNM = drTemp["rate_code"].ToString().ToUpper() + "-" + drTemp["room_type_code"].ToString().ToUpper(); drRow[strColNM] = ("42".Equals(drTemp["commision_mode"].ToString())) ? drTemp["commision"].ToString() + "%" : drTemp["commision"].ToString() + "元"; } dsResult.Tables[0].Rows.Add(drRow); } } dsResult.Tables[0].Columns["EFFECTDT"].ColumnName = "日期/房型"; for (int i = 1; i < dsResult.Tables[0].Columns.Count; i++) { dsResult.Tables[0].Columns[i].ColumnName = dsResult.Tables[0].Columns[i].ColumnName.Substring(0, dsResult.Tables[0].Columns[i].ColumnName.IndexOf('-') + 1) + htRoomNm[dsResult.Tables[0].Columns[i].ColumnName].ToString(); } hotelInfoEntity.QueryResult = dsResult; return hotelInfoEntity; }
public static bool CheckUpdate(HotelInfoEntity hotelInfoEntity) { HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("CheckUpdateSalesID"); cmd.SetParameterValue("@UserCode", dbParm.SalesID); string RoleID = (String.IsNullOrEmpty(ConfigurationManager.AppSettings["SalesRoleID"])) ? "5" : ConfigurationManager.AppSettings["SalesRoleID"].ToString().Trim(); cmd.SetParameterValue("@RoleID", RoleID); DataSet dsResult = cmd.ExecuteDataSet(); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { return true; } return false; }
public bool btnAddData() { MessageContent.InnerHtml = ""; bool bFlag = true; string msgString = ""; if (String.IsNullOrEmpty(txtHotelNM.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError3").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtHotelNM.Text.ToString().Trim()) > 100) { msgString = msgString + GetLocalResourceObject("UpdateError2").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtHotelNMEN.Text.ToString().Trim()) > 100) { msgString = msgString + GetLocalResourceObject("UpdateError12").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtHotelPN.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError115").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtHotelPN.Text.ToString().Trim()) > 1000) { msgString = msgString + GetLocalResourceObject("UpdateError101").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtTotalRooms.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError102").ToString() + "<br/>"; bFlag = false; } if (!ChkNumber(txtTotalRooms.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError103").ToString() + "<br/>"; bFlag = false; } if (!ChkNumber(txtPriceLow.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError117").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtHotelJP.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError116").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtHotelJP.Text.ToString().Trim()) > 1000) { msgString = msgString + GetLocalResourceObject("UpdateError104").ToString() + "<br/>"; bFlag = false; } string strCity = hidCityID.Value.Trim(); if (String.IsNullOrEmpty(strCity.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError105").ToString() + "<br/>"; bFlag = false; } if (!strCity.Contains("[") && !strCity.Contains("]")) { msgString = msgString + GetLocalResourceObject("UpdateError118").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtAddress.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError106").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtAddress.Text.ToString().Trim()) > 150) { msgString = msgString + GetLocalResourceObject("UpdateError4").ToString() + "<br/>"; bFlag = false; } if ((String.IsNullOrEmpty(txtLatitude.Text.ToString().Trim())) || (String.IsNullOrEmpty(txtLongitude.Text.ToString().Trim()))) { msgString = msgString + GetLocalResourceObject("UpdateError21").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(hidBussList.Value.Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError107").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtContactNameZh.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError108").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtContactNameZh.Text.ToString().Trim()) > 100) { msgString = msgString + GetLocalResourceObject("UpdateError109").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtHotelFax.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError71").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtHotelFax.Text.ToString().Trim()) && (StringUtility.Text_Length(txtHotelFax.Text.ToString().Trim()) > 100)) { msgString = msgString + GetLocalResourceObject("UpdateError7").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtContactPhone.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError110").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtContactPhone.Text.ToString().Trim()) && (StringUtility.Text_Length(txtContactPhone.Text.ToString().Trim()) > 30)) { msgString = msgString + GetLocalResourceObject("UpdateError111").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtHotelTel.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError61").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtHotelTel.Text.ToString().Trim()) && (StringUtility.Text_Length(txtHotelTel.Text.ToString().Trim()) > 40)) { msgString = msgString + GetLocalResourceObject("UpdateError6").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtContactEmail.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError113").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtContactEmail.Text.ToString().Trim()) > 100) { msgString = msgString + GetLocalResourceObject("UpdateError11").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtSimpleDescZh.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError112").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtSimpleDescZh.Text.ToString().Trim()) && (StringUtility.Text_Length(txtSimpleDescZh.Text.ToString().Trim()) > 1000)) { msgString = msgString + GetLocalResourceObject("UpdateError8").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtDescZh.Text.ToString().Trim()) && (StringUtility.Text_Length(txtDescZh.Text.ToString().Trim()) > 2000)) { msgString = msgString + GetLocalResourceObject("UpdateError114").ToString() + "<br/>"; bFlag = false; } //if (!RegexValidateData(txtLatitude.Text.ToString().Trim()) || !RegexValidateData(txtLongitude.Text.ToString().Trim())) //{ // msgString = msgString + GetLocalResourceObject("UpdateError31").ToString() + "<br/>"; // bFlag = false; //} if (!bFlag) { MessageContent.InnerHtml = GetLocalResourceObject("UpdateError1").ToString() + "<br/>" + msgString; return false; } _hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); hotelInfoDBEntity.Name_CN = txtHotelNM.Text.Trim(); hotelInfoDBEntity.Name_EN = txtHotelNMEN.Text.Trim(); hotelInfoDBEntity.City = (strCity.IndexOf("]") >= 0) ? strCity.Substring((strCity.IndexOf('[') + 1), (strCity.IndexOf(']') - 1)) : ""; //hotelInfoDBEntity.Administration = ddpAdministration.SelectedValue.Trim(); hotelInfoDBEntity.StarRating = ddpStarRating.SelectedValue; hotelInfoDBEntity.AddRess = txtAddress.Text.Trim(); hotelInfoDBEntity.Phone = txtHotelTel.Text.Trim(); hotelInfoDBEntity.Fax = txtHotelFax.Text.Trim(); hotelInfoDBEntity.Longitude = txtLongitude.Text.Trim(); hotelInfoDBEntity.Latitude = txtLatitude.Text.Trim(); //hotelInfoDBEntity.HotelGroup = ddpHotelGroup.SelectedValue; hotelInfoDBEntity.Bussiness = hidBussList.Value.Trim(); hotelInfoDBEntity.OpenDate = dpOpenDate.Value; hotelInfoDBEntity.RepairDate = dpRepairDate.Value; hotelInfoDBEntity.SimpleDescZh = txtSimpleDescZh.Text.Trim(); hotelInfoDBEntity.DescZh = txtDescZh.Text.Trim(); //hotelInfoDBEntity.HServe = txtHServe.Text.Trim(); //hotelInfoDBEntity.HFacility = txtHFacility.Text.Trim(); hotelInfoDBEntity.Status = ddpOnline.SelectedValue.Trim(); hotelInfoDBEntity.HotelPN = txtHotelPN.Text.Trim(); hotelInfoDBEntity.TotalRooms = txtTotalRooms.Text.Trim(); hotelInfoDBEntity.HotelJP = txtHotelJP.Text.Trim(); hotelInfoDBEntity.Zip = txtZip.Text.Trim(); hotelInfoDBEntity.PriceLow = txtPriceLow.Text.Trim(); hotelInfoDBEntity.ContactPer = txtContactNameZh.Text.Trim(); hotelInfoDBEntity.ContactPhone = txtContactPhone.Text.Trim(); hotelInfoDBEntity.ContactEmail = txtContactEmail.Text.Trim(); //hotelInfoDBEntity.ID = hidHotelNo.Value; //hotelInfoDBEntity.HotelID = hidHotelID.Value; //hotelInfoDBEntity.Status = ddpStatusList.SelectedValue; //hotelInfoDBEntity.WebSite = txtWebSite.Text.Trim(); //hotelInfoDBEntity.Phone = txtPhone.Text.Trim(); //hotelInfoDBEntity.DiamondRating = ddpDiamondRating.SelectedValue; //hotelInfoDBEntity.City = ddpCity.SelectedValue; //hotelInfoDBEntity.ContactPer = txtContactPer.Text.Trim(); //hotelInfoDBEntity.ContactEmail = txtContactEmail.Text.Trim(); //hotelInfoDBEntity.Evaluation = Evaluation; //hotelInfoDBEntity.AutoTrust = (chkAutoTrust.Checked) ? "1" : "0"; //hotelInfoDBEntity.FogStatus = hidFogStatus.Value; _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); _hotelinfoEntity = HotelInfoBP.SupHotelSave(_hotelinfoEntity); int iResult = _hotelinfoEntity.Result; string HotelID = _hotelinfoEntity.ErrorMSG; _commonEntity.LogMessages = _hotelinfoEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "SUP酒店基础信息-保存"; commonDBEntity.Event_ID = HotelID; string conTent = GetLocalResourceObject("EventInsertMessage").ToString(); conTent = string.Format(conTent,HotelID, hotelInfoDBEntity.Name_CN, hotelInfoDBEntity.Name_EN, hotelInfoDBEntity.City, hotelInfoDBEntity.StarRating, hotelInfoDBEntity.AddRess, hotelInfoDBEntity.Phone, hotelInfoDBEntity.Fax, hotelInfoDBEntity.Longitude, hotelInfoDBEntity.Latitude, hotelInfoDBEntity.Bussiness, hotelInfoDBEntity.OpenDate, hotelInfoDBEntity.RepairDate, hotelInfoDBEntity.SimpleDescZh, hotelInfoDBEntity.DescZh, hotelInfoDBEntity.Status, hotelInfoDBEntity.HotelPN, hotelInfoDBEntity.TotalRooms, hotelInfoDBEntity.HotelJP, hotelInfoDBEntity.Zip, hotelInfoDBEntity.PriceLow, hotelInfoDBEntity.ContactPer, hotelInfoDBEntity.ContactPhone, hotelInfoDBEntity.ContactEmail); commonDBEntity.Event_Content = conTent; if (iResult == 1) { commonDBEntity.Event_Result = string.Format(GetLocalResourceObject("UpdateSuccess").ToString(), HotelID); MessageContent.InnerHtml = string.Format(GetLocalResourceObject("UpdateSuccess").ToString(), HotelID); } else if (iResult == 3) { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError33").ToString(); MessageContent.InnerHtml = GetLocalResourceObject("UpdateError33").ToString(); } else if (iResult == 2) { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError22").ToString(); MessageContent.InnerHtml = GetLocalResourceObject("UpdateError22").ToString(); } else { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError1").ToString(); MessageContent.InnerHtml = GetLocalResourceObject("UpdateError1").ToString(); } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); if (iResult == 1) { return true; } else { return false; } }
public static HotelInfoEntity CommonProvincialSelect(HotelInfoEntity hotelInfoEntity) { hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_common_provinciallist", false); return hotelInfoEntity; }
public void getHotelLists() { messageContent.InnerHtml = ""; DataTable dtResult = new DataTable(); HotelInfoEntity _hotelinfoEntity = new HotelInfoEntity(); _hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); string strOrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); string strfaxNum = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxNum"].ToString())) ? null : ViewState["FaxNum"].ToString(); if (!String.IsNullOrEmpty(strOrderID) || !String.IsNullOrEmpty(strfaxNum)) { //hotelInfoDBEntity.Type = ddpSort.SelectedValue; hotelInfoDBEntity.OrderID = strOrderID; hotelInfoDBEntity.FaxNum = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxNum"].ToString())) ? null : ViewState["FaxNum"].ToString(); //hotelInfoDBEntity.OutStartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); //hotelInfoDBEntity.OutEndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); dtResult = HotelInfoBP.GetOrderApproveHotelFaxList(_hotelinfoEntity).QueryResult.Tables[0]; if (dtResult.Rows.Count == 0) { messageContent.InnerHtml = "无订单审核,请确认!"; } } else if (!String.IsNullOrEmpty(hidSelectCity.Value) || !String.IsNullOrEmpty(hidSelectHotel.Value) || !String.IsNullOrEmpty(hidSelectBussiness.Value)) { if (!String.IsNullOrEmpty(hidSelectHotel.Value)) { if (!hidSelectHotel.Value.Trim().Contains("[") || !hidSelectHotel.Value.Trim().Contains("]")) { messageContent.InnerHtml = "查询失败,选择酒店不合法,请修改!"; ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "updateScript", "BtnCompleteStyle();", true); return; } } if (!String.IsNullOrEmpty(hidSelectCity.Value)) { if (!hidSelectCity.Value.Trim().Contains("[") || !hidSelectCity.Value.Trim().Contains("]")) { messageContent.InnerHtml = "查询失败,选择城市不合法,请修改!"; ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "updateScript", "BtnCompleteStyle();", true); return; } } if (!String.IsNullOrEmpty(hidSelectBussiness.Value)) { if (!hidSelectBussiness.Value.Trim().Contains("[") || !hidSelectBussiness.Value.Trim().Contains("]")) { messageContent.InnerHtml = "查询失败,选择商圈不合法,请修改!"; ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "updateScript", "BtnCompleteStyle();", true); return; } } string OutStartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); string OutEndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); if (String.IsNullOrEmpty(OutStartDate) && String.IsNullOrEmpty(OutEndDate)) { messageContent.InnerHtml = "查询失败,请选择离店日期!"; ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "updateScript", "BtnCompleteStyle();", true); return; } //ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "setsalesroomKeysOne", "SetSalesRoom('')", true); hotelInfoDBEntity.City = hidSelectCity.Value == "" ? "" : hidSelectCity.Value.Substring((hidSelectCity.Value.IndexOf('[') + 1), (hidSelectCity.Value.IndexOf(']') - 1)); //"";//城市ID hotelInfoDBEntity.HotelID = hidSelectHotel.Value == "" ? "" : hidSelectHotel.Value.Substring((hidSelectHotel.Value.IndexOf('[') + 1), (hidSelectHotel.Value.IndexOf(']') - 1));//"";//酒店ID hotelInfoDBEntity.Bussiness = hidSelectBussiness.Value == "" ? "" : hidSelectBussiness.Value.Substring((hidSelectBussiness.Value.IndexOf('[') + 1), (hidSelectBussiness.Value.IndexOf(']') - 1));//"";//商圈ID //hotelInfoDBEntity.Type = ddpSort.SelectedValue; //hotelInfoDBEntity.InDateFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); //hotelInfoDBEntity.InDateTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); hotelInfoDBEntity.OutStartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); hotelInfoDBEntity.OutEndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); //hotelInfoDBEntity.OutDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutDateTime"].ToString())) ? null : ViewState["OutDateTime"].ToString(); hotelInfoDBEntity.OrderID = strOrderID; hotelInfoDBEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); hotelInfoDBEntity.ADStatsBack = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["ADStatsBack"].ToString())) ? null : ViewState["ADStatsBack"].ToString(); hotelInfoDBEntity.FaxNum = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxNum"].ToString())) ? null : ViewState["FaxNum"].ToString(); hotelInfoDBEntity.FaxStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxStatus"].ToString())) ? null : ViewState["FaxStatus"].ToString(); _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); dtResult = HotelInfoBP.GetOrderApproveHotelFaxList(_hotelinfoEntity).QueryResult.Tables[0]; if (dtResult.Rows.Count == 0) { messageContent.InnerHtml = "无订单审核,请确认!"; } } else { if (this.hidSelectSalesID.Value != UserSession.Current.UserAccount) { if (String.IsNullOrEmpty(this.hidSelectSalesID.Value.Trim())) { messageContent.InnerHtml = "查询失败,选择用户不合法,请修改!"; ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "updateScript", "BtnCompleteStyle();", true); return; } if (!hidSelectSalesID.Value.Trim().Contains("[") || !hidSelectSalesID.Value.Trim().Contains("]")) { messageContent.InnerHtml = "查询失败,选择用户不合法,请修改!"; ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "updateScript", "BtnCompleteStyle();", true); return; } } string OutStartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); string OutEndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); if (String.IsNullOrEmpty(OutStartDate) && String.IsNullOrEmpty(OutEndDate)) { messageContent.InnerHtml = "查询失败,请选择离店日期!"; ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "updateScript", "BtnCompleteStyle();", true); return; } ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "setsalesroomKeysOne", "SetSalesRoom('" + this.hidSelectSalesID.Value + "')", true); hotelInfoDBEntity.SalesID = this.hidSelectSalesID.Value == UserSession.Current.UserAccount ? UserSession.Current.UserAccount : this.hidSelectSalesID.Value.Substring((this.hidSelectSalesID.Value.IndexOf('[') + 1), (this.hidSelectSalesID.Value.IndexOf(']') - 1));//"";//房控人员 if (!CheckApproveUser(hotelInfoDBEntity.SalesID, 1)) { ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "updateScript", "BtnCompleteStyle();", true); return; } //hotelInfoDBEntity.Type = ddpSort.SelectedValue; //hotelInfoDBEntity.InDateFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); //hotelInfoDBEntity.InDateTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); hotelInfoDBEntity.OrderID = strOrderID; hotelInfoDBEntity.OutStartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); hotelInfoDBEntity.OutEndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); //hotelInfoDBEntity.OutDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutDateTime"].ToString())) ? null : ViewState["OutDateTime"].ToString(); hotelInfoDBEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); hotelInfoDBEntity.ADStatsBack = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["ADStatsBack"].ToString())) ? null : ViewState["ADStatsBack"].ToString(); hotelInfoDBEntity.FaxStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxStatus"].ToString())) ? null : ViewState["FaxStatus"].ToString(); _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); dtResult = HotelInfoBP.GetOrderFaxApproveList(_hotelinfoEntity).QueryResult.Tables[0];//得到当天所有 有计划 的酒店 if (dtResult.Rows.Count == 0) { messageContent.InnerHtml = "该审核人员绑定酒店无订单审核,请确认!"; } } dtResult.DefaultView.Sort = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SortID"].ToString())) ? "" : ViewState["SortID"].ToString(); this.gridHotelList.DataSource = dtResult.DefaultView; this.gridHotelList.DataBind(); //int UADCUN = 0; //int ADCUN = 0; ////int BCUN = 0; //for (int i = 0; i < gridHotelList.Rows.Count; i++) //{ // //首先判断是否是数据行 // if (gridHotelList.Rows[i].RowType == DataControlRowType.DataRow) // { // UADCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[4].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[4].ToString()); // ADCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[5].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[5].ToString()); // //BCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[6].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[6].ToString()); // if (UADCUN == ADCUN) // { // gridHotelList.Rows[i].Cells[0].Attributes.Add("bgcolor", "#70A88C"); // gridHotelList.Rows[i].Cells[1].Attributes.Add("bgcolor", "#70A88C"); // //gridHotelList.Rows[i].Attributes.Add("bgcolor", "#70A88C"); // } // //else if (BCUN > 0) // //{ // // gridHotelList.Rows[i].Cells[0].Attributes.Add("bgcolor", "#94FB92"); // // gridHotelList.Rows[i].Cells[1].Attributes.Add("bgcolor", "#94FB92"); // // //gridHotelList.Rows[i].Attributes.Add("bgcolor", "#94FB92"); // //} // } //} gridViewCSList.DataSource = null; gridViewCSList.DataBind(); this.UpdatePanel1.Update(); string strOrderCount = dtResult.Rows.Count > 0 ? dtResult.Compute("SUM(ordercount)", "").ToString() : "0"; this.countNum.InnerText = dtResult.Rows.Count.ToString() + "/" + strOrderCount; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "keys", "BtnCompleteStyle();", true); }
public static HotelInfoEntity CommonHotelGroupSelect(HotelInfoEntity hotelInfoEntity) { hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_common_hotelgrouplist", false); return hotelInfoEntity; }
public static DataSet ClearDApproveData(HotelInfoEntity hotelInfoEntity, DataSet dsHotel, DataSet dsOrder) { HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); if (dsHotel.Tables.Count > 0 && dsHotel.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dbParm.ADStatsBack)) { for (int i = dsHotel.Tables[0].Rows.Count - 1; i >= 0; i--) { if (!RefushDApproveData(hotelInfoEntity, dsHotel.Tables[0].Rows[i], dsOrder)) { dsHotel.Tables[0].Rows.RemoveAt(i); } } } return dsHotel; }
public static bool chkInserBed(HotelInfoEntity hotelInfoEntity) { HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); OracleParameter[] dlmParm ={ new OracleParameter("BEDCD",OracleType.VarChar), new OracleParameter("BEDNM",OracleType.VarChar) }; dlmParm[0].Value = dbParm.BedCode; dlmParm[1].Value = dbParm.BedName; DataSet dsResult = DbManager.Query("HotelInfo", "t_room_bed_inser_check", false, dlmParm); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { return false; } return true; }
public static HotelInfoEntity GetConsultRoomHotelRoomList(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("SALES",OracleType.VarChar), new OracleParameter("EXTIME",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); if (String.IsNullOrEmpty(dbParm.SalesID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.SalesID; ; } if (String.IsNullOrEmpty(dbParm.EffectDate)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.EffectDate; ; } string SqlString = XmlSqlAnalyze.GotSqlTextFromXml("HotelInfo", "t_lm_b_hotelconsulting_roomtable"); //if (!String.IsNullOrEmpty(dbParm.Type)) //{ // SqlString = SqlString + dbParm.Type; //} hotelInfoEntity.QueryResult = DbHelperOra.Query(SqlString, true, parm); return hotelInfoEntity; //hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_hotelconsulting_roomtable", true, parm); //return hotelInfoEntity; }
public static int CheckSupInsert(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELNM",OracleType.VarChar), new OracleParameter("TEL",OracleType.VarChar), new OracleParameter("FAX",OracleType.VarChar), new OracleParameter("ADDRESS",OracleType.VarChar), new OracleParameter("LONGITUDE",OracleType.VarChar), new OracleParameter("LATITUDE",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); parm[0].Value = dbParm.Name_CN; parm[1].Value = dbParm.Phone; parm[2].Value = dbParm.Fax; parm[3].Value = dbParm.AddRess; parm[4].Value = dbParm.Longitude; parm[5].Value = dbParm.Latitude; hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "t_lm_b_hotelinfo_supinsertcheck", false, parm); if (hotelInfoEntity.QueryResult.Tables.Count > 0 && hotelInfoEntity.QueryResult.Tables[0].Rows.Count > 0) { return 1; } return 0; }
private void BindBalManagerListGrid() { _hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); hotelInfoDBEntity.HotelID = hidHotelID.Value; hotelInfoDBEntity.HRoomList = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BalRoomCD"].ToString())) ? null : ViewState["BalRoomCD"].ToString(); hotelInfoDBEntity.InDateFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BalStartDT"].ToString())) ? null : ViewState["BalStartDT"].ToString(); hotelInfoDBEntity.InDateTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BalEndDT"].ToString())) ? null : ViewState["BalEndDT"].ToString(); _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); _hotelinfoEntity = HotelInfoBP.GetBalanceRoomHistory(_hotelinfoEntity); DataSet dsResult = _hotelinfoEntity.QueryResult; hidLMCount.Value = _hotelinfoEntity.LMCount.ToString(); hidLM2Count.Value = _hotelinfoEntity.LM2Count.ToString(); hidColsNM.Value = _hotelinfoEntity.Cols; //gridViewCSBalList.DataSource = dsResult.Tables[0].DefaultView; //gridViewCSBalList.DataKeyNames = new string[] { "ID" };//主键 //gridViewCSBalList.DataBind(); //for (int i = 0; i < gridViewCSBalList.Rows.Count; i++) //{ // for (int j = 0; j < dsResult.Tables[0].Columns.Count; j++) // { // gridViewCSBalList.Rows[i].Cells[j].HorizontalAlign = HorizontalAlign.Center; // } //} }
public static int DeleteLMSalesHistory(HotelInfoEntity hotelInfoEntity) { HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); OracleParameter[] dlmParm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("SALESID",OracleType.VarChar) }; dlmParm[0].Value = dbParm.HotelID; if (String.IsNullOrEmpty(dbParm.SalesID)) { dlmParm[1].Value = DBNull.Value; } else { dlmParm[1].Value = dbParm.SalesID; } DbManager.ExecuteSql("HotelInfo", "t_lm_sales_history_delete", dlmParm); return 1; }
public void GetBasicOrderAprInfo(string strHotelID) { HotelInfoEntity _hotelinfoEntity = new HotelInfoEntity(); _hotelinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEntity.HotelInfoDBEntity = new List<HotelInfoDBEntity>(); HotelInfoDBEntity hotelInfoDBEntity = new HotelInfoDBEntity(); hotelInfoDBEntity.HotelID = strHotelID; _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); DataSet dsResult = HotelInfoBP.SelectHotelInfoEX(_hotelinfoEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { //日/夜审 if (dsResult.Tables[0].Rows[0]["Ex_Mode"].ToString() == "1") { this.rdOrderVerifyTypeFax.Checked = true; this.rdOrderVerifyTypeTel.Checked = false; } else { this.rdOrderVerifyTypeFax.Checked = false; this.rdOrderVerifyTypeTel.Checked = true; } //审核方式 if (dsResult.Tables[0].Rows[0]["Ex_Time"].ToString() == "000000000111111111100000") { this.rdOrderVerifyTimeDay.Checked = true; this.rdOrderVerifyTimeNight.Checked = false; } else { this.rdOrderVerifyTimeDay.Checked = false; this.rdOrderVerifyTimeNight.Checked = true; } if (dsResult.Tables[0].Rows[0]["Ex_Time"].ToString() == "000000000111111111100000") { //审核联系人 this.txtOrderVerifyLinkMan.Text = (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["LINKMAN"].ToString())) ? "" : dsResult.Tables[0].Rows[0]["LINKMAN"].ToString().Split('|')[10].ToString(); //审核联系电话 this.txtOrderVerifyLinkTel.Text = (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["LINKTEL"].ToString())) ? "" : dsResult.Tables[0].Rows[0]["LINKTEL"].ToString().Split('|')[10].ToString(); //审核联系传真 this.txtOrderVerifyLinkFax.Text = (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["LINKFAX"].ToString())) ? "" : dsResult.Tables[0].Rows[0]["LINKFAX"].ToString().Split('|')[10].ToString(); } else { //审核联系人 this.txtOrderVerifyLinkMan.Text = (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["LINKMAN"].ToString())) ? "" : dsResult.Tables[0].Rows[0]["LINKMAN"].ToString().Split('|')[0].ToString(); //审核联系电话 this.txtOrderVerifyLinkTel.Text = (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["LINKTEL"].ToString())) ? "" : dsResult.Tables[0].Rows[0]["LINKTEL"].ToString().Split('|')[0].ToString(); //审核联系传真 this.txtOrderVerifyLinkFax.Text = (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["LINKFAX"].ToString())) ? "" : dsResult.Tables[0].Rows[0]["LINKFAX"].ToString().Split('|')[0].ToString(); } //审核备注 this.txtOrderVerifyRemark.InnerHtml = dsResult.Tables[0].Rows[0]["REMARK"].ToString(); } else { rdOrderVerifyTimeDay.Checked = false; rdOrderVerifyTimeNight.Checked = false; rdOrderVerifyTypeFax.Checked = false; rdOrderVerifyTypeTel.Checked = false; txtOrderVerifyLinkMan.Text = ""; txtOrderVerifyLinkTel.Text = ""; txtOrderVerifyLinkFax.Text = ""; txtOrderVerifyRemark.Value = ""; } }
public static bool chkDApproveData(HotelInfoEntity hotelInfoEntity, DataRow drRow) { HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); string LDStatus = string.Empty; string NSStatus = string.Empty; string LDdbAppr = string.Empty; string NSdbAppr = string.Empty; string ADStatsBack = (String.IsNullOrEmpty(dbParm.ADStatsBack)) ? "" : dbParm.ADStatsBack; if (ADStatsBack.Contains("1") || ADStatsBack.Contains("3")) { LDStatus = "离店"; } if (ADStatsBack.Contains("2") || ADStatsBack.Contains("4")) { NSStatus = "No-Show"; } if (ADStatsBack.Contains("1")) { LDdbAppr = "0"; } else if (ADStatsBack.Contains("3")) { LDdbAppr = "1"; } if (ADStatsBack.Contains("2")) { NSdbAppr = "0"; } else if (ADStatsBack.Contains("4")) { NSdbAppr = "1"; } OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _orderInfoEntity.OrderInfoDBEntity = new List<OrderInfoDBEntity>(); OrderInfoDBEntity orderinfoEntity = new OrderInfoDBEntity(); orderinfoEntity.HotelID = drRow["prop"].ToString(); orderinfoEntity.OutDate = dbParm.OutDate; orderinfoEntity.OrderID = dbParm.OrderID; orderinfoEntity.AuditStatus = dbParm.AuditStatus; orderinfoEntity.ADStatsBack = dbParm.ADStatsBack; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsOrders = OrderInfoDA.BindOrderApproveFaxList(_orderInfoEntity).QueryResult; DataSet dsResult = new DataSet(); for (int i = dsOrders.Tables[0].Rows.Count - 1; i >= 0; i--) { if ("未审核".Equals(dsOrders.Tables[0].Rows[i]["ORDERST"].ToString())) { continue; } if (!String.IsNullOrEmpty(ADStatsBack)) { DataCommand cmd = DataCommandManager.GetDataCommand("ChkApproveOrderList"); cmd.SetParameterValue("@ORDERID", dsOrders.Tables[0].Rows[i]["ORDERID"].ToString()); dsResult = cmd.ExecuteDataSet(); if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { dsOrders.Tables[0].Rows.RemoveAt(i); } else { if ("离店".Equals(dsResult.Tables[0].Rows[0]["OD_STATUS"].ToString())) { if (!(!String.IsNullOrEmpty(LDStatus) && LDdbAppr.Equals(dsResult.Tables[0].Rows[0]["ISDBAPPROVE"].ToString()))) { dsOrders.Tables[0].Rows.RemoveAt(i); } } else if ("No-Show".Equals(dsResult.Tables[0].Rows[0]["OD_STATUS"].ToString())) { if (!(!String.IsNullOrEmpty(NSStatus) && NSdbAppr.Equals(dsResult.Tables[0].Rows[0]["ISDBAPPROVE"].ToString()))) { dsOrders.Tables[0].Rows.RemoveAt(i); } } else { dsOrders.Tables[0].Rows.RemoveAt(i); } } } } if (dsOrders.Tables.Count > 0 && dsOrders.Tables[0].Rows.Count > 0) { return true; } else { return false; } }
public static HotelInfoEntity CountHotelOnlineLb(HotelInfoEntity hotelInfoEntity) { OracleParameter[] parm ={ new OracleParameter("HotelID",OracleType.VarChar), new OracleParameter("EffectDate",OracleType.VarChar), new OracleParameter("CityID",OracleType.VarChar), new OracleParameter("AreaID",OracleType.VarChar) }; HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); parm[0].Value = dbParm.HotelID; parm[1].Value = dbParm.EffectDate; parm[2].Value = dbParm.City; parm[3].Value = dbParm.AreaID; hotelInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfo", "CountHotelOnlineLb", false, parm); return hotelInfoEntity; }
public static HotelInfoEntity CreateHotelInfo(HotelInfoEntity hotelInfoEntity) { if (hotelInfoEntity.HotelInfoDBEntity.Count == 0) { hotelInfoEntity.Result = 0; return hotelInfoEntity; } if (hotelInfoEntity.LogMessages == null) { hotelInfoEntity.Result = 0; return hotelInfoEntity; } if (CheckSupInsert(hotelInfoEntity) > 0) { hotelInfoEntity.Result = 2; return hotelInfoEntity; } if (CheckSupCity(hotelInfoEntity) <= 0) { hotelInfoEntity.Result = 3; return hotelInfoEntity; } List<CommandInfo> sqlList = new List<CommandInfo>(); HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); CommandInfo InsertLmbPropInfo = new CommandInfo(); OracleParameter[] lmParm ={ new OracleParameter("HOTELNM",OracleType.VarChar), new OracleParameter("HOTELEN",OracleType.VarChar), new OracleParameter("CITYID",OracleType.VarChar), new OracleParameter("STARRATING",OracleType.VarChar), new OracleParameter("DIAMONDRATING",OracleType.VarChar), new OracleParameter("ADDRESS",OracleType.VarChar), new OracleParameter("FAX",OracleType.VarChar), new OracleParameter("LONGITUDE",OracleType.VarChar), new OracleParameter("LATITUDE",OracleType.VarChar), new OracleParameter("CONTACTEMAIL",OracleType.VarChar), new OracleParameter("OPENDATE",OracleType.VarChar), new OracleParameter("REPAIRDATE",OracleType.VarChar), new OracleParameter("SIMPLEDESCZH",OracleType.VarChar), new OracleParameter("DESCZH",OracleType.VarChar), new OracleParameter("STATUSID",OracleType.VarChar), new OracleParameter("HOTELPN",OracleType.VarChar), new OracleParameter("TOTALROOMS",OracleType.VarChar), new OracleParameter("HOTELJP",OracleType.VarChar), new OracleParameter("ZIP",OracleType.VarChar), new OracleParameter("PRICELOW",OracleType.VarChar), new OracleParameter("CONTACTPER",OracleType.VarChar), new OracleParameter("CONTACTPHONE",OracleType.VarChar), new OracleParameter("PHONE",OracleType.VarChar), new OracleParameter("HOTELID",OracleType.Int32), new OracleParameter("EVALUATION",OracleType.VarChar), new OracleParameter("HOTELREMARK",OracleType.VarChar), new OracleParameter("WEBSITE",OracleType.VarChar), new OracleParameter("BDLONGITUDE",OracleType.VarChar), new OracleParameter("BDLATITUDE",OracleType.VarChar), new OracleParameter("KEYWORDS",OracleType.VarChar), new OracleParameter("HOTELGROUP",OracleType.VarChar), new OracleParameter("ISMYHOTEL",OracleType.VarChar) }; lmParm[0].Value = dbParm.Name_CN; lmParm[1].Value = dbParm.Name_EN; lmParm[2].Value = dbParm.City; lmParm[3].Value = dbParm.StarRating.Split('|')[0].ToString().Trim(); lmParm[4].Value = dbParm.StarRating.Split('|')[1].ToString().Trim(); lmParm[5].Value = dbParm.AddRess; lmParm[6].Value = dbParm.Fax; lmParm[7].Value = dbParm.Longitude; lmParm[8].Value = dbParm.Latitude; lmParm[9].Value = dbParm.ContactEmail; lmParm[10].Value = dbParm.OpenDate; lmParm[11].Value = dbParm.RepairDate; lmParm[12].Value = dbParm.SimpleDescZh; lmParm[13].Value = dbParm.DescZh; lmParm[14].Value = dbParm.Status; lmParm[15].Value = dbParm.HotelPN; lmParm[16].Value = dbParm.TotalRooms; lmParm[17].Value = dbParm.HotelJP; lmParm[18].Value = dbParm.Zip; lmParm[19].Value = dbParm.PriceLow; lmParm[20].Value = dbParm.ContactPer; lmParm[21].Value = dbParm.ContactPhone; lmParm[22].Value = dbParm.Phone; lmParm[23].Value = getMaxIDfromSeq("T_LM_B_PROP_SEQ"); lmParm[24].Value = dbParm.Evaluation; //lmParm[25].Value = dbParm.HotelRemark; if (string.IsNullOrEmpty(dbParm.HotelRemark)) { lmParm[25].Value = DBNull.Value; }else { lmParm[25].Value = dbParm.HotelRemark; } lmParm[26].Value = dbParm.WebSite; lmParm[27].Value = dbParm.BDLongitude; lmParm[28].Value = dbParm.BDLatitude; lmParm[29].Value = dbParm.KeyWords; lmParm[30].Value = dbParm.HotelGroup; lmParm[31].Value = dbParm.IsMyHotel; //lmParm[9].Value = dbParm.Bussiness; //DbManager.ExecuteSql("HotelInfo", "t_lm_b_suphotelinfo_insert", lmParm); InsertLmbPropInfo.SqlName = "HotelInfo"; InsertLmbPropInfo.SqlId = "t_lm_b_createhotelinfo_insert"; InsertLmbPropInfo.Parameters = lmParm; sqlList.Add(InsertLmbPropInfo); CommandInfo InsertLmbBussInfo = new CommandInfo(); OracleParameter[] lmBussParm ={ new OracleParameter("HOTELID",OracleType.VarChar) }; lmBussParm[0].Value = lmParm[23].Value; InsertLmbBussInfo.SqlName = "HotelInfo"; InsertLmbBussInfo.SqlId = "t_lm_b_fvphotelbussinfo_insert"; InsertLmbBussInfo.Parameters = lmBussParm; sqlList.Add(InsertLmbBussInfo); if (!String.IsNullOrEmpty(dbParm.Bussiness)) { string strAreaID = ""; string[] strBusList = dbParm.Bussiness.Split(','); foreach (string par in strBusList) { strAreaID = (par.IndexOf("]") >= 0) ? par.Substring((par.IndexOf('[') + 1), (par.IndexOf(']') - 1)) : ""; if (String.IsNullOrEmpty(strAreaID)) { continue; } CommandInfo InsertLmbAreaInfo = new CommandInfo(); OracleParameter[] lmAreaParm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("AREAID",OracleType.VarChar) }; lmAreaParm[0].Value = lmParm[23].Value; lmAreaParm[1].Value = strAreaID; InsertLmbAreaInfo.SqlName = "HotelInfo"; InsertLmbAreaInfo.SqlId = "t_lm_b_suphotelareainfo_insert"; InsertLmbAreaInfo.Parameters = lmAreaParm; sqlList.Add(InsertLmbAreaInfo); } } DbManager.ExecuteSqlTran(sqlList); hotelInfoEntity.Result = 1; hotelInfoEntity.ErrorMSG = lmParm[23].Value.ToString(); return hotelInfoEntity; }