private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("กรุณาระบุเหตุผลในการยกเลิกรายการ", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { var Order = new clsORDER(); Order.Order_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Order_ID"].Value.ToString().Trim(); Order.DateSent = dgvView.Rows[dgvView.CurrentRow.Index].Cells["DateSent"].Value.ToString().Trim(); Order.DateReceive = dgvView.Rows[dgvView.CurrentRow.Index].Cells["DateReceive"].Value.ToString().Trim(); Order.Mem_ID = lblMID.Text.Trim(); Order.note = dgvView.Rows[dgvView.CurrentRow.Index].Cells["note"].Value.ToString().Trim(); Order.Status = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Status"].Value.ToString().Trim(); var frm = new frmNote(); frm.txtNote.Text = dgvView.Rows[dgvView.CurrentRow.Index].Cells["note"].Value.ToString().Trim(); frm.txtID.Text = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Order_ID"].Value.ToString().Trim(); frm.ShowDialog(); if (clsUPDATE .ORDERCANCEL(Order) == true) { MessageBox.Show("ยกเลิกรายการเรียบร้อยแล้ว", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); } } btnSearch_Click( sender, e); }
public static Boolean ORDER(clsORDER O) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" DELETE "); sb.Append(" FROM O_ORDER "); sb.Append(" WHERE Order_ID = '" + O.Order_ID + "'"); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); return true; } catch (Exception ex) { return false; throw ex; } }
private void button2_Click(object sender, EventArgs e) { if (txtNote.Text == "") { MessageBox.Show("กรุณาระบุเหตุผลในการยกเลิกรายการ!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { try { var Note = new clsORDER(); Note.Order_ID = this.txtID .Text.Trim(); Note.note = this.txtNote.Text.Trim(); if (clsUPDATE.UPNOTE(Note) == true) { this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void btnConfirm_Click(object sender, EventArgs e) { if (MessageBox.Show("ต้องการบันทึกข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { var Order = new clsORDER(); Order.Order_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Order_ID"].Value.ToString().Trim(); Order.Product_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_ID"].Value.ToString().Trim(); Order.Product_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_Name"].Value.ToString().Trim(); Order.Price = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Price"].Value.ToString().Trim(); Order.Total = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Total"].Value.ToString().Trim(); if (action1 == "") foreach (DataGridViewRow row in dgvView.Rows) { //if (Convert.ToInt32(row.Cells["Totaol"].Value.ToString())) //{ //}else{ StringBuilder sbUPTOTAL = new StringBuilder(); sbUPTOTAL.Append("UPDATE DETAIL_ORDER "); sbUPTOTAL.Append("SET Total = '" + row.Cells["Total"].Value.ToString() + "' "); sbUPTOTAL.Append(" WHERE Order_ID = '" + row.Cells["Order_ID"].Value.ToString() + "'"); sbUPTOTAL.Append(" AND Product_ID = '" + row.Cells["Product_ID"].Value.ToString() + "' "); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sbUPTOTAL.ToString()); //} } if (clsUPDATE.ORDEROK(Order) == true) { MessageBox.Show("บันทึกข้อมูลเรียบร้อยแล้ว", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); } } btnSearch_Click(sender, e); }
private void btnConfirm_Click(object sender, EventArgs e) { try { var Order = new clsORDER(); Order.Order_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Order_ID"].Value.ToString().Trim(); Order.Product_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_ID"].Value.ToString().Trim(); Order.Product_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_Name"].Value.ToString().Trim(); Order.Price = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Price"].Value.ToString().Trim(); Order.Total = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Total"].Value.ToString().Trim(); var Stock = new clsPRODUCT(); Stock.Product_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_ID"].Value.ToString().Trim(); Stock.Product_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Product_Name"].Value.ToString().Trim(); Stock.Total = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Total"].Value.ToString().Trim(); if (MessageBox.Show("ต้องการบันทึกข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (action == "") { //รับสินค้า StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO DELIVERY(DELIVERY_ID ,Dealer_ID ,DELIVERY_Date ,Mem_ID)"); sb.Append("VALUES ("); sb.Append(" '" + lbID.Text.Trim() + "' "); sb.Append(" ,'" + txtDeler .Text.Trim() + "' "); sb.Append(" ,'" + dtpDateReceive.Value.ToString("MM/dd/yyyy", cConfigAtt.formatEn) + "'"); sb.Append(" ,'" + lblMID.Text.Trim() + "' ) "); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); StringBuilder sbDetail = new StringBuilder(); foreach (DataGridViewRow row in dgvView.Rows) { //รายละเอียดการรับ sbDetail.Append(" INSERT INTO DETAIL_DELIVERY(DELIVERY_ID ,Product_ID,Price ,Total )"); sbDetail.Append(" VALUES( "); sbDetail.Append(" '" + lbID.Text.Trim() + "' "); sbDetail.Append(", '" + row.Cells["Product_ID"].Value.ToString() + "' "); sbDetail.Append(", '" + row.Cells["Price"].Value.ToString() + "' "); sbDetail.Append(", '" + row.Cells["TotalDerivery"].Value.ToString() + "' "); sbDetail.Append(" ); "); if (action1 == "") // เพิ่มสินค้าเข้าสต๊อก { StringBuilder sbUPSTOCK = new StringBuilder(); sbUPSTOCK.Append("update dbo.PRODUCT set Total = "); sbUPSTOCK.Append("Total + " + row.Cells["TotalDerivery"].Value.ToString()); sbUPSTOCK.Append(" where Product_ID = '" + row.Cells["Product_ID"].Value.ToString() + "'" ); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sbUPSTOCK.ToString()); } } clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sbDetail.ToString()); } if (clsUPDATE.DERIVERYOK(Order) == true) // อัพเดดสถานะ { MessageBox.Show("บันทึกข้อมูลเรียบร้อยแล้ว", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); } } } catch (Exception) { MessageBox.Show("เกิดข้อผิดพลาดในการรับสินค้า!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public static Boolean ORDEROK1(clsORDER O) { try { StringBuilder sb = new StringBuilder(); sb.Remove(0, sb.ToString().Length); sb.Append(" UPDATE DETAIL_ORDER "); sb.Append(" SET Total = '" + O.Total + "' "); sb.Append(" WHERE Order_ID = '" + O.Order_ID + "' "); sb.Append(" AND Product_ID = '"+O.Product_ID+"' "); clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString()); return true; } catch (Exception ex) { return false; throw ex; } }