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