public void btSave_Click(object sender, EventArgs e) { var sqlScript = "select boatID from tb_boat where boatID = '" + txtBoatID.Text + "'"; //SQL.SQLCm = New SqlCommand(sqlScript, db.DatabaseConnection(constr)) //db.SQLDr = db.SQLCm.ExecuteReader() // Timer1.Enabled = True SQL.SQLCmd = new System.Data.SqlClient.SqlCommand(sqlScript, SQL.SQLCon); SQL.SQLCon.Open(); SQL.SQLDr = SQL.SQLCmd.ExecuteReader(); if (SQL.SQLDr.HasRows) { MessageBox.Show("ລະຫັດນີ້ມີຢູ່ໃນຖານຂໍ້ມູນແລ້ວ", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Warning); // MsgBox("ລະຫັດ" 5) } else { sqlInsert = "INSERT INTO tb_boat(boatID, boatTypeID, Boatname, boatStatus, boatPicture) values('" + txtBoatID.Text + "','" + System.Convert.ToString(cbBoatType.SelectedValue) + "',N'" + txtBoatName.Text + "',N'" + ComboBox1.SelectedItem.ToString() + "', '" + txtpicture.Text + "')"; ClassInsert save = new ClassInsert(); save.Insert(sqlInsert, connect.DatabaseConnection(constr), "ຂໍ້ມູນເຮືອລະຫັດ " + txtBoatID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ"); txtBoatID.Text = autoID.SetID(constr, "BoatID", "tb_Boat", "B0", 1, 2); selectData.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvboat); Clear(); } SQL.SQLCon.Close(); }
public void btSAve_Click(object sender, EventArgs e) { string sqlInsert = "INSERT INTO tb_Unit values('" + txtUnitID.Text + "', N'" + txtUnitName.Text + "')"; ClassInsert save = new ClassInsert(); save.Insert(sqlInsert, connect.DatabaseConnection(constr), "ຂໍ້ມູນຫົວໜ່ວຍລະຫັດ " + txtUnitID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ"); txtUnitID.Text = idauto.SetID(constr, "UnitID", "tb_Unit", "UN00", 2, 3); show.ShowData("SELECT * FROM v_Unit", connect.DatabaseConnection(constr), dgvUnit); }
public void btSave_Click(object sender, EventArgs e) { string sqlSave = "INSERT INTO tb_RateExchange VALUES('" + txtRateID.Text + "','" + txtCurrency.Text + "','" + txtRate.Text + "')"; ClassInsert save = new ClassInsert(); save.Insert(sqlSave, connect.DatabaseConnection(constr), "ຂໍ້ມູນອັດຕາແລກປ່ຽນລະຫັດ " + txtRateID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ"); txtRateID.Text = idauto.SetID(constr, "RateID", "tb_RateExchange", "R000", 1, 4); show.ShowData("SELECT * FROM v_RateExchange", connect.DatabaseConnection(constr), dgvRate); txtCurrency.Text = ""; txtRate.Clear(); txtCurrency.Focus(); }
public void ButtonX1_Click(object sender, EventArgs e) { if (txtHour.Text == "") { MessageBox.Show("ກະລຸນາປ້ອນຊົ່ວໂມງ"); return; } SqlCommand cm1 = new SqlCommand("select employeeID from tb_employee where employeeName = '" + Frm_Main.Default.btUser.Text + "'", ConstVar.connect.DatabaseConnection(ConstVar.constr)); SqlDataReader dr1 = default(SqlDataReader); dr1 = cm1.ExecuteReader(); dr1.Read(); ConstVar.emID = dr1[0].ToString(); // MsgBox(emID) string boatstate = "ບໍ່ວ່າງ"; string id = ""; // id = auto.SetID(constr, "SellID", "tb_Selling", "DLD", 3, 11, 11, "00000000000") id = Auto.SetID(ConstVar.constr, "SellID", "tb_Selling", "DLD", 3, 11, 11, "00000000000"); //MsgBox(id) string ServiceStyle = ""; if ((string)btRefresh.Tag == "ຈອງແລ້ວ") { ServiceStyle = System.Convert.ToString(1); } else if ((string)btRefresh.Tag == "ວ່າງ") { ServiceStyle = System.Convert.ToString(0); } string sqlboatStatusUpdate = "Update tb_Boat SET boatStatus = N'" + boatstate + "' WHERE boatid = '" + txtBoatID.Text + "'"; classUpdate up = new classUpdate(); up.Update(sqlboatStatusUpdate, ConstVar.connect.DatabaseConnection(ConstVar.constr)); var sql = "insert into tb_Selling(SellID, employeeID,boatID,dateCome, sellStatus,BoatSailHourInit, increase, discount, serveStyle) VALUES('" + id + "','" + ConstVar.emID + "','" + txtBoatID.Text.Trim() + "',getdate(),N'ຕຽມການ', '" + txtHour.Text + "',0,0, '" + ServiceStyle + "')"; ClassInsert save = new ClassInsert(); save.Insert(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr)); this.Close(); show.ShowData("select * from v_Selling", ConstVar.connect.DatabaseConnection(ConstVar.constr), frm_MainService.Default.dgvOrder); show.ShowData("select * from v_SellDetail", ConstVar.connect.DatabaseConnection(ConstVar.constr), frm_MainService.Default.dgvOrderDetail); frm_MainService.Default.RadioButton3.Checked = true; }
public void ButtonX1_Click(object sender, EventArgs e) { var sqlScript = "select FoodID from tb_FoodAndDrink where FoodID = '" + txtID1.Text + "'"; SQL.SQLCmd = new System.Data.SqlClient.SqlCommand(sqlScript, SQL.SQLCon); SQL.SQLCon.Open(); SQL.SQLDr = SQL.SQLCmd.ExecuteReader(); if (SQL.SQLDr.HasRows) { MessageBox.Show("ລະຫັດນີ້ມີຢູ່ໃນຖານຂໍ້ມູນແລ້ວ", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { ClassInsert insert = new ClassInsert(); insert.Insert("INSERT INTO tb_FoodAndDrink VALUES('" + txtID1.Text + "','" + System.Convert.ToString(cbfoodGroup.SelectedValue) + "','" + System.Convert.ToString(cbFoodType.SelectedValue) + "',N'" + txtName1.Text + "','" + System.Convert.ToString(cbUnit.SelectedValue) + "','" + txtPrice1.Text + "','" + txtPath1.Text + "')", connect.DatabaseConnection(constr), "ຂໍ້ມູນອາຫານລະຫັດ " + txtID1.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ"); show.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvEmployee); cleartxt(); } SQL.SQLCon.Close(); }
public void btSave_Click(object sender, EventArgs e) { var sqlScript = "select FoodGroupID from tb_FoodGroup where FoodgroupID = '" + txtID.Text + "'"; SQL.SQLCmd = new System.Data.SqlClient.SqlCommand(sqlScript, SQL.SQLCon); SQL.SQLCon.Open(); SQL.SQLDr = SQL.SQLCmd.ExecuteReader(); if (SQL.SQLDr.HasRows) { MessageBox.Show("ລະຫັດນີ້ມີຢູ່ໃນຖານຂໍ້ມູນແລ້ວ", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { ClassInsert save1 = new ClassInsert(); save1.Insert("INSERT INTO tb_FoodGroup VALUES('" + txtID.Text + "',N'" + txtName.Text + "',N'" + txtDEs.Text + "')", connect.DatabaseConnection(constr), "ຂໍ້ມູນກຸ່ມອາຫານລະຫັດ " + txtID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ"); show.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvFoodType); txtID.Text = autoID.SetID(constr, "FoodGroupID", "tb_FoodGroup", "FG00", 2, 3); cleartxt(); } }
public void btSave_Click(object sender, EventArgs e) { string sqlInsert = ""; var sqlscript = "SELECT EmployeeID FROM tb_Employee WHERE EmployeeID = '" + txtEmployeeID.Text + "'"; SQL.SQLCmd = new System.Data.SqlClient.SqlCommand(sqlscript, SQL.SQLCon); SQL.SQLCon.Open(); SQL.SQLDr = SQL.SQLCmd.ExecuteReader(); if (SQL.SQLDr.HasRows) { MessageBox.Show("ລະຫັດນີ້ມີຢູ່ໃນຖານຂໍ້ມູນແລ້ວ", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Warning); SQL.SQLDr.Close(); } else { sqlInsert = "INSERT INTO tb_Employee VALUES('" + txtEmployeeID.Text + "','" + txtEmployeeName.Text + "','" + txtEmployeeLastName.Text + "','" + dtbDob.Text + "','" + txtEmployeePosition.Text + "','" + txtEmployeeTel.Text + "','" + txtEmployeeParentTel.Text + "','" + txtEmployeeEmail.Text + "','" + txtEmployeeVillage.Text + "','" + txtEmployeeDistrict.Text + "','" + cbProvince.SelectedValue.ToString() + "','" + txtEmployeeSalary.Text + "','" + txtPicturePath.Text + "')"; ClassInsert save = new ClassInsert(); save.Insert(sqlInsert, connect.DatabaseConnection(constr), "ຂໍ້ມູນຂອງພະນັກງານລະຫັດ " + txtEmployeeID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ"); txtEmployeeID.Text = idauto.SetID(constr, "EmployeeID", "tb_Employee", "EP00", 2, 3); show.ShowData("SELECT * FROM v_Employee", connect.DatabaseConnection(constr), dgvEmployee); } SQL.SQLCon.Close(); }
public void btSave_Click(object sender, EventArgs e) { var sqlScript = "select FoodTypeID from tb_FoodType where FoodTypeID = '" + txtID.Text + "'"; //SQL.SQLCm = New SqlCommand(sqlScript, db.DatabaseConnection(constr)) //db.SQLDr = db.SQLCm.ExecuteReader() // Timer1.Enabled = True SQL.SQLCmd = new System.Data.SqlClient.SqlCommand(sqlScript, SQL.SQLCon); SQL.SQLCon.Open(); SQL.SQLDr = SQL.SQLCmd.ExecuteReader(); if (SQL.SQLDr.HasRows) { MessageBox.Show("ລະຫັດນີ້ມີຢູ່ໃນຖານຂໍ້ມູນແລ້ວ", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { ClassInsert save1 = new ClassInsert(); save1.Insert("INSERT INTO tb_FoodType VALUES('" + txtID.Text + "',N'" + txtName.Text + "',N'" + txtDEs.Text + "')", connect.DatabaseConnection(constr), "ຂໍ້ມູນປະເພດອາຫານລະຫັດ " + txtID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ"); show.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvFoodType); txtID.Text = autoID.SetID(constr, "foodTypeID", "tb_foodType", "FT", 2, 3, 3, "000"); } SQL.SQLCon.Close(); }