private void ListViewShow(TreeNode NodeDir)//初始化ListView控制元件，把TrreView控制元件中的資料新增進來
{
ListViewFile.Clear();
if (NodeDir.Parent == null) // 如果目前TreeView的父結點為空，就把我的電腦下的分區名稱新增進來
{
foreach (string DrvName in Directory.GetLogicalDrives()) //取得硬盤分區名
{
ListViewItem ItemList = new ListViewItem(DrvName);
ListViewFile.Items.Add(ItemList);//新增進來
}
}
else//如果目前TreeView的父結點不為空，把點擊的結點，做為一個目錄文件的總結點
{
foreach (string DirName in Directory.GetDirectories((string)NodeDir.Tag))//編歷目前分區或文件夾所有目錄
{
ListViewItem ItemList = new ListViewItem(DirName);
ListViewFile.Items.Add(ItemList);
}
foreach (string FileName in Directory.GetFiles((string)NodeDir.Tag))//編歷目前分區或文件夾所有目錄的文件
{
ListViewItem ItemList = new ListViewItem(FileName);
ListViewFile.Items.Add(ItemList);
}
}
}
private void Machine_FilePositionChanged()
{
RunFilePosition.Text = machine.FilePosition.ToString();
if (ListViewFile.SelectedItem is TextBlock)
{
if (ListViewFile.SelectedIndex >= 0 && ListViewFile.SelectedIndex < machine.File.Count && machine.PauseLines[ListViewFile.SelectedIndex])
{
((TextBlock)ListViewFile.SelectedItem).Background = Brushes.YellowGreen;
}
else
{
((TextBlock)ListViewFile.SelectedItem).Background = Brushes.Transparent;
}
}
ListViewFile.SelectedIndex = machine.FilePosition;
if (ListViewFile.SelectedItem is TextBlock)
{
((TextBlock)ListViewFile.SelectedItem).Background = Brushes.Gray;
}
ListViewFile.ScrollIntoView(ListViewFile.SelectedItem);
}
//
private void ListViewShow(TreeNode NodeDir)//初始化ListView控件，把TreeView控件中的数据添加进来
{
ListViewFile.Clear();
if (NodeDir.Parent == null)// 如果当前TreeView的父结点为空，就把我的电脑下的分区名称添加进来
{
foreach (string DrvName in Directory.GetLogicalDrives())//获得硬盘分区名
{
ListViewItem ItemList = new ListViewItem(DrvName);
ListViewFile.Items.Add(ItemList);//添加进来
}
}
else//如果当前TreeView的父结点不为空，把点击的结点，做为一个目录文件的总结点
{
foreach (string DirName in Directory.GetDirectories((string)NodeDir.Tag))//编历当前分区或文件夹所有目录
{
ListViewItem ItemList = new ListViewItem(DirName);
ListViewFile.Items.Add(ItemList);
}
foreach (string FileName in Directory.GetFiles((string)NodeDir.Tag))//编历当前分区或文件夹所有目录的文件
{
ListViewItem ItemList = new ListViewItem(FileName);
ListViewFile.Items.Add(ItemList);
}
}
}
//显示被点击的列表文件的子目录
private void ListViewShow(string DirFileName)//获取当有文件夹内的文件和目录
{
try
{
//判断是否有访问权限，如果发生异常则是无法访问，执行catch块程序
Boolean authority = HasOperationPermission(DirFileName);
}
catch
{
MessageBox.Show("无法访问路径:" + DirFileName);
return;
}
//如果DirFileName是文件夹
if (Directory.Exists(DirFileName))
{
ListViewFile.Clear();
foreach (string DirName in Directory.GetDirectories(DirFileName))
{
simpleFileName = getSimpleFileName(DirFileName, DirName);
ListViewItem ItemList = new ListViewItem(simpleFileName);
ListViewFile.Items.Add(ItemList);
}
foreach (string FileName in Directory.GetFiles(DirFileName))
{
simpleFileName = getSimpleFileName(DirFileName, FileName);
ListViewItem ItemList = new ListViewItem(simpleFileName);
ListViewFile.Items.Add(ItemList);
}
}
//否则如果是文件
else if (File.Exists(DirFileName))
{
System.Diagnostics.Process.Start(DirFileName);
}
}
private void ListViewShow(string DirFileName)//获取当有文件夹内的文件和目录
{
ListViewFile.Clear();
foreach (string DirName in Directory.GetDirectories(DirFileName))
{
ListViewItem ItemList = new ListViewItem(DirName);
ListViewFile.Items.Add(ItemList);
}
foreach (string FileName in Directory.GetFiles(DirFileName))
{
ListViewItem ItemList = new ListViewItem(FileName);
ListViewFile.Items.Add(ItemList);
}
}
private void ListViewShow(string DirFileName) //取得當有文件夾內的文件和目錄
{
ListViewFile.Clear(); //清空控制元件內容
foreach (string DirName in Directory.GetDirectories(DirFileName))
{
ListViewItem ItemList = //建立控制元件項
new ListViewItem(DirName);
ListViewFile.Items.Add(ItemList); //向控制元件新增項
}
foreach (string FileName in Directory.GetFiles(DirFileName))
{
ListViewItem ItemList = //建立控制元件項
new ListViewItem(FileName);
ListViewFile.Items.Add(ItemList); //向控制元件新增項
}
}
public Int64 InsertTableTaskList(string filename, string name, Int32 minute)
{
ListViewFile lvf = new ListViewFile();
lvf.CreateDate = new DateTime(2018, 1, 1, 9, 0, 0, DateTimeKind.Utc).ToString("yyyy-MM-dd HH:mm:ss"); //dummy
lvf.Description = "description";
lvf.DueDate = new DateTime(2019, 1, 1, 9, minute, 0, DateTimeKind.Utc).ToString("yyyy-MM-dd HH:mm:ss");
lvf.Id = 0; //dummy
lvf.Memo = "memo";
lvf.Name = name;
lvf.Priority = "";
lvf.Status = "Active";
lvf.WorkHolder = Path.GetTempPath();
string path = Path.GetTempPath() + "\\" + filename;
return(SQLiteClass.ExecuteInsertTable(path, lvf));
}
private void Machine_FilePositionChanged()
{
LabelFilePosition.Content = machine.FilePosition;
if (ListViewFile.SelectedItem is TextBlock)
{
((TextBlock)ListViewFile.SelectedItem).Background = Brushes.Transparent;
}
ListViewFile.SelectedIndex = machine.FilePosition;
if (ListViewFile.SelectedItem is TextBlock)
{
((TextBlock)ListViewFile.SelectedItem).Background = Brushes.Gray;
}
ListViewFile.ScrollIntoView(ListViewFile.SelectedItem);
}
private void ListViewShow(string DirName)
{
ListViewFile.Clear();
try
{
foreach (string dirName in Directory.GetDirectories(DirName))
{
ListViewItem listItem = new ListViewItem(dirName);
ListViewFile.Items.Add(listItem);
}
foreach (string FileName in Directory.GetFiles(DirName))
{
ListViewItem ItemList = new ListViewItem(FileName);
ListViewFile.Items.Add(ItemList);
}
}
catch { }
}
//显示被点击树节点的文件列表
private void ListViewShow(TreeNode NodeDir)//初始化ListView控件，把TrreView控件中的数据添加进来
{
ListViewFile.Clear();
if (NodeDir.Parent == null) // 如果当前TreeView的父结点为空，就把我的电脑下的分区名称添加进来
{
foreach (string DrvName in Directory.GetLogicalDrives()) //获得硬盘分区名
{
ListViewItem ItemList = new ListViewItem(DrvName);
ListViewFile.Items.Add(ItemList);//添加进来
}
}
//如果DirFileName是文件夹
else if (Directory.Exists((string)NodeDir.Tag))//如果当前TreeView的父结点不为空，把点击的结点，做为一个目录文件的总结点
{
try
{
//判断是否有访问权限，如果发生异常则是无法访问，执行catch块程序
Boolean authority = HasOperationPermission((string)NodeDir.Tag);
}
catch
{
MessageBox.Show("无法访问路径:" + (string)NodeDir.Tag);
return;
}
curPath = (string)NodeDir.Tag;
foreach (string DirName in Directory.GetDirectories(curPath))//编历当前分区或文件夹所有目录
{
simpleFileName = getSimpleFileName(curPath, DirName);
ListViewItem ItemList = new ListViewItem(simpleFileName);
ListViewFile.Items.Add(ItemList);
}
foreach (string FileName in Directory.GetFiles(curPath))//编历当前分区或文件夹所有目录的文件
{
simpleFileName = getSimpleFileName(curPath, FileName);
ListViewItem ItemList = new ListViewItem(simpleFileName);
ListViewFile.Items.Add(ItemList);
}
}
}
public void ExecuteUpdateTableTest()
{
string dbfile = "taskaludb12.sqlite";
string path = Path.GetTempPath() + "\\" + dbfile;
CreateSQLiteDBFlie(dbfile);
CreateTableTaskList(dbfile);
InsertTableTaskList(dbfile, "hoge", 0);
ListViewFile lvf = new ListViewFile();
lvf.CreateDate = new DateTime(2018, 1, 1, 9, 0, 0, DateTimeKind.Utc).ToString("yyyy-MM-dd HH:mm:ss"); //dummy
lvf.Description = "description2";
lvf.DueDate = new DateTime(2019, 1, 1, 9, 1, 0, DateTimeKind.Utc).ToString("yyyy-MM-dd HH:mm:ss");
lvf.Id = 0; //dummy
lvf.Memo = "memo2";
lvf.Name = "name2";
lvf.Priority = "";
lvf.Status = "Active";
lvf.WorkHolder = Path.GetTempPath();
Debug.Assert(SQLiteClass.ExecuteUpdateTable(path, lvf));
}
