public static int Insert(PaymentEntity paymentEntity)
{
if (paymentEntity.PaymentDBEntity.Count == 0)
{
return 0;
}
if (paymentEntity.LogMessages == null)
{
return 0;
}
if (CheckInsert(paymentEntity) > 0)
{
return 2;
}
PaymentDBEntity dbParm = (paymentEntity.PaymentDBEntity.Count > 0) ? paymentEntity.PaymentDBEntity[0] : new PaymentDBEntity();
List<CommandInfo> sqlList = new List<CommandInfo>();
CommandInfo InsertLmPaymentInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTCODE",OracleType.VarChar),
new OracleParameter("PAYMENTNM",OracleType.VarChar)
};
lmParm[0].Value = getMaxIDfromSeq("T_LM_B_PAYMENT_SEQ");
lmParm[1].Value = dbParm.PaymentID;
lmParm[2].Value = dbParm.Name_CN;
InsertLmPaymentInfo.SqlName = "Payment";
InsertLmPaymentInfo.SqlId = "t_lm_b_payment_insert";
InsertLmPaymentInfo.Parameters = lmParm;
sqlList.Add(InsertLmPaymentInfo);
PaymentEntity platformList = CommonSelect(paymentEntity);
if (platformList.QueryResult.Tables.Count > 0 && platformList.QueryResult.Tables[0].Rows.Count > 0)
{
foreach (DataRow drRow in platformList.QueryResult.Tables[0].Rows)
{
CommandInfo InsertCsPaymentInfo = new CommandInfo();
OracleParameter[] csParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTID",OracleType.VarChar),
new OracleParameter("PLATFORM_ID",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar)
};
csParm[0].Value = getMaxIDfromSeq("T_LM_B_PAYMENT_PLAT_SEQ");
csParm[1].Value = dbParm.PaymentID;
csParm[2].Value = drRow["PlatformCODE"].ToString();
csParm[3].Value = "0";
InsertCsPaymentInfo.SqlName = "Payment";
InsertCsPaymentInfo.SqlId = "t_lm_b_payment_plat_insert";
InsertCsPaymentInfo.Parameters = csParm;
sqlList.Add(InsertCsPaymentInfo);
}
}
DbManager.ExecuteSqlTran(sqlList);
//DataCommand cmd = DataCommandManager.GetDataCommand("InsertCityList");
//foreach (PaymentDBEntity dbParm in paymentEntity.PaymentDBEntity)
//{
// cmd.SetParameterValue("@ChannelID", dbParm.ChannelID);
// cmd.SetParameterValue("@NameCN", dbParm.Name_CN);
// cmd.SetParameterValue("@NameEN", PinyinHelper.GetPinyin(dbParm.Name_CN));
// cmd.SetParameterValue("@OnlineStatus", dbParm.OnlineStatus);
// cmd.SetParameterValue("@Remark", dbParm.Remark);
// cmd.SetParameterValue("@CreateUser", (paymentEntity.LogMessages != null) ? paymentEntity.LogMessages.Userid : "");
// cmd.SetParameterValue("@UpdateUser", (paymentEntity.LogMessages != null) ? paymentEntity.LogMessages.Userid : "");
// cmd.ExecuteNonQuery();
//}
return 1;
}
public static HotelInfoEntity SaveRoomRatherList(HotelInfoEntity hotelInfoEntity)
{
if (hotelInfoEntity.HotelInfoDBEntity.Count == 0)
{
return hotelInfoEntity;
}
if (hotelInfoEntity.LogMessages == null)
{
return hotelInfoEntity;
}
HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity();
List<CommandInfo> cmdList = new List<CommandInfo>();
string strSql = XmlSqlAnalyze.GotSqlTextFromXml("HotelInfo", "t_room_rather_list_save");
DataTable dtResult = dbParm.RoomRather;
for (int i = 0; i < dtResult.Rows.Count; i++)
{
CommandInfo cminfo = new CommandInfo();
cminfo.CommandText = strSql;
OracleParameter[] parm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("ROOMCODE",OracleType.VarChar),
new OracleParameter("DTYPE",OracleType.VarChar),
new OracleParameter("DVALE",OracleType.VarChar),
new OracleParameter("CREATEUSER",OracleType.VarChar)
};
parm[0].Value = dbParm.HotelID;
parm[1].Value = dtResult.Rows[i]["ROOMCD"].ToString();
parm[2].Value = dtResult.Rows[i]["DISCOUNTCD"].ToString();
parm[3].Value = dtResult.Rows[i]["DISCOUNTXT"].ToString();
parm[4].Value = hotelInfoEntity.LogMessages.Username;
cminfo.Parameters = parm;
cmdList.Add(cminfo);
}
DbHelperOra.ExecuteSqlTran(cmdList);
return hotelInfoEntity;
}
public static int Insert(HotelFacilitiesEntity hotelfacilitiesEntity)
{
if (hotelfacilitiesEntity.HotelFacilitiesDBEntity.Count == 0)
{
return 0;
}
if (hotelfacilitiesEntity.LogMessages == null)
{
return 0;
}
if (CheckInsert(hotelfacilitiesEntity) > 0)
{
return 2;
}
HotelFacilitiesDBEntity dbParm = (hotelfacilitiesEntity.HotelFacilitiesDBEntity.Count > 0) ? hotelfacilitiesEntity.HotelFacilitiesDBEntity[0] : new HotelFacilitiesDBEntity();
CommandInfo InsertLmPaymentInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("NAMECN",OracleType.VarChar),
new OracleParameter("TYPE",OracleType.VarChar),
new OracleParameter("CODE",OracleType.VarChar),
new OracleParameter("SEQ",OracleType.VarChar)
};
lmParm[0].Value = getMaxIDfromSeq("t_lm_b_facilities_SEQ");
lmParm[1].Value = dbParm.Name_CN;
lmParm[2].Value = dbParm.Type;
lmParm[3].Value = 'P' + lmParm[0].Value.ToString().PadLeft(4, '0');
lmParm[4].Value = dbParm.FTSeq;
DbManager.ExecuteSql("HotelFacilities", "t_lm_b_hotel_facilities_insert", lmParm);
return 1;
}
public static int Update(PaymentEntity paymentEntity)
{
if (paymentEntity.PaymentDBEntity.Count == 0)
{
return 0;
}
if (paymentEntity.LogMessages == null)
{
return 0;
}
if (CheckUpdate(paymentEntity) > 0)
{
return 2;
}
List<CommandInfo> sqlList = new List<CommandInfo>();
bool iflag = true;
string PaymentID = "";
foreach(PaymentDBEntity paymentDBEntity in paymentEntity.PaymentDBEntity)
{
if (iflag)
{
PaymentEntity commonEntity = new PaymentEntity();
commonEntity.PaymentDBEntity = new List<PaymentDBEntity>();
PaymentDBEntity commonpaycodeDBEntity = new PaymentDBEntity();
commonpaycodeDBEntity.PaymentNo = paymentDBEntity.PaymentNo.ToString();
commonEntity.PaymentDBEntity.Add(commonpaycodeDBEntity);
DataSet dsResult = Select(commonEntity).QueryResult;
PaymentID = (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) ? dsResult.Tables[0].Rows[0]["paymentcode"].ToString() : "";
iflag = false;
}
if (paymentDBEntity.UpdatType.Equals("1"))
{
CommandInfo InsertCsMainPaymentInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTNM",OracleType.VarChar)
};
lmParm[0].Value = int.Parse(paymentDBEntity.PaymentNo.ToString());
lmParm[1].Value = paymentDBEntity.Name_CN;
InsertCsMainPaymentInfo.SqlName = "Payment";
InsertCsMainPaymentInfo.SqlId = "t_lm_b_payment_update";
InsertCsMainPaymentInfo.Parameters = lmParm;
sqlList.Add(InsertCsMainPaymentInfo);
}
else
{
CommandInfo InsertCsPaymentInfo = new CommandInfo();
OracleParameter[] csParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTID",OracleType.VarChar),
new OracleParameter("PLATFORM_ID",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar)
};
csParm[0].Value = (string.IsNullOrEmpty(paymentDBEntity.PaymentNo)) ? getMaxIDfromSeq("T_LM_B_PAYMENT_PLAT_SEQ") : int.Parse(paymentDBEntity.PaymentNo.ToString());
csParm[1].Value = PaymentID;
csParm[2].Value = paymentDBEntity.PaymFormID;
csParm[3].Value = paymentDBEntity.OnlineStatus;
InsertCsPaymentInfo.SqlName = "Payment";
InsertCsPaymentInfo.SqlId = "t_lm_b_payment_plat_update";
InsertCsPaymentInfo.Parameters = csParm;
sqlList.Add(InsertCsPaymentInfo);
}
}
DbManager.ExecuteSqlTran(sqlList);
//OracleParameter[] parm ={
// new OracleParameter("ID",OracleType.Number),
// new OracleParameter("ONLINESTATUS",OracleType.VarChar)
// };
//PaymentDBEntity dbParm = (paymentEntity.PaymentDBEntity.Count > 0) ? paymentEntity.PaymentDBEntity[0] : new PaymentDBEntity();
//parm[0].Value = dbParm.PaymentID;
//parm[1].Value = dbParm.OnlineStatus;
//DbManager.ExecuteSql("Payment", "t_cs_payment_update", parm);
//DataCommand cmd = DataCommandManager.GetDataCommand("UpdateCityList");
//foreach (PaymentDBEntity dbParm in paymentEntity.PaymentDBEntity)
//{
// cmd.SetParameterValue("@ChannelNo", dbParm.ChannelNo);
// cmd.SetParameterValue("@ChannelID", dbParm.ChannelID);
// cmd.SetParameterValue("@NameCN", dbParm.Name_CN);
// cmd.SetParameterValue("@NameEN", PinyinHelper.GetPinyin(dbParm.Name_CN));
// cmd.SetParameterValue("@OnlineStatus", dbParm.OnlineStatus);
// cmd.SetParameterValue("@Remark", dbParm.Remark);
// cmd.SetParameterValue("@UpdateUser", (paymentEntity.LogMessages != null) ? paymentEntity.LogMessages.Userid : "");
// cmd.ExecuteNonQuery();
//}
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 void SetPushMsgByFileUpload(string fileName, string taskID)
{
string strFilePath = System.IO.Path.Combine(ConfigurationManager.AppSettings["UploadFilePath"].ToString(), fileName);
DataTable dtResult = new DataTable();
if (!System.IO.File.Exists(strFilePath))
{
return;
}
dtResult = LoadExcelToDataTable(strFilePath);
if (dtResult.Rows.Count >0)
{
string strSQL = XmlSqlAnalyze.GotSqlTextFromXml("PushMsg", "insert_lm_user_group_list");
int iCount = 0;
int MaxLength = (String.IsNullOrEmpty(ConfigurationManager.AppSettings["MaxLength"].ToString())) ? 1000 : int.Parse(ConfigurationManager.AppSettings["MaxLength"].ToString());
List<CommandInfo> cmdList = new List<CommandInfo>();
foreach (DataRow drUser in dtResult.Rows)
{
CommandInfo cminfo = new CommandInfo();
cminfo.CommandText = strSQL;
OracleParameter[] lmParm ={
new OracleParameter("TelPhone",OracleType.VarChar),
new OracleParameter("TaskID",OracleType.VarChar)
};
lmParm[0].Value = drUser[0].ToString();
lmParm[1].Value = taskID;
cminfo.Parameters = lmParm;
cmdList.Add(cminfo);
iCount = iCount + 1;
if (MaxLength == iCount)
{
try
{
DbHelperOra.ExecuteSqlTran(cmdList);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
iCount = 0;
cmdList.Clear();
}
}
if (iCount > 0)
{
try
{
DbHelperOra.ExecuteSqlTran(cmdList);
}
catch
{
}
}
}
}
public static int SetPromotionData(PromotionEntity promotionEntity, string strImageID)
{
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
List<CommandInfo> sqlList = new List<CommandInfo>();
CommandInfo UpdateLmPromInfo = new CommandInfo();
OracleParameter[] lmPromParm ={
new OracleParameter("ID",OracleType.VarChar)
};
lmPromParm[0].Value = dbParm.ID;
UpdateLmPromInfo.SqlName = "Promotion";
UpdateLmPromInfo.SqlId = "t_lm_promotion_update";
UpdateLmPromInfo.Parameters = lmPromParm;
sqlList.Add(UpdateLmPromInfo);
if ("1".Equals(dbParm.Status))
{
string PromotionCommonKey = String.IsNullOrEmpty(ConfigurationManager.AppSettings["PromotionCommonKey"]) ? "000000" : ConfigurationManager.AppSettings["PromotionCommonKey"].ToString();
CommandInfo InsertLmPromInfo = new CommandInfo();
OracleParameter[] lmPromInserParm ={
new OracleParameter("ID",OracleType.VarChar),
new OracleParameter("TITLE",OracleType.VarChar),
new OracleParameter("PRIORITY",OracleType.VarChar),
new OracleParameter("STARTDTIME",OracleType.VarChar),
new OracleParameter("ENDDTIME",OracleType.VarChar),
new OracleParameter("CONTENT",OracleType.VarChar),
new OracleParameter("IMAGEID",OracleType.VarChar),
new OracleParameter("STATUS",OracleType.VarChar),
new OracleParameter("OPERATEUSER",OracleType.VarChar),
new OracleParameter("RATECODE",OracleType.VarChar),
new OracleParameter("PROTYPE",OracleType.VarChar),
new OracleParameter("COMMONLIST",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("USERGROUPLIST",OracleType.VarChar),
new OracleParameter("PROMETHODID",OracleType.VarChar),
new OracleParameter("LINKURL",OracleType.VarChar)
};
lmPromInserParm[0].Value = dbParm.ID;
lmPromInserParm[1].Value = dbParm.Title;
lmPromInserParm[2].Value = dbParm.Priority;
lmPromInserParm[3].Value = dbParm.StartDTime;
lmPromInserParm[4].Value = dbParm.EndDTime;
lmPromInserParm[5].Value = dbParm.Content;
lmPromInserParm[6].Value = strImageID;
lmPromInserParm[7].Value = dbParm.Status;
lmPromInserParm[8].Value = (promotionEntity.LogMessages != null) ? promotionEntity.LogMessages.Userid : "";
lmPromInserParm[9].Value = String.IsNullOrEmpty(dbParm.RateCode) ? "" : dbParm.RateCode;
lmPromInserParm[10].Value = dbParm.Type;
if ("0".Equals(dbParm.Type))
{
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_all_insert";
lmPromInserParm[11].Value = DBNull.Value;
lmPromInserParm[12].Value = DBNull.Value;
lmPromInserParm[14].Value = dbParm.Promethodid;
}
else if ("1".Equals(dbParm.Type))
{
lmPromInserParm[11].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromInserParm[12].Value = DBNull.Value;
lmPromInserParm[14].Value = dbParm.Promethodid;
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_city_insert";
}
else if ("2".Equals(dbParm.Type))
{
lmPromInserParm[11].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromInserParm[12].Value = DBNull.Value;
lmPromInserParm[14].Value = dbParm.Promethodid;
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_group_insert";
}
else if ("3".Equals(dbParm.Type))
{
lmPromInserParm[11].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromInserParm[12].Value = DBNull.Value;
lmPromInserParm[14].Value = dbParm.Promethodid;
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_hotel_insert";
}
else if ("4".Equals(dbParm.Type))
{
lmPromInserParm[11].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromInserParm[12].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey : dbParm.HotelID;
lmPromInserParm[14].Value = dbParm.Promethodid;
InsertLmPromInfo.SqlId = "t_lm_promotion_detail_room_insert";
}
if (dbParm.UserGroupList.Length > 0)
{
lmPromInserParm[13].Value = dbParm.UserGroupList.Substring(0, dbParm.UserGroupList.Length - 1);
}
else
{
lmPromInserParm[13].Value = DBNull.Value;
}
if (String.IsNullOrEmpty(dbParm.LinkUrl))
{
lmPromInserParm[15].Value = DBNull.Value;
}
else
{
lmPromInserParm[15].Value = dbParm.LinkUrl;
}
InsertLmPromInfo.SqlName = "Promotion";
InsertLmPromInfo.Parameters = lmPromInserParm;
sqlList.Add(InsertLmPromInfo);
}
DbManager.ExecuteSqlTran(sqlList);
return 1;
}
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 int InsertConsultRoomUser(UserEntity userEntity)
{
if (userEntity.UserDBEntity.Count == 0)
{
return 0;
}
if (userEntity.LogMessages == null)
{
return 0;
}
if (CheckConsultInsert(userEntity) > 0)
{
return 2;
}
UserDBEntity dbParm = (userEntity.UserDBEntity.Count > 0) ? userEntity.UserDBEntity[0] : new UserDBEntity();
OracleParameter[] parm ={
new OracleParameter("USERID",OracleType.VarChar),
new OracleParameter("RTYPE",OracleType.VarChar),
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("TAGID",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("CREATEUSER",OracleType.VarChar),
new OracleParameter("TCID",OracleType.Int32),
new OracleParameter("SALESID",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.UserID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.UserID;
}
if (String.IsNullOrEmpty(dbParm.RType))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.RType;
}
if (String.IsNullOrEmpty(dbParm.CityID))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.CityID;
}
if (String.IsNullOrEmpty(dbParm.TagID))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.TagID;
}
if (String.IsNullOrEmpty(dbParm.HotelID))
{
parm[4].Value = DBNull.Value;
}
else
{
parm[4].Value = dbParm.HotelID;
}
parm[5].Value = userEntity.LogMessages.Username;
parm[6].Value = getMaxIDfromSeq("T_LM_CONSULT_ROOM_SEQ");
if (String.IsNullOrEmpty(dbParm.SalesID))
{
parm[7].Value = DBNull.Value;
}
else
{
parm[7].Value = dbParm.SalesID;
}
HotelVp.Common.DBUtility.DbManager.ExecuteSql("User", "t_lm_consult_room_user_insert", parm);//t_lm_consult_room_seq.nextval
if (dbParm.ALDelHT.Length > 0)
{
List<CommandInfo> sqlList = new List<CommandInfo>();
string[] alHotel = dbParm.ALDelHT.Split(',');
foreach (string strHotel in alHotel)
{
if (String.IsNullOrEmpty(strHotel.Trim()))
{
continue;
}
CommandInfo InsertHotelExInfo = new CommandInfo();
OracleParameter[] lmHotelExParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("TLCRID",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("CREATEUSER",OracleType.VarChar)
};
lmHotelExParm[0].Value = getMaxIDfromSeq("T_LM_CONSULT_ROOM_HOTEL_EX_SEQ");
lmHotelExParm[1].Value = parm[6].Value;
lmHotelExParm[2].Value = strHotel;
lmHotelExParm[3].Value = userEntity.LogMessages.Username;
InsertHotelExInfo.SqlName = "User";
InsertHotelExInfo.SqlId = "t_lm_consult_room_hotel_insert";
InsertHotelExInfo.Parameters = lmHotelExParm;
sqlList.Add(InsertHotelExInfo);
}
DbManager.ExecuteSqlTran(sqlList);
}
return 1;
}
private static int AutoMappingBeding(AutoMappingBedEntity hotelcomparisonEntity)
{
CommonEntity _commonEntity = new CommonEntity();
_commonEntity.LogMessages = new Common.Logger.LogMessage();
IPHostEntry hostInfo = Dns.GetHostByName(Dns.GetHostName());
IPAddress[] address = hostInfo.AddressList;
string m_IP = address[0].ToString();
_commonEntity.LogMessages.IpAddress = m_IP;
_commonEntity.LogMessages.Computername = Dns.GetHostName();
_commonEntity.LogMessages.Userid = "JOB System";
_commonEntity.LogMessages.Username = "******";
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
DataSet dsResult = AutoMappingBedDA.AutoHotelRoomMappingList(hotelcomparisonEntity);
DataTable dtMapping = new DataTable();
dtMapping.Columns.Add("SOURCE");
dtMapping.Columns.Add("HOTELID");
dtMapping.Columns.Add("ROOMCD");
dtMapping.Columns.Add("BED");
string ELBed = string.Empty;
string strSQL = XmlSqlAnalyze.GotSqlTextFromXml("AutoMappingBed", "SaveHotelRoomBed");
int iCount = 0;
int MaxLength = (String.IsNullOrEmpty(ConfigurationManager.AppSettings["MaxLength"].ToString())) ? 1000 : int.Parse(ConfigurationManager.AppSettings["MaxLength"].ToString());
List<CommandInfo> cmdList = new List<CommandInfo>();
DataRow[] drTemp;
for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
{
drTemp = dtMapping.Select("SOURCE='" + dsResult.Tables[0].Rows[i]["MPType"].ToString().Trim() + "' and HOTELID='" + dsResult.Tables[0].Rows[i]["Mapping_Hotel"].ToString().Trim() + "'" + " and ROOMCD = '" + dsResult.Tables[0].Rows[i]["Mapping_Room"].ToString().Trim() + "'");
if (drTemp.Count() <= 0)
{
Console.WriteLine(dsResult.Tables[0].Rows[i]["Mapping_Hotel"].ToString().Trim() + " - " + dsResult.Tables[0].Rows[i]["Mapping_Room"].ToString().Trim() + " 艺龙接口调用开始");
GetMappingPrice(dsResult.Tables[0].Rows[i]["MPType"].ToString().Trim(), dsResult.Tables[0].Rows[i]["Mapping_Hotel"].ToString().Trim(), dsResult.Tables[0].Rows[i]["Mapping_Room"].ToString().Trim(), ref dtMapping);
Console.WriteLine(dsResult.Tables[0].Rows[i]["Mapping_Hotel"].ToString().Trim() + " - " + dsResult.Tables[0].Rows[i]["Mapping_Room"].ToString().Trim() + " 艺龙接口调用结束");
Console.WriteLine(dtMapping.Rows.Count);
drTemp = dtMapping.Select("SOURCE='" + dsResult.Tables[0].Rows[i]["MPType"].ToString().Trim() + "' and HOTELID='" + dsResult.Tables[0].Rows[i]["Mapping_Hotel"].ToString().Trim() + "'" + " and ROOMCD = '" + dsResult.Tables[0].Rows[i]["Mapping_Room"].ToString().Trim() + "'");
if (drTemp.Count() <= 0)
{
Console.WriteLine("无");
continue;
}
else
{
ELBed = drTemp[0]["BED"].ToString();
}
}
else
{
Console.WriteLine(dtMapping.Rows.Count);
ELBed = drTemp[0]["BED"].ToString();
}
if (String.IsNullOrEmpty(ELBed))
{
continue;
}
dsResult.Tables[0].Rows[i]["ROOMBED"] = ELBed;
CommandInfo cminfo = new CommandInfo();
cminfo.CommandText = strSQL;
OracleParameter[] lmParm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("ROOMCODE",OracleType.VarChar),
new OracleParameter("ROOMAREA",OracleType.VarChar),
new OracleParameter("UPDATEUSER",OracleType.VarChar)
};
lmParm[0].Value = dsResult.Tables[0].Rows[i]["Hotel_ID"].ToString().Trim();
lmParm[1].Value = dsResult.Tables[0].Rows[i]["Room_Code"].ToString().Trim();
lmParm[2].Value = dsResult.Tables[0].Rows[i]["ROOMBED"].ToString().Trim();
lmParm[3].Value = "CMS JOB";
cminfo.Parameters = lmParm;
cmdList.Add(cminfo);
iCount = iCount + 1;
if (MaxLength == iCount)
{
try
{
AutoMappingBedDA.SaveHotelRoomBedList(cmdList);
Console.Write("成功");
iCount = 0;
cmdList.Clear();
}
catch
{
Console.Write("失败");
}
}
//AutoMappingBedDA.SaveHotelRoomBed(dsResult.Tables[0].Rows[i]);
}
if (iCount > 0)
{
try
{
AutoMappingBedDA.SaveHotelRoomBedList(cmdList);
Console.Write("成功");
iCount = 0;
cmdList.Clear();
}
catch
{
Console.Write("失败");
}
}
//AutoMappingBedDA.UpdateOverDateData();
//if ("1".Equals(hotelcomparisonEntity.AutoHotelComparisonDBEntity[0].SaveType))
//{
// DataSet dsMailData = AutoMappingBedDA.GetMailDataList();
// string strMailBody = "";
// string strMailSubject = "今日{0}家酒店价格过高 " + DateTime.Now.ToShortDateString();
// if (dsMailData.Tables.Count > 0 && dsMailData.Tables["Master"].Rows.Count > 0)
// {
// strMailSubject = String.Format(strMailSubject, dsMailData.Tables["Master"].Rows[0]["BHLID"].ToString());
// }
// else
// {
// strMailSubject = String.Format(strMailSubject, "0");
// }
// strMailBody = SetMailBodyData(dsMailData);
// SendMailExpress(strMailBody, strMailSubject);
//}
return dsResult.Tables[0].Rows.Count;
}
public static int Insert(UserGroupEntity userGroupEntity)
{
if (userGroupEntity.UserGroupDBEntity.Count == 0)
{
return 0;
}
if (userGroupEntity.LogMessages == null)
{
return 0;
}
if (CheckInsert(userGroupEntity) > 0)
{
return 2;
}
UserGroupDBEntity dbParm = (userGroupEntity.UserGroupDBEntity.Count > 0) ? userGroupEntity.UserGroupDBEntity[0] : new UserGroupDBEntity();
string manualAdd = dbParm.ManualAdd.Replace("'", "").Replace("，",",").Replace("\r\n", "");
string[] manualList = manualAdd.Split(',');
string errorString = "";
string complString = "";
ArrayList complList = new ArrayList();
ArrayList tempList = new ArrayList();
int MaxLength = 300;
int iLength = 0;
for (int imanual = 0; imanual <= manualList.Count() - 1; imanual++)
{
if (IsMobileNumber(manualList[imanual].ToString().Trim()) && manualList[imanual].ToString().Trim().Length == 11)
{
if (!tempList.Contains(manualList[imanual].ToString().Trim()))
{
tempList.Add(manualList[imanual].ToString().Trim());
complString = complString + manualList[imanual].ToString().Trim() + ",";
iLength = iLength + 1;
if (iLength == MaxLength)
{
iLength = 0;
complString = complString.Substring(0, complString.Length - 1);
complList.Add(complString);
complString = "";
}
}
}
else
{
errorString = errorString + manualList[imanual].ToString().Trim() + ",";
}
}
if (iLength < MaxLength)
{
complString = (complString.Length > 0) ? complString.Substring(0, complString.Length - 1) : complString;
complList.Add(complString);
}
errorString = (errorString.Length > 0) ? errorString.Substring(0, errorString.Length - 1) : errorString.Trim();
//complList = (complList.Length > 0) ? complList.Substring(0, complList.Length - 1) : complList.Trim();
userGroupEntity.UserGroupDBEntity[0].ErrManualAdd = errorString;
userGroupEntity.UserGroupDBEntity[0].ComplManualAdd = complList;
//if (CheckInsert(userGroupEntity) > 0)
//{
// return 2;
//}
//DataSet dsCity = CheckCity(userGroupEntity);
//if (dsCity.Tables.Count == 0 || dsCity.Tables[0].Rows.Count == 0)
//{
// return 3;
//}
//UserGroupDBEntity dbParm = (userGroupEntity.UserGroupDBEntity.Count > 0) ? userGroupEntity.UserGroupDBEntity[0] : new UserGroupDBEntity();
List<CommandInfo> sqlList = new List<CommandInfo>();
CommandInfo InsertLmUserGroupInfo = new CommandInfo();
OracleParameter[] lmUserGroupParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("USERGROUPNAME",OracleType.VarChar),
new OracleParameter("REGISTSTART",OracleType.VarChar),
new OracleParameter("REGISTEND",OracleType.VarChar),
new OracleParameter("LOGINSTART",OracleType.VarChar),
new OracleParameter("LOGINEND",OracleType.VarChar),
new OracleParameter("SUBMITORDERFROM",OracleType.Int32),
new OracleParameter("SUBMITORDERTO",OracleType.Int32),
new OracleParameter("COMPLETEORDERFROM",OracleType.Int32),
new OracleParameter("COMPLETEORDERTO",OracleType.Int32),
new OracleParameter("LASTORDERSTART",OracleType.VarChar),
new OracleParameter("LASTORDEREND",OracleType.VarChar),
new OracleParameter("MANUALADD",OracleType.VarChar)
};
lmUserGroupParm[0].Value = getMaxIDfromSeq("T_LM_USERGROUP_SEQ");
lmUserGroupParm[1].Value = dbParm.UserGroupNM;
if (String.IsNullOrEmpty(dbParm.RegistStart))
{
lmUserGroupParm[2].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[2].Value = DateTime.Parse(dbParm.RegistStart);
lmUserGroupParm[2].Value = dbParm.RegistStart;
}
if (String.IsNullOrEmpty(dbParm.RegistEnd))
{
lmUserGroupParm[3].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[3].Value = DateTime.Parse(dbParm.RegistEnd);
lmUserGroupParm[3].Value = dbParm.RegistEnd;
}
if (String.IsNullOrEmpty(dbParm.LoginStart))
{
lmUserGroupParm[4].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[4].Value = DateTime.Parse(dbParm.LoginStart);
lmUserGroupParm[4].Value = dbParm.LoginStart;
}
if (String.IsNullOrEmpty(dbParm.LoginEnd))
{
lmUserGroupParm[5].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[5].Value = DateTime.Parse(dbParm.LoginEnd);
lmUserGroupParm[5].Value = dbParm.LoginEnd;
}
if (String.IsNullOrEmpty(dbParm.SubmitOrderFrom))
{
lmUserGroupParm[6].Value = DBNull.Value;
}
else
{
lmUserGroupParm[6].Value = Int32.Parse(dbParm.SubmitOrderFrom);
}
if (String.IsNullOrEmpty(dbParm.SubmitOrderTo))
{
lmUserGroupParm[7].Value = DBNull.Value;
}
else
{
lmUserGroupParm[7].Value = Int32.Parse(dbParm.SubmitOrderTo);
}
if (String.IsNullOrEmpty(dbParm.CompleteOrderFrom))
{
lmUserGroupParm[8].Value = DBNull.Value;
}
else
{
lmUserGroupParm[8].Value = Int32.Parse(dbParm.CompleteOrderFrom);
}
if (String.IsNullOrEmpty(dbParm.CompleteOrderTo))
{
lmUserGroupParm[9].Value = DBNull.Value;
}
else
{
lmUserGroupParm[9].Value = Int32.Parse(dbParm.CompleteOrderTo);
}
if (String.IsNullOrEmpty(dbParm.LastOrderStart))
{
lmUserGroupParm[10].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[10].Value = DateTime.Parse(dbParm.LastOrderStart);
lmUserGroupParm[10].Value = dbParm.LastOrderStart;
}
if (String.IsNullOrEmpty(dbParm.LastOrderEnd))
{
lmUserGroupParm[11].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[11].Value = DateTime.Parse(dbParm.LastOrderEnd);
lmUserGroupParm[11].Value = dbParm.LastOrderEnd;
}
lmUserGroupParm[12].Value = dbParm.ManualAdd;
InsertLmUserGroupInfo.SqlName = "UserGroup";
InsertLmUserGroupInfo.SqlId = "t_lm_usergroup_insert";
InsertLmUserGroupInfo.Parameters = lmUserGroupParm;
sqlList.Add(InsertLmUserGroupInfo);
string[] RegChannelList = dbParm.RegChannelList.Trim().Replace("'", "").Split(',');
string RegChannelString = "";
if (RegChannelList.Length > 0)
{
foreach (string RegCrlString in RegChannelList)
{
if (RegCrlString.Trim().Length > 0)
{
RegChannelString = RegChannelString + RegCrlString.Substring(RegCrlString.IndexOf('_') + 1) + ",";
}
}
//RegChannelString = RegChannelString.Substring(0, RegChannelString.Length - 1);
CommandInfo InsertlmUGROUPRCLInfo = new CommandInfo();
OracleParameter[] lmRclParm ={
new OracleParameter("USERGROUPID_RCL",OracleType.VarChar),
new OracleParameter("REGCHANELCODE",OracleType.VarChar)
};
lmRclParm[0].Value = lmUserGroupParm[0].Value;
lmRclParm[1].Value = RegChannelString;
InsertlmUGROUPRCLInfo.SqlName = "UserGroup";
InsertlmUGROUPRCLInfo.SqlId = "t_lm_usergroup_rechanel_insert";
InsertlmUGROUPRCLInfo.Parameters = lmRclParm;
sqlList.Add(InsertlmUGROUPRCLInfo);
}
string PlatformList = dbParm.PlatformList.Trim().Replace("'", "");
if (PlatformList.Length > 0)
{
CommandInfo InsertlmUGROUPPTMInfo = new CommandInfo();
OracleParameter[] lmPtmParm ={
new OracleParameter("USERGROUPID_PTM",OracleType.VarChar),
new OracleParameter("PLATFORMCODE",OracleType.VarChar)
};
lmPtmParm[0].Value = lmUserGroupParm[0].Value;
lmPtmParm[1].Value = PlatformList;
InsertlmUGROUPPTMInfo.SqlName = "UserGroup";
InsertlmUGROUPPTMInfo.SqlId = "t_lm_usergroup_platform_insert";
InsertlmUGROUPPTMInfo.Parameters = lmPtmParm;
sqlList.Add(InsertlmUGROUPPTMInfo);
}
CommandInfo InsertLmUserListInfo = new CommandInfo();
OracleParameter[] lmUserListParm ={
new OracleParameter("USERGROUPID",OracleType.Int32),
new OracleParameter("REGISTSTART",OracleType.VarChar),
new OracleParameter("REGISTEND",OracleType.VarChar),
new OracleParameter("LOGINSTART",OracleType.VarChar),
new OracleParameter("LOGINEND",OracleType.VarChar),
new OracleParameter("SUBMITORDERFROM",OracleType.Int32),
new OracleParameter("SUBMITORDERTO",OracleType.Int32),
new OracleParameter("COMPLETEORDERFROM",OracleType.Int32),
new OracleParameter("COMPLETEORDERTO",OracleType.Int32),
new OracleParameter("LASTORDERSTART",OracleType.VarChar),
new OracleParameter("LASTORDEREND",OracleType.VarChar),
new OracleParameter("REGCHANNELLIST",OracleType.VarChar),
new OracleParameter("PLATFORMLIST",OracleType.VarChar)
};
lmUserListParm[0].Value = lmUserGroupParm[0].Value;
if (String.IsNullOrEmpty(dbParm.RegistStart))
{
lmUserListParm[1].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[2].Value = DateTime.Parse(dbParm.RegistStart);
lmUserListParm[1].Value = dbParm.RegistStart;
}
if (String.IsNullOrEmpty(dbParm.RegistEnd))
{
lmUserListParm[2].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[3].Value = DateTime.Parse(dbParm.RegistEnd);
lmUserListParm[2].Value = dbParm.RegistEnd;
}
if (String.IsNullOrEmpty(dbParm.LoginStart))
{
lmUserListParm[3].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[4].Value = DateTime.Parse(dbParm.LoginStart);
lmUserListParm[3].Value = dbParm.LoginStart;
}
if (String.IsNullOrEmpty(dbParm.LoginEnd))
{
lmUserListParm[4].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[5].Value = DateTime.Parse(dbParm.LoginEnd);
lmUserListParm[4].Value = dbParm.LoginEnd;
}
if (String.IsNullOrEmpty(dbParm.SubmitOrderFrom))
{
lmUserListParm[5].Value = DBNull.Value;
}
else
{
lmUserListParm[5].Value = Int32.Parse(dbParm.SubmitOrderFrom);
}
if (String.IsNullOrEmpty(dbParm.SubmitOrderTo))
{
lmUserListParm[6].Value = DBNull.Value;
}
else
{
lmUserListParm[6].Value = Int32.Parse(dbParm.SubmitOrderTo);
}
if (String.IsNullOrEmpty(dbParm.CompleteOrderFrom))
{
lmUserListParm[7].Value = DBNull.Value;
}
else
{
lmUserListParm[7].Value = Int32.Parse(dbParm.CompleteOrderFrom);
}
if (String.IsNullOrEmpty(dbParm.CompleteOrderTo))
{
lmUserListParm[8].Value = DBNull.Value;
}
else
{
lmUserListParm[8].Value = Int32.Parse(dbParm.CompleteOrderTo);
}
if (String.IsNullOrEmpty(dbParm.LastOrderStart))
{
lmUserListParm[9].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[10].Value = DateTime.Parse(dbParm.LastOrderStart);
lmUserListParm[9].Value = dbParm.LastOrderStart;
}
if (String.IsNullOrEmpty(dbParm.LastOrderEnd))
{
lmUserListParm[10].Value = DBNull.Value;
}
else
{
//lmUserGroupParm[11].Value = DateTime.Parse(dbParm.LastOrderEnd);
lmUserListParm[10].Value = dbParm.LastOrderEnd;
}
if (String.IsNullOrEmpty(RegChannelString))
{
lmUserListParm[11].Value = DBNull.Value;
}
else
{
lmUserListParm[11].Value = (RegChannelString.Length > 1) ? RegChannelString.Substring(0, RegChannelString.Length -1) : "";
}
if (String.IsNullOrEmpty(PlatformList))
{
lmUserListParm[12].Value = DBNull.Value;
}
else
{
lmUserListParm[12].Value = (PlatformList.Length > 1) ? PlatformList.Substring(0, PlatformList.Length - 1) : "";
}
InsertLmUserListInfo.SqlName = "UserGroup";
InsertLmUserListInfo.SqlId = "t_lm_usergroup_ult_insert";
InsertLmUserListInfo.Parameters = lmUserListParm;
sqlList.Add(InsertLmUserListInfo);
if (userGroupEntity.UserGroupDBEntity[0].ComplManualAdd.Count > 0)
{
foreach (string strManual in userGroupEntity.UserGroupDBEntity[0].ComplManualAdd)
{
if (String.IsNullOrEmpty(strManual))
{
continue;
}
CommandInfo InsertLmManualUserListInfo = new CommandInfo();
OracleParameter[] lmManualUserParm ={
new OracleParameter("USERGROUPID",OracleType.Int32),
new OracleParameter("MANUALADD",OracleType.VarChar)
};
lmManualUserParm[0].Value = lmUserGroupParm[0].Value;
lmManualUserParm[1].Value = strManual;
InsertLmManualUserListInfo.SqlName = "UserGroup";
InsertLmManualUserListInfo.SqlId = "t_lm_usergroup_ult_manual_insert";
InsertLmManualUserListInfo.Parameters = lmManualUserParm;
sqlList.Add(InsertLmManualUserListInfo);
}
}
DbManager.ExecuteSqlTran(sqlList);
if (userGroupEntity.UserGroupDBEntity[0].ErrManualAdd.Length > 0)
{
return 3;
}
else
{
return 1;
}
}
public static SeltEntity SaveSettlementInfo(SeltEntity seltEntity)
{
SeltDBEntity dbParm = (seltEntity.SeltDBEntity.Count > 0) ? seltEntity.SeltDBEntity[0] : new SeltDBEntity();
List<CommandInfo> cmdList = new List<CommandInfo>();
CommandInfo cminfo = new CommandInfo();
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.VarChar),
new OracleParameter("UNIT_NAME",OracleType.VarChar),
new OracleParameter("INVOICE_NAME",OracleType.VarChar),
new OracleParameter("SETTLEMENT_TERM",OracleType.VarChar),
new OracleParameter("HOTEL_TAX",OracleType.VarChar),
new OracleParameter("SETTLEMENT_ADDRESS",OracleType.VarChar),
new OracleParameter("SETTLEMENT_PER",OracleType.VarChar),
new OracleParameter("SETTLEMENT_TEL",OracleType.VarChar),
new OracleParameter("SETTLEMENT_FAX",OracleType.VarChar),
new OracleParameter("SETTLEMENT_SALES",OracleType.VarChar),
new OracleParameter("BILL_ITEM",OracleType.VarChar),
new OracleParameter("HOTEL_TAXNO",OracleType.VarChar),
new OracleParameter("HOTEL_PAYNO",OracleType.VarChar),
new OracleParameter("STATUS",OracleType.VarChar),
new OracleParameter("CREATE_USER",OracleType.VarChar),
new OracleParameter("TERM_STDT",OracleType.VarChar)
};
string strSQL = "";
if (String.IsNullOrEmpty(dbParm.SeltID))
{
parm[0].Value = getMaxIDfromSeq("T_LM_SETTLEMENT_UNIT_SEQ");
strSQL = "t_lm_settlement_unit_insert";
}
else
{
parm[0].Value = dbParm.SeltID;
strSQL = "t_lm_settlement_unit_update";
}
if (String.IsNullOrEmpty(dbParm.UnitNm))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.UnitNm;
}
if (String.IsNullOrEmpty(dbParm.InvoiceNm))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.InvoiceNm;
}
if (String.IsNullOrEmpty(dbParm.Term))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.Term;
}
if (String.IsNullOrEmpty(dbParm.Tax))
{
parm[4].Value = DBNull.Value;
}
else
{
parm[4].Value = dbParm.Tax;
}
if (String.IsNullOrEmpty(dbParm.Address))
{
parm[5].Value = DBNull.Value;
}
else
{
parm[5].Value = dbParm.Address;
}
if (String.IsNullOrEmpty(dbParm.Per))
{
parm[6].Value = DBNull.Value;
}
else
{
parm[6].Value = dbParm.Per;
}
if (String.IsNullOrEmpty(dbParm.Tel))
{
parm[7].Value = DBNull.Value;
}
else
{
parm[7].Value = dbParm.Tel;
}
if (String.IsNullOrEmpty(dbParm.Fax))
{
parm[8].Value = DBNull.Value;
}
else
{
parm[8].Value = dbParm.Fax;
}
if (String.IsNullOrEmpty(dbParm.Sales))
{
parm[9].Value = DBNull.Value;
}
else
{
parm[9].Value = dbParm.Sales;
}
if (String.IsNullOrEmpty(dbParm.BillItem))
{
parm[10].Value = DBNull.Value;
}
else
{
parm[10].Value = dbParm.BillItem;
}
if (String.IsNullOrEmpty(dbParm.TaxNo))
{
parm[11].Value = DBNull.Value;
}
else
{
parm[11].Value = dbParm.TaxNo;
}
if (String.IsNullOrEmpty(dbParm.PayNo))
{
parm[12].Value = DBNull.Value;
}
else
{
parm[12].Value = dbParm.PayNo;
}
parm[13].Value = dbParm.Status;
parm[14].Value = seltEntity.LogMessages.Username;
parm[15].Value = dbParm.TermStDt;
cminfo.CommandText = XmlSqlAnalyze.GotSqlTextFromXml("Settlement", strSQL);
cminfo.Parameters = parm;
cmdList.Add(cminfo);
CommandInfo cmUpinfo = new CommandInfo();
OracleParameter[] upparm ={
new OracleParameter("UNIT_ID",OracleType.VarChar),
new OracleParameter("CREATE_USER",OracleType.VarChar)
};
upparm[0].Value = parm[0].Value;
upparm[1].Value = seltEntity.LogMessages.Username;
cmUpinfo.CommandText = XmlSqlAnalyze.GotSqlTextFromXml("Settlement", "t_lm_settlement_unit_hotel_update");
cmUpinfo.Parameters = upparm;
cmdList.Add(cmUpinfo);
DataTable dtHotel = dbParm.dtHotelList;
string strHotelSQL = XmlSqlAnalyze.GotSqlTextFromXml("Settlement", "t_lm_settlement_unit_hotel_save");
for (int i = 0; i <= dtHotel.Rows.Count - 1; i++)
{
CommandInfo cmhinfo = new CommandInfo();
cmhinfo.CommandText = strHotelSQL;
OracleParameter[] lmParm ={
new OracleParameter("UNIT_ID",OracleType.VarChar),
new OracleParameter("HOTEL_ID",OracleType.VarChar),
new OracleParameter("PRICE_CODE",OracleType.VarChar),
new OracleParameter("VENDOR",OracleType.VarChar),
new OracleParameter("STATUS",OracleType.VarChar),
new OracleParameter("CREATE_USER",OracleType.VarChar)
};
lmParm[0].Value = parm[0].Value;
lmParm[1].Value = dtHotel.Rows[i]["HOTELID"].ToString();
lmParm[2].Value = dtHotel.Rows[i]["PRICECD"].ToString();
lmParm[3].Value = dtHotel.Rows[i]["VENDOR"].ToString();
lmParm[4].Value = "1";
lmParm[5].Value = seltEntity.LogMessages.Username;
cmhinfo.Parameters = lmParm;
cmdList.Add(cmhinfo);
}
DbHelperOra.ExecuteSqlTran(cmdList);
seltEntity.Result = 1;
return seltEntity;
}
public static int UpdateHotelCompareGridBatch(APPContentEntity appcontentEntity)
{
List<CommandInfo> sqlList = new List<CommandInfo>();
string strSql = "";
foreach (APPContentDBEntity dbParm in appcontentEntity.APPContentDBEntity)
{
CommandInfo UpdateHubsInfo = new CommandInfo();
OracleParameter[] lmInfoParm ={
new OracleParameter("HOTELID",OracleType.VarChar)
};
lmInfoParm[0].Value = dbParm.HotelID;
UpdateHubsInfo.SqlName = "APPContent";
switch (dbParm.TypeID)
{
case "HOTELNMZH":
strSql = "t_lm_b_prop_update_nm";
break;
case "HOTELNMEN":
strSql = "t_lm_b_prop_update_nmen";
break;
case "FOGSTATUS":
strSql = "t_lm_b_prop_update_status";
break;
case "CITY":
strSql = "t_lm_b_prop_update_city";
break;
case "DIAMOND":
strSql = "t_lm_b_prop_update_diamond";
break;
case "STAR":
strSql = "t_lm_b_prop_update_star";
break;
case "OPENDT":
strSql = "t_lm_b_prop_update_open";
break;
case "RENOVATIONDT":
strSql = "t_lm_b_prop_update_ren";
break;
case "TRADEAREA":
strSql = "t_lm_b_prop_update_tra";
break;
case "ADDRESS":
strSql = "t_lm_b_prop_update_address";
break;
case "WEBSITE":
strSql = "t_lm_b_prop_update_web";
break;
case "LINKTEL":
strSql = "t_lm_b_prop_update_tel";
break;
case "LINKFAX":
strSql = "t_lm_b_prop_update_fax";
break;
case "LINKMAN":
strSql = "t_lm_b_prop_update_man";
break;
case "LINKMAIL":
strSql = "t_lm_b_prop_update_mail";
break;
case "LONGITUDE":
strSql = "t_lm_b_prop_update_long";
break;
case "LATITUDE":
strSql = "t_lm_b_prop_update_lati";
break;
case "DESCZH":
strSql = "t_lm_b_prop_update_desc";
break;
default:
strSql = "";
break;
}
UpdateHubsInfo.SqlId = strSql;
UpdateHubsInfo.Parameters = lmInfoParm;
sqlList.Add(UpdateHubsInfo);
}
DbManager.ExecuteSqlTran(sqlList);
return 1;
}
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;
}
//private static string AppendString(string param)
//{
// string result = "";
// string[] temp = param.Split(',');
// foreach (string strTemp in temp)
// {
// result = (!String.IsNullOrEmpty(strTemp)) ? result + "'" + strTemp + "'," : result;
// }
// result = (result.Length > 1) ? result.Substring(0, result.Length - 1) : result;
// return result;
//}
//private static bool IsMobileNumber(string str_telephone)
//{
// return System.Text.RegularExpressions.Regex.IsMatch(str_telephone, @"(1[3,4,5,8][0-9])\d{8}$");
//}
public static PromotionEntity Update(PromotionEntity promotionEntity)
{
if (promotionEntity.PromotionDBEntity.Count == 0)
{
promotionEntity.Result = 0;
return promotionEntity;
}
if (promotionEntity.LogMessages == null)
{
promotionEntity.Result = 0;
return promotionEntity;
}
if (!CheckUpdate(promotionEntity))
{
promotionEntity.Result = 2;
return promotionEntity;
}
PromotionDBEntity dbParm = (promotionEntity.PromotionDBEntity.Count > 0) ? promotionEntity.PromotionDBEntity[0] : new PromotionDBEntity();
if ("1".Equals(dbParm.Status))
{
DataSet dsErr = CheckErrUpdate(promotionEntity);
if (dsErr.Tables.Count > 0 && dsErr.Tables[0].Rows.Count > 0)
{
promotionEntity.Result = 3;
promotionEntity.ErrorMSG = dsErr.Tables[0].Rows[0]["pro_title"].ToString();
return promotionEntity;
}
}
List<CommandInfo> sqlList = new List<CommandInfo>();
string strImageID = "";
if (!String.IsNullOrEmpty(dbParm.ImagePath))
{
CommandInfo InsertLmImagesInfo = new CommandInfo();
OracleParameter[] lmImagesParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("TITLE",OracleType.VarChar),
new OracleParameter("PATH",OracleType.VarChar)
};
if (String.IsNullOrEmpty(dbParm.Imageid))
{
lmImagesParm[0].Value = getMaxIDfromSeq("T_IMAGE_SEQ");
}
else
{
lmImagesParm[0].Value = dbParm.Imageid;
}
lmImagesParm[1].Value = DBNull.Value;
lmImagesParm[2].Value = dbParm.ImagePath;
InsertLmImagesInfo.SqlName = "Promotion";
if (String.IsNullOrEmpty(dbParm.Imageid))
{
InsertLmImagesInfo.SqlId = "t_lm_promotion_t_images_insert";
}
else
{
InsertLmImagesInfo.SqlId = "t_lm_promotion_t_images_update";
}
InsertLmImagesInfo.Parameters = lmImagesParm;
sqlList.Add(InsertLmImagesInfo);
strImageID = lmImagesParm[0].Value.ToString();
}
CommandInfo InsertLmPromMsgInfo = new CommandInfo();
OracleParameter[] lmPromMsgParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("TITLE",OracleType.VarChar),
new OracleParameter("PRIORITY",OracleType.VarChar),
new OracleParameter("STARTDTIME",OracleType.VarChar),
new OracleParameter("ENDDTIME",OracleType.VarChar),
new OracleParameter("CONTENT",OracleType.VarChar),
new OracleParameter("IMAGEID",OracleType.VarChar),
new OracleParameter("STATUS",OracleType.VarChar),
new OracleParameter("OPERATEUSER",OracleType.VarChar),
new OracleParameter("RATECODE",OracleType.VarChar),
new OracleParameter("PROMETHODID",OracleType.VarChar)
};
lmPromMsgParm[0].Value = dbParm.ID;
lmPromMsgParm[1].Value = dbParm.Title;
lmPromMsgParm[2].Value = dbParm.Priority;
lmPromMsgParm[3].Value = dbParm.StartDTime;
lmPromMsgParm[4].Value = dbParm.EndDTime;
lmPromMsgParm[5].Value = dbParm.Content;
if (String.IsNullOrEmpty(strImageID))
{
lmPromMsgParm[6].Value = DBNull.Value;
}
else
{
lmPromMsgParm[6].Value = strImageID;
}
lmPromMsgParm[7].Value = dbParm.Status;
lmPromMsgParm[8].Value = (promotionEntity.LogMessages != null) ? promotionEntity.LogMessages.Userid : "";
lmPromMsgParm[9].Value = String.IsNullOrEmpty(dbParm.RateCode) ? "" : dbParm.RateCode;
lmPromMsgParm[10].Value = dbParm.Promethodid;
InsertLmPromMsgInfo.SqlName = "Promotion";
InsertLmPromMsgInfo.SqlId = "t_lm_promotionmsg_update";
InsertLmPromMsgInfo.Parameters = lmPromMsgParm;
sqlList.Add(InsertLmPromMsgInfo);
CommandInfo UpdateLmPromMsgDetailDelInfo = new CommandInfo();
OracleParameter[] lmPromMsgDetailDelParm ={
new OracleParameter("ID",OracleType.Int32)
};
lmPromMsgDetailDelParm[0].Value = dbParm.ID;
UpdateLmPromMsgDetailDelInfo.SqlName = "Promotion";
UpdateLmPromMsgDetailDelInfo.SqlId = "t_lm_promotionmsg_detail_update";
UpdateLmPromMsgDetailDelInfo.Parameters = lmPromMsgDetailDelParm;
sqlList.Add(UpdateLmPromMsgDetailDelInfo);
string PromotionCommonKey = String.IsNullOrEmpty(ConfigurationManager.AppSettings["PromotionCommonKey"]) ? "000000" : ConfigurationManager.AppSettings["PromotionCommonKey"].ToString();
CommandInfo InsertLmPromMsgDetailInfo = new CommandInfo();
OracleParameter[] lmPromMsgDetailParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("PROTYPE",OracleType.VarChar),
new OracleParameter("COMMONLIST",OracleType.VarChar),
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("LINKURL",OracleType.VarChar)
};
lmPromMsgDetailParm[0].Value = lmPromMsgParm[0].Value;
lmPromMsgDetailParm[1].Value = dbParm.Type;
InsertLmPromMsgDetailInfo.SqlName = "Promotion";
if ("0".Equals(dbParm.Type))
{
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_all_insert";
lmPromMsgDetailParm[2].Value = DBNull.Value;
lmPromMsgDetailParm[3].Value = DBNull.Value;
}
else if ("1".Equals(dbParm.Type))
{
lmPromMsgDetailParm[2].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromMsgDetailParm[3].Value = DBNull.Value;
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_city_insert";
}
else if ("2".Equals(dbParm.Type))
{
lmPromMsgDetailParm[2].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromMsgDetailParm[3].Value = DBNull.Value;
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_group_insert";
}
else if ("3".Equals(dbParm.Type))
{
lmPromMsgDetailParm[2].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromMsgDetailParm[3].Value = DBNull.Value;
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_hotel_insert";
}
else if ("4".Equals(dbParm.Type))
{
lmPromMsgDetailParm[2].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey + "," : dbParm.CommonList;
lmPromMsgDetailParm[3].Value = ("1".Equals(dbParm.ChkType)) ? PromotionCommonKey : dbParm.HotelID;
InsertLmPromMsgDetailInfo.SqlId = "t_lm_promotionmsg_detail_room_insert";
}
if (String.IsNullOrEmpty(dbParm.LinkUrl))
{
lmPromMsgDetailParm[4].Value = DBNull.Value;
}
else
{
lmPromMsgDetailParm[4].Value = dbParm.LinkUrl;
}
InsertLmPromMsgDetailInfo.Parameters = lmPromMsgDetailParm;
sqlList.Add(InsertLmPromMsgDetailInfo);
if (dbParm.UserGroupList.Length > 0)
{
CommandInfo InsertLmPromMsgUserGroupInfo = new CommandInfo();
OracleParameter[] lmPromMsgDetailUserGroupParm ={
new OracleParameter("ID",OracleType.Int32),
new OracleParameter("PROTYPE",OracleType.VarChar),
new OracleParameter("USERGROUPLIST",OracleType.VarChar),
new OracleParameter("LINKURL",OracleType.VarChar)
};
lmPromMsgDetailUserGroupParm[0].Value = lmPromMsgParm[0].Value;
lmPromMsgDetailUserGroupParm[1].Value = "5";
lmPromMsgDetailUserGroupParm[2].Value = dbParm.UserGroupList;
if (String.IsNullOrEmpty(dbParm.LinkUrl))
{
lmPromMsgDetailUserGroupParm[3].Value = DBNull.Value;
}
else
{
lmPromMsgDetailUserGroupParm[3].Value = dbParm.LinkUrl;
}
InsertLmPromMsgUserGroupInfo.SqlName = "Promotion";
InsertLmPromMsgUserGroupInfo.SqlId = "t_lm_promotionmsg_usergroup_insert";
InsertLmPromMsgUserGroupInfo.Parameters = lmPromMsgDetailUserGroupParm;
sqlList.Add(InsertLmPromMsgUserGroupInfo);
}
DbManager.ExecuteSqlTran(sqlList);
SetPromotionData(promotionEntity, strImageID);
promotionEntity.Result = 1;
return promotionEntity;
}
public static void PinyingSetting()
{
DateTime dtBegin = new DateTime();
dtBegin = System.DateTime.Now;
DataSet dsHotel = PinyingDA.GetHotelPinyingList();
if (dsHotel.Tables.Count == 0 || dsHotel.Tables[0].Rows.Count == 0)
{
return;
}
CommonEntity _commonEntity = new CommonEntity();
_commonEntity.LogMessages = new Common.Logger.LogMessage();
IPHostEntry hostInfo = Dns.GetHostByName(Dns.GetHostName());
IPAddress[] address = hostInfo.AddressList;
string m_IP = address[0].ToString();
_commonEntity.LogMessages.IpAddress = m_IP;
_commonEntity.LogMessages.Computername = Dns.GetHostName();
_commonEntity.LogMessages.Userid = "JOB System";
_commonEntity.LogMessages.Username = "******";
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
string strResult = "";
string strContent = "";
string strTemp = "酒店目的地信息管理--酒店ID：{0} 全拼：{1} 短拼：{2}";
string strSQL = XmlSqlAnalyze.GotSqlTextFromXml("Pinying", "t_lm_b_pinying_hotel_save");
Hashtable htList = new Hashtable();
int iCount = 0;
int MaxLength = (String.IsNullOrEmpty(ConfigurationManager.AppSettings["MaxLength"].ToString())) ? 1000 : int.Parse(ConfigurationManager.AppSettings["MaxLength"].ToString());
List<CommandInfo> cmdList = new List<CommandInfo>();
ChineseCode chineseCode = new ChineseCode();
for (int i = 0; i <= dsHotel.Tables[0].Rows.Count - 1; i++)
{
if (String.IsNullOrEmpty(dsHotel.Tables[0].Rows[i]["HOTELID"].ToString()))
{
continue;
}
//dsHotel.Tables[0].Rows[i]["LPINYIN"] = HotelVp.Common.Utilities.PinyinHelper.GetPinyin(dsHotel.Tables[0].Rows[i]["PROPNAME"].ToString().Trim());
//dsHotel.Tables[0].Rows[i]["SPINYIN"] = HotelVp.Common.Utilities.PinyinHelper.GetShortPinyin(dsHotel.Tables[0].Rows[i]["PROPNAME"].ToString().Trim());
try
{
dsHotel.Tables[0].Rows[i]["LPINYIN"] = String.IsNullOrEmpty(dsHotel.Tables[0].Rows[i]["PROPNAME"].ToString().Trim()) ? "" : chineseCode.GetSpell(dsHotel.Tables[0].Rows[i]["PROPNAME"].ToString().Trim());
dsHotel.Tables[0].Rows[i]["SPINYIN"] = String.IsNullOrEmpty(dsHotel.Tables[0].Rows[i]["PROPNAME"].ToString().Trim()) ? "" : chineseCode.IndexCode(dsHotel.Tables[0].Rows[i]["PROPNAME"].ToString().Trim()).ToLower();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
CommandInfo cminfo = new CommandInfo();
cminfo.CommandText = strSQL;
OracleParameter[] lmParm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("LPINYIN",OracleType.VarChar),
new OracleParameter("SPINYIN",OracleType.VarChar)
};
lmParm[0].Value = dsHotel.Tables[0].Rows[i]["HOTELID"].ToString();
lmParm[1].Value = dsHotel.Tables[0].Rows[i]["LPINYIN"].ToString();
lmParm[2].Value = dsHotel.Tables[0].Rows[i]["SPINYIN"].ToString();
cminfo.Parameters = lmParm;
cmdList.Add(cminfo);
iCount = iCount + 1;
if (MaxLength == iCount)
{
try
{
PinyingDA.SavePinyingCommonList(cmdList);
strResult = "成功";
}
catch
{
strResult = "失败";
}
foreach (CommandInfo tempinfo in cmdList)
{
OracleParameter[] tempParm = (OracleParameter[])tempinfo.Parameters;
strContent = string.Format(strTemp, tempParm[0].Value.ToString(), tempParm[1].Value.ToString(), tempParm[2].Value.ToString());
CommonDBEntity commonDBEntity = new CommonDBEntity();
commonDBEntity.Event_Type = "JOB-酒店拼音设置";
commonDBEntity.Event_Content = strContent;
commonDBEntity.Event_Result = strResult;
commonDBEntity.Event_ID = tempParm[0].Value.ToString();
commonDBEntity.UserID = "JOB System";
commonDBEntity.UserID = "JOB System";
_commonEntity.LogMessages.Event_id = tempParm[0].Value.ToString();
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
_commonEntity.CommonDBEntity.Clear();
Console.WriteLine(strContent + "设置结果：" + strResult);
}
iCount = 0;
cmdList.Clear();
}
}
if (iCount > 0)
{
try
{
PinyingDA.SavePinyingCommonList(cmdList);
strResult = "成功";
}
catch
{
strResult = "失败";
}
foreach (CommandInfo tempinfo in cmdList)
{
OracleParameter[] tempParm = (OracleParameter[])tempinfo.Parameters;
strContent = string.Format(strTemp, tempParm[0].Value.ToString(), tempParm[1].Value.ToString(), tempParm[2].Value.ToString());
CommonDBEntity commDBEntity = new CommonDBEntity();
commDBEntity.Event_Type = "JOB-酒店拼音设置";
commDBEntity.Event_Content = strContent;
commDBEntity.Event_Result = strResult;
commDBEntity.Event_ID = tempParm[0].Value.ToString();
_commonEntity.LogMessages.Event_id = tempParm[0].Value.ToString();
_commonEntity.CommonDBEntity.Add(commDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
_commonEntity.CommonDBEntity.Clear();
Console.WriteLine(strContent + "设置结果：" + strResult);
}
}
DateTime dtEnd = new DateTime();
dtEnd = System.DateTime.Now;
Console.WriteLine(dtEnd - dtBegin);
}
public static int FtTypeSeqListUpdate(HotelFacilitiesEntity hotelfacilitiesEntity)
{
if (hotelfacilitiesEntity.HotelFacilitiesDBEntity.Count == 0)
{
return 0;
}
if (hotelfacilitiesEntity.LogMessages == null)
{
return 0;
}
HotelFacilitiesDBEntity dbParm = (hotelfacilitiesEntity.HotelFacilitiesDBEntity.Count > 0) ? hotelfacilitiesEntity.HotelFacilitiesDBEntity[0] : new HotelFacilitiesDBEntity();
List<CommandInfo> sqlList = new List<CommandInfo>();
Hashtable htList = dbParm.FTSeqList;
foreach (System.Collections.DictionaryEntry key in htList)
{
CommandInfo UpdateCsTypeInfo = new CommandInfo();
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("SEQ",OracleType.VarChar)
};
parm[0].Value = key.Key;
parm[1].Value = key.Value;
UpdateCsTypeInfo.SqlName = "HotelFacilities";
UpdateCsTypeInfo.SqlId = "t_lm_b_hotel_facilities_type_seq_update";
UpdateCsTypeInfo.Parameters = parm;
sqlList.Add(UpdateCsTypeInfo);
}
DbManager.ExecuteSqlTran(sqlList);
//DbManager.ExecuteSql("HotelFacilities", "t_lm_b_hotel_facilities_type_seq_update", parm);
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 int HotelInsert(HotelFacilitiesEntity hotelfacilitiesEntity)
{
if (hotelfacilitiesEntity.HotelFacilitiesDBEntity.Count == 0)
{
return 0;
}
if (hotelfacilitiesEntity.LogMessages == null)
{
return 0;
}
HotelFacilitiesDBEntity dbParm = (hotelfacilitiesEntity.HotelFacilitiesDBEntity.Count > 0) ? hotelfacilitiesEntity.HotelFacilitiesDBEntity[0] : new HotelFacilitiesDBEntity();
List<CommandInfo> sqlList = new List<CommandInfo>();
CommandInfo UpdateCsHotelInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("HOTELID",OracleType.VarChar)
};
lmParm[0].Value = dbParm.HotelID;
UpdateCsHotelInfo.SqlName = "HotelFacilities";
UpdateCsHotelInfo.SqlId = "t_lm_b_hotel_service_save_update";
UpdateCsHotelInfo.Parameters = lmParm;
sqlList.Add(UpdateCsHotelInfo);
foreach (string drRow in dbParm.AryFalLisT)
{
CommandInfo InsertCsHotelInfo = new CommandInfo();
OracleParameter[] csParm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("FACILITIESCODE",OracleType.VarChar)
};
csParm[0].Value = dbParm.HotelID;
csParm[1].Value = drRow.Trim();
InsertCsHotelInfo.SqlName = "HotelFacilities";
InsertCsHotelInfo.SqlId = "t_lm_b_hotel_service_save";
InsertCsHotelInfo.Parameters = csParm;
sqlList.Add(InsertCsHotelInfo);
}
//OracleParameter[] lmParm ={
// new OracleParameter("ID",OracleType.Number),
// new OracleParameter("NAMECN",OracleType.VarChar)
// };
//lmParm[0].Value = getMaxIDfromSeq("t_lm_b_facilities_hotel_SEQ");
//lmParm[1].Value = dbParm.Name_CN;
//DbManager.ExecuteSql("HotelFacilities", "t_lm_b_hotel_service_save", lmParm);
DbManager.ExecuteSqlTran(sqlList);
return 1;
}
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 void BDTudeConvertSetting()
{
string strResult = "";
string strSQL = XmlSqlAnalyze.GotSqlTextFromXml("GGBDTude", "t_lm_b_hotel_save");
int iCount = 0;
int MaxLength = (String.IsNullOrEmpty(ConfigurationManager.AppSettings["MaxLength"].ToString())) ? 1000 : int.Parse(ConfigurationManager.AppSettings["MaxLength"].ToString());
List<CommandInfo> cmdList = new List<CommandInfo>();
string[] Los = new string[2];
DataSet dsHotel = GGBDTudeDA.GetHotelList();
for (int i = 0; i <= dsHotel.Tables[0].Rows.Count; i++)
{
// 城市-销售人员名-酒店名前四个字母
try
{
Los = GGBDCovertHelper.GGBDCovert(dsHotel.Tables[0].Rows[i]["longitude"].ToString(), dsHotel.Tables[0].Rows[i]["latitude"].ToString());
CommandInfo cminfo = new CommandInfo();
cminfo.CommandText = strSQL;
OracleParameter[] parm ={
new OracleParameter("HOTELID",OracleType.VarChar),
new OracleParameter("LONGITUDE",OracleType.VarChar),
new OracleParameter("LATITUDE",OracleType.VarChar)
};
parm[0].Value = dsHotel.Tables[0].Rows[i]["prop"].ToString();
parm[1].Value = Los[0];
parm[2].Value = Los[1];
cminfo.Parameters = parm;
cmdList.Add(cminfo);
iCount = iCount + 1;
if (MaxLength == iCount)
{
try
{
GGBDTudeDA.SaveHotelTudeCommonList(cmdList);
iCount = 0;
cmdList.Clear();
strResult = "成功";
}
catch
{
strResult = "失败";
}
}
//GGBDTudeDA.SaveHotelTude(dsHotel.Tables[0].Rows[i]["prop"].ToString(), GGBDCovert.GGBDCovert(dsHotel.Tables[0].Rows[i]["longitude"].ToString(), dsHotel.Tables[0].Rows[i]["latitude"].ToString()));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
if (iCount > 0)
{
try
{
GGBDTudeDA.SaveHotelTudeCommonList(cmdList);
strResult = "成功";
}
catch
{
strResult = "失败";
}
}
Console.WriteLine(strResult);
}