private void BindSelectedTable2GridView(int index)
{
string[] v = lstTables.Items[index].Text.Split('.');
//find source table data from real-time update cache instead of backend database
System.Data.DataTable dt = Global.Cache.Find(v[0], v[1]);
gvTable.Columns.Clear(); gvTable.DataSource = dt;
foreach (System.Data.DataColumn dc in dt.Columns)
{
var bf = new System.Web.UI.WebControls.BoundField();
bf.DataField = dc.ColumnName; bf.HeaderText = dc.ColumnName;
gvTable.Columns.Add(bf);
}
gvTable.DataBind();
}
private void GenMainBlockControl_3(TBlockItem BlockItem, String FormViewName)
{
bool isAjaxPage = false;
if (FPage.FindControl("AjaxScriptManager1") != null)
isAjaxPage = true;
WebDataSource Master = (WebDataSource)FPage.FindControl("Master");
Master.DataMember = FClientData.ProviderName;
Master.DataMember = Master.DataMember.Substring(Master.DataMember.IndexOf('.') + 1, Master.DataMember.Length -
Master.DataMember.IndexOf('.') - 1);
if (FormViewName == "wfvMaster")
Master.AutoApply = true;
BlockItem.wDataSource = Master;
WebFormView wfvMaster = (WebFormView)FPage.FindControl(FormViewName);
WebDefault aDefault = new WebDefault();
aDefault.ID = "wd" + BlockItem.TableName;
aDefault.DataSourceID = Master.ID;
aDefault.DataMember = Master.DataMember;
WebValidate aValidate = new WebValidate();
aValidate.ID = "wv" + BlockItem.TableName;
aValidate.DataSourceID = Master.ID;
aValidate.DataMember = Master.DataMember;
Boolean Done = false;
//Generate RESX
WebGridView aGridView = (WebGridView)FPage.FindControl("WgView");
if (aGridView == null)
aGridView = (WebGridView)FPage.FindControl("WebGridView1");
if (aGridView == null)
aGridView = (WebGridView)FPage.FindControl("wgvMaster");
if (aGridView != null)
aGridView.WizardDesignMode = true;
GenResx(Master);
if (aGridView != null)
aGridView.WizardDesignMode = false;
if (FClientData.BaseFormName == "WSingle3" || FClientData.BaseFormName == "WSingle4" || FClientData.BaseFormName == "WMasterDetail3"
|| FClientData.BaseFormName == "WMasterDetail8" || FClientData.BaseFormName == "VBWebCMasterDetail8")
{
aGridView = null;
}
//DataSet Dset = new DataSet();
//if (FPage.Site.DesignMode)
//{
// Dset = GetDD(wfvMaster);
//}
IDbConnection conn = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, false);
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = conn;
String OWNER = String.Empty, SS = this.FClientData.RealTableName, TableName = String.Empty;
if (SS.Contains("."))
{
OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' });
TableName = SS;
}
aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'";
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
DataSet dsColdef = new DataSet();
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, this.FClientData.TableName);
foreach (TBlockFieldItem aFieldItem in BlockItem.BlockFieldItems)
{
if (!Done)
{
GenDefault(aFieldItem, aDefault, aValidate);
CreateQueryField(aFieldItem, "", null, BlockItem.TableName);
}
}
Done = true;
//GridView
System.Web.UI.WebControls.BoundField aBoundField = null;
System.Web.UI.WebControls.TemplateField aTemplateField = null;
List<string> KeyFields = new List<string>();
if (aGridView != null)
{
while (aGridView.Columns.Count > 1)
aGridView.Columns.RemoveAt(1);
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "RefVal", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (isAjaxPage)
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewAjaxRefValEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, aGridView, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewAjaxRefValItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, aGridView, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewAjaxRefValFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, aGridView, FLabelList);
}
else
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewRefValEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, aGridView);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewRefValItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, aGridView);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewRefValFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, aGridView);
}
aGridView.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewComboBoxEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewComboBoxItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewComboBoxFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aGridView.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "ValidateBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewValidateBoxEditItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewValidateBoxItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewValidateBoxFooterItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aGridView.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "CheckBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewCheckBoxEditItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewCheckBoxItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewCheckBoxFooterItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aGridView.Columns.Add(aTemplateField);
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType.ToUpper() == "DATETIMEBOX"))
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (isAjaxPage)
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeEditItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, aGridView);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, aGridView);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeFooterItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, aGridView);
}
else
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewDateTimeEditItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, aGridView);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewDateTimeItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, aGridView);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewDateTimeFooterItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, aGridView);
}
aGridView.Columns.Add(aTemplateField);
}
else
{
if (BFI.EditMask != null && BFI.EditMask != String.Empty)
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewTextBoxEditItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, aGridView);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewTextBoxItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, aGridView);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewTextBoxFooterItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, aGridView);
aGridView.Columns.Add(aTemplateField);
}
else
{
aBoundField = new System.Web.UI.WebControls.BoundField();
aBoundField.DataField = BFI.DataField;
aBoundField.SortExpression = BFI.DataField;
aBoundField.HeaderText = BFI.Description;
//Field.HeaderStyle.Width = BFI.Length * ColumnWidthPixel;
if (aBoundField.HeaderText == "")
aBoundField.HeaderText = BFI.DataField;
aGridView.Columns.Add(aBoundField);
}
}
}
}
}
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
//AjaxTools.AjaxGridView aAjaxGridView = (AjaxTools.AjaxGridView)FPage.FindControl("AjaxGridView1");
//if (aAjaxGridView != null)
//{
// DataTable srcTable = GetDesignTable(Master);
// bool flag = true;
// foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
// {
// AjaxTools.ExtGridColumn extCol = new AjaxTools.ExtGridColumn();
// extCol.AllowSort = false;
// extCol.ColumnName = string.Format("col{0}", BFI.DataField);
// extCol.DataField = BFI.DataField;
// extCol.ExpandColumn = true;
// extCol.HeaderText = BFI.Description;
// extCol.IsKeyField = BFI.IsKey;
// extCol.IsKeyField = IsKeyField(BFI.DataField, srcTable.PrimaryKey);
// extCol.NewLine = flag;
// extCol.Resizable = true;
// extCol.TextAlign = "left";
// extCol.Visible = true;
// extCol.Width = 75;
// this.FieldTypeSelector(BFI.DataType, extCol);
// aAjaxGridView.Columns.Add(extCol);
// flag = !flag;
// }
// NotifyRefresh(200);
// FComponentChangeService.OnComponentChanged(aAjaxGridView, null, "", "M");
//}
if (wfvMaster != null)
{
//wfvMaster.EditItemTemplate = new MyTemplate("WebFormViewEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList);
FormViewDesigner aDesigner = FDesignerHost.GetDesigner(wfvMaster) as FormViewDesigner;
//FormView
foreach (TemplateGroup tempGroup in aDesigner.TemplateGroups)
{
foreach (TemplateDefinition tempDefin in tempGroup.Templates)
{
if (tempDefin.Name == "EditItemTemplate" || tempDefin.Name == "InsertItemTemplate" || tempDefin.Name == "ItemTemplate")
{
StringBuilder builder = new StringBuilder();
string content = tempDefin.Content;
if (content == null || content.Length == 0)
continue;
string[] ctrlTexts = content.Split("\r\n".ToCharArray());
//Control[] ctrls = ControlParser.ParseControls(host, content);
int i = 0;
int j = 0;
int m = wfvMaster.LayOutColNum * 2;
List<string> lists = new List<string>();
String ExtraName = "";
foreach (TBlockFieldItem aFieldItem in BlockItem.BlockFieldItems)
{
String FormatStyle = FormatEditMask(aFieldItem.EditMask);
if (!Done)
{
GenDefault(aFieldItem, aDefault, aValidate);
CreateQueryField(aFieldItem, "", null, BlockItem.TableName);
}
lists.Add(aFieldItem.DataField);
if ((aFieldItem.RefValNo != null && aFieldItem.RefValNo != "") || aFieldItem.RefField != null)
{
String DataSourceID = GenWebDataSource(aFieldItem, BlockItem.TableName, "RefVal", "");
switch (tempDefin.Name)
{
case "EditItemTemplate":
ExtraName = "E";
break;
case "InsertItemTemplate":
ExtraName = "I";
if (aFieldItem.DefaultValue != null && aFieldItem.DefaultValue != "")
{
FormViewField aViewField = new FormViewField();
aViewField.ControlID = "wrv" + BlockItem.TableName + aFieldItem.DataField + ExtraName;
aViewField.FieldName = aFieldItem.DataField;
wfvMaster.Fields.Add(aViewField);
}
break;
case "ItemTemplate":
ExtraName = "";
break;
}
DataSet aDataSet = new DataSet();
StringBuilder RefColumns = new StringBuilder("<Columns>");
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL_D1 where REFVAL_NO = '{0}'", aFieldItem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, aDataSet, aFieldItem.RefValNo);
if (aDataSet != null && aDataSet.Tables.Count > 0 && aDataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in aDataSet.Tables[0].Rows)
{
RefColumns.Append(Environment.NewLine);
RefColumns.Append("<InfoLight:WebRefColumn ColumnName=\"" + DR["FIELD_NAME"].ToString() + "\" HeadText=\"" + DR["HEADER_TEXT"].ToString() + "\" Width=\"100\" />");
}
RefColumns.Append(Environment.NewLine);
RefColumns.Append("</Columns>");
}
else
{
RefColumns = new StringBuilder("");
}
if (tempDefin.Name == "ItemTemplate")
{
String S6 = String.Empty;
if (isAjaxPage)
{
S6 = String.Format("<asp:Label ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{2}) %>'></asp:Label>", "l" + aFieldItem.DataField, aFieldItem.DataField, FormatStyle);
}
else
{
S6 = String.Format("<InfoLight:WebRefVal ID=\"{0}\" runat=\"server\" BindingValue='<%# Bind(\"{1}\"{5}) %>' " +
"ButtonImageUrl=\"../Image/refval/RefVal.gif\" DataBindingField=\"{1}\" DataSourceID=\"{2}\" " +
"DataTextField=\"{3}\" DataValueField=\"{4}\" ReadOnly=\"True\" ResxDataSet=\"\" " +
"ResxFilePath=\"\" UseButtonImage=\"True\" Width=\"130px\" BackColor=\"Transparent\" BorderStyle=\"None\"> " +
RefColumns.ToString() +
"</InfoLight:WebRefVal>",
"wrv" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
DataSourceID,
FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(),
FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(),
FormatStyle
);
}
lists.Add(S6);
}
else
{
String S1 = String.Empty;
if (isAjaxPage)
{
S1 = String.Format("<AjaxTools:AjaxRefVal ID=\"{0}\" runat=\"server\" BindingValue='<%# Bind(\"{1}\"{5}) %>' " +
"DataSourceID=\"{2}\" " +
"DataTextField=\"{3}\" DataValueField=\"{4}\" ResxDataSet=\"\">" +
RefColumns.ToString() +
"</AjaxTools:AjaxRefVal>",
"arv" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
DataSourceID,
FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(),
FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(),
FormatStyle
);
}
else
{
S1 = String.Format("<InfoLight:WebRefVal ID=\"{0}\" runat=\"server\" BindingValue='<%# Bind(\"{1}\"{5}) %>' " +
"ButtonImageUrl=\"../Image/refval/RefVal.gif\" DataBindingField=\"{1}\" DataSourceID=\"{2}\" " +
"DataTextField=\"{3}\" DataValueField=\"{4}\" ReadOnly=\"False\" ResxDataSet=\"\" " +
"ResxFilePath=\"\" UseButtonImage=\"True\"> " +
RefColumns.ToString() +
"</InfoLight:WebRefVal>",
"wrv" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
DataSourceID,
FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(),
FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(),
FormatStyle
);
}
lists.Add(S1);
}
}
else if (aFieldItem.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(aFieldItem, aFieldItem.ComboEntityName, "ComboBox", "");
String S5 = "";
switch (tempDefin.Name)
{
case "EditItemTemplate":
ExtraName = "E";
S5 = String.Format("<InfoLight:WebDropDownList id=\"{0}\" runat=\"server\" DataMember=\"{1}\" DataSourceID=\"{2}\" __designer:wfdid=\"w3\" DataTextField=\"{3}\" Filter DataValueField=\"{4}\" AutoInsertEmptyData=\"False\" SelectedValue='<%# Bind(\"{5}\"{6})%>' Width=\"130px\"></InfoLight:WebDropDownList>",
"wdd" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.ComboEntityName,
DataSourceID,
aFieldItem.ComboTextField,
aFieldItem.ComboValueField,
aFieldItem.DataField,
FormatStyle);
break;
case "InsertItemTemplate":
ExtraName = "I";
S5 = String.Format("<InfoLight:WebDropDownList id=\"{0}\" runat=\"server\" DataMember=\"{1}\" DataSourceID=\"{2}\" __designer:wfdid=\"w3\" DataTextField=\"{3}\" Filter DataValueField=\"{4}\" AutoInsertEmptyData=\"False\" SelectedValue='<%# Bind(\"{5}\"{6}) %>' Width=\"130px\"></InfoLight:WebDropDownList>",
"wdd" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.ComboEntityName,
DataSourceID,
aFieldItem.ComboTextField,
aFieldItem.ComboValueField,
aFieldItem.DataField,
FormatStyle);
if (aFieldItem.DefaultValue != null && aFieldItem.DefaultValue != "")
{
FormViewField aViewField = new FormViewField();
aViewField.ControlID = "wdd" + BlockItem.TableName + aFieldItem.DataField + ExtraName;
aViewField.FieldName = aFieldItem.DataField;
wfvMaster.Fields.Add(aViewField);
}
break;
case "ItemTemplate":
ExtraName = "";
S5 = String.Format("<asp:Label ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{2}) %>'></asp:Label>", "l" + aFieldItem.DataField, aFieldItem.DataField, FormatStyle);
break;
}
lists.Add(S5);
}
else if (aFieldItem.ControlType == "ValidateBox")
{
String S6 = "";
switch (tempDefin.Name)
{
case "EditItemTemplate":
ExtraName = "E";
S6 = String.Format("<InfoLight:WebValidateBox ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{3}) %>' ValidateField=\"{1}\" WebValidateID=\"{2}\" MaxLength=\"{4}\"></InfoLight:WebValidateBox></td>",
"wvb" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
aValidate.ID,
FormatStyle,
aFieldItem.Length);
break;
case "InsertItemTemplate":
ExtraName = "I";
if (aFieldItem.DefaultValue != null && aFieldItem.DefaultValue != "")
{
FormViewField aViewField = new FormViewField();
aViewField.ControlID = "wdd" + BlockItem.TableName + aFieldItem.DataField + ExtraName;
aViewField.FieldName = aFieldItem.DataField;
wfvMaster.Fields.Add(aViewField);
}
S6 = String.Format("<InfoLight:WebValidateBox ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{3}) %>' ValidateField=\"{1}\" WebValidateID=\"{2}\" MaxLength=\"{4}\"></InfoLight:WebValidateBox></td>",
"wvb" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
aValidate.ID,
FormatStyle,
aFieldItem.Length);
break;
case "ItemTemplate":
ExtraName = "";
S6 = String.Format("<asp:Label ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{2}) %>'></asp:Label>", "l" + aFieldItem.DataField, aFieldItem.DataField, FormatStyle);
break;
}
lists.Add(S6);
}
else if (aFieldItem.ControlType == "CheckBox")
{
String S6 = "";
switch (tempDefin.Name)
{
case "EditItemTemplate":
ExtraName = "E";
S6 = String.Format("<asp:CheckBox ID=\"{0}\" runat=\"server\" Checked='<%# Bind(\"{1}\"{2}) %>'></asp:CheckBox></td>",
"cb" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
break;
case "InsertItemTemplate":
ExtraName = "I";
S6 = String.Format("<asp:CheckBox ID=\"{0}\" runat=\"server\" Checked='<%# Bind(\"{1}\"{2}) %>'></asp:CheckBox></td>",
"wvb" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
break;
case "ItemTemplate":
ExtraName = "";
S6 = String.Format("<asp:Label ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{2}) %>'></asp:Label>", "l" + aFieldItem.DataField, aFieldItem.DataField, FormatStyle);
break;
}
lists.Add(S6);
}
else
{
if (aFieldItem.DataType == typeof(DateTime) || (aFieldItem.ControlType != null && aFieldItem.ControlType.ToUpper() == "DATETIMEBOX"))
{
String DataTimeType = "";
if (aFieldItem.EditMask == "ShortDate")
DataTimeType = "ShortDate";
else if (aFieldItem.EditMask == "LongDate")
DataTimeType = "ShortDate";
else
DataTimeType = "None";
String S4 = "";
if (isAjaxPage)
{
switch (tempDefin.Name)
{
case "EditItemTemplate":
ExtraName = "E";
if (aFieldItem.DataType == typeof(DateTime))
S4 = String.Format("<AjaxTools:AjaxDateTimePicker id=\"{0}\" runat=\"server\" Width=\"130px\" Text='<%# Bind(\"{1}\"{2}) %>' DateFormat=\"" + DataTimeType + "\" DateTimeType=\"DateTime\"></AjaxTools:AjaxDateTimePicker>",
"wdtp" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
else if (aFieldItem.DataType == typeof(String) && (aFieldItem.ControlType != null && aFieldItem.ControlType.ToUpper() == "DATETIMEBOX"))
S4 = String.Format("<AjaxTools:AjaxDateTimePicker id=\"{0}\" runat=\"server\" Width=\"130px\" DateString='<%# Bind(\"{1}\"{2}) %>' DateFormat=\"" + DataTimeType + "\" DateTimeType=\"Varchar\"></AjaxTools:AjaxDateTimePicker>",
"wdtp" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
break;
case "InsertItemTemplate":
ExtraName = "I";
if (aFieldItem.DataType == typeof(DateTime))
S4 = String.Format("<AjaxTools:AjaxDateTimePicker id=\"{0}\" runat=\"server\" Width=\"130px\" Text='<%# Bind(\"{1}\"{2}) %>' DateFormat=\"" + DataTimeType + "\" DateTimeType=\"DateTime\"></AjaxTools:AjaxDateTimePicker>",
"wdtp" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
else if (aFieldItem.DataType == typeof(String) && (aFieldItem.ControlType != null && aFieldItem.ControlType.ToUpper() == "DATETIMEBOX"))
S4 = String.Format("<AjaxTools:AjaxDateTimePicker id=\"{0}\" runat=\"server\" Width=\"130px\" DateString='<%# Bind(\"{1}\"{2}) %>' DateFormat=\"" + DataTimeType + "\" DateTimeType=\"Varchar\"></AjaxTools:AjaxDateTimePicker>",
"wdtp" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
break;
case "ItemTemplate":
ExtraName = "";
S4 = String.Format("<asp:Label ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{2}) %>'></asp:Label>", "l" + aFieldItem.DataField, aFieldItem.DataField, FormatStyle);
break;
}
}
else
{
switch (tempDefin.Name)
{
case "EditItemTemplate":
ExtraName = "E";
if (aFieldItem.DataType == typeof(DateTime))
S4 = String.Format("<InfoLight:WebDateTimePicker id=\"{0}\" runat=\"server\" Width=\"100px\" Text='<%# Bind(\"{1}\"{2}) %>' __designer:wfdid=\"w14\" UseButtonImage=\"True\" DateFormat=\"" + DataTimeType + "\" DateTimeType=\"DateTime\"></InfoLight:WebDateTimePicker>",
"wdtp" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
else if (aFieldItem.DataType == typeof(String) && (aFieldItem.ControlType != null && aFieldItem.ControlType.ToUpper() == "DATETIMEBOX"))
S4 = String.Format("<InfoLight:WebDateTimePicker id=\"{0}\" runat=\"server\" Width=\"100px\" DateString='<%# Bind(\"{1}\"{2}) %>' __designer:wfdid=\"w14\" UseButtonImage=\"True\" DateFormat=\"" + DataTimeType + "\" DateTimeType=\"Varchar\"></InfoLight:WebDateTimePicker>",
"wdtp" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
break;
case "InsertItemTemplate":
ExtraName = "I";
if (aFieldItem.DataType == typeof(DateTime))
S4 = String.Format("<InfoLight:WebDateTimePicker id=\"{0}\" runat=\"server\" Width=\"100px\" Text='<%# Bind(\"{1}\"{2}) %>' __designer:wfdid=\"w14\" UseButtonImage=\"True\" DateFormat=\"" + DataTimeType + "\" DateTimeType=\"DateTime\"></InfoLight:WebDateTimePicker>",
"wdtp" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
else if (aFieldItem.DataType == typeof(String) && (aFieldItem.ControlType != null && aFieldItem.ControlType.ToUpper() == "DATETIMEBOX"))
S4 = String.Format("<InfoLight:WebDateTimePicker id=\"{0}\" runat=\"server\" Width=\"100px\" DateString='<%# Bind(\"{1}\"{2}) %>' __designer:wfdid=\"w14\" UseButtonImage=\"True\" DateFormat=\"" + DataTimeType + "\" DateTimeType=\"Varchar\"></InfoLight:WebDateTimePicker>",
"wdtp" + BlockItem.TableName + aFieldItem.DataField + ExtraName,
aFieldItem.DataField,
FormatStyle);
break;
case "ItemTemplate":
ExtraName = "";
S4 = String.Format("<asp:Label ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{2}) %>'></asp:Label>", "l" + aFieldItem.DataField, aFieldItem.DataField, FormatStyle);
break;
}
}
lists.Add(S4);
}
else
{
if (tempDefin.Name == "ItemTemplate")
{
String S3 = String.Format("<asp:Label ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{2}) %>'></asp:Label>", "l" + aFieldItem.DataField, aFieldItem.DataField, FormatStyle);
lists.Add(S3);
}
else
{
if (tempDefin.Name == "InsertItemTemplate")
{
if (aFieldItem.DefaultValue != null && aFieldItem.DefaultValue != "")
{
FormViewField aViewField = new FormViewField();
aViewField.ControlID = "tb" + aFieldItem.DataField;
aViewField.FieldName = aFieldItem.DataField;
wfvMaster.Fields.Add(aViewField);
}
}
String S4 = String.Format("<asp:TextBox ID=\"{0}\" runat=\"server\" Text='<%# Bind(\"{1}\"{2}) %>' MaxLength=\"{3}\"></asp:TextBox>", "tb" + aFieldItem.DataField, aFieldItem.DataField, FormatStyle, aFieldItem.Length);
lists.Add(S4);
}
}
}
}
Done = true;
j = j * 2;
if (m > 0)
{
builder.Append("<table>");
}
foreach (string ctrlText in lists.ToArray())
{
if (ctrlText == null || ctrlText.Length == 0)
continue;
if (m > 0)
{
if (i % m == 0)
{
builder.Append("<tr>");
}
builder.Append("<td>");
}
// add dd
string ddText = "";
if (tempDefin.Name != "ItemTemplate")
{
ddText = GetDDText(ctrlText, BlockItem, tempDefin.Name);
}
else
{
ddText = GetDDText(ctrlText, BlockItem, tempDefin.Name);
}
builder.Append(ddText);
builder.Append("\r\n");
if (m > 0)
{
builder.Append("</td>");
if (i % m == m - 1)
{
builder.Append("</tr>");
}
}
i++;
}
if (m > 0)
{
if (i % m != 0)
{
int n = m - (i % m);
int q = 0;
while (q < n)
{
builder.Append("<td></td>");
q++;
}
builder.Append("</tr>");
}
builder.Append("</table>");
}
tempDefin.Content = builder.ToString();
}
}
}
}
Object aAjaxLayout = FPage.FindControl("AjaxLayout1");
if (aAjaxLayout != null)
{
aAjaxLayout.GetType().GetProperty("Title").SetValue(aAjaxLayout, FClientData.FormTitle, null);
FComponentChangeService.OnComponentChanged(aAjaxLayout, null, "", "M");
}
Object aAjaxFormView = FPage.FindControl("AjaxFormView1");
if (aAjaxFormView != null)
{
bool flag = true;
DataTable srcTable = FWizardDataSet.RealDataSet.Tables[BlockItem.TableName];
IList iFields = aAjaxFormView.GetType().GetProperty("Fields").GetValue(aAjaxFormView, null) as IList;
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
Type fieldsType = aAjaxFormView.GetType().GetProperty("Fields").PropertyType.GetProperties()[0].PropertyType;
object extCol = Activator.CreateInstance(fieldsType);
if (BFI.CheckNull == "Y")
extCol.GetType().GetProperty("AllowNull").SetValue(extCol, false, null);
else
extCol.GetType().GetProperty("AllowNull").SetValue(extCol, true, null);
if (BFI.Description != null && BFI.Description != String.Empty)
extCol.GetType().GetProperty("Caption").SetValue(extCol, BFI.Description, null);
else
extCol.GetType().GetProperty("Caption").SetValue(extCol, BFI.DataField, null);
extCol.GetType().GetProperty("DataField").SetValue(extCol, BFI.DataField, null);
extCol.GetType().GetProperty("DefaultValue").SetValue(extCol, BFI.DefaultValue, null);
extCol.GetType().GetProperty("FieldControlId").SetValue(extCol, string.Format("ctrl{0}", BFI.DataField), null);
extCol.GetType().GetProperty("IsKeyField").SetValue(extCol, IsKeyField(BFI.DataField, srcTable.PrimaryKey), null);
extCol.GetType().GetProperty("NewLine").SetValue(extCol, flag, null);
//extCol.GetType().GetProperty("Resizable").SetValue(extCol, true, null);
//extCol.GetType().GetProperty("TextAlign").SetValue(extCol, "left", null);
//extCol.GetType().GetProperty("Visible").SetValue(extCol, true, null);
extCol.GetType().GetProperty("Width").SetValue(extCol, 140, null);
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "RefVal", "", true);
String extComboBox = GenExtComboBox(BFI, BlockItem.TableName, "ExtRefVal", "", DataSourceID);
extCol.GetType().GetProperty("EditControlId").SetValue(extCol, extComboBox, null);
extCol.GetType().GetProperty("Editor").SetValue(extCol, extCol.GetType().GetProperty("Editor").PropertyType.GetField("ComboBox").GetValue(extCol), null);
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "ComboBox", "", true);
String extComboBox = GenExtComboBox(BFI, BlockItem.TableName, "ExtComboBox", "", DataSourceID);
extCol.GetType().GetProperty("EditControlId").SetValue(extCol, extComboBox, null);
extCol.GetType().GetProperty("Editor").SetValue(extCol, extCol.GetType().GetProperty("Editor").PropertyType.GetField("ComboBox").GetValue(extCol), null);
}
this.FieldTypeSelector(BFI.DataType, extCol, BFI.ControlType);
iFields.Add(extCol);
flag = !flag;
}
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(aAjaxFormView, null, "", "M");
}
FWebDefaultList.Add(aDefault);
FWebValidateList.Add(aValidate);
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(wfvMaster, null, "", "M");
FComponentChangeService.OnComponentChanged(Master, null, "", "M");
FComponentChangeService.OnComponentChanged(aGridView, null, "", "M");
}
private void GenViewBlockControl(TBlockItem BlockItem)
{
#if VS90
object oView = FDesignerDocument.webControls.item("View", 0);
if (oView == null)
oView = FDesignerDocument.webControls.item("Master", 0);
WebDevPage.IHTMLElement eView = null;
WebDevPage.IHTMLElement eWebView1 = null;
if (oView == null || !(oView is WebDevPage.IHTMLElement))
return;
eView = (WebDevPage.IHTMLElement)oView;
BlockItem.wDataSource = new WebDataSource();
String viewDataMember = FClientData.ViewProviderName.Substring(FClientData.ViewProviderName.IndexOf('.') + 1, FClientData.ViewProviderName.Length -
FClientData.ViewProviderName.IndexOf('.') - 1);
if (eView != null)
{
eView.setAttribute("DataMember", viewDataMember, 0);
}
object oWebView1 = FDesignerDocument.webControls.item("WgView", 0);
if (oWebView1 != null)
{
eWebView1 = (WebDevPage.IHTMLElement)oWebView1;
//eWebView1.setAttribute("DataMember", viewDataMember, 0);
}
if (oWebView1 == null)
oWebView1 = FDesignerDocument.webControls.item("WebGridView1", 0);
if (oWebView1 != null)
{
eWebView1 = (WebDevPage.IHTMLElement)oWebView1;
//这里本来想再往下找Columns节点的,可是找不到,只能先这样写了
StringBuilder sb = new StringBuilder(eWebView1.innerHTML);
int idx = eWebView1.innerHTML.IndexOf("</Columns>");
List<string> KeyFields = new List<string>();
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
idx = sb.ToString().IndexOf("</Columns>");
sb.Insert(idx, "\r <asp:BoundField DataField=\"" + BFI.DataField + "\" HeaderText=\"" + (string.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description) + "\" SortExpression=\"" + BFI.DataField + "\" />\r\n ");
}
eWebView1.innerHTML = sb.ToString();
}
AjaxTools.ExtGridColumnCollection aExtGridColumnCollection = new AjaxTools.ExtGridColumnCollection(new AjaxTools.AjaxGridView(), typeof(AjaxTools.ExtColumnMatch));
AjaxTools.ExtQueryFieldCollection aExtQueryFieldCollection = new ExtQueryFieldCollection(new AjaxTools.AjaxGridView(), typeof(AjaxTools.ExtQueryField));
bool flag = true;
DataTable srcTable = FWizardDataSet.RealDataSet.Tables[BlockItem.TableName];
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
AjaxTools.ExtGridColumn extCol = new AjaxTools.ExtGridColumn();
if (BFI.CheckNull == "Y")
extCol.AllowNull = false;
else
extCol.AllowNull = true;
extCol.AllowSort = false;
extCol.ColumnName = string.Format("col{0}", BFI.DataField);
extCol.DataField = BFI.DataField;
extCol.ExpandColumn = true;
if (BFI.Description != null && BFI.Description != String.Empty)
extCol.HeaderText = BFI.Description;
else
extCol.HeaderText = BFI.DataField;
extCol.IsKeyField = BFI.IsKey;
extCol.IsKeyField = IsKeyField(BFI.DataField, srcTable.PrimaryKey);
extCol.NewLine = flag;
extCol.Resizable = true;
extCol.TextAlign = "left";
extCol.Visible = true;
extCol.Width = 75;
extCol.ReadOnly = true;
if (BFI.QueryMode == "Normal")
{
AjaxTools.ExtQueryField aExtQueryField = new AjaxTools.ExtQueryField();
aExtQueryField.Condition = "And";
aExtQueryField.Id = BFI.DataField;
aExtQueryField.DataField = BFI.DataField;
aExtQueryField.Caption = BFI.Description;
if (BFI.DataType == typeof(int) || BFI.DataType == typeof(float) || BFI.DataType == typeof(double))
{
aExtQueryField.Operator = "=";
}
else
{
aExtQueryField.Operator = "%";
}
aExtQueryFieldCollection.Add(aExtQueryField);
}
else if (BFI.QueryMode == "Range")
{
AjaxTools.ExtQueryField aExtQueryField = new AjaxTools.ExtQueryField();
aExtQueryField.Id = BFI.DataField;
aExtQueryField.DataField = BFI.DataField;
aExtQueryField.Caption = BFI.Description;
aExtQueryField.Condition = "And";
aExtQueryField.Operator = ">=";
aExtQueryFieldCollection.Add(aExtQueryField);
AjaxTools.ExtQueryField aExtQueryField2 = new AjaxTools.ExtQueryField();
aExtQueryField2.Id = BFI.DataField + "2";
aExtQueryField2.DataField = BFI.DataField;
aExtQueryField2.Caption = BFI.Description;
aExtQueryField2.Condition = "And";
aExtQueryField2.Operator = "<=";
aExtQueryFieldCollection.Add(aExtQueryField2);
}
this.FieldTypeSelector(BFI.DataType, extCol, BFI.ControlType);
aExtGridColumnCollection.Add(extCol);
flag = !flag;
}
WebDevPage.IHTMLElement AjaxGridView1 = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("AjaxGridView1", 0);
if (AjaxGridView1 != null)
{
SetCollectionValue(AjaxGridView1, typeof(AjaxTools.AjaxGridView).GetProperty("Columns"), aExtGridColumnCollection);
}
if (AjaxGridView1 != null && aExtQueryFieldCollection.Count > 0)
{
SetCollectionValue(AjaxGridView1, typeof(AjaxTools.AjaxGridView).GetProperty("QueryFields"), aExtQueryFieldCollection);
}
#else
WebDataSource View = (WebDataSource)FPage.FindControl("View");
if (View == null)
View = (WebDataSource)FPage.FindControl("Master");
BlockItem.wDataSource = View;
View.DataMember = FClientData.ViewProviderName;
if (View.DataMember == null || View.DataMember == "")
View.DataMember = FClientData.ProviderName;
View.DataMember = View.DataMember.Substring(View.DataMember.IndexOf('.') + 1, View.DataMember.Length -
View.DataMember.IndexOf('.') - 1);
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
FComponentChangeService.OnComponentChanged(View, null, "", "M");
WebGridView WgView = (WebGridView)FPage.FindControl("WgView");
if (WgView == null)
WgView = (WebGridView)FPage.FindControl("WebGridView1");
//???WebGridView2.Columns.Clear();
if (WgView != null)
{
System.Web.UI.WebControls.BoundField Field = null;
List<string> KeyFields = new List<string>();
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
Field = new System.Web.UI.WebControls.BoundField();
Field.DataField = BFI.DataField;
Field.SortExpression = BFI.DataField;
Field.HeaderText = BFI.Description;
//Field.HeaderStyle.Width = BFI.Length * ColumnWidthPixel;
if (Field.HeaderText == "")
Field.HeaderText = BFI.DataField;
if (BFI.IsKey)
KeyFields.Add(Field.DataField);
WgView.Columns.Add(Field);
}
FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
FComponentChangeService.OnComponentChanged(WgView, null, "", "M");
}
//AjaxTools.AjaxGridView aAjaxGridView = FPage.FindControl("AjaxGridView1") as AjaxTools.AjaxGridView;
Object aAjaxGridView = FPage.FindControl("AjaxGridView1");
if (aAjaxGridView != null)
{
bool flag = true;
DataTable srcTable = FWizardDataSet.RealDataSet.Tables[BlockItem.TableName];
IList iColumns = aAjaxGridView.GetType().GetProperty("Columns").GetValue(aAjaxGridView, null) as IList;
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
Type columnsType = aAjaxGridView.GetType().GetProperty("Columns").PropertyType.GetProperties()[0].PropertyType;
object extCol = Activator.CreateInstance(columnsType);
if (BFI.CheckNull == "Y")
extCol.GetType().GetProperty("AllowNull").SetValue(extCol, false, null);
else
extCol.GetType().GetProperty("AllowNull").SetValue(extCol, true, null);
extCol.GetType().GetProperty("AllowSort").SetValue(extCol, false, null);
extCol.GetType().GetProperty("ColumnName").SetValue(extCol, string.Format("col{0}", BFI.DataField), null);
extCol.GetType().GetProperty("DataField").SetValue(extCol, BFI.DataField, null);
extCol.GetType().GetProperty("DefaultValue").SetValue(extCol, BFI.DefaultValue, null);
extCol.GetType().GetProperty("ExpandColumn").SetValue(extCol, true, null);
if (BFI.Description != null && BFI.Description != String.Empty)
extCol.GetType().GetProperty("HeaderText").SetValue(extCol, BFI.Description, null);
else
extCol.GetType().GetProperty("HeaderText").SetValue(extCol, BFI.DataField, null);
//extCol.GetType().GetProperty("IsKeyField").SetValue(extCol, BFI.IsKey, null);
extCol.GetType().GetProperty("IsKeyField").SetValue(extCol, IsKeyField(BFI.DataField, srcTable.PrimaryKey), null);
extCol.GetType().GetProperty("NewLine").SetValue(extCol, flag, null);
extCol.GetType().GetProperty("Resizable").SetValue(extCol, true, null);
extCol.GetType().GetProperty("TextAlign").SetValue(extCol, "left", null);
extCol.GetType().GetProperty("Visible").SetValue(extCol, true, null);
extCol.GetType().GetProperty("Width").SetValue(extCol, 75, null);
if (BFI.QueryMode == "Normal")
{
IList iQueryFields = aAjaxGridView.GetType().GetProperty("QueryFields").GetValue(aAjaxGridView, null) as IList;
Type queryFieldsType = aAjaxGridView.GetType().GetProperty("QueryFields").PropertyType.GetProperties()[0].PropertyType;
object aQueryField = Activator.CreateInstance(queryFieldsType);
aQueryField.GetType().GetProperty("Condition").SetValue(aQueryField, "And", null);
aQueryField.GetType().GetProperty("DataField").SetValue(aQueryField, BFI.DataField, null);
aQueryField.GetType().GetProperty("Caption").SetValue(aQueryField, BFI.Description, null);
if (BFI.DataType == typeof(int) || BFI.DataType == typeof(float) || BFI.DataType == typeof(double))
{
aQueryField.GetType().GetProperty("Operator").SetValue(aQueryField, "=", null);
}
else
{
aQueryField.GetType().GetProperty("Operator").SetValue(aQueryField, "%", null);
}
iQueryFields.Add(aQueryField);
}
else if (BFI.QueryMode == "Range")
{
IList iQueryFields = aAjaxGridView.GetType().GetProperty("QueryFields").GetValue(aAjaxGridView, null) as IList;
Type queryFieldsType = aAjaxGridView.GetType().GetProperty("QueryFields").PropertyType.GetProperties()[0].PropertyType;
object aQueryField = Activator.CreateInstance(queryFieldsType);
aQueryField.GetType().GetProperty("Condition").SetValue(aQueryField, "And", null);
aQueryField.GetType().GetProperty("DataField").SetValue(aQueryField, BFI.DataField, null);
aQueryField.GetType().GetProperty("Caption").SetValue(aQueryField, BFI.Description, null);
aQueryField.GetType().GetProperty("Condition").SetValue(aQueryField, "And", null);
aQueryField.GetType().GetProperty("Operator").SetValue(aQueryField, ">=", null);
iQueryFields.Add(aQueryField);
object aQueryField2 = Activator.CreateInstance(queryFieldsType);
aQueryField2.GetType().GetProperty("Condition").SetValue(aQueryField2, "And", null);
aQueryField2.GetType().GetProperty("DataField").SetValue(aQueryField2, BFI.DataField, null);
aQueryField2.GetType().GetProperty("Caption").SetValue(aQueryField2, BFI.Description, null);
aQueryField2.GetType().GetProperty("Condition").SetValue(aQueryField2, "And", null);
aQueryField2.GetType().GetProperty("Operator").SetValue(aQueryField2, "<=", null);
iQueryFields.Add(aQueryField2);
}
this.FieldTypeSelector(BFI.DataType, extCol, BFI.ControlType);
iColumns.Add(extCol);
//AjaxTools.ExtGridColumn extCol = new AjaxTools.ExtGridColumn();
//extCol.AllowSort = false;
//extCol.ColumnName = string.Format("col{0}", BFI.DataField);
//extCol.DataField = BFI.DataField;
//extCol.ExpandColumn = true;
//extCol.HeaderText = BFI.Description;
//extCol.IsKeyField = BFI.IsKey;
//extCol.IsKeyField = IsKeyField(BFI.DataField, srcTable.PrimaryKey);
//extCol.NewLine = flag;
//extCol.Resizable = true;
//extCol.TextAlign = "left";
//extCol.Visible = true;
//extCol.Width = 75;
//this.FieldTypeSelector(BFI.DataType, extCol);
//aAjaxGridView.Columns.Add(extCol);
flag = !flag;
}
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(aAjaxGridView, null, "", "M");
}
/*
WebGridView2.DataKeyNames = new string[KeyFields.Count];
for (int I = 0; I < KeyFields.Count; I++)
WebGridView2.DataKeyNames[I] = KeyFields[I];
*
*/
/*
if (FClientData.IsMasterDetailBaseForm())
{
InfoDataSet ViewDataSet = FDesignerHost.CreateComponent(typeof(InfoDataSet), "idView") as InfoDataSet;
ViewDataSet.RemoteName = FClientData.ViewProviderName;
if (ViewDataSet.RemoteName.Trim() == "")
{
ViewDataSet.RemoteName = FClientData.ProviderName;
}
ViewDataSet.Active = true;
InfoBindingSource ViewBindingSource = FDesignerHost.CreateComponent(typeof(InfoBindingSource),
"ibsView") as InfoBindingSource;
ViewBindingSource.DataSource = ViewDataSet;
ViewBindingSource.DataMember = ViewDataSet.RealDataSet.Tables[0].TableName;
BlockItem.BindingSource = ViewBindingSource;
InfoNavigator navigator1 = FRootForm.Controls["infoNavigator1"] as InfoNavigator;
if (navigator1 != null)
navigator1.ViewBindingSource = ViewBindingSource;
InfoRelation Relation = new InfoRelation();
Relation.RelationDataSet = FDataSet;
InfoKeyField KeyField;
KeyField = new InfoKeyField();
KeyField.FieldName = ViewDataSet.RealDataSet.Tables[0].Columns[0].ColumnName;
Relation.SourceKeyFields.Add(KeyField);
KeyField = new InfoKeyField();
KeyField.FieldName = ViewDataSet.RealDataSet.Tables[0].Columns[0].ColumnName;
Relation.TargetKeyFields.Add(KeyField);
Relation.Active = true;
ViewBindingSource.Relations.Add(Relation);
}
TBlockFieldItem FieldItem;
System.Windows.Forms.SplitContainer scMaster = FRootForm.Controls["scMaster"] as System.Windows.Forms.SplitContainer;
FViewGrid = FDesignerHost.CreateComponent(typeof(InfoDataGridView), "grdView") as InfoDataGridView;
FViewGrid.Parent = scMaster.Panel1;
FViewGrid.Dock = DockStyle.Fill;
FViewGrid.TabIndex = 0;
FViewGrid.DataSource = BlockItem.BindingSource;
if (FClientData.IsMasterDetailBaseForm())
{
//???FViewGrid.Columns.Clear();
DataGridViewColumn Column;
int I, Index;
for (I = 0; I < BlockItem.BlockFieldItems.Count; I++)
{
FieldItem = BlockItem.BlockFieldItems[I] as TBlockFieldItem;
if (FieldItem.Description == "")
Index = FViewGrid.Columns.Add(FieldItem.DataField, FieldItem.DataField);
else
Index = FViewGrid.Columns.Add(FieldItem.DataField, FieldItem.Description);
Column = FViewGrid.Columns[Index];
Column.DataPropertyName = FieldItem.DataField;
if (Column.HeaderText.Trim() == "")
Column.HeaderText = FieldItem.DataField;
}
}
*/
#endif
}
private void GenMainBlockControl_2(TBlockItem BlockItem)
{
#if VS90
object oMaster = FDesignerDocument.webControls.item("Master", 0);
WebDevPage.IHTMLElement eMaster = null;
WebDevPage.IHTMLElement eWebDetailView1 = null;
if (oMaster == null || !(oMaster is WebDevPage.IHTMLElement))
return;
eMaster = (WebDevPage.IHTMLElement)oMaster;
eMaster.setAttribute("AutoApply", "true", 0);
BlockItem.wDataSource = new WebDataSource();
string mastertablename = string.Empty;
if (eMaster != null)
{
mastertablename = FClientData.ProviderName.Split('.')[1];
eMaster.setAttribute("DataMember", mastertablename, 0);
}
WebDefault Default = new WebDefault();
Default.ID = "wd" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName);
Default.DataSourceID = eMaster.getAttribute("ID", 0).ToString();
Default.DataMember = mastertablename;
WebValidate Validate = new WebValidate();
Validate.ID = "wv" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName);
Validate.DataSourceID = eMaster.getAttribute("ID", 0).ToString();
Validate.DataMember = mastertablename;
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 Page = FDesignerDocument.pageContentElement;
InsertControl(Page, Default);
InsertControl(Page, Validate);
foreach (TBlockFieldItem fielditem in BlockItem.BlockFieldItems)
{
foreach (WebQueryColumns wqc in QueryColumns)
{
if (wqc.ColumnType == "ClientQueryRefValColumn" && wqc.Column == fielditem.DataField && fielditem.RefValNo != String.Empty)
{
WebDataSource aWebDataSource = new WebDataSource();
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = FClientData.Owner.GlobalConnection;
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
if (FSYS_REFVAL != null)
FSYS_REFVAL.Dispose();
FSYS_REFVAL = new DataSet();
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", fielditem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, FSYS_REFVAL, fielditem.RefValNo);
WebRefVal aWebRefVal = new WebRefVal();
aWebRefVal.ID = wqc.WebRefVal;
aWebRefVal.DataTextField = FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
aWebRefVal.DataValueField = FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
aWebRefVal.DataSourceID = String.Format("wds{0}{1}", WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), wqc.Column);
aWebRefVal.Visible = false;
InsertControl(Page, aWebRefVal);
break;
}
else if (wqc.ColumnType == "ClientQueryComboBoxColumn" && wqc.Column == fielditem.DataField
&& !String.IsNullOrEmpty(fielditem.ComboTextField) && !String.IsNullOrEmpty(fielditem.ComboValueField))
{
WebRefVal aWebRefVal = new WebRefVal();
aWebRefVal.ID = wqc.WebRefVal;
aWebRefVal.DataTextField = fielditem.ComboTextField;
aWebRefVal.DataValueField = fielditem.ComboValueField;
aWebRefVal.DataSourceID = String.Format("wds{0}{1}", fielditem.ComboEntityName, wqc.Column);
aWebRefVal.Visible = false;
InsertControl(Page, aWebRefVal);
break;
}
}
}
WebDevPage.IHTMLElement Navigator = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebNavigator1", 0);
if (Navigator != null)
{
SetCollectionValue(Navigator, typeof(WebNavigator).GetProperty("QueryFields"), QueryFields);
}
WebDevPage.IHTMLElement ClientQuery = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebClientQuery1", 0);
if (ClientQuery != null)
{
SetCollectionValue(ClientQuery, typeof(WebClientQuery).GetProperty("Columns"), QueryColumns);
}
object oWebDetailView1 = FDesignerDocument.webControls.item("wdvMaster", 0);
eWebDetailView1 = (WebDevPage.IHTMLElement)oWebDetailView1;
//eWebDetailView1.setAttribute("DataMember", FClientData.TableName, 0);
//这里本来想再往下找Columns节点的,可是找不到,只能先这样写了
StringBuilder sb = new StringBuilder(eWebDetailView1.innerHTML);
int idx = eWebDetailView1.innerHTML.IndexOf("<EmptyDataRowStyle ForeColor=\"Black\" />");
sb.Insert(idx, "<Fields>\r\n </Fields>\r\n ");
eWebDetailView1.innerHTML = sb.ToString();
idx = eWebDetailView1.innerHTML.IndexOf("</Fields>");
List<string> KeyFields = new List<string>();
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
idx = sb.ToString().IndexOf("</Fields>");
if (BFI.ControlType == "RefValBox" && String.IsNullOrEmpty(BFI.RefValNo))
BFI.ControlType = "TextBox";
if (BFI.ControlType == "ComboBox" && (String.IsNullOrEmpty(BFI.ComboRemoteName)
|| String.IsNullOrEmpty(BFI.ComboTextField)
|| String.IsNullOrEmpty(BFI.ComboValueField)))
BFI.ControlType = "TextBox";
if (!string.IsNullOrEmpty(BFI.RefValNo) || BFI.RefField != null)
{
sb.Insert(idx, GenDetailViewTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
}
else if (BFI.ControlType == "ComboBox" || BFI.ControlType == "ValidateBox" || BFI.ControlType == "CheckBox")
{
sb.Insert(idx, GenDetailViewTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType == "DateTimeBox"))
{
sb.Insert(idx, GenDetailViewTemplateFieldHTML("DateTimeBox", BlockItem, BFI));
}
else
{
sb.Insert(idx, "\r <asp:BoundField DataField=\"" + BFI.DataField + "\" HeaderText=\"" + (string.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description) + "\" SortExpression=\"" + BFI.DataField + "\" />\r\n ");
}
}
}
eWebDetailView1.innerHTML = sb.ToString();
#else
bool isAjaxPage = false;
if (FPage.FindControl("AjaxScriptManager1") != null)
isAjaxPage = true;
WebDataSource Master = (WebDataSource)FPage.FindControl("Master");
Master.AutoApply = true;
BlockItem.wDataSource = Master;
WebDetailsView wdvMaster = (WebDetailsView)FPage.FindControl("wdvMaster");
//Generate RESX
//???GenResx(Master);
//wdvMaster.DataMember = FClientData.TableName;
//???WebGridView1.Columns.Clear();
System.Web.UI.WebControls.BoundField aBoundField = null;
System.Web.UI.WebControls.TemplateField aTemplateField = null;
WebDefault aDefault = new WebDefault();
aDefault.ID = "wd" + BlockItem.TableName;
aDefault.DataSourceID = Master.ID;
aDefault.DataMember = Master.DataMember;
WebValidate aValidate = new WebValidate();
aValidate.ID = "wv" + BlockItem.TableName;
aValidate.DataSourceID = Master.ID;
aValidate.DataMember = Master.DataMember;
List<string> KeyFields = new List<string>();
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "RefVal", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewRefValEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, null);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewRefValItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, null);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewRefValInsertItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, null);
wdvMaster.Fields.Add(aTemplateField);
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewComboBoxEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewComboBoxItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewComboBoxFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewComboBoxInsertItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
wdvMaster.Fields.Add(aTemplateField);
}
else if (BFI.ControlType == "ValidateBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewValidateBoxEditItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewValidateBoxInsertItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewValidateBoxItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewValidateBoxInsertItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
wdvMaster.Fields.Add(aTemplateField);
}
else if (BFI.ControlType == "CheckBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewCheckBoxEditItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewCheckBoxInsertItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewCheckBoxItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewCheckBoxInsertItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
wdvMaster.Fields.Add(aTemplateField);
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType.ToUpper() == "DATETIMEBOX"))
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewDateTimeEditItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, null);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewDateTimeItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, null);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewDateTimeFooterItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, null);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewDateTimeInsertItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, null);
wdvMaster.Fields.Add(aTemplateField);
}
else
{
if (BFI.EditMask != null && BFI.EditMask != String.Empty)
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewTextBoxEditItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, null);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewTextBoxItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, null);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewTextBoxFooterItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, null);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewTextBoxInsertItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, null);
wdvMaster.Fields.Add(aTemplateField);
}
else
{
aBoundField = new System.Web.UI.WebControls.BoundField();
aBoundField.DataField = BFI.DataField;
aBoundField.SortExpression = BFI.DataField;
aBoundField.HeaderText = BFI.Description;
aBoundField.HeaderStyle.Width = 150;//BFI.Length * ColumnWidthPixel;
if (aBoundField.HeaderText == "")
aBoundField.HeaderText = BFI.DataField;
wdvMaster.Fields.Add(aBoundField);
}
}
}
if (BFI.IsKey)
KeyFields.Add(BFI.DataField);
CreateQueryField(BFI, "", null, BlockItem.TableName);
GenDefault(BFI, aDefault, aValidate);
}
DataTable DT = FWizardDataSet.RealDataSet.Tables[0];
DataColumn[] PrimDc = DT.PrimaryKey;
string[] AA = new string[PrimDc.Length];
for (int J = 0; J < PrimDc.Length; J++)
AA[J] = PrimDc[J].ColumnName;
/*
wdvMaster.DataKeyNames = new string[AA.Length];
for (int I = 0; I < AA.Length; I++)
{
wdvMaster.DataKeyNames[I] = AA[I];
}
*/
FWebDefaultList.Add(aDefault);
FWebValidateList.Add(aValidate);
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(wdvMaster, null, "", "M");
#endif
}
private void GenMainBlockControl(TBlockItem BlockItem)
{
#if VS90
object oMaster = FDesignerDocument.webControls.item("Master", 0);
WebDevPage.IHTMLElement eMaster = null;
WebDevPage.IHTMLElement eWebGridView1 = null;
if (oMaster == null || !(oMaster is WebDevPage.IHTMLElement))
return;
eMaster = (WebDevPage.IHTMLElement)oMaster;
WebDefault Default = new WebDefault();
Default.ID = "wd" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName);
Default.DataSourceID = eMaster.getAttribute("ID", 0).ToString();
Default.DataMember = FClientData.TableName;
WebValidate Validate = new WebValidate();
Validate.ID = "wv" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName);
Validate.DataSourceID = eMaster.getAttribute("ID", 0).ToString();
Validate.DataMember = FClientData.TableName;
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 Page = FDesignerDocument.pageContentElement;
InsertControl(Page, Default);
InsertControl(Page, Validate);
foreach (TBlockFieldItem fielditem in BlockItem.BlockFieldItems)
{
foreach (WebQueryColumns wqc in QueryColumns)
{
if (wqc.ColumnType == "ClientQueryRefValColumn" && wqc.Column == fielditem.DataField && fielditem.RefValNo != String.Empty)
{
WebDataSource aWebDataSource = new WebDataSource();
InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
//aInfoCommand.Connection = FClientData.Owner.GlobalConnection;
IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
if (FSYS_REFVAL != null)
FSYS_REFVAL.Dispose();
FSYS_REFVAL = new DataSet();
aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", fielditem.RefValNo);
WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, FSYS_REFVAL, fielditem.RefValNo);
WebRefVal aWebRefVal = new WebRefVal();
aWebRefVal.ID = wqc.WebRefVal;
aWebRefVal.DataTextField = FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
aWebRefVal.DataValueField = FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
aWebRefVal.DataSourceID = String.Format("wds{0}{1}", WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), wqc.Column);
aWebRefVal.Visible = false;
InsertControl(Page, aWebRefVal);
break;
}
else if (wqc.ColumnType == "ClientQueryComboBoxColumn" && wqc.Column == fielditem.DataField
&& !String.IsNullOrEmpty(fielditem.ComboTextField) && !String.IsNullOrEmpty(fielditem.ComboValueField))
{
WebRefVal aWebRefVal = new WebRefVal();
aWebRefVal.ID = wqc.WebRefVal;
aWebRefVal.DataTextField = fielditem.ComboTextField;
aWebRefVal.DataValueField = fielditem.ComboValueField;
aWebRefVal.DataSourceID = String.Format("wds{0}{1}", fielditem.ComboEntityName, wqc.Column);
aWebRefVal.Visible = false;
InsertControl(Page, aWebRefVal);
break;
}
}
}
WebDevPage.IHTMLElement Navigator = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebNavigator1", 0);
if (Navigator != null)
{
SetCollectionValue(Navigator, typeof(WebNavigator).GetProperty("QueryFields"), QueryFields);
}
WebDevPage.IHTMLElement ClientQuery = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebClientQuery1", 0);
if (ClientQuery != null)
{
SetCollectionValue(ClientQuery, typeof(WebClientQuery).GetProperty("Columns"), QueryColumns);
}
object oWebGridView1 = FDesignerDocument.webControls.item("wgvMaster", 0);
if (oWebGridView1 == null)
oWebGridView1 = FDesignerDocument.webControls.item("WebGridView1", 0);
eWebGridView1 = (WebDevPage.IHTMLElement)oWebGridView1;
//eWebGridView1.setAttribute("DataMember", FClientData.TableName, 0);
//这里本来想再往下找Columns节点的,可是找不到,只能先这样写了
StringBuilder sb = new StringBuilder(eWebGridView1.innerHTML);
int idx = eWebGridView1.innerHTML.IndexOf("</Columns>");
if (idx == -1)
{
idx = sb.ToString().IndexOf("<SelectedRowStyle");
sb.Insert(idx, "<Columns>\r\n </Columns>");
}
List<string> KeyFields = new List<string>();
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
idx = sb.ToString().IndexOf("</Columns>");
if (BFI.ControlType == "RefValBox" && String.IsNullOrEmpty(BFI.RefValNo))
BFI.ControlType = "TextBox";
if (BFI.ControlType == "ComboBox" && (String.IsNullOrEmpty(BFI.ComboRemoteName)
|| String.IsNullOrEmpty(BFI.ComboTextField)
|| String.IsNullOrEmpty(BFI.ComboValueField)))
BFI.ControlType = "TextBox";
if (!string.IsNullOrEmpty(BFI.RefValNo) || BFI.RefField != null)
{
sb.Insert(idx, GenTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
}
else if (BFI.ControlType == "ComboBox" || BFI.ControlType == "ValidateBox" || BFI.ControlType == "CheckBox")
{
sb.Insert(idx, GenTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType == "DateTimeBox"))
{
sb.Insert(idx, GenTemplateFieldHTML("DateTimeBox", BlockItem, BFI));
}
else
{
sb.Insert(idx, "\r <asp:BoundField DataField=\"" + BFI.DataField + "\" HeaderText=\"" + (string.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description) + "\" SortExpression=\"" + BFI.DataField + "\" />\r\n ");
}
}
}
eWebGridView1.innerHTML = sb.ToString();
WebDevPage.IHTMLElement AjaxGridView1 = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("AjaxGridView1", 0);
if (AjaxGridView1 != null)
{
AjaxTools.ExtGridColumnCollection aExtGridColumnCollection = new AjaxTools.ExtGridColumnCollection(new AjaxTools.AjaxGridView(), typeof(AjaxTools.ExtColumnMatch));
DataTable srcTable = FWizardDataSet.RealDataSet.Tables[BlockItem.TableName];
bool flag = true;
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
AjaxTools.ExtGridColumn extCol = new AjaxTools.ExtGridColumn();
if (BFI.CheckNull == "Y")
extCol.AllowNull = false;
else
extCol.AllowNull = true;
extCol.AllowSort = false;
extCol.ColumnName = string.Format("col{0}", BFI.DataField);
extCol.DataField = BFI.DataField;
extCol.ExpandColumn = true;
if (BFI.Description != null && BFI.Description != String.Empty)
extCol.HeaderText = BFI.Description;
else
extCol.HeaderText = BFI.DataField;
extCol.IsKeyField = BFI.IsKey;
extCol.IsKeyField = IsKeyField(BFI.DataField, srcTable.PrimaryKey);
extCol.NewLine = flag;
extCol.Resizable = true;
extCol.TextAlign = "left";
extCol.Visible = true;
extCol.Width = 75;
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), "RefVal", "", true);
String extComboBox = GenExtComboBox(BFI, WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), "ExtRefVal", "", DataSourceID);
try
{
String str = AjaxGridView1.innerHTML;
}
catch
{
AjaxGridView1 = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("AjaxGridViewDetail", 0);
}
extCol.EditControlId = extComboBox;
extCol.Editor = AjaxTools.ExtGridEditor.ComboBox;
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", "", true);
String extComboBox = GenExtComboBox(BFI, WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), "ExtComboBox", "", DataSourceID);
try
{
String str = AjaxGridView1.innerHTML;
}
catch
{
AjaxGridView1 = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("AjaxGridViewDetail", 0);
}
extCol.EditControlId = extComboBox;
extCol.Editor = AjaxTools.ExtGridEditor.ComboBox;
}
this.FieldTypeSelector(BFI.DataType, extCol, BFI.ControlType);
aExtGridColumnCollection.Add(extCol);
flag = !flag;
}
SetCollectionValue(AjaxGridView1, typeof(AjaxTools.AjaxGridView).GetProperty("Columns"), aExtGridColumnCollection);
}
#else
bool isAjaxPage = false;
if (FPage.FindControl("AjaxScriptManager1") != null)
isAjaxPage = true;
WebDataSource Master = (WebDataSource)FPage.FindControl("Master");
BlockItem.wDataSource = Master;
WebGridView WebGridView1 = (WebGridView)FPage.FindControl("wgvMaster");
if (WebGridView1 == null)
WebGridView1 = (WebGridView)FPage.FindControl("WebGridView1");
//Generate RESX
//???GenResx(Master);
//WebGridView1.DataMember = FClientData.TableName;
//???WebGridView1.Columns.Clear();
System.Web.UI.WebControls.BoundField aBoundField = null;
System.Web.UI.WebControls.TemplateField aTemplateField = null;
WebDefault aDefault = new WebDefault();
aDefault.ID = "wd" + BlockItem.TableName;
aDefault.DataSourceID = Master.ID;
aDefault.DataMember = Master.DataMember;
WebValidate aValidate = new WebValidate();
aValidate.ID = "wv" + BlockItem.TableName;
aValidate.DataSourceID = Master.ID;
aValidate.DataMember = Master.DataMember;
if (WebGridView1 != null)
{
List<string> KeyFields = new List<string>();
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "RefVal", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (isAjaxPage)
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewAjaxRefValEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, WebGridView1, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewAjaxRefValItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, WebGridView1, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewAjaxRefValFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, WebGridView1, FLabelList);
}
else
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewRefValEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, WebGridView1);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewRefValItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, WebGridView1);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewRefValFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, WebGridView1);
}
WebGridView1.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewComboBoxEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewComboBoxItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewComboBoxFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
WebGridView1.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "ValidateBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewValidateBoxEditItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewValidateBoxItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewValidateBoxFooterItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
WebGridView1.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "CheckBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewCheckBoxEditItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewCheckBoxItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewCheckBoxFooterItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
WebGridView1.Columns.Add(aTemplateField);
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType.ToUpper() == "DATETIMEBOX"))
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (isAjaxPage)
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeEditItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, WebGridView1);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, WebGridView1);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeFooterItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, WebGridView1);
}
else
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewDateTimeEditItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, WebGridView1);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewDateTimeItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, WebGridView1);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewDateTimeFooterItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, WebGridView1);
}
WebGridView1.Columns.Add(aTemplateField);
}
else
{
if (BFI.EditMask != null && BFI.EditMask != String.Empty)
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewTextBoxEditItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, WebGridView1);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewTextBoxItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, WebGridView1);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewTextBoxFooterItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, WebGridView1);
WebGridView1.Columns.Add(aTemplateField);
}
else
{
aBoundField = new System.Web.UI.WebControls.BoundField();
aBoundField.DataField = BFI.DataField;
aBoundField.SortExpression = BFI.DataField;
aBoundField.HeaderText = BFI.Description;
//Field.HeaderStyle.Width = BFI.Length * ColumnWidthPixel;
if (aBoundField.HeaderText == "")
aBoundField.HeaderText = BFI.DataField;
WebGridView1.Columns.Add(aBoundField);
}
}
}
if (BFI.IsKey)
KeyFields.Add(BFI.DataField);
CreateQueryField(BFI, "", null, BlockItem.TableName);
GenDefault(BFI, aDefault, aValidate);
}
DataTable DT = FWizardDataSet.RealDataSet.Tables[0];
DataColumn[] PrimDc = DT.PrimaryKey;
string[] AA = new string[PrimDc.Length];
for (int J = 0; J < PrimDc.Length; J++)
AA[J] = PrimDc[J].ColumnName;
/*
WebGridView1.DataKeyNames = new string[AA.Length];
for (int I = 0; I < AA.Length; I++)
{
WebGridView1.DataKeyNames[I] = AA[I];
}
*/
FWebDefaultList.Add(aDefault);
FWebValidateList.Add(aValidate);
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(WebGridView1, null, "", "M");
}
Object aAjaxGridView = FPage.FindControl("AjaxGridView1");
if (aAjaxGridView != null)
{
bool flag = true;
DataTable srcTable = FWizardDataSet.RealDataSet.Tables[BlockItem.TableName];
IList iColumns = aAjaxGridView.GetType().GetProperty("Columns").GetValue(aAjaxGridView, null) as IList;
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
Type columnsType = aAjaxGridView.GetType().GetProperty("Columns").PropertyType.GetProperties()[0].PropertyType;
object extCol = Activator.CreateInstance(columnsType);
if (BFI.CheckNull == "Y")
extCol.GetType().GetProperty("AllowNull").SetValue(extCol, false, null);
else
extCol.GetType().GetProperty("AllowNull").SetValue(extCol, true, null);
extCol.GetType().GetProperty("AllowSort").SetValue(extCol, false, null);
extCol.GetType().GetProperty("ColumnName").SetValue(extCol, string.Format("col{0}", BFI.DataField), null);
extCol.GetType().GetProperty("DataField").SetValue(extCol, BFI.DataField, null);
extCol.GetType().GetProperty("DefaultValue").SetValue(extCol, BFI.DefaultValue, null);
extCol.GetType().GetProperty("ExpandColumn").SetValue(extCol, true, null);
if (BFI.Description != null && BFI.Description != String.Empty)
extCol.GetType().GetProperty("HeaderText").SetValue(extCol, BFI.Description, null);
else
extCol.GetType().GetProperty("HeaderText").SetValue(extCol, BFI.DataField, null);
extCol.GetType().GetProperty("IsKeyField").SetValue(extCol, BFI.IsKey, null);
//extCol.GetType().GetProperty("IsKeyField").SetValue(extCol, IsKeyField(BFI.DataField, srcTable.PrimaryKey), null);
extCol.GetType().GetProperty("NewLine").SetValue(extCol, flag, null);
extCol.GetType().GetProperty("Resizable").SetValue(extCol, true, null);
extCol.GetType().GetProperty("TextAlign").SetValue(extCol, "left", null);
extCol.GetType().GetProperty("Visible").SetValue(extCol, true, null);
extCol.GetType().GetProperty("Width").SetValue(extCol, 75, null);
this.FieldTypeSelector(BFI.DataType, extCol, BFI.ControlType);
iColumns.Add(extCol);
flag = !flag;
}
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(aAjaxGridView, null, "", "M");
}
#endif
}
private void GenDetailBlock(String TemplateName)
{
MWizard.TBlockItem BlockItem = null;
foreach (TBlockItem B in FClientData.Blocks)
{
if (B.wDataSource == null)
{
BlockItem = B;
break;
}
}
#if VS90
object oDetail = FDesignerDocument.webControls.item("Detail", 0);
WebDevPage.IHTMLElement eDetail = null;
WebDevPage.IHTMLElement eWebGridView1 = null;
if (oDetail == null || !(oDetail is WebDevPage.IHTMLElement))
return;
eDetail = (WebDevPage.IHTMLElement)oDetail;
eDetail.setAttribute("DataMember", BlockItem.TableName, 0);
WebQueryFiledsCollection QueryFields = new WebQueryFiledsCollection(null, typeof(QueryField));
WebQueryColumnsCollection QueryColumns = new WebQueryColumnsCollection(null, typeof(QueryColumns));
if (FDesignerDocument.webControls.item("wd" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), 0) == null && FDesignerDocument.webControls.item("wv" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), 0) == null)
{
WebDefault Default = new WebDefault();
Default.ID = "wd" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName);
Default.DataSourceID = eDetail.getAttribute("ID", 0).ToString();
Default.DataMember = BlockItem.TableName;
WebValidate Validate = new WebValidate();
Validate.ID = "wv" + WzdUtils.RemoveSpecialCharacters(BlockItem.TableName);
Validate.DataSourceID = eDetail.getAttribute("ID", 0).ToString();
Validate.DataMember = BlockItem.TableName;
foreach (TBlockFieldItem fielditem in BlockItem.BlockFieldItems)
{
GenDefault(fielditem, Default, Validate);
GenQuery(fielditem, QueryFields, QueryColumns, BlockItem.TableName);
}
WebDevPage.IHTMLElement Page = FDesignerDocument.pageContentElement;
InsertControl(Page, Default);
InsertControl(Page, Validate);
}
WebDevPage.IHTMLElement Navigator = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebNavigator1", 0);
if (Navigator != null)
{
SetCollectionValue(Navigator, typeof(WebNavigator).GetProperty("QueryFields"), QueryFields);
}
WebDevPage.IHTMLElement ClientQuery = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebClientQuery1", 0);
if (ClientQuery != null)
{
SetCollectionValue(ClientQuery, typeof(WebClientQuery).GetProperty("Columns"), QueryColumns);
}
object oWebGridView1 = FDesignerDocument.webControls.item("wgvDetail", 0);
eWebGridView1 = (WebDevPage.IHTMLElement)oWebGridView1;
if (eWebGridView1 != null)
{
//eWebGridView1.setAttribute("DataSourceID", "Detail", 0);
//eWebGridView1.setAttribute("DataMember", BlockItem.TableName, 0);
//这里本来想再往下找Columns节点的,可是找不到,只能先这样写了
StringBuilder sb = new StringBuilder(eWebGridView1.innerHTML);
int idx = eWebGridView1.innerHTML.IndexOf("</Columns>");
List<string> KeyFields = new List<string>();
AddNewRowControlCollection controls = new AddNewRowControlCollection(null, typeof(AddNewRowControlItem));
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
//if (TemplateName == "WMasterDetail4" || TemplateName == "VBWebCMasterDetail4")
//{
// BFI.RefField = null;
// BFI.ControlType = "TextBox";
//}
string controlid = string.Empty;
WebGridView.AddNewRowControlType type = WebGridView.AddNewRowControlType.TextBox;
idx = sb.ToString().IndexOf("</Columns>");
if (!string.IsNullOrEmpty(BFI.RefValNo) || BFI.RefField != null)
{
sb.Insert(idx, GenTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
controlid = WzdUtils.RemoveSpecialCharacters("wrv" + BlockItem.TableName + BFI.DataField + "F");
type = WebGridView.AddNewRowControlType.RefVal;
}
else if (BFI.ControlType == "ComboBox")
{
sb.Insert(idx, GenTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
controlid = WzdUtils.RemoveSpecialCharacters("wdd" + BlockItem.TableName + BFI.DataField + "F");
type = WebGridView.AddNewRowControlType.DropDownList;
}
else if (BFI.ControlType == "ValidateBox")
{
sb.Insert(idx, GenTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
controlid = WzdUtils.RemoveSpecialCharacters("wvb" + BlockItem.TableName + BFI.DataField + "F");
type = WebGridView.AddNewRowControlType.TextBox;
}
else if (BFI.ControlType == "CheckBox")
{
sb.Insert(idx, GenTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
controlid = WzdUtils.RemoveSpecialCharacters("cb" + BlockItem.TableName + BFI.DataField + "F");
type = WebGridView.AddNewRowControlType.CheckBox;
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType == "DateTimeBox"))
{
sb.Insert(idx, GenTemplateFieldHTML("DateTimeBox", BlockItem, BFI));
controlid = WzdUtils.RemoveSpecialCharacters("wdt" + BlockItem.TableName + BFI.DataField + "F");
type = WebGridView.AddNewRowControlType.DateTimePicker;
}
else
{
sb.Insert(idx, "\r <asp:BoundField DataField=\"" + BFI.DataField + "\" HeaderText=\"" + (string.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description) + "\" SortExpression=\"" + BFI.DataField + "\" />\r\n ");
}
}
if (controlid.Length > 0)
{
AddNewRowControlItem item = new AddNewRowControlItem();
item.FieldName = BFI.DataField;
item.ControlID = controlid;
item.ControlType = type;
controls.Add(item);
}
}
eWebGridView1.innerHTML = sb.ToString();
SetCollectionValue(eWebGridView1, typeof(WebGridView).GetProperty("AddNewRowControls"), controls);
}
WebDevPage.IHTMLElement AjaxGridView1 = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("AjaxGridViewDetail", 0);
if (AjaxGridView1 != null)
{
AjaxTools.ExtGridColumnCollection aExtGridColumnCollection = new AjaxTools.ExtGridColumnCollection(new AjaxTools.AjaxGridView(), typeof(AjaxTools.ExtColumnMatch));
DataTable srcTable = FWizardDataSet.RealDataSet.Tables[BlockItem.TableName];
bool flag = true;
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
AjaxTools.ExtGridColumn extCol = new AjaxTools.ExtGridColumn();
if (BFI.CheckNull == "Y")
extCol.AllowNull = false;
else
extCol.AllowNull = true;
extCol.AllowSort = false;
extCol.ColumnName = string.Format("col{0}", BFI.DataField);
extCol.DataField = BFI.DataField;
extCol.DefaultValue = BFI.DefaultValue;
extCol.ExpandColumn = true;
if (BFI.Description != null && BFI.Description != String.Empty)
extCol.HeaderText = BFI.Description;
else
extCol.HeaderText = BFI.DataField;
//extCol.IsKeyField = BFI.IsKey;
extCol.IsKeyField = IsKeyField(BFI.DataField, srcTable.PrimaryKey);
extCol.NewLine = flag;
extCol.Resizable = true;
extCol.TextAlign = "left";
extCol.Visible = true;
extCol.Width = 75;
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), "RefVal", "", true);
String extComboBox = GenExtComboBox(BFI, WzdUtils.RemoveSpecialCharacters(BlockItem.TableName), "ExtRefVal", "", DataSourceID);
try
{
String str = AjaxGridView1.innerHTML;
}
catch
{
AjaxGridView1 = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("AjaxGridViewDetail", 0);
}
extCol.EditControlId = extComboBox;
extCol.Editor = AjaxTools.ExtGridEditor.ComboBox;
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", "", true);
String extComboBox = GenExtComboBox(BFI, BlockItem.TableName, "ExtComboBox", "", DataSourceID);
try
{
String str = AjaxGridView1.innerHTML;
}
catch
{
AjaxGridView1 = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("AjaxGridViewDetail", 0);
}
extCol.EditControlId = extComboBox;
extCol.Editor = AjaxTools.ExtGridEditor.ComboBox;
}
this.FieldTypeSelector(BFI.DataType, extCol, BFI.ControlType);
aExtGridColumnCollection.Add(extCol);
flag = !flag;
}
SetCollectionValue(AjaxGridView1, typeof(AjaxTools.AjaxGridView).GetProperty("Columns"), aExtGridColumnCollection);
}
#else
bool isAjaxPage = false;
if (FPage.FindControl("AjaxScriptManager1") != null)
isAjaxPage = true;
WebDataSource Detail = (WebDataSource)FPage.FindControl("Detail");
Detail.DataMember = BlockItem.TableName;
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
FComponentChangeService.OnComponentChanged(Detail, null, "", "M");
WebGridView WebGridView2 = (WebGridView)FPage.FindControl("WebGridView2");
if (WebGridView2 == null)
{
WebGridView2 = (WebGridView)FPage.FindControl("wgvDetail");
}
if (WebGridView2 != null)
{
int length = WebGridView2.Columns.Count;
for (int i = 1; i < length; i++)
{
WebGridView2.Columns.RemoveAt(1);
}
WebGridView2.DataSourceID = "Detail";
//WebGridView2.DataMember = BlockItem.TableName;
//???WebGridView2.Columns.Clear();
System.Web.UI.WebControls.BoundField aBoundField = null;
System.Web.UI.WebControls.TemplateField aTemplateField = null;
WebDefault aDefault = new WebDefault();
aDefault.ID = "wd" + BlockItem.TableName;
aDefault.DataSourceID = Detail.ID;
aDefault.DataMember = Detail.DataMember;
WebValidate aValidate = new WebValidate();
aValidate.ID = "wv" + BlockItem.TableName;
aValidate.DataSourceID = Detail.ID;
aValidate.DataMember = Detail.DataMember;
List<string> KeyFields = new List<string>();
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
//if (TemplateName == "WMasterDetail4")
//{
// BFI.RefValNo = null;
// BFI.ControlType = "TextBox";
// BFI.DataType = null;
//}
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "RefVal", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (isAjaxPage)
{
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4")
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewAjaxRefValEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, WebGridView2, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewAjaxRefValFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, WebGridView2, FLabelList);
}
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewAjaxRefValItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FAjaxRefValList, FClientData.DatabaseType, WebGridView2, FLabelList);
}
else
{
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4")
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewRefValEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, WebGridView2);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewRefValFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, WebGridView2);
}
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewRefValItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, WebGridView2);
}
WebGridView2.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4")
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewComboBoxEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewComboBoxFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
}
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewComboBoxItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
WebGridView2.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "ValidateBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4")
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewValidateBoxEditItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewValidateBoxFooterItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
}
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewValidateBoxItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
WebGridView2.Columns.Add(aTemplateField);
}
else if (BFI.ControlType == "CheckBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4")
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewCheckBoxEditItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewCheckBoxFooterItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
}
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewCheckBoxItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
WebGridView2.Columns.Add(aTemplateField);
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType.ToUpper() == "DATETIMEBOX"))
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (isAjaxPage)
{
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4")
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeEditItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, WebGridView2);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeFooterItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, WebGridView2);
}
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewAjaxDateTimeItemTemplate", BFI, BlockItem.TableName, FAjaxDateTimePickerList, FLabelList, WebGridView2);
}
else
{
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4")
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewDateTimeEditItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, WebGridView2);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewDateTimeFooterItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, WebGridView2);
}
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewDateTimeItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, WebGridView2);
}
WebGridView2.Columns.Add(aTemplateField);
}
else
{
if (BFI.EditMask != null && BFI.EditMask != String.Empty)
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4")
{
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewTextBoxEditItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, WebGridView2);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewTextBoxFooterItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, WebGridView2);
}
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewTextBoxItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, WebGridView2);
WebGridView2.Columns.Add(aTemplateField);
}
else
{
aBoundField = new System.Web.UI.WebControls.BoundField();
aBoundField.DataField = BFI.DataField;
aBoundField.SortExpression = BFI.DataField;
aBoundField.HeaderText = BFI.Description;
//Field.HeaderStyle.Width = BFI.Length * ColumnWidthPixel;
if (aBoundField.HeaderText == "")
aBoundField.HeaderText = BFI.DataField;
WebGridView2.Columns.Add(aBoundField);
}
}
}
if (BFI.IsKey)
KeyFields.Add(BFI.DataField);
GenDefault(BFI, aDefault, aValidate);
}
/*
WebGridView2.DataKeyNames = new string[KeyFields.Count];
for (int I = 0; I < KeyFields.Count; I++)
WebGridView2.DataKeyNames[I] = KeyFields[I];
*/
if (TemplateName != "WMasterDetail4" && TemplateName != "VBWebCMasterDetail4" && TemplateName != "WMasterDetail6")
{
FWebDefaultList.Add(aDefault);
FWebValidateList.Add(aValidate);
}
FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
FComponentChangeService.OnComponentChanged(WebGridView2, null, "", "M");
}
Object aAjaxGridView = FPage.FindControl("AjaxGridViewDetail");
if (aAjaxGridView != null)
{
bool flag = true;
DataTable srcTable = FWizardDataSet.RealDataSet.Tables[BlockItem.TableName];
IList iColumns = aAjaxGridView.GetType().GetProperty("Columns").GetValue(aAjaxGridView, null) as IList;
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
Type columnsType = aAjaxGridView.GetType().GetProperty("Columns").PropertyType.GetProperties()[0].PropertyType;
object extCol = Activator.CreateInstance(columnsType);
if (BFI.CheckNull == "Y")
extCol.GetType().GetProperty("AllowNull").SetValue(extCol, false, null);
else
extCol.GetType().GetProperty("AllowNull").SetValue(extCol, true, null);
extCol.GetType().GetProperty("AllowSort").SetValue(extCol, false, null);
extCol.GetType().GetProperty("ColumnName").SetValue(extCol, string.Format("col{0}", BFI.DataField), null);
extCol.GetType().GetProperty("DataField").SetValue(extCol, BFI.DataField, null);
extCol.GetType().GetProperty("DefaultValue").SetValue(extCol, BFI.DefaultValue, null);
extCol.GetType().GetProperty("ExpandColumn").SetValue(extCol, true, null);
if (BFI.Description != null && BFI.Description != String.Empty)
extCol.GetType().GetProperty("HeaderText").SetValue(extCol, BFI.Description, null);
else
extCol.GetType().GetProperty("HeaderText").SetValue(extCol, BFI.DataField, null);
extCol.GetType().GetProperty("IsKeyField").SetValue(extCol, IsKeyField(BFI.DataField, srcTable.PrimaryKey), null);
extCol.GetType().GetProperty("NewLine").SetValue(extCol, flag, null);
extCol.GetType().GetProperty("Resizable").SetValue(extCol, true, null);
extCol.GetType().GetProperty("TextAlign").SetValue(extCol, "left", null);
extCol.GetType().GetProperty("Visible").SetValue(extCol, true, null);
extCol.GetType().GetProperty("Width").SetValue(extCol, 75, null);
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "RefVal", "", true);
String extComboBox = GenExtComboBox(BFI, BlockItem.TableName, "ExtRefVal", "", DataSourceID);
extCol.GetType().GetProperty("EditControlId").SetValue(extCol, extComboBox, null);
extCol.GetType().GetProperty("Editor").SetValue(extCol, extCol.GetType().GetProperty("Editor").PropertyType.GetField("ComboBox").GetValue(extCol), null);
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "ComboBox", "", true);
String extComboBox = GenExtComboBox(BFI, BlockItem.TableName, "ExtComboBox", "", DataSourceID);
extCol.GetType().GetProperty("EditControlId").SetValue(extCol, extComboBox, null);
extCol.GetType().GetProperty("Editor").SetValue(extCol, extCol.GetType().GetProperty("Editor").PropertyType.GetField("ComboBox").GetValue(extCol), null);
}
this.FieldTypeSelector(BFI.DataType, extCol, BFI.ControlType);
iColumns.Add(extCol);
flag = !flag;
}
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(aAjaxGridView, null, "", "M");
}
#endif
}
/// <summary>
/// Agrega columnas para mostrar en gridviews
/// </summary>
/// <param name="grilla">Grilla a llenar</param>
/// <param name="obj">Objeto para sacar las propiedades que van a ser las columnas de las grillas</param>
public static void AgregarColumnas(System.Web.UI.WebControls.GridView grilla, Object obj)
{
grilla.Columns.Clear();
System.ComponentModel.PropertyDescriptorCollection propiedades = System.ComponentModel.TypeDescriptor.GetProperties(obj);
foreach(System.ComponentModel.PropertyDescriptor var in propiedades)
{
System.Web.UI.WebControls.BoundField bf = new System.Web.UI.WebControls.BoundField();
bf.DataField = var.Name;
bf.HeaderText = var.Description;
if(var.Category.Equals("Incluida"))
{
grilla.Columns.Add(bf);
}
}
}
private void GenMainBlockControl_2(TBlockItem BlockItem)
{
#if VS90
object oMaster = FDesignerDocument.webControls.item("Master", 0);
WebDevPage.IHTMLElement eMaster = null;
WebDevPage.IHTMLElement eWebGridView1 = null;
if (oMaster == null || !(oMaster is WebDevPage.IHTMLElement))
return;
eMaster = (WebDevPage.IHTMLElement)oMaster;
BlockItem.wDataSource = new WebDataSource();
WebDefault Default = new WebDefault();
Default.ID = "wdMaster"; // +BlockItem.TableName;
Default.DataSourceID = eMaster.getAttribute("ID", 0).ToString();
Default.DataMember = FClientData.TableName;
WebValidate Validate = new WebValidate();
Validate.ID = "wvMaster"; // +BlockItem.TableName;
Validate.DataSourceID = eMaster.getAttribute("ID", 0).ToString();
Validate.DataMember = FClientData.TableName;
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 Page = FDesignerDocument.pageContentElement;
InsertControl(Page, Default);
InsertControl(Page, Validate);
//foreach (TBlockFieldItem fielditem in BlockItem.BlockFieldItems)
//{
// foreach (WebQueryColumns wqc in QueryColumns)
// {
// if (wqc.ColumnType == "ClientQueryRefValColumn" && wqc.Column == fielditem.DataField && fielditem.RefValNo != String.Empty)
// {
// WebDataSource aWebDataSource = new WebDataSource();
// InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType);
// aInfoCommand.Connection = WzdUtils.AllocateConnection(FClientData.DatabaseName, FClientData.DatabaseType, true);
// //aInfoCommand.Connection = FClientData.Owner.GlobalConnection;
// IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand);
// if (FSYS_REFVAL != null)
// FSYS_REFVAL.Dispose();
// FSYS_REFVAL = new DataSet();
// aInfoCommand.CommandText = String.Format("Select * from SYS_REFVAL where REFVAL_NO = '{0}'", fielditem.RefValNo);
// WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, FSYS_REFVAL, fielditem.RefValNo);
// WebRefVal aWebRefVal = new WebRefVal();
// aWebRefVal.ID = wqc.WebRefVal;
// aWebRefVal.DataTextField = FSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString();
// aWebRefVal.DataValueField = FSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString();
// aWebRefVal.DataSourceID = String.Format("wds{0}{1}", BlockItem.TableName, wqc.Column);
// aWebRefVal.Visible = false;
// ////InsertControl(Page, aWebRefVal);
// break;
// }
// else if (wqc.ColumnType == "ClientQueryComboBoxColumn" && wqc.Column == fielditem.DataField
// && !String.IsNullOrEmpty(fielditem.ComboTextField) && !String.IsNullOrEmpty(fielditem.ComboValueField))
// {
// WebRefVal aWebRefVal = new WebRefVal();
// aWebRefVal.ID = wqc.WebRefVal;
// aWebRefVal.DataTextField = fielditem.ComboTextField;
// aWebRefVal.DataValueField = fielditem.ComboValueField;
// aWebRefVal.DataSourceID = String.Format("wds{0}{1}", fielditem.ComboEntityName, wqc.Column);
// aWebRefVal.Visible = false;
// ////InsertControl(Page, aWebRefVal);
// break;
// }
// }
//}
//WebDevPage.IHTMLElement Navigator = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebNavigator1", 0);
//if (Navigator != null)
//{
// ////SetCollectionValue(Navigator, typeof(WebNavigator).GetProperty("QueryFields"), QueryFields);
//}
//WebDevPage.IHTMLElement ClientQuery = (WebDevPage.IHTMLElement)FDesignerDocument.webControls.item("WebClientQuery1", 0);
//if (ClientQuery != null)
//{
// ////SetCollectionValue(ClientQuery, typeof(WebClientQuery).GetProperty("Columns"), QueryColumns);
//}
object oWebGridView1 = FDesignerDocument.webControls.item("gridMaster", 0);
eWebGridView1 = (WebDevPage.IHTMLElement)oWebGridView1;
if (eWebGridView1 != null)
{
//eWebGridView1.setAttribute("DataMember", FClientData.TableName, 0);
//这里本来想再往下找Columns节点的,可是找不到,只能先这样写了
StringBuilder sb = new StringBuilder(eWebGridView1.innerHTML);
int idx = eWebGridView1.innerHTML.IndexOf("</Columns>");
List<string> KeyFields = new List<string>();
int index = 1;
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
if (BFI.IsKey)
KeyFields.Add(BFI.DataField);
idx = sb.ToString().LastIndexOf("</Columns>");
String sHeaderText = String.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description;
/*if (!string.IsNullOrEmpty(BFI.RefValNo) || BFI.RefField != null)
{
sb.Insert(idx, GenTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
}
else*/
if (BFI.ControlType == "ComboBox")
{
//GridViewDataComboBoxColumn
String sComboBox = String.Format("<dx:GridViewDataComboBoxColumn FieldName=\"{0}\" Caption=\"{1}\" VisibleIndex=\"{2}\" >\r\n", BFI.DataField, sHeaderText, index);
sComboBox += String.Format("<PropertiesComboBox DataSourceID=\"{0}\" ValueField=\"{1}\"", GenWebDataSource(BFI, BFI.ComboRemoteName, "ComboBox", ""), BFI.ComboValueField);
sComboBox += "TextFormatString=\"{0}\" >\r\n";
sComboBox += "<Columns>\r\n";
sComboBox += String.Format("<dx:ListBoxColumn Caption=\"{0}\" FieldName=\"{1}\" />", BFI.ComboTextFieldCaption, BFI.ComboTextField);
if (BFI.ComboTextField != BFI.ComboValueField)
{
sComboBox += String.Format("<dx:ListBoxColumn Caption=\"{0}\" FieldName=\"{1}\" />", BFI.ComboValueFieldCaption, BFI.ComboValueField);
}
sComboBox += "</Columns>\r\n";
sComboBox += "</PropertiesComboBox>\r\n";
sComboBox += "</dx:GridViewDataComboBoxColumn> \r\n";
sb.Insert(idx, sComboBox);
}
else if (BFI.ControlType == "CheckBox")
{
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType == "DateTimeBox"))
{
//GridViewDataDateColumn
sb.Insert(idx, String.Format("<dx:GridViewDataDateColumn FieldName=\"{0}\" Caption=\"{1}\" VisibleIndex=\"{2}\" />", BFI.DataField, sHeaderText, index));
}
else
{
//GridViewDataTextColumn>
sb.Insert(idx, String.Format("<dx:GridViewDataTextColumn FieldName=\"{0}\" Caption=\"{1}\" VisibleIndex=\"{2}\" />", BFI.DataField, sHeaderText, index));
}
}
index++;
}
//<Templates>
// <DetailRow>
// <dx:ASPxGridView ID="gridDetail" runat="server" DataSourceID="Detail" KeyFieldName="DetailKeys" Width="100%" OnBeforePerformDataSelect="detailGrid_DataSelect">
// <Columns>
// <dx:GridViewCommandColumn VisibleIndex="0">
// <EditButton Visible="True">
// </EditButton>
// <NewButton Visible="True">
// </NewButton>
// <DeleteButton Visible="True">
// </DeleteButton>
// </dx:GridViewCommandColumn>
// </Columns>
// <Settings ShowFooter="True" />
// </dx:ASPxGridView>
// </DetailRow>
//</Templates>
BlockItem = null;
foreach (TBlockItem B in FClientData.Blocks)
{
if (B.wDataSource == null)
{
BlockItem = B;
break;
}
}
if (BlockItem != null)
{
List<string> DetailKeyFields = new List<string>();
InsertIntoGridView(sb, "<Templates>\r\n");
InsertIntoGridView(sb, "<DetailRow>\r\n");
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
if (BFI.IsKey)
DetailKeyFields.Add(BFI.DataField);
}
String sDetailKeyFieldName = String.Empty;
foreach (var item in DetailKeyFields)
{
sDetailKeyFieldName += item + ";";
}
InsertIntoGridView(sb, String.Format("<dx:ASPxGridView ID=\"gridDetail\" runat=\"server\" DataSourceID=\"Detail\" KeyFieldName=\"{0}\" Width=\"100%\" OnBeforePerformDataSelect=\"detailGrid_DataSelect\" OnInitNewRow=\"gridDetail_InitNewRow\" OnRowValidating=\"gridDetail_RowValidating\">\r\n", sDetailKeyFieldName));
InsertIntoGridView(sb, "<Columns>\r\n");
InsertIntoGridView(sb, "<dx:GridViewCommandColumn VisibleIndex=\"0\">\r\n");
InsertIntoGridView(sb, "<EditButton Visible=\"True\" />\r\n");
InsertIntoGridView(sb, "<NewButton Visible=\"True\" />\r\n");
InsertIntoGridView(sb, "<DeleteButton Visible=\"True\" />\r\n");
InsertIntoGridView(sb, "</dx:GridViewCommandColumn>\r\n");
index = 1;
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
String sHeaderText = String.IsNullOrEmpty(BFI.Description) ? BFI.DataField : BFI.Description;
/*if (!string.IsNullOrEmpty(BFI.RefValNo) || BFI.RefField != null)
{
InsertIntoGridView(sb, GenTemplateFieldHTML(BFI.ControlType, BlockItem, BFI));
}
else*/
if (BFI.ControlType == "ComboBox")
{
//GridViewDataComboBoxColumn
String sComboBox = String.Format("<dx:GridViewDataComboBoxColumn FieldName=\"{0}\" Caption=\"{1}\" VisibleIndex=\"{2}\" >\r\n", BFI.DataField, sHeaderText, index);
sComboBox += String.Format("<PropertiesComboBox DataSourceID=\"{0}\" ValueField=\"{1}\"", GenWebDataSource(BFI, BFI.ComboRemoteName, "ComboBox", ""), BFI.ComboValueField);
sComboBox += "TextFormatString=\"{0}\" >\r\n";
sComboBox += "<Columns>\r\n";
sComboBox += String.Format("<dx:ListBoxColumn Caption=\"{0}\" FieldName=\"{1}\" />", BFI.ComboTextFieldCaption, BFI.ComboTextField);
if (BFI.ComboTextField != BFI.ComboValueField)
{
sComboBox += String.Format("<dx:ListBoxColumn Caption=\"{0}\" FieldName=\"{1}\" />", BFI.ComboValueFieldCaption, BFI.ComboValueField);
}
sComboBox += "</Columns>\r\n";
sComboBox += "</PropertiesComboBox>\r\n";
sComboBox += "</dx:GridViewDataComboBoxColumn> \r\n";
InsertIntoGridView(sb, sComboBox);
}
if (BFI.ControlType == "CheckBox")
{
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType == "DateTimeBox"))
{
//GridViewDataDateColumn
InsertIntoGridView(sb, String.Format("<dx:GridViewDataDateColumn FieldName=\"{0}\" Caption=\"{1}\" VisibleIndex=\"{2}\" />", BFI.DataField, sHeaderText, index));
}
else
{
//GridViewDataTextColumn>
InsertIntoGridView(sb, String.Format("<dx:GridViewDataTextColumn FieldName=\"{0}\" Caption=\"{1}\" VisibleIndex=\"{2}\" />", BFI.DataField, sHeaderText, index));
}
}
index++;
}
InsertIntoGridView(sb, "</Columns>\r\n");
InsertIntoGridView(sb, "<Settings ShowFooter=\"True\" />\r\n");
InsertIntoGridView(sb, "</dx:ASPxGridView>\r\n");
InsertIntoGridView(sb, "</DetailRow>\r\n");
InsertIntoGridView(sb, "</Templates>\r\n");
}
eWebGridView1.innerHTML = sb.ToString();
String sKeyFieldName = String.Empty;
foreach (var item in KeyFields)
{
sKeyFieldName += item + ";";
}
eWebGridView1.outerHTML = eWebGridView1.outerHTML.Replace("KeyFieldName=\"\"", String.Format("KeyFieldName=\"{0}\"", sKeyFieldName));
}
#else
bool isAjaxPage = false;
if (FPage.FindControl("AjaxScriptManager1") != null)
isAjaxPage = true;
WebDataSource Master = (WebDataSource)FPage.FindControl("Master");
Master.AutoApply = true;
BlockItem.wDataSource = Master;
WebDetailsView wdvMaster = (WebDetailsView)FPage.FindControl("wdvMaster");
//Generate RESX
//???GenResx(Master);
//wdvMaster.DataMember = FClientData.TableName;
//???WebGridView1.Columns.Clear();
System.Web.UI.WebControls.BoundField aBoundField = null;
System.Web.UI.WebControls.TemplateField aTemplateField = null;
WebDefault aDefault = new WebDefault();
aDefault.ID = "wd" + BlockItem.TableName;
aDefault.DataSourceID = Master.ID;
aDefault.DataMember = Master.DataMember;
WebValidate aValidate = new WebValidate();
aValidate.ID = "wv" + BlockItem.TableName;
aValidate.DataSourceID = Master.ID;
aValidate.DataMember = Master.DataMember;
List<string> KeyFields = new List<string>();
foreach (TBlockFieldItem BFI in BlockItem.BlockFieldItems)
{
if ((BFI.RefValNo != null && BFI.RefValNo != "") || BFI.RefField != null)
{
String DataSourceID = GenWebDataSource(BFI, BlockItem.TableName, "RefVal", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewRefValEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, null);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewRefValItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, null);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewRefValInsertItemTemplate", BFI, BlockItem.TableName, DataSourceID, FClientData.Owner.GlobalConnection, FWebRefValList, FClientData.DatabaseType, null);
wdvMaster.Fields.Add(aTemplateField);
}
else if (BFI.ControlType == "ComboBox")
{
String DataSourceID = GenWebDataSource(BFI, BFI.ComboEntityName, "ComboBox", "");
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewComboBoxEditItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewComboBoxItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewComboBoxFooterItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewComboBoxInsertItemTemplate", BFI, BlockItem.TableName, DataSourceID, FMyWebDropDownList, FLabelList);
wdvMaster.Fields.Add(aTemplateField);
}
else if (BFI.ControlType == "ValidateBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewValidateBoxEditItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewValidateBoxInsertItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewValidateBoxItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewValidateBoxInsertItemTemplate", BFI, BlockItem.TableName, aValidate, FWebValidateBoxList, FLabelList);
wdvMaster.Fields.Add(aTemplateField);
}
else if (BFI.ControlType == "CheckBox")
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewCheckBoxEditItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewCheckBoxInsertItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewCheckBoxItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewCheckBoxInsertItemTemplate", BFI, BlockItem.TableName, FWebCheckBoxList, FLabelList);
wdvMaster.Fields.Add(aTemplateField);
}
else
{
if (BFI.DataType == typeof(DateTime) || (BFI.ControlType != null && BFI.ControlType.ToUpper() == "DATETIMEBOX"))
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewDateTimeEditItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, null);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewDateTimeItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, null);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewDateTimeFooterItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, null);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewDateTimeInsertItemTemplate", BFI, BlockItem.TableName, FWebDateTimePickerList, FLabelList, null);
wdvMaster.Fields.Add(aTemplateField);
}
else
{
if (BFI.EditMask != null && BFI.EditMask != String.Empty)
{
aTemplateField = new System.Web.UI.WebControls.TemplateField();
aTemplateField.HeaderText = BFI.Description;
aTemplateField.SortExpression = BFI.DataField;
if (aTemplateField.HeaderText == "")
aTemplateField.HeaderText = BFI.DataField;
aTemplateField.EditItemTemplate = new WebControlTemplate("WebGridViewTextBoxEditItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, null);
aTemplateField.ItemTemplate = new WebControlTemplate("WebGridViewTextBoxItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, null);
aTemplateField.FooterTemplate = new WebControlTemplate("WebGridViewTextBoxFooterItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, null);
aTemplateField.InsertItemTemplate = new WebControlTemplate("DetailsViewTextBoxInsertItemTemplate", BFI, BlockItem.TableName, FWebTextBoxList, FLabelList, null);
wdvMaster.Fields.Add(aTemplateField);
}
else
{
aBoundField = new System.Web.UI.WebControls.BoundField();
aBoundField.DataField = BFI.DataField;
aBoundField.SortExpression = BFI.DataField;
aBoundField.HeaderText = BFI.Description;
aBoundField.HeaderStyle.Width = 150;//BFI.Length * ColumnWidthPixel;
if (aBoundField.HeaderText == "")
aBoundField.HeaderText = BFI.DataField;
wdvMaster.Fields.Add(aBoundField);
}
}
}
if (BFI.IsKey)
KeyFields.Add(BFI.DataField);
CreateQueryField(BFI, "", null, BlockItem.TableName);
GenDefault(BFI, aDefault, aValidate);
}
DataTable DT = FWizardDataSet.RealDataSet.Tables[0];
DataColumn[] PrimDc = DT.PrimaryKey;
string[] AA = new string[PrimDc.Length];
for (int J = 0; J < PrimDc.Length; J++)
AA[J] = PrimDc[J].ColumnName;
/*
wdvMaster.DataKeyNames = new string[AA.Length];
for (int I = 0; I < AA.Length; I++)
{
wdvMaster.DataKeyNames[I] = AA[I];
}
*/
FWebDefaultList.Add(aDefault);
FWebValidateList.Add(aValidate);
IComponentChangeService FComponentChangeService = (IComponentChangeService)FDesignerHost.RootComponent.Site.GetService(typeof(IComponentChangeService));
NotifyRefresh(200);
FComponentChangeService.OnComponentChanged(wdvMaster, null, "", "M");
#endif
}
public static void ExportFromGridView(HttpResponseBase httpResponse, Dictionary <string, string> fields, IEnumerable data, string targetFileName, bool headerData = true)
{
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
System.Web.UI.WebControls.GridView gv = new System.Web.UI.WebControls.GridView();
try
{
foreach (var col in fields)
{
var column = new System.Web.UI.WebControls.BoundField();
column.DataField = col.Key;
column.HeaderText = col.Value;
gv.Columns.Add(column);
}
gv.AutoGenerateColumns = false;
gv.DataSource = data;
gv.DataBind();
// add timestamp to file name (only if '{timestamp}' exist in filename)
var fileName = targetFileName.Replace("{timestamp}", DateTime.Now.ToString("yyyyMMddHHmmss"));
httpResponse.ClearContent();
httpResponse.Buffer = true;
httpResponse.AddHeader("content-disposition", $"attachment; filename={fileName}");
httpResponse.ContentType = "application/vnd.ms-excel";
httpResponse.Charset = string.Empty;
foreach (System.Web.UI.WebControls.GridViewRow r in gv.Rows)
{
if (r.RowType == System.Web.UI.WebControls.DataControlRowType.DataRow)
{
if (headerData)
{
//r.Cells[r.Cells.Count - 1].BackColor = ((r.Cells[r.Cells.Count - 1].Text == "green") ? System.Drawing.Color.Green : (((r.Cells[r.Cells.Count - 1].Text == "red") ? System.Drawing.Color.Red : System.Drawing.Color.Yellow)));
//r.Cells[r.Cells.Count - 1].Text = string.Empty;
}
else
{
r.Cells[r.Cells.Count - 2].BackColor = ((r.Cells[r.Cells.Count - 2].Text == "green") ? System.Drawing.Color.Green : (((r.Cells[r.Cells.Count - 2].Text == "red") ? System.Drawing.Color.Red : System.Drawing.Color.Yellow)));
r.Cells[r.Cells.Count - 2].Text = string.Empty;
r.Cells[r.Cells.Count - 1].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
}
}
}
gv.RenderControl(htw);
httpResponse.Output.Write(sw.ToString());
httpResponse.Flush();
httpResponse.End();
}
finally
{
// cleanup
sw = null;
htw = null;
gv = null;
}
}
