public Logs()
{
InitializeComponent();
SetListviewBorder();
StartTime = Insert2DataBase.DateTimeToStamp(dateTimePicker1.Value.ToShortDateString());
EndTime = Insert2DataBase.DateTimeToStamp(dateTimePicker2.Value.ToShortDateString());
InitCombox();
}
private void Datatable2ListView(DataTable dt)
{
listView1.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
string[] str = new string[] {
(i + 1).ToString(),
dt.Rows[i][0].ToString(),
dt.Rows[i][3].ToString(),
Insert2DataBase.StampToDateTime(dt.Rows[i][2].ToString()),
dt.Rows[i][1].ToString()
};
ListViewItem lit = new ListViewItem(str);
listView1.Items.Add(lit);
}
}
private void button2_Click(object sender, EventArgs e)
{
if (MessageBox.Show("是否确认删除? 注意!删除后将无法恢复!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
if (listView1.CheckedItems.Count > 0)
{
foreach (ListViewItem LVI in listView1.CheckedItems)
{
string strCMD = "delete from Logs_Data where CTime = " + Insert2DataBase.DateTimeToStamp(LVI.SubItems[3].Text) + "";
helper.Oledbcommand(strCMD);
}
}
//-------------------------------------------
listView1.Items.Clear();
InitData();
}
private void dateTimePicker2_ValueChanged(object sender, EventArgs e)
{
EndTime = Insert2DataBase.DateTimeToStamp(dateTimePicker2.Value.ToShortDateString());
InitData();
}
