public JQOptions()
{
ColumnCount = 2;
DialogTitle = "JQOptions";
items = new JQCollection<JQComboItem>(this);
OpenDialog = true;
}
public JQDataForm()
: base()
{
columns = new JQCollection<JQFormColumn>(this);
relationColumns = new JQCollection<JQRelationColumn>(this);
Title = "JQDataForm";
}
public JQDataForm()
{
columns = new JQCollection<JQFormColumn>(this);
relationColumns = new JQCollection<JQRelationColumn>(this);
HorizontalColumnsCount = 1;
ValidateStyle = ValidateStyleType.Hint;
toolitems = new JQCollection<JQToolItem>(this);
}
public JQBarChart()
{
Width = new Unit(600, UnitType.Pixel);
Height = new Unit(600, UnitType.Pixel);
Title = "JQBarChart";
barWidth = 20;
labelShow = true;
LegendShow = false;
stack = false;
pointLabels = true;
dataFields = new JQCollection<JQChartDataField>(this);
}
public JQReport()
{
parameters = new JQCollection<JQReportParameter>(this);
headerItems = new JQCollection<JQReportItem>(this);
fieldItems = new JQCollection<JQReportFieldItem>(this);
footerItems = new JQCollection<JQReportItem>(this);
queryColumns = new JQCollection<JQQueryColumn>(this);
//FieldFont = new System.Drawing.Font("Simsun", 9.0f);
DetailFont = new System.Drawing.Font("Simsun", 10.0f);
DetailHeaderFont = new System.Drawing.Font("Simsun", 12.0f);
HeaderFont = new System.Drawing.Font("Simsun", 12.0f);
HeaderBorderWidth = 1;
DetailBorderWidth = 1;
FooterBorderWidth = 1;
LabelCaptionWidth = 100;
LabelHorizontalGap = 50;
DataSetName = "NewDataSet";
HeaderDataSetName = "NewDataSetH";
}
public JQDataGrid()
: base()
{
RenderHeader = true;
RenderFooter = false;
PageSize = 10;
columns = new JQCollection<JQGridColumn>(this);
queryColumns = new JQCollection<JQQueryColumn>(this);
toolItems = new JQCollection<JQToolItem>(this);
GridViewType = JQMobileTools.GridViewType.Grid;
ListColumnCount = 2;
ListCaptionWidth = 120;
ToolItemsPosition = ToolItemsPostionType.Both;
AllowAdd = true;
AllowUpdate = true;
AllowDelete = true;
AllowView = true;
Title = "JQDataGrid";
}
public JQDataGrid()
{
columns = new JQCollection<JQGridColumn>(this);
relationColumns = new JQCollection<JQRelationColumn>(this);
toolitems = new JQCollection<JQToolItem>(this);
queryColumns = new JQCollection<JQQueryColumn>(this);
AutoApply = true;
EditOnEnter = true;
Pagination = true;
PageSize = 10;
PageList = "10,20,30,40,50";
MultiSelect = false;
ViewCommandVisible = true;
UpdateCommandVisible = true;
DeleteCommandVisible = true;
Title = "JQDataGrid";
QueryTitle = "Query";
TotalCaption = "Total:";
CheckOnSelect = true;
ColumnsHibeable = false;
}
public JQLineChart()
{
Width = new Unit(600, UnitType.Pixel);
Height = new Unit(600, UnitType.Pixel);
Title = "JQLineChart";
LegendShow = false;
dataFields = new JQCollection<JQLineChartDataField>(this);
}
public JQGridColumn()
{
Alignment = "left";
Width = 80;
Editor = JQEditorControl.TextBox;
QueryCondition = string.Empty;
_DrillFields = new JQCollection<JQDrillDownFields>(this);
}
private void GenDetailBlock(String TemplateName)
{
MWizard.TBlockItem BlockItem = null;
foreach (TBlockItem B in FClientData.Blocks)
{
if (B.wDataSource == null)
{
BlockItem = B;
break;
}
}
#if VS90
JQDefault Default = new JQDefault();
Default.ID = "defaultDetail"; // +BlockItem.TableName;
Default.BindingObjectID = "dataGridDetail";
JQValidate Validate = new JQValidate();
Validate.ID = "validateDetail"; // +BlockItem.TableName;
Validate.BindingObjectID = "dataGridDetail";
WebQueryFiledsCollection QueryFields = new WebQueryFiledsCollection(null, typeof(QueryField));
WebQueryColumnsCollection QueryColumns = new WebQueryColumnsCollection(null, typeof(QueryColumns));
foreach (TBlockFieldItem fielditem in BlockItem.BlockFieldItems)
{
GenDefault(fielditem, Default, Validate);
//GenQuery(fielditem, QueryFields, QueryColumns, BlockItem.TableName);
}
WebDevPage.IHTMLElement eJQDataGridDetail = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("dataGridDetail", 0);
if (eJQDataGridDetail != null)
{
((WebDevPage.IHTMLElement)eJQDataGridDetail).setAttribute("RemoteName", FClientData.ProviderName, 0);
((WebDevPage.IHTMLElement)eJQDataGridDetail).setAttribute("DataMember", BlockItem.TableName, 0);
StringBuilder sb = new StringBuilder(eJQDataGridDetail.innerHTML);
//sb.Append("<Columns>");
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
int idx = sb.ToString().LastIndexOf("</Columns>");
if (idx == -1)
{
sb.AppendLine("<Columns></Columns>");
idx = sb.ToString().LastIndexOf("</Columns>");
}
String sHeaderText = String.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description;
var relationOptions = string.Empty;
if ((BFI.ControlType == "RefValBox" || BFI.ControlType == "ComboBox") && !string.IsNullOrEmpty(BFI.ComboValueField) && !string.IsNullOrEmpty(BFI.ComboTextField)
&& !string.IsNullOrEmpty(BFI.ComboRemoteName) && !string.IsNullOrEmpty(BFI.ComboEntityName))
{
relationOptions = string.Format("RelationOptions=\"{{RemoteName:'{0}',DisplayMember:'{1}',ValueMember:'{2}'}}\""
, BFI.ComboRemoteName, BFI.ComboTextField, BFI.ComboValueField);
}
sb.Insert(idx, String.Format("<JQMobileTools:JQGridColumn Alignment=\"left\" FieldName=\"{0}\" Caption=\"{1}\" Width=\"120\" {2} Format=\"{3}\"/>", BFI.DataField, sHeaderText, relationOptions, BFI.EditMask));
}
//sb.Append("</Columns>");
eJQDataGridDetail.innerHTML = sb.ToString();
}
WebDevPage.IHTMLElement eJQDataFormDetail = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("dataFormDetail", 0);
if (eJQDataFormDetail != null)
{
StringBuilder sb = new StringBuilder();
((WebDevPage.IHTMLElement)eJQDataFormDetail).setAttribute("RemoteName", FClientData.ProviderName, 0);
((WebDevPage.IHTMLElement)eJQDataFormDetail).setAttribute("DataMember", BlockItem.TableName, 0);
sb.Append("<Columns>");
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
JQControl control = null;
string editor = "text";
String sHeaderText = String.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description;
if ((BFI.ControlType == "ComboBox" || BFI.ControlType == "ComboGrid" || BFI.ControlType == "RefValBox")
&& (string.IsNullOrEmpty(BFI.ComboValueField) || string.IsNullOrEmpty(BFI.ComboTextField)
|| string.IsNullOrEmpty(BFI.ComboRemoteName) || string.IsNullOrEmpty(BFI.ComboEntityName)))
{
BFI.ControlType = "TextBox";
}
if (BFI.ControlType == "ComboBox")
{
control = new JQSelects() { RemoteName = BFI.ComboRemoteName, DisplayMember = BFI.ComboTextField, ValueMember = BFI.ComboValueField };
editor = "selects";
}
else if (BFI.ControlType == "RefValBox")
{
control = new JQRefval() { RemoteName = BFI.ComboRemoteName, DisplayMember = BFI.ComboTextField, ValueMember = BFI.ComboValueField };
//(control as JQRefval).Columns.Add(new JQRefValColumn() { FieldName = BFI.ComboValueField, Caption = BFI.ComboValueFieldCaption });
editor = "refval";
}
else if (BFI.ControlType == "RadioButton")
{
control = new JQRadioButtons() { RemoteName = BFI.ComboRemoteName, DisplayMember = BFI.ComboTextField, ValueMember = BFI.ComboValueField };
editor = "radiobuttons";
}
else if (BFI.ControlType == "CheckBox")
{
JQCollection<JQDataItem> items = new JQCollection<JQDataItem>(control);
JQDataItem item1 = new JQDataItem();
item1.Text = "Yes"; item1.Value = "Yes";
JQDataItem item2 = new JQDataItem();
item2.Text = "No"; item2.Value = "No";
items.Add(item1);
items.Add(item2);
control = new JQCheckBoxes() { RemoteName = BFI.ComboRemoteName, DisplayMember = BFI.ComboTextField, ValueMember = BFI.ComboValueField, Items = items };
editor = "checkboxes";
}
else if (BFI.ControlType == "DateTimeBox")
{
control = new JQDate();
editor = "date";
}
else
{
control = new JQTextBox();
}
sb.AppendFormat("<{0}:{1} Caption=\"{2}\" FieldName=\"{3}\" Editor=\"{4}\" Width=\"120\" EditorOptions=\"{5}\"></{0}:{1}>"
, "JQMobileTools", "JQFormColumn", sHeaderText, BFI.DataField, editor, control.Options);
}
sb.Append("</Columns>");
if (BlockItem.Relation != null && BlockItem.Relation.ChildColumns.Length > 0)
{
sb.Append("<RelationColumns>");
for (int i = 0; i < BlockItem.Relation.ChildColumns.Length; i++)
{
sb.AppendFormat("<JQMobileTools:JQRelationColumn FieldName=\"{0}\" ParentFieldName=\"{1}\" />", BlockItem.Relation.ChildColumns[i].ColumnName, BlockItem.Relation.ParentColumns[i].ColumnName);
}
sb.Append("</RelationColumns>");
}
eJQDataFormDetail.innerHTML = sb.ToString();
WebDevPage.IHTMLElement Page = FDesignerDocument.pageContentElement;
Default.BindingObjectID = "dataFormDetail";
InsertControl(Page, Default);
Validate.BindingObjectID = "dataFormDetail";
InsertControl(Page, Validate);
}
#else
#endif
}
public JQTreeView()
{
columns = new JQCollection<JQTreeViewColumn>(this);
menuitems = new JQCollection<JQTreeViewContextItem>(this);
DialogTitle = "Dialog";
}
public JQRadioButtons()
{
Items = new JQCollection<JQDataItem>(this);
}
public JQRefval()
{
columns = new JQCollection<JQGridColumn>(this);
columnMatches = new JQCollection<JQColumnMatch>(this);
whereItems = new JQCollection<JQWhereItem>(this);
DialogTitle = "JQRefval";
CacheRelationText = true;
CheckData = true;
ShowValueAndText = false;
//DialogWidth = 450;
CapsLock = CapsLockEnum.None;
}
public JQCheckBoxes()
{
Items = new JQCollection<JQDataItem>(this);
}
public JQDrillDownDisplayFields()
{
_DrillFields = new JQCollection<JQDrillDownFields>((this) as IJQProperty);
Width = 80;
}
public JQSelects()
{
Items = new JQCollection<JQDataItem>(this);
Mode = JQSelectMode.dialog;
}
public JQRelation()
{
Items = new JQCollection<JQDataItem>(this);
WhereItems = new JQCollection<JQWhereItem>(this);
}
public JQRefval()
{
columns = new JQCollection<JQRefValColumn>(this);
whereItems = new JQCollection<JQWhereItem>(this);
columnMatches = new JQCollection<JQColumnMatch>(this);
queryColumns = new JQCollection<JQQueryColumn>(this);
PageSize = 20;
DialogTitle = "Select Item";
DialogWidth = 250;
}
public JQChartBase()
{
whereItems = new JQCollection<JQChartWhereItem>(this);
LegendLocation = LegendLocationEnum.ne;
LegendPlacement = LegendPlacementEnum.outsideGrid;
}
public JQTable()
{
fields = new JQCollection<AnalysisFieldItem>(this);
primaryKeys = new JQCollection<AnalysisPrimaryKey>(this);
}
public JQDrillDown()
{
_DisplayFields = new JQCollection<JQDrillDownDisplayFields>(this);
_KeyyFields = new JQCollection<JQDrillDownKeyFields>(this);
}
private void GenMainBlockControl(TBlockItem BlockItem)
{
#if VS90
//object oMaster = FDesignerDocument.webControls.item("Master", 0);
//WebDevPage.IHTMLElement eMaster = null;
//if (oMaster == null || !(oMaster is WebDevPage.IHTMLElement))
// return;
//eMaster = (WebDevPage.IHTMLElement)oMaster;
BlockItem.wDataSource = new WebDataSource();
JQDefault Default = new JQDefault();
Default.ID = "defaultMaster"; // +BlockItem.TableName;
Default.BindingObjectID = "dataGridMaster";
JQValidate Validate = new JQValidate();
Validate.ID = "validateMaster"; // +BlockItem.TableName;
Validate.BindingObjectID = "dataGridMaster";
WebQueryFiledsCollection QueryFields = new WebQueryFiledsCollection(null, typeof(QueryField));
WebQueryColumnsCollection QueryColumns = new WebQueryColumnsCollection(null, typeof(QueryColumns));
foreach (TBlockFieldItem fielditem in BlockItem.BlockFieldItems)
{
GenDefault(fielditem, Default, Validate);
GenQuery(fielditem, QueryFields, QueryColumns, BlockItem.TableName);
}
object oJQGridViewMaster = FDesignerDocument.webControls.item("dataGridMaster", 0);
WebDevPage.IHTMLElement eJQGridViewMaster = (WebDevPage.IHTMLElement)oJQGridViewMaster;
//FClientData.ProviderName
if (eJQGridViewMaster != null)
{
StringBuilder sb = new StringBuilder(eJQGridViewMaster.innerHTML);
((WebDevPage.IHTMLElement)oJQGridViewMaster).setAttribute("RemoteName", FClientData.ProviderName, 0);
((WebDevPage.IHTMLElement)oJQGridViewMaster).setAttribute("DataMember", FClientData.TableName, 0);
((WebDevPage.IHTMLElement)oJQGridViewMaster).setAttribute("Title", FClientData.FormTitle, 0);
//((WebDevPage.IHTMLElement)oJQGridViewMaster).setAttribute("Title", FClientData.FormTitle, 0);
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
int idx = sb.ToString().LastIndexOf("</Columns>");
if (idx == -1)
{
sb.AppendLine("<Columns></Columns>");
idx = sb.ToString().LastIndexOf("</Columns>");
}
String sHeaderText = String.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description;
var relationOptions = string.Empty;
if ((BFI.ControlType == "RefValBox" || BFI.ControlType == "ComboBox") && !string.IsNullOrEmpty(BFI.ComboValueField) && !string.IsNullOrEmpty(BFI.ComboTextField)
&& !string.IsNullOrEmpty(BFI.ComboRemoteName) && !string.IsNullOrEmpty(BFI.ComboEntityName))
{
relationOptions = string.Format("RelationOptions=\"{{RemoteName:'{0}',DisplayMember:'{1}',ValueMember:'{2}'}}\""
, BFI.ComboRemoteName, BFI.ComboTextField, BFI.ComboValueField);
}
sb.Insert(idx, String.Format("<JQMobileTools:JQGridColumn Alignment=\"left\" FieldName=\"{0}\" Caption=\"{1}\" Width=\"120\" {2} Format=\"{3}\"/>", BFI.DataField, sHeaderText, relationOptions, BFI.EditMask));
}
var toolItems = new List<JQMobileTools.JQToolItem>();
if (FClientData.BaseFormName == "JQMobileQuery" || FClientData.BaseFormName == "VBJQMobileQuery")
{
toolItems.Add(JQMobileTools.JQToolItem.PreviousPageItem);
toolItems.Add(JQMobileTools.JQToolItem.NextPageItem);
toolItems.Add(JQMobileTools.JQToolItem.QueryItem);
toolItems.Add(JQMobileTools.JQToolItem.RefreshItem);
}
else
{
toolItems.Add(JQMobileTools.JQToolItem.InsertItem);
toolItems.Add(JQMobileTools.JQToolItem.PreviousPageItem);
toolItems.Add(JQMobileTools.JQToolItem.NextPageItem);
toolItems.Add(JQMobileTools.JQToolItem.QueryItem);
toolItems.Add(JQMobileTools.JQToolItem.RefreshItem);
toolItems.Add(JQMobileTools.JQToolItem.BackItem);
}
int idxTool = sb.ToString().LastIndexOf("</ToolItems>");
if (idxTool != -1)
{
foreach (var item in toolItems)
{
idxTool = sb.ToString().LastIndexOf("</ToolItems>");
sb.Insert(idxTool, String.Format("<JQMobileTools:JQToolItem Icon=\"{0}\" Name=\"{1}\" Text=\"{2}\" Visible=\"True\" />", item.Icon, item.Name, item.Text));
}
}
int idxQuery = sb.ToString().LastIndexOf("</QueryColumns>");
if (idxQuery != -1)
{
foreach (WebQueryField item in QueryFields)
{
idxQuery = sb.ToString().LastIndexOf("</QueryColumns>");
sb.Insert(idxQuery, item.Mode);
//sb.Insert(idxQuery, String.Format("<JQTools:JQQueryColumn Caption=\"{0}\" Condition=\"{1}\" Editor=\"text\" FieldName=\"{2}\" />", item.Caption, item.Operator, item.Column));
}
//foreach (WebQueryColumns item in QueryColumns)
//{
// idxQuery = sb.ToString().LastIndexOf("</QueryColumns>");
// //sb.Insert(idxQuery, item.Mode);
// sb.Insert(idxQuery, String.Format("<JQMobileTools:JQQueryColumn Caption=\"{0}\" Condition=\"{1}\" Editor=\"text\" FieldName=\"{2}\" />", item.Caption, item.Operator, item.Column));
//}
}
eJQGridViewMaster.innerHTML = sb.ToString();
}
//object oJQDialog1 = FDesignerDocument.webControls.item("JQDialog1", 0);
//WebDevPage.IHTMLElement eJQDialog1 = (WebDevPage.IHTMLElement)oJQDialog1;
//if (oJQDialog1 != null)
//{
//((WebDevPage.IHTMLElement)oJQDialog1).setAttribute("Title", FClientData.FormTitle, 0);
object oJQFormViewMaster = FDesignerDocument.webControls.item("dataFormMaster", 0);
WebDevPage.IHTMLElement eJQFormViewMaster = (WebDevPage.IHTMLElement)oJQFormViewMaster;
if (eJQFormViewMaster != null)
{
StringBuilder sb = new StringBuilder();
((WebDevPage.IHTMLElement)oJQFormViewMaster).setAttribute("RemoteName", FClientData.ProviderName, 0);
((WebDevPage.IHTMLElement)oJQFormViewMaster).setAttribute("DataMember", FClientData.TableName, 0);
((WebDevPage.IHTMLElement)oJQFormViewMaster).setAttribute("Title", FClientData.FormTitle, 0);
sb.Append("<Columns>");
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
JQControl control = null;
string editor = "text";
String sHeaderText = String.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description;
if ((BFI.ControlType == "ComboBox" || BFI.ControlType == "ComboGrid" || BFI.ControlType == "RefValBox")
&& (string.IsNullOrEmpty(BFI.ComboValueField) || string.IsNullOrEmpty(BFI.ComboTextField)
|| string.IsNullOrEmpty(BFI.ComboRemoteName) || string.IsNullOrEmpty(BFI.ComboEntityName)))
{
BFI.ControlType = "TextBox";
}
if (BFI.ControlType == "ComboBox")
{
control = new JQSelects() { RemoteName = BFI.ComboRemoteName, DisplayMember = BFI.ComboTextField, ValueMember = BFI.ComboValueField };
editor = "selects";
}
else if (BFI.ControlType == "RefValBox")
{
control = new JQRefval() { RemoteName = BFI.ComboRemoteName, DisplayMember = BFI.ComboTextField, ValueMember = BFI.ComboValueField };
//(control as JQRefval).Columns.Add(new JQRefValColumn() { FieldName = BFI.ComboValueField, Caption = BFI.ComboValueFieldCaption });
editor = "refval";
}
else if (BFI.ControlType == "RadioButton")
{
control = new JQRadioButtons() { RemoteName = BFI.ComboRemoteName, DisplayMember = BFI.ComboTextField, ValueMember = BFI.ComboValueField };
editor = "radiobuttons";
}
else if (BFI.ControlType == "CheckBox")
{
JQCollection<JQDataItem> items = new JQCollection<JQDataItem>(control);
JQDataItem item1 = new JQDataItem();
item1.Text = "Yes"; item1.Value = "Yes";
JQDataItem item2 = new JQDataItem();
item2.Text = "No"; item2.Value = "No";
items.Add(item1);
items.Add(item2);
control = new JQCheckBoxes() { RemoteName = BFI.ComboRemoteName, DisplayMember = BFI.ComboTextField, ValueMember = BFI.ComboValueField, Items = items };
editor = "checkboxes";
}
else if (BFI.ControlType == "DateTimeBox")
{
control = new JQDate();
editor = "date";
}
else
{
control = new JQTextBox();
}
sb.AppendFormat("<{0}:{1} Caption=\"{2}\" FieldName=\"{3}\" Editor=\"{4}\" Width=\"120\" EditorOptions=\"{5}\"></{0}:{1}>"
, "JQMobileTools", "JQFormColumn", sHeaderText, BFI.DataField, editor, control.Options);
}
sb.Append("</Columns>");
eJQFormViewMaster.innerHTML = sb.ToString();
WebDevPage.IHTMLElement Page = FDesignerDocument.pageContentElement;
Default.BindingObjectID = "dataFormMaster";
InsertControl(Page, Default);
Validate.BindingObjectID = "dataFormMaster";
InsertControl(Page, Validate);
}
//}
//else
//{
// if (FClientData.BaseFormName != "JQueryQuery1")
// {
// WebDevPage.IHTMLElement Page = FDesignerDocument.pageContentElement;
// InsertControl(Page, Default);
// InsertControl(Page, Validate);
// }
//}
#else
#endif
}
public JQSecColumns()
{
_columns = new JQCollection<JQSecColumnItem>(this);
}
public JQDefault()
{
columns = new JQCollection<JQDefaultColumn>(this);
}
public JQERLine()
{
relationFields = new JQCollection<AnalysisRelationFieldItem>(this);
}
public JQComboGrid()
{
columns = new JQCollection<JQGridColumn>(this);
MultiSelect = false;
}
public JQValidate()
{
columns = new JQCollection<JQValidateColumn>(this);
}
public JQComboBox()
{
PageSize = -1;
PanelHeight = 200;
items = new JQCollection<JQComboItem>(this);
}