private void FillNotLikeTransactionTotalSource(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(); NHibernate.Expression.ICriterion[] expArray = new NHibernate.Expression.ICriterion[3]; expArray[0] = NHibernate.Expression.Expression.Not(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); //if (!transStatus.Equals(lbl_Param1.Name)) //switch (reportBy) //{ // case ReportBy.Item: // NHibernate.Expression.ICriterion[] expArray = new NHibernate.Expression.ICriterion[1]; // expArray[0]= NHibernate.Expression.Expression.Not( NHibernate.Expression.Expression.InsensitiveLike(VTotalTransactionDetail.ColumnNames.ItemId,ItemOrPIC_Temp)); // 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: // 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) { } }
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 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)); }
internal static void FillSalesComboBox(ComboBox employeeIdComboBox) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); employeeIdComboBox.DropDownStyle = ComboBoxStyle.DropDownList; NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MEmployee.ColumnNames.EmployeeName); IList list = DataMaster.GetList(typeof(MEmployee), null, orderArrays); MEmployee emp = new MEmployee(); emp.EmployeeName = "- Salesman -"; list.Insert(0, emp); //DataTable dt = new DataTable(); //dt.Columns.Add(MEmployee.ColumnNames.EmployeeId); //dt.Columns.Add(MEmployee.ColumnNames.EmployeeName); //DataRow dr; //IList listSupplierType = DataMaster.GetAll(typeof(MEmployee)); //MEmployee supp = new MEmployee(); //supp.EmployeeName = "- Salesman -"; //dr = dt.NewRow(); //dr[0] = supp.EmployeeId; //dr[1] = supp.EmployeeName; //dt.Rows.Add(dr); //for (int i = 0; i < listSupplierType.Count; i++) //{ // supp = (MEmployee)listSupplierType[i]; // dr = dt.NewRow(); // dr[0] = supp.EmployeeId; // dr[1] = supp.EmployeeName; // dt.Rows.Add(dr); //} employeeIdComboBox.DataSource = list; employeeIdComboBox.DisplayMember = MEmployee.ColumnNames.EmployeeName; employeeIdComboBox.ValueMember = MEmployee.ColumnNames.EmployeeId; employeeIdComboBox.Show(); }
internal static void FillSupplierComboBox(ComboBox suppIdComboBox) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); suppIdComboBox.DropDownStyle = ComboBoxStyle.DropDownList; NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MSupplier.ColumnNames.SupplierName); IList list = DataMaster.GetList(typeof(MSupplier), null, orderArrays); MSupplier sup = new MSupplier(); sup.SupplierName = "- Supplier -"; list.Insert(0, sup); //DataTable dt = new DataTable(); //dt.Columns.Add(MSupplier.ColumnNames.SupplierId); //dt.Columns.Add(MSupplier.ColumnNames.SupplierName); //DataRow dr; //IList listSupplierType = DataMaster.GetAll(typeof(MSupplier)); //MSupplier supp = new MSupplier(); //supp.SupplierName = "- Supplier -"; //dr = dt.NewRow(); //dr[0] = supp.SupplierId; //dr[1] = supp.SupplierName; //dt.Rows.Add(dr); //for (int i = 0; i < listSupplierType.Count; i++) //{ // supp = (MSupplier)listSupplierType[i]; // dr = dt.NewRow(); // dr[0] = supp.SupplierId; // dr[1] = supp.SupplierName; // dt.Rows.Add(dr); //} suppIdComboBox.DataSource = list; suppIdComboBox.DisplayMember = MSupplier.ColumnNames.SupplierName; suppIdComboBox.ValueMember = MSupplier.ColumnNames.SupplierId; suppIdComboBox.Show(); }
internal static void FillFinanceComboBox(ComboBox financeIdComboBox) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); financeIdComboBox.DropDownStyle = ComboBoxStyle.DropDownList; NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MFinance.ColumnNames.FinanceName); IList list = DataMaster.GetList(typeof(MFinance), null, orderArrays); MFinance fin = new MFinance(); fin.FinanceName = "- Finance -"; list.Insert(0, fin); //DataTable dt = new DataTable(); //dt.Columns.Add(MFinance.ColumnNames.FinanceId); //dt.Columns.Add(MFinance.ColumnNames.FinanceName); //DataRow dr; //IList listFinanceType = DataMaster.GetAll(typeof(MFinance)); //MFinance finance = new MFinance(); //finance.FinanceName = "- Finance -"; //dr = dt.NewRow(); //dr[0] = finance.FinanceId; //dr[1] = finance.FinanceName; //dt.Rows.Add(dr); //for (int i = 0; i < listFinanceType.Count; i++) //{ // finance = (MFinance)listFinanceType[i]; // dr = dt.NewRow(); // dr[0] = finance.FinanceId; // dr[1] = finance.FinanceName; // dt.Rows.Add(dr); //} financeIdComboBox.DataSource = list; financeIdComboBox.DisplayMember = MFinance.ColumnNames.FinanceName; financeIdComboBox.ValueMember = MFinance.ColumnNames.FinanceId; financeIdComboBox.Show(); }
internal static void FillChannelComboBox(ComboBox channelIdComboBox) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); channelIdComboBox.DropDownStyle = ComboBoxStyle.DropDownList; NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MChannel.ColumnNames.ChannelName); IList list = DataMaster.GetList(typeof(MChannel), null, orderArrays); MChannel chn = new MChannel(); chn.ChannelName = "- Channel -"; list.Insert(0, chn); //DataTable dt = new DataTable(); //dt.Columns.Add(MChannel.ColumnNames.ChannelId); //dt.Columns.Add(MChannel.ColumnNames.ChannelName); //DataRow dr; //IList listChannelType = DataMaster.GetAll(typeof(MChannel)); //MChannel channel = new MChannel(); //channel.ChannelName = "- Channel -"; //dr = dt.NewRow(); //dr[0] = channel.ChannelId; //dr[1] = channel.ChannelName; //dt.Rows.Add(dr); //for (int i = 0; i < listChannelType.Count; i++) //{ // channel = (MChannel)listChannelType[i]; // dr = dt.NewRow(); // dr[0] = channel.ChannelId; // dr[1] = channel.ChannelName; // dt.Rows.Add(dr); //} channelIdComboBox.DataSource = list; channelIdComboBox.DisplayMember = MChannel.ColumnNames.ChannelName; channelIdComboBox.ValueMember = MChannel.ColumnNames.ChannelId; channelIdComboBox.Show(); }
internal static void FillItemComboBox(ComboBox itemIdComboBox) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); itemIdComboBox.DropDownStyle = ComboBoxStyle.DropDownList; NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MItem.ColumnNames.ItemName); IList list = DataMaster.GetList(typeof(MItem), null, orderArrays); MItem item = new MItem(); item.ItemName = "- Type Unit -"; list.Insert(0, item); //DataTable dt = new DataTable(); //dt.Columns.Add(MItem.ColumnNames.ItemId); //dt.Columns.Add(MItem.ColumnNames.ItemName); //DataRow dr; //IList listItemType = DataMaster.GetAll(typeof(MItem)); //MItem item = new MItem(); //item.ItemName = "- Type Unit -"; //dr = dt.NewRow(); //dr[0] = item.ItemId; //dr[1] = item.ItemName; //dt.Rows.Add(dr); //for (int i = 0; i < listItemType.Count; i++) //{ // item = (MItem)listItemType[i]; // dr = dt.NewRow(); // dr[0] = item.ItemId; // dr[1] = item.ItemName; // dt.Rows.Add(dr); //} itemIdComboBox.DataSource = list; itemIdComboBox.DisplayMember = MItem.ColumnNames.ItemName; itemIdComboBox.ValueMember = MItem.ColumnNames.ItemId; itemIdComboBox.Show(); }
internal static void FillColorComboBox(ComboBox stockDesc1ComboBox) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); stockDesc1ComboBox.DropDownStyle = ComboBoxStyle.DropDownList; NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MColour.ColumnNames.ColourDesc); IList list = DataMaster.GetList(typeof(MColour), null, orderArrays); MColour col = new MColour(); col.ColourDesc = "- Warna -"; list.Insert(0, col); //DataTable dt = new DataTable(); //dt.Columns.Add(MColour.ColumnNames.ColourId); //dt.Columns.Add(MColour.ColumnNames.ColourDesc); //DataRow dr; //IList listItemType = DataMaster.GetAll(typeof(MColour)); //MColour warna = new MColour(); //warna.ColourDesc = "- Warna -"; //dr = dt.NewRow(); //dr[0] = warna.ColourId; //dr[1] = warna.ColourDesc; //dt.Rows.Add(dr); //for (int i = 0; i < listItemType.Count; i++) //{ // warna = (MColour)listItemType[i]; // dr = dt.NewRow(); // dr[0] = warna.ColourId; // dr[1] = warna.ColourDesc; // dt.Rows.Add(dr); //} stockDesc1ComboBox.DataSource = list; stockDesc1ComboBox.DisplayMember = MColour.ColumnNames.ColourDesc; stockDesc1ComboBox.ValueMember = MColour.ColumnNames.ColourId; stockDesc1ComboBox.Show(); }
internal static void FillCustomerComboBox(ComboBox custIdComboBox) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); custIdComboBox.DropDownStyle = ComboBoxStyle.DropDownList; NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MCustomer.ColumnNames.CustomerName); IList list = DataMaster.GetList(typeof(MCustomer), null, orderArrays); MCustomer cust = new MCustomer(); cust.CustomerName = "- Pelanggan Baru -"; list.Insert(0, cust); //DataTable dt = new DataTable(); //dt.Columns.Add(MCustomer.ColumnNames.CustomerId); //dt.Columns.Add(MCustomer.ColumnNames.CustomerName); //DataRow dr; //IList listCustomerType = DataMaster.GetAll(typeof(MCustomer)); //MCustomer cust = new MCustomer(); //cust.CustomerName = "- Pelanggan Baru -"; //dr = dt.NewRow(); //dr[0] = cust.CustomerId; //dr[1] = cust.CustomerName; //dt.Rows.Add(dr); //for (int i = 0; i < listCustomerType.Count; i++) //{ // cust = (MCustomer)listCustomerType[i]; // dr = dt.NewRow(); // dr[0] = cust.CustomerId; // dr[1] = cust.CustomerName; // dt.Rows.Add(dr); //} custIdComboBox.DataSource = list; custIdComboBox.DisplayMember = MCustomer.ColumnNames.CustomerName; custIdComboBox.ValueMember = MCustomer.ColumnNames.CustomerId; custIdComboBox.Show(); }
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 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 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; }
public FormStock() { InitializeComponent(); DataGridViewColumn grid_Col; //add kolom kode Stock grid_Col = new DataGridViewColumn(); grid_Col.CellTemplate = new DataGridViewTextBoxCell(); grid_Col.DataPropertyName = TStock.ColumnNames.StockId; grid_Col.HeaderText = "Kode Stock"; grid_Master.Columns.Add(grid_Col); //add kolom Type Unit grid_Col = new DataGridViewColumn(); grid_Col.CellTemplate = new DataGridViewTextBoxCell(); grid_Col.DataPropertyName = TStock.ColumnNames.ItemId; grid_Col.HeaderText = "Type Unit"; grid_Master.Columns.Add(grid_Col); //add kolom Warna grid_Col = new DataGridViewColumn(); grid_Col.CellTemplate = new DataGridViewTextBoxCell(); grid_Col.DataPropertyName = TStock.ColumnNames.StockDesc1; grid_Col.HeaderText = "Warna"; grid_Master.Columns.Add(grid_Col); //add kolom Nomor Rangka grid_Col = new DataGridViewColumn(); grid_Col.CellTemplate = new DataGridViewTextBoxCell(); grid_Col.DataPropertyName = TStock.ColumnNames.StockDesc2; grid_Col.HeaderText = "Nomor Rangka"; grid_Master.Columns.Add(grid_Col); //add kolom Nomor Mesin grid_Col = new DataGridViewColumn(); grid_Col.CellTemplate = new DataGridViewTextBoxCell(); grid_Col.DataPropertyName = TStock.ColumnNames.StockDesc3; grid_Col.HeaderText = "Nomor Mesin"; grid_Master.Columns.Add(grid_Col); //hidden add and edit bindingNavigatorAddNewItem.Visible = false; bindingNavigatorDeleteItem.Visible = false; //add sep ToolStripSeparator sep = new ToolStripSeparator(); bindingNavigator_Master.Items.Add(sep); //add combo itemToolStripComboBox = new ToolStripComboBox(); NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MItem.ColumnNames.ItemName); IList listItem = DataMaster.GetList(typeof(MItem), null, orderArrays); MItem item = new MItem(); item.ItemName = "-Type Unit-"; listItem.Insert(0, item); itemToolStripComboBox.ComboBox.DataSource = listItem; itemToolStripComboBox.ComboBox.DisplayMember = MItem.ColumnNames.ItemName; itemToolStripComboBox.ComboBox.ValueMember = MItem.ColumnNames.ItemId; itemToolStripComboBox.ComboBox.Show(); //combo.Items.Add("Kode Type Unit"); //combo.Items.Add("Nama Type Unit"); itemToolStripComboBox.DropDownStyle = ComboBoxStyle.DropDownList; bindingNavigator_Master.Items.Add(itemToolStripComboBox); //add cari text bindingNavigator_Master.Items.Add("No Rangka :"); //add textbox stockDesc2ToolStripTextBox = new ToolStripTextBox(); stockDesc2ToolStripTextBox.TextBox.Width = 80; bindingNavigator_Master.Items.Add(stockDesc2ToolStripTextBox); //add cari text bindingNavigator_Master.Items.Add("No Mesin :"); //add textbox stockDesc3ToolStripTextBox = new ToolStripTextBox(); stockDesc3ToolStripTextBox.TextBox.Width = 80; bindingNavigator_Master.Items.Add(stockDesc3ToolStripTextBox); //add button ToolStripButton btn = new ToolStripButton(); btn.Text = "Cari"; btn.Image = Properties.Resources.scanner; btn.DisplayStyle = ToolStripItemDisplayStyle.ImageAndText; btn.TextImageRelation = TextImageRelation.ImageAboveText; btn.Click += new EventHandler(btn_Click); bindingNavigator_Master.Items.Add(btn); //refresh navigator bindingNavigator_Master.Refresh(); bindingSource_Master.PositionChanged += new EventHandler(bindingSource_Master_PositionChanged); bindingNavigatorEditItem.Click += new EventHandler(bindingNavigatorEditItem_Click); bindingNavigatorSaveItem.Click += new EventHandler(bindingNavigatorSaveItem_Click); bindingNavigatorRefresh.Click += new EventHandler(bindingNavigatorRefresh_Click); }
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 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(); }