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);
}
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 int AutoSelect(AutoMsgCancelOrdEntity autogotelplanEntity)
{
string strOrderType = ConfigurationManager.AppSettings["OrderType"].ToString();
DataSet dsResult = new DataSet();
dsResult = AutoMsgCancelOrdDA.AutoListSelect(autogotelplanEntity);
string Result = string.Empty;
foreach (DataRow drRow in dsResult.Tables[0].Rows)
{
if (!ChkOrderType(drRow["ORDERNO"].ToString().Trim(), strOrderType))
{
continue;
}
Result = ApplySendMsgService(drRow);
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["USERID"].ToString().Trim();
string conTent = "订单提示短信JOB - FOG订单ID：{0} 创建人：{1} 创建时间：{2} ";
conTent = string.Format(conTent, drRow["ORDERNO"].ToString().Trim(), drRow["USERID"].ToString().Trim(), drRow["CREATETIME"].ToString().Trim());
commonDBEntity.Event_Content = conTent;
commonDBEntity.Event_Result = Result;
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
}
return dsResult.Tables[0].Rows.Count;
}
public static void PusMsgHelping(DataSet dsPusMsgList)
{
int iMaxRows = int.Parse(ConfigurationManager.AppSettings["MaxRows"].ToString());
bool bSleep = (dsPusMsgList.Tables[0].Rows.Count > iMaxRows) ? true : false;
//Variables you may need to edit:
//---------------------------------
//True if you are using sandbox certificate, or false if using production
bool sandbox = ("0".Equals(ConfigurationManager.AppSettings["Sandbox"].ToString())) ? true : false;
//Put your device token in here
// string testDeviceToken = "bc9eb0ca6fedb7967ab7563a36fc197b90df3c99aae38db335cb152b7377fdb9";
//Put your PKCS12 .p12 or .pfx filename here.
// Assumes it is in the same directory as your app
string p12File = GetAppValue("p12File");// "aps_production_identity.p12";
//This is the password that you protected your p12File
// If you did not use a password, set it as null or an empty string
string p12FilePassword = GetAppValue("p12FilePassword");//"123456";
//Number of notifications to send
//int count = 1000;
//Number of milliseconds to wait in between sending notifications in the loop
// This is just to demonstrate that the APNS connection stays alive between messages
//string numberFileName = GetAppValue("tokenFile");
string content = "";// GetAppValue("content");
//bool isTest = GetAppValue("isTest") == "true" ? true : false;
//Actual Code starts below:
//--------------------------------
string p12Filename = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, p12File);
//string numFile = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, numberFileName);
//string[] numberList = ReadFile(numFile).Contains(',') ? ReadFile(numFile).Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries) : new string[] { };
//NotificationService service = new NotificationService(sandbox, p12Filename, p12FilePassword, 1, bSleep);
NotificationService service = new NotificationService(sandbox, p12Filename, p12FilePassword, 1);
service.SendRetries = 1; //5 retries before generating notificationfailed event
service.ReconnectDelay = 5000; //5 seconds
service.Error += new NotificationService.OnError(service_Error);
service.NotificationTooLong += new NotificationService.OnNotificationTooLong(service_NotificationTooLong);
service.BadDeviceToken += new NotificationService.OnBadDeviceToken(service_BadDeviceToken);
service.NotificationFailed += new NotificationService.OnNotificationFailed(service_NotificationFailed);
service.NotificationSuccess += new NotificationService.OnNotificationSuccess(service_NotificationSuccess);
service.Connecting += new NotificationService.OnConnecting(service_Connecting);
service.Connected += new NotificationService.OnConnected(service_Connected);
service.Disconnected += new NotificationService.OnDisconnected(service_Disconnected);
//The notifications will be sent like this:
// Testing: 1...
// Testing: 2...
// Testing: 3...
// etc...
//for (int i = 0; i < numberList.Length; i++)
int sleepBetweenNotifications = (bSleep) ? Convert.ToInt32(GetAppValue("sleepBetweenNotificationsshot")) : Convert.ToInt32(GetAppValue("sleepBetweenNotifications")); //100;
string strResult = string.Empty;
CommonEntity commonEntity = new CommonEntity();
commonEntity.LogMessages = new Common.Logger.LogMessage();
commonEntity.LogMessages.Userid = "JOB System";
commonEntity.LogMessages.Username = "******";
commonEntity.CommonDBEntity = new List<CommonDBEntity>();
for (int i = 0; i < dsPusMsgList.Tables[0].Rows.Count ; i++)
{
try
{
//if (!PushTicketMsgDA.CheckPushPlanActionHistory(taskID, dsPusMsgList.Tables[0].Rows[i]["DEVICETOKEN"].ToString().Trim()))
//{
// continue;
//}
CommonDBEntity dbParm = new CommonDBEntity();
dbParm.Event_Type = "Que Ticket Push发送";
if ("0".Equals(dsPusMsgList.Tables[0].Rows[i]["TYPE"].ToString().Trim()))
{
content = String.Format(GetAppValue("oneContent"), dsPusMsgList.Tables[0].Rows[i]["amount"].ToString().Trim());
}
else
{
content = String.Format(GetAppValue("twoContent"), dsPusMsgList.Tables[0].Rows[i]["amount"].ToString().Trim());
}
dbParm.Event_Content = "Que Push发送Telphone： " + dsPusMsgList.Tables[0].Rows[i]["TELPHONE"].ToString().Trim() + "Que Push发送Devicetoken： " + dsPusMsgList.Tables[0].Rows[i]["DEVICETOKEN"].ToString().Trim() + "Que Push发送内容： " + content;
//Create a new notification to send
Notification alertNotification = new Notification(dsPusMsgList.Tables[0].Rows[i]["DEVICETOKEN"].ToString().Trim());
alertNotification.Payload.Alert.Body = string.Format(content);
alertNotification.Payload.Sound = "default";
alertNotification.Payload.Badge = 1;
//Queue the notification to be sent
if (service.QueueNotification(alertNotification, bSleep))
{
strResult = "发送成功";
Console.WriteLine("Notification Queued!");
writeFile(logFile1, content + "Notification Queued!" + dsPusMsgList.Tables[0].Rows[i]["DEVICETOKEN"].ToString().Trim());
}
else
{
strResult = "发送失败";
Console.WriteLine("Notification Failed to be Queued!");
writeFile(logFile1, content + "Notification Failed to be Queued!" + dsPusMsgList.Tables[0].Rows[i]["DEVICETOKEN"].ToString().Trim());
}
dbParm.Event_ID = dsPusMsgList.Tables[0].Rows[i]["TELPHONE"].ToString().Trim();
dbParm.Event_Result = strResult;
commonEntity.CommonDBEntity.Add(dbParm);
//PushTicketMsgDA.InsertPushPlanActionHistory(taskID, dsPusMsgList.Tables[0].Rows[i]["TELPHONE"].ToString().Trim(), dsPusMsgList.Tables[0].Rows[i]["DEVICETOKEN"].ToString().Trim(), strResult);
//Sleep in between each message
//if (i < numberList.Length)
//{
Console.WriteLine("Sleeping " + sleepBetweenNotifications + " milliseconds before next Notification...");
System.Threading.Thread.Sleep(sleepBetweenNotifications);
//}
}
catch (Exception ex)
{
// Log King
CommonDA.InsertEventHistoryError(dsPusMsgList.Tables[0].Rows[i]["TELPHONE"].ToString().Trim(), "Que Push发送Telphone： " + dsPusMsgList.Tables[0].Rows[i]["TELPHONE"].ToString().Trim() + "Que Push发送Devicetoken： " + dsPusMsgList.Tables[0].Rows[i]["DEVICETOKEN"].ToString().Trim() + "Que Push发送异常： " + ex.Message);
Console.WriteLine(ex.Message);
continue;
}
}
Console.WriteLine("Cleaning Up...");
writeFile(logFile, "Cleaning Up...");
//First, close the service.
//This ensures any queued notifications get sent befor the connections are closed
service.Close();
//Clean up
service.Dispose();
Console.WriteLine("Done!");
writeFile(logFile, "Done");
//Console.WriteLine("Press enter to exit...");
//writeFile(logFile, "Press enter to exit...");
//Console.ReadLine();
CommonDA.InsertEventHistory(commonEntity);
}
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;
}