private void SumSubTotal() { decimal sq = 0; decimal sp = 0; decimal sj = 0; decimal sd = 0; decimal st = 0; for (int i = 0; i < grid_Trans.Rows.Count; i++) { sq += Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value); sp += Convert.ToDecimal(grid_Trans.Rows[i].Cells[3].Value); sj += Convert.ToDecimal(grid_Trans.Rows[i].Cells[4].Value); sd += Convert.ToDecimal(grid_Trans.Rows[i].Cells[5].Value); st += Convert.ToDecimal(grid_Trans.Rows[i].Cells[6].Value); } txt_SubQuantity.Text = ModuleControlSettings.NumericFormat(sq); txt_SubPrice.Text = ModuleControlSettings.NumericFormat(sp); txt_SubJumlah.Text = ModuleControlSettings.NumericFormat(sj); txt_SubDisc.Text = ModuleControlSettings.NumericFormat(sd); txt_SubTotal.Text = ModuleControlSettings.NumericFormat(st); SumGrandTotal(null, null); ResetTransactionDetail(); }
private void button1_Click(object sender, EventArgs e) { if (!ValidateFormDetail()) { return; } string[] field = new string[7]; field[0] = txt_ItemId.Text; field[1] = txt_ItemName.Text; field[2] = ModuleControlSettings.NumericFormat(num_Quantity.Value); field[3] = ModuleControlSettings.NumericFormat(num_Price.Value); field[4] = ModuleControlSettings.NumericFormat(num_Jumlah.Value); field[5] = ModuleControlSettings.NumericFormat(num_Disc.Value); field[6] = ModuleControlSettings.NumericFormat(num_Total.Value); grid_Trans.Rows.Insert(0, field); }
private void CollectReminderData() { listView_Reminder.Items.Clear(); MGudang gud; ItemGudangStok stok; MItem item; ListViewItem viewItem; IList listStok = DataMaster.GetAll(typeof(ItemGudangStok)); string gudangName = ""; for (int i = 0; i < listStok.Count; i++) { stok = (ItemGudangStok)listStok[i]; gud = (MGudang)DataMaster.GetObjectByProperty(typeof(MGudang), MGudang.ColumnNames.GudangId, stok.GudangId); if (gud != null) { gudangName = gud.GudangName; } //kurang dari batas minimum if (stok.ItemStok < stok.ItemMinStok) { viewItem = new ListViewItem(); item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId); if (item != null) { viewItem.Text = item.ItemName + " (" + gudangName + ")"; } else { viewItem.Text = stok.ItemId + " (" + gudangName + ")"; } viewItem.SubItems.Add(ModuleControlSettings.NumericFormat(stok.ItemStok)); viewItem.Group = listView_Reminder.Groups[0]; listView_Reminder.Items.Add(viewItem); } } IList listSupp = DataMaster.GetAll(typeof(MSupplier)); IList listPiHutang; MSupplier supp; TPiHutang pihut; decimal totPiHut; //get hutang for (int i = 0; i < listSupp.Count; i++) { supp = (MSupplier)listSupp[i]; listPiHutang = DataMaster.GetListEqNotEqLessThan(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangPic, supp.SupplierId, TPiHutang.ColumnNames.PiHutangStatus, ListOfPiHutangStatus.Hutang.ToString(), TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero, TPiHutang.ColumnNames.PiHutangJatuhTempo, DateTime.Now); totPiHut = 0; for (int j = 0; j < listPiHutang.Count; j++) { pihut = (TPiHutang)listPiHutang[j]; totPiHut += pihut.PiHutangSisa; } if (totPiHut != 0) { viewItem = new ListViewItem(); viewItem.Text = supp.SupplierName; viewItem.SubItems.Add(ModuleControlSettings.NumericFormat(totPiHut)); viewItem.Group = listView_Reminder.Groups[1]; listView_Reminder.Items.Add(viewItem); } } IList listCust = DataMaster.GetAll(typeof(MCustomer)); MCustomer cust; //get piutang for (int i = 0; i < listCust.Count; i++) { cust = (MCustomer)listCust[i]; listPiHutang = DataMaster.GetListEqNotEqLessThan(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangPic, cust.CustomerId, TPiHutang.ColumnNames.PiHutangStatus, ListOfPiHutangStatus.Piutang.ToString(), TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero, TPiHutang.ColumnNames.PiHutangJatuhTempo, DateTime.Now); totPiHut = 0; for (int j = 0; j < listPiHutang.Count; j++) { pihut = (TPiHutang)listPiHutang[j]; totPiHut += pihut.PiHutangSisa; } if (totPiHut != 0) { viewItem = new ListViewItem(); viewItem.Text = cust.CustomerName; viewItem.SubItems.Add(ModuleControlSettings.NumericFormat(totPiHut)); viewItem.Group = listView_Reminder.Groups[2]; listView_Reminder.Items.Add(viewItem); } } }
private bool ValidateClosing() { period = numericUpDown_Year.Value.ToString() + comboBox_Month.SelectedValue.ToString(); TRekapSubAccount rekap = (TRekapSubAccount)DataMaster.GetObjectByProperty(typeof(TRekapSubAccount), TRekapSubAccount.ColumnNames.RekapSubAccountPeriode, period); if (rekap != null) { if (MessageBox.Show("Proses akhir bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString() + " sudah dilakukan. Anda yakin melanjutkan ?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return(false); } } string today = DateTime.Today.Month.ToString(); if (DateTime.Today.Month < 10) { today = decimal.Zero.ToString() + DateTime.Today.Month.ToString(); } today = DateTime.Today.Year.ToString() + today; if (Convert.ToDecimal(today) <= Convert.ToDecimal(period)) { if (MessageBox.Show("Proses akhir bulan hanya bisa dilakukan untuk periode bulan sebelumnya. Anda yakin melanjutkan ?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return(false); } } IList listAcc = DataMaster.GetAll(typeof(MAccount)); MAccount acc; decimal totDebet = 0; decimal totKredit = 0; for (int i = 0; i < listAcc.Count; i++) { acc = (MAccount)listAcc[i]; if (acc.AccountStatus == ListOfJournalStatus.Debet.ToString()) { totDebet += acc.AccountSaldo; } else if (acc.AccountStatus == ListOfJournalStatus.Kredit.ToString()) { totKredit += acc.AccountSaldo; } } if (totKredit != totDebet) { decimal selisih = totDebet - totKredit; if (selisih < 0) { selisih = selisih * -1; } MessageBox.Show("Proses akhir bulan belum dapat dilakukan, terjadi selisih sebesar " + ModuleControlSettings.NumericFormat(selisih, true), AppCode.AssemblyProduct, MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } return(true); }
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { Single xPos = e.MarginBounds.Left; Single yPos = e.MarginBounds.Top; Font printFont = new Font("MS Sans Serif", 10); Single lineHeight = printFont.GetHeight(e.Graphics) + 5; //Single widthPaper = 480 - e.MarginBounds.Left; Single widthPaper = e.PageSettings.PaperSize.Width - e.MarginBounds.Left; string txt = ""; txt = set.CompanyName; xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2)); e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); txt = set.CompanyAddress + " " + set.CompanyCity; yPos += lineHeight; xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2)); e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); txt = "Telp : " + set.CompanyTelp; yPos += lineHeight; xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2)); e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //xPos = e.MarginBounds.Left; //yPos += lineHeight * 2; //txt = "No : " + txt_Factur.Text; //e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); xPos = e.MarginBounds.Left; yPos += lineHeight; txt = dt_TransactionDate.Value.ToString("dd MMMM yyyy HH:mm"); e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); yPos += lineHeight; for (int i = 0; i < grid_Trans.Rows.Count; i++) { //display item code //xPos = e.MarginBounds.Left; //yPos += lineHeight; //txt = grid_Trans.Rows[i].Cells[0].Value.ToString(); //e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //display nama item //xPos += 100; xPos = e.MarginBounds.Left; yPos += lineHeight; txt = grid_Trans.Rows[i].Cells[1].Value.ToString(); e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //if (Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value) != 1) //{ //display kuantitas xPos = e.MarginBounds.Left; yPos += lineHeight; txt = ModuleControlSettings.NumericFormat(grid_Trans.Rows[i].Cells[2].Value) + " x @" + ModuleControlSettings.NumericFormat(grid_Trans.Rows[i].Cells[3].Value); //display discount if (ModuleControlSettings.isDecimal(grid_Trans.Rows[i].Cells[5].Value.ToString())) { if (Convert.ToDecimal(grid_Trans.Rows[i].Cells[5].Value.ToString()) > 0) { txt += " - " + ModuleControlSettings.NumericFormat(grid_Trans.Rows[i].Cells[5].Value) + "%"; } } e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); ////display total //xPos += 130; txt = ModuleControlSettings.NumericFormat(grid_Trans.Rows[i].Cells[6].Value, true); xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f; e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); } if (num_TaxValue.Value > 0) { //display subtotal xPos = e.MarginBounds.Left + 50; yPos += lineHeight; txt = "Sub Total : "; e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); txt = ModuleControlSettings.NumericFormat(decimal.Parse(txt_SubTotal.Text), true); xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f; e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //display tax xPos = e.MarginBounds.Left + 50; yPos += lineHeight; txt = "Tax : "; e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); txt = ModuleControlSettings.NumericFormat(num_TaxValue.Value, true); xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f; e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); } //display grantotal xPos = e.MarginBounds.Left + 50; yPos += lineHeight; txt = "Total : "; e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); txt = ModuleControlSettings.NumericFormat(num_GrandTotal.Value, true); //xPos = e.MarginBounds.Right -e.Graphics.MeasureString(txt, printFont).Width; xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f; e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); ////display dibayar //xPos = e.MarginBounds.Left + 50; //yPos += lineHeight; //txt = "Tunai : "; //e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //txt = ModuleControlSettings.NumericFormat(num_Pay.Value, true); ////xPos = e.MarginBounds.Right -e.Graphics.MeasureString(txt, printFont).Width; //xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f; //e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); ////display kembali //xPos = e.MarginBounds.Left + 50; //yPos += lineHeight; //txt = "Kembali : "; //e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //txt = ModuleControlSettings.NumericFormat(num_Back.Value, true); ////xPos = e.MarginBounds.Right -e.Graphics.MeasureString(txt, printFont).Width; //xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f; //e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); ////keterangan //txt = "Barang yang sudah dibeli"; //yPos += lineHeight * 2; //xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2)); //e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //txt = "Tidak dapat ditukar / dikembalikan"; //yPos += lineHeight; //xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2)); //e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //thanks txt = "Terima Kasih atas kunjungan anda"; yPos += lineHeight * 2; xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2)); e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //saran txt = "Saran dan kritik, hubungi : "; yPos += lineHeight; xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2)); e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); //saran Inventori.Cafe.Data.TCafeSetting cafeSet = (Inventori.Cafe.Data.TCafeSetting)DataMaster.GetObjectByProperty(typeof(Inventori.Cafe.Data.TCafeSetting), Inventori.Cafe.Data.TCafeSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); if (cafeSet != null) { txt = cafeSet.TelpNoSaranKritik; yPos += lineHeight; xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2)); e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos); } }