private void LoadProjects()
{
SqlDataReader dr;
ListViewItem lvi;
this.Cursor = Cursors.WaitCursor;
//SSS 20131105 dr = CBProject.GetList();
dr = CBProject.GetListProj();
lvwProjects.Items.Clear();
while (dr.Read())
{
lvi = new ListViewItem();
lvi.Text = dr["ID"].ToString();
lvi.SubItems.Add(dr["Number"].ToString());
lvi.SubItems.Add(dr["Description"].ToString());
lvwProjects.Items.Add(lvi);
}
dr.Close();
dr = null;
this.Cursor = Cursors.Default;
}
private void LoadProjects()
{
SqlDataReader dr;
RSLib.COListItem li;
//SSS 20131105 dr = CBProject.GetList();
dr = CBProject.GetListProj();
clstProjects.Items.Clear();
li = new RSLib.COListItem();
li.ID = 0;
li.Description = "All";
clstProjects.Items.Add(li);
while (dr.Read())
{
li = new RSLib.COListItem();
li.ID = Convert.ToInt32(dr["ID"]);
li.Description = dr["Number"].ToString();
clstProjects.Items.Add(li);
}
clstProjects.SetItemChecked(0, true);
dr.Close();
}
private void LoadItemList()
{
SqlDataReader dr;
ListViewItem lvi;
this.Cursor = Cursors.WaitCursor;
//SSS 20131105 dr = CBProject.GetList();
dr = CBProject.GetListProj();
lvwItems.Items.Clear();
while (dr.Read())
{
lvi = new ListViewItem();
lvi.Text = dr["ID"].ToString();
lvi.SubItems.Add(dr["Number"].ToString());
lvi.SubItems.Add(dr["Description"].ToString());
lvi.SubItems.Add(dr["Customer"].ToString());
lvi.SubItems.Add(dr["Location"].ToString());
lvwItems.Items.Add(lvi);
}
lvwItems.ColumnClick += new ColumnClickEventHandler(lvwItems_ColumnClick);
dr.Close();
dr = null;
sbPanStatus.Text = lvwItems.Items.Count.ToString() + " project(s)";
this.Cursor = Cursors.Default;
}
