/// <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("数据入库失败!");
}
// }
}
