public List <ChartTemplateInfo> GetObjects(string xmlFilterParams) { string sql = MB.WcfService.Properties.Resources.ChartTemplate_Sql_SelectObject; List <ChartTemplateInfo> lstData = new List <ChartTemplateInfo>(); var pars = MB.Util.Serializer.QueryParameterXmlSerializer.DefaultInstance.DeSerializer(xmlFilterParams); string sqlFilter = MB.Orm.DbSql.SqlShareHelper.Instance.QueryParametersToSqlString(null, pars); sql = string.Format(sql, sqlFilter); using (IDataReader reader = MB.RuleBase.Common.DatabaseExecuteHelper.NewInstance.ExecuteReader(sql)) { while (reader.Read()) { ChartTemplateInfo newInfo = new ChartTemplateInfo(); newInfo.ID = int.Parse(reader["ID"].ToString()); newInfo.NAME = reader["NAME"].ToString(); newInfo.RULE_PATH = reader["RULE_PATH"].ToString(); newInfo.FILTER_STRING = reader["FILTER_STRING"].ToString(); newInfo.TEMPLATE_FILE = (byte[])reader["TEMPLATE_FILE"]; newInfo.TEMPLATE_TYPE = reader["TEMPLATE_TYPE"].ToString(); newInfo.CREATE_USER = reader["CREATE_USER"].ToString(); newInfo.CREATE_DATE = (DateTime)reader["CREATE_DATE"]; newInfo.GRID_NAME = reader["GRID_NAME"].ToString(); lstData.Add(newInfo); } } return(lstData); }
public virtual void CreateMenuItems(List <ChartTemplateInfo> templateList) { if (_ContainerForm != null && _ContainerForm.ClientRuleObject != null) { string gridName = _ContainerForm.GetType().FullName + "~" + _XtraGrid.Name + "~" + _ContainerForm.GetType().Assembly.GetName().Name; string ruleName = _ContainerForm.ClientRuleObject.GetType().FullName + "~" + _ContainerForm.ClientRuleObject.GetType().Assembly.GetName().Name; ChartTemplateInfo templateInfo = new ChartTemplateInfo(); templateInfo.RULE_PATH = ruleName; templateInfo.GRID_NAME = gridName; templateInfo.TEMPLATE_TYPE = "PUBLIC"; templateInfo.CREATE_USER = MB.WinBase.AppEnvironmentSetting.Instance.CurrentLoginUserInfo.USER_CODE; ChartMenu addMenu = new ChartMenu("默认图表", new EventHandler(menuItemClick), "ChartModule", templateInfo); _TemplateMenu.MenuItems.Add(addMenu); } if (templateList == null || templateList.Count == 0) { return; } foreach (var template in templateList) { ChartMenu menu = new ChartMenu(template.NAME, new EventHandler(menuItemClick), "TemplateChartModule", template); _TemplateMenu.MenuItems.Add(menu); } }
public FrmEditChart(string itemName, IClientRuleQueryBase clientRule, ChartTemplateInfo template, object dataSource) { InitializeComponent(); _ItemName = itemName; _ClientRule = clientRule; _DataSource = dataSource; _CurrentChartTemplate = template; }
public static void SaveChartTemplate(ChartTemplateInfo template) { if (Instance.CurrentModuleBase != null) { ChartModuleBase chartModule = Instance.CurrentModuleBase.TModule as ChartModuleBase; if (chartModule != null) { chartModule.SaveChartControl(template); } } }
void itemDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("确定删除当前行吗?", "提示", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { ChartTemplateInfo item = gvTemplate.GetFocusedRow() as ChartTemplateInfo; if (item != null) { _TemplateList.Remove(item); } this.grdMain.DataSource = _TemplateList.ToArray(); } }
public static void SaveTemplate(ChartTemplateInfo template) { try { if (template.ID <= 0) { string tempType = template.TEMPLATE_TYPE; string name = template.NAME; FrmSaveTemplate frm = new FrmSaveTemplate(tempType, name); frm.ShowDialog(); if (frm.DialogResult == System.Windows.Forms.DialogResult.OK) { template.NAME = frm.TemplateName; template.TEMPLATE_TYPE = frm.TemplateType; } else { return; } } string path = AppDomain.CurrentDomain.BaseDirectory + "\\ChartTemplate\\" + template.TEMPLATE_TYPE + "_" + template.NAME + ".xml"; if (Instance.CurrentModuleBase == null) { return; } ChartModuleBase chartDemoBase = Instance.CurrentModuleBase.TModule as ChartModuleBase; if (chartDemoBase == null) { return; } chartDemoBase.ChartControl.SaveToFile(path); byte[] file = File.ReadAllBytes(path); template.TEMPLATE_FILE = file; File.Delete(path); MB.WinDxChart.Chart.DxChartControlHelper.Instance.SaveChartTemplate(template); } catch (Exception ex) { MB.WinBase.ApplicationExceptionTerminate.DefaultInstance.ExceptionTerminate(ex); } }
public virtual void SaveChartControl(ChartTemplateInfo template) { try { if (template.ID <= 0 || string.IsNullOrEmpty(template.NAME)) { string tempType = template.TEMPLATE_TYPE; string name = template.NAME; FrmSaveTemplate frm = new FrmSaveTemplate(tempType, name); frm.ShowDialog(); if (frm.DialogResult == System.Windows.Forms.DialogResult.OK) { template.NAME = frm.TemplateName; template.TEMPLATE_TYPE = frm.TemplateType; } else { return; } } string basePath = AppDomain.CurrentDomain.BaseDirectory + "\\ChartTemplate\\"; if (!Directory.Exists(basePath)) { Directory.CreateDirectory(basePath); } string path = basePath + template.TEMPLATE_TYPE + "_" + template.NAME + ".xml"; ChartControl.SaveToFile(path); byte[] file = File.ReadAllBytes(path); template.TEMPLATE_FILE = file; File.Delete(path); MB.WinDxChart.Chart.DxChartControlHelper.Instance.SaveChartTemplate(template); } catch (Exception ex) { MB.WinBase.ApplicationExceptionTerminate.DefaultInstance.ExceptionTerminate(ex); } }
private void menuItemClick(object sender, System.EventArgs e) { try { ChartMenu menu = sender as ChartMenu; if (menu == null) { return; } ChartTemplateInfo template = menu.Template; showChart(_XtraGrid, menu.ItemName, ref template); menu.Template = template; } catch (Exception ex) { MB.WinBase.ApplicationExceptionTerminate.DefaultInstance.ExceptionTerminate(ex); } }
public int AddObjectImmediate(ChartTemplateInfo entity) { if (entity.ID > 0) { DeletedImmediate(entity.ID); } string sql = MB.WcfService.Properties.Resources.ChartTemplate_Sql_AddObject; List <MB.Orm.DbSql.SqlParamInfo> pars = new List <MB.Orm.DbSql.SqlParamInfo>(); entity.ID = MB.Orm.Persistence.EntityIdentityHelper.NewInstance.GetEntityIdentity("CHART_TEMPLATE"); pars.Add(new MB.Orm.DbSql.SqlParamInfo("ID", entity.ID, DbType.Int32)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("NAME", entity.NAME, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("RULE_PATH", entity.RULE_PATH, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("GRID_NAME", entity.GRID_NAME, DbType.String)); pars.Add(new Orm.DbSql.SqlParamInfo("FILTER_STRING", entity.FILTER_STRING, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("TEMPLATE_TYPE", entity.TEMPLATE_TYPE, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("TEMPLATE_FILE", entity.TEMPLATE_FILE, DbType.Binary)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("CREATE_USER", entity.CREATE_USER, DbType.String)); return(MB.RuleBase.Common.DatabaseExecuteHelper.NewInstance.ExecuteNonQuery(sql, pars)); }
public ChartMenu(string text, EventHandler click, string itemName, ChartTemplateInfo templateInfo) : base(text, click) { _ItemName = itemName; _Template = templateInfo; }
public void showChart(DevExpress.XtraGrid.GridControl xtraGrid, string itemName, ref ChartTemplateInfo template) { try { object datasource = xtraGrid.DataSource; DataSet ds = null; if (_ContainerForm.ClientRuleObject.ClientLayoutAttribute.CommunicationDataType == WinBase.Common.CommunicationDataType.DataSet) { ds = datasource as DataSet; } else { MB.WinBase.Binding.BindingSourceEx bindingSource = datasource as MB.WinBase.Binding.BindingSourceEx; Type T = bindingSource.Current.GetType(); ds = MB.Util.MyConvert.Instance.ConvertEntityToDataSet(T, bindingSource.List, null); } MB.WinDxChart.FrmEditChart frmChart = new WinDxChart.FrmEditChart(itemName, _ContainerForm.ClientRuleObject, template, ds); frmChart.ShowDialog(); template = frmChart.CurTemplate; } catch (Exception ex) { MB.Util.TraceEx.Write(ex.Message); } }
public int SaveChartTemplate(ChartTemplateInfo entity) { return(_TemplateClient.AddObject(entity)); }
public static void InitChartControl(IClientRuleQueryBase clientRule, object datasource, ChartTemplateInfo template) { if (Instance.CurrentModuleBase != null) { ChartModuleBase chartModule = Instance.CurrentModuleBase.TModule as ChartModuleBase; if (chartModule != null) { chartModule.Template = template; chartModule.InitChartControl(clientRule); //绑定数据源 chartModule.BindingChartControl(datasource); } } }