private void lstRefNo_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { var dr = (DataRowView)lstRefNo.GetDataRecordByNode(lstRefNo.Selection[0]); if (dr == null) { return; } string[] ReferenceNo = new string[2]; ReferenceNo[0] = dr["RefNo"].ToString(); ReferenceNo[1] = dr["Date"].ToString(); DataTable dtTransactions; if (ReferenceNo[0] != "") { OrderID = Convert.ToInt32(dr["ID"]); if (OrderID != 0) { //dtTransactions = iss.GetIssueByRefNo(ReferenceNo[0], Convert.ToInt32(cboStores.EditValue)); OrderID = Convert.ToInt32(dr["ID"]); BLL.PickList pl = new BLL.PickList(); dtTransactions = pl.GetPickListDetailsForOrder(OrderID).Table; // Fix the column names for the reports to recognize //dtTransactions.Columns["BatchNumber"].ColumnName = "BatchNo"; //dtTransactions.Columns["ExpireDate"].ColumnName = "ExpDate"; //dtTransactions.Columns["SKUTOPICK"].ColumnName = "QtyInSKU"; //dtTransactions.Columns["Packs"].ColumnName = "Pack"; //dtTransactions.Columns["Cost"].ColumnName = "CalculatedCost"; gridTransactions.DataSource = dtTransactions; } } }
private void cboIssuedTo_EditValueChanged(object sender, EventArgs e) { if (lkIssuedTo.EditValue != null && cboStores.EditValue != null) { BLL.PickList plst = new BLL.PickList(); DataTable dtRec = new DataTable(); lstRefNo.DataSource = plst.GetDistinctPickList(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkIssuedTo.EditValue)); gridTransactions.DataSource = dtRec; } }
private void cboStores_EditValueChanged(object sender, EventArgs e) { if (cboStores.EditValue != null) { BLL.PickList pl = new BLL.PickList(); DataTable dtIssue = pl.GetDistinctPickList(Convert.ToInt32(cboStores.EditValue)); // add the current year datarow DataRowView drv = dtIssue.DefaultView.AddNew(); drv["ID"] = 0; drv["RefNo"] = "Current Year"; lstRefNo.DataSource = dtIssue; } }