private void dataGridView1_CelltClick(object sender, DataGridViewCellEventArgs e) { try { string id = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); if (e.ColumnIndex == 7) { DialogResult dr = MessageBox.Show("คุณต้องการลบข้อมูลนี้หรือไม่ ?", "ลบข้อมุล", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { string query = "update verify set status ='DELETE' WHERE ver_id = @id"; MySqlCommand cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("@id", id); conn.Open(); try { cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); conn.Close(); this.RenderGrid(); MessageBox.Show("ลบข้อมูลเรียบร้อย"); } catch (Exception ex) { MessageBox.Show("เกิดข้อผิดพลาดในการลบข้อมูลเนื่องจาก : " + ex.Message); conn.Close(); } } } if (e.ColumnIndex == 6) { VerifyAdd da = new VerifyAdd(this); da.ID = id; da.Show(); } if (e.ColumnIndex == 8) { string[] data = new string[4]; data[0] = id; PrintView rw = new PrintView("print_quotation", data); rw.Show(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
private void dataGridView1_CelltClick(object sender, DataGridViewCellEventArgs e) { string id = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); if (e.ColumnIndex == 7) { PayAdd da = new PayAdd(this); da.ID = id; da.Show(); } if (e.ColumnIndex == 6) { string[] data = new string[4]; data[0] = id; PrintView rw = new PrintView("print_pay", data); rw.Show(); } }
private void button1_Click(object sender, EventArgs e) { dateTimePicker1.Text = DateTime.Now.ToString("yyyy-MM-dd"); long ln = DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond; string id = this.id; string query = "REPLACE INTO pay (pay_id,pay_date,ver_id,price)" + "VALUES(@id,NOW(),@ver_id,@price)"; MySqlCommand cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@ver_id", ver_id.Text); cmd.Parameters.AddWithValue("@price", hiddenval.Text); cmd.CommandText = query; conn.Open(); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); conn.Close(); string query1 = "update verify set status ='PAY' where ver_id=@id"; MySqlCommand cmd1 = new MySqlCommand(query1, conn); cmd1.Parameters.AddWithValue("@id", ver_id.Text); cmd1.CommandText = query1; conn.Open(); cmd1.ExecuteNonQuery(); cmd1.Parameters.Clear(); conn.Close(); MessageBox.Show("บันทึกข้อมูลเรียบร้อย"); string[] data = new string[4]; data[0] = id; PrintView rw = new PrintView("print_pay", data); rw.Show(); this.Close(); this.Form.RenderGrid(); }
private void button1_Click(object sender, EventArgs e) { string cusid = ""; if (cus_id.Text == "กรุณาเลือก") { MessageBox.Show("กรุณาเลือกลูกค้า"); } else { string selectOne = "SELECT * from customers WHERE fullname = @name LIMIT 1"; MySqlCommand cmd1 = new MySqlCommand(selectOne, conn); cmd1.Parameters.AddWithValue("@name", cus_id.Text); cmd1.CommandText = selectOne; conn.Open(); MySqlDataReader reader1 = cmd1.ExecuteReader(); while (reader1.Read()) { cusid = reader1.GetString("cus_id"); } conn.Close(); string id2 = ""; string query2 = "Select case when Max(substr(quo_id, -6)) + 1 is null then 'QUO-000001' else case when (Max(substr(quo_id, -6)) + 1) < 10 then CONCAT('QUO-00000',(Max(substr(quo_id, -6)) + 1)) else CONCAT('QUO-0000',(Max(substr(quo_id, -6)) + 1)) end end as MaxID from quotation"; MySqlCommand cmdQuery = new MySqlCommand(query2, conn); cmdQuery.CommandText = query2; conn.Open(); MySqlDataReader dr = cmdQuery.ExecuteReader(); while (dr.Read()) { id2 = dr.GetString("MaxID"); } conn.Close(); string query11 = "REPLACE INTO quotation (quo_id,quo_date,ver_id,price)" + "VALUES(@id,NOW(),@ver_id,@price)"; MySqlCommand cmd11 = new MySqlCommand(query11, conn); cmd11.Parameters.AddWithValue("@id", id2); cmd11.Parameters.AddWithValue("@price", this.hiddenval.Text); cmd11.Parameters.AddWithValue("@ver_id", ver_id.Text); cmd11.CommandText = query11; conn.Open(); cmd11.ExecuteNonQuery(); cmd11.Parameters.Clear(); conn.Close(); string query = "REPLACE INTO verify (ver_id,ver_date,status,all_price,veh_symtom,cus_id)" + "VALUES(@id,NOW(),'QUOTATION',@sumtotal,@veh_symtom,@cus_id)"; MySqlCommand cmd = new MySqlCommand(query, conn); //long ln = DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond; string id = this.id == "" ? null : this.id; cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@sumtotal", this.hiddenval.Text); //cmd.Parameters.AddWithValue("@veh_id", veh_id.Text); //cmd.Parameters.AddWithValue("@veh_type", veh_type.Text); cmd.Parameters.AddWithValue("@veh_symtom", veh_symtom.Text); cmd.Parameters.AddWithValue("@cus_id", cusid); cmd.CommandText = query; conn.Open(); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); conn.Close(); MessageBox.Show("บันทึกข้อมูลเรียบร้อย"); string[] data = new string[4]; data[0] = id2; PrintView rw = new PrintView("print_quotation", data); rw.Show(); this.Close(); this.Form.RenderGrid(); } }