/* * 初始化页面列表 */ private void initCombox() { StorageFileFolder firstFolder = storageFileFolderBll.get(1); if (firstFolder == null) { return; } ComboBoxItem defaultItem = new ComboBoxItem(); defaultItem.Content = "-- 请选择 --"; defaultItem.Tag = 0; defaultItem.IsSelected = true; moveToFolderId.Items.Add(defaultItem); ComboBoxItem firstItem = new ComboBoxItem(); firstItem.Content = firstFolder.name; firstItem.Tag = firstFolder.id; moveToFolderId.Items.Add(firstItem); int level = 0; getTreeViewItemChildren(firstItem, level, 0); }
/* * 初始化文件文件夹树 */ private void StorageFile_InitFolder() { //1.初始化页面树 StorageFileFolder storageFileFolder = storageFileFolderBll.get(1); if (storageFileFolder == null) { return; } TreeViewItem firstItem = new TreeViewItem(); firstItem.IsExpanded = true; firstItem.Header = storageFileFolder.name; firstItem.Tag = storageFileFolder.id; firstItem.Padding = new Thickness(5); StorageFile_GetTreeViewItemChildren(firstItem); //添加单击、右键事件 folderTreeColumn.MouseLeftButtonUp += (object sender, MouseButtonEventArgs e) => StorageFile_TreeView_MouseLeftButtonUp(sender, e); folderTreeColumn.Items.Clear(); folderTreeColumn.Items.Add(firstItem); }
/* * 获取要删除的图片 */ private void getPageNameForDelete() { StorageFileFolder storageFileFolder = storageFileFolderBll.get(folderId); if (storageFileFolder != null) { pageName.Content = storageFileFolder.name; } }
//页面居中显示到最前面 public StorageFileRenameFolderWindow(TreeView pageTreeColumn, Int32 folderId) { InitializeComponent(); WindowStartupLocation = WindowStartupLocation.CenterScreen; this.pageTreeColumn = pageTreeColumn; thatFolderId = folderId; StorageFileFolder thatFolder = storageFileFolderBll.get(thatFolderId); foldername.Text = thatFolder.name; }
/* * 获取最后一个文件夹 */ public StorageFileFolder getLastFolder() { String sql = "select * from storageFileFolder order by id desc limit 0,1"; SQLiteParameter[] parameters = { }; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); StorageFileFolder entity = DataToEntity <StorageFileFolder> .FillModel(dt.Rows[0]); return(entity); }
public StorageFileNewFolderWindow(TreeView folderTreeColumn, Int32 parentId) { InitializeComponent(); //this.folderTreeColumn = folderTreeColumn; this.folderTreeColumn = folderTreeColumn; this.parentId = parentId; StorageFileFolder lastFolder = storageFileFolderBll.getLastFolder(); Int32 maxFolderId = lastFolder.id + 1; pagename.Text = "新文件夹" + maxFolderId; WindowStartupLocation = WindowStartupLocation.CenterScreen; }
/* * 获取父栏目中最大的排序号 */ public StorageFileFolder getMaxIdxByParentId(int parentId) { String sql = "select max(idx) as idx from storageFileFolder where parentId=@parentId"; SQLiteParameter[] parameters = { new SQLiteParameter("@parentId", DbType.Int32, 4) }; parameters[0].Value = parentId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); StorageFileFolder entity = DataToEntity <StorageFileFolder> .FillModel(dt.Rows[0]); return(entity); }
/* * 将新添加的页面加入到页面树中 */ private void updateToTree(ItemsControl tree, StorageFileFolder storageVideoFolder) { foreach (TreeViewItem item in tree.Items) { Int32 pageId = (Int32)item.Tag; if (thatFolderId == pageId) { item.Header = storageVideoFolder.name; break; } else { updateToTree(item, storageVideoFolder); } } }
/* * 插入子文件夹 */ public StorageFileFolder insertChild(StorageFileFolder tmp) { //补充idx,createTime两个参数 StorageFileFolder maxFolder = getMaxIdxByParentId(tmp.parentId); if (maxFolder == null) { tmp.idx = 1; } else { tmp.idx = maxFolder.idx + 1; } return(storageFileFolderDal.insert(tmp)); }
/* * 是否存在同名文件夹 */ public int hasSameName(StorageFileFolder entity) { string sql = "select count(*) from storageFileFolder where name=@name and id!=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@name", DbType.String, 30), new SQLiteParameter("@id", DbType.Int32, 4) }; parameters[0].Value = entity.name; parameters[1].Value = entity.id; object obj = Common.SQLiteHelper.ExecuteScalar(sql, parameters); int result = int.Parse(obj.ToString()); return(result); }
/* * 插入一个文件夹 */ public StorageFileFolder insert(StorageFileFolder entity) { String sql = "insert into storageFileFolder(name,parentId,idx) values(@name,@parentId,@idx);select last_insert_rowid();"; SQLiteParameter[] parameters = { new SQLiteParameter("@name", DbType.String, 100), new SQLiteParameter("@parentId", DbType.Int32, 4), new SQLiteParameter("@idx", DbType.Int32, 4) }; parameters[0].Value = entity.name; parameters[1].Value = entity.parentId; parameters[2].Value = entity.idx; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); int id = DataType.ToInt32(dt.Rows[0]["last_insert_rowid()"].ToString()); entity.id = id; return(entity); }
/* * 获取文件夹 */ public StorageFileFolder get(int id) { String sql = "select * from storageFileFolder where id=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int32, 4) }; parameters[0].Value = id; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); if (dt == null || dt.Rows.Count == 0) { return(null); } StorageFileFolder storageFileFolder = DataToEntity <StorageFileFolder> .FillModel(dt.Rows[0]); return(storageFileFolder); }
/* * 更新 */ public int update(StorageFileFolder entity) { string sql = "update storageFileFolder set name=@name,parentId=@parentId,idx=@idx" + " where id=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@name", DbType.String, 100), new SQLiteParameter("@parentId", DbType.Int32, 4), new SQLiteParameter("@idx", DbType.Int32, 4), new SQLiteParameter("@id", DbType.Int32, 4) }; parameters[0].Value = entity.name; parameters[1].Value = entity.parentId; parameters[2].Value = entity.idx; parameters[3].Value = entity.id; int result = Common.SQLiteHelper.ExecuteNonQuery(sql, parameters); return(result); }
/* * 保存数据 */ private void Button_Click(object sender, RoutedEventArgs e) { StorageFileFolder storageFileFolder = storageFileFolderBll.get(thatFolderId); storageFileFolder.name = foldername.Text; if (string.IsNullOrWhiteSpace(storageFileFolder.name)) { MessageBox.Show("请填写文件夹名称"); return; } //Boolean b = storageFileFolderBll.hasSameName(storageFileFolder); //if (b) //{ // MessageBox.Show("文件夹名称重复,请更换"); // return; //} storageFileFolder = storageFileFolderBll.update(storageFileFolder); updateToTree(pageTreeColumn, storageFileFolder); Close(); }
private void Submit_Button_Click(object sender, RoutedEventArgs e) { StorageFileFolder tmp = new StorageFileFolder(); tmp.name = pagename.Text; tmp.parentId = parentId; if (string.IsNullOrWhiteSpace(tmp.name)) { MessageBox.Show("请填写页面名称"); return; } else if (tmp.parentId == 0) { MessageBox.Show("父页面不存在,请重试"); return; } tmp = storageFileFolderBll.insertChild(tmp); insertToTree(folderTreeColumn, tmp); Close(); }
/* * 将新添加的页面加入到页面树中 */ private void insertToTree(ItemsControl itemsControl, StorageFileFolder folder) { foreach (TreeViewItem item in itemsControl.Items) { Int32 folderId = (Int32)item.Tag; if (parentId == folderId) { TreeViewItem newItem = new TreeViewItem(); newItem.Header = folder.name; newItem.Tag = folder.id; newItem.Padding = new Thickness(5); // newItem.Foreground = Brushes.White; item.Items.Add(newItem); newItem.BringIntoView(); break; } else { insertToTree(item, folder); } } }
/* * 是否存在同名文件夹 */ public bool hasSameName(StorageFileFolder storageFileFolder) { int rows = storageFileFolderDal.hasSameName(storageFileFolder); return(rows > 0 ? true : false); }
/* * 更新 */ public StorageFileFolder update(StorageFileFolder storageFileFolder) { int rows = storageFileFolderDal.update(storageFileFolder); return(storageFileFolder); }