/// <summary> /// 创建工作路径 /// </summary> private void Setwork_directory() { int CaseNum = 0; string dbPath = "Data Source =" + Application.StartupPath + "\\Db\\CaseMsg.db"; g_conn = new SQLiteConnection(dbPath); g_conn.Open(); SQLiteCommand comm = g_conn.CreateCommand(); comm.CommandText = "select count (*) from CaseInfor"; SQLiteDataReader sr = comm.ExecuteReader(); while (sr.Read()) { CaseNum = int.Parse(sr[0].ToString()); //Console.WriteLine(iport); Console.WriteLine(sr[0]); Console.WriteLine("一共有多少条数据"); } // sr.Close(); if (CaseNum <= 0) { WorkDirectoryForm directoryForm = new WorkDirectoryForm(); directoryForm.Show(); Program.m_mainform.g_workPath = directoryForm.WorDIrectoryTexbox.ToString(); } else { //g_conn.Open(); Console.WriteLine("开始设置工作路径"); SQLiteCommand com = g_conn.CreateCommand(); com.CommandText = "select Path, CaseName, Max(CaseId) from CaseInfor"; SQLiteDataReader sr1 = com.ExecuteReader(); while (sr1.Read()) { Program.m_mainform.g_workPath = sr1[0].ToString(); Console.WriteLine(sr1[0].ToString()); Program.m_mainform.g_workPath = Program.m_mainform.g_workPath.Substring(0, g_workPath.LastIndexOf(@"\")); Console.WriteLine(Program.m_mainform.g_workPath); Console.Read(); } } if (!Directory.Exists(g_workPath)) { MessageBoxButtons messBtn = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("\t'" + Program.m_mainform.g_workPath + "'工作路径不存在,是否创建?\n\t或点击取消设置新的工作路径", "提示:确认", messBtn); if (dr == DialogResult.OK) { Directory.CreateDirectory(Program.m_mainform.g_workPath); //创建工作路径 return; } else { return; } } }
/// <summary> /// 弹窗设置工作路径 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnSet_Click(object sender, EventArgs e) { WorkDirectoryForm directoryForm = new WorkDirectoryForm(); directoryForm.Show(); if (g_workPath != "") { directoryForm.WorDIrectoryTexbox.Text = g_workPath; } }