/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static SeatManage.EnumType.HandleResult UpdateRollTitles(SeatManage.ClassModel.RollTitlesInfo model)
{
IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService();
bool error = false;
try
{
return(seatService.UpdateRollTitles(model));
}
catch (Exception ex)
{
error = true;
SeatManageComm.WriteLog.Write("修改滚动广告失败：" + ex.Message);
throw ex;
}
finally
{
ICommunicationObject ICommObjectService = seatService as ICommunicationObject;
try
{
if (ICommObjectService.State == CommunicationState.Faulted)
{
ICommObjectService.Abort();
}
else
{
ICommObjectService.Close();
}
}
catch
{
ICommObjectService.Abort();
}
}
}
public bool AddRollTitles(SeatManage.ClassModel.RollTitlesInfo model)
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO AMS_RollTitles");
sql.Append(" (EffectDate,EndDate,Type,Num)");
sql.Append(" VALUES");
sql.Append(" (@EffectDate,@EndDate,@Type,@Num)");
SqlParameter[] sqlpar =
{
new SqlParameter("@EffectDate", model.EffectDate),
new SqlParameter("@EndDate", model.EndDate),
new SqlParameter("@Type", model.Type),
new SqlParameter("@Num", model.Num)
};
int rows = DbHelperSQL.ExecuteSql(sql.ToString(), sqlpar);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private SeatManage.ClassModel.RollTitlesInfo DataRowToAMS_RollTitles(DataRow dr)
{
SeatManage.ClassModel.RollTitlesInfo model = new SeatManage.ClassModel.RollTitlesInfo
{
EffectDate = Convert.ToDateTime(dr["EffectDate"].ToString()),
EndDate = Convert.ToDateTime(dr["EndDate"].ToString()),
Type = dr["Type"].ToString(),
Num = dr["Num"].ToString()
};
return model;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static SeatManage.EnumType.HandleResult AddRollTitles(SeatManage.ClassModel.RollTitlesInfo model)
{
IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService();
bool error = false;
try
{
return(seatService.AddRollTitles(model));
}
catch (Exception ex)
{
error = true;
SeatManageComm.WriteLog.Write("获取滚动广告失败：" + ex.Message);
throw ex;
}
}
public SeatManage.EnumType.HandleResult UpdateRollTitles(SeatManage.ClassModel.RollTitlesInfo model)
{
try
{
if (ams_RollTitles.UpdateRollTitles(model))
{
return SeatManage.EnumType.HandleResult.Successed;
}
else
{
return SeatManage.EnumType.HandleResult.Failed;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新滚动广告
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool GetTitleAd(int Num)
{
try
{
Model.AMS_RollTitles advertTitle = AMS.ServiceProxy.IRollTitlesService.GetModelNum(Num);
if (advertTitle != null)
{
SeatManage.ClassModel.RollTitlesInfo models = SeatManage.Bll.AMS_RollTitles.GetModelByNum(advertTitle.Num);
SeatManage.ClassModel.RollTitlesInfo seatTitle = new SeatManage.ClassModel.RollTitlesInfo();
seatTitle.EffectDate = Convert.ToDateTime(advertTitle.EffectDate);
seatTitle.EndDate = Convert.ToDateTime(advertTitle.EndDate);
seatTitle.Type = advertTitle.Type;
seatTitle.Num = advertTitle.Num;
if (models == null)
{
if (SeatManage.Bll.AMS_RollTitles.AddRollTitles(seatTitle) == SeatManage.EnumType.HandleResult.Successed)
{
return(true);
}
return(false);
}
else
{
if (SeatManage.Bll.AMS_RollTitles.UpdateRollTitles(seatTitle) == SeatManage.EnumType.HandleResult.Successed)
{
return(true);
}
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
