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