private void LoadDrawingList()
{
ListViewItem li;
SqlDataReader dr;
int leadID;
lvwLogs.Sorting = System.Windows.Forms.SortOrder.Ascending;
dr = CBDrawingLog.GetListByDeptProj(miCurrDept, miCurrProj, cboWBS.Text, 1, true);
lvwLogs.Items.Clear();
leadID = 0;
while (dr.Read())
{
li = new ListViewItem();
li.Text = dr["ID"].ToString();
leadID = Convert.ToInt32(dr["ProjectLeadID"]);
li.SubItems.Add(dr["HGANumber"].ToString());
li.SubItems.Add(dr["CADNumber"].ToString());
li.SubItems.Add(dr["WBS"].ToString());
lvwLogs.Items.Add(li);
}
dr.Close();
CBEmployee emp = new CBEmployee();
emp.Load(leadID);
miCurrLead = leadID;
txtProjectLead.Text = emp.Name;
bttProjectLead.Enabled = false;
sbStatus1.Text = lvwLogs.Items.Count.ToString() + " Drawing(s)";
SortDrawingList sorter = new SortDrawingList();
sorter.SortColumnNumber = 1;
sorter.SortColumnAsc = true;
lvwLogs.ListViewItemSorter = sorter;
lvwLogs.Sort();
miLastSortCol = 1;
mbSortColAsc = true;
if (lvwLogs.Items.Count > 0)
{
lvwLogs.Focus();
lvwLogs.Items[0].Selected = true;
}
}
private void lvwLogs_ColumnClick(object sender, ColumnClickEventArgs e)
{
SortDrawingList sorter = new SortDrawingList();
if (miLastSortCol < 1)
{
mbSortColAsc = true;
}
else if (miLastSortCol == 2)
{
if (e.Column != 2)
{
mbSortColAsc = true;
}
else
{
if (mbSortColAsc == true)
{
mbSortColAsc = false;
}
else
{
mbSortColAsc = true;
}
}
}
else
{
if (e.Column != 1)
{
mbSortColAsc = true;
}
else
{
if (mbSortColAsc == true)
{
mbSortColAsc = false;
}
else
{
mbSortColAsc = true;
}
}
}
sorter.SortColumnNumber = e.Column;
sorter.SortColumnAsc = mbSortColAsc;
lvwLogs.ListViewItemSorter = sorter;
lvwLogs.Sort();
miLastSortCol = e.Column;
}
