/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.AMS_HardAd GetModel(string Name) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Name,Operator,CustomerId,Number,EffectDate,EndDate,AdImage,Describe from AMS_HardAd "); strSql.Append(" where Name=@Name"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar) }; parameters[0].Value = Name; AMS.Model.AMS_HardAd model = new AMS.Model.AMS_HardAd(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "") { model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); } if (ds.Tables[0].Rows[0]["Operator"] != null && ds.Tables[0].Rows[0]["Operator"].ToString() != "") { model.Operator = int.Parse(ds.Tables[0].Rows[0]["Operator"].ToString()); } if (ds.Tables[0].Rows[0]["CustomerId"] != null && ds.Tables[0].Rows[0]["CustomerId"].ToString() != "") { model.CustomerId = int.Parse(ds.Tables[0].Rows[0]["CustomerId"].ToString()); } if (ds.Tables[0].Rows[0]["Number"] != null && ds.Tables[0].Rows[0]["Number"].ToString() != "") { model.Number = ds.Tables[0].Rows[0]["Number"].ToString(); } if (ds.Tables[0].Rows[0]["EffectDate"] != null && ds.Tables[0].Rows[0]["EffectDate"].ToString() != "") { model.EffectDate = DateTime.Parse(ds.Tables[0].Rows[0]["EffectDate"].ToString()); } if (ds.Tables[0].Rows[0]["EndDate"] != null && ds.Tables[0].Rows[0]["EndDate"].ToString() != "") { model.EndDate = DateTime.Parse(ds.Tables[0].Rows[0]["EndDate"].ToString()); } if (ds.Tables[0].Rows[0]["AdImage"] != null && ds.Tables[0].Rows[0]["AdImage"].ToString() != "") { model.AdImage = (byte[])ds.Tables[0].Rows[0]["AdImage"]; } if (ds.Tables[0].Rows[0]["Describe"] != null && ds.Tables[0].Rows[0]["Describe"].ToString() != "") { model.Describe = ds.Tables[0].Rows[0]["Describe"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 预览硬广图片 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void previewmenu_Click(object sender, RoutedEventArgs e) { FunPage.MediaEdit.PreviewHardAdWindow preview = new PreviewHardAdWindow(); preview.vm_HardAdEditWindow.HardAdModel = preview.vm_HardAdEditWindow.GetModel((HardAdLbox.Items[HardAdLbox.SelectedIndex] as AMS.Model.AMS_HardAd).Name); AMS.Model.AMS_HardAd model = preview.vm_HardAdEditWindow.HardAdModel; BitmapImage bmi = new BitmapImage(); bmi.BeginInit(); MemoryStream ms = new MemoryStream(model.AdImage);//model.AdImage为从数据库中获取的byte[]数组 bmi.StreamSource = ms; bmi.EndInit(); preview.image1.Source = bmi; preview.ShowDialog(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.AMS_HardAd model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_HardAd set "); strSql.Append("Name=@Name,"); strSql.Append("Operator=@Operator,"); strSql.Append("CustomerId=@CustomerId,"); strSql.Append("Number=@Number,"); strSql.Append("EffectDate=@EffectDate,"); strSql.Append("EndDate=@EndDate,"); strSql.Append("AdImage=@AdImage,"); strSql.Append("Describe=@Describe"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Operator", SqlDbType.Int, 4), new SqlParameter("@CustomerId", SqlDbType.Int, 4), new SqlParameter("@Number", SqlDbType.NVarChar, 50), new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@AdImage", SqlDbType.Image), new SqlParameter("@Describe", SqlDbType.NVarChar, 200), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.Operator; parameters[2].Value = model.CustomerId; parameters[3].Value = model.Number; parameters[4].Value = model.EffectDate; parameters[5].Value = model.EndDate; parameters[6].Value = model.AdImage; parameters[7].Value = model.Describe; parameters[8].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AMS.Model.AMS_HardAd model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_HardAd("); strSql.Append("Name,Operator,CustomerId,Number,EffectDate,EndDate,AdImage,Describe)"); strSql.Append(" values ("); strSql.Append("@Name,@Operator,@CustomerId,@Number,@EffectDate,@EndDate,@AdImage,@Describe)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Operator", SqlDbType.Int, 4), new SqlParameter("@CustomerId", SqlDbType.Int, 4), new SqlParameter("@Number", SqlDbType.NVarChar, 50), new SqlParameter("@EffectDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@AdImage", SqlDbType.Image), new SqlParameter("@Describe", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.Name; parameters[1].Value = model.Operator; parameters[2].Value = model.CustomerId; parameters[3].Value = model.Number; parameters[4].Value = model.EffectDate; parameters[5].Value = model.EndDate; parameters[6].Value = model.AdImage; parameters[7].Value = model.Describe; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 删除硬广 /// </summary> /// <param name="model"></param> /// <returns></returns> public static string DeleteHardAd(AMS.Model.AMS_HardAd model) { AMS.IBllService.IAdvertManageBllService bllService = AMS.ServiceConnectChannel.AdvertManageBllServiceChannel.CreateServiceChannel(); try { return(bllService.DeleteHardAd(model)); } catch (EndpointNotFoundException ex) { throw new AMS.Model.CustomerException("连接服务器失败"); } catch (CommunicationException ex) { throw ex; } catch (Exception ex) { throw ex; } finally { ICommunicationObject ICommObjectService = bllService as ICommunicationObject; try { if (ICommObjectService.State == CommunicationState.Faulted) { ICommObjectService.Abort(); } else { ICommObjectService.Close(); } } catch { ICommObjectService.Abort(); } } }
/// <summary> /// 获取硬广,并且执行添加到学校数据库操作 /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool GetHardAd(int id) { try { AMS.Model.AMS_HardAd hardAdModel = AMS.ServiceProxy.IHardAdService.GetHardAdModelByNum(id); if (hardAdModel != null) { SeatManage.ClassModel.HardAdvertInfo seathardAdvert = SeatManage.Bll.AMS_HardAd.GetHardAdvertByNum(hardAdModel.Number); if (seathardAdvert != null) { seathardAdvert.AdvertImage = hardAdModel.AdImage; seathardAdvert.EffectDate = Convert.ToDateTime(hardAdModel.EffectDate); seathardAdvert.EndDate = Convert.ToDateTime(hardAdModel.EndDate); if (SeatManage.Bll.AMS_HardAd.UpdateHardAdvert(seathardAdvert) == SeatManage.EnumType.HandleResult.Successed) { return(true); } } else { seathardAdvert = new SeatManage.ClassModel.HardAdvertInfo(); seathardAdvert.AdvertImage = hardAdModel.AdImage; seathardAdvert.EffectDate = Convert.ToDateTime(hardAdModel.EffectDate); seathardAdvert.EndDate = Convert.ToDateTime(hardAdModel.EndDate); seathardAdvert.HardAdvertNo = hardAdModel.Number; if (SeatManage.Bll.AMS_HardAd.AddHardAd(seathardAdvert) == SeatManage.EnumType.HandleResult.Successed) { return(true); } } } return(true); } catch (Exception ex) { throw ex; } }