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);
}
}
}
