public static Boolean DEALERPRODUCT(clsDEALER M) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" INSERT INTO DETAIL_PRODUCT "); sb.Append(" (Dealer_ID "); sb.Append(" ,Type_ID "); sb.Append(" ,Product_ID "); sb.Append(" ,Price) "); sb.Append(" VALUES "); sb.Append(" ('" + M.Dealer_ID + "' "); //sb.Append(" ,'" + M.Dealer_Name + "' "); sb.Append(" ,'" + M.Type_ID + "' "); //sb.Append(" ,'" + M.Type_Name + "' "); sb.Append(" ,'" + M.Product_ID + "' "); sb.Append(" ,'" + M.Price + "') "); 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 == "") { MessageBox.Show("กรุณาระบุชื่อตัวแทนจำหน่ายก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (txtTel.Text == "") { MessageBox.Show("กรุณาระบุหมายเลขโทรศัพท์ก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (txtAddress.Text == "") { MessageBox.Show("กรุณาระบุที่อยู่ก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { try { var Dealer = new clsDEALER(); Dealer.Dealer_ID = this.txtID.Text.Trim(); Dealer.Dealer_Name = this.txtName.Text.Trim(); Dealer.Dealer_Tel = this.txtTel.Text.Trim(); Dealer.Dealer_Address = this.txtAddress.Text.Trim(); if (FUNCTION == "INSERT") { if (clsINSERT.DEALER(Dealer) == true) { MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("ข้อมูลไม่ถูกต้อง", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { if (clsUPDATE.DEALER(Dealer) == 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 Dealer1(clsDEALER M) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" DELETE "); sb.Append(" FROM DETAIL_PRODUCT "); sb.Append(" WHERE Product_ID = '" + M.Dealer_ID + "'"); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); return true; } catch (Exception ex) { return false; throw ex; } }
public static Boolean DEALER(clsDEALER M) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" UPDATE DEALER "); sb.Append(" SET Dealer_Name = '" + M.Dealer_Name + "' "); sb.Append(" ,Dealer_Tel = '" + M.Dealer_Tel + "'"); sb.Append(" ,Dealer_Address = '" + M.Dealer_Address + "'"); sb.Append(" WHERE Dealer_ID = '" + M.Dealer_ID + "' "); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); return true; } catch (Exception ex) { return false; throw ex; } }
private void button1_Click(object sender, EventArgs e) { DataTable dtProduct = clsSELECT.PRODUCT("", this.cbbProduct.Text.Trim()).Tables[0]; string Product_ID = dtProduct.Rows[0]["Product_ID"].ToString(); DataTable dtType = clsSELECT.TypeProduct("", this.cbbTypeProduct.Text.Trim()).Tables[0]; string Type_ID = dtType.Rows[0]["Type_ID"].ToString(); DataTable dtDealer = clsSELECT.Dealer("", this.cbbDealer.Text.Trim()).Tables[0]; string Dealer_ID = dtDealer.Rows[0]["Dealer_ID"].ToString(); if (txtPrice.Text == "") { MessageBox.Show("กรุณาระบุราคาสินค้าก่อน!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { try { var Dealer1 = new clsDEALER(); Dealer1.Dealer_ID = Dealer_ID; Dealer1.Product_ID = Product_ID; Dealer1.Type_ID = Type_ID; Dealer1.Price = this.txtPrice.Text.Trim(); if (FUNCTION == "INSERT") { if (clsINSERT.DEALERPRODUCT(Dealer1) == true) { MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("ข้อมูลไม่ถูกต้อง", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } this.Close(); }
private void btnDProduct_Click(object sender, EventArgs e) { var Dealer1 = new clsDEALER (); Dealer1.Dealer_ID = dgvView1.Rows[dgvView1.CurrentRow.Index].Cells["Dealer_ID1"].Value.ToString().Trim(); Dealer1.Type_ID = dgvView1.Rows[dgvView1.CurrentRow.Index].Cells["Type_ID"].Value.ToString().Trim(); Dealer1.Product_ID = dgvView1.Rows[dgvView1.CurrentRow.Index].Cells["Product_ID"].Value.ToString().Trim(); Dealer1.Price = dgvView1.Rows[dgvView1.CurrentRow.Index].Cells["Price"].Value.ToString().Trim(); if (MessageBox.Show("ต้องการลบข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (clsDELETE.Dealer1(Dealer1) == true) { MessageBox.Show("ลบข้อมูลเรียบร้อยแล้ว", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); } } //btnSearch_Click(sender, e); }
private void btnDelete_Click_1(object sender, EventArgs e) { var Dealer = new clsDEALER (); Dealer.Dealer_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Dealer_ID"].Value.ToString().Trim(); Dealer.Dealer_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Dealer_Name"].Value.ToString().Trim(); Dealer.Dealer_Tel = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Dealer_Tel"].Value.ToString().Trim(); Dealer.Dealer_Address = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Dealer_Address"].Value.ToString().Trim(); if (MessageBox.Show("ต้องการลบข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (clsDELETE.DEALER(Dealer) == true) { MessageBox.Show("ลบข้อมูลเรียบร้อยแล้ว", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); } } btnSearch_Click(sender, e); }
public static Boolean DEALER(clsDEALER M) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" INSERT INTO DEALER "); //sb.Append(" ( Dealer_ID "); sb.Append(" (Dealer_Name "); sb.Append(" ,Dealer_Tel "); sb.Append(" ,Dealer_Address )"); sb.Append(" VALUES "); //sb.Append(" ('" + M.Dealer_ID + "' "); sb.Append(" ('" + M.Dealer_Name + "' "); sb.Append(" ,'" + M.Dealer_Tel + "' "); sb.Append(" ,'" + M.Dealer_Address + "') "); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); return true; } catch (Exception ex) { return false; throw ex; } }