public static string ExportGridColumns(string sGRID_NAME)
{
StringBuilder sbSQL = new StringBuilder();
UniqueStringCollection arrSelectFields = new UniqueStringCollection();
// 05/03/2011 Always include the ID as it might be used by the Export code to filter by selected items.
arrSelectFields.Add("ID");
GridColumns(sGRID_NAME, arrSelectFields, null);
// 04/20/2011 If there are no fields in the GridView.Export, then return all fields (*).
if ( arrSelectFields.Count > 1 )
{
foreach ( string sField in arrSelectFields )
{
if ( sbSQL.Length > 0 )
sbSQL.Append(" , ");
sbSQL.AppendLine(sField);
}
}
else
{
sbSQL.AppendLine("*");
}
return sbSQL.ToString();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
m_sMODULE = "TQClientAddress";
SetMenu(m_sMODULE);
// 02/08/2008 We need to build a list of the fields used by the search clause.
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("ID");
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DATE_MODIFIED");
arrSelectFields.Add("NOTE_ID");
this.AppendGridColumns(grdMain, "ProductTemplates.Notes", arrSelectFields);
if (IsPostBack)
{
ctlDynamicButtons.AppendButtons("ProductTemplates.Notes", Guid.Empty, Guid.Empty);
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
//ctlSearchView.Command += new CommandEventHandler(Page_Command);
//ctlExportHeader.Command += new CommandEventHandler(Page_Command);
// 11/26/2005 Add fields early so that sort events will get called.
m_sMODULE = "TQClientAddress";
SetMenu(m_sMODULE);
// 02/08/2008 We need to build a list of the fields used by the search clause.
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("ID");
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "Invoices";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DATE_ENTERED");
arrSelectFields.Add("INVOICE_ID");
arrSelectFields.Add("ASSIGNED_USER_ID");
this.AppendGridColumns(grdMain, "Payments." + m_sMODULE, arrSelectFields);
if (IsPostBack)
ctlDynamicButtons.AppendButtons("Payments." + m_sMODULE, Guid.Empty, Guid.Empty);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
// ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
ctlSearchView.Command = new CommandEventHandler(Page_Command);
m_sMODULE = "ProductTemplates";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("NAME");
this.AppendGridColumns(grdMain, m_sMODULE + ".PopupView", arrSelectFields);
// ctlDynamicButtons.AppendButtons(m_sMODULE + ".PopupView", Guid.Empty, Guid.Empty);
// if (!IsPostBack)
// ctlDynamicButtons.ShowButton("Clear", !TypeConvert.ToBoolean(Request["ClearDisabled"]));
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
//ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
ctlSearchView.Command = new CommandEventHandler(Page_Command);
m_sMODULE = "ProductCatalog";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("NAME");
this.AppendGridColumns(grdMain, m_sMODULE + ".PopupView", arrSelectFields);
//ctlDynamicButtons.AppendButtons(m_sMODULE + ".PopupView", Guid.Empty, Guid.Empty);
//if (!IsPostBack)
// ctlDynamicButtons.ShowButton("Clear", !TypeConvert.ToBoolean(Request["ClearDisabled"]));
}
public static void SearchGridColumns(string sGRID_NAME, UniqueStringCollection arrSelectFields)
{
StringCollection arrSkippedFields = new StringCollection();
arrSkippedFields.Add("USER_NAME" );
arrSkippedFields.Add("ASSIGNED_TO" );
arrSkippedFields.Add("CREATED_BY" );
arrSkippedFields.Add("MODIFIED_BY" );
arrSkippedFields.Add("DATE_ENTERED" );
arrSkippedFields.Add("DATE_MODIFIED");
arrSkippedFields.Add("TEAM_NAME" );
arrSkippedFields.Add("TEAM_SET_NAME");
GridColumns(sGRID_NAME, arrSelectFields, arrSkippedFields);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "ProductTemplates";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DATE_ENTERED");
arrSelectFields.Add("PRODUCT_TEMPLATE_ID");
this.AppendGridColumns(grdMain, "ProductTemplates.RelatedProducts", arrSelectFields);
if (IsPostBack)
{
ctlDynamicButtons.AppendButtons("ProductTemplates.RelatedProducts", Guid.Empty, Guid.Empty);
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "Payments";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DATE_ENTERED");
arrSelectFields.Add("ID");
this.AppendGridColumns(grdMain, m_sMODULE + ".PaymentTransactions", arrSelectFields);
if (IsPostBack)
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".PaymentTransactions", Guid.Empty, Guid.Empty);
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "Invoices";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DATE_ENTERED");
arrSelectFields.Add("INVOICE_ID");
arrSelectFields.Add("ASSIGNED_USER_ID");
this.AppendGridColumns(grdMain, "Payments." + m_sMODULE, arrSelectFields);
if (IsPostBack)
{
ctlDynamicButtons.AppendButtons("Payments." + m_sMODULE, Guid.Empty, Guid.Empty);
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
m_sMODULE = "ProductTemplates";
SetMenu(m_sMODULE);
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("NAME");
this.AppendGridColumns(grdMain, m_sMODULE + ".ListView", arrSelectFields);
ctlSearchView.Command = new CommandEventHandler(Page_Command);
ctlExportHeader.Command = new CommandEventHandler(Page_Command);
ctlMassUpdate.Command = new CommandEventHandler(Page_Command);
if (CRMSecurity.GetUserAccess(m_sMODULE, "delete") < 0 && CRMSecurity.GetUserAccess(m_sMODULE, "edit") < 0)
{
ctlMassUpdate.Visible = false;
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
ctlDynamicButtonsOpen.Command += new CommandEventHandler(Page_Command);
ctlDynamicButtonsHistory.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "Calls";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DATE_MODIFIED");
arrSelectFields.Add("ACTIVITY_ID");
arrSelectFields.Add("ACTIVITY_TYPE");
arrSelectFields.Add("ACTIVITY_ASSIGNED_USER_ID");
arrSelectFields.Add("IS_OPEN");
arrSelectFields.Add("DATE_DUE");
arrSelectFields.Add("STATUS");
arrSelectFields.Add("DIRECTION");
this.AppendGridColumns(grdOpen, "Invoices.Activities.Open", arrSelectFields);
this.AppendGridColumns(grdHistory, "Invoices.Activities.History", arrSelectFields);
if (IsPostBack)
{
ctlDynamicButtonsOpen.AppendButtons("Invoices.Activities.Open", Guid.Empty, Guid.Empty);
ctlDynamicButtonsHistory.AppendButtons("Invoices.Activities.History", Guid.Empty, Guid.Empty);
}
}
public void ConfigureResolver()
{
UniqueStringCollection strings = new UniqueStringCollection(this._query.AllFileReferences.Concat<string>(PluginAssembly.GetCompatibleAssemblies(this._query.IsMyExtensions)), new FileNameComparer());
if (this._query.Repository != null)
{
strings.AddRange(this._query.Repository.GetDriverAssemblies());
}
UniqueStringCollection strings2 = new UniqueStringCollection(this._query.AdditionalGACReferences);
if (!(this._query.IsMyExtensions || (MyExtensions.Query == null)))
{
strings.AddRange(MyExtensions.Query.AllFileReferences);
strings2.AddRange(MyExtensions.Query.AdditionalGACReferences);
}
bool flag = ((this._query.Repository != null) && this._query.Repository.DriverLoader.IsValid) && (this._query.Repository.DriverLoader.Driver is LinqToSqlDynamicDriver);
string fileOrPath = this._typeResolver.Configure(strings, strings2, (this._query.Repository != null) && !this._query.Repository.DynamicSchema, flag);
if (((fileOrPath != null) && (this._query.Repository != null)) && this._query.Repository.DynamicSchema)
{
this._typeResolver.set_DataContextBuilding(false);
if ((this._query.Repository.IntellicachePath == null) || (this._query.Repository.IntellicachePath.FullPath != fileOrPath))
{
this._query.Repository.IntellicachePath = new TempFileRef(fileOrPath);
}
}
}
// 03/01/2014 Add Preview button.
public void AppendGridColumns(string sGRID_NAME, UniqueStringCollection arrSelectFields, CommandEventHandler Page_Command)
{
SplendidDynamic.AppendGridColumns(sGRID_NAME, this, arrSelectFields, Page_Command);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "ProductTemplates";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DATE_ENTERED");
arrSelectFields.Add("PRODUCT_TEMPLATE_ID");
this.AppendGridColumns(grdMain, "ProductTemplates.RelatedProducts", arrSelectFields);
if (IsPostBack)
ctlDynamicButtons.AppendButtons("ProductTemplates.RelatedProducts", Guid.Empty, Guid.Empty);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
//ctlSearchView.Command += new CommandEventHandler(Page_Command);
//ctlExportHeader.Command += new CommandEventHandler(Page_Command);
// 11/26/2005 Add fields early so that sort events will get called.
m_sMODULE = "TQMyFavorite";
SetMenu(m_sMODULE);
// 02/08/2008 We need to build a list of the fields used by the search clause.
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("ID");
this.AppendGridColumns(grdMain, m_sMODULE + "." + LayoutListView, arrSelectFields);
grdMain.ItemCommand += grdMain_ItemCommand;
}
public static void AppendGridColumns(string sGRID_NAME, DataGrid grd, UniqueStringCollection arrSelectFields)
{
AppendGridColumns(sGRID_NAME, grd, arrSelectFields, null);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
m_sMODULE = "Products";
SetMenu(m_sMODULE);
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("ID");
arrSelectFields.Add("NAME");
this.AppendGridColumns(grdMain, m_sMODULE + ".ListView", arrSelectFields);
ctlSearchView.Command = new CommandEventHandler(Page_Command);
ctlExportHeader.Command = new CommandEventHandler(Page_Command);
ctlMassUpdate.Command = new CommandEventHandler(Page_Command);
if (CRMSecurity.GetUserAccess(m_sMODULE, "delete") < 0 && CRMSecurity.GetUserAccess(m_sMODULE, "edit") < 0)
ctlMassUpdate.Visible = false;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
ctlSearchView.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "BusinessRules";
SetMenu(m_sMODULE);
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("NAME");
this.AppendGridColumns(grdMain, m_sMODULE + "." + LayoutListView, arrSelectFields);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
ctlDynamicButtonsOpen.Command += new CommandEventHandler(Page_Command);
ctlDynamicButtonsHistory.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "Calls";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DATE_MODIFIED");
arrSelectFields.Add("ACTIVITY_ID");
arrSelectFields.Add("ACTIVITY_TYPE");
arrSelectFields.Add("ACTIVITY_ASSIGNED_USER_ID");
arrSelectFields.Add("IS_OPEN");
arrSelectFields.Add("DATE_DUE");
arrSelectFields.Add("STATUS");
arrSelectFields.Add("DIRECTION");
this.AppendGridColumns(grdOpen, "Invoices.Activities.Open", arrSelectFields);
this.AppendGridColumns(grdHistory, "Invoices.Activities.History", arrSelectFields);
if (IsPostBack)
{
ctlDynamicButtonsOpen.AppendButtons("Invoices.Activities.Open", Guid.Empty, Guid.Empty);
ctlDynamicButtonsHistory.AppendButtons("Invoices.Activities.History", Guid.Empty, Guid.Empty);
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
ctlSearchView .Command += new CommandEventHandler(Page_Command);
ctlExportHeader.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "TQAccount";
SetMenu(m_sMODULE);
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("ID");
arrSelectFields.Add("C_UserID");
arrSelectFields.Add("C_Status");
arrSelectFields.Add("isCompanyAdmin");
this.AppendGridColumns(grdMain, m_sMODULE + "." + LayoutListView, arrSelectFields);
grdMain.ItemCommand += grdMain_ItemCommand;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
ctlSearchView.Command += new CommandEventHandler(Page_Command);
ctlCheckAll.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "TQClient";
// 07/26/2007 Use the new PopupView so that the view is customizable.
// 02/08/2008 We need to build a list of the fields used by the search clause.
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("C_ClientShortName");
// 08/01/2010 We need a separate view to select the Full Name instead of the User Name.
this.AppendGridColumns(grdMain, m_sMODULE + ".PopupView" + (Sql.ToString(Request["C_ClientShortName"]) == "1" ? "Name" : ""), arrSelectFields);
// 04/29/2008 Make use of dynamic buttons.
ctlDynamicButtons.AppendButtons(m_sMODULE + ".Popup" + (bMultiSelect ? "MultiSelect" : "View"), Guid.Empty, Guid.Empty);
if (!IsPostBack && !bMultiSelect)
ctlDynamicButtons.ShowButton("Clear", !Sql.ToBoolean(Request["ClearDisabled"]));
}
private void Extract(TagArchive archive, bool recusive, params string[] files)
{
extractionActive = true;
int totalFilesExtracted = 0, totalFilesToExtract = 0;
List <TagSet> sets = archive.BuildTagLocationList(files, currentGame);
// Setup the counts.
foreach (TagSet set in sets)
{
totalFilesToExtract += set.Tags.Count;
}
progressPanel.TotalExtracted = 0;
progressPanel.TagCount = totalFilesToExtract;
UniqueStringCollection additionalFiles = new UniqueStringCollection();
try
{
foreach (TagSet set in sets)
{
string filename = currentGame.Maps[set.MapIndex].Filename;
// UI Update
progressPanel.CurrentMap = Path.GetFileName(filename);
progressPanel.CurrentMap = filename;
progressPanel.OpeningMap = true;
IMapFile map = currentGame.CreateMapFileObject();
map.Load(currentGame.MapFilePath + "\\" + filename);
progressPanel.ExtractingTags = true;
// Sort alphabetically so that folders don't get extracted out of order.
set.Tags.Sort();
// Extract the tags one by one.
foreach (string tag in set.Tags)
{
// UI Update
progressPanel.CurrentTag = tag;
bool successful = true;
try
{
// Check and see if we have attempted to cancel...
if (!extractionActive)
{
return;
}
if (!archive.FileExists(tag))
{
byte[] data = map.GetTag(tag);
archive.AddFile(tag, data);
}
}
catch (Exception ex)
{
successful = false;
Output.Write(OutputTypes.Error, "Unable to extract tag '" + tag + ex.Message);
}
if (successful)
{
RemoveFromQueue(tag);
}
totalFilesExtracted++;
// UI Update
progressPanel.TotalExtracted = totalFilesExtracted;
if (recusive)
{
// Attempt to deserialize the tag, and get its dependencies.
string tagExtension = Path.GetExtension(tag).Trim('.');
Type tagType = currentGame.TypeTable.LocateEntryByName(tagExtension).TagType;
TagPath poolPath = new TagPath(tag, currentGame.GameID, TagLocation.Archive);
string[] dependencies = Core.Prometheus.Instance.Pool.GetTagReferences(poolPath.ToPath(), tagType);
foreach (string dependency in dependencies)
{
if (!archive.FileExists(dependency))
{
additionalFiles.Add(dependency);
}
}
}
}
}
if (additionalFiles.Count > 0)
{
progressPanel.Title = "Extracting dependencies...";
// Extract the additional files.
Extract(archive, true, additionalFiles.ToArray());
}
}
finally
{
UpdateExtractionButton();
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
// 11/26/2005 Add fields early so that sort events will get called.
m_sMODULE = "TQOrderDetailSell";
SetMenu(m_sMODULE);
// 02/08/2008 We need to build a list of the fields used by the search clause.
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("ID");
arrSelectFields.Add("C_Status");
arrSelectFields.Add("C_CarID");
arrSelectFields.Add("C_ShippingUrl");
arrSelectFields.Add("C_Driver");
arrSelectFields.Add("C_Tel");
this.AppendGridColumns(grdMain, m_sMODULE + "." + LayoutListView, arrSelectFields);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
ctlSearchView .Command += new CommandEventHandler(Page_Command);
ctlExportHeader.Command += new CommandEventHandler(Page_Command);
// 11/26/2005 Add fields early so that sort events will get called.
m_sMODULE = "UserLogins";
SetMenu("Users");
// 02/08/2008 We need to build a list of the fields used by the search clause.
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("FULL_NAME");
// 02/21/2008 IS_ADMIN is used in the grid.
arrSelectFields.Add("IS_ADMIN");
arrSelectFields.Add("DATE_MODIFIED");
this.AppendGridColumns(grdMain, "Users.LoginView", arrSelectFields);
}
// 04/20/2011 Create a new method so that we can get export field.
public static void GridColumns(string sGRID_NAME, UniqueStringCollection arrSelectFields, StringCollection arrSkippedFields)
{
DataTable dt = SplendidCache.GridViewColumns(sGRID_NAME);
if ( dt != null )
{
// 01/18/2010 To apply ACL Field Security, we need to know if the Module Name, which we will extract from the EditView Name.
string sMODULE_NAME = String.Empty;
string[] arrGRID_NAME = sGRID_NAME.Split('.');
if ( arrGRID_NAME.Length > 0 )
{
if ( arrGRID_NAME[0] == "ListView" || arrGRID_NAME[0] == "PopupView" || arrGRID_NAME[0] == "Activities" )
sMODULE_NAME = arrGRID_NAME[0];
// 01/18/2010 A sub-panel should apply the access rules of the related module.
else if ( Sql.ToBoolean(HttpContext.Current.Application["Modules." + arrGRID_NAME[1] + ".Valid"]) )
sMODULE_NAME = arrGRID_NAME[1];
else
sMODULE_NAME = arrGRID_NAME[0];
}
foreach(DataRow row in dt.Rows)
{
string sCOLUMN_TYPE = Sql.ToString (row["COLUMN_TYPE"]);
string sDATA_FIELD = Sql.ToString (row["DATA_FIELD" ]);
string sDATA_FORMAT = Sql.ToString (row["DATA_FORMAT"]);
// 04/20/2011 Export requests will not exclude any fields.
if ( arrSkippedFields != null )
{
if ( arrSkippedFields.Contains(sDATA_FIELD) || sDATA_FIELD.EndsWith("_ID") || sDATA_FIELD.EndsWith("_CURRENCY") )
continue;
}
// 01/18/2010 A field is either visible or not. At this time, we will not only show a field to its owner.
bool bIsReadable = true;
if ( SplendidInit.bEnableACLFieldSecurity && !Sql.IsEmptyString(sDATA_FIELD) )
{
Security.ACL_FIELD_ACCESS acl = Security.GetUserFieldSecurity(sMODULE_NAME, sDATA_FIELD, Guid.Empty);
bIsReadable = acl.IsReadable();
}
if ( bIsReadable )
{
if ( String.Compare(sCOLUMN_TYPE, "TemplateColumn", true) == 0 )
{
if ( String.Compare(sDATA_FORMAT, "HyperLink", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
arrSelectFields.Add(sDATA_FIELD);
}
}
else if ( String.Compare(sCOLUMN_TYPE, "BoundColumn", true) == 0 )
{
// 09/23/2010 Add the bound field.
if ( !Sql.IsEmptyString(sDATA_FIELD) )
arrSelectFields.Add(sDATA_FIELD);
}
}
}
}
}
public void Start()
{
ThreadStart start = null;
object obj2;
QueryCore core;
lock ((obj2 = this._locker))
{
core = this._query;
if ((core == null) || this._cancelRequest)
{
return;
}
if (this._executionProgress != LINQPad.ExecutionModel.ExecutionProgress.Starting)
{
throw new InvalidOperationException("Cannot call Start twice on Client");
}
}
if ((core.QueryKind == QueryLanguage.SQL) || (core.QueryKind == QueryLanguage.ESQL))
{
if (this._compileOnly)
{
this.OnQueryCompleted("", "");
}
else
{
lock ((obj2 = this._locker))
{
this._executionProgress = LINQPad.ExecutionModel.ExecutionProgress.Executing;
}
Server server = this._serverGenerator(this);
lock ((obj2 = this._locker))
{
if (this._cancelRequest || (server == null))
{
return;
}
if (this._server != server)
{
this.ClearServer();
}
this._server = server;
}
server.WriteResultsToGrids = core.ToDataGrids && (core.QueryKind == QueryLanguage.SQL);
UniqueStringCollection source = new UniqueStringCollection(new FileNameComparer());
if (core.GetDriver(true) != null)
{
try
{
source.AddRange(core.Repository.GetDriverAssemblies());
if (!((core.QueryKind != QueryLanguage.ESQL) || string.IsNullOrEmpty(core.Repository.CustomAssemblyPath)))
{
source.Add(core.Repository.CustomAssemblyPath);
}
}
catch
{
}
}
server.ExecuteSqlQuery(core.QueryKind, core.Repository, this._source, source.ToArray <string>(), this, this._pluginWinManager);
}
}
else if ((core.Repository != null) && core.Repository.DynamicSchema)
{
lock ((obj2 = this._locker))
{
this._executionProgress = LINQPad.ExecutionModel.ExecutionProgress.AwaitingDataContext;
}
DataContextManager.GetDataContextInfo(core.Repository, new DataContextCallback(this.GotDataContext), SchemaChangeTestMode.None);
}
else
{
if (start == null)
{
start = () => this.CompileAndRun(null);
}
new Thread(start)
{
Name = "Query Compiler", IsBackground = true
}.Start();
}
}
// 02/08/2008 We need to build a list of the fields used by the search clause.
protected void AppendGridColumns(SplendidGrid grd, string sGRID_NAME, UniqueStringCollection arrSelectFields)
{
// 11/17/2007 Convert all view requests to a mobile request if appropriate.
sGRID_NAME = sGRID_NAME + (this.IsMobile ? ".Mobile" : "");
grd.AppendGridColumns(sGRID_NAME, arrSelectFields);
}
// 02/08/2008 We need to build a list of the fields used by the dynamic grid.
public void AppendGridColumns(string sGRID_NAME, UniqueStringCollection arrSelectFields)
{
SplendidDynamic.AppendGridColumns(sGRID_NAME, this, arrSelectFields, null);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
ctlSearchView .Command += new CommandEventHandler(Page_Command);
ctlNewRecord .Command += new CommandEventHandler(Page_Command);
ctlCheckAll .Command += new CommandEventHandler(Page_Command);
m_sMODULE = "BusinessRules";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("NAME");
this.AppendGridColumns(grdMain, m_sMODULE + ".PopupView", arrSelectFields);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".Popup" + (bMultiSelect ? "MultiSelect" : "View"), Guid.Empty, Guid.Empty);
if ( !IsPostBack && !bMultiSelect )
ctlDynamicButtons.ShowButton("Clear", !Sql.ToBoolean(Request["ClearDisabled"]));
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
ctlSearchView .Command += new CommandEventHandler(Page_Command);
m_sMODULE = "DynamicLayout";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("DETAIL_NAME");
this.AppendGridColumns(grdMain, m_sMODULE + ".DetailView.PopupView", arrSelectFields);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".PopupView", Guid.Empty, Guid.Empty);
}
public static void AppendGridColumns(string sGRID_NAME, DataGrid grd, UniqueStringCollection arrSelectFields)
{
if (grd == null)
{
return;
}
DataTable dt = CRMCache.GridViewColumns(sGRID_NAME);
if (dt != null)
{
DataView dv = dt.DefaultView;
dv.Sort = "COLUMN_INDEX";
bool bEnableTeamManagement = Common.Config.enable_team_management();
foreach (DataRowView row in dv)
{
int nCOLUMN_INDEX = TypeConvert.ToInteger(row["COLUMN_INDEX"]);
string sCOLUMN_TYPE = TypeConvert.ToString(row["COLUMN_TYPE"]);
string sHEADER_TEXT = TypeConvert.ToString(row["HEADER_TEXT"]);
string sSORT_EXPRESSION = TypeConvert.ToString(row["SORT_EXPRESSION"]);
string sITEMSTYLE_WIDTH = TypeConvert.ToString(row["ITEMSTYLE_WIDTH"]);
string sITEMSTYLE_CSSCLASS = TypeConvert.ToString(row["ITEMSTYLE_CSSCLASS"]);
string sITEMSTYLE_HORIZONTAL_ALIGN = TypeConvert.ToString(row["ITEMSTYLE_HORIZONTAL_ALIGN"]);
string sITEMSTYLE_VERTICAL_ALIGN = TypeConvert.ToString(row["ITEMSTYLE_VERTICAL_ALIGN"]);
bool bITEMSTYLE_WRAP = TypeConvert.ToBoolean(row["ITEMSTYLE_WRAP"]);
string sDATA_FIELD = TypeConvert.ToString(row["DATA_FIELD"]);
string sDATA_FORMAT = TypeConvert.ToString(row["DATA_FORMAT"]);
string sURL_FIELD = TypeConvert.ToString(row["URL_FIELD"]);
string sURL_FORMAT = TypeConvert.ToString(row["URL_FORMAT"]);
string sURL_TARGET = TypeConvert.ToString(row["URL_TARGET"]);
string sLIST_NAME = TypeConvert.ToString(row["LIST_NAME"]);
string sURL_MODULE = TypeConvert.ToString(row["URL_MODULE"]);
string sURL_ASSIGNED_FIELD = TypeConvert.ToString(row["URL_ASSIGNED_FIELD"]);
if (arrSelectFields != null)
{
arrSelectFields.Add(sDATA_FIELD);
if (!TypeConvert.IsEmptyString(sSORT_EXPRESSION))
arrSelectFields.Add(sSORT_EXPRESSION);
if (!TypeConvert.IsEmptyString(sURL_FIELD))
{
if (sURL_FIELD.IndexOf(' ') >= 0)
arrSelectFields.AddRange(sURL_FIELD.Split(' '));
else
arrSelectFields.Add(sURL_FIELD);
if (!TypeConvert.IsEmptyString(sURL_ASSIGNED_FIELD))
arrSelectFields.Add(sURL_ASSIGNED_FIELD);
}
}
HorizontalAlign eHorizontalAlign = HorizontalAlign.NotSet;
switch (sITEMSTYLE_HORIZONTAL_ALIGN.ToLower())
{
case "left": eHorizontalAlign = HorizontalAlign.Left; break;
case "right": eHorizontalAlign = HorizontalAlign.Right; break;
}
VerticalAlign eVerticalAlign = VerticalAlign.NotSet;
switch (sITEMSTYLE_VERTICAL_ALIGN.ToLower())
{
case "top": eVerticalAlign = VerticalAlign.Top; break;
case "middle": eVerticalAlign = VerticalAlign.Middle; break;
case "bottom": eVerticalAlign = VerticalAlign.Bottom; break;
}
if (row["ITEMSTYLE_WRAP"] == DBNull.Value)
bITEMSTYLE_WRAP = true;
DataGridColumn col = null;
if (String.Compare(sCOLUMN_TYPE, "BoundColumn", true) == 0
&& (String.Compare(sDATA_FORMAT, "Date", true) == 0
|| String.Compare(sDATA_FORMAT, "DateTime", true) == 0
|| String.Compare(sDATA_FORMAT, "Currency", true) == 0
|| String.Compare(sDATA_FORMAT, "Image", true) == 0
)
)
{
sCOLUMN_TYPE = "TemplateColumn";
}
if (String.Compare(sCOLUMN_TYPE, "BoundColumn", true) == 0)
{
if (TypeConvert.IsEmptyString(sLIST_NAME))
{
BoundColumn bnd = new BoundColumn();
bnd.HeaderText = sHEADER_TEXT;
bnd.DataField = sDATA_FIELD;
bnd.SortExpression = sSORT_EXPRESSION;
bnd.ItemStyle.Width = new Unit(sITEMSTYLE_WIDTH);
bnd.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
bnd.ItemStyle.HorizontalAlign = eHorizontalAlign;
bnd.ItemStyle.VerticalAlign = eVerticalAlign;
bnd.ItemStyle.Wrap = bITEMSTYLE_WRAP;
bnd.HeaderStyle.HorizontalAlign = eHorizontalAlign;
col = bnd;
}
else
{
TemplateColumn tpl = new TemplateColumn();
tpl.HeaderText = sHEADER_TEXT;
tpl.SortExpression = sSORT_EXPRESSION;
tpl.ItemStyle.Width = new Unit(sITEMSTYLE_WIDTH);
tpl.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
tpl.ItemStyle.HorizontalAlign = eHorizontalAlign;
tpl.ItemStyle.VerticalAlign = eVerticalAlign;
tpl.ItemStyle.Wrap = bITEMSTYLE_WRAP;
tpl.HeaderStyle.HorizontalAlign = eHorizontalAlign;
tpl.ItemTemplate = new CreateItemTemplateLiteralList(sDATA_FIELD, sLIST_NAME);
col = tpl;
}
}
else if (String.Compare(sCOLUMN_TYPE, "TemplateColumn", true) == 0)
{
TemplateColumn tpl = new TemplateColumn();
tpl.HeaderText = sHEADER_TEXT;
tpl.SortExpression = sSORT_EXPRESSION;
tpl.ItemStyle.Width = new Unit(sITEMSTYLE_WIDTH);
tpl.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
tpl.ItemStyle.HorizontalAlign = eHorizontalAlign;
tpl.ItemStyle.VerticalAlign = eVerticalAlign;
tpl.ItemStyle.Wrap = bITEMSTYLE_WRAP;
tpl.HeaderStyle.HorizontalAlign = eHorizontalAlign;
if (String.Compare(sDATA_FORMAT, "HyperLink", true) == 0)
{
if (sURL_FIELD.IndexOf(' ') >= 0)
tpl.ItemTemplate = new CreateItemTemplateHyperLinkOnClick(sDATA_FIELD, sURL_FIELD, sURL_FORMAT, sURL_TARGET, sITEMSTYLE_CSSCLASS, sURL_MODULE, sURL_ASSIGNED_FIELD);
else
tpl.ItemTemplate = new CreateItemTemplateHyperLink(sDATA_FIELD, sURL_FIELD, sURL_FORMAT, sURL_TARGET, sITEMSTYLE_CSSCLASS, sURL_MODULE, sURL_ASSIGNED_FIELD);
}
else if (String.Compare(sDATA_FORMAT, "Image", true) == 0)
{
tpl.ItemTemplate = new CreateItemTemplateImage(sDATA_FIELD, sITEMSTYLE_CSSCLASS);
}
else
{
tpl.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
tpl.ItemTemplate = new CreateItemTemplateLiteral(sDATA_FIELD, sDATA_FORMAT);
}
col = tpl;
}
else if (String.Compare(sCOLUMN_TYPE, "HyperLinkColumn", true) == 0)
{
HyperLinkColumn lnk = new HyperLinkColumn();
lnk.HeaderText = sHEADER_TEXT;
lnk.DataTextField = sDATA_FIELD;
lnk.SortExpression = sSORT_EXPRESSION;
lnk.DataNavigateUrlField = sURL_FIELD;
lnk.DataNavigateUrlFormatString = sURL_FORMAT;
lnk.Target = sURL_TARGET;
lnk.ItemStyle.Width = new Unit(sITEMSTYLE_WIDTH);
lnk.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
lnk.ItemStyle.HorizontalAlign = eHorizontalAlign;
lnk.ItemStyle.VerticalAlign = eVerticalAlign;
lnk.ItemStyle.Wrap = bITEMSTYLE_WRAP;
lnk.HeaderStyle.HorizontalAlign = eHorizontalAlign;
col = lnk;
}
if (col != null)
{
if (sDATA_FIELD == "TEAM_NAME" && !bEnableTeamManagement)
{
col.Visible = false;
}
if (nCOLUMN_INDEX >= grd.Columns.Count)
grd.Columns.Add(col);
else
grd.Columns.AddAt(nCOLUMN_INDEX, col);
}
}
}
}
public void Start()
{
ThreadStart start = null;
object obj2;
QueryCore core;
lock ((obj2 = this._locker))
{
core = this._query;
if ((core == null) || this._cancelRequest)
{
return;
}
if (this._executionProgress != LINQPad.ExecutionModel.ExecutionProgress.Starting)
{
throw new InvalidOperationException("Cannot call Start twice on Client");
}
}
if ((core.QueryKind == QueryLanguage.SQL) || (core.QueryKind == QueryLanguage.ESQL))
{
if (this._compileOnly)
{
this.OnQueryCompleted("", "");
}
else
{
lock ((obj2 = this._locker))
{
this._executionProgress = LINQPad.ExecutionModel.ExecutionProgress.Executing;
}
Server server = this._serverGenerator(this);
lock ((obj2 = this._locker))
{
if (this._cancelRequest || (server == null))
{
return;
}
if (this._server != server)
{
this.ClearServer();
}
this._server = server;
}
server.WriteResultsToGrids = core.ToDataGrids && (core.QueryKind == QueryLanguage.SQL);
UniqueStringCollection source = new UniqueStringCollection(new FileNameComparer());
if (core.GetDriver(true) != null)
{
try
{
source.AddRange(core.Repository.GetDriverAssemblies());
if (!((core.QueryKind != QueryLanguage.ESQL) || string.IsNullOrEmpty(core.Repository.CustomAssemblyPath)))
{
source.Add(core.Repository.CustomAssemblyPath);
}
}
catch
{
}
}
server.ExecuteSqlQuery(core.QueryKind, core.Repository, this._source, source.ToArray<string>(), this, this._pluginWinManager);
}
}
else if ((core.Repository != null) && core.Repository.DynamicSchema)
{
lock ((obj2 = this._locker))
{
this._executionProgress = LINQPad.ExecutionModel.ExecutionProgress.AwaitingDataContext;
}
DataContextManager.GetDataContextInfo(core.Repository, new DataContextCallback(this.GotDataContext), SchemaChangeTestMode.None);
}
else
{
if (start == null)
{
start = () => this.CompileAndRun(null);
}
new Thread(start) { Name = "Query Compiler", IsBackground = true }.Start();
}
}
private void GetAssemblyReferenceMap(out FileWithVersionInfo[] volatileRefs, out FileWithVersionInfo[] nonvolatileRefs)
{
string fileName = null;
UniqueStringCollection strings = new UniqueStringCollection(base.AllFileReferences, new FileNameComparer());
strings.AddRange(PluginAssembly.GetCompatibleAssemblies(base.IsMyExtensions));
if ((base.Repository != null) && !base.Repository.DynamicSchema)
{
strings.Add(base.Repository.CustomAssemblyPath);
strings.AddRange(base.Repository.GetDriverAssemblies());
if (base.Repository.DriverLoader.IsValid && (base.Repository.DriverLoader.InternalID == null))
{
try
{
fileName = Path.GetFileName(base.Repository.DriverLoader.GetAssemblyPath());
}
catch
{
}
}
}
List<FileWithVersionInfo> list = new List<FileWithVersionInfo>();
List<string> assemblyFilePaths = new List<string>();
foreach (string str2 in strings)
{
try
{
if (Path.IsPathRooted(str2) && File.Exists(str2))
{
if (!(ShadowAssemblyManager.IsShadowable(str2) && !Path.GetFileName(str2).Equals(fileName, StringComparison.OrdinalIgnoreCase)))
{
list.Add(new FileWithVersionInfo(str2));
}
else
{
assemblyFilePaths.Add(str2);
}
}
}
catch
{
}
}
nonvolatileRefs = (from r in list
orderby r.FilePath
select r).ToArray<FileWithVersionInfo>();
volatileRefs = AssemblyProber.GetSameFolderAssemblyReferenceChain(assemblyFilePaths);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
m_sMODULE = "TQQuoteCheck";
SetMenu(m_sMODULE);
// 02/08/2008 We need to build a list of the fields used by the search clause.
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("ID");
arrSelectFields.Add("C_Status");
this.AppendGridColumns(grdMain, m_sMODULE + "." + LayoutListView, arrSelectFields);
grdMain.ItemCommand += grdMain_ItemCommand;
}
// 02/08/2008 We need to build a list of the fields used by the dynamic grid.
// 03/01/2014 Add Preview button.
public static void AppendGridColumns(string sGRID_NAME, DataGrid grd, UniqueStringCollection arrSelectFields, CommandEventHandler Page_Command)
{
if ( grd == null )
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), "DataGrid is not defined for " + sGRID_NAME);
return;
}
DataTable dt = SplendidCache.GridViewColumns(sGRID_NAME);
if ( dt != null )
{
// 01/01/2008 Pull config flag outside the loop.
bool bEnableTeamManagement = Crm.Config.enable_team_management();
// 08/28/2009 Allow dynamic teams to be turned off.
bool bEnableDynamicTeams = Crm.Config.enable_dynamic_teams();
foreach(DataRow row in dt.Rows)
{
int nCOLUMN_INDEX = Sql.ToInteger(row["COLUMN_INDEX" ]);
string sCOLUMN_TYPE = Sql.ToString (row["COLUMN_TYPE" ]);
string sHEADER_TEXT = Sql.ToString (row["HEADER_TEXT" ]);
string sSORT_EXPRESSION = Sql.ToString (row["SORT_EXPRESSION" ]);
string sITEMSTYLE_WIDTH = Sql.ToString (row["ITEMSTYLE_WIDTH" ]);
string sITEMSTYLE_CSSCLASS = Sql.ToString (row["ITEMSTYLE_CSSCLASS" ]);
string sITEMSTYLE_HORIZONTAL_ALIGN = Sql.ToString (row["ITEMSTYLE_HORIZONTAL_ALIGN"]);
string sITEMSTYLE_VERTICAL_ALIGN = Sql.ToString (row["ITEMSTYLE_VERTICAL_ALIGN" ]);
bool bITEMSTYLE_WRAP = Sql.ToBoolean(row["ITEMSTYLE_WRAP" ]);
string sDATA_FIELD = Sql.ToString (row["DATA_FIELD" ]);
string sDATA_FORMAT = Sql.ToString (row["DATA_FORMAT" ]);
string sURL_FIELD = Sql.ToString (row["URL_FIELD" ]);
string sURL_FORMAT = Sql.ToString (row["URL_FORMAT" ]);
string sURL_TARGET = Sql.ToString (row["URL_TARGET" ]);
string sLIST_NAME = Sql.ToString (row["LIST_NAME" ]);
// 04/28/2006 The module is necessary in order to determine if a user has access.
string sURL_MODULE = Sql.ToString (row["URL_MODULE" ]);
// 05/02/2006 The assigned user id is necessary if the user only has Owner access.
string sURL_ASSIGNED_FIELD = Sql.ToString (row["URL_ASSIGNED_FIELD" ]);
// 02/16/2010 Add MODULE_TYPE so that we can lookup custom field IDs.
string sMODULE_TYPE = String.Empty;
try
{
sMODULE_TYPE = Sql.ToString (row["MODULE_TYPE"]);
}
catch(Exception ex)
{
// 06/16/2010 The MODULE_TYPE is not in the view, then log the error and continue.
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
// 10/09/2010 Add PARENT_FIELD so that we can establish dependent listboxes.
string sPARENT_FIELD = String.Empty;
try
{
sPARENT_FIELD = Sql.ToString (row["PARENT_FIELD"]);
}
catch(Exception ex)
{
// 10/09/2010 The PARENT_FIELD is not in the view, then log the error and continue.
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
if ( (sDATA_FIELD == "TEAM_NAME" || sDATA_FIELD == "TEAM_SET_NAME") )
{
if ( bEnableTeamManagement && bEnableDynamicTeams )
{
sHEADER_TEXT = ".LBL_LIST_TEAM_SET_NAME";
sDATA_FIELD = "TEAM_SET_NAME";
}
}
// 02/08/2008 We need to build a list of the fields used by the dynamic grid.
if ( arrSelectFields != null )
{
// 08/02/2010 The JavaScript and Hover fields will not have a data field.
if ( !Sql.IsEmptyString(sDATA_FIELD) )
arrSelectFields.Add(sDATA_FIELD);
if ( !Sql.IsEmptyString(sSORT_EXPRESSION) )
arrSelectFields.Add(sSORT_EXPRESSION);
if ( !Sql.IsEmptyString(sURL_FIELD) )
{
// 08/02/2010 We want to allow Terminology fields, so exclude anything with a "."
if ( sURL_FIELD.IndexOf(' ') >= 0 )
{
string[] arrURL_FIELD = sURL_FIELD.Split(' ');
foreach ( string s in arrURL_FIELD )
{
if ( !s.Contains(".") && !Sql.IsEmptyString(s) )
arrSelectFields.Add(s);
}
}
else if ( !sURL_FIELD.Contains(".") )
arrSelectFields.Add(sURL_FIELD);
if ( !Sql.IsEmptyString(sURL_ASSIGNED_FIELD) )
arrSelectFields.Add(sURL_ASSIGNED_FIELD);
}
// 10/09/2010 Add PARENT_FIELD so that we can establish dependent listboxes.
if ( !Sql.IsEmptyString(sPARENT_FIELD) )
arrSelectFields.Add(sPARENT_FIELD);
}
HorizontalAlign eHorizontalAlign = HorizontalAlign.NotSet;
switch ( sITEMSTYLE_HORIZONTAL_ALIGN.ToLower() )
{
case "left" : eHorizontalAlign = HorizontalAlign.Left ; break;
case "right": eHorizontalAlign = HorizontalAlign.Right; break;
}
VerticalAlign eVerticalAlign = VerticalAlign.NotSet;
switch ( sITEMSTYLE_VERTICAL_ALIGN.ToLower() )
{
case "top" : eVerticalAlign = VerticalAlign.Top ; break;
case "middle": eVerticalAlign = VerticalAlign.Middle; break;
case "bottom": eVerticalAlign = VerticalAlign.Bottom; break;
}
// 11/28/2005 Wrap defaults to true.
if ( row["ITEMSTYLE_WRAP"] == DBNull.Value )
bITEMSTYLE_WRAP = true;
// 01/18/2010 To apply ACL Field Security, we need to know if the Module Name, which we will extract from the EditView Name.
string sMODULE_NAME = String.Empty;
string[] arrGRID_NAME = sGRID_NAME.Split('.');
if ( arrGRID_NAME.Length > 0 )
{
if ( arrGRID_NAME[0] == "ListView" || arrGRID_NAME[0] == "PopupView" || arrGRID_NAME[0] == "Activities" )
sMODULE_NAME = arrGRID_NAME[0];
// 01/18/2010 A sub-panel should apply the access rules of the related module.
else if ( Sql.ToBoolean(HttpContext.Current.Application["Modules." + arrGRID_NAME[1] + ".Valid"]) )
sMODULE_NAME = arrGRID_NAME[1];
else
sMODULE_NAME = arrGRID_NAME[0];
}
// 01/18/2010 A field is either visible or not. At this time, we will not only show a field to its owner.
bool bIsReadable = true;
// 08/02/2010 The JavaScript and Hover fields will not have a data field.
if ( SplendidInit.bEnableACLFieldSecurity && !Sql.IsEmptyString(sDATA_FIELD) )
{
Security.ACL_FIELD_ACCESS acl = Security.GetUserFieldSecurity(sMODULE_NAME, sDATA_FIELD, Guid.Empty);
bIsReadable = acl.IsReadable();
}
DataGridColumn col = null;
// 02/03/2006 Date and Currency must always be handled by CreateItemTemplateLiteral.
// Otherwise, the date or time will not get properly translated to the correct timezone.
// This bug was reported by David Williams.
// 05/20/2009 We need a way to preserve CRLF in description fields.
if ( String.Compare(sCOLUMN_TYPE, "BoundColumn", true) == 0
&& ( String.Compare(sDATA_FORMAT, "Date" , true) == 0
|| String.Compare(sDATA_FORMAT, "DateTime" , true) == 0
|| String.Compare(sDATA_FORMAT, "Currency" , true) == 0
|| String.Compare(sDATA_FORMAT, "Image" , true) == 0
|| String.Compare(sDATA_FORMAT, "MultiLine" , true) == 0
)
)
{
sCOLUMN_TYPE = "TemplateColumn";
}
// 03/14/2014 A hidden field does not render. It is primarily used to add a field to the SQL select list for Business Rules management.
else if ( String.Compare(sCOLUMN_TYPE, "Hidden", true) == 0 )
{
continue;
}
if ( String.Compare(sCOLUMN_TYPE, "BoundColumn", true) == 0 )
{
if ( Sql.IsEmptyString(sLIST_NAME) )
{
// GRID_NAME, COLUMN_ORDER, COLUMN_TYPE, HEADER_TEXT, DATA_FIELD, SORT_EXPRESSION, ITEMSTYLE_WIDTH
BoundColumn bnd = new BoundColumn();
bnd.HeaderText = sHEADER_TEXT ;
bnd.DataField = sDATA_FIELD ;
bnd.SortExpression = sSORT_EXPRESSION ;
bnd.ItemStyle.Width = new Unit(sITEMSTYLE_WIDTH);
bnd.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
bnd.ItemStyle.HorizontalAlign = eHorizontalAlign ;
bnd.ItemStyle.VerticalAlign = eVerticalAlign ;
bnd.ItemStyle.Wrap = bITEMSTYLE_WRAP ;
// 04/13/2007 Align the headers to match the data.
bnd.HeaderStyle.HorizontalAlign = eHorizontalAlign ;
col = bnd;
// 01/18/2010 Apply ACL Field Security.
col.Visible = bIsReadable;
// 10/23/2012 Kevin. Allow me to pass data format for gridview bound columns.
if ( !Sql.IsEmptyString(sDATA_FORMAT) )
{
bnd.DataFormatString = sDATA_FORMAT;
}
}
else
{
// GRID_NAME, COLUMN_ORDER, COLUMN_TYPE, HEADER_TEXT, DATA_FIELD, SORT_EXPRESSION, ITEMSTYLE_WIDTH
TemplateColumn tpl = new TemplateColumn();
tpl.HeaderText = sHEADER_TEXT ;
tpl.SortExpression = sSORT_EXPRESSION ;
tpl.ItemStyle.Width = new Unit(sITEMSTYLE_WIDTH);
tpl.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
tpl.ItemStyle.HorizontalAlign = eHorizontalAlign ;
tpl.ItemStyle.VerticalAlign = eVerticalAlign ;
tpl.ItemStyle.Wrap = bITEMSTYLE_WRAP ;
// 04/13/2007 Align the headers to match the data.
tpl.HeaderStyle.HorizontalAlign = eHorizontalAlign ;
// 10/09/2010 Add PARENT_FIELD so that we can establish dependent listboxes.
tpl.ItemTemplate = new CreateItemTemplateLiteralList(sDATA_FIELD, sLIST_NAME, sPARENT_FIELD);
col = tpl;
// 01/18/2010 Apply ACL Field Security.
col.Visible = bIsReadable;
}
}
else if ( String.Compare(sCOLUMN_TYPE, "TemplateColumn", true) == 0 )
{
// GRID_NAME, COLUMN_ORDER, COLUMN_TYPE, HEADER_TEXT, DATA_FIELD, SORT_EXPRESSION, ITEMSTYLE_WIDTH
TemplateColumn tpl = new TemplateColumn();
tpl.HeaderText = sHEADER_TEXT ;
tpl.SortExpression = sSORT_EXPRESSION ;
tpl.ItemStyle.Width = new Unit(sITEMSTYLE_WIDTH);
tpl.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
tpl.ItemStyle.HorizontalAlign = eHorizontalAlign ;
tpl.ItemStyle.VerticalAlign = eVerticalAlign ;
tpl.ItemStyle.Wrap = bITEMSTYLE_WRAP ;
// 04/13/2007 Align the headers to match the data.
tpl.HeaderStyle.HorizontalAlign = eHorizontalAlign ;
if ( String.Compare(sDATA_FORMAT, "JavaScript", true) == 0 )
{
// 08/02/2010 In our application of Field Level Security, we will hide fields by replacing with "."
if ( SplendidInit.bEnableACLFieldSecurity && !Sql.IsEmptyString(sURL_FIELD) )
{
string[] arrURL_FIELD = sURL_FIELD.Split(' ');
for ( int i=0; i < arrURL_FIELD.Length; i++ )
{
Security.ACL_FIELD_ACCESS acl = Security.GetUserFieldSecurity(sMODULE_NAME, sDATA_FIELD, Guid.Empty);
if ( !acl.IsReadable() )
arrURL_FIELD[i] = ".";
}
sURL_FIELD = String.Join(" ", arrURL_FIELD);
}
tpl.ItemTemplate = new CreateItemTemplateJavaScript(sDATA_FIELD, sURL_FIELD, sURL_FORMAT, sURL_TARGET);
}
// 02/26/2014 Add Preview button.
else if ( String.Compare(sDATA_FORMAT, "JavaImage", true) == 0 )
{
if ( SplendidInit.bEnableACLFieldSecurity && !Sql.IsEmptyString(sURL_FIELD) )
{
string[] arrURL_FIELD = sURL_FIELD.Split(' ');
for ( int i=0; i < arrURL_FIELD.Length; i++ )
{
Security.ACL_FIELD_ACCESS acl = Security.GetUserFieldSecurity(sMODULE_NAME, sDATA_FIELD, Guid.Empty);
if ( !acl.IsReadable() )
arrURL_FIELD[i] = ".";
}
sURL_FIELD = String.Join(" ", arrURL_FIELD);
}
tpl.ItemTemplate = new CreateItemTemplateJavaScriptImage(sURL_FIELD, sURL_FORMAT, sURL_TARGET);
}
// 03/01/2014 Add Preview button.
else if ( String.Compare(sDATA_FORMAT, "ImageButton", true) == 0 )
{
// 03/01/2014 sURL_FIELD is an internal value, so there is no need to apply ACL rules.
tpl.ItemTemplate = new CreateItemTemplateImageButton(sURL_FIELD, sURL_FORMAT, sURL_TARGET, sITEMSTYLE_CSSCLASS, Page_Command);
}
else if ( String.Compare(sDATA_FORMAT, "Hover", true) == 0 )
{
string sIMAGE_SKIN = sURL_TARGET;
if ( Sql.IsEmptyString(sIMAGE_SKIN) )
sIMAGE_SKIN = "info_inline";
// 08/02/2010 In our application of Field Level Security, we will hide fields by replacing with "."
if ( SplendidInit.bEnableACLFieldSecurity && !Sql.IsEmptyString(sURL_FIELD) )
{
string[] arrURL_FIELD = sURL_FIELD.Split(' ');
for ( int i=0; i < arrURL_FIELD.Length; i++ )
{
Security.ACL_FIELD_ACCESS acl = Security.GetUserFieldSecurity(sMODULE_NAME, sDATA_FIELD, Guid.Empty);
if ( !acl.IsReadable() )
arrURL_FIELD[i] = ".";
}
sURL_FIELD = String.Join(" ", arrURL_FIELD);
}
tpl.ItemTemplate = new CreateItemTemplateHover(sDATA_FIELD, sURL_FIELD, sURL_FORMAT, sIMAGE_SKIN);
}
else if ( String.Compare(sDATA_FORMAT, "HyperLink", true) == 0 )
{
// 07/26/2007 PopupViews have special requirements. They need an OnClick action that takes more than one parameter.
if ( sURL_FIELD.IndexOf(' ') >= 0 )
tpl.ItemTemplate = new CreateItemTemplateHyperLinkOnClick(sDATA_FIELD, sURL_FIELD, sURL_FORMAT, sURL_TARGET, sITEMSTYLE_CSSCLASS, sURL_MODULE, sURL_ASSIGNED_FIELD, sMODULE_TYPE);
else
tpl.ItemTemplate = new CreateItemTemplateHyperLink(sDATA_FIELD, sURL_FIELD, sURL_FORMAT, sURL_TARGET, sITEMSTYLE_CSSCLASS, sURL_MODULE, sURL_ASSIGNED_FIELD, sMODULE_TYPE);
}
else if ( String.Compare(sDATA_FORMAT, "Image", true) == 0 )
{
tpl.ItemTemplate = new CreateItemTemplateImage(sDATA_FIELD, sITEMSTYLE_CSSCLASS);
}
else
{
tpl.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
tpl.ItemTemplate = new CreateItemTemplateLiteral(sDATA_FIELD, sDATA_FORMAT, sMODULE_TYPE);
}
col = tpl;
// 01/18/2010 Apply ACL Field Security.
col.Visible = bIsReadable;
}
else if ( String.Compare(sCOLUMN_TYPE, "HyperLinkColumn", true) == 0 )
{
// GRID_NAME, COLUMN_ORDER, COLUMN_TYPE, HEADER_TEXT, DATA_FIELD, SORT_EXPRESSION, ITEMSTYLE_WIDTH, ITEMSTYLE-CSSCLASS, URL_FIELD, URL_FORMAT
HyperLinkColumn lnk = new HyperLinkColumn();
lnk.HeaderText = sHEADER_TEXT ;
lnk.DataTextField = sDATA_FIELD ;
lnk.SortExpression = sSORT_EXPRESSION ;
lnk.DataNavigateUrlField = sURL_FIELD ;
lnk.DataNavigateUrlFormatString = sURL_FORMAT ;
lnk.Target = sURL_TARGET ;
lnk.ItemStyle.Width = new Unit(sITEMSTYLE_WIDTH);
lnk.ItemStyle.CssClass = sITEMSTYLE_CSSCLASS;
lnk.ItemStyle.HorizontalAlign = eHorizontalAlign ;
lnk.ItemStyle.VerticalAlign = eVerticalAlign ;
lnk.ItemStyle.Wrap = bITEMSTYLE_WRAP ;
// 04/13/2007 Align the headers to match the data.
lnk.HeaderStyle.HorizontalAlign = eHorizontalAlign ;
col = lnk;
// 01/18/2010 Apply ACL Field Security.
col.Visible = bIsReadable;
}
if ( col != null )
{
// 11/25/2006 If Team Management has been disabled, then hide the column.
// Keep the column, but hide it so that the remaining column positions will still be valid.
// 10/27/2007 The data field was changed to TEAM_NAME on 11/25/2006. It should have been changed here as well.
// 08/24/2009 Add support for dynamic teams.
if ( (sDATA_FIELD == "TEAM_NAME" || sDATA_FIELD == "TEAM_SET_NAME") && !bEnableTeamManagement )
{
col.Visible = false;
}
// 11/28/2005 In case the column specified is too high, just append column.
if ( nCOLUMN_INDEX >= grd.Columns.Count )
grd.Columns.Add(col);
else
grd.Columns.AddAt(nCOLUMN_INDEX, col);
}
}
}
// 09/20/2012 We need a SCRIPT field that is form specific.
if ( dt.Rows.Count > 0 )
{
try
{
string sFORM_SCRIPT = Sql.ToString(dt.Rows[0]["SCRIPT"]);
if ( !Sql.IsEmptyString(sFORM_SCRIPT) )
{
// 09/20/2012 The base ID is not the ID of the parent, but the ID of the TemplateControl.
sFORM_SCRIPT = sFORM_SCRIPT.Replace("SPLENDID_GRIDVIEW_LAYOUT_ID", grd.TemplateControl.ClientID);
ScriptManager.RegisterStartupScript(grd, typeof(System.String), sGRID_NAME.Replace(".", "_") + "_SCRIPT", sFORM_SCRIPT, true);
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
m_sMODULE = "UserSignatures";
arrSelectFields = new UniqueStringCollection();
arrSelectFields.Add("NAME");
this.AppendGridColumns(grdMain, "Users." + m_sMODULE, arrSelectFields);
if ( IsPostBack )
ctlDynamicButtons.AppendButtons("Users." + m_sMODULE, Guid.Empty, Guid.Empty);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
ctlDynamicButtons.Command += new CommandEventHandler(Page_Command);
ctlSearchView .Command += new CommandEventHandler(Page_Command);
m_sMODULE = "TQAccount";
arrSelectFields = new UniqueStringCollection();
this.AppendGridColumns(grdMain, m_sMODULE + ".PopupView", arrSelectFields);
if ( !IsPostBack)
ctlDynamicButtons.ShowButton("Clear", !Sql.ToBoolean(Request["ClearDisabled"]));
}
