/// <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;
}
}
