public object AddQuerySchemaName(QuerySchemaModel model) { return(SqlHelper.ExecuteScalar(@" insert into SJUserQuerySchema(UserId,SchemaSeq,SchemaName) values(@UserId,@SchemaSeq,@SchemaName); SELECT @@IDENTITY AS R;", new SqlParameter[] { new SqlParameter("UserId", model.UserId), new SqlParameter("@SchemaSeq", model.SchemaSeq), new SqlParameter("@SchemaName", model.SchemaName) })); }
public int AddQuerySchemaName(QuerySchemaModel model) { return(Convert.ToInt32(dal.AddQuerySchemaName(model))); }