public bool AddUserModel_Info(M_ModelInfo ModelInfo) { string strSql1 = "INSERT INTO [ZL_Model] ([ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ModelType],[ContentTemplate],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize])VALUES(@ModelName,@Description,@TableName,@ItemName,@ItemUnit,@ItemIcon,@ModelType,@ContentTemplate,@MultiFlag,@NodeID,@SysModel,@FromModel,@Thumbnail,@Islotsize)"; SqlParameter[] cmdParams = ModelInfo.GetParameters(); ExecuteSql(strSql1, cmdParams); string strSql = "CREATE TABLE dbo." + ModelInfo.TableName + " ([ID][int] IDENTITY (1, 1) NOT NULL PRIMARY KEY ,[UserID][int] NOT NULL,[UserName][nvarchar] (255) NULL,[Styleid] [int] NULL DEFAULT (0),[Recycler] [bit] NULL DEFAULT (0),[IsCreate] [bit] NULL DEFAULT (0), [NewTime] [datetime] NULL DEFAULT (getdate()) )"; return(ExecuteSql(strSql)); }
/// <summary> /// 添加导入模型 /// </summary> public bool Addinput(M_ModelInfo ModelInfo) { string strSql1 = "SET IDENTITY_INSERT [ZL_Model] ON;INSERT INTO [ZL_Model] ([ModelID],[ModelName],[Description],[TableName],[ItemName],[ItemUnit],[ItemIcon],[ModelType],[ContentTemplate],[MultiFlag],[NodeID],[SysModel],[FromModel],[Thumbnail],[Islotsize])VALUES(@ModelID,@ModelName,@Description,@TableName,@ItemName,@ItemUnit,@ItemIcon,@ModelType,@ContentTemplate,@MultiFlag,@NodeID,@SysModel,@FromModel,@Thumbnail,@Islotsize);SET IDENTITY_INSERT [ZL_Model] OFF"; SqlParameter[] cmdParams = ModelInfo.GetParameters(); ExecuteSql(strSql1, cmdParams); string strSql = "CREATE TABLE dbo." + ModelInfo.TableName + " ([ID] [int] IDENTITY (1, 1) PRIMARY Key NOT NULL)"; return(ExecuteSql(strSql)); }