private void btnDelete_Click(object sender, EventArgs e) { var Member = new clsMember (); Member.Mem_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Mem_ID"].Value.ToString().Trim(); Member.Mem_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Mem_Name"].Value.ToString().Trim(); Member.Share_Member = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Share_Member"].Value.ToString().Trim(); Member.Phone = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Phone"].Value.ToString().Trim(); Member.Status = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Status"].Value.ToString().Trim(); Member.Address = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Address"].Value.ToString().Trim(); Member.M_User = dgvView.Rows[dgvView.CurrentRow.Index].Cells["M_User"].Value.ToString().Trim(); Member.M_Pass = dgvView.Rows[dgvView.CurrentRow.Index].Cells["M_Pass"].Value.ToString().Trim(); //if (lblUser.Text == Cells["M_User"].Value.ToString()) //{ // MessageBox.Show("กำลังใช้งาน ไม่สามารถลบได้", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); //} if (MessageBox.Show("ต้องการลบข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (clsDELETE.MEMBER(Member) == true) { MessageBox.Show("ลบข้อมูลสำเร็จ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("ลบข้อมูลไม่สำเร็จ", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); } } btnSearch_Click(sender, e); }
public static Boolean MEMBER(clsMember M) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" INSERT INTO MEMBER "); //sb.Append(" ( Mem_ID "); sb.Append(" ( Mem_Name "); sb.Append(" ,Share_Member "); sb.Append(" ,Phone "); sb.Append(" ,Status "); sb.Append(" ,Address )"); sb.Append(" VALUES "); //sb.Append(" ('" + M.Mem_ID + "' "); sb.Append(" ('" + M.Mem_Name + "' "); sb.Append(" ,'" + M.Share_Member + "' "); sb.Append(" ,'" + M.Phone + "' "); sb.Append(" ,'" + M.Status + "' "); sb.Append(" ,'" + M.Address + "') "); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); return true; } catch (Exception ex) { return false; throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { if (txtName .Text.Trim() == "") { MessageBox.Show("กรุณาระบุชื่อ!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (txtTel .Text.Trim() == "") { MessageBox.Show("กรุณระบุเบอร์โทรศัพท์!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (txtAddress .Text.Trim() == "") { MessageBox.Show("กรุณาระบุที่อยู่!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { try { //ค่าที่รับมา var Member = new clsMember(); Member.Mem_ID = this.txtID.Text.Trim(); Member.Mem_Name = this.txtName.Text.Trim(); Member.Share_Member = this.cbbShere.Text.Trim(); Member.Phone = this.txtTel.Text.Trim(); Member.Status = this.cboStatus.Text.Trim(); Member.Address = this.txtAddress.Text.Trim(); Member.M_User = this.txtUser.Text.Trim(); Member.M_Pass = this.txtPass.Text.Trim(); if (FUNCTION == "INSERT") { if (clsINSERT.MEMBER(Member) == true) { MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { if (clsUPDATE.MEMBER(Member) == true) { MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } this.Close(); }
public static Boolean MEMBER(clsMember M) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" DELETE "); sb.Append(" FROM MEMBER "); sb.Append(" WHERE Mem_ID = '" + M.Mem_ID + "'"); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); return true; } catch (Exception ex) { return false; throw ex; } }
public static Boolean MEMBER(clsMember M) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" UPDATE MEMBER "); sb.Append(" SET Mem_Name = '" + M.Mem_Name + "' "); sb.Append(" ,Share_Member = '" + M.Share_Member + "' "); sb.Append(" ,Phone = '" + M.Phone + "'"); sb.Append(" ,Status = '" + M.Status + "'"); sb.Append(" ,Address = '" + M.Address+ "' "); sb.Append(" WHERE Mem_ID = '" + M.Mem_ID + "' "); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); return true; } catch (Exception ex) { return false; throw ex; } }