public static DataSet AutoListSelectOrder(AutoMappingBedEntity ordersynchronizingEntity)
{
AutoHotelComparisonDBEntity dbParm = (ordersynchronizingEntity.AutoHotelComparisonDBEntity.Count > 0) ? ordersynchronizingEntity.AutoHotelComparisonDBEntity[0] : new AutoHotelComparisonDBEntity();
OracleParameter[] lmParm ={
new OracleParameter("ORDEID",OracleType.VarChar)
};
if ("0".Equals(dbParm.SaveType))
{
lmParm[0].Value = DBNull.Value;
}
else
{
lmParm[0].Value = GetMaxOrderID();
}
DataSet dsResult = DbManager.Query("AutoMappingBed", "AutoSelectOrderList", false, lmParm);
return dsResult;
}
//static string _nameSpaceClass = "HotelVp.JobConsole.Biz.AutoOrderSynchronizing Method: ";
public static void AutoMappingBeding()
{
DateTime dtBegin = new DateTime();
dtBegin = System.DateTime.Now;
AutoMappingBedEntity _hotelcomparisonEntity = new AutoMappingBedEntity();
CommonEntity _commonEntity = new CommonEntity();
_hotelcomparisonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_hotelcomparisonEntity.LogMessages.Userid = "JOB System";
_hotelcomparisonEntity.LogMessages.Username = "******";
_hotelcomparisonEntity.AutoHotelComparisonDBEntity = new List<AutoHotelComparisonDBEntity>();
AutoHotelComparisonDBEntity hotelcomparisondbentity = new AutoHotelComparisonDBEntity();
_hotelcomparisonEntity.AutoHotelComparisonDBEntity.Add(hotelcomparisondbentity);
Console.WriteLine("ELMappingRoomBedJOB自动运行开始");
int iCount = AutoMappingBeding(_hotelcomparisonEntity);
Console.WriteLine("ELMappingRoomBedJOB自动运行 执行记录数：" + iCount.ToString());
DateTime dtEnd = new DateTime();
dtEnd = System.DateTime.Now;
Console.WriteLine(dtEnd - dtBegin);
}
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 DataSet AutoHotelRoomMappingList(AutoMappingBedEntity ordersynchronizingEntity)
{
DataSet dsResult = DbManager.Query("AutoMappingBed", "AutoHotelRoomMappingList", false);
return dsResult;
}
