/// <summary> /// 更新一条数据 /// </summary> public bool Update(SeatManage.ClassModel.TitleAdvertInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_TitleAd set "); strSql.Append("EffectDate=@EffectDate,"); strSql.Append("EndDate=@EndDate,"); strSql.Append("AdContent=@AdContent"); strSql.Append(" where Num=@Num "); SqlParameter[] parameters = { new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@AdContent", SqlDbType.Text), new SqlParameter("@Num", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.EffectDate; parameters[1].Value = model.EndDate; parameters[2].Value = model.TitleAdvert; parameters[3].Value = model.TitleAdvertNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加冠名广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public static EnumType.HandleResult AddTitleAdvert(SeatManage.ClassModel.TitleAdvertInfo model) { IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService(); bool error = false; try { return(seatService.AddTitleAdvert(model)); } catch (Exception ex) { error = true; SeatManageComm.WriteLog.Write("添加冠名广告失败:" + ex.Message); return(EnumType.HandleResult.Failed); } finally { ICommunicationObject ICommObjectService = seatService as ICommunicationObject; try { if (ICommObjectService.State == CommunicationState.Faulted) { ICommObjectService.Abort(); } else { ICommObjectService.Close(); } } catch { ICommObjectService.Abort(); } } }
/// <summary> /// 删除冠名广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public static EnumType.HandleResult DeleteTitleAdvert(SeatManage.ClassModel.TitleAdvertInfo model) { IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService(); bool error = false; try { return(seatService.DeleteTitleAdvert(model)); } catch (Exception ex) { error = true; SeatManageComm.WriteLog.Write("删除冠名广告失败:" + ex.Message); return(EnumType.HandleResult.Failed); } }
/// <summary> /// 删除冠名广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public SeatManage.EnumType.HandleResult DeleteTitleAdvert(SeatManage.ClassModel.TitleAdvertInfo model) { try { if (ams_TitleAd.Delete(model.ID)) { return(SeatManage.EnumType.HandleResult.Successed); } else { return(SeatManage.EnumType.HandleResult.Failed); } } catch (Exception ex) { throw ex; } }