/// <summary>
/// 获取单个记录
/// </summary>
/// <param name="AdNum"></param>
/// <param name="adType"></param>
/// <returns></returns>
public SeatManage.ClassModel.AMS_AdvertUsage GetAdvertUsage(string AdNum, SeatManage.EnumType.AdType adType)
{
try
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" AdvertNum='" + AdNum + "' and AdvertType='" + (int)adType + "'");
DataSet ds = viewadvertusage_dal.GetList(strWhere.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToAMS_AdvertUsage(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
catch
{
throw;
}
}
/// <summary>
/// 获取单个广告
/// </summary>
/// <param name="adNum"></param>
/// <param name="adType"></param>
/// <returns></returns>
public SeatManage.ClassModel.AMS_Advertisement GetAdModel(string adNum, SeatManage.EnumType.AdType adType)
{
try
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" Num='" + adNum + "' and [Type]='" + (int)adType + "'");
DataSet ds = advertisement_dal.GetList(strWhere.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToAMS_Advertisement(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
catch
{
throw;
}
}
/// <summary>
/// 获取有效的广告列表
/// </summary>
/// <param name="isOverTime"></param>
/// <param name="adType"></param>
/// <returns></returns>
public static List <SeatManage.ClassModel.AMS_Advertisement> GetAdList(bool?isOverTime, SeatManage.EnumType.AdType adType)
{
IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService();
try
{
return(seatService.GetAdList(isOverTime, adType));
}
catch (FaultException ex)
{
SeatManageComm.WriteLog.Write("获取广告列表失败：" + ex.Message);
return(new List <AMS_Advertisement>());
}
}
/// <summary>
/// 获取单个广告
/// </summary>
/// <param name="adNum"></param>
/// <param name="adType"></param>
/// <returns></returns>
public static SeatManage.ClassModel.AMS_Advertisement GetAdModel(string adNum, SeatManage.EnumType.AdType adType)
{
IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService();
try
{
return(seatService.GetAdModel(adNum, adType));
}
catch (FaultException ex)
{
SeatManageComm.WriteLog.Write("获取广告失败：" + ex.Message);
return(null);
}
}
/// <summary>
/// 获取有效或无效的广告
/// </summary>
/// <param name="isOverTime">是否超时，null为</param>
/// <param name="adType"></param>
/// <returns></returns>
public List <SeatManage.ClassModel.AMS_Advertisement> GetAdList(bool?isOverTime, SeatManage.EnumType.AdType adType)
{
try
{
List <SeatManage.ClassModel.AMS_Advertisement> modelList = new List <SeatManage.ClassModel.AMS_Advertisement>();
StringBuilder strWhere = new StringBuilder();
if (adType != SeatManage.EnumType.AdType.None)
{
strWhere.Append(" [Type]='" + (int)adType + "'");
}
if (isOverTime != null)
{
if (strWhere.ToString() != "")
{
strWhere.Append(" and ");
}
if (isOverTime.Value)
{
strWhere.Append(" EndDate<'" + DateTime.Now.ToShortDateString() + "'");
}
else
{
strWhere.Append(" EndDate>='" + DateTime.Now.ToShortDateString() + "' and EffectDate <='" + DateTime.Now.ToShortDateString() + "' Order by EndDate desc");
}
}
DataSet ds = advertisement_dal.GetList(strWhere.ToString(), null);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
modelList.Add(DataRowToAMS_Advertisement(ds.Tables[0].Rows[i]));
}
return(modelList);
}
catch
{
throw;
}
}
/// <summary>
/// 获取有效的广告列表
/// </summary>
/// <param name="isOverTime"></param>
/// <param name="adType"></param>
/// <returns></returns>
public static List <SeatManage.ClassModel.AMS_Advertisement> GetAdList(bool?isOverTime, SeatManage.EnumType.AdType adType)
{
IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService();
try
{
return(seatService.GetAdList(isOverTime, adType));
}
catch (FaultException ex)
{
SeatManageComm.WriteLog.Write("获取广告列表失败：" + ex.Message);
return(new List <AMS_Advertisement>());
}
finally
{
ICommunicationObject ICommObjectService = seatService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
/// <summary>
/// 获取单个记录
/// </summary>
/// <param name="AdNum"></param>
/// <param name="adType"></param>
/// <returns></returns>
public static SeatManage.ClassModel.AMS_AdvertUsage GetAdvertUsage(string AdNum, SeatManage.EnumType.AdType adType)
{
IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService();
try
{
return(seatService.GetAdvertUsage(AdNum, adType));
}
catch (FaultException ex)
{
SeatManageComm.WriteLog.Write("获取广告状态失败：" + ex.Message);
return(null);
}
finally
{
ICommunicationObject ICommObjectService = seatService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
