private void btnItemDown_Click(object sender, EventArgs e) { Int32 i = lstDocTypes.SelectedIndex; if (i < lstDocTypes.Items.Count - 1) { CheckedListBoxItem docType = (CheckedListBoxItem)lstDocTypes.Items[i]; lstDocTypes.Items.RemoveAt(i); lstDocTypes.Items.Insert(i + 1, docType); lstDocTypes.SelectedIndex = i + 1; } else { lstDocTypes.SelectedIndex = i; } }
private void connectToolStripMenuItem_Click(object sender, EventArgs e) { Connect connForm = Connect.GetChildInstance(); if (connForm.ShowDialog(this) == DialogResult.OK) { this.DocListChkLst.Items.Clear(); this.connector = new OBConnection(connForm.ConnName, connForm.ConnString); this.ConnStatusLbl.Text = "Connection Name: " + connForm.ConnName; String queryString = "select itemtypenum, trim(itemtypename) from hsi.doctype where itemtypenum in (select itemtypenum from hsi.scanqueuexit) and itemtypegroupnum > 100 order by itemtypename"; Type[] typeAr = { Type.GetType("System.Int32"), Type.GetType("System.String") }; System.Data.DataSet DocumentTypes = this.connector.Query(queryString, typeAr); System.Data.DataTable DocTypeTable = DocumentTypes.Tables[0]; for (Int32 x = 0; x < DocTypeTable.Rows.Count; x++) { CheckedListBoxItem clbItem = new CheckedListBoxItem((System.String)DocTypeTable.Rows[x][1], System.Decimal.ToInt32((System.Decimal)DocTypeTable.Rows[x][0])); DocListChkLst.Items.Add(clbItem); } } }
private void connectToolStripMenuItem_Click(object sender, EventArgs e) { Connect connForm = Connect.GetChildInstance(); if (connForm.ShowDialog(this) == DialogResult.OK) { this.DocListChkLst.Items.Clear(); this.connector = new OBConnection(connForm.ConnName, connForm.ConnString); this.ConnStatusLbl.Text = "Connection Name: " + connForm.ConnName; String queryString = "select itemtypenum, trim(itemtypename) from hsi.doctype where itemtypenum in (select itemtypenum from hsi.scanqueuexit) and itemtypegroupnum > 100 order by itemtypename"; Type[] typeAr = { Type.GetType("System.Int32"), Type.GetType("System.String") }; System.Data.DataSet DocumentTypes = this.connector.Query(queryString, typeAr); System.Data.DataTable DocTypeTable = DocumentTypes.Tables[0]; for (Int32 x = 0; x < DocTypeTable.Rows.Count; x++) { CheckedListBoxItem clbItem = new CheckedListBoxItem((System.String)DocTypeTable.Rows[x][1], System.Decimal.ToInt32((System.Decimal)DocTypeTable.Rows[x][0])); DocListChkLst.Items.Add(clbItem); } } }