public static LmSystemLogEntity OrderConfirmSendMsgToLMSales(LmSystemLogEntity dbParm, string strHotelID, string strSendMSG) { DataSet dsSales = LmSystemLogDA.GetSalesLMHotelInfo(strHotelID); if (dsSales.Tables.Count == 0 || dsSales.Tables[0].Rows.Count == 0 || String.IsNullOrEmpty(dsSales.Tables[0].Rows[0]["User_Tel"].ToString())) { return dbParm; } string DataString = ""; DataString = DataString + "{\"method\":\"save\",\"data\":{\"syscode\":\"" + "CMS" + "\",\"reqid\":\"" + dsSales.Tables[0].Rows[0]["User_Tel"].ToString() + "\",\"bizcode\":\"" + "CMS-订单确认短信通知" + "\","; DataString = DataString + "\"cnfnum\":\"" + dbParm.FogOrderID + "\",\"mobiles\":\"" + dsSales.Tables[0].Rows[0]["User_Tel"].ToString() + "\",\"msg\":\"" + strSendMSG + "\","; DataString = DataString + "\"sign\":\"" + PostSignKey("CMS" + dsSales.Tables[0].Rows[0]["User_Tel"].ToString()) + "\"},\"version\":\"v1.0\"}"; string HotelFullRoomUrl = JsonRequestURLBuilder.applySendMsgV2(); CallWebPage callWebPage = new CallWebPage(); string strHotelFullRoom = callWebPage.CallWebByURL(HotelFullRoomUrl, DataString); JObject oHotelFullRoom = JObject.Parse(strHotelFullRoom); if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(oHotelFullRoom, "message").Trim('"'))) { dbParm.Result = 1; dbParm.ErrorMSG = "发送成功!"; } else { dbParm.Result = 2; dbParm.ErrorMSG = "发送失败!" + JsonRequestURLBuilder.GetJsonStringValue(oHotelFullRoom, "message").Trim('"'); } return dbParm; }
//导出Excel文件 protected void btnExport_Click(object sender, EventArgs e) { LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); CommonEntity _commonEntity = new CommonEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.EventID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); _lmSystemLogEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString(); ; _lmSystemLogEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString(); ; _lmSystemLogEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); _lmSystemLogEntity.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString(); _lmSystemLogEntity.PayCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PayCode"].ToString())) ? null : ViewState["PayCode"].ToString(); _lmSystemLogEntity.BookStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BookStatus"].ToString())) ? null : ViewState["BookStatus"].ToString(); _lmSystemLogEntity.PayStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PayStatus"].ToString())) ? null : ViewState["PayStatus"].ToString(); _lmSystemLogEntity.PlatForm = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PlatForm"].ToString())) ? null : ViewState["PlatForm"].ToString(); _lmSystemLogEntity.Ticket = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Ticket"].ToString())) ? null : ViewState["Ticket"].ToString(); _lmSystemLogEntity.Mobile = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Mobile"].ToString())) ? null : ViewState["Mobile"].ToString(); _lmSystemLogEntity.InStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["InStart"].ToString())) ? null : ViewState["InStart"].ToString(); _lmSystemLogEntity.InEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["InEnd"].ToString())) ? null : ViewState["InEnd"].ToString(); _lmSystemLogEntity.Aprove = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Aprove"].ToString())) ? null : ViewState["Aprove"].ToString(); DataSet dsResult = LmSystemLogBP.ReviewSelectByNew(_lmSystemLogEntity).QueryResult; if (dsResult.Tables.Count == 0 && dsResult.Tables[0].Rows.Count ==0) { messageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString(); return; } CommonFunction.ExportExcelForLM(dsResult); }
public static string SetImagePreviewList(string Hid, string Otsd, string Oted, string Fst, string Oid, string Fnu) { LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.HotelID = Hid; _lmSystemLogEntity.OutStart = Otsd; _lmSystemLogEntity.OutEnd = Oted; _lmSystemLogEntity.FaxStatus = Fst; _lmSystemLogEntity.FogOrderID = Oid; _lmSystemLogEntity.FaxNum = Fnu; string json = ""; DataSet dsResult = LmSystemLogBP.HotelFaxHis(_lmSystemLogEntity).QueryResult; try { if (dsResult.Tables[0] != null && dsResult.Tables[0].Rows.Count > 0) { json = ToJson(dsResult.Tables[0]); } else { json = "[{\"FAXBDT\":\"\",\"FAXNID\":\"\",\"FAXUNID\":\"\",\"FAXID\":\"\",\"FAXDT\":\"\",\"FAXTST\":\"\",\"FAXBST\":\"\",\"FAXTURL\":\"\",\"FAXBURL\":\"\"}]"; } } catch (Exception ex) { json = "[{\"FAXBDT\":\"\",\"FAXNID\":\"\",\"FAXUNID\":\"\",\"FAXID\":\"\",\"FAXDT\":\"\",\"FAXTST\":\"\",\"FAXBST\":\"\",\"FAXTURL\":\"\",\"FAXBURL\":\"\"}]"; } return json; }
public static string GetHCorderViewList(string orderID, string hotelID, string contTel) { LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.FogOrderID = orderID; _lmSystemLogEntity.HotelID = hotelID; _lmSystemLogEntity.ContactTel = contTel; string json = ""; DataSet dsResult = LmSystemLogBP.GetHCorderViewList(_lmSystemLogEntity).QueryResult; try { if (dsResult.Tables[0] != null && dsResult.Tables[0].Rows.Count > 0) { json = ToJson(dsResult.Tables[0]); } else { json = "[]"; } } catch (Exception ex) { json = "[]"; } return json; }
public static LmSystemLogEntity ReviewOrderListSelect(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "ReviewOrderListSelect"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return OrderSearchDA.ReviewOrderListSelect(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "ReviewOrderListSelect Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static LmSystemLogEntity ChkOrderOperationSelect(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "ChkOrderOperationSelect"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return LmSystemLogDA.ChkOrderOperationSelect(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "ChkOrderOperationSelect Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static string SetMemoVal(string strKey) { StringBuilder sbMemo = new StringBuilder(); LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.MemoKey = strKey; DataSet dsResult = LmSystemLogBP.GetOrderActionHisList(_lmSystemLogEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { foreach (DataRow drRow in dsResult.Tables[0].Rows) { if ("订单确认".Equals(drRow["EVENT_TYPE"].ToString())) { if (String.IsNullOrEmpty(drRow["CANNEL"].ToString()) && !"取消单".Equals(drRow["OD_STATUS"].ToString())) { sbMemo.Append(GetMenoHtml(0, drRow)); } else { sbMemo.Append(GetMenoHtml(1, drRow)); } } else { if (String.IsNullOrEmpty(drRow["CANNEL"].ToString())) { sbMemo.Append(GetMenoHtml(2, drRow)); } else { sbMemo.Append(GetMenoHtml(3, drRow)); } } } } return sbMemo.ToString(); }
public static LmSystemLogEntity UserDetailListSelectByNew(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "UserDetailListSelectByNew"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return LmSystemLogDA.UserDetailListSelectByNew(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "UserDetailListSelectByNew Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static LmSystemLogEntity SendMsgToLMSales(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SendMsgToLMSales"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return OrderInfoSA.SendMsgToLMSales(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SendMsgToLMSales Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
private DataSet GetOrderInfoData(string orderID) { LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); CommonEntity _commonEntity = new CommonEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.FogOrderID = orderID; return LmSystemLogBP.GetOrderInfoData(_lmSystemLogEntity).QueryResult; }
public static LmSystemLogEntity OrderSurveyDetail(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "OrderSurveyDetail"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return LmSystemLogDA.OrderSurveyDetail(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "OrderSurveyDetail Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static string SaveOrderListInterFace(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveOrderOperation"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { if (!LmSystemLogDA.ChkOrderOperationLock(lmSystemLogEntity)) { return "订单:" + lmSystemLogEntity.FogOrderID + " 被其他人锁定。请稍后重试!"; } DataSet dsOrderInfo = LmSystemLogDA.GetSaveOrderOpeRemarkList(lmSystemLogEntity.FogOrderID); if (LmSystemLogDA.SaveOrderOpeRemarkListConfirm(lmSystemLogEntity, dsOrderInfo) != 1) { return "订单:" + lmSystemLogEntity.FogOrderID + " 信息不存在。请确认!"; } //string strMsg = OrderInfoSA.SaveOrderOperationList(lmSystemLogEntity); string strMsg = OrderInfoSA.SynOrderOperationList(lmSystemLogEntity); if (!String.IsNullOrEmpty(strMsg)) { return strMsg;// "订单:" + lmSystemLogEntity.FogOrderID + " " + strMsg; } OrderInfoSA.SaveOrderConfirmPlanMail(lmSystemLogEntity, dsOrderInfo); return ""; } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveOrderOperation Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static int SaveHotelExRemark(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveHotelExRemark"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { if (!LmSystemLogDA.ChkHotelExRemark(lmSystemLogEntity)) { return 2; } return LmSystemLogDA.SaveHotelExRemark(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveHotelExRemark Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static LmSystemLogEntity SaveConfirmOrderList(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveConfirmOrderList"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { if (!LmSystemLogDA.ChkOrderOperationLock(lmSystemLogEntity)) { lmSystemLogEntity.Result = 2; lmSystemLogEntity.ErrorMSG = "保存失败。订单:" + lmSystemLogEntity.FogOrderID + "已被其他人锁定,请稍后再试!"; return lmSystemLogEntity; } string[] ODList = lmSystemLogEntity.OrderList.TrimEnd(',').Split(','); string[] ODDetail; string strOdStatus = string.Empty; LmSystemLogEntity lmEntity = new LmSystemLogEntity(); lmEntity.LogMessages = new LogMessage(); lmEntity.LogMessages = lmSystemLogEntity.LogMessages; string strResult = string.Empty; string allMSG = string.Empty; int iCount = ODList.Length; foreach (string tempOD in ODList) { strResult = ""; ODDetail = tempOD.Split('_'); lmEntity.FogOrderID = ODDetail[0].Trim(); if (!LmSystemLogDA.ChkOrderOperationLock(lmEntity)) { lmSystemLogEntity.ErrorMSG += lmEntity.FogOrderID + ","; iCount = iCount - 1; continue; } if (!"2".Equals(ODDetail[1].Trim())) { lmEntity.OrderBookStatus = ("1".Equals(ODDetail[1].Trim())) ? "6" : "7";//CC确认 CC取消 lmEntity.OrderBookStatusOther = ("1".Equals(ODDetail[1].Trim())) ? "4" : "9"; lmEntity.CanelReson = ("0".Equals(ODDetail[1].Trim())) ? ODDetail[2].Trim() : ""; lmEntity.BookRemark = ODDetail[3].Trim(); lmEntity.FollowUp = ("true".Equals(ODDetail[4].Trim())) ? "1" : "0"; lmEntity.ActionID = ("1".Equals(ODDetail[1].Trim())) ? ODDetail[2].Trim() : ""; strResult = LmSystemLogBP.SaveOrderListInterFace(lmEntity); allMSG += strResult; iCount = (String.IsNullOrEmpty(strResult)) ? iCount : iCount - 1; } if (String.IsNullOrEmpty(strResult.Trim())) { if ("1".Equals(ODDetail[1].Trim())) { strOdStatus = "可入住"; } else if ("0".Equals(ODDetail[1].Trim())) { strOdStatus = "CC取消"; } else if ("2".Equals(ODDetail[1].Trim())) { strOdStatus = "备注"; } OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _orderInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _orderInfoEntity.LogMessages = lmSystemLogEntity.LogMessages; _orderInfoEntity.OrderInfoDBEntity = new List<OrderInfoDBEntity>(); OrderInfoDBEntity orderinfoEntity = new OrderInfoDBEntity(); orderinfoEntity.EventType = "订单确认"; orderinfoEntity.ORDER_NUM = ODDetail[0].Trim(); orderinfoEntity.OdStatus = strOdStatus; orderinfoEntity.REMARK = (!"2".Equals(ODDetail[1].Trim())) ? ODDetail[3].Trim() : ODDetail[2].Trim(); orderinfoEntity.ActionID = ("1".Equals(ODDetail[1].Trim())) ? ODDetail[2].Trim() : ""; orderinfoEntity.CANNEL = ("0".Equals(ODDetail[1].Trim())) ? ODDetail[2].Trim() : ""; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); } } if (!String.IsNullOrEmpty(lmSystemLogEntity.ErrorMSG) || !String.IsNullOrEmpty(allMSG.Trim())) { lmSystemLogEntity.Result = 3; lmSystemLogEntity.ErrorMSG = ((iCount > 0) ? "其他订单保存成功。" : "保存失败。") + allMSG.Trim() + ((!String.IsNullOrEmpty(lmSystemLogEntity.ErrorMSG)) ? ("订单:" + lmSystemLogEntity.ErrorMSG.TrimEnd(',') + " 被其他人锁定,请稍后再试!") : ""); } else { lmSystemLogEntity.Result = 1; } return lmSystemLogEntity; } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveConfirmOrderList Error: " + ex.Message + lmSystemLogEntity.OrderList; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static LmSystemLogEntity SaveBindReciveFax(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveBindReciveFax"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { if ("0".Equals(lmSystemLogEntity.SendFaxType)) { DataSet dsBarCode = LmSystemLogDA.CheckBarCode(lmSystemLogEntity); if (dsBarCode.Tables.Count == 0 || dsBarCode.Tables[0].Rows.Count == 0) { lmSystemLogEntity.Result = 2; lmSystemLogEntity.ErrorMSG = "接收传真重新绑定保存失败 - 该二维码编号不存在,请修改!"; return lmSystemLogEntity; } } return OrderInfoSA.SaveBindReciveFax(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveBindReciveFax Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
//导出Excel文件 protected void btnExport_Click(object sender, EventArgs e) { LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); CommonEntity _commonEntity = new CommonEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.OutTest = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutTest"].ToString())) ? null : ViewState["OutTest"].ToString(); _lmSystemLogEntity.RestBookStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RestBookStatus"].ToString())) ? null : ViewState["RestBookStatus"].ToString(); _lmSystemLogEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString();//下单开始时间 _lmSystemLogEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString();//下单结束时间 _lmSystemLogEntity.GroupID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["GroupID"].ToString())) ? null : ViewState["GroupID"].ToString();//集团 _lmSystemLogEntity.InStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["InStart"].ToString())) ? null : ViewState["InStart"].ToString();//入住开始日期 _lmSystemLogEntity.InEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["InEnd"].ToString())) ? null : ViewState["InEnd"].ToString();//入住结束日期 _lmSystemLogEntity.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString(); //城市 _lmSystemLogEntity.TagInfo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Business"].ToString())) ? null : ViewState["Business"].ToString();//商圈 _lmSystemLogEntity.OutStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStart"].ToString())) ? null : ViewState["OutStart"].ToString();//离店开始时间 _lmSystemLogEntity.OutEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEnd"].ToString())) ? null : ViewState["OutEnd"].ToString();//离店结束时间 _lmSystemLogEntity.Sales = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Sales"].ToString())) ? null : ViewState["Sales"].ToString(); //销售 _lmSystemLogEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString();//酒店 _lmSystemLogEntity.Mobile = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Mobile"].ToString())) ? null : ViewState["Mobile"].ToString();//登录手机 _lmSystemLogEntity.FogOrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString();//订单ID _lmSystemLogEntity.GuestName = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["GuestName"].ToString())) ? null : ViewState["GuestName"].ToString();//入住人 _lmSystemLogEntity.CreateStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BookStatusOtherCreate"].ToString())) ? null : ViewState["BookStatusOtherCreate"].ToString();//创建状态 成功 失败 _lmSystemLogEntity.UserCancel = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["UserCancel"].ToString())) ? null : ViewState["UserCancel"].ToString();//用户取消 1 是 2 否 _lmSystemLogEntity.PriceCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PriceCode"].ToString())) ? null : ViewState["PriceCode"].ToString(); //价格代码 _lmSystemLogEntity.AffirmStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BookStatusOtherAffirm"].ToString())) ? null : ViewState["BookStatusOtherAffirm"].ToString();//确认状态 _lmSystemLogEntity.Timeout = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Timeout"].ToString())) ? null : ViewState["Timeout"].ToString();//确认超时 1是 2 否 _lmSystemLogEntity.Ticket = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Ticket"].ToString())) ? null : ViewState["Ticket"].ToString();//含返现券 1是 2 否 _lmSystemLogEntity.PlatForm = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PlatForm"].ToString())) ? null : ViewState["PlatForm"].ToString();//订单平台 _lmSystemLogEntity.OrderChannel = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderChannel"].ToString())) ? null : ViewState["OrderChannel"].ToString();//订单渠道 _lmSystemLogEntity.Aprove = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Aprove"].ToString())) ? null : ViewState["Aprove"].ToString();//审核状态 _lmSystemLogEntity.HotelComfirm = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelComfirm"].ToString())) ? null : ViewState["HotelComfirm"].ToString();//酒店是否已确认 _lmSystemLogEntity.BookStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BookStatus"].ToString())) ? null : ViewState["BookStatus"].ToString();//LMBAR状态 _lmSystemLogEntity.PayCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PayCode"].ToString())) ? null : ViewState["PayCode"].ToString();//支付方式 _lmSystemLogEntity.PayStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PayStatus"].ToString())) ? null : ViewState["PayStatus"].ToString();//支付状态 #region 优惠券信息 _lmSystemLogEntity.RestBookStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RestBookStatus"].ToString())) ? null : ViewState["RestBookStatus"].ToString(); _lmSystemLogEntity.RestPriceCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RestPriceCode"].ToString())) ? null : ViewState["RestPriceCode"].ToString(); _lmSystemLogEntity.TicketType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TicketType"].ToString())) ? null : ViewState["TicketType"].ToString(); _lmSystemLogEntity.TicketData = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TicketData"].ToString())) ? null : ViewState["TicketData"].ToString(); _lmSystemLogEntity.TicketPayCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TicketPcode"].ToString())) ? null : ViewState["TicketPcode"].ToString(); _lmSystemLogEntity.PackageName = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["packagename"].ToString())) ? null : ViewState["packagename"].ToString(); _lmSystemLogEntity.AmountFrom = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["amountfrom"].ToString())) ? null : ViewState["amountfrom"].ToString(); _lmSystemLogEntity.AmountTo = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["amountto"].ToString())) ? null : ViewState["amountto"].ToString(); _lmSystemLogEntity.PickfromDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["pickfromdate"].ToString())) ? null : ViewState["pickfromdate"].ToString(); _lmSystemLogEntity.PicktoDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["picktodate"].ToString())) ? null : ViewState["picktodate"].ToString(); _lmSystemLogEntity.TicketTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["tickettime"].ToString())) ? null : ViewState["tickettime"].ToString(); #endregion _lmSystemLogEntity.SortField = gridViewCSReviewLmSystemLogList.Attributes["SortExpression"].ToString(); _lmSystemLogEntity.SortType = gridViewCSReviewLmSystemLogList.Attributes["SortDirection"].ToString(); DataSet dsResult = new DataSet(); if (ViewState["orderXPaymentCode"].ToString() != "" && ViewState["orderXPaymentCode"].ToString() == "QuFen") { //dsResult = LmSystemLogBP.order_XPayment_ReviewLmOrderLogExport(_lmSystemLogEntity).QueryResult; } else if (ViewState["orderInTheNight"].ToString() != "" && ViewState["orderInTheNight"].ToString() == "CKIN") { //dsResult = LmSystemLogBP.order_InTheNight_ReviewLmOrderLogExport(_lmSystemLogEntity).QueryResult; } else if (ViewState["Rests"].ToString() != "" && ViewState["Rests"].ToString() == "Rests") { //dsResult = LmSystemLogBP.ExportLmOrderSelectByRests(_lmSystemLogEntity).QueryResult;//其他 排除已存在的渠道 } else { dsResult = OrderSearchBP.ExportOrderListSelect(_lmSystemLogEntity).QueryResult; } if (dsResult.Tables.Count == 0 && dsResult.Tables[0].Rows.Count == 0) { messageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString(); return; } if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { //for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++) for (int i = dsResult.Tables[0].Rows.Count - 1; i >= 0; i--) { if (dsResult.Tables[0].Rows[i]["LOGIN_MOBILE"].ToString() == "" && (dsResult.Tables[0].Rows[i]["ORDER_CHANNEL"].ToString() == "HOTELVP" || dsResult.Tables[0].Rows[i]["ORDER_CHANNEL"].ToString() == "HOTELVPPRO" || dsResult.Tables[0].Rows[i]["ORDER_CHANNEL"].ToString() == "GETAROOM")) { dsResult.Tables[0].Rows[i]["LOGIN_MOBILE"] = "游客"; } else if (dsResult.Tables[0].Rows[i]["LOGIN_MOBILE"].ToString() == "" && dsResult.Tables[0].Rows[i]["ORDER_CHANNEL"].ToString() == "QUNAR") { dsResult.Tables[0].Rows[i]["LOGIN_MOBILE"] = "QUNAR"; } if (!string.IsNullOrEmpty(ViewState["Timeout"].ToString())) { if (!string.IsNullOrEmpty(dsResult.Tables[0].Rows[i]["confirmTime"].ToString())) { if (ViewState["Timeout"].ToString() == "1")//只取超时订单 { if (int.Parse(dsResult.Tables[0].Rows[i]["confirmTime"].ToString()) <= 30) { dsResult.Tables[0].Rows.Remove(dsResult.Tables[0].Rows[i]); } } else//只取没有超时的订单 { if (int.Parse(dsResult.Tables[0].Rows[i]["confirmTime"].ToString()) > 30) { dsResult.Tables[0].Rows.Remove(dsResult.Tables[0].Rows[i]); } } } else { dsResult.Tables[0].Rows.Remove(dsResult.Tables[0].Rows[i]); } } } } CommonFunction.ExportExcelForLM(dsResult); }
//导出Excel文件 protected void btnExport_Click(object sender, EventArgs e) { if (gridViewCSReviewLmSystemLogList.Rows.Count == 0) { messageContent.InnerHtml = GetLocalResourceObject("RowsEmptyMessage").ToString(); return; } LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); CommonEntity _commonEntity = new CommonEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; chartData = "["; chartName = "["; DateTime dateTemp; for (int i = 0; i < gridViewCSReviewLmSystemLogList.Rows.Count; i++) { _lmSystemLogEntity.FogOrderID = gridViewCSReviewLmSystemLogList.Rows[i].Cells[2].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.Mobile = gridViewCSReviewLmSystemLogList.Rows[i].Cells[3].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.CityID = gridViewCSReviewLmSystemLogList.Rows[i].Cells[4].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.HotelID = gridViewCSReviewLmSystemLogList.Rows[i].Cells[5].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.StartDTime = gridViewCSReviewLmSystemLogList.Rows[i].Cells[6].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.EndDTime = gridViewCSReviewLmSystemLogList.Rows[i].Cells[7].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.InStart = gridViewCSReviewLmSystemLogList.Rows[i].Cells[8].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.InEnd = gridViewCSReviewLmSystemLogList.Rows[i].Cells[9].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.PayCode = gridViewCSReviewLmSystemLogList.Rows[i].Cells[10].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.BookStatus = gridViewCSReviewLmSystemLogList.Rows[i].Cells[11].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.HotelComfirm = gridViewCSReviewLmSystemLogList.Rows[i].Cells[12].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.PayStatus = gridViewCSReviewLmSystemLogList.Rows[i].Cells[13].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.Aprove = gridViewCSReviewLmSystemLogList.Rows[i].Cells[14].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.Ticket = gridViewCSReviewLmSystemLogList.Rows[i].Cells[15].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.PlatForm = gridViewCSReviewLmSystemLogList.Rows[i].Cells[16].Text.ToString().Trim().Replace("amp;", "").Replace(" ", ""); _lmSystemLogEntity.ShowType = ddpTimeSpace.SelectedValue.Trim(); chartName = chartName + "'" + gridViewCSReviewLmSystemLogList.Rows[i].Cells[1].Text.ToString().Trim().Replace("amp;", "").Replace(" ", "") + "',"; StringBuilder sb = new StringBuilder(); string temp = string.Empty; DataSet dsResult = LmSystemLogBP.ChartExportLmOrderSelect(_lmSystemLogEntity).QueryResult; if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { dateTemp = DateTime.Parse(_lmSystemLogEntity.StartDTime); if (double.Parse(_lmSystemLogEntity.ShowType) > 1) { chartData = chartData + "[['" + dateTemp.ToShortDateString() + "', 0]],"; } else { chartData = chartData + "[['" + dateTemp.ToString() + "', 0]],"; } continue; } foreach (DataRow drRow in dsResult.Tables[0].Rows) { temp = "['" + drRow["Date"].ToString() + "'," + drRow["Volume"].ToString() + "]"; sb.Append(temp); sb.Append(','); } chartData = chartData + "["+ sb.ToString().Trim(',') + "],"; } chartData = chartData.Trim(',') + "]"; chartName = chartName.Trim(',') + "]"; if (double.Parse(_lmSystemLogEntity.ShowType) > 1) { hidFormatString.Value = "%#m/%#d/%y"; } else { hidFormatString.Value = "%Y/%#m/%#d %H:%M:%S"; } //dvBtnUpdate.Style.Add("display", "none"); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DrawingLines();", true); }
public static LmSystemLogEntity GetOrderInfoData(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "GetOrderInfoData"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return LmSystemLogDA.GetOrderInfoData(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "GetOrderInfoData Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static LmSystemLogEntity HotelFaxHis(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "HotelFaxHis"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return LmSystemLogDA.HotelFaxHis(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "HotelFaxHis Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static int SaveOrderOperation(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveOrderOperation"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { if (!LmSystemLogDA.ChkOrderOperationLock(lmSystemLogEntity)) { return 2; } DataSet dsOrderInfo = LmSystemLogDA.GetSaveOrderOpeRemarkList(lmSystemLogEntity.FogOrderID); //if (LmSystemLogDA.SaveOrderOpeRemarkList(lmSystemLogEntity) != 1) //{ // return 0; //} if (LmSystemLogDA.SaveOrderOpeRemarkListConfirm(lmSystemLogEntity, dsOrderInfo) != 1) { return 0; } if (OrderInfoSA.SaveOrderOperation(lmSystemLogEntity) != 1) { return 0; } OrderInfoSA.SaveOrderConfirmPlanMail(lmSystemLogEntity, dsOrderInfo); return 1; } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveOrderOperation Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static LmSystemLogEntity order_XPayment_ReviewLmOrderLogExport(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "order_XPayment_ReviewLmOrderLogSelect"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return LmSystemLogDA.order_XPayment_ReviewLmOrderLogExport(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "order_XPayment_ReviewLmOrderLogSelect Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static int SaveOrderOpeRemark(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveOrderOperation"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { if (LmSystemLogDA.SaveOrderOpeRemark(lmSystemLogEntity) != 1) { return 0; } if (!String.IsNullOrEmpty(lmSystemLogEntity.OrderBookStatus)) { if (OrderInfoSA.SaveOrderOperation(lmSystemLogEntity) != 1) { return 0; } } return 1; } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveOrderOperation Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static LmSystemLogEntity ReviewLmOrderLogSelectCountByRests(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "ReviewLmOrderLogSelectCountByRests"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return LmSystemLogDA.ReviewLmOrderLogSelectCountByRests(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "ReviewLmOrderLogSelectCountByRests Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
protected void btnSendFax_Click(object sender, EventArgs e) { string HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); if (String.IsNullOrEmpty(HotelID)) { messageContent.InnerHtml = "发送传真失败,请选择酒店列表内酒店信息!"; ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "keyalert", "grLayout();", true); return; } if (gridViewCSList.Rows.Count == 0) { messageContent.InnerHtml = "发送传真失败,选择酒店无审核订单信息,请修改!"; ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "keyalert", "grLayout();", true); return; } ArrayList alList = new ArrayList(); for (int i = 0; i < this.gridViewCSList.Rows.Count; i++) { System.Web.UI.HtmlControls.HtmlInputCheckBox ck = (System.Web.UI.HtmlControls.HtmlInputCheckBox)gridViewCSList.Rows[i].FindControl("chkItems"); if (ck.Checked == true) { alList.Add(gridViewCSList.DataKeys[i].Value.ToString()); } } if (alList.Count == 0) { messageContent.InnerHtml = "发送传真失败,请选择订单列表需要发送传真的订单!"; ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "keyalert", "grLayout();", true); return; } //StringBuilder sbOrderList = new StringBuilder(); //for (int i = 0; i < gridViewCSList.Rows.Count; i++) //{ // sbOrderList.Append("\""); // sbOrderList.Append(gridViewCSList.DataKeys[i].Values[0].ToString()); // sbOrderList.Append("\","); //} StringBuilder sbOrderList = new StringBuilder(); foreach (string strSN in alList) { sbOrderList.Append("\""); sbOrderList.Append(strSN); sbOrderList.Append("\","); } LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.HotelID = HotelID; _lmSystemLogEntity.FogOrderID = sbOrderList.ToString().TrimEnd(','); _lmSystemLogEntity.SendFaxType = "4"; _lmSystemLogEntity.BookRemark = ""; _lmSystemLogEntity.ObjectID = HotelID; int iResult = LmSystemLogBP.SendFaxService(_lmSystemLogEntity).Result; _commonEntity.LogMessages = _lmSystemLogEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单审核-发送传真"; commonDBEntity.Event_ID = hidOrderID.Value; string conTent = GetLocalResourceObject("EventSendFaxMessage").ToString(); conTent = string.Format(conTent, _lmSystemLogEntity.FogOrderID, sbOrderList.ToString().TrimEnd(',')); commonDBEntity.Event_Content = conTent; if (iResult == 1) { commonDBEntity.Event_Result = GetLocalResourceObject("SendFaxSuccess").ToString(); messageContent.InnerHtml = GetLocalResourceObject("SendFaxSuccess").ToString(); } else { commonDBEntity.Event_Result = GetLocalResourceObject("SendFaxError").ToString(); messageContent.InnerHtml = GetLocalResourceObject("SendFaxError").ToString(); } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "keyalert", "BtnCompleteStyle();", true); }
public static LmSystemLogEntity SaveOrderOpeRemarkList(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveOrderOpeRemarkList"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { if (LmSystemLogDA.SaveOrderOpeRemarkList(lmSystemLogEntity) != 1) { lmSystemLogEntity.Result = 0; return lmSystemLogEntity; } if ("1".Equals(lmSystemLogEntity.IsDbApprove)) { lmSystemLogEntity.ErrorMSG = OrderInfoSA.SaveOrderOperationDoubleApprove(lmSystemLogEntity); lmSystemLogEntity.Result = (String.IsNullOrEmpty(lmSystemLogEntity.ErrorMSG)) ? 1 : 2; return lmSystemLogEntity; } else { if (!String.IsNullOrEmpty(lmSystemLogEntity.OrderBookStatus)) { string strMsg = OrderInfoSA.SaveOrderOperationList(lmSystemLogEntity); if (!String.IsNullOrEmpty(strMsg)) { lmSystemLogEntity.Result = 2; lmSystemLogEntity.ErrorMSG = strMsg; return lmSystemLogEntity; } } } lmSystemLogEntity.Result = 1; return lmSystemLogEntity; } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveOrderOpeRemarkList Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
public static string UnlockOrder(string OrderID) { LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.FogOrderID = OrderID; DataSet dsMainResult = LmSystemLogBP.ChkOrderOperationSelect(_lmSystemLogEntity).QueryResult; if (dsMainResult.Tables.Count == 0 || dsMainResult.Tables[0].Rows.Count == 0) { //imgAlert.Src = "../../Styles/images/err.png"; //dvImg.Style.Add("margin-left", "100px"); //dvErrorInfo.InnerHtml = GetLocalResourceObject("WarningMessage").ToString(); //ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "setScript", "invokeOpenList()", true); return "../../Styles/images/err.png" + "|" + "120px" + "|" + "该订单信息不存在,请确认!" + "|"; } string strMsg = LmSystemLogBP.UnlockOrderConfirmControl(_lmSystemLogEntity).ErrorMSG; if (!String.IsNullOrEmpty(strMsg)) { //dvErrorInfo.InnerHtml = strMsg; //imgAlert.Src = "../../Styles/images/err.png"; //dvImg.Style.Add("margin-left", "100px"); return "../../Styles/images/err.png" + "|" + "120px" + "|" + strMsg + "|"; } else { CommonEntity _commonEntity = new CommonEntity(); _commonEntity.LogMessages = _lmSystemLogEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单确认-强制锁定"; commonDBEntity.Event_ID = _lmSystemLogEntity.FogOrderID; string conTent = "订单确认强制锁定 - 订单ID:{0} 操作人:{1}";// GetLocalResourceObject("EventUnLockMessage").ToString(); conTent = string.Format(conTent, _lmSystemLogEntity.FogOrderID, _lmSystemLogEntity.LogMessages.Username); commonDBEntity.Event_Content = conTent; commonDBEntity.Event_Result = " 订单确认锁定成功! ";// GetLocalResourceObject("UpdateUnLockSuccess").ToString(); //dvErrorInfo.InnerHtml = GetLocalResourceObject("UpdateUnLockSuccess").ToString(); //imgAlert.Src = "../../Styles/images/suc.png"; //dvImg.Style.Add("margin-left", "100px"); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); return "../../Styles/images/suc.png" + "|" + "120px" + "|" + "订单确认锁定成功!" + "|" + UserSession.Current.UserAccount; //lbActionUser.Text = UserSession.Current.UserAccount; } //return json; }
protected void btnAddRemark_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtBOOK_REMARK.Text.Trim()) && (StringUtility.Text_Length(txtBOOK_REMARK.Text.ToString().Trim()) > 250)) { detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorRemark").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } if ("8".Equals(hidActionType.Value) && String.IsNullOrEmpty(txtInRoomID.Text.Trim())) { detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorAction").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } if (String.IsNullOrEmpty(hidActionType.Value)) { if (String.IsNullOrEmpty(txtBOOK_REMARK.Text.Trim())) { detailMessageContent.InnerHtml = GetLocalResourceObject("EmpryRemark").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _orderInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _orderInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _orderInfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _orderInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _orderInfoEntity.OrderInfoDBEntity = new List<OrderInfoDBEntity>(); OrderInfoDBEntity orderinfoEntity = new OrderInfoDBEntity(); orderinfoEntity.EventType = "订单审核"; orderinfoEntity.ORDER_NUM = hidOrderID.Value; orderinfoEntity.OdStatus = SetActionTypeVal(hidActionType.Value); orderinfoEntity.REMARK = txtBOOK_REMARK.Text.Trim(); orderinfoEntity.CANNEL = ""; orderinfoEntity.ApproveId = ""; orderinfoEntity.InRoomID = ""; orderinfoEntity.IsDbApprove = "1"; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); messageContent.InnerHtml = GetLocalResourceObject("RemarkSuccess").ToString(); } else { LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.FogOrderID = hidOrderID.Value; _lmSystemLogEntity.OrderBookStatus = hidActionType.Value; _lmSystemLogEntity.CanelReson = ddpNoShow.SelectedValue; _lmSystemLogEntity.BookRemark = txtBOOK_REMARK.Text.Trim(); _lmSystemLogEntity.ApproveId = txtActionID.Text.Trim(); _lmSystemLogEntity.InRoomID = txtInRoomID.Text.Trim(); _lmSystemLogEntity.IsDbApprove = "1";// (chkDbApprove.Checked) ? "1" : "0"; _lmSystemLogEntity = LmSystemLogBP.SaveOrderOpeRemarkList(_lmSystemLogEntity); int iResult = _lmSystemLogEntity.Result; _commonEntity.LogMessages = _lmSystemLogEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单审核-保存"; commonDBEntity.Event_ID = hidOrderID.Value; string conTent = GetLocalResourceObject("EventSaveMessage").ToString(); conTent = string.Format(conTent, _lmSystemLogEntity.FogOrderID, _lmSystemLogEntity.OrderBookStatus, _lmSystemLogEntity.BookRemark, _lmSystemLogEntity.InRoomID, _lmSystemLogEntity.ApproveId, _lmSystemLogEntity.CanelReson); commonDBEntity.Event_Content = conTent; if (iResult == 1) { OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _orderInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _orderInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _orderInfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _orderInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _orderInfoEntity.OrderInfoDBEntity = new List<OrderInfoDBEntity>(); OrderInfoDBEntity orderinfoEntity = new OrderInfoDBEntity(); orderinfoEntity.EventType = "订单审核"; orderinfoEntity.ORDER_NUM = hidOrderID.Value; orderinfoEntity.OdStatus = SetActionTypeVal(hidActionType.Value); orderinfoEntity.REMARK = txtBOOK_REMARK.Text.Trim(); orderinfoEntity.CANNEL = ("8".Equals(hidActionType.Value)) ? "" : ddpNoShow.SelectedValue; orderinfoEntity.ApproveId = ("5".Equals(hidActionType.Value)) ? "" : txtActionID.Text.Trim(); orderinfoEntity.InRoomID = ("5".Equals(hidActionType.Value)) ? "" : txtInRoomID.Text.Trim(); orderinfoEntity.IsDbApprove = "1";//(chkDbApprove.Checked) ? "1" : "0"; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); string strMsg = ""; if ("5".Equals(hidActionType.Value)) { strMsg = GetLocalResourceObject("UpdateSuccess12").ToString(); } else if ("8".Equals(hidActionType.Value)) { strMsg = GetLocalResourceObject("UpdateSuccess11").ToString(); } commonDBEntity.Event_Result = strMsg; messageContent.InnerHtml = strMsg; ResetOrderConfirmListGrid(); } else if (iResult == 0) { commonDBEntity.Event_Result = GetLocalResourceObject("WarningMessage").ToString(); detailMessageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString(); } else if (iResult == 2) { commonDBEntity.Event_Result = _lmSystemLogEntity.ErrorMSG; detailMessageContent.InnerHtml = _lmSystemLogEntity.ErrorMSG; ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } else { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError").ToString(); messageContent.InnerHtml = GetLocalResourceObject("UpdateError").ToString(); } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); } gridHotelList.SelectedIndex = int.Parse(this.HidSelIndex.Value); string PROP = gridHotelList.DataKeys[int.Parse(this.HidSelIndex.Value)].Values[0].ToString(); int UADCUN = 0; int ADCUN = 0; int BCUN = 0; for (int i = 0; i < gridHotelList.Rows.Count; i++) { //首先判断是否是数据行 if (gridHotelList.Rows[i].RowType == DataControlRowType.DataRow) { UADCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[4].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[4].ToString()); ADCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[5].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[5].ToString()); BCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[6].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[6].ToString()); if (UADCUN == ADCUN) { gridHotelList.Rows[i].BackColor = System.Drawing.ColorTranslator.FromHtml("#70A88C"); } else if (BCUN > 0) { gridHotelList.Rows[i].BackColor = System.Drawing.ColorTranslator.FromHtml("#94FB92"); } gridHotelList.Rows[i].Attributes.Add("onMouseOver", "t=this.style.backgroundColor;this.style.backgroundColor='#ebebce';"); gridHotelList.Rows[i].Attributes.Add("onMouseOut", "this.style.backgroundColor=t;"); } } gridHotelList.Rows[gridHotelList.SelectedIndex].BackColor = System.Drawing.ColorTranslator.FromHtml("#FFCC66"); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeCloseList()", true); }
public static int SaveReciveFax(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveReciveFax"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { return LmSystemLogDA.SaveReciveFax(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveReciveFax Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
//private int CountLmSystemLog() //{ // _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); // _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; // _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; // _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; // _lmSystemLogEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); // _lmSystemLogEntity.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString(); // _lmSystemLogEntity.Sales = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SaleID"].ToString())) ? null : ViewState["SaleID"].ToString(); // _lmSystemLogEntity.IsReserve = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DSourceType"].ToString())) ? null : ViewState["DSourceType"].ToString(); // _lmSystemLogEntity.GuestName = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DSourceData"].ToString())) ? null : ViewState["DSourceData"].ToString(); // DataSet dsResult = LmSystemLogBP.HotelComparisonSelectCount(_lmSystemLogEntity).QueryResult; // if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0][0].ToString())) // { // return int.Parse(dsResult.Tables[0].Rows[0][0].ToString()); // } // return 0; //} private void BindReviewLmSystemLogListGrid() { //messageContent.InnerHtml = ""; _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); _lmSystemLogEntity.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString(); _lmSystemLogEntity.Sales = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SaleID"].ToString())) ? null : ViewState["SaleID"].ToString(); _lmSystemLogEntity.DSourceType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DSourceType"].ToString())) ? null : ViewState["DSourceType"].ToString(); _lmSystemLogEntity.DSourceData = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DSourceData"].ToString())) ? null : ViewState["DSourceData"].ToString(); _lmSystemLogEntity.Discount = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Discount"].ToString())) ? null : ViewState["Discount"].ToString(); _lmSystemLogEntity.PageCurrent = AspNetPager1.CurrentPageIndex; _lmSystemLogEntity.PageSize = gridViewCSReviewLmSystemLogList.PageSize; _lmSystemLogEntity = LmSystemLogBP.HotelComparisonSelect(_lmSystemLogEntity); DataSet dsResult = _lmSystemLogEntity.QueryResult; gridViewCSReviewLmSystemLogList.DataSource = dsResult.Tables["Detail"].DefaultView; gridViewCSReviewLmSystemLogList.DataKeyNames = new string[] { "Hotel_ID" };//主键 gridViewCSReviewLmSystemLogList.DataBind(); if (dsResult.Tables.Count > 0 && dsResult.Tables["Detail"].Rows.Count > 0) { lbUpdatTime.Text = dsResult.Tables["Detail"].Rows[dsResult.Tables["Detail"].Rows.Count - 1]["Update_time"].ToString(); } AspNetPager1.PageSize = gridViewCSReviewLmSystemLogList.PageSize; AspNetPager1.RecordCount = _lmSystemLogEntity.TotalCount;//CountLmSystemLog(); if (dsResult.Tables.Count > 0 && dsResult.Tables["Master"].Rows.Count > 0) { lbBHLID.Text = dsResult.Tables["Master"].Rows[0]["BHLID"].ToString(); lbLHLID.Text = dsResult.Tables["Master"].Rows[0]["LHLID"].ToString(); lbDHLID.Text = dsResult.Tables["Master"].Rows[0]["DHLID"].ToString(); lbBRMCD.Text = dsResult.Tables["Master"].Rows[0]["BRMCD"].ToString(); lbLRMCD.Text = dsResult.Tables["Master"].Rows[0]["LRMCD"].ToString(); lbDRMCD.Text = dsResult.Tables["Master"].Rows[0]["DRMCD"].ToString(); } else { lbBHLID.Text = "0"; lbLHLID.Text = "0"; lbDHLID.Text = "0"; lbBRMCD.Text = "0"; lbLRMCD.Text = "0"; lbDRMCD.Text = "0"; } this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); }
public static LmSystemLogEntity SendFaxService(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SendFaxService"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { DataSet dsResult = LmSystemLogDA.OrderOperationSelect(lmSystemLogEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { string book_status_other = dsResult.Tables[0].Rows[0]["book_status_other"].ToString(); if ("3".Equals(book_status_other) || "9".Equals(book_status_other)) { lmSystemLogEntity.SendFaxType = "2"; } } return OrderInfoSA.SendFaxService(lmSystemLogEntity); } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SendFaxService Error: " + ex.Message; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }