/// <summary> /// 把百度图片与关键字绑定 /// </summary> /// <param name="Request"></param> /// <returns></returns> public int UserBindBaiDuUrl(SavaPicRequest Request) { using (var dbContextTransaction = DbContext.Database.BeginTransaction()) { try { var dbset = DbContext.UserInfo.Where(c => c.TitleInfoID == Request.TitleInfoID && c.IsEnable == 1).FirstOrDefault(); if (dbset != null && dbset.ID > 0) { dbset.IsStep = 2; DbContext.SaveChanges(); for (int i = 0; i < Request.BaiDuUrlList.Count; i++) { Model.BaiDuInfo baiDuInfo = new BaiDuInfo { BaiDuUrl = Request.BaiDuUrlList[i], IsEnable = 1, TitleInfoID = Request.TitleInfoID }; DbContext.BaiDuInfo.Add(baiDuInfo); DbContext.SaveChanges(); } } else { return(3); } dbContextTransaction.Commit(); return(1); } catch (Exception e) { dbContextTransaction.Rollback(); return(101); } } }
/// <summary> /// 提交数据入库 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSaveData_Click(object sender, RoutedEventArgs e) { //System.Windows.Forms.DialogResult dr = System.Windows.Forms.MessageBox.Show("一个关键字只能提交一次,确认提交数据码?", "温馨提示", System.Windows.Forms.MessageBoxButtons.YesNo); //if (dr.ToString() == "Yes") //{ List <ImageCollectsDto> dtos = new List <ImageCollectsDto>(); var imgList = imageCount.imgItem.Where(m => m.imgCheck.Visibility == Visibility.Visible).ToList(); var urlList = new List <string>(); foreach (var imgL in imgList) { ImageCollectsDto imageCollects = new ImageCollectsDto(); imageCollects.ImageUrl = imgL.imgShow.Source.ToString(); imageCollects.ImageFrom = "百度"; //imageCollects.UserName = this.txtUserName.Text.Trim(); imageCollects.ImageClassName = this.txtKeyWorlds.Text.Trim(); dtos.Add(imageCollects); urlList.Add(imgL.imgShow.Source.ToString()); } //bool result = HttpHelper.BatchInsert(HttpHelper.ToDataTable(dtos), "ImageCollects"); Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo(); SavaPicRequest request = new SavaPicRequest(); //request.UserInfoID = SelectItem.ID; //request.IsEnable = 1; //request.TitleInfoID = SelectItem.ID; //var urlList = PictureControlViewModels.Where(c => c.IsCheck == true).Select(a => new { a.Url }).ToList();//把选中的url获取出来 //var newList = new List<string>(); //for (int i = 0; i < urlList.Count; i++) //{ // newList.Add(urlList[i].Url); //} //request.BaiDuUrlList = urlList; var ret = titleInfo.UserBindBaiDuUrlT(this.txtKeyWorlds.Text, urlList); //if (ret == 1) //{ // SavaPicMsg = "保存成功"; // Task.Run(new Action(Init)); // PageNo = 0; // PictureControlViewModels.Clear(); //} //else if (ret == 3) //{ // SavaPicMsg = "保存失败"; //} //else if (ret == 101) //{ // SavaPicMsg = "未知错误"; //} if (ret == 1) { ViewModel.Msg = "保存成功"; //System.Windows.Forms.MessageBox.Show("数据入库成功!"); //更改关键字 刷新界面 刷新关键字 //var res = SqlHelper.cmdExecuteNonQuery("update keywords set isuse=1 where key_name='" + this.txtKeyWorlds.Text.Trim() + "'"); this.warpPanelKeys.Children.Clear(); this.AddStackPanel.Children.Clear(); this.labCounts.Content = "已选素材 0 张"; this.txtKeyWorlds.Text = ""; LoadData(); //var dt = SqlHelper.GetLocalDataTable("select * from keywords where isown='" + this.txtUserName.Text.Trim() + "' and isuse=0 order by search_total"); //var list = ModelConvertHelper<keyWordDto>.ConvertToModel(dt); //foreach (var l in list) //{ // Button btn = new Button() { BorderThickness = new Thickness(2), FontSize = Convert.ToDouble(15.0) }; // btn.Click += Btn_Click; // btn.Content = l.key_name; // this.warpPanelKeys.Children.Add(btn); //} } else { ViewModel.Msg = "保存失败"; System.Windows.Forms.MessageBox.Show("数据入库失败!"); } // } }