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