private void Event_OnOrderGridViewRowCellStyle(object sender, RowCellStyleEventArgs e) { var status = Order_GridView.GetRowCellValue(e.RowHandle, Order_GridView.Columns[9]).ToString(); var noted = Order_GridView.GetRowCellValue(e.RowHandle, Order_GridView.Columns[10]).ToString(); Color selectedColor = default(Color); switch (status) { case "Success": //selectedColor = Color.Green; break; case "Waiting": selectedColor = Color.PaleGoldenrod; break; case "Canceled": selectedColor = Color.PaleVioletRed; break; case "Declined": selectedColor = Color.FromArgb(255, 150, 150); break; } if (status == "Waiting") { if (noted != ".") { selectedColor = Color.LimeGreen; } } if (!selectedColor.IsEmpty) { RGBAPix pix = selectedColor.ToRGBA(); HSLAPix hsl = pix; if (Order_GridView.IsRowSelected(e.RowHandle)) { hsl.l -= 0.10f; } else { if (e.RowHandle % 2 != 0) { hsl.l -= 0.05f; } } pix = hsl; e.Appearance.BackColor = (pix).ToWinColor(); } }
private void Event_OnOrderGridDoubleClicked(GridHitInfo info) { //Example /* * for (int i = 0; i < Order_GridView.Columns.Count; i++) { * var value = Order_GridView.GetRowCellValue(info.RowHandle, Order_GridView.Columns[i]); * } */ Form_OrderAction order_action = new Form_OrderAction(); order_action.Text = "" + Order_GridView.GetRowCellValue(info.RowHandle, "ORDER_NO"); Console.WriteLine(order_action.Text); ShowForm(order_action); FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null); }
/// <summary> /// Event yang dipanggil ketika <see cref="CircleButton"/> terclick di Area <see cref="Order_NavFrmae"/> /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Event_OnOrderNavButtonClicked(object sender, EventArgs e) { var btn = (CircleButton)sender; switch (btn.tag) { case "Approve": for (int i = 0; i < Order_GridView.GetSelectedRows().Length; i++) { string order_no = Order_GridView.GetRowCellValue(Order_GridView.GetSelectedRows()[i], "ORDER_NO").ToString(); DBSql.DoCommand("update checkouts set checkout_status='Success' where checkout_status='Waiting' and order_no='" + order_no + "'"); } FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null); Toast.ShowToast(Order_GridView.GetSelectedRows().Length + " Order Approved", "Order", ToastIndicator.Ok); break; case "Decline": for (int i = 0; i < Order_GridView.GetSelectedRows().Length; i++) { string order_no = Order_GridView.GetRowCellValue(Order_GridView.GetSelectedRows()[i], "ORDER_NO").ToString(); DBSql.DoCommand("update checkouts set checkout_status='Declined' where checkout_status='Waiting' and order_no='" + order_no + "'"); } FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null); Toast.ShowToast(Order_GridView.GetSelectedRows().Length + " Order Declined", "Order", ToastIndicator.Ok); break; case "Cancel": for (int i = 0; i < Order_GridView.GetSelectedRows().Length; i++) { string order_no = Order_GridView.GetRowCellValue(Order_GridView.GetSelectedRows()[i], "ORDER_NO").ToString(); DBSql.DoCommand("update checkouts set checkout_status='Canceled' where checkout_status='Waiting' and order_no='" + order_no + "'"); } FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null); Toast.ShowToast(Order_GridView.GetSelectedRows().Length + " Order Canceled", "Order", ToastIndicator.Ok); break; case "Print": break; case "Export": Dialog.ShowSaveFileDialog("Export Database", "Excel 97-2003 Workbook|*.xls", delegate(bool ok, string path) { if (ok) { DataSet ds = DBSql.DoGetData("select checkouts.order_no as ORDER_NO, checkouts.order_date as TANGGAL, tbl_customers.segment as BIDANG_USAHA, checkouts.customer_name as CUSTOMER, tbl_customers.region_name as WILAYAH, tbl_orders.product_name as PRODUCT_DESC, tbl_orders.family_name as FAMILY_DESC, tbl_orders.part_no as PART_NO, tbl_orders.design_name as DESAIN, tbl_orders.colors_name as WARNA, checkouts.currency as KURS, tbl_orders.price_unit as HARGA_SATUAN, tbl_orders.qty as QTY, tbl_orders.total_price as HARGA_TOTAL, tbl_users.fullname as SALESMAN, checkouts.notes as NOTE, checkouts.checkout_status as STATUS from checkouts inner join tbl_orders on tbl_orders.order_no=checkouts.order_no inner join tbl_customers on tbl_customers.customer_id=checkouts.customer_id inner join tbl_users on tbl_users.user_id=checkouts.sales_id"); if (ds != null) { XlsData data = new XlsData(ds); data.ToFile(path); } Toast.ShowToast("Data Berhasil Diexport", "Export Data Order", ToastIndicator.Ok); } }); break; case "Filter_Filter": //m_orderFilterToggle.state = !m_orderFilterToggle.state; Form_FilterOrder order_filter = new Form_FilterOrder(); order_filter.ShowDialog(); string query_filter = " where"; if (order_filter.filterRegion != "") { query_filter += " region='" + order_filter.filterRegion + "' AND"; } if (order_filter.filterBidUsaha != "") { query_filter += " segment='" + order_filter.filterBidUsaha + "' AND"; } if (order_filter.filterSalesman != "") { query_filter += " tbl_users.fullname='" + order_filter.filterSalesman + "' AND"; } query_filter = query_filter.Substring(0, query_filter.Length - 3); if (order_filter.status_filter_order) { FormUtility.LoadDatabaseToGrid(queryOrder + query_filter, Order_Grid, null); } break; case "Filter_Cancel": FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null); break; case "NextPage": break; case "PrevPage": break; case "Negosiasi": //This is event Form_Nego form_nego = new Form_Nego(); ShowForm(form_nego); break; } }