I added a Button to a Dashboard that when they highlight rows and press the Copy Button it copies Order/Line/Rel and 0 to the clipboard. Then they could paste this data directly to Customer Shipment Entry to add those lines in mass.
What I want to do instead of highlighting the rows, is to check a “Select” box that I added. So then the user presses the button and copies the data. See image, first field is “Select”.
I’ve already try to reverse engineer some things on my own, but could not figure it out. I assume you need to make the “Select” field Active after it loads the Dashboard. Then with some code the button will read the boxes checked instead of the highlighted rows.
I also want to add a button to add a shortcut to “Sales Order Pick List”, so instead of going to back thru menu, they could open the Print Report directly and paste the Data and Print.
So far just have the code for the Copy button. I don’t know what do next in order to Activate the Select Box in the Grid so users can check and uncheck it. Then the plan is to run the Code from the Button on those checked rows.
public class Script
{
public void InitializeCustomCode()
{
this.epiButtonC1.Click += new System.EventHandler(this.epiButtonC1_Click);
this.epiButtonC2.Click += new System.EventHandler(this.epiButtonC2_Click);
}
public void DestroyCustomCode()
{
this.epiButtonC1.Click -= new System.EventHandler(this.epiButtonC1_Click);
this.epiButtonC2.Click -= new System.EventHandler(this.epiButtonC2_Click);
}
private void epiButtonC1_Click(object sender, System.EventArgs args)
{
EpiUltraGrid eugOD = (EpiUltraGrid)csm.GetNativeControlReference("3b8c933f-cf47-48d1-8ad1-03f6b1ba46b3");
string strBuilder = "";
foreach(var r in eugOD.Selected.Rows)
{
strBuilder += r.Cells["OrderRel_OrderNum"].Text.ToString() + "\t" + r.Cells["OrderRel_OrderLine"].Text.ToString() + "\t" + r.Cells["OrderRel_OrderRelNum"].Text.ToString() + "\t" + 0 + Environment.NewLine;
}
Clipboard.SetText(strBuilder);
}
private void epiButtonC2_Click(object sender, System.EventArgs args)
{
EpiUltraGrid eugOD = (EpiUltraGrid)csm.GetNativeControlReference("3b8c933f-cf47-48d1-8ad1-03f6b1ba46b3");
string strBuilder = "";
foreach(var r in eugOD.Selected.Rows)
{
strBuilder += r.Cells["OrderRel_OrderNum"].Text.ToString() + Environment.NewLine;
}
Clipboard.SetText(strBuilder);
}
} ```
Are you wanting the rows that the user highlights/selects to mark the (I’m assuming unbound) checkbox to true? And then the click event on your button(s) will copy fields from the selected rows?
Either way, there are at least 2 ways to go about this (that I know of).
The first is to go after the dataview itself versus the grid control, if you want to stick with the dashboard approach. In this way, you’d establish the dataview driving the grid and you could loop through the selected rows from that. I don’t think you’d need to necessarily have the two step thing of a checkbox, especially if you are simply selecting the same rows.
This example selects a single row, but I’m sure you could select multiple.
private void btnSelect_Click(object sender, System.EventArgs args)
{
// ** Place Event Handling Code Here **
EpiDataView edvQ = (EpiDataView)oTrans.EpiDataViews["V_JRF_Quotes_1View"];
int QuoteNum = Convert.ToInt32(edvQ.dataView[edvQ.Row]["QuoteDtl_QuoteNum"]);
int QuoteLine = Convert.ToInt32(edvQ.dataView[edvQ.Row]["QuoteDtl_QuoteLine"]);
//show your variables if you want
}
The second way I know is if you have a custom grid and you’ve added a BAQ behind it to control the data in the grid. This way gives you a lot of relatively simple flexibility with custom columns like “Select”.
This example loops through a custom grid and checks the row for the value of a custom “Add” checkbox.
foreach (UltraGridRow selectedRow in grdAvailableToPurchase.Rows)
{
if ((bool)selectedRow.Cells["Add"].Value)
{
lot = (string)selectedRow.Cells["UD100_Key1"].Value.ToString();
part = (string)selectedRow.Cells["UD100_Key2"].Value.ToString();
}
}
After reading the messages in this post, and digging thru other posts I figured out the solution. You need to enable Infragistics. The first code (Main Controller_Load) will enable the Column Activation and the Second (SetExtendedProperties) enables the column and makes it editable.
I know I’m late to this one, but a lot simpler way to get checkboxes is to make a bit calculated field in the BAQ and set that field as updateable. It will allow you to check the box in the dashboard.
I agree with Brandon, and that’s how we did it. Simple calc/updateable field on the BAQ. Then a little code will cycle through all the rows with the checkbox checked.
