public void Execute()
{
var dt = SqlServerCompactService.GetData("UserAccount");
var useraccount = from user in dt.AsEnumerable()
where user.Field <string>("UserName") == UserName && user.Field <string>("Password") == Password
select user;
if (useraccount.ToList().Count == 0)
{
UserName = "******";
}
else
{
SalesWindow window = new SalesWindow();
SalesWindowViewModel model = new SalesWindowViewModel(window);
model.AfterLogoutHandler += (s, e) => { UserName = ""; Password = ""; };
window.DataContext = model;
window.Owner = Application.Current.MainWindow;
window.ShowDialog();
}
}
private void BindData()
{
SOURCE = new ObservableCollection <Customer>(SqlServerCompactService.GetData("Customer").Cast <Customer>());
SOURCE = new ObservableCollection <Customer>(SOURCE.OrderByDescending(s => s.UpdateTime));
CustomerColletion = new ObservableCollection <Customer>(SOURCE.Skip(PageIndex * PAGESIZE).Take(PAGESIZE));
}
static ItemTypeModel()
{
ItemTypeModelList = SqlServerCompactService.GetData("ItemTypeModel").Cast <ItemTypeModel>().ToList();
}