public static ELRelationEntity HVPAreaSelect(ELRelationEntity ELRelationEntity) { ELRelationEntity.LogMessages.MsgType = MessageType.INFO; ELRelationEntity.LogMessages.Content = _nameSpaceClass + "HVPAreaSelect"; LoggerHelper.LogWriter(ELRelationEntity.LogMessages); try { return ELRelationDA.HVPAreaSelect(ELRelationEntity); } catch (Exception ex) { ELRelationEntity.LogMessages.MsgType = MessageType.ERROR; ELRelationEntity.LogMessages.Content = _nameSpaceClass + "HVPAreaSelect Error: " + ex.Message; LoggerHelper.LogWriter(ELRelationEntity.LogMessages); throw ex; } }
//[WebMethod] //public static void SetHotelRoomMappingList(string HidRowID) //{ // ddpRoomList = new DataSet(); // ddpRoomList.Tables.Add(new DataTable()); // ddpRoomList.Tables[0].Columns.Add("SUPID"); // ddpRoomList.Tables[0].Columns.Add("SUPNM"); // dsMappingRoomList = new DataSet(); // dsMappingRoomList.Tables.Add(new DataTable()); // dsMappingRoomList.Tables[0].Columns.Add("ROOMCD"); // dsMappingRoomList.Tables[0].Columns.Add("ROOMNM"); // dsMappingRoomList.Tables[0].Columns.Add("SOURCES"); // ELRelationEntity _elRelationEntity = new ELRelationEntity(); // _elRelationEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); // _elRelationEntity.LogMessages.Userid = UserSession.Current.UserAccount; // _elRelationEntity.LogMessages.Username = UserSession.Current.UserDspName; // _elRelationEntity.LogMessages.IpAddress = UserSession.Current.UserIP; // _elRelationEntity.ELRelationDBEntity = new List<ELRelationDBEntity>(); // ELRelationDBEntity usergroupEntity = new ELRelationDBEntity(); // usergroupEntity.HVPID = HidRowID; // _elRelationEntity.ELRelationDBEntity.Add(usergroupEntity); // DataSet dsResult = ELRelationBP.SaSupHotelMappingDetail(_elRelationEntity).QueryResult; // for (int i = 0; i < dsResult.Tables["Master"].Rows.Count; i++) // { // DataRow dr = ddpRoomList.Tables[0].NewRow(); // dr["SUPNM"] = dsResult.Tables["Master"].Rows[i]["SUPNM"].ToString(); // dr["SUPID"] = dsResult.Tables["Master"].Rows[i]["SOURCES"].ToString(); // ddpRoomList.Tables[0].Rows.Add(dr); // } // if (dsResult.Tables.Count > 1 && dsResult.Tables["Detail"].Rows.Count > 0) // { // for (int i = 0; i < dsResult.Tables["Detail"].Rows.Count; i++) // { // DataRow dr = dsMappingRoomList.Tables[0].NewRow(); // dr["ROOMCD"] = dsResult.Tables["Detail"].Rows[i]["ROOMCD"].ToString(); // dr["ROOMNM"] = dsResult.Tables["Detail"].Rows[i]["ROOMNM"].ToString(); // dr["SOURCES"] = dsResult.Tables["Detail"].Rows[i]["SOURCES"].ToString(); // dsMappingRoomList.Tables[0].Rows.Add(dr); // } // } //} public void SetHotelRoomMappingList(string HidRowID) { ddpRoomList = new DataSet(); ddpRoomList.Tables.Add(new DataTable()); ddpRoomList.Tables[0].Columns.Add("SUPID"); ddpRoomList.Tables[0].Columns.Add("SUPNM"); dsMappingRoomList = new DataSet(); dsMappingRoomList.Tables.Add(new DataTable()); dsMappingRoomList.Tables[0].Columns.Add("ROOMCD"); dsMappingRoomList.Tables[0].Columns.Add("ROOMNM"); dsMappingRoomList.Tables[0].Columns.Add("SOURCES"); ELRelationEntity _elRelationEntity = new ELRelationEntity(); _elRelationEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _elRelationEntity.LogMessages.Userid = UserSession.Current.UserAccount; _elRelationEntity.LogMessages.Username = UserSession.Current.UserDspName; _elRelationEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _elRelationEntity.ELRelationDBEntity = new List<ELRelationDBEntity>(); ELRelationDBEntity usergroupEntity = new ELRelationDBEntity(); usergroupEntity.HVPID = HidRowID; _elRelationEntity.ELRelationDBEntity.Add(usergroupEntity); DataSet dsResult = ELRelationBP.SaSupHotelMappingDetail(_elRelationEntity).QueryResult; for (int i = 0; i < dsResult.Tables["Master"].Rows.Count; i++) { DataRow dr = ddpRoomList.Tables[0].NewRow(); dr["SUPNM"] = dsResult.Tables["Master"].Rows[i]["SUPNM"].ToString(); dr["SUPID"] = dsResult.Tables["Master"].Rows[i]["SOURCES"].ToString(); ddpRoomList.Tables[0].Rows.Add(dr); } if (dsResult.Tables.Count > 1 && dsResult.Tables["Detail"].Rows.Count > 0) { for (int i = 0; i < dsResult.Tables["Detail"].Rows.Count; i++) { DataRow dr = dsMappingRoomList.Tables[0].NewRow(); dr["ROOMCD"] = dsResult.Tables["Detail"].Rows[i]["ROOMCD"].ToString(); dr["ROOMNM"] = dsResult.Tables["Detail"].Rows[i]["ROOMNM"].ToString(); dr["SOURCES"] = dsResult.Tables["Detail"].Rows[i]["SOURCES"].ToString(); dsMappingRoomList.Tables[0].Rows.Add(dr); } } ViewState["ddpRoomList"] = ddpRoomList; ViewState["dsMappingRoomList"] = dsMappingRoomList; }
public static ELRelationEntity ReviewSupRoomMappingDetail(ELRelationEntity ELRelationEntity) { ELRelationEntity.LogMessages.MsgType = MessageType.INFO; ELRelationEntity.LogMessages.Content = _nameSpaceClass + "ReviewSupRoomMappingDetail"; LoggerHelper.LogWriter(ELRelationEntity.LogMessages); try { return ELRelationDA.ReviewSupRoomMappingDetail(ELRelationEntity); } catch (Exception ex) { ELRelationEntity.LogMessages.MsgType = MessageType.ERROR; ELRelationEntity.LogMessages.Content = _nameSpaceClass + "ReviewSupRoomMappingDetail Error: " + ex.Message; LoggerHelper.LogWriter(ELRelationEntity.LogMessages); throw ex; } }
public static ELRelationEntity SaSupHotelMappingDetail(ELRelationEntity ELRelationEntity) { ELRelationEntity.LogMessages.MsgType = MessageType.INFO; ELRelationEntity.LogMessages.Content = _nameSpaceClass + "SaSupHotelMappingDetail"; LoggerHelper.LogWriter(ELRelationEntity.LogMessages); try { DataSet dsResult = new DataSet(); DataTable dtMaster = new DataTable(); DataTable dtDetail = new DataTable(); dtMaster = ELRelationDA.SaSupHotelMappingDetail(ELRelationEntity).Tables[0].Copy(); dtMaster.TableName = "Master"; DataSet dstemp = HotelInfoSA.GetSupRoomList(dtMaster); dtDetail = dstemp.Tables[0].Copy(); dtDetail.TableName = "Detail"; dsResult.Tables.Add(dtMaster); dsResult.Tables.Add(dtDetail); ELRelationEntity.QueryResult = dsResult; return ELRelationEntity; } catch (Exception ex) { ELRelationEntity.LogMessages.MsgType = MessageType.ERROR; ELRelationEntity.LogMessages.Content = _nameSpaceClass + "SaSupHotelMappingDetail Error: " + ex.Message; LoggerHelper.LogWriter(ELRelationEntity.LogMessages); throw ex; } }
public static ELRelationEntity UpdateSUPRoomList(ELRelationEntity elrelationEntity) { ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (!ChkSUPRoomInsert(elrelationEntity)) { elrelationEntity.Result = 2; return elrelationEntity; } if ("0".Equals(dbParm.SupType)) { OracleParameter[] parm ={ new OracleParameter("APPROOM",OracleType.VarChar), new OracleParameter("SUPROOM",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("INUSE",OracleType.VarChar), new OracleParameter("APPHOTELID",OracleType.VarChar), new OracleParameter("SUPHOTELID",OracleType.VarChar), new OracleParameter("OSOURCE",OracleType.VarChar), new OracleParameter("OSUPROOM",OracleType.VarChar), new OracleParameter("OSUPHOTELID",OracleType.VarChar) }; string strSupHRID = dbParm.ELongID; if (String.IsNullOrEmpty(dbParm.RoomCD)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.RoomCD; } if (String.IsNullOrEmpty(strSupHRID)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = strSupHRID.Split('_')[1].ToString(); } if (String.IsNullOrEmpty(dbParm.Source)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.InUse)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.InUse; } if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(strSupHRID)) { parm[5].Value = DBNull.Value; } else { parm[5].Value = strSupHRID.Split('_')[0].ToString(); } if (String.IsNullOrEmpty(dbParm.OSource)) { parm[6].Value = DBNull.Value; } else { parm[6].Value = dbParm.OSource; } string strOSuphid = dbParm.OSuphid; if (String.IsNullOrEmpty(strOSuphid)) { parm[7].Value = DBNull.Value; } else { parm[7].Value = strOSuphid.Split('_')[1].ToString(); } if (String.IsNullOrEmpty(strOSuphid)) { parm[8].Value = DBNull.Value; } else { parm[8].Value = strOSuphid.Split('_')[0].ToString(); } DbManager.ExecuteSql("ELRelation", "t_fx_sup_hotel_room_update", parm); } else { OracleParameter[] parm ={ new OracleParameter("APPROOM",OracleType.VarChar), new OracleParameter("SUPROOM",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("INUSE",OracleType.VarChar), new OracleParameter("APPHOTELID",OracleType.VarChar), new OracleParameter("SUPHOTELID",OracleType.VarChar) }; string strSupHRID = dbParm.ELongID; if (String.IsNullOrEmpty(dbParm.RoomCD)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.RoomCD; } if (String.IsNullOrEmpty(strSupHRID)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = strSupHRID.Split('_')[1].ToString(); } if (String.IsNullOrEmpty(dbParm.Source)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.InUse)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.InUse; } if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(strSupHRID)) { parm[5].Value = DBNull.Value; } else { parm[5].Value = strSupHRID.Split('_')[0].ToString(); } DbManager.ExecuteSql("ELRelation", "t_fx_sup_hotel_room_create", parm); } UpdateSUPRoomPlanList(elrelationEntity); elrelationEntity.Result = 1; return elrelationEntity; }
public static bool ChkSUPRoomInsert(ELRelationEntity elrelationEntity) { bool bUpdate = true; DataSet dsResult = new DataSet(); ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if ("0".Equals(dbParm.SupType)) { OracleParameter[] parm ={ new OracleParameter("APPROOM",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("APPHOTELID",OracleType.VarChar), new OracleParameter("OROWID",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.RoomCD)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.RoomCD; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.ORowID)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.ORowID; } dsResult = DbManager.Query("ELRelation", "t_fx_sup_hotel_room_update_chk", true, parm); } else { OracleParameter[] parm ={ new OracleParameter("APPROOM",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("APPHOTELID",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.RoomCD)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.RoomCD; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.HVPID; } dsResult = DbManager.Query("ELRelation", "t_fx_sup_hotel_room_create_chk", true, parm); } if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { bUpdate = false; } return bUpdate; }
public static ELRelationEntity UpdateELList(ELRelationEntity elrelationEntity) { OracleParameter[] parm ={ new OracleParameter("HVPID",OracleType.VarChar), new OracleParameter("ELID",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("OSOURCE",OracleType.VarChar) }; ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.ELongID)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.ELongID; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.SupType)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.SupType; } //if (String.IsNullOrEmpty(dbParm.HOTELNM)) //{ // parm[2].Value = DBNull.Value; //} //else //{ // parm[2].Value = dbParm.HOTELNM; //} DbManager.ExecuteSql("ELRelation", "t_fx_hvp_hotel_update", parm); elrelationEntity.Result = 1; return elrelationEntity; }
public static ELRelationEntity HVPAreaSelect(ELRelationEntity elrelationEntity) { OracleParameter[] parm ={ new OracleParameter("HVPHOTELID",OracleType.VarChar), new OracleParameter("CITYNAME",OracleType.VarChar) }; ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.AmountFrom)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.AmountFrom.ToLower(); } //elrelationEntity.Result = DbManager.ExecuteSql("ELRelation", "t_fx_hvp_area_select", parm); elrelationEntity.QueryResult = DbManager.Query("ELRelation", "t_fx_hvp_area_select", true, parm); return elrelationEntity; }
public static ELRelationEntity ReviewSupRoomMappingDetail(ELRelationEntity elrelationEntity) { OracleParameter[] parm ={ new OracleParameter("HVPID",OracleType.VarChar), new OracleParameter("ROOMCD",OracleType.VarChar) }; ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.RoomCD)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.RoomCD; } elrelationEntity.QueryResult = DbManager.Query("ELRelation", "t_sup_hvp_hotel_mapping_room_detail", false , parm); return elrelationEntity; }
public static DataSet SaSupHotelMappingDetail(ELRelationEntity elrelationEntity) { OracleParameter[] parm ={ new OracleParameter("HVPID",OracleType.VarChar) }; ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } return DbManager.Query("ELRelation", "t_sup_hvp_hotel_detail_sa", false, parm); }
public static ELRelationEntity ReviewSupHotelMappingSelectCount(ELRelationEntity elrelationEntity) { OracleParameter[] parm ={ new OracleParameter("HVPID",OracleType.VarChar), new OracleParameter("HVPLP",OracleType.VarChar), new OracleParameter("HVPRP",OracleType.VarChar), new OracleParameter("SALES",OracleType.VarChar) }; ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.HVPLP)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.HVPLP; } if (String.IsNullOrEmpty(dbParm.HVPRP)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.HVPRP; } if (String.IsNullOrEmpty(dbParm.Sales)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.Sales; } elrelationEntity.QueryResult = DbManager.Query("ELRelation", "t_sup_hvp_hotel_select_count", true, parm); return elrelationEntity; }
public static ELRelationEntity ReviewSelect(ELRelationEntity elrelationEntity) { OracleParameter[] parm ={ new OracleParameter("HVPID",OracleType.VarChar), new OracleParameter("HVPLP",OracleType.VarChar) }; ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.HVPLP)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.HVPLP; } elrelationEntity.QueryResult = DbManager.Query("ELRelation", "t_fx_hvp_hotel_select", parm, (elrelationEntity.PageCurrent - 1) * elrelationEntity.PageSize, elrelationEntity.PageSize, false); return elrelationEntity; }
public static ELRelationEntity HVPHotelSelectCircle(ELRelationEntity elrelationEntity) { OracleParameter[] parm ={ new OracleParameter("HVPHOTELID",OracleType.VarChar) }; ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } elrelationEntity.QueryResult = DbManager.Query("ELRelation", "t_fx_hvp_hotel_select_circle", true, parm); return elrelationEntity; }
/// <summary> /// 绑定酒店商圈 /// </summary> public void BindHotelTagIngo() { MessageContent.InnerHtml = ""; ELRelationEntity _ELRelationEntity = new ELRelationEntity(); _ELRelationEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _ELRelationEntity.LogMessages.Userid = UserSession.Current.UserAccount; _ELRelationEntity.LogMessages.Username = UserSession.Current.UserDspName; _ELRelationEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _ELRelationEntity.ELRelationDBEntity = new List<ELRelationDBEntity>(); ELRelationDBEntity elrelationDBEntity = new ELRelationDBEntity(); elrelationDBEntity.HVPID = hidHotelID.Value; _ELRelationEntity.ELRelationDBEntity.Add(elrelationDBEntity); DataTable ds = ELRelationBP.HVPHotelSelectCircle(_ELRelationEntity).QueryResult.Tables[0]; if (ds != null && ds.Rows.Count > 0) { _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; _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); DataSet dsResult = HotelInfoBP.GetTagInfoAERA(_hotelinfoEntity).QueryResult; StringBuilder sb = new StringBuilder(); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++) { sb.Append("<span style='background:#DBEAF9;height:15px;margin-right:10px;background-position: right center;background-repeat: no-repeat'>" + dsResult.Tables[0].Rows[i]["REVALUE_ALL"].ToString() + "</span>"); } } sb.Append("<input type='button' id='Button1' runat='server' class='btn primary' value='修改' onclick='PopupArea()' />"); dvUserGroupList.InnerHtml = sb.ToString(); } else { StringBuilder sb = new StringBuilder(); sb.Append("<span style='color:red'>该酒店未绑定供应商酒店ID,请先绑定再设置商圈</span>"); dvUserGroupList.InnerHtml = sb.ToString(); } }
public static ELRelationEntity UpdateSUPList(ELRelationEntity elrelationEntity) { ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (!ChkSUPListInsert(elrelationEntity)) { elrelationEntity.Result = 2; return elrelationEntity; } if ("0".Equals(dbParm.SupType)) { OracleParameter[] parm ={ new OracleParameter("HVPID",OracleType.VarChar), new OracleParameter("SUPID",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("INUSE",OracleType.VarChar), new OracleParameter("OSOURCE",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.ELongID)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.ELongID; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.InUse)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.InUse; } if (String.IsNullOrEmpty(dbParm.OSource)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.OSource; } DbManager.ExecuteSql("ELRelation", "t_fx_sup_hotel_update", parm); if (!dbParm.Source.Equals(dbParm.OSource) || !dbParm.ELongID.Equals(dbParm.OSupId)) { OracleParameter[] lmparm ={ new OracleParameter("HVPID",OracleType.VarChar), new OracleParameter("SUPID",OracleType.VarChar), new OracleParameter("OSOURCE",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.HVPID)) { lmparm[0].Value = DBNull.Value; } else { lmparm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.OSupId)) { lmparm[1].Value = DBNull.Value; } else { lmparm[1].Value = dbParm.OSupId; } if (String.IsNullOrEmpty(dbParm.OSource)) { lmparm[2].Value = DBNull.Value; } else { lmparm[2].Value = dbParm.OSource; } DbManager.ExecuteSql("ELRelation", "t_fx_sup_hotel_update_for_detail", lmparm); } } else { OracleParameter[] parm ={ new OracleParameter("HVPID",OracleType.VarChar), new OracleParameter("SUPID",OracleType.VarChar), new OracleParameter("SOURCE",OracleType.VarChar), new OracleParameter("INUSE",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.ELongID)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.ELongID; } if (String.IsNullOrEmpty(dbParm.Source)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.Source; } if (String.IsNullOrEmpty(dbParm.InUse)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.InUse; } DbManager.ExecuteSql("ELRelation", "t_fx_sup_hotel_create", parm); } elrelationEntity.Result = 1; return elrelationEntity; }
public bool btnAddData() { MessageContent.InnerHtml = ""; bool bFlag = true; string msgString = ""; #region add 判断是否已和供应商酒店绑定 //因为控件在保存的时候 还是会自动查询 所以 只能重新查询 来判断 ELRelationEntity _ELRelationEntity = new ELRelationEntity(); _ELRelationEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _ELRelationEntity.LogMessages.Userid = UserSession.Current.UserAccount; _ELRelationEntity.LogMessages.Username = UserSession.Current.UserDspName; _ELRelationEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _ELRelationEntity.ELRelationDBEntity = new List<ELRelationDBEntity>(); ELRelationDBEntity elrelationDBEntity = new ELRelationDBEntity(); elrelationDBEntity.HVPID = hidHotelID.Value; _ELRelationEntity.ELRelationDBEntity.Add(elrelationDBEntity); DataTable ds = ELRelationBP.HVPHotelSelectCircle(_ELRelationEntity).QueryResult.Tables[0]; if (ds == null || ds.Rows.Count <= 0) { MessageContent.InnerHtml = "该酒店未绑定供应商酒店ID,请先绑定再设置商圈" + "<br/>"; //bFlag = false; return false; } #endregion #region 编辑酒店各项验证 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 (this.ddpStatusList.SelectedValue == "0")//下线 { if (String.IsNullOrEmpty(this.ddpStatusListRemark.SelectedValue)) { msgString = msgString + GetLocalResourceObject("UpdateErrorDdpStatusListRemark").ToString() + "<br/>"; bFlag = false; } } if (StringUtility.Text_Length(txtHotelNMEN.Text.ToString().Trim()) > 100) { msgString = msgString + GetLocalResourceObject("UpdateError12").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtAddress.Text.ToString().Trim()) > 150) { msgString = msgString + GetLocalResourceObject("UpdateError4").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtWebSite.Text.ToString().Trim()) > 200) { msgString = msgString + GetLocalResourceObject("UpdateError5").ToString() + "<br/>"; bFlag = false; } //if (String.IsNullOrEmpty(txtPhone.Text.ToString().Trim())) //{ // msgString = msgString + GetLocalResourceObject("UpdateError61").ToString() + "<br/>"; // bFlag = false; //} //if (String.IsNullOrEmpty(txtFax.Text.ToString().Trim())) //{ // msgString = msgString + GetLocalResourceObject("UpdateError71").ToString() + "<br/>"; // bFlag = false; //} //if (!String.IsNullOrEmpty(txtPhone.Text.ToString().Trim()) && (StringUtility.Text_Length(txtPhone.Text.ToString().Trim()) > 40 )) //{ // msgString = msgString + GetLocalResourceObject("UpdateError6").ToString() + "<br/>"; // bFlag = false; //} //if (!String.IsNullOrEmpty(txtFax.Text.ToString().Trim()) && (StringUtility.Text_Length(txtFax.Text.ToString().Trim()) > 20 )) //{ // msgString = msgString + GetLocalResourceObject("UpdateError7").ToString() + "<br/>"; // bFlag = false; //} //if (StringUtility.Text_Length(txtContactPer.Text.ToString().Trim()) > 100) //{ // msgString = msgString + GetLocalResourceObject("UpdateError10").ToString() + "<br/>"; // bFlag = false; //} //if (StringUtility.Text_Length(txtContactEmail.Text.ToString().Trim()) > 100) //{ // msgString = msgString + GetLocalResourceObject("UpdateError11").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 (!RegexValidateData(txtLatitude.Text.ToString().Trim()) || !RegexValidateData(txtLongitude.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("UpdateError31").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtSimpleDescZh.Text.ToString().Trim()) && (StringUtility.Text_Length(txtSimpleDescZh.Text.ToString().Trim()) > 600)) { 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("UpdateError81").ToString() + "<br/>"; bFlag = false; } string Evaluation = string.Empty; for (int i = 0; i < this.gridViewEvaluationList.Rows.Count; i++) { TextBox txtBox = (TextBox)gridViewEvaluationList.Rows[i].FindControl("txtEvalist"); if (!ChkEvaContent(txtBox.Text.Trim()))//if (txtBox.Text.Trim().Contains(",") || txtBox.Text.Trim().Contains(",")) { msgString = msgString + GetLocalResourceObject("UpdateError32").ToString() + "<br/>"; bFlag = false; break; } Evaluation = (!string.IsNullOrEmpty(txtBox.Text.Trim())) ? Evaluation + txtBox.Text.Trim() + "," : Evaluation; } Evaluation = (Evaluation.Length > 0) ? Evaluation.Substring(0, Evaluation.Length - 1) : Evaluation; if (!String.IsNullOrEmpty(Evaluation) && (StringUtility.Text_Length(Evaluation) > 1000)) { msgString = msgString + GetLocalResourceObject("UpdateError9").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtUHotelPN.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError115").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtUHotelPN.Text.ToString().Trim()) > 1000) { msgString = msgString + GetLocalResourceObject("CreateError101").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtUTotalRooms.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError102").ToString() + "<br/>"; bFlag = false; } if (!ChkNumber(txtUTotalRooms.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError103").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtUPriceLow.Text.ToString().Trim()) || !ChkNumber(txtUPriceLow.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError117").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtUHotelJP.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError116").ToString() + "<br/>"; bFlag = false; } if (StringUtility.Text_Length(txtUHotelJP.Text.ToString().Trim()) > 1000) { msgString = msgString + GetLocalResourceObject("CreateError104").ToString() + "<br/>"; bFlag = false; } string strCity = hidUCityID.Value.Trim(); if (String.IsNullOrEmpty(strCity.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError105").ToString() + "<br/>"; bFlag = false; } else if (!strCity.Contains("[") && !strCity.Contains("]")) { msgString = msgString + GetLocalResourceObject("CreateError118").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtUHotelFax.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError71").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtUHotelFax.Text.ToString().Trim()) && (StringUtility.Text_Length(txtUHotelFax.Text.ToString().Trim()) > 100)) { msgString = msgString + GetLocalResourceObject("CreateError7").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtURemark.Text.ToString().Trim()) && (StringUtility.Text_Length(txtURemark.Text.ToString().Trim()) > 2000)) { msgString = msgString + GetLocalResourceObject("CreateError91").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtUContactPhone.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError110").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtUContactPhone.Text.ToString().Trim()) && (StringUtility.Text_Length(txtUContactPhone.Text.ToString().Trim()) > 30)) { msgString = msgString + GetLocalResourceObject("CreateError111").ToString() + "<br/>"; bFlag = false; } if (String.IsNullOrEmpty(txtUHotelTel.Text.ToString().Trim())) { msgString = msgString + GetLocalResourceObject("CreateError61").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(txtUHotelTel.Text.ToString().Trim()) && (StringUtility.Text_Length(txtUHotelTel.Text.ToString().Trim()) > 40)) { msgString = msgString + GetLocalResourceObject("CreateError6").ToString() + "<br/>"; bFlag = false; } //if (String.IsNullOrEmpty(txtUContactEmail.Text.ToString().Trim())) //{ // msgString = msgString + GetLocalResourceObject("CreateError113").ToString() + "<br/>"; // bFlag = false; //} if (StringUtility.Text_Length(txtUContactEmail.Text.ToString().Trim()) > 100) { msgString = msgString + GetLocalResourceObject("CreateError11").ToString() + "<br/>"; bFlag = false; } if (!String.IsNullOrEmpty(hidUKeyWords.Value) && (StringUtility.Text_Length(hidUKeyWords.Value.Trim().TrimEnd(',')) > 300)) { msgString = msgString + GetLocalResourceObject("CreateError10").ToString() + "<br/>"; bFlag = false; } if (!hidOnline.Value.Equals(ddpStatusList.SelectedValue) && !chkDaveValEmpty()) { msgString = msgString + GetLocalResourceObject("UpdateError91").ToString() + "<br/>"; bFlag = false; } if (!bFlag) { MessageContent.InnerHtml = GetLocalResourceObject("UpdateError1").ToString() + "<br/>" + msgString; return false; } #endregion _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.ID = hidHotelNo.Value; //hotelInfoDBEntity.HotelID = hidHotelID.Value; //hotelInfoDBEntity.Name_CN = txtHotelNM.Text.Trim(); //hotelInfoDBEntity.Name_EN = txtHotelNMEN.Text.Trim(); //hotelInfoDBEntity.Status = ddpStatusList.SelectedValue; //hotelInfoDBEntity.StarRating = ddpUStarRating.SelectedValue.Split(',')[0].ToString(); //hotelInfoDBEntity.DiamondRating = ddpUStarRating.SelectedValue.Split(',')[1].ToString(); //hotelInfoDBEntity.City = hidCityID.Value;// ddpCity.SelectedValue; //hotelInfoDBEntity.OpenDate = dpOpenDate.Value; //hotelInfoDBEntity.RepairDate = dpRepairDate.Value; //hotelInfoDBEntity.AddRess = txtAddress.Text.Trim(); //hotelInfoDBEntity.WebSite = txtWebSite.Text.Trim(); //hotelInfoDBEntity.Longitude = txtLongitude.Text.Trim(); //hotelInfoDBEntity.Latitude = txtLatitude.Text.Trim(); //hotelInfoDBEntity.SimpleDescZh = txtSimpleDescZh.Text.Trim(); //hotelInfoDBEntity.DescZh = txtDescZh.Text.Trim(); //hotelInfoDBEntity.Evaluation = Evaluation; //hotelInfoDBEntity.AutoTrust = "1"; //hotelInfoDBEntity.FogStatus = hidFogStatus.Value; hotelInfoDBEntity.ID = hidHotelNo.Value; hotelInfoDBEntity.HotelID = hidHotelID.Value; hotelInfoDBEntity.Name_CN = txtHotelNM.Text.Trim(); hotelInfoDBEntity.Name_EN = txtHotelNMEN.Text.Trim(); hotelInfoDBEntity.Status = ddpStatusList.SelectedValue; if (ddpStatusList.SelectedValue == "0") { hotelInfoDBEntity.Remark = ddpStatusListRemark.SelectedValue; } hotelInfoDBEntity.City = (hidUCityID.Value.IndexOf("]") >= 0) ? hidUCityID.Value.Substring((hidUCityID.Value.IndexOf('[') + 1), (hidUCityID.Value.IndexOf(']') - 1)) : ""; hotelInfoDBEntity.HotelGroup = (hidHotelGroup.Value.IndexOf("]") >= 0) ? hidHotelGroup.Value.Substring((hidHotelGroup.Value.IndexOf('[') + 1), (hidHotelGroup.Value.IndexOf(']') - 1)) : "";//酒店集团 hotelInfoDBEntity.StarRating = ddpUStarRating.SelectedValue; hotelInfoDBEntity.AddRess = txtAddress.Text.Trim(); hotelInfoDBEntity.Phone = txtUHotelTel.Text.Trim(); hotelInfoDBEntity.Fax = txtUHotelFax.Text.Trim(); hotelInfoDBEntity.Longitude = txtLongitude.Text.Trim(); hotelInfoDBEntity.Latitude = txtLatitude.Text.Trim(); hotelInfoDBEntity.BDLongitude = txtBDLongitude.Text.Trim(); hotelInfoDBEntity.BDLatitude = txtBDLatitude.Text.Trim(); hotelInfoDBEntity.Bussiness = hidBussList.Value.Trim(); hotelInfoDBEntity.OpenDate = dpOpenDate.Value; hotelInfoDBEntity.RepairDate = dpRepairDate.Value; hotelInfoDBEntity.SimpleDescZh = txtSimpleDescZh.Text.Trim(); hotelInfoDBEntity.DescZh = txtDescZh.Text.Trim(); hotelInfoDBEntity.Status = ddpStatusList.SelectedValue.Trim(); hotelInfoDBEntity.HotelPN = txtUHotelPN.Text.Trim(); hotelInfoDBEntity.TotalRooms = txtUTotalRooms.Text.Trim(); hotelInfoDBEntity.HotelJP = txtUHotelJP.Text.Trim(); hotelInfoDBEntity.Zip = txtUZip.Text.Trim(); hotelInfoDBEntity.PriceLow = txtUPriceLow.Text.Trim(); hotelInfoDBEntity.ContactPer = txtUContactNameZh.Text.Trim(); hotelInfoDBEntity.ContactPhone = txtUContactPhone.Text.Trim(); hotelInfoDBEntity.ContactEmail = txtUContactEmail.Text.Trim(); hotelInfoDBEntity.WebSite = txtWebSite.Text.Trim(); hotelInfoDBEntity.Evaluation = Evaluation; hotelInfoDBEntity.HotelRemark = txtURemark.Text.ToString().Trim(); hotelInfoDBEntity.FogStatus = hidFogStatus.Value; hotelInfoDBEntity.KeyWords = hidUKeyWords.Value.Trim().TrimEnd(','); hotelInfoDBEntity.IsMyHotel = ddlUpdateIsMyHotel.SelectedValue;//是否为自签酒店 _hotelinfoEntity.HotelInfoDBEntity.Add(hotelInfoDBEntity); int iResult = HotelInfoBP.UpdateHotelInfo(_hotelinfoEntity).Result; _commonEntity.LogMessages = _hotelinfoEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "酒店基础信息-保存"; commonDBEntity.Event_ID = hidHotelID.Value; string conTent = GetLocalResourceObject("EventInsertMessage").ToString(); conTent = string.Format(conTent, hidHotelID.Value, 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, hotelInfoDBEntity.WebSite, hotelInfoDBEntity.Evaluation, hotelInfoDBEntity.HotelRemark, hotelInfoDBEntity.BDLongitude, hotelInfoDBEntity.BDLatitude, hotelInfoDBEntity.KeyWords); //string conTent = GetLocalResourceObject("EventInsertMessage").ToString(); //conTent = string.Format(conTent, hotelInfoDBEntity.HotelID, hotelInfoDBEntity.Name_CN, hotelInfoDBEntity.Status, hotelInfoDBEntity.HotelGroup, hotelInfoDBEntity.StarRating, hotelInfoDBEntity.DiamondRating, hotelInfoDBEntity.City, hotelInfoDBEntity.OpenDate.ToString(), hotelInfoDBEntity.RepairDate.ToString(), hotelInfoDBEntity.AddRess, hotelInfoDBEntity.WebSite, hotelInfoDBEntity.SimpleDescZh, hotelInfoDBEntity.DescZh, hotelInfoDBEntity.Evaluation); commonDBEntity.Event_Content = conTent; if (iResult == 1) { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateSuccess").ToString(); MessageContent.InnerHtml = GetLocalResourceObject("UpdateSuccess").ToString(); } else if (iResult == 3) { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError331").ToString(); MessageContent.InnerHtml = GetLocalResourceObject("UpdateError331").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 ELRelationEntity HVPAreaInsertBase(ELRelationEntity elrelationEntity) { OracleParameter[] parm ={ new OracleParameter("HVPHOTELID",OracleType.VarChar), new OracleParameter("AREAID",OracleType.VarChar) }; ELRelationDBEntity dbParm = (elrelationEntity.ELRelationDBEntity.Count > 0) ? elrelationEntity.ELRelationDBEntity[0] : new ELRelationDBEntity(); if (String.IsNullOrEmpty(dbParm.HVPID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HVPID; } if (String.IsNullOrEmpty(dbParm.ELongID)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.ELongID; } elrelationEntity.Result = DbManager.ExecuteSql("ELRelation", "t_fx_hvp_hotel_insertbase", parm); return elrelationEntity; }