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 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 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));
}
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 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();
}
