void financeIdComboBox_SelectedIndexChanged(object sender, EventArgs e) { IList list = new List <TTransaction>(); if (financeIdComboBox.SelectedIndex != 0) { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3]; expArrays[0] = NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionDesc2, financeIdComboBox.SelectedValue.ToString()); expArrays[1] = NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()); //sisa utang tidak nol expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionPpn, decimal.Zero)); NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(TTransaction.ColumnNames.TransactionDate); list = DataMaster.GetList(typeof(TTransaction), expArrays, orderArrays); for (int i = 0; i < list.Count; i++) { TTransaction t = list[i] as TTransaction; t.TransactionByName = AppCode.GetCustomerName(t.TransactionBy, true); } } tTransactionBindingSource.DataSource = list; }
public void BindData(object sender, EventArgs e) { string myKeyWord = "%" + txt_SearchById.Text.Trim() + "%"; if (txt_SearchById.Text.Equals("<Cari Berdasar No Surat Jalan Supplier>")) { myKeyWord = "%%"; } bindingSource_Search.Clear(); NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2]; expArrays[0] = NHibernate.Expression.Expression.Between(TTransactionDelivery.ColumnNames.DeliveryReceiveDate, dt_From.Value, dt_To.Value); expArrays[1] = NHibernate.Expression.Expression.Like(TTransactionDelivery.ColumnNames.DeliveryNumberPic, myKeyWord); NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1]; ordArrays[0] = NHibernate.Expression.Order.Asc(TTransactionDelivery.ColumnNames.DeliveryReceiveDate); IList listSearch = DataMaster.GetList(typeof(TTransactionDelivery), expArrays, ordArrays); if (listSearch.Count > 0) { bindingSource_Search.DataSource = listSearch; } }
private void BindData() { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3]; if (itemToolStripComboBox.ComboBox.SelectedValue != null) { if (itemToolStripComboBox.ComboBox.SelectedValue.ToString() != string.Empty) { expArrays[0] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.ItemId, itemToolStripComboBox.ComboBox.SelectedValue); } } expArrays[1] = NHibernate.Expression.Expression.Like(TStock.ColumnNames.StockDesc2, stockDesc2ToolStripTextBox.Text, NHibernate.Expression.MatchMode.Anywhere); expArrays[2] = NHibernate.Expression.Expression.Like(TStock.ColumnNames.StockDesc3, stockDesc3ToolStripTextBox.Text, NHibernate.Expression.MatchMode.Anywhere); IList listMaster = DataMaster.GetList(typeof(TStock), expArrays, null); if (listMaster.Count > 0) { bindingSource_Master.DataSource = listMaster; } else { bindingSource_Master.Clear(); } bindingSource_Master_PositionChanged(null, null); }
private void FillTransactionTotalSource(string transStatus, DateTime from, DateTime to, ReportBy reportBy, string ItemOrPIC) { string ItemOrPIC_Temp = ItemOrPIC; if (ItemOrPIC_Temp.Equals("")) { ItemOrPIC_Temp = "%%"; } bs = new BindingSource(); bs.Clear(); //if (!transStatus.Equals(lbl_Param1.Name)) switch (reportBy) { case ReportBy.Item: NHibernate.Expression.ICriterion[] expArray = new NHibernate.Expression.ICriterion[3]; expArray[0] = NHibernate.Expression.Expression.InsensitiveLike(VTotalTransactionDetail.ColumnNames.ItemId, ItemOrPIC_Temp); expArray[1] = NHibernate.Expression.Expression.Between(VTotalTransactionDetail.ColumnNames.TransactionDate, from, to); expArray[2] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString())); bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDetail), expArray, null); //bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetail.ColumnNames.ItemId, ItemOrPIC_Temp); break; case ReportBy.PIC: expArray = new NHibernate.Expression.ICriterion[3]; expArray[0] = NHibernate.Expression.Expression.InsensitiveLike(VTotalTransactionDetail.ColumnNames.TransactionBy, ItemOrPIC_Temp); expArray[1] = NHibernate.Expression.Expression.Between(VTotalTransactionDetail.ColumnNames.TransactionDate, from, to); expArray[2] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString())); bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDetail), expArray, null); //bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetail.ColumnNames.TransactionBy, ItemOrPIC_Temp); break; default: break; } //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)); try { ReportParameter[] parameters = new ReportParameter[2]; parameters[0] = new ReportParameter("Report_Parameter_DateFrom", from.ToString(AppCode.DateTimeFormat)); parameters[1] = new ReportParameter("Report_Parameter_DateTo", to.ToString(AppCode.DateTimeFormat)); reportViewer1.LocalReport.SetParameters(parameters); } catch (Exception) { } }
private int CalculateStockAkhir(string ItemId) { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3]; expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, ItemId); expArrays[1] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value); expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateIn, System.Data.SqlTypes.SqlDateTime.MinValue.Value)); int stokMasuk = DataMaster.GetList(typeof(VTStockDetail), expArrays, null).Count; expArrays = new NHibernate.Expression.ICriterion[3]; expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, ItemId); expArrays[1] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateOut, transactionDateDateTimePicker.Value); expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value)); int stokKeluar = DataMaster.GetList(typeof(VTStockDetail), expArrays, null).Count; return(stokMasuk - stokKeluar); }
private void FillVStockDetailDataSource() { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2]; if (itemIdComboBox.SelectedIndex != 0) { expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, itemIdComboBox.SelectedValue); } if (FilterByDateCheckBox.Checked) { expArrays[1] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1)); } bs = new BindingSource(); bs.DataSource = DataMaster.GetList(typeof(VTStockDetail), expArrays, null); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTStockDetail", bs)); }
private void FillTPihutang(string piHutangStatus) { bs = new BindingSource(); NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[1]; expArrays[0] = NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangStatus, piHutangStatus); //expArrays[1] = NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangPic, piHutangPicComboBox.SelectedValue.ToString()); //expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero)); NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1]; ordArrays[0] = NHibernate.Expression.Order.Desc(TPiHutang.ColumnNames.PiHutangDate); bs.DataSource = DataMaster.GetList(typeof(TPiHutang), expArrays, ordArrays); //bs.DataSource = DataMaster.GetListEqNotEqLessThan(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangStatus, piHutangStatus, TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero, TPiHutang.ColumnNames.PiHutangJatuhTempo, DateTime.Today); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_TPiHutang", bs)); }
private decimal CalculateStock(bool isIn, string ItemId) { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3]; expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, ItemId); if (isIn) { expArrays[1] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1)); expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateIn, System.Data.SqlTypes.SqlDateTime.MinValue.Value)); } else { expArrays[1] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateOut, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1)); expArrays[2] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value)); } return(DataMaster.GetList(typeof(VTStockDetail), expArrays, null).Count); }
private void FillVTransactionWithBankAccSource(string transStatus, DateTime from, DateTime to, object[] transBy) { bs = new BindingSource(); bs.Clear(); NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3]; expArrays[0] = NHibernate.Expression.Expression.Eq(VTransactionWithBankAcc.ColumnNames.TransactionStatus, transStatus); expArrays[1] = NHibernate.Expression.Expression.Between(VTransactionWithBankAcc.ColumnNames.TransactionDate, from, to); expArrays[2] = NHibernate.Expression.Expression.In(VTransactionWithBankAcc.ColumnNames.TransactionBy, transBy); NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1]; ordArrays[0] = NHibernate.Expression.Order.Asc(VTransactionWithBankAcc.ColumnNames.TransactionFactur); bs.DataSource = DataMaster.GetList(typeof(VTransactionWithBankAcc), expArrays, ordArrays); //bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTransactionWithBankAcc), VTransactionWithBankAcc.ColumnNames.TransactionDate, from, to); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTransactionWithBankAcc", bs)); }
private void FillVTotalDelivery(DateTime DateFrom, DateTime DateTo, string likeValue) { if (string.IsNullOrEmpty(likeValue)) { likeValue = "%%"; } bs = new BindingSource(); NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2]; expArrays[0] = NHibernate.Expression.Expression.Between(VTotalTransactionDelivery.ColumnNames.DeliveryReceiveDate, DateFrom, DateTo); expArrays[1] = NHibernate.Expression.Expression.Like(VTotalTransactionDelivery.ColumnNames.DeliveryExpedission, likeValue); NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1]; ordArrays[0] = NHibernate.Expression.Order.Asc(VTotalTransactionDelivery.ColumnNames.DeliveryReceiveDate); bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDelivery), expArrays, ordArrays); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDelivery", bs)); }
private void piHutangPicComboBox_SelectedIndexChanged(object sender, EventArgs e) { if (piHutangPicComboBox.SelectedIndex == -1) { return; } tPiHutangDataGridView.Rows.Clear(); NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[3]; expArrays[0] = NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangStatus, PiHutang.ToString()); expArrays[1] = NHibernate.Expression.Expression.Eq(TPiHutang.ColumnNames.PiHutangPic, piHutangPicComboBox.SelectedValue.ToString()); expArrays[2] = NHibernate.Expression.Expression.Gt(TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero); NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Desc(TPiHutang.ColumnNames.TransactionId); IList piHutangList = DataMaster.GetList(typeof(TPiHutang), expArrays, orderArrays); //IList piHutangList = DataMaster.GetListEqGreatThan(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangStatus, PiHutang.ToString(), TPiHutang.ColumnNames.PiHutangPic, piHutangPicComboBox.SelectedValue.ToString(), TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero); TPiHutang piHut; for (int i = 0; i < piHutangList.Count; i++) { piHut = (TPiHutang)piHutangList[i]; object[] piHutangDetail = new object[9]; piHutangDetail[0] = false; piHutangDetail[1] = piHut.PiHutangDesc; piHutangDetail[2] = piHut.PiHutangJatuhTempo; piHutangDetail[3] = piHut.PiHutangJumlah; piHutangDetail[4] = piHut.PiHutangRetur; piHutangDetail[5] = piHut.PiHutangSisa; piHutangDetail[6] = string.Empty; piHutangDetail[7] = piHut.PiHutangId; piHutangDetail[8] = piHut.SubAccountId; tPiHutangDataGridView.Rows.Add(piHutangDetail); } }
private void FillVTotalTransactionDataSource(decimal p) { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[5]; if (gudangIdComboBox.SelectedIndex != 0) { int t = 0; if (int.TryParse(gudangIdComboBox.SelectedValue.ToString(), out t)) { expArrays[0] = NHibernate.Expression.Expression.Eq(VTotalTransactionDealer.ColumnNames.GudangId, int.Parse(gudangIdComboBox.SelectedValue.ToString())); } } if (locationIdComboBox.SelectedIndex != 0) { expArrays[1] = NHibernate.Expression.Expression.Eq(VTotalTransactionDealer.ColumnNames.LocationId, locationIdComboBox.SelectedValue); } if (transactionByComboBox.SelectedIndex != 0) { expArrays[2] = NHibernate.Expression.Expression.Eq(VTotalTransactionDealer.ColumnNames.TransactionBy, transactionByComboBox.SelectedValue); } if (FilterByDateCheckBox.Checked) { expArrays[3] = NHibernate.Expression.Expression.Between(VTotalTransactionDealer.ColumnNames.TransactionDate, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1)); } expArrays[4] = NHibernate.Expression.Expression.Eq(VTotalTransactionDealer.ColumnNames.TransactionStatus, listOfTransaction.ToString()); NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(VTotalTransactionDealer.ColumnNames.TransactionDate); bs = new BindingSource(); bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDealer), expArrays, orderArrays); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDealer", bs)); }
private void DeleteTransaction(DateTime from, DateTime to) { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2]; expArrays[0] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString())); expArrays[1] = NHibernate.Expression.Expression.Between(TTransaction.ColumnNames.TransactionDate, from, to); IList list = DataMaster.GetList(typeof(TTransaction), expArrays, null); TTransaction t; TTransactionDetail det; for (int i = 0; i < list.Count; i++) { t = (TTransaction)list[i]; IList listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, t.TransactionId); for (int j = 0; j < listDet.Count; j++) { det = (TTransactionDetail)listDet[j]; DataMaster.Delete(det); } DataMaster.Delete(t); } MessageBox.Show("Transaksi Berhasil dihapus", "Hapus Transaksi Berhasil.", MessageBoxButtons.OK, MessageBoxIcon.Information); groupBox1.Enabled = false; }
private void FillTransactionDetail(TTransaction tr) { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add("AddDetail", typeof(bool)); dt.Columns.Add("ItemId", typeof(string)); dt.Columns.Add("ItemName", typeof(string)); dt.Columns.Add("Quantity", typeof(decimal)); dt.Columns.Add("QuantityDeliveryLast", typeof(decimal)); dt.Columns.Add("QuantityDelivery", typeof(decimal)); dt.Columns.Add("TransactionDetailId", typeof(decimal)); dt.Columns.Add("DeliveryDetailId", typeof(decimal)); IList listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, tr.TransactionId); NHibernate.Expression.ICriterion[] expArrays; if (isInEdit) { expArrays = new NHibernate.Expression.ICriterion[2]; expArrays[0] = NHibernate.Expression.Expression.Eq(TTransactionDelivery.ColumnNames.TransactionId, tr.TransactionId); expArrays[1] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(TTransactionDelivery.ColumnNames.DeliveryId, delId)); } else { expArrays = new NHibernate.Expression.ICriterion[1]; expArrays[0] = NHibernate.Expression.Expression.Eq(TTransactionDelivery.ColumnNames.TransactionId, tr.TransactionId); } NHibernate.Expression.Order[] ordArrays = new NHibernate.Expression.Order[1]; ordArrays[0] = NHibernate.Expression.Order.Asc(TTransactionDelivery.ColumnNames.DeliveryReceiveDate); IList listDel = DataMaster.GetList(typeof(TTransactionDelivery), expArrays, ordArrays); TTransactionDetail det; MItem item; TTransactionDelivery del; TTransactionDeliveryDetail delDet; decimal delCount = decimal.Zero; for (int i = 0; i < listDet.Count; i++) { delCount = decimal.Zero; det = (TTransactionDetail)listDet[i]; dr = dt.NewRow(); dr[0] = false; dr[1] = det.ItemId; item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, det.ItemId); if (item != null) { dr[2] = item.ItemName; } dr[3] = det.Quantity; for (int j = 0; j < listDel.Count; j++) { del = (TTransactionDelivery)listDel[j]; delDet = (TTransactionDeliveryDetail)DataMaster.GetObjectByProperty(typeof(TTransactionDeliveryDetail), TTransactionDeliveryDetail.ColumnNames.DeliveryId, del.DeliveryId, TTransactionDeliveryDetail.ColumnNames.TransactionDetailId, det.TransactionDetailId); if (delDet != null) { delCount += delDet.DeliveryDetailQuantity; } //listDelDet = DataMaster.GetListEq(typeof(TTransactionDeliveryDetail), TTransactionDeliveryDetail.ColumnNames.DeliveryId, del.DeliveryId); //for (int k = 0; k < listDelDet.Count; k++) //{ // delDet = (TTransactionDeliveryDetail)listDelDet[k]; // delCount += delDet.DeliveryDetailQuantity; //} } dr[4] = delCount; if (isInEdit) { del = (TTransactionDelivery)DataMaster.GetObjectByProperty(typeof(TTransactionDelivery), TTransactionDeliveryDetail.ColumnNames.DeliveryId, delId); if (del != null) { delDet = (TTransactionDeliveryDetail)DataMaster.GetObjectByProperty(typeof(TTransactionDeliveryDetail), TTransactionDeliveryDetail.ColumnNames.DeliveryId, del.DeliveryId, TTransactionDeliveryDetail.ColumnNames.TransactionDetailId, det.TransactionDetailId); if (delDet != null) { dr[5] = delDet.DeliveryDetailQuantity; dr[7] = delDet.DeliveryDetailId; } else { dr[5] = decimal.Zero; dr[7] = decimal.Zero; } } } else { dr[5] = decimal.Zero; dr[7] = decimal.Zero; } dr[6] = det.TransactionDetailId; dt.Rows.Add(dr); } tTransactionDeliveryDetailDataGridView.DataSource = dt; tTransactionDeliveryDetailDataGridView.Show(); }
private void FillVStockDetailTransactionDealerDataSource() { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[10]; if (itemIdComboBox.SelectedIndex != 0) { expArrays[0] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.ItemId, itemIdComboBox.SelectedValue); } if (stockDesc1ComboBox.SelectedIndex != 0) { expArrays[1] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDesc1, stockDesc1ComboBox.SelectedValue); } if (!string.IsNullOrEmpty(stockDesc2TextBox.Text.Trim())) { expArrays[2] = NHibernate.Expression.Expression.Like(VTStockDetail.ColumnNames.StockDesc2, stockDesc2TextBox.Text, NHibernate.Expression.MatchMode.Anywhere); } if (!string.IsNullOrEmpty(stockDesc3TextBox.Text.Trim())) { expArrays[3] = NHibernate.Expression.Expression.Like(VTStockDetail.ColumnNames.StockDesc3, stockDesc3TextBox.Text, NHibernate.Expression.MatchMode.Anywhere); } if (listOfReports != ListOfReports.ReportRecapSisaStock) { if (FilterByDateCheckBox.Checked) { expArrays[4] = NHibernate.Expression.Expression.Between(VTStockDetail.ColumnNames.StockDateIn, transactionDateDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1)); } //jika status stok terjual if (StatusStockComboBox.SelectedIndex == 1) { expArrays[5] = NHibernate.Expression.Expression.Not(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value)); } //jika status stok belum terjual else if (StatusStockComboBox.SelectedIndex == 2) { expArrays[5] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value); } } //jika gudang visible if (ShowGudangIdPanel) { if (gudangIdComboBox.SelectedIndex != 0) { expArrays[6] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.GudangId, Convert.ToInt32(gudangIdComboBox.SelectedValue)); try { if (Convert.ToInt32(gudangIdComboBox.SelectedValue) == 4) { if (locationIdComboBox.SelectedIndex != 0) { expArrays[7] = NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.LocatonId, locationIdComboBox.SelectedValue); } } } catch (Exception) { } } } if (listOfReports == ListOfReports.ReportRecapSisaStock) { expArrays[8] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTStockDetail.ColumnNames.StockDateOut, System.Data.SqlTypes.SqlDateTime.MinValue.Value), NHibernate.Expression.Expression.Gt(VTStockDetail.ColumnNames.StockDateOut, transactionDateToDateTimePicker.Value.AddDays(1))); //expArrays[8] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateOut, transactionDateToDateTimePicker.Value.AddDays(1)); expArrays[9] = NHibernate.Expression.Expression.Lt(VTStockDetail.ColumnNames.StockDateIn, transactionDateToDateTimePicker.Value.AddDays(1)); } IList listStok = DataMaster.GetList(typeof(VTStockDetail), expArrays, null); VTStockDetail s; IList list = new List <VStockDetailTransactionDealer>(); VStockDetailTransactionDealer v; VTotalTransactionDealer det; for (int i = 0; i < listStok.Count; i++) { s = listStok[i] as VTStockDetail; v = new VStockDetailTransactionDealer(); v.ChannelName = s.ChannelName; v.ColourDesc = s.ColourDesc; det = DataMaster.GetObjectByProperty(typeof(VTotalTransactionDealer), VTotalTransactionDealer.ColumnNames.StockId, s.StockId, VTotalTransactionDealer.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()) as VTotalTransactionDealer; if (det != null) { v.CustomerName = det.CustomerName; } v.GudangId = s.GudangId; v.GudangName = s.GudangName; v.ItemId = s.ItemId; v.ItemName = s.ItemName; v.LocatonId = s.LocatonId; v.StockBarcodeId = s.StockBarcodeId; v.StockDateIn = s.StockDateIn; v.StockDateOut = s.StockDateOut; v.StockDesc1 = s.StockDesc1; v.StockDesc2 = s.StockDesc2; v.StockDesc3 = s.StockDesc3; v.StockId = s.StockId; v.StockInBy = s.StockInBy; v.StockIsAvailable = s.StockIsAvailable; v.StockOutBy = s.StockOutBy; v.StockPriceIn = s.StockPriceIn; v.StockPriceOut = s.StockPriceOut; list.Add(v); } //expArrays[8] =NHibernate.Expression.Expression NHibernate.Expression.Expression.Eq(VStockDetailTransactionDealer.ColumnNames.ItemId, itemIdComboBox.SelectedValue); bs = new BindingSource(); bs.DataSource = list; reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VStockDetailTransactionDealer", bs)); }
private void UpdatePrice(string ItemId) { NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[2]; expArrays[0] = NHibernate.Expression.Expression.Between(TTransaction.ColumnNames.TransactionDate, transactionDateFromDateTimePicker.Value, transactionDateToDateTimePicker.Value.AddDays(1)); expArrays[1] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Purchase.ToString())); IList listTrans = DataMaster.GetList(typeof(TTransaction), expArrays, null); IList listDet; IList listStock; TTransaction t; TTransactionDetail det; TStock stok; decimal total = decimal.Zero; for (int i = 0; i < listTrans.Count; i++) { t = listTrans[i] as TTransaction; total = decimal.Zero; listDet = DataMaster.GetListEq(typeof(TTransactionDetail), TTransactionDetail.ColumnNames.TransactionId, t.TransactionId, TTransactionDetail.ColumnNames.ItemId, ItemId); for (int j = 0; j < listDet.Count; j++) { det = listDet[j] as TTransactionDetail; if (t.TransactionStatus == ListOfTransaction.Sales.ToString()) { det.Price = itemPriceMaxNumericUpDown.Value; DataMaster.UpdatePersistence(det); total += det.Price; } else if (true) { det.Price = itemPricePurchaseNumericUpDown.Value; DataMaster.UpdatePersistence(det); total += det.Price; } listStock = DataMaster.GetListEq(typeof(TStock), TStock.ColumnNames.StockId, det.StockId, TStock.ColumnNames.ItemId, ItemId); for (int k = 0; k < listStock.Count; k++) { stok = listStock[k] as TStock; if (t.TransactionStatus == ListOfTransaction.Sales.ToString()) { stok.StockPriceIn = itemPriceMaxNumericUpDown.Value; } else if (true) { stok.StockPriceOut = itemPricePurchaseNumericUpDown.Value; } } } if (listDet.Count > 0) { t.TransactionSubTotal = total; t.TransactionGrandTotal = total; if (t.TransactionPayment == ListOfPayment.Credit.ToString()) { t.TransactionSisa = t.TransactionGrandTotal - t.TransactionPaid + t.TransactionPotongan; t.TransactionPpn = t.TransactionGrandTotal - t.TransactionPaid + t.TransactionPotongan; } } } }
private void BindData(object sender, EventArgs e) { string myKeyWord = string.Empty; string col = TStock.ColumnNames.StockDesc2; if (sender == txt_SearchById) { if (!txt_SearchById.Text.Equals("<Cari Berdasar No Rangka>")) { myKeyWord = txt_SearchById.Text.Trim(); } col = TStock.ColumnNames.StockDesc2; } else if (sender == txt_SearchByName) { if (!txt_SearchByName.Text.Equals("<Cari Berdasar No Mesin>")) { myKeyWord = txt_SearchByName.Text.Trim(); } col = TStock.ColumnNames.StockDesc3; } //bindingSource_Search.Clear(); NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[5]; expArrays[0] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.ItemId, cb_ItemId.SelectedValue.ToString()); expArrays[1] = NHibernate.Expression.Expression.InsensitiveLike(col, myKeyWord, NHibernate.Expression.MatchMode.Anywhere); expArrays[2] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.GudangId, GudangId); if (!string.IsNullOrEmpty(LocationId)) { expArrays[3] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.LocatonId, LocationId); } expArrays[4] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.StockIsAvailable, true); IList listSearch = DataMaster.GetList(typeof(TStock), expArrays, null); TStock stok; MColour color; MItem item; DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add(TStock.ColumnNames.StockId); dt.Columns.Add(TStock.ColumnNames.ItemId); dt.Columns.Add(TStock.ColumnNames.StockDesc1); dt.Columns.Add(TStock.ColumnNames.StockDesc2); dt.Columns.Add(TStock.ColumnNames.StockDesc3); for (int i = 0; i < listSearch.Count; i++) { stok = listSearch[i] as TStock; dr = dt.NewRow(); dr[0] = stok.StockId; //nama item item = DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId) as MItem; if (item == null) { item = new MItem(); } dr[1] = item.ItemName; //nama warna color = DataMaster.GetObjectByProperty(typeof(MColour), MColour.ColumnNames.ColourId, stok.StockDesc1) as MColour; if (color == null) { color = new MColour(); } dr[2] = color.ColourDesc; dr[3] = stok.StockDesc2; dr[4] = stok.StockDesc3; dt.Rows.Add(dr); } bindingSource_Search.DataSource = dt; //if (listSearch.Count > 0) // bindingSource_Search.DataSource = listSearch; }