public static int CheckInsert(DestinationEntity destinationEntity)
{
OracleParameter[] parm ={
new OracleParameter("TYPENM",OracleType.VarChar)
};
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
parm[0].Value = dbParm.Name_CN;
destinationEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Destination", "t_lm_b_destination_type_sigle", false, parm);
if (destinationEntity.QueryResult.Tables.Count > 0 && destinationEntity.QueryResult.Tables[0].Rows.Count > 0)
{
return 1;
}
return 0;
}
public static DestinationEntity CommonTypeSelectSigle(DestinationEntity destinationEntity)
{
destinationEntity.LogMessages.MsgType = MessageType.INFO;
destinationEntity.LogMessages.Content = _nameSpaceClass + "CommonTypeSelectSigle";
LoggerHelper.LogWriter(destinationEntity.LogMessages);
try
{
return DestinationDA.CommonTypeSelectSigle(destinationEntity);
}
catch (Exception ex)
{
destinationEntity.LogMessages.MsgType = MessageType.ERROR;
destinationEntity.LogMessages.Content = _nameSpaceClass + "CommonTypeSelectSigle Error: " + ex.Message;
LoggerHelper.LogWriter(destinationEntity.LogMessages);
throw ex;
}
}
public static int CheckUpdate(DestinationEntity destinationEntity)
{
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("NAMECN",OracleType.VarChar)
};
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
parm[0].Value = int.Parse(dbParm.DestinationID.ToString());
parm[1].Value = dbParm.Name_CN;
destinationEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Destination", "t_lm_b_destination_type_updatesigle", false, parm);
if (destinationEntity.QueryResult.Tables.Count > 0 && destinationEntity.QueryResult.Tables[0].Rows.Count > 0)
{
return 1;
}
return 0;
}
public static int Update(DestinationEntity destinationEntity)
{
if (destinationEntity.DestinationDBEntity.Count == 0)
{
return 0;
}
if (destinationEntity.LogMessages == null)
{
return 0;
}
if (CheckUpdate(destinationEntity) > 0)
{
return 2;
}
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
DataSet dsParents = GetDestinationParentsID(dbParm.DestinationID, dbParm.ParentsID);
string oldParentsID = (dsParents.Tables[0].Rows.Count > 0) ? dsParents.Tables[0].Rows[0]["PARENTSID"].ToString() : "";
int iCount = (dsParents.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsParents.Tables[0].Rows[0]["ICOUNT"].ToString())) ? int.Parse(dsParents.Tables[0].Rows[0]["ICOUNT"].ToString()) : 0;
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PARENTSID",OracleType.VarChar),
new OracleParameter("NAMECN",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar)
};
parm[0].Value = dbParm.DestinationID;
parm[1].Value = dbParm.ParentsID;
parm[2].Value = dbParm.Name_CN;
parm[3].Value = dbParm.OnlineStatus;
DbManager.ExecuteSql("Destination", "t_lm_b_destination_type_update", parm);
if (!String.IsNullOrEmpty(dbParm.ParentsID))
{
UpdateFlag(dbParm.ParentsID, "0");
}
if (!oldParentsID.Equals("0") && !oldParentsID.Equals(dbParm.ParentsID) && iCount == 0)
{
UpdateFlag(oldParentsID, "1");
}
return 1;
}
public static DestinationEntity TypeSelect(DestinationEntity destinationEntity)
{
destinationEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Destination", "t_lm_b_destination_type_union", false);
return destinationEntity;
}
public static int Insert(DestinationEntity destinationEntity)
{
if (destinationEntity.DestinationDBEntity.Count == 0)
{
return 0;
}
if (destinationEntity.LogMessages == null)
{
return 0;
}
if (CheckInsert(destinationEntity) > 0)
{
return 2;
}
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
CommandInfo InsertLmPaymentInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PARENTSID",OracleType.VarChar),
new OracleParameter("NAMECN",OracleType.VarChar)
};
lmParm[0].Value = getMaxIDfromSeq("T_LM_B_DESTINATION_TYPE_SEQ");
lmParm[1].Value = dbParm.ParentsID;
lmParm[2].Value = dbParm.Name_CN;
DbManager.ExecuteSql("Destination", "t_lm_b_destination_type_insert", lmParm);
if (!String.IsNullOrEmpty(dbParm.ParentsID))
{
UpdateFlag(dbParm.ParentsID, "0");
}
return 1;
}
public static int DestinationUpdateBatchHotel(DestinationEntity destinationEntity)
{
if (destinationEntity.DestinationDBEntity.Count == 0)
{
return 0;
}
if (destinationEntity.LogMessages == null)
{
return 0;
}
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
OracleParameter[] lmhotelParm ={
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("DESTINATIONID",OracleType.VarChar)
};
lmhotelParm[0].Value = dbParm.CityID;
lmhotelParm[1].Value = dbParm.DestinationID;
DataSet dsCity = HotelVp.Common.DBUtility.DbManager.Query("Destination", "t_lm_b_destination_hotel_batchlist", false, lmhotelParm);
int MaxLength = (String.IsNullOrEmpty(ConfigurationManager.AppSettings["MaxLength"].ToString())) ? 1000 : int.Parse(ConfigurationManager.AppSettings["MaxLength"].ToString());
List<CommandInfo> cmdList = new List<CommandInfo>();
string strSQL = XmlSqlAnalyze.GotSqlTextFromXml("Destination", "t_lm_b_destination_hotel_save");
int iCount = 0;
for (int i = 0; i <= dsCity.Tables[0].Rows.Count - 1; i++)
{
if (String.IsNullOrEmpty(dsCity.Tables[0].Rows[i]["DESTINATIONID"].ToString()))
{
continue;
}
dsCity.Tables[0].Rows[i]["DISTANCE"] = GetTotalDistance(dsCity.Tables[0].Rows[i]["HLLATITUDE"].ToString(), dsCity.Tables[0].Rows[i]["HLLONGITUDE"].ToString(), dsCity.Tables[0].Rows[i]["DTLATITUDE"].ToString(), dsCity.Tables[0].Rows[i]["DTLONGITUDE"].ToString());
CommandInfo cminfo = new CommandInfo();
cminfo.CommandText = strSQL;
OracleParameter[] lmParm ={
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("DESTINATIONID",OracleType.VarChar),
new OracleParameter("TYPEID",OracleType.VarChar),
new OracleParameter("DISTANCE",OracleType.VarChar)
};
lmParm[0].Value = dsCity.Tables[0].Rows[i]["CITYID"].ToString();
lmParm[1].Value = dsCity.Tables[0].Rows[i]["HOTELID"].ToString();
lmParm[2].Value = dsCity.Tables[0].Rows[i]["DESTINATIONID"].ToString();
lmParm[3].Value = dsCity.Tables[0].Rows[i]["TYPEID"].ToString();
lmParm[4].Value = dsCity.Tables[0].Rows[i]["DISTANCE"].ToString();
cminfo.Parameters = lmParm;
cmdList.Add(cminfo);
iCount = iCount + 1;
if (MaxLength == iCount)
{
try
{
DbHelperOra.ExecuteSqlTran(cmdList);
}
catch
{
}
iCount = 0;
cmdList.Clear();
}
}
if (iCount > 0)
{
try
{
DbHelperOra.ExecuteSqlTran(cmdList);
}
catch
{
}
}
return 1;
}
public static int DestinationUpdate(DestinationEntity destinationEntity)
{
if (destinationEntity.DestinationDBEntity.Count == 0)
{
return 0;
}
if (destinationEntity.LogMessages == null)
{
return 0;
}
//if (CheckDestinationUpdate(destinationEntity) > 0)
//{
// return 2;
//}
if (CheckDestinationCityInsert(destinationEntity) == 0)
{
return 3;
}
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
CommandInfo InsertLmPaymentInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("TYPEID",OracleType.VarChar),
new OracleParameter("NAMECN",OracleType.VarChar),
new OracleParameter("ADDRESSCN",OracleType.VarChar),
new OracleParameter("TELST",OracleType.VarChar),
new OracleParameter("TELLG",OracleType.VarChar),
new OracleParameter("LATITUDE",OracleType.VarChar),
new OracleParameter("LONGITUDE",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar)
};
lmParm[0].Value = dbParm.DestinationID;
lmParm[1].Value = dbParm.CityID;
lmParm[2].Value = dbParm.DestinationTypeID;
lmParm[3].Value = dbParm.Name_CN;
lmParm[4].Value = dbParm.AddRess;
lmParm[5].Value = dbParm.TelST;
lmParm[6].Value = dbParm.TelLG;
lmParm[7].Value = dbParm.Latitude;
lmParm[8].Value = dbParm.Longitude;
lmParm[9].Value = dbParm.OnlineStatus;
DbManager.ExecuteSql("Destination", "t_lm_b_destination_update", lmParm);
return 1;
}
public static DestinationEntity DestinationTypeDetail(DestinationEntity destinationEntity)
{
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.VarChar)
};
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
parm[0].Value = dbParm.DestinationID;
destinationEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Destination", "t_lm_b_destination_type_detail",false, parm);
return destinationEntity;
}
public static DestinationEntity DestinationListSelect(DestinationEntity destinationEntity)
{
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.VarChar),
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("TYPEID",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar)
};
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
if (String.IsNullOrEmpty(dbParm.DestinationID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.DestinationID;
}
if (String.IsNullOrEmpty(dbParm.CityID))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.CityID;
}
if (String.IsNullOrEmpty(dbParm.DestinationTypeID))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.DestinationTypeID;
}
if (String.IsNullOrEmpty(dbParm.Status))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.Status;
}
destinationEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Destination", "t_lm_b_destination_all", false, parm);
return destinationEntity;
}
public static DestinationEntity DestinationInsert(DestinationEntity destinationEntity)
{
if (destinationEntity.DestinationDBEntity.Count == 0)
{
destinationEntity.Result = 0;
return destinationEntity;
}
if (destinationEntity.LogMessages == null)
{
destinationEntity.Result = 0;
return destinationEntity;
}
//if (CheckDestinationInsert(destinationEntity) > 0)
//{
// return 2;
//}
if (CheckDestinationCityInsert(destinationEntity) == 0)
{
destinationEntity.Result = 3;
return destinationEntity;
}
DestinationDBEntity dbParm = (destinationEntity.DestinationDBEntity.Count > 0) ? destinationEntity.DestinationDBEntity[0] : new DestinationDBEntity();
CommandInfo InsertLmPaymentInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("TYPEID",OracleType.VarChar),
new OracleParameter("NAMECN",OracleType.VarChar),
new OracleParameter("ADDRESSCN",OracleType.VarChar),
new OracleParameter("TELST",OracleType.VarChar),
new OracleParameter("TELLG",OracleType.VarChar),
new OracleParameter("LATITUDE",OracleType.VarChar),
new OracleParameter("LONGITUDE",OracleType.VarChar)
};
lmParm[0].Value = getMaxIDfromSeq("T_LM_B_DESTINATION_SEQ");
lmParm[1].Value = dbParm.CityID;
lmParm[2].Value = dbParm.DestinationTypeID;
lmParm[3].Value = dbParm.Name_CN;
lmParm[4].Value = dbParm.AddRess;
lmParm[5].Value = dbParm.TelST;
lmParm[6].Value = dbParm.TelLG;
lmParm[7].Value = dbParm.Latitude;
lmParm[8].Value = dbParm.Longitude;
destinationEntity.DestinationDBEntity[0].DestinationID = lmParm[0].Value.ToString();
DbManager.ExecuteSql("Destination", "t_lm_b_destination_insert", lmParm);
destinationEntity.Result = 1;
return destinationEntity;
}
public static DestinationEntity CitySelect(DestinationEntity destinationEntity)
{
destinationEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Destination", "t_fc_city", false);
return destinationEntity;
}
//public static DestinationEntity PlatFormSelect(DestinationEntity destinationEntity)
//{
// destinationEntity.LogMessages.MsgType = MessageType.INFO;
// destinationEntity.LogMessages.Content = _nameSpaceClass + "PlatFormSelect";
// LoggerHelper.LogWriter(destinationEntity.LogMessages);
// try
// {
// return DestinationDA.PlatFormSelect(destinationEntity);
// }
// catch (Exception ex)
// {
// destinationEntity.LogMessages.MsgType = MessageType.ERROR;
// destinationEntity.LogMessages.Content = _nameSpaceClass + "PlatFormSelect Error: " + ex.Message;
// throw ex;
// }
//}
public static int DestinationInsert(DestinationEntity destinationEntity)
{
destinationEntity.LogMessages.MsgType = MessageType.INFO;
destinationEntity.LogMessages.Content = _nameSpaceClass + "DestinationInsert";
LoggerHelper.LogWriter(destinationEntity.LogMessages);
try
{
destinationEntity = DestinationDA.DestinationInsert(destinationEntity);
if (destinationEntity.Result == 1)
{
DestinationDA.DestinationUpdateBatchHotel(destinationEntity);
}
return destinationEntity.Result;
}
catch (Exception ex)
{
destinationEntity.LogMessages.MsgType = MessageType.ERROR;
destinationEntity.LogMessages.Content = _nameSpaceClass + "DestinationInsert Error: " + ex.Message;
LoggerHelper.LogWriter(destinationEntity.LogMessages);
throw ex;
}
}
public static int Insert(DestinationEntity destinationEntity)
{
destinationEntity.LogMessages.MsgType = MessageType.INFO;
destinationEntity.LogMessages.Content = _nameSpaceClass + "Insert";
LoggerHelper.LogWriter(destinationEntity.LogMessages);
try
{
return DestinationDA.Insert(destinationEntity);
}
catch (Exception ex)
{
destinationEntity.LogMessages.MsgType = MessageType.ERROR;
destinationEntity.LogMessages.Content = _nameSpaceClass + "Insert Error: " + ex.Message;
LoggerHelper.LogWriter(destinationEntity.LogMessages);
throw ex;
}
}
public static int DestinationUpdate(DestinationEntity destinationEntity)
{
destinationEntity.LogMessages.MsgType = MessageType.INFO;
destinationEntity.LogMessages.Content = _nameSpaceClass + "DestinationUpdate";
LoggerHelper.LogWriter(destinationEntity.LogMessages);
try
{
int iResult = DestinationDA.DestinationUpdate(destinationEntity);
if (iResult != 1)
{
return iResult;
}
DestinationDA.DestinationUpdateBatchHotel(destinationEntity);
return iResult;
}
catch (Exception ex)
{
destinationEntity.LogMessages.MsgType = MessageType.ERROR;
destinationEntity.LogMessages.Content = _nameSpaceClass + "DestinationUpdate Error: " + ex.Message;
LoggerHelper.LogWriter(destinationEntity.LogMessages);
throw ex;
}
}
