public static void AutoHotelPlaning() { DateTime dtBegin = new DateTime(); dtBegin = System.DateTime.Now; AutoHotelPlanEntity _autohotelplanEntity = new AutoHotelPlanEntity(); CommonEntity _commonEntity = new CommonEntity(); _autohotelplanEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _autohotelplanEntity.LogMessages.Userid = "JOB System"; _autohotelplanEntity.LogMessages.Username = "******"; _autohotelplanEntity.AutoHotelPlanDBEntity = new List<AutoHotelPlanDBEntity>(); AutoHotelPlanDBEntity appcontentDBEntity = new AutoHotelPlanDBEntity(); _autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity); Console.WriteLine("酒店销售计划JOB自动运行开始"); int iCount = AutoSelect(_autohotelplanEntity); Console.WriteLine("酒店销售计划JOB自动运行 执行记录数:" + iCount.ToString()); //Console.WriteLine("发送邮件开始"); //bool bResult = SendMailExpress(dsResult); //string strResult = "失败"; //if (bResult) //{ // strResult = "成功"; //} //else //{ // Thread.Sleep(5000); //} //Console.WriteLine("发送邮件结束 结果:" + strResult); DateTime dtEnd = new DateTime(); dtEnd = System.DateTime.Now; Console.WriteLine(dtEnd - dtBegin); }
private static string ApplySalesRoomService(DataRow drRow, string Type) { AutoHotelPlanEntity _autohotelplanEntity = new AutoHotelPlanEntity(); _autohotelplanEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _autohotelplanEntity.LogMessages.Userid = "JOB System"; _autohotelplanEntity.LogMessages.Username = drRow["Create_User"].ToString().Trim(); _autohotelplanEntity.AutoHotelPlanDBEntity = new List<AutoHotelPlanDBEntity>(); AutoHotelPlanDBEntity appcontentDBEntity = new AutoHotelPlanDBEntity(); appcontentDBEntity.HotelID = drRow["HOTEL_ID"].ToString().Trim(); appcontentDBEntity.PriceCode = drRow["RATE_CODE"].ToString().Trim(); appcontentDBEntity.RoomCode = drRow["ROOM_TYPE_CODE"].ToString().Trim(); appcontentDBEntity.RoomName = drRow["ROOM_TYPE_NAME"].ToString().Trim(); appcontentDBEntity.StartDTime = drRow["StartDtime"].ToString().Trim(); appcontentDBEntity.EndDTime = drRow["EndDtime"].ToString().Trim(); appcontentDBEntity.EffHour = drRow["EFFECT_HOUR"].ToString().Trim(); appcontentDBEntity.WeekList = drRow["Week_List"].ToString().Trim(); appcontentDBEntity.Note1 = drRow["GUAID"].ToString().Trim(); appcontentDBEntity.Note2 = drRow["CXLID"].ToString().Trim(); appcontentDBEntity.OnePrice = drRow["ONE_PRICE"].ToString().Trim(); appcontentDBEntity.TwoPrice = drRow["TWO_PRICE"].ToString().Trim(); appcontentDBEntity.ThreePrice = drRow["THREE_PRICE"].ToString().Trim(); appcontentDBEntity.FourPrice = drRow["FOUR_PRICE"].ToString().Trim(); appcontentDBEntity.BedPrice = drRow["ATTN_PRICE"].ToString().Trim(); appcontentDBEntity.BreakfastNum = drRow["BREAKFAST_NUM"].ToString().Trim(); appcontentDBEntity.BreakPrice = drRow["EACH_BREAKFAST_PRICE"].ToString().Trim(); appcontentDBEntity.IsNetwork = drRow["IS_NETWORK"].ToString().Trim(); appcontentDBEntity.Offsetval = drRow["OFFSETVAL"].ToString().Trim(); appcontentDBEntity.Offsetunit = drRow["OFFSETUNIT"].ToString().Trim(); appcontentDBEntity.RoomStatus = drRow["STATUS"].ToString().Trim(); appcontentDBEntity.RoomCount = drRow["ROOM_NUM"].ToString().Trim(); appcontentDBEntity.IsReserve = drRow["IS_RESERVE"].ToString().Trim(); appcontentDBEntity.UpdateUser = drRow["Create_User"].ToString().Trim(); appcontentDBEntity.TypeID = Type; _autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity); _autohotelplanEntity = AutoHotelPlanSA.ApplySalesPlan(_autohotelplanEntity); return _autohotelplanEntity.ErrorMSG; }
private static int AutoSelect(AutoHotelPlanEntity autogotelplanEntity) { int iMaxLenth = String.IsNullOrEmpty(ConfigurationManager.AppSettings["MaxLength"]) ? 200 : int.Parse(ConfigurationManager.AppSettings["MaxLength"].ToString()); DataSet dsResult = new DataSet(); dsResult = AutoHotelPlanDA.AutoListSelect(autogotelplanEntity); int iCount = 0; string PlanID=string.Empty; string Status=string.Empty; string Action=string.Empty; string Result=string.Empty; string Username = string.Empty; //string strToDay = DateTime.Now.ToShortDateString(); //int strToWeek = (int)DateTime.Now.DayOfWeek + 1; //string strDayTemp = string.Empty; string strWeekTemp = string.Empty; string strTypeNm = string.Empty; string strTypeTime = string.Empty; string ChkResult = string.Empty; ArrayList alHotelList = new ArrayList(); Hashtable htErrList = new Hashtable(); Hashtable htErr = new Hashtable(); foreach (DataRow drRow in dsResult.Tables[0].Rows) { if (!"0".Equals(drRow["Type"].ToString().Trim())) { ChkResult = CheckApplySalesRoomService(drRow, drRow["Type"].ToString().Trim()); if (!String.IsNullOrEmpty(ChkResult)) { htErrList.Add(drRow["HPID"].ToString().Trim(), ChkResult); } else { alHotelList.Add(drRow); } } else { alHotelList.Add(drRow); } iCount = iCount + 1; if (iCount == iMaxLenth) { htErr = ApplySalesRoomServiceList(alHotelList); foreach (System.Collections.DictionaryEntry item in htErr) { if (!htErrList.ContainsKey(item.Key.ToString())) { htErrList.Add(item.Key.ToString(), item.Value.ToString()); } } iCount = 0; } } if (iCount > 0) { htErr = ApplySalesRoomServiceList(alHotelList); foreach (System.Collections.DictionaryEntry item in htErr) { if (!htErrList.ContainsKey(item.Key.ToString())) { htErrList.Add(item.Key.ToString(), item.Value.ToString()); } } } foreach (DataRow drRow in dsResult.Tables[0].Rows) { if ("0".Equals(drRow["Type"].ToString().Trim())) { strTypeNm = "立即保存"; strTypeTime = drRow["Plan_DTime"].ToString().Trim(); PlanID = drRow["HPID"].ToString().Trim(); Status = "2"; Action = "1"; //Result = ApplySalesRoomService(drRow, drRow["Type"].ToString().Trim()); Result = htErrList[drRow["HPID"].ToString().Trim()].ToString(); Username = drRow["Create_User"].ToString().Trim(); AutoHotelPlanDA.UpdateSalesPlanEventStatus(PlanID, Status, Action, Result, Username); AutoHotelPlanDA.UpdateSalesPlanEventJobStatus(drRow["JID"].ToString().Trim(), Action, Result, Username); iCount = iCount + 1; } else if ("1".Equals(drRow["Type"].ToString().Trim())) { strTypeNm = "定时保存"; strTypeTime = drRow["Plan_DTime"].ToString().Trim(); PlanID = drRow["HPID"].ToString().Trim(); Status = "2"; Action = "1"; //Result = ApplySalesRoomService(drRow, drRow["Type"].ToString().Trim()); Result = htErrList[drRow["HPID"].ToString().Trim()].ToString(); Username = drRow["Create_User"].ToString().Trim(); AutoHotelPlanDA.UpdateSalesPlanEventStatus(PlanID, Status, Action, Result, Username); AutoHotelPlanDA.UpdateSalesPlanEventJobStatus(drRow["JID"].ToString().Trim(), Action, Result, Username); iCount = iCount + 1; } else if ("2".Equals(drRow["Type"].ToString().Trim())) { strTypeNm = "每日自动更新"; strTypeTime = drRow["PlanTime"].ToString().Trim(); //strDayTemp = drRow["EndDtime"].ToString().Trim(); strWeekTemp = drRow["Week_List"].ToString().Trim(); Status = (DateTime.Parse(drRow["JPDTime"].ToString().Trim()) == DateTime.Parse(drRow["PlanPlanEnd"].ToString().Trim() + " " + drRow["PlanTime"].ToString().Trim())) ? "2" : "1"; PlanID = drRow["HPID"].ToString().Trim(); //Console.WriteLine("Action:" + drRow["Action"].ToString().Trim()); //Console.WriteLine("HPID:" + drRow["HPID"].ToString().Trim()); //Console.WriteLine(htErrList[drRow["HPID"].ToString().Trim()].ToString()); Action = ChkNumerVal(drRow["Action"].ToString().Trim()).ToString(); //Result = ApplySalesRoomService(drRow, drRow["Type"].ToString().Trim()); Result = htErrList[drRow["HPID"].ToString().Trim()].ToString(); Username = drRow["Create_User"].ToString().Trim(); AutoHotelPlanDA.UpdateSalesPlanEventStatus(PlanID, Status, Action, Result, Username); AutoHotelPlanDA.UpdateSalesPlanEventJobStatus(drRow["JID"].ToString().Trim(), "1", Result, Username); iCount = iCount + 1; } CommonEntity _commonEntity = new CommonEntity(); _commonEntity.LogMessages = autogotelplanEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "酒店销售计划-JOB"; commonDBEntity.Event_ID = drRow["HPID"].ToString().Trim(); string conTent = "销售计划 运行一次 - 计划ID:{0} 更新方式:{1} 定时执行时间:{2} 定时开始日期:{3} 定时结束日期:{4} 星期详情:{5} 修改时间:{6} 修改人:{7}"; conTent = string.Format(conTent, drRow["HPID"].ToString().Trim(), strTypeNm, strTypeTime, drRow["StartDtime"].ToString().Trim(), drRow["EndDtime"].ToString().Trim(), strWeekTemp, drRow["Update_Time"].ToString().Trim(), drRow["Update_User"].ToString().Trim()); commonDBEntity.Event_Content = conTent; commonDBEntity.Event_Result = Result; _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); } return dsResult.Tables[0].Rows.Count; }
private static Hashtable ApplySalesRoomServiceList(ArrayList alHotelList) { AutoHotelPlanEntity _autohotelplanEntity = new AutoHotelPlanEntity(); _autohotelplanEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _autohotelplanEntity.LogMessages.Userid = "JOB System"; _autohotelplanEntity.LogMessages.Username = "******"; _autohotelplanEntity.AutoHotelPlanDBEntity = new List<AutoHotelPlanDBEntity>(); for (int i = 0; i < alHotelList.Count; i++) { DataRow drRow = (DataRow)alHotelList[i]; AutoHotelPlanDBEntity appcontentDBEntity = new AutoHotelPlanDBEntity(); appcontentDBEntity.HotelID = drRow["HOTEL_ID"].ToString().Trim(); appcontentDBEntity.PriceCode = drRow["RATE_CODE"].ToString().Trim(); appcontentDBEntity.RoomCode = drRow["ROOM_TYPE_CODE"].ToString().Trim(); appcontentDBEntity.RoomName = drRow["ROOM_TYPE_NAME"].ToString().Trim(); appcontentDBEntity.StartDTime = drRow["StartDtime"].ToString().Trim(); appcontentDBEntity.EndDTime = drRow["EndDtime"].ToString().Trim(); appcontentDBEntity.EffHour = drRow["EFFECT_HOUR"].ToString().Trim(); appcontentDBEntity.WeekList = drRow["Week_List"].ToString().Trim(); appcontentDBEntity.Note1 = drRow["GUAID"].ToString().Trim(); appcontentDBEntity.Note2 = drRow["CXLID"].ToString().Trim(); appcontentDBEntity.OnePrice = drRow["ONE_PRICE"].ToString().Trim(); appcontentDBEntity.TwoPrice = drRow["TWO_PRICE"].ToString().Trim(); appcontentDBEntity.ThreePrice = drRow["THREE_PRICE"].ToString().Trim(); appcontentDBEntity.FourPrice = drRow["FOUR_PRICE"].ToString().Trim(); appcontentDBEntity.BedPrice = drRow["ATTN_PRICE"].ToString().Trim(); appcontentDBEntity.NetPrice = drRow["NET_PRICE"].ToString().Trim(); appcontentDBEntity.BreakfastNum = drRow["BREAKFAST_NUM"].ToString().Trim(); appcontentDBEntity.BreakPrice = drRow["EACH_BREAKFAST_PRICE"].ToString().Trim(); appcontentDBEntity.IsNetwork = drRow["IS_NETWORK"].ToString().Trim(); appcontentDBEntity.Offsetval = drRow["OFFSETVAL"].ToString().Trim(); appcontentDBEntity.Offsetunit = drRow["OFFSETUNIT"].ToString().Trim(); appcontentDBEntity.RoomStatus = drRow["STATUS"].ToString().Trim(); appcontentDBEntity.RoomCount = drRow["ROOM_NUM"].ToString().Trim(); appcontentDBEntity.IsReserve = drRow["IS_RESERVE"].ToString().Trim(); appcontentDBEntity.UpdateUser = drRow["Create_User"].ToString().Trim(); appcontentDBEntity.TypeID = drRow["Type"].ToString().Trim(); appcontentDBEntity.HPID = drRow["HPID"].ToString().Trim(); appcontentDBEntity.Supplier = drRow["SOURCE"].ToString().Trim(); _autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity); } Hashtable htResult = new Hashtable(); htResult = AutoHotelPlanSA.ApplySalesPlanList(_autohotelplanEntity); return htResult; }
private static int AutoSelect(AutoHotelPlanEntity autogotelplanEntity) { DataSet dsResult = new DataSet(); dsResult = AutoHotelPlanDA.AutoListSelect(autogotelplanEntity); int iCount = 0; string PlanID=string.Empty; string Status=string.Empty; string Action=string.Empty; string Result=string.Empty; string Username = string.Empty; //string strToDay = DateTime.Now.ToShortDateString(); //int strToWeek = (int)DateTime.Now.DayOfWeek + 1; //string strDayTemp = string.Empty; string strWeekTemp = string.Empty; string strTypeNm = string.Empty; string strTypeTime = string.Empty; foreach (DataRow drRow in dsResult.Tables[0].Rows) { if ("0".Equals(drRow["Type"].ToString().Trim())) { strTypeNm = "立即保存"; strTypeTime = drRow["Plan_DTime"].ToString().Trim(); PlanID = drRow["HPID"].ToString().Trim(); Status = "2"; Action = "1"; Result = ApplySalesRoomService(drRow, drRow["Type"].ToString().Trim()); Username = drRow["Create_User"].ToString().Trim(); AutoHotelPlanDA.UpdateSalesPlanEventStatus(PlanID, Status, Action, Result, Username); AutoHotelPlanDA.UpdateSalesPlanEventJobStatus(drRow["JID"].ToString().Trim(), Action, Result, Username); iCount = iCount + 1; } else if ("1".Equals(drRow["Type"].ToString().Trim())) { strTypeNm = "定时保存"; strTypeTime = drRow["Plan_DTime"].ToString().Trim(); PlanID = drRow["HPID"].ToString().Trim(); Status = "2"; Action = "1"; Result = ApplySalesRoomService(drRow, drRow["Type"].ToString().Trim()); Username = drRow["Create_User"].ToString().Trim(); AutoHotelPlanDA.UpdateSalesPlanEventStatus(PlanID, Status, Action, Result, Username); AutoHotelPlanDA.UpdateSalesPlanEventJobStatus(drRow["JID"].ToString().Trim(), Action, Result, Username); iCount = iCount + 1; } else if ("2".Equals(drRow["Type"].ToString().Trim())) { strTypeNm = "每日自动更新"; strTypeTime = drRow["PlanTime"].ToString().Trim(); //strDayTemp = drRow["EndDtime"].ToString().Trim(); strWeekTemp = drRow["Week_List"].ToString().Trim(); Status = (DateTime.Parse(drRow["JPDTime"].ToString().Trim()) == DateTime.Parse(drRow["PlanPlanEnd"].ToString().Trim() + " " + drRow["PlanTime"].ToString().Trim())) ? "2" : "1"; PlanID = drRow["HPID"].ToString().Trim(); Action = ChkNumerVal(drRow["Action"].ToString().Trim()).ToString(); Result = ApplySalesRoomService(drRow, drRow["Type"].ToString().Trim()); Username = drRow["Create_User"].ToString().Trim(); AutoHotelPlanDA.UpdateSalesPlanEventStatus(PlanID, Status, Action, Result, Username); AutoHotelPlanDA.UpdateSalesPlanEventJobStatus(drRow["JID"].ToString().Trim(), "1", Result, Username); iCount = iCount + 1; } CommonEntity _commonEntity = new CommonEntity(); _commonEntity.LogMessages = autogotelplanEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "酒店销售计划-JOB"; commonDBEntity.Event_ID = drRow["HPID"].ToString().Trim(); string conTent = "销售计划 运行一次 - 计划ID:{0} 更新方式:{1} 定时执行时间:{2} 定时开始日期:{3} 定时结束日期:{4} 星期详情:{5} 修改时间:{6} 修改人:{7}"; conTent = string.Format(conTent, drRow["HPID"].ToString().Trim(), strTypeNm, strTypeTime, drRow["StartDtime"].ToString().Trim(), drRow["EndDtime"].ToString().Trim(), strWeekTemp, drRow["Update_Time"].ToString().Trim(), drRow["Update_User"].ToString().Trim()); commonDBEntity.Event_Content = conTent; commonDBEntity.Event_Result = Result; _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); } return iCount; }
public static DataSet AutoListSelect(AutoHotelPlanEntity autohotelplanEntity) { AutoHotelPlanDBEntity dbParm = (autohotelplanEntity.AutoHotelPlanDBEntity.Count > 0) ? autohotelplanEntity.AutoHotelPlanDBEntity[0] : new AutoHotelPlanDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("AutoListSelect"); return cmd.ExecuteDataSet(); ; }