private DataSet SignerCC(int quoteNum)
{
//returns a list of signers (doc + non-arthrex ppl) and cc's (reps)
//parsed in GetSignersAndCCs method
DataSet dsResults = new DataSet();
using (DynamicQueryAdapter querySigners = new DynamicQueryAdapter(oTrans))
{
//Create QuoteNum parameter
QueryExecutionDataSet parameters = new QueryExecutionDataSet();
DataRow paramRow = parameters.ExecutionParameter.NewRow();
paramRow["ParameterID"] = "QuoteNum";
paramRow["ParameterValue"] = quoteNum;
paramRow["ValueType"] = "int";
paramRow["IsEmpty"] = "False";
parameters.ExecutionParameter.Rows.Add(paramRow);
//Call JRF-QuoteCnts_HelloSign
querySigners.BOConnect();
querySigners.ExecuteByID("JRF-QuoteCnts_HelloSign", parameters);
dsResults = querySigners.QueryResults;
querySigners.Dispose();
}
return(dsResults);
}
/** Same function as in Part Entry Form**/
private void FillVehicleGrid(String vPartNum, String vRevisionNum)
{
try
{
DynamicQueryAdapter ad = new DynamicQueryAdapter(oTrans);
ad.BOConnect();
QueryExecutionDataSet parameters = new QueryExecutionDataSet();
parameters.Tables["ExecutionParameter"].Rows.Add("vPartNum", vPartNum, "nvarchar", false, Guid.NewGuid(), "A");
parameters.Tables["ExecutionParameter"].Rows.Add("vRevision", vRevisionNum, "nvarchar", false, Guid.NewGuid(), "A");
ad.ExecuteByID("RAN_DEL_VehicleTable", parameters);
gridVehicle.DataSource = ad.QueryResults.Tables["Results"];
ad.Dispose();
//Hide Columns
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Company"].Hidden = true;
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100A_ChildKey1"].Hidden = true;
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100A_ChildKey2"].Hidden = true;
//Set Format
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Number01"].Format = "###,###,###,##0.0";
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Number02"].Format = "###,###,###,##0.0";
//Disable Columns
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Key1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Key2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Key3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Key4"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Key5"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Number01"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.gridVehicle.DisplayLayout.Bands[0].Columns["UD100_Number02"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.gridVehicle.DisplayLayout.Bands[0].Columns["Calculated_Check"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
foreach (UltraGridRow row in gridVehicle.Rows)
{
row.Appearance.BackColorDisabled = System.Drawing.Color.White;
row.Appearance.ForeColorDisabled = System.Drawing.Color.Black;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void FillVehicleGrid(String vPartNum, String vRevisionNum)
{
try
{
DynamicQueryAdapter ad = new DynamicQueryAdapter(oTrans);
ad.BOConnect();
QueryExecutionDataSet parameters = new QueryExecutionDataSet();
parameters.Tables["ExecutionParameter"].Rows.Add("vPartNum", vPartNum, "nvarchar", false, Guid.NewGuid(), "A");
parameters.Tables["ExecutionParameter"].Rows.Add("vRevision", vRevisionNum, "nvarchar", false, Guid.NewGuid(), "A");
ad.ExecuteByID("RAN_DEL_VehicleTable", parameters);
ugdVehicle.DataSource = ad.QueryResults.Tables["Results"];
ad.Dispose();
// foreach(Infragistics.Win.UltraWinGrid.UltraGridColumn curColumn in ugdVehicle.DisplayLayout.Bands[0].Columns)
// {
// curColumn.Hidden = true;
// }
//
// //Unhide the "columns"
// ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key1"].Hidden = false;
// ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key2"].Hidden = false;
// ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key3"].Hidden = false;
// ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key4"].Hidden = false;
// ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key5"].Hidden = false;
// ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Number01"].Hidden = false;
// ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Number02"].Hidden = false;
// ugdVehicle.DisplayLayout.Bands[0].Columns["Calculated_Check"].Hidden = false;
// ugdVehicle.Rows.Band.Columns["Calculated_Check"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CheckBox;
//
// ugdVehicle.DisplayLayout.Override.SelectedAppearancesEnabled = Infragistics.Win.DefaultableBoolean.False;
// ugdVehicle.DisplayLayout.Override.ActiveAppearancesEnabled = Infragistics.Win.DefaultableBoolean.False;
//Hide Columns
ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Company"].Hidden = true;
ugdVehicle.DisplayLayout.Bands[0].Columns["UD100A_ChildKey1"].Hidden = true;
ugdVehicle.DisplayLayout.Bands[0].Columns["UD100A_ChildKey2"].Hidden = true;
//Set Format
ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Number01"].Format = "###,###,###,##0.0";
ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Number02"].Format = "###,###,###,##0.0";
//Disable Columns
this.ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key4"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key5"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Number01"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
this.ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Number02"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
//Disable BackColor Columns
//this.ugdVehicle.DisplayLayout.Bands[0].Columns["UD100_Key1"].Appearance.BackColorDisabled = System.Drawing.Color.White;
// args.Row.Cells["UD100_Key1"].Appearance.ForeColorDisabled = System.Drawing.Color.Black;
// args.Row.Cells["UD100_Key2"].Appearance.BackColorDisabled = System.Drawing.Color.White;
// args.Row.Cells["UD100_Key3"].Appearance.BackColorDisabled = System.Drawing.Color.White;
// args.Row.Cells["UD100_Key4"].Appearance.BackColorDisabled = System.Drawing.Color.White;
// args.Row.Cells["UD100_Key5"].Appearance.BackColorDisabled = System.Drawing.Color.White;
// args.Row.Cells["UD100_Number01"].Appearance.BackColorDisabled = System.Drawing.Color.White;
// args.Row.Cells["UD100_Number02"].Appearance.BackColorDisabled = System.Drawing.Color.White;
foreach (UltraGridRow row in ugdVehicle.Rows)
{
row.Appearance.BackColorDisabled = System.Drawing.Color.White;
row.Appearance.ForeColorDisabled = System.Drawing.Color.Black;
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
}