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 LoadDrawingList(int sortColumn, bool sortAsc)
{
ListViewItem li;
SqlDataReader dr;
int leadID;
dr = CBDrawingLog.GetListByDeptProj(miCurrDept, miCurrProj, cboWBS.Text, sortColumn, sortAsc);
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)";
if (lvwLogs.Items.Count > 0)
{
lvwLogs.Focus();
lvwLogs.Items[0].Selected = true;
LoadSelectedItem(0);
}
}
