protected override void InitWebGrid()
{
base.InitWebGrid();
this.gridHelper.AddColumn("Sequence", "次序", null);
this.gridHelper.AddColumn("ColumnName", "栏位名称", null);
this.gridHelper.AddColumn("DisplayDesc", "显示提示", null);
this.gridHelper.AddColumn("FilterType", "过滤方式", null);
this.gridHelper.AddColumn("InputUIType", "输入方式", null);
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["DisplayDesc"].ReadOnly = false;
((BoundDataField)this.gridWebGrid.Columns.FromKey("InputUIType")).HtmlEncode = false;
//this.gridWebGrid.Columns.FromKey("DisplayDesc").AllowUpdate = Infragistics.WebUI.UltraWebGrid.AllowUpdate.Yes;
//this.gridWebGrid.Columns.FromKey("DisplayDesc").CellStyle.BackColor = Color.FromArgb(255, 252, 240);
DropDownProvider dropdownProvider = new DropDownProvider();
dropdownProvider.ID = "dropdownProviderFilterType";
dropdownProvider.EditorControl.ID = "editorControlFilterType";
dropdownProvider.EditorControl.DisplayMode = DropDownDisplayMode.DropDownList;
dropdownProvider.EditorControl.TextField = "FilterTypeText";
dropdownProvider.EditorControl.ValueField = "FilterTypeValue";
dropdownProvider.EditorControl.DropDownContainerWidth = new Unit(150);
BindDropDownFilterType(dropdownProvider);
this.gridWebGrid.EditorProviders.Add(dropdownProvider);
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["FilterType"].EditorID = "dropdownProviderFilterType";
if (bIsSqlDataSource == true)
{
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["FilterType"].ReadOnly = false;
}
//多语言
this.gridHelper.ApplyLanguage(this.languageComponent1);
}
private void BindDropDownTotalType(DropDownProvider dropdownProvider)
{
DataTable dt = new DataTable();
dt.Columns.Add("TotalTypeValue");
dt.Columns.Add("TotalTypeText");
dt.AcceptChanges();
DataRow rowSum = dt.NewRow();
rowSum["TotalTypeValue"] = ReportTotalType.Sum;
rowSum["TotalTypeText"] = this.languageComponent1.GetString(ReportTotalType.Sum);
DataRow rowCount = dt.NewRow();
rowCount["TotalTypeValue"] = ReportTotalType.Count;
rowCount["TotalTypeText"] = this.languageComponent1.GetString(ReportTotalType.Count);
DataRow rowAvg = dt.NewRow();
rowAvg["TotalTypeValue"] = ReportTotalType.Avg;
rowAvg["TotalTypeText"] = this.languageComponent1.GetString(ReportTotalType.Avg);
dt.Rows.Add(rowSum);
dt.Rows.Add(rowCount);
dt.Rows.Add(rowAvg);
dropdownProvider.EditorControl.ValueField = "TotalTypeValue";
dropdownProvider.EditorControl.TextField = "TotalTypeText";
dropdownProvider.EditorControl.DataSource = dt;
dropdownProvider.EditorControl.DataBind();
}
protected override void InitWebGrid()
{
base.InitWebGrid();
this.gridHelper.AddColumn("Sequence", "次序", null);
this.gridHelper.AddColumn("ColumnName", "栏位名称", null);
this.gridHelper.AddColumn("ColumnDesc", "栏位名称", null);
this.gridHelper.AddColumn("TotalType", "统计方式", null);
DropDownProvider dropdownProvider = new DropDownProvider();
dropdownProvider.ID = "dropdownProviderTotalType";
dropdownProvider.EditorControl.ID = "editorControlTotalType";
dropdownProvider.EditorControl.DisplayMode = DropDownDisplayMode.DropDownList;
dropdownProvider.EditorControl.TextField = "TotalTypeText";
dropdownProvider.EditorControl.ValueField = "TotalTypeValue";
dropdownProvider.EditorControl.DropDownContainerWidth = new Unit(150);
BindDropDownTotalType(dropdownProvider);
this.gridWebGrid.EditorProviders.Add(dropdownProvider);
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["TotalType"].ReadOnly = false;
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["TotalType"].EditorID = "dropdownProviderTotalType";
this.gridWebGrid.Columns.FromKey("ColumnName").Hidden = true;
//多语言
this.gridHelper.ApplyLanguage(this.languageComponent1);
InitData();
}
protected void Page_Load(object sender, System.EventArgs e)
{
this.gridHelper = new GridHelperNew(this.gridWebGrid, DtSource);
if (this.IsPostBack == false)
{
// 初始化页面语言
this.InitPageLanguage(this.languageComponent1, false);
this.txtReportName.Text = this.designView.DesignMain.ReportName;
this.InitColumnList();
// InitWebGrid();
this.lblDesignStep4Title.Text = this.languageComponent1.GetString("$PageControl_DesignStep4Title");
}
if (this.gridWebGrid.Columns.FromKey("FilterType") != null)
{
DropDownProvider dropdownProvider = this.gridWebGrid.EditorProviders.GetProviderById("dropdownProviderFilterType") as DropDownProvider;
BindDropDownFilterType(dropdownProvider);
dropdownProvider.EditorControl.DropDownContainerWidth = new Unit(150);
}
//this.gridWebGrid.Behaviors.CreateBehavior<Selection>().Enabled = true;
//this.gridWebGrid.Behaviors.CreateBehavior<Selection>().RowSelectType = SelectType.Single;
////this.gridWebGrid.Behaviors.CreateBehavior<Selection>().CellClickAction = CellClickAction.;
//this.gridWebGrid.Behaviors.CreateBehavior<RowSelectors>().Enabled = true;
//this.gridWebGrid.Behaviors.CreateBehavior<Selection>().CellSelectType = SelectType.None;
//this.gridWebGrid.Behaviors.CreateBehavior<Activation>().ActiveGroupedRow.
this.gridWebGrid.Behaviors.CreateBehavior <Activation>().Enabled = true;
InitializeBackGroundColor();
}
private void BindDropDownDataType(DropDownProvider dropdownProvider)
{
DataTable dt = new DataTable();
dt.Columns.Add("DataTypeValue");
dt.Columns.Add("DataTypeText");
dt.AcceptChanges();
DataRow rowDate = dt.NewRow();
rowDate["DataTypeValue"] = ReportDataType.Date;
rowDate["DataTypeText"] = this.languageComponent1.GetString(ReportDataType.Date);
DataRow rowNumeric = dt.NewRow();
rowNumeric["DataTypeValue"] = ReportDataType.Numeric;
rowNumeric["DataTypeText"] = this.languageComponent1.GetString(ReportDataType.Numeric);
DataRow rowString = dt.NewRow();
rowString["DataTypeValue"] = ReportDataType.String;
rowString["DataTypeText"] = this.languageComponent1.GetString(ReportDataType.String);
dt.Rows.Add(rowDate);
dt.Rows.Add(rowNumeric);
dt.Rows.Add(rowString);
dropdownProvider.EditorControl.ValueField = "DataTypeValue";
dropdownProvider.EditorControl.TextField = "DataTypeText";
dropdownProvider.EditorControl.DataSource = dt;
dropdownProvider.EditorControl.DataBind();
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!this.IsPostBack)
{
// 初始化页面语言
this.InitPageLanguage(this.languageComponent1, false);
if (_facade == null)
{
_facade = new ReportViewFacade(base.DataProvider);
}
object obj = _facade.GetRptViewDataSource(Convert.ToDecimal(this.GetRequestParam("id")));
txtDBName.Text = ((RptViewDataSource)obj).Name.ToString();
txtDllName.Text = ((RptViewDataSource)obj).DllFileName.ToString();
if (((RptViewDataSource)obj).SourceType == DataSourceType.SQL)
{
txtDllName.Text = ((RptViewDataSource)obj).SQL.ToString();
}
datasourceid.Value = this.GetRequestParam("id");
//_facade.SetColumn(this.MapPath(""), this.txtDllName.Text, decimal.Parse(datasourceid.Value), this.GetUserCode());
}
if (this.gridWebGrid.Columns.FromKey("DataType") != null)
{
DropDownProvider dropdownProvider = this.gridWebGrid.EditorProviders.GetProviderById("dropdownProviderDataType") as DropDownProvider;
BindDropDownDataType(dropdownProvider);
dropdownProvider.EditorControl.DropDownContainerWidth = new Unit(150);
}
}
protected override void InitWebGrid()
{
base.InitWebGrid();
this.gridHelper.AddColumn("ColumnSequence", "次序", null);
this.gridHelper.AddColumn("ColumnName", "栏位名称", null);
this.gridHelper.AddColumn("Description", "栏位描述", null);
this.gridHelper.AddDataColumn("DataType", "数据类型", 150);
this.gridHelper.AddCheckBoxColumn("Visible", "是否可见", true, 100);
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["Description"].ReadOnly = false;
//cell有下拉框
DropDownProvider dropdownProvider = new DropDownProvider();
dropdownProvider.ID = "dropdownProviderDataType";
dropdownProvider.EditorControl.ID = "editorControlDataType";
dropdownProvider.EditorControl.DisplayMode = DropDownDisplayMode.DropDownList;
dropdownProvider.EditorControl.TextField = "DataTypeText";
dropdownProvider.EditorControl.ValueField = "DataTypeValue";
dropdownProvider.EditorControl.DropDownContainerWidth = new Unit(150);
BindDropDownDataType(dropdownProvider);
this.gridWebGrid.EditorProviders.Add(dropdownProvider);
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["DataType"].ReadOnly = false;
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["DataType"].EditorID = "dropdownProviderDataType";
//下拉框列固定列宽
ColumnResizeSetting crs = new ColumnResizeSetting(this.gridWebGrid);
crs.EnableResize = false;
crs.ColumnKey = "DataType";
this.gridWebGrid.Behaviors.CreateBehavior <ColumnResizing>().ColumnSettings.Add(crs);
//是否可见列可编辑
this.gridWebGrid.Behaviors.CreateBehavior <EditingCore>().Behaviors.CreateBehavior <CellEditing>().ColumnSettings["Visible"].ReadOnly = false;
//InitRow();
//多语言
this.gridHelper.ApplyLanguage(this.languageComponent1);
this.cmdQuery_Click(null, null);
}
/// <summary>
/// Initializes a new instance of a <see cref="MultiColumnComboBox"/>.
/// </summary>
public MultiColumnComboBox()
{
_ddp = new DropDownProvider(this);
VerticalAlignment = VerticalAlignment.Center;
Background = _brTransparent;
BorderThickness = _thkEmpty;
Padding = _thkPadding;
MaxDropDownHeight = 300;
}
public ucCalcKeyboard()
{
InitializeComponent();
txtInput.Font = GerenciadorDeFontesCustomizadas.GetFont(GerenciadorDeFontesCustomizadas.LEDFonte, txtInput.Font);
_fontErro = GerenciadorDeFontesCustomizadas.GetFont(GerenciadorDeFontesCustomizadas.LCDFonte, new Font(new FontFamily("Microsoft Sans Serif"), 14, FontStyle.Italic));
_fontNormal = GerenciadorDeFontesCustomizadas.GetFont(GerenciadorDeFontesCustomizadas.LCDFonte, new Font(new FontFamily("Microsoft Sans Serif"), 30, FontStyle.Bold));
lbResult.Font = _fontNormal;
_ucDx = new ucDx();
_dpDx = new DropDownProvider(_ucDx, btnDx);
}
private void BindDropDownFilterType(DropDownProvider dropdownProvider)
{
DataTable dt = new DataTable();
dt.Columns.Add("FilterTypeValue");
dt.Columns.Add("FilterTypeText");
dt.AcceptChanges();
DataRow rowEqual = dt.NewRow();
rowEqual["FilterTypeValue"] = ReportFilterType.Equal;
rowEqual["FilterTypeText"] = this.languageComponent1.GetString(ReportFilterType.Equal);
DataRow rowGreater = dt.NewRow();
rowGreater["FilterTypeValue"] = ReportFilterType.Greater;
rowGreater["FilterTypeText"] = this.languageComponent1.GetString(ReportFilterType.Greater);
DataRow rowGreaterEqual = dt.NewRow();
rowGreaterEqual["FilterTypeValue"] = ReportFilterType.GreaterEqual;
rowGreaterEqual["FilterTypeText"] = this.languageComponent1.GetString(ReportFilterType.GreaterEqual);
DataRow rowLesser = dt.NewRow();
rowLesser["FilterTypeValue"] = ReportFilterType.Lesser;
rowLesser["FilterTypeText"] = this.languageComponent1.GetString(ReportFilterType.Lesser);
DataRow rowLesserEqual = dt.NewRow();
rowLesserEqual["FilterTypeValue"] = ReportFilterType.LesserEqual;
rowLesserEqual["FilterTypeText"] = this.languageComponent1.GetString(ReportFilterType.LesserEqual);
DataRow rowLeftMatch = dt.NewRow();
rowLeftMatch["FilterTypeValue"] = ReportFilterType.LeftMatch;
rowLeftMatch["FilterTypeText"] = this.languageComponent1.GetString(ReportFilterType.LeftMatch);
DataRow rowRightMatch = dt.NewRow();
rowRightMatch["FilterTypeValue"] = ReportFilterType.RightMatch;
rowRightMatch["FilterTypeText"] = this.languageComponent1.GetString(ReportFilterType.RightMatch);
dt.Rows.Add(rowEqual);
dt.Rows.Add(rowGreater);
dt.Rows.Add(rowGreaterEqual);
dt.Rows.Add(rowLesser);
dt.Rows.Add(rowLesserEqual);
dt.Rows.Add(rowLeftMatch);
dt.Rows.Add(rowRightMatch);
dropdownProvider.EditorControl.ValueField = "FilterTypeValue";
dropdownProvider.EditorControl.TextField = "FilterTypeText";
dropdownProvider.EditorControl.DataSource = dt;
dropdownProvider.EditorControl.DataBind();
}
protected void Page_Load(object sender, System.EventArgs e)
{
this.gridHelper = new GridHelperNew(this.gridWebGrid, DtSource);
if (this.IsPostBack == false)
{
//InitWebGrid();
//InitData();
this.txtReportName.Text = Server.UrlDecode(this.GetRequestParam("reportname"));
// 初始化页面语言
this.InitPageLanguage(this.languageComponent1, false);
this.lblTotalTypeTitle.Text = this.languageComponent1.GetString("$PageControl_TotalTypeTitle");
}
if (this.gridWebGrid.Columns.FromKey("TotalType") != null)
{
DropDownProvider dropdownProvider = this.gridWebGrid.EditorProviders.GetProviderById("dropdownProviderTotalType") as DropDownProvider;
BindDropDownTotalType(dropdownProvider);
dropdownProvider.EditorControl.DropDownContainerWidth = new Unit(150);
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
this.gridHelper = new GridHelperNew(this.gridWebGrid, DtSource);
if (this.IsPostBack == false)
{
// 初始化页面语言
this.InitPageLanguage(this.languageComponent1, false);
string strFileName = this.designView.UploadFileName;
strFileName = strFileName.Substring(strFileName.LastIndexOf("\\") + 1);
this.txtReportFile.Text = strFileName;
this.txtReportName.Text = this.designView.DesignMain.ReportName;
this.InitColumnList();
//InitGrid();
}
if (this.gridWebGrid.Columns.FromKey("FilterType") != null)
{
DropDownProvider dropdownProvider = this.gridWebGrid.EditorProviders.GetProviderById("dropdownProviderFilterType") as DropDownProvider;
BindDropDownFilterType(dropdownProvider);
dropdownProvider.EditorControl.DropDownContainerWidth = new Unit(150);
}
InitializeBackGroundColor();
}
protected void Page_Load(object sender, System.EventArgs e)
{
needVScroll = true;
this.gridHelper = new GridHelperNew(this.gridWebGrid, DtSource);
ReportViewFacade rptFacade = new ReportViewFacade(this.DataProvider);
RptViewDataSourceColumn[] columns = rptFacade.GetRptViewDataSourceColumnByDataSourceId(Convert.ToInt32(this.designView.DesignMain.DataSourceID));
if (!IsPostBack)
{
// 初始化页面语言
this.InitPageLanguage(this.languageComponent1, false);
InitButtonVisible();
this.txtReportName.Text = this.designView.DesignMain.ReportName;
//InitGridData();
this.InitChartDescLanguage();
this.lstUnSelectColumn.Items.Clear();
for (int i = 0; columns != null && i < columns.Length; i++)
{
this.lstUnSelectColumn.Items.Add(new System.Web.UI.WebControls.ListItem(columns[i].Description, columns[i].ColumnName));
}
}
this.lstUnSelectedSeries.Items.Clear();
this.lstUnSelectedCategory.Items.Clear();
for (int i = 0; columns != null && i < columns.Length; i++)
{
this.lstUnSelectedSeries.Items.Add(new System.Web.UI.WebControls.ListItem(columns[i].Description, columns[i].ColumnName));
this.lstUnSelectedCategory.Items.Add(new System.Web.UI.WebControls.ListItem(columns[i].Description, columns[i].ColumnName));
}
this.lstSelectedSeries.Items.Clear();
this.lstSelectedCategory.Items.Clear();
if (this.hidSelectedSeriesValue.Value != "")
{
string[] strArrTmp = this.hidSelectedSeriesValue.Value.Split(';');
for (int i = 0; i < strArrTmp.Length; i++)
{
if (strArrTmp[i] != "")
{
System.Web.UI.WebControls.ListItem item = this.lstUnSelectedSeries.Items.FindByValue(strArrTmp[i]);
if (item != null)
{
this.lstSelectedSeries.Items.Add(new System.Web.UI.WebControls.ListItem(item.Text, item.Value));
this.lstUnSelectedSeries.Items.Remove(item);
}
}
}
}
if (this.hidSelectedCategoryValue.Value != "")
{
string[] strArrTmp = this.hidSelectedCategoryValue.Value.Split(';');
for (int i = 0; i < strArrTmp.Length; i++)
{
if (strArrTmp[i] != "")
{
System.Web.UI.WebControls.ListItem item = this.lstUnSelectedCategory.Items.FindByValue(strArrTmp[i]);
if (item != null)
{
this.lstSelectedCategory.Items.Add(new System.Web.UI.WebControls.ListItem(item.Text, item.Value));
this.lstUnSelectedCategory.Items.Remove(item);
}
}
}
}
if (this.hidSelectedDataValue.Value != "")
{
string[] strArrTmp = this.hidSelectedDataValue.Value.Split(';');
for (int i = 0; i < strArrTmp.Length; i++)
{
if (strArrTmp[i] != "")
{
System.Web.UI.WebControls.ListItem item = this.lstUnSelectColumn.Items.FindByValue(strArrTmp[i]);
if (item != null)
{
this.lstUnSelectColumn.Items.Remove(item);
}
}
}
}
if (this.gridWebGrid.Columns.FromKey("TotalType") != null)
{
DropDownProvider dropdownProvider = this.gridWebGrid.EditorProviders.GetProviderById("dropdownProviderTotalType") as DropDownProvider;
BindDropDownTotalType(dropdownProvider);
dropdownProvider.EditorControl.DropDownContainerWidth = new Unit(150);
}
this.gridWebGrid.Behaviors.CreateBehavior <Activation>().Enabled = true;
}
