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