public void GetDateList(Action <ActionResult> action = null)
{
Task.Factory.StartNew(() =>
{
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
TitleInfoRequest request = new TitleInfoRequest();
request.PageIndex = 1;
request.PageSize = 100;
TitleInfoListResponse str = titleInfo.SelectTitleInfoList(request);
if (str.RowCount > 0)
{
List <MainWindowModel> tList = str.mainWindowModels.ToList();
ObservableCollection <MainWindowModel> oc = new ObservableCollection <MainWindowModel>();
tList.ForEach(x => oc.Add(x));
Items = oc;
}
else
{
return;
}
var result = new ActionResult();
try
{
result.Result = true;
}
catch (Exception exception)
{
result.ErrorMessage = exception.Message;
}
finally
{
action?.Invoke(result);
}
});
}
private void ExcuteSendCommand()
{
try
{
//if (!(obj is Window win))
// return;
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
//TitleHandleRequest request = new TitleHandleRequest();
//request.ID = SelectItem.ID;
var ret = titleInfo.RelieveBinds(TitleID);
if (ret == 1)
{
//win.Close();
SavaPicMsg = "成功还原";
AddTitlePageViewModel.Incccc.Init();
//PageNo = 0;
}
else if (ret == 3)
{
SavaPicMsg = "失败还原";
}
else if (ret == 101)
{
SavaPicMsg = "未知错误";
}
Messenger.Default.Send <String>(ret.ToString(), "ViewAlert"); //注意：token参数一致
}
catch (Exception)
{
}
finally
{
}
}
/// <summary>
/// 加载数据
/// </summary>
public async void Init()
{
Items.Clear();
await Task.Run(() =>
{
try
{
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
TitleInfoRequest request = new TitleInfoRequest();
request.PageIndex = 0;
request.PageSize = 20;
//request.IsOccupy = 0;
request.UserNo = No;
var str = titleInfo.SelectAllTitleInfoList(request);
if (str.RowCount > 0)
{
PageMax = str.PageMax;
var tList = str.mainWindowModels.ToList();
ObservableCollection <MainWindowModel> oc = new ObservableCollection <MainWindowModel>();
tList.ForEach(x => oc.Add(x));
Items = oc;
//foreach (var item in tList)
//{
// Items.Add(item);
//}
//foreach (var item in Items)
//{
// item.IsHandle = 0;
//}
}
else
{
return;
}
//var result = new ActionResult();
//result.Result = true;
}
catch (Exception e)
{
var str = e.Message;
}
finally
{
}
});
}
/// <summary>
/// 身份认证
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
//string logStr = "select count(*) from UserInfo where UserName='******' and PassWord='******'";
//int result = SqlHelper.cmdExecuteScalar(logStr);
//if (result == 0)
//{
// MessageBox.Show("登陆失败!");
// return;
//}
//this.Title = "欢迎【" + this.txtUserName.Text.Trim() + "】登陆!";
//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);
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
TitleInfoRequest request = new TitleInfoRequest();
request.PageIndex = 0;
request.PageSize = 10;
request.IsOccupy = 0;
//request.UserNo = No;
TitleInfoListResponse str = titleInfo.SelectUserTitleInfoList(request);
var tList = new List <MainWindowModel>();
if (str.RowCount > 0)
{
//PageMax = str.PageMax;
tList = str.mainWindowModels.ToList();
//ObservableCollection<MainWindowModel> oc = new ObservableCollection<MainWindowModel>();
//tList.ForEach(x => oc.Add(x));
//Items = oc;
}
else
{
return;
}
foreach (var l in tList)
{
Button btn = new Button()
{
BorderThickness = new Thickness(2), FontSize = Convert.ToDouble(15.0)
};
btn.Click += Btn_Click;
btn.Content = l.NewTitle;
this.warpPanelKeys.Children.Add(btn);
}
}
private void Handle_Click(object sender, RoutedEventArgs e)
{
try
{
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
TitleHandleRequest request = new TitleHandleRequest();
//request.PageIndex = 0;
//request.PageSize = 20;
////request.IsOccupy = 0;
//PageNo = request.PageIndex;
//request.UserNo = No;
request.ID = ViewModel.SelectItem.ID;
var str = titleInfo.TitleHandle(request);
if (str == 1)
{
//Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
TitleInfoRequest requestTitleInfo = new TitleInfoRequest();
requestTitleInfo.PageIndex = ViewModel.PageNo;
requestTitleInfo.PageSize = 20;
//request.IsOccupy = 0;
requestTitleInfo.UserNo = ViewModel.No;
var strTitleInfo = titleInfo.SelectAllTitleInfoList(requestTitleInfo);
if (strTitleInfo.RowCount > 0)
{
ViewModel.PageMax = strTitleInfo.PageMax;
var tList = strTitleInfo.mainWindowModels.ToList();
ObservableCollection <MainWindowModel> oc = new ObservableCollection <MainWindowModel>();
tList.ForEach(x => oc.Add(x));
ViewModel.Items = oc;
}
}
else
{
return;
}
//var result = new ActionResult();
//result.Result = true;
}
catch (Exception)
{
}
finally
{
}
}
//private ObservableCollection<MainWindowModel> _items;
//public ObservableCollection<MainWindowModel> Items
//{
// get { return _items; }
// set { Set("Items", ref _items, value); }
//}
#region 加载数据
/// <summary>
/// 加载数据
/// </summary>
public async void Init()
{
await Task.Run(() =>
{
try
{
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
BaiDuInfoRequest request = new BaiDuInfoRequest();
request.TitleID = TitleID;
var str = titleInfo.SelectBaiDuInfoList(request);
UserName = str.UserName;
UserNo = str.UserNo;
NewTitle = str.NewTitle;
OldTitle = str.OldTitle;
UpTime = str.UpTime;
var tList = str.PicModelList;
ObservableCollection <PictureControlModel> oc = new ObservableCollection <PictureControlModel>();
tList.ForEach(x => oc.Add(x));
PicItmes = oc;
//PicItmes = str.PicModelList;
//if (str.RowCount > 0)
//{
// PageMax = str.PageMax;
// var tList = str.mainWindowModels.ToList();
// ObservableCollection<MainWindowModel> oc = new ObservableCollection<MainWindowModel>();
// tList.ForEach(x => oc.Add(x));
// Items = oc;
//}
//else
//{
// return;
//}
//var result = new ActionResult();
//result.Result = true;
}
catch (Exception)
{
}
finally
{
}
});
}
private void TitleHandle_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.DialogResult dr = System.Windows.Forms.MessageBox.Show("隐藏数据不可撤销，确认隐藏数据吗？", "温馨提示", System.Windows.Forms.MessageBoxButtons.YesNo);
if (dr.ToString() == "Yes")
{
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
TitleHandleRequest request = new TitleHandleRequest();
var str = titleInfo.TitleHandle(txtKeyWorlds.Text);
if (str == 1)
{
this.warpPanelKeys.Children.Clear();
this.AddStackPanel.Children.Clear();
MessageBox.Show("成功隐藏该数据");
LoadData();
}
else
{
return;
}
}
}
public void LoadData()
{
warpPanelKeys.Children.Clear();
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
TitleInfoRequest request = new TitleInfoRequest();
request.PageIndex = 0;
request.PageSize = 10;
request.IsOccupy = 0;
request.UserNo = ViewModel.No;
TitleInfoListResponse str = titleInfo.SelectUserTitleInfoList(request);
var tList = new List <MainWindowModel>();
if (str.RowCount > 0)
{
//PageMax = str.PageMax;
tList = str.mainWindowModels.ToList();
//ObservableCollection<MainWindowModel> oc = new ObservableCollection<MainWindowModel>();
//tList.ForEach(x => oc.Add(x));
//Items = oc;
}
else
{
return;
}
foreach (var l in tList)
{
Button btn = new Button()
{
BorderThickness = new Thickness(2), FontSize = Convert.ToDouble(15.0)
};
//FontSize = "24"
btn.FontSize = 20;
btn.Margin = new Thickness(10);
btn.Click += Btn_Click;
btn.Content = l.NewTitle;
this.warpPanelKeys.Children.Add(btn);
}
}
/// <summary>
/// 加载数据
/// </summary>
public async void Init()
{
await Task.Run(() =>
{
try
{
Entity.EFOperation.TitleInfo titleInfo = new Entity.EFOperation.TitleInfo();
TitleInfoRequest request = new TitleInfoRequest();
request.PageIndex = 0;
request.PageSize = 500;
request.IsOccupy = 0;
request.UserNo = No;
request.IsStep = 2;
TitleInfoListResponse str = titleInfo.SelectUserTitleInfoList(request);
if (str.RowCount > 0)
{
//PageMax = str.PageMax;
var tList = str.mainWindowModels.ToList();
ObservableCollection <MainWindowModel> oc = new ObservableCollection <MainWindowModel>();
tList.ForEach(x => oc.Add(x));
Items = oc;
}
else
{
return;
}
//var result = new ActionResult();
//result.Result = true;
}
catch (Exception)
{
}
finally
{
}
});
}
/// <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("数据入库失败!");
}
// }
}
