/// <summary> /// 更新一条数据 /// </summary> public bool Update(HardAdvertInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_HardAd set "); strSql.Append("EffectDate=@EffectDate,"); strSql.Append("EndDate=@EndDate,"); strSql.Append("AdImage=@AdImage"); strSql.Append(" where AdNo=@AdNo "); SqlParameter[] parameters = { new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@AdImage", SqlDbType.Image), new SqlParameter("@AdNo", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.EffectDate; parameters[1].Value = model.EndDate; parameters[2].Value = model.AdvertImage; parameters[3].Value = model.HardAdvertNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HardAdvertInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_HardAd("); strSql.Append("AdNo,EffectDate,EndDate,AdImage)"); strSql.Append(" values ("); strSql.Append("@AdNo,@EffectDate,@EndDate,@AdImage)"); SqlParameter[] parameters = { new SqlParameter("@AdNo", SqlDbType.NVarChar, 50), new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@AdImage", SqlDbType.Image) }; parameters[0].Value = model.HardAdvertNo; parameters[1].Value = model.EffectDate; parameters[2].Value = model.EndDate; parameters[3].Value = model.AdvertImage; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加硬广操作 /// </summary> /// <param name="hardAdvert"></param> /// <returns></returns> public static SeatManage.EnumType.HandleResult AddHardAd(HardAdvertInfo hardAdvert) { IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService(); bool error = false; try { return(seatService.AddHardAd(hardAdvert)); } catch (FaultException 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(); } } }
private HardAdvertInfo dataRowToHardAdvertInfo(DataRow dr) { HardAdvertInfo info = new HardAdvertInfo(); info.AdvertImage = (byte[])dr["AdImage"]; info.EffectDate = DateTime.Parse(dr["EffectDate"].ToString()); info.EndDate = DateTime.Parse(dr["EndDate"].ToString()); info.HardAdvertNo = dr["AdNo"].ToString(); return(info); }
/// <summary> /// 更新硬广内容 /// </summary> /// <param name="model"></param> /// <returns></returns> public SeatManage.EnumType.HandleResult UpdateHardAdvert(HardAdvertInfo model) { if (ams_HardAd.Update(model)) { return(SeatManage.EnumType.HandleResult.Successed); } else { return(SeatManage.EnumType.HandleResult.Failed); } }
/// <summary> /// 添加硬广 /// </summary> /// <param name="hardAdvert"></param> /// <returns></returns> public SeatManage.EnumType.HandleResult AddHardAd(HardAdvertInfo hardAdvert) { if (ams_HardAd.Add(hardAdvert)) { return(SeatManage.EnumType.HandleResult.Successed); } else { return(SeatManage.EnumType.HandleResult.Failed); } }
/// <summary> /// 更新硬广 /// </summary> /// <param name="model"></param> /// <returns></returns> public static SeatManage.EnumType.HandleResult UpdateHardAdvert(HardAdvertInfo model) { IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService(); bool error = false; try { return(seatService.UpdateHardAdvert(model)); } catch (FaultException ex) { error = true; SeatManageComm.WriteLog.Write("更新硬广失败:" + ex.Message); return(EnumType.HandleResult.Failed); } }