public List <ChartLayoutTemplateInfo> GetObjects(string xmlFilterParams) { string sql = MB.WcfService.Properties.Resources.ChartLayoutTemplate_Sql_SelectObject; List <ChartLayoutTemplateInfo> lstData = new List <ChartLayoutTemplateInfo>(); 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()) { ChartLayoutTemplateInfo newInfo = new ChartLayoutTemplateInfo(); newInfo.ID = int.Parse(reader["ID"].ToString()); newInfo.NAME = reader["NAME"].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"]; lstData.Add(newInfo); } } return(lstData); }
public int AddObjectImmediate(ChartLayoutTemplateInfo entity, List <ChartLayoutItemInfo> items) { if (entity.ID > 0) { DeletedImmediate(entity.ID); } string sql = MB.WcfService.Properties.Resources.ChartLayoutTemplate_Sql_AddObject; List <MB.Orm.DbSql.SqlParamInfo> pars = new List <MB.Orm.DbSql.SqlParamInfo>(); entity.ID = MB.Orm.Persistence.EntityIdentityHelper.NewInstance.GetEntityIdentity("CHART_LAYOUT_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("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)); int iRet = MB.RuleBase.Common.DatabaseExecuteHelper.NewInstance.ExecuteNonQuery(sql, pars); foreach (ChartLayoutItemInfo item in items) { sql = MB.WcfService.Properties.Resources.ChartLayoutItem_Sql_AddObject; pars.Clear(); item.ID = MB.Orm.Persistence.EntityIdentityHelper.NewInstance.GetEntityIdentity("CHART_LAYOUT_ITEM"); pars.Add(new MB.Orm.DbSql.SqlParamInfo("ID", item.ID, DbType.Int32)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("NAME", item.NAME, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("LT_ID", entity.ID, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("CT_ID", item.CT_ID, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("ITEM_TYPE", item.ITEM_TYPE, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("TEXT", item.TEXT, DbType.String)); pars.Add(new MB.Orm.DbSql.SqlParamInfo("FORM_TEXT", item.FORM_TEXT, DbType.String)); iRet += MB.RuleBase.Common.DatabaseExecuteHelper.NewInstance.ExecuteNonQuery(sql, pars); } return(iRet); }
public int SaveChartLayoutTemplate(ChartLayoutTemplateInfo entity, List <ChartLayoutItemInfo> items) { return(_LayoutTemplateClient.AddObject(entity, items)); }