private void TestSetAdvertiseOrderInfoList() { //cPos.Service.cBillService bs = new cBillService(); //cPos.Model.LoggingSessionInfo loggingSessionInfo = new LoggingSessionInfo(); //loggingSessionInfo = new cPos.Service.CLoggingSessionService().GetLoggingSessionInfo("29E11BDC6DAC439896958CC6866FF64E", "e3b3c960a42f41b0bf8e6e2ae3a8ad43"); LoggingManager loggingManager = new cLoggingManager().GetLoggingManager("29E11BDC6DAC439896958CC6866FF64E"); AdvertiseOrderService advertiseOrderService = new AdvertiseOrderService(); IList <AdvertiseOrderInfo> advertiseOrderInfoList = new List <AdvertiseOrderInfo>(); AdvertiseOrderInfo adInfo1 = new AdvertiseOrderInfo(); adInfo1.order_id = "1"; adInfo1.order_code = "可口可乐"; adInfo1.order_date = "2012-11-19"; adInfo1.date_start = "2012-12-01"; adInfo1.date_end = "2012-12-31"; adInfo1.time_start = "00:00"; adInfo1.time_end = "24:00"; adInfo1.playbace_no = Convert.ToInt32("100"); adInfo1.customer_id = "29E11BDC6DAC439896958CC6866FF64E"; adInfo1.status = "10"; adInfo1.status_desc = "审批通过"; adInfo1.url_address = "http://192.168.0.55:8201/"; advertiseOrderInfoList.Add(adInfo1); this.lb1.Text = advertiseOrderService.SetAdvertiseOrderInfoList(loggingManager, advertiseOrderInfoList, true).ToString(); }
/// <summary> /// 设置打包批次号 /// </summary> /// <param name="loggingSessionInfo">登录model</param> /// <param name="bat_id">批次号</param> /// <param name="AdvertiseOrderUnitInfoList">广告订单与门店关系集合</param> /// <param name="strError">错误信息返回</param> /// <returns></returns> public bool SetAdvertiseOrderBatInfo(LoggingSessionInfo loggingSessionInfo, string bat_id, IList <AdvertiseOrderUnitInfo> AdvertiseOrderUnitInfoList, out string strError) { AdvertiseOrderInfo advertiseOrderInfo = new AdvertiseOrderInfo(); advertiseOrderInfo.bat_no = bat_id; advertiseOrderInfo.advertiseOrderUnitInfoList = AdvertiseOrderUnitInfoList; cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("AdvertiseOrder.UpdateUnDownloadBatId", advertiseOrderInfo); strError = "Success"; return(true); }
/// <summary> /// 更新Item表打包标识方法 /// </summary> /// <param name="loggingSessionInfo">登录model</param> /// <param name="bat_id">批次标识</param> /// <param name="strError">错误信息返回</param> /// <returns></returns> public bool SetAdvertiseOrderIfFlagInfo(LoggingSessionInfo loggingSessionInfo, string bat_id, out string strError) { AdvertiseOrderInfo advertiseOrderInfo = new AdvertiseOrderInfo(); advertiseOrderInfo.bat_no = bat_id; //advertiseOrderInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id; //advertiseOrderInfo.Modify_Time = GetCurrentDateTime(); cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("AdvertiseOrder.UpdateUnDownloadIfFlag", advertiseOrderInfo); strError = "Success"; return(true); }
/// <summary> /// 保存单个广告播放订单 /// </summary> /// <param name="loggingSessionInfo">登录model</param> /// <param name="advertiseOrderInfo">广告订单对象</param> /// <returns></returns> public bool SetAdvertiseOrderInfo(LoggingManager loggingManager, AdvertiseOrderInfo advertiseOrderInfo) { if (advertiseOrderInfo != null) { advertiseOrderInfo.customer_id = loggingManager.Customer_Id; if (advertiseOrderInfo.create_user_id == null || advertiseOrderInfo.create_user_id.Equals("")) { //advertiseOrderInfo.create_user_id = loggingSessionInfo.CurrentUser.User_Id; advertiseOrderInfo.create_time = GetCurrentDateTime(); } if (advertiseOrderInfo.modify_user_id == null || advertiseOrderInfo.modify_user_id.Equals("")) { //advertiseOrderInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id; advertiseOrderInfo.modify_time = GetCurrentDateTime(); } cSqlMapper.Instance(loggingManager).Update("AdvertiseOrder.InsertOrUpdate", advertiseOrderInfo); } return(true); }
private void TestSetAdvertiseOrderAdvertiseByOrder() { //cPos.Service.cBillService bs = new cBillService(); //cPos.Model.LoggingSessionInfo loggingSessionInfo = new LoggingSessionInfo(); //loggingSessionInfo = new cPos.Service.CLoggingSessionService().GetLoggingSessionInfo("29E11BDC6DAC439896958CC6866FF64E", "e3b3c960a42f41b0bf8e6e2ae3a8ad43"); LoggingManager loggingManager = new cLoggingManager().GetLoggingManager("29E11BDC6DAC439896958CC6866FF64E"); AdvertiseOrderInfo advertiseOrderInfo = new AdvertiseOrderInfo(); IList <AdvertiseOrderAdvertiseInfo> aoaList = new List <AdvertiseOrderAdvertiseInfo>(); AdvertiseOrderAdvertiseInfo aoaInfo1 = new AdvertiseOrderAdvertiseInfo(); aoaInfo1.id = "1"; aoaInfo1.customer_id = "29E11BDC6DAC439896958CC6866FF64E"; aoaInfo1.order_id = "1"; aoaInfo1.advertise_id = "1"; aoaList.Add(aoaInfo1); advertiseOrderInfo.advertiseOrderAdvertiseInfoList = aoaList; AdvertiseOrderAdvertiseService aoaService = new AdvertiseOrderAdvertiseService(); this.lb1.Text = aoaService.SetAdvertiseOrderAdvertiseByOrder(loggingManager, advertiseOrderInfo).ToString(); }
private void TestSetAdvertiseOrderAdvertiseInfoXML() { AdvertiseOrderInfo adInfo1 = new AdvertiseOrderInfo(); adInfo1.order_id = "2"; adInfo1.order_code = "可口可乐"; adInfo1.order_date = "2012-11-19"; adInfo1.date_start = "2012-12-01"; adInfo1.date_end = "2012-12-31"; adInfo1.time_start = "00:00"; adInfo1.time_end = "24:00"; adInfo1.playbace_no = Convert.ToInt32("100"); adInfo1.customer_id = "29E11BDC6DAC439896958CC6866FF64E"; adInfo1.status = "10"; adInfo1.status_desc = "审批通过"; adInfo1.url_address = "http://192.168.0.55:8201/"; IList <AdvertiseOrderInfo> advertiseOrderInfoList = new List <AdvertiseOrderInfo>(); advertiseOrderInfoList.Add(adInfo1); string str1 = cXMLService.Serialiaze(advertiseOrderInfoList); string customer_id = "29E11BDC6DAC439896958CC6866FF64E"; string str = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<ArrayOfAdvertiseOrderInfo xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><AdvertiseOrderInfo> <order_id>100</order_id><order_code>001</order_code> <order_date>2012-01-01</order_date><playbace_no>0</playbace_no> <status>0</status> <icount>0</icount><row_no>0</row_no></AdvertiseOrderInfo></ArrayOfAdvertiseOrderInfo>"; //反序列化 //IList<AdvertiseOrderAdvertiseInfo> advertiseOrderAdvertiseInfoList = (IList<AdvertiseOrderAdvertiseInfo>)cXMLService.Deserialize(str, typeof(List<cPos.Model.Advertise.AdvertiseOrderAdvertiseInfo>)); AdvertiseOrderService advertiseOrderService = new AdvertiseOrderService(); //bool bReturn = advertiseOrderService.SetAdvertiseOrderXML(str, customer_id); string strAdvertise = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<ArrayOfAdvertiseInfo xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">\r\n <AdvertiseInfo>\r\n <advertise_id>EA7E0557235B4295BAC72CCF470154A0</advertise_id>\r\n <advertise_name>ad01</advertise_name>\r\n <advertise_code>ad01</advertise_code>\r\n <file_size>10000</file_size>\r\n <file_format>.flv</file_format>\r\n <url_address>ad01.flv</url_address>\r\n <status>1</status>\r\n <icount>0</icount>\r\n <row_no>0</row_no>\r\n </AdvertiseInfo>\r\n</ArrayOfAdvertiseInfo>"; cPos.Service.AdvertiseService advertiseService = new AdvertiseService(); bool b = advertiseService.SetAdvertiseOrderXML(strAdvertise, "FEA59DDDBB034817AD71DA12262ED0D8"); this.lb1.Text = b.ToString(); }
/// <summary> /// 批量处理广告订单与门店关系 /// </summary> /// <param name="loggingSessionInfo">登录model</param> /// <param name="advertiseOrderAdvertiseInfoList">关系集合</param> /// <param name="IsTrans">是否批处理</param> /// <returns></returns> public bool SetAdvertiseOrderUnitInfoList(LoggingManager loggingManager , IList <AdvertiseOrderUnitInfo> advertiseOrderUnitInfoList, bool IsTrans) { if (IsTrans) { cSqlMapper.Instance(loggingManager).BeginTransaction(); } try { IList <AdvertiseOrderInfo> advertiseOrderInfolist = new List <AdvertiseOrderInfo>(); if (advertiseOrderUnitInfoList != null) { #region 获取广告播放订单主信息集合 foreach (AdvertiseOrderUnitInfo aoa in advertiseOrderUnitInfoList) { AdvertiseOrderInfo advertiseOrderInfo = new AdvertiseOrderInfo(); if (advertiseOrderInfolist == null || advertiseOrderInfolist.Count == 0) { advertiseOrderInfo.order_id = aoa.order_id; advertiseOrderInfo.customer_id = aoa.customer_id; advertiseOrderInfolist.Add(advertiseOrderInfo); } else { bool bSelect = true; foreach (AdvertiseOrderInfo aoi in advertiseOrderInfolist) { if (aoi.customer_id.Equals(aoa.customer_id) && aoi.order_id.Equals(aoa.order_id)) { bSelect = false; break; } } if (bSelect) { advertiseOrderInfo.order_id = aoa.order_id; advertiseOrderInfo.customer_id = aoa.customer_id; advertiseOrderInfolist.Add(advertiseOrderInfo); } } } #endregion #region 分别处理订单信息 if (advertiseOrderInfolist != null) { foreach (AdvertiseOrderInfo aoi in advertiseOrderInfolist) { IList <AdvertiseOrderUnitInfo> aoaList1 = new List <AdvertiseOrderUnitInfo>(); foreach (AdvertiseOrderUnitInfo aoa in advertiseOrderUnitInfoList) { if (aoi.customer_id.Equals(aoa.customer_id) && aoi.order_id.Equals(aoa.order_id)) { aoaList1.Add(aoa); } } aoi.advertiseOrderUnitInfoList = aoaList1; bool b = SetAdvertiseOrderUnitByOrder(loggingManager, aoi); } } #endregion } if (IsTrans) { cSqlMapper.Instance(loggingManager).CommitTransaction(); } return(true); } catch (Exception ex) { if (IsTrans) { cSqlMapper.Instance(loggingManager).RollBackTransaction(); } throw (ex); } }
/// <summary> /// 设置广告订单与门店关系信息 /// </summary> /// <param name="loggingSessionInfo">登录model</param> /// <param name="advertiseOrderInfo">广告订单主信息</param> /// <returns></returns> public bool SetAdvertiseOrderUnitByOrder(LoggingManager loggingManager, AdvertiseOrderInfo advertiseOrderInfo) { //处理广告订单与广告关系 cSqlMapper.Instance(loggingManager).Update("AdvertiseOrder.HandleUnit", advertiseOrderInfo); return(true); }
/// <summary> /// 检查AdOrder是否已存在 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CheckExistAdOrder(AdvertiseOrderInfo model) { int count = MSSqlMapper.Instance().QueryForObject <int>("AdOrder.CheckExistAdOrder", model); return(count > 0 ? true : false); }