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>
/// <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);
}
}
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
{
}
});
}
