private void Bt_Unit_Click(object sender, EventArgs e)
{
foreach (Form form in Application.OpenForms) //คำสั่งห้ามเปิดซ้อนสอง
{
if (form.GetType() == typeof(FrmSetting14))
{
form.Activate();
return;
}
}
FrmSetting14 iFrmMM13 = new FrmSetting14();
iFrmMM13.MdiParent = MainForm.ActiveForm;
iFrmMM13.Show();
}
private void หนวยToolStripMenuItem_Click(object sender, EventArgs e)
{
foreach (Form form in Application.OpenForms) //คำสั่งห้ามเปิดซ้อนสอง
{
if (form.GetType() == typeof(FrmSetting14))
{
form.Activate();
return;
}
}
FrmSetting14 iFrmSetting14 = new FrmSetting14();
iFrmSetting14.MdiParent = this;
iFrmSetting14.Show();
}
private void AddEditMedi()
{
epCheck.Clear();
Regex RegID = new Regex(@"[a-zA-Z0-9]{6,16}$");
Regex RegMoney = new Regex(@"^((\d{1,8})|(\d{1,6}\.\d{1,2}))$");
Regex RegInt = new Regex(@"^(\d{1,3})$");
int iStock = 0;
if (CheckBox_Stock.Checked == true)
{
iStock = 1;
}
else
{
txb_MediOrder.Text = "0";
}
//Regex RegDate = new Regex(@"^\d{1,3}$");
if (!RegID.IsMatch(txb_MediID.Text))
{
epCheck.SetError(txb_MediID, "***กรุณากรอกรหัสยาอย่างน้อย 6 หลัก *ตัวอย่าง Aa0001");
txb_MediID.Focus();
}
else if (txb_MediName.Text == string.Empty)
{
epCheck.SetError(txb_MediName, "***กรุณากรอกชื่อยา");
txb_MediName.Focus();
}
else if (!RegMoney.IsMatch(txb_MediPrice.Text))
{
epCheck.SetError(txb_MediPrice, "***กรุณาใส่ค่าให้ถูกต้อง เช่น 777 หรือ 777.25");
txb_MediPrice.Focus();
}
else if (!RegMoney.IsMatch(txb_MediSale.Text))
{
epCheck.SetError(txb_MediSale, "***กรุณาใส่ค่าให้ถูกต้อง เช่น 777 หรือ 777.25");
txb_MediSale.Focus();
}
else if (cb_MediUnit.SelectedValue == null)
{
MessageBox.Show("ไม่พบหน่วย กรุณาเพิ่มหน่วย");
epCheck.SetError(cb_MediUnit, "กรุณาเลือกหน่วย");
foreach (Form form in Application.OpenForms) //คำสั่งห้ามเปิดซ้อนสอง
{
if (form.GetType() == typeof(FrmSetting14))
{
form.Activate();
return;
}
}
FrmSetting14 iFrmMM13 = new FrmSetting14();
iFrmMM13.MdiParent = MainForm.ActiveForm;
iFrmMM13.Show();
cb_MediUnit.Focus();
}
else if (!RegInt.IsMatch(txb_MediAmt.Text))
{
epCheck.SetError(txb_MediAmt, "***คุณกรอกจำนวนไม่ถูกต้อง");
txb_MediAmt.Focus();
}
else if (!RegInt.IsMatch(txb_MediOrder.Text))
{
epCheck.SetError(txb_MediOrder, "***คุณกรอกจำนวนไม่ถูกต้อง");
txb_MediOrder.Focus();
}
else
{
string itxbMediID = txb_MediID.Text.Trim();
string itxbMediName = txb_MediName.Text.Trim();
string itxbMediDetail = txb_MediDetail.Text.Trim();
string icbMediUnit = "";
if (cb_MediUnit.SelectedValue != null)
{
icbMediUnit = cb_MediUnit.SelectedValue.ToString();
}
else
{
LoadUnit();
icbMediUnit = cb_MediUnit.SelectedValue.ToString();
}
System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-US");
System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo;
System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo;
string idtpProduct = dTP_Product.Value.ToString("yyyy-MM-dd");
string idtpExpired = dTP_Expired.Value.ToString("yyyy-MM-dd");
string itxbMediAmt = txb_MediAmt.Text.Trim();
string itxbMediOrder = txb_MediOrder.Text.Trim();
string itxbMediPrice = txb_MediPrice.Text.Trim();
string itxbMediSale = txb_MediSale.Text.Trim();
string ilbMediID = lb_MediIDH.Text.Trim();
if (iAddEditMedi == "AddMedi")
{
DataTable iCheckMedi;
string isqlCheckMedi = "SELECT * FROM tb_medicine where Medi_ID ='" + itxbMediID + "'";
iCheckMedi = iConnect.SelectByCommand(isqlCheckMedi);
if (iCheckMedi.Rows.Count > 0)
{
string iMedi = iCheckMedi.Rows[0].Field <string>(1);
MessageBox.Show("มียารหัส " + itxbMediID + " - " + iMedi + " อยู่ในระบบแล้ว", "ตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DialogResult iConfirmResult = MessageBox.Show("เพิ่มยา " + itxbMediName + " มั๊ย?", "เพิ่มยา..", MessageBoxButtons.YesNo);
if (iConfirmResult == DialogResult.Yes)
{
string isqlAddMedi = "Insert into tb_medicine (Medi_ID,Medi_Des,Medi_Detall,Medi_Price,Medi_Sale,Unit_ID,Medi_Product,Medi_Expired,Medi_Unit_Amt,Medi_Unit_Order,Medi_Stock) " +
"Values ('" + itxbMediID + "','" + itxbMediName + "', '" + itxbMediDetail + "', '" + itxbMediPrice + "', '" + itxbMediSale + "', '" + icbMediUnit + "', '" + idtpProduct + "', '" + idtpExpired + "', '" + itxbMediAmt + "', '" + itxbMediOrder + "',b'" + iStock + "')";
iConnect.Insert(isqlAddMedi);
MessageBox.Show("ทำการเพิ่ม '" + itxbMediID + "' - '" + itxbMediName + " แล้ว");
ClearTxtMedi();
LoadMedi();
iAddEditMedi = string.Empty;
}
}
}
else if (iAddEditMedi == "EditMedi")
{
DataTable iMediCheck;
string isqlMedi = "SELECT * FROM petshop.tb_medicine where Medi_ID = '" + ilbMediID + "'";
iMediCheck = iConnect.SelectByCommand(isqlMedi);
if (iMediCheck.Rows.Count > 0)
{
DialogResult iConfirmResult = MessageBox.Show("แก้ไขข้อมูลยา " + itxbMediName + " มั๊ย?", "แก้ไข..", MessageBoxButtons.YesNo);
if (iConfirmResult == DialogResult.Yes)
{
//string isqlAddMedi = "UPDATE `tb_medicine` SET Medi_ID = '" + itxbMediID + "',`Medi_Des` = '" + itxbMediName + "', `Medi_Detall` = '" + itxbMediDetail + "', `Medi_Price` = '" + itxbMediPrice + "', `Medi_Sale` = '" + itxbMediSale + "', `Unit_ID` = '" + icbMediUnit + "', `Medi_Product` = '" + idtpProduct + "', `Medi_Expired` = '" + idtpExpired + "', `Medi_Unit_Amt` = '" + itxbMediAmt + "', `Medi_Unit_Order` = '" + itxbMediOrder + "', Medi_Stock = b'" + iStock + "' WHERE `tb_medicine`.`Medi_ID` = '" + ilbMediID + "'";
string isqlAddMedi = "UPDATE `tb_medicine` SET `Medi_Des` = '" + itxbMediName + "', `Medi_Detall` = '" + itxbMediDetail + "', `Medi_Price` = '" + itxbMediPrice + "', `Medi_Sale` = '" + itxbMediSale + "', `Unit_ID` = '" + icbMediUnit + "', `Medi_Product` = '" + idtpProduct + "', `Medi_Expired` = '" + idtpExpired + "', `Medi_Unit_Amt` = '" + itxbMediAmt + "', `Medi_Unit_Order` = '" + itxbMediOrder + "', Medi_Stock = b'" + iStock + "' WHERE `tb_medicine`.`Medi_ID` = '" + ilbMediID + "'";
iConnect.Insert(isqlAddMedi);
LoadMedi();
ClearTxtMedi();
iAddEditMedi = string.Empty;
}
}
}
}
}
private void AddEditProduct()
{
epCheck.Clear();
Regex RegID = new Regex(@"[a-zA-Z0-9]{6,16}$");
Regex RegMoney = new Regex(@"^((\d{1,8})|(\d{1,6}\.\d{1,2}))$");
Regex RegInt = new Regex(@"^(\d{1,3})$");
//Regex RegDate = new Regex(@"^\d{1,3}$");
int iStock = 0;
if (CheckBox_Stock.Checked == true)
{
iStock = 1;
}
else
{
txb_ProductOrder.Text = "0";
}
if (!RegID.IsMatch(txb_ProductID.Text))
{
epCheck.SetError(txb_ProductID, "***กรุณากรอกรหัสสินค้าอย่างน้อย 6 หลัก *ตัวอย่าง Aa0001");
txb_ProductID.Focus();
}
else if (txb_ProductName.Text == string.Empty)
{
epCheck.SetError(txb_ProductName, "***กรุณากรอกชื่อสินค้า");
txb_ProductName.Focus();
}
else if (!RegMoney.IsMatch(txb_ProductPrice.Text))
{
epCheck.SetError(txb_ProductPrice, "***กรุณาใส่ค่าให้ถูกต้อง เช่น 777 หรือ 777.25");
txb_ProductPrice.Focus();
}
else if (!RegMoney.IsMatch(txb_ProductSale.Text))
{
epCheck.SetError(txb_ProductSale, "***กรุณาใส่ค่าให้ถูกต้อง เช่น 777 หรือ 777.25");
txb_ProductSale.Focus();
}
else if (cb_ProductUnit.SelectedValue == null)
{
MessageBox.Show("ไม่พบหน่วย กรุณาเพิ่มหน่วย");
epCheck.SetError(cb_ProductUnit, "กรุณาเลือกหน่วย");
foreach (Form form in Application.OpenForms) //คำสั่งห้ามเปิดซ้อนสอง
{
if (form.GetType() == typeof(FrmSetting14))
{
form.Activate();
return;
}
}
FrmSetting14 iFrmMM13 = new FrmSetting14();
iFrmMM13.MdiParent = MainForm.ActiveForm;
iFrmMM13.Show();
cb_ProductUnit.Focus();
}
else if (!RegInt.IsMatch(txb_ProductAmt.Text))
{
epCheck.SetError(txb_ProductAmt, "***คุณกรอกจำนวนไม่ถูกต้อง");
txb_ProductAmt.Focus();
}
else if (!RegInt.IsMatch(txb_ProductOrder.Text))
{
epCheck.SetError(txb_ProductOrder, "***คุณกรอกจำนวนไม่ถูกต้อง");
txb_ProductOrder.Focus();
}
else
{
string itxbProductID = txb_ProductID.Text.Trim();
string itxbProductName = txb_ProductName.Text.Trim();
string itxbProductDetail = txb_ProductDetail.Text.Trim();
string itxbProductPrice = txb_ProductPrice.Text.Trim();
string itxbProductSale = txb_ProductSale.Text.Trim();
string icbProductUnit = cb_ProductUnit.SelectedValue.ToString();
System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-US");
System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo;
System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo;
string idtpProduct = dTP_Product.Value.ToString("yyyy-MM-dd");
string idtpExpired = dTP_Expired.Value.ToString("yyyy-MM-dd");
string itxbProductAmt = txb_ProductAmt.Text.Trim();
string itxbProductOrder = txb_ProductOrder.Text.Trim();
string ilbProductID = lb_ProductIDh.Text.Trim();
DataTable idtProductCheck;
string isqlProductCheck = "SELECT * FROM petshop.tb_product where Product_ID = '" + itxbProductID + " '";
idtProductCheck = iConnect.SelectByCommand(isqlProductCheck);
if (iAddEditProduct == "AddProduct")
{
if (idtProductCheck.Rows.Count > 0)
{
MessageBox.Show("มีสินค้ารหัส " + itxbProductID + " อยู่ในระบบแล้ว", "ตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DialogResult iConfirmResult = MessageBox.Show("เพิ่มสินค้า " + itxbProductName + " มั๊ย?", "เพิ่มสินค้า..", MessageBoxButtons.YesNo);
if (iConfirmResult == DialogResult.Yes)
{
string isqlAddProduct = "INSERT INTO `tb_product` (`Product_ID`, `Product_Des`, `Product_Detail`, `Product_Price`, `Product_Sale`, `Unit_ID`, `Product_Product`, `Product_Expired`, `Product_Unit_Amt`, `Product_Unit_Order`,Product_Stock) " +
"VALUES ('" + itxbProductID + "','" + itxbProductName + "', '" + itxbProductDetail + "', '" + itxbProductPrice + "', '" + itxbProductSale + "', '" + icbProductUnit + "', '" + idtpProduct + "', '" + idtpExpired + "', '" + itxbProductAmt + "', '" + itxbProductOrder + "',b'" + iStock + "')";
iConnect.Insert(isqlAddProduct);
LoadProduct();
ClearTxtProduct();
iAddEditProduct = string.Empty;
}
}
}
else if (iAddEditProduct == "EditProduct")
{
if (idtProductCheck.Rows.Count > 0)
{
if ((itxbProductID != null) && (itxbProductID != string.Empty))
{
DialogResult iConfirmResult = MessageBox.Show("แก้ไข " + itxbProductName + " มั๊ย?", "แก้ไขข้อมูล..", MessageBoxButtons.YesNo);
if (iConfirmResult == DialogResult.Yes)
{
string isqlAddProduct = "UPDATE `tb_product` SET `Product_Des` = '" + itxbProductName + "', `Product_Detail` = '" + itxbProductDetail + "', `Product_Price` = '" + itxbProductPrice + "', `Product_Sale` = '" + itxbProductSale + "', `Unit_ID` = '" + icbProductUnit + "', `Product_Product` = '" + idtpProduct + "', `Product_Expired` = '" + idtpExpired + "', `Product_Unit_Amt` = '" + itxbProductAmt + "', `Product_Unit_Order` = '" + itxbProductOrder + "',Product_Stock = b'" + iStock + "' WHERE `tb_product`.`Product_ID` = '" + ilbProductID + "'";
//string isqlAddProduct = "UPDATE `tb_product` SET Product_ID = '" + itxbProductID + "',`Product_Des` = '" + itxbProductName + "', `Product_Detail` = '" + itxbProductDetail + "', `Product_Price` = '" + itxbProductPrice + "', `Product_Sale` = '" + itxbProductSale + "', `Unit_ID` = '" + icbProductUnit + "', `Product_Product` = '" + idtpProduct + "', `Product_Expired` = '" + idtpExpired + "', `Product_Unit_Amt` = '" + itxbProductAmt + "', `Product_Unit_Order` = '" + itxbProductOrder + "',Product_Stock = b'" + iStock + "' WHERE `tb_product`.`Product_ID` = '" + ilbProductID + "';";
iConnect.Insert(isqlAddProduct);
LoadProduct();
ClearTxtProduct();
iAddEditProduct = string.Empty;
}
}
}
}
}
}
