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