private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Jenis Pengeluaran" }); GridListControlHelper.InitializeGridListControl <JenisPengeluaran>(this.gridList, _listOfJenisPengeluaran, gridListProperties); if (_listOfJenisPengeluaran.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfJenisPengeluaran.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfJenisPengeluaran.Count) { var jenisPengeluaran = _listOfJenisPengeluaran[rowIndex]; switch (e.ColIndex) { case 2: e.Style.CellValue = jenisPengeluaran.nama_jenis_pengeluaran; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama", Width = 200 }); gridListProperties.Add(new GridListControlProperties { Header = "Jabatan", Width = 200 }); gridListProperties.Add(new GridListControlProperties { Header = "Kehadiran", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Absen", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Gaji", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Tunjangan", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Bonus", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Lembur", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Potongan", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Total" }); GridListControlHelper.InitializeGridListControl <GajiKaryawan>(this.gridList, _listOfGaji, gridListProperties); if (_listOfGaji.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfGaji.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfGaji.Count) { var gaji = _listOfGaji[rowIndex]; switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(gaji.tanggal); break; case 3: var karyawan = gaji.Karyawan; if (karyawan != null) { e.Style.CellValue = karyawan.nama_karyawan; } break; case 4: var jabatan = gaji.Karyawan.Jabatan; if (jabatan != null) { e.Style.CellValue = jabatan.nama_jabatan; } break; case 5: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = gaji.kehadiran; break; case 6: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = gaji.absen; break; case 7: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(gaji.gaji_akhir); break; case 8: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(gaji.tunjangan); break; case 9: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(gaji.bonus); break; case 10: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(gaji.lembur_akhir); break; case 11: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(gaji.potongan); break; case 12: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(gaji.total_gaji); break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridControl(GridControl grid) { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Jenis Pengeluaran", Width = 350 }); gridListProperties.Add(new GridListControlProperties { Header = "Jumlah", Width = 50 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga", Width = 90 }); gridListProperties.Add(new GridListControlProperties { Header = "Sub Total", Width = 110 }); gridListProperties.Add(new GridListControlProperties { Header = "Aksi" }); GridListControlHelper.InitializeGridListControl <ItemPengeluaranBiaya>(grid, _listOfItemPengeluaran, gridListProperties); grid.PushButtonClick += delegate(object sender, GridCellPushButtonClickEventArgs e) { if (e.ColIndex == 6) { if (grid.RowCount == 1) { MsgHelper.MsgWarning("Minimal 1 item pengeluaran harus diinputkan !"); return; } if (MsgHelper.MsgDelete()) { var itemPengeluaran = _listOfItemPengeluaran[e.RowIndex - 1]; itemPengeluaran.entity_state = EntityState.Deleted; _listOfItemPengeluaranDeleted.Add(itemPengeluaran); _listOfItemPengeluaran.Remove(itemPengeluaran); grid.RowCount = _listOfItemPengeluaran.Count(); grid.Refresh(); RefreshTotal(); } } }; grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { // Make sure the cell falls inside the grid if (e.RowIndex > 0) { if (!(_listOfItemPengeluaran.Count > 0)) { return; } var itemPengeluaran = _listOfItemPengeluaran[e.RowIndex - 1]; var jenisPengeluaran = itemPengeluaran.JenisPengeluaran; if (e.RowIndex % 2 == 0) { e.Style.BackColor = ColorCollection.BACK_COLOR_ALTERNATE; } switch (e.ColIndex) { case 1: // no urut e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.Enabled = false; e.Style.CellValue = e.RowIndex.ToString(); break; case 2: // nama jenis pengeluaran if (jenisPengeluaran != null) { e.Style.CellValue = jenisPengeluaran.nama_jenis_pengeluaran; } break; case 3: // jumlah e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = itemPengeluaran.jumlah; break; case 4: // harga e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(itemPengeluaran.harga); break; case 5: // subtotal e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.Enabled = false; e.Style.CellValue = NumberHelper.NumberToString(itemPengeluaran.jumlah * itemPengeluaran.harga); break; case 6: // button hapus e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellType = GridCellTypeName.PushButton; e.Style.Enabled = true; e.Style.Description = "Hapus"; break; default: break; } e.Handled = true; // we handled it, let the grid know } }; var colIndex = 2; // kolom nama produk grid.CurrentCell.MoveTo(1, colIndex, GridSetCurrentCellOptions.BeginEndUpdate); }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama", Width = 300 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat", Width = 300 }); gridListProperties.Add(new GridListControlProperties { Header = "Telepon", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Jenis Gajian", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Status", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Jabatan", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Kasbon" }); GridListControlHelper.InitializeGridListControl <Karyawan>(this.gridList, _listOfKaryawan, gridListProperties); if (_listOfKaryawan.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfKaryawan.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfKaryawan.Count) { var karyawan = _listOfKaryawan[rowIndex]; switch (e.ColIndex) { case 2: e.Style.CellValue = karyawan.nama_karyawan; break; case 3: e.Style.CellValue = karyawan.alamat; break; case 4: e.Style.CellValue = karyawan.telepon; break; case 5: e.Style.CellValue = karyawan.jenis_gajian == JenisGajian.Mingguan ? "Mingguan" : "Bulanan"; break; case 6: e.Style.CellValue = karyawan.is_active ? "Aktif" : "Non Aktif"; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 7: var jabatan = karyawan.Jabatan; if (jabatan != null) { e.Style.CellValue = jabatan.nama_jabatan; } break; case 8: e.Style.CellValue = NumberHelper.NumberToString(karyawan.sisa_kasbon); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Kurir", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Jenis Layanan", Width = 330 }); gridListProperties.Add(new GridListControlProperties { Header = "Tarif" }); GridListControlHelper.InitializeGridListControl <costs>(this.gridList, _listOfCost, gridListProperties); if (_listOfCost.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfCost.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfCost.Count) { var cost = _listOfCost[rowIndex]; switch (e.ColIndex) { case 2: e.Style.CellValue = cost.kurir_code; break; case 3: e.Style.CellValue = string.Format("{0} ({1})", cost.service, cost.description); break; case 4: var costDetail = cost.cost[0]; e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(costDetail.value); break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridControl(GridControl grid) { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Kode Produk", Width = 120 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama Produk", Width = 240 }); gridListProperties.Add(new GridListControlProperties { Header = "Jumlah", Width = 50 }); gridListProperties.Add(new GridListControlProperties { Header = "Diskon", Width = 50 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga", Width = 90 }); gridListProperties.Add(new GridListControlProperties { Header = "Sub Total", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Aksi" }); GridListControlHelper.InitializeGridListControl <ItemJualProduk>(grid, _listOfItemJual, gridListProperties); grid.PushButtonClick += delegate(object sender, GridCellPushButtonClickEventArgs e) { if (e.ColIndex == 8) { if (grid.RowCount == 1) { MsgHelper.MsgWarning("Minimal 1 item produk harus diinputkan !"); return; } if (MsgHelper.MsgDelete()) { var itemJual = _listOfItemJual[e.RowIndex - 1]; itemJual.entity_state = EntityState.Deleted; _listOfItemJualDeleted.Add(itemJual); _listOfItemJual.Remove(itemJual); grid.RowCount = _listOfItemJual.Count(); grid.Refresh(); RefreshTotal(); } } }; grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { // Make sure the cell falls inside the grid if (e.RowIndex > 0) { if (!(_listOfItemJual.Count > 0)) { return; } var itemJual = _listOfItemJual[e.RowIndex - 1]; var produk = itemJual.Produk; if (e.RowIndex % 2 == 0) { e.Style.BackColor = ColorCollection.BACK_COLOR_ALTERNATE; } double hargaBeli = 0; double hargaJual = 0; double jumlah = 0; var isRetur = itemJual.jumlah_retur > 0; if (isRetur) { e.Style.BackColor = Color.Red; e.Style.Enabled = false; } switch (e.ColIndex) { case 1: // no urut e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.Enabled = false; e.Style.CellValue = e.RowIndex.ToString(); break; case 2: if (produk != null) { e.Style.CellValue = produk.kode_produk; } break; case 3: // nama produk if (produk != null) { e.Style.CellValue = produk.nama_produk; } break; case 4: // jumlah e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = itemJual.jumlah - itemJual.jumlah_retur; break; case 5: // diskon e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = itemJual.diskon; break; case 6: // harga e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; hargaBeli = itemJual.harga_beli; hargaJual = itemJual.harga_jual; if (produk != null) { if (!(hargaBeli > 0)) { hargaBeli = produk.harga_beli; } if (!(hargaJual > 0)) { hargaJual = produk.harga_jual; } } e.Style.CellValue = NumberHelper.NumberToString(hargaJual); break; case 7: // subtotal e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.Enabled = false; jumlah = itemJual.jumlah - itemJual.jumlah_retur; hargaBeli = itemJual.harga_beli; hargaJual = itemJual.harga_setelah_diskon; if (produk != null) { if (!(hargaBeli > 0)) { hargaBeli = produk.harga_beli; } if (!(hargaJual > 0)) { double diskon = itemJual.diskon; double diskonRupiah = 0; if (!(diskon > 0)) { diskon = produk.diskon > 0 ? produk.diskon : produk.Golongan.diskon; } diskonRupiah = diskon / 100 * produk.harga_jual; hargaJual = produk.harga_jual - diskonRupiah; } } e.Style.CellValue = NumberHelper.NumberToString(jumlah * hargaJual); break; case 8: // button hapus e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellType = GridCellTypeName.PushButton; e.Style.Description = "Hapus"; break; default: break; } e.Handled = true; // we handled it, let the grid know } }; var colIndex = 2; // kolom nama produk grid.CurrentCell.MoveTo(1, colIndex, GridSetCurrentCellOptions.BeginEndUpdate); }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Produk", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Penambahan", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Penambahan", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Pengurangan", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Pengurangan", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Alasan Penyesuaian", Width = 350 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan" }); GridListControlHelper.InitializeGridListControl <PenyesuaianStok>(this.gridList, _listOfPenyesuaianStok, gridListProperties, false, additionalRowCount: 1); this.gridList.Grid.Model.RowHeights[1] = 25; this.gridList.Grid.Model.Rows.FrozenCount = 1; this.gridList.Grid.PrepareViewStyleInfo += delegate(object sender, GridPrepareViewStyleInfoEventArgs e) { var subHeaderHargaJual = new string[] { "Stok Etalase", "Stok Gudang", "Stok Etalase", "Stok Gudang" }; if (e.ColIndex > 3 && e.RowIndex == 1) { var colIndex = 4; foreach (var header in subHeaderHargaJual) { if (colIndex == e.ColIndex) { e.Style.Text = header; } colIndex++; } } }; if (_listOfPenyesuaianStok.Count > 0) { this.gridList.SetSelected(1, true); } // merge cell var column = 1; // kolom no this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 2; // tanggal this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 3; // produk this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 4; // kolom penambahan stok etalase dan gudang this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 0, column + 1)); column = 6; // kolom pengurangan stok etalase dan gudang this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 0, column + 1)); column = 8; // alasan penyesuaian this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 9; // keterangan this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); var headerStyle = this.gridList.Grid.BaseStylesMap["Column Header"].StyleInfo; headerStyle.CellType = GridCellTypeName.Header; this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (e.RowIndex == 1) { if (e.ColIndex > 3) { e.Style.ModifyStyle(headerStyle, StyleModifyType.ApplyNew); } // we handled it, let the grid know e.Handled = true; } if (_listOfPenyesuaianStok.Count > 0) { if (e.RowIndex > 1) { var rowIndex = e.RowIndex - 2; if (rowIndex < _listOfPenyesuaianStok.Count) { var penyesuaianStok = _listOfPenyesuaianStok[rowIndex]; switch (e.ColIndex) { case 1: e.Style.CellValue = e.RowIndex - 1; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(penyesuaianStok.tanggal); break; case 3: e.Style.CellValue = penyesuaianStok.Produk.nama_produk; break; case 4: e.Style.CellValue = penyesuaianStok.penambahan_stok; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 5: e.Style.CellValue = penyesuaianStok.penambahan_stok_gudang; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 6: e.Style.CellValue = penyesuaianStok.pengurangan_stok; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 7: e.Style.CellValue = penyesuaianStok.pengurangan_stok_gudang; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 8: e.Style.CellValue = penyesuaianStok.AlasanPenyesuaianStok.alasan; break; case 9: e.Style.CellValue = penyesuaianStok.keterangan; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat", Width = 300 }); gridListProperties.Add(new GridListControlProperties { Header = "Kontak", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Telepon", Width = 130 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Hutang", Width = 100 }); GridListControlHelper.InitializeGridListControl <Supplier>(this.gridList, _listOfSupplier, gridListProperties); if (_listOfSupplier.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfSupplier.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfSupplier.Count) { var supplier = _listOfSupplier[rowIndex]; switch (e.ColIndex) { case 2: e.Style.CellValue = supplier.nama_supplier; break; case 3: e.Style.CellValue = supplier.alamat; break; case 4: e.Style.CellValue = supplier.kontak; break; case 5: e.Style.CellValue = supplier.telepon; break; case 6: e.Style.CellValue = NumberHelper.NumberToString(supplier.total_hutang - supplier.total_pembayaran_hutang); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridListHistoriPembayaran() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Jumlah", Width = 90 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan" }); GridListControlHelper.InitializeGridListControl <PembayaranKasbon>(this.gridListHistoriPembayaran, _listOfHistoriPembayaranKasbon, gridListProperties); if (_listOfHistoriPembayaranKasbon.Count > 0) { this.gridListHistoriPembayaran.SetSelected(0, true); } this.gridListHistoriPembayaran.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfHistoriPembayaranKasbon.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfHistoriPembayaranKasbon.Count) { var pembayaranKasbon = _listOfHistoriPembayaranKasbon[rowIndex]; switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(pembayaranKasbon.tanggal); break; case 3: e.Style.CellValue = pembayaranKasbon.nota; break; case 4: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(pembayaranKasbon.nominal); break; case 5: e.Style.CellValue = pembayaranKasbon.keterangan; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; this.gridListHistoriPembayaran.SelectedValueChanged += delegate(object sender, EventArgs e) { GridListHistoriPembayaranHandleSelectionChanged((GridListControl)sender); }; this.gridListHistoriPembayaran.DoubleClick += delegate(object sender, EventArgs e) { if (btnPerbaikiPembayaran.Enabled) { btnPerbaikiPembayaran_Click(sender, e); } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Tempo", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Supplier", Width = 300 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan", Width = 300 }); gridListProperties.Add(new GridListControlProperties { Header = "Hutang", Width = 140 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Hutang", Width = 140 }); gridListProperties.Add(new GridListControlProperties { Header = "Histori Pembayaran" }); GridListControlHelper.InitializeGridListControl <BeliProduk>(this.gridList, _listOfBeli, gridListProperties, false); if (_listOfBeli.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.PushButtonClick += delegate(object sender, GridCellPushButtonClickEventArgs e) { if (e.RowIndex > 0) { var index = e.RowIndex - 1; switch (e.ColIndex) { case 9: // histori pembayaran using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0))) { var beli = _listOfBeli[index]; IPembayaranHutangProdukBll bll = new PembayaranHutangProdukBll(_log); var listOfHistoriPembayaran = bll.GetHistoriPembayaran(beli.beli_produk_id); if (listOfHistoriPembayaran.Count > 0) { var frmHistoriPembayaran = new FrmLookupHistoriPembayaran("Histori Pembayaran Hutang", beli, listOfHistoriPembayaran); frmHistoriPembayaran.ShowDialog(); } else { MsgHelper.MsgInfo("Belum ada informasi histori pembayaran"); } } break; default: break; } } }; this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfBeli.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfBeli.Count) { double totalNota = 0; var beli = _listOfBeli[rowIndex]; if (beli != null) { totalNota = beli.grand_total; } var isRetur = beli.retur_beli_produk_id != null; if (isRetur) { e.Style.BackColor = Color.Red; } switch (e.ColIndex) { case 1: var noUrut = (_pageNumber - 1) * _pageSize + e.RowIndex; e.Style.CellValue = noUrut; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(beli.tanggal); break; case 3: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(beli.tanggal_tempo); break; case 4: e.Style.CellValue = beli.nota; break; case 5: if (beli.Supplier != null) { e.Style.CellValue = beli.Supplier.nama_supplier; } break; case 6: e.Style.CellValue = beli.keterangan; break; case 7: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota); break; case 8: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota - beli.total_pelunasan); break; case 9: // button history pembayaran e.Style.Enabled = beli.tanggal_tempo != null; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellType = GridCellTypeName.PushButton; e.Style.Description = "Cek Histori"; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Tempo", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Customer", Width = _pengaturanUmum.jenis_printer == JenisPrinter.InkJet ? 180 : 260 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan", Width = 350 }); gridListProperties.Add(new GridListControlProperties { Header = "Piutang", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Piutang", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Histori Pembayaran", Width = 80 }); if (_pengaturanUmum.jenis_printer == JenisPrinter.InkJet) { gridListProperties.Add(new GridListControlProperties { Header = "Cetak Nota/Label", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "" }); } else { gridListProperties.Add(new GridListControlProperties { Header = "Cetak Nota", Width = 80 }); } GridListControlHelper.InitializeGridListControl <JualProduk>(this.gridList, _listOfJual, gridListProperties, false, rowHeight: 40); if (_pengaturanUmum.jenis_printer == JenisPrinter.InkJet) { // merge header kolom cetak nota/label this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, 10, 0, 11)); } if (_listOfJual.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.PushButtonClick += delegate(object sender, GridCellPushButtonClickEventArgs e) { if (e.RowIndex > 0) { var index = e.RowIndex - 1; switch (e.ColIndex) { case 9: // histori pembayaran using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0))) { var jual = _listOfJual[index]; IPembayaranPiutangProdukBll bll = new PembayaranPiutangProdukBll(_log); var listOfHistoriPembayaran = bll.GetHistoriPembayaran(jual.jual_id); if (listOfHistoriPembayaran.Count > 0) { var frmHistoriPembayaran = new FrmLookupHistoriPembayaran("Histori Pembayaran Piutang", jual, listOfHistoriPembayaran); frmHistoriPembayaran.ShowDialog(); } else { MsgHelper.MsgInfo("Belum ada informasi histori pembayaran"); } } break; case 10: // cetak nota jual using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0))) { var jual = _listOfJual[index]; switch (this._pengaturanUmum.jenis_printer) { case JenisPrinter.DotMatrix: if (MsgHelper.MsgKonfirmasi("Apakah proses pencetakan ingin dilanjutkan ?")) { CetakNotaDotMatrix(jual); } break; case JenisPrinter.MiniPOS: if (MsgHelper.MsgKonfirmasi("Apakah proses pencetakan ingin dilanjutkan ?")) { CetakNotaMiniPOS(jual); } break; default: var frmCetakNota = new FrmPreviewNotaPenjualan("Preview Nota Penjualan", jual); frmCetakNota.ShowDialog(); break; } } break; case 11: // cetak label nota jual using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0))) { var jual = _listOfJual[index]; var frmCetakLabelNota = new FrmPreviewLabelNotaPenjualan("Preview Label Nota Penjualan", jual); frmCetakLabelNota.ShowDialog(); } break; default: break; } } }; this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfJual.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfJual.Count) { double totalNota = 0; var jual = _listOfJual[rowIndex]; if (jual != null) { totalNota = jual.grand_total; } var isRetur = jual.retur_jual_id != null; var oldStyleBackColor = e.Style.BackColor; if (isRetur) { e.Style.BackColor = Color.Red; } switch (e.ColIndex) { case 1: var noUrut = (_pageNumber - 1) * _pageSize + e.RowIndex; e.Style.CellValue = noUrut; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(jual.tanggal); break; case 3: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(jual.tanggal_tempo); break; case 4: e.Style.CellValue = jual.nota; break; case 5: if (jual.Customer != null) { SetWilayahCustomer(jual.Customer); e.Style.CellValue = jual.Customer.nama_customer; } break; case 6: e.Style.CellValue = jual.keterangan; break; case 7: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota); break; case 8: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota - jual.total_pelunasan); break; case 9: // button history pembayaran e.Style.Enabled = jual.tanggal_tempo != null; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellType = GridCellTypeName.PushButton; e.Style.BackColor = oldStyleBackColor; e.Style.Description = "Cek Histori"; break; case 10: // button cetak nota e.Style.Enabled = jual.Customer != null; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellType = GridCellTypeName.PushButton; e.Style.BackColor = oldStyleBackColor; e.Style.Description = "Cetak Nota"; break; case 11: // button cetak label nota if (_pengaturanUmum.jenis_printer == JenisPrinter.InkJet) { e.Style.Enabled = jual.Customer != null; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellType = GridCellTypeName.PushButton; e.Style.BackColor = oldStyleBackColor; e.Style.Description = "Cetak Label Nota"; } break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Kode Produk", Width = 130 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama Produk", Width = 540 }); gridListProperties.Add(new GridListControlProperties { Header = "Satuan", Width = 130 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga Beli", Width = 110 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga Jual", Width = 110 }); gridListProperties.Add(new GridListControlProperties { Header = "Stok Etalase", Width = 90 }); gridListProperties.Add(new GridListControlProperties { Header = "Stok Gudang", Width = 90 }); gridListProperties.Add(new GridListControlProperties { Header = "Min. Stok Gudang", Width = 110 }); GridListControlHelper.InitializeGridListControl <Produk>(this.gridList, _listOfProduk, gridListProperties); if (_listOfProduk.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfProduk.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfProduk.Count) { var produk = _listOfProduk[rowIndex]; switch (e.ColIndex) { case 2: e.Style.CellValue = produk.kode_produk; break; case 3: e.Style.CellValue = produk.nama_produk; break; case 4: var satuan = string.Empty; if (produk.satuan.Length > 0) { satuan = produk.satuan; } e.Style.CellValue = satuan; break; case 5: e.Style.CellValue = NumberHelper.NumberToString(produk.harga_beli); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; case 6: e.Style.CellValue = NumberHelper.NumberToString(produk.harga_jual); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; case 7: e.Style.CellValue = produk.stok; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 8: e.Style.CellValue = produk.stok_gudang; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 9: e.Style.CellValue = produk.minimal_stok_gudang; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 80, HorizontalAlignment = GridHorizontalAlignment.Center }); gridListProperties.Add(new GridListControlProperties { Header = "Tempo", Width = 80, HorizontalAlignment = GridHorizontalAlignment.Center }); if (this._referensiType == ReferencesType.NotaJualProduk) { gridListProperties.Add(new GridListControlProperties { Header = "Nota Jual", Width = 90, HorizontalAlignment = GridHorizontalAlignment.Center }); gridListProperties.Add(new GridListControlProperties { Header = "Customer", Width = 170 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Piutang", HorizontalAlignment = GridHorizontalAlignment.Right }); } else { gridListProperties.Add(new GridListControlProperties { Header = "Nota Beli", Width = 90, HorizontalAlignment = GridHorizontalAlignment.Center }); gridListProperties.Add(new GridListControlProperties { Header = "Supplier", Width = 170 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Hutang", HorizontalAlignment = GridHorizontalAlignment.Right }); } var listCount = 0; switch (this._referensiType) { case ReferencesType.NotaBeliProduk: GridListControlHelper.InitializeGridListControl <BeliProduk>(this.gridList, _listOfNotaBeliProduk, gridListProperties); this.gridList.Grid.QueryCellInfo += GridNotaBeliProduk_QueryCellInfo; listCount = _listOfNotaBeliProduk.Count; break; case ReferencesType.NotaJualProduk: GridListControlHelper.InitializeGridListControl <JualProduk>(this.gridList, _listOfNotaJualProduk, gridListProperties); this.gridList.Grid.QueryCellInfo += GridNotaJualProduk_QueryCellInfo; listCount = _listOfNotaJualProduk.Count; break; default: break; } if (listCount > 0) { this.gridList.SetSelected(0, true); } }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Kode Produk", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama Produk", Width = 270 }); gridListProperties.Add(new GridListControlProperties { Header = "Jumlah", Width = 50 }); gridListProperties.Add(new GridListControlProperties { Header = "Diskon", Width = 50 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga", Width = 75 }); gridListProperties.Add(new GridListControlProperties { Header = "Sub Total", Width = 100 }); var listOfItemJual = _jual.item_jual; GridListControlHelper.InitializeGridListControl <ItemJualProduk>(this.gridList, listOfItemJual, gridListProperties); if (listOfItemJual.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (listOfItemJual.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < listOfItemJual.Count) { var itemJual = listOfItemJual[rowIndex]; var produk = itemJual.Produk; switch (e.ColIndex) { case 2: if (produk != null) { e.Style.CellValue = produk.kode_produk; } break; case 3: // nama produk if (produk != null) { e.Style.CellValue = produk.nama_produk; } break; case 4: // jumlah e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = itemJual.jumlah - itemJual.jumlah_retur; break; case 5: // diskon e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = itemJual.diskon; break; case 6: // harga e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(itemJual.harga_jual); break; case 7: // subtotal e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; var jumlah = itemJual.jumlah - itemJual.jumlah_retur; e.Style.CellValue = NumberHelper.NumberToString(jumlah * itemJual.harga_setelah_diskon); break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGrid() { var glProp = new List <GridListControlProperties>(); glProp.Add(new GridListControlProperties { Header = "No", Width = 30 }); glProp.Add(new GridListControlProperties { Header = "User Name", Width = 300 }); glProp.Add(new GridListControlProperties { Header = "First Name", Width = 300 }); glProp.Add(new GridListControlProperties { Header = "Last Name", Width = 300 }); glProp.Add(new GridListControlProperties { Header = "Roles", Width = 200 }); GridListControlHelper.InitializeGridListControl <User>(grdLstUser, _lstUser, glProp); if (_lstUser.Count > 0) { this.grdLstUser.SetSelected(0, true); } grdLstUser.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_lstUser.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _lstUser.Count) { var users = _lstUser[rowIndex]; switch (e.ColIndex) { case 2: e.Style.CellValue = users.userId; break; case 3: e.Style.CellValue = users.firstName; break; case 4: e.Style.CellValue = users.lastName; break; case 5: e.Style.CellValue = users.roles; break; default: break; } } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Tempo", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Customer", Width = 230 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan", Width = 350 }); gridListProperties.Add(new GridListControlProperties { Header = "Piutang", Width = 130 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Piutang", Width = 130 }); gridListProperties.Add(new GridListControlProperties { Header = "Cetak Nota/Label", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "" }); GridListControlHelper.InitializeGridListControl <JualProduk>(this.gridList, _listOfJual, gridListProperties); // merge header kolom cetak nota/label this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, 9, 0, 10)); if (_listOfJual.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.PushButtonClick += delegate(object sender, GridCellPushButtonClickEventArgs e) { if (e.RowIndex > 0) { var index = e.RowIndex - 1; switch (e.ColIndex) { case 9: // cetak nota jual using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0))) { var jual = _listOfJual[index]; if (this._pengaturanUmum.is_printer_mini_pos) { if (MsgHelper.MsgKonfirmasi("Apakah proses pencetakan ingin dilanjutkan ?")) { CetakNotaMiniPOS(jual); } } else { var frmCetakNota = new FrmPreviewNotaPenjualan("Preview Nota Penjualan", jual); frmCetakNota.ShowDialog(); } } break; case 10: // cetak label nota jual using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0))) { var jual = _listOfJual[index]; var frmCetakLabelNota = new FrmPreviewLabelNotaPenjualan("Preview Label Nota Penjualan", jual); frmCetakLabelNota.ShowDialog(); } break; default: break; } } }; this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfJual.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfJual.Count) { double totalNota = 0; var jual = _listOfJual[rowIndex]; if (jual != null) { totalNota = jual.grand_total; } var isRetur = jual.retur_jual_id != null; var oldStyleBackColor = e.Style.BackColor; if (isRetur) { e.Style.BackColor = Color.Red; } switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(jual.tanggal); break; case 3: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(jual.tanggal_tempo); break; case 4: e.Style.CellValue = jual.nota; break; case 5: if (jual.Customer != null) { e.Style.CellValue = jual.Customer.nama_customer; } break; case 6: e.Style.CellValue = jual.keterangan; break; case 7: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota); break; case 8: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota - jual.total_pelunasan); break; case 9: // button hapus e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellType = GridCellTypeName.PushButton; e.Style.BackColor = oldStyleBackColor; e.Style.Description = "Cetak Nota"; break; case 10: // button hapus e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellType = GridCellTypeName.PushButton; e.Style.BackColor = oldStyleBackColor; e.Style.Description = "Cetak Label Nota"; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); var listCount = 0; switch (this._referensiType) { case ReferencesType.Customer: gridListProperties.Add(new GridListControlProperties { Header = "Nama Customer", Width = 200 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat" }); GridListControlHelper.InitializeGridListControl <Customer>(this.gridList, _listOfCustomer, gridListProperties); this.gridList.Grid.QueryCellInfo += GridCustomer_QueryCellInfo; listCount = _listOfCustomer.Count; break; case ReferencesType.Supplier: gridListProperties.Add(new GridListControlProperties { Header = "Nama Supplier", Width = 200 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat" }); GridListControlHelper.InitializeGridListControl <Supplier>(this.gridList, _listOfSupplier, gridListProperties); this.gridList.Grid.QueryCellInfo += GridSupplier_QueryCellInfo; listCount = _listOfSupplier.Count; break; case ReferencesType.Produk: gridListProperties.Add(new GridListControlProperties { Header = "Kode Produk", Width = 120 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama Produk" }); GridListControlHelper.InitializeGridListControl <Produk>(this.gridList, _listOfProduk, gridListProperties); this.gridList.Grid.QueryCellInfo += GridProduk_QueryCellInfo; listCount = _listOfProduk.Count; break; default: break; } if (listCount > 0) { this.gridList.SetSelected(0, true); } }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 90 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota", Width = 90 }); gridListProperties.Add(new GridListControlProperties { Header = "Karyawan", Width = 230 }); gridListProperties.Add(new GridListControlProperties { Header = "Jumlah", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan" }); GridListControlHelper.InitializeGridListControl <Kasbon>(this.gridList, _listOfKasbon, gridListProperties); if (_listOfKasbon.Count > 0) { this.gridList.SetSelected(0, true); GridListHandleSelectionChanged(this.gridList); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfKasbon.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfKasbon.Count) { var kasbon = _listOfKasbon[rowIndex]; switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(kasbon.tanggal); break; case 3: e.Style.CellValue = kasbon.nota; break; case 4: var karyawan = kasbon.Karyawan; if (karyawan != null) { e.Style.CellValue = kasbon.Karyawan.nama_karyawan; } break; case 5: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(kasbon.nominal); break; case 6: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(kasbon.sisa); break; case 7: e.Style.CellValue = kasbon.keterangan; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; this.gridList.SelectedValueChanged += delegate(object sender, EventArgs e) { GridListHandleSelectionChanged((GridListControl)sender); }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 50 }); var listCount = 0; this.gridList.Grid.QueryRowHeight += delegate(object sender, GridRowColSizeEventArgs e) { e.Size = 27; e.Handled = true; }; switch (this._referensiType) { case ReferencesType.Customer: gridListProperties.Add(new GridListControlProperties { Header = "Nama Customer", Width = 400 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat" }); GridListControlHelper.InitializeGridListControl <Customer>(this.gridList, _listOfCustomer, gridListProperties); this.gridList.Grid.QueryCellInfo += GridCustomer_QueryCellInfo; listCount = _listOfCustomer.Count; break; case ReferencesType.Produk: gridListProperties.Add(new GridListControlProperties { Header = "Kode Produk", Width = 150 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama Produk", Width = 400 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga", Width = 120 }); gridListProperties.Add(new GridListControlProperties { Header = "Stok", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Golongan" }); GridListControlHelper.InitializeGridListControl <Produk>(this.gridList, _listOfProduk, gridListProperties); this.gridList.Grid.QueryCellInfo += GridProduk_QueryCellInfo; listCount = _listOfProduk.Count; break; default: break; } if (listCount > 0) { this.gridList.SetSelected(0, true); } }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota Retur", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota Jual", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Customer", Width = 400 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan", Width = 500 }); gridListProperties.Add(new GridListControlProperties { Header = "Total", Width = 150 }); GridListControlHelper.InitializeGridListControl <ReturJualProduk>(this.gridList, _listOfRetur, gridListProperties); if (_listOfRetur.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfRetur.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfRetur.Count) { double totalNota = 0; var retur = _listOfRetur[rowIndex]; if (retur != null) { totalNota = retur.total_nota; } switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(retur.tanggal); break; case 3: e.Style.CellValue = retur.nota; break; case 4: var jual = retur.JualProduk; if (jual != null) { e.Style.CellValue = jual.nota; } break; case 5: if (retur.Customer != null) { e.Style.CellValue = retur.Customer.nama_customer; } break; case 6: e.Style.CellValue = retur.keterangan; break; case 7: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota); break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama", Width = 150 }); gridListProperties.Add(new GridListControlProperties { Header = "Provinsi", Width = 120 }); gridListProperties.Add(new GridListControlProperties { Header = "Kabupaten", Width = 140 }); gridListProperties.Add(new GridListControlProperties { Header = "Kecamatan", Width = 140 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Kode Pos", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Kontak", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Telepon", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Diskon", Width = 50 }); gridListProperties.Add(new GridListControlProperties { Header = "Plafon Piutang", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Piutang" }); GridListControlHelper.InitializeGridListControl <Customer>(this.gridList, _listOfCustomer, gridListProperties); if (_listOfCustomer.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfCustomer.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfCustomer.Count) { var customer = _listOfCustomer[rowIndex]; switch (e.ColIndex) { case 2: e.Style.CellValue = customer.nama_customer; break; case 3: e.Style.CellValue = customer.Provinsi != null ? customer.Provinsi.nama_provinsi : string.Empty; break; case 4: e.Style.CellValue = customer.Kabupaten != null ? customer.Kabupaten.nama_kabupaten : customer.kabupaten_old.NullToString(); break; case 5: e.Style.CellValue = customer.Kecamatan != null ? customer.Kecamatan.nama_kecamatan : customer.kecamatan_old.NullToString(); break; case 6: e.Style.CellValue = customer.alamat; break; case 7: e.Style.CellValue = customer.kode_pos; break; case 8: e.Style.CellValue = customer.kontak; break; case 9: e.Style.CellValue = customer.telepon; break; case 10: e.Style.CellValue = customer.diskon; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 11: e.Style.CellValue = NumberHelper.NumberToString(customer.plafon_piutang); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; case 12: e.Style.CellValue = NumberHelper.NumberToString(customer.total_piutang - customer.total_pembayaran_piutang); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan", Width = 500 }); gridListProperties.Add(new GridListControlProperties { Header = "Total" }); GridListControlHelper.InitializeGridListControl <PengeluaranBiaya>(this.gridList, _listOfPengeluaran, gridListProperties); if (_listOfPengeluaran.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfPengeluaran.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfPengeluaran.Count) { var pengeluaran = _listOfPengeluaran[rowIndex]; switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(pengeluaran.tanggal); break; case 3: e.Style.CellValue = pengeluaran.nota; break; case 4: e.Style.CellValue = pengeluaran.keterangan; break; case 5: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(pengeluaran.total); break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota Pembayaran", Width = 120 }); gridListProperties.Add(new GridListControlProperties { Header = "Customer", Width = 300 }); gridListProperties.Add(new GridListControlProperties { Header = "Pembayaran", Width = 150 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan" }); GridListControlHelper.InitializeGridListControl <PembayaranPiutangProduk>(this.gridList, _listOfPembayaranPiutang, gridListProperties); if (_listOfPembayaranPiutang.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfPembayaranPiutang.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfPembayaranPiutang.Count) { var pembayaran = _listOfPembayaranPiutang[rowIndex]; switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(pembayaran.tanggal); break; case 3: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = pembayaran.nota; break; case 4: var customer = pembayaran.Customer; if (customer != null) { e.Style.CellValue = customer.nama_customer; } break; case 5: var total = pembayaran.item_pembayaran_piutang.Sum(f => f.nominal); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(total); break; case 6: e.Style.CellValue = pembayaran.keterangan; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Golongan", Width = 130 }); gridListProperties.Add(new GridListControlProperties { Header = "Kode Produk", Width = 130 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama Produk", Width = 350 }); gridListProperties.Add(new GridListControlProperties { Header = "Satuan", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga Beli", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga Jual", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga Jual", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga Jual", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga Jual", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Diskon", Width = 50 }); gridListProperties.Add(new GridListControlProperties { Header = "Stok Etalase", Width = 60 }); gridListProperties.Add(new GridListControlProperties { Header = "Stok Gudang", Width = 60 }); gridListProperties.Add(new GridListControlProperties { Header = "Min. Stok Gudang" }); GridListControlHelper.InitializeGridListControl <Produk>(this.gridList, _listOfProduk, gridListProperties, false, additionalRowCount: 1); this.gridList.Grid.Model.RowHeights[1] = 25; this.gridList.Grid.Model.Rows.FrozenCount = 1; this.gridList.Grid.PrepareViewStyleInfo += delegate(object sender, GridPrepareViewStyleInfoEventArgs e) { var subHeaderHargaJual = new string[] { "Retail", "Grosir 1", "Grosir 2", "Grosir 3" }; if (e.ColIndex > 6 && e.RowIndex == 1) { var colIndex = 7; foreach (var header in subHeaderHargaJual) { if (colIndex == e.ColIndex) { e.Style.Text = header; } colIndex++; } } }; if (_listOfProduk.Count > 0) { this.gridList.SetSelected(1, true); } // merge cell var column = 1; // kolom no this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 2; // kolom golongan this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 3; // kolom kode this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 4; // kolom nama produk this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 5; // kolom satuan this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 6; // kolom harga beli this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 7; // kolom harga jual this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 0, column + 3)); column = 11; // kolom diskon this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 12; // kolom stok etalase this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 13; // kolom stok gudang this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); column = 14; // kolom minimal stok this.gridList.Grid.CoveredRanges.Add(GridRangeInfo.Cells(0, column, 1, column)); var headerStyle = this.gridList.Grid.BaseStylesMap["Column Header"].StyleInfo; headerStyle.CellType = GridCellTypeName.Header; this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (e.RowIndex == 1) { if (e.ColIndex > 6) { e.Style.ModifyStyle(headerStyle, StyleModifyType.ApplyNew); } // we handled it, let the grid know e.Handled = true; } if (_listOfProduk.Count > 0) { if (e.RowIndex > 1) { var rowIndex = e.RowIndex - 2; if (rowIndex < _listOfProduk.Count) { var produk = _listOfProduk[rowIndex]; var listOfHargaGrosir = produk.list_of_harga_grosir; var hargaGrosir = 0d; switch (e.ColIndex) { case 1: var noUrut = (_pageNumber - 1) * _pageSize + e.RowIndex - 1; e.Style.CellValue = noUrut; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 2: if (produk.Golongan != null) { e.Style.CellValue = produk.Golongan.nama_golongan; } break; case 3: e.Style.CellValue = produk.kode_produk; break; case 4: e.Style.CellValue = produk.nama_produk; break; case 5: var satuan = string.Empty; if (produk.satuan.Length > 0) { satuan = produk.satuan; } e.Style.CellValue = satuan; break; case 6: e.Style.CellValue = NumberHelper.NumberToString(produk.harga_beli); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; case 7: // harga jual ritel e.Style.CellValue = NumberHelper.NumberToString(produk.harga_jual); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; case 8: // harga grosir 1 hargaGrosir = listOfHargaGrosir.Count > 0 ? listOfHargaGrosir[0].harga_grosir : 0; e.Style.CellValue = NumberHelper.NumberToString(hargaGrosir); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; case 9: // harga grosir 2 hargaGrosir = listOfHargaGrosir.Count > 1 ? listOfHargaGrosir[1].harga_grosir : 0; e.Style.CellValue = NumberHelper.NumberToString(hargaGrosir); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; case 10: // harga grosir 3 hargaGrosir = listOfHargaGrosir.Count > 2 ? listOfHargaGrosir[2].harga_grosir : 0; e.Style.CellValue = NumberHelper.NumberToString(hargaGrosir); e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; break; case 11: e.Style.CellValue = produk.diskon; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 12: e.Style.CellValue = produk.stok; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 13: e.Style.CellValue = produk.stok_gudang; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 14: e.Style.CellValue = produk.minimal_stok_gudang; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Tempo", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Customer", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan", Width = 450 }); gridListProperties.Add(new GridListControlProperties { Header = "Piutang", Width = 150 }); gridListProperties.Add(new GridListControlProperties { Header = "Sisa Piutang" }); GridListControlHelper.InitializeGridListControl <JualProduk>(this.gridList, _listOfJual, gridListProperties); if (_listOfJual.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfJual.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfJual.Count) { double totalNota = 0; var jual = _listOfJual[rowIndex]; if (jual != null) { totalNota = jual.grand_total; } var isRetur = jual.retur_jual_id != null; if (isRetur) { e.Style.BackColor = Color.Red; } switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(jual.tanggal); break; case 3: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(jual.tanggal_tempo); break; case 4: e.Style.CellValue = jual.nota; break; case 5: if (jual.Customer != null) { e.Style.CellValue = jual.Customer.nama_customer; } break; case 6: e.Style.CellValue = jual.keterangan; break; case 7: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota); break; case 8: e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.CellValue = NumberHelper.NumberToString(totalNota - jual.total_pelunasan); break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridControl(GridControl grid) { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Kode Produk", Width = 190 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama Produk", Width = _pengaturanUmum.is_tampilkan_keterangan_tambahan_item_jual ? 520 : 720 } ); gridListProperties.Add(new GridListControlProperties { Header = _pengaturanUmum.keterangan_tambahan_item_jual, Width = _pengaturanUmum.is_tampilkan_keterangan_tambahan_item_jual ? 200 : 0 } ); gridListProperties.Add(new GridListControlProperties { Header = "Jumlah", Width = 75 }); gridListProperties.Add(new GridListControlProperties { Header = "Diskon", Width = 75 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga", Width = 120 }); gridListProperties.Add(new GridListControlProperties { Header = "Sub Total" }); GridListControlHelper.InitializeGridListControl <ItemJualProduk>(grid, _listOfItemJual, gridListProperties); grid.QueryRowHeight += delegate(object sender, GridRowColSizeEventArgs e) { e.Size = 27; e.Handled = true; }; grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { // Make sure the cell falls inside the grid if (e.RowIndex > 0) { if (!(_listOfItemJual.Count > 0)) { return; } var itemJual = _listOfItemJual[e.RowIndex - 1]; var produk = itemJual.Produk; if (e.RowIndex % 2 == 0) { e.Style.BackColor = ColorCollection.BACK_COLOR_ALTERNATE; } double hargaBeli = 0; double hargaJual = 0; double jumlah = 0; var isRetur = itemJual.jumlah_retur > 0; if (isRetur) { e.Style.BackColor = Color.Red; e.Style.Enabled = false; } e.Style.Font = new GridFontInfo(new Font("Arial", 15f)); switch (e.ColIndex) { case 1: // no urut e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.Enabled = false; e.Style.CellValue = e.RowIndex.ToString(); break; case 2: if (produk != null) { e.Style.CellValue = produk.kode_produk; } break; case 3: // nama produk if (produk != null) { e.Style.CellValue = produk.nama_produk; } break; case 4: // keterangan e.Style.CellValue = itemJual.keterangan; break; case 5: // jumlah e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = itemJual.jumlah - itemJual.jumlah_retur; break; case 6: // diskon e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = itemJual.diskon; break; case 7: // harga e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; hargaBeli = itemJual.harga_beli; hargaJual = itemJual.harga_jual; if (produk != null) { if (!(hargaBeli > 0)) { hargaBeli = produk.harga_beli; } if (!(hargaJual > 0)) { jumlah = itemJual.jumlah - itemJual.jumlah_retur; hargaJual = GetHargaJualFix(produk, jumlah, produk.harga_jual); } } e.Style.CellValue = NumberHelper.NumberToString(hargaJual); break; case 8: // subtotal e.Style.HorizontalAlignment = GridHorizontalAlignment.Right; e.Style.Enabled = false; jumlah = itemJual.jumlah - itemJual.jumlah_retur; hargaBeli = itemJual.harga_beli; hargaJual = itemJual.harga_setelah_diskon; if (produk != null) { if (!(hargaBeli > 0)) { hargaBeli = produk.harga_beli; } if (!(hargaJual > 0)) { double diskon = itemJual.diskon; double diskonRupiah = 0; if (!(diskon > 0)) { if (_customer != null) { diskon = _customer.diskon; } if (!(diskon > 0)) { var diskonProduk = GetDiskonJualFix(produk, jumlah, produk.diskon); diskon = diskonProduk > 0 ? diskonProduk : produk.Golongan.diskon; } } hargaJual = GetHargaJualFix(produk, jumlah, produk.harga_jual); diskonRupiah = diskon / 100 * hargaJual; hargaJual -= diskonRupiah; } } e.Style.CellValue = NumberHelper.NumberToString(jumlah * hargaJual); break; default: break; } e.Handled = true; // we handled it, let the grid know } }; var colIndex = 2; // kolom nama produk grid.CurrentCell.MoveTo(1, colIndex, GridSetCurrentCellOptions.BeginEndUpdate); }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Tanggal", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Produk", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Penambahan Stok Etalase", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Penambahan Stok Gudang", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Pengurangan Stok Etalase", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Pengurangan Stok Gudang", Width = 80 }); gridListProperties.Add(new GridListControlProperties { Header = "Alasan Penyesuaian", Width = 350 }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan" }); GridListControlHelper.InitializeGridListControl <PenyesuaianStok>(this.gridList, _listOfPenyesuaianStok, gridListProperties, rowHeight: 35); if (_listOfPenyesuaianStok.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfPenyesuaianStok.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfPenyesuaianStok.Count) { var penyesuaianStok = _listOfPenyesuaianStok[rowIndex]; switch (e.ColIndex) { case 2: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = DateTimeHelper.DateToString(penyesuaianStok.tanggal); break; case 3: e.Style.CellValue = penyesuaianStok.Produk.nama_produk; break; case 4: e.Style.CellValue = penyesuaianStok.penambahan_stok; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 5: e.Style.CellValue = penyesuaianStok.penambahan_stok_gudang; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 6: e.Style.CellValue = penyesuaianStok.pengurangan_stok; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 7: e.Style.CellValue = penyesuaianStok.pengurangan_stok_gudang; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; break; case 8: e.Style.CellValue = penyesuaianStok.AlasanPenyesuaianStok.alasan; break; case 9: e.Style.CellValue = penyesuaianStok.keterangan; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Golongan", Width = 700 }); gridListProperties.Add(new GridListControlProperties { Header = "Keuntungan (%)", Width = 400 }); gridListProperties.Add(new GridListControlProperties { Header = "Diskon" }); GridListControlHelper.InitializeGridListControl <Golongan>(this.gridList, _listOfGolongan, gridListProperties); if (_listOfGolongan.Count > 0) { this.gridList.SetSelected(0, true); } this.gridList.Grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { if (_listOfGolongan.Count > 0) { if (e.RowIndex > 0) { var rowIndex = e.RowIndex - 1; if (rowIndex < _listOfGolongan.Count) { var golongan = _listOfGolongan[rowIndex]; switch (e.ColIndex) { case 2: e.Style.CellValue = golongan.nama_golongan; break; case 3: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = golongan.persentase_keuntungan; break; case 4: e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.CellValue = golongan.diskon; break; default: break; } // we handled it, let the grid know e.Handled = true; } } } }; }
private void InitGridList() { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); var listCount = 0; switch (this._referensiType) { case ReferencesType.JenisPengeluaran: gridListProperties.Add(new GridListControlProperties { Header = "Jenis Biaya" }); GridListControlHelper.InitializeGridListControl <JenisPengeluaran>(this.gridList, _listOfJenisPengeluaran, gridListProperties); this.gridList.Grid.QueryCellInfo += GridJenisPengeluaran_QueryCellInfo; listCount = _listOfJenisPengeluaran.Count; break; case ReferencesType.Customer: gridListProperties.Add(new GridListControlProperties { Header = "Nama Customer", Width = 200 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat" }); GridListControlHelper.InitializeGridListControl <Customer>(this.gridList, _listOfCustomer, gridListProperties); this.gridList.Grid.QueryCellInfo += GridCustomer_QueryCellInfo; listCount = _listOfCustomer.Count; break; case ReferencesType.Supplier: gridListProperties.Add(new GridListControlProperties { Header = "Nama Supplier", Width = 200 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat" }); GridListControlHelper.InitializeGridListControl <Supplier>(this.gridList, _listOfSupplier, gridListProperties); this.gridList.Grid.QueryCellInfo += GridSupplier_QueryCellInfo; listCount = _listOfSupplier.Count; break; case ReferencesType.Dropshipper: gridListProperties.Add(new GridListControlProperties { Header = "Nama Dropshipper", Width = 200 }); gridListProperties.Add(new GridListControlProperties { Header = "Alamat" }); GridListControlHelper.InitializeGridListControl <Dropshipper>(this.gridList, _listOfDropshipper, gridListProperties); this.gridList.Grid.QueryCellInfo += GridDropshipper_QueryCellInfo; listCount = _listOfDropshipper.Count; break; case ReferencesType.Produk: gridListProperties.Add(new GridListControlProperties { Header = "Kode Produk", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Nama Produk", Width = 260 }); gridListProperties.Add(new GridListControlProperties { Header = "Harga", Width = 70 }); gridListProperties.Add(new GridListControlProperties { Header = "Stok", Width = 50 }); gridListProperties.Add(new GridListControlProperties { Header = "Golongan" }); GridListControlHelper.InitializeGridListControl <Produk>(this.gridList, _listOfProduk, gridListProperties); this.gridList.Grid.QueryCellInfo += GridProduk_QueryCellInfo; listCount = _listOfProduk.Count; break; case ReferencesType.KabupatenAsal: gridListProperties.Add(new GridListControlProperties { Header = "Provinsi", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Kota/Kabupaten", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Kode Pos" }); GridListControlHelper.InitializeGridListControl <KabupatenAsalRajaOngkir>(this.gridList, _listOfKabupatenAsal, gridListProperties); this.gridList.Grid.QueryCellInfo += GridKabupatenAsal_QueryCellInfo; listCount = _listOfKabupatenAsal.Count; break; case ReferencesType.KabupatenTujuan: gridListProperties.Add(new GridListControlProperties { Header = "Provinsi", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Kota/Kabupaten", Width = 250 }); gridListProperties.Add(new GridListControlProperties { Header = "Kode Pos" }); GridListControlHelper.InitializeGridListControl <KabupatenTujuanRajaOngkir>(this.gridList, _listOfKabupatenTujuan, gridListProperties); this.gridList.Grid.QueryCellInfo += GridKabupatenTujuan_QueryCellInfo; listCount = _listOfKabupatenTujuan.Count; break; default: break; } if (listCount > 0) { this.gridList.SetSelected(0, true); } }
private void InitGridControl(GridControl grid) { var gridListProperties = new List <GridListControlProperties>(); gridListProperties.Add(new GridListControlProperties { Header = "No", Width = 30 }); gridListProperties.Add(new GridListControlProperties { Header = "Nota Beli", Width = 100 }); gridListProperties.Add(new GridListControlProperties { Header = "Total", Width = 100, IsEditable = false, HorizontalAlignment = GridHorizontalAlignment.Right }); gridListProperties.Add(new GridListControlProperties { Header = "Kekurangan", Width = 100, IsEditable = false, HorizontalAlignment = GridHorizontalAlignment.Right }); gridListProperties.Add(new GridListControlProperties { Header = "Pembayaran", Width = 100, HorizontalAlignment = GridHorizontalAlignment.Right }); gridListProperties.Add(new GridListControlProperties { Header = "Keterangan", Width = 200 }); gridListProperties.Add(new GridListControlProperties { Header = "Aksi" }); GridListControlHelper.InitializeGridListControl <ItemPembayaranHutangProduk>(grid, _listOfItemPembayaranHutang, gridListProperties); grid.PushButtonClick += delegate(object sender, GridCellPushButtonClickEventArgs e) { if (e.ColIndex == 7) { if (grid.RowCount == 1) { MsgHelper.MsgWarning("Minimal 1 nota harus diinputkan !"); return; } if (MsgHelper.MsgDelete()) { var pembayaranHutang = _listOfItemPembayaranHutang[e.RowIndex - 1]; pembayaranHutang.entity_state = EntityState.Deleted; _listOfItemPembayaranHutangDeleted.Add(pembayaranHutang); _listOfItemPembayaranHutang.Remove(pembayaranHutang); grid.RowCount = _listOfItemPembayaranHutang.Count(); grid.Refresh(); RefreshTotal(); } } }; grid.QueryCellInfo += delegate(object sender, GridQueryCellInfoEventArgs e) { // Make sure the cell falls inside the grid if (e.RowIndex > 0) { if (!(_listOfItemPembayaranHutang.Count > 0)) { return; } double grand_total = 0; double sisaNota = 0; var itemPembayaran = _listOfItemPembayaranHutang[e.RowIndex - 1]; var beli = itemPembayaran.BeliProduk; if (beli != null) { grand_total = beli.grand_total; sisaNota = beli.sisa_nota; } switch (e.ColIndex) { case 1: // no urut e.Style.CellValue = e.RowIndex.ToString(); break; case 2: // nota beli if (beli != null) { e.Style.CellValue = beli.nota; } if (beli != null) { if (beli.tanggal_tempo.IsNull()) // nota tunai nominalnya tidak bisa diedit { e.Style.Enabled = false; e.Style.BackColor = ColorCollection.DEFAULT_FORM_COLOR; base.SetButtonSimpanToFalse(true); } } break; case 3: // total e.Style.CellValue = NumberHelper.NumberToString(grand_total); break; case 4: // kekurangan e.Style.CellValue = NumberHelper.NumberToString(sisaNota); break; case 5: // pembayaran if (beli != null) { if (beli.tanggal_tempo.IsNull()) // nota tunai nominalnya tidak bisa diedit { e.Style.Enabled = false; e.Style.BackColor = ColorCollection.DEFAULT_FORM_COLOR; } } e.Style.CellValue = NumberHelper.NumberToString(itemPembayaran.nominal); break; case 6: // keterangan e.Style.CellValue = itemPembayaran.keterangan; break; case 7: // button hapus e.Style.CellType = GridCellTypeName.PushButton; e.Style.HorizontalAlignment = GridHorizontalAlignment.Center; e.Style.Description = "Hapus"; if (beli != null) { e.Style.Enabled = !beli.tanggal_tempo.IsNull(); } break; default: break; } e.Handled = true; // we handled it, let the grid know } }; var colIndex = 2; // kolom nama produk grid.CurrentCell.MoveTo(1, colIndex, GridSetCurrentCellOptions.BeginEndUpdate); }