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