/// <summary>
/// 添加滚动文字
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddRollTitles(AMS.Model.AMS_RollTitles model)
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO AMS_RollTitles");
sql.Append(" (Name,EffectDate,EndDate,CustomerId,Type,Operator,Num)");
sql.Append(" VALUES");
sql.Append(" (@Name,@EffectDate,@EndDate,@CustomerId,@Type,@Operator,@Num)");
SqlParameter[] sqlpar =
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@EffectDate", model.EffectDate),
new SqlParameter("@EndDate", model.EndDate),
new SqlParameter("@CustomerId", model.CustomerId),
new SqlParameter("@Type", model.Type),
new SqlParameter("@Operator", model.OperatorID),
new SqlParameter("@Num", model.Num)
};
int rows = DbHelperSQL.ExecuteSql(sql.ToString(), sqlpar);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改滚动文字
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateRollTitles(AMS.Model.AMS_RollTitles model)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE AMS_RollTitles");
sql.Append(" SET Name = @Name");
sql.Append(" ,EffectDate = @EffectDate");
sql.Append(" ,EndDate = @EndDate");
sql.Append(" ,CustomerId = @CustomerId");
sql.Append(" ,Type = @Type");
sql.Append(" ,Operator = @Operator ");
sql.Append("WHERE ID=@ID");
SqlParameter[] sqlpar =
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@EffectDate", model.EffectDate),
new SqlParameter("@EndDate", model.EndDate),
new SqlParameter("@CustomerId", model.CustomerId),
new SqlParameter("@Type", model.Type),
new SqlParameter("@Operator", model.OperatorID),
new SqlParameter("@ID", model.ID)
};
int rows = DbHelperSQL.ExecuteSql(sql.ToString(), sqlpar);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新滚动广告
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool GetTitleAd(int Num)
{
try
{
AMS.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;
}
}
