/// <summary> /// 增加一条数据 /// </summary> public bool Add(SeatManage.ClassModel.AMS_Advertisement model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_Advertisement("); strSql.Append("[Num],[Name],[EffectDate],[EndDate],[Type],[AdContent])"); strSql.Append(" values ("); strSql.Append("@Num,@Name,@EffectDate,@EndDate,@Type,@AdContent)"); SqlParameter[] parameters = { new SqlParameter("@Num", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@Type", SqlDbType.Int), new SqlParameter("@AdContent", SqlDbType.Text) }; parameters[0].Value = model.Num; parameters[1].Value = model.Name; parameters[2].Value = model.EffectDate; parameters[3].Value = model.EndDate; parameters[4].Value = (int)model.Type; parameters[5].Value = model.AdContent; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加广告 /// </summary> /// <param name="adInfo"></param> /// <returns></returns> public static string AddAdModel(SeatManage.ClassModel.AMS_Advertisement adInfo) { IWCFService.ISeatManageService seatService = WcfAccessProxy.ServiceProxy.CreateChannelSeatManageService(); try { return(seatService.AddAdModel(adInfo)); } catch (FaultException ex) { SeatManageComm.WriteLog.Write("添加广告失败:" + ex.Message); return(ex.Message); } finally { ICommunicationObject ICommObjectService = seatService as ICommunicationObject; try { if (ICommObjectService.State == CommunicationState.Faulted) { ICommObjectService.Abort(); } else { ICommObjectService.Close(); } } catch { ICommObjectService.Abort(); } } }
/// <summary> /// 删除广告 /// </summary> /// <param name="adInfo"></param> /// <returns></returns> public static string DeleteAdModel(SeatManage.ClassModel.AMS_Advertisement adInfo) { IWCFService.ISeatManageService seatService = new WcfServiceForSeatManage.SeatManageDateService(); try { return(seatService.DeleteAdModel(adInfo)); } catch (FaultException ex) { SeatManageComm.WriteLog.Write("删除广告失败:" + ex.Message); return(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SeatManage.ClassModel.AMS_Advertisement model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_Advertisement set "); strSql.Append("Num=@Num,"); strSql.Append("Name=@Name,"); strSql.Append("EffectDate=@EffectDate,"); strSql.Append("EndDate=@EndDate,"); strSql.Append("[Type]=@Type,"); strSql.Append("AdContent=@AdContent"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@Num", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@Type", SqlDbType.Int), new SqlParameter("@AdContent", SqlDbType.Text), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.Num; parameters[1].Value = model.Name; parameters[2].Value = model.EffectDate; parameters[3].Value = model.EndDate; parameters[4].Value = (int)model.Type; parameters[5].Value = model.AdContent; parameters[6].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(SeatManage.ClassModel.AMS_Advertisement model) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from AMS_Advertisement "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }