Exemplo n.º 1
0
        private void txt_barcode_TextChanged(object sender, EventArgs e)
        {
            int count = 0;
            int tubeIntId = 0;
            foreach (char c in txt_barcode.Text)
            {
                count++;
            }

            if (count == 9)
            {
                try
                {
                    tubeIntId = Convert.ToInt32(txt_barcode.Text.Substring(3));
                }
                catch (Exception E)
                {

                }

                string q = "SELECT t_brand AS Brand, t_size AS Size, t_amps AS Make, t_type AS Tube_Type, t_qty AS Qty, t_prize AS Price FROM tube_add WHERE t_stok_id = '" + tubeIntId + "'";
                DataSet ds_tube = middle_access.db_access.SelectData(q);
                if (ds_tube != null)
                {
                    DataRow dr_tube = ds_tube.Tables[0].Rows[0];

                    tube_category_data.brand = dr_tube.ItemArray.GetValue(0).ToString();
                    tube_category_data.size = dr_tube.ItemArray.GetValue(1).ToString();
                    // tube_category_data.voltage = voltage;
                    tube_category_data.amps = dr_tube.ItemArray.GetValue(2).ToString();
                    tube_category_data.type = dr_tube.ItemArray.GetValue(3).ToString();
                    tube_category_data.qty = dr_tube.ItemArray.GetValue(4).ToString();
                    tube_category_data.price = dr_tube.ItemArray.GetValue(5).ToString();

                    this.Enabled = false;
                    tube_qty q1 = new tube_qty();
                    q1.MdiParent = DHNAULA.ActiveForm;
                    q1.Visible = true;
                }
                else
                {
                    MessageBox.Show("No shuch a tube in the database!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    txt_barcode.Clear();
                }
                txt_barcode.Clear();
            }
        }
Exemplo n.º 2
0
        private void grdTubesearch_CellClick(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e)
        {
            int val = e.RowIndex;
            int r_count = grdTubesearch.RowCount;
            if (val >= 0)
            {
                string brand = grdTubesearch.Rows[e.RowIndex].Cells[0].Value.ToString();
                string size = grdTubesearch.Rows[e.RowIndex].Cells[1].Value.ToString();
                string amp = grdTubesearch.Rows[e.RowIndex].Cells[2].Value.ToString();
                string type = grdTubesearch.Rows[e.RowIndex].Cells[3].Value.ToString();

                tube_category_data.brand = brand;
                tube_category_data.size = size;
                tube_category_data.amps = amp;
                tube_category_data.type = type;
                tube_category_data.qty = grdTubesearch.Rows[e.RowIndex].Cells[4].Value.ToString();
                tube_category_data.price = grdTubesearch.Rows[e.RowIndex].Cells[5].Value.ToString();

                this.Enabled = false;
                tube_qty q = new tube_qty();
                q.MdiParent = DHNAULA.ActiveForm;
                q.Visible = true;
            }
        }