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); } }); }
public TitleInfoListResponse SelectTitleInfoList(TitleInfoRequest Request) { TitleInfoListResponse response = new TitleInfoListResponse(); try { using (var entities = new ResKey_dbEntities()) { var rowCount = Request.PageIndex * Request.PageSize; var pageSize = Request.PageSize; var list = new List <Expression <Func <Entity.Model.TitleInfo, bool> > >(); if (Request.ID.HasValue) { list.Add(c => c.ID == Request.ID.Value); } if (Request.IsHandle.HasValue) { list.Add(c => c.IsHandle == Request.IsHandle); } Expression <Func <Entity.Model.TitleInfo, bool> > entitiesQuery = null; foreach (var expression in list) { entitiesQuery = entitiesQuery == null ? expression : entitiesQuery.And(expression); } var dbset = entities.TitleInfo; var query = entitiesQuery == null ? dbset : dbset.Where(entitiesQuery); var mainWindowModel = query.Select(entity => new MainWindowModel { ID = entity.ID, IsAdd = entity.IsAdd, IsHandle = entity.IsHandle, OldID = entity.OldID, ModificationTime = entity.ModificationTime, NewTitle = entity.NewTitle, OldTitle = entity.OldTitle, UpTime = entity.UpTime }); var arrayL = mainWindowModel.OrderBy(c => c.ID) .Skip(rowCount) .Take(pageSize) .ToArray() .OrderByDescending(c => c.ID).ToArray(); response.mainWindowModels = arrayL; response.RowCount = arrayL.Count(); response.PageSize = pageSize; } } catch (Exception exception) { //response.Error = new Error //{ // ErrorMessage = exception.GetBaseException().Message, // ErrorCode = 5001 //}; } return(response); }
/// <summary> /// 查询所有关键字 /// </summary> /// <param name="Request"></param> /// <returns></returns> public TitleInfoListResponse SelectAllTitleInfoList(TitleInfoRequest Request) { TitleInfoListResponse response = new TitleInfoListResponse(); try { using (var entities = new ResKey_dbEntities()) { var rowCount = Request.PageIndex * Request.PageSize; var pageSize = Request.PageSize; var list = new List <Expression <Func <Entity.Model.TitleInfo, bool> > >(); list.Add(c => c.IsHandle == 0); if (!string.IsNullOrWhiteSpace(Request.TitleName)) { list.Add(c => c.NewTitle.Contains(Request.TitleName)); } Expression <Func <Entity.Model.TitleInfo, bool> > entitiesQuery = null; foreach (var expression in list) { entitiesQuery = entitiesQuery == null ? expression : entitiesQuery.And(expression); } var dbset = entities.TitleInfo; var query = entitiesQuery == null ? dbset : dbset.Where(entitiesQuery); var mainWindowModel = query.Select(entity => new MainWindowModel { ID = entity.ID, IsAdd = entity.IsAdd, IsHandle = entity.IsHandle, OldID = entity.OldID, ModificationTime = entity.ModificationTime, NewTitle = entity.NewTitle, OldTitle = entity.OldTitle, UpTime = entity.UpTime }); var arrayL = mainWindowModel.OrderBy(c => c.ID) .Skip(rowCount) .Take(pageSize) .ToArray() .OrderByDescending(c => c.ID).ToArray(); //int c = a % b == 0 ? a / b : a / b + 1; response.PageMax = (mainWindowModel.Count() % Request.PageSize == 0 ? mainWindowModel.Count() / Request.PageSize : mainWindowModel.Count() / Request.PageSize + 1) - 1; //mainWindowModel.Count()/Request.PageSize; response.mainWindowModels = arrayL; response.RowCount = arrayL.Count(); response.PageSize = pageSize; } } catch (Exception exception) { } return(response); }
/// <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 { } }
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 { } }); }
public int TitleAddUser(TitleInfoRequest Request) { using (var dbContextTransaction = DbContext.Database.BeginTransaction()) { try { var rowCount = Request.PageIndex * Request.PageSize; var pageSize = Request.PageSize; var list = new List <Expression <Func <Entity.Model.TitleInfo, bool> > >(); if (Request.IsHandle.HasValue) { list.Add(c => c.IsHandle == Request.IsHandle); } list.Add(c => c.IsOccupy == 0); Expression <Func <Entity.Model.TitleInfo, bool> > entitiesQuery = null; foreach (var expression in list) { entitiesQuery = entitiesQuery == null ? expression : entitiesQuery.And(expression); } var dbset = DbContext.TitleInfo; var query = entitiesQuery == null ? dbset : dbset.Where(entitiesQuery); var mainWindowModel = query.Select(entity => new MainWindowModel { ID = entity.ID, IsAdd = entity.IsAdd, IsHandle = entity.IsHandle, OldID = entity.OldID, ModificationTime = entity.ModificationTime, NewTitle = entity.NewTitle, OldTitle = entity.OldTitle, UpTime = entity.UpTime }); var arrayL = mainWindowModel.OrderBy(c => c.ID) .Skip(rowCount) .Take(pageSize) .ToArray() .OrderByDescending(c => c.ID).ToArray(); for (int i = 0; i < arrayL.Count(); i++) { var ID = arrayL[i].ID; var dbModel = DbContext.TitleInfo.Where(c => c.ID == ID).FirstOrDefault(); if (dbModel != null) { dbModel.IsOccupy = 1;//已占用 var info = DbContext.UserInfo.Where(c => c.TitleInfoID == dbModel.ID && c.IsEnable == 1).FirstOrDefault(); if (info != null && info.ID > 0) { //return 2; } else { Model.UserInfo userInfo = new UserInfo { IsEnable = 1, TitleInfoID = dbModel.ID, UserName = Request.UserName, UserNo = Request.UserNo, }; DbContext.UserInfo.Add(userInfo); DbContext.SaveChanges(); } } } dbContextTransaction.Commit(); return(1); } catch (Exception e) { dbContextTransaction.Rollback(); return(101); } } }