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