private void txt_mobile1_KeyPress(object sender, KeyPressEventArgs e) { db.isDigit(e); if (e.KeyChar == Convert.ToChar(Keys.Return)) { db.readData("Select cust_name from customer where cust_mobile = '" + txt_mobile1.Text + "'", txt_cust_name); db.readData("Select cust_company from customer where cust_mobile = '" + txt_mobile1.Text + "'", txt_comp_name); this.ActiveControl = txt_prod_id; enableIdata(); txt_mobile1.Enabled = false; } }
private void btn_inv_num_search_Click(object sender, EventArgs e) { if (txt_inv_mob.Text == "") { } else { db.readData("Select cust_company, cust_name, cust_mobile, cust_mobile2, cust_city from customer where cust_mobile = '" + txt_inv_mob.Text + "'", dataGridView1); db.readData("Select cust_company from customer where cust_mobile = '" + txt_inv_mob.Text + "'", txt_inv_company); //db.readData("Select cust_company from customer where cust_mobile = '" +txt_inv_mob.Text +"'",txt_cust_comp); //db.readData("Select cust_name from customer where cust_mobile1 = '" + txt_inv_mob.Text + "'", txt_cust_name); //db.readData("Select cust_mobile2 from customer where cust_mobile1 = '" + txt_inv_mob.Text + "'", txt_cust_mob2); } }
public Customer() { InitializeComponent(); simpleSoft.dbClass db = new dbClass(); db.readData("Select cust_code AS CODE, cust_name AS NAME, cust_company AS COMPANY, cust_city AS CITY, cust_mobile AS MOBILE1, cust_mobile2 AS MOBILE2, cust_office1 AS OFFICE,cust_fax AS FAX from customer", dataGridView1); btn_edited.Enabled = false; }
public addInvoice() { InitializeComponent(); dbClass db = new dbClass(); db.readData("Select MAX(inv_num) from invoice", txt_inv_number, 1); addIdataColumn(); disableforever(); disableIdata(); txt_temp.Hide(); }
public editInvoice() { InitializeComponent(); db.readData("Select MAX(inv_num) from invoice", txt_inv_number); txt_temp.Hide(); }