private void AddEditOutlay() { epCheck.Clear(); Regex RegMoney = new Regex(@"^((\d{1,8})|(\d{1,6}\.\d{1,2}))$"); Regex RegInt = new Regex(@"^(\d{1,3})$"); if (txb_outlayDetail.Text == string.Empty) { epCheck.SetError(txb_outlayDetail, "กรุณาระบุรายละเอียด"); txb_outlayDetail.Focus(); } else if (!RegMoney.IsMatch(txb_outlayPrice.Text)) { epCheck.SetError(txb_outlayPrice, "คุณกรอกไม่ถูกต้อง"); txb_outlayPrice.Focus(); txb_outlayPrice.Text = "0.00"; } else { string itxboutlayID = txb_outlayID.Text.Trim(); string itxboutlayDetail = txb_outlayDetail.Text.Trim(); string itxboutlayPrice = txb_outlayPrice.Text.Trim(); if (iAddEditOutlay == "AddOutlay") { DialogResult iConfirmResult = MessageBox.Show("เพิ่มรายการ รายจ่าย " + itxboutlayDetail + " มั๊ย?", "เพิ่มรายการ..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlUnit = "INSERT INTO `petshop`.`tb_outlay` (`outlay_Detail`, `outlay_Price`) VALUES ('" + itxboutlayDetail + "', '" + itxboutlayPrice + "');"; iConnect.Insert(isqlUnit); loadData(); clearTxb(); } } else if (iAddEditOutlay == "EditOutlay") { if (txb_outlayID.Text != string.Empty) { DialogResult iConfirmResult = MessageBox.Show("แก้ไขเป็น " + itxboutlayDetail + " มั๊ย?", "แก้ไขรายการ..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqloutlay = "UPDATE `petshop`.`tb_outlay` SET `outlay_Detail`='" + itxboutlayDetail + "', `outlay_Price`='" + itxboutlayPrice + "' WHERE `outlay_ID`='" + itxboutlayID + "'"; iConnect.Insert(isqloutlay); loadData(); clearTxb(); } } else { epCheck.SetError(txb_outlayID, "กรุณาเลือกรายการที่จะแก้ไข"); } } } }
private void AddProductBill() { string ilbBillID = Lb_BillID.Text.Trim(); string itxbReferID = txb_ReferID.Text.Trim(); if ((itxbReferID != null) && (itxbReferID != "")) { if ((ilbBillID != null) && (ilbBillID != "")) { for (int i = 0; dGV_Product.Rows.Count > i; i++) { if (dGV_Product.Rows[i].Cells[0].Value != null) { String iServiceID = dGV_Product.Rows[i].Cells[2].Value.ToString(); String iServicePrice = dGV_Product.Rows[i].Cells[3].Value.ToString(); DataTable idtServiceBilCheck; string isqlServiceBillCheck = "SELECT * FROM tb_productsalebill where Bill_ID = '" + ilbBillID + "'AND Product_ID = '" + iServiceID + "' "; idtServiceBilCheck = iConnect.SelectByCommand(isqlServiceBillCheck);//ลักษณะการทำงานคือ เมื่อเข้าไปเช็คในฐานข้อมูล หากมี ให้ทำการดอรป์ออก if (idtServiceBilCheck.Rows.Count > 0) { string isqlServiceBill = "DELETE FROM `tb_productsalebill` WHERE `Bill_ID`='" + ilbBillID + "' and`Product_ID`='" + iServiceID + "'"; iConnect.Insert(isqlServiceBill); } } if (Convert.ToBoolean(dGV_Product.Rows[i].Cells[0].Value) == false) { //ถ้าไม่เช็ค String iProductID = dGV_Product.Rows[i].Cells[2].Value.ToString(); String iProductPrice = dGV_Product.Rows[i].Cells[3].Value.ToString(); String iProductUnit = dGV_Product.Rows[i].Cells[4].Value.ToString(); string iProductAmt = dGV_Product.Rows[i].Cells[5].Value.ToString(); decimal iPrice = Convert.ToDecimal(iProductPrice); DataTable idtProductBilCheck; string isqlProductBillCheck = "SELECT * FROM tb_productsalebill where Bill_ID = '" + ilbBillID + "'AND Product_ID = '" + iProductID + "' "; idtProductBilCheck = iConnect.SelectByCommand(isqlProductBillCheck);//ลักษณะการทำงานคือ เมื่อเข้าไปเช็คในฐานข้อมูล หากไม่มี ให้ทำการเพิ่ม หากมีอยู่แล้ว ให้ทำการ แก้ไขให้ตรงกับปัจจุบัน if (idtProductBilCheck.Rows.Count == 0) { string isqlProductBill = "INSERT INTO `tb_productsalebill` (`Bill_ID`, `Product_ID`, `Productsale_Bill_Unit`, `Productsale_Bill_Price`, `Productsale_Bill_Amt`) VALUES ('" + ilbBillID + "', '" + iProductID + "', '" + iProductUnit + "', '" + iProductPrice + "', '" + iProductAmt + "')"; iConnect.Insert(isqlProductBill); } } //เรียกผลรวมมาแสดง } } } loaddata(); }
private void AddRecordProductSale() //สร้างรหัส และ อัพเดต Total DC Net { epCheck.Clear(); Regex RegMoney = new Regex(@"^((\d{1,8})|(\d{1,6}\.\d{1,2}))$"); string ilbProductSaleID = lb_ProductSaleID.Text.Trim(); if (cb_Em.SelectedValue == null) { epCheck.SetError(cb_Em, "ไม่ได้เลือกเจ้าหน้าที่"); } else { string icb_Em = cb_Em.SelectedValue.ToString(); string itxbRemark = txb_Remark.Text.Trim(); string itxbProductSaletotal = txb_ProductSaleTotal.Text.Trim(); string itxbProductSaleDC = txb_ProductSaleDC.Text.Trim(); string itxbProductSaleNet = txb_ProductSaleNet.Text.Trim(); string ilbyear = lbyear.Text.Trim(); System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-US"); System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo; System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo; string idTP_ProductSaleDate = dTP_ProductSaleDate.Value.ToString("yyyy-MM-dd"); if ((ilbProductSaleID == string.Empty) || (ilbProductSaleID == null)) { DialogResult iConfirmResult = MessageBox.Show("ต้องการบันทึกข้อมูลการรักษาใช่หรือไม่?", "บันทึกข้อมูล..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlProductSale = "INSERT INTO `tb_productsale` (`ProductSale_ID`, `Em_ID`, `ProductSale_Date`, `Productsale_Total`, `Productsale_DC`, `Productsale_Net`, `Productsale_Remark`) " + "VALUES (CONCAT('" + ilbyear + "99', LPAD( IFNULL( (SELECT SUBSTR(`ProductSale_ID`, 5) FROM `tb_productsale` AS `alias` WHERE SUBSTR(`ProductSale_ID`, 1, 2) = ('" + ilbyear + "') " + "ORDER BY `ProductSale_ID` DESC LIMIT 1 ) + 1, 1 ), 5, '0' )) , '" + icb_Em + "', '" + idTP_ProductSaleDate + "', '" + itxbProductSaletotal + "', '" + itxbProductSaleDC + "', '" + itxbProductSaleNet + "', '" + itxbRemark + "')"; iConnect.Insert(isqlProductSale); DataTable idtProductSaleID; //เรียกไอดีเดิมขึ้นมาโชว์ string isqProductSaleID = "SELECT ProductSale_ID FROM `tb_productsale` WHERE SUBSTR(`ProductSale_ID`, 1, 2) = ('" + ilbyear + "') ORDER BY `ProductSale_ID` DESC LIMIT 1"; idtProductSaleID = iConnect.SelectByCommand(isqProductSaleID); loadData(); loadProductSale(); lb_ProductSaleID.Text = idtProductSaleID.Rows[0].Field <string>(0); } } else { DataTable idtBillCheck; //BillCheck string isqlBillCheck = "SELECT * FROM petshop.tb_bill where Refer_ID = '" + ilbProductSaleID + "'"; idtBillCheck = iConnect.SelectByCommand(isqlBillCheck); if (idtBillCheck.Rows.Count == 0) { //ส่วนอัพเดต string isqlUpdate = "UPDATE `tb_productsale` SET `Em_ID`='" + icb_Em + "', `Productsale_Total`='" + itxbProductSaletotal + "', `Productsale_DC`='" + itxbProductSaleDC + "', `Productsale_Net`='" + itxbProductSaleNet + "', `Productsale_Remark`='" + itxbRemark + "' WHERE `ProductSale_ID`='" + ilbProductSaleID + "'"; iConnect.Insert(isqlUpdate); loadData(); loadProductSale(); MessageBox.Show("บันทึกข้อมูลแล้ว"); } } } }
private void AddBreed() { epCheck.Clear(); string itxbBreed = txb_BreedName.Text.Trim(); string icbType = ""; if (cb_Type.SelectedValue != null) { icbType = cb_Type.SelectedValue.ToString(); } else { LoadType(); epCheck.GetError(cb_Type); } if ((itxbBreed != null) && (itxbBreed != string.Empty)) { string isqlBreed = "INSERT INTO `tb_petbreed` (`PetBreed_ID`, `PetType_ID`, `PetBreed_Des`) VALUES (NULL, '" + icbType + "', '" + itxbBreed + "');"; DialogResult iConfirmResult = MessageBox.Show("เพิ่มพันธุ์ " + itxbBreed + " มั๊ย?", "เพิ่มพันธุ์สัตว์..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { iConnect.Insert(isqlBreed); LoadBreed(); clearBreedTxb(); txb_BreedName.Focus(); } } else { epCheck.SetError(txb_BreedName, "กรุณากรอกพันธุ์สัตว์"); txb_BreedID.Focus(); } }
private void bt_AddEmPosition_Click(object sender, EventArgs e) { epCheck.Clear(); if ((txb_Emposition.Text != null) && (txb_Emposition.Text != string.Empty)) { string itxbEmposition = txb_Emposition.Text.Trim(); DialogResult iConfirmResult = MessageBox.Show("เพิ่มตำแหน่ง " + itxbEmposition + " มั๊ย?", "Insert..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlEmposition = "INSERT INTO `tb_emposition` (`EmPosition_ID`, `Em_Position`) VALUES (NULL, '" + itxbEmposition + "')"; iConnect.Insert(isqlEmposition); ClearTxbPosition(); LoadEmPloyee(); LoadEmpoition(); txb_Emposition.Focus(); } } else { epCheck.SetError(txb_Emposition, "กรุณาระบุตำแหน่ง"); } }
private void AddoutlayDetail() { System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-US"); System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo; System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo; string ioutlayDate = dTP_outlayDate.Value.ToString("yyyy-MM-dd"); string icboutlay = cb_outlay.SelectedValue.ToString(); string icbEm = cb_Em.SelectedValue.ToString(); string itxboutlayAmt = txb_outlayAmt.Text.Trim(); string itxboutlayRemark = txb_outlayRemark.Text.Trim(); DialogResult iConfirmResult = MessageBox.Show("เพิ่มรายการ รายจ่าย " + cb_outlay.SelectedText.ToString() + " มั๊ย?", "เพิ่มรายการ..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlAddOutlay = "INSERT INTO `petshop`.`tb_outlaydetail` (`Em_ID`, `outlayDetail_Date`, `outlay_ID`, `outlayDetail_Remark`, `outlayDetail_Amt`) VALUES ('" + icbEm + "', '" + ioutlayDate + "', '" + icboutlay + "', '" + itxboutlayRemark + "', '" + itxboutlayAmt + "')"; iConnect.Insert(isqlAddOutlay); MessageBox.Show("เพิ่มรายจ่ายแล้ว"); loadoutlayDetail(); clearTxb(); } }
private void AddData() { epCheck.Clear(); string itxbUnitID = txb_UnitID.Text.Trim(); string itxbUnitName = txb_UnitName.Text.Trim(); if ((txb_UnitName.Text != null) && (txb_UnitName.Text != string.Empty)) { string isqlUnit = "INSERT INTO `petshop`.`tb_unit` (`Unit_ID`, `Unit_Name`) VALUES (NULL, '" + itxbUnitName + "')"; DialogResult iConfirmResult = MessageBox.Show("เพิ่มหน่วย " + itxbUnitName + " มั๊ย?", "เพิ่มหน่วย..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { iConnect.Insert(isqlUnit); loadData(); clearTxb(); } } else { epCheck.SetError(txb_UnitName, "กรุณากรอกหน่วย"); txb_UnitName.Focus(); } }
private void bt_remove_Click(object sender, EventArgs e) { string itxbPetProfileID = txb_PetProfileID.Text.ToString(); DataTable idtCheckProfileID; string isqlCheckProfileID = "SELECT * FROM petshop.tb_petprofile where Pet_ID = '" + itxbPetProfileID + "' "; idtCheckProfileID = iConnect.SelectByCommand(isqlCheckProfileID); if (idtCheckProfileID.Rows.Count != 0) { DataTable idtCheckStatus; string isqlCheckStatus = "SELECT * FROM petshop.tb_petprofile where Pet_ID = '" + itxbPetProfileID + "' AND Status = 0"; idtCheckStatus = iConnect.SelectByCommand(isqlCheckStatus); if (idtCheckStatus.Rows.Count == 1) { DialogResult iConfirmResult = MessageBox.Show("ต้องการลบข้อมูลสัตว์ใช่หรือไม่?", "ลบข้อมูลข้อมูล..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlreStatus = "UPDATE `petshop`.`tb_petprofile` SET `Status`=1 WHERE `Pet_ID`='" + itxbPetProfileID + "'"; iConnect.Insert(isqlreStatus); clearTxb(); } } else { DialogResult iConfirmResult = MessageBox.Show("ต้องการคืนข้อมูลสัตว์ใช่หรือไม่?", "คืนค่าข้อมูลข้อมูล..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlreStatus = "UPDATE `petshop`.`tb_petprofile` SET `Status`=0 WHERE `Pet_ID`='" + itxbPetProfileID + "'"; iConnect.Insert(isqlreStatus); clearTxb(); } } } LoadPetProfile(); }
private void bt_Submit_Click(object sender, EventArgs e) { string itxbOldPwd = txb_OldPwd.Text.Trim(); string itxbNewPwd = txb_NewPwd.Text.Trim(); string itxbPwdconf = txb_Pwdconf.Text.Trim(); byte[] hashold; byte[] hashnew; byte[] hashconf; using (MD5 md5 = MD5.Create()) { hashold = md5.ComputeHash(Encoding.UTF8.GetBytes(itxbOldPwd)); hashnew = md5.ComputeHash(Encoding.UTF8.GetBytes(itxbNewPwd)); hashconf = md5.ComputeHash(Encoding.UTF8.GetBytes(itxbPwdconf)); } string iPwdOld = Convert.ToBase64String(hashold); string iPwdnew = Convert.ToBase64String(hashnew); string iPwdconf = Convert.ToBase64String(hashconf); if (iPwdnew == iPwdconf) { string ilbPetID = lb_PetID.Text.Trim(); DataTable idtCheckPassword; string isqlCheckPass = "******" + ilbPetID + "' AND `Em_Pwd`='" + iPwdOld + "'"; idtCheckPassword = iConnect.SelectByCommand(isqlCheckPass); if (idtCheckPassword.Rows.Count == 1) { string isqlChangePwd = "UPDATE `petshop`.`tb_employee` SET `Em_Pwd`='" + iPwdnew + "' WHERE `Em_ID`='" + ilbPetID + "'"; iConnect.Insert(isqlChangePwd); this.Close(); MessageBox.Show("เปลี่ยนรหัสผ่านแล้ว"); } else { epCheck.SetError(txb_OldPwd, "รหัสผ่านเดิมไม่ถูกต้อง"); } } else { epCheck.SetError(txb_Pwdconf, "รหัสผ่านไม่ตรงกัน"); } }
private void bt_Update_Click(object sender, EventArgs e) { epCheck.Clear(); Regex RegInt2 = new Regex(@"^(\d{2})$"); if (txb_Company_Name.Text == string.Empty) { epCheck.SetError(txb_Company_Name, "กรุณาระบุชื่อองค์กร"); txb_Company_Name.Focus(); } else if (txb_CompanyAddr.Text == string.Empty) { epCheck.SetError(txb_CompanyAddr, "กรุณาระบุที่อยู่"); txb_CompanyAddr.Focus(); } else if (txb_CompanyTel.Text == string.Empty) { epCheck.SetError(txb_CompanyTel, "กรุณาระบุเบอร์โทรศัพท์"); txb_CompanyTel.Focus(); } else if (!RegInt2.IsMatch(txb_CoID.Text)) { epCheck.SetError(txb_CoID, "กรุณาระบุรหัสสาขา 2 ตำแหน่ง"); txb_CoID.Focus(); } else if (!RegInt2.IsMatch(txb_CoService.Text)) { epCheck.SetError(txb_CoService, "กรุณาระบุรหัสบริการ 2 ตำแหน่ง"); txb_CoService.Focus(); } else if (!RegInt2.IsMatch(txb_CoSale.Text)) { epCheck.SetError(txb_CoSale, "กรุณาระบุรหัสขายสินค้า 2 ตำแหน่ง"); txb_CoSale.Focus(); } else if (!RegInt2.IsMatch(txb_CoBill.Text)) { epCheck.SetError(txb_CoBill, "กรุณาระบุรหัสใบเสร็จ 2 ตำแหน่ง"); txb_CoBill.Focus(); } else { string itxbCompanyID = txb_CoID.Text.Trim(); string ilbCoID = lb_CoIDH.Text.Trim(); string itxbCompanyName = txb_Company_Name.Text.Trim(); string itxbCompanyAddr = txb_CompanyAddr.Text.Trim(); string itxbCompanyTel = txb_CompanyTel.Text.Trim(); string itxbCompanyremark = txb_CompanyRemark.Text.Trim(); string itxbCoService = txb_CoService.Text.Trim(); string itxbCoSale = txb_CoSale.Text.Trim(); string itxbCoBill = txb_CoBill.Text.Trim(); DialogResult iConfirmResult = MessageBox.Show("บันทึกข้อมูลองค์กร?", "Insert..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { if (idtCompany.Rows.Count > 0) { string isqlCompanyUpdate = "UPDATE `tb_company` SET `Company_ID`='" + itxbCompanyID + "', `Company_Name`='" + itxbCompanyName + "', `Company_Addr`='" + itxbCompanyAddr + "', `Company_Tel`='" + itxbCompanyTel + "', `Company_Remark`='" + itxbCompanyremark + "', `CoService`='" + itxbCoService + "', `CoSale`='" + itxbCoSale + "', `CoBill`='" + itxbCoBill + "' WHERE `Company_ID`='" + ilbCoID + "'"; iConnect.Insert(isqlCompanyUpdate); MessageBox.Show("ทำการปรับข้อมูลแล้ว"); ClearTxb(); LoadData(); } else { string isqlCompanyAdd = "INSERT INTO `tb_company` (`Company_ID`, `Company_Name`, `Company_Addr`, `Company_Tel`, `Company_Remark`, `CoService`, `CoSale`, `CoBill`) VALUES ('" + itxbCompanyID + "', '" + itxbCompanyName + "', '" + itxbCompanyAddr + "', '" + itxbCompanyTel + "', '" + itxbCompanyremark + "', '" + itxbCoService + "', '" + itxbCoSale + "', '" + itxbCoBill + "')"; iConnect.Insert(isqlCompanyAdd); MessageBox.Show("ทำการเพิ่มข้อมูลแล้ว"); ClearTxb(); LoadData(); } } } }
private void AddEditService() { epCheck.Clear(); Regex RegMoney = new Regex(@"^((\d{1,8})|(\d{1,6}\.\d{1,2}))$"); Regex Regint = new Regex(@"^\d{1,3}$"); if (!Regint.IsMatch(txb_ServiceDate.Text)) { epCheck.SetError(txb_ServiceDate, "***คุณลืมใส่วัน"); txb_ServiceDate.Text = "0"; } if (txb_ServiceDetail.Text == string.Empty) { epCheck.SetError(txb_ServiceDetail, "***กรุณากรอกชื่อบริการ"); txb_ServiceDetail.Focus(); } /* else if (!Regint.IsMatch(txb_ServiceDate.Text)) * { * epCheck.SetError(txb_ServiceDate, "***คุณลืมใส่วัน"); * txb_ServiceDate.Text = "0"; * } */ else if (!RegMoney.IsMatch(txb_ServicePrice.Text)) { epCheck.SetError(txb_ServicePrice, "***กรุณาใส่ค่าให้ถูกต้อง เช่น 777 หรือ 777.25"); txb_ServicePrice.Focus(); } else { string itxbserviceID = txb_ServiceID.Text.Trim(); string itxbServiceDetail = txb_ServiceDetail.Text.Trim(); string itxbServicePrice = txb_ServicePrice.Text.Trim(); string itxbServiceDate = txb_ServiceDate.Text.Trim(); if (iaddEditService == "AddService") { DialogResult iConfirmResult = MessageBox.Show("เพิ่มบริการ " + itxbServiceDetail + " มั๊ย?", "เพิ่มบริการ..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlAddService = "Insert into tb_service (Service_ID,Service_Des,Service_Price,Service_DuringDate) " + "Values (CONCAT('S',LPAD(IFNULL((SELECT SUBSTR(`Service_Id`, 2) FROM `tb_Service` as `alias` " + "Order By Service_ID DESC Limit 1)+1,1),12,'0')),'" + itxbServiceDetail + "','" + itxbServicePrice + "','" + itxbServiceDate + "')"; iConnect.Insert(isqlAddService); LoadService(); txb_ServiceDetail.Focus(); ClearTxtService(); iaddEditService = string.Empty; } } else if (iaddEditService == "EditService") { if ((itxbserviceID != null) && (itxbserviceID != string.Empty)) { DialogResult iConfirmResult = MessageBox.Show("แก้ไขบริการ " + itxbServiceDetail + " มั๊ย?", "แก้ไขบริการ..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlAddService = "UPDATE `tb_service` SET `Service_Des` = '" + itxbServiceDetail + "', `Service_Price` = '" + itxbServicePrice + "', `Service_DuringDate` = '" + itxbServiceDate + "' WHERE `tb_service`.`Service_ID` = '" + itxbserviceID + "'"; iConnect.Insert(isqlAddService); LoadService(); ClearTxtService(); iaddEditService = string.Empty; } } else { epCheck.SetError(txb_MediID, "ไม่ได้ระบุรหัสบริการ"); txb_MediID.Focus(); } } } }
private void AddEditBloodTest() { string ilbBloodTestID = lb_BloodTestID.Text.Trim(); System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-US"); System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo; System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo; string idtpBlootTestDate = dTP_BloodTestDate.Value.ToString("yyyy-MM-dd"); string icbEmID = cb_Em.SelectedValue.ToString(); string ilbPetID = lb_PetID.Text.Trim(); ///////////////////////////////////////////// Regex Regdecimal = new Regex(@"^((\d{1,8})|(\d{1,6}\.\d{1,2}))$"); if (!Regdecimal.IsMatch(txb_HGB.Text)) { txb_HGB.Text = "0.00"; } string itxbHGB = txb_HGB.Text.Trim(); /////////////////// if (!Regdecimal.IsMatch(txb_PCV.Text)) { txb_PCV.Text = "0.00"; } string itxbPCV = txb_PCV.Text.Trim(); /////////////////// if (!Regdecimal.IsMatch(txb_RBC.Text)) { txb_RBC.Text = "0.00"; } string itxbRBC = txb_RBC.Text.Trim(); ///////////////////// if (!Regdecimal.IsMatch(txb_MCV.Text)) { txb_MCV.Text = "0.00"; } string itxbMCV = txb_MCV.Text.Trim(); /////////////////// if (!Regdecimal.IsMatch(txb_MCHC.Text)) { txb_MCHC.Text = "0.00"; } string itxbMCHC = txb_MCHC.Text.Trim(); ////////////////// if (!Regdecimal.IsMatch(txb_WBC.Text)) { txb_WBC.Text = "0.00"; } string itxbWBC = txb_WBC.Text.Trim(); ///////////////////// if (!Regdecimal.IsMatch(txb_MYCYTE.Text)) { txb_MYCYTE.Text = "0.00"; } string itxbMYCYTE = txb_MYCYTE.Text.Trim(); ///////////////////////// if (!Regdecimal.IsMatch(txb_META.Text)) { txb_META.Text = "0.00"; } string itxbMETA = txb_META.Text.Trim(); ///////////////// if (!Regdecimal.IsMatch(txb_BAND.Text)) { txb_BAND.Text = "0.00"; } string itxbBand = txb_BAND.Text.Trim(); //////////////// if (!Regdecimal.IsMatch(txb_SEGS.Text)) { txb_SEGS.Text = "0.00"; } string itxbSEGS = txb_SEGS.Text.Trim(); /////////////////////////////////////////// if (!Regdecimal.IsMatch(txb_LYMPH.Text)) { txb_LYMPH.Text = "0.00"; } string itxbLYMPH = txb_LYMPH.Text.Trim(); if (!Regdecimal.IsMatch(txb_Mono.Text)) { txb_Mono.Text = "0.00"; } string itxbMONO = txb_Mono.Text.Trim(); if (!Regdecimal.IsMatch(txb_EOS.Text)) { txb_EOS.Text = "0.00"; } string itxbEOS = txb_EOS.Text.Trim(); if (!Regdecimal.IsMatch(txb_BASO.Text)) { txb_BASO.Text = "0.00"; } string itxbBASO = txb_BASO.Text.Trim(); if (!Regdecimal.IsMatch(txb_UNCLASS.Text)) { txb_UNCLASS.Text = "0.00"; } string itxbUNCLASS = txb_UNCLASS.Text.Trim(); /////////////////////////////////////////// if (!Regdecimal.IsMatch(txb_NUCLRBC.Text)) { txb_NUCLRBC.Text = "0.00"; } string itxbNUCLRBC = txb_NUCLRBC.Text.Trim(); if (!Regdecimal.IsMatch(txb_RETICS.Text)) { txb_RETICS.Text = "0.00"; } string itxbRETICS = txb_RETICS.Text.Trim(); if (!Regdecimal.IsMatch(txb_PLATELETS.Text)) { txb_PLATELETS.Text = "0.00"; } string itxbPLATELETS = txb_PLATELETS.Text.Trim(); if (!Regdecimal.IsMatch(txb_REFRACT.Text)) { txb_REFRACT.Text = "0.00"; } string itxbREFRACT = txb_REFRACT.Text.Trim(); if (!Regdecimal.IsMatch(txb_Blmor.Text)) { txb_Blmor.Text = "0.00"; } string itxbBlmor = txb_Blmor.Text.Trim(); //////////////////////////////////////// if (!Regdecimal.IsMatch(txb_BUN.Text)) { txb_BUN.Text = "0.00"; } string itxbBUN = txb_BUN.Text.Trim(); if (!Regdecimal.IsMatch(txb_CREATINNIE.Text)) { txb_CREATINNIE.Text = "0.00"; } string itxbCREATINNIE = txb_CREATINNIE.Text.Trim(); if (!Regdecimal.IsMatch(txb_GLUCOSE.Text)) { txb_GLUCOSE.Text = "0.00"; } string itxbGLUCOSE = txb_GLUCOSE.Text.Trim(); if (!Regdecimal.IsMatch(txb_AMYLASE.Text)) { txb_AMYLASE.Text = "0.00"; } string itxbAMYLASE = txb_AMYLASE.Text.Trim(); if (!Regdecimal.IsMatch(txb_ALT.Text)) { txb_ALT.Text = "0.00"; } string itxbALT = txb_ALT.Text.Trim(); if (!Regdecimal.IsMatch(txb_AST.Text)) { txb_AST.Text = "0.00"; } string itxbAST = txb_AST.Text.Trim(); if (!Regdecimal.IsMatch(txb_ALK.Text)) { txb_ALK.Text = "0.00"; } string itxbALK = txb_ALK.Text.Trim(); if (!Regdecimal.IsMatch(txb_CPK.Text)) { txb_CPK.Text = "0.00"; } string itxbCPK = txb_CPK.Text.Trim(); if (!Regdecimal.IsMatch(txb_BILIRUBIN.Text)) { txb_BILIRUBIN.Text = "0.00"; } string itxbBILIRUBIN = txb_BILIRUBIN.Text.Trim(); if (!Regdecimal.IsMatch(txb_DIRECT.Text)) { txb_DIRECT.Text = "0.00"; } string itxbDIRECT = txb_DIRECT.Text.Trim(); if (!Regdecimal.IsMatch(txb_INDIRECT.Text)) { txb_INDIRECT.Text = "0.00"; } string itxbINDIRECT = txb_INDIRECT.Text.Trim(); if (!Regdecimal.IsMatch(txb_CHOLESTEROL.Text)) { txb_CHOLESTEROL.Text = "0.00"; } string itxbCHOLESTEROL = txb_CHOLESTEROL.Text.Trim(); if (!Regdecimal.IsMatch(txb_TRIGLYCERIDE.Text)) { txb_TRIGLYCERIDE.Text = "0.00"; } string itxbTRIGLYCERIDE = txb_TRIGLYCERIDE.Text.Trim(); if (!Regdecimal.IsMatch(txb_BIURET.Text)) { txb_BIURET.Text = "0.00"; } string itxbBIURET = txb_BIURET.Text.Trim(); if (!Regdecimal.IsMatch(txb_ALBUMIN.Text)) { txb_ALBUMIN.Text = "0.00"; } string itxbALBUMIN = txb_ALBUMIN.Text.Trim(); if (!Regdecimal.IsMatch(txb_GLOBULIN.Text)) { txb_GLOBULIN.Text = "0.00"; } string itxbGLOBULIN = txb_GLOBULIN.Text.Trim(); //////////////////////////////////////////// if (!Regdecimal.IsMatch(txb_CALCIUM.Text)) { txb_CALCIUM.Text = "0.00"; } string itxbCALCIUM = txb_CALCIUM.Text.Trim(); if (!Regdecimal.IsMatch(txb_PHOSPHORUS.Text)) { txb_PHOSPHORUS.Text = "0.00"; } string itxbPHOSPHORUS = txb_PHOSPHORUS.Text.Trim(); if (!Regdecimal.IsMatch(txb_SODIUM.Text)) { txb_SODIUM.Text = "0.00"; } string itxbSODIUM = txb_SODIUM.Text.Trim(); if (!Regdecimal.IsMatch(txb_POTASSIUM.Text)) { txb_POTASSIUM.Text = "0.00"; } string itxbPOTASSIUM = txb_POTASSIUM.Text.Trim(); if (!Regdecimal.IsMatch(txb_CHLORIDE.Text)) { txb_CHLORIDE.Text = "0.00"; } string itxbCHLORIDE = txb_CHLORIDE.Text.Trim(); if (!Regdecimal.IsMatch(txb_AMMONIA.Text)) { txb_AMMONIA.Text = "0.00"; } string itxbAMMONIA = txb_AMMONIA.Text.Trim(); if (!Regdecimal.IsMatch(txb_OTHERS.Text)) { txb_OTHERS.Text = "0.00"; } string itxbOTHERS = txb_OTHERS.Text.Trim(); /////////////////////////////////////////// string itxbRemark = txb_bloodtestRemark.Text.Trim(); if ((ilbBloodTestID != string.Empty) && (ilbBloodTestID != null)) { DialogResult iConfirmResult = MessageBox.Show("ต้องการแก้ไขข้อมูลผลเลือดหรือไม่?", "บันทึกข้อมูล..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlBloodTestEdit = "UPDATE `petshop`.`tb_bloodtest` SET `Bloodtest_Date`='" + idtpBlootTestDate + "', `Em_ID`='" + icbEmID + "', `HGB`='" + itxbHGB + "', `PCV`='" + itxbPCV + "', `RBC`='" + itxbRBC + "', `MCV`='" + itxbMCV + "', `MCHC`='" + itxbMCHC + "', `WBC`='" + itxbWBC + "', `MYCYTE`='" + itxbMYCYTE + "', `META`='" + itxbMETA + "', `BAND`='" + itxbBand + "', `SEGS`='" + itxbSEGS + "', `LYMPH`='" + itxbLYMPH + "', `MONO`='" + itxbMONO + "', `EOS`='" + itxbEOS + "', `BASO`='" + itxbBASO + "', `UNCLASS`='" + itxbUNCLASS + "', `NUCLRBC`='" + itxbNUCLRBC + "', `RETICS`='" + itxbRETICS + "', `PLATELETS`='" + itxbPLATELETS + "', `REFRACT`='" + itxbREFRACT + "', `blmor`='" + itxbBlmor + "', `BUN`='" + itxbBUN + "'," + " `CREATINNIE`='" + itxbCREATINNIE + "', `GLUCOSE`='" + itxbGLUCOSE + "', `AMYLASE`='" + itxbAMYLASE + "', `ALT`='" + itxbALT + "', `AST`='" + itxbAST + "', `ALK`='" + itxbALK + "', `CPK`='" + itxbCPK + "', `BILIRUBIN`='" + itxbBILIRUBIN + "', `DIRECT`='" + itxbDIRECT + "', `INDIRECT`='" + itxbINDIRECT + "', `CHOLESTEROL`='" + itxbCHOLESTEROL + "', `TRIGLYCERIDE`='" + itxbTRIGLYCERIDE + "', `BIURET`='" + itxbBIURET + "', `ALBUMIN`='" + itxbALBUMIN + "', `GLOBULIN`='" + itxbGLOBULIN + "', `CALCIUM`='" + itxbCALCIUM + "', `PHOSPHORUS`='" + itxbPHOSPHORUS + "', `SODIUM`='" + itxbSODIUM + "', `POTASSIUM`='" + itxbPOTASSIUM + "', `CHLORIDE`='" + itxbCHLORIDE + "', `AMMONIA`='" + itxbAMMONIA + "', `bloodtest_OTHERS`='" + itxbOTHERS + "', `bloodtest_remark`='" + itxbRemark + "' WHERE `Bloodtest_ID`='" + ilbBloodTestID + "'"; iConnect.Insert(isqlBloodTestEdit); MessageBox.Show("ทำการข้อมูลแก้ไขแล้ว"); } } else { DialogResult iConfirmResult = MessageBox.Show("ต้องการเพิ่มข้อมูลผลเลือดหรือไม่?", "บันทึกข้อมูล..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlBloodTestAdd = "INSERT INTO `petshop`.`tb_bloodtest` (`Bloodtest_Date`, `Em_ID`, `Pet_ID`, `HGB`, `PCV`, `RBC`, `MCV`, `MCHC`, `WBC`, `MYCYTE`, `META`, `BAND`, `SEGS`, `LYMPH`, `MONO`, `EOS`, `BASO`, `UNCLASS`, `NUCLRBC`, `RETICS`, `PLATELETS`, `REFRACT`, `blmor`, `BUN`, `CREATINNIE`, `GLUCOSE`, `AMYLASE`, `ALT`, `AST`, `ALK`, `CPK`, `BILIRUBIN`, `DIRECT`, `INDIRECT`, `CHOLESTEROL`, `TRIGLYCERIDE`, `BIURET`, `ALBUMIN`, `GLOBULIN`, `CALCIUM`, `PHOSPHORUS`, `SODIUM`, `POTASSIUM`, `CHLORIDE`, `AMMONIA`, `bloodtest_OTHERS`, `bloodtest_remark`) " + "VALUES ('" + idtpBlootTestDate + "', '" + icbEmID + "', '" + ilbPetID + "', '" + itxbHGB + "', '" + itxbPCV + "', '" + itxbRBC + "', '" + itxbMCV + "', '" + itxbMCHC + "', '" + itxbWBC + "', '" + itxbMYCYTE + "', '" + itxbMETA + "', '" + itxbBand + "', '" + itxbSEGS + "', '" + itxbLYMPH + "', '" + itxbMONO + "', '" + itxbEOS + "', '" + itxbBASO + "', '" + itxbUNCLASS + "', '" + itxbNUCLRBC + "', '" + itxbRETICS + "', '" + itxbPLATELETS + "', '" + itxbREFRACT + "', '" + itxbBlmor + "', '" + itxbBUN + "', '" + itxbCREATINNIE + "', '" + itxbGLUCOSE + "', '" + itxbAMYLASE + "', '" + itxbAST + "', '" + itxbAST + "', '" + itxbALK + "', '" + itxbCPK + "', '" + itxbBILIRUBIN + "', '" + itxbDIRECT + "', '" + itxbINDIRECT + "', '" + itxbCHOLESTEROL + "', '" + itxbTRIGLYCERIDE + "', '" + itxbBIURET + "', '" + itxbALBUMIN + "', '" + itxbGLOBULIN + "', '" + itxbCALCIUM + "', '" + itxbPHOSPHORUS + "', '" + itxbSODIUM + "', '" + itxbPOTASSIUM + "', '" + itxbCHLORIDE + "', '" + itxbAMMONIA + "', '" + itxbOTHERS + "', '" + itxbRemark + "')"; iConnect.Insert(isqlBloodTestAdd); MessageBox.Show("บันทึกข้อมูลแล้ว"); DataTable idtBloodTest; string isqlBloodTest = "SELECT * FROM petshop.tb_bloodtest ORDER BY Bloodtest_ID DESC LIMIT 1"; idtBloodTest = iConnect.SelectByCommand(isqlBloodTest); lb_BloodTestID.Text = idtBloodTest.Rows[0].Field <Int32>(0).ToString(); } } }
private void AddHealRecord() { epCheck.Clear(); Regex RegString = new Regex(@"^[\d+]|[\w+]|[ ]$"); //Regex Regint = new Regex(@"^\d{1,3}$"); Regex Regdecimal = new Regex(@"^((\d{1,8})|(\d{1,6}\.\d{1,2}))$"); if ((txb_PetID.Text == null) || (txb_PetID.Text == "")) { epCheck.SetError(txb_PetID, "ไม่พบรหัสสัตว์"); } else if (cb_Em.SelectedValue == null) { epCheck.SetError(cb_Em, "กรุณาเลือกเจ้าหน้าที่"); } /*else if ((txb_HealRecordSymptom.Text == null) && (txb_HealRecordSymptom.Text == string.Empty)) * { * epCheck.SetError(txb_HealRecordSymptom, "กรุณาระบุอาการ"); * }*/ else if (!Regdecimal.IsMatch(txb_Temp.Text)) { epCheck.SetError(txb_Temp, "กรุณาระบุอณุหภูมิสัตว์"); } else if (!Regdecimal.IsMatch(txb_Weight.Text)) { epCheck.SetError(txb_Weight, "กรุณาระบุน้ำหนักสัตว์"); } else if (!Regdecimal.IsMatch(txb_HR.Text)) { epCheck.SetError(txb_HR, "กรุณาระบุอัตราการเต้นหัวใจ"); } else if (!Regdecimal.IsMatch(txb_RR.Text)) { epCheck.SetError(txb_RR, "กรุณาระบุอัตราการหายใจ"); } else { string ilbHealRecordID = lb_HealRecordID.Text.Trim(); string itxbPetID = txb_PetID.Text.Trim(); string icbEmID = cb_Em.SelectedValue.ToString(); string itxbHealRecordSymptom = txb_HealRecordSymptom.Text.Trim(); string itxbHealRecordRemark = txb_HealRecordRemark.Text.Trim(); string itxbWeight = txb_Weight.Text.Trim(); string itxbTemp = txb_Temp.Text.Trim(); string itxbHR = txb_HR.Text.Trim(); string itxbRR = txb_RR.Text.Trim(); System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-US"); System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo; System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo; string idtpHealRecordDate = dTP_HealRecordDate.Value.ToString("yyyy-MM-dd"); string ilbcompany = lbCompanyID.Text.ToString(); string ilbyear = lbYear.Text.ToString(); string itbHealTotal = txb_HealRecordTotal.Text.Trim(); string itbHealDC = txb_HealRecordDC.Text.Trim(); string itbHealNet = txb_HealRecordNet.Text.Trim(); if ((lb_HealRecordID.Text == null) || (lb_HealRecordID.Text == "")) { DialogResult iConfirmResult = MessageBox.Show("ต้องการบันทึกข้อมูลการรักษาใช่หรือไม่?", "บันทึกข้อมูล..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlHealthRecord = "INSERT INTO `tb_healrecord` (`HealRecord_ID`, `Pet_ID`, `Em_ID`, `HealRecord_Symptom`, `HealRecord_Remark`, `HealRecord_Weight`, `HealRecord_Temp`,HealRecord_HR,HealRecord_RR, `HealRecord_Date`, `HealRecord_Total`, `HealRecord_DC`, `HealRecord_Net`) " + "VALUES (CONCAT('" + ilbyear + ilbcompany + "', LPAD( IFNULL( (SELECT SUBSTR(`healrecord_Id`, 5) FROM `tb_healrecord` AS `alias` WHERE SUBSTR(`healrecord_Id`, 1, 2) = ('" + ilbyear + "') ORDER BY `healrecord_Id` DESC LIMIT 1 ) + 1, 1 ), 5, '0' )) " + " ,'" + itxbPetID + "', '" + icbEmID + "', '" + itxbHealRecordSymptom + "', '" + itxbHealRecordRemark + "', '" + itxbWeight + "', '" + itxbTemp + "','" + itxbHR + "','" + itxbRR + "', '" + idtpHealRecordDate + "', '" + itbHealTotal + "', '" + itbHealDC + "','" + itbHealNet + "')"; iConnect.Insert(isqlHealthRecord); DataTable idtHealRecordID; string isqlHealRecordID = "SELECT healrecord_Id FROM `tb_healrecord` WHERE SUBSTR(`healrecord_Id`, 1, 2) = ('" + ilbyear + "') ORDER BY `healrecord_Id` DESC LIMIT 1"; idtHealRecordID = iConnect.SelectByCommand(isqlHealRecordID); lb_HealRecordID.Text = idtHealRecordID.Rows[0].Field <string>(0); MessageBox.Show("สร้างเลขที่ทำการรักษาแล้ว"); } } else { DataTable idtBillCheck; //BillCheck string isqlBillCheck = "SELECT * FROM petshop.tb_bill where Refer_ID = '" + ilbHealRecordID + "'"; idtBillCheck = iConnect.SelectByCommand(isqlBillCheck); if (idtBillCheck.Rows.Count == 0) { string isqlHealRecordUpdate = "UPDATE `tb_healrecord` SET `Em_ID`='" + icbEmID + "', `HealRecord_Symptom`='" + itxbHealRecordSymptom + "', `HealRecord_Remark`='" + itxbHealRecordRemark + "', `HealRecord_Weight`='" + itxbWeight + "', `HealRecord_Temp`='" + itxbTemp + "',HealRecord_HR='" + itxbHR + "',HealRecord_RR='" + itxbRR + "',HealRecord_Date = '" + idtpHealRecordDate + "', `HealRecord_Total`='" + itbHealTotal + "', `HealRecord_DC`='" + itbHealDC + "', `HealRecord_Net`='" + itbHealNet + "' WHERE `HealRecord_ID`='" + ilbHealRecordID + "'"; iConnect.Insert(isqlHealRecordUpdate); MessageBox.Show("ทำการบันทึกข้อมูลแล้ว"); } } } loadHealRecord(); loadServiceRecord(); loadMediRecord(); }
private void AddServiceBill() { string ilbBillID = Lb_BillID.Text.Trim(); if ((txb_ReferID.Text != null) && (txb_ReferID.Text != "")) { if ((Lb_BillID.Text != null) && (Lb_BillID.Text != "")) { for (int i = 0; dGV_Service.Rows.Count > i; i++) { if (dGV_Service.Rows[i].Cells[0].Value != null) { String iServiceID = dGV_Service.Rows[i].Cells[2].Value.ToString(); String iServicePrice = dGV_Service.Rows[i].Cells[3].Value.ToString(); DataTable idtServiceBilCheck; string isqlServiceBillCheck = "SELECT * FROM tb_servicebill where Bill_ID = '" + ilbBillID + "'AND Service_ID = '" + iServiceID + "' "; idtServiceBilCheck = iConnect.SelectByCommand(isqlServiceBillCheck); //ลักษณะการทำงานคือ เมื่อเข้าไปเช็คในฐานข้อมูล หากมี ให้ทำการดอรป์ออก foreach (DataRow row in idtServiceBilCheck.Rows) { object value = row["Service_ID"]; if (value == DBNull.Value) { } else { string isqlServiceBill = "DELETE FROM `tb_servicebill` WHERE `Bill_ID`='" + ilbBillID + "' and`Service_ID`='" + iServiceID + "'"; iConnect.Insert(isqlServiceBill); } } ///////////////////////////////// } if (Convert.ToBoolean(dGV_Service.Rows[i].Cells[0].Value) == false) { //ถ้าไม่เช็ค String iServiceID = dGV_Service.Rows[i].Cells[2].Value.ToString(); String iServicePrice = dGV_Service.Rows[i].Cells[3].Value.ToString(); decimal iPrice = Convert.ToDecimal(iServicePrice); DataTable idtServiceBilCheck; string isqlServiceBillCheck = "SELECT * FROM tb_servicebill where Bill_ID = '" + ilbBillID + "'AND Service_ID = '" + iServiceID + "' "; idtServiceBilCheck = iConnect.SelectByCommand(isqlServiceBillCheck); //ลักษณะการทำงานคือ เมื่อเข้าไปเช็คในฐานข้อมูล หากไม่มี ให้ทำการเพิ่ม หากมีอยู่แล้ว ให้ทำการ แก้ไขให้ตรงกับปัจจุบัน if (idtServiceBilCheck.Rows.Count == 0) { string isqlServiceBill = "INSERT INTO `tb_servicebill` (`Bill_ID`, `Service_ID`, `Service_Bill_Unit`, `Service_Bill_Price`, `Service_Bill_Amt`) VALUES ('" + ilbBillID + "', '" + iServiceID + "', '1', '" + iServicePrice + "', '" + iServicePrice + "')"; iConnect.Insert(isqlServiceBill); } } //เรียกผลรวมมาแสดง } ///////////////////////////////////////////MediBill//////////////////////////////////////////////////// for (int i = 0; dGV_Medi.Rows.Count > i; i++) { if (dGV_Medi.Rows[i].Cells[0].Value != null) { String iMediID = dGV_Medi.Rows[i].Cells[2].Value.ToString(); String iMediUnit = dGV_Medi.Rows[i].Cells[3].Value.ToString(); String iMediPrice = dGV_Medi.Rows[i].Cells[4].Value.ToString(); String iMediAmt = dGV_Medi.Rows[i].Cells[5].Value.ToString(); DataTable idtMediBillCheck; string isqlMediBillCheck = "SELECT * FROM tb_medibill where Bill_ID = '" + ilbBillID + "'AND Medi_ID = '" + iMediID + "' "; idtMediBillCheck = iConnect.SelectByCommand(isqlMediBillCheck); foreach (DataRow row in idtMediBillCheck.Rows) { object value = row["Medi_ID"]; if (value == DBNull.Value) { } else { string isqlMediBill = "DELETE FROM `petshop`.`tb_medibill` WHERE `Bill_ID`='" + ilbBillID + "' and`Medi_ID`='" + iMediID + "'"; iConnect.Insert(isqlMediBill); } } } if (Convert.ToBoolean(dGV_Medi.Rows[i].Cells[0].Value) == false) { // ถ้าไม่เช็ค String iMediID = dGV_Medi.Rows[i].Cells[2].Value.ToString(); String iMediUnit = dGV_Medi.Rows[i].Cells[3].Value.ToString(); String iMediPrice = dGV_Medi.Rows[i].Cells[4].Value.ToString(); String iMediAmt = dGV_Medi.Rows[i].Cells[5].Value.ToString(); DataTable idtMediBillCheck; string isqlMediBillCheck = "SELECT * FROM tb_medibill where Bill_ID = '" + ilbBillID + "'AND Medi_ID = '" + iMediID + "' "; idtMediBillCheck = iConnect.SelectByCommand(isqlMediBillCheck); if (idtMediBillCheck.Rows.Count == 0) { string isqlMediBill = "INSERT INTO `petshop`.`tb_medibill` (`Bill_ID`, `Medi_ID`, `Medi_Bill_Unit`, `Medi_Bill_Price`, `Medi_Bill_Amt`) VALUES ('" + ilbBillID + "', '" + iMediID + "', '" + iMediUnit + "', '" + iMediPrice + "', '" + iMediAmt + "')"; iConnect.Insert(isqlMediBill); } } //เรียกผลรวมมาแสดง } ////////////////////////////////////////////////////////////////////////////////////////////////////// } else { BillAdd(); } } loadData(); }
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; } } } } } }
private void AddEditHealDate() { epCheck.Clear(); Regex RegString = new Regex(@"^[\d+]|[\w+]|[ ]$"); Regex Regint = new Regex(@"^\d{1,3}$"); if (lb_PetID.Text == string.Empty) { epCheck.SetError(lb_PetID, "ไม่พบรหัสสัตว์"); } else if (lb_HealRecordID.Text == string.Empty) { epCheck.SetError(lb_HealRecordID, "ไม่พบรหัสการรักษา"); } else if (cb_Service.SelectedValue == null) { epCheck.SetError(cb_Service, "กรุณาเลือกบริการที่นัดหมาย"); } else if (!Regint.IsMatch(txb_Remind.Text)) { epCheck.SetError(txb_Remind, "กรุณาระบุจำนวนวันก่อนถึงวันนัดหมาย"); txb_Remind.Focus(); } else { string ilbPetID = lb_PetID.Text.Trim(); string ilbHealRecordID = lb_HealRecordID.Text.Trim(); string icbService = cb_Service.SelectedValue.ToString(); string itxbRemark = Txb_Remark.Text.Trim(); System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-US"); System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo; System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo; string idTPHealDate = dTP_HealDate.Value.ToString("yyyy-MM-dd"); string iRe = "-" + txb_Remind.Text.Trim(); //MessageBox.Show(iRe); Int32 itxbRemind = Convert.ToInt32(iRe); DateTime iDateHeal = dTP_HealDate.Value; DateTime Remind = iDateHeal.AddDays(itxbRemind); string iRemind = Remind.ToString("yyyy-MM-dd"); if (iAddEditHealDate == "AddHealDate") { if ((lb_PetID.Text != "") || (lb_PetID.Text != null)) { DialogResult iConfirmResult = MessageBox.Show("ต้องการเพิ่มข้อมูลสัตว์ใช่หรือไม่?", "บันทึกข้อมูล..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlAddHealDate = "INSERT INTO `petshop`.`tb_healdate` (`Pet_ID`, `HealRecord_ID`, `Service_ID`, `HealDate_Remark`, `HealDate_Day`, `HealDate_Remind`, `HealDate_Status`) " + "VALUES ('" + ilbPetID + "', '" + ilbHealRecordID + "', '" + icbService + "', '" + itxbRemark + "', '" + idTPHealDate + "', '" + iRemind + "', 0)"; iConnect.Insert(isqlAddHealDate); ClearTxb(); /* DataTable idtHealDateID; * string isqlHealDateID = "SELECT HealDate_ID FROM `tb_healdate` ORDER BY `healDate_ID` DESC LIMIT 1"; * idtHealDateID = iConnect.SelectByCommand(isqlHealDateID); * lb_HealDateID.Text = Convert.ToString(idtHealDateID.Rows[0].Field<UInt32>(0));*/ MessageBox.Show("บันทึกการนัดหมายแล้ว"); loadData(); } } } else if (iAddEditHealDate == "EditHealDate") { string ilbHealDateID = lb_HealDateID.Text.Trim(); int iContract; //string iContract; if (CheckBox_Contract.Checked == true) { iContract = 1; //iContract = "ติดต่อแล้ว"; } else { iContract = 0; //iContract = "ยังไม่ได้ติดต่อ"; } if ((lb_HealDateID.Text != "") || (lb_HealDateID.Text != null)) { DialogResult iConfirmResult = MessageBox.Show("ต้องการเพิ่มข้อมูลสัตว์ใช่หรือไม่?", "บันทึกข้อมูล..", MessageBoxButtons.YesNo); if (iConfirmResult == DialogResult.Yes) { string isqlAddHealDate = "UPDATE `tb_healdate` " + " SET Service_Id = '" + icbService + "', `HealDate_Remark`='" + itxbRemark + "', `HealDate_Day`='" + idTPHealDate + "', `HealDate_Remind`='" + iRemind + "', `HealDate_Status`=" + iContract.ToString() + " WHERE `HealDate_ID`='" + ilbHealDateID + "'"; iConnect.Insert(isqlAddHealDate); ClearTxb(); MessageBox.Show("แก้ไขข้อมูลการนัดหมาย"); loadData(); } } } } }