private void button1_Click(object sender, EventArgs e) { conn.Open(); try { int qty = Convert.ToInt32(lblcount.Text); int sub = qty + Convert.ToInt32(textBox1.Text); string query = ("UPDATE medical SET medi_qty = '" + sub + "' , medi_qty_use = '" + sub + "' WHERE medi_name = '" + lblmedi.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); clinic_pharmacist_ms doc1 = new clinic_pharmacist_ms(); doc1.Show(); clinic_pharmacist_ms clnlog = new clinic_pharmacist_ms(); clnlog.Close(); Visible = false; MessageBox.Show("อัพเดตข้อมูลเรียบร้อย"); } catch (Exception ex) { MessageBox.Show("มีข้อผิดพลาด"); } conn.Close(); }
private void button2_Click(object sender, EventArgs e) { conn.Open(); try { string namemedi = txtmedi.Text; int medi_no = Convert.ToInt32(txtmedino.Text); int medi_num = Convert.ToInt32(txtmedinum.Text); string unit_medi = txtmediunit.Text; double unit_price = Convert.ToDouble(txtpriceunit.Text); double price = Convert.ToDouble(txtprice.Text); string query = ("insert into medical (medi_name,medi_no,medi_qty_use,medi_qty,medi_unit,medi_price_unit,medi_price) values ('" + namemedi + "','" + medi_no + "','" + medi_num + "','" + medi_num + "','" + unit_medi + "','" + unit_price + "','" + price + "')"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); clinic_pharmacist_ms doc1 = new clinic_pharmacist_ms(); doc1.Show(); clinic_pharmacist_ms clnlog = new clinic_pharmacist_ms(); clnlog.Close(); Visible = false; MessageBox.Show("อัพเดตข้อมูลเรียบร้อย"); } catch (Exception) { MessageBox.Show("มีข้อผิดพลาด"); } conn.Close(); }
private void button2_Click(object sender, EventArgs e) { conn.Open(); try { CultureInfo ThaiCulture = new CultureInfo("th-TH"); DateTime date_start = Convert.ToDateTime(label16.Text); DateTime date_end = Convert.ToDateTime(dateTimePicker3.Text); DateTime today = DateTime.Now; string start = date_start.ToString("yyyy-MM-dd"); string end = date_end.ToString("yyyy-MM-dd", ThaiCulture); string namemedi = txtmedi.Text; string medi_num = txtmedinum.Text; string min = txtmin.Text; string unit_medi = comboBox1.SelectedItem.ToString(); double unit_price = Convert.ToDouble(txtpriceunit.Text); double price = Convert.ToDouble(txtprice.Text); if (txtmedi.Text == "0" || txtmedinum.Text == "0" || txtpriceunit.Text == "0" || txtprice.Text == "0" || unit_medi == "") { MessageBox.Show("กรุณากรอกข้อมูลให้ครบ"); } else { string query = ("select count(*) from medical where medi_name LIKE '%" + txtmedi.Text + "%'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); int new_stock1 = (int)cmd.ExecuteScalar(); if (new_stock1 < 1) { query = ("insert into medical (medi_name,medi_qty_total,medi_qty,medi_unit,medi_price_unit,medi_price,medi_date_x,medi_date_by,medi_status_stock,medi_status_new_stock,medi_status_xby,medi_min) values ('" + namemedi + "','" + medi_num + "','" + medi_num + "','" + unit_medi + "','" + unit_price + "','" + price + "','" + start + "','" + end + "',1,0,1,'" + min + "')"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); clinic_pharmacist_ms doc1 = new clinic_pharmacist_ms(); doc1.Show(); clinic_pharmacist_ms clnlog = new clinic_pharmacist_ms(); clnlog.Close(); Visible = false; MessageBox.Show("อัพเดตข้อมูลเรียบร้อย"); } else { MessageBox.Show("ชื่อยาซ้ำกัน"); } } } catch (Exception) { MessageBox.Show("กรอกข้อมูลให้เรียบร้อย"); } conn.Close(); }
private void button1_Click(object sender, EventArgs e) { conn.Open(); try { CultureInfo ThaiCulture = new CultureInfo("th-TH"); DateTime date_start = Convert.ToDateTime(label16.Text); DateTime date_end = Convert.ToDateTime(dateTimePicker2.Text); string start = date_start.ToString("yyyy-MM-dd"); string end = date_end.ToString("yyyy-MM-dd", ThaiCulture); DateTime today = DateTime.Now; int qty = Convert.ToInt32(lblcount.Text); int sub = qty + Convert.ToInt32(textBox1.Text); int xby1 = Convert.ToInt32(textBox1.Text); string medi_name = lblmedi.Text; /* * string query = ("select medi_name,medi_no,medi_qty,medi_unit,medi_price_unit,medi_price,medi_date_x,medi_date_by,medi_min from medical where medi_name = '" + medi_name + "'"); * // string query = ("select medi_name from medical where medi_name = '" + medi_name + "'"); * cmd = new SqlCommand(query, conn); * sda = new SqlDataAdapter(cmd); * dt = new DataTable(); * sda.Fill(dt); * sdr = cmd.ExecuteReader(); * if (sdr.Read()) * { * string medi_name1 = sdr["medi_name"].ToString(); * string medi_no = sdr["medi_no"].ToString(); * string medi_qty = sdr["medi_qty"].ToString(); * string medi_unit = sdr["medi_unit"].ToString(); * string medi_price_unit = sdr["medi_price_unit"].ToString(); * string medi_price = sdr["medi_price"].ToString(); * string medi_date_x = sdr["medi_date_x"].ToString(); * string medi_date_by = sdr["medi_date_by"].ToString(); * string min = sdr["medi_min"].ToString(); * query = ("insert into medical (medi_name,medi_no,medi_qty,medi_unit,medi_price_unit,medi_price,medi_date_x,medi_date_by,medi_status_stock,medi_status_new_stock,medi_status_xby,medi_min) values ('" + medi_name1 + "','" + medi_no + "','" + textBox1.Text + "','" + medi_unit + "','" + medi_price_unit + "','" + medi_price + "','" + start + "','" + end + "',2,1,2,'"+min+"')"); * cmd = new SqlCommand(query, conn); * sda = new SqlDataAdapter(cmd); * dt = new DataTable(); * * sda.Fill(dt); * * } */ if (today.Date >= date_end.Date) { MessageBox.Show("ไม่สามารถปรับปรุงยาได้"); } else { if (textBox1.Text == "") { MessageBox.Show("ไม่มีข้อมูลการปรับปรุงยา"); } else { string query = ("select count(*) from medical where medi_status_stock = 0 OR medi_status_xby = 0 AND medi_name = '" + lblmedi.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); int count = (int)cmd.ExecuteScalar(); if (count < 1) { MessageBox.Show("ไม่สามารถอัพเดตได้"); } else { query = ("select count(*) from medical where medi_status_stock = 0 AND medi_name = '" + lblmedi.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); int new_stock = (int)cmd.ExecuteScalar(); if (new_stock < 1) { MessageBox.Show("ไม่สามารถปรับปรุงยาได้"); } else { query = ("select * from medical where medi_status_new_stock = 0 AND medi_name = '" + lblmedi.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); sdr = cmd.ExecuteReader(); if (sdr.Read()) { int min = Convert.ToInt32(sdr["medi_min"].ToString()); int qty1 = Convert.ToInt32(sdr["medi_qty"].ToString()); int new_stock1 = Convert.ToInt32(sdr["medi_status_stock"].ToString()); int xby = Convert.ToInt32(sdr["medi_status_xby"].ToString()); if (xby == 0 && new_stock1 == 0) { query = ("UPDATE medical SET medi_qty_total = '" + sub + "',medi_qty = '" + xby1 + "',med_qty_use = '" + xby1 + "',medi_date_x = '" + start + "',medi_date_by = '" + end + "',medi_status_stock = 1 , medi_status_xby = 1 WHERE medi_name = '" + lblmedi.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); clinic_pharmacist_ms doc1 = new clinic_pharmacist_ms(); doc1.Show(); clinic_pharmacist_ms clnlog = new clinic_pharmacist_ms(); clnlog.Close(); Visible = false; MessageBox.Show("เติมข้อมูลยาเรียบร้อย"); } else { query = ("select medi_id from medical where medi_name = '" + lblmedi.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); sdr = cmd.ExecuteReader(); if (sdr.Read()) { int medi_id = Convert.ToInt32(sdr["medi_id"].ToString()); query = ("UPDATE medical SET medi_qty_total = '" + sub + "',medi_status_stock = 1 WHERE medi_name = '" + lblmedi.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); query = ("insert into medical_detail (medical_detail_qty,medical_detail_date_x,medical_detail_date_y,medi_id) values ('" + xby1 + "','" + start + "','" + end + "','" + medi_id + "')"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); } /* query = ("UPDATE medical SET medi_qty = '" + sub + "',medi_date_x = '" + start + "',medi_date_by = '" + end + "',medi_status_stock = 1 WHERE medi_name = '" + lblmedi.Text + "'"); * cmd = new SqlCommand(query, conn); * sda = new SqlDataAdapter(cmd); * dt = new DataTable(); * * sda.Fill(dt);*/ clinic_pharmacist_ms doc1 = new clinic_pharmacist_ms(); doc1.Show(); clinic_pharmacist_ms clnlog = new clinic_pharmacist_ms(); clnlog.Close(); Visible = false; MessageBox.Show("อัพเดตข้อมูลเรียบร้อย"); } // MessageBox.Show("dddddddddddddddddd" + xby + " " + new_stock1); } } /* query = ("select * from medical where medi_status_new_stock = 0 AND medi_status_xby <= 1 AND medi_name = '" + lblmedi.Text + "'"); * cmd = new SqlCommand(query, conn); * sda = new SqlDataAdapter(cmd); * dt = new DataTable(); * sda.Fill(dt); * sdr = cmd.ExecuteReader(); * if (sdr.Read()) * { * int min = Convert.ToInt32(sdr["medi_min"].ToString()); * int qty1 = Convert.ToInt32(sdr["medi_qty"].ToString()); * * * if (qty1 < min) * { * // MessageBox.Show("ปรับปรุงข้อมูล"); * /* query = ("UPDATE medical SET medi_qty = '" + sub + "',medi_date_x = '" + start + "',medi_date_by = '" + end + "',medi_status_stock = 1 WHERE medi_name = '" + lblmedi.Text + "'"); * cmd = new SqlCommand(query, conn); * sda = new SqlDataAdapter(cmd); * dt = new DataTable(); * * sda.Fill(dt); * * clinic_pharmacist_ms doc1 = new clinic_pharmacist_ms(); * doc1.Show(); * clinic_pharmacist_ms clnlog = new clinic_pharmacist_ms(); * clnlog.Close(); * Visible = false;*/ /* MessageBox.Show("อัพเดตข้อมูลเรียบร้อย"); * } * else * { * /* query = ("UPDATE medical SET medi_qty = '" + qty + "',medi_date_x = '" + start + "',medi_date_by = '" + end + "',medi_status_stock = 1 , medi_status_xby = 1 WHERE medi_name = '" + lblmedi.Text + "'"); * cmd = new SqlCommand(query, conn); * sda = new SqlDataAdapter(cmd); * dt = new DataTable(); * * sda.Fill(dt); * * clinic_pharmacist_ms doc1 = new clinic_pharmacist_ms(); * doc1.Show(); * clinic_pharmacist_ms clnlog = new clinic_pharmacist_ms(); * clnlog.Close(); * Visible = false;*/ /* MessageBox.Show("เติมข้อมูลยาเรียบร้อย"); * } * * * }*/ } } } } catch (Exception) { MessageBox.Show("ไม่มีข้อมูลการปรับปรุงยา"); } conn.Close(); }
private void mspToolStripMenuItem_Click(object sender, EventArgs e) { clinic_pharmacist_ms cliapp = new clinic_pharmacist_ms(); cliapp.Show(); }