public void Initialize(string _ProjectName, string _ProjectType)
{
ProjectName = _ProjectName;
ProjectType = _ProjectType;
if (ProjectType == "DISPENSER")
{
ScreenshotIndex = 4;
}
else
{
ScreenshotIndex = 4;
}
DateTime TimeNow = DateTime.Now;
SelectDateFrom = String.Format("{0:D4}-{1:D2}-{2:D2}", TimeNow.Year, TimeNow.Month, TimeNow.Day);
SelectDateTo = String.Format("{0:D4}-{1:D2}-{2:D2}", TimeNow.Year, TimeNow.Month, TimeNow.Day);
monthCalendarFrom.SetDate(TimeNow);
monthCalendarTo.SetDate(TimeNow);
HistoryToolTip.SetToolTip(btnSelectView, "View selected period");
HistoryToolTip.SetToolTip(btnAllview, "View all");
HistoryToolTip.SetToolTip(btnSelectDelete, "Delete selected Period");
HistoryToolTip.SetToolTip(btnAllDelete, "Delete All");
SqliteManager.SetHistoryFolderPath(ProjectName);
}
//LDH, 2019.06.28, DB에서 특정 Column에 있는 데이터 유형 찾기
private List <string> SearchColumnName(string _ColumnName)
{
List <string> _GetDataList = new List <string>();
SqliteManager.SqlDistinct(ref _GetDataList, _ColumnName);
return(_GetDataList);
}
public bool CheckDBFile()
{
if (SqliteManager.CheckDirectory() == null)
{
MessageBox.Show(new Form {
TopMost = true
}, "DB File not found."); return(false);
}
else
{
return(true);
}
}
private void SetSearchCondition()
{
if (ckbRecipe.Checked == true)
{
List <string> RecipeList = new List <string>();
for (int iLoopCount = 0; iLoopCount < Recipecount; iLoopCount++)
{
if (ckListBoxRecipe.GetItemChecked(iLoopCount))
{
RecipeList.Add(ckListBoxRecipe.Items[iLoopCount].ToString());
}
}
SqliteManager.SqlSetSearchCondition(ckbRecipe.Text, ckbRecipe.Checked, RecipeList);
}
else
{
SqliteManager.SqlSetSearchConditionClear(ckbRecipe.Text, false);
}
if (ckbResult.Checked == true)
{
List <string> NGResultList = new List <string>();
NGResultList.Add(comboBoxResult.Text);
SqliteManager.SqlSetSearchCondition(ckbResult.Text, ckbResult.Checked, NGResultList);
}
else
{
SqliteManager.SqlSetSearchConditionClear(ckbResult.Text, false);
}
if (ckbNGType.Checked == true)
{
List <string> NGTypeList = new List <string>();
for (int iLoopCount = 0; iLoopCount < ckListBoxNGType.Items.Count; iLoopCount++)
{
if (ckListBoxNGType.GetItemChecked(iLoopCount))
{
NGTypeList.Add(ckListBoxNGType.Items[iLoopCount].ToString());
}
}
SqliteManager.SqlSetSearchCondition("NGType", ckbNGType.Checked, NGTypeList);
}
else
{
SqliteManager.SqlSetSearchConditionClear("NGType", false);
}
GC.Collect();
}
public void SetDataGridViewHistory(bool SelectDate, string SelectSQL, string SelectedDateFrom = null, string SelectedDateTo = null)
{
ClearDataGridViewHistory();
SetSearchCondition();
switch (SelectSQL)
{
case "Open": dataGridViewHistory.DataSource = SqliteManager.SqlOpen(SelectDate, SelectedDateFrom, SelectedDateTo).Tables[0]; break;
case "Delete": dataGridViewHistory.DataSource = SqliteManager.SqlDelete(SelectDate, SelectedDateFrom, SelectedDateTo).Tables[0]; break;
}
dataGridViewHistory.Refresh();
//GridViewInitialize();
}
//LDH, 2016.12.13 Inspection ScreenShot 삭제
private void DeleteScreenShot(bool _DeleteAll)
{
string ScreenShotpath;
ScreenShotpath = SqliteManager.SqlGetScreenshotPath();
if (ScreenShotpath == null)
{
MessageBox.Show(new Form {
TopMost = true
}, "History File is not found."); return;
}
char Character = '\\';
string[] SplitFolderName = ScreenShotpath.Split(Character);
int FolderLength = SplitFolderName.Length;
string RemoveFolderPath = "";
string DeleteFolder;
int YearIndex = 0;
for (int iLoopCount = 0; iLoopCount < 5; iLoopCount++)
{
//폴더 경로내에 최근 5년 까지의 폴더이름이 있는지 체크
YearIndex = Array.IndexOf(SplitFolderName, (DateTime.Now.Year - iLoopCount).ToString());
if (YearIndex != -1)
{
break;
}
}
//TrimForm 부터 아래 코드로 변경
//RemoveFolderPath = String.Format(@"\{0}\{1}\{2}\{3}", SplitFolderName[FolderLength - 4], SplitFolderName[FolderLength - 3], SplitFolderName[FolderLength - 2], SplitFolderName[FolderLength - 1]);
for (int jLoopCount = YearIndex; jLoopCount < SplitFolderName.Length; jLoopCount++)
{
RemoveFolderPath = RemoveFolderPath + "\\" + SplitFolderName[jLoopCount];
}
ScreenShotpath = ScreenShotpath.Replace(RemoveFolderPath, "");
//Year 폴더 삭제
DirectoryInfo DeleteYearFolderInfo = new DirectoryInfo(ScreenShotpath);
if (DeleteYearFolderInfo.Exists)
{
DirectoryInfo[] YearFolderInfo = DeleteYearFolderInfo.GetDirectories();
foreach (DirectoryInfo YearFolder in YearFolderInfo)
{
if (_DeleteAll)
{
if (Convert.ToInt32(YearFolder.Name) <= Convert.ToInt32(DateTime.Now.Year))
{
DeleteFolder = String.Format("{0}\\{1}", ScreenShotpath, YearFolder.Name);
Directory.Delete(DeleteFolder, true);
}
}
else
{
if (Convert.ToInt32(YearFolder.Name) < Convert.ToInt32(SplitFolderName[YearIndex]))
{
DeleteFolder = String.Format("{0}\\{1}", ScreenShotpath, YearFolder.Name);
Directory.Delete(DeleteFolder, true);
}
}
}
DeleteYearFolderInfo.Refresh();
}
//Month 폴더 삭제
ScreenShotpath = String.Format("{0}\\{1}", ScreenShotpath, SplitFolderName[YearIndex]);
DirectoryInfo DeleteMonthFolderInfo = new DirectoryInfo(ScreenShotpath);
if (DeleteMonthFolderInfo.Exists)
{
DirectoryInfo[] MonthFolderInfo = DeleteMonthFolderInfo.GetDirectories();
foreach (DirectoryInfo MonthFolder in MonthFolderInfo)
{
if (Convert.ToInt32(MonthFolder.Name) < Convert.ToInt32(SplitFolderName[YearIndex + 1]))
{
DeleteFolder = String.Format("{0}\\{1}", ScreenShotpath, MonthFolder.Name);
Directory.Delete(DeleteFolder, true);
}
}
DeleteMonthFolderInfo.Refresh();
}
//Day 폴더 삭제
ScreenShotpath = String.Format("{0}\\{1}", ScreenShotpath, SplitFolderName[YearIndex + 1]);
DirectoryInfo DeleteDayFolderInfo = new DirectoryInfo(ScreenShotpath);
if (DeleteDayFolderInfo.Exists)
{
DirectoryInfo[] DayFolderInfo = DeleteDayFolderInfo.GetDirectories();
foreach (DirectoryInfo DayFolder in DayFolderInfo)
{
if (Convert.ToInt32(DayFolder.Name) < Convert.ToInt32(SplitFolderName[YearIndex + 2]))
{
DeleteFolder = String.Format("{0}\\{1}", ScreenShotpath, DayFolder.Name);
Directory.Delete(DeleteFolder, true);
}
}
DeleteDayFolderInfo.Refresh();
}
}
//LDH, 2016.12.13 Inspection ScreenShot 삭제
private void DeleteScreenShot()
{
string ScreenShotpath;
ScreenShotpath = SqliteManager.SqlGetScreenshotPath();
if (ScreenShotpath == null)
{
MessageBox.Show(new Form {
TopMost = true
}, "History File is not found."); return;
}
char Character = '\\';
string[] SplitFolderName = ScreenShotpath.Split(Character);
int FolderLength = SplitFolderName.Length;
string RemoveFolderPath;
string DeleteFolder;
RemoveFolderPath = String.Format(@"\{0}\{1}\{2}\{3}", SplitFolderName[FolderLength - 4], SplitFolderName[FolderLength - 3], SplitFolderName[FolderLength - 2], SplitFolderName[FolderLength - 1]);
ScreenShotpath = ScreenShotpath.Replace(RemoveFolderPath, "");
//Year 폴더 삭제
DirectoryInfo DeleteYearFolderInfo = new DirectoryInfo(ScreenShotpath);
if (DeleteYearFolderInfo.Exists)
{
DirectoryInfo[] YearFolderInfo = DeleteYearFolderInfo.GetDirectories();
foreach (DirectoryInfo YearFolder in YearFolderInfo)
{
if (Convert.ToInt32(YearFolder.Name) < Convert.ToInt32(SplitFolderName[FolderLength - 4]))
{
DeleteFolder = String.Format("{0}\\{1}", ScreenShotpath, YearFolder.Name);
Directory.Delete(DeleteFolder, true);
}
}
}
//Month 폴더 삭제
ScreenShotpath = String.Format("{0}\\{1}", ScreenShotpath, SplitFolderName[FolderLength - 4]);
DirectoryInfo DeleteMonthFolderInfo = new DirectoryInfo(ScreenShotpath);
if (DeleteMonthFolderInfo.Exists)
{
DirectoryInfo[] MonthFolderInfo = DeleteMonthFolderInfo.GetDirectories();
foreach (DirectoryInfo MonthFolder in MonthFolderInfo)
{
if (Convert.ToInt32(MonthFolder.Name) < Convert.ToInt32(SplitFolderName[FolderLength - 3]))
{
DeleteFolder = String.Format("{0}\\{1}", ScreenShotpath, MonthFolder.Name);
Directory.Delete(DeleteFolder, true);
}
}
}
//Day 폴더 삭제
ScreenShotpath = String.Format("{0}\\{1}", ScreenShotpath, SplitFolderName[FolderLength - 2]);
DirectoryInfo DeleteDayFolderInfo = new DirectoryInfo(ScreenShotpath);
if (DeleteDayFolderInfo.Exists)
{
DirectoryInfo[] DayFolderInfo = DeleteDayFolderInfo.GetDirectories();
foreach (DirectoryInfo DayFolder in DayFolderInfo)
{
if (Convert.ToInt32(DayFolder.Name) < Convert.ToInt32(SplitFolderName[FolderLength - 1]))
{
DeleteFolder = String.Format("{0}\\{1}", ScreenShotpath, DayFolder.Name);
Directory.Delete(DeleteFolder, true);
}
}
}
}
/// <summary>
/// Error 코드를 저장
/// </summary>
/// <param name="strKey"></param>
/// <param name="strErrLevel"></param>
/// <param name="strErrMsg"></param>
/// <returns></returns>
public static int HistoryInsertQuery(string HistoryItem, bool _CreateTable, string _CreateComm = "")
{
return(SqliteManager.SqlExecute(HistoryItem, _CreateTable, _CreateComm));
}
