private void SaveToDb(bool isEdit, MyKanji kanji)
{
try
{
if (isEdit)
{
using (var db = new mainEntities())
{
var result = db.MyKanjis.SingleOrDefault(b => b.C_key == kanji.C_key);
if (result != null)
{
SetData(ref result, _kanjiViewModel);
db.SaveChanges();
FlashCardView.KanjiList = db.MyKanjis.ToList <MyKanji>();
}
}
}
else
{
using (var db = new mainEntities())
{
MyKanji result = new MyKanji();
long maxKey = (from ka in FlashCardView.KanjiList select ka.C_key).Max();
SetData(ref result, _kanjiViewModel);
db.MyKanjis.Add(result);
db.SaveChanges();
FlashCardView.KanjiList = db.MyKanjis.ToList <MyKanji>();
}
}
}
catch (Exception ex)
{
}
}
public MainWindowViewModel(TransferData transferData, IDbContext dbContext)
{
_dbContext = dbContext.DbContext;
_transferData = transferData ?? throw new ArgumentNullException(nameof(transferData));
_authors = new ObservableCollection <Authors>();
FilterAuthors = "";
_books = new ObservableCollection <Books>();
FilterBooks = "";
DeleteBookCommand = new RelayCommand(DeleteBook, x => SelectedBook != null);
AddBookCommand = new RelayCommand(AddBook, x => SelectedAuthor != null);
EditBookCommand = new RelayCommand(EditBook, x => SelectedBook != null);
GetInfoAboutApp = new RelayCommand(x => MessageBox.Show("App.xaml.cs\n" +
"Курсовой проект.\n" +
"Корпоративная библиотека предприятия.\n" +
"Студент группы МОИС-451, Неретин Е.М. 2021 год.\n"));
DeleteAuthorCommand = new RelayCommand(DeleteAuthor, x => x != null);
AddAuthorCommand = new RelayCommand(AddAuthor);
EditAuthorCommand = new RelayCommand(EditAuthor, x => x != null);
SettingCompaniesCommand = new RelayCommand(SettingCompanies);
SettingGenresCommand = new RelayCommand(SettingGenre);
RefreshListAuthors();
}
private void BtnSaveAdd_Click(object sender, RoutedEventArgs e)
{
//界面控制
btnAdd.Visibility = Visibility.Visible;
btnSaveAdd.Visibility = Visibility.Collapsed;
btnEdit.Visibility = Visibility.Visible;
btnDelete.Visibility = Visibility.Visible;
txtBoxName.IsReadOnly = true;
txtBoxID.IsReadOnly = true;
//数据处理
staff staff = (staff)gridMemberInfo.DataContext;
if (IsFormLegal(staff) == "")
{
using (mainEntities db = new mainEntities())
{
staff.Id = db.staffs.Count() + 1;
db.staffs.Add(staff);
db.SaveChanges();
db.Dispose();
}
MessageBox.Show("已添加！");
}
}
/// <summary>
/// 点击删除按钮后的操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
staff staff = (staff)gridMemberInfo.DataContext;
if (MessageBox.Show("是否删除当前代理人", "确认删除", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
using (mainEntities db = new mainEntities())
{
var entry = db.Entry(staff);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
db.staffs.Attach(staff);
}
db.staffs.Remove(staff);
db.SaveChanges();
db.Dispose();
}
//List<MemberTree> department = new List<MemberTree>() { GetAllMembers(staff.部门) };
//memberTree.ItemsSource = department;
dgStaff.ItemsSource = null;
gridMemberInfo.DataContext = null;
}
}
/// <summary>
/// 获得全部文件夹集合
/// </summary>
/// <returns>全部文件夹集合</returns>
public static List <Floder> TravelFloder()
{
using (mainEntities db = new mainEntities())
{
return(db.Floder.Where(u => u.FatherDirectory == 1).ToList());
}
}
/// <summary>
/// 获得全部其他文件集合
/// </summary>
/// <returns>全部其他文件集合</returns>
public static List <Filedate> TravelOther()
{
using (mainEntities db = new mainEntities())
{
return(db.Filedate.Where(u => u.Type.Contains("exe") || u.Type.Contains("zip") || u.Type.Contains("rar")).ToList());
}
}
public AuthorWindowViewModel(TransferData transferData, IDbContext dbContext)
{
_dbContext = dbContext.DbContext;
_transferData = transferData ?? throw new ArgumentNullException(nameof(transferData));
Authors author = _dbContext.Authors.Where(x => x.ID_Author == transferData.ID_Author).SingleOrDefault();
if (author is null)
{
AcceptCommand = new RelayCommand(AddAuthor);
Author = new Authors();
Title = "Автор | Добавление";
}
else
{
AcceptCommand = new RelayCommand(EditAuthor);
Title = "Автор | Изменение";
Author = new Authors()
{
ID_Author = author.ID_Author.ToString(),
Name = author.Name.ToString(),
Surname = author.Surname.ToString(),
Patronymic = (author.Patronymic is null) ? "" : author.Patronymic.ToString(),
Nickname = (author.Nickname is null) ? "" : author.Nickname.ToString()
};
}
}
/// <summary>
/// 获得照片集合
/// </summary>
/// <returns>全部照片集合</returns>
public static List <Filedate> TravelPicture()
{
using (mainEntities db = new mainEntities())
{
return(db.Filedate.Where(u => u.Type.Contains("png") || u.Type.Contains("jpg") || u.Type.Contains("gif")).ToList());
}
}
//新建一筆資料
public bool AddProduct(int ProductId)
{
var result = this.cartItems
.Where(s => s.Id == ProductId)
.Select(s => s)
.FirstOrDefault();
//id判斷
if (result == default(Models.Cart.CartItem))
{
using (Models.mainEntities db = new mainEntities())
{
var product = (from s in db.Products where s.Id == ProductId select s).FirstOrDefault();
if (product != default(Models.Product)) //表示有新資料進入
{
this.AddProduct(product);
}
}
}
else
{
//已存在
result.Quantity += 1;
}
return(true);
}
/// <summary>
/// 获得全部视频文件
/// </summary>
/// <returns>全部视频文件</returns>
public static List <Filedate> TravelVideo()
{
using (mainEntities db = new mainEntities())
{
return(db.Filedate.Where(u => u.Type.Contains("mp4")).ToList());
}
}
/// <summary>
/// 验证新增的代理人信息是否符合要求
/// </summary>
/// <param name="staff"></param>
/// <returns></returns>
private string IsFormLegal(staff staff)
{
string message = "";
if (staff.Name == "")
{
message += "姓名为空！\n";
}
if (staff.Account == "")
{
message += "账号为空！\n";
}
string pattern = @"^\S\d{5}$";
if (!Regex.IsMatch(staff.Account, pattern))
{
message += "账号不符合规范，应为H+5位数字！\n";
}
using (mainEntities db = new mainEntities())
{
List <staff> staffs = new List <staff>();
staffs = db.staffs.Where(x => x.Account == staff.Account).ToList <staff>();
if (staffs.Count() > 0)
{
message += "账号已被使用！\n";
}
}
return(message);
}
/// <summary>
/// 保存网络最新操作状态
/// </summary>
/// <param name="userID"></param>
/// <param name="macAddress"></param>
/// <param name="onLineStatus"></param>
/// <param name="OperateContext"></param>
private void WriteOnLineStatus(string userID, List <string> macAddress, OnLineOperateType onLineStatus, string OperateContext = "")
{
string _mac = string.Join(",", macAddress.ToArray());
using (mainEntities db = new mainEntities())
{
var lines = db.Session_LastOperation.Where(x => x.MacID == _mac).FirstOrDefault();
if (lines != null)
{
lines.LastOperator = onLineStatus.ToString();
lines.OperateContext = OperateContext;
lines.LastOperationTime = DateTime.Now.ToString();
lines.LastOperator = userID;
}
else
{
lines = new Session_LastOperation();
lines.MacID = _mac;
lines.LastOperator = onLineStatus.ToString();
lines.OperateContext = OperateContext;
lines.LastOperationTime = DateTime.Now.ToString();
lines.LastOperator = userID;
db.Session_LastOperation.Add(lines);
}
db.SaveChanges();
}
}
/// <summary>
/// 获得查询文件
/// </summary>
/// <param name="name">文件名</param>
/// <returns>查询文件集合</returns>
public static List <Filedate> GetFindFiledate(string name)
{
using (mainEntities db = new mainEntities())
{
return(db.Filedate.Where(s => s.Name.Contains(name)).ToList());
}
}
public MainWindowViewModel(TransferData transferData, IDbContext dbContext)
{
_dbContext = dbContext.DbContext;
_transferData = transferData ?? throw new ArgumentNullException(nameof(transferData));
_authors = new ObservableCollection <Authors>();
FilterAuthors = "";
_books = new ObservableCollection <Books>();
FilterBooks = "";
DeleteBookCommand = new RelayCommand(DeleteBook, x => SelectedBook != null);
AddBookCommand = new RelayCommand(AddBook, x => SelectedAuthor != null);
EditBookCommand = new RelayCommand(EditBook, x => SelectedBook != null);
DeleteAuthorCommand = new RelayCommand(DeleteAuthor, x => x != null);
AddAuthorCommand = new RelayCommand(AddAuthor);
EditAuthorCommand = new RelayCommand(EditAuthor, x => x != null);
SettingCompaniesCommand = new RelayCommand(SettingCompanies);
SettingGenresCommand = new RelayCommand(SettingGenre);
RefreshListAuthors();
}
/// <summary>
/// 获得全部文本集合
/// </summary>
/// <returns>全部文本集合</returns>
public static List <Filedate> GetFile()
{
using (mainEntities db = new mainEntities())
{
return(db.Filedate.Where(u => u.Type.Contains("xlsx") || u.Type.Contains("doc") || u.Type.Contains("ppt")).ToList());
}
}
private void InitializeDataForGroupCombo()
{
List <GROUP_KANJI> grouplist = new List <GROUP_KANJI>();
using (mainEntities mainEntities = new mainEntities())
{
grouplist = mainEntities.GROUP_KANJI.ToList <GROUP_KANJI>();
}
List <GroupWordViewModel> groupListViewModel = new List <GroupWordViewModel>();
foreach (var group in grouplist)
{
groupListViewModel.Add(new GroupWordViewModel
{
GroupName = Convert.ToString(group.groupname),
GroupId = (int)group.groupid,
});
}
cmbGroup.ItemsSource = groupListViewModel;
cmbGroup_SelectionChanged(null, null);
//this._flashCardView.SetLabelFont(Convert.ToString(cmbFonts.SelectedValue));
//KanjiFont fonts = new KanjiFont();
//fontsDict.Keys.CopyTo(fonts.FontFamilyNameList, 0);
//this.cmbFonts.ItemsSource = fonts.FontFamilyNameList;
}
/// <summary>
/// 获得全部文件集合
/// </summary>
/// <returns>全部文件集合</returns>
public static List <Filedate> TravelFile()
{
using (mainEntities db = new mainEntities())
{
return(db.Filedate.Where(u => u.FatherFolder == 1).ToList());
}
}
/// <summary>
/// 获取部门所有成员，并以membertree的形式返回
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
private MemberTree GetAllMembers(string department)
{
MemberTree Department = new MemberTree();
Department.Name = department;
using (mainEntities db = new mainEntities())
{
List <staff> staffs = new List <staff>();
staffs = db.staffs.Where(x => x.部门 == department).ToList <staff>();;
foreach (var item in staffs)
{
//新建一个与datarow对应的子树
MemberTree Company = new MemberTree();
Company.Name = item.分公司;
Company.Children = new List <MemberTree>();
MemberTree Group = new MemberTree();
Group.Name = item.组别;
Group.Children = new List <MemberTree>();
MemberTree Member = new MemberTree();
//Member.Name = dr["姓名"].ToString()+"("+dr["系统账号"].ToString()+")";
Member.Name = item.Name;
Member.Account = item.Account;
Group.Children.Add(Member);
Company.Children.Add(Group);
//将子树合并到部门树中去
Department.Add(Company);
}
}
return(Department);
}
private void bgkInit_DoWork(object sender, DoWorkEventArgs e)
{
//读取本机数据库，获取配置信息
using (mainEntities db = new mainEntities())
{
var user = db.Session_Users.Where(x => x.userID == userID).FirstOrDefault();
if (user != null)
{
userName = user.userName; //获取
userAccount = user.userAccount; //获取账号
//获取照片
if (user.userPhoto != null)
{
try
{
Image photo = Image.FromStream(new MemoryStream(user.userPhoto));
}
catch
{
}
}
//获取拥有权限
var rights = db.Session_Grant_Users.Where(x => x.userID == user.userID).ToList();
foreach (var itm in rights)
{
roleList.Add(itm.roleID);
}
}
//获取最后通信时间
List <string> macIP = common.GetMacAddress();
List <Session_LastOperation> lastTime = new List <Session_LastOperation>();
foreach (string itm in macIP)
{
var last = db.Session_LastOperation.Where(x => x.MacID.Contains(itm)).FirstOrDefault();
if (last != null)
{
lastTime.Add(last);
}
}
if (lastTime.Count > 0)
{
lastSessionTime = DateTime.Parse(lastTime.Max(x => x.LastOperationTime));
}
string _MacAddress = string.Join(",", macIP.ToArray());
var _login = db.Session_LogIn.FirstOrDefault(x => x.lastLogMacID == _MacAddress);
if (_login != null)
{
WorkStatus _t;
if (Enum.TryParse(_login.WorkStatus, out _t))
{
OldWorkStatus = _t;
}
}
}
}
/// <summary>
/// 获得子文件夹
/// </summary>
/// <param name="name">文件名</param>
/// <returns>子文件夹集合</returns>
public static List <Floder> GetChildfolder(string name)
{
using (mainEntities db = new mainEntities())
{
Floder flode = db.Floder.Where(u => u.Name == name).FirstOrDefault();
return(db.Floder.Where(u => u.FatherDirectory == flode.ID).ToList());
}
}
/// <summary>
/// 获取MD5名称EF
/// </summary>
/// <param name="name">名字</param>
/// <returns>MD5名称</returns>
public static string GetMd5Name(string name)
{
using (mainEntities db = new mainEntities())
{
Filedate filedate = db.Filedate.Where(u => u.Name == name).FirstOrDefault();
return(filedate.MD5Name);
}
}
/// <summary>
/// 获得子文件
/// </summary>
/// <param name="name">文件名</param>
/// <returns>子文件集合</returns>
public static List <Filedate> GetChildfiledate(string name)
{
using (mainEntities db = new mainEntities())
{
Floder flode = db.Floder.Where(u => u.Name == name).FirstOrDefault();
return(db.Filedate.Where(u => u.FatherFolder == flode.ID).ToList());
}
}
public void Update(Cards item)
{
using (var db = new mainEntities())
{
db.Cards.Attach(item);
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// 移动文件夹EF
/// </summary>
/// <param name="name">文件夹名称</param>
/// <param name="relativePath">相对路径</param>
/// <returns>成功OR失败</returns>
public static bool MoveFloder(string name, string relativePath)
{
using (mainEntities db = new mainEntities())
{
Floder floder = db.Floder.Where(u => u.Name == name).FirstOrDefault();
floder.RelativePath = relativePath;
// floder.FullPath = path + relativePath;
return(db.SaveChanges() > 0 ? true : false);
}
}
private void FormLogin_Shown(object sender, EventArgs e)
{
//从本机数据库中加载历史登录信息
using (mainEntities db = new mainEntities())
{
List <Session_Users> list = db.Session_Users.ToList();
cboUserID.DataSource = list;
cboUserID.DisplayMember = "userName";
cboUserID.ValueMember = "userID";
}
}
private bool testConnecton()
{
var con = ConfigurationManager.ConnectionStrings["mainEntities"].ConnectionString;
//MessageBox.Show(con);
using (mainEntities dbContext = new mainEntities())
{
return(dbContext.Database.Exists());
}
}
public List <Cards> GetAll()
{
List <Cards> cards = null;
using (var db = new mainEntities())
{
cards = db.Cards.ToList();
}
return(cards);
}
public List <Phones> GetAll()
{
List <Phones> phones = null;
using (var db = new mainEntities())
{
phones = db.Phones.ToList();
}
return(phones);
}
public List <Transactions> GetAll()
{
List <Transactions> transactions = null;
using (var db = new mainEntities())
{
transactions = db.Transactions.ToList();
}
return(transactions);
}
public List <Clients> GetAll()
{
List <Clients> clients = null;
using (var db = new mainEntities())
{
clients = db.Clients.ToList();
}
return(clients);
}
