//private void FillRekapTotalTransactionByItemDataSource(string transStatus) //{ // bs = new BindingSource(); // bs.Clear(); // if (!transStatus.Equals(lbl_Param1.Name)) // bs.DataSource = DataMaster.GetListEq(typeof(VTotalTransactionByItem), VTotalTransactionByItem.ColumnNames.TransactionStatus, transStatus); // else // bs.DataSource = DataMaster.GetAll(typeof(VTotalTransactionByItem)); // reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionByItem", bs)); //} private void FillTransactionTotalSource(string transStatus, DateTime from, DateTime to) { bs = new BindingSource(); bs.Clear(); if (!transStatus.Equals(lbl_Param1.Name)) { bs.DataSource = DataMaster.GetListBetweenEqValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus); } else { bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to); } reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs)); ReportParameter[] parameters = new ReportParameter[3]; parameters[0] = new ReportParameter("Report_Parameter_DateFrom", from.ToString("f")); parameters[1] = new ReportParameter("Report_Parameter_DateTo", to.ToString("f")); parameters[2] = new ReportParameter("Report_Parameter_Status", transStatus); reportViewer1.LocalReport.SetParameters(parameters); bs = new BindingSource(); bs.Clear(); if (transStatus.Equals(lbl_Param1.Name) || transStatus.Equals(ListOfTransaction.Sales.ToString()) || transStatus.Equals(ListOfTransaction.SalesVIP.ToString())) { bs.DataSource = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()); } else { bs.DataSource = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.TransactionStatus, transStatus); } reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_TTransaction", bs)); }
private void FillUserLogSource(DateTime from, DateTime to, string p) { bs = new BindingSource(); bs.Clear(); if (!string.IsNullOrEmpty(p)) { bs.DataSource = DataMaster.GetListBetweenEqValue(typeof(TLog), TLog.ColumnNames.LogDate, from, to, TLog.ColumnNames.LogUser, p); } else { bs.DataSource = DataMaster.GetListBetweenValue(typeof(TLog), TLog.ColumnNames.LogDate, from, to); } reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_TLog", bs)); }
private void FillVStokCard(DateTime DateFrom, DateTime DateTo) { bs = new BindingSource(); bs.DataSource = DataMaster.GetListBetweenValue(typeof(VStokCard), VStokCard.ColumnNames.StokCardDate, DateFrom, DateTo); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VStokCard", bs)); }
private void buttonOK_Click(object sender, EventArgs e) { if (MessageBox.Show("Anda yakin melakukan tutup hari?", "Konfirmasi tutup hari", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } pb_Loading.Visible = true; lbl_Loading.Visible = true; pb_Loading.Maximum = 5; pb_Loading.Value = 0; this.Refresh(); DateTime from = dt_ClosingFrom.Value; DateTime to = dt_ClosingTo.Value; IList listEmployee = DataMaster.GetAll(typeof(MEmployee)); MEmployee emp; IList listTrans; TTransaction trans; IList listDet; TTransactionDetail transDet; TRekapTransaction rekapTrans; TRekapCommission rekapCom; decimal refereePrice = 0; string billiardItem = "Rental Meja"; TBilliardSetting bilSet = (TBilliardSetting)DataMaster.GetObjectByProperty(typeof(TBilliardSetting), TBilliardSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); if (bilSet == null) { MessageBox.Show("Setting untuk menghitung komisi wasit tidak terdaftar, \n Hubungi supervisor anda untuk konfigurasi sistem. \n Atau klik menu Tools - Konfigurasi Program", "Konfirmasi tutup hari", MessageBoxButtons.OK); return; } else { if (bilSet.RefereeBonus == 0) { MessageBox.Show("Bonus wasit 0, \n Hubungi supervisor anda untuk konfigurasi sistem. \n Atau klik menu Tools - Konfigurasi Program", "Konfirmasi tutup hari", MessageBoxButtons.OK); return; } else { refereePrice = bilSet.RefereeBonus; } } decimal totSales = 0; decimal totSalesVIP = 0; decimal totReturSales = 0; decimal totReturSalesVIP = 0; decimal totPurchase = 0; decimal totReturPurchase = 0; decimal totCorrection = 0; decimal q = 0; decimal totDuration; decimal totBonus; pb_Loading.Value = 1; //looping for available employee for (int i = 0; i < listEmployee.Count; i++) { emp = (MEmployee)listEmployee[i]; listTrans = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.EmployeeId, emp.EmployeeId); if (listTrans.Count > 0) { totDuration = 0; totBonus = 0; //looping for list transaction for (int j = 0; j < listTrans.Count; j++) { trans = (TTransaction)listTrans[j]; //searching transaction detail for billiard item listDet = DataMaster.GetListLikeEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId, TTransactionDetail.ColumnNames.ItemId, billiardItem + "%"); if (listDet.Count > 0) { transDet = (TTransactionDetail)listDet[0]; if (transDet != null) { totDuration += transDet.Quantity; totBonus += transDet.Quantity * refereePrice; } } } totBonus = Math.Floor(totBonus / bilSet.FullfillPrice) * bilSet.FullfillPrice; rekapCom = new TRekapCommission(); rekapCom.EmployeeId = emp.EmployeeId; rekapCom.RefereePrice = refereePrice; rekapCom.RefereePriceVip = refereePrice; rekapCom.RekapBonus = totBonus; rekapCom.RekapDateFrom = from; rekapCom.RekapDateTo = to; //duration in minutes rekapCom.RekapTotalDuration = totDuration * 60; rekapCom.ModifiedBy = lbl_UserName.Text; rekapCom.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(rekapCom); } } //trans does not have referee listTrans = DataMaster.GetListBetweenEqValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to, TTransaction.ColumnNames.EmployeeId, string.Empty); if (listTrans.Count > 0) { totDuration = 0; totBonus = 0; //looping for list transaction for (int j = 0; j < listTrans.Count; j++) { trans = (TTransaction)listTrans[j]; //searching transaction detail for billiard item listDet = DataMaster.GetListLikeEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId, TTransactionDetail.ColumnNames.ItemId, billiardItem + "%"); if (listDet.Count > 0) { transDet = (TTransactionDetail)listDet[0]; if (transDet != null) { totDuration += transDet.Quantity; totBonus += transDet.Quantity * refereePrice; } } } totBonus = Math.Floor(totBonus / bilSet.FullfillPrice) * bilSet.FullfillPrice; rekapCom = new TRekapCommission(); rekapCom.EmployeeId = string.Empty; rekapCom.RefereePrice = refereePrice; rekapCom.RefereePriceVip = refereePrice; rekapCom.RekapBonus = totBonus; rekapCom.RekapDateFrom = from; rekapCom.RekapDateTo = to; //duration in minutes rekapCom.RekapTotalDuration = totDuration * 60; rekapCom.ModifiedBy = lbl_UserName.Text; rekapCom.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(rekapCom); } pb_Loading.Value = 3; //sum transaction grand total by date listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to); for (int j = 0; j < listTrans.Count; j++) { trans = (TTransaction)listTrans[j]; if (trans.TransactionStatus.Equals(ListOfTransaction.Sales.ToString())) { totSales += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.SalesVIP.ToString())) { totSalesVIP += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSales.ToString())) { totReturSales += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSalesVIP.ToString())) { totReturSalesVIP += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.Purchase.ToString())) { totPurchase += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturPurchase.ToString())) { totReturPurchase += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.Correction.ToString())) { listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); for (int k = 0; k < listDet.Count; k++) { transDet = (TTransactionDetail)listDet[k]; q = transDet.Quantity; if (transDet.Quantity < 0) { q = transDet.Quantity * -1; } totCorrection += q; } } } pb_Loading.Value = 4; rekapTrans = new TRekapTransaction(); rekapTrans.RekapDateFrom = from; rekapTrans.RekapDateTo = to; rekapTrans.TotalCorrection = totCorrection; rekapTrans.TotalPurchase = totPurchase; rekapTrans.TotalReturPurchase = totReturPurchase; rekapTrans.TotalReturSales = totReturSales; rekapTrans.TotalReturSalesVip = totReturSalesVIP; rekapTrans.TotalSales = totSales; rekapTrans.TotalSalesVip = totSalesVIP; rekapTrans.ModifiedBy = lbl_UserName.Text; rekapTrans.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(rekapTrans); pb_Loading.Value = 5; pb_Loading.Visible = false; lbl_Loading.Visible = false; buttonOK.Enabled = false; FormViewReport f_ViewReport = new FormViewReport(); f_ViewReport.lbl_TempReport.Text = ListOfReports.ReportListTransaction.ToString(); f_ViewReport.lbl_Param1.Text = ListOfTransaction.Sales.ToString(); f_ViewReport.lbl_Param2.Text = dt_ClosingFrom.Value.ToString(); f_ViewReport.lbl_Param3.Text = dt_ClosingTo.Value.ToString(); f_ViewReport.StartPosition = FormStartPosition.WindowsDefaultLocation; f_ViewReport.WindowState = FormWindowState.Maximized; f_ViewReport.Show(); }
private void buttonOK_Click(object sender, EventArgs e) { if (MessageBox.Show("Anda yakin melakukan tutup periode?", "Konfirmasi tutup periode", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } ModuleControlSettings.SaveLog(ListOfAction.Insert, dt_ClosingFrom.Value.ToLongDateString() + ";" + dt_ClosingTo.Value.ToLongDateString(), ListOfTable.TRekapTransaction, lbl_UserName.Text); pb_Loading.Visible = true; lbl_Loading.Visible = true; pb_Loading.Maximum = 5; pb_Loading.Value = 0; this.Refresh(); DateTime from = dt_ClosingFrom.Value; DateTime to = dt_ClosingTo.Value; IList listTrans; TTransaction trans; IList listDet; TTransactionDetail transDet; TRekapTransaction rekapTrans; decimal totSales = 0; decimal totSalesVIP = 0; decimal totReturSales = 0; decimal totReturSalesVIP = 0; decimal totPurchase = 0; decimal totReturPurchase = 0; decimal totCorrection = 0; decimal q = 0; pb_Loading.Value = 1; //sum transaction grand total by date listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to); for (int j = 0; j < listTrans.Count; j++) { trans = (TTransaction)listTrans[j]; if (trans.TransactionStatus.Equals(ListOfTransaction.Sales.ToString())) { totSales += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.SalesVIP.ToString())) { totSalesVIP += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSales.ToString())) { totReturSales += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturSalesVIP.ToString())) { totReturSalesVIP += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.Purchase.ToString())) { totPurchase += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.ReturPurchase.ToString())) { totReturPurchase += trans.TransactionGrandTotal; } else if (trans.TransactionStatus.Equals(ListOfTransaction.Correction.ToString())) { listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); for (int k = 0; k < listDet.Count; k++) { transDet = (TTransactionDetail)listDet[k]; q = transDet.Quantity; if (transDet.Quantity < 0) { q = transDet.Quantity * -1; } totCorrection += q; } } } rekapTrans = new TRekapTransaction(); rekapTrans.RekapDateFrom = from; rekapTrans.RekapDateTo = to; rekapTrans.TotalCorrection = totCorrection; rekapTrans.TotalPurchase = totPurchase; rekapTrans.TotalReturPurchase = totReturPurchase; rekapTrans.TotalReturSales = totReturSales; rekapTrans.TotalReturSalesVip = totReturSalesVIP; rekapTrans.TotalSales = totSales; rekapTrans.TotalSalesVip = totSalesVIP; rekapTrans.ModifiedBy = lbl_UserName.Text; rekapTrans.ModifiedDate = DateTime.Now; DataMaster.SavePersistence(rekapTrans); pb_Loading.Value = 4; ////delete before transaction //listTrans = DataMaster.GetListLessThan(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from); //for (int j = 0; j < listTrans.Count; j++) //{ // trans = (TTransaction)listTrans[j]; // DataMaster.Delete(trans); // listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); // for (int k = 0; k < listDet.Count; k++) // { // transDet = (TTransactionDetail)listDet[k]; // DataMaster.Delete(transDet); // } //} pb_Loading.Value = 5; pb_Loading.Visible = false; //lbl_Loading.Visible = false; buttonOK.Enabled = false; lbl_Loading.Text = "Tutup periode berhasil dilakukan."; try { System.Threading.Thread.Sleep(2000); } catch (Exception) { } f_ViewReport = new FormViewReport(); f_ViewReport.lbl_TempReport.Text = ListOfReports.ReportTransactionTotal.ToString(); // f_ViewReport.lbl_Param1.Text = ListOfTransaction.Sales.ToString(); f_ViewReport.lbl_Param2.Text = dt_ClosingFrom.Value.ToString(); f_ViewReport.lbl_Param3.Text = dt_ClosingTo.Value.ToString(); f_ViewReport.StartPosition = FormStartPosition.WindowsDefaultLocation; f_ViewReport.WindowState = FormWindowState.Maximized; f_ViewReport.Show(); f_ViewReport.reportViewer1.RefreshReport(); //export to excel string exportDir = Application.StartupPath; TCafeSetting cafeSet = (TCafeSetting)DataMaster.GetObjectByProperty(typeof(TCafeSetting), TCafeSetting.ColumnNames.SettingId, AppCode.AssemblyProduct); if (cafeSet != null) { exportDir = cafeSet.ExportedDir; } string fileName = exportDir + "\\Cafe " + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; Warning[] warnings; string[] streamids; string mimeType; string encoding; string filenameExtension; byte[] bytes = f_ViewReport.reportViewer1.LocalReport.Render( "Excel", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings); using (FileStream fs = new FileStream(fileName, FileMode.Create)) { fs.Write(bytes, 0, bytes.Length); } if (MessageBox.Show("Laporan berhasil diekspor ke \n " + fileName + "\n Buka file?", "Ekspor Laporan ke File Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { //Excel.Application exc = new Excel.Application; //Excel.Workbook wb = exc.Workbooks.Open( //System.IO.File.OpenRead(fileName); try { System.Diagnostics.Process.Start(fileName); } catch (Exception) { MessageBox.Show("File hasil ekspor gagal dibuka. Silahkan buka secara manual di lokasi hasil ekspor laporan.", "Laporan", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void FillVTotalTransactionDataSource(DateTime DateFrom, DateTime DateTo) { bs = new BindingSource(); bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, DateFrom, DateTo); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs)); }
private void CalculateItemValue() { //IList listGudang = DataMaster.GetAll(typeof(MGudang)); //MGudang gud; //IList listItemStok; //ItemGudangStok stok; //MItem item; //decimal itemvalue = 0; //for (int i = 0; i < listGudang.Count; i++) //{ // gud = (MGudang)listGudang[i]; // listItemStok = DataMaster.GetListEq(typeof(ItemGudangStok), ItemGudangStok.ColumnNames.GudangId, gud.GudangId); // for (int j = 0; j < listItemStok.Count; j++) // { // stok = (ItemGudangStok)listItemStok[j]; // item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId); // if (item != null) // { // itemvalue += stok.ItemStok * item.ItemPricePurchaseAvg; // } // } //} IList listTrans = DataMaster.GetListBetweenValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, from, to); IList listDet; TTransaction trans; TTransactionDetail det; decimal salesTot = 0; decimal retSalesTot = 0; decimal hppSalesTot = 0; decimal hppRetSalesTot = 0; //decimal purTot = 0; //decimal retPurTot = 0; for (int i = 0; i < listTrans.Count; i++) { trans = (TTransaction)listTrans[i]; if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString() || trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) { if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString()) { salesTot += trans.TransactionGrandTotal; } else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) { retSalesTot += trans.TransactionGrandTotal; } listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, trans.TransactionId); for (int j = 0; j < listDet.Count; j++) { det = (TTransactionDetail)listDet[j]; if (trans.TransactionStatus == ListOfTransaction.Sales.ToString() || trans.TransactionStatus == ListOfTransaction.Service.ToString()) { hppSalesTot += det.CostPrice; } else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) { hppRetSalesTot += det.CostPrice; } } } //else if (trans.TransactionStatus == ListOfTransaction.ReturSales.ToString()) // retSalesTot += trans.TransactionGrandTotal; //else if (trans.TransactionStatus == ListOfTransaction.Purchase.ToString()) // purTot += trans.TransactionGrandTotal; //else if (trans.TransactionStatus == ListOfTransaction.ReturPurchase.ToString()) // retPurTot += trans.TransactionGrandTotal; } decimal salesNet = salesTot - retSalesTot; decimal hppNet = hppSalesTot - hppRetSalesTot; decimal laba = salesNet - hppNet; ListViewItem v = new ListViewItem(); v.Text = "Penjualan"; v.SubItems.Add(salesTot.ToString("N")); listView1.Items.Add(v); v = new ListViewItem(); v.Text = "Retur Penjualan"; v.SubItems.Add(retSalesTot.ToString("N")); listView1.Items.Add(v); v = new ListViewItem(); v.Text = string.Empty; v.SubItems.Add("--------------------------"); listView1.Items.Add(v); v = new ListViewItem(); v.Text = "Penjualan Bersih"; v.SubItems.Add(string.Empty); v.SubItems.Add(salesNet.ToString("N")); listView1.Items.Add(v); //v = new ListViewItem(); //v.Text = "Pembelian"; //v.SubItems.Add(purTot.ToString("N")); //listView1.Items.Add(v); //v = new ListViewItem(); //v.Text = "Retur Pembelian"; //v.SubItems.Add(retPurTot.ToString("N")); //listView1.Items.Add(v); //v = new ListViewItem(); //v.Text = string.Empty; //v.SubItems.Add("--------------------------"); //listView1.Items.Add(v); //v = new ListViewItem(); //v.Text = "Pembelian Bersih"; //v.SubItems.Add(string.Empty); //v.SubItems.Add(purNet.ToString("N")); //listView1.Items.Add(v); v = new ListViewItem(); v.Text = "Harga Pokok Penjualan Periode " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString(); v.SubItems.Add(string.Empty); v.SubItems.Add(hppNet.ToString("N")); listView1.Items.Add(v); v = new ListViewItem(); v.Text = string.Empty; v.SubItems.Add(string.Empty); v.SubItems.Add("--------------------------"); listView1.Items.Add(v); v = new ListViewItem(); v.Text = "Laba / Rugi"; v.SubItems.Add(string.Empty); v.SubItems.Add(laba.ToString("N")); listView1.Items.Add(v); SaveRekap(listAcc.Sales, "Penjualan", salesTot); SaveRekap(listAcc.ReturSales, "Retur Penjualan", retSalesTot); SaveRekap(listAcc.SalesNet, "Penjualan Bersih", salesNet); SaveRekap(listAcc.HPP, "Harga Pokok Penjualan", hppNet); SaveRekap(listAcc.RugiLaba, "Laba / Rugi", laba); //string voucherno = AppCode.GetVoucherNo(); //TJournal jur = new TJournal(); //jur.JournalDate = DateTime.Today; //jur.JournalDesc = "Persediaan barang akhir bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString(); //jur.JournalJumlah = itemvalue; //jur.JournalPic = string.Empty; //jur.JournalStatus = ListOfJournalStatus.Debet.ToString(); //jur.SubAccountId = AppCode.GetPersediaanAccountNo(); //jur.VoucherNo = voucherno; //jur.ModifiedBy = lbl_UserName.Text; //jur.ModifiedDate = DateTime.Now; //AppCode.SaveTJournal(jur); //jur = new TJournal(); //jur.JournalDate = DateTime.Today; //jur.JournalDesc = "Ikhtiar Rugi Laba bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString(); //jur.JournalJumlah = itemvalue; //jur.JournalPic = string.Empty; //jur.JournalStatus = ListOfJournalStatus.Kredit.ToString(); //jur.SubAccountId = AppCode.GetIkhtiarRLAccountNo(); //jur.VoucherNo = voucherno; //jur.ModifiedBy = lbl_UserName.Text; //jur.ModifiedDate = DateTime.Now; //AppCode.SaveTJournal(jur); }