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