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();
}
